NTSB investigations: Cessna 210N
5 cases on aircraft the registry lists as Cessna 210N, where the first occurrence was “In flight encounter with weather”. 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
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1990 | 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 ('2073453')
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\" = 240))
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 ('2073453')
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" = 240))
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 FTW04FA079Accident · 1 fatalField investigationFinal reportCessna 210N · Valley Spring, TXThe pilot's continued flight into known adverse weather and failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, due to spatial disorientation.NTSB NYC99FA198Accident · 2 fatalField investigationFinal reportCessna 210 · Mount Pocono, PAThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain aircraft control. A related factor was the fog.NTSB BFO90FA045Accident · 6 fatalField investigationFinal reportCessna 210N · Shady Grove Cor, VAVFR flight by the non-instument rated pilot into instrument meteorological conditions (IMC), his loss of aircraft control, due to spatial disorientation, and his exceeding the design stress limits of the aircraft, while recovering from an uncontrolled…NTSB BFO88FA026Accident · 3 fatalField investigationFinal reportCessna 210N · Quantico, VAThe acft was abt 25 mi south & inbound to dca when the plt rprtd an enctr with snowshwrs which were part of a cold front. He asked & was clrd to dscnd to 2500 ft so he could maint VMC. Radar data showed, the acft dscndd past 2500 ft to 1300 ft. abt 16 mi…NTSB FTW87FA064Accident · 2 fatalField investigationFinal reportCessna 210N · Diboll, TXAcft was destroyed when it impacted the ground in an uncontrolled attitude at high speed. The non-instrument rated pvt plt had filed IFR and departed into M80VC 5 l-f weather with tops above 8,000'. About 20 minutes after departure, the plt reported to the…