# NTSB investigations: Champion 7GCAA: 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 CEN18FA242](https://openairdocs.org/ntsb/CEN18FA242.md): Champion 7GCAA · Arthur, NE · Accident · 1 fatal · Field investigation · Final report · Jun 29, 2018 · N9026L · Substantial damage
  > The pilot's failure to recover from a spin for reasons that could not be determined based on the available information.
- [NTSB GAA15CA188](https://openairdocs.org/ntsb/GAA15CA188.md): Champion 7GCAA · Kingsland, TX · Accident · No injuries · Data collection · Final report · Jul 15, 2015 · N8305V · Substantial damage
  > The pilot's failure to maintain pitch attitude which resulted in an aerodynamic stall, hard landing and a loss of directional control.
- [NTSB ERA14LA222](https://openairdocs.org/ntsb/ERA14LA222.md): Champion 7GCAA · Bardwell, KY · Accident · Minor injuries · Limited investigation · Final report · May 4, 2014 · N9588S · Substantial damage
  > The failure of the pilot to maintain airspeed while maneuvering shortly after takeoff, resulting in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, uncontrolled descent, and impact with the ground.
- [NTSB WPR13FA370](https://openairdocs.org/ntsb/WPR13FA370.md): Champion 7GCAA · Paradise, CA · Accident · 2 fatal · Field investigation · Final report · Aug 13, 2013 · N9607S · Destroyed
  > The pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.
- [NTSB CEN09LA396](https://openairdocs.org/ntsb/CEN09LA396.md): Champion 7GCAA · Shelbyville, IN · Accident · No injuries · Limited investigation · Final report · Jun 29, 2009 · N9085L · Substantial damage
  > The partial loss of engine power due to the failure of the mixture control cable. Contributing to the accident was the inadequate maintenance on the airplane and the pilot's decision to operate the airplane in a condition that was not airworthy.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101N8')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND 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?model=21101N8

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