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 LAX79FA002Accident · 2 fatalClosedCessna 152 · Scottsdale, AZNTSB SEA79FA001Accident · 2 fatalClosedCessna 150H · Omak, WANTSB ANC79FA001Accident · 1 fatalClosedCessna 180H · Anchorage, AKNTSB DEN79FA002Accident · 2 fatalClosedGrum Amer AA5 · Littleton, CONTSB IAD79FA001Accident · 5 fatalClosedPiper PA-31P · Lexington, KYNTSB NYC79FFJ06Accident · 1 fatalClosedFly Baby JD-1 · Java Center, NYNTSB MIA79DA001Accident · 1 fatalClosedDouglas DC-3 · Ft Walton Bch, FLNTSB LAX79FA001Accident · 1 fatalClosedNavion A · Buena Park, CANTSB IAD79FA018Accident · 1 fatalClosedCessna 152 · Linden, TNNTSB DEN79FQA01Accident · 1 fatalClosedSteen Skyblt · Albuquerque, NMNTSB DEN79FA001Accident · 1 fatalClosedSikorsky S58ET · Steamboat Spgs, CONTSB CHI79FCA01Accident · 2 fatalClosedReplica 1 · Pierron, ILNTSB FTW78FA086Accident · 3 fatalClosedPiper PA-28 · Richland Hills, TXNTSB NYC79FFJ40Accident · 1 fatalClosedVarieze CN-VEZ · Angola, NYNTSB DCA78AA024Accident · 6 fatalClosedBeech D18S · San Juan, PRNTSB NYC79FA009Accident · 3 fatalClosedCessna 310N · Monroe, MANTSB DCA78AA023Accident · 137 fatalClosedBoeing 727 · San Diego, CANTSB CHI78FA070Accident · 1 fatalClosedCessna 150F · Portage, WINTSB LAX78FA079Accident · 2 fatalClosedCessna 182M · Santa Barbara, CANTSB NYC78FHA39Accident · 1 fatalClosedBlanik L-3 · Pittstown, NJNTSB NYC78FHA37Accident · 1 fatalClosedSoneria II · Pipersville, PANTSB IAD78FIA19Accident · 1 fatalClosedPiper PA-28 · Indian Head, MDNTSB FTW78FA085Accident · 7 fatalClosedAero Comdr 500 · Laredo, TXNTSB OAK78FA057Accident · 2 fatalClosedPiper PA-28 · Concord, CANTSB MIA78FA126Accident · 2 fatalClosedCessna 337G · Atlanta, GANTSB MIA78FA128Accident · 4 fatalClosedDouglas DC-3 · Missing AircraftNTSB SEA78FYK24Accident · 1 fatalClosedCallair B-1A · Glide, ORNTSB NYC78FA097Accident · 1 fatalClosedCessna 172M · Windsor Locks, CTNTSB SEA78FA066Accident · 4 fatalClosedPiper PA-28 · Hall, MTNTSB MIA78FA125Accident · 1 fatalClosedPiper E-2 · Fernandina, FLNTSB NYC78FA095Accident · 2 fatalClosedPiper PA-31 · Granville, MANTSB FTW78FA081Accident · 5 fatalClosedBeech 35 · Kerrville, TXNTSB ANC78FA079Accident · 1 fatalClosedMaule M-5 · Sterling, AKNTSB ANC78DA081Accident · 3 fatalClosedCessna 411 · Missing AircraftNTSB OAK78FA054Accident · 2 fatalClosedGrum Amer AA-1C · Bear Valley, CANTSB OAK78DA055Accident · 2 fatalClosedN.American SNJ-4 · Reno, NVNTSB NYC78FA093Accident · 2 fatalClosedCessna R172K · Venice Center, NYNTSB NYC78FA092Accident · 5 fatalClosedPiper PA-32R · Robbinsville, NJNTSB NYC78FA094Accident · 1 fatalClosedCessna 182 · Dupont, PANTSB IAD78FKM25Accident · 1 fatalClosedBensen B8 · Salisbury, NCNTSB ANC78FA082Accident · 1 fatalClosedAeronca 7EC · Fairbanks, AKNTSB SEA78FA065Accident · 1 fatalClosedPiper PA-28 · Rainier, ORNTSB OAK78FA052Accident · 3 fatalClosedBellanca 17-31A · San Jose, CANTSB ANC78FA078Accident · 6 fatalClosedDehavilland DHC-2 · Whittier, AKNTSB FTW78FA079Accident · 2 fatalClosedPiper J3C · Ferris, TXNTSB SEA78FA064Accident · 1 fatalClosedCessna 185F · Riggins, IDNTSB NYC78FA091Accident · 3 fatalClosedAero Comdr 500S · Hammondsport, NYNTSB MKC78FA069Accident · 2 fatalClosedLuscombe 8A · Fayette, MONTSB MIA78FA123Accident · 1 fatalClosedCessna 172N · Gautier, MSNTSB CHI78FA066Accident · 1 fatalClosedBrantley B-2B · Brook, IN