# NTSB investigations: Piper AEROSTAR 601P, 2002

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 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 LAX02FA073](https://openairdocs.org/ntsb/LAX02FA073.md): Piper Aerostar 601P · Stonyford, CA · Accident · 1 fatal · Field investigation · Final report · Jan 31, 2002 · N3636M · Destroyed
  > the pilot's failure to maintain terrain clearance during cruise flight, which resulted in the in-flight collision with mountainous terrain. Factors in the accident were the mountainous terrain and the dark night light conditions.

## 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") = 2002
  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&year=2002

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