# NTSB investigations: Piper AEROSTAR 600, MI

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 CHI90FA190](https://openairdocs.org/ntsb/CHI90FA190.md): Piper PA-28 · Plymouth, MI · Accident · 3 fatal · Field investigation · Final report · Jul 23, 1990 · N55354 · 2 aircraft · Destroyed
  > Inadequate visual lookout by the pilot of the PA-60. A factor related to the accident was that neither of the flight crews had obatained atc/radar assistance.
- [NTSB CHI85LA080](https://openairdocs.org/ntsb/CHI85LA080.md): Piper Aerostar 600 · Kalamazoo, MI · Accident · No injuries · Limited investigation · Final report · Dec 27, 1984 · N8060J · Substantial damage
  > The plt reported upon touchdown, the acft contacted a patch of ice causing it to slide sideways resulting in a left main gear collapse. ATC twr witnesses stated the acft appeared fast on final and a hard landing was made.
- [NTSB CHI84FA148](https://openairdocs.org/ntsb/CHI84FA148.md): Piper Aerostar 600 · Pontiac, MI · Accident · No injuries · Field investigation · Final report · Apr 4, 1984 · N3645T · Substantial damage
  > During an ILS apch, the acft collided with treetops while it was slightly left of the apch course near the middle marker. The plt continued to fly the acft to the rwy & the plane touched down about 1000 ft beyond the threshold. At touchdown, the acft veered…

## 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" = 'MI' 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=MI

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