NTSB investigations: Balloon Works FIREFLY 7, IL
5 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 per year
| 1978 | 1 |
|---|---|
| 1980 | 1 |
| 1984 | 2 |
| 1985 | 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\" = 'IL' 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 ('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."eventStateOrRegion" = 'IL' 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 ('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 CHI85FEE02Accident · Serious injuriesFinal reportBalloon Works Firefly AX-7 · Somonauk, ILThe Balloon collided with powerlines during takeoff. The wind was reported as 10-15 mph with gusts. The operation was canceled due to the wind after 6 successful launches. The last plt was reportedly pressured to go by his pass'g and a gust of wind blew them…NTSB CHI84LA268Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Batavia, ILThe plt received a wx briefing before the flt. The 1950 surface observation reported winds from 090 deg at 4 KTS. During flt, the winds suddenly picked up & the plt attempted a landing. A rapid rate of descent developed & the balloon collided with trees…NTSB CHI84LA260Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Geneva, ILThe Balloon descended in an area of thunderstorms and turbulence and collided with trees. The plt said the Balloon 'caved in' and descended rapidly. The plts husband and a passenger revealed that the Balloon was 'vented' by the plt to land before reaching a…NTSB CHI80DEE57Accident · No injuriesClosedBLN Works FF-7 · Rock Island, ILNTSB CHI79DEE07Accident · No injuriesClosedBalloon WKS FF7 · Grayslake, IL