# NTSB investigations: Cessna 172D: 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 LAX96FA121](https://openairdocs.org/ntsb/LAX96FA121.md): Cessna 172D · Julian, CA · Accident · 3 fatal · Field investigation · Final report · Feb 26, 1996 · N2598U · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions which resulted in an inadvertent stall/spin. The pilot's inadequate preflight/preparation, low clouds, fog, and mountain obscuration were factors in the accident.
- [NTSB ATL91FAMS1](https://openairdocs.org/ntsb/ATL91FAMS1.md): Cessna 172D · Missing (Atlantic Ocean) · Accident · 2 fatal · Missing aircraft · Final report · Jan 7, 1991 · N2165Y · Destroyed
  > The pilot's continuation of visual flight into instrument meteorological conditions which resulted in spatial disorientation and a loss of aircraft control. Factors related to the accident were: the pilot's failure to obtain a weather briefing before…
- [NTSB NYC90LA131](https://openairdocs.org/ntsb/NYC90LA131.md): Cessna 172 · Augusta, ME · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 1990 · N2898U · Destroyed
  > Poor judgement of the pilot, his decision to attempt VFR flight in instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the pilot's lack of proper certification…
- [NTSB ATL89LA083](https://openairdocs.org/ntsb/ATL89LA083.md): Cessna 172D · Cumming, GA · Accident · Serious injuries · Limited investigation · Final report · Jan 27, 1989 · N2556U · Destroyed
  > The pilot's decision to attempt VFR flight in adverse meteorological conditions at night with an inoperative attitude indicator and insufficient fuel reserve for the intended flight.
- [NTSB ATL87LA103](https://openairdocs.org/ntsb/ATL87LA103.md): Cessna 172D · Oliver Springs, TN · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 1987 · N2510Y · Substantial damage
  > The plt reported that the acft encountered heavy turbulence and a strong gusty x-wind close to the ground while on short final to his private airstrip. The plt attempted a go-around and encountered 'extremely heavy turbulence' during a turning climbout…

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