NTSB investigations: Cessna 210L, CA
16 cases on aircraft the registry lists as Cessna 210L. 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
| 1974 | 1 |
|---|---|
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1988 | 1 |
| 1991 | 2 |
| 1995 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2020 | 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 ('2073448'))
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 ('2073448'))
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 WPR20LA101Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Needles, CAA loss of engine power for undetermined reasons due to a lack of available evidence.NTSB SEA08LA028Accident · No injuriesLimited investigationFinal reportCessna 210L · Santa Barbara, CAThe left main landing gear's down limit switch plunger being bent and stuck in the closed position, which resulted in the collapse of the landing gear during the landing roll. The reason for the down limit switch plunger being bent could not be determined.NTSB LAX05FA108Accident · No injuriesField investigationFinal reportCessna 210L · Oxnard, CAA pinhole leak in the fuel pressure line during the takeoff roll that was ignited by an electrical arc associated with wires adjacent to the fuel line. A contributing factor in the accident was the failure of maintenance personnel to comply with a…NTSB LAX95LA234Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Truckee, CAfuel exhaustion due to the pilot's inadequate preflight fuel planning, and his failure to refuel the aircraft while en route.NTSB LAX92LA035Accident · No injuriesLimited investigationFinal reportCessna 210 · San Diego, CAThe total loss of engine power due to unknown reason(s). A factor in this accident was the lack of suitable terrain to land the airplane, without incurring damage to the airplane.NTSB LAX91LA234Accident · No injuriesLimited investigationFinal reportCessna T-210 · St. Helena, CAThat the pilot executed a poorly planned approach and failed to attain a proper touchdown point and delayed the go-around.NTSB LAX88FA162Accident · 2 fatalField investigationFinal reportCessna 210L · Maricopa, CAAircraft inadvertent flight into instrument meteorological conditions.NTSB LAX83LA084Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Ocotillo Wells, CAThe acft was on a night sightseeing flight when the engine quit. The fuel selector was on the left tank and the left tank was empty. The pilot switched tanks but the engine did not restart. The acft impacted the desert in a skid with left wing low. Post…NTSB LAX82FA345Accident · 2 fatalField investigationFinal reportBeech 200 · Huntington Beac, CAN9FQ, a Beech 200, had taken off from rwy 19R at john wayne arpt at santa ana, departed the traffic pattern on a right crosswind leg, & proceeded nw toward burbank. N732BP, a C-210L, was on a local training flt out of santa ana & had just completed practice…NTSB LAX82FA258Accident · Minor injuriesField investigationFinal reportCessna 210L · Santa Ana, CAAbout 3 mi se of the arpt, with gear down & full flaps, the eng fuel pressure went to zero & the eng lost power. The pltdid not declare an emergency, but advised tower that the acft lost the fuel pressure. The plt was then cleared for a landing on rwy 19R. As…NTSB LAX79FA017Accident · 1 fatalClosedCessna 210L · Irvine, CANTSB OAK77FXQ33Accident · No injuriesClosedCessna 210L · Beckwourth, CANTSB LAX77FUG23Accident · Minor injuriesClosedCessna 210 · Aguanga, CANTSB LAX76AL094Accident · 1 fatalClosedCessna 210 · San Diego, CANTSB LAX76DYA24Accident · No injuriesClosedCessna 210L · Lost Hills, CANTSB OAK75FVD19Accident · No injuriesClosedCessna 210 · Hoopa, CA