Final NTSB investigations: AiResearch TPE331 series
211 cases on aircraft whose registry engine model is AiResearch TPE331 series. 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, newest first
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.\"completionStatus\" = 'Completed'
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"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.
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."completionStatus" = 'Completed'
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA09CA298Accident · Serious injuriesData collectionFinal reportAyres S2R-G1 · Bald Eagle, PAThe pilot's failure to maintain clearance from a power line.NTSB ERA09FA083Accident · Minor injuriesField investigationFinal reportMitsubishi MU-2B-60 · Millington, TNThe pilot’s improper configuration of the airplane following an engine shutdown, which resulted in a low-altitude, unstabilized approach. Contributing to the accident was a loss of engine power for undetermined reasons.NTSB ANC09LA009Accident · Minor injuriesLimited investigationFinal reportConstrucciones Aeronauticas CASA-212 · Toksook Bay, AKThe flight crew’s inability to adjust/increase power to the right engine during the landing approach due to an in-flight disconnect of the engine power control linkage, resulting in a loss of control of the airplane. Contributing to the accident was the…NTSB SEA08CA183Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164A · Hazelton, IDThe pilot's inadequate compensation for the tailwind and failure to attain and maintain airspeed, which resulted in an inadvertent stall. The tailwind was a contributing factor.NTSB DEN08LA107Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Pine Bluff, ARA total loss of engine power due to fuel starvation as a result of an electrical short in the wiring to the manual fuel switch that closed the fuel valves.NTSB ANC08CA057Accident · No injuriesData collectionFinal reportFairchild Swearingen SA 227-AC · Anchorage, AKThe flightcrew's misjudged flare while landing.NTSB ANC08IA033Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Dutch Harbor, AKThe disengagement of the rudder control cable and loose rudder cable retaining pins. A factor contributing to the accident was a wind gust.NTSB SEA08CA034Accident · No injuriesData collectionFinal reportAyres S2R-G1 · Calexico, CAThe pilot's failure to maintain directional control while landing. A factor in the accident was the close proximity of the drainage ditch to the edge of the private airstrip's runway.NTSB DFW08LA035Accident · No injuriesLimited investigationFinal reportAyres S2-R · Lenora, TXThe loss of engine power due to separation of the "P3" line from the engine's fuel control.NTSB ANC07FA103Accident · 1 fatalField investigationFinal reportShort Bros. SC-7 · McGrath, AKA collision with trees during takeoff-initial climb for an undetermined reason.NTSB ANC07LA095Accident · No injuriesLimited investigationFinal reportShort Bros. SC-7 · McGrath, AKThe pilot's selection of unsuitable terrain for landing and subsequent nose gear collapse during the landing roll. Contributing to the accident was the soft terrain.NTSB CHI07LA207Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Wyoming, ILThe pilot's failure to maintain clearance with the power lines during the aerial application flight. Contributing to the accident were the power lines and the low altitude.NTSB DFW07CA150Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Colorado City, TXThe loss of engine power due to an oil leak. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC07LA032Accident · No injuriesLimited investigationFinal reportBeech D18S · Levelock, AKThe pilot's misjudged flare, which precipitated a hard landing, and damage to the main landing gear, resulting in a main landing gear collapse during the landing roll. A factor contributing to the accident was the overload failure of the main landing gear…NTSB CHI07LA108Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Wheeling, ILPartial failure of the left engine propeller governor during the takeoff ground roll. Factors included that directional control was not possible by the pilot which subsequently led to a collision with an airport sign.NTSB DEN06MA119Accident · 1 fatalMajor investigationFinal reportMitsubishi MU-2B-35 · Argyle, FLthe 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 NYC06MA208Accident · 2 fatalMajor investigationFinal reportMitsubishi MU-2B-40 · Bunnell, FLThe pilot's inadvertent encounter with thunderstorms.NTSB CHI06LA244Accident · Minor injuriesLimited investigationFinal reportFairchild SA227-AC · Grain Valley, MOthe pilot not maintaining clearance from the fence. Contributing factors were the pilot's fatigue and the fence.NTSB ATL06LA119Accident · No injuriesLimited investigationFinal reportAyres S2R · Doerun, GAThe 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 ANC06FAMS1Accident · 3 fatalMissing aircraftFinal reportAero Commander 690A · Anchorage, AKUndetermined; the airplane and its occupants are missing.NTSB MIA06FA120Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Fort Pierce, FLthe 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 DEN06IA056Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Denver, COthe 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.NTSB CHI05CA246Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Davenport, NDThe pilot failed to gain suffient altitude during takeoff in order to clear the corn crop at the end of the runway. A factor associated with the accident was the corn crop.NTSB ANC05LA130Accident · No injuriesLimited investigationFinal reportCessna 441 · Anchorage, AKThe pilot's failure to lower the airplane's landing gear during landing, which resulted in an inadvertent wheels up landing.NTSB DFW05FA202Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Parker, COThe pilot’s failure to fly a stabilized instrument approach at night which resulted in controlled flight into terrain. Contributing factors were; the dark night, low clouds, the inadequate design and function of the airport facility’s Minimum Safe Altitude…NTSB SEA05LA146Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jerome, IDFailure to maintain clearance from terrain during takeoff and initial climb. A high density altitude was a factor.NTSB LAX05TA226Accident · Minor injuriesFinal reportAyres S2R-G10 · Wickenburg, AZthe partial loss of engine power for undetermined reasons.NTSB DFW05CA133Accident · No injuriesData collectionFinal reportGrumman 164-B · Fontaine, ARThe pilot's failure to maintain clearance during a downwind takeoff with a full load of fertilizer. Factor contributing to the accident were the prevailing tailwind and the high density altitude.NTSB LAX05LA151Accident · 1 fatalLimited investigationFinal reportGulfstream 695A · North Las Vegas, NVThe incapacitation of the pilot.NTSB MIA05LA084Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Miami, FL"This case was modified may 30, 2006." The airplane's inadvertent impact with one of several deer that had entered the airport property and crossed the runway during the landing rollout.NTSB CHI05LA071Accident · No injuriesLimited investigationFinal reportTwin Commander Acft. 680V · Fort Wayne, INThe malfunction of the landing gear extension assembly during approach for undetermined reasons.NTSB LAX05CA059Accident · No injuriesData collectionFinal reportCessna 441 · Thermal, CAthe pilot's misjudged speed and distance, which resulted in a failure to attain the proper touchdown point and a subsequent overrun of the runway. A factor in the accident was limited braking effectiveness resulting from the wet runway condition.NTSB DEN05FA034Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · Englewood, COthe 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 IAD05FA023Accident · 6 fatalClass 1 · FieldFinal reportCASA 212-200-CC · Bamiyan, Afghanistanthe 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 SEA05LA014Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Boise, IDThe 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 DCA05MA004Accident · 13 fatalClass 1 · MajorFinal reportBritish Aerospace Jetstream 32 · Kirksville, MOthe 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 DEN04LA112Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Rifle, COthe 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 ANC04FA063Accident · 1 fatalField investigationFinal reportBeech C-45H · Kodiak, AKThe 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 FTW04LA158Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Needville, TXThe loss of engine power and subsequent in-flight fire for undetermined reasons.NTSB CHI04LA096Accident · No injuriesLimited investigationFinal reportSwearingen SA226-T · Omaha, NEThe pilot failed to maintain directional control during takeoff. Contributing factors to the accident were the runway light and the soft terrain.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.NTSB 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…NTSB ATL04FA049Accident · 2 fatalField investigationFinal reportCessna 441 · Vestavia Hills, ALThe pilot's failure to maintain adequate airspeed during climb in icing conditions, which resulted in an inadvertent stall / spin of the airplane and subsequent uncontrolled descent and collision with terrain. A factor was the accumulation of airframe ice.NTSB DEN04FA027Accident · No injuriesField investigationFinal reportSwearingen SA226-TC · Denver, COthe failure of the pilot of the taxiing aircraft to maintain clearance and adequate visual lookout for the stopped aircraft.NTSB SEA04FA023Accident · 1 fatalField investigationFinal reportFairchild Swearingen SA227-AT · Spokane, WAThe pilot-in-command's failure to maintain proper glidepath alignment during an ILS approach in poor weather resulting in collision with trees and terrain. Contributing factors were the unreliable status of the primary (NAV 1) ILS receiver (leaving the pilot…NTSB DEN04LA023Accident · No injuriesLimited investigationFinal reportFairchild Swearingen SA226TC · Grand Junction, COthe operator's improper maintenance and servicing of the airplane's nose landing gear assembly, resulting in the collapse of the nose landing gear during the landing roll. Contributing factors include the nose section of the airplane's subsequent contact with…NTSB DEN04LA020Accident · No injuriesLimited investigationFinal reportFairchild Swearingen SA227BC · Rawlins, WYthe pilot's failure to maintain directional control during the landing roll. Contributing factors include the pilot's improper in-flight planning/decision, the icy, snow covered runway and the snow bank.NTSB CHI03LA278Accident · 1 fatalLimited investigationFinal reportAyres S2R-G6 · Breckenridge, MIThe pilot's failure to maintain clearance from the powerlines during the aerial application pass rendering the airplane uncontrollable. The powerlines were a factor.NTSB ANC03LA062Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-226T · Goodnews, AKThe flight crew's inadequate evaluation of the weather conditions, which resulted in their inadequate compensation for the wind conditions, and subsequent undershoot. A contributing factor in the accident was a downdraft.NTSB FTW03LA159Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Palestine, ARThe shearing of the torsion shaft which resulted in a loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.