Final NTSB investigations: Aerostar International S-66A
9 cases on aircraft the registry lists as Aerostar International S-66A. 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.
Cases per year
| 1986 | 1 |
|---|---|
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7486066'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7486066'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 DEN08LA004Accident · 1 fatalLimited investigationFinal reportAerostar S-66A · Albuquerque, NMThe pilot's failure to maintain adequate visual lookout and clearance resulting in an in-flight collision with power lines, and the ground crew's improper assistance. Contributing to this accident were the high wind, the pilot's diverted attention, low…NTSB DEN03LA081Accident · Serious injuriesLimited investigationFinal reportAerostar International S66A-3060 · Albuquerque, NMthe pilot's failure to maintain aircraft control during a high wind landing, which resulted in a hard landing. Contributing factors include the high wind and the berm.NTSB DEN00LA150Accident · No injuriesLimited investigationFinal reportAerostar S-66A · Edwards, COLack of crew coordination when the ground crew failed to hold the balloon in position following landing as the pilot expected them to do. A factor was power lines.NTSB LAX93LA188Accident · Serious injuriesLimited investigationFinal reportAerostar AX-9 · Calistoga, CAThe balloon's encounter with higher than forecast winds which resulted in a hard landing. A factor in the accident was the design of the balloon basket with a recessed area which prevented any lateral movement of the injured passenger's foot during the…NTSB NYC92LA177Accident · No injuriesLimited investigationFinal reportAerostar AX-9 · Hopkinton, MAThe pilot's inflight planning which resulted in a forced landing in unsuitable terrain due to fuel exhaustion.NTSB BFO92LA082Accident · Serious injuriesLimited investigationFinal reportAerostar AX-9 - S-66A · Southhampton, NJThe pilot used an excessive descent rate during landing. Contributing to the accident was an unfavorable wind condition.NTSB LAX90LA220Accident · No injuriesLimited investigationFinal reportAerostar S-66A · Davis, CAThe failure of the pilot to properly manage the fuel valves to provide adequate fuel pressure to the burner.NTSB DEN88LA007Accident · Serious injuriesLimited investigationFinal reportAerostar S-66A · Albuquerque, NMUpon landing, the balloon touched down on a gravel road and bounced over a small depression. The basket struck a small mound and threw three of the six passengers against the rail of the basket. The other passengers fell against them and the three were…NTSB DEN86LA229Accident · No injuriesLimited investigationFinal reportRaven Aero Star S-66A · Fort Collins, COThe plt rprtd he began venting the balloon in preparation for a landing in a field. The balloon encountered a wind shift & started drifting toward powerlines. The plt said there was not enough time to add heat to avoid the powerlines, so he held the vent open…