NTSB investigations: Balloon Works FIREFLY 7, VA
6 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 | 3 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1999 | 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\" = 'VA' 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" = 'VA' 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 NYC99LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Gasburg, VAThe unforecast high winds that required the pilot in command to make a precautionary landing.NTSB BFO87LA063Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Richmond, VAThe Balloon was 10th to takeoff in a hound-&-hare competition. Drg flt, the plt noticed the wind had picked up & that the Balloon was drifting towards Richmond. He decided to land in a cemetery & briefed the passengers that the Balloon would touch down hard &…NTSB BFO86LA046Accident · Serious injuriesLimited investigationFinal reportBalloon Works FF-7 · Roanoke, VAThe hot air Balloon was involved in an air show flight event. While enroute to the airport the plt stated that he encountered winds that forced him to land short of the arpt. During the lndg apch he became distracted by spectators on the ground who were in…NTSB IAD78FIA13Accident · Minor injuriesClosedBalloon WKS Frfy 7 · Catlett, VANTSB IAD78FIA10Accident · Serious injuriesClosedBalloon WKS Fire 7 · Catlett, VANTSB IAD78DIA11Accident · Serious injuriesClosedBalloon WKS Frfy 7 · Casanova, VA