Skip to content

Fatal NTSB investigations: Cessna 310C

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

19642026

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 ('2074210')) 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 ('2074210'))
  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 ('2074210'))
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 CEN10FA493Accident · 2 fatalField investigationFinal reportCessna 310C · Calhan, COThe pilots'failure to maintain control of the airplane which resulted in an inadvertent stall and spin.Aug 23, 2010 · N896H · Substantial damage NTSB CHI93FA267Accident · 4 fatalField investigationFinal reportCessna 310C · Norton, KSThe pilot's failure to maintain aircraft control due to alcohol impairment. Factors which contributed to the accident were: the pilot's intentional flight into adverse weather, fog, and the dark night.Jul 22, 1993 · N339R · Destroyed NTSB FTW92FA022Accident · 2 fatalField investigationFinal reportCessna 310C · Waller, TXThe loss of directional control as result of the velocity minimum control airspeed not being maintained. A factor was that the maneuver was initiated at an inadequate altitude too low for the pilot to recover.Nov 16, 1991 · N6704T · Destroyed NTSB CHI85FA005Accident · 1 fatalField investigationFinal reportCessna 310C · Allegan, MIThe non inst non multi-eng rated pvt plt/owner occupied the rt seat & employed the CFI for ferrying the newly purchased acft. From the start, the flt experienced comm difficulties & a compass system malfunction problem. ARTCC transcripts reveal that ATC was…Oct 7, 1984 · N9715Z · Destroyed NTSB DEN81FA015Accident · 1 fatalClosedCessna 310C · Encampment, WYJan 4, 1981 · N6726T · Destroyed NTSB DEN80FA008Accident · 2 fatalClosedCessna 310 · Tucumcari, NMOct 30, 1979 · N1758H · Destroyed NTSB DEN7LAD004Accident · 1 fatalClosedCessna 310C · Springfield, COJul 14, 1975 · N1774H · Destroyed NTSB LAX75AL008Accident · 2 fatalClosedCessna 310C · Holbrook, AZAug 19, 1974 · N627W · Destroyed NTSB LAX74AL042Accident · 3 fatalClosedCessna 310C · San Diego, CANov 27, 1973 · N1732H · 2 aircraft · Destroyed NTSB IAD74AI018Accident · 4 fatalClosedCessna 310H · Paintsville, KYSep 9, 1973 · N1834H · Destroyed NTSB ANC73AA028Accident · 4 fatalClosedCessna 310C · Missing AircraftOct 16, 1972 · N1812H · Destroyed NTSB MIA73RM013Accident · 5 fatalClosedCessna 310C · Normans Cay, Burkina FasoJul 27, 1972 · N2121T · Destroyed NTSB IAD71AI054Accident · 4 fatalClosedCessna 310C · Dunlo, PAMay 27, 1971 · N1765H · Destroyed NTSB MIA70A0001Accident · 1 fatalClosedCessna 310C · Athens, GAJul 10, 1969 · N6719T · Destroyed NTSB DEN69A0034Accident · 1 fatalClosedCessna 310C · Aspen, COMar 7, 1969 · N1803H · Destroyed NTSB MKC69A0049Accident · 1 fatalClosedCessna 310C · High Hill, MOFeb 5, 1969 · N1792H · Destroyed NTSB DEN69A0029Accident · 2 fatalClosedCessna 310C · Rock Springs, WYDec 25, 1968 · N1872H · Destroyed NTSB SEA69A0024Accident · 1 fatalClosedCessna 310C · Burley, IDOct 17, 1968 · N1761H · Substantial damage NTSB OAK68A0042Accident · 1 fatalClosedCessna 310C · Salinas, CANov 8, 1967 · N6684B · Destroyed NTSB CHI67A0024Accident · 5 fatalClosedCessna 310C · Hebron, OHAug 16, 1966 · N1836H · Destroyed NTSB CHI66A0079Accident · 1 fatalClosedCessna 310C · Chicago, ILMar 29, 1966 · N1878H · Substantial damage NTSB MKC66A0027Accident · 5 fatalClosedCessna 310C · Highmore S, SDOct 18, 1965 · N1802H · Destroyed NTSB LAX65A0080Accident · 1 fatalClosedCessna 310C · Henderson, NVApr 10, 1965 · N12341 · Destroyed NTSB UNK64X0640Accident · 1 fatalClosedCessna 310C · Jetmore, KSFeb 21, 1964 · N6712T · Destroyed