# NTSB investigations: AiResearch TPE331 series, 2004

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 DEN05FA034](https://openairdocs.org/ntsb/DEN05FA034.md): Mitsubishi MU-2B-60 · Englewood, CO · Accident · 2 fatal · Field investigation · Final report · Dec 11, 2004 · N538EA · Destroyed
  > the pilot's failure to maintain minimum controllable airspeed during the night visual approach resulting in a loss of control and uncontrolled descent into terrain. A contributing factor was the precautionary shutdown of the left engine for undetermined…
- [NTSB IAD05FA023](https://openairdocs.org/ntsb/IAD05FA023.md): CASA 212-200-CC · Bamiyan, Afghanistan · Accident · 6 fatal · Class 1 · Field · Final report · Nov 27, 2004 · N960BW · Destroyed
  > the captain's inappropriate decision to fly a nonstandard route and his failure to maintain adequate terrain clearance, which resulted in the inflight collision with mountainous terrain. Factors were the operator's failure to require its flight crews to file…
- [NTSB SEA05LA014](https://openairdocs.org/ntsb/SEA05LA014.md): Swearingen SA226TC · Boise, ID · Accident · No injuries · Limited investigation · Final report · Nov 9, 2004 · N162WA · Substantial damage
  > The pilot's failure to maintain the required glidepath, and his failure to maintain obstacle clearance after visual contact with the runway during the instrument approach.
- [NTSB DCA05MA004](https://openairdocs.org/ntsb/DCA05MA004.md): British Aerospace Jetstream 32 · Kirksville, MO · Accident · 13 fatal · Class 1 · Major · Final report · Oct 20, 2004 · N875JX · Destroyed
  > the pilots' failure to follow established procedures and properly conduct a nonprecision instrument approach at night in IMC, including their descent below the minimum descent altitude (MDA) before required visual cues were available (which continued…
- [NTSB DEN04LA112](https://openairdocs.org/ntsb/DEN04LA112.md): Swearingen SA-226T · Rifle, CO · Accident · No injuries · Limited investigation · Final report · Jul 21, 2004 · N84GA · Substantial damage
  > the pilot's failure to maintain aircraft control during the aborted takeoff resulting in the airplane departing the runway and striking a runway light and two taxiway signs. Factors contributing to the accident were the broken sensor wire to the left engine's…
- [NTSB ANC04FA063](https://openairdocs.org/ntsb/ANC04FA063.md): Beech C-45H · Kodiak, AK · Accident · 1 fatal · Field investigation · Final report · Jun 14, 2004 · N401CK · Destroyed
  > The pilot's failure to follow proper IFR procedures by not adhering to the published missed approach procedures, which resulted in an in-flight collision with tree-covered terrain. Factors contributing to the accident were a low ceiling, fog, rain, and the…
- [NTSB FTW04LA158](https://openairdocs.org/ntsb/FTW04LA158.md): Rockwell International S-2R · Needville, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 10, 2004 · N4968X · Substantial damage
  > The loss of engine power and subsequent in-flight fire for undetermined reasons.
- [NTSB CHI04LA096](https://openairdocs.org/ntsb/CHI04LA096.md): Swearingen SA226-T · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Mar 31, 2004 · N636SP · Substantial damage
  > The pilot failed to maintain directional control during takeoff. Contributing factors to the accident were the runway light and the soft terrain.
- [NTSB LAX04FA165](https://openairdocs.org/ntsb/LAX04FA165.md): Mitsubishi MU-2B-40 · Napa, CA · Accident · 2 fatal · Field investigation · Final report · Mar 12, 2004 · N966MA · Destroyed
  > The pilot's failure to maintain control of the airplane following a shutdown of the left engine during a night visual approach. A factor contributing to the accident was the dark night.
- [NTSB DEN04FA035](https://openairdocs.org/ntsb/DEN04FA035.md): Rockwell 690A · Cortez, CO · Accident · 1 fatal · Field investigation · Final report · Jan 3, 2004 · N700SR · Destroyed
  > the pilot's inadequate planned approach and his failure to maintain airspeed which resulted in a stall. Contributing factors were low altitude flight maneuvering in an attempt to lose excessive altitude and realign the airplane for landing, and his failure to…

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

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