NTSB investigations, MO
69 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 7 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 7 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 6 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 3 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 2 |
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\" = 351)
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" = 351) 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 CHI07LA154Accident · Serious injuriesLimited investigationFinal reportCessna 421 · Chesterfield, MOMaintenance personnel failed to comply with an Airworthiness Directive which resulted in the total failure of the starter adapter gear teeth and the crankshaft gear teeth and the pilot failed to follow the published emergency procedures. Contributing to the…NTSB CHI07LA127Accident · No injuriesLimited investigationFinal reportBeech S35 · Brookfield, MOImproper maintenance by maintenance personnel by not properly torquing cylinder thru-bolts. The loose stud nuts which resulted in the separation of the cylinder and the crop and ditch were factors.NTSB CHI07IA042Incident · No injuriesIncident investigationFinal reportBell 407 · Raytown, MOThe loss of engine power during cruise flight due to third stage turbine wheel blade fatigue and subsequent separation, which resulted in an emergency landing.NTSB CHI07LA039Accident · No injuriesLimited investigationFinal reportCessna 140 · Vienna, MOThe loss of engine power during cruise flight due to fatigued crankshaft cluster gear bolts and the inadequate major overhaul of the engine that was last performed by other maintenance personnel. An additional cause was a subsequent major engine overhaul not…NTSB CHI06FA210Accident · 6 fatalClass 1 · FieldFinal reportde Havilland DHC-6-100 · Sullivan, MOthe pilot's failure to maintain airspeed following a loss of power in the right engine due to the fracturing of compressor turbine blades for undetermined reasons. Contributing to some parachutists' injuries was the lack of a more effective restraint system…NTSB CHI05IA116Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Kansas City, MOThe fatigue failure during cruise flight of the fan spinner and forward fan retaining ring due to an interference between the mating parts resulting from the inadequate design by the manufacturer.NTSB CHI04LA283Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Houstonia, MOThe fatigue failure of the piston end of the connecting rod and the pilot's failure to maintain aircraft control during the forced landing.NTSB CHI04LA144Accident · No injuriesLimited investigationFinal reportBeech M35 · Strafford, MOThe improper installation of the cylinder during the engine overhaul which resulted in the fatigue failure of the cylinder studs and through-bolts and the subsequent separation of the cylinder. Factors associated with the accident were the fence and the guy…NTSB CHI04LA011Accident · Minor injuriesLimited investigationFinal reportDomeier RV-7A · Augusta, MOThe failure of the supercharger and alternator drive belts which resulted in foreign object damage to the valve timing system and subsequent loss of engine power, and the unsuitable terrain encountered by the pilot during the forced landing. A factor was the…NTSB CHI02LA087Accident · No injuriesLimited investigationFinal reportCessna 182H · West Plains, MOThe engine failure due to the fatigue fracture of the crankshaft which resulted from the installation of improper pistons during an STC'd engine conversion by other maintenance personnel. Additional factors included the unsuitable terrain encountered by the…NTSB CHI02LA005Accident · No injuriesLimited investigationFinal reportCessna 182N · Graham, MOA loss of engine power due to the fatigue failure of the number 2 piston. Contributing to the accident was the unsuitable terrain.NTSB CHI01IA211Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Whiteman AFB, MOThe separation of a fan blade due to fatigue failure which led to case separation and loss of engine power in the left engine.NTSB CHI99LA253Accident · No injuriesLimited investigationFinal reportBeech B36TC · Brookfield, MOthe total mechanical failure of the engine crankshaft due to fatigue. A factor was the ditch encountered on landing.NTSB CHI99LA226Accident · No injuriesLimited investigationFinal reportCessna 177RG · Weldon Springs, MOthe loss of engine oil for undetermined reasons. A factor was the trees.NTSB CHI99LA143Accident · No injuriesLimited investigationFinal reportNarzinski Avid Flyer Mark IV · West Alton, MOThe failure of the connecting rod bearing, and the rough/uneven terrain condition.NTSB CHI98FA106Accident · 6 fatalField investigationFinal reportCessna U206G · Grain Valley, MOPilot's inadequate preflight, the partial loss of oil and the resulting rod failure. A factor was the pilot's failure to maintain flying speed.NTSB CHI97LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Fulton, MOa malfunction of the engine's carburetor that was associated with a spalled carburetor float fulcrum pin which resulted in fuel starvation.NTSB CHI97LA021Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Kirksville, MOan improper maintenance overhaul by company maintenance personnel which led to a bearing failure. The soft terrain was a factor.NTSB CHI97LA009Accident · No injuriesLimited investigationFinal reportHayes Lancair 235 · Kansas City, MOa stuck carburetor float valve which resulted in excessive fuel flow and ultimately fuel exhaustion. A factor related to the accident was the rough terrain on which the forced landing was made.NTSB CHI96LA270Accident · Minor injuriesLimited investigationFinal reportGeide SPORT-A · Slater, MOfailure of a #2 connecting rod bolt, which led to a jammed connecting rod and subsequent overload separation of the #2 cylinder. A factor relating to the accident was: lack of suitable terrain for an emergency landing.NTSB CHI96LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocie, MOfailure of the number three exhaust valve.NTSB CHI95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Columbia, MOA loose (or missing) nut and clip for the bottom magneto stud, due to inadequate maintenance, and fatigue failure of the magneto housing flange, which restulted in an oil leak, engine compartment fire, and a forced landing. A factor relating to the accident…NTSB CHI95LA139Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Kirksville, MOthe loss of engine power due to failure of the engine's hydraulic tappet body heads. Related factors in the accident were the restricted visual lookout, and the unsuitable terrain encountered during the forced landing.NTSB CHI95LA047Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Aurora, MOAn undetermined failure of the engine crankshaft resulting in total loss of engine power. The terrain at the emergency landing site and nighttime darkness were contributing factors.NTSB CHI94LA286Accident · No injuriesLimited investigationFinal reportSnow S2C · Leslie, MOthe separation of the cylinder and subsequent oil leak. A factor to the accident was the pilot's restricted visual outlook.NTSB CHI94LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28 · St. Joseph, MOthe loss of engine power due to the failure of the number two cylinder.NTSB CHI94LA177Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Bolivar, MOthe failure of a pressure fuel line. A factor was the encountering of unsuitable terrain during a forced landing.NTSB CHI94LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Sikeston, MOa fatigue failure of a compressor blade which resulted in a catostrophic engine failure.NTSB CHI94LA005Accident · No injuriesLimited investigationFinal reportCessna 150G · Osceola, MOFracture of the number four piston at the piston pin boss. A factor related to the accident was: the lack of suitable terrain for an emergency landing.NTSB CHI93LA357Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Springfield, MOthe disconnection of the primer supply line at the fuel strainer.NTSB CHI93LA324Accident · Minor injuriesLimited investigationFinal reportBellanca BL-17-30 · Lee'S Summit, MOimproper maintenance which resulted in a disconnected throttle lever linkage.NTSB CHI93LA216Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Malden, MOA broken mixture control cable resulting in fuel starvation.NTSB CHI93LA212Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Buckner, MOThe nut backing off the connecting rod bolt resulting in rod failure. A factor involved in this accident was the lack of suitable terrain for the pilot in command to make a run on landing.NTSB CHI93FA182Accident · 2 fatalField investigationFinal reportAerospatiale AS-350B · Cameron, MOThe loss of engine power due to failure of the second stage turbine labyrinth seal. Factors related to the accident were: the unfavorable wind and tall trees bordering the emergency landing area.NTSB CHI92DCA04Accident · Serious injuriesFinal reportTinsman RV6 · Foristell, MOThe partial failure of the fuel injection system. Factors related to the accident are the pilot's insufficient altitude to reach the runway from the downwind leg, and the presence of transmission wires in the off airport landing site.NTSB CHI92DCG04Accident · No injuriesFinal reportDennis L. Fetters Mini 500 · Missouri City, MOAn improper connecting rod assembly resulting in mechanical binding between the rod and the engine crankshaft.NTSB CHI91LA298Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Sunset Hills, MOA blocked fuel system line and inadequate maintenance of the airplane by other maintenance personnel.NTSB CHI90LA198Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ozark, MOTotal loss of engine power due to #2 turbine shaft bearing failure. A factor related to the accident was: none suitable terrain.NTSB CHI90IA181Incident · No injuriesIncident investigationFinal reportBell 206A · Lake Ozark, MOCompression assembly blade and emergency floatation gear failure.NTSB MKC90LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hornersville, MOFailure of an engine cylinder.NTSB MKC89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Excelsor Sprgs, MOThe catastrophic failure of the aircraft engine and the pilots failure to maintain directional control of the aircraft during the landing roll. Improper maintenance, the dark night conditions, and restricted visibility due to oil on the windscreen were…NTSB MKC88FA147Accident · 2 fatalField investigationFinal reportMooney M20C · Missouri City, MOThe co-owner of the acft stated he had experienced a fuel flow pblm while flying to the (ojc) arpt, where pax (one of them was a co-owner) were to board. He stated he advzd the other owner of the pblm, but no corrective action was taken. The acft was then…NTSB MKC88LA133Accident · No injuriesLimited investigationFinal reportGrumman 164A · Poplar Bluff, MOThe pilot experienced an engine failure while attempting to land during an aerial application flight. Altitude was not adequate to select a suitable forced landing area. The aircraft impacted in a pipeline right of way and came to rest in a small stream,…NTSB MKC88LA114Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Eldon, MOTotal failure of the powerplant due to an oil line rupture, and proper touchdown point not attained by the pilot in command.NTSB MKC87FA163Accident · Serious injuriesField investigationFinal reportBeech 35 · Excelsior Spgs, MOAccording to witnesses, the pilot declared an emergency over the radio stating that the eng was losing power and that she was attempting an emerg lndg at Excelsior springs arpt. The pilot stated that she initiated a go-around, after the rwy was assured, due…NTSB MKC87LA152Accident · No injuriesLimited investigationFinal reportAero Commander Callair A9-B · Osgood, MODuring an aerial application operation, pilot experienced partial power loss and vibration, followed by a loud explosive sound and total loss of power. An emergency ldg was made followed by a nose over. Postaccident inspection revealed the entire propeller…NTSB MKC87LA141Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Bear Creek, MODuring a personal xc flt, plt experienced a partial loss of power followed by a total loss of power. During emergency ldg, pilot stated that he prematurely added full flaps, which resulted in too steep of a descent, causing acft to be short of intended…NTSB MKC87LA096Accident · No injuriesLimited investigationFinal reportRotorway Executive · Gerald, MOThe stu PIC was solo on a x-country flt when the eng backfired. The stu entered autorotation with low rotor RPM which accelerated the descent rate. The stu flared before touchdown but did not level the helo in time to land. The tailboom struck the gnd and the…NTSB MKC87LA058Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Tipton, MOThe pilot stated that, fifteen minutes into the flight, while at cruise the engine oil pressure began dropping as the oil temperature rose. While attempting to reach sedalia, Missouri to perform a precautionary landing, oil began covering the aircraft's…NTSB MKC87LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Malden, MOThe acft was being used on training flt when the eng failed. During the forced landing in a muddy field, the acft flipped forward to an inverted position. Post accident inspection revealed the eng failed due to a connecting rod bolt failure on the number two…