# NTSB investigations: Piper AEROSTAR 601P, AZ

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 GAA19CA559](https://openairdocs.org/ntsb/GAA19CA559.md): Piper PA60 · Sedona, AZ · Accident · No injuries · Data collection · Final report · Sep 20, 2019 · N700NJ · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.
- [NTSB LAX03FA076](https://openairdocs.org/ntsb/LAX03FA076.md): Piper PA-60-601P · Scottsdale, AZ · Accident · 2 fatal · Field investigation · Final report · Jan 27, 2003 · N3636Q · Destroyed
  > the pilot's failure to maintain an adequate altitude clearance from mountainous terrain. Contributing factors were dark night conditions, mountainous terrain, and the pilot's diverted attention.
- [NTSB LAX82FA275](https://openairdocs.org/ntsb/LAX82FA275.md): Piper PA-601P · South Of Wicken, AZ · Accident · 2 fatal · Field investigation · Final report · Jul 24, 1982 · N3642T · Destroyed
  > At about 1005 MST the plt received a wx briefing for a flt to Florida with an overnight stay in Texas. Thunderstorm activity was forecast along the proposed route of flt. The briefer advised the plt to get an updated briefing before departure because of 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."eventStateOrRegion" = 'AZ' 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=AZ

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