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 MIA77FLA26Accident · 1 fatalClosedBensen BM-8 · Palatka, FLApr 16, 1977 · N64613 · DestroyedNTSB MIA77AA054Accident · 4 fatalClosedBellanca 14-13 · Thomaston, GAApr 16, 1977 · N74483 · DestroyedNTSB LAX77FA038Accident · 4 fatalClosedGrum Amer AA5-A · Flagstaff, AZApr 16, 1977 · N9894U · DestroyedNTSB NYC77FA052Accident · 1 fatalClosedPiper PA-28 · Nashua, NHApr 15, 1977 · N75042 · Substantial damageNTSB OAK77DJA09Accident · 5 fatalClosedCessna 310 · Honolulu, HIApr 13, 1977 · N8179M · DestroyedNTSB NYC77FA038Accident · 1 fatalClosedPiper PA-23 · Weathersfield, CTApr 13, 1977 · N4483P · DestroyedNTSB IAD77FA034Accident · 3 fatalClosedPiper PA-28 · Glasgow, KYApr 13, 1977 · N7165W · DestroyedNTSB DEN77FA036Accident · 2 fatalClosedCessna TU206F · Duchesne, UTApr 12, 1977 · N1066V · DestroyedNTSB MIA77FA052Accident · 4 fatalClosedBeech A36 · Miami, FLApr 11, 1977 · N2135L · DestroyedNTSB CHI77FEM22Accident · 1 fatalClosedAmer Avco AA1 · East Tawas, MIApr 11, 1977 · N5706L · DestroyedNTSB SEA77FA027Accident · 3 fatalClosedCessna 182P · Port Orchard, WAApr 10, 1977 · N1282S · DestroyedNTSB SEA77FA026Accident · 2 fatalClosedCessna 180 · Newdale, IDApr 10, 1977 · N2974A · DestroyedNTSB LAX77FA039Accident · 1 fatalClosedHiller UH-12E · Thermal, CAApr 10, 1977 · N90465 · DestroyedNTSB CHI77FA039Accident · 3 fatalClosedNa Rockwell 112 · Hudson, WIApr 10, 1977 · N1404J · DestroyedNTSB NYC77FA049Accident · 4 fatalClosedCessna 195 · Reading, PAApr 9, 1977 · N4377N · 2 aircraft · DestroyedNTSB IAD77FID16Accident · 1 fatalClosedSchweizer 1-26B · Windsor, VAApr 9, 1977 · N680U · Substantial damageNTSB DEN77FA034Accident · 3 fatalClosedCessna 150 · Boulder, COApr 9, 1977 · N50513 · 2 aircraft · DestroyedNTSB CHI77FEM21Accident · 1 fatalClosedCessna 150J · Albion, MIApr 9, 1977 · N50883 · DestroyedNTSB DEN77FA035Accident · 2 fatalClosedCessna 182H · Tooele, UTApr 8, 1977 · N8390S · DestroyedNTSB ANC77FA038Accident · 2 fatalClosedBellanca 8GCBC · Fairbanks, AKApr 8, 1977 · N8749V · Substantial damageNTSB NYC77FA048Accident · 1 fatalClosedBellanca 17-30A · Jamestown, NYApr 7, 1977 · N14752 · DestroyedNTSB MIA77FKQ07Accident · 1 fatalClosedBellanca 8GCBC · Edwards, MSApr 7, 1977 · N86981 · DestroyedNTSB FTW77FPD19Accident · 1 fatalClosedCessna A188B · De Leon, TXApr 7, 1977 · N9154G · DestroyedNTSB DEN77FA033Accident · 2 fatalClosedAeronca 7AC · Laramie, WYApr 7, 1977 · N83541 · DestroyedNTSB OAK77FA028Accident · 1 fatalClosedPiper PA28 · Auberry, CAApr 5, 1977 · N15638 · DestroyedNTSB NYC77FA046Accident · 7 fatalClosedMitsubishi MU-2 · Bronx, NYApr 5, 1977 · N888RJ · DestroyedNTSB LAX77FVJ43Accident · 1 fatalClosedStits SA-3A · Bisbee, AZApr 5, 1977 · N8157 · DestroyedNTSB SEA77FYM25Accident · 1 fatalClosedMooney M20E · Toledo, ORApr 4, 1977 · N2659W · DestroyedNTSB SEA77FA025Accident · 2 fatalClosedPiper PA-28 · Sekiu, WAApr 4, 1977 · N32948 · DestroyedNTSB DCA77AA015Accident · 62 fatalClosedDouglas DC-9 · New Hope, GAApr 4, 1977 · N1335U · DestroyedNTSB MIA77FA050Accident · 2 fatalClosedBeech C24R · Monroe, GAApr 3, 1977 · N23969 · DestroyedNTSB LAX77FA034Accident · 2 fatalClosedPiper PA-28 · Saugus, CAApr 3, 1977 · N1269T · DestroyedNTSB IAD77FKM13Accident · 1 fatalClosedCessna 150 · Eden, NCApr 3, 1977 · N18011 · Substantial damageNTSB FTW77FPD17Accident · 3 fatalClosedPiper PA-24 · Wichita Falls, TXApr 3, 1977 · N8124P · DestroyedNTSB DEN77FA032Accident · 4 fatalClosedAvions Mrcl DA-10 · Denver, COApr 3, 1977 · N60MB · DestroyedNTSB CHI77FA038Accident · 2 fatalClosedBrantly B-2 · Tremont, ILApr 2, 1977 · N2131U · DestroyedNTSB LAX77FA033Accident · 7 fatalClosedCessna 411A · Spring Valley, CAApr 1, 1977 · N9100V · DestroyedNTSB FTW77FA048Accident · 6 fatalClosedPiper PA-32R · Commerce, TXApr 1, 1977 · N6127J · DestroyedNTSB CHI77FEI16Accident · 1 fatalClosedSchweizer SGS233 · Liverpool, OHApr 1, 1977 · N2613H · DestroyedNTSB SEA77FA024Accident · 2 fatalClosedBell 214B-1 · Liberty, WAMar 31, 1977 · N90128 · DestroyedNTSB SEA77FA023Accident · 2 fatalClosedBeech B19 · Ephrata, WAMar 30, 1977 · N24012 · DestroyedNTSB MIA77FA048Accident · 1 fatalClosedCessna 207 · Atlanta, GAMar 30, 1977 · N91073 · DestroyedNTSB CHI77FEG14Accident · 1 fatalClosedKen Rand KR-2 · Xenia, OHMar 29, 1977 · N59JJ · DestroyedNTSB LAX77FA036Accident · 1 fatalClosedBeech E55 · Phoenix, AZMar 28, 1977 · N4068S · DestroyedNTSB DCA77RA014Accident · 574 fatalClosedBoeing 747 · Tenerife, SPMar 27, 1977 · N736PA · 2 aircraft · DestroyedNTSB CHI77FA037Accident · 2 fatalClosedCessna 172M · Iron River, MIMar 27, 1977 · N1136U · DestroyedNTSB IAD77FA032Accident · 4 fatalClosedPiper PA-28 · Powell, TNMar 26, 1977 · N8690W · DestroyedNTSB FTW77FA047Accident · 3 fatalClosedPiper PA-23 · Mcalester, OKMar 26, 1977 · N3361P · DestroyedNTSB LAX77FUQ22Accident · 1 fatalClosedCessna 172M · Inyokern, CAMar 25, 1977 · N20441 · Substantial damageNTSB LAX77FA031Accident · 4 fatalClosedCessna 172 · Payson, AZMar 25, 1977 · N4181F · Destroyed