What spell did Fred Weasley die from?

Fred Weasley dies because it was a war and people die in wars, even good people.

J.K. Rowling originally planned to kill Arthur Weasley in the fifth book, but ultimately decided not to kill him so that Harry would have one father figure left and instead killed off Fred. Killing off good characters unexpectedly makes the series more real.