October 8, 2010 Carlsbad, California – Killed 0-Dead 2

41-year-old Brendan O’Rourke climbed over a fence and opened fire with a handgun in a playground of Kelly Elementary School, which had 230 students; two second-grade female students were grazed in the arms before O’Rourke was subdued by a construction worker.

He was found guilty of seven counts of attempted murder and was sentenced to 189 years to life in prison.

Source: List of school shootings in the United States – Wikipedia, the free encyclopedia