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 CHI78FEV08Accident · 1 fatalClosedCessna 150H · Carmi, ILNTSB OAK78FA005Accident · 4 fatalClosedBeech E35 · Willows, CANTSB FTW78FA012Accident · 2 fatalClosedPiper PA-18 · Waldron, ARNTSB ANC78FA003Accident · 2 fatalClosedBrittnorman BN2A-8 · Missing AircraftNTSB MIA78FA014Accident · 2 fatalClosedCessna 150M · Richland, FLNTSB CHI78FA010Accident · 1 fatalClosedPiper PA-28R · Ladoga, INNTSB ANC78FAD01Accident · 1 fatalClosedCessna 150 · Goddard, AKNTSB CHI788A011Accident · 5 fatalClosedBeech P35 · New Salem, INNTSB MIA78FA013Accident · 7 fatalClosedCessna 441 · Greensboro, ALNTSB LAX78FA007Accident · 3 fatalClosedPiper PA-28 · Newport Beach, CANTSB SEA78FA008Accident · 4 fatalClosedCessna 172M · Newport, WANTSB LAX78FA005Accident · 2 fatalClosedBellanca 17-30 · Fullerton, CANTSB DEN78FA007Accident · 2 fatalClosedStinson 108-2 · Hope, NMNTSB NYC78FA006Accident · 2 fatalClosedPorterfield 35W · Ft Devens, MANTSB OAK78FVW03Accident · 1 fatalClosedJeanie Teenie · Boulder City, NVNTSB ANC78FA002Accident · 2 fatalClosedMooney M-20C · Northway, AKNTSB IAD78FA011Accident · 2 fatalClosedPiper PA-32 · Emmitsburg, MDNTSB FTW78FA011Accident · 3 fatalClosedN.American NA-265 · New Orleans, LANTSB DEN78FA006Accident · 2 fatalClosedCessna 182P · Kemmerer, WYNTSB CHI78FA008Accident · 1 fatalClosedCessna 310P · Eagle River, WINTSB NYC78FA007Accident · 3 fatalClosedCessna 180 · Jay, VTNTSB CHI78FA007Accident · 1 fatalClosedCessna 310Q · Watertown, WINTSB NYC78FA005Accident · 5 fatalClosedPiper PA-23 · Claryville, NYNTSB MIA78RA012Accident · 6 fatalClosedCessna 310Q · Freeport, Burkina FasoNTSB MIA78FA011Accident · 1 fatalClosedCessna 150J · Sugarloaf Key, FLNTSB SEA78FA007Accident · 1 fatalClosedPiper PA-28 · Gales Creek, ORNTSB OAK78FA004Accident · 4 fatalClosedCessna 172K · Willits, CANTSB OAK78FA003Accident · 2 fatalClosedPiper PA-28R · Las Vegas, NVNTSB MKC78FA007Accident · 1 fatalClosedCessna 310 · Kansas City, KSNTSB CHI78FA006Accident · 2 fatalClosedCessna 150G · Columbus, OHNTSB FTW78FPJ05Accident · 1 fatalClosedCessna A188B · Thomas, OKNTSB MKC78FA006Accident · 1 fatalClosedCessna 210L · Odessa, MONTSB MIA78FA010Accident · 2 fatalClosedCessna 150L · Inverness, FLNTSB LAX78FA003Accident · 1 fatalClosedCessna 182J · Buckeye, AZNTSB IAD78FA009Accident · 1 fatalClosedCessna 150L · Ash, NCNTSB CHI78FA005Accident · 4 fatalClosedBeech P35 · Francesville, INNTSB NYC78FA004Accident · 2 fatalClosedWaco UPF-7 · Palmyra, NYNTSB FTW78FA008Accident · 1 fatalClosedSchweizer 1-26B · Cedar Hill, TXNTSB CHI78FA004Accident · 5 fatalClosedCessna 180 · Bidwell, OHNTSB MIA77FA009Accident · 2 fatalClosedCessna 182K · Atlanta, GANTSB DEN78FA005Accident · 1 fatalClosedCessna 150G · Kiowa, CONTSB MIA78FKQ03Accident · 1 fatalClosedThrush S2R · Poplarville, MSNTSB MIA78FA008Accident · 2 fatalClosedLet-Np-K L-13 · Pensacola, FLNTSB IAD78FA008Accident · 1 fatalClosedPiper PA-23 · Morganton, NCNTSB SEA78FA005Accident · 2 fatalClosedPiper PA-32 · Troutdale, ORNTSB NYC78FA002Accident · 1 fatalClosedPiper PA-28 · Randolph, NJNTSB NYC78FA001Accident · 4 fatalClosedMooney M20J · Morristown, VTNTSB OAK78FVW01Accident · 2 fatalClosedHoward DGA-6 · Tonopah, NVNTSB MKC78FA005Accident · 1 fatalClosedPiper PA-28 · Lamar, MONTSB FTW78FPJ04Accident · 1 fatalClosedPiper PA-36 · Garber, OK