NTSB investigations: Cessna T210M, WA

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

NTSB investigations: Cessna T210M, WA per year, 1978–2026: 9 cases
1978	1
1979	2
1983	2
1985	1
1988	1
1993	1
1996	1

Where

Open the map

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" = 'WA' 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

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\" = 'WA' 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" = 'WA' 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

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 SEA97FA005Accident · 1 fatalField investigationFinal reportCessna T210M · Everett, WAThe pilot's impairment of judgment and performance due to the recent excessive use of potent prescription drugs, the pilot's descent below the published decision height, and the pilot's failure to execute a missed approach. Factors contributing to the…Oct 8, 1996 · N761TQ · Destroyed NTSB SEA93LA087Accident · No injuriesLimited investigationFinal reportCessna T210M · Scappose, WAClearance from objects was not maintained. The pilot's poor inflight planning and the weather conditions were factors.Apr 6, 1993 · N16CE · Substantial damage NTSB SEA89FA002Accident · 2 fatalField investigationFinal reportCessna T210M · Prosser, WAThe flight was on initial climb after takeoff at 400 AGL when the engine quit. During the ensuing forced landing, the aircraft impacted on an interstate highway perpendicular to the roadway, bounced into open pasture land, impacted a rock berm and burst into…Oct 2, 1988 · N1817M · Destroyed NTSB SEA85LA205Accident · Minor injuriesLimited investigationFinal reportCessna T210-M · Camano Island, WAThe plt failed to visually verify the fuel on board prior to takeoff and he was aware that one fuel gage was inaccurate.a total loss of pwr occurred over water aprx 30 miles from the intended destination arpt. The plt was able to reach land during the…Aug 30, 1985 · N761VV · Substantial damage NTSB SEA84FA101Accident · 1 fatalField investigationFinal reportCessna T210M · East Sound, WAThe acft collided with steeply upsloping terrain along the NE side of orcas island. The plt had been reportedly flying throughout the puget Sound/pacific nw area for more than 10 years & was familiar with the terrain & associated wx. Several plts located in…Dec 8, 1983 · N761PW · Destroyed NTSB SEA84LA003Accident · No injuriesLimited investigationFinal reportCessna T210M · Seattle, WAAfter takeoff while on a right turnout from rwy 31L, & at about 1000 ft AGL, the eng quit. The plt returned to the arpt & elected to lower the gear when he knew rwy 13L could be reached. However the left main gear failed to lock prior to touchdown & the…Oct 5, 1983 · N1817M · Substantial damage NTSB SEA80FA013Accident · 1 fatalClosedCessna T210M · Pasco, WADec 8, 1979 · N732QJ · Destroyed NTSB SEA80FA007Accident · 2 fatalClosedCessna T210M · Yakima, WANov 21, 1979 · N321TT · Substantial damage NTSB SEA78FYP50Accident · Minor injuriesClosedCessna T210M · Spokane, WASep 1, 1978 · N761CM · Substantial damage