# NTSB investigations: Piper AEROSTAR 601P, FL

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 NYC07LA183](https://openairdocs.org/ntsb/NYC07LA183.md): Piper Aerostar 601P · Fort Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Aug 2, 2007 · N60801 · Substantial damage
  > The total loss of power in one engine during approach, due to a fatigue fracture of the crankshaft.
- [NTSB MIA01FA108](https://openairdocs.org/ntsb/MIA01FA108.md): Piper PA-60-601P · Marco Island, FL · Accident · 1 fatal · Field investigation · Final report · Mar 31, 2001 · N900CE · Destroyed
  > The failure of the pilot to maintain control of the aircraft during a rejected landing and the collision with the terrain and mangrove trees. A finding in the investigation was the presence of quinine in the blood and urine during postmortem toxicological…
- [NTSB MIA90FA033](https://openairdocs.org/ntsb/MIA90FA033.md): Piper Aerostar 601P · Orlando, FL · Accident · 2 fatal · Field investigation · Final report · Dec 1, 1989 · N6079H · Destroyed
  > Loss of aircraft control during takeoff for an unknown reason which resulted in a collision with the ground.
- [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…
- [NTSB MIA83LA111](https://openairdocs.org/ntsb/MIA83LA111.md): Piper PA-60-601P · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Apr 5, 1983 · N6079R · Destroyed
  > The aircraft departed runway 18L at Tampa intl airport. Shortly after takeoff the pilot reported to the control tower that the main cabin door was open and requested landing instructions. The pilot stated he was holding the door and trying to fly the aircraft…
- [NTSB MIA81FA007](https://openairdocs.org/ntsb/MIA81FA007.md): Piper 601P · Wilma, FL · Accident · 2 fatal · Closed · Oct 23, 1980 · N8250J · Destroyed

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

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

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