NTSB investigations: Cessna T210F, CA
18 cases on aircraft the registry lists as Cessna T210F. 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
| 1967 | 3 |
|---|---|
| 1968 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 2 |
| 1983 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 2002 | 1 |
| 2013 | 1 |
| 2017 | 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\" = 'CA' 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 ('2073422'))
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" = 'CA' 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 ('2073422'))
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 WPR17LA172Accident · No injuriesLimited investigationFinal reportCessna T210F · Llano, CAA failure of the turbocharger that resulted in complete depletion of the engine oil and catastrophic internal failure of the engine. Contributing to the accident was improper and/or incomplete maintenance and inspection of the turbocharger.NTSB WPR14LA056Accident · No injuriesLimited investigationFinal reportCessna T210 - F · Oceanside, CAThe pilot's failure to determine the actual onboard fuel quantity before beginning the flight, which resulted in a complete loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's habitual reliance solely on the cockpit fuel…NTSB LAX02LA238Accident · No injuriesLimited investigationFinal reportCessna T210F · Willits, CAthe student pilot's misjudged, distance, and speed, and failure to attain the proper touchdown point.NTSB LAX95LA117Accident · No injuriesLimited investigationFinal reportCessna T210F · Phalen, CAthe pilot's decision to continue the flight with a known mechanical discrepancy in the brake system.NTSB LAX91FA044Accident · 1 fatalField investigationFinal reportCessna T210-F · Fontana, CAThe pilot-in-command's decision to continue flight into known adverse weather conditions during the hours of darkness in mountainous terrain.NTSB LAX83FUG22Accident · No injuriesFinal reportCessna T210F · Mecca, CAThe stolen acft, operated by persons unknown, landed on a road and turned over on its back.NTSB LAX82FVD07Accident · No injuriesClosedCessna T210F · Penngrove, CANTSB LAX81FXQ20Accident · Serious injuriesClosedCessna T210F · S.Lake Tahoe, CANTSB LAX80FUA14Accident · No injuriesClosedCessna T210 · Anaheim, CANTSB OAK79DVG04Accident · No injuriesClosedCessna T210 · Oroville, CANTSB LAX77FUG61Accident · No injuriesClosedCessna 210F · Baker, CANTSB OAK76FVA18Accident · No injuriesClosedCessna T210F · Chowchilla, CANTSB OAK72AP035Accident · 1 fatalClosedCessna 210K · Sacramento, CANTSB LAX71FUA02Accident · No injuriesClosedCessna 210 · Santa Ana, CANTSB CHI68F0545Accident · No injuriesClosedCessna T-210F · Bakersfield, CANTSB LAX68D0137Accident · No injuriesClosedCessna 210 · Santa Paula, CANTSB LAX67D0433Accident · No injuriesClosedCessna 210 · Inyokern, CANTSB OAK67D0302Accident · Minor injuriesClosedCessna T210 · Placerville, CA