NTSB investigations: Pratt & Whitney R1340 series, CA
279 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\" = 'CA' 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" = 'CA' 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 LAX07CA053Accident · No injuriesData collectionFinal reportNorth American AT-6C · Mojave, CAthe pilot's failure to maintain adequate clearance from a sign while performing a low altitude maneuver.NTSB LAX06LA280Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Paramount, CAthe loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the landing.NTSB ANC06CA039Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164A · Dixon, CAThe pilot's failure to attain altitude/clearance during takeoff/initial climb, which resulted in an in-flight collision with terrain. Factors associated with the accident were the pilot's inadequate evaluation of the weather, and unfavorable winds.NTSB LAX05LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Chino, CAthe pilot of the other airplane's failure to maintain an adequate clearance from obstacles while taxiing.NTSB LAX04CA323Accident · No injuriesData collectionFinal reportAero Commander S2R · Firebaugh, CAthe failure of the pilot to maintain clearance from high tension wires in dark night conditions. The reason for the loss of engine power after the wire collision was not determined.NTSB LAX04LA267Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Richvale, CAthe loss of engine power during takeoff due to the engine's deteriorated fuel control unit's inner drive shaft bearing. The reason for the bearing's deteriorated condition could not be determined.NTSB LAX04CA154Accident · Minor injuriesData collectionFinal reportAyres S-2R · Los Banos, CAthe pilot's failure to maintain proper runway alignment due to visual restrictions from the light condition, resulting in a nose over. Factors in the accident were the dusk light conditions and sun glare.NTSB LAX04CA153Accident · No injuriesData collectionFinal reportAyres S2R-600 · Calipatria, CAthe failure of ground personnel to refuel the airplane with the proper fuel grade/octane, resulting in the airplane's loss of engine power. Also causal was the pilot's failure to detect the fuel problem during a preflight inspection.NTSB LAX04LA126Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tracy, CAA loss of engine power for undetermined reasons during cruise flight.NTSB LAX03LA230Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Tulelake, CAThe pilot's inadequate preflight inspection and failure to remove the gust lock, which resulted in his loss of airplane control.NTSB LAX03LA158Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Willows, CAA loss of engine power for an undetermined reason during an aerial application.NTSB LAX02LA257Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dos Palos, CAthe failure of the propeller blade due to fatigue. Factors in the accident were the inadequate maintenance-repair of the blade, and, inadequate pilot preflight inspections.NTSB LAX02LA246Accident · No injuriesLimited investigationFinal reportAero Commander S2R-T34 · Los Banos, CAThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall.NTSB LAX02LA216Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Sacramento, CAPropeller blade failure due to fatigue. A contributing factor was the rising embankment.NTSB LAX02LA203Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Westmorland, CAThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A factor was the dark night condition.NTSB LAX02LA143Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164C · Olivehurst, CAFuel starvation due to the failure of an engine accessory component. A contributing factor was the rough terrain.NTSB LAX01LA228Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Meridian, CAThe pilot's misjudged and inadequate altitude while maneuvering during an aerial application flight.NTSB LAX00LA344Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Corcoran, CAThe pilot's inadequate preflight inspection and his failure to maintain directional control during takeoff. Factors were the pilot's failure to ensure that the fuel tank cover was replaced properly, fuel contamination of the windscreen, and the sun angle that…NTSB LAX00LA261Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gridley, CAA partial loss of engine power due to the failure of an exhaust valve during an aerial application flight.NTSB LAX00LA254Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6F · Grass Valley, CAfailure of the pilot to maintain directional control during the landing roll resulting in a collision with terrain.NTSB LAX00LA199Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Biggs, CAThe broken exhaust valve rocker arm of the number 3 cylinder that resulted in a total loss of engine power during an aerial application flight.NTSB LAX00LA162Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Lodi, CAA loss of engine power for undetermined reasons.NTSB LAX99LA312Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Acampo, CAThe pilot's failure to maintain runway alignment, which resulted in the aircraft encountering high vegetation, the loss of directional control, and collision with trees.NTSB LAX99LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Maxwell, CAFailure of the pilot to attain and maintain the proper reference climb airspeed during the rotation and initial climb, which resulted in a stall/mush condition.NTSB LAX99LA158Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Hollister, CAThe pilot's inadequate compensation for the crosswind condition, and his failure to maintain directional control during landing.NTSB LAX99LA040Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164C · Oroville, CAThe pilot's decision to attempt readjustment of the rudder pedal in-flight.NTSB LAX99LA008Accident · Minor injuriesLimited investigationFinal reportStearman E75 · Oakland, CAA loss of engine power due to the pilot's inadvertent entry into a negative 'g' condition, which induced a temporary interruption of the fuel supply.NTSB LAX98LA255Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Nelson, CAThe pilot's failure to maintain an adequate ground clearance altitude while applying chemicals to a rice field.NTSB LAX98LA240Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Tracy, CAThe failure of the pilot to maintain an adequate clearance with the telephone wires.NTSB LAX98LA238Accident · No injuriesLimited investigationFinal reportAyres S2R · Shafter, CAThe pilot's failure to maintain an adequate clearance from the irrigation standpipe due to glare from the rising sun.NTSB LAX98LA090Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Wasco, CAThe pilot overboosting the engine on takeoff which resulted in a cracked cylinder and subsequent loss of engine power.NTSB LAX97LA212Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Rio Linda, CAthe pilot's inadequate preflight planning/preparation by failing to ensure that sufficient airspeed would be obtained and/or maintained to remain clear of obstacles at the departure end of the runway. The obstacles (power lines & poles) were a related factor.NTSB LAX97LA121Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Winters, CAthe failure of the engine cylinder head assembly due to operational fatigue.NTSB LAX97LA099Accident · No injuriesLimited investigationFinal reportAyres S2R-T65 · Firebaugh, CAfailure of the pilot to compensate for crosswind conditions and to maintain proper runway alignment. Factors relating to the accident were: the crosswind, narrow runway condition, and the soft terrain and ditch beside the runway.NTSB LAX97LA045Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAthe pilot's premature lift-off from the runway and his failure to attain adequate airspeed.NTSB LAX96LA299Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Caruthers, CAthe loss of engine power due to the failure of a cylinder. The road's soft surface was a factor.NTSB LAX96LA213Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lost Hills, CAthe loss of engine power due to a cylinder failure. A contributing factor was the lack of a suitable field for the forced landing.NTSB LAX96LA012Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lost Hills, CAthe pilot misjudged the aircraft's altitude.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 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 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 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 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 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 LAX94LA299Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Live Oak, CAthe improper adjustment of the fuel control unit by contract maintenance personnel.NTSB LAX94LA247Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Bakersfield, CAThe in-flight fire due to the spontaneous combustion of sulfur dust and subsequent forced landing. A factor was the high temperature.NTSB SEA94LA117Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Yuba City, CAAn inadvertent stall/mush after takeoff. The over-weight loading of the aircraft was a factor.NTSB LAX94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe pilot's improper use of the brakes.NTSB LAX94LA133Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Clarksburg, CAThe total failure of the no. 1 cylinder due to fatigue resulting from an improperly adjusted mixture causing detonation. The soft, wet plowed field was a factor in this accident.NTSB LAX94LA099Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Davis, CAwas that the pilot misjudged the airplane's altitude during the swath run.