# NTSB investigations: Cessna 172G: On ground/water 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 CHI90LA037](https://openairdocs.org/ntsb/CHI90LA037.md): Cessna 172G · Savoy, IL · Accident · No injuries · Limited investigation · Final report · Dec 2, 1989 · N3783L · Substantial damage
  > Improper planning/decision by the pilot, which resulted in his inability to maintain control of the aircraft. A factor related to the accident was: the adverse wind condition.
- [NTSB DEN89LA053](https://openairdocs.org/ntsb/DEN89LA053.md): Cessna 172 · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · Jan 2, 1989 · N4440L · Substantial damage
  > Improper planning/decision by the pilot. Factors related to the accident were the high wind and gusts, which he was unable to compensate for.
- [NTSB FTW88DPJ06](https://openairdocs.org/ntsb/FTW88DPJ06.md): Cessna 172G · Frederick, OK · Accident · Serious injuries · Final report · Jun 9, 1988 · N1103F · Substantial damage
  > During slow taxi to takeoff, a gust of wind or a dust devil lifted aircraft off taxiway and flipped it inverted. Numerous small whirlwinds were observed in the vicinity of the airport at the time.
- [NTSB DEN88LA103](https://openairdocs.org/ntsb/DEN88LA103.md): Cessna 172G · Las Vegas, NM · Accident · No injuries · Limited investigation · Final report · May 1, 1988 · N6059R · Substantial damage
  > The private plt and his daughter were on a cross country flight. Landing with a strong headwind and reported gusts to 31 knots, the plt taxied clear of the runway. A 90 degree turn crosswind on the taxiway resulted in wind lifting the left wing and a loss of…
- [NTSB MKC88LA068](https://openairdocs.org/ntsb/MKC88LA068.md): Cessna 172G · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Mar 24, 1988 · N72PF · Substantial damage
  > The pilot reported that while taxiing for takeoff a wind gust caught the wing of the aircraft resulting in loss of aircraft control. Aircraft moved nose down and the propeller and the right wing contacted the runway. Winds at the time of the accident were 180…
- [NTSB LAX85LA149](https://openairdocs.org/ntsb/LAX85LA149.md): Cessna 172G · Mojave, CA · Accident · No injuries · Limited investigation · Final report · Feb 20, 1985 · N1112F · Substantial damage
  > Prior to landing the plt was advised of wind gusts as high as 68 KTS. Plt landed & while taxiing to the ramp a gust of wind was experienced which blew the acft over to an inverted position.

## 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 ('2072420')
    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" = 330))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072420&occurrence=330

---
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.