# NTSB investigations: Balloon Works FIREFLY 7, VA

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB NYC99LA118](https://openairdocs.org/ntsb/NYC99LA118.md): Balloon Works FIREFLY-7 · Gasburg, VA · Accident · Serious injuries · Limited investigation · Final report · May 23, 1999 · N9070T · No damage
  > The unforecast high winds that required the pilot in command to make a precautionary landing.
- [NTSB BFO87LA063](https://openairdocs.org/ntsb/BFO87LA063.md): Balloon Works Firefly 7 · Richmond, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 7, 1987 · N37526 · Minor damage
  > The 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 BFO86LA046](https://openairdocs.org/ntsb/BFO86LA046.md): Balloon Works FF-7 · Roanoke, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1986 · N7423H · Minor damage
  > The 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 IAD78FIA13](https://openairdocs.org/ntsb/IAD78FIA13.md): Balloon WKS Frfy 7 · Catlett, VA · Accident · Minor injuries · Closed · Jun 27, 1978 · N2348H · Substantial damage
- [NTSB IAD78FIA10](https://openairdocs.org/ntsb/IAD78FIA10.md): Balloon WKS Fire 7 · Catlett, VA · Accident · Serious injuries · Closed · Jun 27, 1978 · N27138 · Minor damage
- [NTSB IAD78DIA11](https://openairdocs.org/ntsb/IAD78DIA11.md): Balloon WKS Frfy 7 · Casanova, VA · Accident · Serious injuries · Closed · Jun 27, 1978 · N2091F · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/ntsb?model=1050100&state=VA

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.