Traffic Accidents in the UK 2012-2014

Project Overview

UK Traffic Accident looks at the UK’s road casualty statistics, analysing the data for each country that is: Scotland, Ireland and England.
Statistics for road injury in Great Britain are collated and published by the Department of Transportation. The information used to create these statistics are collected by police forces, either through officers attending the scene of crashes or from members of the public reporting a crash in police stations after the incident, or online.
Statistics for Northern Ireland are collated and published by Police service of Northern Ireland.
For the purpose of this project, The data has been extracted from the original file for efficiency purposes. This project analyzes traffic accidents for the years 2012- 2014 with attributes like road type, weather conditions, light conditions , speed limit , number of causalities etc.
This project aims to analyze the UK accident data to inform the UK government agencies and the public on trends and possible causes of traffic accidents and what could be done to reduce them by focusing on five KPIs - Total Accidents, Daily Accidents, Accidents Mom%, Accidents YoY% and High Severity YoY%.

Role:

Problem Statement

Every day, hundreds of road traffic accidents occur across the country. In fact, statistics show that there are more than 10 motor vehicle-related deaths each day in any give Province. Many of the common causes of collisions are preventable. Significant percentage of the motorists are underinsured.
Road accidents occur for a variety of reasons. Often, drivers are distracted while behind the wheel, taking their focus away from the road. In other cases, drivers can become tired after spending multiple hours at the wheel, resulting in preventable errors.
Sometimes, accidents occur for a combination of reasons, from bad visibility to unsafe road design, or other drivers lack caution. While the causes of accidents can vary, the consequences are often the same, resulting in everything from vehicular and property damage to serious injuries.

Executive Summary

Data Dictionary

Key Takeaways