# NTSB investigations: Cessna 172C: 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 CHI07FA290](https://openairdocs.org/ntsb/CHI07FA290.md): Cessna 172C · Kelleys Island, OH · Accident · 2 fatal · Field investigation · Final report · Sep 4, 2007 · N1301Y · Substantial damage
  > The pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing to the accident were the water and dark night conditions which resulted in the lack of ground references during the takeoff.
- [NTSB LAX04CA157](https://openairdocs.org/ntsb/LAX04CA157.md): Cessna 172C · Thermal, CA · Accident · Minor injuries · Data collection · Final report · Mar 14, 2004 · N8287X · Substantial damage
  > the pilot's failure to retract the flaps during the go-around and his failure to obtain and maintain sufficient airspeed, which led to a stall mush condition. High density altitude was a contributing factor.
- [NTSB CHI99FA094](https://openairdocs.org/ntsb/CHI99FA094.md): Cessna 172C · Grenola, KS · Accident · 2 fatal · Field investigation · Final report · Feb 21, 1999 · N1831Y · Destroyed
  > loss of control in flight due to incapacitation.
- [NTSB SEA95LA169](https://openairdocs.org/ntsb/SEA95LA169.md): Cessna 172C · Red Lodge, MT · Accident · No injuries · Limited investigation · Final report · Aug 1, 1995 · N1364Y · Substantial damage
  > The pilot's failure to maintain airspeed. The pilot's inadequate preflight planning/preparation and selection of unsuitable terrain for landing were factors.
- [NTSB SEA87LA045](https://openairdocs.org/ntsb/SEA87LA045.md): Cessna 172 · Eatonville, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 1987 · N1815Y · Destroyed
  > The student plt was on approach to home field after a x-c flight. During final, the pilot elected to go-around due to gusty winds and a downdraft. The acft stalled into trees along side the runway. Investigation revealed the flaps were set at 40 degrees and…
- [NTSB ATL83LA356](https://openairdocs.org/ntsb/ATL83LA356.md): Cessna 172C · Portsmouth Isl., NC · Accident · No injuries · Limited investigation · Final report · Aug 30, 1983 · N8338X · Substantial damage
  > Before hauling passengers, the plt elected to make a flt to survey the area & to practice a landing on Portsmouth island. He estimated that the wind at Portsmouth was from the north at 15 to 20 KTS. Also, he said that the arpt was oriented toward the…
- [NTSB LAX83LA108](https://openairdocs.org/ntsb/LAX83LA108.md): Cessna 172C · Rubidoux, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 1983 · N8347X · Destroyed
  > The acft crashed alongside the runway during takeoff in windy conditions. Witnesses observed the acft stagger into the air at slow airspeed from a grass runway into a 20-30 KTS santa ana wind out of the north. The pilot stated that he attempted a soft field…

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