# NTSB investigations: Cessna 172B: 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 SEA07CA107](https://openairdocs.org/ntsb/SEA07CA107.md): Cessna 172B · Los Angeles, CA · Accident · Minor injuries · Data collection · Final report · Apr 19, 2007 · N7546X · Substantial damage
  > The pilot's failure to maintain adequate airspeed during performance of a go around, resulting in an inadvertent stall and in-flight collision with the ground.
- [NTSB FTW03LA116](https://openairdocs.org/ntsb/FTW03LA116.md): Cessna 172B · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Mar 26, 2003 · N6947X · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall.
- [NTSB CHI95LA055](https://openairdocs.org/ntsb/CHI95LA055.md): Cessna 172 · Allegan, MI · Accident · No injuries · Limited investigation · Final report · Dec 21, 1994 · N7656X · Substantial damage
  > the student pilot's failure to maintain directional control which resulted in the inability to obtain proper runway alignment. Related factors are the student pilot's lack of total flight experience and the snowbank.
- [NTSB CHI94LA216](https://openairdocs.org/ntsb/CHI94LA216.md): Cessna 172B · Shiocton, WI · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 1994 · N7472X · Destroyed
  > the pilot's failure to maintain Vso during takeoff. Factors related to the accident was the disregard for performance data and trees.
- [NTSB ATL92FA108](https://openairdocs.org/ntsb/ATL92FA108.md): Cessna 172B · Cherokee, NC · Accident · 3 fatal · Field investigation · Final report · May 24, 1992 · N8102X · Destroyed
  > The failure of the pilot to maintain control of the aircraft as a result of spatial disorientation. The lack of total flight time, and rain in the accident area were factors in the accident.
- [NTSB FTW92LA088](https://openairdocs.org/ntsb/FTW92LA088.md): Cessna 172B · Scottsville, TX · Accident · No injuries · Limited investigation · Final report · Apr 1, 1992 · N7492X · Substantial damage
  > Pilots' inadequate compensation for unfavorable windshift. A facator was the unfavorable wind.
- [NTSB DEN91LA058](https://openairdocs.org/ntsb/DEN91LA058.md): Cessna 172B · La Junta, CO · Accident · Minor injuries · Limited investigation · Final report · Mar 31, 1991 · N6904X · Substantial damage
  > The pilot's failure to maintain adequate airspeed and the resultant inadvertent stall. The pilot's failure to raise the flaps was a factor in the accident.
- [NTSB CHI89LA020](https://openairdocs.org/ntsb/CHI89LA020.md): Cessna 172B · Columbus, OH · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 1988 · N7418X · Substantial damage
  > Student pilot's failure to maintain control of the airplane during landing flare.
- [NTSB DEN86LA140](https://openairdocs.org/ntsb/DEN86LA140.md): Cessna 172B · Alamosa, CO · Accident · No injuries · Limited investigation · Final report · May 19, 1986 · N6990X · Substantial damage
  > The student plt had soloed that morning. After a short rest period he flew with his instructor. He then flew a second solo flt. The student plt made two landings. On the third approach the plt made a go-around. On the next approach the acft stalled close to…

## 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 ('2072406')
    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" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072406&occurrence=250

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