NTSB investigations: Cessna 310R, OH

10 cases on aircraft the registry lists as Cessna 310R. 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

19802026

NTSB investigations: Cessna 310R, OH per year, 1980–2026: 10 cases
1980	1
1990	2
1992	1
1995	2
2000	1
2004	1
2022	1
2026	1

Where

Open the map

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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074245')) 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.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074245'))
  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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074245'))
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 ERA27LA028Accident · No injuriesClass 4 · LimitedInvestigation openCessna 310R · Dayton, OHNov 2, 2026 · N1297G NTSB ERA23LA018Accident · No injuriesClass 4 · LimitedFinal reportCessna 310 · Middlefield, OHThe pilot’s inadequate fuel planning and inflight fuel management which resulted in exhaustion of his fuel supply and a forced landing.Oct 13, 2022 · N62368 · Substantial damage NTSB NYC04FA123Accident · 1 fatalField investigationFinal reportCessna 310R · Willoughby, OHThe pilot's failure to maintain aircraft control during the initial climb after takeoff. Factors in this accident were clouds and the night conditions.May 15, 2004 · N3161M · Destroyed NTSB NYC00LA083Accident · No injuriesLimited investigationFinal reportCessna 310R · Sandusky, OHThe pilot's decision to land on a runway that was covered with ice and snow, without obtaining current wind information. Factors were the 20-knot tailwind and the snow-covered runway.Feb 18, 2000 · N87341 · Substantial damage NTSB BFO96FA032Accident · 3 fatalField investigationFinal reportCessna 310R · Bellville, OHthe pilot's in-flight loss of aircraft control for undetermined reason(s), which resulted in the airplane exceeding its design stress limitations and an in-flight breakup.Dec 21, 1995 · N1269G · Destroyed NTSB NYC95LA153Accident · No injuriesLimited investigationFinal reportCessna 310R · Columbus, OHA loss of directional control during takeoff for undetermined reasons.Jul 12, 1995 · N1723E · Destroyed NTSB NYC92LA094Accident · No injuriesLimited investigationFinal reportCessna 310R · Cleveland, OHA failure of the left main gear's upper strut housing and down lock link assembly attach point.Jun 2, 1992 · N225SC · Substantial damage NTSB NYC91LA021Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Columbus, OHFailure by pilots of the other aircraft to see and alter taxi path to avoid the standing aircraft.Oct 29, 1990 · N972VJ · 2 aircraft · Minor damage NTSB NYC90LA183Accident · No injuriesLimited investigationFinal reportCessna 310R · Mansfield, OHAn unavoidable collision with a deer while taking off which bent the drag brace and prevented it from locking. Factors related to the accident were the night conditions which reduced the pilots visibility to the illuminated area of the landing lights.Jul 11, 1990 · N3463G · Substantial damage NTSB CHI80FEG12Accident · Serious injuriesClosedCessna 310R · Miamisburg, OHApr 24, 1980 · N5029J · Substantial damage