NTSB investigations: Balloon Works FIREFLY 7, 1987
5 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 | 6 |
|---|---|
| 1979 | 6 |
| 1980 | 10 |
| 1981 | 1 |
| 1982 | 11 |
| 1983 | 9 |
| 1984 | 7 |
| 1985 | 8 |
| 1986 | 6 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 3 |
| 1991 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2007 | 1 |
| 2017 | 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 year(c.\"eventDate\") = 1987
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 year(c."eventDate") = 1987
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 DEN88LA010Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMTwo balloons, a rally and a firefly, collided in flight during the Albuquerque international Balloon fiesta. The pilot of the firely was climbing at approximately 300 feet per minute when his envelope contacted the basket of the rally. The pilot of the rally…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 ATL87LA158Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Kannapolis, NCThe Balloon pilot was executing a landing approach to a clear area. He failed to see and avoid electrical power lines on the near side of the field as he made his approach. The Balloon collided with the power lines and the basket landed hard. The Balloon…NTSB DEN87LA074Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Park City, UTThe Balloon was landing in an open field and struck a rock. One pax had prepared for hard landing and one had elected to continue filming. The photographer was thrown forward out of the basket and the basket passed over him, coming to rest 50 feet away.NTSB DEN87LA054Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Colo. Springs, COThe Balloon attempted a normal landing. The instructor plt diverted his attention while the student plt allowed the envelope to cool excessively. This gave a high rate of descent and the Balloon made a hard landing.