NTSB investigations: Cessna 310C, CA
14 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.
Cases per year
| 1965 | 2 |
|---|---|
| 1967 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1989 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2011 | 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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" 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 WPR11LA092Accident · No injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot did not maintain an appropriate descent profile during the approach. Contributing to the accident was that the pilot did not follow checklist procedures.NTSB LAX04LA030Accident · No injuriesLimited investigationFinal reportCessna 310C · Los Angeles, CAThe pilot's misjudgment of distance and speed on the approach resulting in an overrun.NTSB LAX98LA101Accident · Minor injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot's improper use of the mixture controls.NTSB LAX89LA177Accident · No injuriesLimited investigationFinal reportCessna 310C · Jackson, CAThe failure of the instructor pilot (pilot in command) to reject the takeoff after the loss of power on one engine when sufficient runway remained to stop the aircraft. Contributing to the accident was the disregard of the aircraft manual, failure to use the…NTSB LAX83LA127Accident · Minor injuriesLimited investigationFinal reportCessna 310C · San Jose, CAThe plt reported that when he was taking off, he heard a noise, during gear retraction, that sounded to him like an explosion & the gear-up light did not illuminate. He then tried to extend the gear, but was unable to get a safe-down indication. He was able…NTSB LAX81FVM26Accident · No injuriesClosedCessna 310C · Paso Robles, CANTSB LAX79DVD35Accident · No injuriesClosedCessna 310C · Hayward, CANTSB OAK76DVA40Accident · No injuriesClosedCessna 310C · Bakersfield, CANTSB OAK75FVD16Accident · No injuriesClosedCessna 310C · Hayward, CANTSB LAX74AL042Accident · 3 fatalClosedCessna 310C · San Diego, CANTSB LAX70FUG26Accident · No injuriesClosedCessna 310C · Chino, CANTSB OAK68A0042Accident · 1 fatalClosedCessna 310C · Salinas, CANTSB OAK66F0042Accident · No injuriesClosedCessna 310C · San Francisco, CANTSB OAK65F0026Accident · No injuriesClosedCessna 310C · Palo Alto, CA