# NTSB investigations: Smith AEROSTAR 601P, 2005

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 NYC06LA042](https://openairdocs.org/ntsb/NYC06LA042.md): Piper PA-46-310P · Dunkirk, NY · Accident · No injuries · Limited investigation · Final report · Dec 14, 2005 · N302H · 2 aircraft · Substantial damage
  > The Piper Malibu pilot's failure to use the correct radio frequency for traffic advisories, and his selection of the wrong, inactive runway, which resulted in an on-ground collision with another airplane while landing.
- [NTSB DFW05CA247](https://openairdocs.org/ntsb/DFW05CA247.md): Smith, Ted Aerostar 601P · Mexia, TX · Accident · Minor injuries · Data collection · Final report · Sep 22, 2005 · N909KF · Destroyed
  > The pilot's failure to maintain clearance from the barn. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.
- [NTSB DFW05CA201](https://openairdocs.org/ntsb/DFW05CA201.md): Smith Aerostar 601P · Sinton, TX · Accident · Minor injuries · Data collection · Final report · Aug 4, 2005 · N15BA · Destroyed
  > The pilot's failure to abort the takeoff and the subsequent loss of engine power for undetermined reasons. Contributing factors were the attempted operation of the airplane with known deficiencies in the equipment and the lack of suitable terrain for the…

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

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

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