Fatal NTSB investigations: Cessna 310K
14 cases on aircraft the registry lists as Cessna 310K. 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 2 |
| 1987 | 1 |
| 1989 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1998 | 1 |
| 2004 | 1 |
Where
Open the mapLatest 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 ('2074228'))
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 ('2074228'))
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 LAX05FA011Accident · 1 fatalField investigationFinal reportCessna 310K · Kula, HIThe failure of the pilot to maintain adequate clearance from mountainous terrain during cruise flight. A factor in the accident was the dark night lighting conditions.NTSB LAX98FA296Accident · 2 fatalField investigationFinal reportCessna 310K · Saugus, CAthe pilot's in-flight loss of control which led to a subsequent structural airframe failure as the pilot exceeded the design stress limits of the airplane during an attempted recovery.NTSB FTW94FA091Accident · 4 fatalField investigationFinal reportCessna 310K · Wichita Falls, TXWas the loss of control due to the pilot's spatial disorientation following a complete electrical system failure. Factors were the dark night and the electrical failure as result of burned out wiring terminal.NTSB ATL93FA008Accident · 4 fatalField investigationFinal reportCessna 310K · East Point, GAThe pilot's mismanagement of the fuel supply which resulted in fuel stravation of both engines.NTSB NYC92FA067Accident · 1 fatalField investigationFinal reportCessna 310K · Unionville, PAThe pilot did not follow the published IFR procedures and allowed the airplane to descend to an altitude insufficient to clear the terrain. Factors which contributed to the accident were: the pilot's apprehension due to the low fuel state, the dark night,…NTSB LAX89FA319Accident · 2 fatalField investigationFinal reportCessna 310K · Ojai, CAThe pilot-in-command's intentional VFR flight into instrument meteorological weather conditions, and his failure to maintain adequate altitude to provide terrain clearance. Contributing factors were: the mountainous terrain, adverse weather conditions, and…NTSB MIA88FA003Accident · 4 fatalField investigationFinal reportCessna 310K · Inverness, FLWitnesses stated that the plt initiated a go around at the runway 19 threshold, broke off to the right & went behind a tree line in a 60 degree right bank. On the other side of the tree line the acft was observed to strike the trees with the left wing and…NTSB FTW84FA082Accident · 1 fatalField investigationFinal reportCessna 310K · Hodgen, OKThe plt had purchased the acft at rexburg, id on the day of the accident. Reportedly, the previous owner had flown with the plt, before the plt departed rexburg, and said he had flown the acft very well. The previous owner stated that the DME was not…NTSB FTW83FA117Accident · 1 fatalField investigationFinal reportCessna 310K · Andrews, TXThe plt had received a wx briefing for a flt to miland, TX. A witness reported that after taking off, he made 2 or 3 touch-and-go landings. During takeoff from the last touch-and-go, witnesses observed the acft pull up abruptly, enter a steep right bank, then…NTSB ATL82FA023Accident · 2 fatalClosedCessna 310K · Gainsville, GANTSB DEN81FA011Accident · 2 fatalClosedCessna 310K · Boulder, CONTSB IAD79FA069Accident · 2 fatalClosedCessna 310K · Cresaptown, MDNTSB DEN72AD023Accident · 4 fatalClosedCessna 310K · Ramah, NMNTSB NYC71AN015Accident · 1 fatalClosedCessna 310K · Woodstock, NY