NTSB investigations, MO
32 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 1 |
| 1988 | 5 |
| 1989 | 2 |
| 1990 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 3 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2006 | 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\" = 354)
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" = 354) 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 CHI07CA047Accident · Minor injuriesData collectionFinal reportCessna T210L · North St. Louis, MOFuel starvation due to an inadequate fuel supply. A factor associated with the accident was the soft terrain encountered during the landing.NTSB CHI01LA182Accident · 1 fatalLimited investigationFinal reportMooney M20J · Columbia, MOThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI01FA146Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Osage Beach, MOAircraft control not being maintained by the pilot during the forced landing and inadequate preflight inspection performed by the pilot. Contributing factors to the accident were the fuel system contamination that resulted in the loss of engine power, the…NTSB CHI00LA195Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman A75N1(PT17) · Windsor, MOfuel exhaustion and the pilot abruptly applying normal brakes during the landing roll. Factors relating to this accident were the precautionary landing, and the pilot's inadequate in-flight planning/ decision.NTSB CHI99LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Butler, MOloss of engine power for undetermined reason, and the pilot's inability to maintain clearance from the fence during the forced landing. Factors relating to this accident were the rising terrain, the rough/uneven terrain, and the fence posts.NTSB CHI99LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Odessa, MOthe total loss of engine power for reasons undetermined. Factors were total loss of engine power, the instructor pilot's encounter with unsuitable terrain, and the rough terrain.NTSB CHI96LA345Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kearney, MOthe pilot's improper use of carburetor heat, which resulted in a reduction of engine power and subsequent collision with the terrain, during a forced landing.NTSB CHI96LA321Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Grant City, MOlow oil level which resulted in the partial loss of engine power, the pilot's intentional operation of the airplane with a known mechanical deficiency, and the hay bale. Factors relating to this accident were the owner/pilot mechanic's failure to comply with…NTSB CHI96LA239Accident · No injuriesLimited investigationFinal reportCessna A188B · Saint Charles, MOa partial loss of engine power due to undetermined reasons and the pilot's failure to maintain aircraft control. The factors involved were the pilot did not perform load jettison and low airspeed.NTSB CHI95LA246Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Springfield, MOthe partial loss of engine power due to fouled spark plugs as a result of an improper fuel/air mixture. A factor in the accident was the powerlines.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.NTSB CHI94LA183Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Bolivar, MOThe partial blockage of the carburetor's induction air opening by a plastic bag.NTSB CHI94LA100Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eugene, MOimproper use of carbureter heat and a poorly planned precautionary landing approach. Factors related to the accident were carburetor icing conditions, the pilot's lack of total experience, trees and anxiety/apprehension.NTSB CHI93LA344Accident · No injuriesLimited investigationFinal reportBeech 19A · Troy, MOThe pilot's use of improper fuel in the airplane. Wet turf on the runway was a related factor.NTSB CHI93LA306Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Liberty, MOThe pilot's failure to maintain adequate aircraft control during the emergency landing. A factor is the pilot's lack of experience in the aircraft.NTSB CHI93LA027Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Aurora, MOThe pilot's lack of familiarity with the airplane, a switched off fuel selector and fuel starvation.NTSB CHI92LA128Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Lee'S Summit, MOA delayed aborted takeoff by the pilot in command. A factor in the accident is the presence of carburetor icing conditions.NTSB MKC90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · St. Louis, MOInadequate maintenance and proper touchdown point not attained by the pilot in command.NTSB MKC89FA194Accident · Serious injuriesField investigationFinal reportCessna 206A · Lees Summit, MOEngine partial power loss due to water in the aircraft fuel system, and an inadequate preflight.NTSB MKC89LA169Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Harviell, MOThe pilot's inability to avoid unsuitable terrain during the landing roll after a forced landing. The forced landing was made necessary by a loss of engine power caused by a foreign object restricting the fuel system.NTSB MKC89LA008Accident · No injuriesLimited investigationFinal reportDavis TRI-Q-200 · Carthage, MODrg the 2nd flt of the newly constructed home built acft, the eng began to lose power shortly after takeoff. The plt reentered the pattern for a precautionary landing, but misjudged the apch & had to go around. Drg the next apch, the eng lost power…NTSB MKC88LA121Accident · No injuriesLimited investigationFinal reportBeech A-60 · Lexington, MOThe pilot failed to provide the aircraft with a fuel supply adequate to complete the proposed flight and the pilots failure to maintain directional control of the aircraft during the landing roll on the active runway.NTSB MKC88LA113Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Florence, MOWhile on a personal flight, PIC said he began to lose engine power. He elected to make a precautionary ldg in a farm field, and during the roll out, the nose wheel struck a ditch. Post flt examination failed to reveal any cause for the partial power loss.NTSB MKC88LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Dexter, MOShortly after takeoff, during an instructional night cross country training flt, the CFI said he began to lose engine RPM. He made a 180 degree turn to return to the departure apt, when he had a complete power failure. An emergency ldg was made on a freshly…NTSB MKC88LA045Accident · No injuriesLimited investigationFinal reportCessna 195 · Rolla, MOShortly after takeoff, during a personal flight, the engine progressively lost power. The PIC attempted an emergency ldg in a pasture. During the ldg roll, the acft collided with a tree, causing substantial damage to the right wing. Post accident aircraft…NTSB MKC85LA221Accident · Minor injuriesLimited investigationFinal reportLon J. Mcknight Flybaby 1A · Lebanon, MOAfter washing his aircraft the plt dptd the airport for a LCL flight. The flight lasted for approx. 30 min. When the plt stated the end began running rough. A precautionary landing was made to the airport. The acft stalled impacting the ground short of the…NTSB MKC84LA283Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Slater, MOPlt quickly pulled excessive collective while attempting takeoff from a hover. Rotor RPM decreased and the acft touched down hard on the right skid. A post accident engine run revealed no discrepancies.NTSB MKC84LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Kirksville, MOThe acft lost power and emitted black smoke during takeoff. The acft was forced to land in a field off the arpt. The weather was conducive to carburetor icing. The plt said that he had not used carburetor heat anytime during the sequenceof events.NTSB MKC84LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Osage Beach, MOThe plt reported that while he was making an instrument apch in heavy rain, there was a parial loss of eng power. He applied carburetor heat, but reported that the eng still did not provide full power. He continued the vor/dme apch. When he saw the rwy, he…NTSB MKC83LA193Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Keytesville, MOAccording to the pilot, after departure he climbed to 2000 feet MSL, adjusted the throttle for 2500 RPM and leaned the mixture for cruise flight. The engine slowed to 2000 RPM so he selected the opposite fuel tank, moved the mixture to full rich and applied…NTSB MKC83LA123Accident · No injuriesLimited investigationFinal reportCessna 150H · Salem, MOThe flt instructor (CFI) initiated a simulated forced landing at about 500 ft AGL as the acft was climbing during takeoff at night. The student elected to turn downwind for a landing on the departure rwy. When the CFI determined that the student would not be…NTSB MKC83FCA01Accident · 4 fatalFinal reportPiper PA-28-161 · St. Charles, MOThe acft crashed on the north boundary of the arpt within minutes after having been seen departing rwy 27. Dense ground fog prevailed at the crash site. Approximately 1-1/2 hours after the accident examination disclosd very heavy frost on all acft parked…