Skip to content

Fatal NTSB investigations: Cessna 310I

16 cases on aircraft the registry lists as Cessna 310I. 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 ('2074224')) 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 ('2074224'))
  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 ('2074224'))
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 ERA20LA132Accident · 1 fatalClass 3 · LimitedFinal reportCessna 310 · Charleston, SCThe pilot’s fuel mismanagement during flight, resulting in a total loss of engine power due to fuel starvation.Mar 21, 2020 · N8080M · Substantial damage NTSB CEN19FA248Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · De Queen, ARA loss of control for reasons that could not be determined based on the available information.Aug 4, 2019 · N310QA · Substantial damage NTSB LAX02FA214Accident · 4 fatalField investigationFinal reportCessna 310I · San Dimas, CAthe pilot's failure to maintain control of the airplane following a loss of power in one engine during takeoff. The reason for the loss of power in the left engine could not be determined. Contributing factors to the accident were the pilot's failure to…Jul 4, 2002 · N8145M · Destroyed NTSB LAX97FA036Accident · 1 fatalField investigationFinal reportCessna 310I · Van Nuys, CAThe pilot's failure to maintain a climb following initiation of a missed approach in fog due to spatial disorientation, and his inadequate training by company personnel. Potential rescue was delayed due to the FAA radar controller's failure to follow…Nov 14, 1996 · N8046M · Destroyed NTSB DEN90FA021Accident · 2 fatalField investigationFinal reportCessna 310I · Provo, UTThe Cessna pilot misjudge his altitude above the water. Contributing factors were: the pilot allowing his attention to be diverted and his lack of visual/depth perception over the calm (glassy) water.Nov 9, 1989 · N145Y · Destroyed NTSB DEN89FA218Accident · 2 fatalField investigationFinal reportCessna 310I · Hesperia, CAThe non-instrument rated pilot continued VFR flight into instrument meteorological conditions (IMC) and misjudged his altitude above the terrain. Contributing factors were: the pilot's lack of instrument experience, pressure induced by his wife (the…Sep 17, 1989 · N8087M · Destroyed NTSB DEN88FA093Accident · 2 fatalField investigationFinal reportCessna 310I · Helena, MTThe acft depd glasgow, Montana, where the passenger (secretary of state for Montana) had been campaigning. Initially, a VFR flt plan had been filed; however, drg arrival at Helena, an IFR flt plan was filed when the plt realized the wx had deteriorated. The…Apr 9, 1988 · N8008M · Destroyed NTSB MKC84FA116Accident · 2 fatalField investigationFinal reportCessna 310I · Fayetteville, ARWhen the plt received a wx briefing at 1012 CST, he was advised that the wx at his destination (Fayetteville, AR) was an estimated 600' overcast, vis 4 mi with light drizzle & fog, but the wx was forcast to begin to improve in about 1 hr. He took off & during…Apr 4, 1984 · N8156M · Destroyed NTSB CHI82FA003Accident · 4 fatalClosedCessna 310I · Hainesville, ILOct 13, 1981 · N8099M · Destroyed NTSB IAD79FA008Accident · 2 fatalClosedCessna 310I · Portland, TNNov 7, 1978 · N8037M · Destroyed NTSB MIA78FA050Accident · 2 fatalClosedCessna 310I · Laurel, MSMar 7, 1978 · N8114M · Destroyed NTSB OAK77DJA09Accident · 5 fatalClosedCessna 310 · Honolulu, HIApr 13, 1977 · N8179M · Destroyed NTSB FTW74AF029Accident · 2 fatalClosedCessna 310I · Euless, TXNov 6, 1973 · N8077M · Destroyed NTSB OAK70AP053Accident · 3 fatalClosedCessna 310 · Beatty, NVApr 27, 1970 · N8164M · Destroyed NTSB DEN69A0040Accident · 6 fatalClosedCessna 310I · Laveta, COMar 22, 1969 · N8011M · Destroyed NTSB NYC66A0026Accident · 2 fatalClosedCessna 310 · Livingstn Manr, NYJul 22, 1965 · N8001M · Destroyed