NTSB investigations: Cessna T210M, PA
5 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.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 2015 | 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.\"eventStateOrRegion\" = 'PA' 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" = 'PA' 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" 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 ERA15LA238Accident · No injuriesLimited investigationFinal reportCessna T210 · Palmyra, PAThe pilot's delay in conducting an aborted landing and his subsequent failure to establish a proper airspeed during the attempted go-around on a hot day, which resulted in the airplane’s inability to climb and a subsequent stall/mush.NTSB NYC91LA222Accident · No injuriesLimited investigationFinal reportCessna T-210-M · Clearfield, PAVapor lock of the fuel system resulting in fuel starvation. A factor related to the accident was the failure of the owner to comply with a service letter calling for insulated fuel lines forward of the fire wall.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 NYC84FA184Accident · 1 fatalField investigationFinal reportCessna T210M · Bloomsburg, PAThe acft collided with pwr lines during an attempted go-around. Witnesses stated the acft was nose low until just prior to touchdown when it pitched up. The acft bounced into the air and touched down on the nose gear. The acft 'rocked side to side' on the rwy…NTSB NYC82FA059Accident · 5 fatalField investigationFinal reportCessna T210M · Williamsport, PAThe acft impacted a mountain about 5 mi sw of the arpt at an elevation of approximately 1,400 ft while executing a missed approach from an ILS approach to rwy 27. The published missed approach procedure requires a climbing right turn to 3,700 ft via a heading…