NTSB investigations: Cessna 310D, CA
15 cases on aircraft the registry lists as Cessna 310D. 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 | 1 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1996 | 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 ('2074212'))
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 ('2074212'))
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 LAX96FA189Accident · 4 fatalField investigationFinal reportCessna 310D · Los Angeles, CAfailure of the pilot to maintain aircraft control due to spatial disorientation. Factors were clouds and dark night light conditions, and the pilot's diverted attention due to a landing gear problem.NTSB LAX87LA328Accident · No injuriesLimited investigationFinal reportCessna 310D · Lancaster, CAThe pilot-in-command (PIC) rprtd that he heard a loud bang during gear retraction after takeoff. By using the convex mirrors mounted on the tip tanks, he determined that the nose gear was hanging. He cycled the landing gear switch several times, but the nose…NTSB LAX86LA157Accident · No injuriesLimited investigationFinal reportCessna 310D · Yermo, CAThe acft collided with rough terrain after an eng failure on takeoff from a private dirt airstrip. The plt indicated that the left eng failed just after liftoff. The acft yawed uncontrolled to the left and drifted off the 30 ft wide strip. The plt aborted the…NTSB LAX80FA039Accident · No injuriesClosedCessna 310D · Irvine, CANTSB LAX78FUG21Accident · No injuriesClosedCessna 310D · Chino, CANTSB OAK76FVM36Accident · Minor injuriesClosedCessna 310D · San Carlos, CANTSB OAK76AP019Accident · 2 fatalClosedCessna 310D · Bishop, CANTSB LAX74FUM15Accident · No injuriesClosedCessna 310D · San Diego, CANTSB LAX72AL003Accident · 2 fatalClosedCessna 310D · Apple Vally, CANTSB OAK71DVA14Accident · No injuriesClosedCessna 310 · Visalia, CANTSB LAX69D0200Accident · No injuriesClosedCessna 310 · Adelanto, CANTSB OAK69D0132Accident · No injuriesClosedCessna 310D · Davis, CANTSB LAX68D0205Accident · No injuriesClosedCessna 310 · Bakersfield, CANTSB OAK66F0028Accident · No injuriesClosedCessna 310D · Porterville, CANTSB UNK64X0298Accident · No injuriesClosedCessna 310D · Compton, CA