Skip to content

NTSB investigations: Pratt & Whitney R1340 series, OR

17 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

19682026

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" = 'OR' 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\" = 'OR' 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" = 'OR' 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 WPR26LA312Accident · Serious injuriesClass 3 · LimitedPreliminary reportSchweizer G-164B · Olene, OROn August 20, 2026, about 9:32 Pacific daylight time, a Schweizer Aircraft Corp., G-164B, N7501Q, was destroyed when it was involved in an accident near Orlene, Oregon. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…Aug 20, 2026 · N7501Q · Destroyed NTSB WPR23LA261Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6G · La Grande, ORThe pilot's failure to maintain clearance from trees during an airstrip overfly, which resulted in impact damage to the left wing.Jul 8, 2023 · N92761 · Substantial damage NTSB GAA19CA185Accident · Minor injuriesData collectionFinal reportRockwell S 2R · Hermiston, ORThe pilot's distraction due to a spray handle opening and his improper pitch trim setting during final approach, which resulted in an excessive pitchdown when he took his hand off the controls to close the handle.Mar 28, 2019 · N4250X · Substantial damage NTSB WPR15LA106Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Alfalfa, ORA total loss of engine power after takeoff for reasons that could not be determined, because examination of the engine did not reveal any mechanical anomalies that would have precluded normal operation.Feb 18, 2015 · N4863 · Substantial damage NTSB SEA03LA152Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hermiston, ORThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power. Rocky terrain was a factor.Jul 21, 2003 · N4250X · Substantial damage NTSB SEA95LA057Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Salem, ORThe pilot-in-command's failure to maintain directional control during the landing rollout.Feb 25, 1995 · N4269E · Substantial damage NTSB SEA89LA096Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Hermiston, ORFailure and separation of the left main landing wheel.May 26, 1989 · N8768H · Substantial damage NTSB SEA85FYM01Accident · Serious injuriesFinal reportAir Tractor AT301 · Weston, ORDuring this aerial application flight the aircraft clipped a tree and then impacted with the ground. The pilot was seriously injured when the stitching on the shoulder harness failed and the pilot was thrown forward.Apr 30, 1985 · N3652F · Destroyed NTSB SEA79FYM48Accident · No injuriesClosedGrumman G-164A · Hermiston, ORJul 11, 1979 · N5340 · Substantial damage NTSB SEA79DYM38Accident · Minor injuriesClosedSnow S2D · Echo, ORJun 7, 1979 · N1717S · Destroyed NTSB SEA79DYM37Accident · No injuriesClosedAero Comdr S2R · Helix, ORMay 25, 1979 · N4999X · Substantial damage NTSB SEA77DYK15Accident · Minor injuriesClosedGrumman G-164A · Klamath Falls, ORJun 16, 1977 · N6662Q · Destroyed NTSB SEA76FYC48Accident · No injuriesClosedAero Comdr 600S2R · Hermiston, ORMay 6, 1976 · N4229X · Substantial damage NTSB SEA73FYC24Accident · No injuriesClosedKaman K-600 · Pilot Rock, ORApr 11, 1973 · N11012 · Substantial damage NTSB SEA72DYA43Accident · Minor injuriesClosedAero Comdr 600S2R · Ontario, ORJun 30, 1972 · N1782S · Substantial damage NTSB SEA72FYI04Accident · No injuriesClosedKaman HUK-1 · Central Pt, ORAug 7, 1971 · N9847 · Substantial damage NTSB SEA69A0022Accident · 2 fatalClosedN.American AT-6C · Veneta, OROct 2, 1968 · N5186V · Destroyed