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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MKC76AK084Accident · 1 fatalClosedBeech P35 · Red Wing, MNNTSB MKC76AK083Accident · 2 fatalClosedN. American AT-6G · Beatrice, NENTSB IAD76FID44Accident · 1 fatalClosedPitts Spcl S-1C · Weyers Cave, VANTSB GAF76AA138Accident · 4 fatalClosedCessna 172L · Beluga Mt, AKNTSB FTW76AF126Accident · 1 fatalClosedPiper PA-28 · Greenfield, OKNTSB DEN76AD074Accident · 6 fatalClosedPiper PA-23 · Steamboat Spgs, CONTSB DCA76AZ039Accident · 11 fatalClosedGrumman G-1159 · Hot Springs, VANTSB CHI76AC093Accident · 3 fatalClosedCessna T210L · Peoria, ILNTSB SEA76AS079Accident · 4 fatalClosedPiper PA-34 · Kent, WANTSB MIA76AM110Accident · 2 fatalClosedCessna 310D · Daytona Beach, FLNTSB DEN76AD073Accident · 2 fatalClosedBell 47G3B2 · Mantua, UTNTSB SEA76AS078Accident · 1 fatalClosedPiper PA-18 · Zurich, MTNTSB OAK76AP071Accident · 2 fatalClosedBellanca Bkcab · Las Vegas, NVNTSB MIA76AM111Accident · 2 fatalClosedPiper PA-28 · Deland, FLNTSB LAX76AL097Accident · 4 fatalClosedSikorsky S-55B · San Bernardino, CANTSB LAX76AL096Accident · 1 fatalClosedPiper PA-28 · Grand Canyon, AZNTSB FTW76AF125Accident · 1 fatalClosedPiper PA-12 · Greenwood, LANTSB LAX76AL095Accident · 1 fatalClosedCessna 182 · Santa Barbara, CANTSB CHI77AC095Accident · 2 fatalClosedBeech 95 · L'Anse, MINTSB LAX76FUM31Accident · 1 fatalClosedAero Comdr A-9B · Imperial, CANTSB DEN76AD072Accident · 2 fatalClosedPiper PA-31 · Pinon, NMNTSB CHI76AC092Accident · 1 fatalClosedCessna 210B · Hamilton, OHNTSB OAK76FVA92Accident · 1 fatalClosedBoeing A75 · Parlier, CANTSB MKC76AK082Accident · 2 fatalClosedAir & Space 18A. · Oxford, KSNTSB FTW76AF124Accident · 1 fatalClosedBellanca 17-30 · Eagletown, OKNTSB FTW76AF123Accident · 4 fatalClosedPiper PA-32 · Oak Ridge, LANTSB FTW76AF122Accident · 3 fatalClosedCessna 421B · Ashdown, ARNTSB ANC76AA133Accident · 1 fatalClosedPiper PA-18 · Aniak, AKNTSB CHI76AC091Accident · 6 fatalClosedBeech D55 · Coldwater, MINTSB ANC76DAH73Accident · 1 fatalClosedCessna 180A · King Salmon, AKNTSB SEA76AS077Accident · 2 fatalClosedCessna A185F · Geraldine, MTNTSB OAK76AP070Accident · 4 fatalClosedPiper PA-24 · Trinity Center, CANTSB OAK76AP069Accident · 4 fatalClosedPiper PA-32R · North Fork, CANTSB MIA76AM109Accident · 2 fatalClosedBeech C-45H · W Palm Beach, FLNTSB MIA76FKQ47Accident · 2 fatalClosedPiper PA-18 · Flora, MSNTSB ANC76AA135Accident · 1 fatalClosedBellanca 7GCBC · Missing Aircraft, AKNTSB MIA76AM108Accident · 5 fatalClosedCessna 414 · Brighton, FLNTSB FTW76AF121Accident · 1 fatalClosedCessna 150M · Kiefer, OKNTSB IAD76AI099Accident · 1 fatalClosedAmer Avco AA1 · Frederick, MDNTSB FTW76FPH12Accident · 1 fatalClosedPitts Spcl · El Dorado, ARNTSB FTW76AF120Accident · 3 fatalClosedCessna 172H · Glen Rose, TXNTSB MKC76AK080Accident · 1 fatalClosedErco 415-C · Saint James, MONTSB LAX76AL094Accident · 1 fatalClosedCessna 210 · San Diego, CANTSB FTW76FPD57Accident · 1 fatalClosedBoeing B75N1 · Goldthwaite, TXNTSB ANC76AA130Accident · 3 fatalClosedCessna 150 · Wrangell, AKNTSB ANC76AA129Accident · 1 fatalClosedCessna 150 · Sterling, AKNTSB OAK76AP068Accident · 3 fatalClosedCessna 177RG · Mt.Tallac, CANTSB DEN76AD071Accident · 2 fatalClosedPiper PA-28 · Scholle, NMNTSB SEA76AS076Accident · 2 fatalClosedUniversal GC-1B · Mckenzie Brdg, ORNTSB NYC76AN126Accident · 1 fatalClosedBeech S35 · Block Island, RI