NTSB investigations: Cessna T210L
14 cases on aircraft the registry lists as Cessna T210L, where the first occurrence was “Loss of control - in flight”. 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
| 1986 | 1 |
|---|---|
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1995 | 2 |
| 1997 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2004 | 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 ('2073449')
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\" = 250))
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 ('2073449')
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" = 250))
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 SEA04FA165Accident · 3 fatalField investigationFinal reportCessna T210L · Tulsa, OKThe pilot's inadequate preflight inspection by his failure to secure the oil cap, which resulted in oil leakage on the windscreen, obstructing his vision, and his failure to maintain adequate airspeed.NTSB CHI03LA076Accident · Minor injuriesLimited investigationFinal reportCessna T210L · New Hudson, MIThe pilot's failure to maintain aircraft control which resulted in the airplane stalling while on final approach.NTSB DEN00FA025Accident · 1 fatalField investigationFinal reportCessna T210L · Elida, NMThe pilot's failure to maintain aircraft control for reasons undetermined. Factors were icing conditions and instrument failure, as reported by the pilot.NTSB MIA97FA095Accident · 3 fatalField investigationFinal reportCessna T210L · Meridianville, ALthe pilot's improper decision to takeoff downwind which resulted in his failure to maintain control of the airplane. The winds were a factor.NTSB FTW95FA401Accident · 1 fatalField investigationFinal reportCessna T210L · Groom, TXLoss of control for unknown reason(s).NTSB SEA95FA095Accident · 6 fatalField investigationFinal reportCessna T210L · Milford, UTthe pilot's continued flight into known adverse weather (icing conditions), and his delay in executing a course reversal to exit those conditions, which resulted in airframe ice accumulation and loss of control. A factor was the icing conditions.NTSB LAX92LA031Accident · No injuriesLimited investigationFinal reportCessna T210L · Van Nuys, CAThe inadvertent loss of control during the initial climb after takeoff that resulted from the collapse of the rudder pedal because of a worn locking pin hole in the rudder pedal stowing system, which allowed the pin to disengage.NTSB DEN91FA017Accident · 4 fatalField investigationFinal reportCessna T210L · Aspen, COImproper planning/decision by the pilot and his failure to maintain adequate airspeed, while turning over high terrain beside the airport, which resulted in an inadvertent stall. Factors related to the accident were: excessive gross weight of the aircraft,…NTSB LAX90LA117Accident · 3 fatalLimited investigationFinal reportCessna T210L · Mesa, AZThe failure of the pilot to follow the airplane checklist and properly configure the airplane for takeoff. Contributing to the accident was the pilot's poor preflight preparation and the failure of the pilot to compute the aircraft weight before takeoff.NTSB LAX89LA226Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Parker Dam, CAImproper planning/decision by the pilot and his failure to obtain wind information before landing. Factors relating to this accident were: the adverse weather conditions.NTSB LAX89FA069Accident · 2 fatalField investigationFinal reportCessna T210L · Norco, CAAccident was that the pilot became disoriented and was unable to arrest the ensuing descending spiraling turn.NTSB SEA87FA190Accident · 3 fatalField investigationFinal reportCessna T210L · Hailey, IDAfter dark night takeoff, acft was observed to execute an immediate left turn up a canyon into rising terrain. During climb, acft lights were seen to perform maneuver characteristic of stall/spin. Investigation showed acft struck terrain slightly nose low. No…NTSB SEA87LA108Accident · No injuriesLimited investigationFinal reportCessna T210L · Dayton, WADuring landing the aircraft floated. The pilot elected to make a go-around but had used up more than one half the runway. Shortly after applying full power the pilot reduced power to idle for landing on a barley field at the departure end of the runway.…NTSB CHI87DEM05Accident · Serious injuriesFinal reportCessna T210L · Lawton, MIThe plt experienced a loss of control shortly after takeoff which resulted in an uncontrolled descent. The acft struck the ground with its left wingtip causing it to flip over onto its side. The plt reported that the auto-plt had been worked on after having…