# NTSB investigations, 2017, 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 CEN18FA060](https://openairdocs.org/ntsb/CEN18FA060.md): X-Air XA85 · Oskaloosa, IA · Accident · 1 fatal · Field investigation · Final report · Dec 23, 2017 · N20XA · Substantial damage
  > The pilot's low altitude flight into a power line due to his impairment from an acute physiologic event during the flight. Contributing to the pilot's impairment was his use of two sedating medications.
- [NTSB CEN18LA051](https://openairdocs.org/ntsb/CEN18LA051.md): Cessna 172C · Algona, IA · Accident · No injuries · Limited investigation · Final report · Dec 9, 2017 · N8856B · Substantial damage
  > The No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.
- [NTSB CEN18LA025](https://openairdocs.org/ntsb/CEN18LA025.md): Robinson Helicopter R44 · Larchwood, IA · Accident · Serious injuries · Limited investigation · Final report · Nov 6, 2017 · N7085M · Substantial damage
  > The pilot's loss of situational awareness, which resulted in his failure to maintain adequate clearance from powerlines.
- [NTSB DCA17CA217](https://openairdocs.org/ntsb/DCA17CA217.md): Boeing 737-8H4 · Sioux City, IA · Accident · Serious injuries · Data collection · Final report · Sep 25, 2017 · N500WR · No damage
  > the flight attendant accidentally pouring hot water on his hand which resulted in a 2nd degree burn.
- [NTSB GAA17CA436](https://openairdocs.org/ntsb/GAA17CA436.md): Bell 47G 3B · Toterville, IA · Accident · No injuries · Data collection · Final report · Jul 24, 2017 · N47AH · Substantial damage
  > The pilot’s failure to maintain rotor rpm while maneuvering at low altitude with low airspeed and a tailwind.
- [NTSB GAA17CA433](https://openairdocs.org/ntsb/GAA17CA433.md): Stinson SR9 · Bode, IA · Accident · No injuries · Data collection · Final report · Jul 22, 2017 · N83K · Substantial damage
  > The pilot’s decision to take off from an unimproved bean field with insufficient length for the airplane to clear adjacent corn stalks.
- [NTSB CEN17CA346](https://openairdocs.org/ntsb/CEN17CA346.md): Robinson Helicopter R44 II · Logan, IA · Accident · Minor injuries · Data collection · Final report · Jul 20, 2017 · N192E · Substantial damage
  > The pilot’s failure to maintain clearance from a wire during an agricultural application flight.
- [NTSB GAA17CA422](https://openairdocs.org/ntsb/GAA17CA422.md): Piper PA32 · Marion, IA · Accident · No injuries · Data collection · Final report · Jul 15, 2017 · N31841 · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll.
- [NTSB CEN17LA263](https://openairdocs.org/ntsb/CEN17LA263.md): Cirrus Design SR22 · Corydon, IA · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 2017 · N929DE · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.
- [NTSB GAA17CA578](https://openairdocs.org/ntsb/GAA17CA578.md): Columbia Aircraft Mfg LC41 · Eagle Grove, IA · Accident · No injuries · Data collection · Final report · Jul 3, 2017 · N711NN · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll in crosswind conditions.
- [NTSB CEN17FA249](https://openairdocs.org/ntsb/CEN17FA249.md): Flight Design Ctsw · Monticello, IA · Accident · 1 fatal · Field investigation · Final report · Jul 1, 2017 · N62JN · Substantial damage
  > The pilot's decision to fly with his large dog in the two-seat, light sport airplane, and the dog's likely contact with the flight controls during landing, which resulted in the pilot's loss of airplane control and a subsequent aerodynamic stall when the…
- [NTSB GAA17CA338](https://openairdocs.org/ntsb/GAA17CA338.md): Piper PA 28 · Estherville, IA · Accident · No injuries · Data collection · Final report · Jun 14, 2017 · N33764 · Substantial damage
  > The student pilot's failure to maintain crosswind correction during a go-around in gusting wind conditions.
- [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 GAA17CA238](https://openairdocs.org/ntsb/GAA17CA238.md): Cheung David S Vans RV6 · Indianola, IA · Accident · No injuries · Data collection · Final report · Apr 17, 2017 · N822DC · Substantial damage
  > The pilot’s failure to maintain an adequate approach path, which resulted in a long landing and subsequent runway overrun.
- [NTSB CEN17LA156](https://openairdocs.org/ntsb/CEN17LA156.md): Loomis Xenon 4 · Knoxville, IA · Accident · No injuries · Limited investigation · Final report · Apr 17, 2017 · N912XV · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.
- [NTSB CEN17FA147](https://openairdocs.org/ntsb/CEN17FA147.md): Piper PA-28-180 · Oxford, IA · Accident · 2 fatal · Field investigation · Final report · Apr 7, 2017 · N9179J · Destroyed
  > The failure of the pilot receiving instruction to recover from the practice stall before the airplane entered a spin and the flight instructor's inadequate monitoring of the pilot receiving instruction and delayed remedial action to recover the airplane.

## 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 year(c."eventDate") = 2017
  AND c."eventStateOrRegion" = 'IA' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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