# NTSB investigations: Bellanca 7KCAB, MD

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 ERA23LA069](https://openairdocs.org/ntsb/ERA23LA069.md): Bellanca 7KCAB · Accident, MD · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 28, 2022 · N68531 · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll in crosswind conditions.
- [NTSB BFO89FA057](https://openairdocs.org/ntsb/BFO89FA057.md): Bellanca 7KCAB · Berlin, MD · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1989 · N57417 · Destroyed
  > Pilot failure to maintain adequate airspeed, resulting in an aerodynamic stall. Contributing to the accident was the low altitude at which the stall occurred.
- [NTSB BFO86LA028](https://openairdocs.org/ntsb/BFO86LA028.md): Bellanca 7KCAB · Berlin, MD · Accident · No injuries · Limited investigation · Final report · May 29, 1986 · N12AP · Substantial damage
  > While climbing out after picking up an advertising banner the pilot of the Bellanca 7KCAB noticed that the aircraft yawed excessively to the right. After verifying that the engine was at full power. The pilot elected to drop the banner and make a…

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

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

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