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

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\") = 1965
    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 CHI65F0165Accident · No injuriesClosedHoward DGA-15 · Almont, MIMay 8, 1965 · N1335M · Substantial damageNTSB SEA66D0061Accident · No injuriesClosedBoeing PT-17 · Walla Walla, WAMay 7, 1965 · N4812V · Substantial damageNTSB OAK66F0037Accident · No injuriesClosedBoeing A75N-1 · Williams, CAApr 24, 1965 · N1066N · DestroyedNTSB OAK66F0001Accident · No injuriesClosedGrumman G-164 · Yuba City, CAApr 24, 1965 · N405Y · Substantial damageNTSB MKC66D0052Accident · Minor injuriesClosedBoeing A75N1 · Duenweg, MOApr 24, 1965 · N59209 · Substantial damageNTSB LAX65D0048Accident · Minor injuriesClosedBoeing B-75 · Delano, CAApr 20, 1965 · N64037 · Substantial damageNTSB MKC66F0130Accident · No injuriesClosedHoward DGA-15 · Basehor, KSApr 18, 1965 · N9045H · Substantial damageNTSB CHI65F0099Accident · No injuriesClosedBeechcraft D-18S · Wakeman, OHApr 8, 1965 · N86R · Substantial damageNTSB DEN65D0062Accident · No injuriesClosedBoeing A75N1 · Mesa, AZApr 6, 1965 · N57249 · Substantial damageNTSB NYC65F0223Accident · Minor injuriesClosedBeechcraft D-18S · New Castle, DEApr 2, 1965 · N9910 · Substantial damageNTSB MIA65F0035Accident · No injuriesClosedBeechcraft C45H · San Juan, PRMar 26, 1965 · N494DM · Substantial damageNTSB SEA65F0042Accident · No injuriesClosedBoeing B-75N1 · Ewan, WAMar 19, 1965 · N37194 · Substantial damageNTSB MIA65F0042Accident · No injuriesClosedBoeing PT-13 · Homestead, FLMar 12, 1965 · N7872B · DestroyedNTSB UNK65X1449Accident · No injuriesClosedBeechcraft 65 · Chihuahua, MexicoFeb 23, 1965 · N848Q · Substantial damageNTSB LAX65D0008Accident · No injuriesClosedBoeing A-75 · Wasco, CAFeb 11, 1965 · N5057V · Substantial damageNTSB MIA65S0003Accident · 1 fatalClosedBeechcraft AT-11 · Freeport, Burkina FasoFeb 2, 1965 · N52933 · DestroyedNTSB UNK65X1344Accident · No injuriesClosedBeechraft C45H · Sacramento, CAJan 24, 1965 · N9660C · Substantial damageNTSB CHI65F0022Accident · No injuriesClosedBeechraft AT11 · Wheeling, ILJan 9, 1965 · N107RS · Substantial damage