Skip to content

NTSB investigations: Pratt & Whitney R1340 series

1,656 cases on aircraft whose registry engine model is Pratt & Whitney R1340 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 ('52016')) 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 ('52016'))
  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 ('52016'))
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 LAX75DVA04Accident · No injuriesClosedGrumman G-164A · Ducor, CAJul 15, 1974 · N6587 · Substantial damage NTSB SEA75DYA04Accident · No injuriesClosedGrumman G-164A · Burley, IDJul 14, 1974 · N7365 · Substantial damage NTSB ANC75AA004Accident · No injuriesClosedAero Comdr 600S2R · Umiat, AKJul 9, 1974 · N5521X · Substantial damage NTSB FTW75DPG01Accident · No injuriesClosedGrumman G-164A · Walnut Ridge, ARJul 3, 1974 · N7926 · Substantial damage NTSB LAX75DUJ08Accident · No injuriesClosedSnow 600S2C · Poston, AZJul 1, 1974 · N9468R · Substantial damage NTSB OAK74DVA77Accident · Minor injuriesClosedBoeing A75 · Patterson, CAJun 18, 1974 · N5041V · Substantial damage NTSB FTW74DPG71Accident · No injuriesClosedGrumman G-164A · West Memphis, ARJun 11, 1974 · N9678 · Substantial damage NTSB CHI74DEP51Accident · No injuriesClosedHoward DGA15P · Franklin, WIMay 19, 1974 · N9887H · Substantial damage NTSB MIA74DLD87Accident · No injuriesClosedGrumman G-164A · Leesburg, FLMay 18, 1974 · N7986 · Substantial damage NTSB OAK74FXQ38Accident · No injuriesClosedGrumman G-164 · Fallon, NVMay 14, 1974 · N6538 · Substantial damage NTSB FTW74FRD36Accident · No injuriesClosedAero Comdr 600S2R · Rayne, LAMay 12, 1974 · N4072X · Substantial damage NTSB FTW74DRJ29Accident · No injuriesClosedGrumman G-164A · Mer Rouge, LAApr 5, 1974 · N7364 · Substantial damage NTSB CHI74DEV41Accident · No injuriesClosedGrumman G-164A · Ware, ILMar 27, 1974 · N7248 · Substantial damage NTSB FTW74FRA31Accident · 1 fatalClosedGrumman G-164A · Buckeye, TXMar 6, 1974 · N5458 · 2 aircraft · Destroyed NTSB OAK74FVG22Accident · No injuriesClosedGrumman G-164 · Zamora, CAJan 30, 1974 · N7445 · Substantial damage NTSB OAK74DVA39Accident · No injuriesClosedAero Comdr 600S2R · Five Points, CAJan 10, 1974 · N5542X · Substantial damage NTSB LAX74DUJ38Accident · No injuriesClosedGrumman G-164A · Tonopah, AZDec 31, 1973 · N5363 · Substantial damage NTSB FTW74FQG28Accident · Minor injuriesClosedN.American AT-6 · Shallowater, TXNov 17, 1973 · N7000S · Substantial damage NTSB ANC74AA043Accident · No injuriesClosedDehavilland DHC-3 · Eek, AKNov 2, 1973 · N98T · Substantial damage NTSB MKC74DCA11Accident · No injuriesClosedGrumman G-164 · Charleston, MOOct 18, 1973 · N7248 · Substantial damage NTSB FTW74DPG30Accident · No injuriesClosedAero Comdr S-2R · Fisher, AROct 8, 1973 · N5521X · Destroyed NTSB MKC74FCA10Accident · No injuriesClosedGrumman G-164A · Charleston, MOSep 28, 1973 · N6581 · Substantial damage NTSB MIA74FLD26Accident · No injuriesClosedSikorsky S-55 · Duette, FLSep 19, 1973 · N15182 · Substantial damage NTSB FTW74FRD13Accident · No injuriesClosedGrumman G-164A · Indian Village, LASep 17, 1973 · N6609 · Destroyed NTSB FTW74FQG09Accident · No injuriesClosedAero Comdr 600S2R · Dimmitt, TXAug 14, 1973 · N5540X · Substantial damage NTSB MIA74DLD11Accident · No injuriesClosedGrumman G-164A · Zolfo Springs, FLJul 31, 1973 · N4976 · Substantial damage NTSB IAD74FLJ06Accident · 1 fatalClosedN.American AT-6C · Clarkton, NCJul 29, 1973 · N6419D · Substantial damage NTSB FTW74DRG06Accident · No injuriesClosedAero Comdr S2R · Mission, TXJul 21, 1973 · N5510X · Substantial damage NTSB MIA74FLG02Accident · No injuriesClosedGrumman G-164A · Marion, SCJul 20, 1973 · N8497 · Destroyed NTSB NYC74FHJ05Accident · Serious injuriesClosedN.American SNJ-2 · Flushing, NYJul 18, 1973 · N65370 · Substantial damage NTSB FTW74FRA01Accident · No injuriesClosedBoeing A75 · Winnie, TXJul 10, 1973 · N4576N · Substantial damage NTSB SEA74FYA02Accident · Minor injuriesClosedAero Comdr 600S2R · Homedale, IDJul 7, 1973 · N5553X · Substantial damage NTSB NYC74FFA01Accident · Minor injuriesClosedN.American SNJ-4 · East Chatham, NYJul 2, 1973 · N7008C · Substantial damage NTSB OAK73FVG71Accident · No injuriesClosedNaval Fcty N3N-1 · Davis, CAJun 29, 1973 · N7752C · Substantial damage NTSB CHI74FEC41Accident · No injuriesClosedAero Comdr 600S2R · Ottowa Lake, MIJun 29, 1973 · N8870Q · Substantial damage NTSB IAD73FLT21Accident · Minor injuriesClosedGrumman G-164A · Covington, TNJun 28, 1973 · N7964 · Substantial damage NTSB DEN73FTC29Accident · Serious injuriesClosedSnow S2C · Sheridan, WYJun 14, 1973 · N1641S · Destroyed NTSB FTW73DQG41Accident · No injuriesClosedBoeing A75N1 · Guthrie, TXJun 12, 1973 · N62167 · Substantial damage NTSB FTW73DRD35Accident · No injuriesClosedGrumman G-164A · Abbeville, LAJun 4, 1973 · N7839 · Substantial damage NTSB FTW73FRD27Accident · No injuriesClosedBoeing A75 · Crowley, LAMay 12, 1973 · N51440 · Substantial damage NTSB FTW73FRA29Accident · No injuriesClosedBoeing E75 · Nome, TXMay 9, 1973 · N1682M · Substantial damage NTSB MIA73FKT94Accident · No injuriesClosedGrumman G-73 · Miami, FLMay 7, 1973 · N7306 · Substantial damage NTSB MIA73DKJ58Accident · No injuriesClosedAero Comdr 600S2C · Camden, ALMay 1, 1973 · N5598X · Substantial damage NTSB MIA73FKT82Accident · Minor injuriesClosedAero Comdr 600S2R · Ft Myers, FLApr 17, 1973 · N8805Q · Substantial damage NTSB SEA73FYC24Accident · No injuriesClosedKaman K-600 · Pilot Rock, ORApr 11, 1973 · N11012 · Substantial damage NTSB DEN73DQA34Accident · No injuriesClosedGrumman G-164A · Clayton, NMMar 31, 1973 · N4398 · Substantial damage NTSB OAK73DVG54Accident · No injuriesClosedGrumman G-164 · Knights Ldg, CAMar 30, 1973 · N6172U · Substantial damage NTSB MIA73FLD56Accident · No injuriesClosedSikorsky H-19A · Mascotte, FLMar 1, 1973 · N15182 · Substantial damage NTSB LAX73FUG38Accident · No injuriesClosedHarvard MK4 · Rubidoux, CAFeb 25, 1973 · N20425 · Substantial damage NTSB MIA73FLD24Accident · No injuriesClosedGrumman G-164A · Zellwood, FLOct 21, 1972 · N770ZF · Substantial damage