NTSB investigations: Cessna 210, NV
12 cases on aircraft the registry lists as Cessna 210. 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
| 1964 | 1 |
|---|---|
| 1968 | 2 |
| 1971 | 1 |
| 1973 | 1 |
| 1982 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2011 | 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\" = 'NV' 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 ('2073402'))
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" = 'NV' 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 ('2073402'))
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 WPR11LA154Accident · No injuriesLimited investigationFinal reportCessna 210 · Pahrump, NVThe pilot's failure to extend the landing gear prior to touchdown and his improper decision to abort a gear-up landing following a propeller strike.NTSB LAX03LA218Accident · No injuriesLimited investigationFinal reportCessna 210 · Henderson, NVA bolt in the fuel selector that restricted the flow of fuel to the engine, which resulted in fuel starvation and a partial loss of engine power during the final approach to land.NTSB LAX00LA022Accident · No injuriesLimited investigationFinal reportCessna 210 · Enterprise, NVThe failure of the pilot to maintain directional control of the aircraft during the landing roll, which resulted in a collision with a ditch.NTSB SEA89LA034Accident · No injuriesLimited investigationFinal reportCessna 210 · Carson City, NVSeparation of the throttle cable due to wear as power was applied for a landing go-around. Contributing to the accident was rough terrain at the touchdown point of the forced landing.NTSB SEA88LA136Accident · No injuriesLimited investigationFinal reportCessna 210 · Baker, NVThe pilot stated he landed long on unattended grass strip due to gusty wing conds. The aircraft encountered a ditch or vehicle track hidden by vegetation, shearing nose gear and collapsing left main.NTSB SEA88LA104Accident · No injuriesLimited investigationFinal reportCessna 210 · Reno, NVDuring an instructional flight and an ILS approach, a total loss of engine power occurred at about 1200 feet AGL. A forced landing was made onto rough terrain. During landing roll the nose gear separated from the aircraft. The private pilot receiving…NTSB LAX82DA210Accident · Minor injuriesFinal reportCessna 210 · Lovelock, NVDuring arrival, the pilot was unable to contact the fss. He was unaware that the fss station had already closed. He observed the wind sock and elected to land on runway 01 with a wind from 325 degrees at 30 knots. On final approach, a distinct crab of about…NTSB OAK74FXQ16Accident · Minor injuriesClosedCessna 210 · Carson City, NVNTSB OAK71DXQ39Accident · No injuriesClosedCessna 210 · Mina, NVNTSB OAK69A0027Accident · 3 fatalClosedCessna 210 · Wells, NVNTSB OAK69D0103Accident · No injuriesClosedCessna 210 · Fallon, NVNTSB UNK64X3395Accident · No injuriesClosedCessna 210 · Las Vegas, NV