Data Doughnut
Data catalog › Community health & safety

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_hashrow_idreportkeyincidentkeyyearaccident_datestatestate_fipscounty_fipscounty_namerailroad_codeaccident_typehazmat_released_carspersons_evacuatedtotal_killedtotal_injuredtotal_damage_costlatitudelongitudesnapshot_date
000045ec306d19ce2ce8b15c07caf6aa00b7ba25row-qb5q.xrie-duk6BNSF113198202BNSF11319820219821982-02-20KS2020205WILSONBNSide collision000013500No dataNo data2026-10-10
000055a2bee244cd52bb724942561f29c6211691row-c9wp.d89j-5uepBNCO291197807BNCO29119780719781978-07-04NE3131087HITCHCOCKBNDerailment000019230No dataNo data2026-10-10
0000685270e5f602c7100f7e2fddca2efd2e67e2row-h7wn-by6p.r4usLN047706083197704LN04770608319770419771977-04-28KY2121107HOPKINSLNDerailment00003864No dataNo data2026-10-10
00007afc86acb5a71db8f8b7721cde79b41310a2row-arfh.v6qe.e9ycUP1022NC012202210UP1022NC01220221020222022-10-10NV3232031WASHOEUPObstruction00002800039.548622-119.5733642026-10-10
000080cac11a37762715ef4605f0248aa7136bdarow-4uki.aq9v.xt7nCR0520010197901CR052001019790119791979-01-27PA4242033CLEARFIELDCRDerailment00005900No dataNo data2026-10-10
00009a01ae491c1d9fc3191f40daf3d4dbb68fb8row-hqnk_2s3w.eemjNS101094201208NS10109420120820122012-08-21IN1818053GRANTNSDerailment00004900040.548580-85.6563322026-10-10
000131993b50b72861b4d0453574acac6cf428e9row-77xt.cmh4-mm3vDME2005085200505DME200508520050520052005-05-22SD4646011BROOKINGSDMEDerailment0000650560.0000000.0000002026-10-10
000152451203350cd12206813b09f074b1815453row-wew3-f2fm-j8f2BNSFKS1115102201511BNSFKS111510220151120152015-11-09OK4040151WOODSBNSFDerailment00003280036.603600-98.8743632026-10-10
000211e8c21df4f14c6436131ca48970b9014e19row-gn5q-t5v3.gk2tUP0422GC002202204UP0422GC00220220420222022-04-02LA2222077POINTE COUPEEUPOther impacts00001631730.517556-91.5452002026-10-10
00022bf080e7adb28f695764f49e76191968ae8erow-5hnt-ym9k.cjb2CSX038822013198803CSX03882201319880319881988-03-14WV5454041LEWISCSXDerailment000025250No dataNo data2026-10-10
00024ecb8c68c8bb0a523ff02ddff82b44f78192row-a5qy~edbj_bptqUP1107CB018200711UP1107CB01820071120072007-11-01IA1919113LINNUPOther impacts000083970.0000000.0000002026-10-10
000258c5003ed4eedecc604da0fdecfdf0572f35row-sr9y.ekmn~kftvUP1088PD207198810UP1088PD20719881019881988-10-16OR4141051MULTNOMAHUPOther impacts00006300No dataNo data2026-10-10
000260e57cd42988a995a15bcb2cd0e94fb4d422row-5m62_gwsd_n6srUP1022GL013202210UP1022GL01320221020222022-10-14IA1919153POLKUPDerailment00008259041.589552-93.5703422026-10-10
0002e289601cd8cfa14901fb42f8c21457ef77bcrow-udxh.tkcc-jsukICG17272197609ICG1727219760919761976-09-03LA2222015BOSSIERICGDerailment00009775No dataNo data2026-10-10
00033ce9ae30a4a9f459553e51beb9944b1e8708row-ewim_gnuq.igdpSLSFT4A68197610SLSFT4A6819761019761976-10-19OK4040109OKLAHOMASLSFDerailment00004000No dataNo data2026-10-10
0003d1e580447d8b7cd2fe2bfa55766a2277ef37row-xwd7~ksz3.53wbUP1004TS025200410UP1004TS02520041020042004-10-16AZ0404019PIMAUPDerailment000067710.0000000.0000002026-10-10
000472b8793aa217543f53d5bc5cda184c3cca27row-u22u_utx6.pkviSPX3302198206SPX330219820619821982-06-30TX4848157FORT BENDSPHead on collision000043000No dataNo data2026-10-10
0004862cb13b1ef799ef6d788c4c735fa8368b3arow-5vmt.upaw-b4agUP0612FW013201206UP0612FW01320120620122012-06-15TX4848329MIDLANDUPHwy-rail crossing000010826832.031509-102.0040232026-10-10
0004aa449c0c095d3a220af80a407b2301091603row-fcag-z4zd-67azUP0899SA043199908UP0899SA04319990819991999-08-20TX4848123DE WITTUPDerailment0000199071No dataNo data2026-10-10
0004ebb317ab987fe48b53d7ca3abfdd3e46ce0brow-4vyx_da9p-brg5ICSEP00798199809ICSEP0079819980919981998-09-03TN4747157SHELBYICOther impacts000040000No dataNo data2026-10-10
00050b6380c7422f8a101ee8fa9222484b87469brow-cyaa.5kit-9y2iICG17035197603ICG1703519760319761976-03-18KY2121107HOPKINSICGDerailment000014750No dataNo data2026-10-10
000519eba230e662bc0541bebaef7064a5916626row-xxru.q9ez.umhnWCG2061199301SOO9301G005219930119931993-01-19IL1717031COOKWCDerailment000025504No dataNo data2026-10-10
00052920f778ebdcfcf7a7343ae466817b93d3a4row-zanx.yr7r_zhhrCNW010492199201CNW01049219920119921992-01-08IL1717031COOKCNWHead on collision00007400No dataNo data2026-10-10
000573dce1aff66230d0423f57849befcdbf2e34row-69af-2v9c_kdnhUP1179NP015197911UP1179NP01519791119791979-11-01NE3131111LINCOLNUPRear end collision000217000No dataNo data2026-10-10
0005b634b378a12d57b3db8558bb8d6ad7dbff80row-aenv.n2r2~twwdBNMN350198305BNMN35019830519831983-05-18SD4646099MINNEHAHABNDerailment00007250No dataNo data2026-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