Fatal NTSB investigations: Cessna 310H
15 cases on aircraft the registry lists as Cessna 310H. 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.
Cases per year
| 1964 | 2 |
|---|---|
| 1967 | 2 |
| 1976 | 2 |
| 1980 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2013 | 1 |
| 2015 | 1 |
Where
Latest cases
Query with SQL
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 ('2074220'))
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 ('2074220'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN15FA400Accident · 4 fatalField investigationFinal reportCessna 310H · Silverton, COThe noninstrument-rated pilot's improper judgment and his failure to maintain situational awareness, which resulted in the flight's encounter with instrument meteorological conditions and controlled flight into terrain during cruise flight.NTSB ERA13FA133Accident · 3 fatalField investigationFinal reportCessna 310H · Yeehaw Junction, FLThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions and his subsequent spatial disorientation. Contributing to the accident was the copilot's improper evaluation of the weather…NTSB LAX98FA118Accident · 3 fatalField investigationFinal reportCessna 310H · Corona, CAThe failure of both pilots to maintain an adequate visual lookout and to see and avoid the other airplane.NTSB LAX94FA355Accident · 1 fatalField investigationFinal reportCessna 310H · Reno, NVThe pilot's failure to maintain minimum control airspeed.NTSB LAX93FA300Accident · 6 fatalField investigationFinal reportCessna 310H · Lancaster, CAthe pilot's improper in-flight planning/decision and his failure to maintain the minimum control airspeed which progressed to an inadverent stall/spin. Factors relating to this accident were fuel exhaustion and the pilot's lack of experience in the accident…NTSB FTW85FA211Accident · 1 fatalField investigationFinal reportCessna 310H · Avinger, TXThe pilot stated he was flying low over the lake surface. He felt a decelaration to the right and the next thing he was in the water. Witnesses saw the aircraft over the lake at a low altitude and saw the right wing impact the water and cartwheel to the right…NTSB NYC85FA098Accident · 1 fatalField investigationFinal reportCessna 310H · Ronkonkoma, NYThe aircraft deeparted runway 33L and climbed to about 500 feet AGL with the landing gear down. Near the departure end of runway 33L the aircraft banked right and spiraled to the ground and crashed.NTSB DEN84FA223Accident · 3 fatalField investigationFinal reportCessna 310H · Questa, NMThe acft collided with rising terrain at the 12500 ft level. The summit was about 200 ft above the crash site. A friend of the plt was interviewed by the iic from NTSB. This friend was the host of the 3 accident victims for the weekend at his gunnison ranch.…NTSB CHI80FA028Accident · 3 fatalClosedCessna 310H · Indianapolis, INNTSB CHI76AC063Accident · 1 fatalClosedCessna 310H · Richland City, INNTSB FTW76AF090Accident · 3 fatalClosedCessna 310 · Ardmore, OKNTSB FTW68A0055Accident · 1 fatalClosedCessna 310H · Alpine, TXNTSB CHI68A0030Accident · 2 fatalClosedCessna 310H · Coal Valley, ILNTSB UNK64X3161Accident · 6 fatalClosedCessna 310H · Manhatn Beach, CANTSB UNK64X0795Accident · 1 fatalClosedCessna 310H · Lake Jackson Tex, TX