I've usually gotten rid of a vehicle while it's still operational- either it I'd get tired of it, it would need repairs that I wasn't rich enough or ambitious enough to undertake, or sometimes it would no longer suit my needs.
But I've had two vehicles that died in sudden and spectacular fashion. The first was my 1985 Buick Lesabre. First halfway decent car I ever owned- had intact factory paint, working a/c... the entire vehicle was reasonably functional. I bought it in 1996 and drove it until Spring of 1998- at which time I crashed it. Pulled out in front of a gal driving a Dodge Caravan- entirely my fault. She was ok, but the van was totaled, and the Buick's driver's side door was pushed in about 18". My knee was between the driver's door and the steering wheel and got a little bruised- but luckily the steering column broke before my knee did. Would've killed me if I hadn't been driving a massive Buick. I got a nice lawsuit out of the deal- luckily covered by my insurance. And I became a much more cautious driver... still am 13 years later.
My other spectacular vehicle failure was just a few months ago. I had taken my '94 Chevy Corsica on a 1000-mile road trip back to Tennessee (stupid, I know... long story). Anyway, the car made it to Tennessee without incident. On the way back to Kansas, I was cruising along at 70mph going up and down some big hills on I-75 in Eastern Kentucky. It was about 75 degrees outside. The car was running perfectly, no overheating, no abnormal behavior whatsoever. I topped a long, steep pass... rolled down hill for a while... crossed a bridge at the bottom... then the interstate started sloping back up for the next hill. I heard this awful racket. Looked around to see if maybe a Harley was passing me- nothing. Swerved a little to feel the tires- thought maybe one was coming apart- nothing. Then I realized that I was hearing the engine hitting against the rev limiter. The transmission was in 'drive', but wouldn't pull the vehicle. The car rolled to a stop and never moved under its own power again. It was filled with relatively fresh Dexron VI (maybe 10,000 miles on it). Fluid level was fine. I'd had an external transmission cooler on this vehicle for years, and an inline filter (which was fairly new). When I'd idle the engine and check the ATF level, it showed over-full... just like when you check it with the engine shut of. The pump wasn't pumping.
I had my brother drive up from TN (a couple hours away) and pick up me and the car. I flew back to Kansas, and now the old Corsica sits at a friend's house. He has since removed a trans cooler line and started the engine- no ATF came out. Somehow the pump or the pump shaft failed suddenly and completely.