# NTSB investigations: Piper AEROSTAR 601P: Loss of engine power

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 ANC08LA010](https://openairdocs.org/ntsb/ANC08LA010.md): Piper 601P · Penn Yan, NY · Accident · No injuries · Limited investigation · Final report · Oct 28, 2007 · N717SB · Substantial damage
  > The loss of engine power during cruise flight for an undetermined reason.
- [NTSB CHI02FA112](https://openairdocs.org/ntsb/CHI02FA112.md): Piper 601P · Moscow, KS · Accident · 1 fatal · Field investigation · Final report · Apr 23, 2002 · N101LT · Destroyed
  > The pilot's intentional operation of the airplane with a known engine boost problem resulting in the improper use of brakes to maintain directional control during takeoff, the brake system fire, and the loss of control for undetermined reasons during the…
- [NTSB MIA88FA261](https://openairdocs.org/ntsb/MIA88FA261.md): Piper PA-60 · Pembroke Pines, FL · Accident · 3 fatal · Field investigation · Final report · Aug 25, 1988 · N6069W · Destroyed
  > Witnesses stated that the acft used almost the entire length of the runway during the ground run. After rotation & gear retraction, it continued to climb in a nose high attitude to aprx 100-150 feet, then it started an aprx 20 degree bank to the right until…

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

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

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