NTSB investigations: Pratt & Whitney R-985 series, TX
150 cases on aircraft whose registry engine model is Pratt & Whitney R-985 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, newest first
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 c.\"eventStateOrRegion\" = 'TX' 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 ('52008'))
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" = 'TX' 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 ('52008'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 FTW83LA162Accident · No injuriesLimited investigationFinal reportBeech D-18S · Dfw Airport, TXN80017 experienced engine trouble and shut down the left engine enroute from amarillo, TX. Later, because of electrical problems the pilot secured all electrical equipment except the no. 2 radio, transponder and rotating beacon after landing, the pilot taxied…NTSB FTW82DA277Accident · Serious injuriesFinal reportChampion 7AC · Justin, TXThe aerial application aircraft was returning to land when it collided with another aircraft that was on a straight-in final approach. The pilot of the other aircraft stated that he was below and ahead at about 150 feet AGL when the collision occurred. Both…NTSB FTW82DA211Accident · No injuriesFinal reportBeech D18S · Beeville, TXThe pilot and three passengers departed on a pleasure flight. The pilot stated that after climbing several hundred feet and while at 110 mph, the right propeller went into high pitch following a propeller governor failure. This resulted in a loss of engine…NTSB FTW82DA185Accident · No injuriesFinal reportBoeing A75N1 · Fabens, TXFollowing a left turn on landing roll the pilot applied the brakes to correct for right drift. The braking action resulted in the aircraft nose over. Investigation revealed no mechanical malfunction or failure.NTSB FTW82DA161Accident · Minor injuriesFinal reportBoeing E75 · Sterling City, TXThe pilot stated that he was flying the aircraft from devine, TX to Montana for the owner. He received about a half-hour of dual instruction in the aircraft and then departed. Several en route stops were made. The pilot stated that he checked the fuel…NTSB FTW82FRA19Accident · 1 fatalFinal reportBoeing A75 · Chapell Hill, TXDuring a pull-up from a swath run, the right wing of the aircraft struck the top of a 45 ft pecan tree. The lower right wing tip separated, and the aircraft rolled inverted and crashed.NTSB FTW82DA117Accident · No injuriesFinal reportBeech C-18S · Hereford, TXThe pilot experienced total electrical failure during flight. Before landing he allowed the gear to free fall and attempted to crank it into the fully extended and locked position. When the crank would not turn he assumed the gear was in the locked down…NTSB FTW82DA093Accident · 1 fatalFinal reportBeech C-45H · Mcallen, TXAbout 18 minutes after takeoff, the pilot radioed that the no. 2 engine had lost power and that he was returning to land at Mcallen, TX. While approaching to land, the aircraft crashed in an open field about 400 yards short of the runway and 115 feet right of…NTSB FTW82FRG24Accident · Minor injuriesFinal reportBeech E18S · Charlotte, TXThe aircraft crashed during takeoff from a clearing on a ranch and then was abandoned. The aircraft landing gear struck a concrete trough for watering cattle. Drugs were found on board the aircraft.NTSB FTW82FPA11Accident · No injuriesFinal reportBeech D18S · Dallas, TXDuring a night, ILS approach, the plane struck a powerline about two miles short of the runway after the pilot was provided a low altitude alert. The left engine lost power and was feathered. The pilot feared possible gear damage and left it extended. Unable…NTSB FTW82FQG06Accident · No injuriesClosedBoeing A75N1 · Sweetwater, TXNTSB FTW81FQD26Accident · Minor injuriesClosedBeech D17S · Canutillo, TXNTSB FTW81DRA27Accident · No injuriesClosedGrumman G-164 · Garwood, TXNTSB FTW81DPD17Accident · Minor injuriesClosedGrumman G-164A · Granbury, TXNTSB FTW81DPD14Accident · No injuriesClosedBoeing A75HI · Justin, TXNTSB FTW81DA001Accident · No injuriesClosedBeech 18 · Dallas, TXNTSB FTW80FQG42Accident · Minor injuriesClosedBoeing E-75 · Snyder, TXNTSB FTW80FRA51Accident · No injuriesClosedGrumman G-164A · Winnie, TXNTSB FTW80FA113Accident · No injuriesClosedBeech C-45G · Abilene, TXNTSB FTW80DPA17Accident · No injuriesClosedCnsd Vultee BT-13 · Waco, TXNTSB FTW80DRG07Accident · No injuriesClosedBoeing B75N1 · Crystal City, TXNTSB FTW79DQD12Accident · No injuriesClosedBoeing A75N-1 · El Paso, TXNTSB FTW79DRA29Accident · No injuriesClosedBoeing A-75N1 · Beaumont, TXNTSB FTW79FRG32Accident · Minor injuriesClosedGrumman G-164B · La Feria, TXNTSB FTW79FA015Accident · 1 fatalClosedBeech H18 · Brownsville, TXNTSB FTW79FRG02Accident · No injuriesClosedBeech E18S · Laredo, TXNTSB FTW78FPD27Accident · No injuriesClosedBeech D-17S · Ranger, TXNTSB FTW78FQG41Accident · No injuriesClosedPiper PA-36 · Lubbock, TXNTSB FTW78DRG59Accident · Minor injuriesClosedBeech G18S · Mc Allen, TXNTSB FTW78DRA27Accident · No injuriesClosedGrumman G-164A · Alvin, TXNTSB FTW78FRA20Accident · Serious injuriesClosedGrumman G-164B · La Ward, TXNTSB FTW78FRA19Accident · No injuriesClosedGrumman G-164A · Baytown, TXNTSB FTW77DRG60Accident · No injuriesClosedBeech C-45 · Del Rio, TXNTSB FTW77FRG31Accident · No injuriesClosedBeech C45H · San Benito, TXNTSB FTW77DQG09Accident · No injuriesClosedGrumman G-164B · Springlake, TXNTSB FTW76FPD57Accident · 1 fatalClosedBoeing B75N1 · Goldthwaite, TXNTSB FTW76FQD28Accident · No injuriesClosedBoeing A75N1 · Fabens, TXNTSB FTW76DRG66Accident · No injuriesClosedBoeing A75 · La Feria, TXNTSB FTW76DRA47Accident · No injuriesClosedBoeing A75 · Fresno, TXNTSB FTW76DRA42Accident · No injuriesClosedBeech D18S · Tomball, TXNTSB FTW76DQG67Accident · Serious injuriesClosedBoeing B75N1 · Childress, TXNTSB FTW76AF049Accident · No injuriesClosedBeech D18S · Mineral Wells, TXNTSB FTW76FQD06Accident · No injuriesClosedWaco UPF-7 · El Paso, TXNTSB FTW76AF004Accident · No injuriesClosedBeech G18S · Dallas, TXNTSB FTW75DRA31Accident · No injuriesClosedGrumman G-164A · Garwood, TXNTSB FTW75FRA24Accident · No injuriesClosedBoeing B75N1 · Anahuac, TXNTSB FTW75DRG05Accident · No injuriesClosedGrumman 164-A · San Benito, TXNTSB FTW74DRA46Accident · No injuriesClosedBoeing E75 · Rosharon, TXNTSB FTW74DRG84Accident · No injuriesClosedWeatherly 201 · Pearsall, TXNTSB FTW74AF026Accident · No injuriesClosedBeech E18S · El Paso, TX