Skip to content

Fatal NTSB investigations: Cessna 310D

23 cases on aircraft the registry lists as Cessna 310D. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

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' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074212')) 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'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074212'))
  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'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074212'))
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 ERA25FA086Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310 · Peebles, OHOn December 30, 2024, about 1515 eastern standard time, a Cessna 310D, N6979T, was substantially damaged when it was involved in an accident near Peebles, Ohio. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Dec 30, 2024 · N6979T · Substantial damage NTSB CEN23FA173Accident · 1 fatalClass 3 · FieldFinal reportCessna 310D · Ennis, TXThe partial loss of right engine power due to reduced fuel flow as a result of the contamination of the fuel screen.May 6, 2023 · N6798T · Destroyed NTSB NYC06FA162Accident · 2 fatalField investigationFinal reportCessna 310D · Sutton, WVThe pilot's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/mush. A factor associated with the accident was the inadvertent stall/mush.Jun 30, 2006 · N6867T · Destroyed NTSB DEN03FA068Accident · 3 fatalField investigationFinal reportCessna 310D · Provo, UTfailure of the student to maintain aircraft control. Contributing factors were the instructor's inattention to the fuel supply, fuel exhaustion, an inadvertent stall/spin during the turn from base leg to final approach. and the instructor's inadequate…Apr 17, 2003 · N6861T · Destroyed NTSB LAX96FA189Accident · 4 fatalField investigationFinal reportCessna 310D · Los Angeles, CAfailure of the pilot to maintain aircraft control due to spatial disorientation. Factors were clouds and dark night light conditions, and the pilot's diverted attention due to a landing gear problem.May 4, 1996 · N6780T · Destroyed NTSB CHI92FA257Accident · 3 fatalField investigationFinal reportCessna 310D · Crystal, MNThe pilot's failure to maintain aircraft control during takeoff/initial climb in gusty, shifting crosswind conditions.Aug 29, 1992 · N6908T · Destroyed NTSB NYC80FAMS1Accident · 2 fatalClosedCessna 310 · Missing AircraftJul 15, 1979 · N181D · Destroyed NTSB MIA76AM110Accident · 2 fatalClosedCessna 310D · Daytona Beach, FLSep 25, 1976 · N6859T · Destroyed NTSB IAD76AI066Accident · 1 fatalClosedCessna 310D · Sandston, VAApr 15, 1976 · N871S · Destroyed NTSB OAK76AP019Accident · 2 fatalClosedCessna 310D · Bishop, CAOct 10, 1975 · N818V · Destroyed NTSB FTW75FPM10Accident · 1 fatalClosedCessna 310D · Tulsa, OKOct 16, 1974 · N310F · Substantial damage NTSB MKC75AK010Accident · 2 fatalClosedCessna 310 · Pisgah, IAAug 9, 1974 · N6862T · Destroyed NTSB DEN73AD005Accident · 3 fatalClosedCessna 310D · Denver, COAug 2, 1972 · N771J · Destroyed NTSB CHI72AC095Accident · 3 fatalClosedCessna 310D · Cleveland, OHMay 29, 1972 · N83T · Destroyed NTSB MIA72AM072Accident · 1 fatalClosedCessna 310D · Bear Creek, ALJan 20, 1972 · N6993T · Destroyed NTSB MIA72AM071Accident · 1 fatalClosedCessna 310D · Mableton, GAJan 20, 1972 · N162G · Destroyed NTSB LAX72AL003Accident · 2 fatalClosedCessna 310D · Apple Vally, CAJul 7, 1971 · N6833T · Destroyed NTSB MKC71AK044Accident · 1 fatalClosedCessna 172G · Marshalltown, IAFeb 6, 1971 · N4678L · 2 aircraft · Destroyed NTSB CHI71AC026Accident · 3 fatalClosedCessna 310D · Watertown, WIOct 20, 1970 · N6765T · Destroyed NTSB IAD70AI065Accident · 3 fatalClosedCessna 310D · West Union, WVJun 26, 1970 · N6841T · Destroyed NTSB FTW69A0088Accident · 1 fatalClosedCessna 310 · Somerset, TXJun 8, 1969 · N6784T · Destroyed NTSB NYC66A0005Accident · 4 fatalClosedCessna 310D · 5s Mercersburg, PAJul 11, 1965 · N6735T · Destroyed NTSB CHI66A0006Accident · 2 fatalClosedCessna 310 · Detroit, MIJul 11, 1965 · N6811T · Destroyed