NTSB investigations: Cessna P210N, CO
14 cases on aircraft the registry lists as Cessna P210N. 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
| 1981 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 2008 | 2 |
| 2009 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2022 | 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\" = 'CO' 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 ('2073454', '2073462'))
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" = 'CO' 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 ('2073454', '2073462'))
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 CEN22LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Englewood, COA total loss of engine power on short final for reasons that could not be determined based on the available evidence.NTSB CEN17LA247Accident · No injuriesLimited investigationFinal reportCessna P210N · Eagle, COThe loss of engine power due to fuel starvation for reasons that could not be determined because an examination of the airplane and engine did not reveal any malfunctions or failures that would have precluded normal operation.NTSB GAA17CA221Accident · No injuriesData collectionFinal reportCessna P210 · Granby, COThe pilot's failure to extend the landing gear before landing.NTSB CEN16FA188Accident · 1 fatalField investigationFinal reportCessna P210N · Sheridan Lake, COThe pilot's severe impairment from the combined effects of high levels of ingested alcohol as well as three impairing medications (zolpidem, lorazepam, and diphenhydramine), which resulted in his decision to attempt an aerobatic maneuver that the airplane was…NTSB CEN14CA106Accident · Minor injuriesData collectionFinal reportCessna P210N · Pagosa Springs, COThe pilot's inadequate preflight inspection which led to a loss of oil pressure and partial loss of engine power on takeoff. Contributing to the accident was the pilot's failure to check the security of the oil filler cap prior to the flight.NTSB CEN10FA021Accident · Minor injuriesField investigationFinal reportCessna P210N · Rifle, COThe pilot’s failure to properly identify the power lever and, instead, manipulating the propeller condition lever.NTSB CEN09LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Whitewater, COBoth pilots' failure to see and avoid the other airplane. Contributing factors in this accident were the Cessna 180 pilot's attention being diverted and the Cessna 210 pilot's vision being affected by the sun glare.NTSB DEN08LA069Accident · No injuriesLimited investigationFinal reportCessna P210N · Elizabeth, COthe loss of engine power due to the fatigue failure of the camshaft gear. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DEN01LA042Accident · No injuriesLimited investigationFinal reportCessna P210N · Pagosa Springs, COfailure to maintain directional control of the aircraft after an encounter with adverse weather during landing roll. A factor was ground fog.NTSB FTW95LA051Accident · No injuriesLimited investigationFinal reportCessna P210N · Alamosa, COFailure by the pilot to properly judge the touch down point. Factors were: failure of the nose landing gear to extend and rough and uneven terrain.NTSB DEN91FA135Accident · 1 fatalField investigationFinal reportCessna P210N · Pagosa Springs, COFailure of the pilot to maintain clearance from trees during an approach for a precautionary landing. His improper use of the mixture control was a related factor concerning the partial loss of engine power.NTSB DEN85FA120Accident · 1 fatalField investigationFinal reportCessna P210N · Laporte, COThe plt was a business man, involved in building/construction work. On the morning of the acdnt, he had breakfast with friends who said he was in good spirits & was going to fly before going to work. Witnesses near the acdnt site saw the acft flying in the…NTSB DEN83LA048Accident · No injuriesLimited investigationFinal reportCessna P210N · Glade Park, COThe acft landing gear collapsed during a forced landing after an engine failure. The pilot said he lost manifold and oilpressure and turned back toward grand junction when the engine began making loud noises. A landing was made on a slippery road and the acft…NTSB DEN81FTE72Accident · No injuriesClosedCessna 210 · Rifle, CO