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 MKC78FA033Accident · 1 fatalClosedBellanca 8KCAB · Council Bluffs, IANTSB NYC78FA061Accident · 1 fatalClosedAmer Avco AA-5A · Guilford, NYNTSB MIA78FA092Accident · 2 fatalClosedPiper PA-28R · Hernando Beach, FLNTSB ANC78FA044Accident · 1 fatalClosedPiper PA-11 · King Salmon, AKNTSB MKC78FA043Accident · 2 fatalClosedCessna 140 · Wolbach, NENTSB LAX78FA052Accident · 1 fatalClosedPiper PA-11 · Tonopah, AZNTSB FTW78FA049Accident · 2 fatalClosedPiper PA-18 · Greenfield, OKNTSB ANC78FA040Accident · 3 fatalClosedCessna 180 · Dillingham, AKNTSB UNK78X0124Accident · 2 fatalClosedBellanca 14-19 · L Mrcds, NiueNTSB SEA78FTI21Accident · 2 fatalClosedBellanca 7KCAB · Pray, MTNTSB MKC78FA042Accident · 2 fatalClosedSwift GC-1B · Piedmont, MONTSB MKC78FA041Accident · 4 fatalClosedBeech 35-B33 · Harris, MNNTSB LAX78AA050Accident · 4 fatalClosedCessna 310 · Irvine, CANTSB FTW78FA048Accident · 1 fatalClosedPiper PA-23 · Longdale, OKNTSB DEN78FTM21Accident · 1 fatalClosedBede BD5 · Wendover, UTNTSB CHI78FEE40Accident · 1 fatalClosedGrum Amer AA1-B · Antioch, ILNTSB LAX78FUG29Accident · 1 fatalClosedTruman Cnkl B8M · Adelanto, CANTSB CHI78FA043Accident · 4 fatalClosedPiper PA-22 · Saint Helen, MINTSB CHI78FA042Accident · 1 fatalClosedCessna 150M · Waukesha, WINTSB UNK78X0122Accident · 2 fatalClosedCessna 180C · Numazi, JANTSB NYC78FA060Accident · 1 fatalClosedPiper PA-28 · Tannersville, PANTSB FTW78FA047Accident · 2 fatalClosedAero Comdr 690A · Calumet, OKNTSB CHI78FA041Accident · 4 fatalClosedCessna T210M · Bloomer, WINTSB MIA78FA091Accident · 3 fatalClosedMooney M20C · Jackson, ALNTSB MIA78DA117Accident · 2 fatalClosedBeech 65 · Missing AircraftNTSB IAD78FA068Accident · 1 fatalClosedTed Smith 601P · Bumpass, VANTSB SEA78FA033Accident · 1 fatalClosedHughes 269A · Vancouver, WANTSB OAK78DVG41Accident · 1 fatalClosedStarduster SA-300 · Napa, CANTSB LAX78FA049Accident · 1 fatalClosedPiper PA-32 · Redlands, CANTSB FTW78FA046Accident · 1 fatalClosedCessna 182E · Dierks, ARNTSB NYC78FA059Accident · 1 fatalClosedStol UC-1 · Champion, PANTSB NYC78FA058Accident · 1 fatalClosedPiper PA-31 · Fleetville, PANTSB LAX78FA043Accident · 1 fatalClosedPiper PA-18 · Upland, CANTSB SEA78FA034Accident · 2 fatalClosedPiper PA-28 · Bremerton, WANTSB SEA78FA031Accident · 1 fatalClosedBuhl Acft LA1 · Kimberly, IDNTSB MIA78FA086Accident · 1 fatalClosedCessna 150L · Ft.Lauderdale, FLNTSB LAX78FUG28Accident · 1 fatalClosedPiper PA-25 · Blythe, CANTSB LAX78FA048Accident · 2 fatalClosedCessna 337D · Santa Barbara, CANTSB ANC78FA039Accident · 2 fatalClosedPiper PA-18 · Rocky Cove, AKNTSB NYC78FA057Accident · 1 fatalClosedBeech 95-B55 · Provincetown, MANTSB NYC78FA056Accident · 2 fatalClosedPiper PA-22 · Northampton, PANTSB CHI78FA040Accident · 3 fatalClosedCessna 172M · Lapeer, MINTSB MKC78FA039Accident · 1 fatalClosedCessna 402B · Alexandria, MNNTSB MKC78FA038Accident · 1 fatalClosedPiper PA-28 · Scott City, KSNTSB MIA78DA089Accident · 4 fatalClosedPiper PA-28 · Missing AircraftNTSB FTW78FRG43Accident · 2 fatalClosedBensen B-8M · Cotulla, TXNTSB DCA78AA013Accident · 6 fatalClosedSud Avtn DA-20 · Memphis, TNNTSB NYC78FA055Accident · 1 fatalClosedBell 47G-3B · Wantagh, NYNTSB IAD78FA065Accident · 2 fatalClosedN-American SNJ-5 · Greensboro, NCNTSB SEA78FA032Accident · 1 fatalClosedBeech K35 · Wenatchee, WA