About this Dataset

Railroad Equipment Accident/Incident Source Data (Form 54)

Rail equipment accidents/incidents, collisions, derailments, fires, explosions, acts of God, or other events involving the operation of railroad on-track equipment (standing or moving) and causing reportable damages greater than the reporting threshold for the year in which the accident/incident occurred, must be reported by railroads to the FRA on Form FRA 6180.54 - Rail Equipment Accident/Incident.

This dataset is the source dataset and contains raw data values. It replaced the legacy data download (https://safetydata.fra.dot.gov/OfficeofSafety/publicsite/on_the_fly_download.aspx). To download data that contains data in a user-friendly human-readable format, please reference https://data.transportation.gov/Railroads/Rail-Equipment-Accident-Incident-Data/85tf-25kj.

The data dictionary can be found here: https://datahub.transportation.gov/api/views/aqxq-n5hy/files/ea00a728-94b0-43e7-8c11-8481f13170a7?download=true&filename=accfile_EFFECTIVE_060111%20(8).pdf.

For information on how to filter and export data, please visit: https://data.transportation.gov/stories/s/Download-Export-and-Print-User-Guide/s8hj-vns8/.

To view the data release schedule, please visit: https://data.transportation.gov/stories/s/Data-Release-Schedule/qfc9-tapk/.
Organization: Department of Transportation
Last updated: 2025-09-10T23:38:37.866773
Tags: accident, form-54, rail-accident, rail-equipment, train-accident

Tables

Table 1

@usgov.dot_gov_railroad_equipment_accident_incident_source_fo_aed5e39c.table_1

37.62 MB
222,956 rows
145 columns

CREATE TABLE table_1 (
  "iyr" BIGINT,
  "imo" BIGINT,
  "railroad" VARCHAR,
  "incdtno" VARCHAR,
  "iyr2" DOUBLE,
  "imo2" DOUBLE,
  "rr2" VARCHAR,
  "incdtno2" VARCHAR,
  "iyr3" DOUBLE,
  "imo3" DOUBLE,
  "rr3" VARCHAR,
  "incdtno3" VARCHAR,
  "dummy1" VARCHAR,
  "gxid" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "timehr" DOUBLE,
  "timemin" DOUBLE,
  "ampm" VARCHAR,
  "type" BIGINT,
  "cars" BIGINT,
  "carsdmg" BIGINT,
  "carshzd" BIGINT,
  "evacuate" BIGINT,
  "division" VARCHAR,
  "station" VARCHAR,
  "milepost" VARCHAR,
  "state" BIGINT,
  "temp" BIGINT,
  "visiblty" DOUBLE,
  "weather" DOUBLE,
  "trnspd" DOUBLE,
  "typspd" VARCHAR,
  "trnnbr" VARCHAR,
  "trndir" VARCHAR,
  "tons" BIGINT,
  "typeq" VARCHAR,
  "eqatt" VARCHAR,
  "trkname" VARCHAR,
  "trkclas" VARCHAR,
  "trkdnsty" VARCHAR,
  "typtrk" VARCHAR,
  "rrcar1" VARCHAR,
  "carnbr1" VARCHAR,
  "positon1" DOUBLE,
  "loaded1" VARCHAR,
  "rrcar2" VARCHAR,
  "carnbr2" DOUBLE,
  "positon2" DOUBLE,
  "loaded2" VARCHAR,
  "headend1" BIGINT,
  "midman1" BIGINT,
  "midrem1" BIGINT,
  "rman1" BIGINT,
  "rrem1" BIGINT,
  "headend2" BIGINT,
  "midman2" BIGINT,
  "midrem2" BIGINT,
  "rman2" BIGINT,
  "rrem2" BIGINT,
  "loadf1" BIGINT,
  "loadp1" BIGINT,
  "emptyf1" BIGINT,
  "emptyp1" BIGINT,
  "caboose1" BIGINT,
  "loadf2" BIGINT,
  "loadp2" BIGINT,
  "emptyf2" BIGINT,
  "emptyp2" BIGINT,
  "caboose2" BIGINT,
  "eqpdmg" BIGINT,
  "trkdmg" DOUBLE,
  "cause" VARCHAR,
  "cause2" VARCHAR,
  "caskldrr" BIGINT,
  "casinjrr" BIGINT,
  "caskld" BIGINT,
  "casinj" BIGINT,
  "accause" VARCHAR,
  "acctrk" VARCHAR,
  "acctrkcl" VARCHAR,
  "highspd" DOUBLE,
  "accdmg" DOUBLE,
  "dummy2" VARCHAR,
  "stcnty" VARCHAR,
  "totinj" BIGINT,
  "dummy3" DOUBLE,
  "totkld" BIGINT,
  "engrs" DOUBLE,
  "firemen" DOUBLE,
  "conductr" DOUBLE,
  "brakemen" DOUBLE,
  "enghr" DOUBLE,
  "engmin" DOUBLE,
  "cdtrhr" DOUBLE,
  "cdtrmin" DOUBLE,
  "jointcd" BIGINT,
  "region" BIGINT,
  "dummy4" VARCHAR
);