NTSB investigations: Cessna 210
14 cases on aircraft the registry lists as Cessna 210, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 2 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073402')
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\" = 353))
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 ('2073402')
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" = 353))
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 LAX05LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Apple Valley, CAloss of engine power due to fuel starvation/exhaustion, which was a result of the pilot's inadequate preflight inspection and failure to ensure there was enough fuel onboard for the flight.NTSB LAX99FA161Accident · 2 fatalField investigationFinal reportCessna 210 · Hayward, CAThe pilot's inadequate preflight planning and his failure to verify fuel consumption during flight that resulted in fuel exhaustion and subsequent collision with obstacles and the ground.NTSB FTW97LA307Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Eagle, COwater contamination of the fuel, which led to a total loss of engine power and a forced landing. Factors relating to the accident were: the delay in refueling the aircraft by the FBO, which allowed condensation to form in the fuel tanks, and inadequate…NTSB SEA95LA162Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Cody, WYThe pilot's failure to refuel which resulted in a loss of power due to fuel exhaustion.NTSB ATL93LA043Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Smithville, TNThe failure of the pilot to follow pilot manual procedures by slipping the aircraft with inadequate fuel available, which resulted in fuel starvation. Factors were the inadequate fuel supply on the aircraft and the failure of the pilot to refuel.NTSB FTW92LA031Accident · No injuriesLimited investigationFinal reportCessna 210 · Groves, TXFuel exhaustion which precipitated the forced landing due to the pilot's inadequate fuel consumption calculations. A factor in the accident was the pilot's failure to divert to an alternate destination when he recognized that fuel exhaustion was a possibility.NTSB DEN91LA014Accident · Minor injuriesLimited investigationFinal reportCessna T-210-M · Buena Vista, COThe pilot misjudged the fuel supply resulting in fuel exhaustion.NTSB CHI90DEV06Accident · Minor injuriesFinal reportCessna 210 · Salem, ILImproper positioning of the fuel selector by the pilot, which resulted in fuel starvation, and the pilot's improper emergency procedure.NTSB LAX90LA030Accident · Minor injuriesLimited investigationFinal reportCessna 210 · North Hollywood, CAImproper planning/decision by the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel. Factors related to the accident were: false fuel gage indications, lack of a suitable area for a forced landing, and obstructions (utility pole &…NTSB MIA90LA007Accident · No injuriesLimited investigationFinal reportCessna 210 · Jacksonville, FLInadequate preflight by the pilot, and fuel starvation, due to his improper positioning of the fuel selector.NTSB NYC88LA251Accident · No injuriesLimited investigationFinal reportCessna 210 · Kirkwood, NYThe plt attempted to land at a private airport at night on an unlit rwy. A go-around was initiated and during the go-around the eng lost pwr. A gear up landing was made beyond the rwy. The investigation revealed water in the fuel system. The eng was run up…NTSB DEN85LA090Accident · No injuriesLimited investigationFinal reportCessna 210 · Bountiful, UTOn March 8, 1985, a Cessna 210, operated by the pilot, lost engine power and was substantially damaged. The airplane departed hurricane, Utah and the destination was Bountiful skypark aprt. The pilot stated that the airplane was being ferried to the airport…NTSB LAX82FVG34Accident · Serious injuriesFinal reportCessna 210 · Placerville, CAPilot states he was descending from 10,000 feet to 8,000 feet when engine quit. Further stated fuel was above red arc-no steep or sharp maneuvers. No mention of rate of descent or deck angle in descent. Forced landing was made circling to right-useable fuel…NTSB CHI82DA173Accident · No injuriesFinal reportCessna 210 · Loganville, WIDuring landing approach the engine lost power and the pilot attempted to land in an open field. The aircraft failed to clear a terrace and the nose gear separated from the airplane. The pilot stated, "while concentrating on the various aspects of operation in…