NTSB investigations: Cessna T210M, MO

7 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

19852026

NTSB investigations: Cessna T210M, MO per year, 1985–2026: 7 cases
1985	2
1986	1
1993	1
1994	1
2011	1
2014	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" = 'MO' 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\" = 'MO' 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" = 'MO' 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 CEN14LA194Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Lee's Summit, MOThe pilots’ inadequate preflight planning and fuel management, which resulted in fuel exhaustion, a loss of engine power, and a forced landing on a soft field. Contributing to the accident was the flying pilot’s improper use of flaps during the forced landing.Apr 6, 2014 · N761BT · Substantial damage NTSB CEN11FA202Accident · Minor injuriesField investigationFinal reportCessna T210M · Independence, MOLatent dimensional discrepancies related to the engine crankcase main bearing saddle bores, which precipitated the fatigue failure of the crankshaft and a complete loss of engine power. Contributing to the accident was the engine manufacturer's failure to…Feb 24, 2011 · N6149B · Substantial damage NTSB CHI94LA125Accident · No injuriesLimited investigationFinal reportCessna T210-M · Pomona, MOThe seperation of the landing gear door actuator, resulting in total loss of hydraulic fluid.Mar 31, 1994 · N732YK · Substantial damage NTSB CHI93LA287Accident · No injuriesLimited investigationFinal reportCessna T210M · Neosho, MOIs the pilot in command's failure to maintain proper clearance. Factors relating to this accident are the pilot in command's inadequate preflight preparation and the loss of total engine power as a result of fuel exhaustion.Jul 27, 1993 · N761DD · Substantial damage NTSB MKC86LA193Accident · No injuriesLimited investigationFinal reportCessna T210M · Old Monroe, MOThe PIC had initiated his descent ot his destination arpt when he rptd experiencing eng pblms. The rough running eng finally quit and the PIC made a forced lndg to an open fld. The subsequent lndg encountered a ditch and the nose gear collapsed. Exam of the…Sep 23, 1986 · N6163N · Substantial damage NTSB MKC86FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Kansas City, MOThe plt was seen to enter the acft for a short time and then get out, go to the front of the acft and pull down on the prop. The eng fired and the prop struck the pilot's head. A plt who approached the acft moments after the acdt looked into the cockpit and…Dec 20, 1985 · N761YS · No damage NTSB MKC85LA073Accident · No injuriesLimited investigationFinal reportCessna T210M · Joplin, MOThe acft nose gear collapsed after a hard bounced landing. The plt stated that she touched down hard on the main gear then bounced and relanded on main and nose gear. During the 2nd touchdown the nose gear collapsed. The plt and her one-year-old daughter were…Mar 18, 1985 · N732XD · Substantial damage