# NTSB investigations: Cessna 172F, 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 MKC88LA008](https://openairdocs.org/ntsb/MKC88LA008.md): Cessna 172F · Lamoni, IA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N8508U · Substantial damage
  > The pilot said he was too high on final and went around. He stated that, when he was on short final during the next approach, he thought he was still too high and put down full flaps. The airplane stalled and touched down short of the runway. The nosegear was…
- [NTSB MKC86LA090](https://openairdocs.org/ntsb/MKC86LA090.md): Cessna 172D · Garden Grove, IA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1986 · N2502Y · Substantial damage
  > The plt stated that he was attempting a no-flap takeoff from his pvt strip when the wheels hit a wet spot. He said that the acft slowed down but he extended flaps and continued the takeoff. When he saw that he was running out of rwy, he aborted the takeoff…
- [NTSB MKC84LA076](https://openairdocs.org/ntsb/MKC84LA076.md): Cessna 172 · Chariton, IA · Accident · No injuries · Limited investigation · Final report · Feb 15, 1984 · N2502Y · Substantial damage
  > The acft lost power during takeoff and was forced to land in a muddy field. The CFI said he examined the fuel in a sightglass after refueling the acft and did not notice any water in the fuel. Later examination of the acft by FAA showed water in the fuel…
- [NTSB MKC77FA027](https://openairdocs.org/ntsb/MKC77FA027.md): Cessna 172 · Cedar Rapids, IA · Accident · 2 fatal · Closed · Jun 18, 1977 · N5172F · Substantial damage
- [NTSB MKC76FCD43](https://openairdocs.org/ntsb/MKC76FCD43.md): Cessna 150M · Perry, IA · Accident · Minor injuries · Closed · May 20, 1976 · N7925U · Substantial damage
- [NTSB MKC76FCD28](https://openairdocs.org/ntsb/MKC76FCD28.md): Cessna 172F · Iowa City, IA · Accident · Serious injuries · Closed · Feb 18, 1976 · N8733U · Destroyed
- [NTSB MKC73DCD47](https://openairdocs.org/ntsb/MKC73DCD47.md): Cessna 172 · Newton, IA · Accident · No injuries · Closed · Jan 14, 1973 · N8527U · Substantial damage
- [NTSB MKC72DCD36](https://openairdocs.org/ntsb/MKC72DCD36.md): Cessna 172 · Independence, IA · Accident · No injuries · Closed · Oct 10, 1971 · N8283U · Substantial damage
- [NTSB MKC70DCD38](https://openairdocs.org/ntsb/MKC70DCD38.md): Cessna 172F · Harlan, IA · Accident · No injuries · Closed · Jun 11, 1970 · N8817U · Substantial damage
- [NTSB MKC69F0182](https://openairdocs.org/ntsb/MKC69F0182.md): Cessna 172F · Pella, IA · Accident · No injuries · Closed · Sep 27, 1968 · N8544U · Substantial damage
- [NTSB MKC68D0444](https://openairdocs.org/ntsb/MKC68D0444.md): Cessna 172F · Indianola, IA · Accident · No injuries · Closed · Feb 16, 1968 · N8272U · Destroyed
- [NTSB MKC66D0330](https://openairdocs.org/ntsb/MKC66D0330.md): Cessna 172 · Waukon, IA · Accident · Minor injuries · Closed · Oct 29, 1965 · N5491R · 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 ('2072414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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