NTSB investigations: Cessna T210N
14 cases on aircraft the registry lists as Cessna T210N, where the first occurrence was “In flight collision with object”. 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
| 1984 | 3 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 2005 | 1 |
| 2006 | 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 ('2073456')
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\" = 220))
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 ('2073456')
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" = 220))
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 NYC07LA036Accident · No injuriesLimited investigationFinal reportCessna T210N · Caldwell, NJThe private pilot's failure to maintain adequate altitude/clearance, and the flight instructor's failure to take remedial action. Contributing to the accident was the night light conditions.NTSB DEN06LA067Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Arkansas City, KSthe pilot's failure to maintain clearance from the guide wire resulting in the airplane striking the wire and subsequently impacting the terrain.NTSB ATL05LA137Accident · 1 fatalLimited investigationFinal reportCessna T210 · Muscle Shoals, ALThe pilot's inadequate visual lookout, and failure to maintain clearance, which resulted in an in flight collision with a transmission wire.NTSB LAX90FA252Accident · 3 fatalField investigationFinal reportCessna T210N · Pinon, AZFailure of the pilot to attain the proper touchdown point during the landing, her delay in initiating a go-around (aborted landing), and her failure to remain clear of power lines on rising terrain during the aborted landing. Factors related to the accident…NTSB ATL90FA038Accident · 3 fatalField investigationFinal reportCessna T210N · Spindale, NCThe pilot-in-command's improper IFR procedure which resulted in descent below the minimum descent altitude. Contributingfactor(s) was: the fog and low ceiling.NTSB CHI89FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Springfield, ILThe pilot's improper IFR procedure during an ILS approach in below minimum conditions, and the pilot's failure to proceed to an alternate destination. Contributing factors were the adverse weather conditions.NTSB LAX88FA278Accident · 1 fatalField investigationFinal reportCessna T-210 · Brea, CANTSB BFO87LA017Accident · No injuriesLimited investigationFinal reportCessna T210N · West Point, VAThe plt stated that the left main gear collided with a snowbank when the acft touched down on the rwy about 100 ft from the apch end and 10 ft left of the rwy centerline. Afterwards the left main gear folded into the wheel well.NTSB ATL87DEG01Accident · No injuriesFinal reportCessna T210N · Cleves, OHThe plt reported that he initiated a go-around during an apch T0 a private strip. He stated that he misjudged the height of the acft and stalled it into trees and brush while climbing over rising terrain. He also said he was suffering from a cold and sinus…NTSB LAX86FA288Accident · 6 fatalField investigationFinal reportCessna T210N · Bullhead City, AZThe private pilot, who had accumulated approximately 450 hours of flight experience and his 5 passengers, arrived at the destination airport during darkness. This was the pilot's first landing at the uncontrolled airport and he was not familiar with the…NTSB CHI86LA039Accident · No injuriesLimited investigationFinal reportCessna T210N · Doran, MNWhile in cruise flt at 3000 ft MSL at night, the acft struck a bird with the left wing. The plt experienced some control problems but was able to retain sufficient control to affect a safe landing. Post-flt inspection revealed substantial damage to the left…NTSB FTW84LA285Accident · No injuriesLimited investigationFinal reportCessna T210N · Monahans, TXThe plt made several unsuccessfull downwind landing attempts. The last attempt was long & fast & upon go around, the acft struck the arpt boundry fence & came to rest 700 ft past the departure end of the rwy.NTSB ATL84LA209Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Williamsport, TNPilot stated that while departing from a small 2000 foot long private strip the engine appeared to loose power. The aircraft would not climb and collided with a tree at the departure ens of the rwy. The acft then collided with several other trees prior to…NTSB DEN84LA092Accident · No injuriesLimited investigationFinal reportCessna T-210 · Duchesne, UTThe acft departed the side of the rwy during the landing roll. The plt stated that he could no determine where the center of the rwy was due to about 2 inches of fresh snow. The rt landing gear collapsed & the nose gear failed.