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 OAK78DA032Accident · 3 fatalClosedCessna 182Q · Weber Peak, CANTSB NYC78FA054Accident · 4 fatalClosedCessna 402B · Trenton, MENTSB DEN78FA044Accident · 4 fatalClosedBeech 36 · Granite, CONTSB MIA78FA085Accident · 1 fatalClosedAmer Avco AA-1B · Clearwater, FLNTSB LAX78FUG26Accident · 1 fatalClosedSchleicher ASW-12 · Hemet, CANTSB IAD78FA061Accident · 1 fatalClosedBeech C23 · The Plains, VANTSB DEN78FA042Accident · 2 fatalClosedBellanca 8GCBC · Nunn, CONTSB CHI78FA039Accident · 3 fatalClosedPiper PA-31T · Pellston, MINTSB MKC78FA037Accident · 2 fatalClosedBeech F35 · East Prairie, MONTSB MIA78FLD44Accident · 1 fatalClosedMaule M5220C · Holopaw, FLNTSB MIA78FA084Accident · 3 fatalClosedPiper PA-23 · Oldsmar, FLNTSB IAD78FA062Accident · 1 fatalClosedCessna 182Q · Linville, NCNTSB NYC78FA052Accident · 3 fatalClosedPiper PA-32 · Lawrence, MANTSB LAX78FA047Accident · 1 fatalClosedVolpar C-45H · Lake Elsinore, CANTSB ANC78FA037Accident · 1 fatalClosedPiper PA-12 · Anchorage, AKNTSB FTW78FRG39Accident · 3 fatalClosedDehaviland DHC-3 · Del Rio, TXNTSB FTW78FQG29Accident · 1 fatalClosedHughes 369HS · Brownfield, TXNTSB DCA78AA012Accident · 3 fatalClosedBoeing 727 · Pensacola, FLNTSB SEA78FA028Accident · 1 fatalClosedCessna 210G · Tumwater, WANTSB NYC78FA048Accident · 2 fatalClosedAerospatle 330J · Atlantic City (Atlantic Ocean)NTSB MIA78FA078Accident · 3 fatalClosedPiper PA-28 · Jekyll Island, GANTSB FTW78FA044Accident · 4 fatalClosedCessna 182C · Dobbin, TXNTSB MIA78FA077Accident · 2 fatalClosedHamilton T-28A · Huntsville, ALNTSB SEA78FA027Accident · 2 fatalClosedBeech 35C33 · Vancouver, WANTSB LAX78FA046Accident · 1 fatalClosedCessna T210M · Salome, AZNTSB DEN78FA043Accident · 2 fatalClosedBellanca BL-J4 · Carrizozo, NMNTSB DEN78FA040Accident · 4 fatalClosedBeech D50C · Wheatland, WYNTSB OAK78FVG29Accident · 1 fatalClosedBoeing A-75N1 · Robbins, CANTSB LAX78FUJ51Accident · 1 fatalClosedKr-1 · Yuma, AZNTSB CHI78FA038Accident · 4 fatalClosedBeech 35 · Middletown, OHNTSB NYC78FA047Accident · 2 fatalClosedCessna 150 · Mantoloking, NJNTSB MKC78FA036Accident · 1 fatalClosedBeech UC45J · Spiritwood, NDNTSB MIA78FA075Accident · 3 fatalClosedLockheed 18-56 · Durbin, FLNTSB LAX78FA045Accident · 1 fatalClosedBeech S35 · Palmdale, CANTSB CHI78FA037Accident · 1 fatalClosedCessna 182G · Berrien Spring, MINTSB MIA78FA076Accident · 2 fatalClosedBeech D-18S · Ocala, FLNTSB MIA78DA083Accident · 1 fatalClosedCessna 172 · Missing AircraftNTSB ANC78FA034Accident · 1 fatalClosedPiper PA-18 · Homer, AKNTSB ANC78FA033Accident · 2 fatalClosedCrosswinds PA-18 · Birchwood, AKNTSB ANC78DA035Accident · 1 fatalClosedMaule M4210C · Bethel, AKNTSB OAK78FA030Accident · 1 fatalClosedBeech C23 · Independence, CANTSB NYC78FHA21Accident · 1 fatalClosedBensen B8M · Pittstown, NJNTSB NYC78FA046Accident · 1 fatalClosedPiper PA-28 · Danbury, CTNTSB NYC78FA045Accident · 1 fatalClosedChampion 7ECA · Shenango Twp, PANTSB MKC78FA035Accident · 2 fatalClosedVultee BT-13 · Augusta, KSNTSB MKC78FA034Accident · 5 fatalClosedBeech S-35 · Audubon, IANTSB LAX78FUQ23Accident · 1 fatalClosedMakurat 5-BX · Lompoc, CANTSB SEA78FYE20Accident · 1 fatalClosedBensen G-1D · Tacoma, WANTSB OAK78FVG26Accident · 1 fatalClosedPiper PA-28R · Alturas, CANTSB OAK78FA038Accident · 6 fatalClosedCessna T210H · Reno, NV