NTSB investigations: General Balloon AX-6
9 cases on aircraft the registry lists as General Balloon AX-6. 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
| 1976 | 1 |
|---|---|
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1995 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3760202'))
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 ('3760202'))
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 LAX07CA094Accident · No injuriesData collectionFinal reportGeneral Balloon AX-6 · San Martin, CAThe pilot's failure to maintain adequate altitude/clearance from power lines.NTSB FTW96LA067Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Houston, TXFailure by the pilot to maintain control of the balloon during landing. A factor was unfavorable wind.NTSB LAX88LA255Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Pilot Hill, CADuring a local sightseeing flight, just prior to touchdown, the Pilot reported that a gust of wind caught the balloon. The Pilot made a high wind landing. The balloon was dragged several feet before coming to rest. The Pilot stated that afterward the winds…NTSB BFO87LA041Accident · 1 fatalLimited investigationFinal reportPiccard AX-6 · Gaithersburg, MDAfter two aborted landings the pilot saw a field in the distance and attempted to land. Although two other balloons had landed nearby, the field he was blown towards had numerous powerlines surrounding it, some of them at treetop height. During the approach…NTSB LAX85LA395Accident · Serious injuriesLimited investigationFinal reportPiccard AX6 · Pilot Hill, CADuring inflation of the balloon prior to flt, the plt said he noticed a 5 kt gust of wind. Plt then sent a small balloon aloft to test the wind and said it 'showed a slowing of the wind' at 60 to 80 ft AGL & acceptable flt conditions. After launch the wind…NTSB LAX85LA223Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Panamint Valley, CAThe plt reported that he was landing on desert terrain in nearly calm air when a 'strong thermal wind pushed the balloon 90 degrees from the direction of track.' Subsequently, the balloon landed hard & was dragged about 150 ft across the desert. While…NTSB LAX81DUG36Accident · Minor injuriesClosedPiccard AX-6 · Corona, CANTSB CHI81DEC02Accident · Serious injuriesClosedPiccard AX-6 · Metamora, MINTSB OAK76FVG98Accident · Minor injuriesClosedPiccard AX-6 · Napa, CA