# NTSB investigations: Cessna R172K: 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 ATL05CA092](https://openairdocs.org/ntsb/ATL05CA092.md): Cessna 172 · Crossville, TN · Accident · Minor injuries · Data collection · Final report · Jun 3, 2005 · N1202V · Substantial damage
  > The pilot's continued VFR flight into IMC conditions which resulted in an in-flight collision with trees. A related factor was the clouds.
- [NTSB ANC03FA061](https://openairdocs.org/ntsb/ANC03FA061.md): Cessna 172 · Skagway, AK · Accident · 2 fatal · Field investigation · Final report · Jun 25, 2003 · N736QK · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Factors associated with the accident were low ceilings, rain, and fog.
- [NTSB IAD99FA005](https://openairdocs.org/ntsb/IAD99FA005.md): Cessna R172K · Bowie, MD · Accident · 1 fatal · Field investigation · Final report · Oct 13, 1998 · N736KL · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Also causal was the pilot's poor in-flight planning/decision, and his continued VFR flight into instrument meteorological conditions. A related factor was the fog.
- [NTSB LAX97FA093](https://openairdocs.org/ntsb/LAX97FA093.md): Cessna R172K · Bagdad, AZ · Accident · 1 fatal · Field investigation · Final report · Jan 22, 1997 · N736WZ · Destroyed
  > continued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from terrain. Factors relating to the accident were: the high/mountainous terrain and adverse weather conditions.
- [NTSB LAX93LA008](https://openairdocs.org/ntsb/LAX93LA008.md): Cessna R172K · Picacho, AZ · Accident · No injuries · Limited investigation · Final report · Oct 10, 1992 · N736WZ · Substantial damage
  > The pilot's encounter with the unforecasted cyclonic wind.
- [NTSB DEN90LA151](https://openairdocs.org/ntsb/DEN90LA151.md): Cessna 172XP · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Jul 2, 1990 · N736NB · Substantial damage
  > The flights encounter with turblence on final which resulted in a loss of control and a subsequent collision with the ground.
- [NTSB FTW89FA073](https://openairdocs.org/ntsb/FTW89FA073.md): Cessna 172XP · Hondo, TX · Accident · 4 fatal · Field investigation · Final report · Mar 28, 1989 · N736RT · Destroyed
  > The pilot's decision to depart into known adverse weather and his lack of instrument training and experience.
- [NTSB FTW88LA041](https://openairdocs.org/ntsb/FTW88LA041.md): Cessna 172XP · Godley, TX · Accident · No injuries · Limited investigation · Final report · Dec 23, 1987 · N736AN · Substantial damage
  > During a cross country flight, the weather worsened. Visibility decreased and the ceiling lowered, forcing the pilot to descend in order to remain VFR. The pilot elected to perform a precautionary landing in a field. During landing roll the pilot noticed a…
- [NTSB FTW87FA031](https://openairdocs.org/ntsb/FTW87FA031.md): Cessna 172K · El Reno, OK · Accident · 2 fatal · Field investigation · Final report · Dec 15, 1986 · N736XP · Destroyed
  > Private pilot of Cessna 172K attempted VFR flight in IFR flight conditions. Contacted okc approach control and requested special VFR approach during hours of darkness. Approach denied special VFR due to lack of instrument qualification of pilot. Pilot was…
- [NTSB FTW86LA072](https://openairdocs.org/ntsb/FTW86LA072.md): Cessna R172K · Waco, TX · Accident · No injuries · Limited investigation · Final report · Mar 21, 1986 · N758KU · Substantial damage
  > The pilot of a Cessna 172, N758KU, over-shot his approach to a privately owned grass strip. The runway is 05/23, 3180 foot long and 100 foot wide with an approximate 300 ft. displaced threshold at east end. The wind was variable from 300 degrees at 8 knots at…
- [NTSB DEN83FA214](https://openairdocs.org/ntsb/DEN83FA214.md): Cessna R172K · Silverton, CO · Accident · 1 fatal · Field investigation · Final report · Sep 8, 1983 · N758PB · Destroyed
  > The plt departed longmont, CO at about 0520 MDT. At 0617 MDT, he contacted the denver en route flt advisory service & received wx info. The location of the acft at that time was not determined. No further radio communications were received from the plt. A…
- [NTSB FTW83FPG02](https://openairdocs.org/ntsb/FTW83FPG02.md): Cessna R172K · Near Paris, AR · Accident · 2 fatal · Final report · Nov 12, 1982 · N736QD · Destroyed
  > The plt & pax were on a flt from amarillo, TX to little rock, AR. An enroute stop was made at haskell, ok at appr 1900 to refuel. The owner of the afpt at haskell stated that the plane arrived in a fairly heavy rainstorm. At that time, a winter type cold…
- [NTSB FTW82FRA14](https://openairdocs.org/ntsb/FTW82FRA14.md): Cessna R172K · Hearne, TX · Accident · 1 fatal · Final report · Jan 2, 1982 · N758SK · Destroyed
  > Before the aircraft took off, fog was noted at the airport. Witnesses reported that the ceiling was about 100 to 200 ft and the visibility was about 1/2 mile. Reportedly, the pilot tried to contact the fss by telephone; however, only a pay telephone was…

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