NTSB investigations: Pratt & Whitney R1340 series
126 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “Loss of engine power”. 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 FTW99LA097Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Hobart, OKThe loss of engine power due to an undetermined reason. A factor was the ditch.NTSB ATL99LA014Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Statesboro, GAThe pilot's failure to use carburetor heat. Factors were conditions favorable for the formation of carburetor ice.NTSB ATL98LA117Accident · No injuriesLimited investigationFinal reportAir Tractor 401 · Holly Bluff, MSThe malfunction of the carburetor which resulted in improper fuel flow to the engine.NTSB CHI98LA301Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · La Moure, NDa loss of engine power due to undetermined reasons.NTSB MIA98LA201Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Belzoni, MSThe malfunction in the engine blower section, resulting in oil starvation, the seizure of the engine.NTSB CHI98LA250Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Dyersville, IAthe pilot in command's not maintaining control of the airplane and his inadvertently allowing the airplane to enter a stall. A factor was the undetermined loss of engine power.NTSB MIA98LA181Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Rich, MSa loss of engine power for an undetermined reason, resulting in a forced landing and subsequent impact with rough terrain.NTSB CHI98LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDthe pilot failed to abort the takeoff in a timely manner and could not stop on the runway.NTSB CHI97LA204Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Donnelly, MNundetermined event resulting in the broken connecting rod and cylinder.NTSB FTW97LA228Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pond Creek, OKloss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB CHI97LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Prairie View, KSan undetermined event, which resulted in loss of engine power. Factors relating to the accident were: an automobile, which prevented the pilot from landing on a road; and a dirt bank (terrace) in the emergency landing area.NTSB FTW96LA346Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Hatch, NMa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB ATL96LA117Accident · No injuriesLimited investigationFinal reportGrumman G164 · Dawson, GAloss of engine power for undetermined reason(s), which resulted in an overrun, an encounter with soft terrain, and a nose over.NTSB ATL96LA107Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Scotia, SCa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for a forced landing.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 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 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 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 ATL95LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jakin, GAThe loss of engine power for undetermined reasons.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 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 MIA94LA172Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Rolling Fork, MSThe loss of engine power for undetermined causes. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB MIA94LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Walls, MSThe partial loss of engine power for undetermined reasons. The sandy terrain was a factor.NTSB ATL94LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Finley, TNThe loss of engine power for undetermined reasons. Factors were wet and soft terrain.NTSB FTW94LA131Accident · Minor injuriesLimited investigationFinal reportGulfstream G-164B · Delaplaine, ARThe loss of engine power for undetermined reasons. A factor was the low altitude at which the power loss occurred.NTSB LAX94LA019Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Arvin, CAthe loss of power for undetermined reasons.NTSB FTW93LA230Accident · No injuriesLimited investigationFinal reportAero Commander S2R · England, ARA partial loss of engine power for undetermined reasons.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 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 SEA92LA125Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coulee City, WAA loss of engine power for undetermined reasons. Factors include soft terrain.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 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 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 MKC90LA079Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Des Arc, ARFailure of the engine fuel pump.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 FTW89DRD12Accident · No injuriesFinal reportSchweizer G-164B · Donaldsonville, LALoss of engine power for undetermined reasons. A contributing factor was the soft terrain.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 FTW89DRD07Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Morse, LALoss of engine power for an undetermined reason. The soft terrain was a contributing factor.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 FTW89DRG05Accident · No injuriesFinal reportGrumman-Schweizer G-164 · Edcouch, TXLoss of engine power for an undetermined reason. The corn crop was a contributing factor.NTSB MKC89LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roseau, MNFuel starvation due to fuel ice.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 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 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…NTSB MKC88LA131Accident · No injuriesLimited investigationFinal reportRockwell S2R · Swifton, ARThe PIC was conducting ag-spray maneuvers dispensing liquid fertilizer to rice. During a procedure turn to return to the field the eng quit. The PIC chose an open field abt 60 degrees to his rt to land the aircraft. The field was wet, soft and rough. The acft…NTSB FTW88DRG07Accident · No injuriesFinal reportGrumman G-164A · Alamo, TXThe pilot experienced a total loss of engine power during climb when he made his initial power reduction. The power loss was accompanied by a loud bang. A severe postaccident ground fire melted a large portion of the engine. A partial engine teardown was…NTSB MIA87LA228Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6D · Panama City, FLThe plt stated that he was inbound to sandy creek airport when he heard a loud bang and lost power. On landing rollout in a field the aircraft hit some sod, flipped over & came to rest inverted. Post crash examination of the engine revealed an internal blower…NTSB ATL87DKG05Accident · No injuriesFinal reportSchweizer G-164A · Summerdale, ALThe pilot was about to engage in an aerial application operation. During climb the engine lost power, the chemical load was dumped and the airplane was landed in an adjacent field. On rollout the airplane hit a ditch and nosed over. Examination of the engine…NTSB FTW87DRG05Accident · No injuriesFinal reportAero Commander S2R · La Joya, TXDuring an aerial application flight at a low altitude the aircraft's engine failed. A forced landing was made to a grassfield resulting in substantial damage to the aircraft. Disassembly of the engine revealed partial failure of the left magneto. The aircraft…NTSB LAX87DVG05Accident · No injuriesFinal reportAero Commander S2R · Gridley, CAOn takeoff from a farmer's field the aircraft's engine lost power. The aircraft was unable to clear a levee, struck the levee and came to rest in a rice field. The aircraft's fuel pump was removed and tested. After one minute of operation the pump pressure…