# NTSB investigations, IA: Controlled flight into terr/obj (CFIT)

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 CEN20LA136](https://openairdocs.org/ntsb/CEN20LA136.md): Robinson Helicopter R44 II · Audubon, IA · Accident · 2 fatal · Class 3 · Limited · Final report · Mar 31, 2020 · N107EH · Destroyed
  > The pilot’s failure to recognize and avoid the power line during the low-altitude flight. Contributing to the accident was the pilot’s fatigue, which affected the pilot’s ability to see and avoid the power line.
- [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 CEN16LA292](https://openairdocs.org/ntsb/CEN16LA292.md): Air Tractor AT 402 · Sac City, IA · Accident · 1 fatal · Limited investigation · Final report · Jul 29, 2016 · N1016G · Destroyed
  > The pilot's failure to maintain adequate clearance from power lines. Contributing to the accident was the pilot's failure to circle over the field to identify hazards before beginning the aerial application.
- [NTSB CEN16LA289](https://openairdocs.org/ntsb/CEN16LA289.md): Bell OH 58A · Lake Mills, IA · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2016 · N288NS · Substantial damage
  > The pilot's inadequate visual lookout, which resulted in a wire strike.
- [NTSB CEN16FA062](https://openairdocs.org/ntsb/CEN16FA062.md): Piper PA46 500TP · Council Bluffs, IA · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2015 · N145JR · Substantial damage
  > The pilot's failure to maintain clearance from power lines while returning to the airport after becoming distracted by a noncritical flight instrumentation anomaly indication.
- [NTSB CEN14LA487](https://openairdocs.org/ntsb/CEN14LA487.md): Robinson Helicopter R44 II · Macedonia, IA · Accident · 1 fatal · Limited investigation · Final report · Sep 6, 2014 · N699TQ · Substantial damage
  > The pilot’s inadequate visual lookout, which resulted in a collision with a static line.
- [NTSB CEN13CA133](https://openairdocs.org/ntsb/CEN13CA133.md): American General Acft AG5B · Ankeny, IA · Accident · No injuries · Data collection · Final report · Jan 12, 2013 · N897GA · Substantial damage
  > The pilot’s failure to maintain a proper glide path to the runway in gusty wind conditions and his failure to maintain clearance from obstructions during the subsequent go-around. Contributing to the accident was the pilot's improper interior lighting…
- [NTSB CEN13FA078](https://openairdocs.org/ntsb/CEN13FA078.md): Taylorcraft BC12-D · Clutier, IA · Accident · 1 fatal · Field investigation · Final report · Nov 28, 2012 · N94973 · Substantial damage
  > The pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground…
- [NTSB CEN10CA100](https://openairdocs.org/ntsb/CEN10CA100.md): Cessna P172D · Cedar Rapids, IA · Accident · Minor injuries · Data collection · Final report · Jan 18, 2010 · N8584X · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions and his failure to maintain a proper glidepath during the approach. Contributing to the accident was the pilot's lack of instrument proficiency.

## 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" = '120' 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/120/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.
