# NTSB investigations: Balloon Works FIREFLY 7: On ground/water collision with object

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 ATL85LLT07](https://openairdocs.org/ntsb/ATL85LLT07.md): Barnes FF-7 · Franklin, TN · Accident · Serious injuries · Final report · May 8, 1985 · N4049Y · Minor damage
  > The plt noticed a power line extending across the field he had selected for landing at which time air was released from the envelope for an emergency descent. As the basket touched down, the envelope drifted into the line. A passenger was seriously injuried…
- [NTSB FTW84LA087](https://openairdocs.org/ntsb/FTW84LA087.md): Balloon Works Firefly 7 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Dec 3, 1983 · N4061P · Substantial damage
  > The plt reported that during flt, unfavorable winds were encountered. An apch was made to a golf course, but the plt aborted dur to high winds. A short time later, an apch was made to a park area. According to the plt, the wind switched as the Balloon touched…
- [NTSB LAX82DA089](https://openairdocs.org/ntsb/LAX82DA089.md): Barnes Balloon AX7 · Napa, CA · Accident · Minor injuries · Final report · Feb 28, 1982 · N40688 · Destroyed
  > The 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…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1050100')
    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" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.