Skip to content

NTSB investigations: Aerostar International RX 8, NM

13 cases on aircraft the registry lists as Aerostar International RX 8. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19892026

Where

Latest cases

Query with 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" = 'NM' 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 ('7487008')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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\" = 'NM' 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 ('7487008'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB WPR26LA021Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Albuquerque, NMThe pilot's failure to maintain clearance from a power line during a descent for landing.Oct 6, 2025 · N5315M · Substantial damage NTSB CEN17CA013Accident · Minor injuriesData collectionFinal reportAerostar RX-8 · Albuquerque, NMThe pilot's improperly planned landing, which resulted in a strike with power lines.Oct 2, 2016 · N5161Y · Substantial damage NTSB CEN16LA030Accident · Serious injuriesLimited investigationFinal reportAerostar RX8 · Albuquerque, NMThe pilot's delay in deflating the balloon envelope completely after landing, which resulted in a loss of control due to a wind gust.Oct 10, 2015 · N5294Q · No damage NTSB CEN13LA032Accident · Minor injuriesLimited investigationFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to attain the desired touchdown point because of wind conditions and surrounding obstructions, which resulted in the balloon impacting a fence during the approach to landing.Oct 10, 2012 · N90550 · Substantial damage NTSB CEN10CA015Accident · Serious injuriesData collectionFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to select an adequate landing area.Oct 8, 2009 · N4014J · Minor damage NTSB DEN08LA007Accident · No injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMThe pilot's inability to maintain aircraft control due to high winds, resulting in the aircraft coming in contact with an arroyo and a wall in a residential area.Oct 9, 2007 · N5315M · Substantial damage NTSB DEN06CA069Accident · Serious injuriesData collectionFinal reportAerostar International RX 8 · Albuquerque, NMthe pilot's inability to maintain a proper descent rate due to the high winds, resulting in a hard landing. A contributing factor was the high wind conditions.Apr 22, 2006 · N7142S · No damage NTSB FTW98LA009Accident · No injuriesLimited investigationFinal reportCameron N-90 · Albuquerque, NMThe failure of the pilot of the Aerostar RX 8, N71415, to follow procedures/directives.Oct 10, 1997 · N1602R · 2 aircraft · Substantial damage NTSB FTW97LA069Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Rio Rancho, NMThe pilot's inadvertent flight into high wind.Dec 22, 1996 · N6310T · Minor damage NTSB FTW97LA023Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMA sudden increase in wind velocity.Oct 8, 1996 · N3581D · No damage NTSB FTW96LA055Accident · Serious injuriesLimited investigationFinal reportAerostar RX8 · Rio Rancho, NMThe pilot's improper planning/decision. A factor relating to the accident was: the high wind condition.Nov 26, 1995 · N6360U · No damage NTSB FTW96LA013Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMThe pilot's improper in-flight planning/decision. The variable wind condition was a related factor.Oct 10, 1995 · N9153X · No damage NTSB DEN90LA005Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Albuquerque, NMThe pilot's selection of an unsuitable area (terrain) for landing. The static cable & power line were considered to be related factors.Oct 8, 1989 · N3581D · Substantial damage