# NTSB investigations: Cessna 172K, 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 GAA19CA193](https://openairdocs.org/ntsb/GAA19CA193.md): Cessna 172 · Pella, IA · Accident · No injuries · Data collection · Final report · Mar 26, 2019 · N7127G · Substantial damage
  > The student pilot's failure to maintain the runway heading and the flight instructor's delayed remedial action during landing, which resulted in the instructor landing the airplane in grass left of the runway and a subsequent nose-over.
- [NTSB MKC87LA076](https://openairdocs.org/ntsb/MKC87LA076.md): Cessna 172 · Muscatine, IA · Accident · No injuries · Limited investigation · Final report · Apr 5, 1987 · N79179 · Destroyed
  > The grass runway was 1300 feet long. The wind was 90 degrees cross at 5 knots, gusts to 20 KTS. The instructor said they had a wind shift and then they hit a soft spot near the end of the runway which slowed them. The elevator and stabilizer caught on a…
- [NTSB MKC85LA220](https://openairdocs.org/ntsb/MKC85LA220.md): Cessna 172K · Kalona, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1985 · N78227 · Substantial damage
  > The plt reported that on the initial indication of rain, he elected to takeoff from the harvested soybean field before it became muddy. The field was soft & was about 2100 ft long. Before the acdnt, the wind was from the south, so the plt began his takeoff in…
- [NTSB MKC81DCD10](https://openairdocs.org/ntsb/MKC81DCD10.md): Cessna 172 · Spencer, IA · Accident · No injuries · Closed · Feb 22, 1981 · N7318G · Substantial damage
- [NTSB MKC78DCD57](https://openairdocs.org/ntsb/MKC78DCD57.md): Cessna 172 · Jesup, IA · Accident · No injuries · Closed · Sep 30, 1978 · N46438 · Substantial damage
- [NTSB MKC76DCD38](https://openairdocs.org/ntsb/MKC76DCD38.md): Cessna 172 · Council Bluffs, IA · Accident · No injuries · Closed · Apr 8, 1976 · N84412 · Substantial damage
- [NTSB MKC72DCD14](https://openairdocs.org/ntsb/MKC72DCD14.md): Cessna 172K · Lowden, IA · Accident · No injuries · Closed · Jul 23, 1971 · N78842 · Substantial damage
- [NTSB MKC71DCD40](https://openairdocs.org/ntsb/MKC71DCD40.md): Cessna 172K · Johnston, IA · Accident · No injuries · Closed · Dec 5, 1970 · N84093 · 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 ('2072430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072430&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.