NTSB investigations: Cessna T210L, NV
10 cases on aircraft the registry lists as Cessna T210L. 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 | 1 |
|---|---|
| 1975 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 2 |
| 1986 | 1 |
| 1992 | 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 ('2073449'))
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 ('2073449'))
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 LAX92LA357Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Jackpot, NVThe pilot allowing himself to become distracted while searching for a landing light switch during a critical phase of flight and the resultant failure to maintain control of the aircraft. Factors in the accident were the dark night light conditions and the…NTSB SEA86LA190Accident · No injuriesLimited investigationFinal reportCessna T210L · Elko, NVDuring landing rollout on runway 23 the aircraft deviated to the right and the pilot corrected first with rudder and then left brake. The aircraft then veered left and departed the runway. The pilot then attempted to initiate a go around and fly out of the…NTSB LAX82FA262Accident · 1 fatalField investigationFinal reportCessna T-210L · Reno, NVThe pilot was descending in a mountainous area and did not clear the high terrain before collision with the ground occurred. The pilot was in radio communication with Reno tower and was given landing instructions. There was no verbal indication of trouble on…NTSB LAX82FA088Accident · 6 fatalField investigationFinal reportCessna T21OL · Verdi, NVPrior to the acft's departure from truckee-tahoe arpt, an inbound plt recommended via radio that the flt not go because he had just flown thru the donner pass & the wx was terrible. He reported the wind 25-35K, gusting 40-45K. The flt received a wx briefing…NTSB LAX81FA101Accident · 3 fatalClosedCessna T210 · Elko, NVNTSB LAX80FA074Accident · 1 fatalClosedCessna T210L · Lovelock, NVNTSB OAK79DXQ13Accident · No injuriesClosedCessna 210 · Battle Mt, NVNTSB OAK79FA008Accident · 1 fatalClosedCessna T-210L · Dayton, NVNTSB OAK76FVW02Accident · No injuriesClosedCessna T210L · Las Vegas, NVNTSB OAK75AP023Accident · Serious injuriesClosedCessna 210T · Reno, NV