# NTSB investigations: Piper AEROSTAR 601P: In flight encounter with weather

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 FTW97FA042](https://openairdocs.org/ntsb/FTW97FA042.md): Piper Aerostar 601P · Eagle, CO · Accident · 5 fatal · Field investigation · Final report · Nov 17, 1996 · N251B · Destroyed
  > The pilot initiating flight into known adverse weather conditions without proper certification. Factors were the meteorological conditions that existed --- low ceiling, low visibility, and falling snow --- and his use of contraindicated drugs.
- [NTSB BFO94FA163](https://openairdocs.org/ntsb/BFO94FA163.md): Piper PA-601P · Sea Isle City, NJ · Accident · 4 fatal · Field investigation · Final report · Aug 15, 1994 · N3642A · Destroyed
  > the pilot's failure to maintain aircraft control. Factors contributing to the accident were the presence of a level 6 thunderstorm, loss of gyro's for an undetermined reason, and the pilot's poor weather evaluation.
- [NTSB FTW91FA012](https://openairdocs.org/ntsb/FTW91FA012.md): Piper 601P · Nacogdoches, TX · Accident · 5 fatal · Field investigation · Final report · Nov 9, 1990 · N23NS · Destroyed
  > Failure of the pilot to follow IFR procedures and maintain the proper altitude. Factors related to the accident were: the adverse weather conditions, dark night, low fuel state of the aircraft, and trees at the accident site.
- [NTSB LAX89FA268](https://openairdocs.org/ntsb/LAX89FA268.md): Piper PA-601P · Ramona, CA · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1989 · N6067Z · Destroyed
  > The pilot's VFR flight in instrument meteorologial conditions (IMC) and spatial disorientation, which resulted in an inadvertent descent into the ground. Factors related to the accident were: darkness, low ceiling, and the pilot's lack of a preflight weather…
- [NTSB CHI83LA040](https://openairdocs.org/ntsb/CHI83LA040.md): Piper 601P · Sheboygan, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 18, 1982 · N6078U · Destroyed
  > The plt noticed haze in lights at destination but had excellent ground contact throughout the approach. At threshold he entered dense ground fog & lost all visual contact. The acft crashed during the go-around.
- [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."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" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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