Skip to content

NTSB investigations: Pratt & Whitney R1340 series, WI

21 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

19652026

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" = 'WI' 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\" = 'WI' 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" = 'WI' 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 WPR24LA253Accident · No injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Jul 25, 2024 · N52494 · Substantial damage NTSB CEN23FA332Accident · 2 fatalClass 3 · FieldFinal reportNorth American AT-6D · Oshkosh, WIThe pilot’s failure to maintain airspeed while maneuvering, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall/spin.Jul 29, 2023 · N49961 · Destroyed NTSB CEN19CA237Accident · No injuriesData collectionFinal reportNorth American AT 6F · Oshkosh, WIThe pilot's loss of directional control during landing with a quartering tailwind, which resulted in a runway excursion and subsequent substantial damage.Jul 24, 2019 · N7976A · Substantial damage NTSB CEN15LA345Accident · No injuriesLimited investigationFinal reportAir Tractor AT 401 · Nekoosa, WIThe pilot’s inadequate preflight planning, which resulted in his attempt to take off for the agricultural application flight with the airplane over its maximum gross weight in high-density altitude conditions and led to the airplane’s degraded climb…Aug 5, 2015 · N1539U · Substantial damage NTSB CEN11FA562Accident · No injuriesField investigationFinal reportAir Tractor AT-301 · Nekoosa, WIA total loss of engine power during initial climb for undetermined reasons.Aug 4, 2011 · N4345S · Substantial damage NTSB CEN09LA602Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · New Miner, WIA total loss of engine power due to the fatigue failure of the engine torsion shaft. Contributing to the accident was the chrome plating of the shaft by an undetermined maintenance/overhaul facility.Aug 22, 2009 · N3651R · Substantial damage NTSB CEN09CA522Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Evansville, WIA jam of the elevator flight control for undetermined reasons.Aug 12, 2009 · N9794 · Substantial damage NTSB CHI07LA219Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Fond Du Lac, WIThe loss of engine power due to the failure of the engine's master connecting rod which resulted in the forced landing. The road sign was a factor.Jul 23, 2007 · N22NA · Substantial damage NTSB CHI02LA133Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bancroft, WIThe loss of engine power due to contamination of the fuel system from an unknown source and the blocked fuel filter. The rough terrain was a factor.May 10, 2002 · N4224X · Substantial damage NTSB CHI01LA240Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Plainfield, WIThe pilot not maintaining aircraft control while maneuvering on the aerial application flight. A factor to the accident was the encountered stall/mush at a low altitude.Jul 21, 2001 · N8703V · Substantial damage NTSB CHI97LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Burlington, WIthe deer which contacted the airplane.Aug 16, 1997 · N7016Y · Substantial damage NTSB CHI96LA263Accident · Minor injuriesLimited investigationFinal reportRockwell S-2D · Bancroft, WIthe pilot's inadequate compensation for wind conditions and failure to maintain directional control, which resulted in a ground swerve, encounter with soft/sandy terrain, and a subsequent noseover. Factors relating to the accident were: the pilot's selection…Jul 31, 1996 · N1768S · Substantial damage NTSB CHI94LA176Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Bancroft, WIthe pilots failure to select carburetor heat during an extended descent, which resulted in loss of engine power. Factors were carburetor icing conditions and the presence of a ditch at the forced landing site.May 25, 1994 · N1659S · Substantial damage NTSB CHI94LA148Accident · Minor injuriesLimited investigationFinal reportNorth American T-6G · Prairie Du Sac, WIinadequate compensation for wind conditions which resulted in a failure to maintain directional control. Factors associated with the accident were the crosswind conditions and the soft terrain.May 5, 1994 · N3715G · Substantial damage NTSB CHI89DEP10Accident · 1 fatalFinal reportAir Tractor AT-301 · Plainfield, WIFailure of the pilot-in-command to maintain control of the aircraft while conducting aerial application maneuvers in close proximity to the terrain.Aug 1, 1989 · N5044S · Destroyed NTSB CHI83FA069Accident · 2 fatalField investigationFinal reportNorth American T-6G · Genoa City, WIPrior to the accident the acft flew over the arpt at tree-top level with the gear retracted. The acft then landed. After spending about 15 min on the ground the plts took off to the west. The gear was retracted immediately after takeoff & the acft remained…Jan 2, 1983 · N3168G · Destroyed NTSB CHI81FEP34Accident · No injuriesClosedSikorsky HRS-1 · Rosedale, WIJul 2, 1981 · N4782S · Destroyed NTSB CHI77FEP41Accident · No injuriesClosedSnow S2C · Nekoosa, WIJun 25, 1977 · N1670S · Substantial damage NTSB CHI74DEP51Accident · No injuriesClosedHoward DGA15P · Franklin, WIMay 19, 1974 · N9887H · Substantial damage NTSB CHI66F0480Accident · No injuriesClosedPiper PA-28 · Milwaukee, WIOct 17, 1965 · N7326W · 2 aircraft · Substantial damage NTSB CHI66F0047Accident · Minor injuriesClosedNo American SNJ-5 · Hales Corner, WIJun 28, 1965 · N3262G · Substantial damage