Skip to content

NTSB investigations: Pratt & Whitney R1340 series, MO

26 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 per year

19672026

Where

Latest cases

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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' AND 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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND 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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
  AND 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 CEN24LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Andover, MOThe pilot’s inability to maintain altitude and airspeed during cruise flight likely due to a decrease in engine performance associated with the unauthorized use of automobile fuel, which led to an inflight collision with a tree and hard landing.Jun 27, 2024 · N3165C · Substantial damage NTSB CEN16LA222Accident · Serious injuriesLimited investigationFinal reportNorth American AT-6D · Henley, MOThe pilot’s decision to conduct extended inverted flight, which resulted in a total loss of engine power due to fuel flow disruption. Contributing to the accident was his decision to conduct aerobatic maneuvers at low altitude, which precluded him from…Jun 19, 2016 · N150U · Substantial damage NTSB CEN12LA440Accident · 1 fatalLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Darksville, MOThe pilot did not maintain clearance from a tree line at the completion of an agricultural spray run.Jul 13, 2012 · N6846Q · Substantial damage NTSB CEN10CA201Accident · No injuriesData collectionFinal reportGrumman G-164B · Forest City, MOThe pilot's failure to maintain aircraft control during landing, which resulted in an encounter with wet/muddy terrain and a subsequent nose over.Apr 8, 2010 · N993QC · Substantial damage NTSB CEN10CA185Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Malden, MOThe pilot's failure to maintain clearance from a tree during an aerial application flight.Apr 2, 2010 · N3653T · Substantial damage NTSB DFW08LA178Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Stotesbury, MOFracture of the engine's number eight cylinder barrel resulting in a loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.Jul 3, 2008 · N520Y · Destroyed NTSB CHI98LA202Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Risco, MOthe pilot's abrupt application of the brakes. Factors contributing to this accident were the pilot's inadequate preflight preparation, his delayed decision to abort the takeoff, and the soft field.Jun 16, 1998 · N36576 · Substantial damage NTSB CHI96LA119Accident · No injuriesLimited investigationFinal reportAyres S2-R · Wyatt, MOthe pilot's failure to maintain control of the airplane during takeoff. A factor was the crosswind condition.Mar 26, 1996 · N3024V · Substantial damage NTSB CHI95LA265Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Wyatt, MOthe pilot's failure to use carburetor heat which led to carburetor ice. Factors were weather conditions conducive to carburetor icing and the unsuitable terrain encountered during the forced landing.Aug 3, 1995 · N5663X · Substantial damage NTSB CHI95LA247Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Poplar Bluff, MOthe pilot's inadequate preflight/planning preparation. Factors in the accident were: the loss of engine power due to carburetor icing, the wet runway, and the ditch.Jul 26, 1995 · N3655Q · Substantial damage NTSB MKC90LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hornersville, MOFailure of an engine cylinder.Apr 5, 1990 · N1015A · Substantial damage NTSB MKC88LA129Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Baker, MOWitnesses said that shortly after takeoff, the fully loaded acft appeared to be unable to climb out of ground effect. About 1.5 mile from the airstrip, the pilot began a turn back to the north. Unable to climb, he initiated action to dump his chemical load,…Jul 7, 1988 · N6848K · Substantial damage NTSB MKC86LA085Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jackson, MOIn cruise flt the PIC smelled something burning and noticed black and white smoke pouring fm the eng cowling. This was followed by a partial loss of pwr. A precautionary landing was made in a field. The PIC noticed flames erupting fm the eng area after…Apr 11, 1986 · N5564X · Substantial damage NTSB MKC84LA260Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Dexter, MOThe engine on the ag-plane lost power during takeoff and the plt began dumping his load as he made a forced landing. Thelanding area available was a flooded rice levee. The acft was landed tailwheel first but when the main gear dug in, the acft nose over.…Aug 23, 1984 · N31623 · Substantial damage NTSB MKC84LA200Accident · Minor injuriesLimited investigationFinal reportGrumman G164A · Bernie, MODescending out of the procedure turn into a swath run the plt was unable to level the acft in time to avoid flying into the bean field. The acft nosed over on impact and caught fire. Density altitude was about 2,800 ft. acft gross weight was aprx 5,500…Jul 3, 1984 · N4796 · Substantial damage NTSB MKC79FCA17Accident · Serious injuriesClosedGrumman G-164A · Bell City, MOJun 9, 1979 · N7499 · Destroyed NTSB MKC78FA051Accident · 1 fatalClosedN American SNJ-4 · Gravois Mills, MOJun 25, 1978 · N9589C · Destroyed NTSB MKC77FCA27Accident · No injuriesClosedGrumman G-164A · Sikeston, MOJul 4, 1977 · N7499 · Substantial damage NTSB MKC75FCA15Accident · No injuriesClosedBeech E18S · Festus, MONov 3, 1974 · N762SP · Substantial damage NTSB MKC75FCG07Accident · 1 fatalClosedGrumman G-164A · St Joseph, MOAug 5, 1974 · N6606 · 2 aircraft · Substantial damage NTSB MKC74DCA11Accident · No injuriesClosedGrumman G-164 · Charleston, MOOct 18, 1973 · N7248 · Substantial damage NTSB MKC74FCA10Accident · No injuriesClosedGrumman G-164A · Charleston, MOSep 28, 1973 · N6581 · Substantial damage NTSB MKC72FCA16Accident · No injuriesClosedN.American SNJ-4 · Chesterfield, MONov 16, 1971 · N1395N · Substantial damage NTSB MKC72DCG30Accident · No injuriesClosedN. American SNJ-5 · Grain Valley, MOOct 25, 1971 · N21JD · Substantial damage NTSB MKC71DCG07Accident · No injuriesClosedAero Comdr 600S2D · Faucett, MOJul 16, 1970 · N1725S · Substantial damage NTSB MKC67D0576Accident · No injuriesClosedBoeing A75N1 · Sedalia, MOMay 9, 1967 · N61673 · Substantial damage