About this Dataset

Highway-Rail Grade Crossing Accident/Incident Source Data (Form 57)

All impacts between railroad on-track equipment and highway users at a highway-rail grade crossing are reported by railroads to the FRA on Form FRA F 6180.57 Highway-Rail Grade Crossing Accident/Incident Report.

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/Highway-Rail-Grade-Crossing-Accident-Data/7wn6-i5b9.

The data dictionary can be found here: https://datahub.transportation.gov/api/views/icqf-xf4w/files/531a212f-6b94-4403-9876-a6933a1469aa?download=true&filename=gxirfile_EFFECTIVE_060111%20(24).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:42:51.097765
Tags: form-57, grade-crossing, grade-crossing-incident, highway-rail, highway-rail-grade-crossing, highway-rail-incident

Tables

Table 1

@usgov.dot_gov_highway_rail_grade_crossing_accident_incident__2f92b996.table_1

22.28 MB
249,311 rows
103 columns

CREATE TABLE table_1 (
  "amtrak" VARCHAR,
  "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,
  "casinjrr" BIGINT,
  "gxid" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "timehr" BIGINT,
  "timemin" BIGINT,
  "ampm" VARCHAR,
  "station" VARCHAR,
  "county" VARCHAR,
  "state" DOUBLE,
  "region" DOUBLE,
  "dummy2" VARCHAR,
  "city" VARCHAR,
  "highway" VARCHAR,
  "vehspd" DOUBLE,
  "typveh" VARCHAR,
  "vehdir" VARCHAR,
  "position" DOUBLE,
  "rrequip" VARCHAR,
  "rrcar" DOUBLE,
  "typacc" DOUBLE,
  "hazard" DOUBLE,
  "temp" DOUBLE,
  "visiblty" DOUBLE,
  "weather" DOUBLE,
  "typeq" VARCHAR,
  "typtrk" DOUBLE,
  "trkname" VARCHAR,
  "trkclas" VARCHAR,
  "nbrlocos" DOUBLE,
  "nbrcars" DOUBLE,
  "trnspd" VARCHAR,
  "typspd" VARCHAR,
  "trndir" VARCHAR,
  "signal" VARCHAR,
  "locwarn" VARCHAR,
  "warnsig" DOUBLE,
  "lights" DOUBLE,
  "standveh" DOUBLE,
  "train2" VARCHAR,
  "motorist" DOUBLE,
  "view" DOUBLE,
  "vehdmg" DOUBLE,
  "driver" DOUBLE,
  "inveh" DOUBLE,
  "totkld" BIGINT,
  "totinj" BIGINT,
  "totocc" DOUBLE,
  "incdrpt" DOUBLE,
  "jointcd" BIGINT,
  "typrr" VARCHAR,
  "dummy3" DOUBLE,
  "caskldrr" BIGINT,
  "dummy4" DOUBLE,
  "crossing" VARCHAR,
  "narrlen" DOUBLE,
  "dummy5" DOUBLE,
  "year4" BIGINT,
  "division" VARCHAR,
  "public" VARCHAR,
  "cntycd" DOUBLE,
  "stcnty" VARCHAR,
  "hzmrlsed" DOUBLE,
  "hzmname" VARCHAR,
  "hzmqnty" VARCHAR,
  "hzmmeas" VARCHAR,
  "sigwarnx" VARCHAR,
  "whisban" VARCHAR,
  "drivage" DOUBLE,
  "drivsex" VARCHAR,
  "pleontrn" DOUBLE,
  "ssb1" VARCHAR,
  "ssb2" VARCHAR,
  "userkld" DOUBLE,
  "userinj" DOUBLE,
  "rrempkld" DOUBLE,
  "rrempinj" DOUBLE,
  "passkld" DOUBLE,
  "passinj" DOUBLE,
  "narr1" VARCHAR,
  "narr2" VARCHAR,
  "narr3" VARCHAR,
  "narr4" VARCHAR,
  "narr5" VARCHAR,
  "subdiv" VARCHAR
);