NTSB investigations: Cessna T210M, FL

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, FL per year, 1978–2026: 9 cases
1978	1
1980	1
1982	2
1984	1
2002	1
2003	1
2005	1
2012	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" = 'FL' 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\" = 'FL' 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" = 'FL' 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 ERA12LA164Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Clearwater, FLThe total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident testing of the engine did not reveal any malfunctions or failures that would preclude normal operation. Contributing to the accident was the…Jan 28, 2012 · N761HW · Substantial damage NTSB MIA05LA147Accident · No injuriesLimited investigationFinal reportCessna T210M · Kissimmee, FLA loss of engine power due to the pilot's inaccurate fuel consumption calculations and subsequent fuel exhaustion.Aug 7, 2005 · N732WN · Substantial damage NTSB MIA03LA160Accident · No injuriesLimited investigationFinal reportCessna T210M · Hialeah, FLSpinning of the crankshaft No. 2 main bearing for undetermined reasons resulting in damage to the aft cheek of the No. 2 main bearing journal, fatigue failure of the crankshaft cheek, failure of the engine in cruise flight, and damage to the airplane during…Aug 10, 2003 · N86PH · Substantial damage NTSB ATL03LA021Accident · No injuriesLimited investigationFinal reportCessna T210M · Lakeland, FLThe collapse of the main landing gear for undetermined reasons.Nov 25, 2002 · N6026N · Substantial damage NTSB MIA85FA044Accident · 4 fatalField investigationFinal reportCessna 210 · Clermont, FLDespite 5 pre-flt wx briefings from the local fss, warnings from a plt who had just landed in a corporate jet, and questioning from the ATCT regarding the plt's knowledge of existing conditions. The plt departed at 1138 EST. The acft impacted inverted and the…Nov 23, 1984 · N6658B · Destroyed NTSB MIA82DA118Accident · Minor injuriesFinal reportCessna T210M · Fort Lauderdale, FLApproximately 18 miles west of the Fort Lauderdale airport, while cruising at 7500 feet, the engine lost power. After advising the tower of the problem, ATC suggested attempting a landing at a closer airport. At this point the pilot stated that power had been…May 7, 1982 · N613C · Substantial damage NTSB MIA82DA074Accident · No injuriesFinal reportCessna T210M · Miami, FLThe pilot experienced a loss of electrical power on a VFR flight. Upon arrival in the Miami area he was unable to extend the main gear and landed gear up.Mar 16, 1982 · N761NJ · Substantial damage NTSB MIA81FLA04Accident · No injuriesClosedRobertson T210M · Gainesville, FLNov 29, 1980 · N1877M · Substantial damage NTSB MIA79FA002Accident · 1 fatalClosedCessna T210M · Plymouth, FLOct 19, 1978 · N6827B · Destroyed