# Fatal NTSB investigations: Bombardier ROTAX (ALL), 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 CEN11LA050](https://openairdocs.org/ntsb/CEN11LA050.md): Mcfarland Bill Challenger II · Praire Du Sac, WI · Accident · 1 fatal · Limited investigation · Final report · Nov 1, 2010 · N448WM · Substantial damage
  > The separation of the fuselage-mounted wing strut attachment fitting for an undetermined reason, which resulted in the separation of the left wing of the airplane.
- [NTSB CHI07LA238](https://openairdocs.org/ntsb/CHI07LA238.md): Swanson Aventura II · Lakewood, WI · Accident · 1 fatal · Limited investigation · Final report · Jul 28, 2007 · N914JS · Substantial damage
  > The pilot's excessive pull up, his not maintaining airspeed, and the inadvertent stall resulting in the loss of control. A factor contributing to the accident was the trees.
- [NTSB CHI03LA201](https://openairdocs.org/ntsb/CHI03LA201.md): McIlraith Sea Rey · Tomah, WI · Accident · 2 fatal · Limited investigation · Final report · Jul 5, 2003 · N216ST · Destroyed
  > The loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed resulting in a stall/spin during the forced landing.
- [NTSB CHI02LA268](https://openairdocs.org/ntsb/CHI02LA268.md): Rebholz Rans S-10 · Cottage Grove, WI · Accident · 1 fatal · Limited investigation · Final report · Sep 4, 2002 · N92PD · Substantial damage
  > The pilot's decision to turn back to the airport following the loss of engine power during initial climb, the pilot not maintaining airspeed and aircraft control, which resulted in the stall at a low altitude. An additional cause was the seizure of the engine…
- [NTSB CHI88DEP13](https://openairdocs.org/ntsb/CHI88DEP13.md): Heibel AIR Command 532 · Cottage Grove, WI · Accident · 1 fatal · Final report · Sep 21, 1988 · N7015C · Destroyed
  > While in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.…

## 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."highestInjuryLevel" = 'Fatal'
  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&fatal=1&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.
