Final NTSB investigations: Pratt & Whitney R-2000 series

12 cases on aircraft whose registry engine model is Pratt & Whitney R-2000 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19682026

Final NTSB investigations: Pratt & Whitney R-2000 series per year, 1968–2026: 12 cases
1968	1
1976	2
1984	1
1995	1
2001	1
2003	1
2005	1
2007	2
2016	1
2020	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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52023')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52023'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52023'))
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 ANC21LA001Accident · No injuriesClass 4 · LimitedFinal reportDouglas C54 · Yakataga, AKThe pilots’ decision to land on a wet, soft runway, which resulted in the loss of braking action upon landing and a subsequent runway overrun and nose landing gear collapse.Oct 10, 2020 · N96358 · Substantial damage NTSB GAA16CA462Accident · No injuriesData collectionFinal reportAir Tractor AT · Hondo, TXThe pilot’s failure to maintain clearance from an antenna atop a tower while maneuvering at a low altitude and the airplane’s subsequent impact with terrain during an attempted off-airport landing.Sep 5, 2016 · N31627 · Substantial damage NTSB DFW07LA152Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400 · Delhi, LAthe pilot's failure to maintain control of the airplane while practicing aerial application turns over a field.Jul 8, 2007 · N3164N · Substantial damage NTSB ANC07LA040Accident · No injuriesLimited investigationFinal reportDouglas DC-4 · McGrath, AKAn undershoot and collision with the runway when the pilot misjudged the distance/altitude during the landing flare/touchdown.May 30, 2007 · N898AT · Substantial damage NTSB DEN05LA106Accident · Serious injuriesLimited investigationFinal reportClarke YAK 3UR 2000 · Heber City, UTloss of engine power due to a leaking carburetor and an inoperative float, and the pilot's failure to maintain aircraft control during the restart attempt. Contributing factors were the sudden engine power surge during the attempted restart, and unsuitable…Jul 9, 2005 · N134US · Substantial damage NTSB LAX03LA063Accident · Serious injuriesLimited investigationFinal reportDavis YAK-3 UR-2000 · Parker, AZfailure of the propeller shaft extension mechanism resulting in a loss of power, and the pilot's failure to attain the proper touchdown point.Jan 10, 2003 · N498SD · Substantial damage NTSB ANC01LA129Accident · Minor injuriesLimited investigationFinal reportde Havilland C-7A · Port Alsworth, AKThe captain's failure to maintain the proper glidepath, and improper short field landing procedures. Factors in the accident were a downdraft, and the captain's inadequate evaluation of the weather conditions.Aug 30, 2001 · N2225C · Substantial damage NTSB LAX95TA304Accident · No injuriesFinal reportDouglas C-54G · Aubeery, CAfailure of the pilot to see and avoid known obstacles along his route of flight. Contributing was the insufficient information given by the pilot in the lead aircraft.Aug 23, 1995 · N2742G · Substantial damage NTSB MIA84LA228Accident · No injuriesLimited investigationFinal reportDouglas C-54 · Ft.Lauderdale, FLThe acft had returned for precautionary landing after #4 engine vibration was noted 10 mins into the flt. Acft landed 4000 lbs over max allowable landing wt. After #4 engine examination the acft was released for flight. An exchangeof pilot in command was made…Aug 14, 1984 · N74183 · Substantial damage NTSB MIA76OM011Accident · No injuriesClosedDouglas C-54B · Grand Turk, TokelauSep 16, 1976 · N88939 · Substantial damage NTSB OAK76IP059Incident · No injuriesClosedDouglas C-54B · Chico, CAJun 28, 1976 · N74183 · Minor damage NTSB MIA68A0092Accident · No injuriesClosedDouglas DC3C · Jacksonville, FLMay 3, 1968 · N88829 · Substantial damage