Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 ATL80FA051Accident · 2 fatalClosedCessna 172 · Salisbury, NCJun 8, 1980 · N8866B · Destroyed NTSB DEN80FA037Accident · 1 fatalClosedGlobe GC-1B · Spanish Fork, UTJun 7, 1980 · N211M · Destroyed NTSB CHI80FA045Accident · 1 fatalClosedPiper PA32RT · South Bend, INJun 6, 1980 · N36839 · Destroyed NTSB LAX80FA105Accident · 2 fatalClosedPiper PA-18 · Newport Beach, CAJun 5, 1980 · N54986 · Destroyed NTSB SEA80FA031Accident · 1 fatalClosedCessna 210L · Harrisburg, ORJun 4, 1980 · N732DX · Destroyed NTSB NYC80FA044Accident · 1 fatalClosedPiper PA-23 · Neptune, NJJun 4, 1980 · N646MA · Destroyed NTSB DEN80FTG12Accident · 1 fatalClosedPiper PA-25 · Englevale, NDJun 3, 1980 · N9706P · Destroyed NTSB NYC80FA043Accident · 3 fatalClosedCessna 172G · Cape May, NJJun 2, 1980 · N3847L · Destroyed NTSB MKC80FA038Accident · 4 fatalClosedPiper PA-28 · Brookville, KSJun 1, 1980 · N9594K · Destroyed NTSB LAX80FA103Accident · 6 fatalClosedCessna T207 · Furnace Creek, CAJun 1, 1980 · N1535U · Destroyed NTSB LAX80FA102Accident · 1 fatalClosedPiper PA-38 · Las Vegas, NVMay 31, 1980 · N2493D · Destroyed NTSB DEN80FTE46Accident · 2 fatalClosedBullen Bede 4 · Colorado Sprgs, COMay 30, 1980 · N8144 · Destroyed NTSB MKC80FA036Accident · 1 fatalClosedCherokee II · So Sioux City, NEMay 28, 1980 · N129V · Substantial damage NTSB LAX80FAMS2Accident · 2 fatalClosedBeech T-34B · Missing AircraftMay 28, 1980 · N34MN · Destroyed NTSB LAX80FA101Accident · 2 fatalClosedMooney M20J · Cajon, CAMay 28, 1980 · N4253H · Destroyed NTSB ATL80FA049Accident · 6 fatalClosedPiper PA-31 · Mobile, ALMay 28, 1980 · N6492L · Destroyed NTSB ANC80FA048Accident · 2 fatalClosedPiper PA-18 · Ninilchik, AKMay 28, 1980 · N4275Z · Destroyed NTSB FTW80FA080Accident · 2 fatalClosedPiper PA-32 · Lakeview, ARMay 27, 1980 · N6535C · Destroyed NTSB LAX80FA100Accident · 1 fatalClosedBeech A36 · Los Banos, CAMay 26, 1980 · N2061S · Destroyed NTSB LAX80FXQ28Accident · 2 fatalClosedCessna 172A · Tahoe City, CAMay 25, 1980 · N7803T · Substantial damage NTSB ATL80FA050Accident · 2 fatalClosedBeech P35 · Bennettsville, SCMay 25, 1980 · N1529Z · Destroyed NTSB MIA80FA065Accident · 3 fatalClosedConvair 240 · Daytona Beach, FLMay 24, 1980 · N300GR · Destroyed NTSB CHI80FA043Accident · 3 fatalClosedMooney M20C · Byron, ILMay 24, 1980 · N9347V · Destroyed NTSB DEN80FA036Accident · 1 fatalClosedCessna TR182 · Wheatland, WYMay 23, 1980 · N738GG · Destroyed NTSB DEN80FA035Accident · 3 fatalClosedMooney 20F · Raynesford, MTMay 23, 1980 · N7068V · Destroyed NTSB CHI80FA042Accident · 2 fatalClosedGrum-Amer AA-1C · Portage, WIMay 23, 1980 · N9524U · Destroyed NTSB CHI80FA041Accident · 4 fatalClosedCessna 172K · Big Fork, MNMay 23, 1980 · N64368 · Destroyed NTSB CHI80DA044Accident · 1 fatalClosedCessna 150 · St Paul, MNMay 23, 1980 · N11960 · No damage NTSB NYC80FA022Accident · 1 fatalClosedMaule 235C · Eagle Lake, MEMay 21, 1980 · N56356 · Destroyed NTSB FTW80FPG29Accident · 1 fatalClosedGrumman G-164B · Minturn, ARMay 21, 1980 · N8128K · Destroyed NTSB DEN80FTC16Accident · 2 fatalClosedCessna R172K · Cheyenne, WYMay 21, 1980 · N758LA · Destroyed NTSB CHI80FA040Accident · 1 fatalClosedCessna 152 · Jerome, MIMay 21, 1980 · N5104B · Destroyed NTSB DCA80AA018Accident · 2 fatalClosedLearjet 25D · Gulf Of Mexico (Gulf of Mexico)May 19, 1980 · N125NE · Destroyed NTSB CHI80FEM25Accident · 1 fatalClosedChampion 7KCAB · Grant, MIMay 19, 1980 · N1635G · Destroyed NTSB SEA80FA029Accident · 1 fatalClosedGrumman G-164B · Cle Elum, WAMay 18, 1980 · N48432 · Destroyed NTSB LAX80FA097Accident · 2 fatalClosedCessna 182P · Seal Beach, CAMay 18, 1980 · N7403Q · Destroyed NTSB DEN80FA034Accident · 1 fatalClosedHughes 500 · Vernal, UTMay 18, 1980 · N58245 · Substantial damage NTSB CHI80FA039Accident · 2 fatalClosedGrumman AA-1 · Sylvania, OHMay 18, 1980 · N5754L · Destroyed NTSB FTW80FA076Accident · 4 fatalClosedCessna 172M · Beasley, TXMay 17, 1980 · N9624Q · Destroyed NTSB NYC80FA041Accident · 1 fatalClosedPiper PA-32 · E.Setauket, NYMay 16, 1980 · N777MD · Substantial damage NTSB FTW80FRA31Accident · 1 fatalClosedCessna A188B · El Campo, TXMay 16, 1980 · N731YK · Destroyed NTSB ATL80FA047Accident · 1 fatalClosedPiper PA-34 · Enterprise, MSMay 16, 1980 · N812DM · Destroyed NTSB ANC80FA045Accident · 1 fatalClosedAeronca 15AC · Wasilla, AKMay 16, 1980 · N1007H · Substantial damage NTSB MIA80FA064Accident · 2 fatalClosedPiaggio P136L1 · Pahokee, FLMay 14, 1980 · N40030 · Destroyed NTSB CHI80FEX17Accident · 1 fatalClosedGR Lakes X2T-1T · Lizton, INMay 10, 1980 · N6187L · Destroyed NTSB CHI80DA037Accident · 1 fatalClosedCessna 172 · Nappanee, INMay 10, 1980 · N3912F · Destroyed NTSB ATL80FA045Accident · 1 fatalClosedCessna 150 · Pikeville, KYMay 10, 1980 · N50931 · Destroyed NTSB SEA80FA028Accident · 1 fatalClosedPiper PA-28 · Imperial, CAMay 9, 1980 · N44725 · Destroyed NTSB NYC80FA040Accident · 4 fatalClosedCessna 411 · Vineland, NJMay 9, 1980 · N4973T · Destroyed NTSB FTW80DA072Accident · 1 fatalClosedBell 206B · Intracstl Cy, LAMay 9, 1980 · N90095 · Substantial damage