# Final NTSB investigations: Balloon Works FIREFLY 6

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 CHI87LA167](https://openairdocs.org/ntsb/CHI87LA167.md): Balloon Works Firefly 7 · Springfield, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1987 · N1505F · 2 aircraft · Substantial damage
  > Two hot air balloons were involved in a midair collision during a sanctioned Balloon competition. N40363 was able to retain control and landed uneventfully. N1505F partially deflated and descended out of control to the ground. Witnesses stated that N40363 was…
- [NTSB MKC87FA067](https://openairdocs.org/ntsb/MKC87FA067.md): Balloon Works Firefly 6 · Kansas City, MO · Accident · Serious injuries · Field investigation · Final report · Apr 5, 1987 · N3695B · Substantial damage
  > The pilot stated that lift-off and climbout were normal but, shortly thereafter, the fuel pilot light began to fail continuously until the burner flamed out. The passengers were briefed and the chase vehicle was contacted by cb radio before the plt climbed up…
- [NTSB MKC83LA228](https://openairdocs.org/ntsb/MKC83LA228.md): Balloon Works Firefly 6 · Fort Madison, IA · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 1983 · N2023F · No damage
  > The Balloon was one of 25 balloons participating in an event. The plts had received a collective briefing from the Balloon master at 0630 who stated that current winds at nearby reporting facilities were 8-10 KTS. The 0600 observation at burlington, IA,…
- [NTSB CHI80DEC18](https://openairdocs.org/ntsb/CHI80DEC18.md): BLN Works FRFY6B · Orchard Lake, MI · Accident · Serious injuries · Closed · Apr 19, 1980 · N4067L · No 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1050101'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1050101&status=final

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