Fred Weasley dies in Harry Potter and the Deathly Hallows (Book 7), during the Battle of Hogwarts.
He is killed by an explosion caused by a Death Eater (implied to be Augustus Rookwood) while fighting alongside his brother Percy. George survives, losing an ear earlier in the book.