I've only had two computers die on me. One was an A1200 mobo fitted in an Elbox tower which died after I reinserted the Power Flyer while it was in the tower and probably damaged something while the motherboard was bending under the pressure.
The other was my original A2000 which I took to Belize with me. My office had high humidity and no air conditioning and after 6 months the internal PSU caught fire! Nasty. At that time the ECS A1500 was out so I bought one of them and transferred the parts from the A2000.
My original VIC-20 is still alive and kicking, except the power lead broke where it inserts into the VIC and I cut the plug off, made 2 loops out of the wires, put them over the prongs and then shoved a lump of blue-tac in to hold it in place.
My original C64 is alive.
My original C128 was stolen and the A1500 from the Belize story above was sold when I moved to the USA.
I still have 2 functioning A1200T, a regular A1200, a CD32, used A2000 (perfect) and a used A3000 (no battery and an iffy df0). My Buddha IDE card has developed a strange fault where it either locks up the A2000 or A3000 or just doesn't allow the attached drives to be recognised. I picked up a C128 last month and it's in mint condition.
I've lost count of how many PCs I've owned and none of them have died, but I've had 3 hard drive failures over the years and an old Pentium 2 laptop needed the lid stwich to be bridged.