NTSB investigations: Cessna 210
11 cases on aircraft the registry lists as Cessna 210, where the first occurrence was “Loss of engine power”. 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
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 350))
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" = 350))
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 CHI07LA129Accident · No injuriesLimited investigationFinal reportCessna 210 · Vienna, OHLoss of engine power during approach for undetermined reasons. Unsuitable terrain encountered during the forced landing and a vehicle were factors.NTSB DFW06CA165Accident · No injuriesData collectionFinal reportCessna 210 · Lawton, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX04LA083Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rialto, CAThe pilot's inadequate in-flight planning/decision by his fuel mismanagement and his delay in initiating remedial action which resulted in fuel exhaustion and the loss of engine power.NTSB IAD02LA049Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Westhampton Bch, NYLoss of engine power for undetermined reasons.NTSB FTW00LA051Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Bulverde, TXThe total loss of engine power for an undetermined reason.NTSB ATL96LA081Accident · No injuriesLimited investigationFinal reportCessna 210 · Knoxville, TNThe pilot's failure to heed known operating information by not correcting the flight attitude to prevent fuel unporting during a prolonged slipped descent.NTSB ATL90LA185Accident · No injuriesLimited investigationFinal reportCessna 210 · White Plains, GAThe fuel starvation to the engine for undertermined reasons.NTSB DEN90LA007Accident · No injuriesLimited investigationFinal reportCessna 210 · Ogden, UTAn engine stoppage for undetermined reasons.NTSB SEA88LA104Accident · No injuriesLimited investigationFinal reportCessna 210 · Reno, NVDuring an instructional flight and an ILS approach, a total loss of engine power occurred at about 1200 feet AGL. A forced landing was made onto rough terrain. During landing roll the nose gear separated from the aircraft. The private pilot receiving…NTSB SEA86LA196Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Stibnite, IDThe pilot executed a steep, reduced power descent into the destination airstrip. He then reported that when he attempted to reduce the rate of descent with a power application, the engine did not respond. There was no evidence of any mechanical malfunction…NTSB FTW84LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Truth Or Cons, NMThe plt reported that while the acft was cruising at 10,500 ft MSL, the eng lost power & he was unable to restart it. During an emergency landing, the nose gear hit a rock & collapsed. The acft was checked, but the eng could not be started, when 1st…