# 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 CEN14FA163](https://openairdocs.org/ntsb/CEN14FA163.md): Smith Aerostar 601P · Aurora, CO · Accident · 1 fatal · Field investigation · Final report · Mar 19, 2014 · N90464 · Destroyed
  > The pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control.
- [NTSB CEN12CA202](https://openairdocs.org/ntsb/CEN12CA202.md): Smith Aerostar 601P · Casterville, TX · Accident · No injuries · Data collection · Final report · Mar 24, 2012 · N602BV · Substantial damage
  > The pilot did not maintain control of the airplane while circling to land.
- [NTSB ERA12FA146](https://openairdocs.org/ntsb/ERA12FA146.md): Aerostar PA-60-601P · Philadelphia, MS · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2012 · N700PS · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff following loss of power to the left engine due to fuel starvation. Contributing to the loss of control was the pilot’s failure to feather the left propeller following the loss of left engine…
- [NTSB CEN10FA108](https://openairdocs.org/ntsb/CEN10FA108.md): Smith Aerostar 601P · Sugar Grove, IL · Accident · 2 fatal · Field investigation · Final report · Jan 24, 2010 · N222AQ · Destroyed
  > The pilot's spatial disorientation and subsequent failure to maintain airplane control.

## 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/240/sequence?model=8360608

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