# NTSB investigations: Balony Kubicek Spol Sro BB30Z

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 CEN18LA245](https://openairdocs.org/ntsb/CEN18LA245.md): Kubicek BB30 · Ashland, OH · Accident · 1 fatal · Limited investigation · Final report · Jun 30, 2018 · N717FN · Minor damage
  > The pilot's failure to ensure that he was secure in the balloon's basket after landing, which resulted in him falling and striking his head on the burners when the wind caught the envelope and tipped the basket over. Contributing to the accident was the…
- [NTSB GAA15CA157](https://openairdocs.org/ntsb/GAA15CA157.md): Balloon Works FIREFLY8 - 24 · Provo, UT · Accident · Minor injuries · Data collection · Final report · Jul 2, 2015 · N7148P · 2 aircraft · Substantial damage
  > **This report was modified on 4/21/2016. Please see the public docket for this accident for more information.** The failure of the Balony balloon pilot to see and avoid the Balloon Works balloon during an ascent, which resulted in the basket of the Balony…

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

This list as a web page: https://openairdocs.org/ntsb?model=1370501

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