# NTSB investigations: Champion 7GCB, ID

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 SEA98LA087](https://openairdocs.org/ntsb/SEA98LA087.md): Champion 7GCB · Hailey, ID · Accident · No injuries · Limited investigation · Final report · Jun 4, 1998 · N912CP · Substantial damage
  > The disconnection of the rear right-main brake pedal from the brake master cylinder, and the overloading of the right main landing gear. A factor was the oscillation of the tailwheel.
- [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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101PC'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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