# NTSB investigations: Smith AEROSTAR 601, TX

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 FTW95LA320](https://openairdocs.org/ntsb/FTW95LA320.md): Piper PA-60-601A · Fulshear, TX · Accident · No injuries · Limited investigation · Final report · Jul 29, 1995 · N135TS · Substantial damage
  > The pilot's failure to maintain a proper climb rate after take off. Factors were the pilot's diverted attention toward the malfunctioning landing gear, his intentional shutdown of operational engines, and the lack of suitable terrain for landing.
- [NTSB FTW87FA149](https://openairdocs.org/ntsb/FTW87FA149.md): Piper PA-60-601 · Hillsboro, TX · Accident · No injuries · Field investigation · Final report · Jun 22, 1987 · N7481S · Substantial damage
  > Aprx 3 min after leveling at 6500', the acft began losing pwr despite attempts to remedy the problem by using boost pump & x-feed. Subsequently, both engs lost power & the acft was damaged drg a wheels-up lndg in a milo field. An exam revealed the upper &…
- [NTSB FTW72AF007](https://openairdocs.org/ntsb/FTW72AF007.md): Aerostar 601 · Fort Worth, TX · Accident · 2 fatal · Closed · Jul 22, 1971 · N7480S · 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" = 'TX' 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 ('8360606'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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