# NTSB investigations: Rotax 912S series, 2021

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 CEN21LA471](https://openairdocs.org/ntsb/CEN21LA471.md): Just Highlander · West Cobb, AR · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 29, 2021 · N419SD · Substantial damage
  > The airplane’s encounter with gusting wind conditions and low-level wind shear on final approach, which resulted in a loss of control, an aerodynamic stall, and a subsequent hard landing.
- [NTSB ERA21LA247](https://openairdocs.org/ntsb/ERA21LA247.md): Garrison Ronald L Zodiac 601 XL · Cumberland, MD · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 8, 2021 · N315SV · Substantial damage
  > An inadvertent release of the canopy, which allowing the canopy to open during flight and led to an inflight loss of airplane control. Contributing to the accident was the lack of any safeguard to prevent the inadvertent opening of the canopy.
- [NTSB WPR21LA202](https://openairdocs.org/ntsb/WPR21LA202.md): Goodsell Lynn A Classic 4 · Richmond, UT · Accident · No injuries · Class 4 · Limited · Final report · May 18, 2021 · N549Z · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines while maneuvering for landing, which resulted in a wire strike and impact with terrain.

## 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") = 2021
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55570'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=55570&year=2021

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