Rail Equipment Accident/Incident Data (Form 54)
datahub.transportation.gov | Last Updated 29 Sep 2024This dataset is in a user-friendly human-readable format. To download the source dataset that contains raw data values, go here: https://data.transportation.gov/dataset/Form-54-Source-Table/aqxq-n5hy.
This dataset has the following 161 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Reporting Railroad Code | reportingrailroadcode | text | Code of the reporting railroad [Block #1a on Form 6180.54] | UP BNSF CSX BN CR view top 100 |
| Reporting Railroad Name | reportingrailroadname | text | Name of the reporting railroad [Block #1 on Form 6180.54] | Union Pacific Railroad Company BNSF Railway Company CSX Transportation Burlington Northern Railroad Company Conrail view top 100 |
| Year | year | text | Report year | 1978 1977 1976 1979 1980 view top 100 |
| Accident Number | accidentnumber | text | Assigned accident number for the reporting railroad [Block #1b on Form 6180.54] | 001 0410001 0940001 0830001 0330001 view top 100 |
| PDF Link | url | url | Pdf readout of the form contents | view top 100 |
| Accident Year | accidentyear | text | Year of accident for reporting railroad [Block #5 on Form 6180.54] | 78 77 76 79 80 view top 100 |
| Accident Month | accidentmonth | text | Month of accident for reporting railroad [Block #5 on Form 6180.54] | 03 01 07 08 06 view top 100 |
| Other Railroad Code | otherrailroadcode | text | Code of the other railroad involved [Block #2a on Form 6180.54] | ATK UP CR BNSF BN view top 100 |
| Other Railroad Name | otherrailroadname | text | Name of the other railroad involved [Block #2 on Form 6180.54] | Amtrak (National Railroad Passenger Corporation) Union Pacific Railroad Company Conrail BNSF Railway Company Burlington Northern Railroad Company view top 100 |
| Other Accident Number | otheraccidentnumber | text | Assigned accident number for the other railroad involved [Block #2b on Form 6180.54] | INDUSTRY ZZZZZZZZZZ 0360001 ZZZ 0920001 view top 100 |
| Other Accident Year | otheraccidentyear | text | Year of accident for other railroad involved [Block #5 on Form 6180.54] | 78 77 76 79 75 view top 100 |
| Other Accident Month | otheraccidentmonth | text | Month of accident for other railroad involved [Block #5 on Form 6180.54] | 03 02 06 01 10 view top 100 |
| Maintenance Railroad Code | maintenancerailroadcode | text | Code of the railroad responsible for track maintenance [Block #3a on Form 6180.54] | UP BNSF CSX BN CR view top 100 |
| Maintenance Railroad Name | maintenancerailroadname | text | Name of the railroad responsible for track maintenance [Block #3 on Form 6180.54] | Union Pacific Railroad Company BNSF Railway Company CSX Transportation Burlington Northern Railroad Company Conrail view top 100 |
| Maintenance Accident Number | maintenanceaccidentnumber | text | Assigned accident number for the railroad responsible for track maintenance [Block #3b on Form 6180.54] | INDUSTRY 001 0830001 0940001 0530001 view top 100 |
| Maintenance Accident Year | maintenanceaccidentyear | text | Year of accident for railroad responsible for track maintenance [Block #5 on Form 6180.54] | 78 77 76 79 80 view top 100 |
| Maintenance Accident Month | maintenanceaccidentmonth | text | Month of accident for railroad responsible for track maintenance [Block #5 on Form 6180.54] | 03 01 07 08 06 view top 100 |
| Grade Crossing ID | gxid | text | Grade crossing ID number [Block #4 on Form 6180.54] | NOTASGN 522646H 027656A 272609N 745870K view top 100 |
| Day | day | text | Day of the accident | 17 14 12 05 10 view top 100 |
| Date | date | calendar_date | Date of the accident [Block #5 on Form 6180.54] | 1978-01-20T00:00:00.000 1978-02-04T00:00:00.000 1980-03-21T00:00:00.000 1977-01-14T00:00:00.000 1979-11-10T00:00:00.000 view top 100 |
| Time | time | text | Time of the accident [Block #6 on Form 6180.54] | 5:00 PM 10:30 AM 2:30 AM 4:30 PM 4:00 PM view top 100 |
| Accident Type Code | accident_type_code | text | Type of accident code [Block #7 on Form 6180.54] | 01 04 12 07 03 view top 100 |
| Accident Type | accidenttype | text | Type of accident [Block #7 on Form 6180.54] | Derailment Side collision Other impacts Hwy-rail crossing Rear end collision view top 100 |
| Hazmat Cars | hazmatcars | number | Number of hazmat cars involved [Block #8 on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Hazmat Cars Damaged | hazmatcarsdamaged | number | Number of hazmat cars damaged or derailed [Block #9 on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Hazmat Released Cars | hazmatreleasedcars | number | Number of cars that released hazmat [Block #10 on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Persons Evacuated | personsevacuated | number | Number of persons evacuated [Block #11 on Form 6180.54] | 0 50 100 200 20 view top 100 |
| Subdivision | subdivision | text | Railroad subdivision [Block #12 on Form 6180.54] | SYSTEM NORTH PLATTE TERMINA PITTSBURGH ALABAMA INDIANAPOLIS TERMINA view top 100 |
| Division Code | divisioncode | text | Railroad division code [For accidents occurring June 1, 2011 or later, this field will be blank.] | ?????? SYSTEM CHICAG SOUTHE HOUSTO view top 100 |
| Division | division | text | Railroad division [For accidents occurring June 1, 2011 or later, this field will be blank.] | SYSTEM CHICAGO SOUTHERN WESTERN HOUSTON view top 100 |
| Station | station | text | Nearest city and town [Block #13 on Form 6180.54] | KANSAS CITY HOUSTON CHICAGO MEMPHIS NORTH PLATTE view top 100 |
| Milepost | milepost | text | Nearest milepost to the accident [Block #14 on Form 6180.54] | 0.0 YARD 0 0000.0 1.0 view top 100 |
| State Code | statecode | text | FIPS state code [Block #15 on Form 6180.54] | 17 48 06 42 39 view top 100 |
| State Abbreviation | stateabbr | text | Two letter abbreviation of state [Block #15 on Form 6180.54] | IL TX CA PA OH view top 100 |
| State Name | statename | text | Name of state | ILLINOIS TEXAS CALIFORNIA PENNSYLVANIA OHIO view top 100 |
| County Code | countycode | number | FIPS county code | 31 37 201 1 95 view top 100 |
| County Name | countyname | text | Name of county [Block #16 on Form 6180.54] | COOK JEFFERSON HARRIS JACKSON LINCOLN view top 100 |
| District | district | text | FRA assigned geographical district | 4 5 6 3 2 view top 100 |
| Temperature | temperature | number | Temperature recorded at time of accident [Block #17 on Form 6180.54] | 70.0 60.0 50.0 65.0 40.0 view top 100 |
| Visibility Code | visibility_code | text | Visibility code recorded at time of accident [Block #18 on Form 6180.54] | 2 4 3 1 0 view top 100 |
| Visibility | visibility | text | Visibility recorded at time of accident [Block #18 on Form 6180.54] | Day Dark Dusk Dawn view top 100 |
| Weather Condition Code | weather_condition_code | text | Weather condition code recorded at time of accident [Block #19 on Form 6180.54] | 1 2 3 6 4 view top 100 |
| Weather Condition | weathercondition | text | Weather condition recorded at time of accident [Block #19 on Form 6180.54] | Clear Cloudy Rain Snow Fog view top 100 |
| Track Type Code | track_type_code | text | Type of track code [Block #20 on Form 6180.54] | 2 1 4 3 5 view top 100 |
| Track Type | tracktype | text | Type of track [Block #20 on Form 6180.54] | Yard Main Industry Siding view top 100 |
| Track Name | trackname | text | Name of track [Block #21 on Form 6180.54] | MAIN SINGLE MAIN TRACK SINGLE MAIN YARD MAIN LINE view top 100 |
| Track Class | trackclass | text | FRA Track Class [Block #22 on Form 6180.54] | 1 2 4 3 5 view top 100 |
| Track Density | trackdensity | text | Annual track-density; gross tonnage in millions [Block #23 on Form 6180.54] | 000000 0000.0 0000 0 . view top 100 |
| Train Direction Code | train_direction_code | text | Direction of train code [Block #24 on Form 6180.54] | 3 4 1 2 0 view top 100 |
| Train Direction | traindirection | text | Direction of train [Block #24 on Form 6180.54] | East West North South view top 100 |
| Equipment Type Code | equipment_type_code | text | Type of equipment consist code [Block #25 on Form 6180.54] | 1 7 6 5 8 view top 100 |
| Equipment Type | equipmenttype | text | Type of equipment consist [Block #25 on Form 6180.54] | Freight Train Yard/switching Cut of cars Single Car Light loco(s) view top 100 |
| Equipment Attended | equipmentattended | text | Yes/No if equipment was attended [Block #26 on Form 6180.54] | Yes No 7 0 view top 100 |
| Train Number | trainnumber | text | Train ID number [Block #27 on Form 6180.54] | 1 2 NOTR CUTO YARD view top 100 |
| Train Speed | trainspeed | number | Speed of train in miles/hour [Block #28 on Form 6180.54] | 0 5 4 10 3 view top 100 |
| Recorded Estimated Speed | recordedestimatedspeed | text | Recorded or Estimated train speed [Block #28 on Form 6180.54] | Estimated Recorded A F T view top 100 |
| Maximum Speed | maximumspeed | number | Maximum speed reported for equipment involved | 5 4 10 3 8 view top 100 |
| Gross Tonnage | grosstonnage | number | Trailing tons, gross tonnage, excluding power units [Block #29 on Form 6180.54] | 0 2000 3000 1500 1200 view top 100 |
| Signalization Code | signalization_code | text | Type of territory signalization code [Block #30 on Form 6180.54] | 2 1 view top 100 |
| Signalization | signalization | text | Type of territory signalization code [Block #30 on Form 6180.54] | Not Signaled Signaled view top 100 |
| Method of Operation Code | method_of_operation_code | text | Method of operation/Authority for movement code [Block #30 on Form 6180.54] | N E L NM M view top 100 |
| Method of Operation | methodofoperation | text | Method of operation/Authority for movement [Block #30 on Form 6180.54] | Other Than Main Track Signal Indication Direct Train Control Yard/Restricted Limits Block Register Territory view top 100 |
| Adjunct Code 1 | adjunct_code_1 | text | Supplemental/adjacent code found in FRA Guide for Preparing Accident/Incident Reporting, Appendix J [Block #30 on Form 6180.54] | K Q L P D view top 100 |
| Adjunct Name 1 | adjunctname1 | text | Supplemental/adjacent code name found in FRA Guide for Preparing Accident/Incident Reporting, Appendix J [Block #30 on Form 6180.54] | Restricted Speed or Equivalent Traffic Control System/CTC Special Instructions Track Warrant Control Automatic Block Signals System view top 100 |
| Adjunct Code 2 | adjunct_code_2 | text | Supplemental/adjacent code found in FRA Guide for Preparing Accident/Incident Reporting, Appendix J [Block #30 on Form 6180.54] | L Q J D B view top 100 |
| Adjunct Name 2 | adjunctname2 | text | Supplemental/adjacent code name found in FRA Guide for Preparing Accident/Incident Reporting, Appendix J [Block #30 on Form 6180.54] | Special Instructions Traffic Control System/CTC Positive Train Control Automatic Block Signals System Auto Train Control view top 100 |
| Adjunct Code 3 | adjunct_code_3 | text | Supplemental/adjacent code found in FRA Guide for Preparing Accident/Incident Reporting, Appendix J [Block #30 on Form 6180.54] | Q L J D C view top 100 |
| Adjunct Name 3 | adjunctname3 | text | Supplemental/adjacent code name found in FRA Guide for Preparing Accident/Incident Reporting, Appendix J [Block #30 on Form 6180.54] | Traffic Control System/CTC Special Instructions Positive Train Control Automatic Block Signals System Auto Train Stop view top 100 |
| Remote Control Locomotive Code | remote_control_locomotive_code | text | Remote control locomotive code [Block #30a on Form 6180.54] | 0 3 1 2 N view top 100 |
| Remote Control Locomotive | remotecontrollocomotive | text | Remote control locomotive [Block #30a on Form 6180.54] | Not a remotely controlled operation Remote control portable transmitter - more than one remote control transmitter Remote control portable transmitter Remote control tower operation view top 100 |
| First Car Initials | firstcarinitials | text | Initials of first car involved in accident [Block #31a(1) on Form 6180.54] | UP BN SP BNSF GATX view top 100 |
| First Car Number | firstcarnumber | text | Number of first car involved in accident [Block #31a(1) on Form 6180.54] | 999999 000001 000002 000101 000102 view top 100 |
| First Car Position | firstcarposition | number | Position of first car involved in accident [Block #31b(1) on Form 6180.54] | 1 2 3 0 4 view top 100 |
| First Car Loaded | firstcarloaded | text | Yes/No if first car was loaded [Block #31c(1) on Form 6180.54] | Yes No E L R view top 100 |
| Causing Car Initials | causingcarinitials | text | Initials of causing car of the accident [Block #31a(2) on Form 6180.54] | UP BN SP CR LN view top 100 |
| Causing Car Number | causingcarnumber | text | Number of causing car of the accident [Block #31a(2) on Form 6180.54] | 000000 000001 000101 002008 002038 view top 100 |
| Causing Car Position | causingcarposition | number | Position of causing car of the accident [Block #31b(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Causing Car Loaded | causingcarloaded | text | Yes/No if causing car was loaded [Block #31c(2) on Form 6180.54] | Yes No L view top 100 |
| Positive Alcohol Tests | positivealcoholtests | number | Number of positive alcohol tests [Block #32 on Form 6180.54] | 0 1 2 view top 100 |
| Positive Drug Tests | positivedrugtests | number | Number of positive drug tests [Block #32 on Form 6180.54] | 0 1 2 4 3 view top 100 |
| Passengers Transported | passengerstransported | text | Yes/No if passengers were being transported [Block #33 on Form 6180.54] | No Yes view top 100 |
| Head End Locomotives | headendlocomotives | number | Number of head end locomotives [Block #34a(1) on Form 6180.54] | 2 1 0 3 4 view top 100 |
| Mid Train Manual Locomotives | midtrainmanuallocomotives | number | Number of mid train locomotives, manual [Block #34b(1) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Mid Train Remote Locomotives | midtrainremotelocomotives | number | Number of mid train locomotives, remote [Block #34c(1) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Rear End Manual Locomotives | rearendmanuallocomotives | number | Number of rear end locomotives, manual [Block #34d(1) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Rear End Remote Locomotives | rearendremotelocomotives | number | Number of rear end locomotives, remote [Block #34e(1) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Derailed Head End Locomotives | derailedheadendlocomotives | number | Number of derailed head end locomotives [Block #34a(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Derailed Mid Train Manual Locomotives | derailedmidtrainmanuallo | number | Number of derailed mid train locomotives, manual [Block #34b(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Derailed Mid Train Remote Locomotives | derailedmidtrainremotelo | number | Number of derailed mid train locomotives, remote [Block #34c(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Derailed Rear End Manual Locomotives | derailedrearendmanualloc | number | Number of derailed rear end locomotives, manual [Block #34d(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Derailed Rear End Remote Locomotives | derailedrearendremoteloc | number | Number of derailed rear end locomotives, remote [Block #34e(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Loaded Freight Cars | loadedfreightcars | number | Number of loaded freight cars [Block #35a(1) on Form 6180.54] | 0 1 2 3 10 view top 100 |
| Loaded Passenger Cars | loadedpassengercars | number | Number of loaded passenger cars [Block #35b(1) on Form 6180.54] | 0 6 4 5 7 view top 100 |
| Empty Freight Cars | emptyfreightcars | number | Number of empty freight cars [Block #35c(1) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Empty Passenger Cars | emptypassengercars | number | Number of empty passenger cars [Block #35d(1) on Form 6180.54] | 0 2 1 6 4 view top 100 |
| Cabooses | cabooses | number | Number of cabooses [Block #35e(1) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Derailed Loaded Freight Cars | derailedloadedfreightcars | number | Number of derailed loaded freight cars [Block #35a(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Derailed Loaded Passenger Cars | derailedloadedpassengercars | number | Number of derailed loaded passenger cars [Block #35b(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Derailed Empty Freight Cars | derailedemptyfreightcars | number | Number of derailed empty freight cars [Block #35c(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Derailed Empty Passenger Cars | derailedemptypassengercars | number | Number of derailed empty passenger cars [Block #35d(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Derailed Cabooses | derailedcabooses | number | Number of derailed cabooses [Block #35e(2) on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Equipment Damage Cost | equipmentdamagecost | number | Cost of damage to equipment in dollars [Block #36 on Form 6180.54] | 0 5000 10000 3000 2000 view top 100 |
| Track Damage Cost | trackdamagecost | number | Cost of damage to the track, signal, way & structure in dollars [Block #37 on Form 6180.54] | 0 500 1000 2000 5000 view top 100 |
| Total Damage Cost | totaldamagecost | number | Total cost of accident damage in dollars | 10000 5000 15000 8000 7000 view top 100 |
| Primary Accident Cause Code | primaryaccidentcausecode | text | Primary cause code of accident [Block #38 on Form 6180.54] | T110 H702 H306 T314 H503 view top 100 |
| Primary Accident Cause | primaryaccidentcause | text | Primary cause of accident [Block #38 on Form 6180.54] | Wide gage (due to defective or missing crossties) Switch improperly lined Shoving movement, absence of man on or at leading end of movement Switch point worn or broken Buffing or slack action excessive, train handling view top 100 |
| Contributing Accident Cause Code | contributingaccidentcausecode | text | Contributing cause code of accident [Block #39 on Form 6180.54] | H702 T001 H503 H302 H306 view top 100 |
| Contributing Accident Cause | contributingaccidentcause | text | Contributing cause of accident [Block #39 on Form 6180.54] | Switch improperly lined Roadbed settled or soft Buffing or slack action excessive, train handling Cars left foul Shoving movement, absence of man on or at leading end of movement view top 100 |
| Accident Cause Code | accidentcausecode | text | Accident cause code from JOINTCD=1 record applied to represent this incident (refer to Appendix C) | T110 H702 H306 T314 H503 view top 100 |
| Accident Cause | accidentcause | text | Total cause of the accident | Wide gage (due to defective or missing crossties) Switch improperly lined Shoving movement, absence of man on or at leading end of movement Switch point worn or broken Buffing or slack action excessive, train handling view top 100 |
| Engineers On Duty | engineersonduty | number | Number of engineers/operators on duty [Block #40 on Form 6180.54] | 1 0 2 3 4 view top 100 |
| Firemen On Duty | firemenonduty | number | Number of firemen on duty [Block #41 on Form 6180.54] | 0 1 2 3 6 view top 100 |
| Conductors On Duty | conductorsonduty | number | Number of conductors on duty [Block #42 on Form 6180.54] | 1 0 2 3 4 view top 100 |
| Brakemen On Duty | brakemenonduty | number | Number of brakemen on duty [Block #43 on Form 6180.54] | 2 0 1 3 4 view top 100 |
| Hours Engineers On Duty | hoursengineersonduty | number | Number of hours engineers/operators were on duty [Block #44 on Form 6180.54] | 3 2 4 5 1 view top 100 |
| Minutes Engineers On Duty | minutesengineersonduty | number | Number of minutes engineers/operators were on duty [Block #44 on Form 6180.54] | 30 0 15 45 20 view top 100 |
| Hours Conductors On Duty | hoursconductorsonduty | number | Number of hours conductors were on duty [Block #45 on Form 6180.54] | 3 4 2 5 1 view top 100 |
| Minutes Conductors On Duty | minutesconductorsonduty | number | Number of minutes conductors were on duty [Block #45 on Form 6180.54] | 30 0 15 45 20 view top 100 |
| Railroad Employees Killed | railroademployeeskilled | number | Number of railroad employees killed in the accident [Block #46 on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Railroad Employees Injured | railroademployeesinjured | number | Number of railroad employees injured in the accident [Block #46 on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Passengers Killed | passengerskilled | number | Number of passengers killed in the accident [Block #47 on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Passengers Injured | passengersinjured | number | Number of passengers injured in the accident [Block #47 on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Others Killed | otherskilled | number | Number of other people killed in the accident [Block #48 on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Others Injured | othersinjured | number | Number of other people injured in the accident [Block #48 on Form 6180.54] | 0 1 2 3 4 view top 100 |
| Reporting Railroad Fatalities for 55a | reportingrailroadfatalitiesfor55a | number | Total number of people killed in the accident, as reported on the Form 55a. The JOINTCD=1 record contains the total number and other reports contain zero. This is the official fatality count per accident, not per report. There is only one report for each accident containing the sum for all reports for one unique accident. Use this field to sum fatalities in the full Form 54 dataset. | 0 1 2 3 4 view top 100 |
| Reporting Railroad Injuries for 55a | reportingrailroadinjuriesfor55a | number | Total number of people injured in the accident, as reported on the Form 55a. The JOINTCD=1 record contains the total number and other reports contain zero. This is the official injury count per accident, not per report. There is only one report for each accident containing the sum for all reports for one unique accident. Use this field to sum injuries in the full Form 54 dataset. | 0 1 2 3 4 view top 100 |
| Total Persons Killed | totalpersonskilled | number | Total number of people killed in the accident as reported on Form 55a. This field contains the total fatalities for all reports filled for the single accident. Use this field to sum fatalities in the unique accident Form 54 dataset, where there is only one report per accident. If this field is used to sum in the full Form 54 dataset, the data will be duplicated. | 0 1 2 3 4 view top 100 |
| Total Persons Injured | totalpersonsinjured | number | Total number of people injured in the accident as reported on Form 55a. This field contains the total injuries for all reports filled for the single accident. Use this field to sum injuries in the unique accident Form 54 dataset, where there is only one report per accident. If this field is used to sum in the full Form 54 dataset, the data will be duplicated. | 0 1 2 3 4 view top 100 |
| Total Killed Form 54 | totalkilledform54 | number | Total killed as reported on Form 54. Do not use this field to sum fatalities. | 0 1 2 3 4 view top 100 |
| Total Injured Form 54 | totalinjuredform54 | number | Total injuries as reported on Form 54. Do not use this field to sum injuries. | 0 1 2 3 4 view top 100 |
| Special Study 1 | specialstudy1 | text | Type of track accident occured on, CWR or OTH [Block #49a on Form 6180.54] | OTH CWR N/A 0 R view top 100 |
| Special Study 2 | specialstudy2 | text | Additional Special Study block [Block #49b on Form 6180.54] | 000-000-000 2 000-000-00 1 0 view top 100 |
| Latitude | latitude | number | Latitude of the accident [Block #50 on Form 6180.54] | 0.0 33.548904999999998 42.565902999999999 39.759791 36.112141999999999 view top 100 |
| Longitude | longitude | number | Longitude of the accident [Block #51 on Form 6180.54] | 0.0 -73.854184000000004 -86.327526000000006 -86.67801 -86.770736999999997 view top 100 |
| Narrative | narrative | text | Written narrative of the accident [Block #52 on Form 6180.54] | NoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone BROKEN RAIL.NoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone SEE ATTACHED REPORT.NoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone BROKEN SWITCH POINT.NoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone SLACK ACTION.NoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNoneNone view top 100 |
| Joint Track Type | jointtracktype | text | Track type code from jointcd | Yard Main Industry Siding view top 100 |
| Joint Track Class | jointtrackclass | text | Track class code from jointcd | 1 2 4 3 0 view top 100 |
| Class Code | classcode | text | Railroad Class Code | 1L 1 3L CL 3S view top 100 |
| Class | class | text | Railroad Class | 1L 1 3L CL 3S view top 100 |
| Joint CD | jointcd | text | Railroad reporting | 1 3 2 view top 100 |
| Incident Key | incidentkey | text | Unique key for the incident | NS023081200508 RTD178197806 NS145000202204 CSX000133453201408 BOCTACH54197702 view top 100 |
| Report Key | reportkey | text | Unique key for the report | NS023081200508 RTD178197806 NS145000202204 CSX000133453201408 ATK061273200003 view top 100 |
| Reporting Railroad Company Grouping | reporting_railroad_company_grouping | text | Shortline Passenger (Formerly Commuter) Switching and Terminal Tourist, Excursion, Historical Shippers view top 100 | |
| Reporting Railroad Class | reporting_railroad_class | text | Class 1 Class 3 Class 2 view top 100 | |
| Reporting Railroad SMT Grouping | reporting_railroad_smt_grouping | text | SMT-6 - UP/KCS SMT-5 - BNSF SMT-9 - CSX SMT-4 - CPKC/CP/CN/CCD SMT-3 - Norfolk Southern view top 100 | |
| Reporting Parent Railroad Code | reporting_parent_railroad_code | text | UP BNSF CSX NS CRSH view top 100 | |
| Reporting Parent Railroad Name | reporting_parent_railroad_name | text | Union Pacific Railroad Company BNSF Railway Company CSX Transportation Norfolk Southern Railway Company Consolidated Rail Corporation view top 100 | |
| Reporting Railroad Holding Company | reporting_railroad_holding_company | text | Union Pacific Railroad Company Not Assigned BNSF Railway Company CSX Transportation Norfolk Southern Railway Company view top 100 | |
| Other Railroad Company Grouping | other_railroad_company_grouping | text | Passenger (Formerly Commuter) Shortline Shippers Switching and Terminal Tourist, Excursion, Historical view top 100 | |
| Other Railroad Class | other_railroad_class | text | Class 1 Class 3 Class 2 view top 100 | |
| Other Railroad SMT Grouping | other_railroad_smt_grouping | text | SMT-6 - UP/KCS SMT-1 - Amtrak, Commuter East SMT-5 - BNSF SMT-8 - Short Line West SMT-9 - CSX view top 100 | |
| Other Parent Railroad Code | other_parent_railroad_code | text | UP ATK BNSF CSX CPKC view top 100 | |
| Other Parent Railroad Name | other_parent_railroad_name | text | Union Pacific Railroad Company Amtrak (National Railroad Passenger Corporation) BNSF Railway Company CSX Transportation CANADIAN PACIFIC KANSAS CITY view top 100 | |
| Other Railroad Holding Company | other_railroad_holding_company | text | Not Assigned Union Pacific Railroad Company Amtrak BNSF Railway Company CSX Transportation view top 100 | |
| Maintenance Railroad Company Grouping | maintenance_railroad_company_grouping | text | Shortline Passenger (Formerly Commuter) Shippers Switching and Terminal Tourist, Excursion, Historical view top 100 | |
| Maintenance Railroad Class | maintenance_railroad_class | text | Class 1 Class 3 Class 2 view top 100 | |
| Maintenance Railroad SMT Grouping | maintenance_railroad_smt_grouping | text | SMT-6 - UP/KCS SMT-5 - BNSF SMT-9 - CSX SMT-8 - Short Line West SMT-4 - CPKC/CP/CN/CCD view top 100 | |
| Maintenance Parent Railroad Code | maintenance_parent_railroad_code | text | UP BNSF CSX NS CRSH view top 100 | |
| Maintenance Parent Railroad Name | maintenance_parent_railroad_name | text | Union Pacific Railroad Company BNSF Railway Company CSX Transportation Norfolk Southern Railway Company Consolidated Rail Corporation view top 100 | |
| Maintenance Railroad Holding Company | maintenance_railroad_holding_company | text | Union Pacific Railroad Company Not Assigned BNSF Railway Company CSX Transportation Norfolk Southern Railway Company view top 100 | |
| Location | location | point | {"coordinates":[0,0],"type":"Point"} {"coordinates":[-73.854184,42.565903],"type":"Point"} {"coordinates":[-86.327526,39.759791],"type":"Point"} {"coordinates":[-86.67801,33.548905],"type":"Point"} {"coordinates":[-86.770737,36.112142],"type":"Point"} view top 100 |