Fatal NTSB investigations: Cessna T210G
13 cases on aircraft the registry lists as Cessna T210G. 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
| 1968 | 1 |
|---|---|
| 1973 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2009 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073432'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073432'))
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 WPR10FA027Accident · 1 fatalField investigationFinal reportCessna T210G · Provo, UTA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate preflight inspection.NTSB SEA07FA228Accident · 1 fatalField investigationFinal reportCessna T210G · Lomita, CAThe loss of engine power during approach as a result of fuel starvation due to the pilot's improper pre takeoff fuel system selector valve positioning. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DEN05FA074Accident · 4 fatalField investigationFinal reportCessna T210G · Ouray, COthe pilot's inadvertent flight into adverse weather conditions, loss of control, and resulting exceedence of the design stress limits of the aircraft. which led to an in-flight structural failure. Factors in the accident included the pilot's inadequate…NTSB DEN01FA110Accident · 3 fatalField investigationFinal reportCessna T210G · Lyons, COThe pilot's inadequate preflight planning/preparation and his continued flight into adverse weather condition resulting in controlled flight into terrain. Contributing factors were the fog, low ceilings and the pilot's lack of recent experience.NTSB DEN89FA104Accident · 1 fatalField investigationFinal reportCessna T210F · Aspen, COThe engine falure due to undetermined reasons and the pilot's misjudgement of the wind conditions which resulted in the attempt to glide to the runway. The pilot also failed to maintain adequate airspeed during the glide which resulted in a stall.NTSB DEN85FA037Accident · 1 fatalField investigationFinal reportCessna T-210G · Meeker, COThe a/c dept larami, WY on an IFR flt to grand junction, CO.in the vicinity of Meeker, CO, the plt experienced an apparent instrument gyro problem. He flew off course once but with the help of ARTCC he was vectored back on course, only to again go off crse,…NTSB DEN81FA032Accident · 3 fatalClosedCessna T210G · Worland, WYNTSB FTW79FA052Accident · 1 fatalClosedCessna 210G · Jennings, LANTSB OAK79FA006Accident · 2 fatalClosedCessna T210G · Groveland, CANTSB SEA77FA037Accident · 4 fatalClosedCessna T210G · Elgin, ORNTSB MIA76AM107Accident · 3 fatalClosedCessna T210G · Brantley, ALNTSB LAX73AL047Accident · 2 fatalClosedCessna T210G · Solvang, CANTSB DEN69A0015Accident · 3 fatalClosedCessna T-210G · Estancia, NM