NTSB investigations: Cessna 210
10 cases on aircraft the registry lists as Cessna 210, where the first occurrence was “Hard landing”. 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
| 1984 | 1 |
|---|---|
| 1987 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 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\" = 200))
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" = 200))
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 ATL04FA079Accident · 2 fatalField investigationFinal reportCessna 210 · Blountville, TNThe pilot's improper flare, and improper recovery which resulted in a bounced landing, collapse of the left main landing gear, and the pilot's failure to maintain airspeed while maneuvering resulting in a stall, uncontrolled descent, and collision with the…NTSB CHI03LA326Accident · No injuriesLimited investigationFinal reportCessna 210 · St. Paul, MNThe pilot in command performing an improper flare.NTSB FTW02LA131Accident · No injuriesLimited investigationFinal reportCessna 210 · Albuquerque, NMthe pilot's inadequate compensation for the wind conditions resulting in a hard landing. A contributing factor was the gusty winds.NTSB CHI01LA208Accident · No injuriesLimited investigationFinal reportCessna 210 · Saint Charles, MOthe inadequate flare by the pilot.NTSB ATL98LA048Accident · No injuriesLimited investigationFinal reportCessna 210 · Hazel Green, ALthe pilot's improper flare, which resulted in a hard landing and the nose gear collapsing.NTSB LAX92LA291Accident · No injuriesLimited investigationFinal reportCessna 210 · Truckee, CAThe pilot's improper flare.NTSB SEA91LA149Accident · No injuriesLimited investigationFinal reportCessna 210 · Salt Lake City, UTThe pilot's poor inflight planning and decisions in that he failed to anticipate wake turbulence from the departing helicopter.NTSB NYC88LA040Accident · No injuriesLimited investigationFinal reportCessna 210 · Schenectady, NYDuring landing, the left main gear collapsed. A metallurgical examination revealed that the left main gear saddle assembly was fractured into three pieces through the area near the forward edge of the landing gear strut. When examined further, the faces and…NTSB DEN88LA018Accident · No injuriesLimited investigationFinal reportCessna 210 · Greeley, COThe CFI was instructing the private rated plt in simulated forced landings. The plt reported that after a full stop landing, the aircraft would not turn properly to the right, and she suspected brake system failure. The CFI took control and attempted to taxi…NTSB DEN84LA067Accident · No injuriesLimited investigationFinal reportCessna 210 · Grand Junction, COThe plt stated he touched down too hard, bounced & that he over-corrected causing the acft to land hard again collapsingthe nose gear.