Why did my headlights kill my car?

I would start at the battery connection. A poor one will overheat and fail, but a change in load can sometimes cause an arc that cleans a spot and continues to carry current.

The battery connections might be fine, but I've seen so many poorly connected ones cause trouble that it's the very first thing I do on any car these days..