# NTSB investigations, IA: Nose over

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 CHI03LA068](https://openairdocs.org/ntsb/CHI03LA068.md): Cessna 182F · Estherville, IA · Accident · No injuries · Limited investigation · Final report · Feb 11, 2003 · N3455U · Substantial damage
  > The pilot failed to maintain adequate control of the airplane while taxiing in high wind conditions. A factor was the high winds.
- [NTSB CHI02LA029](https://openairdocs.org/ntsb/CHI02LA029.md): Schenfield Acro Sport II · Keosauqua, IA · Accident · No injuries · Limited investigation · Final report · Nov 12, 2001 · N90287 · Substantial damage
  > Aircraft control not maintained by pilot during landing.
- [NTSB CHI97LA113](https://openairdocs.org/ntsb/CHI97LA113.md): Cessna 185 · Pella, IA · Accident · No injuries · Limited investigation · Final report · Apr 24, 1997 · N4641E · Substantial damage
  > the pilot's selection of an unsuitable area for the landing. A factor relating to the accident was: the soft landing surface of the farm strip.
- [NTSB CHI96LA100](https://openairdocs.org/ntsb/CHI96LA100.md): Cessna 172 · Ankeny, IA · Accident · No injuries · Limited investigation · Final report · Mar 2, 1996 · N8626B · Substantial damage
  > the pilot's poor judgment in attempting flight operations in the existing wind condition, and the high gusting wind.
- [NTSB CHI93LA023](https://openairdocs.org/ntsb/CHI93LA023.md): Cessna 140 · Waverly, IA · Accident · No injuries · Limited investigation · Final report · Oct 27, 1992 · N4213N · Substantial damage
  > The pilot's excessive application of brakes during landing roll.
- [NTSB MKC86LA054](https://openairdocs.org/ntsb/MKC86LA054.md): Cessna 150 · Bancroft, IA · Accident · No injuries · Limited investigation · Final report · Jan 24, 1986 · N7595U · Substantial damage
  > The plt became disoriented on a night, VFR flt and landed at an arpt to determine his location. The unattended arpt did not have a phone so the plt tookoff again enroute to his original dest. He became disoriented a second time and, because the acft was…
- [NTSB MKC82DA051](https://openairdocs.org/ntsb/MKC82DA051.md): Cessna 172L · Des Moines, IA · Accident · No injuries · Final report · Mar 30, 1982 · N4325Q · Substantial damage
  > The pilot landed on runway 23 with the wind from 230 degrees at 34 gusting 40 knots. After turning off to the right side of the runway, a gust of wind tipped the aircraft, turned it further to the right, and then blew it over on its back.

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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