NTSB investigations: Pratt & Whitney R-985 series, 1968, CA

13 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, 1968, CA per year, 1962–2026: 310 cases
19621
196416
196516
196616
196718
196813
196915
197010
197110
19727
197319
197423
197510
197611
197711
197810
19798
19804
19818
19827
19834
19843
19853
19863
19875
19882
19893
19902
19917
19922
19933
19943
19952
19962
19973
20002
20021
20033
20042
20051
20061
20071
20081
20092
20102
20111
20122
20144
20161
20171
20201
20212
20231
20241

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\") = 1968
    AND 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 ('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.

NTSB LAX69A0034Accident · No injuriesClosedBeech E18S · Los Angeles, CADec 20, 1968 · N25X · Substantial damageNTSB OAK69D0190Accident · No injuriesClosedStearman A75N1 · Paso Robles, CANov 22, 1968 · N7783C · Substantial damageNTSB OAK69D0157Accident · Minor injuriesClosedStearman 75 · Mariposa, CAOct 3, 1968 · N68447 · Substantial damageNTSB LAX69D0151Accident · No injuriesClosedBoeing 75 · Old River, CASep 23, 1968 · N5600 · Substantial damageNTSB LAX69D0100Accident · Minor injuriesClosedBoeing E75 · Ripley, CAAug 31, 1968 · N67912 · Substantial damageNTSB LAX69D0119Accident · No injuriesClosedBoeing A-75 · Wheeler Ridge, CAAug 25, 1968 · N263N · Substantial damageNTSB LAX69F0084Accident · No injuriesClosedNaval Fcty N3N-1 · Calipatria, CAAug 14, 1968 · N44922 · Substantial damageNTSB OAK69D0096Accident · No injuriesClosedBoeing B75N1 · Woodlake, CAAug 10, 1968 · N2803D · Substantial damageNTSB LAX69D0104Accident · No injuriesClosedHoward DGA15P · Rosamond, CAJul 23, 1968 · N67191 · Substantial damageNTSB OAK69A0003Accident · Minor injuriesClosedPiper PA-25 · Crows Lndng, CAJul 16, 1968 · N4574Y · 2 aircraft · DestroyedNTSB LAX69D0057Accident · No injuriesClosedBensen B-8M · Shafter, CAJul 14, 1968 · N1585 · 2 aircraft · Substantial damageNTSB OAK68F0345Accident · Serious injuriesClosedNaval Fcty N3N-3 · Oakley, CAMar 28, 1968 · N45011 · DestroyedNTSB LAX68F0371Accident · Minor injuriesClosedGrumman G-164 · Lancaster, CAMar 20, 1968 · N10211 · Destroyed