# NTSB investigations: Smith 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 MIA83FA046](https://openairdocs.org/ntsb/MIA83FA046.md): Piper PA-601P · Valparaiso, FL · Accident · 3 fatal · Field investigation · Final report · Dec 9, 1982 · N90692 · Destroyed
  > Two minutes after takeoff the plt reported a loss of the left eng. He was immediately cleared for a landing at eglin afb. While maneuvering for a landing the left eng & wing separated from the acft. The eng was separated from the wing & showed evidence of in…
- [NTSB NYC83FA004](https://openairdocs.org/ntsb/NYC83FA004.md): Ted Smith 601P · Augusta, ME · Accident · 1 fatal · Field investigation · Final report · Oct 29, 1982 · N90439 · Destroyed
  > Pilot lost control of his aircraft during low altitude maneuvers to align the aircraft for landing. The low ceiling and rising terrain around the airport influenced the pilots decisions to make tight turns at low altitude. The aircraft was stalled and rolled…
- [NTSB MIA82FA120](https://openairdocs.org/ntsb/MIA82FA120.md): Piper P-60-601P · Titusville, FL · Accident · 1 fatal · Field investigation · Final report · May 18, 1982 · N90702 · Destroyed
  > Shortly after takeoff witnesses observed the acft in a steep left bank descending until it crashed approximately 1200 ftnw of the departure end of the rwy. According to the pax the initial climb distracting the attention of the plt who lostcontrol of the acft…

## 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 ('8360608'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=8360608&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.
