The Motor Vehicle Collisions crash table contains details on specific crash events that occurred around new York city. Each row represents a crash event. The Motor Vehicle Collisions data tables contain information from all police reported motor vehicle collisions in NYC.

The police report (MV104-AN) is required to be filled out for collisions where someone is injured or killed, or where there is at least $1000 worth of damage

The MV-104AN is a New York State form that has all the details of a traffic collision.

Link: https://data.cityofnewyork.us/Public-Safety/Motor-Vehicle-Collisions-Crashes/h9gi-nx95/about_data

The Motor Vehicle Collisions crash table contains data on police-reported motor vehicle collisions in NYC, with each row representing a crash event. Police fill out the MV-104AN form for any collision involving injury, death, or at least $1,000 in damage. This dataset is based on preliminary data, which can be updated as crash reports are revised.

The NYPD implemented TrafficStat in 1998, modeled after CompStat, to improve traffic safety by collecting and analyzing collision data. Initially, a system called TAMS was used to gather basic traffic crash statistics. As the need for more detailed data grew, the Vision Zero initiative, launched in 2014, emphasized the goal of eliminating traffic fatalities. In 2016, the NYPD replaced TAMS with the Finest Online Records Management System (FORMS), allowing officers to electronically input detailed data from the MV-104AN form.

For my analysis, I specifically used data where a bicyclist was injured or died in the collision.

What can we learn from this data?:

This dataset contains a total of 58,512 records. Of these:

• 15,366 records list “unspecified” as a contributing factor for the first vehicle involved in the collision.
• 28,663 records list “unspecified” as a contributing factor for the second vehicle.
• 13,225 records list “unspecified” as a contributing factor for both vehicles.

Regarding location data:

• 4,216 records are missing latitude and longitude information, with 998 of these also missing “on-street” details.
• 39 records are missing all geospatial information.
• 197 records incorrectly report the latitude and longitude as (0, 0).

Despite these issues, 54,099 records include latitude and longitude data. Of those, 8,539 are missing “on-street” information, but most still have other types of street data. Only 23 records lack any street information but still include location coordinates.

In terms of boroughs, Brooklyn leads with approximately 21,999 motor vehicle crashes involving cyclist injuries or deaths, followed by Manhattan with 18,673 Queens with 11,090, the Bronx with 5,756, and Staten Island with about 936 crashes.

The top ten streets across New York City with the most motor vehicle crashes involving cyclist injuries are Broadway (910 crashes), 5 Avenue (496), Bedford Avenue (420), 2 Avenue (392), 3 Avenue (388), 1 Avenue (330), Roosevelt Avenue (299), Fulton Street (281), Myrtle Avenue (277), and 7 Avenue (245).

Focusing on Manhattan, the top areas with the highest number of motor vehicle crashes involving cyclists are:

• Broadway (827)
• 2 Avenue (543)
• 1 Avenue (329)
• 3 Avenue (253)
• 5 Avenue (226)
• 8 Avenue (135)
• Avenue of the Americas (177)
• Amsterdam Avenue (164)

These streets highlight the most dangerous locations for cyclists in Manhattan, with Broadway and major avenues being particularly high-risk areas.

Trends in Bicycle Accidents from 2014 – 2023

Tree Map of Injuries by Contributing Factor And Injury Type

Instances where the Second Vehicle was a contributing factor

Sum of Injuries and Fatalities by Borough

Identifying the Month with the Highest Bicycle Collision Volume

Identifying the Weekday with the Highest Bicycle Collision Volume

Identifying the hour with the Highest Bicycle Collision Volume

What was the most prevalent contributing factor for each hour?

Vehicle Type of the First Vehicle Listed in the Accident Report

Vehicle Type of the Second Vehicle Listed in the Accident Report

What is causing Cyclist Death?

Which Vehicles are contributing to cyclist death?

Vehicle Types contributing to cyclist death by year

Sedans:

