NTSB investigations: Balloon Works FIREFLY 7
90 cases on aircraft the registry lists as Balloon Works FIREFLY 7. 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, newest first
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 ('1050100'))
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 ('1050100'))
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 FTW83FA364Accident · No injuriesField investigationFinal reportBalloon Works Firefly AX-7 · Fort Worth, TXThe intended landing area was a parking lot. Adjacent to the lot was a one-story building on top of which a tv antenna about 20 ft above the roof top. In an effort to clear the antenna during the descent to the parking lot, the pltwas not aware of a set of…NTSB CHI83LA318Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Utica, MIThe student pilot made a delayed decision to land and landed within a few ft of wires without seeing them. The ground crew tried to hold him but the balloon still had too much lift. The student then saw the wires and tried to go over thembut the collision…NTSB MKC83LA140Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7 · Ellsworth, KSThe Balloon collided with a radio tower during takeoff. The wind was reported to be from 180 degrees at 12-18 KTS. There is no evidence that this plt received weather briefing. This Balloon was launched closer to the tower than any of the other balloons…NTSB CHI83LA265Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Flint, MIAfter takeoff, the plt leveled the Balloon, and a short time later, he collapsed to the floor of the gondola & had difficulty breathing. The Balloon began descending. Subsequently, it hit the porch of a house & was damaged. The plt died from acute myocardial…NTSB DEN83FTE03Accident · Serious injuriesFinal reportBalloon Works Firefly 7 · Del Norte, COWhile circumnavigating snow showers at night in mountainous terrain the plt elected to make a precautionary landing on a highway. The acft struck trees on a hillside that the plt hadn't seen in the darkness.NTSB CHI83LA134Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly AX-7 · Augusta, MIThe Balloon made a hard landing and ejected the pilot and passenger. The landing was made in a school parking lot. Afterdropping the occupants the Balloon contacted power lines with the envelope. The occurants were not injured.NTSB FTW83LA005Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe Balloon collided with trees while landing in a zoo parking lot. The weather was VMC and no flight plan was filed. The pilot stated that in attempting to land next to the Balloon they were chasing in a hound and hare game, he allowed the gondola to drag…NTSB FTW83LA010Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe Balloon landed in high winds and was dragged by the envelope for about 150 yards. While the gondola was being dragged a passengers boot got caught and twisted his leg so that both bones were broken. The weather was VMC and no flight plan was filed. The…NTSB DEN82DTE26Accident · Serious injuriesFinal reportBarnes AX-7 · Aurora, COThe VFR local pleasure flight was being conducted in strong 20-25 kt wind conditions. The wind condition had changed substantially during the duration of the flight. During a landing in a plowed field the gondola bounced and was drug approximately 270 feet.…NTSB NYC82FNC11Accident · Serious injuriesFinal reportFirefly 7 · Winslow, MEWhile descending to land in an open field, the balloon began drifting towards high powerlines. In an attempt to avoid a collision, the pilot fired the burner approximately nine times, using short blasts of the burner. The balloon failed to gain altitude and…NTSB ATL82DA189Accident · No injuriesFinal reportBalloon Works Firefly 7 · Greenville, SCThe ballon with three persons on board dropped too low in a target hitting contest. The pilot then decided he could not climb above wires so he vented the Balloon in an attempt to land short. The bag contacted the wires and burned. The pilot stated he…NTSB FTW82FQA21Accident · Serious injuriesFinal reportBarnes AX-7 · Albuquerque, NMThe pilot stated she made a practice landing near a large hill and had no problems landing. She continued flight for approximately 20 minutes and prepared to land on a road. The balloon impacted a road embankment at touchdown and the pilot broke her leg. She…NTSB MKC82DA109Accident · No injuriesFinal reportBalloon Works Firfly 7 · Ballwin, MOThe student pilot was demonstrating his ability to make 3 landings to meet the flight requirements for a private pilot rating. The first 2 landing were without incident. After the third takeoff, an increase in the wind velocity was encountered. For the third…NTSB CHI82DA178Accident · No injuriesFinal reportBalloon Works FIREFLY-7 · Wyoming, MIThe pilot was attempting to takeoff from a parking lot. He stated that when the Balloon was about 15 feet from the ground a gust of wind pushed the Balloon down into some trees and an apartment house.NTSB LAX82DA089Accident · Minor injuriesFinal reportBarnes Balloon AX7 · Napa, CAThe pilot attempted to land short of powerlines after aborting an ascent to safely clear them because of what he reported as unstable air. The gondola bounced and slid into the wires. The pilot stated that electric current passed through the load lines and a…NTSB CHI82DA076Accident · Serious injuriesFinal reportBarnes FIREFLY-7 · Cincinnati, OHPilot stated that after a normal inflation, before the balloon was hot enough to sustain flight, a gust of wind blew it into a school building. After striking the building, the balloon was dragged through a line of trees.NTSB LAX82FUJ28Accident · No injuriesFinal reportBalloon Works Firefly · Phoenix, AZThe pilot was landing in a vacant lot when the light and variable wind shifted and started blowing the Balloon toward powerlines. Just prior to the wind shift, the Balloon was descending rapidly. Rather than make a hard landing, the pilot tried to "burn" his…NTSB CHI82FA005Accident · 1 fatalClosedBLN Works FF-7 · Delaware, OHNTSB CHI80DEE57Accident · No injuriesClosedBLN Works FF-7 · Rock Island, ILNTSB FTW80DRJ43Accident · Minor injuriesClosedBLN Works FF-7 · Tyler, TXNTSB NYC80;GM29Accident · No injuriesClosedBLN Works FF-7 · Indiana, PANTSB NYC80DNA23Accident · Minor injuriesClosedBLN Works FF-7 · Edgartown, MANTSB DEN80DTE57Accident · Serious injuriesClosedBLN Works FF-7 · Elbert, CONTSB DEN80DTE61Accident · Serious injuriesClosedFirefly 7 · Colo Springs, CONTSB IAD80FA039Accident · 3 fatalClosedBalloon WKS AX-7 · Hurricane, WVNTSB MKC80FCQ12Accident · No injuriesClosedBalloon WKS FF7 · Towanda, KSNTSB LAX80DUJ44Accident · Serious injuriesClosedBLN Works FF-7 · Tucson, AZNTSB IAD80DKM11Accident · No injuriesClosedBalloon WKS AX-7 · East Bend, NCNTSB MIA80DLD13Accident · Serious injuriesClosedBalloon WKS KS-7 · Plant City, FLNTSB FTW79FPD46Accident · Serious injuriesClosedFirefly 7 · Mansfield, TXNTSB MKC79FA049Accident · Serious injuriesClosedBalloon WKS F'FLY7 · Clinton, MONTSB DEN79DTE68Accident · Serious injuriesClosedBalloon WKS Fire 7 · Firestone, CONTSB FTW79FPJ23Accident · No injuriesClosedBalloon WKS FRFLY7 · Norman, OKNTSB MKC79DCG64Accident · Serious injuriesClosedBalloon WKS Firefy · Grain Valley, MONTSB CHI79DEE07Accident · No injuriesClosedBalloon WKS FF7 · Grayslake, ILNTSB CHI78DEC53Accident · No injuriesClosedBalloon WKS 7 · Northville, MINTSB CHI78FEX37Accident · 3 fatalClosedBalloon WKS FF 7 · Fishers, INNTSB IAD78FIA13Accident · Minor injuriesClosedBalloon WKS Frfy 7 · Catlett, VANTSB IAD78FIA10Accident · Serious injuriesClosedBalloon WKS Fire 7 · Catlett, VANTSB IAD78DIA11Accident · Serious injuriesClosedBalloon WKS Frfy 7 · Casanova, VA