NTSB investigations: Pratt & Whitney R1340 series, 1988

5 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “Loss of engine power”. 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, 1988 per year, 1982–2026: 126 cases
198210
19833
19842
19856
19864
19875
19885
19897
19902
19912
19922
19933
19947
19954
19963
19973
19987
19996
20004
20018
20026
20035
20045
20057
20064
20076

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\") = 1988
    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\" = 350))
  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 MKC88LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Elaine, ARDuring an aerial application operation, the pilot said that immediately after breaking ground on takeoff, the engine quit. He attempted to re-land on the remaining available runway, but ran off the end, hitting a ditch and nosing over. Cause of the engine…Aug 22, 1988 · N6661Q · Substantial damageNTSB FTW88DRD17Accident · No injuriesFinal reportSchweizer G-164A · Mangham, LAThe ag airplane was spraying cotton when the engine started to vibrate. Pilot pulled airplane up and vibration was so bad power had to be reduced. Pilot made a forced landing in a muddy field. The left wing caught in tall grass and airplane cartwheeled. Pilot…Aug 14, 1988 · N7234 · Substantial damageNTSB MKC88LA141Accident · No injuriesLimited investigationFinal reportRockwell S2R · O'Kean, ARWhile performing an aerial application operation, the plt said he experienced a total powerplant failure. He attempted an emergency ldg in a cultivated rice field. During the ldg attempt, the aircraft sustained substantial damage to the propeller, landing…Jul 28, 1988 · N3665X · Substantial damageNTSB MKC88LA131Accident · No injuriesLimited investigationFinal reportRockwell S2R · Swifton, ARThe PIC was conducting ag-spray maneuvers dispensing liquid fertilizer to rice. During a procedure turn to return to the field the eng quit. The PIC chose an open field abt 60 degrees to his rt to land the aircraft. The field was wet, soft and rough. The acft…Jul 18, 1988 · N8441V · Substantial damageNTSB FTW88DRG07Accident · No injuriesFinal reportGrumman G-164A · Alamo, TXThe pilot experienced a total loss of engine power during climb when he made his initial power reduction. The power loss was accompanied by a loud bang. A severe postaccident ground fire melted a large portion of the engine. A partial engine teardown was…Feb 26, 1988 · N4647 · Destroyed