NTSB investigations: Pratt & Whitney R1340 series, 1991

6 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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

19822026
NTSB investigations: Pratt & Whitney R1340 series, 1991 per year, 1982–2026: 115 cases
19825
198310
19848
19855
19862
19873
19885
19896
19909
19916
19926
19934
19946
199510
19965
19971
19982
19991
20005
20014
20023
20032
20043
20053
20071

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\") = 1991
    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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351))
  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 MIA91LA219Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Sumner, MSFailure of the no. 1 cylinder assembly.Sep 16, 1991 · N1004W · Substantial damageNTSB LAX91LA364Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wasco, CAA total loss of engine power due to a fracture of the camshaft and the subsequent forced landing into a soft field.Aug 12, 1991 · N4663 · Substantial damageNTSB SEA91LA136Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wilson Creek, WAThe loss of engine power in flight due to improper overhaul of the carburetor float assembly fulcrum screw, shutting off fuel flow to the engine.May 27, 1991 · N8407K · Substantial damageNTSB LAX91LA109Accident · No injuriesLimited investigationFinal reportRockwell S2R-600 · Corcoran, CAFailure of the aircraft engine's fuel pump valve assembly bypass.Feb 18, 1991 · N4930X · Substantial damageNTSB ATL91LA059Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Pavo, GAThe failure of the no. 2 exhaust valve and cylinder head, which resulted in a total loss of engine power. A factor in the accident was the collision with a road sign during the forced landing.Feb 18, 1991 · N8770S · Substantial damageNTSB ANC91LA022Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-3 · Nome, AKThe failure of the 1, 2, 6, 7, 8 and 9 piston linkrods which were broken at the master rod attach end. Contributing to the accident was the rough, uneven terrain.Jan 28, 1991 · N212NY · Substantial damage