This sound is from Sound Effects - Goonies II - Sound Effects (NES)

Wes Ford Takahashi is an American visual effects animator and animation supervisor. He is known for his special effects work on numerous films. His efforts include animating the time travel sequences for all three Back to the Future films and the "boy on the moon" in the DreamWorks logo.
See also: Kenneth F. Smith, Sean Astin, Close Encounters of the Third Kind, Back to the Future Part II & III, Superman (1978 film), Bill George (visual effects supervisor).