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 MIA79FA007Accident · 2 fatalClosedPiper PA-34 · Titusville, FLNTSB MIA79FA005Accident · 3 fatalClosedBeech 95 · Madison, ALNTSB LAX79FA010Accident · 2 fatalClosedPiper PA-32 · Mojave, CANTSB OAK79FA006Accident · 2 fatalClosedCessna T210G · Groveland, CANTSB MIA79FA004Accident · 1 fatalClosedGreat Lakes 2T-1A2 · Guntersville, ALNTSB FTW79DA008Accident · 1 fatalClosedMooney M18LA · Wilson, TXNTSB SEA79FA010Accident · 3 fatalClosedPiper PA-20 · Joseph, ORNTSB SEA79FA007Accident · 1 fatalClosedSchweizer SGS232 · Hailey, IDNTSB NYC79FA006Accident · 1 fatalClosedPiper PA-38 · West Townshend, VTNTSB MIA79FKJ09Accident · 1 fatalClosedAmateur Mini · Bessemer, ALNTSB LAX79FA009Accident · 2 fatalClosedCessna TU206G · Chula Vista, CANTSB IAD79FKW01Accident · 2 fatalClosedCessna 150G · Evensville, TNNTSB IAD79FA006Accident · 1 fatalClosedCessna 120 · Covington, TNNTSB NYC79FA005Accident · 1 fatalClosedPiper PA-28 · Great Bend, PANTSB IAD79FA005Accident · 2 fatalClosedPiper PA-28 · Harpers Ferry, WVNTSB CHI79FA012Accident · 1 fatalClosedCessna 172M · Gallipolis, OHNTSB LAX79FA007Accident · 2 fatalClosedCessna 182P · Whiteriver, AZNTSB CHI79FA011Accident · 1 fatalClosedPiper PA-24 · Ashton, ILNTSB FTW79FPJ01Accident · 1 fatalClosedPiper PA-25 · Hydro, OKNTSB FTW79FA007Accident · 2 fatalClosedMooney M20E · Texarkana, TXNTSB DEN79FA005Accident · 4 fatalClosedBeech 65-80 · Torreon, NMNTSB OAK79FA004Accident · 1 fatalClosedPiper PA-28 · Galt, CANTSB NYC79FGT02Accident · 1 fatalClosedGyrocopter JW-1 · Smoketown, PANTSB CHI79FEX02Accident · 1 fatalClosedCassutt LSS · Cloverdale, INNTSB SEA79FA006Accident · 4 fatalClosedGrum Amer AA-5B · Roche Harbor, WANTSB SEA79FA005Accident · 5 fatalClosedRolladn SCH LS-1-F · Ephrata, WANTSB CHI79FEC01Accident · 2 fatalClosedNord Stampe SV4C · Wixom, MINTSB OAK79FA003Accident · 1 fatalClosedCessna T-210L · San Leandro, CANTSB LAX79FA006Accident · 1 fatalClosedPiper PA32RT · Green Vly Lk, CANTSB LAX79FA005Accident · 3 fatalClosedBeech 35 · Williams, AZNTSB DEN79FA004Accident · 1 fatalClosedCessna 172 · Provo, UTNTSB MIA79FA002Accident · 1 fatalClosedCessna T210M · Plymouth, FLNTSB LAX79FA004Accident · 1 fatalClosedLear Jet 24 · Lancaster, CANTSB CHI79FA009Accident · 4 fatalClosedPiper PA-22 · Tell City, INNTSB OAK79FVG02Accident · 2 fatalClosedNord Stampe SV4C · Shingle Spgs, CANTSB FTW79FA004Accident · 2 fatalClosedCessna 172K · New Orleans, LANTSB ANC79FA006Accident · 1 fatalClosedCessna 185 · Ketchikan, AKNTSB LAX79FA003Accident · 2 fatalClosedRockwell 112A · Yucca Valley, CANTSB SEA79FA003Accident · 2 fatalClosedPiper PA-18S · Bozeman, MTNTSB ANC79FA004Accident · 1 fatalClosedDehavnd Can DHC-6 · Barrow, AKNTSB OAK79FA002Accident · 2 fatalClosedBellanca 8KCAB · Palo Alto, CANTSB NYC79FA004Accident · 2 fatalClosedEnstrom F-28A · Bakertown, PANTSB DEN79FA003Accident · 1 fatalClosedCessna 150J · Eunice, NMNTSB OAK79DA001Accident · 1 fatalClosedCessna 182 · Monterey, CANTSB NYC79FA003Accident · 2 fatalClosedPiper PA-28R · Parsippany, NJNTSB CHI79FA006Accident · 2 fatalClosedPiper PA-24 · Baraboo, WINTSB FTW79FA001Accident · 1 fatalClosedCessna 172 · Bridgeport, TXNTSB ANC79FA002Accident · 2 fatalClosedBell 205A-1 · Kenai, AKNTSB SEA79FA002Accident · 1 fatalClosedPiper PA-11 · Nashua, MTNTSB NYC79FA002Accident · 1 fatalClosedBoeing E-75 · East Gramby Ct, CT