NTSB investigations, MO
30 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1983 | 3 |
|---|---|
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 3 |
| 1995 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2002 | 2 |
| 2005 | 1 |
Where
Open the mapLatest cases
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 c.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352) 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 CHI05LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Macon, MOThe loss of engine power due to failure of the engine exhaust valve. The pilot's inability to maintain clearance from obstacles, the trees, the residence and the pilot's evasive maneuver were factors in the accident.NTSB CHI02LA297Accident · No injuriesLimited investigationFinal reportJonas Nieuport · Creve Coeur, MOThe installation of improper carburetor jets resulting in an improper fuel mixture and loss of engine power.NTSB CHI02LA186Accident · No injuriesLimited investigationFinal reportCessna 175 · Kaiser/Lake Oza, MOThe pilot's decision to conduct the flight with a known deficiency in the aircraft, a failure by the pilot to execute a precautionary landing due to "sluggish" performance during takeoff, the loss of engine power due to the malfunction of the left magneto,…NTSB CHI99LA277Accident · No injuriesLimited investigationFinal reportCessna 150M · Sikeston, MOthe loss of engine power due to the stuck exhaust valve. A factor was the lack of suitable terrain available for the forced landing.NTSB CHI99FA163Accident · 4 fatalField investigationFinal reportCessna 421B · Jefferson City, MOthe pilot failed to maintain control of the airplane. A factor was the partial loss of power due to the exhaust valve fatigue failure.NTSB CHI98LA366Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Point Lookout, MOThe pilot's continued flight with a known deficiency in equipment. Contributing to the accident was the maintenance adjustment that was not completed by the mechanic.NTSB CHI95FA226Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Festus, MOan improper annual inspection, the fouled spark plugs, the arcing magneto distributor, and the pilot's attempt to take off with known deficiencies.NTSB CHI95LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · St. Louis, MOA loss of engine power due to an excessive fuel mixture caused by undetermined reasons.NTSB CHI92LA167Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Wyatt, MOAn improper decision during flight when the pilot in command overflew two suitable landing areas after a partial power loss in one engine. The mechanical deficiencies in the engines were factors in the engine.NTSB CHI92LA162Accident · Serious injuriesLimited investigationFinal reportCommander C3C · Grain Valley, MOThe jammed (kinked) choke plate control cable, which resulted in reduced power and collision with rising terrain.NTSB CHI92LA146Accident · No injuriesLimited investigationFinal reportCessna 150F · Eldon, MOA binding exhaust valve resulting in a partial loss of engine power. Factors in the accident are rising terrain conditions, inadequate aircraft climb capability, and a ditch in the forced landing area.NTSB CHI91LA267Accident · No injuriesLimited investigationFinal reportCessna 150M · Old Monroe, MOThe separation of the throttle control cable. Contributing to the accident was the rough terrain on which a forced landing was made.NTSB CHI91DCG02Accident · Serious injuriesFinal reportHuff Pulsar · Missouri City, MOOil fouled spark plugs resulting in a partial loss of engine power. Soft terrain in the forced landing area was a factor.NTSB MKC90LA084Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Branson, MOA disconnected throttle linkage that was inadequately inspected.NTSB MKC89LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Kansas City, MOImproper use of the carburetor heat control by pilot in command.NTSB MKC88FA171Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Goodman, MOEngine ignition and lubrication problems which resulted in the pilot's election to execute a precautionary landing. A contributing factor was the pilot's inability to see and avoid power lines in his approach path due to bright sunshine.NTSB MKC87LA160Accident · No injuriesLimited investigationFinal reportNorth American Navion · Chillicothe, MOThe PIC was ferrying the navion to a distant location to undergo an annual insp. Abt 20 min into the flt, the PIC rptd experiencing eng pblms. The PIC was able to fly to a nearby arpt for a precautionary lndg. Instead of making the lndg the PIC went around to…NTSB MKC87DCA03Accident · Serious injuriesFinal reportBurkholder Q-2 · St Charles, MODrg takeoff, the eng began to run rough at an estd alt of 50 to 100 ft AGL & would not developed enough power to maint flt. Subsequently, as the plt was lndg in a soybean field, the acft flipped over & came to rest in an upright attitude. A teardown of the…NTSB MKC86LA086Accident · No injuriesLimited investigationFinal reportGrumman G164B · Advance, MOThe airplane was being operated as an agricultural aircraft when the engine started backfiring and then quit. During the forced landing in a plowed field, the airplane flipped forward to the inverted position. Investigation revealed the teeth on the left…NTSB MKC86LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Ava, MOThe plt reports that the eng began to run rough and lose RPM while the acft was cruising at 2500 ft. he said he attempted emerg proc but the loss of RPM continued and he decided on an off-arpt landing. During the apch to the landing area the eng RPM dropped…NTSB MKC86FA017Accident · Serious injuriesField investigationFinal reportSilvaggio Cassutt 111M · Plattsburg, MOThe acft was level, in cruise when the plt noticed high eng temperatures. He stated that he started a shallow climb and headed for the nearest arpt. En route to nearest arpt, smoke came into the cockpit and the plt heard a loud noise that was accompanied by…NTSB MKC85LA166Accident · Minor injuriesLimited investigationFinal reportJames Gress Quickie · Fenton, MOWhile taking off, the plt noted a partial loss of eng power during the initial climb. He was unable to maintain alt & tried to maneuver around trees near the departure end of the rwy. However, the acft descended into the tree tops, then crashed onto the roof…NTSB MKC85LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Rushville, MOShortly after the plt departed on a flt, the eng lost power while the acft was cruising at 1800 ft MSL over hilly terrain. The plt reported that the eng speed dropped to 800 RPM & he was unable to correct the situation. During a forced landing on soft…NTSB MKC85LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Springfield, MOThe acft collided with trees during a forced landing, while on a dual instructional flt. The CFI said after the climb tocruise the eng began to slow dwn. The CFI took control of the acft to return to arpt of departure. He said the vibrationwas excessive as…NTSB MKC84FCA02Accident · Serious injuriesFinal reportMooney M20E · Chesterfield, MOThe acft crashed short of the rwy after making a 180 deg turn after takeoff following a loss of power. The plt stated that after takeoff & at an indicated airspeed of 100 to 110 mph, at an altitude of 50 ft, the acft eng started to lose power. He decided to…NTSB MKC84FA221Accident · 1 fatalField investigationFinal reportMorgan T. Melton SKY Rider · West Plains, MOThe owner/bulder stated that he & his brother had been having an eng problem which they assumed was due to a vapor lock. They had installed a metal box around the electric fuel pump to insulate it from the heat of the exhaust pipe. The brother initiated a hi…NTSB MKC84LA188Accident · No injuriesLimited investigationFinal reportCessna 152 · Lee'S Summit, MOWhile taking off from a touch-&-go landing, the eng failed to develope full power. The instructor plt (CFI) pulled the throttle back to abort the takeoff, but the RPM would not reduce to idle. Subsequently, the acft continued aprx 500 ft past the end of the…NTSB MKC84FA010Accident · No injuriesField investigationFinal reportConvair 340 · St. Louis, MOWhile in a climb after takeoff, the aircrew encountered an eng problem (which was reported as detonation) & requested clearance to return to the departure arpt. The flt was vectored for a right traffic pattern to rwy 24. The plt reported he was at 2000 ft MSL…NTSB MKC84FA005Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Sullivan, MOThe acft collided with trees during an attempted go-around from a precautionary/forced landing. There were no radio calls from the pilot but evidence discovered in the engine tear down revealed internal problems. The magneto had broken and the oil pan…NTSB MKC83FA064Accident · Minor injuriesField investigationFinal reportCessna 310F · Vichy, MOThe plt stated that shortly after takeoff, at 500 ft AGL, the left prop feathered by itself, then the left engine quit & he was unable to restart it. He elected to divert to rolla, MO & land at the national arpt which had a longer rwy. While en route, he…