top of page
Search

NYC Vehicle Collision Risk Analysis

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

Updated: Apr 4, 2025

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