NTSB investigations: Cessna 310

6 cases on aircraft the registry lists as Cessna 310, where the first occurrence was “Loss of control - in flight”. 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

19872026

NTSB investigations: Cessna 310 per year, 1987–2026: 6 cases
1987	2
1988	2
1990	1
2007	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074202') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074202')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2074202')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 DFW07FA055Accident · 1 fatalField investigationFinal reportCessna 310 · Jackson, MSThe pilot's loss of control for undetermined reasons.Jan 10, 2007 · N2625H · Destroyed NTSB MIA91FA058Accident · Serious injuriesField investigationFinal reportCessna 310 · New Smyrna Bch, FLThe pilot-in-command/mechanic reversal of the aileron control cables on the sprocket during installation. This resulted in an in flight loss of control on takeoff, uncontrolled descent, and in flight collision with terrain.Dec 29, 1990 · N4808B · Destroyed NTSB LAX88FA230Accident · 4 fatalField investigationFinal reportCessna 310 · Big Bear Lake, CAThe recently certificated multiengine pilot and friends flew to big Bear airport for lunch. The density altitude at the airport was about 8,000 feet. The pilot entered a south downwind leg for runway 07 at the airport following a Mooney 231. Ground witnesses…Jun 23, 1988 · N170R · Destroyed NTSB FTW88FA051Accident · 1 fatalField investigationFinal reportCessna 310 · Conroe, TXThe newly certificated private pilot, who had 55.2 hours total flight experience, was on his initial solo flight in the Cessna 310 model. His flight logbook had been endorsed for solo flight in the aircraft on November 20, 1987. Witnesses observed a rather…Jan 14, 1988 · N3022D · Destroyed NTSB CHI88FA008Accident · 4 fatalField investigationFinal reportCessna 310 · Brownton, MNAcft crashed in open farm field during night dark conditions witness heard loud roar of engs then a hard dull thud and then silence. Angle of impact was near vertical. Engs were buried 8FT and dist of wreckage was confined to within the dimensions of acft.…Oct 20, 1987 · N57DS · Destroyed NTSB NYC87LA211Accident · No injuriesLimited investigationFinal reportCessna 310 · Wrightstown, NJThe instructor (CFI) & multi-eng commercial plt (student) were on a flt for a check-out in the Cessna 310. Drg a single eng go-around, the student increased the pitch attitude excessively & the airspeed decayed. The CFI took control of the acft & increased…Jul 26, 1987 · N5077Y · Substantial damage