Fatal NTSB investigations: Cessna 310F
15 cases on aircraft the registry lists as Cessna 310F. 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
| 1967 | 1 |
|---|---|
| 1969 | 2 |
| 1970 | 2 |
| 1971 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 2001 | 1 |
| 2011 | 1 |
| 2016 | 1 |
| 2022 | 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 ('2074216'))
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 ('2074216'))
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 GAA23WA097Accident · 1 fatalClass 5 · ForeignCessna 310F · Puerto Vallarta, MexicoNTSB CEN16FA172Accident · 1 fatalField investigationFinal reportCessna 310F · North Little Rock, ARThe pilot's failure to promptly feather the left propeller upon the initial loss of engine power shortly after takeoff and his failure to maintain airspeed while maneuvering with one engine inoperative, which resulted in a loss of control at a low altitude.…NTSB ERA11FA102Accident · 1 fatalField investigationFinal reportCessna 310F · Orange, MAThe pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.NTSB LAX01FA152Accident · 1 fatalField investigationFinal reportCessna 310F · Carmel Valley, CAThe in-flight loss of control of the airplane in instrument meteorological conditions for undetermined reasons.NTSB FTW85FA224Accident · 1 fatalField investigationFinal reportCessna 310F · Marfa, TXThe plt experienced a partial pwr loss from the right eng during the takeoff climb and in his haste to circle back and land did not allow the acft to gain alt. He then failed to maintain adequate airspeed and as a result, lost control of the acft and stalled…NTSB DEN82FA002Accident · 3 fatalClosedCessna 310 · Eureka, UTNTSB FTW74AF025Accident · 1 fatalClosedCessna 310F · West Memphis, ARNTSB LAX74AL010Accident · 1 fatalClosedCessna 310F · Buena Park, CANTSB LAX74AL004Accident · 2 fatalClosedCessna 310F · Phoenix, AZNTSB CHI71AC055Accident · 1 fatalClosedCessna 310 · Sidney, OHNTSB CHI71AC030Accident · 3 fatalClosedCessna 310F · Ann Arbor, MINTSB FTW70AF057Accident · 3 fatalClosedCessna 310F · Millington, TNNTSB DEN70A0034Accident · 3 fatalClosedCessna 310F · Elbert, CONTSB OAK69A0052Accident · 4 fatalClosedCessna 310F · Reno, NVNTSB DIA68A0025Accident · 2 fatalClosedCessna 310F · Norfolk, VA