NTSB investigations: Cessna T210M
13 cases on aircraft the registry lists as Cessna T210M, where the first occurrence was “In flight collision with terrain/water”. 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
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1985 | 1 |
| 1986 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2002 | 1 |
Where
Latest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073451', '2073452')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073451', '2073452')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 DEN03FA002Accident · 1 fatalField investigationFinal reportCessna T210M · Laramie, WYthe pilot's improper inflight planning/decision, and his failure to maintain terrain clearance while attempting a low altitude maneuver. Contributing factors were the mountainous terrain, the airplane’s low altitude, and the pilot's lack of total instrument…NTSB CHI94LA226Accident · 2 fatalLimited investigationFinal reportCessna T210M · Beaver Island, MISpatial disorientation of the pilot-in-command due to flight into known instrument meteorological conditions; factors in the accident were the fog and low ceiling.NTSB LAX93FA125Accident · 2 fatalField investigationFinal reportCessna T210M · Coalinga, CAThe pilots inadequate preflight planning and his failure to select a cruise altitude which would ensure adequate terrain clearance during the night cross country. Factors in the accident were: the mountainous nature of the terrain and the dark night light…NTSB DEN91FA048Accident · 1 fatalField investigationFinal reportCessna T210M · Taos, NMThe pilot's decision to initiate flight into freezing rain which resulted in structural icing that exceeded the ability of the aircraft to maintain flight. A factor was: improper deicing.NTSB LAX90FA300Accident · 4 fatalField investigationFinal reportCessna T-210-M · Placerville, CAThe pilot's misidentification of the airport and his failure to select an adequate altitude above the terrain. Factors in the accident were the pilot's disregard for his night time medical limitation and lack of geographic familiarity with the area.NTSB DEN86LA135Accident · No injuriesLimited investigationFinal reportCessna T210M · Erie, COThe plt reports that he remembers going through the checklist on downwind following a short flight from a nearby airport. He does not remember doing a final 'down and green' check and the aircraft was landed gear up.NTSB DEN86LA074Accident · No injuriesLimited investigationFinal reportCessna T210M · Truth Or Conseq, NMAccording to the pilot, during the landing roll he is accustomed to keeping the nose gear off the runway until the ground speed has slowed. The pilot stated he did not check the landing gear condition lights. Upon lowering the nose, the acft propeller and…NTSB LAX86LA022Accident · No injuriesLimited investigationFinal reportCessna 210M · Oakdale, CAThe plt said that he made a 'fairly rapid descent' from a 10,500 ft MSL cruise alt to the airport pattern and experienced a 'painful pressure' in his ears. The plt said he was also wearing a headset. On entry into the pattern, theplt said he 'forgot to lower…NTSB SEA84FA101Accident · 1 fatalField investigationFinal reportCessna T210M · East Sound, WAThe acft collided with steeply upsloping terrain along the NE side of orcas island. The plt had been reportedly flying throughout the puget Sound/pacific nw area for more than 10 years & was familiar with the terrain & associated wx. Several plts located in…NTSB CHI84FA053Accident · 3 fatalField investigationFinal reportCessna T210M · White Lk Twnshp, MIAt about 1600, the acft was taken out of a heated hangar & parked on the ramp for refueling. It remained outside until the plt took off at about 1740 EST. During that time, snow was falling & the temp dropped from 34 to 31 deg. The plt initially contacted the…NTSB LAX83LA369Accident · No injuriesLimited investigationFinal reportCessna T210N · Glennville, CADuring a landing, the acft touched down with the gear retracted. It came to rest with the gear handle in the down position, the amber warning light illuminated, and the gear motor circuit breaker disengaged.NTSB SEA82FYA08Accident · 1 fatalFinal reportCessna T210M · Shoshone, IDThe aircraft crashed in a near level attitude and at a high rate of speed. Neither the seat belt nor shoulder harness was fastened. The pilot's blood alcohol level was 236 mg%.NTSB NYC82FA059Accident · 5 fatalField investigationFinal reportCessna T210M · Williamsport, PAThe acft impacted a mountain about 5 mi sw of the arpt at an elevation of approximately 1,400 ft while executing a missed approach from an ILS approach to rwy 27. The published missed approach procedure requires a climbing right turn to 3,700 ft via a heading…