# NTSB investigations: Cessna 172G: Loss of control - on ground/water

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 LAX97LA054](https://openairdocs.org/ntsb/LAX97LA054.md): Cessna 172G · Chino, CA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1996 · N5854R · Destroyed
  > the pilot's attempt to taxi with a crosswind component well in excess of the aircraft's maximum factory demonstrated capability. The wind conditions were factors.
- [NTSB SEA92LA059](https://openairdocs.org/ntsb/SEA92LA059.md): Cessna 172G · Billings, MT · Accident · No injuries · Limited investigation · Final report · Mar 15, 1992 · N4615L · Substantial damage
  > The pilot's failure to maintain directional control. A factor was the crosswind.
- [NTSB SEA91LA011](https://openairdocs.org/ntsb/SEA91LA011.md): Cessna 172G · Anacortes, WA · Accident · No injuries · Limited investigation · Final report · Oct 27, 1990 · N4174L · Substantial damage
  > The pilot poorly compensated for the wind condition.
- [NTSB MKC86LA065](https://openairdocs.org/ntsb/MKC86LA065.md): Cessna 172 · Grain Valley, MO · Accident · No injuries · Limited investigation · Final report · Mar 2, 1986 · N3979L · Substantial damage
  > The PIC was making a roundtrip flt to numerous airports across Kansas and Missouri. The owner of the aircraft was aboard for the trip which was for pleasure. The PIC had obtained weather info and was apprised of the wind conditions for his route of flt. Upon…
- [NTSB LAX85LA189](https://openairdocs.org/ntsb/LAX85LA189.md): Cessna 172G · Show Low, AZ · Accident · No injuries · Limited investigation · Final report · Mar 27, 1985 · N3757L · Substantial damage
  > Instructor plt stated that prior to departure for Show Low he called the fixed base operator at Show Low and learned the winds were currently from 190 to 200 degrees a 20 T0 30 knots. He and his student departed and upon arriving in the Show Low area learned…
- [NTSB MKC83LA229](https://openairdocs.org/ntsb/MKC83LA229.md): Cessna 172G · La Porte City, IA · Accident · No injuries · Limited investigation · Final report · Jun 18, 1983 · N3862L · Substantial damage
  > Scattered rain showers in the area had just made the turf rwy wet. The pilot reported that as he turned off the rwy the acft skidded and went sideways into a ditch.
- [NTSB CHI82DA095](https://openairdocs.org/ntsb/CHI82DA095.md): Cessna 172G · Cambridge, MN · Accident · No injuries · Final report · Mar 11, 1982 · N1120F · Substantial damage
  > After landing on runway 16, the aircraft ran off the right side of the runway. It hit a snowbank, and both wing spars were bent.

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

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

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