Skip to content

NTSB investigations: Cessna T210L, AZ

14 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19752026

Where

Latest cases

Query with SQL

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 ('2073449')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('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" = '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 ('2073449'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR23LA012Accident · No injuriesClass 3 · LimitedFinal reportCessna T210L · Marana, AZA failure of a retaining ring in the airplane’s left main landing gear door actuator and the subsequent complete loss of hydraulic fluid, which resulted in a gear-up landing.Oct 10, 2022 · N2425S · Substantial damage NTSB LAX04LA111Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Goodyear, AZThe pilot's inadequate fuel consumption calculations and in-flight planning/decision, which resulted in fuel exhaustion.Feb 1, 2004 · N2234S · Substantial damage NTSB LAX03LA034Accident · Minor injuriesLimited investigationFinal reportCessna T210 L · Williams, AZAn in-flight fire for undetermined reasons.Nov 20, 2002 · N59132 · Destroyed NTSB LAX00LA183Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Grand Canyon, AZThe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during landing, resulting in the airplane veering off the runway and the subsequent collision with a culvert.May 7, 2000 · N1726X · Substantial damage NTSB LAX97LA043Accident · No injuriesLimited investigationFinal reportCessna T210L · Mesa, AZthe pilot's failure to maintain directional control of the aircraft during the landing roll, which resulted in an inadvertent ground swerve.Nov 16, 1996 · N911JB · Substantial damage NTSB LAX96LA323Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Globe, AZfuel starvation due to the pilot's inadequate preflight inspection and improper fuel tank selection.Aug 31, 1996 · N2059S · Substantial damage NTSB LAX92FA092Accident · 2 fatalField investigationFinal reportCessna T210L · Temple Bar, AZFatigue failure of the turbocharger's turbine shaft due to inadequate maintenance, and the pilot's improper in-flight planning/decision after experiencing a turbocharger failure. A factor related to the accident was: the lack of information in the pilot…Jan 13, 1992 · N22592 · Destroyed NTSB LAX90LA215Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Marble Canyon, AZInadequate compensation for wind conditions by the pilot and his delay in attempting a go-around. Factors related to the accident were: the surrounding terrain, unfavorable weather conditions, the pilot's failure to attain the proper touchdown point, and…Jun 6, 1990 · N732KD · Substantial damage NTSB LAX90LA117Accident · 3 fatalLimited investigationFinal reportCessna T210L · Mesa, AZThe failure of the pilot to follow the airplane checklist and properly configure the airplane for takeoff. Contributing to the accident was the pilot's poor preflight preparation and the failure of the pilot to compute the aircraft weight before takeoff.Mar 11, 1990 · N94302 · Destroyed NTSB LAX88FA052Accident · 4 fatalField investigationFinal reportCessna T210L · Camp Verde, AZNov 22, 1987 · N42CR · Destroyed NTSB LAX78DUJ23Accident · Minor injuriesClosedCessna 210L · Flagstaff, AZJan 21, 1978 · N732BW · Substantial damage NTSB LAX77DUJ57Accident · Minor injuriesClosedCessna 210 · Estrella, AZJun 7, 1977 · N732EC · Substantial damage NTSB LAX75DUJ95Accident · Minor injuriesClosedCessna 210 · Payson, AZJun 28, 1975 · N16CM · Substantial damage NTSB LAX75DUJ77Accident · No injuriesClosedCessna 210 · Phoenix, AZApr 11, 1975 · N94148 · Substantial damage