# NTSB investigations: Balloon Works FIREFLY 7: Miscellaneous/other

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 IAD98LA105](https://openairdocs.org/ntsb/IAD98LA105.md): Balloon Works Firefly 7 · Freehold, NJ · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 1998 · N9067F · No damage
  > The passenger's failure to secure himself during landing.
- [NTSB NYC88LA142](https://openairdocs.org/ntsb/NYC88LA142.md): Balloon Works Firefly 7 · Red Creek, NY · Accident · Serious injuries · Limited investigation · Final report · May 14, 1988 · N1502K · No damage
  > While the pilot was waiting for liftoff, three ground crewmen were sitting on the basket holding the Balloon down. As the pilot prepared for liftoff, he announced that he was ready for liftoff and untied the rope. As the Balloon reached an altitude of about…
- [NTSB DEN86LA189](https://openairdocs.org/ntsb/DEN86LA189.md): Balloon Works Firefly 7 · Hurley, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 1986 · N37486 · No damage
  > During landing, one of the paxs in the Balloon basket suffered a broken ankle. Plt says landing was a normal rip out landing. Neither he nor pax knows how injury occurred.
- [NTSB FTW84LA254](https://openairdocs.org/ntsb/FTW84LA254.md): Balloon Works Firefly 7 · Amarillo, TX · Accident · Serious injuries · Limited investigation · Final report · May 27, 1984 · N3610R · No damage
  > During a pre-flt breifing, the wind was reported to be from 280 deg at 6 to 12 KTS. At launch time, the plt estimated the wind was blowing at 7 KTS. He took off at 0720 CDT without difficulty & climbed to about 1000 ft AGL. Aprx 1 hr after taking off, the plt…

## 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" = 430))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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