# NTSB investigations, 2012, PA: Loss of engine power (partial)

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 ERA13LA025](https://openairdocs.org/ntsb/ERA13LA025.md): Piper PA-28-140 · Allentown, PA · Accident · No injuries · Limited investigation · Final report · Oct 12, 2012 · N15037 · Substantial damage
  > The operator's failure to perform magneto inspections per the manufacturer's recommendations and failure to comply with the engine manufacturer's recommended time interval for engine overhaul, which resulted in defects in the magnetos going undetected and the…
- [NTSB ERA12LA539](https://openairdocs.org/ntsb/ERA12LA539.md): Cessna 172M · Canadensis, PA · Accident · No injuries · Limited investigation · Final report · Aug 31, 2012 · N391R · Substantial damage
  > The pilot’s failure to attain a proper glidepath.
- [NTSB ERA12LA507](https://openairdocs.org/ntsb/ERA12LA507.md): Aeronca 7AC · Clifford, PA · Accident · No injuries · Limited investigation · Final report · Aug 6, 2012 · N83826 · Substantial damage
  > Partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA12LA343](https://openairdocs.org/ntsb/ERA12LA343.md): Cessna 195A · Tipton, PA · Accident · No injuries · Limited investigation · Final report · May 18, 2012 · N9859A · Substantial damage
  > A fatigue failure of a copper oil line, which resulted in a partial loss of engine power due to oil starvation.

## 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") = 2012
  AND c."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/342/sequence?state=PA&year=2012

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