NTSB investigations: Cessna P210N
17 cases on aircraft the registry lists as Cessna P210N, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1983 | 1 |
|---|---|
| 1986 | 4 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2004 | 2 |
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 ('2073454', '2073462')
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\" = 351))
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 ('2073454', '2073462')
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" = 351))
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 IAD05FA012Accident · 1 fatalField investigationFinal reportCessna P210 · Paint Lick, KYImproper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.NTSB DEN04LA107Accident · No injuriesLimited investigationFinal reportCessna P210N · Douglas, WYthe failure of the engine's crankshaft due to the rotation of the engine's number two bearing, which resulted in the oil starvation of the crankshaft's number 2 main journal. Contributing factors include the engine's improper maintenance, and the in-flight…NTSB NYC01FA141Accident · 3 fatalField investigationFinal reportCessna P210N · Honesdale, PAAn improperly manufactured torquemeter gearshaft assembly, which resulted in gearshaft assembly failure, an N2 overspeed, and a subsequent uncontained engine failure.NTSB NYC00LA200Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Richfield Sprng, NYFailure of the number two cylinder main bearing for undetermined reasons.NTSB IAD96LA046Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Hazard, KYfailure of the engine crankshaft, which resulted in loss of engine power, a forced landing, and subsequent damage to the airplane. A factor relating to the accident was: lack of suitable terrain for a forced landing.NTSB SEA95FA213Accident · 1 fatalField investigationFinal reportCessna P210N · Black Diamond, WAimproper maintenance which led to oil starvation due to a inadequately tightened B-nut in an oil line. A factor was the lack of suitable terrain for a forced landing.NTSB CHI95LA137Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Dodge City, KSfatigue and subsequent catastrophic failure of the connecting rod originating from the decarburized area on the shank of the rod. Factors were the low cloud weather condition and the ditch.NTSB CHI95LA047Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Aurora, MOAn undetermined failure of the engine crankshaft resulting in total loss of engine power. The terrain at the emergency landing site and nighttime darkness were contributing factors.NTSB LAX93LA194Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Oakland, CAthe pilot's poor decision to continue flying the airplane with a known deficiency and the poorly performed major overhaul of the engine. The failed crankshaft due to fatigue are factors in this accident.NTSB CHI92FA215Accident · 2 fatalField investigationFinal reportCessna P210N · Mineral Point, WIThe pilot's inadvertent stall and descent into terrain during a forced landing. Related factors are the manufacturer's undertorqued crankcase halves and inadequate surveillance, the pilot's delay in setting up the proper descent rate, and the altered aircraft…NTSB FTW89LA160Accident · No injuriesLimited investigationFinal reportCessna 210P · Bethany, OKA loose fuel line connection, due to inadequate maintenance, which resulted in fuel starvation. Factors related to the accident were: darkness and the obstructions (hay bale & approach light pole) in the emergency landing area.NTSB CHI88LA068Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILNTSB SEA86LA249Accident · No injuriesLimited investigationFinal reportCessna P-210 · Pasco, WAWhile in cruise at 14,000 feet MSL, a catastrophic engine failure with a flash fire at the turbocharger occurred. A turn to reverse direction for a forced landing was initiated while making a rapid descent. An undershoot to the runway occurred with the…NTSB LAX86LA331Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Salton City, CAA total loss of power was experienced during a descent from 17,500' MSL to 10,000' MSL. Attempts to restart the engine failed and the acft was landed gear-up in a rocky field. Post accident inspection disclosed a track of internal electrical arcing in the…NTSB FTW86LA148Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Altus, OKThe engine failed at 10,500 feet MSL and the pilot was vectored to a small private sod strip. However, this strip had been closed and plowed up for about a year and was not listed on the current aeronautical charts. The pilot was then revectored to another…NTSB DEN86FA077Accident · 3 fatalField investigationFinal reportCessna P210N · Dulce, NMThe plt with his 4 passengers, departed durango airport on an IFR flt plan en route to wichita, Kansas. The acft had a complete loss of pwr while climbing to attitude. The subsequent forced landing on unsuitable terrain resulted in substantial damage to the…NTSB DEN83LA048Accident · No injuriesLimited investigationFinal reportCessna P210N · Glade Park, COThe acft landing gear collapsed during a forced landing after an engine failure. The pilot said he lost manifold and oilpressure and turned back toward grand junction when the engine began making loud noises. A landing was made on a slippery road and the acft…