# NTSB investigations: Cessna 172D: 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 NYC06CA107](https://openairdocs.org/ntsb/NYC06CA107.md): Cessna 172D · Lumberton, NJ · Accident · No injuries · Data collection · Final report · May 2, 2006 · N2549Y · Substantial damage
  > The student pilot's failure to maintain aircraft control while landing, which resulted in an runway overrun and subsequent impact with terrain.
- [NTSB CHI93LA080](https://openairdocs.org/ntsb/CHI93LA080.md): Cessna 172D · Slayton, MN · Accident · No injuries · Limited investigation · Final report · Jan 30, 1993 · N2440U · Substantial damage
  > The pilot's inadequate compensation for the crosswind condition. The crosswind was a factor.
- [NTSB MIA88LA253](https://openairdocs.org/ntsb/MIA88LA253.md): Cessna 172D · Tupelo, MS · Accident · No injuries · Limited investigation · Final report · Aug 11, 1988 · N2344U · Substantial damage
  > The private pilot landed on runway 18 after completing a cross-country flight. During landing roll the aircraft encountered a downwind gust of wind and the pilot lost control of the aircraft while on the ground. The propeller and right wing were substantially…
- [NTSB NYC88LA122](https://openairdocs.org/ntsb/NYC88LA122.md): Cessna 172 · Myerstown, PA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1988 · N2825U · Destroyed
  > The pilot stated that during takeoff the aircraft veered to the left and the left wheel dug into the sod. At the same time the right wing lifted up and the aircraft rolled over. The wind was variable at 10 to 15 knots, gusting to 30.

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