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 DEN78FA023Accident · 1 fatalClosedPiper PA-24 · Pojoaque, NMNTSB DCA78AA007Accident · 17 fatalClosedBeech 99 · Richland, WANTSB MIA78FA039Accident · 1 fatalClosedCessna 310 · St Petersburg, FLNTSB SEA78FA019Accident · 4 fatalClosedBeech 35 · Cascade Locks, ORNTSB NYC78FFJ13Accident · 1 fatalClosedCessna 150 · Auburn, NYNTSB MKC78FA022Accident · 1 fatalClosedBeech D95A · Amidon, NDNTSB LAX78FA025Accident · 2 fatalClosedPiper PA-24 · Rowland Heigts, CANTSB IAD78FA038Accident · 1 fatalClosedCessna 402B · Greensboro, NCNTSB DEN78FA022Accident · 1 fatalClosedTaylorcraft BC12D · Albuquerque, NMNTSB ANC78FA018Accident · 5 fatalClosedCessna 320D · Wrangell, AKNTSB CHI79FA019Accident · 1 fatalClosedCessna 150M · Big Bay Denoc, MINTSB LAX78FA024Accident · 1 fatalClosedCessna 182A · Los Angeles, CANTSB OAK78DVW08Accident · 1 fatalClosedPiper PA-28 · Pahrump, NVNTSB MIA78FA037Accident · 1 fatalClosedCessna 402B · Tuscaloosa, ALNTSB CHI78FA018Accident · 1 fatalClosedCessna 152 · Ypsilanti, MINTSB OAK78FA015Accident · 1 fatalClosedCessna 182 · Turlock, CANTSB MIA78FLD21Accident · 1 fatalClosedHolt PDQ2 · Arcadia, FLNTSB DEN78FTM11Accident · 1 fatalClosedTurner T-40 · Ogden, UTNTSB ANC78FA016Accident · 3 fatalClosedCessna 170-A · Anchorage, AKNTSB IAD78DA042Accident · 1 fatalClosedStinson 108 · Ocean City, MDNTSB LAX78FA023Accident · 1 fatalClosedHarvard MK4 · St Johns, AZNTSB SEA78FYP08Accident · 1 fatalClosedCessna 182Q · Colfax, WANTSB MIA78FA035Accident · 3 fatalClosedPiper PA-28 · New Prt Richey, FLNTSB FTW78FA025Accident · 1 fatalClosedBell 206B · Palacids, TXNTSB NYC78FA023Accident · 2 fatalClosedAerostar 601P · Dubois, PANTSB MKC78FCJ08Accident · 3 fatalClosedCessna 177 · Hayes Center, NENTSB LAX78FA022Accident · 2 fatalClosedCessna 150L · Lucerne Valley, CANTSB DEN78FA021Accident · 4 fatalClosedCessna 177B · Salt Lake City, UTNTSB MKC78FA021Accident · 2 fatalClosedChampion 7EC · Marmarth, NDNTSB CHI78FEM08Accident · 1 fatalClosedCessna 150 · Millersburg, MINTSB SEA78FYK07Accident · 1 fatalClosedPiper PA-25 · Christmas Vly, ORNTSB SEA78FYK06Accident · 1 fatalClosedHiller UH-12E · Reedsport, ORNTSB MIA78FA034Accident · 1 fatalClosedAmer Avco AA1-A · Ormond Beach, FLNTSB ANC78FA012Accident · 1 fatalClosedBrittnorman BN-2A · Toksook Bay, AKNTSB DEN78FA020Accident · 3 fatalClosedDehavilland DHC-6 · Pueblo, CONTSB NYC78FA025Accident · 1 fatalClosedCessna 150 · Missing AircraftNTSB LAX78FA021Accident · 1 fatalClosedPiper PA-32 · Kernville, CANTSB SEA78FA018Accident · 6 fatalClosedPiper PA-23 · Medford, ORNTSB MKC78FA020Accident · 3 fatalClosedPiper PA-22 · Tama, IANTSB NYC78FA024Accident · 1 fatalClosedTemco GC1B · Newport, RINTSB OAK78FA013Accident · 1 fatalClosedCessna T210L · Bishop, CANTSB MIA78FA031Accident · 5 fatalClosedBeech B-90 · Yazoo City, MSNTSB IAD78FA031Accident · 2 fatalClosedBell 47J · Chesapeake, VANTSB OAK78FA014Accident · 1 fatalClosedLake LA-4 · Hawthorne, NVNTSB NYC78FA022Accident · 2 fatalClosedCessna 210K · Ithaca, NYNTSB MIA78FA030Accident · 4 fatalClosedBeech B-58P · Tylertown, MSNTSB NYC78FA021Accident · 1 fatalClosedBeech H50 · Pottstown, PANTSB MIA78FA042Accident · 1 fatalClosedBeech C23 · Eatonton, GANTSB LAX78FUQ10Accident · 1 fatalClosedCessna 150 · Pacoima, CANTSB LAX78FA020Accident · 2 fatalClosedCessna 182F · Sells, AZ