NTSB investigations: Pratt & Whitney R-985 series, TX

7 cases on aircraft whose registry engine model is Pratt & Whitney R-985 series, where the first occurrence was “In flight collision with object”. 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

19822026

NTSB investigations: Pratt & Whitney R-985 series, TX per year, 1982–2026: 7 cases
1982	3
1993	1
1997	1
2004	1
2005	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" = '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') 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" = 220)) 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\" = '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')
      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\" = 220))
  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')
    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" = 220))
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 DFW05LA138Accident · 1 fatalLimited investigationFinal reportStearman D75 · Taylor, TXThe pilot's failure to maintain clearance from an unmarked transmission line. A contributing factor was low altitude selected by the pilot.May 28, 2005 · N56259 · Substantial damage NTSB FTW04LA157Accident · No injuriesLimited investigationFinal reportSnow S2C · La Feria, TXThe pilot's failure to maintain clearance from the obstacle while maneuvering to perform an aerial application. A contributing factor was the high vegetation.Jun 5, 2004 · N9492R · Substantial damage NTSB FTW98FA028Accident · 1 fatalField investigationFinal reportWeatherly 620B · Cee Vee, TXThe pilot's failure to maintain clearance with the power lines during an aerial application flight.Oct 22, 1997 · N46278 · Destroyed NTSB FTW93LA257Accident · 1 fatalLimited investigationFinal reportBeech C-45H · Fentress, TXInadvertent deployment of the skydiver's reserve parachute for undetermined reasons.Sep 5, 1993 · N125MB · Minor damage 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.Apr 27, 1982 · N1774B · Destroyed 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.Mar 8, 1982 · N700W · Substantial damage 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…Feb 26, 1982 · N8517Z · Substantial damage