# NTSB investigations: Champion 7GCB: Loss of control - in flight

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 SEA04CA116](https://openairdocs.org/ntsb/SEA04CA116.md): Champion 7GCB · Florence, OR · Accident · No injuries · Data collection · Final report · Jun 21, 2004 · N9827Y · Substantial damage
  > Pilot's improper touchdown point during landing. A sand mound was a factor in the accident.
- [NTSB NYC98LA141](https://openairdocs.org/ntsb/NYC98LA141.md): Champion 7GCG · Neavitt, MD · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1998 · N9985Y · Substantial damage
  > The pilot's failure to maintain control of the airplane.
- [NTSB SEA88LA153](https://openairdocs.org/ntsb/SEA88LA153.md): Champion 7GCB · Oreana, ID · Accident · No injuries · Limited investigation · Final report · Aug 15, 1988 · N9806Y · Substantial damage
  > Plt was circling a friend's ranch at low alt when acft began an uncommanded left roll. Plt was able to level wings before ground contact in rough terrain. Investigation revealed aileron attach bolt missing. Aileron had just undergone repair.
- [NTSB SEA86FA217](https://openairdocs.org/ntsb/SEA86FA217.md): Aeronca 7GCB · Stanley, ID · Accident · 2 fatal · Field investigation · Final report · Aug 21, 1986 · N9940Y · Destroyed
  > Witnesses reported the aircraft came from the direction of Stanley (8 miles to the north). Circled over the guest lodge, made one or more low (100 to 300 foot) passes. On the last pass the acft was heading away from the lodge towards highway 75. The acft…

## 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 ('21101PC')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=21101PC&occurrence=250

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