# NTSB investigations: Cessna 150: 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 IAD97LA019](https://openairdocs.org/ntsb/IAD97LA019.md): Cessna 150 · Edgerton, OH · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 1996 · N5627E · Destroyed
  > the pilot's Inadvertent VFR flight into instrument meteorological conditions resulting in spatial disorientation and subsequent loss of control of the airplane. Factors to this accident were the night conditions and snow.
- [NTSB ATL88LA255](https://openairdocs.org/ntsb/ATL88LA255.md): Cessna 150 · Bessemer City, NC · Accident · No injuries · Limited investigation · Final report · Sep 25, 1988 · N7831E · Substantial damage
  > The pilot reported that he had observed a cloud layer forming along his flt route. At about the same time, the acft VOR rcvr failed. The plt elected to continue vfr-on-top to his planned destination based on VFR wx reported by an ATIS broadcast from an arpt…
- [NTSB DEN84LA020](https://openairdocs.org/ntsb/DEN84LA020.md): Cessna 150M · Hillsboro, ND · Accident · No injuries · Limited investigation · Final report · Nov 2, 1983 · N6141K · Destroyed
  > The student plt encountered fog immediately after takeoff at about 150 AGL. The plt looked back & could still see the rwy lights, he then began a descending rt turn to the rwy to land. During this descending turn, the rt wing hit the ground followed by the…
- [NTSB FTW83LA065](https://openairdocs.org/ntsb/FTW83LA065.md): Cessna 150 · Nash, OK · Accident · No injuries · Limited investigation · Final report · Dec 22, 1982 · N14084 · Substantial damage
  > Pilot encountered fog and decided to land in a wheat field looked frozen but was soft and aircraft nosed over. There were 3 local airports within 20 miles.

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