# NTSB investigations, IA: Miscellaneous/other

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 CEN26LA260](https://openairdocs.org/ntsb/CEN26LA260.md): Robinson Helicopter R44 · Emerson, IA · Accident · No injuries · Class 4 · Limited · Final report · Jul 20, 2026 · N224RH · Substantial damage
  > The failure of the pilot to verify the loading hose had been disconnected before taking off and the failure of the loader to disconnect the fuel hose from the helicopter.
- [NTSB CEN24LA355](https://openairdocs.org/ntsb/CEN24LA355.md): Just SuperStol · Mount Vernon, IA · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 12, 2024 · N874FT · Substantial damage
  > The pilot’s failure to maintain airplane control during a go-around which resulted in an aerodynamic stall and collision with terrain.
- [NTSB CEN20LA261](https://openairdocs.org/ntsb/CEN20LA261.md): Enstrom 280 · Des Moines, IA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 4, 2020 · N282SH · Destroyed
  > The partial loss of rotor and engine speed during approach for landing, which resulted in an autorotation and impact with terrain. The reason for the partial loss of rotor and engine speed could not be determined based on the available evidence. Contributing…
- [NTSB GAA17CA317](https://openairdocs.org/ntsb/GAA17CA317.md): Cessna 177 · Guttenberg, IA · Accident · No injuries · Data collection · Final report · Jun 3, 2017 · N34462 · Substantial damage
  > The pilot’s failure to maintain an adequate approach path, which resulted in the left wing impacting a street sign.
- [NTSB CEN16LA320](https://openairdocs.org/ntsb/CEN16LA320.md): Cirrus Design SR20 · Des Moines, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 2016 · N314BF · Destroyed
  > The two separations in the induction system due to improper installation and/or maintenance, which resulted in a partial loss of engine power during initial climb.
- [NTSB CEN13LA500](https://openairdocs.org/ntsb/CEN13LA500.md): Cessna 206 · Brooklyn, IA · Accident · 1 fatal · Limited investigation · Final report · Aug 16, 2013 · N2070K · Minor damage
  > The improper routing of the seatbelt, which resulted in the inadvertent deployment of the reserve parachute, and the open jump door, which allowed the passenger to be pulled from the airplane.
- [NTSB CEN13CA238](https://openairdocs.org/ntsb/CEN13CA238.md): Enstrom F-28C · Lanesboro, IA · Accident · No injuries · Data collection · Final report · Apr 24, 2013 · N51767 · Substantial damage
  > The pilot’s failure to maintain control of the helicopter while making an off-airport landing with a gusty tailwind.
- [NTSB CEN12CA607](https://openairdocs.org/ntsb/CEN12CA607.md): North American AT-6F · Council Bluffs, IA · Accident · No injuries · Data collection · Final report · Aug 31, 2012 · N244GR · Substantial damage
  > An unlocking of the excessively worn tailwheel lock mechanism, which resulted in a loss of directional control during landing.
- [NTSB CEN10CA349](https://openairdocs.org/ntsb/CEN10CA349.md): Piper PA-28-151 · Webster, IA · Accident · No injuries · Data collection · Final report · May 9, 2010 · N8083C · Substantial damage
  > The pilot misjudged his speed and distance during landing, which resulted in an overrun.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/900/sequence?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.
