# NTSB investigations: Smith AEROSTAR 601P, PA

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 NYC00FA064](https://openairdocs.org/ntsb/NYC00FA064.md): Aerostar 601P · Coatesville, PA · Accident · 2 fatal · Field investigation · Final report · Jan 10, 2000 · N905DK · Destroyed
  > The pilot's failure to follow the published instrument approach procedure, and his failure to establish a climb after passing the missed approach point.
- [NTSB NYC87LA189](https://openairdocs.org/ntsb/NYC87LA189.md): Piper PA-60 · Doylestown, PA · Accident · No injuries · Limited investigation · Final report · Jun 26, 1987 · N14HR · Substantial damage
  > Upon landing, the flight encountered standing water on the runway and the aircraft hydroplaned veering right of the centerline. The main landing gear collapsed causing substantial damage. The acft went off the rt side of the rwy after 2839 ft of roll and…
- [NTSB NYC86LA193](https://openairdocs.org/ntsb/NYC86LA193.md): Piper PA-60-601P · Lancaster, PA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1986 · N9531Q · Substantial damage
  > The Piper PA-60 Aerostar was making a takeoff with five passengers on board. The PIC did not establish any procedures with his co-pilot prior to the takeoff. The aircraft continued off the 4100 ft runway to the overrun finally becoming airborne. The co-pilot…
- [NTSB NYC78FA023](https://openairdocs.org/ntsb/NYC78FA023.md): Aerostar 601P · Dubois, PA · Accident · 2 fatal · Closed · Jan 24, 1978 · N1BE · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?model=8360608&state=PA

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