Skip to content

NTSB investigations: Pratt & Whitney R-985 series

1,867 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 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

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 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 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

Run 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 LAX76IL081Incident · No injuriesClosedGrumman G-21A · Long Beach, CAMay 28, 1976 · N93G · Minor damage NTSB LAX76IL077Incident · No injuriesClosedBeech E18S · San Diego, CAMay 26, 1976 · N342E · Minor damage NTSB FTW76DRA42Accident · No injuriesClosedBeech D18S · Tomball, TXMay 23, 1976 · N80036 · Substantial damage NTSB IAD76FID26Accident · Minor injuriesClosedBoeing A75 · Cape Charles, VAMay 22, 1976 · N54565 · Substantial damage NTSB FTW76DQG67Accident · Serious injuriesClosedBoeing B75N1 · Childress, TXMay 22, 1976 · N65578 · Substantial damage NTSB FTW76DPG50Accident · Minor injuriesClosedGrumman G-164A · Carlisle, ARMay 14, 1976 · N975X · Substantial damage NTSB LAX76DVA60Accident · No injuriesClosedBoeing 75 · Bakersfield, CAMay 3, 1976 · N268N · Substantial damage NTSB CHI76AC058Accident · No injuriesClosedBeech E18 · Kalamazoo, MIApr 30, 1976 · N2510C · Substantial damage NTSB LAX76DVA58Accident · No injuriesClosedGrumman G-164B · Buttonwillow, CAApr 28, 1976 · N31184 · Substantial damage NTSB SEA76DYG45Accident · No injuriesClosedBoeing E75N1 · Kennewick, WAApr 22, 1976 · N58978 · Substantial damage NTSB SEA76DTI23Accident · No injuriesClosedGrumman G-164A · Chester, MTApr 9, 1976 · N5338 · Substantial damage NTSB FTW76FRD34Accident · No injuriesClosedGrumman G-164A · Elton, LAMar 26, 1976 · N8559H · Substantial damage NTSB OAK76DVG55Accident · No injuriesClosedNaval Fcty N3N-3 · Winters, CAMar 16, 1976 · N52568 · Substantial damage NTSB OAK76DVA44Accident · Serious injuriesClosedBoeing A75N1 · Visalia, CAMar 5, 1976 · N49701 · Destroyed NTSB IAD76II060Incident · No injuriesClosedBeech E18S · Asheville, NCMar 4, 1976 · N474E · Minor damage NTSB FTW76DPJ26Accident · Minor injuriesClosedBoeing A75N1 · Eldorado, OKFeb 25, 1976 · N67238 · Destroyed NTSB NYC76FHM20Accident · No injuriesClosedSikorsky S-51 · Perkasie, PAFeb 20, 1976 · N92868 · Substantial damage NTSB LAX76F0015Accident · No injuriesClosedBeech E18S · Bahia De L.A., MexicoFeb 20, 1976 · N342E · Substantial damage NTSB DEN76AD030Accident · No injuriesClosedWeatherly 201B · Two Buttes, COFeb 17, 1976 · N1294W · Substantial damage NTSB MIA76FLD42Accident · No injuriesClosedBeech D18S · Venice, FLFeb 12, 1976 · N19S · Substantial damage NTSB OAK76AP043Accident · 1 fatalClosedBeech H18 · Pacific Ocean (Pacific Ocean)Feb 11, 1976 · N1900G · Destroyed NTSB NYC76AN072Accident · No injuriesClosedBeech E18S · Erie, PAJan 30, 1976 · N43T · Substantial damage NTSB DEN76FQA30Accident · No injuriesClosedBeech TC-45G · El Vado, NMJan 10, 1976 · N9907Z · Destroyed NTSB FTW76FRJ14Accident · No injuriesClosedBeech D18S · Garland City, ARJan 8, 1976 · N947MS · Substantial damage NTSB LAX76DUQ20Accident · Minor injuriesClosedConvair L-13 · San Fernando, CAJan 1, 1976 · N101BH · Substantial damage NTSB NYC76AN061Accident · No injuriesClosedBeech E18S · Boston, MADec 24, 1975 · N911E · Substantial damage NTSB OAK76AP032Accident · No injuriesClosedBeech D18S · Oakland, CADec 8, 1975 · N4861 · Substantial damage NTSB FTW76AF049Accident · No injuriesClosedBeech D18S · Mineral Wells, TXDec 8, 1975 · N629Z · Substantial damage NTSB FTW76FRD22Accident · No injuriesClosedGrumman G-164 · Iowa, LANov 25, 1975 · N11983 · Substantial damage NTSB MIA76DLD29Accident · No injuriesClosedBoeing A75N1 · Lake Placid, FLNov 18, 1975 · N5506A · Substantial damage NTSB IAD76AI025Accident · No injuriesClosedBeech E18S · Lexington, KYNov 17, 1975 · N5611D · Substantial damage NTSB FTW76FPM10Accident · Minor injuriesClosedBoeing A75N1 · Blanco, OKNov 9, 1975 · N62146 · Substantial damage NTSB FTW76AF044Accident · 2 fatalClosedBeech E18S · Missing AircraftOct 28, 1975 · N5657D · Destroyed NTSB MIA76FLD22Accident · Minor injuriesClosedBeech D18S · Cedar Key, FLSep 28, 1975 · N9758 · Substantial damage NTSB ANC76AA032Accident · 8 fatalClosedDehavilland DHC-2 · Kijik, AKSep 12, 1975 · N64392 · Destroyed NTSB OAK76DVG21Accident · No injuriesClosedWeatherly 201A · Davis, CASep 9, 1975 · N1263W · Substantial damage NTSB FTW76FQD06Accident · No injuriesClosedWaco UPF-7 · El Paso, TXSep 6, 1975 · N2369Q · Substantial damage NTSB MIA76AM022Accident · No injuriesClosedBeech D18S · Jacksonville, FLSep 5, 1975 · N80387 · Substantial damage NTSB LAX76FUJ20Accident · No injuriesClosedBeech E18S · Grand Canyon, AZAug 24, 1975 · N203C · Substantial damage NTSB FTW75DPJ06Accident · Minor injuriesClosedGrumman G-164 · Pauls Valley, OKAug 15, 1975 · N957X · Substantial damage NTSB SEA76DYE09Accident · No injuriesClosedDehavilland DHC-2 · Kent, WAAug 14, 1975 · N5162G · Substantial damage NTSB LAX76DUG14Accident · Minor injuriesClosedBoeing A75N1 · Ripley, CAAug 11, 1975 · N4821V · Substantial damage NTSB FTW76DRJ04Accident · No injuriesClosedGrumman G-164A · Rayville, LAAug 11, 1975 · N5256 · Destroyed NTSB CHI76DEP13Accident · Minor injuriesClosedStearman A75N1 · Portage, WIAug 11, 1975 · N55891 · Destroyed NTSB IAD7LDLT02Accident · Minor injuriesClosedGrumman G-164 · Dyersburg, TNAug 8, 1975 · N8506H · Destroyed NTSB SEA76DTI07Accident · No injuriesClosedBoeing A75N1 · Chester, MTAug 5, 1975 · N5600 · Substantial damage NTSB LAX76IL006Accident · No injuriesClosedGrumman G-21 · Long Beach, CAJul 30, 1975 · N324 · Substantial damage NTSB MKC76DCA04Accident · No injuriesClosedGrumman G-164 · Randlees, MOJul 29, 1975 · N602Y · Substantial damage NTSB SEA76DYI08Accident · No injuriesClosedBoeing E75 · Klamath Falls, ORJul 23, 1975 · N4769V · Substantial damage NTSB CHI76DEP06Accident · No injuriesClosedStearman A75N1 · Alma Center, WIJul 22, 1975 · N55898 · Substantial damage