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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI65F0165Accident · No injuriesClosedHoward DGA-15 · Almont, MINTSB SEA66D0061Accident · No injuriesClosedBoeing PT-17 · Walla Walla, WANTSB OAK66F0037Accident · No injuriesClosedBoeing A75N-1 · Williams, CANTSB OAK66F0001Accident · No injuriesClosedGrumman G-164 · Yuba City, CANTSB MKC66D0052Accident · Minor injuriesClosedBoeing A75N1 · Duenweg, MONTSB LAX65D0048Accident · Minor injuriesClosedBoeing B-75 · Delano, CANTSB MKC66F0130Accident · No injuriesClosedHoward DGA-15 · Basehor, KSNTSB CHI65F0099Accident · No injuriesClosedBeechcraft D-18S · Wakeman, OHNTSB DEN65D0062Accident · No injuriesClosedBoeing A75N1 · Mesa, AZNTSB NYC65F0223Accident · Minor injuriesClosedBeechcraft D-18S · New Castle, DENTSB MIA65F0035Accident · No injuriesClosedBeechcraft C45H · San Juan, PRNTSB SEA65F0042Accident · No injuriesClosedBoeing B-75N1 · Ewan, WANTSB MIA65F0042Accident · No injuriesClosedBoeing PT-13 · Homestead, FLNTSB UNK65X1449Accident · No injuriesClosedBeechcraft 65 · Chihuahua, MexicoNTSB LAX65D0008Accident · No injuriesClosedBoeing A-75 · Wasco, CANTSB MIA65S0003Accident · 1 fatalClosedBeechcraft AT-11 · Freeport, Burkina FasoNTSB UNK65X1344Accident · No injuriesClosedBeechraft C45H · Sacramento, CANTSB CHI65F0022Accident · No injuriesClosedBeechraft AT11 · Wheeling, IL