# NTSB investigations: Cessna 172C: 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 FTW03LA138](https://openairdocs.org/ntsb/FTW03LA138.md): Cessna 172C · Pecos, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 22, 2003 · N1667Y · Substantial damage
  > The failure of the pilot to maintain aircraft control while landing. A contributing factor was the gusty wind condition.
- [NTSB CHI93LA222](https://openairdocs.org/ntsb/CHI93LA222.md): Cessna 172 · St. Cloud, MN · Accident · No injuries · Limited investigation · Final report · Jun 25, 1993 · N1670Y · Substantial damage
  > the pilot's improper starting procedures.
- [NTSB CHI92LA171](https://openairdocs.org/ntsb/CHI92LA171.md): Cessna 172 · Liberty, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 1992 · N5533A · Substantial damage
  > The pilot-in-commands failure to maintain aircraft control. Related factors are the pilot's lack of total experience and improper recovery from a bounced landing.
- [NTSB MKC90LA098](https://openairdocs.org/ntsb/MKC90LA098.md): Cessna 172 · Ames, IA · Accident · Serious injuries · Limited investigation · Final report · Apr 29, 1990 · N8472X · Substantial damage
  > The wrong runway was selected and directional control was not maintained by the pilot in command.
- [NTSB ANC88DAG02](https://openairdocs.org/ntsb/ANC88DAG02.md): Cessna 172 · Willow, AK · Accident · No injuries · Final report · Jan 9, 1988 · N8439X · Substantial damage
  > The pilot stated that immediately upon touchdown, the airplane started sinking in (two feet) deep snow, and came to a stop in about 50 feet. The left wing and propeller struck the ground. The plt had overflown the arpt and saw the snow removal equipment about…
- [NTSB CHI86LA217](https://openairdocs.org/ntsb/CHI86LA217.md): Cessna 172C · Bement, IL · Accident · No injuries · Limited investigation · Final report · Aug 30, 1986 · N8404X · Substantial damage
  > On touchdown the aircraft was not properly aligned with the rwy. While rolling out the left wing caught the full grown corn on the left edge of the rwy and pulled the aircraft into the corn.
- [NTSB CHI86LA095](https://openairdocs.org/ntsb/CHI86LA095.md): Cessna 172C · Waupun, WI · Accident · No injuries · Limited investigation · Final report · Mar 1, 1986 · N1636Y · Substantial damage
  > Drg arrival for a x-wind landing, the plt made a high apch & used full flaps to steepen his dscnt over trees near the apch end of the rwy. He stated that the touchdown was normal, but before he could raise the flaps, the x-wind pushed the plane to the left.…

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