# NTSB investigations: Cessna 172L: Loss of control in flight

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 WPR20CA095](https://openairdocs.org/ntsb/WPR20CA095.md): Cessna 172 · Dubois, ID · Accident · No injuries · Data collection · Final report · Feb 27, 2020 · N7904G · Substantial damage
  > The student pilot's failure to maintain a proper airspeed and descent rate while conducting a low pass over a snow-covered runway after encountering a downdraft and the flight instructor's delayed action, which resulted in the wheels contacting the snow and…
- [NTSB GAA19CA424](https://openairdocs.org/ntsb/GAA19CA424.md): Cessna 172 · Grand Canyon, AZ · Accident · No injuries · Data collection · Final report · Jul 16, 2019 · N1079M · Substantial damage
  > The pilot's failure to maintain lateral control during landing in gusting wind conditions, which resulted in the left wing striking the ground.
- [NTSB ERA18FA174](https://openairdocs.org/ntsb/ERA18FA174.md): Cessna 172 · Diamondhead, MS · Accident · 1 fatal · Field investigation · Final report · Jun 22, 2018 · N7239Q · Destroyed
  > The student pilot's failure to retract the flaps following landing and the stall/mush that resulted during the subsequent full-flap takeoff and initial climb.
- [NTSB WPR17FA213](https://openairdocs.org/ntsb/WPR17FA213.md): Cessna 172L · Perkinsville, AZ · Accident · 2 fatal · Field investigation · Final report · Sep 22, 2017 · N7070Q · Destroyed
  > The pilot's decision to fly into a canyon during wind conditions conducive to turbulence and downdrafts, and his subsequent loss of aircraft control while maneuvering in the canyon. Contributing to the accident was the pilot's limited canyon flying experience.
- [NTSB GAA17CA216](https://openairdocs.org/ntsb/GAA17CA216.md): Cessna 172 · Twisp, WA · Accident · No injuries · Data collection · Final report · Apr 3, 2017 · N7547G · Substantial damage
  > The pilot’s failure to maintain crosswind correction during landing, which resulted in the airplane cartwheeling.
- [NTSB GAA16CA002](https://openairdocs.org/ntsb/GAA16CA002.md): Cessna 172 · Avalon, CA · Accident · No injuries · Data collection · Final report · Oct 1, 2015 · N4286Q · Substantial damage
  > The pilot's exceedance of the critical angle of attack in turbulent and downdraft conditions, which resulted in an aerodynamic stall and collision with terrain on final approach.
- [NTSB ERA13CA392](https://openairdocs.org/ntsb/ERA13CA392.md): Cessna 172L · McComb, MS · Accident · Minor injuries · Data collection · Final report · Aug 30, 2013 · N7892G · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during approach to landing, which resulted in an aerodynamic stall and subsequent loss of control.
- [NTSB DEN08FA155](https://openairdocs.org/ntsb/DEN08FA155.md): Cessna 172L · York, NE · Accident · 2 fatal · Field investigation · Final report · Sep 19, 2008 · N4380Q · Substantial damage
  > The student pilot's failure to maintain aircraft control, and the flight instructor's failure to take remedial action, for undetermined reasons.

## 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 ('2072432')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/240/sequence?model=2072432

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