Federal Railroad Administration
Rail crossings & accidents
Every railroad crossing, crashes at crossings, and train accidents by county and year.
Published by Federal Railroad Administration
Finest detail facility
Tables 2
Train accidents
Sample of 25 rows out of about 150,854
· 20 columns
| row_hash | row_id | reportkey | incidentkey | year | accident_date | state | state_fips | county_fips | county_name | railroad_code | accident_type | hazmat_released_cars | persons_evacuated | total_killed | total_injured | total_damage_cost | latitude | longitude | snapshot_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 000045ec306d19ce2ce8b15c07caf6aa00b7ba25 | row-qb5q.xrie-duk6 | BNSF113198202 | BNSF113198202 | 1982 | 1982-02-20 | KS | 20 | 20205 | WILSON | BN | Side collision | 0 | 0 | 0 | 0 | 13500 | No data | No data | 2026-10-10 |
| 000055a2bee244cd52bb724942561f29c6211691 | row-c9wp.d89j-5uep | BNCO291197807 | BNCO291197807 | 1978 | 1978-07-04 | NE | 31 | 31087 | HITCHCOCK | BN | Derailment | 0 | 0 | 0 | 0 | 19230 | No data | No data | 2026-10-10 |
| 0000685270e5f602c7100f7e2fddca2efd2e67e2 | row-h7wn-by6p.r4us | LN047706083197704 | LN047706083197704 | 1977 | 1977-04-28 | KY | 21 | 21107 | HOPKINS | LN | Derailment | 0 | 0 | 0 | 0 | 3864 | No data | No data | 2026-10-10 |
| 00007afc86acb5a71db8f8b7721cde79b41310a2 | row-arfh.v6qe.e9yc | UP1022NC012202210 | UP1022NC012202210 | 2022 | 2022-10-10 | NV | 32 | 32031 | WASHOE | UP | Obstruction | 0 | 0 | 0 | 0 | 28000 | 39.548622 | -119.573364 | 2026-10-10 |
| 000080cac11a37762715ef4605f0248aa7136bda | row-4uki.aq9v.xt7n | CR0520010197901 | CR0520010197901 | 1979 | 1979-01-27 | PA | 42 | 42033 | CLEARFIELD | CR | Derailment | 0 | 0 | 0 | 0 | 5900 | No data | No data | 2026-10-10 |
| 00009a01ae491c1d9fc3191f40daf3d4dbb68fb8 | row-hqnk_2s3w.eemj | NS101094201208 | NS101094201208 | 2012 | 2012-08-21 | IN | 18 | 18053 | GRANT | NS | Derailment | 0 | 0 | 0 | 0 | 49000 | 40.548580 | -85.656332 | 2026-10-10 |
| 000131993b50b72861b4d0453574acac6cf428e9 | row-77xt.cmh4-mm3v | DME2005085200505 | DME2005085200505 | 2005 | 2005-05-22 | SD | 46 | 46011 | BROOKINGS | DME | Derailment | 0 | 0 | 0 | 0 | 65056 | 0.000000 | 0.000000 | 2026-10-10 |
| 000152451203350cd12206813b09f074b1815453 | row-wew3-f2fm-j8f2 | BNSFKS1115102201511 | BNSFKS1115102201511 | 2015 | 2015-11-09 | OK | 40 | 40151 | WOODS | BNSF | Derailment | 0 | 0 | 0 | 0 | 32800 | 36.603600 | -98.874363 | 2026-10-10 |
| 000211e8c21df4f14c6436131ca48970b9014e19 | row-gn5q-t5v3.gk2t | UP0422GC002202204 | UP0422GC002202204 | 2022 | 2022-04-02 | LA | 22 | 22077 | POINTE COUPEE | UP | Other impacts | 0 | 0 | 0 | 0 | 16317 | 30.517556 | -91.545200 | 2026-10-10 |
| 00022bf080e7adb28f695764f49e76191968ae8e | row-5hnt-ym9k.cjb2 | CSX038822013198803 | CSX038822013198803 | 1988 | 1988-03-14 | WV | 54 | 54041 | LEWIS | CSX | Derailment | 0 | 0 | 0 | 0 | 25250 | No data | No data | 2026-10-10 |
| 00024ecb8c68c8bb0a523ff02ddff82b44f78192 | row-a5qy~edbj_bptq | UP1107CB018200711 | UP1107CB018200711 | 2007 | 2007-11-01 | IA | 19 | 19113 | LINN | UP | Other impacts | 0 | 0 | 0 | 0 | 8397 | 0.000000 | 0.000000 | 2026-10-10 |
| 000258c5003ed4eedecc604da0fdecfdf0572f35 | row-sr9y.ekmn~kftv | UP1088PD207198810 | UP1088PD207198810 | 1988 | 1988-10-16 | OR | 41 | 41051 | MULTNOMAH | UP | Other impacts | 0 | 0 | 0 | 0 | 6300 | No data | No data | 2026-10-10 |
| 000260e57cd42988a995a15bcb2cd0e94fb4d422 | row-5m62_gwsd_n6sr | UP1022GL013202210 | UP1022GL013202210 | 2022 | 2022-10-14 | IA | 19 | 19153 | POLK | UP | Derailment | 0 | 0 | 0 | 0 | 82590 | 41.589552 | -93.570342 | 2026-10-10 |
| 0002e289601cd8cfa14901fb42f8c21457ef77bc | row-udxh.tkcc-jsuk | ICG17272197609 | ICG17272197609 | 1976 | 1976-09-03 | LA | 22 | 22015 | BOSSIER | ICG | Derailment | 0 | 0 | 0 | 0 | 9775 | No data | No data | 2026-10-10 |
| 00033ce9ae30a4a9f459553e51beb9944b1e8708 | row-ewim_gnuq.igdp | SLSFT4A68197610 | SLSFT4A68197610 | 1976 | 1976-10-19 | OK | 40 | 40109 | OKLAHOMA | SLSF | Derailment | 0 | 0 | 0 | 0 | 4000 | No data | No data | 2026-10-10 |
| 0003d1e580447d8b7cd2fe2bfa55766a2277ef37 | row-xwd7~ksz3.53wb | UP1004TS025200410 | UP1004TS025200410 | 2004 | 2004-10-16 | AZ | 04 | 04019 | PIMA | UP | Derailment | 0 | 0 | 0 | 0 | 6771 | 0.000000 | 0.000000 | 2026-10-10 |
| 000472b8793aa217543f53d5bc5cda184c3cca27 | row-u22u_utx6.pkvi | SPX3302198206 | SPX3302198206 | 1982 | 1982-06-30 | TX | 48 | 48157 | FORT BEND | SP | Head on collision | 0 | 0 | 0 | 0 | 43000 | No data | No data | 2026-10-10 |
| 0004862cb13b1ef799ef6d788c4c735fa8368b3a | row-5vmt.upaw-b4ag | UP0612FW013201206 | UP0612FW013201206 | 2012 | 2012-06-15 | TX | 48 | 48329 | MIDLAND | UP | Hwy-rail crossing | 0 | 0 | 0 | 0 | 108268 | 32.031509 | -102.004023 | 2026-10-10 |
| 0004aa449c0c095d3a220af80a407b2301091603 | row-fcag-z4zd-67az | UP0899SA043199908 | UP0899SA043199908 | 1999 | 1999-08-20 | TX | 48 | 48123 | DE WITT | UP | Derailment | 0 | 0 | 0 | 0 | 199071 | No data | No data | 2026-10-10 |
| 0004ebb317ab987fe48b53d7ca3abfdd3e46ce0b | row-4vyx_da9p-brg5 | ICSEP00798199809 | ICSEP00798199809 | 1998 | 1998-09-03 | TN | 47 | 47157 | SHELBY | IC | Other impacts | 0 | 0 | 0 | 0 | 40000 | No data | No data | 2026-10-10 |
| 00050b6380c7422f8a101ee8fa9222484b87469b | row-cyaa.5kit-9y2i | ICG17035197603 | ICG17035197603 | 1976 | 1976-03-18 | KY | 21 | 21107 | HOPKINS | ICG | Derailment | 0 | 0 | 0 | 0 | 14750 | No data | No data | 2026-10-10 |
| 000519eba230e662bc0541bebaef7064a5916626 | row-xxru.q9ez.umhn | WCG2061199301 | SOO9301G0052199301 | 1993 | 1993-01-19 | IL | 17 | 17031 | COOK | WC | Derailment | 0 | 0 | 0 | 0 | 25504 | No data | No data | 2026-10-10 |
| 00052920f778ebdcfcf7a7343ae466817b93d3a4 | row-zanx.yr7r_zhhr | CNW010492199201 | CNW010492199201 | 1992 | 1992-01-08 | IL | 17 | 17031 | COOK | CNW | Head on collision | 0 | 0 | 0 | 0 | 7400 | No data | No data | 2026-10-10 |
| 000573dce1aff66230d0423f57849befcdbf2e34 | row-69af-2v9c_kdnh | UP1179NP015197911 | UP1179NP015197911 | 1979 | 1979-11-01 | NE | 31 | 31111 | LINCOLN | UP | Rear end collision | 0 | 0 | 0 | 2 | 17000 | No data | No data | 2026-10-10 |
| 0005b634b378a12d57b3db8558bb8d6ad7dbff80 | row-aenv.n2r2~twwd | BNMN350198305 | BNMN350198305 | 1983 | 1983-05-18 | SD | 46 | 46099 | MINNEHAHA | BN | Derailment | 0 | 0 | 0 | 0 | 7250 | No data | No data | 2026-10-10 |
🔒 Some columns are hidden in this preview for privacy.
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing