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

68 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 year(c.\"eventDate\") = 1973
    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 SEA73DYI14Accident · No injuriesClosedBoeing E75 · Klamath Fall, ORMay 24, 1973 · N4742V · Substantial damageNTSB OAK73FVA57Accident · 1 fatalClosedBoeing A75 · Reedley, CAMay 21, 1973 · N68448 · DestroyedNTSB FTW73FPG47Accident · No injuriesClosedGrumman G-164A · Dewitt, ARMay 14, 1973 · N930X · Substantial damageNTSB LAX73DUA55Accident · No injuriesClosedBoeing B75N1 · Delano, CAMay 9, 1973 · N64037 · Substantial damageNTSB FTW73FRA24Accident · Minor injuriesClosedBeech C18S · Cleveland, TXApr 28, 1973 · N6417C · Substantial damageNTSB OAK73DVG60Accident · No injuriesClosedNaval Fcty N3N · Nelson, CAApr 24, 1973 · N45307 · Substantial damageNTSB FTW73FPJ15Accident · No injuriesClosedBoeing B75N1 · El Reno, OKApr 20, 1973 · N5080N · Substantial damageNTSB LAX73FUQ27Accident · No injuriesClosedNaval Fcty N3N-3 · Acton, CAMar 30, 1973 · N9611 · Substantial damageNTSB CHI73DE135Accident · No injuriesClosedGrumman G-164A · Kent, OHMar 20, 1973 · N4369 · DestroyedNTSB OAK73AP026Accident · No injuriesClosedBeech D18S · Oakland, CAMar 14, 1973 · N118L · Substantial damageNTSB LAX73DUJ58Accident · No injuriesClosedBeech C-45 · Portal, AZMar 12, 1973 · N72Q · Substantial damageNTSB FTW73DRJ28Accident · No injuriesClosedBoeing A75 · Mangham, LAMar 7, 1973 · N49954 · Substantial damageNTSB FTW73DPJ10Accident · No injuriesClosedBoeing E75 · Hollis, OKMar 6, 1973 · N5191N · Substantial damageNTSB ANC73AA042Accident · No injuriesClosedDehavilland DHC-2 · Sitka, AKFeb 28, 1973 · N616W · Substantial damageNTSB FTW73DOG31Accident · No injuriesClosedBoeing B75N1 · Stratford, TXFeb 23, 1973 · N75937 · Substantial damageNTSB NYC73FIA11Accident · Minor injuriesClosedHoward DGA15P · Hartwood, VAFeb 4, 1973 · N79530 · DestroyedNTSB OAK73AP023Accident · No injuriesClosedBeech D18S · Fresno, CAJan 17, 1973 · N118L · Substantial damageNTSB MIA73AM075Accident · No injuriesClosedGrumman G-21A · Fredericksted (Atlantic Ocean)Jan 12, 1973 · N8777A · Substantial damage