# NTSB investigations: Cessna 172E: 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 FTW01FA098](https://openairdocs.org/ntsb/FTW01FA098.md): Cessna 172E · Bay City, TX · Accident · 1 fatal · Field investigation · Final report · Apr 13, 2001 · N5638T · Destroyed
  > the pilot's delay in taking remedial action (contacting ATC) after he became lost/disoriented during a night cross country flight, which resulted in a forced landing due to fuel exhaustion. Contributing factors to the accident were the pilot's failure to…
- [NTSB FTW98LA295](https://openairdocs.org/ntsb/FTW98LA295.md): Cessna 172E · Watkins, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1998 · N7780U · Destroyed
  > The pilot's inadequate evaluation of the weather which resulted in an encounter with a microburst. Contributing was the airplane's climb capability exceeded by the microburst, and rising terrain.
- [NTSB LAX95LA221](https://openairdocs.org/ntsb/LAX95LA221.md): Cessna 172 · Yerington, NV · Accident · No injuries · Limited investigation · Final report · Jun 23, 1995 · N5363T · Substantial damage
  > The pilot's improper in-flight decision to enter mountainous terrain at an insufficient altitude to safely escape adverse weather conditions. Factors relating to the accident were: the terrain and weather conditions.
- [NTSB BFO95LA059](https://openairdocs.org/ntsb/BFO95LA059.md): Cessna 172E · Muncy Valley, PA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1995 · N3070U · Substantial damage
  > the non-instrument rated pilot's failure to maintain clearance from terrain after inadvertently entering instrument meteorological conditions. The weather conditions (haze and fog) were a factor in the accident.
- [NTSB ATL94FA023](https://openairdocs.org/ntsb/ATL94FA023.md): Cessna 172 · Gadsden, AL · Accident · 1 fatal · Field investigation · Final report · Nov 26, 1993 · N7702U · Substantial damage
  > The pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.
- [NTSB BFO92LA126](https://openairdocs.org/ntsb/BFO92LA126.md): Cessna 172E · Tuckahoe, NJ · Accident · 1 fatal · Limited investigation · Final report · Sep 4, 1992 · N3847S · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the light conditions at dusk (or darkness), and the pilot's lack…
- [NTSB FTW90LA049](https://openairdocs.org/ntsb/FTW90LA049.md): Cessna 172E · Hammond, LA · Accident · Minor injuries · Limited investigation · Final report · Jan 4, 1990 · N3531S · Destroyed
  > Pilot in command's initiation and continuation of the flight into an area of known IMC weather conditions and his subsequent inability to land prior to running out of fuel. Contributing factors to the accident were the pilot's failure to exercise good…
- [NTSB SEA88FA169](https://openairdocs.org/ntsb/SEA88FA169.md): Cessna 172E · Petersburg, AK · Accident · 4 fatal · Field investigation · Final report · Sep 5, 1988 · N3841S · Destroyed
  > Plt was briefed for marginal VFR conditions. Witnesses on departure noted fog bank offshore from airport. Witnesses near accident site, 10 mi from departure point, heard acft and sounds of impact. They reported fog on the water and glassy water conditions.
- [NTSB DEN87FA039](https://openairdocs.org/ntsb/DEN87FA039.md): Cessna 172E · Crossroads, NM · Accident · 1 fatal · Field investigation · Final report · Dec 21, 1986 · N7821U · Destroyed
  > The student plt with no simulated or actual instrument and a total of 9 hours night flt time called the amarillo FAA fss, who briefed him on wx for a flt from borger, Texas, to big spring, Texas, located 210 NM south. He was briefed on marginal VFR wx en…

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