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 MKC77FCQ08Accident · 1 fatalClosedBede BD-5G · Newton, KSNTSB FTW77FA016Accident · 1 fatalClosedCessna 182A · Boutte, LANTSB SEA77FA008Accident · 1 fatalClosedPiper PA-28R · Sandpoint, IDNTSB SEA77FA006Accident · 1 fatalClosedBellanca 7GCBC · Geyser, MTNTSB FTW77FA015Accident · 2 fatalClosedPiper PA-11 · Comstock, TXNTSB NYC77FA014Accident · 1 fatalClosedCessna 172M · Conneautville, PANTSB MKC77FA005Accident · 2 fatalClosedChampion 7GCBC · Lincoln, KSNTSB MKC77FA004Accident · 3 fatalClosedPiper PA-18 · Grand Rapids, MNNTSB LAX77FA011Accident · 2 fatalClosedCessna 182 · San Marcos, CANTSB FTW77FA014Accident · 1 fatalClosedCessna 210B · Waelder, TXNTSB FTW77FA013Accident · 1 fatalClosedPiper PA-28 · Rosebud, TXNTSB DEN77FA010Accident · 2 fatalClosedBellanca 17-30A · Taos, NMNTSB CHI77FA007Accident · 1 fatalClosedMooney M20C · Peoria, ILNTSB FTW77DA025Accident · 1 fatalClosedAero Comdr 500-S · Gulf Of Guinea (Atlantic Ocean)NTSB OAK77FA005Accident · 2 fatalClosedCessna 310L · Hawthorne, NVNTSB MKC77FA002Accident · 1 fatalClosedAero Comdr 690A · Independence, KSNTSB MIA77FA010Accident · 3 fatalClosedPiper PA-31 · Tallahassee, FLNTSB OAK77FVG10Accident · 1 fatalClosedCessna T210K · Davis, CANTSB MIA76FA008Accident · 1 fatalClosedCessna 150L · Orlando, FLNTSB IAD77FA013Accident · 3 fatalClosedCessna 310 · Black Mountain, NCNTSB CHI77FEM10Accident · 1 fatalClosedScorpion 2 · Alston, MINTSB MIA77FA009Accident · 3 fatalClosedPiper PA-28 · Beaufort, SCNTSB OAK77FA029Accident · 2 fatalClosedCessna 182L · Bell Station, CANTSB LAX77FA010Accident · 1 fatalClosedAero Comdr 112A · Trabuco Canyon, CANTSB LAX77FA009Accident · 1 fatalClosedBeech 19A · Grand Canyon, AZNTSB UNK77X0101Accident · 5 fatalClosedPiper PA-31T · Shannon Arpt, EINTSB NYC77FA012Accident · 1 fatalClosedPiper PA-22 · Warren Center, PANTSB IAD77FA012Accident · 4 fatalClosedPiper PA-28 · Wise, NCNTSB CHI77FA006Accident · 2 fatalClosedPiper PA-31 · Spring Lake, MINTSB CHI77FA005Accident · 1 fatalClosedTaylorcraft DC0-65 · Belleville, ILNTSB SEA77FA005Accident · 2 fatalClosedCessna 172 · Pendleton, ORNTSB IAD77DA011Accident · 1 fatalClosedBell 47G-2 · Pigeon Forge, TNNTSB FTW77FA011Accident · 1 fatalClosedCessna 150 · Denton, TXNTSB DEN77FA008Accident · 2 fatalClosedPiper PA-24 · Grantsville, UTNTSB LAX77FA008Accident · 1 fatalClosedBeech D-45 · Avalon, CANTSB FTW77FA010Accident · 2 fatalClosedCessna A150M · Cypress, TXNTSB LAX77FA007Accident · 2 fatalClosedCessna 172 · Terminal Islnd, CANTSB NYC77FA008Accident · 1 fatalClosedBeech 35-B33 · Glenville, NYNTSB MIA77FA006Accident · 2 fatalClosedLuscombe 8E · Batesville, MSNTSB NYC77FA007Accident · 2 fatalClosedMooney M20C · Andes, NYNTSB MIA77FA005Accident · 1 fatalClosedCessna R172E · Jonesboro, GANTSB LAX77FA006Accident · 2 fatalClosedCessna 172 · Flagstaff, AZNTSB LAX77FA005Accident · 1 fatalClosedCessna U206 · Joseph City, AZNTSB DEN77FA004Accident · 1 fatalClosedPiper PA-32R · Matheson, CONTSB OAK77FA004Accident · 2 fatalClosedBellanca 8GCBC · Las Vegas, NVNTSB FTW77FA009Accident · 1 fatalClosedCessna 177B · Oklahoma City, OKNTSB SEA77FA004Accident · 1 fatalClosedBeech A36 · Chester, MTNTSB MIA77DA004Accident · 1 fatalClosedBeech E-50 · Missing AircraftNTSB IAD77FA009Accident · 2 fatalClosedBellanca 17-30A · Nakina, NCNTSB OAK77FA003Accident · 1 fatalClosedBeech A36 · Coalinga, CA