The NYC Open Data portal provides an interesting data set from the NYPD that is a breakdown of every motor vehicle collision in NYC by location and injury. Each record represents a collision in NYC by city, borough, precinct and cross street. This data can be used by the public to see how dangerous/safe intersections are in NYC.
We imported the data into the DB4IoT analytics platform to visualize the six-year period from July 2012 through June 2018. The following series of images detail the results. Public data sets such as this can be combined in DB4IoT with transportation, traffic, smart-city and ITS data from other soutces such as INRIX, GTFS feeds, CAD/AVL feeds etc. to give planners and traffic engineers a more comprehensive big picture view that leads to better decisions and outcomes.
1.3 Million Collisions in Six Years
The histogram shows the distribution by time of day.
243,000 Collisions with Injuries
Histogram: collisions track activity patterns during the day
3,317 Injury Collisions with Alcohol Involvement
Histogram: many more alcohol-related collisions take place at night
155,000 Collisions with Injured Motorists
Histogram: collisions track activity patterns during the day
25,000 Collisions with Injured Cyclists
Given there are fewer cyclists, cycling is relatively dangerous
65,000 Collisions with Injured Pedestrians
Walking and public transit are less dangerous than driving
538 Collisions with Motorist Fatalities
Collisions at night are more often deadly for motorists
106 Collisions with Cyclist Fatalities
NYPD Motor Vehicle Collisions – Number of Collisions with Cyclist Fatalities
822 Collisions with Pedestrian Fatalities
Pedestrians are injured less frequently, but four times more likely to die in collisions with motor vehicles
