# NTSB investigations: Cessna 172A: 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 ANC07LA031](https://openairdocs.org/ntsb/ANC07LA031.md): Cessna 172A · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Apr 25, 2007 · N7224T · Substantial damage
  > The pilot's inadequate compensation for wind conditions, which resulted in a loss of control during landing, and collision with objects. Factors associated with the accident were wind gusts and a crosswind.
- [NTSB SEA06CA041](https://openairdocs.org/ntsb/SEA06CA041.md): Cessna 172A · Othello, WA · Accident · No injuries · Data collection · Final report · Jan 8, 2006 · N9852T · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll. A factor was the berm.
- [NTSB LAX00LA053](https://openairdocs.org/ntsb/LAX00LA053.md): Cessna 172A · Shoshone, CA · Accident · No injuries · Limited investigation · Final report · Dec 18, 1999 · N34261 · Substantial damage
  > The pilot's inadequate compensation for the existing strong and gusting wind conditions and his subsequent failure to maintain directional control.
- [NTSB LAX95LA316](https://openairdocs.org/ntsb/LAX95LA316.md): Cessna 172A · Weed, CA · Accident · No injuries · Limited investigation · Final report · Aug 30, 1995 · N7641T · Substantial damage
  > the flight instructor's failure to maintain directional control of the aircraft.
- [NTSB FTW88LA117](https://openairdocs.org/ntsb/FTW88LA117.md): Cessna 172A · Cleveland, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1988 · N7317T · Substantial damage
  > This acft was damaged when it collided with a ditch and flipped over. The acft's battery was dead and the plt hand propped the eng without the benefit of chocks or an experienced individual in the cockpit. The eng started and as the plt was attempting to…
- [NTSB LAX86LA230](https://openairdocs.org/ntsb/LAX86LA230.md): Cessna 172B · Tracy, CA · Accident · No injuries · Limited investigation · Final report · May 18, 1986 · N7176T · Substantial damage
  > The acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…
- [NTSB DEN86LA053](https://openairdocs.org/ntsb/DEN86LA053.md): Cessna 172A · Anthony, NM · Accident · No injuries · Limited investigation · Final report · Dec 22, 1985 · N7451T · Substantial damage
  > The plt was practicing emer ldgs on a dirt road. During the last ldg which resulted in an accident, he allowed his attention to be diverted momentarily to inside the cockpit and he lost control of the acft. The acft veered off the roadand sustained…
- [NTSB LAX83LA284](https://openairdocs.org/ntsb/LAX83LA284.md): Cessna 172A · Carmel Valley, CA · Accident · No injuries · Limited investigation · Final report · Jun 5, 1983 · N9854T · Substantial damage
  > According to the pilot there were no tiedowns, chocks or other restraining devices available so he ask a non certificated person to sit in the aircraft and apply the brakes while he rotated the prop by hand to start the engine. The engine started and the…
- [NTSB CHI82DA151](https://openairdocs.org/ntsb/CHI82DA151.md): Cessna 172A · Cissno Park, IL · Accident · No injuries · Final report · May 5, 1982 · N7709T · Substantial damage
  > During takeoff on runway 09, the aircraft veered to the left. The pilot closed the throttle, but was unable to stop before the left wheel went into soft soil on the north side of the runway. Gusty winds from the south picked up the tail and gently rolled the…

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