NTSB investigations, MS
41 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 4 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 4 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 4 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 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\" = 'MS' 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" = 'MS' 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 DFW07CA065Accident · No injuriesData collectionFinal reportMcDonnell Douglas 600N · Vicksburg, MSThe loss of engine power due to fuel starvation as result of a fuel transfer check valve stuck in the closed position. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA05LA107Accident · Serious injuriesLimited investigationFinal reportC.W. Smith Rans S6 Coyote II · Louisville, MSGalling of the front piston and cylinder of the Rotax 503 2-stroke engine, consistent with the engine running hot and lean for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB MIA05LA016Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Raymond, MSThe total loss of engine power which was initiated by fretting of the crankcase halves for undetermined reasons, causing rotation of several of the main bearings, oil starvation, and subsequent failure of several of the connecting rods. A contributing factor…NTSB MIA04LA127Accident · No injuriesLimited investigationFinal reportMooney M20F · Brandon, MSA loss of engine power due to the fatigue failure of all studs and/or thru-bolts of the No. 3 cylinder for undetermined reasons causing separation of the cylinder. Contributing to the accident was the unsuitable terrain encountered by the pilot.NTSB MIA03LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocean Springs, MSA loss of engine power due to starvation as a result of the pilot's continued operation of an airplane with known deficiencies.NTSB MIA02LA108Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · Meridian, MSinadequate quality control of the manufacturing processes of the crankshaft gear bolt, resulting in failure of the gear bolt, due to hydrogen embrittlement, a total loss of engine power, and damage to the airplane during the subsequent forced landing.NTSB ATL99LA129Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Caledonia, MSThe failure of the fuel control gear train due to oil contamination. A factor was Inadequate maintenance.NTSB MIA99LA204Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Isola, MSFailure of the No. 4 cylinder due to a leaking intake valve resulting in loss of engine power and collision with a ditch while making a forced landing on unsuitable terrain. Contributing to the accident was improper maintenance adjustment of the engine valves…NTSB ATL99LA087Accident · No injuriesLimited investigationFinal reportCessna T188C · Bruce, MSThe loss of lubrication to the number 2 connecting rod due to the shifted bearing that resulted in the total loss of engine power.NTSB ATL99LA055Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Bay Springs, MSThe fuel control drive bearing failure at the intermediate gear resulted in fuel starvation and the subsequent loss of engine power.NTSB ATL99LA006Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Fayette, MSThe fuel filter contamination which resulted in the loss of engine power. The air leak in the fuel system was a factor.NTSB ATL97LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Fulton, MSThe excessively rich mixture produced by the carburetor, which led to the fuel exhaustion.NTSB ATL97LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Columbus, MSinadequate maintenance/inspection and subsequent corrosion of the air filter, which resulted in pieces of the air filter to block the intake to the carburetor and result in loss of engine power. A factor relating to the accident was: failure of maintenance…NTSB MIA96LA183Accident · No injuriesLimited investigationFinal reportRockwell S2R · Belzoni, MSfatigue failure of the #5 cylinder skirt, which resulted in debris that caused the oil scavenge pump to fail, oil starvation, cam drive seizure, loss of engine power, and a subsequent forced landing in a field of cotton.NTSB MIA96LA131Accident · No injuriesLimited investigationFinal reportCessna 210M · Meridian, MSprevious engine damage; failure of the pilot of the previous flight to report to the operator and/or mechanics that the engine had been operated with low (or no) oil pressure; inadequate maintenance/inspection after most of the oil had leaked from the engine…NTSB MIA95LA192Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Quitman, MSImproper (low) outflow from the fuel control unit, due to improper maintenance, which resulted in a loss of engine power and a forced landing.NTSB MIA95LA080Accident · No injuriesLimited investigationFinal reportMooney M20E · Mclain, MSThe improper reassembly of the servo fuel injector during overhaul by maintenance personnel. This resulted in a total loss of engine power during cruise flight due to fuel starvation, forced landing, and subsequent on-ground collision with a fixed object…NTSB MIA95LA066Accident · No injuriesLimited investigationFinal reportBeech 35 · Sardis, MSA loss of engine power due to fuel starvation caused by a fuel selector stem failure, due to wear, that precluded the pilot from selecting a fuel tank that had fuel.NTSB MIA94LA194Accident · Minor injuriesLimited investigationFinal reportAerosport Quail · Waynesboro, MSAn engine failure due to improper maintenance [overhaul] of the engine crankshaft.NTSB MIA94FA064Accident · 2 fatalField investigationFinal reportCessna T210M · Prentiss, MSA total loss of engine power due to the number five piston crown structure sustaining detonation/pre-ignition damage for undetermined reasons. The number two connecting rod and rod bolts failed due to an oil distress event. This resulted in a subsequent…NTSB MIA93LA136Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Laurel, MSA ruptured center bellows seal in the fuel servo and/or a plugged fuel injector due to contamination (rust) from the fuel servo. Factors related to the accident were: improper servicing of the aircraft, and people and trees in the emergency landing area.NTSB MIA93LA134Accident · No injuriesLimited investigationFinal reportCessna 182P · Corinth, MSFailure of the engine over terrain unsuitable for a forced landing. Contributing to the accident was the failure of the no. 5 piston for undetermined causes.NTSB MIA93LA086Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Madison, MSInduction air control/system partial failure, induction air control/system leak, and the lack of suitable terrain for the forced landing.NTSB MIA93LA072Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Raleigh, MSThe fatigue failure of the no. 1 exhaust valve for undetermined reasons, and the lack of suitable terrain for the forced landing.NTSB MIA92LA076Accident · Minor injuriesLimited investigationFinal reportAero Mercantil Gavilan 358 EL-1 · Columbus, MSFatigue failure of the crankshaft due to improper engine assembly by the manufacturer.NTSB MIA91LA219Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Sumner, MSFailure of the no. 1 cylinder assembly.NTSB MIA91LA202Accident · No injuriesLimited investigationFinal reportCessna A188B · Hollandale, MSOverload failure of the no. 5 cylinder connecting rod bolt due to being loose for undetermined reasons. This resulted in the damage during the forced landing following total loss of engine power.NTSB MIA90LA176Accident · No injuriesLimited investigationFinal reportGrumman 164-A · Dundee, MSImproper maintenance repair by an unknown person that initiated the engine failure and the forced landing.NTSB MIA89LA168Accident · No injuriesLimited investigationFinal reportBeech A24R · Gulfport, MSFailure of a #2 connecting rod assembly, which resulted in separation of the #2 cylinder and subsequent loss of engine power. Contributing factors were: inadequate maintenance, the transmission (power) line, and trees.NTSB MIA89LA166Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Lambert, MSFailure of the engine impeller. The ditch in the emergency landing area was a related factor.NTSB MIA89LA114Accident · Minor injuriesLimited investigationFinal reportDyar KIT FOX · Purvis, MSFailure of the engine's rear piston. Factors related to the accident were: the pilot's lack of altitude for a forced landing and trees in the emergency landing area.NTSB MIA89LA007Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Flora, MSAfter dispensing a chemical load, the plt was rtrng to re-load when the eng began running rough. He said he noted the fuel flow was erratic, so he turned on the boost pump. The eng stabilized momentarily, then smoke entered the cockpit & the eng began…NTSB MIA88LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Waynesboro, MSWhile cruising at 5500 ft, the plt smelled burning oil. Moments later, oil press was lost, the prop went into high RPM & the tach zoomed over redline. A loud report was heard & all power was lost. A forced ldg was attempted in the rolling country but the acft…NTSB MIA88LA198Accident · No injuriesLimited investigationFinal reportHughes 369D · Horn Lake, MSBfr tkof, the helicopter was svcd with 100LL fuel (an approved altn fuel if the boost pump is used in flt). Drg flt, theeng lost pwr. An autorotation was made in tall vegetation, but drg the lndg, the main rotor blades severed the tail boom. An inspn of the…NTSB MIA87LA115Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Oxford, MSDuring final apch the eng quit. The plt then attempted to land the acft on a road, during which, it collided with trees. Inspection of the acft revealed that the adjusting screw on the eng driven fuel pump backed out aprx 8 turns. Bench test of the pump…NTSB MIA86FLT01Accident · Serious injuriesFinal reportAmateur Built Eenie TWO · Waynesboro, MSThe acft nosed over during a forced landing after a power loss. According to witnesses the acft made a climbing turn after takeoff followed by a low pass near the witnesses. The acft then disappeared behind some trees and when it reappeared the engine was not…NTSB ATL84LA230Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Georgetown, MSThe plt reported that during a pull-up, the prop went to a low pitch angle & the eng was not developing full power. He noted that the tachometer was near the red line & he retarded the prop pitch control & the throttle. Also, he noted that the oil pressure…NTSB ATL82DA252Accident · No injuriesFinal reportGrumman G-164C · Gunnison, MSThe pilot reported that he smelled something hot while spraying. He checked the instruments and noted that the oil temperature gauge was indicating off the high side of the scale. He started to make a precautionary landing but the engine seized during final…NTSB ATL82DA188Accident · No injuriesFinal reportGrumman G-164A · Doddsville, MSThe pilot reported that at the end of a swath run, he noticed the smell of burned oil and saw smoke when the engine began a hard miss. He reported that these occurred when the number five cylinder failed. He made a forced landing in a flooded rice field where…NTSB ATL82DA180Accident · No injuriesFinal reportCessna 185 · Scooba, MSThe aircraft was climbing to cruise altitude of 8500 feet. The engine began to lose power, then quit entirely. The pilot called the accompaning aircraft and made an emergency landing in a plowed field. The aircraft nosed over during landing. Examination…NTSB ATL82DA122Accident · No injuriesFinal reportPiper PA-25-235 · Greenwood, MSThe pilot smelled an odor similar to burning rubber followed by a loss of oil pressure. During the attempted forced landing the right wing contacted a fence causing substantial damage. Examination of the engine logbook reflected installation of new pistons,…