Skip to content

NTSB investigations: Cessna 210A, CA

21 cases on aircraft the registry lists as Cessna 210A. 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 ('2073408')) 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 ('2073408'))
  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 ('2073408'))
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 LAX05LA251Accident · No injuriesLimited investigationFinal reportCessna 210A · San Diego, CAThe pilot's failure to ensure that the landing gear was fully extended prior to landing. A contributing factor was the pilot's diverted attention.Jul 31, 2005 · N9468X · Substantial damage NTSB LAX01FA194Accident · 3 fatalField investigationFinal reportCessna 210A · Escondido, CAthe pilot's spatial disorientation and lack of instrument flight proficiency that resulted in a loss of directional control and the airplane's subsequent in-flight collision with the ground.May 28, 2001 · N9462X · Destroyed NTSB LAX97LA001Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Truckee, CAa total loss of engine power for undetermined nonmechanical reasons.Oct 11, 1996 · N9403X · Substantial damage NTSB LAX93LA363Accident · No injuriesLimited investigationFinal reportCessna 210A · Salinas, CAAn undetermined loss of engine power during the final approach phase of landing resulting in a collision with terrain during the forced landing.Jul 25, 1993 · N9520X · Substantial damage NTSB LAX88LA039Accident · No injuriesLimited investigationFinal reportCessna 210A · San Luis Obispo, CAWhile approaching the arpt the plt stated that he slipped the acft from 1800 feet to 1400 feet, leveled the wings, still descending, and entered the pattern at 1200 feet. While on final approach the engine quit. Unable to land on the rwy, the plt landed in a…Nov 12, 1987 · N9505X · Substantial damage NTSB LAX83LA039Accident · No injuriesLimited investigationFinal reportCessna 210 · El Monte, CAThe pilot experienced a problem directly after takeoff when he discovered the landing gear would not retract. After continually trying to lock the gear in place, he executed an emergency landing. Investigation revealed a malfunction in the hydraulic power…Nov 26, 1982 · N9504X · Substantial damage NTSB LAX83LA018Accident · No injuriesLimited investigationFinal reportCessna 210 · Chico, CAThe pilot reported that he failed to extend the landing gear in the traffic pattern. Subsequently, the plane was damaged during a wheels up landing.Oct 20, 1982 · N6583X · Substantial damage NTSB LAX82FUG16Accident · 2 fatalFinal reportCessna 210A · Lake Havasu, CAThe pilot and passenger departed Lake Havasu airport. Following takeoff, the aircraft turned west and crossed the lake and shortly thereafter impacted the ground. There were no witnesses to the accident. The weather at the time of the accident was clear sky,…Sep 7, 1982 · N6652X · Destroyed NTSB LAX78FUG11Accident · Minor injuriesClosedCessna 210A · La Verne, CAJan 8, 1978 · N6636X · Substantial damage NTSB OAK75FVA64Accident · Minor injuriesClosedCessna 210A · Porterville, CAMay 22, 1975 · N9462X · Substantial damage NTSB OAK75FVG27Accident · No injuriesClosedCessna 210A · Sacramento, CASep 4, 1974 · N6615X · Substantial damage NTSB LAX72FUG06Accident · Serious injuriesClosedCessna 210A · Claremont, CAJul 23, 1971 · N9529X · Substantial damage NTSB OAK71DVA05Accident · No injuriesClosedCessna 210A · Modesto, CAJul 3, 1970 · N9512X · Substantial damage NTSB OAK68D0167Accident · No injuriesClosedCessna 210 · San Bruno, CASep 18, 1967 · N9511X · Substantial damage NTSB LAX68F0018Accident · No injuriesClosedCessna 210A · San Clemente, CAMay 29, 1967 · N6653X · Substantial damage NTSB LAX67D0181Accident · No injuriesClosedCessna 210 · Imperial, CAOct 29, 1966 · N9496X · Substantial damage NTSB LAX66D0336Accident · No injuriesClosedCessna 210 · Hemet, CAApr 19, 1966 · N6619X · Substantial damage NTSB OAK66D0106Accident · No injuriesClosedCessna 210 · Nut Tree, CAOct 15, 1965 · N9484X · Substantial damage NTSB UNK65X0444Accident · No injuriesClosedCessna 210 · Torrance, CAOct 26, 1964 · N6602X · Substantial damage NTSB UNK64X1504Accident · 2 fatalClosedCessna 210A · Santa Cruz, CAApr 28, 1964 · N9498X · Destroyed NTSB UNK64X0769Accident · No injuriesClosedCessna 210 · Palm Spring, CAMar 1, 1964 · N9443X · Substantial damage