# NTSB investigations: Bombardier ROTAX (ALL): Sys/Comp malf/fail (non-power)

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 CEN13LA524](https://openairdocs.org/ntsb/CEN13LA524.md): Stemme S10-VT · Mackinaw City, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 2013 · N389BD · Substantial damage
  > The mechanic’s failure to inspect the tightness of the bolts that connected the flexible disk to the driveshaft, which resulted in the failure of these components.
- [NTSB CEN12CA567](https://openairdocs.org/ntsb/CEN12CA567.md): Fantasy Air Allegro 2000 · Bear Creek, WI · Accident · No injuries · Data collection · Final report · Aug 17, 2012 · N5064E · Substantial damage
  > A malfunction of the right brake for reasons that could not be determined because of the perishable evidence, which resulted in the pilot’s inability to maintain directional control of the airplane during landing.
- [NTSB CEN12LA531](https://openairdocs.org/ntsb/CEN12LA531.md): Ristine Avid Mark IV · Poplar Grove, IL · Accident · No injuries · Limited investigation · Final report · Aug 9, 2012 · N1328L · Substantial damage
  > The failure of the lower right side longeron tail-spring support area during landing due to excessive corrosion.
- [NTSB WPR11CA358](https://openairdocs.org/ntsb/WPR11CA358.md): Mcdonald Lynn B Avid Flyer Mark IV · Yamhill, OR · Accident · No injuries · Data collection · Final report · Jul 31, 2011 · N30456 · Substantial damage
  > The pilot’s loss of directional control during landing rollout due to an unlocked tail wheel that was caused by a degradation of the tailwheel assembly mounting angle.
- [NTSB ERA11LA150](https://openairdocs.org/ntsb/ERA11LA150.md): Flaglor Tom Kolb Aircraft MK III · Stetson, ME · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 2011 · N213 · Substantial damage
  > The in-flight failure of the No. 1 composite propeller blade due to fatigue, which resulted in a violent vibration, loss of engine power, and a subsequent forced landing to unsuitable terrain.
- [NTSB CEN11CA143](https://openairdocs.org/ntsb/CEN11CA143.md): Rardin William I Kitfox III · Carlisle, AR · Accident · No injuries · Data collection · Final report · Jan 2, 2011 · N876KF · Substantial damage
  > Failure of the left main landing gear strut due to a pre-existing crack in the weld joint.
- [NTSB CHI08CA105](https://openairdocs.org/ntsb/CHI08CA105.md): Schultz Mini 500 · Batavia, OH · Accident · No injuries · Data collection · Final report · Apr 6, 2008 · N62GS · Substantial damage
  > The failure of the helicopter's centrifugal clutch during hover which led to the pilot's inability to maintain control of the craft and its subsequent impact with the ground.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('09050')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '330'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/330/cases?engine=09050

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