# NTSB investigations: Cessna 210N: In flight encounter with weather

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB FTW04FA079](https://openairdocs.org/ntsb/FTW04FA079.md): Cessna 210N · Valley Spring, TX · Accident · 1 fatal · Field investigation · Final report · Feb 22, 2004 · N6175Y · Destroyed
  > The 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 NYC99FA198](https://openairdocs.org/ntsb/NYC99FA198.md): Cessna 210 · Mount Pocono, PA · Accident · 2 fatal · Field investigation · Final report · Aug 13, 1999 · N4827C · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain aircraft control. A related factor was the fog.
- [NTSB BFO90FA045](https://openairdocs.org/ntsb/BFO90FA045.md): Cessna 210N · Shady Grove Cor, VA · Accident · 6 fatal · Field investigation · Final report · May 10, 1990 · N6481N · Destroyed
  > VFR 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 BFO88FA026](https://openairdocs.org/ntsb/BFO88FA026.md): Cessna 210N · Quantico, VA · Accident · 3 fatal · Field investigation · Final report · Mar 20, 1988 · N6401N · Destroyed
  > The 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 FTW87FA064](https://openairdocs.org/ntsb/FTW87FA064.md): Cessna 210N · Diboll, TX · Accident · 2 fatal · Field investigation · Final report · Feb 7, 1987 · N6497N · Destroyed
  > Acft 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…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/ntsb?model=2073453&occurrence=240

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
