NTSB investigations: Cessna T210M, AZ
12 cases on aircraft the registry lists as Cessna T210M. 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
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1980 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 2 |
| 2017 | 1 |
| 2019 | 1 |
| 2025 | 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 ('2073451', '2073452'))
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 ('2073451', '2073452'))
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 WPR25LA164Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Tucson Estates, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA19CA171Accident · No injuriesData collectionFinal reportCessna T210 · Chandler, AZThe pilot's distraction while looking for other aircraft in the traffic pattern, which resulted in his failure to follow a prelanding checklist and to extend the landing gear before landing. Contributing to the accident was the improperly rigged landing gear…NTSB WPR17LA053Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Buckeye, AZThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB LAX05LA136Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Phoenix, AZa loss of power for undetermined reasons.NTSB LAX05LA065Accident · No injuriesLimited investigationFinal reportCessna T210M · Mesa, AZthe pilot's failure to use the emergency gear extension procedure to manually extend the landing gear to the down and locked position.NTSB LAX01LA248Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Marble Canyon, AZThe pilot's failure to use all the available runway and his failure to follow the prescribed short field takeoff procedure resulting in a loss of control during the takeoff roll. Factors were the short, rough, and rising runway, and the soft dirt surrounding…NTSB LAX00GA102Accident · No injuriesFinal reportCessna T210M · Elfrida, AZThe company mechanic's failure to correctly install one or more of the crankshaft counterweight pin retaining plate snap rings, specifically ensuring that the snap rings were fully seated in their grooves. This led to the complete separation of the No. 2…NTSB LAX92LA098Accident · No injuriesLimited investigationFinal reportMooney M20J · Bullhead City, AZThe pilot of the other aircraft inadvertently landing on the taxiway instead of the active runway.NTSB LAX89LA240Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Chandler, AZInadequat preflight planning/preparation and the improper flight planning/decisions, ie. Improper fuel consumption calculations, by the PIC.NTSB LAX80FUJ40Accident · No injuriesClosedCessna T210M · Aguila, AZNTSB LAX79DUJ87Accident · No injuriesClosedCessna T210 · Kingman, AZNTSB LAX78FA046Accident · 1 fatalClosedCessna T210M · Salome, AZ