# NTSB investigations: Cessna 210D: 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 SEA96FA021](https://openairdocs.org/ntsb/SEA96FA021.md): Cessna 210D · Yellow Pine, ID · Accident · 3 fatal · Field investigation · Final report · Nov 18, 1995 · N3741Y · Destroyed
  > improper planning/decision by the pilot, his resultant VFR flight into instrument meteorological conditions (IMC), and his failure to maintain altitude and clearance from mountainous terrain. Factors relating to the accident were: the adverse weather…
- [NTSB FTW89FA172](https://openairdocs.org/ntsb/FTW89FA172.md): Cessna 210D · Covington, LA · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1989 · N3962Y · Destroyed
  > The pilot in command's disregard of the weather information provided during two briefings and his decision to continue VFR flight into IMC condtions. Factors contributing to the accident were the pilot's lack of night and instrument experience.
- [NTSB DEN89FA091](https://openairdocs.org/ntsb/DEN89FA091.md): Cessna 210D · Eugene, OR · Accident · 1 fatal · Field investigation · Final report · Mar 23, 1989 · N3823Y · Destroyed
  > The pilot's decision to continue VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: the terrain and weather conditions at the accident site, and the pilot's lack of instrument experience.
- [NTSB CHI89FA039](https://openairdocs.org/ntsb/CHI89FA039.md): Cessna 210D · Alvin, IL · Accident · 2 fatal · Field investigation · Final report · Jan 1, 1989 · N3767Y · Destroyed
  > Continued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude. Factors related to the accident were: darkness, adverse weather conditions, the pilot's lack of instrument…

## 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 ('2073414')
    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=2073414&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.