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 MIA96LA122Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edison, GAFailure of the mounting studs for the No. 4 cylinder, which resulted in separation of the cylinder and loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB CHI96LA119Accident · No injuriesLimited investigationFinal reportAyres S2-R · Wyatt, MOthe pilot's failure to maintain control of the airplane during takeoff. A factor was the crosswind condition.NTSB FTW96LA135Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARFailure of the engine master rod. A factor relating to the accident was: the lack of suitable terrain for a forced landing, due to the proximity of a power line and trees.NTSB FTW96LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pawnee, OKThe pilot's failure to maintain adequate clearance from the terrain.NTSB LAX96LA012Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lost Hills, CAthe pilot misjudged the aircraft's altitude.NTSB FTW96LA007Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamburg, ARLoss of engine power due to a cylinder failure. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB ATL95LA169Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Plains, GAFailure of the number four cylinder rocker arm housing and pin, which resulted in a closed exhaust valve and loss of engine power.NTSB FTW95LA362Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dalhart, TXthe pilot's failure to maintain control of the airplane during takeoff.NTSB MIA95LA192Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Quitman, MSImproper (low) outflow from the fuel control unit, due to improper maintenance, which resulted in a loss of engine power and a forced landing.NTSB CHI95LA260Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A-450 · Grand Forks, NDthe pilot's failure to maintain clearance with transmission wires. A factor in the accident was the sunglare.NTSB CHI95LA265Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Wyatt, MOthe pilot's failure to use carburetor heat which led to carburetor ice. Factors were weather conditions conducive to carburetor icing and the unsuitable terrain encountered during the forced landing.NTSB LAX95LA276Accident · No injuriesLimited investigationFinal reportNorth American AT-6B · Glendale, AZThe failure of the pilot of the other aircraft to follow pre-briefed instructions and failure to see and avoid the preceding aircraft awaiting takeoff.NTSB LAX95LA274Accident · No injuriesLimited investigationFinal reportNorth American AT-6F · Long Beach, CAthe failure of the left main landing gear locking mechanism to fully seat in the 'down' position due to loose attachment bolts.NTSB FTW95LA322Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Edna, TXThe collapsing of the landing gear for undetermined reasons.NTSB CHI95LA247Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Poplar Bluff, MOthe pilot's inadequate preflight/planning preparation. Factors in the accident were: the loss of engine power due to carburetor icing, the wet runway, and the ditch.NTSB SEA95LA161Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Havre, MTthe loss of power due to a failure of the cylinder head exhaust valve rocker box. The tall crop encountered during the forced landing is a factor.NTSB CHI95LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Grygla, MNThe pilot's failure to maintain altitude and/or clearance at the beginning of the spray run. A factor was turbulence due to the different Air temperatures of adjoining terrain.NTSB FTW95LA301Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, AREngine power loss due to partial failure of one magneto combined with total failure of the other magneto. A factor was the lack of suitable terrain for a forced landing.NTSB MIA95LA180Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Clewiston, FLImproper weather evaluation by the pilot in command while attempting to takeoff with a quartering tailwind associated with a nearby thunderstorm and failure of the pilot to maintain directional control.NTSB SEA95LA138Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burley, IDA total loss of engine power due to fatigue failure of the crankshaft. A factor in the accident was the lack of suitable terrain for the forced landing.NTSB FTW95LA283Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Widener, ARLoss of engine power for an undetermined reason. The proximity of power lines (obstruction) was a related factor.NTSB SEA95LA143Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WALoss of engine power due to a cracked cylinder.NTSB FTW95LA282Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Newport, ARA disconnected throttle push pull rod, due to inadequate maintenance. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB FTW95LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cheneyville, LAThe pilot's failure to maintain adequate airspeed at a low altitude.NTSB CHI95LA198Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Hoxie, KSthe loss of engine power due to the loose nut on the adjustment screw and the jammed exhaust valve on the number three cylinder. A factor in the accident was the ditch.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 CHI95LA163Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · E. Grand Forks, MNThe pilot's failure to maintain clearance with the wires.NTSB SEA95LA108Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · Terreton, IDThe pilot's failure to maintain an adequate altitude to overcome the downdraft. The downdraft was a factor.NTSB LAX95LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAa loss of engine power due to a separation of the number 6 cylinder, and the nose over during the subsequent forced landing.NTSB CHI95LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Clark, SDthe failure of the pilot to refuel prior to fuel exhaustion. A factor in the accident was the pilot's excessive braking.NTSB FTW95LA213Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Caldwell, ARThe loss of power due to a crack in the #4 cylinder. Factors were the lack of suitable terrain for the forced landing and proper touchdown point not possible.NTSB FTW95LA205Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · St Martinville, LAThe pilot's failure to maintain control of the aircraft. A factor was the high winds.NTSB FTW95LA202Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Joes, COA total loss of power due to fuel exhaustion. Factors were: a malfunction in the fuel measuring system, the pilot's failure to perform fuel consumption calculations, and soft and unsuitable terrain for a forced landing.NTSB LAX95LA186Accident · Minor injuriesLimited investigationFinal reportGrumman 164A · Richvale, CAthe pilot's failure to maintain a glidepath adequate to avoid an obstacle, and his inadequate compensation for the wind.NTSB FTW95LA145Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Gillett, ARThe engine main rod bearing seized to the crankshaft due to worn master rod metal pieces blocking the oil passages. A factor was an engine overhaul was not performed by company maintenance personnel.NTSB LAX95LA126Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Robbins, CAA failure of the engine master rod. A factor in the accident was the soft, wet condition of the field available for the forced landing.NTSB SEA95LA057Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Salem, ORThe pilot-in-command's failure to maintain directional control during the landing rollout.NTSB LAX95LA091Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pixley, CAthe total failure of the number three cylinder. The wet and soft terrain were factors in this accident.NTSB MIA95LA015Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Madison, MSThe pilots improper use of brakes during a precautionary landing.NTSB MIA95LA008Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLFailure of the pilot to refuel resulting in loss of engine power due to fuel exhaustion.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 ATL95LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jakin, GAThe loss of engine power for undetermined reasons.NTSB ATL95LA004Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Ashburn, GAThe failure of a blade counterweight bearing shaft, allowing one propeller blade to go to high pitch.NTSB FTW94LA306Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARThe loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB LAX94LA368Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · Reno, NVthat the pilot of the other airplane misjudged the distance between the airplanes. The other airplane pilot's diverted attention to the air race is a factor in this accident.NTSB CHI94LA292Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Clifton, ILthe pilots failure to keep visual contact with and to avoid unmarked powerlines adjacent to the crop field he was spraying.NTSB LAX94LA327Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Firebaugh, CAthe loss of engine power due to the failure of the number 2 cylinder head. A factor was the dark night conditions which inhibited the pilot's ability to visually detect ground obstructions in the landing area.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 FTW94LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARTotal loss of engine power as the engine seized due to a blower bearing failure. A factor was the lack of suitable terrain for the forced landing.NTSB SEA94LA200Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Connell, WAThe pilot's failure to maintain airspeed while conducting aerial application activities.