NTSB investigations: Cessna 310Q, FL

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

19762026

NTSB investigations: Cessna 310Q, FL per year, 1976–2026: 10 cases
1976	2
1978	1
1984	1
1987	1
1993	1
1994	2
1998	1
2016	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" = 'FL' 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 ('2074242')) 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\" = 'FL' 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 ('2074242'))
  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" = 'FL' 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 ('2074242'))
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 ERA16LA252Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Bartow, FLThe pilot's failure to move the fuel selectors to the “main” position in accordance with the Before Landing checklist, which resulted in fuel starvation and the total loss of power of both engines.Jul 11, 2016 · N100CP · Substantial damage NTSB MIA98FA205Accident · 2 fatalField investigationFinal reportCessna 310Q · Port Orange, FLThe pilot's inadequate weather evaluation and his continued visual flight into instrument meteorological conditions which resulted in in-flight collision with trees. A related factor was the fog.Jul 23, 1998 · N8135Q · Destroyed NTSB ATL95FA031Accident · 2 fatalField investigationFinal reportCessna 310Q · St. Augustine, FLThe non-instrument rated pilot's attempted flight into known instrument meteorological conditions which resulted in spatial disorientation and loss of control.Dec 30, 1994 · N30LC · Destroyed NTSB MIA94LA107Accident · No injuriesLimited investigationFinal reportCessna 310Q · West Palm Beach, FLThe pilot-in-command's inadvertent landing with the brakes on, resulting in a bounced landing and his failure to maintain airspeed after a bounced landing which resulted in the aircraft stalling and landing hard.Mar 26, 1994 · N69978 · Substantial damage NTSB MIA93LA114Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Fort Lauderdale, FLThe pilot-in-command's failure to insure the aircraft contained adequate fuel to complete the flight, which resulted in loss of power in both engines due to fuel exhaustion.May 2, 1993 · N7656Q · Destroyed NTSB MIA87IA131Incident · No injuriesIncident investigationFinal reportCessna 310Q · Ft.Lauderdale, FLDuring the landing roll the right main gear collapsed. Inspection of the acft by FAA personnel revealed that this was caused by a twisted torque tube which failed to fully extend the gear.Apr 7, 1987 · N7665Q · Minor damage NTSB MIA84FA157Accident · Minor injuriesField investigationFinal reportCessna 310Q · Keystone Hgts, FLThe acft crashed while the plt was attempting to takeoff from rwy 10, which was not lighted. Tire marks showed that the acft had run off the rwy about 1200 from the threshold. After leaving the rwy, the acft collided with trees before coming to rest. Both…May 1, 1984 · N80GC · Substantial damage NTSB MIA78DKJ44Accident · No injuriesClosedCessna 310Q · Destin, FLJun 3, 1978 · N7600Q · Substantial damage NTSB MIA76DLD73Accident · No injuriesClosedCessna 310 · New Smyrna Bch, FLJul 21, 1976 · N7765Q · Substantial damage NTSB MIA76FKT52Accident · No injuriesClosedCessna 310Q · Homestead, FLFeb 8, 1976 · N7861Q · Substantial damage