NTSB investigations: Pratt & Whitney R-985 series, 2002, AK

4 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 per year

19622026
NTSB investigations: Pratt & Whitney R-985 series, 2002, AK per year, 1962–2026: 175 cases
19621
19631
19642
19651
19662
19671
19681
19691
19702
19711
19732
19741
19753
19763
19774
19781
19792
19806
19816
19823
19832
19842
19852
19861
19873
19882
19894
19905
19915
19921
19934
19943
19952
19962
19972
19984
19991
20003
20013
20024
20033
20043
20054
20062
20074
20084
20093
20105
20112
20126
20134
20151
20161
20172
20186
20195
20201
20212
20224
20235
20245
20253
20261

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\") = 2002
    AND c.\"eventStateOrRegion\" = 'AK' 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.