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 FTW81DA133Accident · 3 fatalClosedMooney M20E · Bayside, TXMar 16, 1980 · N7135U · Destroyed NTSB FTW80FAMS4Accident · 3 fatalClosedMooney 720E · Missing AircraftMar 16, 1980 · N7135U · Destroyed NTSB MIA80FKJ26Accident · 1 fatalClosedBenson B8MD · Pensacola, FLMar 15, 1980 · N1743 · Substantial damage NTSB LAX80FA066Accident · 2 fatalClosedCessna 182P · San Andreas, CAMar 15, 1980 · N106JH · Destroyed NTSB LAX80FA065Accident · 5 fatalClosedCessna 414 · Vacaville, CAMar 14, 1980 · N4632G · Destroyed NTSB LAX80FA064Accident · 2 fatalClosedCessna 421B · Tucson, AZMar 14, 1980 · N59RZ · Destroyed NTSB ANC80FA035Accident · 4 fatalClosedCessna A185F · Shaktoolik, AKMar 14, 1980 · N93322 · Substantial damage NTSB LAX80FA068Accident · 2 fatalClosedPiper PA-28 · Chester, CAMar 13, 1980 · N36728 · Destroyed NTSB CHI80FA028Accident · 3 fatalClosedCessna 310H · Indianapolis, INMar 13, 1980 · N1065Q · Destroyed NTSB DEN80FA028Accident · 1 fatalClosedCessna 182RG · Ordway, COMar 11, 1980 · N76064 · Destroyed NTSB NYC80FA027Accident · 1 fatalClosedMooney M20C · Ogdensburg, NJMar 10, 1980 · N7171V · Destroyed NTSB NYC80FA026Accident · 2 fatalClosedBeech 90 · Flushing, NYMar 10, 1980 · N4GN · Destroyed NTSB MIA80FA046Accident · 3 fatalClosedPiper PA-28 · Florence, SCMar 10, 1980 · N1438X · Destroyed NTSB MIA80FA045Accident · 1 fatalClosedPiper PA-23 · Bradley Jct, FLMar 10, 1980 · N6102Y · Destroyed NTSB FTW80FA054Accident · 1 fatalClosedMooney M-18C · Saginaw, TXMar 9, 1980 · N4156 · Destroyed NTSB DEN80FA027Accident · 1 fatalClosedCessna 172M · Englewood, COMar 9, 1980 · N20545 · Substantial damage NTSB LAX80FVD12Accident · 1 fatalClosedPitts S-1S · Tracy, CAMar 8, 1980 · N55TH · Destroyed NTSB IAD80FA030Accident · 4 fatalClosedPiper PA-34 · Pine Mountain, GAMar 7, 1980 · N36074 · Destroyed NTSB MIA80FA044Accident · 3 fatalClosedMooney M20K · Blairsville, GAMar 6, 1980 · N231GQ · Destroyed NTSB MIA80FA042Accident · 5 fatalClosedPiper PA-32R · Ocala, FLMar 6, 1980 · N2543Q · Destroyed NTSB LAX80FA062Accident · 2 fatalClosedCessna 402C · Crescent City, CAMar 6, 1980 · N5718C · Destroyed NTSB FTW80FA052Accident · 1 fatalClosedRockwell 112 · Witt Springs, ARMar 4, 1980 · N1098J · Destroyed NTSB MKC80AA026Accident · 3 fatalClosedAerospatle AS350D · Webster City, IAMar 3, 1980 · N353RM · Destroyed NTSB LAX80FA061Accident · 5 fatalClosedPiper PA-23 · So.Lake Tahoe, CAMar 3, 1980 · N4180P · Destroyed NTSB IAD80FA029Accident · 1 fatalClosedCessna 182K · Hartsville, TNMar 3, 1980 · N48G · Destroyed NTSB MIA80FA040Accident · 1 fatalClosedCessna 310D · Ft.Lauderdale, FLMar 2, 1980 · CFHWT · Destroyed NTSB LAX80FA060Accident · 4 fatalClosedDouglas B-26C · Georgetown, CAMar 2, 1980 · N4204A · Destroyed NTSB MIA80FA039Accident · 2 fatalClosedBell 206B · Kissimmee, FLFeb 29, 1980 · N5015Y · Destroyed NTSB FTW80FA049Accident · 3 fatalClosedBell 212 · Hillsboro, TXFeb 29, 1980 · TPH-04 · Destroyed NTSB MIA80FLT01Accident · 1 fatalClosedCessna 188 · Tunica, MSFeb 27, 1980 · N8148V · Destroyed NTSB IAD80FKM10Accident · 1 fatalClosedStits Playby · China Grove, NCFeb 27, 1980 · N3732 · Destroyed NTSB CHI80FA027Accident · 1 fatalClosedCessna 172XP · Indianapolis, INFeb 26, 1980 · N758HQ · Destroyed NTSB MIA80FA038Accident · 2 fatalClosedCessna 140 · Homestead, FLFeb 25, 1980 · N76663 · Destroyed NTSB LAX80FA058Accident · 2 fatalClosedBellanca 17-31A · Long Beach, CAFeb 25, 1980 · N8853V · Destroyed NTSB SEA80FA020Accident · 3 fatalClosedCessna 172N · Dufur, ORFeb 24, 1980 · N2340E · Destroyed NTSB MIA80FA037Accident · 3 fatalClosedBeech V35 · Valdosta, GAFeb 24, 1980 · N5620S · Destroyed NTSB IAD80FKW09Accident · 1 fatalClosedDer Jagger Wilson · Loudon, TNFeb 24, 1980 · N75BW · Destroyed NTSB IAD80FA027Accident · 1 fatalClosedCessna 150 · Reidland, KYFeb 24, 1980 · N1678Q · Destroyed NTSB MIA80FA036Accident · 2 fatalClosedCessna 210N · Jacksonville, FLFeb 23, 1980 · N6640N · Destroyed NTSB FTW80FA048Accident · 7 fatalClosedMitsubishi MU-2B · New Orleans, LAFeb 23, 1980 · N962MA · Destroyed NTSB LAX80FA057Accident · 1 fatalClosedCessna T337G · Reno, NVFeb 22, 1980 · N1ZQ · Destroyed NTSB CHI80FA026Accident · 4 fatalClosedPiper PA-32 · Ft Wayne, INFeb 22, 1980 · N200BF · Destroyed NTSB MKC80FA024Accident · 2 fatalClosedGrum-Amer AA-5B · Spencer, IAFeb 21, 1980 · N74028 · Destroyed NTSB LAX80FA056Accident · 2 fatalClosedPiper PA-22 · Oxnard, CAFeb 21, 1980 · N4685Z · Destroyed NTSB FTW80FAMS2Accident · 5 fatalClosedBeech A36 · Missing AircraftFeb 21, 1980 · N3154W · Destroyed NTSB FTW80FA106Accident · 5 fatalClosedBeech A36 · Taos, NMFeb 21, 1980 · N3154W · Destroyed NTSB FTW80FA045Accident · 6 fatalClosedSikorsky S-62A · Leeville, LAFeb 21, 1980 · N442Y · Destroyed NTSB FTW80FA046Accident · 5 fatalClosedPiper PA-32 · Ardmore, OKFeb 20, 1980 · N56482 · Destroyed NTSB LAX80FA059Accident · 4 fatalClosedCessna 182G · Grand Canyon, AZFeb 19, 1980 · N2350R · Destroyed NTSB IAD80FA026Accident · 2 fatalClosedBeech 95-B55 · Cumming, GAFeb 19, 1980 · N88LR · Destroyed