# NTSB investigations: Aerostar International RX 8: In flight collision with object

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 CHI06LA208](https://openairdocs.org/ntsb/CHI06LA208.md): Aerostar International RX 8 · Claremont, MN · Accident · Serious injuries · Limited investigation · Final report · Jul 21, 2006 · N3639Q · No damage
  > The procedure not followed by the passenger during landing and the inadequate supervision of the passenger by the pilot during landing. A contributing factors were the barbed wire fence.
- [NTSB LAX99FA177](https://openairdocs.org/ntsb/LAX99FA177.md): Aerostar Rally RX-8 · Morgan Hill, CA · Accident · 2 fatal · Field investigation · Final report · May 9, 1999 · N70290 · Destroyed
  > The pilot's selection of an inadequate takeoff site that did not allow sufficient horizontal clearance from obstacles in the takeoff path, and, his failure to ensure that all burners were connected to fuel sources, which reduced the available climb capability…
- [NTSB MIA96LA177](https://openairdocs.org/ntsb/MIA96LA177.md): Aerostar RX-8 · Canton, MS · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1996 · N7155N · Substantial damage
  > failure of the pilot to maintain sufficient altitude and/or clearance from the tower.
- [NTSB DEN90LA005](https://openairdocs.org/ntsb/DEN90LA005.md): Aerostar RX-8 · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 8, 1989 · N3581D · Substantial damage
  > The pilot's selection of an unsuitable area (terrain) for landing. The static cable & power line were considered to be related factors.

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

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

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