This sound effect can be found on RH 66/67, which was made by Robert Hall Productions.
https://soundeffects.fandom.com/wiki/File:Robert_Hall,_U.S_Navy_Cruiser_(General_Alarm).ogg