NTSB investigations: Cessna 210L, AZ
10 cases on aircraft the registry lists as Cessna 210L. 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
| 1976 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 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\" = 'AZ' 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 ('2073448'))
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" = 'AZ' 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 ('2073448'))
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 LAX96LA325Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Glendale, AZThe loss of engine power due to the pilot's mismanagement of the fuel system, which resulted in fuel starvation. The passenger's action, which restricted the pilot's ability to control the aircraft, was a factor in this accident.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 LAX94LA365Accident · No injuriesLimited investigationFinal reportCessna 210L · Payson, AZAnimals on the runway.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 LAX89LA305Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Marble Canyon, AZThe pilot selected the wrong runway and landed downwind.NTSB LAX84LA436Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Chinle, AZAt about 1400 MST, the plt took off. He climbed & leveled off at 8500 ft. he was using fuel from the right tank which ran dry, then he switched to the left tank. At that time, he thought he had 30 mins of fuel remaining. He decided to land at Chinle, AZ, &…NTSB LAX82FA023Accident · 3 fatalClosedCessna 210L · Douglas, AZNTSB LAX78FUJ24Accident · No injuriesClosedCessna 210L · Mesa, AZNTSB LAX77FUJ69Accident · Serious injuriesClosedCessna 210L · Tuba City, AZNTSB LAX76DUJ67Accident · No injuriesClosedCessna 210 · Wilcox, AZ