# NTSB investigations: Rotax SEE BOMBADIER, NY

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 GAA17CA567](https://openairdocs.org/ntsb/GAA17CA567.md): Chancey Gerry M RV-12 · Dunkirk, NY · Accident · No injuries · Data collection · Final report · Sep 6, 2017 · N1214J · Substantial damage
  > The pilot's failure to maintain lateral/bank control during takeoff in crosswind conditions.
- [NTSB ERA11LA473](https://openairdocs.org/ntsb/ERA11LA473.md): Woolston Glenn E Zenith 701 Stol · Carlton, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 2011 · N246CV · Substantial damage
  > The pilot’s lack of recognition that the engine was being supplied fuel from only the right tank with the fuel selector in the both position, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the…
- [NTSB NYC05CA115](https://openairdocs.org/ntsb/NYC05CA115.md): Wagner Kitfox II · Albion, NY · Accident · Minor injuries · Data collection · Final report · Jul 6, 2005 · N16AF · Substantial damage
  > The pilot's loss of airplane control after inadvertently taking off while conducting high-speed taxi runs. A factor related to the accident was the pilot's lack of experience in the airplane.
- [NTSB IAD02LA030](https://openairdocs.org/ntsb/IAD02LA030.md): Korsch Classic IV · East Moriches, NY · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 2002 · N767PG · Substantial damage
  > The pilot's improper recovery from a bounced landing, which resulted in a loss of directional control. A contributing factor was the pilot's lack of experience in aircraft type.

## 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."eventStateOrRegion" = 'NY' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55555'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=55555&state=NY

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