This is kind of messed up...but hilarious at the same time. I hope that someone can verify that this was an actual error sound effect.
The 13 Other Greatest Error Messages of All Time|Technologizer
4. Car Crash (early Macs)
In our earlier error story, I named the Mac’s Sad Mac error as the third greatest error message of all time. Several commenters responded by bringing up the sound effect that accompanied the Sad Mac when pre-1998 Macs failed their Power On Self Test (POST) bootup diagnostics–which was, in some cases, that of a crashing car, complete with breaking glass. Like many error messages, the effect added pain to what was likely already a stressful situation; a neutral beep or two (as used by PCs and later Macs) would have sufficed. One commenter shared a heart-rending story of an assistant who was reduced to tears by the car crash; reading of her distress, I’m getting a little emotional myself.
Here's the "heart-rending story":
I came back to my office one day with my assistant crying and hysterical. The OS 7.?.? Mac had crashed on her, and instead of the bomb (which would have been bad enough), it played the sound of a car skidding to a stop before crashing.
Horrible sound. Traumatizing sound. About as far as you can get from the happy smiling Mac and comparatively nonthreatening cartoon bomb.
So, the Mac car-crash sound gets my vote for scaring the hell out of the people who hear it.
Blue Screen may not be that informative for non-techies, but at least it doesn't traumatize them.