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 DEN67A0070Accident · No injuriesClosedKaman H43-A · Lander, WYMay 17, 1967 · N2856J · Substantial damage NTSB MKC67D0576Accident · No injuriesClosedBoeing A75N1 · Sedalia, MOMay 9, 1967 · N61673 · Substantial damage NTSB FTW67F0567Accident · No injuriesClosedBoeing E75 · Nome, TXApr 24, 1967 · N1682M · 2 aircraft · Substantial damage NTSB OAK67D0297Accident · No injuriesClosedN.American AT-6 · Las Vegas, NVApr 11, 1967 · N7034C · Substantial damage NTSB FTW67F0522Accident · No injuriesClosedBoeing A75N1 · Billings, MTMar 21, 1967 · N59137 · Substantial damage NTSB OAK67D0226Accident · No injuriesClosedBoeing E75N1 · Sonora, CAFeb 13, 1967 · N5051V · Substantial damage NTSB ANC67A0053Accident · No injuriesClosedDehaviland DHC-3 · Anchorage, AKJan 17, 1967 · N98T · Substantial damage NTSB CHI67F0416Accident · No injuriesClosedHoward DGA-15 · Xenia, OHJan 2, 1967 · N9887H · Substantial damage NTSB LAX67F0230Accident · No injuriesClosedN.American SNJ-6 · Shafter, CADec 7, 1966 · N611F · Substantial damage NTSB MIA67F0307Accident · No injuriesClosedN.American SNJ-5 · Picayune, MSNov 26, 1966 · N7987C · Substantial damage NTSB MIA67F0329Accident · Serious injuriesClosedBoeing A75 · Florida City, FLNov 15, 1966 · N58226 · Substantial damage NTSB OAK67D0093Accident · Minor injuriesClosedBoeing A75 · Gustine, CASep 2, 1966 · N5041V · Substantial damage NTSB FTW67F0233Accident · No injuriesClosedSnow 600S2C · Bay, ARAug 29, 1966 · N1670S · Substantial damage NTSB FTW67A0013Accident · 1 fatalClosedN.American SNJ-5 · Waxahachie, TXJul 18, 1966 · N7991C · Destroyed NTSB CHI67F0072Accident · No injuriesClosedN.American SNJ-5 · Blue Ash, OHJul 9, 1966 · N3645F · Substantial damage NTSB DEN67F0024Accident · No injuriesClosedN American AT-6 · Delta, UTJul 5, 1966 · N3326G · Substantial damage NTSB ANC66A0052Accident · No injuriesClosedSikorsky S55 · Kenai, AKJun 29, 1966 · N874 · Substantial damage NTSB FTW67F0324Accident · No injuriesClosedBoeing E75 · Kapaln, LAJun 28, 1966 · N4593N · Substantial damage NTSB FTW67D0034Accident · Minor injuriesClosedBoeing E75N1 · Nome, TXJun 6, 1966 · N4566N · Substantial damage NTSB SEA66D0280Accident · No injuriesClosedN American T-6G · Hogeland, MTMay 21, 1966 · N3172G · Substantial damage NTSB MIA66D0545Accident · No injuriesClosedN. American SNJ · Batesville, MSMay 5, 1966 · N12377 · Substantial damage NTSB OAK66F0237Accident · No injuriesClosedBoeing A-75N1 · Colusa, CAApr 25, 1966 · N57271 · Substantial damage NTSB OAK66F0274Accident · No injuriesClosedGrumman G-164 · Butte City, CAApr 20, 1966 · N729Y · Substantial damage NTSB OAK66D0225Accident · No injuriesClosedGrumman G-164 · Chico, CAApr 5, 1966 · N716Y · Destroyed NTSB FTW66F0446Accident · No injuriesClosedAlon A2 · Amarillo, TXDec 6, 1965 · N6572Q · 2 aircraft · Substantial damage NTSB DEN66F0174Accident · Minor injuriesClosedNaval Arcft N3N-3 · Sun City, AZNov 4, 1965 · N44757 · Substantial damage NTSB CHI66F0480Accident · No injuriesClosedPiper PA-28 · Milwaukee, WIOct 17, 1965 · N7326W · 2 aircraft · Substantial damage NTSB NYC66F0258Accident · No injuriesClosedNo American AT-6 · Newcomb, NYSep 4, 1965 · N3646F · Substantial damage NTSB NYC66F0166Accident · No injuriesClosedNo American SNJ-5 · Monroeville, PAAug 14, 1965 · N9813C · Substantial damage NTSB FTW66F0189Accident · No injuriesClosedSnow S2C · Garwood, TXAug 2, 1965 · N1672S · Substantial damage NTSB LAX66D0059Accident · No injuriesClosedNo American AT-6C · San Diego, CAJul 27, 1965 · N7062C · Substantial damage NTSB CHI66F0047Accident · Minor injuriesClosedNo American SNJ-5 · Hales Corner, WIJun 28, 1965 · N3262G · Substantial damage NTSB ANC66F0005Accident · No injuriesClosedAmerican 100B · Dry Bay, AKJun 24, 1965 · N709Y · Substantial damage NTSB OAK65F0079Accident · No injuriesClosedBoeing D-75 · Maxwell, CAJun 10, 1965 · N56747 · Substantial damage NTSB DEN65A0076Accident · No injuriesClosedBoeing A-75N1 · Broomfield, COMay 31, 1965 · N64991 · No damage NTSB FTW66F0085Accident · No injuriesClosedSnow S2C · Garwood, TXMay 29, 1965 · N1682S · Substantial damage NTSB OAK66F0080Accident · No injuriesClosedSnow S2C · Nelson, CAMay 13, 1965 · N1681S · Substantial damage NTSB FTW66D0024Accident · No injuriesClosedGrumman G-164 · Esterwood, LAMay 6, 1965 · N520Y · Substantial damage NTSB OAK65D0081Accident · No injuriesClosedBoeing A-75N1 · Williams, CAMay 4, 1965 · N68467 · Substantial damage NTSB FTW66F0017Accident · No injuriesClosedBoeing A75-N1 · San Saba, TXMar 31, 1965 · N62167 · Substantial damage NTSB NYC65F0124Accident · No injuriesClosedNorth Ameri SNJ-5 · Wilmington, DEJan 31, 1965 · N3673F · Substantial damage NTSB UNK65X0879Accident · No injuriesClosedBoeing A-75 · Homestead, FLNov 29, 1964 · N50164 · 2 aircraft · Substantial damage NTSB UNK65X0222Accident · No injuriesClosedSnow S2C600 · Ropesville, TXOct 10, 1964 · N1607S · Substantial damage NTSB UNK64X3353Accident · No injuriesClosedBoeing A75N1 · Waseca, MNAug 13, 1964 · N64514 · Substantial damage NTSB UNK64X3241Accident · No injuriesClosedBoeing A75 · Dos Palos, CAAug 6, 1964 · N68406 · Substantial damage NTSB UNK64X3213Accident · Minor injuriesClosedGrumman G164 · Alpaugh, CAAug 4, 1964 · N716Y · Destroyed NTSB UNK64X2873Accident · No injuriesClosedBoeing A75 · Webb, MSJul 17, 1964 · N51420 · Substantial damage NTSB UNK64X2854Accident · Minor injuriesClosedBoeing E75N1 · Hosston, LAJul 16, 1964 · N5945V · Substantial damage NTSB UNK64X2604Accident · No injuriesClosedGrumman G164 · Firebaugh, CAJul 2, 1964 · N657Y · Destroyed NTSB UNK64X2205Accident · No injuriesClosedGrumman G164 · Bakersfield, CAJun 9, 1964 · N657Y · Substantial damage