# NTSB investigations: Smith AEROSTAR 600: 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 NYC98FA179](https://openairdocs.org/ntsb/NYC98FA179.md): Smith, Ted Aerostar TS-600 · Marietta, PA · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1998 · N600JB · Destroyed
  > The failure of the pilot to maintain airspeed during a precautionary landing which resulted in a loss of control while operating with one engine shutdown. An additional cause was the improper maintenance procedures that resulted in the #5 cylinder not being…
- [NTSB NYC86IA231](https://openairdocs.org/ntsb/NYC86IA231.md): Piper PA-60-600 · Binghamton, NY · Incident · No injuries · Incident investigation · Final report · Sep 9, 1986 · N90349 · Minor damage
  > The plt stated that after leveling off at 9000 ft MSL. He heard a pop followed by an explosion in the left eng. The entire left side of the upper cowling was protruding into the airstream which caused the aircraft to roll to the right. The pilot had to use…
- [NTSB MIA83LA200](https://openairdocs.org/ntsb/MIA83LA200.md): Aerostar 600 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Aug 9, 1983 · N7447S · Substantial damage
  > The acft departed ft. pierce, FL on a VFR flight to key west, FL, and ditched in lake okeechobee. While climbing THROUGH5000 ft the left engine lost power and started surging, the oil temperature gauge failed and smoke came from under the instrument panel.…

## 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 ('8360602')
    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=8360602&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.