# NTSB investigations: Aeronca 11AC, 1987

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 NYC87LA151](https://openairdocs.org/ntsb/NYC87LA151.md): Aeronca 11AC · Jeanette, PA · Accident · No injuries · Limited investigation · Final report · May 17, 1987 · N3886E · Substantial damage
  > The plt put small chocks under the wheels, then began to hand prop the eng with no one at the controls. The eng started, & before the plt could reach the cockpit, the acft made svrl 360 deg turns & subsequently rolled into trees.
- [NTSB MIA87LA149](https://openairdocs.org/ntsb/MIA87LA149.md): Aeronca 11AC · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N3167E · Substantial damage
  > Pilot made a hard landing at which time the left main gear collapsed. The aircraft then ground looped and ran off the runway. Post crash examination of the left main gear revealed it collapsed when a support brace rusted through from the inside of the tube.…
- [NTSB MKC87FA083](https://openairdocs.org/ntsb/MKC87FA083.md): Aeronca 11AC · Stillwell, KS · Accident · Serious injuries · Field investigation · Final report · Apr 19, 1987 · N85846 · Substantial damage
  > The pilot stated that this flight was to be a photographic, pleasure trip involving two aircraft. After several aerial photos were taken of each other's aircraft, both airplanes landed at the accident airport. The PIC and his passenger then took-off while the…
- [NTSB CHI87LA075](https://openairdocs.org/ntsb/CHI87LA075.md): Aeronca 11AC · Dodgeville, WI · Accident · No injuries · Limited investigation · Final report · Feb 5, 1987 · N86079 · Substantial damage
  > While taxiing after landing on runway 12, a tailwind was encountered. The acft spun around, slid backwards off the rwy, down a steep embankment and struck a large rock. The plt reported winds from 270 degrees at 12 knots gusting to 18 knots.

## 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 year(c."eventDate") = 1987
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0191102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0191102&year=1987

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