NTSB investigations: Cessna 210L, OH
8 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
| 1975 | 1 |
|---|---|
| 1976 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1999 | 2 |
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\" = 'OH' 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" = 'OH' 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 NYC00LA046Accident · No injuriesLimited investigationFinal reportCessna 210L · Columbus, OHThe pilot's failure to verify landing gear extension. Factors were the unreliable retraction/extension assembly, and the flying club's continued operation of the airplane with known deficiencies in the equipment.NTSB NYC00FA020Accident · 2 fatalField investigationFinal reportCessna 210L · Medina, OHThe pilot's failure to maintain proper altitude during the final approach segment of the visual approach. A factor was the diminishing light conditions of a deepening dusk.NTSB NYC93LA021Accident · No injuriesLimited investigationFinal reportCessna 210L · Cincinnati, OHThe failure of the pilot to maintain directional control during landing which resulted in the airplane striking a drainage ditch. Factors related to the accident were the crosswind and the drainage ditch.NTSB CHI90LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · New Phila, OHThe pilot's failure to drain all of the trapped water from the fuel system prior to flight. Factors related to the accident were: the unfavorable wind condition and trees in the emergency landing area.NTSB CHI82FEK02Accident · No injuriesClosedCessna 210L · Columbus, OHNTSB CHI78FEG03Accident · Serious injuriesClosedCessna 210L · Washington Ch, OHNTSB CHI76FEI37Accident · Minor injuriesClosedCessna 210L · Wadsworth, OHNTSB CHI75FEK25Accident · No injuriesClosedCessna 210L · Urbana, OH