NTSB investigations: General Balloon AX-6, CA
6 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 |
|---|---|
| 1981 | 1 |
| 1985 | 2 |
| 1988 | 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.\"eventStateOrRegion\" = 'CA' 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 ('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."eventStateOrRegion" = 'CA' 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 ('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 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 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 OAK76FVG98Accident · Minor injuriesClosedPiccard AX-6 · Napa, CA