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 MKC77FA037Accident · 3 fatalClosedPiper PA-28 · Eagle Butte, SDNTSB CHI77FEI42Accident · 1 fatalClosedFalck Spec · Cleveland, OHNTSB ANC77FA085Accident · 2 fatalClosedPiper PA-18 · Anchorage, AKNTSB ANC77FA084Accident · 3 fatalClosedCessna 172 · Palmer, AKNTSB ANC77FA083Accident · 3 fatalClosedCessna 185 · Minto Lake, AKNTSB NYC77FA093Accident · 1 fatalClosedPiper PA-28 · Duanesburg, NYNTSB ANC78DAH09Accident · 1 fatalClosedTaylorcraft BC-12D · Red Devil Lake, AKNTSB NYC77FA090Accident · 2 fatalClosedPiper PA-28R · Greenwich, CTNTSB LAX77FA069Accident · 4 fatalClosedPiper PA-32 · Corona, CANTSB MKC77FA036Accident · 1 fatalClosedCessna 172M · Henning, MNNTSB LAX77FA068Accident · 2 fatalClosedBellanca 17-30 · San Dimas, CANTSB IAD77FA063Accident · 1 fatalClosedCessna 172M · Manchester, KYNTSB FTW77FRG65Accident · 2 fatalClosedBoeing B75-N1 · Kingsville, TXNTSB OAK77FA052Accident · 2 fatalClosedCessna 205A · Kirkwood, CANTSB NYC77FA089Accident · 1 fatalClosedCessna 195B · Mt Holley Spgs, PANTSB NYC77FA088Accident · 4 fatalClosedBeech F35 · North Wales, PANTSB FTW77FA073Accident · 3 fatalClosedPiper PA-28R · Hugo, OKNTSB FTW77FA072Accident · 3 fatalClosedPiper PA-24 · Canyon, TXNTSB DEN77FA055Accident · 2 fatalClosedBeech C-23 · Miami, NMNTSB ANC77DA079Accident · 7 fatalClosedCessna 411 · Yakutat, AKNTSB OAK77FA051Accident · 4 fatalClosedAerostar 601 · Little Norway, CANTSB OAK77FA050Accident · 2 fatalClosedSkyvan SC-7 · Kailua Kona, HINTSB NYC77FA087Accident · 1 fatalClosedPiper PA-24 · New Lebanon, NYNTSB MIA77FKQ39Accident · 1 fatalClosedCessna A188B · Winona, MSNTSB LAX77FA067Accident · 4 fatalClosedMooney M20E · Torrance, CANTSB LAX77FA066Accident · 3 fatalClosedBeech 65-88 · Camarillo, CANTSB CHI77FA069Accident · 4 fatalClosedCessna 170 · Florence, WINTSB MIA77FLG33Accident · 1 fatalClosedCessna 182 · Myrtle Beach, SCNTSB LAX77FA065Accident · 2 fatalClosedBeech E18S · Catalina Is, CANTSB CHI77FA068Accident · 1 fatalClosedCessna 172N · Salem, MINTSB SEA77FYM59Accident · 1 fatalClosedPitts MR1 · Vancouver, WANTSB SEA77FA049Accident · 4 fatalClosedCessna 185 · Hansville, WANTSB NYC77FA085Accident · 1 fatalClosedBeech P35 · Pittsburgh, PANTSB MIA77FA082Accident · 2 fatalClosedChampion 7EC · Yazoo City, MSNTSB OAK77FXQ34Accident · 1 fatalClosedPiper PA-32 · Carson City, NVNTSB OAK77FA049Accident · 4 fatalClosedPiper PA-28 · Los Banos, CANTSB MIA77FKJ76Accident · 1 fatalClosedPiper PA-25 · Castleberry, ALNTSB MIA77FA081Accident · 1 fatalClosedBeech G18S · Aero Oasis Apt, FLNTSB ANC77FA077Accident · 3 fatalClosedBell 206-B · Deadhorse, AKNTSB NYC77FA084Accident · 1 fatalClosedDehavilland DHC-2 · Morrisville, PANTSB FTW77FA071Accident · 1 fatalClosedPiper PA-28R · Healdton, OKNTSB SEA77FA048Accident · 3 fatalClosedCessna 195A · Elgin, ORNTSB MKC77FA034Accident · 2 fatalClosedLuscombe 8A · Carthage, MONTSB FTW77FA070Accident · 1 fatalClosedBeech V35B · Ida, LANTSB CHI77FA067Accident · 4 fatalClosedFairchild F24 · Cedar, MINTSB ANC77FA075Accident · 1 fatalClosedTaylorcraft BC-12D · Kakhonak, AKNTSB FTW77FA069Accident · 1 fatalClosedCessna 150L · Fort Worth, TXNTSB DEN77FA054Accident · 3 fatalClosedCessna 172 · Nsalina, UTNTSB ANC77FA074Accident · 2 fatalClosedPiper PA-12 · Delta Junction, AKNTSB LAX77FUG58Accident · 1 fatalClosedPiper PA-28 · 29 Palms, CA