NTSB investigations: Avian Balloon SKYHAWK
6 cases on aircraft the registry lists as Avian Balloon SKYHAWK. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2023 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0900104'))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0900104'))
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 ERA23LA377Accident · Serious injuriesClass 4 · LimitedFinal reportAvian Balloon Skyhawk · Bucyrus, OHThe balloon pilot’s bounced landing, which resulted in the basket tipping over and a serious injury to a passenger.NTSB NYC03LA013Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Cottageville, WVThe pilot's improper decision not to over fly the landing area, which resulted in an in-flight collision with power lines.NTSB FTW97LA011Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Albuquerque, NMThe ground crew member's failure keep clear from the gondola during take off. A factor was the pilot's failure to insure crew coordination during take off.NTSB SEA86LA147Accident · No injuriesLimited investigationFinal reportAvian Skyhawk · Yakima, WAA forced landing was made due to fuel starvation. During the forced landing the balloon struck power lines, severing the basket from the envelope. Sparks from the wire strike caused a small brush fire. Post accident exam revealed the plt inadvertently…NTSB CHI84LA388Accident · No injuriesLimited investigationFinal reportAvian Balloon AX8 · Canton, OHPlt and passenger (student balloon pilot) elected a precautionary landing in an open field rather than overfly densely populated area and power lines, on touchdown, wind lifted balloon slightly and caused drift. As student plt was operating envelope vent, she…NTSB DEN82FTE18Accident · Serious injuriesFinal reportAvian Balloon Skyhawk · Longmont, COThe pilot tookoff in the balloon with three passengers on a sight-seeing flight. The wind was from 200 degrees at 5 gusting 7 knots. A large field was selected for landing. While using a high wind landing procedure, the gondola tipped over during touchdown.…