I had one TPK when the players assumed the great wyrm they were talking with was evil and attacked it. They also learned the difference between "green dragon" and "emerald dragon" that day.
Most times, it's been because they don't use strategy. "Oh, those orcs have bows! No way they'd dive...