About this Dataset

Rail Equipment Accident/Incident Data (Form 54) Subset – Unique Train Accidents (Not At Grade Crossings)

October 2025 - Dataset View and OData/API Connection Change Notice - Please Read: https://data.transportation.gov/stories/s/6kdh-gsgx

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.

Please note that this dataset displays unique train accidents. When an accident involves multiple railroads, each railroad must report its data. As a result, there can be multiple records for one accident. This dataset has been modified to pull and display one record for each accident. Highway-rail crossing incidents have also been removed from this dataset because they are not considered train accidents.

To see the full dataset with all reports with all data for all accidents, please visit 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/byy5-w977/files/ac84a1c8-56d4-4a21-85c2-3a33080ab720?download=true&filename=Form54_Data_Dictionary.xlsx.

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:39:39.480317
Tags: accident, form-54, rail-accident, rail-equipment, train-accident

Tables

Table 1

@usgov.dot_gov_rail_equipment_accident_incident_form_54_subse_38de1159.table_1

46.52 MB
181,015 rows
161 columns

CREATE TABLE table_1 (
  "reporting_railroad_code" VARCHAR,
  "reporting_railroad_name" VARCHAR,
  "year" BIGINT,
  "accident_number" VARCHAR,
  "pdf_link" VARCHAR,
  "accident_year" BIGINT,
  "accident_month" BIGINT,
  "other_railroad_code" VARCHAR,
  "other_railroad_name" VARCHAR,
  "other_accident_number" VARCHAR,
  "other_accident_year" DOUBLE,
  "other_accident_month" DOUBLE,
  "maintenance_railroad_code" VARCHAR,
  "maintenance_railroad_name" VARCHAR,
  "maintenance_accident_number" VARCHAR,
  "maintenance_accident_year" DOUBLE,
  "maintenance_accident_month" DOUBLE,
  "grade_crossing_id" VARCHAR,
  "day" BIGINT,
  "date" VARCHAR,
  "time" VARCHAR,
  "accident_type_code" BIGINT,
  "accident_type" VARCHAR,
  "hazmat_cars" BIGINT,
  "hazmat_cars_damaged" BIGINT,
  "hazmat_released_cars" BIGINT,
  "persons_evacuated" BIGINT,
  "subdivision" VARCHAR,
  "division_code" VARCHAR,
  "division" VARCHAR,
  "station" VARCHAR,
  "milepost" VARCHAR,
  "state_code" BIGINT,
  "state_abbreviation" VARCHAR,
  "state_name" VARCHAR,
  "county_code" DOUBLE,
  "county_name" VARCHAR,
  "district" BIGINT,
  "temperature" DOUBLE,
  "visibility_code" DOUBLE,
  "visibility" VARCHAR,
  "weather_condition_code" DOUBLE,
  "weather_condition" VARCHAR,
  "track_type_code" VARCHAR,
  "track_type" VARCHAR,
  "track_name" VARCHAR,
  "track_class" VARCHAR,
  "track_density" VARCHAR,
  "train_direction_code" VARCHAR,
  "train_direction" VARCHAR,
  "equipment_type_code" VARCHAR,
  "equipment_type" VARCHAR,
  "equipment_attended" VARCHAR,
  "train_number" VARCHAR,
  "train_speed" DOUBLE,
  "recorded_estimated_speed" VARCHAR,
  "maximum_speed" DOUBLE,
  "gross_tonnage" BIGINT,
  "signalization_code" DOUBLE,
  "signalization" VARCHAR,
  "method_of_operation_code" VARCHAR,
  "method_of_operation" VARCHAR,
  "adjunct_code_1" VARCHAR,
  "adjunct_name_1" VARCHAR,
  "adjunct_code_2" VARCHAR,
  "adjunct_name_2" VARCHAR,
  "adjunct_code_3" VARCHAR,
  "adjunct_name_3" VARCHAR,
  "remote_control_locomotive_code" DOUBLE,
  "remote_control_locomotive" VARCHAR,
  "first_car_initials" VARCHAR,
  "first_car_number" VARCHAR,
  "first_car_position" DOUBLE,
  "first_car_loaded" VARCHAR,
  "causing_car_initials" VARCHAR,
  "causing_car_number" DOUBLE,
  "causing_car_position" DOUBLE,
  "causing_car_loaded" VARCHAR,
  "positive_alcohol_tests" DOUBLE,
  "positive_drug_tests" DOUBLE,
  "passengers_transported" VARCHAR,
  "head_end_locomotives" BIGINT,
  "mid_train_manual_locomotives" BIGINT,
  "mid_train_remote_locomotives" BIGINT,
  "rear_end_manual_locomotives" BIGINT,
  "rear_end_remote_locomotives" BIGINT,
  "derailed_head_end_locomotives" BIGINT,
  "derailed_mid_train_manual_locomotives" BIGINT,
  "derailed_mid_train_remote_locomotives" BIGINT,
  "derailed_rear_end_manual_locomotives" BIGINT,
  "derailed_rear_end_remote_locomotives" BIGINT,
  "loaded_freight_cars" BIGINT,
  "loaded_passenger_cars" BIGINT,
  "empty_freight_cars" BIGINT,
  "empty_passenger_cars" BIGINT,
  "cabooses" BIGINT,
  "derailed_loaded_freight_cars" BIGINT,
  "derailed_loaded_passenger_cars" BIGINT,
  "derailed_empty_freight_cars" BIGINT,
  "derailed_empty_passenger_cars" BIGINT
);