# NTSB investigations: AiResearch TPE331 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 CEN22FA032](https://openairdocs.org/ntsb/CEN22FA032.md): Beech E-90 · Boyne City, MI · Accident · 2 fatal · Class 3 · Field · Final report · Nov 15, 2021 · N290KA · Destroyed
  > The pilot’s failure to maintain sufficient airspeed and his exceedance of the airplane’s critical angle of attack while in icing conditions, which resulted in an aerodynamic stall and subsequent ground impact.
- [NTSB CEN21LA296](https://openairdocs.org/ntsb/CEN21LA296.md): Grumman Acft ENG Cor-Schweizer G-164B · Hoxie, AR · Accident · No injuries · Class 4 · Limited · Final report · Jun 29, 2021 · N6611K · Substantial damage
  > The pilot’s failure to ensure an adequate fuel supply for the intended flight.
- [NTSB CEN21LA287](https://openairdocs.org/ntsb/CEN21LA287.md): Grumman G164 · Sedgwick, AR · Accident · No injuries · Class 3 · Limited · Final report · Jun 20, 2021 · N62375 · Substantial damage
  > The total loss of engine power due to the failure and disengagement of the torque sensor assembly front spur gear from its splined shouldered shaft due to a loose self-locking nut.
- [NTSB CEN21FA215](https://openairdocs.org/ntsb/CEN21FA215.md): Swearingen SA226TC · Englewood, CO · Accident · No injuries · Class 3 · Field · Final report · May 12, 2021 · N280KL · 2 aircraft · Substantial damage
  > The Cirrus pilot’s failure to maintain the final approach course for the assigned runway, which resulted in a collision with the Swearingen which was on final approach to the parallel runway. Contributing to the accident was the failure of the controller to…
- [NTSB ERA21LA124](https://openairdocs.org/ntsb/ERA21LA124.md): Cessna 441 · Belvidere, TN · Accident · 2 fatal · Class 3 · Limited · Final report · Feb 7, 2021 · N44776 · Destroyed
  > The pilot’s failure to follow the published instrument approach procedure by prematurely descending the airplane below the final approach fix altitude to fly under the low ceiling conditions, which resulted in controlled flight into 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 ('01514', '01517'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=01514&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.