# NTSB investigations, 2020, IA: Collision with terr/obj (non-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 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 CEN20CA244](https://openairdocs.org/ntsb/CEN20CA244.md): Coyote S-6ES · Pisgah, IA · Accident · Serious injuries · Class 4 · Data collection · Final report · Jun 23, 2020 · N7764W · Substantial damage
  > The uncertificated pilot's failure to attain/maintain a proper angle-of-attack during an initial climb that resulted in an aerodynamic stall and subsequent impact with terrain.
- [NTSB CEN20CA155](https://openairdocs.org/ntsb/CEN20CA155.md): Vans RV 3 · Independence, IA · Accident · No injuries · Data collection · Final report · Apr 23, 2020 · N24DE · Substantial damage
  > The pilot's failure to maintain directional control during a high-speed taxi with a quartering tailwind, which resulted in a runway excursion and impact with a fence and terrain.
- [NTSB CEN20CA120](https://openairdocs.org/ntsb/CEN20CA120.md): Aeronca 7AC · Ankeny, IA · Accident · Serious injuries · Data collection · Final report · Mar 11, 2020 · N83032 · Substantial damage
  > The pilot's improper starting procedure, which allowed the airplane to move forward over the wheel chocks and impact him and a hangar when he subsequently hand propped the engine.
- [NTSB CEN20CA064](https://openairdocs.org/ntsb/CEN20CA064.md): Guimbal Cabri G2 · Independence, IA · Accident · Serious injuries · Data collection · Final report · Jan 21, 2020 · N715RK · Substantial damage
  > The student pilot's failure to maintain helicopter control while maneuvering to land, which resulted in impact with an airplane and a hangar.

## 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") = 2020
  AND 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" = '470' 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/470/sequence?state=IA&year=2020

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
