# NTSB investigations: Cessna 210H: 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 MKC86FA053](https://openairdocs.org/ntsb/MKC86FA053.md): Cessna 210H · Fremont, NE · Accident · 4 fatal · Field investigation · Final report · Jan 19, 1986 · N5961F · Destroyed
  > The plt of N5961F received a wx brf about 40 min before the acdt for a VFR flt from Fremont to cheyenne. The 3 reporting stations nearest to Fremont were IFR and local authorities who helped search for the acdt site reported low clouds and haze. There were no…
- [NTSB NYC83FA198](https://openairdocs.org/ntsb/NYC83FA198.md): Cessna 210H · Marlborough, CT · Accident · 3 fatal · Field investigation · Final report · Aug 1, 1983 · N1968X · Destroyed
  > The acft collided with trees and the ground during an approach to land on a foggy night at an arpt with no instrument approach facilities or control. The 67 year old plt had canceled his IFR flt plan at 2110 EDT. The accident occurred at 2115 EDT. The plt and…

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