# NTSB investigations: Bellanca 7KCAB: In flight collision with object

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 NYC02LA194](https://openairdocs.org/ntsb/NYC02LA194.md): Bellanca 7KCAB · Erwinna, PA · Accident · Minor injuries · Limited investigation · Final report · Sep 24, 2002 · N4210Y · Substantial damage
  > The pilot's failure to maintain directional control during an aborted landing. A factor was a crosswind.
- [NTSB SEA97LA212](https://openairdocs.org/ntsb/SEA97LA212.md): Bellanca 7KCAB · Oakridge, OR · Accident · 2 fatal · Limited investigation · Final report · Sep 18, 1997 · N8509 · Destroyed
  > The first pilot's decision to perform a low altitude maneuver, and his subsequent failure to maintain altitude and clearance from trees during a low altitude maneuver.
- [NTSB MIA86LA141](https://openairdocs.org/ntsb/MIA86LA141.md): Bellanca 7KCAB · New Smyrna Bch, FL · Accident · No injuries · Limited investigation · Final report · May 2, 1986 · N90985 · Substantial damage
  > During a pickup of an aerial advertising banner the acft struck the pickup bridle with the left main landing gear. He stated that he was unable to climb. The acft then stalled and crashed along the arpt boundary in a swamp.
- [NTSB LAX84FUG01](https://openairdocs.org/ntsb/LAX84FUG01.md): Bellanca 8KCAB · Riverside, CA · Accident · Minor injuries · Final report · Feb 9, 1984 · N5037G · Substantial damage
  > The plt tried to takeoff from a grassy area adjacent to the paved rwy. The takeoff was hindered by high grass. Just after takeoff the acft collided with a fence and cartwheeled.

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

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

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