# NTSB investigations: Aeronca 15AC: Loss of engine power(total) - mech failure/malf

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 ANC84LA134](https://openairdocs.org/ntsb/ANC84LA134.md): Aeronca 15AC · Murphy Dome, AK · Accident · No injuries · Limited investigation · Final report · Aug 22, 1984 · N1067H · Substantial damage
  > The CFI said the engine quit in 'straight and level flight' & 'acted like fuel starvation.' The prop was windmilling. Restarts were attempted without success. A forced landing was made in a wooded area. The landing was cushioned by the acft floats and wings.…
- [NTSB ANC84LA109](https://openairdocs.org/ntsb/ANC84LA109.md): Aeronca 15AC · Ester, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 1984 · N1436H · Substantial damage
  > The acft was landed in the tops of small spruce trees after the engine lost oil pressure and was shut down. The plt later admitted that the oil lines needed relacement on the last annual on 06-22-84 but he postponed it and later forgot to do it in the…

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

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

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