As of 2016, which has been the last Type-Moon work that's contained explicit content?
Note: this answer assumes that &quot;graphic or deeply detailed sexual content which would be restricted to adults only&quot; means R-18/CERO Z in Japan.


Games
Surprisingly, Japanese Wikipedia mentioned this,

2005年10月28日発売の『Fate/hollow ataraxia』以降アダルトゲームの新規発表は行われていない。
Since the release of Fate/hollow ataraxia on 28 Oct 2005, there's no announcement on new adult games.

So, at least that's the answer to the last game containing explicit content: Fate/hollow ataraxia (the original PC version, not the PS Vita one).
After that, they started releasing console games only (except Mahoutsukai no Yoru for PC as mentioned on the question) with Fate/EXTRA CCC having the highest rating of CERO D (R-17, no international release).
Anime, Movie &amp; OVA
Since almost all of them were broadcasted on the TV, then they could be considered as 一般向けアニメ (ippan muke anime, anime for the general public) even though they might include heavy ecchi scenes (e.g. Fate/kaleid liner Prisma Illya ).
This is also true for movies such as Kara no Kyoukai, Fate/stay night UBW, and also Carnival Phantasm OVA.
Manga &amp; Light Novel
Some manga were published by Kadokawa, and as far as I know, Kadokawa doesn't publish adult manga (aka. hentai) although, again, they might include heavy ecchi scenes.
I can't comment on books under Type-Moon label itself though.
Music &amp; Drama CDs
I believe all music CDs are clean, but I can't comment on drama CDs.

As a matter of fact, only Fate/stay night and Fate/hollow ataraxia games require age checking on the official Type-Moon website.
Note: Regarding &quot;Kinoko Nasu first started Type-Moon as a doujin group, so I also include any Type-Moon released doujinshi they may have released (if there are any) which contained explicit content.&quot;, Type-Moon stopped being a doujin circle and instead became a game company in 2003. As a doujin circle, they only released Tsukihime and its extra contents. Fate/stay night was the first work as a game company.