# NTSB investigations: Cessna 172E, IA

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 CHI04FA234](https://openairdocs.org/ntsb/CHI04FA234.md): Cessna 172E · Decorah, IA · Accident · 2 fatal · Field investigation · Final report · Aug 22, 2004 · N5410T · Destroyed
  > The pilot's intentional operation of the airplane with a defective magneto, his failure to abort the takeoff due to degraded aircraft performance, and his failure to obtain or maintain airspeed which resulted in a stall/spin and subsequent impact with the…
- [NTSB CHI91LA178](https://openairdocs.org/ntsb/CHI91LA178.md): Cessna 172E · Grundy Center, IA · Accident · No injuries · Limited investigation · Final report · May 31, 1991 · N3663S · Substantial damage
  > Failure by other maintenance personnel to install a safety wire and fuel exhaustion.
- [NTSB MKC87LA089](https://openairdocs.org/ntsb/MKC87LA089.md): Cessna 172E · Moorhead, IA · Accident · No injuries · Limited investigation · Final report · Apr 23, 1987 · N3777S · Substantial damage
  > According to FAA statements, the pilot was attempting a takeoff from a taxiway when a wing dipped. The pilot then lost control as the wing dragged, causing the aircraft to ground loop/swerve onto the terrain. The nose gear tire blew during the swerve and the…
- [NTSB MKC84LA169](https://openairdocs.org/ntsb/MKC84LA169.md): Cessna 172E · Waterloo, IA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1984 · N5614T · Substantial damage
  > There was heavy traffic at the arpt & the winds were from 280 deg at 16 KTS gusting to 25 KTS. Rather than waiting for the primary rwy (24), the plt elected to land on rwy 18. During the landing, a gust of wind lifted the right wing & the left wing dragged on…
- [NTSB MKC84LA030](https://openairdocs.org/ntsb/MKC84LA030.md): Cessna 172 · Hampton, IA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1983 · N7737U · Substantial damage
  > On his fourth touch and go landing the pilot added power for the go-around and the aircraft drifted off the left side of the runway. The left main gear hit a snowbank and the aircraft flipped over landing upside down in the snow. The winds at macon city, IA…
- [NTSB MKC68D0399](https://openairdocs.org/ntsb/MKC68D0399.md): Cessna 172E · Agency, IA · Accident · No injuries · Closed · Dec 28, 1967 · N3684S · Substantial damage
- [NTSB MKC68D0080](https://openairdocs.org/ntsb/MKC68D0080.md): Cessna 182 · Oskaloosa, IA · Accident · No injuries · Closed · Jul 15, 1967 · N2611G · 2 aircraft · No damage
- [NTSB MKC66D0527](https://openairdocs.org/ntsb/MKC66D0527.md): Cessna 172 · Creston, IA · Accident · No injuries · Closed · Mar 31, 1966 · N3940S · Substantial damage

## 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."eventStateOrRegion" = 'IA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072412'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072412&state=IA

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