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

19 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, 1973, 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\") = 1973
    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 OAK74DVA38Accident · No injuriesClosedBoeing A75N1 · Hanford, CADec 17, 1973 · N4768V · Substantial damageNTSB OAK74DVA33Accident · No injuriesClosedBoeing A75 · Hickman, CANov 15, 1973 · N56416 · Substantial damageNTSB OAK74AVA31Accident · No injuriesClosedSnow S2C · Tulare, CANov 1, 1973 · N9477R · Substantial damageNTSB OAK74FVA20Accident · 1 fatalClosedVultee BT-13A · Madera, CASep 29, 1973 · N67579 · DestroyedNTSB OAK74DVA13Accident · No injuriesClosedBoeing A75-N1 · Porterville, CAAug 18, 1973 · N7740C · Substantial damageNTSB LAX74AL016Accident · No injuriesClosedBeech C-45H · Los Angeles, CAAug 17, 1973 · N281H · Substantial damageNTSB OAK74DVA11Accident · No injuriesClosedBoeing A75 · Fresno, CAAug 7, 1973 · N56533 · Substantial damageNTSB OAK74DVA09Accident · No injuriesClosedBoeing A75N1 · Woodlake, CAAug 2, 1973 · N2852D · Substantial damageNTSB OAK74DVA08Accident · Minor injuriesClosedBoeing 75 · Mendota, CAJul 25, 1973 · N68401 · Substantial damageNTSB OAK74FVA07Accident · Minor injuriesClosedBoeing A75 · Tranquility, CAJul 23, 1973 · N5003V · Substantial damageNTSB OAK74FVA04Accident · 1 fatalClosedBoeing A75 · Hickman, CAJul 6, 1973 · N1137N · Substantial damageNTSB LAX73DUG63Accident · No injuriesClosedBeech D18S · Perris, CAJun 9, 1973 · N165WP · Substantial damageNTSB OAK73DVA63Accident · Minor injuriesClosedBoeing A75N1 · Kingsburg, CAJun 5, 1973 · N1359N · Substantial damageNTSB OAK73FVA57Accident · 1 fatalClosedBoeing A75 · Reedley, CAMay 21, 1973 · N68448 · DestroyedNTSB LAX73DUA55Accident · No injuriesClosedBoeing B75N1 · Delano, CAMay 9, 1973 · N64037 · Substantial damageNTSB OAK73DVG60Accident · No injuriesClosedNaval Fcty N3N · Nelson, CAApr 24, 1973 · N45307 · Substantial damageNTSB LAX73FUQ27Accident · No injuriesClosedNaval Fcty N3N-3 · Acton, CAMar 30, 1973 · N9611 · Substantial damageNTSB OAK73AP026Accident · No injuriesClosedBeech D18S · Oakland, CAMar 14, 1973 · N118L · Substantial damageNTSB OAK73AP023Accident · No injuriesClosedBeech D18S · Fresno, CAJan 17, 1973 · N118L · Substantial damage