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

8 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, 1993, 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\") = 1993
    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 LAX94LA063Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Santa Paula, CAwas the failure of the needle valve pin assembly in the airplane's carburetor. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.Dec 3, 1993 · N89014 · Substantial damageNTSB LAX94LA019Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Arvin, CAthe loss of power for undetermined reasons.Oct 19, 1993 · N7501K · Substantial damageNTSB LAX93LA327Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dos Palos, CAThe failure of the master rod which resulted in a complete loss of engine power and subsequent forced landing. The irrigation ditch was a factor in this accident.Aug 18, 1993 · N2330V · Substantial damageNTSB LAX93LA303Accident · No injuriesLimited investigationFinal reportAyres S2R · Stratford, CAThat the pilot misjudged the airplane's altitude. Factors relating to this accident were the pilot's fatigue and the light conditions.Jul 28, 1993 · N4930X · DestroyedNTSB LAX93LA200Accident · 1 fatalLimited investigationFinal reportGrumman 164A · Biggs, CAFailure of the number 2 engine cylinder. A factor related to the accident was the lack of altitude for the pilot to make a successfull forced landing.May 5, 1993 · N5249 · DestroyedNTSB LAX93LA189Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Sacramento, CAfailure of the pilot in command to maintain adequate airspeed during a low altitude maneuvering turn which resulted in an inadvertent stall.Apr 27, 1993 · N8307K · Substantial damageNTSB LAX93LA167Accident · Serious injuriesLimited investigationFinal reportAero Commander ST-R · San Jose, CAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.Apr 7, 1993 · N1783S · DestroyedNTSB LAX93LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lost Hills, CAThe pilot's inability to maintain directional control during the landing roll out due to a binding left brake master cylinder.Jan 22, 1993 · N6654 · Substantial damage