# NTSB investigations: Bombardier ROTAX (ALL), OK

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 CEN12CA329](https://openairdocs.org/ntsb/CEN12CA329.md): Brumbaugh B/Kasowski L Avid Flyer IV · Pryor, OK · Accident · No injuries · Data collection · Final report · May 29, 2012 · N85AY · Substantial damage
  > The pilot's failure to maintain directional control during a high speed taxi.
- [NTSB CEN12LA307](https://openairdocs.org/ntsb/CEN12LA307.md): Dial David L Titan Tornado II · Checotah, OK · Accident · 1 fatal · Limited investigation · Final report · May 19, 2012 · N158TX · Substantial damage
  > The noncertificated pilot's loss of airplane control while maneuvering during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s ostentatious display.
- [NTSB FTW02LA134](https://openairdocs.org/ntsb/FTW02LA134.md): Robinson Tierra II · Hooker, OK · Accident · 1 fatal · Limited investigation · Final report · May 1, 2002 · N3960D · Destroyed
  > the loss of control for an undetermined reason, which resulted in an in-flight collision with terrain.
- [NTSB FTW00LA222](https://openairdocs.org/ntsb/FTW00LA222.md): Romero SEA REY · Tulsa, OK · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2000 · N817R · Substantial damage
  > The loss of control by the pilot due to incapacitation for unknown reasons.
- [NTSB FTW83LA182](https://openairdocs.org/ntsb/FTW83LA182.md): Rotec Rally 3B · Edmond, OK · Accident · No injuries · Limited investigation · Final report · Apr 10, 1983 · N65RE · Substantial damage
  > The plt of the registered, 2 place, ultralight acft reported that the winds were variable & he was intending to land into the wind. However, he further stated that he believed the wind had switched to a tail wind before the landing. After landing, he realized…

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

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

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