# NTSB investigations: Rotax SEE BOMBADIER, GA

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 ERA23LA279](https://openairdocs.org/ntsb/ERA23LA279.md): Edmisten Robert Eugene SR Rans S-14 Airaile · Bonaire, GA · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 25, 2023 · N528RE · Substantial damage
  > The pilot’s failure to properly adjust the propeller’s pitch angle, which resulted in a loss of thrust and an inability to maintain altitude.
- [NTSB ERA13CA250](https://openairdocs.org/ntsb/ERA13CA250.md): Thomas David W Rans S-12 XL · Cleveland, GA · Accident · Minor injuries · Data collection · Final report · May 18, 2013 · N81788 · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of overall recent flight experience and lack of experience in make and model.
- [NTSB NYC08LA235](https://openairdocs.org/ntsb/NYC08LA235.md): Lanier James A Talon XP · Cleveland, GA · Accident · 1 fatal · Limited investigation · Final report · Jul 2, 2008 · N1974L · Destroyed
  > An inadvertent stall during the initial climb.
- [NTSB ATL88DKG05](https://openairdocs.org/ntsb/ATL88DKG05.md): American Falcon XP · Palmetto, GA · Accident · No injuries · Final report · Oct 11, 1987 · N377AA · Substantial damage
  > The pilot failed to properly flare the aircraft during a normal landing which resulted in a hard landing. The nose gear assembly failed from overload, and the pilot was not able to control the aircraft as it slid over the ground. The aircraft collided with a…

## 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" = 'GA' 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=GA

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