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.
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" 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 SEA73DYI14Accident · No injuriesClosedBoeing E75 · Klamath Fall, ORNTSB OAK73FVA57Accident · 1 fatalClosedBoeing A75 · Reedley, CANTSB FTW73FPG47Accident · No injuriesClosedGrumman G-164A · Dewitt, ARNTSB LAX73DUA55Accident · No injuriesClosedBoeing B75N1 · Delano, CANTSB FTW73FRA24Accident · Minor injuriesClosedBeech C18S · Cleveland, TXNTSB OAK73DVG60Accident · No injuriesClosedNaval Fcty N3N · Nelson, CANTSB FTW73FPJ15Accident · No injuriesClosedBoeing B75N1 · El Reno, OKNTSB LAX73FUQ27Accident · No injuriesClosedNaval Fcty N3N-3 · Acton, CANTSB CHI73DE135Accident · No injuriesClosedGrumman G-164A · Kent, OHNTSB OAK73AP026Accident · No injuriesClosedBeech D18S · Oakland, CANTSB LAX73DUJ58Accident · No injuriesClosedBeech C-45 · Portal, AZNTSB FTW73DRJ28Accident · No injuriesClosedBoeing A75 · Mangham, LANTSB FTW73DPJ10Accident · No injuriesClosedBoeing E75 · Hollis, OKNTSB ANC73AA042Accident · No injuriesClosedDehavilland DHC-2 · Sitka, AKNTSB FTW73DOG31Accident · No injuriesClosedBoeing B75N1 · Stratford, TXNTSB NYC73FIA11Accident · Minor injuriesClosedHoward DGA15P · Hartwood, VANTSB OAK73AP023Accident · No injuriesClosedBeech D18S · Fresno, CANTSB MIA73AM075Accident · No injuriesClosedGrumman G-21A · Fredericksted (Atlantic Ocean)