Excel Infographic: Showing When People Get Killed In Cars

Every year, the National Highway Traffic Safety Administration releases data for automobile crashes that result in a fatality. John Nelson, a designer at IDV Solutions, downloaded five years’ worth of data and dumped it into Excel. After massaging the data a bit, he came up with this Excel infographic.

The first set of graphs show accidents by the time of the day and the day of the week. Note some of the conclusions you can draw from this data:

There’s a higher percentage of alcohol-related accidents after midnight, when people are leaving bars.

Accidents involving pedestrians occur most frequently after dusk.

Accidents where weather is a factor tend to happen from 5 to 8 o’clock in the morning, when conditions like fog and ice cause trouble when people are driving to work.