NTSB investigations: Cessna T210N, NV
6 cases on aircraft the registry lists as Cessna T210N. 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 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 2 |
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 ('2073456'))
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 ('2073456'))
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 SEA86LA191Accident · No injuriesLimited investigationFinal reportCessna T210 · Las Vegas, NVDuring landing roll the aircraft departed the runway to the right despite the pilots attempt to correct with left rudder. The acft struck a ditch and the nose gear separated from the acft. During acft repair the mechanic found the right master cylinder was…NTSB SEA86LA184Accident · No injuriesLimited investigationFinal reportCessna T-210 · Battle Mountain, NVAfter a loss of power and a propeller overspeed, a forced landing was made. The pilot diverted from two chosen landing sites due to power lines crossing them. A road was chosen and during landing rollout the aircraft's wing tip clipped the top of a fence. The…NTSB SEA86LA022Accident · No injuriesLimited investigationFinal reportCessna T210N · Overton, NVSeveral diversions had been made due to encountering airframe icing. Once the pilot realized that a low fuel condition existed he asked for vectors to the nearest airport. The pilot had to make a forced landing due to fuel exhaustion 1 mile short of the…NTSB SEA85LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Gabbs, NVOn landing touchdown, the acft bounced and ballooned back into the air. Plt applied full throttle for go-around, but engine responded with partial power, insufficient for successful go-around. Plt then cut throttle in attempt to remain within airport confines…NTSB SEA84LA202Accident · No injuriesLimited investigationFinal reportCessna 210N II · Elko, NVFuel exhaustion occurred on final approach to destination airport. The nose landing gear contacted the top of the chain link airport perimeter fence breaking a connector and allowing the nose gear to retract. The main gear were not damaged. On landing roll…NTSB LAX81DXQ22Accident · No injuriesClosedCessna T210 · Ely, NV