# NTSB investigations: Rotax SEE BOMBADIER, 2009

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 ERA09FA524](https://openairdocs.org/ntsb/ERA09FA524.md): Curtis John P SEA REY · Winter Haven, FL · Accident · Serious injuries · Field investigation · Final report · Sep 17, 2009 · N563JL · Substantial damage
  > The flightcrew's failure to maintain adequate airspeed while maneuvering during a simulated engine failure, resulting in an aerodynamic stall and uncontrolled descent.
- [NTSB WPR09LA427](https://openairdocs.org/ntsb/WPR09LA427.md): Stone Kitfox Series 6 · May, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 2009 · N2070A · Substantial damage
  > The pilot's failure to maintain clearance from obstacles during the takeoff initial climb.
- [NTSB ANC09FA062](https://openairdocs.org/ntsb/ANC09FA062.md): Zenair Stol CH 701 · Wasilla, AK · Accident · 2 fatal · Field investigation · Final report · Jul 14, 2009 · N701BX · Destroyed
  > The pilot's failure to maintain sufficient airspeed to avoid an aerodynamic stall during takeoff and his decision to fly the airplane over its allowable gross weight. Contributing to the accident was the airplane's excessive gross weight.
- [NTSB CEN09LA345](https://openairdocs.org/ntsb/CEN09LA345.md): Curtiss Moses Aerolite · Los Lunas, NM · Accident · Serious injuries · Limited investigation · Final report · Jun 9, 2009 · N43598 · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement.
- [NTSB ERA09CA254](https://openairdocs.org/ntsb/ERA09CA254.md): American Longevity Searey · Littleton, NC · Accident · Minor injuries · Data collection · Final report · Apr 19, 2009 · N915TR · Substantial damage
  > The pilot's failure to ensure the landing gear was properly configured for the water landing.
- [NTSB ERA09CA255](https://openairdocs.org/ntsb/ERA09CA255.md): Martin Edward H Fire Star II · Church Hill, TN · Accident · Serious injuries · Data collection · Final report · Apr 18, 2009 · N582EF · Substantial damage
  > The pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during final approach.

## 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 year(c."eventDate") = 2009
  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&year=2009

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