NTSB investigations: Balloon Works FIREFLY 7-B
4 cases on aircraft the registry lists as Balloon Works FIREFLY 7-B, where the first occurrence was “In flight encounter with weather”. 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
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1990 | 1 |
| 1998 | 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 ('10501A9')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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 ('10501A9')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 FTW98LA231Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Longmont, COThe pilot's failure to properly position his foot for a high wind landing. Factors were high winds and windshear.NTSB ATL90LA104Accident · No injuriesLimited investigationFinal reportBalloon Works 7B · Lexington, KYThe overload failure of several jumper cords. Factor(s) were inadvertent encounter with unfavorable wind (dust devil). Subsequently, the pilot was unable to control the rate of descent.NTSB MKC86FA117Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 7-B · Lee'S Summit, MOThe PIC stated that prior to liftoff, the Balloon was gyrating and instructed the gnd crew member to steady the Balloon by holding the rope. Just as the Balloon became steady the PIC initiated his takeoff. The PIC was aware of turbulence in the takeoff site…NTSB FTW82DQG17Accident · Serious injuriesFinal reportBalloon Works 7-B · Masterson, TXAfter making weather observations and obtaining a weather briefing, the instructor pilot (ip) briefed the chase crew of the expected northerly track. The ip and student took off at 0705 CST and ascended to 1200 to 15000 ft AGL and began tracking…