Skip to content

NTSB investigations: Pratt & Whitney R1340 series, AL

20 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

19702026

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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 ERA13CA163Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Greenbrier, ALThe pilot’s failure to maintain adequate clearance from trees.Feb 24, 2013 · N7310N · Substantial damage NTSB ERA09CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Bessemer, ALThe pilot's failure to maintain aircraft control while landing with a crosswind.Apr 14, 2009 · N269WB · Substantial damage NTSB ATL07CA018Accident · No injuriesData collectionFinal reportGrumman G-164B · Pine Hill, ALThe pilot's improper fuel management resulting in a total loss of engine power in cruise flight due to fuel exhaustion, subsequent forced landing to non suitable terrain, and an on-ground collision with tree stumps on the landing roll out.Nov 9, 2006 · N962QC · Substantial damage NTSB ATL94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Samson, ALThe failure of the aileron torque tube bolt from fatigue, which resulted in an inflight loss of aircraft control and collision with terrain.Jul 18, 1994 · N4242X · Substantial damage NTSB ATL94LA130Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Autaugaville, ALThe pilot's inadequate preflight planning, in that he did not properly evaluate the condition of the runway prior to takeoff, and his failure to abort the takeoff when adequate acceleration was not observed. Factors were the high vegetation (grass) on the…Jul 3, 1994 · N3659D · Substantial damage NTSB ATL93LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Deatsville, ALWas a crack in no.3 cylinder head which resulted in the loss of engine power.Sep 11, 1993 · N36613 · Substantial damage NTSB ATL93LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Atmore, ALThe total failure of the engine supercharger, which resulted in engine stoppage. A factor was the rough terrain at the forced landing site.Jul 23, 1993 · N4824 · Substantial damage NTSB ATL89DKJ03Accident · No injuriesFinal reportGrumman G-164A · Loxley, ALThe loss of engine power due to carburetor ice, and the pilot's improper use of carburetor heat.May 22, 1989 · N8881H · Substantial damage NTSB ATL88LA190Accident · Minor injuriesLimited investigationFinal reportSikorsky S-55C · Coaling, ALThe helo was approaching a helipad for landing after the last aerial application flight of the day when there was a pop and tail rotor control was lost. After several rotations about the vertical axis, the PIC landed the helo hard, collapsing the landing…Jun 7, 1988 · N883 · Substantial damage 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…Jul 30, 1987 · N8881H · Substantial damage NTSB ATL87LA225Accident · Serious injuriesLimited investigationFinal reportNorth American AT-6G · Clanton, ALThe airplane engine loss pwr shortly after takeoff, and the plt turned back toward the arpt. The airplane crashed approx 1200 ft short of the rwy in a clearing. The plt reported that he had departed the arpt with the fuel selector in the 'off' position.Jul 26, 1987 · N5557V · Substantial damage NTSB ATL82DA254Accident · No injuriesFinal reportGrumman G164B · Sampson, ALThe aircraft lost power during a swath run, the pilot attempted to lighten the load but the aircraft collided with a tree. When interviewed the pilot stated that the aircraft was sold for salvage. No examination of the engine was possible but he indicated…Aug 30, 1982 · N6795Q · Destroyed NTSB ATL82DA199Accident · No injuriesFinal reportGrumman G-164A · Wetumpka, ALWhile taxiing onto the runway with a load of insecticide, the left main landing gear strut failed. The failure occurred about 2 inches from the fuselage attach point.Jul 13, 1982 · N7234 · Substantial damage NTSB MIA77DKJ64Accident · Minor injuriesClosedRockwell S2R · Bay Minette, ALAug 6, 1977 · N8942Q · Substantial damage NTSB MIA77FKJ44Accident · No injuriesClosedGrumman G-164A · Centreville, ALJun 1, 1977 · N4824 · Substantial damage NTSB MIA76DKK02Accident · No injuriesClosedGrumman G-164A · Ashford, ALSep 9, 1976 · N9936 · Substantial damage NTSB MIA76FKJ97Accident · 1 fatalClosedAero-Comdr 600S2R · Ashland, ALAug 30, 1976 · N5652X · 2 aircraft · No damage NTSB MIA73DKJ58Accident · No injuriesClosedAero Comdr 600S2C · Camden, ALMay 1, 1973 · N5598X · Substantial damage NTSB MIA72DKJ63Accident · No injuriesClosedAero Comdr Thrush · Pell City, ALMay 23, 1972 · N8974Q · Substantial damage NTSB MIA70DKJ22Accident · No injuriesClosedN American SNJ-4 · Dothan, ALApr 12, 1970 · N6411D · Substantial damage