Open data

Every death, one CSV

One row per person killed, 2010–2024, versioned in the open. No portal or login — a plain CSV you can cite, fork, or take to a city council meeting.

The dataset

Every pedalcyclist fatality in NHTSA's Fatality Analysis Reporting System, 2010–2024, cleaned and joined: date, location (99.5% geocoded), age, sex, light condition, striking vehicle class, and crash-level hit-and-run, impaired-driver and speeding flags.

cyclist_fatalities.csv13,050 rows · 1.4 MB · CC BY 4.0
DATA_DICTIONARY.mdcolumn definitions & caveats
aggregates.jsonpre-computed chart data · JSON

Methodology

  • Source: NHTSA FARS annual files (public domain), person type 6–7, fatal injury.
  • Validated: yearly totals match NHTSA published counts (2010: exact; 2023: 1,173 exact).
  • Hit-and-run, impairment and speeding are crash-level flags — "any vehicle in the crash," NHTSA's own convention.
  • 2024 is NHTSA's Annual Report File and will be revised; we re-release when FARS finalizes.
  • Pipeline code is open source — every transform is inspectable and re-runnable.

License

Data: CC BY 4.0 — use it for anything, credit "Last Ride Registry." Code: MIT. Upstream FARS data is US-government public domain.

The pattern

What fifteen years of data show

Fifteen years of federal crash data, one row per person. The numbers below reconcile with NHTSA's published totals to within a fraction of a percent, and every row behind them is downloadable above.