Skip to content

Analyse

Understanding Vehicle Accidents in France

Explored French government open data on road traffic accidents in Excel to identify key risk factors, accident patterns and prevention levers for La Poste's vehicle fleet.

Data AnalysisExcelOpen DataRoad Safety

The challenge

Operating one of the largest vehicle fleets in France, La Poste is directly exposed to road risk. Conducted during a three-week Business Deep Dive, this study analyzed national road accident records to better understand the circumstances and dynamics behind vehicle accidents in France.

The question

What do French government road-safety datasets reveal about the conditions, vehicle profiles and risk factors driving traffic accidents across France?

What I did

Structured, cleaned and cross-tabulated the government accident databases in Excel using pivot tables, statistical breakdowns and multi-criteria filtering to isolate high-risk profiles and recurring accident dynamics.

Backstage · Data sources

French government open datasets on road traffic accidents across France (circumstances, locations, weather/lighting conditions, vehicle categories and severity).

The result

Delivered a structured breakdown of road accident drivers in France, highlighting the most critical temporal, environmental and behavioral risk factors to support fleet safety and prevention initiatives.