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 SEA77FYM32Accident · 1 fatalClosedCessna 150M · Independence, ORNTSB MKC77FA023Accident · 4 fatalClosedPiper PA-28 · White Bear Lke, MNNTSB FTW77FA056Accident · 4 fatalClosedCessna 310N · Amarillo, TXNTSB FTW77FA055Accident · 1 fatalClosedBell 47J · Dallas, TXNTSB OAK77FA032Accident · 4 fatalClosedCessna 172M · Lahaina Maui, HINTSB CHI77FA043Accident · 2 fatalClosedPiper PA-23 · Norwalk, OHNTSB CHI77FEK19Accident · 1 fatalClosedSchweizer 1-35 · Derwent, OHNTSB SEA77FA032Accident · 4 fatalClosedPiper PA-23 · Ashland, ORNTSB DCA77AA006Accident · 4 fatalClosedSikorsky S-61L · New York, NYNTSB FTW77FFA22Accident · 1 fatalClosedBoeing E75N1 · Beaumont, TXNTSB FTW77FA054Accident · 1 fatalClosedRyan ST-3KR · San Angelo, TXNTSB DEN77FA043Accident · 1 fatalClosedCessna 182B · Trinidad, CONTSB LAX77FA042Accident · 4 fatalClosedCessna 172 · Dana Point, CANTSB ANC77FA043Accident · 1 fatalClosedBeech C-23 · Dan Creek, AKNTSB IAD77FA040Accident · 1 fatalClosedPiper PA-28 · Alexandria, VANTSB FTW77FF053Accident · 2 fatalClosedCessna 170A · Marion, ARNTSB OAK77FA031Accident · 1 fatalClosedCessna 150L · Gilroy, CANTSB MIA77FKT38Accident · 2 fatalClosedPiccard AX-6 · Miami, FLNTSB OAK77FA030Accident · 1 fatalClosedCessna 320C · Wells, NVNTSB IAD77FA039Accident · 3 fatalClosedPiper PA-31 · Taplin, WVNTSB DEN77FA041Accident · 2 fatalClosedPiper PA-34 · Bigtrails, WYNTSB LAX77FA041Accident · 4 fatalClosedBeech 35 · Huntington Bch, CANTSB SEA77FA031Accident · 2 fatalClosedCessna 182 · Orofino, IDNTSB DEN77FA040Accident · 4 fatalClosedBeech J35 · Lander, WYNTSB NYC77FA055Accident · 2 fatalClosedGR Lakes 2T1A-2 · Milford, NJNTSB SEA77FA030Accident · 1 fatalClosedBeech 58 · Vancouver, WANTSB FTW77FA051Accident · 1 fatalClosedBeech C50 · Utopia, TXNTSB CHI77FA042Accident · 1 fatalClosedBeagle 206S2 · Mendon, MINTSB SEA77FA029Accident · 2 fatalClosedCessna 172N · Newberg, ORNTSB IAD77FLQ12Accident · 1 fatalClosedBeech F35 · Pikeville, KYNTSB DEN77FA039Accident · 1 fatalClosedMooney M20C · Silver Plume, CONTSB MIA77FLG15Accident · 2 fatalClosedStarduster 2 · Camden, SCNTSB DEN77FA037Accident · 2 fatalClosedPiper PA-32 · Englewood, CONTSB DEN77FA038Accident · 2 fatalClosedBellanca 7KCAB · Morgan, UTNTSB IAD77AA038Accident · 4 fatalClosedBeech HS.125 · Mclean, VANTSB OAK77FVG31Accident · 2 fatalClosedAero-Comdr S-2R · Maxwell, CANTSB MKC77FA022Accident · 1 fatalClosedPiper PA-36 · Pierre, SDNTSB CHI77FEI18Accident · 1 fatalClosedVern Board Mini · Lorain, OHNTSB LAX77FA040Accident · 1 fatalClosedCessna 150L · Fullerton, CANTSB OAK77FXQ17Accident · 1 fatalClosedPiper PA-28 · Winnemucca, NVNTSB CHI77FA040Accident · 4 fatalClosedAero Comdr 690A · Chicago, ILNTSB NYC77FA053Accident · 1 fatalClosedBell 47G-4A · Hartsdale, NYNTSB MKC77FA021Accident · 1 fatalClosedCessna 182M · Aberdeen, SDNTSB UNK77X0104Accident · 1 fatalClosedPiper PA-28 · Gruver, TXNTSB SEA78DA046Accident · 2 fatalClosedBeech 23 · Lewiston, MTNTSB LAX77FUA10Accident · 1 fatalClosedPiper PA-28R · Long Beach, CANTSB IAD77FA036Accident · 4 fatalClosedPiper PA-28 · Windsor, NCNTSB IAD77FA035Accident · 1 fatalClosedBeech C23 · Knoxville, TNNTSB FTW77FA049Accident · 5 fatalClosedBeech BE200 · Ruddock, LANTSB MIA77FA055Accident · 1 fatalClosedAeronca C3 · Immokalee, FL