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 CHI77FEC48Accident · 1 fatalClosedPiper PA-28 · Romeo, MINTSB CHI77FA074Accident · 1 fatalClosedBeech C55 · Farmersburg, INNTSB NYC77FHM26Accident · 1 fatalClosedMahler-Wbr PJ-260 · Westhampton, NYNTSB DEN77FA058Accident · 6 fatalClosedCessna U206 · Salida, CONTSB CHI77FA073Accident · 2 fatalClosedBeech C90 · Pontiac, ILNTSB MIA77FKG81Accident · 1 fatalClosedAero Comdr 600S2R · Albany, GANTSB LAX77FA064Accident · 1 fatalClosedCessna T210L · Carlsbad, CANTSB IAD77FA067Accident · 1 fatalClosedPiper PA-32R · Williamson, WVNTSB FTW77FPG91Accident · 1 fatalClosedAeronca 7AC · Slovak, ARNTSB SEA77FA054Accident · 1 fatalClosedCessna 180 · Ashland, ORNTSB OAK77FA057Accident · 2 fatalClosedCessna 150L · Mariposa, CANTSB OAK77FA055Accident · 1 fatalClosedCessna 150L · Concord, CANTSB MKC77FA040Accident · 2 fatalClosedAeronca 7AC · Grand Rapids, MNNTSB FTW77FRA34Accident · 1 fatalClosedBoeing A75N1 · Tomball, TXNTSB CHI78FET35Accident · 1 fatalClosedPiper PA-18 · Benton Harbor, MINTSB SEA77FA053Accident · 1 fatalClosedCessna 150L · Clarkston, WANTSB OAK77FA054Accident · 2 fatalClosedCessna 177 · Soda Springs, CANTSB CHI77FA072Accident · 4 fatalClosedCessna 177RG · Missing AircraftNTSB SEA77FA052Accident · 3 fatalClosedCessna 172K · Skykomish, WANTSB NYC77FA098Accident · 2 fatalClosedPiper PA-28R · Montauk Point, NYNTSB MIA77FA088Accident · 4 fatalClosedCessna 172 · Lauderhill, FLNTSB MKC77FA039Accident · 2 fatalClosedCessna 177 · Coldwater, KSNTSB FTW77FRJ23Accident · 1 fatalClosedCessna 150M · Oil City, LANTSB IAD78FA012Accident · 1 fatalClosedPiper PA28 · Ashford, WVNTSB MIA77FLA54Accident · 2 fatalClosedCessna 188-B · Nashville, GANTSB MIA77FA087Accident · 2 fatalClosedPiper PA-28 · Jackson, MSNTSB FTW77FQD28Accident · 1 fatalClosedPiper PA-25 · Coyanosa, TXNTSB FTW77FA074Accident · 3 fatalClosedBeech V35A · Idabel, OKNTSB DCA77AA027Accident · 4 fatalClosedDouglas DC-7BF · Yakutat, AKNTSB CHI78FA071Accident · 2 fatalClosedCessna 320 · Milwaukee, WINTSB CHI77FET34Accident · 1 fatalClosedPiper PA-22 · Fort Wayne, INNTSB NYC77FA096Accident · 1 fatalClosedLake LA-4 · Greenville, MENTSB SEA77FA051Accident · 2 fatalClosedCessna 182L · Bellevue, WANTSB LAX77FA071Accident · 1 fatalClosedPiper PA-22 · Malibu, CANTSB IAD77AA065Accident · 5 fatalClosedLearjet 25B · Sanford, NCNTSB MIA77FA086Accident · 1 fatalClosedCessna 172N · Bunnell, FLNTSB MIA77FA085Accident · 3 fatalClosedPiper PA-28 · Danville, GANTSB MIA77FA084Accident · 1 fatalClosedCessna 172 · Key West, FLNTSB LAX77FA072Accident · 2 fatalClosedCessna 182P · San Onofre, CANTSB ANC77DAA51Accident · 1 fatalClosedCessna A185F · Bettles, AKNTSB MKC77FA038Accident · 1 fatalClosedPiper PA-18 · Jamestown, NDNTSB LAX77FA070Accident · 1 fatalClosedPiper PA-23 · Gorman, CANTSB DCA77AA026Accident · 13 fatalClosedDehavilland DHC-6 · Iliamna, AKNTSB NYC77FA095Accident · 2 fatalClosedTaylorcraft BC1265 · Oval, PANTSB IAD77FA064Accident · 2 fatalClosedPiper PA-28 · Harriman, TNNTSB CHI77FEE50Accident · 1 fatalClosedCessna 172 · Rockford, ILNTSB SEA77FA050Accident · 1 fatalClosedGrum Amer AA1C · Othello, WANTSB MIA77FA083Accident · 2 fatalClosedPiper PA-28 · Lodge, SCNTSB CHI77FEX48Accident · 1 fatalClosedBeech C45 · Richmond, INNTSB CHI77FEM39Accident · 1 fatalClosedCessna 182Q · East Tawas, MI