Sedans are one of the most frequent vehicle types involved in cyclist deaths.

They caused 3 deaths in 2024, down from a peak of 7 deaths in 2021 and 5 deaths in 2020.

Their consistent involvement highlights their prominence in urban traffic.

E-Bikes:

Rapid Increase: E-Bike involvement has risen significantly from 1 death in 2019 to a peak of 7 deaths in 2023.

Decline in 2024: E-Bike-related deaths fell to 2 in 2024, potentially due to improved regulations, awareness campaigns, and infrastructure changes.

In 2020, there were 2 recorded deaths, marking the beginning of E-bike fatalities in the dataset. In 2021, the number slightly increased to 3 deaths, indicating growing adoption and potential risks associated with E-bikes.

By 2023, E-bike deaths reached a notable high of 7 fatalities, reflecting a significant rise compared to earlier years. In 2024, the recorded deaths decreased to 2,

Station Wagons/SUVs:

This category has consistently caused cyclist deaths, with a high of 8 deaths in 2019 and steady representation every year.

In 2024, these vehicles accounted for 6 deaths, showing a continued risk to cyclists.

2013: Station wagons were linked to 2 deaths, marking their initial recorded involvement in fatalities.

2014: Fatalities increased to 6 deaths, indicating a rise in incidents involving these vehicles

2016: Deaths dropped to 1, showing a brief decline.

2017: A single death was recorded, maintaining the low level from the previous year.

2018: Fatalities again remained low at 1 death.

2019: Deaths spiked significantly to 8, marking a notable increase and the highest count in the dataset for this vehicle type.

2020: Fatalities decreased to 4 deaths, reflecting a reduction in incidents.2021: Deaths dropped further to 1, continuing the downward trend

2022: Fatalities rose slightly to 3 deaths.

2023: Deaths increased to 7, reflecting another significant spike.

2024: Station wagon-related deaths stabilized at 6 fatalities.

Bike on Bike Death

Bicycle-related deaths (caused by cyclist-cyclist collisions or other bike-related incidents) appear consistently across the dataset.

2017: The highest number of bike-related deaths (11 fatalities), highlighting potential issues with cyclist interactions or infrastructure.

2018 and 2022: Both years reported 5 fatalities, indicating continued risk despite growing safety awareness.

2024: 3 deaths, showing a slight decline but still indicating a significant issue.

Death By Truck

2024 – 12 – Highest number of truck-related deaths, led by Box Trucks (6).

2023 – 3 – Significant drop, dominated by Dump Trucks and Box Trucks.

2022 – 6 – Continued risks from Tanker Trucks and Tractor Trucks.

2019 – 10 – High fatalities from Dump Trucks (2) and Tanker Trucks (2).

2016 – 6 – Deaths across various types: Concrete Mixers, Flat Beds, and Box Trucks.

Garbage Trucks:

1.Consistent Involvement:

1.Garbage trucks (categorized as “Garbage or Refuse”) are involved in cyclist fatalities across several years.

2.They caused 1 death in 2022 and 1 death in 2019.

Buses

involved in multiple cyclist deaths over the years:1 death in 2023 and 2022.

4 deaths in 2020, marking the peak year for bus-related cyclist fatalities.

Sporadic involvement in earlier years, including 2 deaths in 2017 and 1 death in 2019.

Tractor Trucks

2 deaths in 2024 and 2022.

1 death per year in 2019, 2017, and 2016.

Tow Trucks

1 death each in 2022 and 2019.

Vehicle Types Involved in Cyclist Deaths by Year Summary(Death by truck)

Did you know…

According to the NYC Department of Transportation, over 24 million cycling trips were recorded across key locations in 2023, marking a 40% increase from 2019. However, despite infrastructure improvements, cycling-related injuries in Manhattan have risen by 15% since 2020, underscoring the need for further safety measures.

Visit Source: NYC Department of Transportation Cycling Data