# NTSB investigations: U/A Canada PT6A-27-28: Airframe/component/system failure/malfunction

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 FTW02LA172](https://openairdocs.org/ntsb/FTW02LA172.md): Beech BE-100-A100 · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Jun 5, 2002 · N799DD · Substantial damage
  > The malfunction of the left main landing gear retraction/extension assembly due to a missing lock pin/washer/nut on the clevis of the push/pull gear extension tube that resulted from improper maintenance.
- [NTSB LAX93IA029](https://openairdocs.org/ntsb/LAX93IA029.md): Piper PA-31T-620 · Medford, OR · Incident · No injuries · Incident investigation · Final report · Nov 5, 1992 · N131AF · No damage
  > Fatigue failure of the elevator control tube rod end bearing resulting in a loss of elevator control.
- [NTSB ATL88MA048](https://openairdocs.org/ntsb/ATL88MA048.md): Beech C90 · Beaufort, SC · Accident · 2 fatal · Major investigation · Final report · Nov 30, 1987 · N4463W · Destroyed
  > At 0938, while clbg thru 9000', the plt was clrd to clb to FL 210. Aprx 10 min later, the ATC ctlr noted the acft's mode c rtrn wasn't being displayed on his scope. He tried to adz the plt, but couldn't establish radio contact. The acftbroke up in flt & the…
- [NTSB MIA87LA027](https://openairdocs.org/ntsb/MIA87LA027.md): Beech A100 · Brooksville, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 8, 1986 · N78L · Destroyed
  > The pilot stated that shortly after departure the cockpit filled with smoke. While returning for landing his visibility was reduced due to the smoke and ground fog. On landing roll the the aircraft ran off the left side of the runway, went through a cow fence…

## 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=61504&occurrence=130

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