Road Accidents Analysis

Road Accident Dashboard Summary

Objective: The goal of this project is to provide an in-depth analysis of road accident statistics to identify key trends, patterns, and areas for improvement in road safety.

Dashboard Highlights:

Total Accidents and Casualties:

Total Accidents: 14,962

Total Casualties: 19,942

Breakdown: Slight (85%), Serious (13%), Fatal (2%)

Hourly Accident Ratio:

Peak accident times: 8% at 8 AM, 6% at 5 PM.

Monthly Casualty Trends (2021 vs 2022):

Comparison of monthly casualty trends between two years to spot seasonal variations.

Casualties by Vehicle Type:

Majority involving cars (15,594), followed by motorcycles (1,628) and bicycles (961).

Accident Percentage by Area and Road Type:

Urban areas: 68%, Rural areas: 32%.

Single Carriageway: 74%, Dual Carriageway: 24%.

Road Conditions and Weather:

Majority of accidents occurred on dry roads (60%) and in fine weather without high winds (71%).

Speed and Accident Ratio:

Most accidents happened at 30 KM/S (67.88%).

Key Factors Contributing to Accidents:

High percentages linked to urban settings (68.40%) and single carriageways (74.31%).

Accident Density Map:

Visualization of top 10 accident-prone locations in the UK.

Insights:

The dashboard reveals critical insights into when and where accidents most frequently occur, highlighting the importance of targeted safety measures.

The analysis helps pinpoint specific times of day, weather conditions, and road types that are associated with higher accident rates, informing future preventative strategies.