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 ANC77FA066Accident · 5 fatalClosedCessna 170-A · Portage Pass, AKJul 30, 1977 · N9543A · DestroyedNTSB SEA77FA045Accident · 1 fatalClosedCessna 182Q · Elk City, IDJul 29, 1977 · N182DM · DestroyedNTSB NYC77FHA30Accident · 1 fatalClosedTaylorcraft BC12D · Sciota, PAJul 29, 1977 · N43805 · DestroyedNTSB MIA77FA072Accident · 3 fatalClosedPiper PA-32 · Clanton, ALJul 29, 1977 · N8663N · DestroyedNTSB IAD77FA054Accident · 3 fatalClosedBeech 95 · Fletcher, NCJul 29, 1977 · N771B · DestroyedNTSB ANC77FA064Accident · 1 fatalClosedCessna 150 · Anchorage, AKJul 29, 1977 · N66552 · DestroyedNTSB ANC77FA063Accident · 1 fatalClosedHiller 12EJ3 · Ketchikan, AKJul 28, 1977 · N5358V · DestroyedNTSB SEA77FTI16Accident · 2 fatalClosedCessna 150M · Helena, MTJul 27, 1977 · N45126 · Substantial damageNTSB MIA77FA071Accident · 5 fatalClosedCessna 172L · Vienna, GAJul 27, 1977 · N19691 · DestroyedNTSB IAD78FA010Accident · 1 fatalClosedStinson 108-3 · Knoxville, TNJul 27, 1977 · N6734M · DestroyedNTSB MIA77FKQ24Accident · 1 fatalClosedPiper PA-18 · Louisville, MSJul 26, 1977 · N1358C · DestroyedNTSB SEA77FA043Accident · 5 fatalClosedPiper PA-32R · Bernard Creek, IDJul 25, 1977 · N9228K · DestroyedNTSB DEN77FA050Accident · 1 fatalClosedCessna 152 · Garfield, COJul 25, 1977 · N1907C · DestroyedNTSB SEA77FA042Accident · 1 fatalClosedKr-2 · Arlington, WAJul 24, 1977 · N43TS · DestroyedNTSB OAK77FA044Accident · 2 fatalClosedPiper PA-32R · Tahoe Paradise, CAJul 24, 1977 · N1263H · DestroyedNTSB MKC77FA031Accident · 3 fatalClosedBeech C35 C35 · Omaha, NEJul 24, 1977 · N1857D · DestroyedNTSB FTW77FPA21Accident · 1 fatalClosedWolf-Hirth HI-27 · Sherman, TXJul 24, 1977 · N13LS · DestroyedNTSB FTW77FA064Accident · 1 fatalClosedMooney M20 · Shelbyville, TXJul 24, 1977 · N5243B · DestroyedNTSB MIA77FLT04Accident · 2 fatalClosedGrumman G-164A · Tunica, MSJul 23, 1977 · N6543 · 2 aircraft · DestroyedNTSB DEN77FA049Accident · 4 fatalClosedBeech D35 · Bakersville, COJul 23, 1977 · N444Y · DestroyedNTSB OAK77FA043Accident · 4 fatalClosedPiper PA-28 · Jackpot, NVJul 22, 1977 · N5438F · DestroyedNTSB CHI77FA060Accident · 1 fatalClosedPiper PA-23 · Plano, ILJul 21, 1977 · N5900Y · DestroyedNTSB ANC77FA062Accident · 1 fatalClosedBrittnorman BN-2H · Ruby, AKJul 21, 1977 · N22JA · Substantial damageNTSB OAK77FA042Accident · 2 fatalClosedBeech 95-B55 · Eureka, CAJul 20, 1977 · N125WE · DestroyedNTSB NYC77FA072Accident · 1 fatalClosedPiper PA-31 · Cheektowaga, NYJul 20, 1977 · N406CA · DestroyedNTSB SEA77FYE29Accident · 1 fatalClosedTaylor B8M · Shelton, WAJul 19, 1977 · N65360 · DestroyedNTSB OAK77FA041Accident · 1 fatalClosedPiper PA-28 · Truckee, CAJul 18, 1977 · N44119 · DestroyedNTSB DEN77FTC19Accident · 2 fatalClosedDouglas DC-3A · Sheridan, WYJul 18, 1977 · N459 · DestroyedNTSB DEN77FA048Accident · 2 fatalClosedBellanca 8GCBC · San Mateo, NMJul 18, 1977 · N18854 · DestroyedNTSB CHI77FEE32Accident · 2 fatalClosedPiper PA-28 · Wadsworth, ILJul 18, 1977 · N6899J · DestroyedNTSB ANC77FA060Accident · 2 fatalClosedPiper PA-14 · Wasilla, AKJul 17, 1977 · N5115H · DestroyedNTSB MIA77FA069Accident · 2 fatalClosedPiper PA-32 · Andros Is, Burkina FasoJul 16, 1977 · N4434F · DestroyedNTSB MIA77FA068Accident · 6 fatalClosedAero Cmdr 680 · Ft Lauderdale, FLJul 16, 1977 · N6892S · DestroyedNTSB MKC77FA030Accident · 4 fatalClosedPiper PA-22 · Bunker, MOJul 15, 1977 · N2928P · DestroyedNTSB MIA77FA067Accident · 2 fatalClosedBellanca 7KCAB · Elberta, ALJul 14, 1977 · N87045 · DestroyedNTSB IAD77DA053Accident · 1 fatalClosedGrum Amer AA-1 · Vine Grove, KYJul 14, 1977 · N5652L · Substantial damageNTSB CHI77FA059Accident · 1 fatalClosedCessna 150M · Peoria, ILJul 14, 1977 · N8993U · DestroyedNTSB LAX77FA058Accident · 2 fatalClosedCessna 150J · Silverado, CAJul 13, 1977 · N61044 · DestroyedNTSB DEN77FA047Accident · 1 fatalClosedCessna TU206C · Vaughn, NMJul 13, 1977 · N29101 · DestroyedNTSB OAK77FVD43Accident · 1 fatalClosedCallair A-9B · Stockton, CAJul 10, 1977 · N7763V · DestroyedNTSB LAX77FA057Accident · 1 fatalClosedBell 47G-5A · Maricopa, AZJul 10, 1977 · N6276N · DestroyedNTSB IAD77FA051Accident · 1 fatalClosedGrum Amer AA5-A · Warrenton, VAJul 10, 1977 · N9836U · DestroyedNTSB CHI77FA058Accident · 1 fatalClosedPiper PA-28 · Clayton, ILJul 10, 1977 · N32742 · DestroyedNTSB ANC77FA055Accident · 1 fatalClosedPiper PA-28 · Tyonek, AKJul 10, 1977 · N7312F · Substantial damageNTSB SEA77FYA28Accident · 1 fatalClosedHughes 369HS · American Falls, IDJul 9, 1977 · N9224F · DestroyedNTSB NYC77FA071Accident · 1 fatalClosedPiper PA-28 · Ocean City, NJJul 9, 1977 · N4257Q · Substantial damageNTSB NYC77FA070Accident · 3 fatalClosedPiper PA-28R · Hingham, MAJul 8, 1977 · N5275S · DestroyedNTSB LAX77FUQ39Accident · 1 fatalClosedThorp T-18 · Van Nuys, CAJul 8, 1977 · N56LU · DestroyedNTSB CHI77FET22Accident · 1 fatalClosedPiper PA-28 · Huntington, INJul 8, 1977 · N8091N · DestroyedNTSB OAK77FA040Accident · 1 fatalClosedCessna 421A · San Rafael, CAJul 7, 1977 · N29760 · Destroyed