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 LAX93LA189Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Sacramento, CAfailure of the pilot in command to maintain adequate airspeed during a low altitude maneuvering turn which resulted in an inadvertent stall.NTSB MIA93LA104Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Fort Pierce, FLFailure of the no. 2 cylinder in fatigue for undetermined reasons, over unsuitable terrain. The lack of suitale terrain for the forced landing was a factor.NTSB LAX93LA167Accident · Serious injuriesLimited investigationFinal reportAero Commander ST-R · San Jose, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB SEA93LA085Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Walla Walla, WAA loss of engine power for undetermined reasons. The lack of a suitable landing area was a factor.NTSB SEA93LA078Accident · No injuriesLimited investigationFinal reportSchweizer G-164B-600 · Quincy, WAUnsuitable terrain encountered during a forced landing after an engine cylinder assembly had separated. Factors include a snowbank.NTSB 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 LAX93LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lost Hills, CAThe pilot's inability to maintain directional control during the landing roll out due to a binding left brake master cylinder.NTSB MIA92LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Satartia, MSFailure of the brake system due to installation of a bogus part by an unknown person. Directional control by the pilot in command was not possible.NTSB CHI92DTG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Alice, NDComplete loss of engine power as a result of the partial failure of four pistons.NTSB ATL92LA172Accident · No injuriesLimited investigationFinal reportAyres S-2R · Douglas, GAThe pilot's failure to check weather prior to the flight. A factor was the dark night.NTSB LAX92LA358Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Laveen, AZThe failure of the pilot to maintain directional control of the aircraft during the landing roll.NTSB FTW92DRD05Accident · Minor injuriesFinal reportGrumman G-164 · Thibodaux, LAThe pilot's failure to maintain clearance from the wires.NTSB LAX92LA340Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tolleson, AZThe pilot's selection of unsuitable terrain for takeoff. Contributing to this accident was the ravine that crossed the runway.NTSB MIA92LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Redwood, MSImproper maintenance of the airplane by an unknown person.NTSB SEA92LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paul, IDThe pilot's selection of unsuitable terrain. The soft terrain was a factor.NTSB FTW92DPG11Accident · No injuriesFinal reportGrumman G-164B · Fouke, ARThe pilot's selection of unsuitable terrain for takeoff. Factors were the trees and the soft field.NTSB LAX92LA325Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Visalia, CAThe pilot's improper stowage of an aerosol spray can in the cockpit which caused an electrical short and an ensuing fire, and his failure to maintain directional control of the aircraft during the subsequent aborted takeoff.NTSB FTW92DPG10Accident · No injuriesFinal reportRockwell S2R-R3S · Minturn, ARThe loss of engine power and the encounter with unsuitable terrain during the forced landing.NTSB FTW92DPG09Accident · Serious injuriesFinal reportAir Tractor AT-301A · Fisher, ARA loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed above a stall.NTSB FTW92DPG06Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARLoss of engine power. A factor was the lack of suitable terrain for forced landing.NTSB LAX92LA274Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Tulare, CAAn inflight hopper compartment fire due to the incompatibility of the chemical loads, and, the failure of the operator follow the cautionary directives of the chemical manufacturer.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 ATL92LA124Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ft. Gaines, GAThe pilot's inadequate preflight planning/preparation.NTSB SEA92LA125Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coulee City, WAA loss of engine power for undetermined reasons. Factors include soft terrain.NTSB DEN92LA056Accident · No injuriesLimited investigationFinal reportNorth American Harvard MK-II · Watkins, COThe pilot inadvertently stalling the airplane. Factors included: the pilot's failure to maintain directional control on takeoff, and inadequate airspeed.NTSB FTW92LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Oil Trough, ARThe pilot's selection of unsuitable terrain for takeoff.NTSB LAX92LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Butte City, CAThe pilot's failure to follow normal procedures by selecting the wrong runway. Contributing to this accident was the pilot's premature lift off and the existing tailwind.NTSB FTW92LA143Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Walnut Ridge, ARThe pilot's failure to maintain adequate terrain clearance. A factor was the loss of power as result of the uncoupling of the engine and the propeller.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 SEA92LA091Accident · No injuriesLimited investigationFinal reportRockwell S2R · St. John, WAThe separation of the number 1 cylinder and remedial action by the PIC not possible. A factor contributing to the accident was: rough/uneven terrain.NTSB FTW92LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Almyra, ARThe pilot's improper judgement of the descent rate and his inadequate pull up at the bottom.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 LAX92LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dixon, CAThe pilot's premature lift-off. Contributing to the accident was the inadvertent stall/mush and the soft dirt airstrip.NTSB LAX92LA110Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenfield, CAThe pilot's failure to maintain adequate altitude during an intentionally performed low altitude flight in mountainous terrain. Contributing factors related to the pilot's visual perception of the canyon area because of changes in the ambient lighting…NTSB LAX92LA018Accident · No injuriesLimited investigationFinal reportSnow S2C · Bowie, AZThe failure of the pilot to maintain directional control after landing. The unfavorable wind condition was a related factor.NTSB NYC91LA253Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Manchester, NHThe pilot's failure to maintain control. A factor was the unforecasted strong cross winds.NTSB MIA91LA219Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Sumner, MSFailure of the no. 1 cylinder assembly.NTSB LAX91LA392Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Reno, NVThe failure of the pilot to maintain an adequate clearance between the aircraft and the ground while maneuvering around a pylon, which resulted in a loss of control during landing.NTSB LAX91LA384Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Hayward, CAThe failure of the pilot to maintain directional control of the aircraft while correcting an unwanted deviation.NTSB LAX91LA362Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Verona, CAThe pilot's improper planning/decision to depart from a runway with high vegetation along the edge and subsequent collision with terrain.NTSB LAX91LA364Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wasco, CAA total loss of engine power due to a fracture of the camshaft and the subsequent forced landing into a soft field.NTSB CHI91DTG07Accident · No injuriesFinal reportAyres S2R · Drayton, NDMisjudged clearance by the pilot. A factor related to the accident is overconfidence in personal ability.NTSB SEA91LA200Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Murtaugh, IDThe improper preflight planning/decision by the pilot, resulting in his attempt to takeoff with the aircraft loaded over maximum certificated gross takeoff weight.NTSB FTW91DPG18Accident · No injuriesFinal reportGrumman G-164A · Dewitt, ARThe pilot's failure to maintain proper glidepath. A factor was the berm at the approach end of the runway.NTSB FTW91DRD07Accident · No injuriesFinal reportGrumman G-164B · Donaldsonville, LAThe mechanical failure of the propeller blade pitch positioning bolt. A factor was the lack of suitable terrain available for the forced landing.NTSB CHI91DTG06Accident · No injuriesFinal reportAyres S2R · Drayton, NDThat the pilot did not perform any preflight planning, and did not use the aircraft performance data.NTSB CHI91DCQ07Accident · No injuriesFinal reportGrumman G-164A · Sharon Springs, KSAircraft takeoff performance exceeded and disregard of performance data by the pilot. A factor associated with the accident is high density altitude.NTSB FTW91DPG14Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARPartial failure of the hopper, chemical fire, and the failure of the landing gear. A factor ws the loss of visual outside reference.NTSB ATL91LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hawkinsville, GAA complete loss of engine power for undetermined reasons. A factor in this accident was: the rough, uneven terrain at the forced landing site.