NTSB investigations: Cessna 210L
10 cases on aircraft the registry lists as Cessna 210L, 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
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 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 ('2073448')
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 ('2073448')
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 ATL04LA015Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Hickory, NCThe pilot's failure to maintain airspeed which resulted in a stall.NTSB NYC02LA144Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Zelienople, PAThe pilot failure to follow the published aborted landing procedures, with the retraction of the flaps to 10 degrees prior to reaching a safe altitude and airspeed, which resulted in an uncontrolled descent.NTSB LAX00FA176Accident · 2 fatalField investigationFinal reportCessna T210L · North Las Vegas, NVThe pilot's failure to maintain control of the airplane during a go-around in a crosswind condition.NTSB LAX96FA052Accident · 2 fatalField investigationFinal reportCessna 210L · Grand Canyon, AZthe pilot's loss of aircraft control as a result of spatial disorientation. Factors were: the pilot's lack of experience in instrument and night flight conditions, inadequate transition/upgrade training, and the dark night light condition.NTSB LAX93LA252Accident · No injuriesLimited investigationFinal reportCessna 210L · Douglas, AZThe pilot's premature retraction of the landing gear and flaps at a critical time in the takeoff initial climb and his failure to attain an adequate climb airspeed which resulted in an inadvertent stall/mush condition. A factor in the accident was the high…NTSB NYC93LA021Accident · No injuriesLimited investigationFinal reportCessna 210L · Cincinnati, OHThe failure of the pilot to maintain directional control during landing which resulted in the airplane striking a drainage ditch. Factors related to the accident were the crosswind and the drainage ditch.NTSB MIA91FA075Accident · 1 fatalField investigationFinal reportCessna 210L · Orlando, FLThe pilot's failure to maintain aircraft control in instrument conditions and his spatial disorientation. Factors were a failure of the vacuum pump and the pilot's lack of recent experience in partial panel instrument flying or training.NTSB DEN90FA109Accident · Serious injuriesField investigationFinal reportCessna 210L · Telluride, COThe pilot's ffailure to maintain flying speed which resulted in a stall. Factor was wind shear reported off departure end of rwy.NTSB MIA86FA055Accident · 2 fatalField investigationFinal reportCessna 210L · Lake City, FLPrior to departure on a VFR flight from Florida to Michigan the non-instrument rated plt did not obtain a weather briefing. 53 minutes after departure the pilot contacted jacksonville ARTCC and reported he had flown VFR into the clouds and was having trouble…NTSB 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…