# NTSB investigations: Piper AEROSTAR 600, OH

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 ATL87LA254](https://openairdocs.org/ntsb/ATL87LA254.md): Aerostar 600 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Sep 11, 1987 · N8073J · 2 aircraft · Substantial damage
  > The scheduled domestic all cargo flt was taxiing from the ramp to the rwy behind another company acft when the plt suddenly realized that the lead acft was not moving. The plts attempts to stop the acft were not successful. The stopped acft was substantially…
- [NTSB CHI82DA068](https://openairdocs.org/ntsb/CHI82DA068.md): Piper PA-60 · Cleveland, OH · Accident · No injuries · Final report · Feb 23, 1982 · N8035J · Substantial damage
  > During takeoff roll from a dry runway the pilot reported the aircraft started veering to the left. The pilot attempted to straighten the aircraft with power & brakes to no avail then pushed in throttle in an attempt to fly out. The aircraft departed 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 c."eventStateOrRegion" = 'OH' 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 ('7106001', '7104100'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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