# NTSB investigations: U/A Canada PT6A-27-28: Loss of control in flight

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 CEN23LA028](https://openairdocs.org/ntsb/CEN23LA028.md): Beech E-90 · Slidell, LA · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 7, 2022 · N809DM · Destroyed
  > The pilot’s failure to maintain airplane control during an attempted go-around in low visibility conditions.
- [NTSB ERA23FA024](https://openairdocs.org/ntsb/ERA23FA024.md): Beech E-90 · Marietta, OH · Accident · 2 fatal · Class 3 · Field · Final report · Oct 18, 2022 · N515GK · Substantial damage
  > Structural icing on the tailplane that resulted in a tailplane stall and subsequent loss of control.
- [NTSB CEN20MA044](https://openairdocs.org/ntsb/CEN20MA044.md): Piper PA 31T · Lafayette, LA · Accident · 5 fatal · Class 2 · Major · Final report · Dec 28, 2019 · N42CV · Destroyed
  > The pilot’s loss of airplane control due to spatial disorientation during the initial climb in instrument meteorological conditions.
- [NTSB CEN13FA105](https://openairdocs.org/ntsb/CEN13FA105.md): Beech E-90 · Amarillo, TX · Accident · 2 fatal · Field investigation · Final report · Dec 15, 2012 · N67PS · Substantial damage
  > The pilot’s loss of control of the airplane after encountering icing conditions and heavy to extreme turbulence and the subsequent exceedance of the airplane’s design limit, which led to an in-flight breakup.

## 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 ('61504')
    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" = '240'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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