# NTSB investigations: AiResearch TPE331 series, 2006

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 DEN06MA119](https://openairdocs.org/ntsb/DEN06MA119.md): Mitsubishi MU-2B-35 · Argyle, FL · Accident · 1 fatal · Major investigation · Final report · Sep 1, 2006 · N6569L · Destroyed
  > the pilot's inadvertent flight into thunderstorm activity that resulted in the loss of control, design limits of the airplane being exceeded and subsequent in-flight breakup. A contributing factor was the failure of air traffic control to use available radar…
- [NTSB NYC06MA208](https://openairdocs.org/ntsb/NYC06MA208.md): Mitsubishi MU-2B-40 · Bunnell, FL · Accident · 2 fatal · Major investigation · Final report · Aug 25, 2006 · N171MA · Destroyed
  > The pilot's inadvertent encounter with thunderstorms.
- [NTSB CHI06LA244](https://openairdocs.org/ntsb/CHI06LA244.md): Fairchild SA227-AC · Grain Valley, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 2006 · N620PA · Substantial damage
  > the pilot not maintaining clearance from the fence. Contributing factors were the pilot's fatigue and the fence.
- [NTSB ATL06LA119](https://openairdocs.org/ntsb/ATL06LA119.md): Ayres S2R · Doerun, GA · Accident · No injuries · Limited investigation · Final report · Aug 10, 2006 · N61224 · Destroyed
  > The loss of engine power for an underdetermined reason, resulting in a forced landing, an on ground collision with trees, and a post crash fire.
- [NTSB ANC06FAMS1](https://openairdocs.org/ntsb/ANC06FAMS1.md): Aero Commander 690A · Anchorage, AK · Accident · 3 fatal · Missing aircraft · Final report · Jul 29, 2006 · N57096 · Destroyed
  > Undetermined; the airplane and its occupants are missing.
- [NTSB MIA06FA120](https://openairdocs.org/ntsb/MIA06FA120.md): Mitsubishi MU-2B-60 · Fort Pierce, FL · Accident · 1 fatal · Field investigation · Final report · Jun 25, 2006 · N316PR · Destroyed
  > the pilot’s loss of aircraft control during the initial climb which was precipitated by the sudden loss of thrust and increase in drag from the right engine, and the pilot’s failure to adhere to the published emergency procedures regarding the position of the…
- [NTSB DEN06IA056](https://openairdocs.org/ntsb/DEN06IA056.md): Swearingen SA226TC · Denver, CO · Incident · No injuries · Incident investigation · Final report · Apr 5, 2006 · N770S · No damage
  > the failure of the elevator down cable due to an improperly routed cable by unknown maintenance personnel. A contributing factor was the improper inspection of the elevator cable by the operator's maintenance personnel.

## 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") = 2006
  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=2006

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