NTSB investigations: Pratt & Whitney R1340 series, 1994, 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, 1994, 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\") = 1994
    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 LAX94LA327Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Firebaugh, CAthe loss of engine power due to the failure of the number 2 cylinder head. A factor was the dark night conditions which inhibited the pilot's ability to visually detect ground obstructions in the landing area.Aug 19, 1994 · N8843Q · Substantial damageNTSB LAX94LA299Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Live Oak, CAthe improper adjustment of the fuel control unit by contract maintenance personnel.Jul 27, 1994 · N3627Q · Substantial damageNTSB LAX94LA247Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Bakersfield, CAThe in-flight fire due to the spontaneous combustion of sulfur dust and subsequent forced landing. A factor was the high temperature.Jun 11, 1994 · N8507H · Substantial damageNTSB SEA94LA117Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Yuba City, CAAn inadvertent stall/mush after takeoff. The over-weight loading of the aircraft was a factor.May 12, 1994 · N8214S · Substantial damageNTSB LAX94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe pilot's improper use of the brakes.Apr 23, 1994 · N6774K · Substantial damageNTSB LAX94LA133Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Clarksburg, CAThe total failure of the no. 1 cylinder due to fatigue resulting from an improperly adjusted mixture causing detonation. The soft, wet plowed field was a factor in this accident.Feb 23, 1994 · N36265 · Substantial damageNTSB LAX94LA099Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Davis, CAwas that the pilot misjudged the airplane's altitude during the swath run.Jan 20, 1994 · N8649H · Destroyed