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 MIA78FA051Accident · 2 fatalClosedCessna 172M · Griffing, GAMar 7, 1978 · N13304 · DestroyedNTSB MIA78FA050Accident · 2 fatalClosedCessna 310I · Laurel, MSMar 7, 1978 · N8114M · DestroyedNTSB ANC78FA022Accident · 1 fatalClosedPiper PA-20 · Trading Bay, AKMar 7, 1978 · N7151 · DestroyedNTSB OAK78DA021Accident · 1 fatalClosedCessna 150 · Eureka, CAMar 6, 1978 · N8991U · DestroyedNTSB MIA78FA049Accident · 1 fatalClosedPiper PA-28 · Bishopville, SCMar 5, 1978 · N8827J · DestroyedNTSB DEN78FA030Accident · 1 fatalClosedCessna 320 · Gallup, NMMar 4, 1978 · N4108T · DestroyedNTSB OAK78FA020Accident · 4 fatalClosedCessna 411 · Chilcoot, CAMar 3, 1978 · N3212R · DestroyedNTSB MIA78FA048Accident · 2 fatalClosedPiper PA-30 · Waco, GAMar 2, 1978 · N7428Y · DestroyedNTSB DEN78FA029Accident · 4 fatalClosedBeech 95-C55 · Durango, COMar 2, 1978 · N885M · DestroyedNTSB OAK78FJY01Accident · 2 fatalClosedCessna 337F · Agana, GUMar 1, 1978 · N101SX · DestroyedNTSB DCA78AA008Accident · 2 fatalClosedDouglas DC-10 · Los Angeles, CAMar 1, 1978 · N68045 · DestroyedNTSB LAX78FA031Accident · 7 fatalClosedAero Comdr 500A · Solvang, CAFeb 28, 1978 · N6143X · DestroyedNTSB IAD78FA045Accident · 1 fatalClosedPiper PA-32 · Myersville, MDFeb 27, 1978 · N40012 · DestroyedNTSB DEN78FA027Accident · 6 fatalClosedBeech A90 · Big Piney, WYFeb 27, 1978 · N878T · DestroyedNTSB ANC78FA023Accident · 3 fatalClosedEvangel 4500 · Merrill Pass, AKFeb 27, 1978 · N4508L · DestroyedNTSB LAX78FA030Accident · 4 fatalClosedPiper PA-28 · Santa Susana, CAFeb 26, 1978 · N4467J · DestroyedNTSB SEA78FYP14Accident · 1 fatalClosedCessna 185 · Naches, WAFeb 25, 1978 · C-GFYS · DestroyedNTSB FTW78FA030Accident · 1 fatalClosedCessna 150M · Denton, TXFeb 25, 1978 · N9355U · DestroyedNTSB DEN78FA028Accident · 2 fatalClosedBeech 35-B33 · Walden, COFeb 25, 1978 · N8932M · DestroyedNTSB DEN78FA026Accident · 5 fatalClosedCessna 206 · Yoder, COFeb 25, 1978 · N5205U · DestroyedNTSB SEA78FA020Accident · 7 fatalClosedPiper PA-32R · Oak Harbor, WAFeb 22, 1978 · N6992J · DestroyedNTSB MIA78FA046Accident · 1 fatalClosedMooney M20F · Ft.Lauderdale (Atlantic Ocean)Feb 22, 1978 · N9255V · DestroyedNTSB LAX78FA029Accident · 6 fatalClosedCessna T2101 · Bakersfield, CAFeb 22, 1978 · N59313 · DestroyedNTSB LAX78FA028Accident · 1 fatalClosedPiper PA-28 · Wasco, CAFeb 20, 1978 · N44138 · DestroyedNTSB IAD78FA044Accident · 2 fatalClosedSiai-Marche SF260 · Charlotte, NCFeb 20, 1978 · N7896 · DestroyedNTSB FTW78FA029Accident · 4 fatalClosedCessna 172N · Lubbock, TXFeb 20, 1978 · N737MQ · DestroyedNTSB DEN78FA025Accident · 2 fatalClosedBeech 35 · Ogden, UTFeb 20, 1978 · N338RW · DestroyedNTSB OAK78FA017Accident · 4 fatalClosedMooney M20C · Morgan Hill, CAFeb 19, 1978 · N5671Q · DestroyedNTSB DEN78FA024Accident · 6 fatalClosedAero Comdr 560A · Glenrock, WYFeb 19, 1978 · N2639B · DestroyedNTSB OAK78FVG21Accident · 1 fatalClosedBreezy Stokie · Lincoln, CAFeb 18, 1978 · N7GS · DestroyedNTSB OAK78FA018Accident · 4 fatalClosedBeech 58 · Genoa Peak, NVFeb 18, 1978 · N4307W · DestroyedNTSB MIA78FA044Accident · 1 fatalClosedBeech A45 · Moultrie, GAFeb 18, 1978 · N7747C · DestroyedNTSB MIA78DA045Accident · 4 fatalClosedPiper PA-28 · Jekyll Island, GAFeb 18, 1978 · N620FL · DestroyedNTSB IAD78FA043Accident · 2 fatalClosedPiper PA-22 · Camden, TNFeb 18, 1978 · N1693P · DestroyedNTSB FTW78FA028Accident · 2 fatalClosedPiper PA-31 · Searcy, ARFeb 18, 1978 · N6751L · DestroyedNTSB DEN78FTE30Accident · 1 fatalClosedCessna 150G · Ft Garland, COFeb 18, 1978 · N6244S · DestroyedNTSB MIA78FA043Accident · 2 fatalClosedBeech V35B · Myrtle Beach, SCFeb 17, 1978 · N17523 · DestroyedNTSB FTW78FA027Accident · 1 fatalClosedCessna 340 · Amarillo, TXFeb 16, 1978 · N39L · DestroyedNTSB CHI78FA023Accident · 1 fatalClosedTaylorcraft BC12D · Lowell, MIFeb 16, 1978 · N96797 · DestroyedNTSB MIA78FA041Accident · 1 fatalClosedCessna 150F · Jefferson, GAFeb 15, 1978 · N8318G · DestroyedNTSB IAD78FA041Accident · 4 fatalClosedAero Cmdr 680FL · Morrisville, NCFeb 13, 1978 · N26511 · DestroyedNTSB UNK78X0106Accident · 5 fatalClosedMitsubishi MU2 · Neiva, ColombiaFeb 12, 1978 · N888MA · DestroyedNTSB OAK78FVG19Accident · 1 fatalClosedCessna 150 · Vacaville, CAFeb 12, 1978 · N6539T · DestroyedNTSB NYC78FNC14Accident · 2 fatalClosedCessna 150K · Dexter, MEFeb 12, 1978 · N5802G · Substantial damageNTSB LAX78FA027Accident · 2 fatalClosedPiper PA-30 · Glen Ivy, CAFeb 12, 1978 · N7558Y · DestroyedNTSB LAX78FA026Accident · 3 fatalClosedGrum Amer AA-5A · Fontana, CAFeb 12, 1978 · N9842U · Substantial damageNTSB MIA78FA040Accident · 2 fatalClosedBeech D18S · Clewiston, FLFeb 11, 1978 · N80FA · DestroyedNTSB FTW78FA026Accident · 2 fatalClosedCessna 177RG · Wimberley, TXFeb 11, 1978 · N35862 · DestroyedNTSB OAK78FA016Accident · 1 fatalClosedBeech 35 · Napa, CAFeb 10, 1978 · N3783N · DestroyedNTSB NYC78FA027Accident · 1 fatalClosedPiper PA-32R · Danbury, CTFeb 10, 1978 · N47574 · Destroyed