Fatal NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases, newest first

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"highestInjuryLevel\" = 'Fatal'
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB FTW78FA007Accident · 1 fatalClosedEsteen Skyblt · Albany, TXOct 24, 1977 · N4RH · DestroyedNTSB SEA77FA004Accident · 4 fatalClosedN.American Navion · Yakima, WAOct 23, 1977 · N91580 · DestroyedNTSB MKC78FA004Accident · 4 fatalClosedPiper PA-28 · Blair, NEOct 23, 1977 · N55184 · DestroyedNTSB MKC78FA003Accident · 1 fatalClosedAmer Avco AA-1B · St Louis, MOOct 23, 1977 · N1473R · DestroyedNTSB MKC78FA002Accident · 2 fatalClosedGrumann AA-5A · Pierce, NEOct 23, 1977 · N9762U · DestroyedNTSB FTW78FA006Accident · 2 fatalClosedPiper PA-30 · Wetumka, OKOct 23, 1977 · N7623Y · DestroyedNTSB FTW78FA005Accident · 1 fatalClosedBeech M35 · Dubach, LAOct 23, 1977 · N9840R · DestroyedNTSB LAX78FA002Accident · 2 fatalClosedBeech A23-24 · El Cajon, CAOct 22, 1977 · N4735J · DestroyedNTSB IAD78FA006Accident · 1 fatalClosedPiper J-3 · Pulaski, TNOct 22, 1977 · N98067 · DestroyedNTSB DEN78FA004Accident · 1 fatalClosedPiper PA-23 · Corona, NMOct 22, 1977 · N1906T · DestroyedNTSB DEN78FQD02Accident · 1 fatalClosedPiper PA-28R · Columbus, NMOct 20, 1977 · N32061 · Substantial damageNTSB DCA78AA001Accident · 6 fatalClosedConvair 240 · Gillsburg, MSOct 20, 1977 · N55VM · DestroyedNTSB FTW78FQG03Accident · 1 fatalClosedPiper PA-25 · Smyer, TXOct 19, 1977 · N4578Y · DestroyedNTSB CHI78FA003Accident · 1 fatalClosedBeech 200 · Valparaiso, INOct 19, 1977 · N17530 · DestroyedNTSB OAK78FA001Accident · 2 fatalClosedCessna 150J · Klamath, CAOct 16, 1977 · N60337 · DestroyedNTSB FTW78FA004Accident · 2 fatalClosedCessna 150L · Dewey, OKOct 16, 1977 · N1632Q · DestroyedNTSB IAD78FA005Accident · 3 fatalClosedBeech D35 · Livingston, KYOct 15, 1977 · N2982B · DestroyedNTSB MIA78FA006Accident · 3 fatalClosedCessna 150 · Cedar Key, FLOct 14, 1977 · N9116U · DestroyedNTSB MIA77FA005Accident · 2 fatalClosedPiper PA-28 · Brunswick, GAOct 14, 1977 · N8097N · DestroyedNTSB FTW78FPA02Accident · 2 fatalClosedPiper J3C-65 · Terrell, TXOct 11, 1977 · N42321 · DestroyedNTSB MIA78FA002Accident · 2 fatalClosedPiper PA-30 · Charleston, SCOct 10, 1977 · N7585Y · DestroyedNTSB IAD78FA003Accident · 1 fatalClosedBellanca 7GCBC · Sparta, TNOct 10, 1977 · N10988 · DestroyedNTSB FTW78FA003Accident · 2 fatalClosedBell 206B · Grand Chenier, LAOct 10, 1977 · N157AL · DestroyedNTSB IAD78FA002Accident · 4 fatalClosedCessna 182P · Wise, VAOct 9, 1977 · N7049S · DestroyedNTSB SEA78FA003Accident · 3 fatalClosedPiper PA-31P · Vancouver, WAOct 8, 1977 · N117HC · DestroyedNTSB MKC78FA001Accident · 2 fatalClosedNavion A · Caldwell, KSOct 6, 1977 · N91482 · DestroyedNTSB SEA78FA006Accident · 2 fatalClosedCessna 182J · Umpqua, OROct 5, 1977 · N3383F · DestroyedNTSB FTW78FA001Accident · 5 fatalClosedPilatus PC6CH2 · Oklahoma City, OKOct 5, 1977 · N331V · DestroyedNTSB SEA78FA002Accident · 2 fatalClosedBellanca 7GCBC · Lowman, IDOct 4, 1977 · N57429 · DestroyedNTSB DEN78FA003Accident · 2 fatalClosedMooney M20C · Sheridan, WYOct 4, 1977 · N5581Q · DestroyedNTSB DEN78FA001Accident · 2 fatalClosedBellanca 8KCAB · Vernal, UTOct 2, 1977 · N53961 · DestroyedNTSB SEA78FA001Accident · 7 fatalClosedDehavilland DHC-2 · Stevens Pass, WAOct 1, 1977 · N64391 · DestroyedNTSB SEA77FA055Accident · 2 fatalClosedPiper PA-28 · Reardan, WASep 30, 1977 · N8342W · DestroyedNTSB MIA77FA095Accident · 1 fatalClosedCessna 182P · Stone Mountain, GASep 30, 1977 · N1833M · DestroyedNTSB DEN78FA002Accident · 7 fatalClosedPiper PA-32 · Cedar Fort, UTSep 30, 1977 · N5400F · Substantial damageNTSB OAK77FA059Accident · 2 fatalClosedCessna 172N · Pahala, HISep 29, 1977 · N733FZ · DestroyedNTSB NYC77FA099Accident · 2 fatalClosedCessna 402B · Mercer, PASep 29, 1977 · N69338 · DestroyedNTSB LAX77FVA59Accident · 2 fatalClosedCessna 172M · Bakersfield, CASep 29, 1977 · N5253Q · DestroyedNTSB SEA77FA056Accident · 1 fatalClosedCessna 206 · Cove, ORSep 28, 1977 · N35904 · DestroyedNTSB FTW77FA076Accident · 1 fatalClosedRyan ST-A · Mason, TXSep 28, 1977 · N17346 · DestroyedNTSB MIA77FA093Accident · 1 fatalClosedBeech 100 · Auburn, ALSep 27, 1977 · N925BD · DestroyedNTSB DEN77FA060Accident · 2 fatalClosedBellanca 7GCBC · Tensleep, WYSep 27, 1977 · N8363V · Substantial damageNTSB MIA77FA092Accident · 1 fatalClosedCessna 152 · Delray Beach, FLSep 26, 1977 · N24497 · DestroyedNTSB OAK77FA058Accident · 2 fatalClosedRepublic RC-3 · No.Las Vegas, NVSep 25, 1977 · N6734K · DestroyedNTSB MIA77FA091Accident · 2 fatalClosedAeronca 7DC · Cleveland, MSSep 25, 1977 · N82685 · DestroyedNTSB LAX77FA075Accident · 1 fatalClosedBellanca 7AC · Yucca Valley, CASep 25, 1977 · N2119E · DestroyedNTSB IAD77FA068Accident · 2 fatalClosedCessna 210L · Smithville, TNSep 25, 1977 · N2199S · DestroyedNTSB FTW77FA077Accident · 1 fatalClosedChampion 7ECA · Nacogdoches, TXSep 25, 1977 · N3035G · DestroyedNTSB DEN77FA059Accident · 1 fatalClosedCessna 150K · Cedar Fort, UTSep 25, 1977 · N5956G · DestroyedNTSB MIA77FA090Accident · 1 fatalClosedCessna 150 · Water Valley, MSSep 24, 1977 · N6677G · Destroyed