BECMI:
X3, Curse of Xanathon, has some mystery/investigative elements.
1E:
N2, The Assassin's Knot. PDF used to be available free on the WOTC site, though I don't know if it still is. Pretty solid murder mystery.
I2, Tomb of the Lizard King. Little mystery, mostly revenge.