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 NYC77FA022Accident · 2 fatalClosedPiper PA-23 · Danvers, MANTSB OAK77FA008Accident · 2 fatalClosedCessna 150G · Escalon, CANTSB IAD77FA016Accident · 2 fatalClosedBoeing A75 · Crofton, MDNTSB DEN77FA015Accident · 3 fatalClosedGrum Amer AA-1 · Alder, CONTSB CHI77FA016Accident · 1 fatalClosedErco 415-C · Palo, MINTSB OAK77FA007Accident · 4 fatalClosedBeech H-35 · Vacaville, CANTSB ANC77DA018Accident · 2 fatalClosedCessna A185F · Nondalton, AKNTSB FTW77FA023Accident · 2 fatalClosedPiper PA-28 · El Paso, TXNTSB LAX77FA015Accident · 1 fatalClosedPiper PA-23 · Blythe, CANTSB CHI77FEX06Accident · 1 fatalClosedCessna 150G · Patriot, INNTSB CHI77FA015Accident · 2 fatalClosedAeronca 7AC · Freedom, WINTSB FTW77FA022Accident · 1 fatalClosedAmerican AA1B · Oklahoma City, OKNTSB MIA77FA018Accident · 1 fatalClosedGrum Amer AA-1B · Dorado, PRNTSB DCA77AA006Accident · 3 fatalClosedDehavilland DHC-6 · Wildwood, NJNTSB OAK77FJA01Accident · 2 fatalClosedYankee AA1 · Wainiha, HINTSB FTW77FA019Accident · 1 fatalClosedCessna 172H · Houston, TXNTSB DEN77FA013Accident · 1 fatalClosedCessna 120 · Sheridan, WYNTSB CHI77FEV06Accident · 1 fatalClosedHughes 369C · Pontiac, ILNTSB CHI77FA014Accident · 3 fatalClosedCessna 172M · Vandalia, ILNTSB CHI77FA012Accident · 1 fatalClosedCessna 177 · Harrison, OHNTSB CHI76FA013Accident · 1 fatalClosedCessna 421B · Winchester, INNTSB FTW77FA020Accident · 3 fatalClosedCessna 182E · Temple, TXNTSB CHI77FA011Accident · 1 fatalClosedCessna 195 · Roanoke, INNTSB OAK77FA015Accident · 2 fatalClosedLockheed PV-1 · Yosemite, CANTSB MIA77FA017Accident · 2 fatalClosedCessna 150J · Opa-Locka, FLNTSB MIA77FA016Accident · 5 fatalClosedPiper PA-23 · Clewiston, FLNTSB MKC77FA007Accident · 3 fatalClosedPiper PA-24 · Kimball, NENTSB LAX77FA014Accident · 5 fatalClosedAerostar 601P · Costa Mesa, CANTSB FTW77FA018Accident · 2 fatalClosedCessna 310 · Bronte, TXNTSB NYC77FA019Accident · 5 fatalClosedPiper PA-34 · Forked River, NJNTSB NYC77FA018Accident · 5 fatalClosedPiper PA-31 · Grand View, NYNTSB LAX77FUJ10Accident · 1 fatalClosedScorpion TOO · Corona, CANTSB LAX77FA016Accident · 2 fatalClosedPiper PA-28R · Scottsdale, AZNTSB CHI77FA010Accident · 1 fatalClosedCessna 150E · Depere, WINTSB MIA77DA015Accident · 2 fatalClosedCessna 337G · Summer Haven, FLNTSB DEN77FA011Accident · 2 fatalClosedPiper PA-32 · Denver, CONTSB ANC77FA012Accident · 2 fatalClosedBeech E90 · Tok, AKNTSB MIA77FA014Accident · 1 fatalClosedPiper J3C · Copeland, FLNTSB LAX77FA012Accident · 1 fatalClosedBell 47J · Glen Ivy, CANTSB IAD77FA015Accident · 4 fatalClosedCessna 210 · Oxford, NCNTSB IAD77FA014Accident · 4 fatalClosedPiper PA-23 · Lexington, KYNTSB NYC77FA016Accident · 3 fatalClosedPiper PA-28 · Westhampton, NYNTSB MIA77FA013Accident · 2 fatalClosedPiper PA-28R · Tallahassee, FLNTSB MIA77FA012Accident · 2 fatalClosedCessna 182P · Savannah, GANTSB DEN77FA012Accident · 2 fatalClosedPiper PA-28 · Farmington, NMNTSB CHI77FA008Accident · 2 fatalClosedCessna 310P · Muskegon, MINTSB SEA77FA007Accident · 4 fatalClosedPiper PA-28R · Kimberly, ORNTSB FTW77FA017Accident · 1 fatalClosedErco 415-C · Little Rock, ARNTSB ANC77DA011Accident · 1 fatalClosedCessna 206 · Kotzebue, AKNTSB NYC77FA015Accident · 1 fatalClosedCessna 150L · Sherburne, VT