# NTSB investigations: Champion 7GCBC, NJ

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 NYC96FA152](https://openairdocs.org/ntsb/NYC96FA152.md): Champion 7GCBC · Farmingdale, NJ · Accident · 1 fatal · Field investigation · Final report · Jul 18, 1996 · N7557F · Destroyed
  > the pilot's improper handling of the airplane during a banner pickup maneuver, which resulted in a stall/mush and collision with the ground. A factor relating to the accident was: the pilot's lack of experience in the type of operation.
- [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 NYC81DHD11](https://openairdocs.org/ntsb/NYC81DHD11.md): Champion 7GCBC · Normandy Beach, NJ · Accident · Minor injuries · Closed · Jan 24, 1981 · N9666S · Destroyed
- [NTSB NYC80FHD17](https://openairdocs.org/ntsb/NYC80FHD17.md): Champion 7GCBC · Williamstown, NJ · Accident · No injuries · Closed · Jun 1, 1980 · N1880G · Substantial damage

## 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" = 'NJ' 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 ('21101PK'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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