Rocco Panella

The Worst US States for Getting Stuck in Traffic from Accidents and Construction

· #data science #python #traffic #analysis

I have long been interested in the experiences of driving across the United States. Almost everyone I have met has their own anecdotes about how bad certain states are for drivers.

I decided to pull available data for a slightly tongue-in-cheek exercise to determine which US states actually are most unpleasant for drivers.

Data

I found two interesting datasets on Kaggle:

Assembled by Sobhan Moosavi and their research team:

Moosavi, Sobhan, et al. “A Countrywide Traffic Accident Dataset.” 2019.

To normalize fairly, I used the Federal Highway Administration’s road length data — so we compare events per 100 miles of lane rather than raw counts:

Analysis approach

A few important notes:

  1. Only 2021 data is used. Collection methods improved each year, making year-over-year trends unreliable.
  2. Alaska and Hawaii excluded due to data availability.
  3. Highway vs. surface-street classification is approximate (based on road name patterns).

1. Which states have the most traffic events per 100 miles of road?

Starting with raw totals (reality check):

Total Counts of Events Total count of traffic events by state in 2021

Big states lead the way — and Pennsylvania ranks just behind Texas. Now normalized to events per 100 miles of lane:

Total Events per 100 miles road Traffic event occurrence per 100 miles of road by state in 2021

Washington D.C. leads by a wide margin. Florida, California, and New York follow. Weighting by severity doesn’t change rankings meaningfully:

Severity Events per 100 miles road Traffic events per 100 miles, weighted by severity, 2021

Breaking it down into accidents vs. construction:

Accidents per 100 miles road Accidents per 100 miles of road by state in 2021

Construction per 100 miles road Construction per 100 miles of road by state in 2021

And looking at all 49 states/DC:

Every State Traffic events per 100 miles of road, all states, 2021

2. Highway vs. surface street differences

Accidents Highway Accidents per 100 miles of highway lane

Accidents Surface Accidents per 100 miles of surface street lane

DC leads both. South Carolina ranks significantly worse for surface streets than highways. New Jersey ranks poorly for highway accidents but doesn’t crack the top 10 for surface streets — who gets off the highway in Jersey?

Full rankings across all categories:

StateTotal EventsAccidents HwyAccidents RoadConstruction HwyConstruction RoadFederal Funding
DC1111215
FL232439
AZ3151030112
CA42311111
NY511111042
DE612142538
PA7148368
MD855231010
NJ9616894
CT1041861416
VA1176151219
CO1229365822
OR1381572323
LA1418791627
SC1594184232
IL1636262573
IN172630121313
TX18241319186
MN191019292411
WA20212317195
UT211317312824
NC22179363520
RI231933212235
ID243222222041
MI252721451521
AR263031143036
MA27383832177
GA282535272614
TN291612464125
MT302020204544
WY314045243648
OH324329282518
ME3348372139
NM343943133731
NV353132164328
OK364527263433
WV372225333843
AL382328394029
WI394647402926
IA403334443134
KY414144383230
VT4246482749
NH434442353346
KS443540343937
MO452824434617
MS463437414440
SD474749424845
NE484241474742
ND493739494947

Some interesting observations:

3. Does accident frequency correlate to construction frequency?

Correlation matrix (1 = perfectly correlated, 0 = no correlation):

Total EventsAccidents HwyAccidents RoadConstruction HwyConstruction RoadFederal Funding
Total Events10.8020.8750.7210.9140.345
Accidents Hwy0.80210.8350.6730.5350.451
Accidents Road0.8750.83510.5970.6570.329
Construction Hwy0.7210.6730.59710.5250.247
Construction Road0.9140.5350.6570.52510.232
Federal Funding0.3450.4510.3290.2470.2321

Key findings:

Summary

Most unpleasant states for driving (normalized by road miles): DC, Florida, California, Arizona, New York, Delaware, Pennsylvania.

Least eventful: The Dakotas, Nebraska, Mississippi, Missouri.

A correlation above 0.5 between accidents and construction is enough evidence for me that there’s a real relationship worth investigating further — especially for highway planners.

Here’s to hoping Pennsylvania gets those highways repaired!

Rocco Panella, May 5, 2022