# NTSB investigations: Piper AEROSTAR 601P, 1982

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 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 LAX83FA035](https://openairdocs.org/ntsb/LAX83FA035.md): Piper 601P · Tonopah, NV · Accident · No injuries · Field investigation · Final report · Nov 17, 1982 · N3642A · Substantial damage
  > As the acft reached 15,500 ft, aprx 30 mi from the dep arpt, the plt & pax noted fumes that irritated the eyes & caused dizziness & breathing difficulties. The plt reversed course, then elected to make an emerg lndg on a dirt road. Drg the lndg roll-out, the…
- [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 year(c."eventDate") = 1982
  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=1982

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