# NTSB investigations: Bellanca 7GCBC: In flight encounter with weather

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 ANC01LA144](https://openairdocs.org/ntsb/ANC01LA144.md): Bellanca 7GCBC · Mentasta, AK · Accident · No injuries · Limited investigation · Final report · Sep 22, 2001 · N8943 · Substantial damage
  > The pilot's inadequate compensation for wind conditions while landing. Factors associated with the accident were the pilot's inadequate recovery from a bounced landing, and a variable wind.
- [NTSB ANC99LA149](https://openairdocs.org/ntsb/ANC99LA149.md): Bellanca 7GCBC · Fairbanks, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 1999 · N53728 · Substantial damage
  > The pilot's inadequate compensation for wind conditions. Factors in the accident were a windshear, and a short runway area.
- [NTSB NYC94LA083](https://openairdocs.org/ntsb/NYC94LA083.md): Bellanca 7GCBC · Lewisburg, WV · Accident · Minor injuries · Limited investigation · Final report · May 17, 1994 · N36236 · Substantial damage
  > The pilot's inadequate inflight decision, inadvertent VFR flight into IMC, and failure to maintain adequate terrain clearance which resulted in inflight collision with trees. A factor was inadequate altitude.
- [NTSB SEA92LA144](https://openairdocs.org/ntsb/SEA92LA144.md): Bellanca 7GCBC · Wenatchee, WA · Accident · No injuries · Limited investigation · Final report · Jul 4, 1992 · N36031 · Substantial damage
  > The failure of the pilot to maintain directional control during landing, resulting in a ground loop and aircraft impact with terrain. A factor relating to the accident was the gusty wind conditions.
- [NTSB ANC87LA113](https://openairdocs.org/ntsb/ANC87LA113.md): Bellanca 7GCBC · Happy Valley, AK · Accident · 2 fatal · Limited investigation · Final report · Jul 26, 1987 · N5052C · Destroyed
  > The aircraft struck the mountain at the 4000 foot level. At the time of the accident several witnesses stated that the weather was IFR, low ceiling, ground fog, and the prevailing visibility was less than one mile.

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

This list as a web page: https://openairdocs.org/ntsb?model=1220601&occurrence=240

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