# NTSB investigations: Smith AEROSTAR 601P: Loss of engine power(partial) - mech failure/malf

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 FTW99FA199](https://openairdocs.org/ntsb/FTW99FA199.md): Smith, Ted Aerostar Aerostar 601P · Bethany, OK · Accident · 2 fatal · Field investigation · Final report · Jul 23, 1999 · N345LS · Destroyed
  > The pilot's failure to maintain the minimum controllable airspeed. A factor was the disconnected rubber interconnect boot, which resulted in the partial loss of left engine power.
- [NTSB MIA87LA021](https://openairdocs.org/ntsb/MIA87LA021.md): Smith, Ted Aerostar 601P · Jacksonville, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 5, 1986 · N8002J · Destroyed
  > While in cruise flight, the pilot noted that the left engine began losing power and oil pressure. He stated that he then shut down the engine and feathered the propeller. He declared an emergency and descended to land. While on final approach, he lowered the…
- [NTSB LAX83FA104](https://openairdocs.org/ntsb/LAX83FA104.md): Piper 601P · San Diego, CA · Accident · 5 fatal · Field investigation · Final report · Feb 18, 1983 · N90353 · Destroyed
  > While taking off, the acft climbed aprx 100 to 200 ft, then began loosing alt. During a forced landing on a street, it hit a parked car & a light pole & burst in flames. The plt, who later expired, said that neither eng developed full power (2575 RPM). He…

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

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

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