NTSB investigations: Pratt & Whitney R1340 series, CA

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19872026

NTSB investigations: Pratt & Whitney R1340 series, CA per year, 1987–2026: 8 cases
1987	1
1993	1
1995	1
2000	2
2003	1
2004	1
2006	1

Where

Open the map

Latest cases

Query with SQL

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 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') 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

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

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 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')
    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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB LAX06LA280Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Paramount, CAthe loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the landing.Aug 26, 2006 · N111VA · Substantial damage NTSB LAX04LA126Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tracy, CAA loss of engine power for undetermined reasons during cruise flight.Feb 17, 2004 · N6774K · Substantial damage NTSB LAX03LA158Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Willows, CAA loss of engine power for an undetermined reason during an aerial application.May 21, 2003 · N5653X · Substantial damage NTSB LAX00LA199Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Biggs, CAThe broken exhaust valve rocker arm of the number 3 cylinder that resulted in a total loss of engine power during an aerial application flight.May 18, 2000 · N5335 · Substantial damage NTSB LAX00LA162Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Lodi, CAA loss of engine power for undetermined reasons.Apr 20, 2000 · N3629F · Substantial damage NTSB LAX95LA091Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pixley, CAthe total failure of the number three cylinder. The wet and soft terrain were factors in this accident.Feb 1, 1995 · N705Y · Substantial damage NTSB LAX94LA019Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Arvin, CAthe loss of power for undetermined reasons.Oct 19, 1993 · N7501K · Substantial damage NTSB LAX87DVG05Accident · No injuriesFinal reportAero Commander S2R · Gridley, CAOn takeoff from a farmer's field the aircraft's engine lost power. The aircraft was unable to clear a levee, struck the levee and came to rest in a rice field. The aircraft's fuel pump was removed and tested. After one minute of operation the pump pressure…Apr 27, 1987 · N5644X · Substantial damage