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 LAX79FA002Accident · 2 fatalClosedCessna 152 · Scottsdale, AZOct 7, 1978 · N67408 · DestroyedNTSB SEA79FA001Accident · 2 fatalClosedCessna 150H · Omak, WAOct 6, 1978 · N22421 · DestroyedNTSB ANC79FA001Accident · 1 fatalClosedCessna 180H · Anchorage, AKOct 5, 1978 · N8203V · Substantial damageNTSB DEN79FA002Accident · 2 fatalClosedGrum Amer AA5 · Littleton, COOct 4, 1978 · N6071L · DestroyedNTSB IAD79FA001Accident · 5 fatalClosedPiper PA-31P · Lexington, KYOct 3, 1978 · N338J · DestroyedNTSB NYC79FFJ06Accident · 1 fatalClosedFly Baby JD-1 · Java Center, NYOct 1, 1978 · N12JD · Substantial damageNTSB MIA79DA001Accident · 1 fatalClosedDouglas DC-3 · Ft Walton Bch, FLOct 1, 1978 · N74Z · DestroyedNTSB LAX79FA001Accident · 1 fatalClosedNavion A · Buena Park, CAOct 1, 1978 · N91160 · Substantial damageNTSB IAD79FA018Accident · 1 fatalClosedCessna 152 · Linden, TNOct 1, 1978 · N25955 · DestroyedNTSB DEN79FQA01Accident · 1 fatalClosedSteen Skyblt · Albuquerque, NMOct 1, 1978 · N88PM · DestroyedNTSB DEN79FA001Accident · 1 fatalClosedSikorsky S58ET · Steamboat Spgs, COOct 1, 1978 · N47783 · DestroyedNTSB CHI79FCA01Accident · 2 fatalClosedReplica 1 · Pierron, ILOct 1, 1978 · N1912G · DestroyedNTSB FTW78FA086Accident · 3 fatalClosedPiper PA-28 · Richland Hills, TXSep 28, 1978 · N1853H · 2 aircraft · DestroyedNTSB NYC79FFJ40Accident · 1 fatalClosedVarieze CN-VEZ · Angola, NYSep 27, 1978 · N56CN · Substantial damageNTSB DCA78AA024Accident · 6 fatalClosedBeech D18S · San Juan, PRSep 26, 1978 · N500L · DestroyedNTSB NYC79FA009Accident · 3 fatalClosedCessna 310N · Monroe, MASep 25, 1978 · N4121Q · DestroyedNTSB DCA78AA023Accident · 137 fatalClosedBoeing 727 · San Diego, CASep 25, 1978 · N533PS · 2 aircraft · Substantial damageNTSB CHI78FA070Accident · 1 fatalClosedCessna 150F · Portage, WISep 25, 1978 · N8815S · DestroyedNTSB LAX78FA079Accident · 2 fatalClosedCessna 182M · Santa Barbara, CASep 24, 1978 · N71182 · DestroyedNTSB NYC78FHA39Accident · 1 fatalClosedBlanik L-3 · Pittstown, NJSep 23, 1978 · N90861 · DestroyedNTSB NYC78FHA37Accident · 1 fatalClosedSoneria II · Pipersville, PASep 23, 1978 · N81915 · Substantial damageNTSB IAD78FIA19Accident · 1 fatalClosedPiper PA-28 · Indian Head, MDSep 23, 1978 · N5179F · DestroyedNTSB FTW78FA085Accident · 7 fatalClosedAero Comdr 500 · Laredo, TXSep 23, 1978 · N6244B · DestroyedNTSB OAK78FA057Accident · 2 fatalClosedPiper PA-28 · Concord, CASep 22, 1978 · N36762 · 2 aircraft · DestroyedNTSB MIA78FA126Accident · 2 fatalClosedCessna 337G · Atlanta, GASep 22, 1978 · N1309L · DestroyedNTSB MIA78FA128Accident · 4 fatalClosedDouglas DC-3 · Missing AircraftSep 21, 1978 · N407D · DestroyedNTSB SEA78FYK24Accident · 1 fatalClosedCallair B-1A · Glide, ORSep 20, 1978 · N7269V · Substantial damageNTSB NYC78FA097Accident · 1 fatalClosedCessna 172M · Windsor Locks, CTSep 20, 1978 · N20285 · DestroyedNTSB SEA78FA066Accident · 4 fatalClosedPiper PA-28 · Hall, MTSep 19, 1978 · N8359C · DestroyedNTSB MIA78FA125Accident · 1 fatalClosedPiper E-2 · Fernandina, FLSep 19, 1978 · N12627 · DestroyedNTSB NYC78FA095Accident · 2 fatalClosedPiper PA-31 · Granville, MASep 18, 1978 · N63731 · DestroyedNTSB FTW78FA081Accident · 5 fatalClosedBeech 35 · Kerrville, TXSep 17, 1978 · N48RH · DestroyedNTSB ANC78FA079Accident · 1 fatalClosedMaule M-5 · Sterling, AKSep 17, 1978 · N9070E · Substantial damageNTSB ANC78DA081Accident · 3 fatalClosedCessna 411 · Missing AircraftSep 17, 1978 · N1EC · DestroyedNTSB OAK78FA054Accident · 2 fatalClosedGrum Amer AA-1C · Bear Valley, CASep 16, 1978 · N9812U · DestroyedNTSB OAK78DA055Accident · 2 fatalClosedN.American SNJ-4 · Reno, NVSep 16, 1978 · N7038C · 2 aircraft · DestroyedNTSB NYC78FA093Accident · 2 fatalClosedCessna R172K · Venice Center, NYSep 16, 1978 · N9655V · Substantial damageNTSB NYC78FA092Accident · 5 fatalClosedPiper PA-32R · Robbinsville, NJSep 16, 1978 · N3930F · DestroyedNTSB NYC78FA094Accident · 1 fatalClosedCessna 182 · Dupont, PASep 15, 1978 · N9237G · Substantial damageNTSB IAD78FKM25Accident · 1 fatalClosedBensen B8 · Salisbury, NCSep 15, 1978 · NONE · DestroyedNTSB ANC78FA082Accident · 1 fatalClosedAeronca 7EC · Fairbanks, AKSep 15, 1978 · N4739E · DestroyedNTSB SEA78FA065Accident · 1 fatalClosedPiper PA-28 · Rainier, ORSep 14, 1978 · N5877U · DestroyedNTSB OAK78FA052Accident · 3 fatalClosedBellanca 17-31A · San Jose, CASep 13, 1978 · N6626V · DestroyedNTSB ANC78FA078Accident · 6 fatalClosedDehavilland DHC-2 · Whittier, AKSep 13, 1978 · N37741 · Substantial damageNTSB FTW78FA079Accident · 2 fatalClosedPiper J3C · Ferris, TXSep 12, 1978 · N78430 · DestroyedNTSB SEA78FA064Accident · 1 fatalClosedCessna 185F · Riggins, IDSep 11, 1978 · N80172 · DestroyedNTSB NYC78FA091Accident · 3 fatalClosedAero Comdr 500S · Hammondsport, NYSep 11, 1978 · N40MA · Substantial damageNTSB MKC78FA069Accident · 2 fatalClosedLuscombe 8A · Fayette, MOSep 11, 1978 · N28828 · DestroyedNTSB MIA78FA123Accident · 1 fatalClosedCessna 172N · Gautier, MSSep 11, 1978 · N666ZH · DestroyedNTSB CHI78FA066Accident · 1 fatalClosedBrantley B-2B · Brook, INSep 11, 1978 · N2284U · Destroyed