Skip to content

NTSB investigations: Pratt & Whitney R1340 series, NV

15 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

19672026

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" = 'NV' 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\" = 'NV' 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" = 'NV' 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 WPR23FA345Accident · 2 fatalClass 3 · FieldFinal reportNorth American T-6G · Reno, NVThe failure of both the Race 14 and Race 6 pilots to see and avoid each other while in the airport traffic pattern. Contributing to the accident was both pilots’ failure to fly the standard downwind and base legs.Sep 17, 2023 · N2897G · 2 aircraft · Substantial damage NTSB WPR10CA052Accident · No injuriesData collectionFinal reportNorth American T6-G · Carson City, NVThe pilot's failure to maintain directional control during landing.Nov 8, 2009 · N48N · Substantial damage NTSB WPR09LA457Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ely, NVThe pilot's failure to maintain directional control during the landing roll.Jul 28, 2009 · N555Q · Substantial damage NTSB WPR09LA270Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Yerington, NVThe pilot's failure to maintain aircraft control while maneuvering during an aerial application flight.Jun 18, 2009 · N9723 · Substantial damage NTSB LAX02LA034Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401B · Las Vegas, NVthe failure of the AT-401 pilot to maintain clearance with the AT-402 airplane during landing. Contributing factors were the unreliable communication radio in the AT-401, the AT-401 pilot's continued flight with known communication radio problems, and the…Nov 30, 2001 · N9186J · 2 aircraft · No damage NTSB LAX00LA105Accident · Minor injuriesLimited investigationFinal reportAyres · Elko, NVthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing forced landing.Feb 18, 2000 · N4011Y · Substantial damage NTSB LAX94LA368Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · Reno, NVthat the pilot of the other airplane misjudged the distance between the airplanes. The other airplane pilot's diverted attention to the air race is a factor in this accident.Sep 18, 1994 · N8540Z · 2 aircraft · Destroyed NTSB LAX91LA392Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Reno, NVThe failure of the pilot to maintain an adequate clearance between the aircraft and the ground while maneuvering around a pylon, which resulted in a loss of control during landing.Sep 12, 1991 · N29931 · Substantial damage NTSB SEA86LA243Accident · 1 fatalLimited investigationFinal reportGrumman G164A-450 · Orovado, NVPower lines were inadvertently struck in flight while maneuvering during aerial application. After striking the power lines the aircraft descended to the ground where a fire erupted and the aircraft was then destroyed by fire.Sep 12, 1986 · N8025K · Destroyed NTSB LAX85IA396Incident · No injuriesIncident investigationFinal reportNorth American SNJ-4 · Reno, NVThe pilot experienced a 'severe vibration' and made an emergency landing during a heat race at the national championship air races. Subsequent examination revealed that a propeller blade pitch change bolt, p/n 53546, had failed, allowing one propeller blade…Sep 12, 1985 · N86WW · Minor damage NTSB OAK78DA055Accident · 2 fatalClosedN.American SNJ-4 · Reno, NVSep 16, 1978 · N7038C · 2 aircraft · Destroyed NTSB OAK76FXQ15Accident · 1 fatalClosedStearman PT-17 · Reno, NVSep 12, 1975 · N121R · Minor damage NTSB OAK75DXQ11Accident · No injuriesClosedSnow 600S2D · Orovada, NVJul 28, 1974 · N1725S · Substantial damage NTSB OAK74FXQ38Accident · No injuriesClosedGrumman G-164 · Fallon, NVMay 14, 1974 · N6538 · Substantial damage NTSB OAK67D0297Accident · No injuriesClosedN.American AT-6 · Las Vegas, NVApr 11, 1967 · N7034C · Substantial damage