I recall about twenty years ago when a S-3 Viking went down in a parking lot in Sorrento Valley. I was heading south on I-5, right at the 805 split, when it went overhead and down. Intense.
There was an A3D that went down in the pattern at Miramar in '87. An A-4 went down on approach in the hills east of Miramar in 89-89 timeframe. I remember the smoke billowing up on the horizon. It maked you feel bad in your gut.