NYC Car Crash Data Exploration In SQL
About this project
Link to project: NYC Car Crash Data Exploration In SQL
The objective of this project is to reveal significant insights into car crashes in New York City. The obtained information will be utilized to assist transportation safety officials in making informed decisions regarding the implementation of safety measures and regulations, which aim to decrease the incidence of car crashes in the city.
Key Insights From Analysis
"Unspecified" represents the contributing factors for about 1 Million NYC car crashes. When we combine the top 9 contributing factors after "Unspecified", they account for an additional 770K incidents. This indicates a significant portion of car crashes where the cause is unknown, making it challenging to identify specific reasons and devise effective solutions. To address this issue, I recommend enhancing the data collection process concerning contributing factors. By improving data collection, we can gain better insights into the causes of car crashes and develop more targeted approaches to prevent them.
Apart from the category of "Unspecified," the leading contributing factor for car crashes involving injuries is "Driver Inattention/Distraction." It surpasses the next highest contributing factor by more than double. To enhance road safety, apart from addressing the unspecified category, it is crucial to prioritize combating distracted driving through awareness campaigns, stricter enforcement, and promoting responsible driving habits. By targeting this key factor, we can significantly reduce injuries caused by car crashes and improve overall road safety.
In fatal car crashes, "unsafe speed" surpasses "Driver Inattention/Distraction" as the leading cause. Addressing both factors is crucial for prioritizing road safety. Possible solutions include stricter speed limit enforcement, education on the dangers of speeding, and implementing traffic calming measures.
Brooklyn has the highest number of car crashes in NYC, surpassing the next-highest borough by about 20%. To effectively address this issue, it is crucial to target efforts and resources toward improving road safety in Brooklyn.
To effectively reduce the car crash rate in NYC, it is crucial to implement specific safety measures at the locations with the highest number of crashes, as shown on slide 17.
About 70% of car crashes happen between 8 am and 8 pm. Though this seems significant, it is important to consider the potential influence of higher traffic volume during that time period. Since there are typically more cars on the road during daytime hours, it is reasonable to expect a higher likelihood of car crashes occurring between 8 am and 8 pm.
