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 NYC78FA090Accident · 2 fatalClosedPiper PA-32 · Honesdale, PANTSB MIA78FLD73Accident · 1 fatalClosedGyrocopter 1 · Dunnellon, FLNTSB IAD78FA108Accident · 1 fatalClosedGrum Amer AA-5 · Jackson, TNNTSB FTW78FA080Accident · 1 fatalClosedBeech V35 · Alexandria, LANTSB DEN78FA067Accident · 1 fatalClosedAeronca 11AC · Wray, CONTSB CHI78FA065Accident · 3 fatalClosedCessna 172K · Mackinaw City, MINTSB ANC78DA083Accident · 3 fatalClosedCessna 185 · Missing AircraftNTSB NYC78FA089Accident · 2 fatalClosedCessna 150M · Millbury, MANTSB MIA78FLA50Accident · 1 fatalClosedBirdman TL1A · Deland, FLNTSB CHI78FA064Accident · 6 fatalClosedPiper PA-31 · Savoy, ILNTSB ANC79FA076Accident · 3 fatalClosedSoloy 12EJ3 · Wrangell, AKNTSB OAK78FA049Accident · 4 fatalClosedBeech C-24R · Big Sur, CANTSB OAK78FA048Accident · 1 fatalClosedWeatherly 201B · Greenfield, CANTSB MIA78FA122Accident · 2 fatalClosedPiper PA-38 · Florence, SCNTSB SEA78FA063Accident · 4 fatalClosedPiper PA-28 · Sisters, ORNTSB SEA78FA062Accident · 1 fatalClosedAero Comdr 500B · Great Falls, MTNTSB OAK78FA050Accident · 3 fatalClosedPiper PA-24 · Mariposa, CANTSB FTW78FA075Accident · 1 fatalClosedDouglas DC-7C · Farmersville, LANTSB SEA78FA061Accident · 2 fatalClosedPiper J3 · Lynden, WANTSB OAK78FA047Accident · 1 fatalClosedPiper PA-28R · Auburn, CANTSB OAK78DA046Accident · 1 fatalClosedPiper PA-28 · Fort Ross, CANTSB MIA78FKT77Accident · 1 fatalClosedBeech 65-A80 · South Bay, FLNTSB MIA78FA121Accident · 2 fatalClosedConvair 240 · Clewiston, FLNTSB FTW78FPG85Accident · 1 fatalClosedPiper PA-18A · Lonoke, ARNTSB ANC78FA075Accident · 1 fatalClosedCessna 206 · Twin Lakes, AKNTSB SEA78FA060Accident · 2 fatalClosedPiper J3C · Mccall, IDNTSB NYC78FA087Accident · 1 fatalClosedCessna 150 · Dover, NJNTSB LAX78FA074Accident · 1 fatalClosedBell 47G-3B · Pasadena, CANTSB ANC78FA074Accident · 2 fatalClosedCessna 152 · Anchorage, AKNTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYNTSB DCA78AA021Accident · 4 fatalClosedGrumman G-21A · St Thomas, VINTSB MKC78FA068Accident · 2 fatalClosedLuscombe 8A · Porcupine, SDNTSB IAD78FA104Accident · 2 fatalClosedHughes 269C · Robbinsville, NCNTSB IAD78FA103Accident · 1 fatalClosedBell 47G3 · Grissettown, NCNTSB ANC78FA072Accident · 4 fatalClosedCessna 177RG · Fairbanks, AKNTSB ANC78FA071Accident · 2 fatalClosedPiper PA-18 · Cooper Landing, AKNTSB ANC78FA070Accident · 6 fatalClosedBeech A36 · Ketchikan, AKNTSB UNK78X0134Accident · 10 fatalClosedPiper PA-31 · Las Vegas, NVNTSB SEA78FYM50Accident · 1 fatalClosedMini Coupe Buffum · Independence, ORNTSB LAX78FA072Accident · 2 fatalClosedMooney M20 · Los Angeles, CANTSB FTW78FA073Accident · 4 fatalClosedBell 206B · Intracstl City, LANTSB CHI78FEP64Accident · 2 fatalClosedGrumman AA-1C · Laona, WINTSB LAX78FA071Accident · 4 fatalClosedPiper PA-32 · Laverne, CANTSB CHI78FEX37Accident · 3 fatalClosedBalloon WKS FF 7 · Fishers, INNTSB ANC78FA069Accident · 2 fatalClosedCessna 182Q · Ketchikan, AKNTSB NYC78FA085Accident · 2 fatalClosedMitsubishi MU-2P · Bedford, NHNTSB FTW78FPG83Accident · 1 fatalClosedWeatherly 201C · Elaine, ARNTSB UNK78X0133Accident · 4 fatalClosedDouglas DC-6 · Muscat, MauritiusNTSB MKC78FCJ43Accident · 1 fatalClosedCessna 188 · Grand Island, NENTSB LAX78FA070Accident · 4 fatalClosedBeech 95-B55 · Costa Mesa, CA