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 MIA79FA015Accident · 3 fatalClosedCessna 172N · Ormond Beach, FLNTSB MIA79FA014Accident · 2 fatalClosedPiper PA-23 · Ormond Beach, FLNTSB MIA79DA019Accident · 4 fatalClosedPiper PA-23 · Missing AircraftNTSB FTW79FA015Accident · 1 fatalClosedBeech H18 · Brownsville, TXNTSB SEA79FA014Accident · 2 fatalClosedBellanca 17-30 · Medford, ORNTSB FTW79FA014Accident · 3 fatalClosedPiper PA-24 · Amarilld, TXNTSB ANC79DA021Accident · 2 fatalClosedLake LA-4 · Missing AircraftNTSB IAD79FA013Accident · 1 fatalClosedCessna 152 · Spencer, WVNTSB FTW79FA013Accident · 1 fatalClosedCessna 172H · Kent, TXNTSB DEN79FA008Accident · 1 fatalClosedAero Comdr 500S · Gallup, NMNTSB MKC79FA004Accident · 2 fatalClosedBeech G18S · Hays, KSNTSB IAD79FA011Accident · 4 fatalClosedPiper PA-24 · Bowie, MDNTSB FTW79FA012Accident · 2 fatalClosedCessna 310J · Lubbock, TXNTSB MKC79FA003Accident · 1 fatalClosedCessna 310Q · Eden Prairie, MNNTSB MIA79FLD15Accident · 1 fatalClosedHoffman X2 · Tarpon Springs, FLNTSB MIA79FA017Accident · 1 fatalClosedPiper PA-28 · Jacksonville, FLNTSB LAX79FA014Accident · 2 fatalClosedGrum Amer AA1-G · Kernville, CANTSB LAX79FA013Accident · 1 fatalClosedCessna 172N · Sn Jun Cpstrn, CANTSB FTW79FA011Accident · 2 fatalClosedBell 206B · Sabine Pass, TXNTSB CHI79FEK01Accident · 1 fatalClosedGrum Amer AA-5 · Reno, OHNTSB OAK79FA010Accident · 1 fatalClosedCessna 182A · Reno, NVNTSB NYC79FA011Accident · 6 fatalClosedPiper PA-32 · Newry, MENTSB LAX79FUJ13Accident · 1 fatalClosedBell 47G3B · Springerville, AZNTSB DEN79FA006Accident · 2 fatalClosedBeech A36 · Silver City, NMNTSB CHI79FA017Accident · 2 fatalClosedGrumman AA-5 · Norway, MINTSB SEA79FA012Accident · 1 fatalClosedCessna 177B · Kimberly, ORNTSB IAD79FA010Accident · 4 fatalClosedPiper PA-32 · Melfa, VANTSB DEN79FA007Accident · 4 fatalClosedGrum-Amer AA-5B · Meeteetse, WYNTSB IAD79FA008Accident · 2 fatalClosedCessna 310I · Portland, TNNTSB MIA79FA013Accident · 2 fatalClosedCessa 152 · Boca Raton, FLNTSB MIA79FA012Accident · 8 fatalClosedBeech 60 · Jackson, MSNTSB LAX79FA011Accident · 1 fatalClosedCessna T210M · Hermosa Beach, CANTSB SEA79FA011Accident · 3 fatalClosedCessna 185 · Joseph, ORNTSB NYC79FNC09Accident · 1 fatalClosedDehavilland DH-82A · No.Hampton, NHNTSB NYC79FA008Accident · 1 fatalClosedCessna 152 · West Mifflin, PANTSB MKC79FA001Accident · 4 fatalClosedBeech A23-24 · Lyndon, KSNTSB CHI79FA014Accident · 4 fatalClosedCessna 210A · Chicago, ILNTSB ANC79FA016Accident · 1 fatalClosedPiper PA-18 · Copper Center, AKNTSB CHI79FEV03Accident · 1 fatalClosedStarduster TOO · Nhenderson, ILNTSB CHI79FET04Accident · 2 fatalClosedMonocoupe 90A · Mentone, INNTSB MIA79FA010Accident · 1 fatalClosedPiper PA-31 · Missing AircraftNTSB SEA79FA009Accident · 3 fatalClosedCessna P210 · Toutle, WANTSB NYC79FA007Accident · 2 fatalClosedCessna 172 · Marcy, NYNTSB FTW79FA009Accident · 2 fatalClosedAeronca 7EC · Richmond, LANTSB OAK79FA009Accident · 3 fatalClosedMooney M20J · Capay, CANTSB OAK79FA008Accident · 1 fatalClosedCessna T-210L · Dayton, NVNTSB OAK79FA007Accident · 2 fatalClosedBellanca 7ECA · San Jose, CANTSB OAK78FA051Accident · 2 fatalClosedBellanca 8KCAB · Truckee, CANTSB SEA79FA008Accident · 1 fatalClosedCessna 150H · Swan Lake, MTNTSB ANC79DA015Accident · 3 fatalClosedGrumman G-44A · Cordova, AK