NTSB investigations: Pratt & Whitney R1340 series, 1989, CA

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

Cases per year

19642026
NTSB investigations: Pratt & Whitney R1340 series, 1989, CA per year, 1964–2026: 279 cases
19646
19654
19665
19677
19681
19692
19713
19724
19733
19746
19754
197611
19779
197816
19799
198011
198115
19825
19838
19844
19852
19863
19876
19886
19897
19905
19914
19925
19938
19947
19956
19963
19973
19986
19993
20005
20011
20025
20032
20045
20051
20063
20071
20082
20093
20105
20115
20122
20131
20142
20153
20162
20175
20183
20194
20202
20213
20232
20244
20251

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 1989
    AND c.\"eventStateOrRegion\" = 'CA' 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.

NTSB LAX90DVG02Accident · No injuriesFinal reportSchweizer G-164B · Knights Landing, CAThe failure of the right main Landing gear due to a sheared bolt that attached the spring leg to the gear.Nov 18, 1989 · N6977K · Substantial damageNTSB LAX90LA004Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pacoima, CAThe pilot's misjudgement of the proper altitude and distance from the runway during a night approach.Oct 3, 1989 · N12377 · Substantial damageNTSB LAX89DUG09Accident · No injuriesFinal reportAir Tractor AT-301A · Blythe, CAThe pilot's failure to verify the fuel supply prior to takeoff.Sep 22, 1989 · N3654N · Substantial damageNTSB LAX89DVA09Accident · No injuriesFinal reportAero Commander S2R · Tranquillity, CAThe pilot's visual look-out was inadequate and that he failed to see the high vegetation upon landing. Factors relating to this accident are dark night and high vegetation.Aug 11, 1989 · N4072X · Substantial damageNTSB LAX89DVG07Accident · No injuriesFinal reportSchweizer G-164B · Willows, CAFailure of the connecting rod on #1 cylinder of the aircraft powerplant.Jul 4, 1989 · N3627G · Substantial damageNTSB LAX89DVG06Accident · No injuriesFinal reportGrumman G-164B · Davis, CAThe pilot failed to properly use his brakes during the off airport landing.May 14, 1989 · N3629Y · Substantial damageNTSB LAX89LA114Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6 · Compton, CAFatigue cracks that existed in an engine cylinder.Feb 23, 1989 · N6972C · Substantial damage