Fatal NTSB investigations: AiResearch TPE331 series

6 cases on aircraft whose registry engine model is AiResearch TPE331 series, where the first occurrence was “Loss of control - in flight”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19842026
Fatal NTSB investigations: AiResearch TPE331 series per year, 1984–2026: 6 cases
19841
19871
19971
20011
20042

Latest cases

Query with SQL
duckdb -csv -c "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.\"highestInjuryLevel\" = 'Fatal'
    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')
      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\" = 250))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB LAX04FA165Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · Napa, CAThe 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.Mar 12, 2004 · N966MA · DestroyedNTSB DEN04FA035Accident · 1 fatalField investigationFinal reportRockwell 690A · Cortez, COthe 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…Jan 3, 2004 · N700SR · DestroyedNTSB DEN01FA113Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-20 · Cerrillos, NMthe pilot's loss of aircraft control inflight for reasons undetermined. Contributing factors were the pilot's inadequate transition/upgrade training and his total lack of experience in aircraft make/model.Jun 10, 2001 · N187AF · DestroyedNTSB SEA98FA023Accident · 2 fatalField investigationFinal reportAero Commander 690A · Yakima, WAA loss of aircraft control for undetermined reasons.Dec 13, 1997 · N72VF · DestroyedNTSB DCA87MA030Accident · 2 fatalMajor investigationFinal reportCASA C-212-CC · Mayaguez, PRAfter several maintenance adjustments of the right propeller and flight idle fuel flow, the aircraft was test flown and released for flight. Several pilots continued to note descrepancies concerning the right propeller system. Adjustments were made and the…May 8, 1987 · N432CA · DestroyedNTSB DCA84AA015Accident · 3 fatalFinal reportSwearingen SA226TC · Terre Haute, INAfter taking off from rwy 23, the acft crashed ssw of the arpt about 6300 ft from the departure end of the rwy & about 1800 ft to the left of the rwy centerline. Impact occurred while the acft was in a steep descent. The wreckage path was scattered along a…Jan 30, 1984 · N63Z · Destroyed