NTSB investigations: Aerostar International S-77A
8 cases on aircraft the registry lists as Aerostar International S-77A. 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
| 1990 | 1 |
|---|---|
| 1995 | 1 |
| 1996 | 1 |
| 2000 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2008 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7487077'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7487077'))
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 LAX08CA209Accident · Minor injuriesData collectionFinal reportAerostar International S-77A · Boulder, COAn encounter with a sudden gust of wind, which rendered the balloon uncontrollable and led to a collision with a tree.NTSB CHI03LA147Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Cottage Grove, MNThe inadequate touchdown by the pilot.NTSB CHI02LA216Accident · Serious injuriesLimited investigationFinal reportAerostar International S-77A · Custer, SDThe pilot of the balloon did not maintain aircraft control. Factors contributing to the accident include the variable winds and the inadequate compensation for the wind conditions by the pilot in command.NTSB DEN00LA146Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Steamboat Spgs, COThe pilot's failure to maintain clearance from a bush during the balloon landing.NTSB CHI00LA196Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · River Falls, WIthe unfavorable wind condition for landing and control of the balloon during landing not possible by the pilot.NTSB LAX96LA190Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Tucson, AZthe interruption to the pilot's planned landing approach due to obstructions in the original touchdown spot, which led to the pilot misjudging the landing flare.NTSB LAX95LA237Accident · 1 fatalLimited investigationFinal reportAerostar S-77A · Davis, CAthe pilot's misjudgement of the balloon's excessive rate-of-descent in a high wind landing and her inadequate remedial action to correct the condition.NTSB LAX91LA038Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Phoenix, AZStrength degradation of the kevlar suspension cables, due to previous heat damage. Factors related to the accident were: failure of the quick release line to release, and susceptibility of kevlar suspension cables to heat.