# NTSB investigations: Smith AEROSTAR 600, NY

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 NYC89LA113](https://openairdocs.org/ntsb/NYC89LA113.md): Smith, Ted Aerostar Aerostar 600 · Utica, NY · Accident · No injuries · Limited investigation · Final report · Apr 6, 1989 · N90437 · Substantial damage
  > A fire in the cockpit from an unknown source.
- [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 NYC76FFJ02](https://openairdocs.org/ntsb/NYC76FFJ02.md): Ted Smith 600 · Gasport, NY · Accident · No injuries · Closed · Jul 4, 1975 · N7547S · Substantial damage

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

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

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