NTSB investigations: Pratt & Whitney R1340 series
1,656 cases on aircraft whose registry engine model is Pratt & Whitney R1340 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52016'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52016'))
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 CHI03LA095Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Knox, INA loss of engine power due to oil starvation as a result of the failure of the master rod bearing. Contributing factors were the tree line at the edge of the field, and the unsuitable terrain.NTSB FTW03LA084Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Alamo, TXThe pilot's failure to maintain airspeed which resulted in a stall. Low altitude flight is a contributing factor.NTSB ANC03LA021Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Nikolai, AKAn improper and undocumented major repair of the elevator torque tube support assembly by an unknown person, which resulted in an in-flight disconnection of the airplane's right elevator, and a jammed rudder. A factor associated with the accident is the…NTSB DEN03LA016Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Elbert, COoverload failure of the cable between the left rudder pedal and the tail wheel, rendering directional control impossible and resulting in an inadvertent ground loop and nose over. Contributing factors were the crosswind and the soft, wet ground.NTSB FTW02LA256Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Altus, OKthe pilot's failure to maintain clearance with electrical wires while maneuvering during an aerial application flight.NTSB ANC02LA115Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Tenakee Springs, AKThe pilot's misjudgment of the airplane's speed/distance from a dock resulting in the airplane drifting into a wooden piling during a taxi from landing. A factor in the accident was the presence of a tidal current.NTSB FTW02LA245Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hearne, TXThe pilot's failure to maintain clearance with a pump rig while maneuvering during an aerial application flight. A factor was the object.NTSB LAX02LA257Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dos Palos, CAthe failure of the propeller blade due to fatigue. Factors in the accident were the inadequate maintenance-repair of the blade, and, inadequate pilot preflight inspections.NTSB SEA02LA166Accident · No injuriesLimited investigationFinal reportAero Commander S2R Thrush · Connell, WAThe pilot's failure to adequately compensate for wind conditions and his failure to maintain directional control. Factors include rough uneven terrain.NTSB FTW02LA239Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Simmesport, LAthe contamination of the fuel system with water and a foreign material.NTSB CHI02LA238Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Sturgis, MIThe failure of the turbine section of the engine, and the unsuitable terrain encountered for the forced landing. The low altitude was a factor.NTSB ATL02LA153Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Memphis, TNThe pilot's decision to make a precautionary landing to an unsuitable sod airstrip that resulted in a ground loop. A factor was tall vegetation.NTSB LAX02LA246Accident · No injuriesLimited investigationFinal reportAero Commander S2R-T34 · Los Banos, CAThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall.NTSB FTW02LA221Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Roads, LAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin of the airplane.NTSB CHI02LA221Accident · Minor injuriesLimited investigationFinal reportAir Tractor 301 · Ulen, MNThe pilot not performing an aborted takeoff. A factor was the soybean crop.NTSB CHI02CA224Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Malta, ILThe probable cause of this accident was fuel exhaustion, due to a failure to properly compute initial fuel quantity and/or fuel consumption.NTSB CHI02LA206Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401B · Pratt, KSThe pilot's failure to maintain terrain clearance. A factor was low altitude flight.NTSB MIA02LA135Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cochran, GAA loss of power while conducting aerial application to cotton crops due to failure of a magneto housing, and the resultant emergency descent and landing to an unsuitable field, causing the collision with a tree.NTSB SEA02LA123Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Weiser, IDThe fracture of the number 3 cylinder exhaust pushrod resulting in the exhaust valve's inability to open during the exhaust cycle and the subsequent engine stoppage. Contributing factors were the ditch and elevated roadway which the aircraft crossed during…NTSB LAX02LA216Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Sacramento, CAPropeller blade failure due to fatigue. A contributing factor was the rising embankment.NTSB MIA02LA145Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dyer, TNThe failure of the pilot to maintain wingtip clearance with corn crops at the edge of the road resulting in the collision with the crops.NTSB SEA02LA111Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R Thrush · Winifred, MTThe pilot's improper inflight decision to continue his aerial application flight after he realized the aircraft might be low on fuel. Factors include the pilot's failure to maintain clearance from a shed.NTSB LAX02LA203Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Westmorland, CAThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A factor was the dark night condition.NTSB CHI02LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Langdon, NDThe pilot did not maintain directional control while taxiing. A contributing factor was the wind gust condition present at the time of the accident.NTSB FTW02LA152Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hathaway, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI02LA133Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bancroft, WIThe loss of engine power due to contamination of the fuel system from an unknown source and the blocked fuel filter. The rough terrain was a factor.NTSB LAX02LA143Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164C · Olivehurst, CAFuel starvation due to the failure of an engine accessory component. A contributing factor was the rough terrain.NTSB FTW02LA111Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARThe inadequate supervision by the flight instructor of the pilot who was receiving instruction resulting in the excessive application of the brakes during the landing roll resulting in a nose over. A factor was the gusty crosswind conditions.NTSB ATL02FA072Accident · 2 fatalField investigationFinal reportNorth American T-6-AT6D · Gainesville, GAA loss of engine power following a supercharger bearing failure and subsequent collision with the ground while maneuvering for an emergency landing.NTSB FTW02LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Ferriday, LAthe failure of the number three cylinder exhaust rocker arm, resulting in a total loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI02LA095Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164A · Cascade, IAThe pilot's inadequate preflight planning/preparation and his failure to maintain clearance with the wire. A factor associated with the accident was the wire that the airplane contacted.NTSB MIA02WA063Accident · No injuriesForeign investigationGrumman G-73T · Paradise Island, BahamasNTSB LAX02LA034Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401B · Las Vegas, NVthe failure of the AT-401 pilot to maintain clearance with the AT-402 airplane during landing. Contributing factors were the unreliable communication radio in the AT-401, the AT-401 pilot's continued flight with known communication radio problems, and the…NTSB LAX02LA014Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Mesa, AZThe pilot's inadequate compensation for an existing crosswind condition, and failure to maintain directional control on the landing rollout.NTSB FTW02LA020Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Morton, TXThe pilot's loss of control of the airplane during an aerial application maneuver.NTSB ATL02LA007Accident · No injuriesLimited investigationFinal reportNorth American SNJ-6 · Kissimmee, FLSee narrative for ATL02LA007A.NTSB FTW01LA209Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Eagle Lake, TXthe partial loss of engine power for an undetermined reason, which resulted in an in flight collision with trees and terrain.NTSB ANC01LA138Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-3 · Cordova, AKThe loss of engine power during cruise due to the fracture of an engine cylinder exhaust valve.NTSB CHI01LA300Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Atlantic, IAThe loss of engine power for undetermined reasons during the takeoff and initial climb, and the unsuitable terrain encountered during the forced landing. Factors relating to this accident were the corn crop and the low altitude.NTSB ATL01LA100Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bentonia, MSThe loss of engine power due to the loss of throttle cable continunity. The throttle cable linkage was worn beyond servicable limits. A factor was uneven terrain at the emergency landing site.NTSB ATL01LA099Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Batesville, MSThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for an emergency landing.NTSB FTW01LA184Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fabens, TXthe pilot's inadequate preflight resulting in loss of engine power due to fuel exhaustion. A contributing factor was the power line.NTSB CHI01LA286Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Petersburg, NEThe failure of the engine cylinder, and the unsuitable terrain for landing encountered by the pilot. Factors were the low altitude and the muddy field.NTSB FTW01LA178Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Grand Coteau, LAthe loss of engine power while maneuvering, which resulted from a fractured #4 cylinder head at the exhaust valve rocker arm boss. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA01LA146Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Latah, WAthe failure of a cylinder head exhaust rocker shaft boss while the aircraft was performing aerial application. Factors include soft terrain and a drop-off in the field where the emergency landing took place.NTSB MIA01LA204Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Edison, GAPartial loss of engine power for undetermined reasons during takeoff resulting in the airplane descending, colliding with the ground, and nosing over.NTSB CHI01LA251Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Pierre, SDclearance not obtained by the pilot. A contributing factor was the transmission line.NTSB CHI01IA246Incident · No injuriesIncident investigationFinal reportAir Tractor AT-401 · Kenesaw, NEThe propeller blade fatigue leading to its tip separating during an aerial application. Factors were no suitable terrain for an emergency landing, high vegetation, and soft terrain encountered during the emergency landing.NTSB CHI01LA242Accident · No injuriesLimited investigationFinal reportAg-Cat G-164B · Wallace, NEThe inadequate preflight planning by the pilot, the pilot initiating the flight with an inadequate fuel supply, and the unsuitable terrain encountered during the forced landing. Factors were the fuel exhaustion, the low altitude and the soft field.NTSB CHI01LA229Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge Center, MNThe pilot not maintaining directional control on the ground during the takeoff roll. Factors relating to this accident were the total failure of the propeller governor and the corn crop.