SKYWALKER, ALARM - KLAXON "AHOOGA"

This's a Skywalker Sound sound effect.

Movies

 * Lorelei: The Witch of the Pacific Ocean (2005)
 * Speed 2: Cruise Control (1997)

Audio Samples
The oil tanker's alarm in Speed 2, close to and near the end of the film is the best source for reference.