What you can ask
- “What does FRA Railroad Safety have for the area or asset I'm working on?”
- “Pull the most recent FRA Railroad Safety records and put them in a table.”
- “What does FRA Railroad Safety cover, and how fresh is the data?”
About this source
FRA Railroad Safety — Federal Railroad Administration (US DOT) Office of Safety Analysis accident/incident data, served via Socrata SODA on the USDOT open-data portal (data.transportation.gov). Two datasets: Form 54 — Rail Equipment Accident/Incident (~224K rows, 1975–present: derailments, collisions, and other rail equipment accidents, with railroad, location, damage cost, casualties, cause, and a free-text narrative) and Form 57 — Highway-Rail Grade Crossing Accident/Incident (collisions between rail equipment and highway users at grade crossings). Search and aggregate by state, accident type, railroad, and date. Note: numeric/date fields are returned as strings; a native GeoJSON `location` Point exists alongside latitude/longitude fields. No auth.
Connector ID fra-railroad-safety
Provenance
Freshness & coverage
› Methods (6)
Technical detail for developers: parameters, pagination, units, and freshness per method.
searchAccidents
readSearch Form 54 rail equipment accidents by state, accident type, railroad, and date
state code or name; railroad code (BNSF) or name part; newest first.
getAccidentById
readSingle Form 54 rail equipment accident record by its accident number
Required paramsaccidentNumberaccidentNumber required; returns found and the Form 54 record.
getAccidentStats
readGrouped counts of Form 54 accidents (e.g. by accident type, state, railroad, or year)
groupBy any column; optional state; returns groups sorted by count.
countAccidents
readCount-only of Form 54 accidents matching optional state and accident-type filters
Optional state and accidentType filters; returns count.
searchGradeCrossingIncidents
readSearch Form 57 highway-rail grade-crossing incidents by state
state accepts code or full name; limit max 1000; newest first.
getServiceInfo
readStatic API overview — the two datasets, SoQL filters, string-typed fields, and Socrata token note
