NTSB investigations: Balloon Works FIREFLY 8-24, AZ
6 cases on aircraft the registry lists as Balloon Works FIREFLY 8-24. 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1994 | 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\" = 'AZ' 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 ('1050107'))
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" = 'AZ' 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 ('1050107'))
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 LAX94LA337Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Sedona, AZa tip over of the balloon and basket during a high wind landing due to the pilot's inability to compensate for the increased wind speed conditions during the final stages of the flight and landing.NTSB LAX88LA079Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Phoenix, AZNTSB LAX87LA168Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Phoenix, AZDuring a pleasure Balloon ride, the Balloon lifted off in a southerly direction then shifted to a south easterly direction. The plt felt that the balloons response time for adequate lift took too long. The Balloon began drifting toward 50 to 60 ft power…NTSB LAX87LA160Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes FF-8-24 · Phoenix, AZDuring a local sightseeing flight, the pilot reported that upon lift-off the weather conditions were clear and calm. During the flight, however, the wind conditions had increased from a westerly direction at a velocity of 12 knots, gusting to 15. The pilot…NTSB LAX86LA159Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Pheonix, AZThe Balloon collided with the terrain during a sight seeing tour. The plt noticed the dust signature of ground turbulent wx phenomena known as rotors or dust devils arpx 3 miles ahead. He elected to make an immediate precautionary landing and descended to an…NTSB LAX84LA231Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 8-24 · Phoenix, AZThe plt took off on a sight-seeing Balloon flt with 5 passengers whose ages were reportedly from 65 to 83 yrs old. About 1 hr & 15 mins later, he landed on desert terrain in winds that he estimated were aprx 10 KTS gusting to 15 KTS. During touchdown, the…