This sound is from Sound Effects - Gumshoe (USA) - Sound Effects (NES)

Phantasmagoria is a point-and-click adventure horror video game designed by Roberta Williams for MS-DOS and Microsoft Windows and released on August 24, 1995. The game was originally budgeted for $800,000, but it ultimately cost $4.5 million to develop and was filmed in a $1.
See also: Phoenix Wright: Ace Attorney – Trials and Tribulations, Zeitgeist (The Smashing Pumpkins album), List of The Daily Show recurring segments, Harmon Craig, and Ralph de Toledano.