NTSB investigations: Pratt & Whitney R1340 series
79 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “Loss of control - on ground/water”. 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\" = 260))
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" = 260))
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 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 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 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 DEN90LA061Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Englewood, COTo be a failure of the pilot to maintain directional control.NTSB ATL90LA003Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Albemarle, NCThe pilot's failure to maintain directional control of the airplane.NTSB LAX89DVA09Accident · No injuriesFinal reportAero Commander S2R · Tranquillity, CAThe pilot's visual look-out was inadequate and that he failed to see the high vegetation upon landing. Factors relating to this accident are dark night and high vegetation.NTSB MIA89LA130Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Lakeland, FLThe pilot's failure to maintain directional control, which resulted in an inadvertent ground loop.NTSB ATL89LA008Accident · Serious injuriesLimited investigationFinal reportNorth American T-6G · West Jefferson, NCDuring a landing attempt, the pilot lost directional control and veered off the right side of runway 27. The pilot reported applying opposite braking with negative results. The airplane examination failed to disclose any system problem.NTSB MKC88LA158Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Humphrey, ARWhile attempting to land on a narrow dirt road bordered by crops, the plt said he contacted the high vegetation on the right side. The acft began to veer to the right. The plt attempted to steer to the left and veered off the roadway into a ditch and nosed…NTSB MKC88LA116Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cotton Plant, ARThe pilot did not adequately secure the aircraft prior to hand-propping the engine. The engine started and resulted in the aircraft taxiing without a pilot at the controls. The pilot-less aircraft impacted a utility pole causing substantial damage.NTSB ANC88LA066Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Eagle, AKThe pilot was attempting to land a heavily loaded De Havilland otter (DHC-3) on a gravel strip in rural Alaska. Upon touchdown, the pilot reported that the airplane veered slightly to the right. He unlocked the tail wheel centering device and attempted to…NTSB CHI88LA106Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Eden Prairie, MNWhile on an aircraft familiarization for purpose of check out, the pilot encountered a gusty crosswind on landing and failed to maintain aircraft control. The instructor pilot took over the controls, but was unable to regain directional control, and the…NTSB MKC87LA168Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Holly Grove, ARThe pilot lost control on takeoff roll, ran off the side of the runway and impacted a dirt bank. The aircraft came to rest in an inverted position. Investigation revealed no preimpact mechanical malfunctions/failures.NTSB DEN87LA222Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Colorado Spring, COThe plt reports that he accepted a tailwind for his landing and ground-looped during the roll out.NTSB BFO87LA030Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Norfolk, VAThe tower cleared the aircraft to land on runway 35 at Norfolk international airport with winds from 010 degrees at 20 to 25 knots. The pilot stated that all other traffic was using runway 05. During landing roll the aircraft started to drift to the right,…NTSB LAX87LA054Accident · No injuriesLimited investigationFinal reportNorth American-Maslon SNJ-4 · El Cajon, CAA North American SNJ-4 ground looped after a loss of control during takeoff roll on runway 27R. The aircraft swerved to the left twice and then lifted off the ground with a high angle of attack and low airspeed. The aircraft then 'mushed along' at…NTSB MIA86LA190Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Valley Park, MSThe plt stated that a thndrstrm was in the immediate area & he took off with a left quartering headwind. During the take off roll, the wind shifted & a left quartering tailwind blew the acft into a ditch. The plt estimated the winds at 50 to 60 mph.NTSB MIA86LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Vaiden, MSThe plt stated that upon landing in a cow pasture he lost directional control of the acft. The acft collided with a vehicle located at the FAR end and off to one side of the pasture. The acft then traveled through a fence and a ditch before coming to rest…NTSB MKC86LA102Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Almyra, ARThe plt stated that the landing was routine until he used the brakes. At this point the left wheel brake assembly came apart and the acft veered out of control off the right side of the rwy and into a ditch, where the left main landing gear collapsed. Post…NTSB LAX85LA340Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Tucson, AZThe tailwheel equipped acft nosed over after the plt lost iirecitional control during lndg. There were no reports of mechanical difficulties or weather facotrs to be considered in the area of cause. The plts flt experience is unknown since repeated attempts…NTSB FTW85LA162Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Frederick, OKThe passenger heard a loud mechanical noise from the tail of the aircraft during rollout from a touch-and-go landing. The pilot was unable to maintain directional control, the aircraft ground looped, the main landing gear collapsed, and the wings were…NTSB LAX85LA026Accident · No injuriesLimited investigationFinal reportHarvard MK IV/AT-6 · Apple Valley, CAPlt had executed successful crosswind landing and was decelerating on roll-out when a gust of wind caused the acft to swerve into the wind. Directional control could not be regained with rudder so plt elected to attempt go-around. Acft became airborne in…NTSB FTW83LA209Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Cheneyville, LAAccording to the operator, the brakes failed during landing causing the acft to ground loop off of the rwy. He also stated that postcrash investigation revealed a broken brake line on the right brake which he suspects was an act of sabotage by an unknown…NTSB ATL83LA147Accident · No injuriesLimited investigationFinal reportGrumman G164 A · New Church, VAThe acft swerved from a soft spot on the runway and left the runway. When the acft went into a plowed field the landing gear mired and the acft nosed over. The pilot could not see over the nose of the tailwheel acft to detect the soft spot in the runway. The…NTSB LAX83LA148Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Dos Palos, CAAccording to the operator, the plt landed with a quartering tailwind & directional control was lost. The acft veered offthe rwy into soft mud & flipped over.NTSB LAX83LA146Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Corcoran, CAAccording to the plt, he was taking off in a x-wind condition & allowed the acft to drift off the duster strip. He stated that he decided to continue the takeoff because of soft ground. The acft lifted off, then settled & the gear struck a levee. The plane…NTSB LAX83LA101Accident · No injuriesLimited investigationFinal reportGrumman G164 · Avenal, CADuring a landing after a spraying operation, the right brake failed and the aircraft collided with a berm before nosing over. The pilot said the right brake failed to keep aircraft on the runway when the rudder became ineffective. The 'o' ring part number an…NTSB FTW82DA177Accident · No injuriesFinal reportGrumman G-164A · Elreno, OKDuring takeoff the pilot encountered standing water on the runway. The aircraft swerved left and nosed over.NTSB NYC82DA078Accident · No injuriesFinal reportNorth American SNJ-2 · Flushing, NYThe flight proceeded without incident until the tail wheel was unlocked during the landing roll. The aircraft drifted to the left and struck a parked cherokee. Both aircraft were substantially damaged. Inspection revealed that residue of a recent paint…