NTSB investigations: Pratt & Whitney R1340 series, TX
185 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND 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 FTW99LA239Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hart, TXThe pilot's failure to maintain clearance with power lines.NTSB FTW99LA163Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Mckinney, TXThe pilot's failure to maintain directional control on landing. Contributing factors were the elevator control restriction, the pilot's inadequate preflight, the ditch, and gusty conditions.NTSB FTW99LA157Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Monaville, TXThe pilot's failure to touch down on the dry area of the landing strip. A factor was the soft terrain condition on the sides of the grass strip.NTSB FTW99LA134Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G164-B · Garwood, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A related factor was the high density altitude.NTSB FTW98LA304Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plainview, TXThe pilot's failure to maintain obstacle clearance during the aerial application flight. A factor was the transmission wire.NTSB FTW98LA257Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Hondo, TXThe inadvertent stall due to the pilot's failure to maintain control of the airplane. Factors were the high winds and the wind induced turbulence.NTSB FTW98LA004Accident · No injuriesLimited investigationFinal reportNorth American Harvard MK IV · Midland, TXthe failure of the pilots of both airplanes to maintain clearance from each other. A factor was their failure to follow procedures/directives.NTSB FTW97LA336Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Muleshoe, TXfailure of the pilot to see the standpipe in time to avoid an accident (inadequate visual lookout), and his failure to maintain clearance with electrical wires, while maneuvering during an aerial application flight.NTSB FTW97LA242Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edna, TXfailure of the pilot to maintain clearance from a guy wire, during a swath run.NTSB FTW97LA137Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Dilley, TXfailure of the pilot to maintain adequate airspeed, while maneuvering over high transmission line(s), which resulted in a stall/mush and collision with the terrain. The unfavorable weather condition (with turbulence) and the obstruction (high transmission…NTSB FTW96LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Meadow, TXThe pilot's failure to maintain clearance from the transmission wire. A factor was the lack of suitable terrain for a forced landing.NTSB FTW96LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Brownfield, TXThe pilot's failure to maintain directional control during landing roll. A factor was the crosswind.NTSB FTW96LA341Accident · No injuriesLimited investigationFinal reportAyres S-2R · Wharton, TXtotal loss of engine power due to a fractured torque sensor shaft. Factors relating to the accident were: the obstructions (fence and trees) in the emergency landing area.NTSB FTW95LA362Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dalhart, TXthe pilot's failure to maintain control of the airplane during takeoff.NTSB FTW95LA322Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Edna, TXThe collapsing of the landing gear for undetermined reasons.NTSB FTW95LA233Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Collegeport, TXThe pilot's improper planning/decision by attempting to takeoff in an overweight condition from an 1,800 foot runway. Factors were the wet and soft condition of the runway.NTSB FTW95LA028Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's failure to maintain clearance with the irrigation equipment. A factor was pilot fatigue.NTSB FTW94LA271Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Clint, TXThe power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA145Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · El Campo, TXThe partial loss of engine power due to one magneto being weak and the other magneto arcing inside its case. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA122Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Mount Bellvue, TXThe pilot's failure to maintain directional control. Factors were the soft runway and gusty winds.NTSB FTW93LA239Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Garwood, TXThe partial power loss for undetermined reasons. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB FTW93LA173Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Ganado, TXThe pilot's failure to maintain clearance with the power linesNTSB FTW93LA075Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Fort Worth, TXThe pilot's failure to compensate for the crosswind. A factor was the crosswind.NTSB FTW92DRA03Accident · No injuriesFinal reportSchweizer G-164B · Bay City, TXThe pilot's inability to initiate a climb due to exceeding the takeoff capability of the airplane. A factor was the high grass on the airstrip.NTSB FTW92LA131Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot of the other airplane delayed compensation for turbulence. A factor was the turbulence.NTSB FTW92LA094Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe loss of engine power due to rocker arm failure. A factor was the unsuitable terrain.NTSB FTW92LA085Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Valley Mills, TXPower loss due inadequate maintenance and the resultant multiple maintenance discrepancies. A factor was the wet terrain.NTSB FTW91DRG03Accident · Serious injuriesFinal reportGrumman G-164A · Weslaco, TXFailure of the pilot to maintain clearance.NTSB FTW90DRA09Accident · No injuriesFinal reportGrumman G-164A · Altair, TXThe pilot's use of improper terrain for takeoff.NTSB FTW90DRG04Accident · No injuriesFinal reportAir Tractor AT-301 · Mission, TXThe pilot's failure to maintain proper clearance above the crops he was spraying. A factor was the tree induced mechanical turbulence encountered during the descending turn.NTSB FTW90DPA07Accident · No injuriesFinal reportAyres S2R · Mcgregor, TXThe fuel exhaustion induced power loss, which resulted from the pilot's inaccurate fuel consumption calculations.NTSB FTW90DRA05Accident · No injuriesFinal reportGrumman 164-B · Garwood, TXThe power loss due to super charger impeller failure.NTSB FTW90DRA04Accident · No injuriesFinal reportGrumman 164A · Garwood, TXFailure of the number 8 cylinder.NTSB FTW89DQG05Accident · No injuriesFinal reportSchweizer G-164A · Sunray, TXA total power loss for undetermined reasons. A factor was the rough uneven terrain in which the pilot had to make the forced landing.NTSB FTW89DRG04Accident · No injuriesFinal reportSchweizer G-164B · Austwell, TXPilot's selection of an unsuitable landing area (terrain). High vegetation and rough terrain were contributing factors.NTSB FTW89DRG08Accident · No injuriesFinal reportAir Tractor AT-301 · Rio Hondo, TXImproper compensation for wind conditions by the pilot. Factors related to the accident were the adverse wind conditions.NTSB FTW89DRG05Accident · No injuriesFinal reportGrumman-Schweizer G-164 · Edcouch, TXLoss of engine power for an undetermined reason. The corn crop was a contributing factor.NTSB FTW88DRA07Accident · No injuriesFinal reportGrumman G-164B · Lissie, TXAcft experienced an eng failure shortly after t/o from a pvt strip. Acft had been recently refueled at the strip. On touchdown, the acft flipped over and slid to a stop. Investigation revealed water in the acft fuel tank and in the fuel supply tank.NTSB FTW88DRA08Accident · No injuriesFinal reportGrumman G-164 · Palacios, TXThe plt stated that following a normal landing, he applied too much brake, causing the wheels to lock up. This, in turn, caused dead grass and mud to accumulate in front of the wheels. The acft subsequently flipped over and slid to a stop inverted.NTSB FTW88DRG07Accident · No injuriesFinal reportGrumman G-164A · Alamo, TXThe pilot experienced a total loss of engine power during climb when he made his initial power reduction. The power loss was accompanied by a loud bang. A severe postaccident ground fire melted a large portion of the engine. A partial engine teardown was…NTSB FTW88DRG05Accident · No injuriesFinal reportAir Tractor 301 · Circleville, TXThe airplane was being ferried to a new location, and an en route refueling stop was planned. A low ceiling and low visibility set in and the pilot tried to extend the flight to a different town. The fuel was exhausted 6 miles short of a town. The airplane…NTSB FTW87DRG05Accident · No injuriesFinal reportAero Commander S2R · La Joya, TXDuring an aerial application flight at a low altitude the aircraft's engine failed. A forced landing was made to a grassfield resulting in substantial damage to the aircraft. Disassembly of the engine revealed partial failure of the left magneto. The aircraft…NTSB FTW87DPA01Accident · Serious injuriesFinal reportNorth American SNJ-5 · Mckinney, TXThe pilot reportedly made a normal touchdown in a calm wind condition. During the landing rollout,however, he applied excessive braking. This caused the tail wheel equipped aircraft to nose over into an inverted attitude.NTSB FTW86LRG23Accident · No injuriesFinal reportNorth American Rockwell S2-R · Mercedes, TXThe acft experienced a complete loss of eng power at an alt of 200 ft AGL shortly after takeoff. The plt was forced to land against the rows in a muddy cotton field. Shortly after touchdown, the acft flipped over. The exact nature of the eng failure was not…NTSB FTW86FRG20Accident · No injuriesFinal reportAir Tractor AT301 · Taylor, TXCommercial pilot of an Air Tractor AT301 enroute to base of operations at Taylor, TX executed a forced landing after experiencing severe vibration in the aircraft. Landing was made to a soft field. The aircraft nosed over during landing roll and was…NTSB FTW85LRA04Accident · Minor injuriesFinal reportRockwell S2R-600 · Rosharon, TXThe plt reported the acft contacted the ground after the left boom caught weeds during a spray run.NTSB FTW85LA294Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Port Isabel, TXThe acft was substantially damaged when it undershot the runway and cartwheeled during an emergency landing following an engine failure in the traffic pattern. The plt reported that initial examination of the engine revealed that initial examination of the…NTSB FTW85LRA02Accident · Serious injuriesFinal reportAir Tractor AT301 · Anahuac, TXThe acft collided with the ground after the engine reportedly lost power for an undetermined reason. Due to the low altitude while applying fertilizer the acft had to be landed in the path of flt.NTSB FTW85LA039Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Mission, TXAfter a loss of oil pressure the acft was landed downwind. During the precautionary landing across plowed furrows, the rt wing caught in the sugar cane crop and the acft turned to the rt, collapsing the left landing gear and damaging the left wing. The plts…NTSB FTW85LA017Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Seminole, TXThe plt reported that while on a local flt the engine 'blew up' & he made an emergency landing. He stated that the windshield was covered with oil & he could not see to flare the acft & landed hard. Inspection revealed a failure of the #4 rod at the master…