NTSB investigations: Cessna T210M
10 cases on aircraft the registry lists as Cessna T210M, where the first occurrence was “Loss of engine power”. 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
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2006 | 2 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073451', '2073452')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073451', '2073452')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 ATL07FA036Accident · 1 fatalField investigationFinal reportCessna T210M · Haddock, GALoss of engine power for undetermined reasons.NTSB SEA06LA185Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Delta, UTA loss of engine power for an undetermined reason during cruise flight.NTSB LAX06LA214Accident · No injuriesLimited investigationFinal reportCessna T210M · Hayward, CAA loss of power for undetermined reasons.NTSB LAX01FA297Accident · 1 fatalField investigationFinal reportCessna T210M · Watsonville, CAThe loss of engine power for undetermined reasons.NTSB SEA98LA099Accident · Minor injuriesLimited investigationFinal reportCessna T210M · La Pine, ORFuel starvation for undetermined reasons.NTSB FTW97LA246Accident · No injuriesLimited investigationFinal reportCessna T210M · Kerrville, TXThe disintegration of the #1 cylinder piston resulting from a detonation/pre-ignition condition due to an unknown reason. A factor was the lack of suitable terrain for the forced landing.NTSB BFO95FA028Accident · 1 fatalField investigationFinal reportCessna T210M · Youngstown, OHloss of engine power for undetermined reason(s). Factors relating to the accident were: the weather conditions (restricted visibility with snow falling), reduced light condition at dusk, and the lack of suitable terrain for an emergency landing.NTSB MKC89FA017Accident · Serious injuriesField investigationFinal reportCessna T210M · Clarksville, ARThe pilot took off on a 4500 ft runway, raised the landing gear, and turned south at approximately the 2500 ft point. Aircraft lost engine power. Pilot attempted to return to departure runway. Aircraft impacted prior to reaching the runway. Examination of the…NTSB NYC86LA032Accident · No injuriesLimited investigationFinal reportCessna 210M · Butler, PAThe plt had flown to new jersey, dropped off a passenger and was returning to Butler, PA, when a pwr loss occurred. The eng failed on base to final to rwy 26 when the position of the mixture was changed to the rich position. The plt stalled the acft into…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…