Brooklyn Motor Vehcile Collision Data Analysis

This repository contains the work related to analysis done on NYC Motor Collision data so as to understand factors associated with accidents in Brooklyn area.

Agenda for Analysis

Motivation behind the analysis is to understand different factors associated with accidents in Brooklyn area and recommend ideas for reducing them.

The Data used for analysis is from Year 2015 - 2017 for Brooklyn Borough.

Vehicles associated and main causes of Accidents

As the trend shows majority of the accidents are caused by Passenger Vehicles followed by Sports Utility/Station Wagon Vehicles.

The main cause behind these accidents is due to Driver Inattention/Distraction and the failure to yield Right of way.

Time Series Analysis

The trend shows that the most affected injured population comprises of Motorist followed by the Pedestrians.

Under the Vision Zero plan, New York City and Brooklyn Area had its safest-ever year in 2016 with the fewest traffic fatalities ever recorded. Vision Zero is a program created by New York City Mayor Bill de Blasio in 2014. Its purpose is to reduce by 50% the number traffic fatalities by 2025.

Suggestions to Curb the Accidents

The major accidents for the motorists occurred in the area of Linden Boulevard followed by Ralph Avenue.

To reduce the number of these incidents I would suggest the below-

1. Put up more signs and boards especially for the right of way.
2. Add more speed bumps in these specific areas.
3. Increase the number of traffic cameras to capture the people breaking the traffic laws and penalize them accordingly.

The major accidents for the pedestrians occurred in the area of 4th Avenue.
To reduce the number of these incidents I would suggest the below-

1. Check the distance the pedestrians needs to cross and if it could be shortened by redesigning specific streets in these priority areas.
2. Increase the enforcement officials in these places so that traffic laws are strictly followed there.
3. There should be strict enforcement on passenger/taxi vehicles as those are the ones majorly responsible for reckless driving.
4. Collaborate with agencies to provide safety demonstrations to the public, strict training for passenger vehicles and people who have received speeding tickets in the past.

Accident By days and hour

Analysis and Suggestions

1. The trend shows the maximum accidents happen on Friday between 4-5 PM majorly because people are in a rush to leave office.
2. The best approach to reduce the incidents is to display warning signs on highways to drive slow, don’t text or talk on phone while driving.
3. Lot of people engage in drinking in the evening and they need to understand the impact if they drink above the limit. The penalty should be heavy in these cases to set good examples. Law enforcement should be added on Fri – Sun to track these drivers.

References

1. Google Big Query - https://cloud.google.com/bigquery/
2. Tableau 10.5 for analyzing the data.
3. Link To Dashboard: - https://public.tableau.com/profile/vizaarora#!/vizhome/Brooklyn-Accident_Analysis/BrooklynCollisionAnalysis
4. NYPD Motor Vehicle Collision Data - https://cloud.google.com/bigquery/public-data/nypd-mv-collisions