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 MIA91LA183Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenwood, FLThe inadequate preflight which resulted in debris in the cockpit which reduced the pilot's visual lookout. Unsuitable terrain encountered during the landing was a factor.NTSB LAX91LA301Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Eloy, AZThe failure of the pilot to maintain the terrain clearance of the aircraft while maneuvering for a potential emergency landing on a moonless dark night.NTSB MIA91LA169Accident · No injuriesLimited investigationFinal reportGrumman G164B · Immokalee, FLLoss of enine power due to undetermined reasons. Contributing to the accident was unsuitable terrain encounteered during the forced landing.NTSB FTW91DRG03Accident · Serious injuriesFinal reportGrumman G-164A · Weslaco, TXFailure of the pilot to maintain clearance.NTSB MIA91LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · High Springs, FLLoss of engine power due to disintegration of the impeller caused by a worn impeller bearing.NTSB SEA91LA136Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wilson Creek, WAThe loss of engine power in flight due to improper overhaul of the carburetor float assembly fulcrum screw, shutting off fuel flow to the engine.NTSB DEN91LA077Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAPremature pull up from an aerial application swath run resulting in a collision with an electrical transmission line.NTSB ANC91LA061Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Larsen Bay, AKThe pilot's decision to continue VFR into IMC conditions and failure to maintain proper altitude. Contributing to the accident was the low ceiling and fog.NTSB FTW91DPG06Accident · No injuriesFinal reportGrumman G-164A · Gillett, ARThe windshiled becoming obscured by aerial application spray and the resultant limited vision from the cockpit.NTSB FTW91LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pioneer, LAThe pilot's use of a runway unsuitable due to recent rains.NTSB MIA91LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Avon, MSLoss of engine power for undetermined reasons during a turn while on an aerial application flight. Contributing to the accident was failure of the left magneto due to failure of a phenolic gear which drives the rotating magnet.NTSB FTW91DPG02Accident · No injuriesFinal reportGrumman G-164A · Light, ARThe pilot's selection of the downwind runway for landing. A factor was the tailwind.NTSB LAX91LA109Accident · No injuriesLimited investigationFinal reportRockwell S2R-600 · Corcoran, CAFailure of the aircraft engine's fuel pump valve assembly bypass.NTSB ATL91LA059Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Pavo, GAThe failure of the no. 2 exhaust valve and cylinder head, which resulted in a total loss of engine power. A factor in the accident was the collision with a road sign during the forced landing.NTSB ANC91LA022Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-3 · Nome, AKThe failure of the 1, 2, 6, 7, 8 and 9 piston linkrods which were broken at the master rod attach end. Contributing to the accident was the rough, uneven terrain.NTSB MIA91LA033Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT401 · Belle Glade, FLThe pilot failed to maintain airspeed, and stalled the airplane, resulting in a uncontrolled descent, and collision with the terrain.NTSB ANC90LA184Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · King Salmon, AKThe pilot-in-command's failure to maintain airplane control during the takeoff roll, and failure of not attaining airspeed on takeoff.NTSB FTW90DRA09Accident · No injuriesFinal reportGrumman G-164A · Altair, TXThe pilot's use of improper terrain for takeoff.NTSB NYC90DFJ04Accident · No injuriesFinal reportSchweizer Grumman G-164A · Wayland, NYA cracked engine cylinder assembly, which resulted in loss of engine power.NTSB FTW90DPG13Accident · No injuriesFinal reportGrumman G-164A · Luxora, ARA partial power loss due to failure of the number five connecting rod. A factor was the soft terrain in which the forced landing was made.NTSB FTW90DPG08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Corning, ARBlockage of the carburetor Air intake by a collapsed Air induction hose due to improper maintenance by an unknown party.NTSB ATL90FA158Accident · 2 fatalField investigationFinal reportNorth American T-6G · Locust Grove, GAThe pilot-in-command's failure to maintain aircraft control during maneuvering flight, allowing the airplane to stall without sufficient altitude for recovery.NTSB LAX90DXQ03Accident · Minor injuriesFinal reportAir Tractor AT-401 · Tule Lake, CAAn engine failure due to mechanical failure of the distributor.NTSB FTW90DPG04Accident · No injuriesFinal reportAir Tractor 301A · Foreman, ARThe pilot's inadvertent stall/mush.NTSB LAX90DVA07Accident · 1 fatalFinal reportAir Tractor AT-401 · San Joaquin, CAThe failure of the no. 4 cylinder head.NTSB SEA90LA140Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAThe pilot's failure to ensure an adequate supply of fuel, which resulted in fuel exhaustion.NTSB MKC90LA147Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Egypt, ARThe pilot's failure to maintain directional control. A factor related to the accident was the soft/muddy area on the runway.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 ANC90LA103Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-3 · Beaver Village, AKMechanical failure of an exhaust rocker arm.NTSB CHI90DEE07Accident · Minor injuriesFinal reportSchweizer G-164B · Deer Grove, ILThe pilot's inadequate visual lookout, resulting in collision with a power line.NTSB SEA90LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDThe pilot did not maintain a proper altitude while maneuvering to reverse direction.NTSB SEA90LA103Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tekoa, WAFailure of the pilot to maintain clearance between the airplane and tall grass adjacent to the gravel strip.NTSB MKC90LA129Accident · No injuriesLimited investigationFinal reportRockwell S2R · Tilton, ARFailure of the engine blower(supercharger). Related to the accident was the soft/wet terrain, where the forced landing was performed.NTSB MKC90LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ulysses, KSFailure of the powerplant cylinder and stall/mush encountered by the pilot in command.NTSB FTW90DPA07Accident · No injuriesFinal reportAyres S2R · Mcgregor, TXThe fuel exhaustion induced power loss, which resulted from the pilot's inaccurate fuel consumption calculations.NTSB LAX90DVA04Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Buttonwillow, CAFailure of the #7 cylinder due to a pre-existing crack. The terrain condition was a related factor.NTSB FTW90DRA05Accident · No injuriesFinal reportGrumman 164-B · Garwood, TXThe power loss due to super charger impeller failure.NTSB LAX90DVG07Accident · Serious injuriesFinal reportGrumman G-164A · Gridley, CAFailure of the no.7 cylinder head which led to a forced landing and substantial damage to the aircraft when it nosed over after colliding with a ditch.NTSB FTW90DRD07Accident · No injuriesFinal reportGrumman G-164A · Ville Platte, LAPartial loss of engine power due to a cracked number four cylinder intake rocker box housing. The lack of a suitable forced landing site was a related factor.NTSB FTW90DRA04Accident · No injuriesFinal reportGrumman 164A · Garwood, TXFailure of the number 8 cylinder.NTSB LAX90DUG05Accident · 1 fatalFinal reportGrumman G-164B · Blythe, CAFailure of the pilots of N6708K and N10222 to maintain adequate visual lookout and failure of the pilot of N6708K to follow a prearanged procedure for reversing the direction of flight.NTSB ATL90DLT01Accident · No injuriesFinal reportGrumman G-164B · Tiptonville, TNA loss of engine power for undetermined reasons. A factor in the accident was the rough terrain.NTSB MKC90LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hornersville, MOFailure of an engine cylinder.NTSB MKC90LA080Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mounds, ARThe pilot's improper compensation for wind conditions. Factors related to the accident were: the pilot's selection of the wrong runway and the resultant tailwind condition.NTSB MKC90LA079Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Des Arc, ARFailure of the engine fuel pump.NTSB FTW90DRD04Accident · No injuriesFinal reportGrumman G-164B · Fenton, LAFailure of the elevator control rod end bearing.NTSB MKC90LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARFailure of the pilot to maintain proper runway alignment, which resulted in an encounter with soft/wet (muddy) terrain and a subsequent nose over of the aircraft.NTSB DEN90LA061Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Englewood, COTo be a failure of the pilot to maintain directional control.NTSB ATL90LA078Accident · No injuriesLimited investigationFinal reportNorth American T-6 G · Albany, GAA locked brake which prevented the pilot from maintaining directional control during the landing roll. The brake material expanded after becoming water soaked while taxiing.NTSB LAX90DVG02Accident · No injuriesFinal reportSchweizer G-164B · Knights Landing, CAThe failure of the right main Landing gear due to a sheared bolt that attached the spring leg to the gear.