# NTSB investigations: Champion 7GCBC, 1985

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 ANC85LA155](https://openairdocs.org/ntsb/ANC85LA155.md): Champion 7GCBC · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Aug 18, 1985 · N1868G · Substantial damage
  > During landing the plt applied hard braking to avoid an airplane and rolled over.
- [NTSB NYC85FA162](https://openairdocs.org/ntsb/NYC85FA162.md): Bellanca 7GCBC · Cape May, NJ · Accident · 1 fatal · Field investigation · Final report · Jul 4, 1985 · N1880G · No damage
  > The tow plane came in for a banner pickup. The ground handler holding the tail of the double banner had his left foot caught by the banner as it went airborne. The ground handler was carried 50 to 100 ft in the air prior to falling to the ground. The ground…
- [NTSB SEA85LA071](https://openairdocs.org/ntsb/SEA85LA071.md): Champion 7GC · Reno, NV · Accident · No injuries · Limited investigation · Final report · Mar 10, 1985 · N7545F · Substantial damage
  > A hard landing occurred and the right main gear collapsed. The aircraft veered to the side of the runway where it caught fire. The acft had no fire extinguishing equipment on board and the acft was then destroyed by the fire.

## 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") = 1985
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('21101PK'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=21101PK&year=1985

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