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 CHI77FA050Accident · 1 fatalClosedCessna 150H · Benton, ILJun 13, 1977 · N7087S · DestroyedNTSB ANC77FA052Accident · 4 fatalClosedLake LA-4 · Matanuska Glcr, AKJun 13, 1977 · N1223L · DestroyedNTSB OAK77FA036Accident · 1 fatalClosedN.American SNJ-5 · Petaluma, CAJun 11, 1977 · N9823C · Substantial damageNTSB FTW77FPG59Accident · 1 fatalClosedBensen B8M · Berryville, ARJun 11, 1977 · N3121 · DestroyedNTSB CHI77FEV27Accident · 1 fatalClosedTolman SA-3AM · Salem, ILJun 11, 1977 · N1054 · DestroyedNTSB CHI77FA049Accident · 4 fatalClosedPiper PA-24 · Grafton, WIJun 11, 1977 · N6349P · DestroyedNTSB SEA77FYM41Accident · 1 fatalClosedPitts S1 · Forrest Grove, ORJun 10, 1977 · N8444 · DestroyedNTSB FTW77FPD26Accident · 1 fatalClosedStarduster TOO · Alvord, TXJun 9, 1977 · N13GH · DestroyedNTSB SEA77FA040Accident · 2 fatalClosedCessna 172 · Azalea, ORJun 8, 1977 · N73382 · DestroyedNTSB SEA77FA039Accident · 4 fatalClosedPiper PA-28 · Spokane, WAJun 7, 1977 · N2161T · DestroyedNTSB NYC77FA063Accident · 1 fatalClosedBellanca 8KCAB · Haverhill, MAJun 7, 1977 · N86770 · Substantial damageNTSB MKC77FA024Accident · 4 fatalClosedCessna 172M · Gordon, NEJun 7, 1977 · N80078 · DestroyedNTSB LAX77FA050Accident · 2 fatalClosedCessna 177RG · Riverside, CAJun 7, 1977 · N1599H · DestroyedNTSB LAX77FA049Accident · 5 fatalClosedAero Comdr 680 · Upland, CAJun 7, 1977 · N6853S · DestroyedNTSB IAD77FA044Accident · 3 fatalClosedBellanca 14-19 · Robinson Creek, KYJun 6, 1977 · N1293R · DestroyedNTSB FTW77FA059Accident · 2 fatalClosedAmerican AA-1A · Marion, TXJun 5, 1977 · N6415L · DestroyedNTSB SEA77FA038Accident · 3 fatalClosedPiper PA-28 · Lavina, MTJun 4, 1977 · N1176H · DestroyedNTSB OAK77FA035Accident · 2 fatalClosedBeech A33 · Coalinga, CAJun 4, 1977 · N924T · DestroyedNTSB NYC77FHD15Accident · 1 fatalClosedFly-Baby 1A · Oxford, PAJun 4, 1977 · N5550 · DestroyedNTSB MIA77FLA36Accident · 1 fatalClosedBensen B-8-MG · St Augustine, FLJun 4, 1977 · N3120 · Substantial damageNTSB FTW77FPG42Accident · 1 fatalClosedGrumman G-164A · Dumas, ARJun 4, 1977 · N7363 · DestroyedNTSB CHI77FA048Accident · 1 fatalClosedBeech E18S · Springfield, OHJun 3, 1977 · N68A · Substantial damageNTSB OAK77FA034Accident · 3 fatalClosedCessna 150L · San Ramon, CAJun 2, 1977 · N5456Q · 2 aircraft · DestroyedNTSB MIA77FA060Accident · 1 fatalClosedGrum Amer AA-1A · Atlanta, GAJun 2, 1977 · N9373L · Substantial damageNTSB SEA77FA037Accident · 4 fatalClosedCessna T210G · Elgin, ORJun 1, 1977 · N6888R · DestroyedNTSB IAD77FA043Accident · 1 fatalClosedCessna 172 · Cavetown, MDMay 31, 1977 · N20480 · DestroyedNTSB FTW77FA058Accident · 3 fatalClosedCessna 185 · Houma, LAMay 31, 1977 · N3345L · DestroyedNTSB SEA77FA036Accident · 2 fatalClosedPiper PA-22 · Horseshoe Bend, IDMay 30, 1977 · N8993C · DestroyedNTSB SEA77FA035Accident · 2 fatalClosedTaylorcraft L-2B · Yelm, WAMay 30, 1977 · N50290 · DestroyedNTSB LAX77FA046Accident · 2 fatalClosedPiper PA-28R · Yucca Valley, CAMay 30, 1977 · N8699E · DestroyedNTSB DEN78FA017Accident · 1 fatalClosedHughes 269C · Colorado Sprgs, COMay 30, 1977 · N7457F · DestroyedNTSB CHI77FEG19Accident · 2 fatalClosedBellanca 7KCAB · Goshen, OHMay 29, 1977 · N2FN · DestroyedNTSB SEA77DYM33Accident · 1 fatalClosedPiper PA-22S · Madras, ORMay 28, 1977 · N2563P · No damageNTSB MKC77FCA21Accident · 1 fatalClosedPiper PA-25 · Poplar Bluff, MOMay 28, 1977 · N4995Y · DestroyedNTSB FTW77FQD19Accident · 1 fatalClosedBellanca 7KCAB · El Paso, TXMay 28, 1977 · N4103Y · DestroyedNTSB FTW77FA057Accident · 2 fatalClosedBeech S35 · Lamar, ARMay 28, 1977 · N5775K · DestroyedNTSB DEN77FA044Accident · 2 fatalClosedBeech 19A · Wheatland, WYMay 28, 1977 · N6952Q · DestroyedNTSB CHI77FA046Accident · 4 fatalClosedPiper PA-24 · Evansville, WIMay 27, 1977 · N9326P · DestroyedNTSB NYC77FA062Accident · 3 fatalClosedCessna 182F · Oxbow, MEMay 26, 1977 · N3148U · Substantial damageNTSB NYC77FA061Accident · 1 fatalClosedPiper PA-16 · Collins, NYMay 26, 1977 · N6862K · 2 aircraft · DestroyedNTSB IAD77FA041Accident · 1 fatalClosedPiper PA-34 · Bridgeport, WVMay 26, 1977 · N1153H · DestroyedNTSB OAKMMFJA12Accident · 1 fatalClosedRockwell 112B · Honolulu, HIMay 24, 1977 · N1285J · DestroyedNTSB FTW77FPM10Accident · 1 fatalClosedPiper J-3 · Jay, OKMay 24, 1977 · N6355H · DestroyedNTSB UNK77X0105Accident · 1 fatalClosedBellanca 17-30A · Brightwood, ORMay 23, 1977 · N8866V · DestroyedNTSB LAX77FA047Accident · 2 fatalClosedGrum Amer AA5-B · San Luis Obspo, CAMay 23, 1977 · N81003 · DestroyedNTSB NYC77FA060Accident · 4 fatalClosedPiper PA-28 · Keeseville, NYMay 22, 1977 · N5110L · DestroyedNTSB NYC77FA059Accident · 1 fatalClosedCessna 172K · Flushing, NYMay 22, 1977 · N217NY · DestroyedNTSB DEN77FA042Accident · 1 fatalClosedAero Tek IV · Moriarty, NMMay 22, 1977 · N101AT · DestroyedNTSB CHI77FA044Accident · 1 fatalClosedCessna 172 · East Dundee, ILMay 22, 1977 · N8031B · DestroyedNTSB LAX77FUJ48Accident · 2 fatalClosedTailwind W-8A · Mayer, AZMay 21, 1977 · N19EW · Destroyed