The most fascinating ones to me are the ones where there is a completely survivable mechanical failure, combined with human failures that lead to crashes. The one that comes to mind there is the plane where the engine was leaking fuel, so the tanks were not equal so the pilots engaged the cross-feed valve, causing BOTH tanks to drain leading to an out-of-fuel situation. If they hadn't done that, they could have easily made it to their ETOPS airport with minimal issues.
Also, that show makes me sound smarter than I am. I've had conversations with pilots, who will ask if I'm a pilot. Its great fun for parties when you run into pilots (GA and commercial).