In Harry Potter and the Order of the Phoenix (both book and film), Sirius Black is killed by his cousin, Bellatrix Lestrange. During the Battle of the Department of Mysteries, Bellatrix hits Sirius with a curse (the Killing Curse in the film; an unnamed spell in the book) that knocks him backward through the veil in the Death Chamber—an archway separating the living from the dead.
Sirius's death is a pivotal moment: it shatters Harry's last link to his parents' generation, fuels his rage against Bellatrix, and underscores the war's escalating cost. Bellatrix later dies at Molly Weasley's hand in the final battle—a poetic justice for the murder of her "blood traitor" cousin.