NTSB investigations: Cessna 210L, TX
17 cases on aircraft the registry lists as Cessna 210L. 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
| 1974 | 2 |
|---|---|
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1981 | 3 |
| 1982 | 2 |
| 1988 | 1 |
| 1996 | 1 |
| 2005 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2020 | 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\" = 'TX' 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 ('2073448'))
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" = 'TX' 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 ('2073448'))
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 CEN20LA162Accident · Minor injuriesClass 2 · LimitedFinal reportCessna T210 · New Braunfels, TXThe pilot's inadequate preflight inspection and fuel planning, which resulted in the loss of engine power due to fuel exhaustion.NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.NTSB CEN10LA389Accident · No injuriesLimited investigationFinal reportCessna 210 · Houston, TXThe failure of a hydraulic fluid line, which caused a loss of hydraulic pressure to the landing gear extension system and resulted in the partial collapse of the right main landing gear during touchdown.NTSB DFW05CA124Accident · No injuriesData collectionFinal reportCessna 210L · Houston, TXThe pilot's failure to maintain directional control during landing roll. A contributing factor was reported partial loss of brake control.NTSB FTW97FA073Accident · 2 fatalField investigationFinal reportCessna 210L · Brackettville, TXfailure of the pilot to maintain sufficient altitude and/or clearance from terrain, while on a cross-country flight at night. Factors relating to the accident were: darkness, the prevailing low ceilings, and mountainous/hilly terrain.NTSB FTW89LA029Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Texarkana, TXNTSB FTW83FA009Accident · 4 fatalField investigationFinal reportCessna 210L · Hebbronville, TXThe crew were advised that the acft's vacuum pump system was inoperative due to a sheared pump driveshaft. The copilot had stated that fss had forecast 25,000 ft broken & he did not feel he would need the pump. At 1735 the plt contacted center & requested…NTSB FTW82DA212Accident · Minor injuriesFinal reportCessna 210L · Wichita Falls, TXAfter climbing to 2500 ft the engine suddenly lost power and quit. The pilot lowered the landing gear and shut down all switches but did not extend the flaps. During the ensuing emergency landing the aircraft nosed over in a wheat field. Engine examination…NTSB FTW82FA001Accident · 3 fatalClosedCessna 210L · Clyde, TXNTSB FTW81FQG24Accident · Minor injuriesClosedCessna 210L · Hale Center, TXNTSB FTW81FPA07Accident · No injuriesClosedCessna 210L · Mckinney, TXNTSB FTW78DQG61Accident · No injuriesClosedCessna 210L · Roscoe, TXNTSB FTW77FQG58Accident · No injuriesClosedCessna 210L · Dalhart, TXNTSB FTW76DQG54Accident · No injuriesClosedCessna 210 · Pampa, TXNTSB FTW76AF038Accident · 2 fatalClosedCessna 210L · Magnolia, TXNTSB FTW75FPD19Accident · No injuriesClosedCessna 210 · Jacksboro, TXNTSB FTW74FRG74Accident · Serious injuriesClosedCessna 210L · Corpus Chrsti, TX