# NTSB investigations: Aeronca 7BCM: Directional control

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 ERA22LA355](https://openairdocs.org/ntsb/ERA22LA355.md): Aeronca 7BCM · Cranberry Township, PA · Accident · No injuries · Class 4 · Limited · Final report · Aug 3, 2022 · N9325H · Substantial damage
  > The pilots’ failure to maintain directional control of the airplane while landing in gusting wind conditions.
- [NTSB GAA16CA292](https://openairdocs.org/ntsb/GAA16CA292.md): Aeronca 7BCM · Rochester, WI · Accident · No injuries · Data collection · Final report · Jun 8, 2016 · N1127N · Substantial damage
  > The pilot's failure to maintain directional control during the landing, which resulted in a runway excursion, left main landing gear collapse, and a nose down. Contributing to the accident was the wind shift.
- [NTSB GAA15CA201](https://openairdocs.org/ntsb/GAA15CA201.md): Aeronca 7BCM · Warsaw, MO · Accident · No injuries · Data collection · Final report · Jul 23, 2015 · N81686 · Substantial damage
  > The pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a collision with terrain.
- [NTSB WPR12CA114](https://openairdocs.org/ntsb/WPR12CA114.md): Aeronca 7BCM · Woodland, CA · Accident · No injuries · Data collection · Final report · Feb 19, 2012 · N6451C · Substantial damage
  > The pilot did not maintain directional control during landing.
- [NTSB ERA10CA321](https://openairdocs.org/ntsb/ERA10CA321.md): Aeronca 7BCM · Bolivar, TN · Accident · Minor injuries · Data collection · Final report · Jun 19, 2010 · N2553B · Substantial damage
  > The pilot's failure to maintain directional control while landing.

## 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 ('2110106')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '01062020')))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/01062020/cases?model=2110106

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
