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 LAX90LA004Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pacoima, CAThe pilot's misjudgement of the proper altitude and distance from the runway during a night approach.NTSB ATL90LA003Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Albemarle, NCThe pilot's failure to maintain directional control of the airplane.NTSB LAX89DUG09Accident · No injuriesFinal reportAir Tractor AT-301A · Blythe, CAThe pilot's failure to verify the fuel supply prior to takeoff.NTSB ANC89LA156Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Sheenjek River, AKFailure of the pilot to go around when he was unable to attain the proper touchdown point and his excessive application of brakes during the landing. Contributing factors were: the downdraft, excessive remedial action, and soft terrain.NTSB MKC89LA190Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Wabbaseka, ARImproper planning/decision by the pilot which resulted in his failure to maintain clearance from the tall vegetation (grass). The tall vegetation & high density altitude were considered to be contributing factors.NTSB LAX89DVA09Accident · No injuriesFinal reportAero Commander S2R · Tranquillity, CAThe pilot's visual look-out was inadequate and that he failed to see the high vegetation upon landing. Factors relating to this accident are dark night and high vegetation.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 CHI89DEP10Accident · 1 fatalFinal reportAir Tractor AT-301 · Plainfield, WIFailure of the pilot-in-command to maintain control of the aircraft while conducting aerial application maneuvers in close proximity to the terrain.NTSB ATL89DKG05Accident · Minor injuriesFinal reportGrumman G-164A · Dawson, GAFailure of the number three cylinder head.NTSB FTW89DRD12Accident · No injuriesFinal reportSchweizer G-164B · Donaldsonville, LALoss of engine power for undetermined reasons. A contributing factor was the soft terrain.NTSB MKC89LA170Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Portland, AREngine failure due to failure of an engine cylinder.NTSB SEA89LA135Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Albion, IDThe pilot's improper use of the mixture control during takeoff. The fence was a related factor.NTSB MIA89LA203Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Schlater, MSInadequate preflight planning/preparation by the pilot which resulted in the selection of the wrong runway. The tailwindand dirt bank were considered to be contributing factors.NTSB FTW89DRD11Accident · No injuriesFinal reportSchweizer G-164A · Lake Arthur, LALoss of engine power for undetermined reasons. The high weeds (vegetation) & levee (dirt bank) were considered to be related factors.NTSB LAX89DVG07Accident · No injuriesFinal reportSchweizer G-164B · Willows, CAFailure of the connecting rod on #1 cylinder of the aircraft powerplant.NTSB MKC89LA150Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jonesboro, ARThe pilot's encounter with unsuitable terrain during a forced landing made necessary by the separation of three feet of one of the propeller blades.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 SEA89LA121Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Colfax, WAImproper installation of the cylinder assembly. The terrain was not suitable for a successful forced landing.NTSB CHI89LA111Accident · No injuriesLimited investigationFinal reportBoeing E75 · Shelbyville, INThe pilot allowed his attention to be devaited, misjudged altitude and distance to the runway while on final approach, and failed to maintain clearance above the power lines. Contributing factors were: the power lines and parked aircraft.NTSB FTW89DRD07Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Morse, LALoss of engine power for an undetermined reason. The soft terrain was a contributing factor.NTSB MKC89LA129Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Wynne, ARUnsuitable terrain selected by the pilot. A contributing factor was the rough/uneven landing area.NTSB MIA89LA166Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Lambert, MSFailure of the engine impeller. The ditch in the emergency landing area was a related factor.NTSB SEA89LA096Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Hermiston, ORFailure and separation of the left main landing wheel.NTSB MIA89LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Arcola, MSThe circumferential on the number 2 cylinder which resulted in a loss of engine power.NTSB ATL89DKJ03Accident · No injuriesFinal reportGrumman G-164A · Loxley, ALThe loss of engine power due to carburetor ice, and the pilot's improper use of carburetor heat.NTSB LAX89DVG06Accident · No injuriesFinal reportGrumman G-164B · Davis, CAThe pilot failed to properly use his brakes during the off airport landing.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 SEA89LA071Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Grangeville, IDA partial power loss due to a blower failure. A factor related to the accident was the soft field condition.NTSB MKC89LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roseau, MNFuel starvation due to fuel ice.NTSB MIA89LA130Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Lakeland, FLThe pilot's failure to maintain directional control, which resulted in an inadvertent ground loop.NTSB FTW89DPJ03Accident · No injuriesFinal reportAir Tractor 301 · Jefferson, OKLoss of engine power, due to a cracked number 4 cylinder. A factor related to the accident was: the terrace (dirt bank) in the emergency landing area.NTSB MKC89LA079Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARFailure of the engine blower assembly drive shaft, while maneuvering at low altitude, and failure of the pilot to maintain adequate airspeed, which resulted in a stall before he could land.NTSB LAX89LA114Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6 · Compton, CAFatigue cracks that existed in an engine cylinder.NTSB ATL89DKG01Accident · No injuriesFinal reportGrumman G-164A · Dawson, GATotal loss of engine power due to leaking carburetor float. Contributing to the accident was the soft terrain used for a forced landing.NTSB LAX89DUM03Accident · No injuriesFinal reportGrumman G-164 · Blythe, CAThe pilot stated that the engine lost power on a 'spray pass.' He then executed a forced landing straight ahead and nosed over after touchdown in a cotton field. Investigation revealed an elbow fitting connecting the main fuel supply line and the carburetor…NTSB ATL89LA008Accident · Serious injuriesLimited investigationFinal reportNorth American T-6G · West Jefferson, NCDuring a landing attempt, the pilot lost directional control and veered off the right side of runway 27. The pilot reported applying opposite braking with negative results. The airplane examination failed to disclose any system problem.NTSB ATL88DKG15Accident · Minor injuriesFinal reportRockwell S2R · Pelham, GAThe crop duster had completed the third swath run of the morning when the engine began to lose power. The plt released the contents of the hopper and made a forced landing in a soybean field. During the landing roll, the airplane nosed over and a ground fire…NTSB ATL88DKG14Accident · Minor injuriesFinal reportAyres Thrush S2R · Ochlocknee, GAShortly after takeoff the pilot allowed the nose to drop resulting in a collision with the ground. The airplane hit the ground, right wing first, and traveled about 500 feet before stopping. The pilot had been spraying methyl parathion all day and stated he…NTSB MKC88LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Elaine, ARDuring an aerial application operation, the pilot said that immediately after breaking ground on takeoff, the engine quit. He attempted to re-land on the remaining available runway, but ran off the end, hitting a ditch and nosing over. Cause of the engine…NTSB MKC88LA161Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARWhile en route to engage in an aerial application operation, the plt said the engine began to misfire and cut out. Unable to correct the malfunction, the plt dumped his chemical load and began returning to the departure airstrip. En route, he felt he would…NTSB LAX88DVA12Accident · No injuriesFinal reportAyres S2R · Kerman, CADrg an aerial application flt, the eng lost power & a fire started in the eng compartment when a fuel line failed, just forward of the fire wall. The plt made a successful landing in an open field, but the acft was substantially damaged due to the fire.NTSB MIA88LA258Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Shelby, MSWhile on an aerial application flt during the ground roll to takeoff, the forwardmost of two main gear clamp block bolts of the rt main landing gear failed. The gear trailed aft. The inboard main gear large bolt failed. The acft travelled off the rwy into a…NTSB MKC88LA158Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Humphrey, ARWhile attempting to land on a narrow dirt road bordered by crops, the plt said he contacted the high vegetation on the right side. The acft began to veer to the right. The plt attempted to steer to the left and veered off the roadway into a ditch and nosed…NTSB MKC88LA159Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Swifton, ARShortly after takeoff during an aerial application operation, the pilot said he was unable to establish a positive climb. After traveling about 1 mile, he elected to dump his dry fertilizer load. When he dumped the load, the increased aerodynamic drag caused…NTSB FTW88DRD18Accident · Serious injuriesFinal reportGrumman G-164A · Rayne, LAAt the end of a swath run, the ag pilot pulled the airplane up and to the left to start a turn-around. The upper left wing struck a steel guy-cable of a 300 foot tower. The airplane made several turns of an inverted flat-spin before water impact into an eight…NTSB FTW88DRD17Accident · No injuriesFinal reportSchweizer G-164A · Mangham, LAThe ag airplane was spraying cotton when the engine started to vibrate. Pilot pulled airplane up and vibration was so bad power had to be reduced. Pilot made a forced landing in a muddy field. The left wing caught in tall grass and airplane cartwheeled. Pilot…NTSB MKC88DPG02Accident · 2 fatalFinal reportSnow 600-S2C · Almyra, ARTwo ag aircraft were spraying the same field. According to several witnesses, 1671S was heading south and 3660X was heading east. Both aircraft were actively engaged in the spraying operation but did not seem to the witnesses to be coordinating with each…NTSB LAX88DVG09Accident · No injuriesFinal reportSchweizer G-164B · Robbins, CADuring landing roll, after an aerial application flight, the sprayboom became entangled in weeds. The airplane ground looped and nosed over. There were no reported mechanical failures or malfunctions of the airplane at the time of the accident.NTSB MKC88LA141Accident · No injuriesLimited investigationFinal reportRockwell S2R · O'Kean, ARWhile performing an aerial application operation, the plt said he experienced a total powerplant failure. He attempted an emergency ldg in a cultivated rice field. During the ldg attempt, the aircraft sustained substantial damage to the propeller, landing…