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 MKC76AK084Accident · 1 fatalClosedBeech P35 · Red Wing, MNSep 26, 1976 · N1584Z · DestroyedNTSB MKC76AK083Accident · 2 fatalClosedN. American AT-6G · Beatrice, NESep 26, 1976 · N2886G · DestroyedNTSB IAD76FID44Accident · 1 fatalClosedPitts Spcl S-1C · Weyers Cave, VASep 26, 1976 · N2153 · DestroyedNTSB GAF76AA138Accident · 4 fatalClosedCessna 172L · Beluga Mt, AKSep 26, 1976 · N7004Q · DestroyedNTSB FTW76AF126Accident · 1 fatalClosedPiper PA-28 · Greenfield, OKSep 26, 1976 · N55481 · DestroyedNTSB DEN76AD074Accident · 6 fatalClosedPiper PA-23 · Steamboat Spgs, COSep 26, 1976 · N777MF · DestroyedNTSB DCA76AZ039Accident · 11 fatalClosedGrumman G-1159 · Hot Springs, VASep 26, 1976 · N500J · DestroyedNTSB CHI76AC093Accident · 3 fatalClosedCessna T210L · Peoria, ILSep 26, 1976 · N732AB · DestroyedNTSB SEA76AS079Accident · 4 fatalClosedPiper PA-34 · Kent, WASep 25, 1976 · N15867 · DestroyedNTSB MIA76AM110Accident · 2 fatalClosedCessna 310D · Daytona Beach, FLSep 25, 1976 · N6859T · DestroyedNTSB DEN76AD073Accident · 2 fatalClosedBell 47G3B2 · Mantua, UTSep 25, 1976 · N2205W · DestroyedNTSB SEA76AS078Accident · 1 fatalClosedPiper PA-18 · Zurich, MTSep 24, 1976 · N8966C · DestroyedNTSB OAK76AP071Accident · 2 fatalClosedBellanca Bkcab · Las Vegas, NVSep 24, 1976 · N53859 · DestroyedNTSB MIA76AM111Accident · 2 fatalClosedPiper PA-28 · Deland, FLSep 23, 1976 · N657FL · DestroyedNTSB LAX76AL097Accident · 4 fatalClosedSikorsky S-55B · San Bernardino, CASep 22, 1976 · N9389 · DestroyedNTSB LAX76AL096Accident · 1 fatalClosedPiper PA-28 · Grand Canyon, AZSep 21, 1976 · N40722 · DestroyedNTSB FTW76AF125Accident · 1 fatalClosedPiper PA-12 · Greenwood, LASep 21, 1976 · N78592 · DestroyedNTSB LAX76AL095Accident · 1 fatalClosedCessna 182 · Santa Barbara, CASep 20, 1976 · N91620 · DestroyedNTSB CHI77AC095Accident · 2 fatalClosedBeech 95 · L'Anse, MISep 20, 1976 · N2080C · DestroyedNTSB LAX76FUM31Accident · 1 fatalClosedAero Comdr A-9B · Imperial, CASep 19, 1976 · N7659V · DestroyedNTSB DEN76AD072Accident · 2 fatalClosedPiper PA-31 · Pinon, NMSep 19, 1976 · N54294 · DestroyedNTSB CHI76AC092Accident · 1 fatalClosedCessna 210B · Hamilton, OHSep 19, 1976 · N9656X · Substantial damageNTSB OAK76FVA92Accident · 1 fatalClosedBoeing A75 · Parlier, CASep 18, 1976 · N68497 · DestroyedNTSB MKC76AK082Accident · 2 fatalClosedAir & Space 18A. · Oxford, KSSep 18, 1976 · N73546 · DestroyedNTSB FTW76AF124Accident · 1 fatalClosedBellanca 17-30 · Eagletown, OKSep 18, 1976 · N4885V · DestroyedNTSB FTW76AF123Accident · 4 fatalClosedPiper PA-32 · Oak Ridge, LASep 18, 1976 · N3918W · DestroyedNTSB FTW76AF122Accident · 3 fatalClosedCessna 421B · Ashdown, ARSep 18, 1976 · N29RX · DestroyedNTSB ANC76AA133Accident · 1 fatalClosedPiper PA-18 · Aniak, AKSep 17, 1976 · N7860D · No damageNTSB CHI76AC091Accident · 6 fatalClosedBeech D55 · Coldwater, MISep 16, 1976 · N8330N · DestroyedNTSB ANC76DAH73Accident · 1 fatalClosedCessna 180A · King Salmon, AKSep 16, 1976 · N9664B · Substantial damageNTSB SEA76AS077Accident · 2 fatalClosedCessna A185F · Geraldine, MTSep 15, 1976 · N53075 · DestroyedNTSB OAK76AP070Accident · 4 fatalClosedPiper PA-24 · Trinity Center, CASep 15, 1976 · N7614P · DestroyedNTSB OAK76AP069Accident · 4 fatalClosedPiper PA-32R · North Fork, CASep 15, 1976 · N6265J · DestroyedNTSB MIA76AM109Accident · 2 fatalClosedBeech C-45H · W Palm Beach, FLSep 15, 1976 · N3505G · DestroyedNTSB MIA76FKQ47Accident · 2 fatalClosedPiper PA-18 · Flora, MSSep 14, 1976 · N4686Y · DestroyedNTSB ANC76AA135Accident · 1 fatalClosedBellanca 7GCBC · Missing Aircraft, AKSep 14, 1976 · N5VB · DestroyedNTSB MIA76AM108Accident · 5 fatalClosedCessna 414 · Brighton, FLSep 13, 1976 · N8PR · 2 aircraft · DestroyedNTSB FTW76AF121Accident · 1 fatalClosedCessna 150M · Kiefer, OKSep 13, 1976 · N45690 · DestroyedNTSB IAD76AI099Accident · 1 fatalClosedAmer Avco AA1 · Frederick, MDSep 12, 1976 · N6137L · DestroyedNTSB FTW76FPH12Accident · 1 fatalClosedPitts Spcl · El Dorado, ARSep 12, 1976 · N94ES · Substantial damageNTSB FTW76AF120Accident · 3 fatalClosedCessna 172H · Glen Rose, TXSep 12, 1976 · N8228L · DestroyedNTSB MKC76AK080Accident · 1 fatalClosedErco 415-C · Saint James, MOSep 11, 1976 · N87059 · DestroyedNTSB LAX76AL094Accident · 1 fatalClosedCessna 210 · San Diego, CASep 11, 1976 · N2288S · DestroyedNTSB FTW76FPD57Accident · 1 fatalClosedBoeing B75N1 · Goldthwaite, TXSep 11, 1976 · N73621 · DestroyedNTSB ANC76AA130Accident · 3 fatalClosedCessna 150 · Wrangell, AKSep 11, 1976 · N4710X · DestroyedNTSB ANC76AA129Accident · 1 fatalClosedCessna 150 · Sterling, AKSep 11, 1976 · N63215 · Substantial damageNTSB OAK76AP068Accident · 3 fatalClosedCessna 177RG · Mt.Tallac, CASep 10, 1976 · N1531H · DestroyedNTSB DEN76AD071Accident · 2 fatalClosedPiper PA-28 · Scholle, NMSep 10, 1976 · N8981W · DestroyedNTSB SEA76AS076Accident · 2 fatalClosedUniversal GC-1B · Mckenzie Brdg, ORSep 8, 1976 · N80826 · DestroyedNTSB NYC76AN126Accident · 1 fatalClosedBeech S35 · Block Island, RISep 8, 1976 · N272D · Minor damage