# NTSB investigations: Cessna 172E: 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 CHI07CA090](https://openairdocs.org/ntsb/CHI07CA090.md): Cessna 172E · Big Rapids, MI · Accident · No injuries · Data collection · Final report · Mar 14, 2007 · N3622S · Substantial damage
  > The student pilot's failure to maintain directional control of the airplane during takeoff which led to the impact with the snow banks adjacent to the runway. The snow banks were contributing factors in the accident.
- [NTSB CHI06CA123](https://openairdocs.org/ntsb/CHI06CA123.md): Cessna 172E · Richmond, IN · Accident · No injuries · Data collection · Final report · Apr 22, 2006 · N2985U · Substantial damage
  > The pilot's inadequate compensation for wind conditions during the landing. Factors were the crosswind and gusts.
- [NTSB CHI06CA120](https://openairdocs.org/ntsb/CHI06CA120.md): Cessna 172E · Wadena, MN · Accident · No injuries · Data collection · Final report · Apr 19, 2006 · N5766T · Substantial damage
  > The pilot's inadequate compensation for the wind conditions during the landing. Factors were the crosswinds, the gusts, and the ditch.
- [NTSB SEA04LA053](https://openairdocs.org/ntsb/SEA04LA053.md): Cessna 172E · Raymond, WA · Accident · No injuries · Limited investigation · Final report · Mar 21, 2004 · N3950S · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll resulting in the aircraft nosing over. Incorrect remedial action and soft terrain were factors.
- [NTSB NYC04CA068](https://openairdocs.org/ntsb/NYC04CA068.md): Cessna 172E · Batavia, NY · Accident · No injuries · Data collection · Final report · Feb 15, 2004 · N369WP · Substantial damage
  > The pilot's failure to maintain directional control while landing. Factors were a tailwind and icy runway.
- [NTSB FTW02LA170](https://openairdocs.org/ntsb/FTW02LA170.md): Cessna 172E · Navajo Dam, NM · Accident · No injuries · Limited investigation · Final report · Jun 2, 2002 · N364SR · Substantial damage
  > the pilot's failure maintain directional control of the airplane during a touch and go landing which resulted in a collision with trees. A contributing factor was the gusting wind conditions.
- [NTSB DEN99LA125](https://openairdocs.org/ntsb/DEN99LA125.md): Cessna 172E · Peyton, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1999 · N5696T · Substantial damage
  > The pilot's failure to maintain directional control of the aircraft during landing touchdown. Factors were the crosswind and the ditch.
- [NTSB FTW99LA071](https://openairdocs.org/ntsb/FTW99LA071.md): Cessna 172E · Guymon, OK · Accident · No injuries · Limited investigation · Final report · Jan 26, 1999 · N5606T · Substantial damage
  > The pilot's failure to maintain aircraft control. A factor was the gusty crosswind.
- [NTSB CHI87LA096](https://openairdocs.org/ntsb/CHI87LA096.md): Cessna 172E · Muncie, IN · Accident · No injuries · Limited investigation · Final report · Mar 16, 1987 · N7757U · Substantial damage
  > According to the plt, he contacted the mie tower about 20 miles north of Muncie, Indiana and received a weather briefing with a choice of rwy 14 or 02. The plt stated that the winds were reported as 12 knots from 080, and he chose to land on rwy 14. According…
- [NTSB SEA86LA103](https://openairdocs.org/ntsb/SEA86LA103.md): Cessna 172 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N5786T · Substantial damage
  > The student plt lost control of the acft during high gusty wind conditions. The acft then veered to the right of the rwy. The wind at the time of the accident was from 280 degrees at 28 knots gusting to 31 knots.
- [NTSB NYC86LA062](https://openairdocs.org/ntsb/NYC86LA062.md): Cessna 172 · Durhamville, NY · Accident · No injuries · Limited investigation · Final report · Jan 16, 1986 · N5456T · Substantial damage
  > The flight was returning from a 4-LEG 300-mile cross country trip. On flare touchdown, the pilot reported severe vibration. As brakes were applied the vibration increased, and the aircraft became uncontrollable. The aircraft pulled to the right and collided…
- [NTSB MKC84LA030](https://openairdocs.org/ntsb/MKC84LA030.md): Cessna 172 · Hampton, IA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1983 · N7737U · Substantial damage
  > On his fourth touch and go landing the pilot added power for the go-around and the aircraft drifted off the left side of the runway. The left main gear hit a snowbank and the aircraft flipped over landing upside down in the snow. The winds at macon city, IA…
- [NTSB CHI83LA177](https://openairdocs.org/ntsb/CHI83LA177.md): Cessna 172 · Youngstown, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 1983 · N5527T · Destroyed
  > The pilot stated that during a landing, the left wing was caught by the wind and the aircraft drifted to the right. A go-around was initiated but the aircraft struck a runway light and a runway distance marker and nosed over.

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