# NTSB investigations: Smith AEROSTAR 600, 1983

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 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.…
- [NTSB NYC83IA056](https://openairdocs.org/ntsb/NYC83IA056.md): Smith, Ted Aerostar 600 Aerostar · Philadelphia, PA · Incident · No injuries · Incident investigation · Final report · Jan 25, 1983 · N9759Q · Minor damage
  > The aircraft veered off the runway during landing. The weather was VMC at the time. When the landing gear was lowered for landing no discrepancies were noted by the pilot prior to touchdown. During touchdown the aircraft veered to the left. The pilot took…

## 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") = 1983
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8360602'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=8360602&year=1983

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