NTSB investigations: Cessna T210N
13 cases on aircraft the registry lists as Cessna T210N, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1984 | 1 |
|---|---|
| 1986 | 2 |
| 1987 | 2 |
| 1989 | 1 |
| 1995 | 3 |
| 1997 | 1 |
| 2003 | 2 |
| 2005 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073456')
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\" = 130))
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 ('2073456')
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" = 130))
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 SEA05LA084Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kalispell, MTAn airborne fire which was fueled by leaking hydraulic fluid (the ignition source for the fire was undetermined) from the landing gear hydraulic system located under the cockpit instrument panel due to inadequate maintenance from other maintenance personnel.…NTSB CHI03LA159Accident · No injuriesLimited investigationFinal reportCessna T210N · Tribune, KSThe in-flight separation of the turbocharger exhaust band clamp resulting in an in-flight fire and uncommanded landing gear extension. Also causal was the improper maintenance by unknown personnel.NTSB FTW03FA093Accident · 3 fatalField investigationFinal reportCessna T210N · Mission, TXThe pilot's failure to maintain aircraft control, which resulted in his exceeding the airplane's design limitation. Contributing factors were the pilot's decision to fly the airplane with known deficiencies with the attitude indicator, and the failure of the…NTSB LAX97FA143Accident · 2 fatalField investigationFinal reportCessna T210N · Grand Canyon, AZThe pilot's failure to maintain aircraft control due to spatial disorientation and his lack of proficiency in conducting instrument flight. Contributing were the inoperative alternator, cockpit lighting, and vacuum system.NTSB SEA95LA200Accident · No injuriesLimited investigationFinal reportCessna 210 · Sunriver, ORThe failure of the landing gear hydraulic drive motor.NTSB NYC95FA129Accident · 2 fatalField investigationFinal reportCessna T210N · Monkton, VTfailure of the pilot to maintain sufficient altitude or clearance from mountainous terrain. Factors related to the accident were: loss of electrical power for undetermined reason(s), darkness, and the mountainous terrain.NTSB CHI95LA096Accident · No injuriesLimited investigationFinal reportCessna T210N · Rockford, ILA disconnect of the alternator belt, and failure of the pilot to attain a down and locked condition of the gear with the emergency extension system.NTSB LAX89LA223Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Herlong, CAFuel starvation, after the pilot diverted his attention to an electrical problem, and his failure to reposition the fuel selector switch, either before the engine lost power or during emergency procedures. Factors related to the accident were: the tripped…NTSB MIA88LA030Accident · No injuriesLimited investigationFinal reportCessna T-210N · Tallahassee, FLDuring ldg gear extension plt did not get safe down indication. Attempts to use emergency extension pump were unsuccessful. Acft was landed nose gear extended main gear retracted. Post accident inspection of the acft revealed the left main gear down lock…NTSB FTW87LA124Accident · No injuriesLimited investigationFinal reportCessna T210N · Tahlequah, OKThe right brake disk separated from the hub when brakes were applied during landing rollout. The aircraft veered left off the runway and into a drainage ditch where the horizontal stabilizer contacted the ground, damaging both of its spars.NTSB SEA86LA191Accident · No injuriesLimited investigationFinal reportCessna T210 · Las Vegas, NVDuring landing roll the aircraft departed the runway to the right despite the pilots attempt to correct with left rudder. The acft struck a ditch and the nose gear separated from the acft. During acft repair the mechanic found the right master cylinder was…NTSB NYC86LA083Accident · No injuriesLimited investigationFinal reportCessna T210N · White Plains, NYDuring the flight the plt noted a full discharge on the ammeter and a open alternator circuit breaker after ATC reported loss of transpx signal. The circuit breaker would not reset. The low voltage light did not come on. He diverted the flight to White Plains…NTSB LAX84LA354Accident · No injuriesLimited investigationFinal reportCessna T210N · Camp Verde, AZThe plt reported that during the landing, the acft rolled about 200 to 250 ft after touchdown, then began veering to the left. He attempted to maintain directional control by applying right rudder & brake, but was unusccessful. The left main gear hit a berm,…