top of page
Search

NYC Vehicle Collision Risk Analysis

  • Writer: Rajwol Khadka
    Rajwol Khadka
  • Mar 19
  • 2 min read

Updated: Apr 4

Project Overview


This project utilizes data from New York City's Open Data Portal to analyze motor vehicle collisions across the city. The dataset encompasses detailed information about collisions, including:

  • Geographic information (boroughs and zip codes)

  • Recorded injuries and fatalities

  • Contributing factors leading to the collisions

The primary objective is to leverage SQL for data analysis and visualize these insights through an interactive Tableau Dashboard


Dataset Description

 

Objectives

  • Time Series Analysis: Identify collision patterns by days of the week and times of the day.

  • Root Cause Analysis: Determine the leading contributing factors to collisions.

  • Location Trends: Explore boroughs and neighborhoods with high collision frequencies to uncover trends.


 

Dashboard

Click here to view interactive Tableau dashboard


 

Analysis

  1. Encouraging Trends: The total number of vehicle collisions has decreased 60.7% from 2018 to 2024, reflecting a significant downtrend due to effective safety measures, stricter policies and penalties, and increased adoption of safety features in vehicles.


  2. Pay Attention!: Through all combination of borough and year, driver inattention / distraction was the number one contributor to collisions. One in four (25%) of all collisions are a result of driver inattention / distraction, 3.2 times more than the second-leading cause (following too closely). This prioritizes a need to focus on targeting distracted drivers through awareness campaigns, stricter enforcement, or technology solutions in order to mitigate the potential of a collision.


  3. Injuries & Fatalities: Trends within the data reveal that vehicle collisions account for an average of 267 fatalities per year. Furthermore, approximately 40% of all collisions result in an injury.


  4. Identifying Hotspots: Specifically in Brooklyn, the neighborhoods of East New York (11207) and Canarsie (11236) account for 12% of all collisions and nearly 10% of all vehicle-related fatalities within the borough despite being only 5% of the borough's zip codes (2 out of 38). These statistics indicate a disproportionately high share of traffic incidents and a need to prioritize for safety interventions in these areas.



 
 
 

Comments

bottom of page