Skip to content

NTSB investigations: Pratt & Whitney R1340 series, AZ

37 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'AZ' 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

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\" = 'AZ' 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" = 'AZ' 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

Run 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 WPR16FA112Accident · 2 fatalField investigationFinal reportNorth American AT 6 · Mesa, AZThe pilot's inability to return to the departure airport due to an unspecified in-flight emergency for reasons that could not be determined during a postaccident examination of the airplane.May 18, 2016 · N3198G · Destroyed NTSB LAX02LA014Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Mesa, AZThe pilot's inadequate compensation for an existing crosswind condition, and failure to maintain directional control on the landing rollout.Oct 23, 2001 · N3246G · Substantial damage NTSB LAX01LA183Accident · No injuriesLimited investigationFinal reportNorth American AT-6 D · Prescott, AZThe pilot's inadequate compensation for an existing crosswind condition.May 5, 2001 · N7421C · Substantial damage 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.Aug 1, 1995 · N105DG · 2 aircraft · Minor damage NTSB LAX93LA365Accident · Minor injuriesLimited investigationFinal reportSnow 600-S2C · Surprise, AZThe pilot's improper inflight planning resulting in his airplane's encounter with wake turbulence.Sep 22, 1993 · N1677S · Substantial damage NTSB LAX92LA358Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Laveen, AZThe failure of the pilot to maintain directional control of the aircraft during the landing roll.Aug 19, 1992 · N5363 · Substantial damage NTSB LAX92LA340Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tolleson, AZThe pilot's selection of unsuitable terrain for takeoff. Contributing to this accident was the ravine that crossed the runway.Aug 9, 1992 · N6809K · Substantial damage NTSB LAX92LA018Accident · No injuriesLimited investigationFinal reportSnow S2C · Bowie, AZThe failure of the pilot to maintain directional control after landing. The unfavorable wind condition was a related factor.Oct 17, 1991 · N1625S · Substantial damage 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.Jul 9, 1991 · N6633K · Substantial damage NTSB LAX85LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Williams Afb, AZAfter making his first swath run,during the hours of darkness,the pilot became disorented and flew into an area with tall electrical transmission lines. He descended into trees beneath the lines in his attempt to miss them.Aug 27, 1985 · N3168U · Substantial damage NTSB LAX85LA360Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Tolleson, AZAccording to the pilot,the engine lost partial power while in cruise flt. He selected a cotton field in which to make a precautionary lng. The aircraft over shot the intended landing area and impacted a utility pole. The collision ruptured the fuel system and…Aug 21, 1985 · N6749K · Destroyed 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…Aug 4, 1985 · N45CT · Substantial damage NTSB LAX84LA379Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Stanfield, AZThe plt was maneuvering to start another field when the acft's left wing hit the roof of the ground flagging vehicle. The acft then collided with the ground.Jul 2, 1984 · N8430V · Destroyed NTSB LAX83LA128Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Williams Afb, AZWhile on a spray run, the eng lost power. Subsequently, the acft was damaged during a forced landing.Mar 6, 1983 · N4529 · Substantial damage NTSB LAX82DA353Accident · No injuriesFinal reportGrumman G-164A · Magma, AZShortly after takeoff the eng became rough & losing power. The plt observed long streaks of red flame pouring from the exhaust. The pesticide was jettisoned & an attempt was made to return to the strip. The eng continued to lose power & quit completely just…Sep 23, 1982 · N6602 · Substantial damage NTSB LAX82FUJ42Accident · 1 fatalFinal reportAir Tractor 301 · Yuma, AZThe pilot had completed his last load of the day and was en route back to the airport. According to witnesses, the aircraft entered a nose high attitude, then the nose dropped and the plane entered a spin. It struck the ground before recovering from the spin.…Jul 16, 1982 · N8538S · Destroyed NTSB LAX81DUJ91Accident · Minor injuriesClosedGrumman G-164B · Tonapah, AZAug 29, 1981 · N6776K · Destroyed NTSB LAX81DUJ83Accident · Minor injuriesClosedSnow 600S2C · Willcox, AZAug 5, 1981 · N1625S · Substantial damage NTSB LAX80FUJ92Accident · No injuriesClosedRockwell 600S2R · Buckeye, AZAug 4, 1980 · N5696X · Substantial damage NTSB LAX80DUJ86Accident · No injuriesClosedGrumman G-164A · Cotton Center, AZJun 9, 1980 · N4623 · Substantial damage NTSB LAX80DUJ67Accident · No injuriesClosedAero Comdr 600S2C · Wilcox, AZJun 9, 1980 · N1625S · Substantial damage NTSB LAX78FA023Accident · 1 fatalClosedHarvard MK4 · St Johns, AZJan 26, 1978 · N10908 · 2 aircraft · Minor damage NTSB LAX77FUJ98Accident · No injuriesClosedAero Comdr S2R · Stanfield, AZSep 5, 1977 · N8961Q · Substantial damage NTSB LAX77FUJ64Accident · Minor injuriesClosedAero Comdr 600S2R · Maricopa, AZJun 22, 1977 · N5626X · Destroyed NTSB LAX77FUJ44Accident · No injuriesClosedGrumman G-164A · Queen Creek, AZApr 21, 1977 · N73PB · Substantial damage NTSB LAX76DUK16Accident · No injuriesClosedGrumman G-164 · Sun City, AZSep 30, 1976 · N638U · Substantial damage NTSB LAX76DUK03Accident · No injuriesClosedGrumman G-164A · Gila Bend, AZAug 12, 1976 · N4529 · Destroyed NTSB LAX75DUJ22Accident · No injuriesClosedGrumman G-164A · Buckeye, AZAug 24, 1974 · N4529 · Substantial damage NTSB LAX75DUJ08Accident · No injuriesClosedSnow 600S2C · Poston, AZJul 1, 1974 · N9468R · Substantial damage NTSB LAX74DUJ38Accident · No injuriesClosedGrumman G-164A · Tonopah, AZDec 31, 1973 · N5363 · Substantial damage NTSB LAX72DUJ46Accident · No injuriesClosedNaval Fcty N3N-1 · Gadsden, AZSep 14, 1971 · N45065 · Substantial damage NTSB LAX72DUJ23Accident · No injuriesClosedNaval Fcty N3N-3 · Stanfield, AZAug 11, 1971 · N44713 · No damage NTSB LAX70D0131Accident · No injuriesClosedNaval Fcty N3N-3 · Somerton, AZAug 19, 1969 · N44936 · Substantial damage NTSB LAX68D0065Accident · No injuriesClosedNaval Fcty N3N · Chandler, AZJul 27, 1967 · N45151 · Substantial damage NTSB LAX68D0095Accident · No injuriesClosedNaval Fcty N3N · Chandler, AZJul 21, 1967 · N44814 · Substantial damage NTSB DEN66F0174Accident · Minor injuriesClosedNaval Arcft N3N-3 · Sun City, AZNov 4, 1965 · N44757 · Substantial damage NTSB UNK64X1956Accident · Minor injuriesClosedNavy N3N3 · Sun Sites, AZMay 25, 1964 · N44837 · Substantial damage