NTSB investigations: Cessna T210L, OR
13 cases on aircraft the registry lists as Cessna T210L. 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
| 1976 | 1 |
|---|---|
| 1977 | 2 |
| 1978 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 2007 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 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.\"eventStateOrRegion\" = 'OR' 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 ('2073449'))
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" = 'OR' 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 ('2073449'))
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 WPR19LA165Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210 · Medford, ORA total loss of engine power due to fuel starvation.NTSB WPR18LA057Accident · No injuriesLimited investigationFinal reportCessna T210L · Aurora, ORA collapse of the right main landing gear during the landing roll because the gear would not lock into place. Contributing to the accident was the pilot's failure to perform the alternate landing gear extension procedure before landing.NTSB WPR15CA112Accident · No injuriesData collectionFinal reportCessna T210 - L · The Dalles, ORThe pilot's failure to extend the landing gear prior to touch down. Contributing to the accident was the pilot's failure to utilize the pre-landing checklist.NTSB WPR13LA267Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chiloquin, ORThe pilot’s unstabilized approach and use of an excessive speed at touchdown, which resulted in a loss of directional control during the landing and a subsequent runway excursion.NTSB LAX07CA159Accident · No injuriesData collectionFinal reportCessna T210L · The Dalles, ORThe pilot's failure to extend the landing gear.NTSB SEA94LA157Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chiloquin, ORFuel exhaustion due to a false indication on the fuel quantity sensor.NTSB SEA92LA087Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Prineville, ORThe pilot in command delaying his decision to divert for fuel, overloading of the nose gear strut and the pilot in command's inability to maintain aircraft control subsequent to the nose wheel separation. Factors contributing to the accident were: the pilot…NTSB SEA86LA186Accident · No injuriesLimited investigationFinal reportCessna 210 · Hillsboro, ORThe pilot reported that he struck a post on take-off and broke off the main landing gear wheel. The pilot proceeded to Hillsboro, Oregon where an emergency landing was made on a paved runway with the landing gear still extended. The stub caught in the runway…NTSB SEA84LA044Accident · No injuriesLimited investigationFinal reportCessna T21OL · Bend, ORThe plt reported that he departed boulder city, NV with 92 gal of fuel on board. About 4 hrs & 10 min later, he was forced to land when the eng lost power from fuel exhaustion. According to him, the fuel gages had been indicating normal with an indication of…NTSB SEA78DYM35Accident · No injuriesClosedCessna 210 · Waldport, ORNTSB SEA78DYK02Accident · No injuriesClosedCessna T210 · Redmond, ORNTSB SEA77DA046Accident · Minor injuriesClosedCessna 210L · Klamath Falls, ORNTSB SEA76DYC55Accident · No injuriesClosedCessna T210L · Mcminnville, OR