NTSB investigations, MS
73 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1986 | 5 |
| 1987 | 5 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 4 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 2 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 5 |
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\" = 350)
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" = 350) 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 DFW08LA018Accident · No injuriesLimited investigationFinal reportCessna 150K · Flora, MSLoss of engine power due to fuel contamination. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA187Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Cary, MSThe total loss of engine power due to a power turbine failure. Contributing to the accident were the lack of suitable terrain available to pilot for the forced landing and the low altitude.NTSB DFW07LA172Accident · No injuriesLimited investigationFinal reportCessna 172C · Pascagoula, MSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA154Accident · Minor injuriesLimited investigationFinal reportWsk-Pzl Mielic M-18A · Tunica, MSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA144Accident · Serious injuriesLimited investigationFinal reportFrew Zodiac 601XL · Oxford, MSThe loss of engine power for undetermined reasons.NTSB DFW06FA110Accident · 1 fatalField investigationFinal reportMooney M20K · Columbus, MSThe loss of engine power for undetermined reasons. A contributing factor was the pilot's improper decision to forgo suitable forced landing opportunities in an attempt to return to the airport.NTSB MIA05LA155Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Ocean Springs, MSThe pilot's mismanagement of available fuel and continued operation with the fuel selector set to the left tank position, which resulted in fuel starvation and subsequent loss of engine power.NTSB MIA05LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Gulfport, MSA loss engine power for undetermined reasons, that resulted in a forced landing, and damage to the helicopter during the landing.NTSB MIA03LA131Accident · Serious injuriesLimited investigationFinal reportBeech Be-35-33 · Raymond, MSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.NTSB ATL02LA169Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Morton, MSContamination in the exhaust valve guide area which caused the binding of the exhaust valve in the open position.NTSB MIA02LA159Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hernando, MSThe pilot's operation of the airplane with known deficiencies ( contaminated fuel system) which resulted in fuel starvation, a forced landing to a cotton field, and damage to the airplane during the landing.NTSB ATL02LA060Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Schlater, MSan unknown person at an unknown time exceeded the engine temperature limitations that resulted in the failure of compressor turbine and the subsequent loss of engine power during takeoff.NTSB ATL01LA100Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bentonia, MSThe loss of engine power due to the loss of throttle cable continunity. The throttle cable linkage was worn beyond servicable limits. A factor was uneven terrain at the emergency landing site.NTSB ATL01LA099Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Batesville, MSThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for an emergency landing.NTSB ATL01LA075Accident · No injuriesLimited investigationFinal reportBell 47 · Indianola, MSThe pilot's improper use of flight controls during an autorotation that resulted inn the collapse of the skids and cross tube assembly. A factor was the loss of engine power due to the failure of # 1 connecting rod and the overload failure of the skids and…NTSB ATL01LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Picayune, MSThe pilot's inflight fuel planning /decision that resulted in fuel starvation and a loss of engine power. A factor was the failure of the fuel transfer pump.NTSB MIA01LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Poplarville, MSa loss of engine power due to a cracked number 2 cylinder which resulted in a forced landing, subsequent impact with the runway, departure from the runway down an embankment, soft terrain and nose over.NTSB MIA00LA272Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Gulfport, MSa loss of power on both engines, during a simulated engine out approach, resulting in a forced landing and the subsequent on ground impact with a pole.NTSB MIA00LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean Springs, MSThe pilot's failure to maintain control of the aircraft while making a forced landing following loss of engine power for undetermined reasons, resulting in the aircraft impacting hard on the runway, bouncing into the air, and colliding with powerlines off the…NTSB MIA00LA015Accident · No injuriesLimited investigationFinal reportCessna 172G · Itta Bena, MSa loss of engine power for undetermined reasons resulting in a forced landing that was short of the intended touchdown point, and the subsequent impact with the ground.NTSB MIA99LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Anguilla, MSThe P3 air line disconnected at the P3 air filter housing , and a 'B' nut not being safetied by maintenance personnel, which resulted in a total loss of engine power.NTSB ATL99LA118Accident · No injuriesLimited investigationFinal reportBeech G35 · Columbus, MSThe loss of engine power for undetermined reasons and unsuitable terrain to make a forced landing.NTSB MIA99LA205Accident · No injuriesLimited investigationFinal reportCessna R172K · Pontotoc, MSa complete loss of engine power due to the failure of the oil pressure pump, resulting in oil starvation, a forced landing and subsequent nose over.NTSB MIA99LA203Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Drew, MSa loss of engine power due to the failure of cylinder No. 4 boss, which was caused by fatigue cracking, resulting in a forced landing in marshy terrain and subsequent nose over.NTSB MIA99LA162Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jackson, MSThe loss of engine power due to contamination and corrosion of the carburetor, and inadequate inspection of the carburetor by maintenance personnel.NTSB ATL99LA085Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Louisville, MSInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB ATL99LA028Accident · Minor injuriesLimited investigationFinal reportSid Champion Jurca MJ-5 · Madison, MSA loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.NTSB ATL98LA117Accident · No injuriesLimited investigationFinal reportAir Tractor 401 · Holly Bluff, MSThe malfunction of the carburetor which resulted in improper fuel flow to the engine.NTSB MIA98LA201Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Belzoni, MSThe malfunction in the engine blower section, resulting in oil starvation, the seizure of the engine.NTSB MIA98LA181Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Rich, MSa loss of engine power for an undetermined reason, resulting in a forced landing and subsequent impact with rough terrain.NTSB MIA98TA011Accident · Minor injuriesFinal reportCessna 172P · Wiggins, MSLoss of engine power for undetermined reasons resulting in a forced landing on unsuitable terrain and the aircraft nosing over during landing roll.NTSB MIA97LA209Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · New Albany, MSa forced landing due to an undetermined complete loss of engine power, and subsequent impact with tress.NTSB MIA97LA203Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Bay St. Louis, MSThe pilot's improper short field landing procedure and use of full flaps prior to being assured of reaching the proper touchdown point, resulting in an in-flight collision with an embankment, and subsequent nose over. Contributing to the accident was a total…NTSB MIA96LA225Accident · No injuriesLimited investigationFinal reportCessna A188B · Winona, MSimproper maintenance of the airplane by the unqualified pilot/owner, by providing inadequate clearance between a flexible oil hose and a heat shield, which resulted in chafing of the hose, an oil leak, and subsequent oil starvation. A factor relating to the…NTSB ATL96LA091Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Gulfport, MSimproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.NTSB ATL96LA078Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B · Batesville, MSan anomaly in the fuel system that allowed a pressure differential to occur between the center and outer portions of the main integral fuel tank, which in turn resulted in fuel starvation of both engines. A factor relating to the accident was: failure of…NTSB ATL96LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Jackson, MSloss of engine power during takeoff for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB MIA96LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Saltillo, MSThe failure of the pilot-in-command to perform fuel comsumption calculations before and during the flight.NTSB ATL96FA006Accident · 2 fatalField investigationFinal reportLuscombe 8E · Picayune, MSa worn left magneto distributor gear, which resulted in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB MIA95LA193Accident · No injuriesLimited investigationFinal reportCessna 150L · Picayune, MSLoss of engine power due to undetermined reasons.NTSB MIA94LA172Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Rolling Fork, MSThe loss of engine power for undetermined causes. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB MIA94LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Walls, MSThe partial loss of engine power for undetermined reasons. The sandy terrain was a factor.NTSB MIA94LA027Accident · 1 fatalLimited investigationFinal reportThompson Bushby Mustang II · Madison, MSAn engine failure for undetermined reasons.NTSB MIA93LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rome, MSLoss of engine power for an undetermined reason. A factor related to the accident was: failure of the pilot to use all available runway for takeoff.NTSB MIA93FA156Accident · 1 fatalField investigationFinal reportMooney M20-J · Jackson, MSA power loss for undetermined reasons during takeoff, the failure of the pilot-in-command to abort the takeoff, and his improper decision to turn back to the airport when there was suitable terrain ahead for the forced landing.NTSB MIA93FA129Accident · Serious injuriesField investigationFinal reportBeech F33A · Oxford, MSLoss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB MIA92LA184Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Poplarville, MSA reported loss of engine power for undetermined reasons resulting in a forced landing and in flight collision with trees.NTSB MIA91LA188Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Cleveland, MSInadequate preflight resulting in water contamination causing loss of engine power.NTSB MIA91LA187Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Meridian, MSLoss of power from the right engine due to undetermined reasons. The failure of the propeller to feather was a factor in the accident.NTSB MIA91LA184Accident · No injuriesLimited investigationFinal reportCessna 120 · Pocahontas, MSPartial loss of engine power due to undetermined reasons and in-flight collision with a power line during an emergency descent for a forced landing.