Skip to content

NTSB investigations: Cessna 210D, CA

25 cases on aircraft the registry lists as Cessna 210D. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('2073414')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2073414'))
  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 ('2073414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR19LA166Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Romona, CAA total loss of engine power due to oil starvation as a result of the failure of an oil filter adapter fiber gasket.Jun 10, 2019 · N3997Y · Substantial damage NTSB WPR13LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · San Rafael, CAThe loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Nov 20, 2012 · N3919Y · Substantial damage NTSB LAX99LA140Accident · Minor injuriesLimited investigationFinal reportCessna 210D · El Monte, CAA loss of engine power due to the fatigue failure of the mixture control cable, which was due to the improper installation and adjustment of the cable 99 hours prior to the accident.Apr 5, 1999 · N2340F · Substantial damage NTSB LAX82DA139Accident · No injuriesFinal reportCessna 210D · N. South Lake T, CAAfter takeoff, the pilot made a normal climb to about 8500 ft. he then noticed indications of higher than normal EGT and fuel pressure and a lower than normal fuel flow. The pilot reported that he had leveled off and throttled back when the engine began to…Apr 17, 1982 · N3972Y · Destroyed NTSB LAX73DUG36Accident · No injuriesClosedCessna 210D · Big Bear, CAFeb 17, 1973 · N3844Y · Substantial damage NTSB LAX72FUQ61Accident · Minor injuriesClosedCessna 210D · Lancaster, CAFeb 12, 1972 · N3772Y · Substantial damage NTSB OAK71AP015Accident · 2 fatalClosedCessna 210D · Bass Lake, CASep 13, 1970 · N2310F · Destroyed NTSB OAK70FVW21Accident · No injuriesClosedCessna 210D · Furnace Ck, CAJun 11, 1970 · N3901Y · Substantial damage NTSB OAK70DVG16Accident · No injuriesClosedCessna 210D · Tulelake, CAMay 17, 1970 · N3805Y · Substantial damage NTSB LAX70F0136Accident · No injuriesClosedCessna 210D · Chino, CASep 16, 1969 · N3857Y · Substantial damage NTSB OAK69D0191Accident · No injuriesClosedCessna 210D · Oakland, CANov 23, 1968 · N3925Y · Substantial damage NTSB OAK69D0231Accident · No injuriesClosedCessna 210D · Tule Lake, CAJul 13, 1968 · N3726Y · Substantial damage NTSB OAK68D0218Accident · No injuriesClosedCessna 210 · Red Bluff, CANov 5, 1967 · N3872Y · Substantial damage NTSB OAK68D0040Accident · No injuriesClosedCessna 210D · Hayward, CAJun 25, 1967 · N3895Y · Substantial damage NTSB OAK67D0330Accident · No injuriesClosedCessna 210 · Rio Vista, CAApr 14, 1967 · N3895Y · Substantial damage NTSB OAK67D0223Accident · No injuriesClosedCessna 210D · Sonora, CAJan 15, 1967 · N3884Y · Substantial damage NTSB OAK66D0299Accident · No injuriesClosedCessna 210C · Al Tahoe, CAApr 15, 1966 · N3961Y · Substantial damage NTSB OAK66F0272Accident · No injuriesClosedCessna 210D · San Carlos, CAApr 1, 1966 · N3925Y · Substantial damage NTSB OAK66D0166Accident · No injuriesClosedCessna 210 · Tracy, CADec 17, 1965 · N3805Y · Substantial damage NTSB LAX66F0154Accident · No injuriesClosedCessna 210 · Van Nuys, CAOct 22, 1965 · N3785Y · Substantial damage NTSB OAK66F0078Accident · No injuriesClosedCessna 210D · Fresno, CASep 21, 1965 · N3731Y · Substantial damage NTSB OAK66F0089Accident · No injuriesClosedCessna 210 · Al Tahoe, CASep 6, 1965 · N3961Y · Substantial damage NTSB OAK65F0048Accident · No injuriesClosedCessna 210 · Tracy, CAApr 19, 1965 · N3805Y · Substantial damage NTSB LAX65F0046Accident · Minor injuriesClosedCessna 210 · San Diego, CAApr 14, 1965 · N3799Y · Substantial damage NTSB UNK64X2150Accident · No injuriesClosedCessna 210 · Porterville, CAJun 6, 1964 · N3920Y · Substantial damage