# NTSB investigations: Rotax SEE BOMBADIER, WI

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 CEN19FA276](https://openairdocs.org/ntsb/CEN19FA276.md): Shirley Carl Sportcopter Vortex · Viroqua, WI · Accident · 1 fatal · Class 2 · Field · Final report · Aug 19, 2019 · N634SC · Destroyed
  > The noncertificated pilot's loss of control of the gyrocopter after a total loss of engine power due to seizure of the crankshaft bearings. Contributing to the accident were the insufficient maintenance of the engine and the pilot's lack of gyrocopter flight…
- [NTSB CHI08LA288](https://openairdocs.org/ntsb/CHI08LA288.md): Fantasy Air Sro Allegro 20 · Walworth, WI · Accident · No injuries · Limited investigation · Final report · Aug 31, 2008 · N1005W · Substantial damage
  > The pilot's failure to maintain directional control during landing.
- [NTSB CHI06FA196](https://openairdocs.org/ntsb/CHI06FA196.md): Shaw Europa XS · Oshkosh, WI · Accident · 2 fatal · Field investigation · Final report · Jul 23, 2006 · N229WC · Substantial damage
  > The pilot's failure to maintain adequate airspeed on final approach which resulted in a stall.
- [NTSB CHI06CA142](https://openairdocs.org/ntsb/CHI06CA142.md): Stys T-Bird Sport · West Bend, WI · Accident · No injuries · Data collection · Final report · May 30, 2006 · N391T · Substantial damage
  > The loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed which resulted in a stall.
- [NTSB CHI03LA256](https://openairdocs.org/ntsb/CHI03LA256.md): Nicoson Antares MA-33 · Palmyra, WI · Accident · No injuries · Limited investigation · Final report · Aug 10, 2003 · N246AN · Destroyed
  > The loss of engine power for undetermined reasons and the pilot misjudging the descent rate during the forced landing, which resulted in the airplane landing short of the desired landing area. A factor to the accident was the fence.

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

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