I think it’s probably the humpback whale sounds from Star Trek 4
You mean when the earth was being threatened by a giant screeching beef log?