# NTSB investigations: Smith AEROSTAR 601P: Loss of control - in flight

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 NYC07FA038](https://openairdocs.org/ntsb/NYC07FA038.md): Smith, Ted Aerostar 601P · West Dover, VT · Accident · 1 fatal · Field investigation · Final report · Dec 2, 2006 · N9797Q · Destroyed
  > A loss of control during approach for undetermined reasons, which resulted in a collision with trees.
- [NTSB NYC02FA051](https://openairdocs.org/ntsb/NYC02FA051.md): Smith Aerostar 601P · Chittenden, VT · Accident · 2 fatal · Field investigation · Final report · Jan 25, 2002 · N104CS · Destroyed
  > The pilot's failure to maintain aircraft control while holding.
- [NTSB DEN99FA066](https://openairdocs.org/ntsb/DEN99FA066.md): Smith, Ted Aerostar 601P · Ruidoso, NM · Accident · 2 fatal · Field investigation · Final report · Apr 23, 1999 · N48MD · Destroyed
  > The pilot's failure to maintain aircraft control for undetermined reason. A factor was the low ceiling IMC weather condition.
- [NTSB DEN86LA095](https://openairdocs.org/ntsb/DEN86LA095.md): Smith, Ted Aerostar 601P Aerostar · Dickinson, ND · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 1986 · N35DM · Substantial damage
  > While enroute on an IFR flight plan, the plt changed destination to Dickinson, ND, which extended the length of the flt. He did not desiginate an alternate arpt or have an adequate fuel reserve as required. On arrival at the destination, he executed an…
- [NTSB NYC83FA004](https://openairdocs.org/ntsb/NYC83FA004.md): Ted Smith 601P · Augusta, ME · Accident · 1 fatal · Field investigation · Final report · Oct 29, 1982 · N90439 · Destroyed
  > Pilot lost control of his aircraft during low altitude maneuvers to align the aircraft for landing. The low ceiling and rising terrain around the airport influenced the pilots decisions to make tight turns at low altitude. The aircraft was stalled and rolled…
- [NTSB MIA82FA120](https://openairdocs.org/ntsb/MIA82FA120.md): Piper P-60-601P · Titusville, FL · Accident · 1 fatal · Field investigation · Final report · May 18, 1982 · N90702 · Destroyed
  > Shortly after takeoff witnesses observed the acft in a steep left bank descending until it crashed approximately 1200 ftnw of the departure end of the rwy. According to the pax the initial climb distracting the attention of the plt who lostcontrol of the acft…

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

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

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