NTSB investigations, MN
44 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 4 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 5 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 5 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 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\" = 'MN' 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" = 'MN' 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 CHI05LA076Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Rochester, MNThe loss of engine power due to oil starvation and the subsequent failure of a connecting rod. Additional causes were the improper maintenance due to under-torqued fasteners, and inadequate airframe manufacturer maintenance procedures resulting in an improper…NTSB CHI04LA181Accident · No injuriesLimited investigationFinal reportBeech BE-N35 · Austin, MNThe loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.NTSB CHI03LA214Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Staples, MNThe fatigue fracture of the oil jet flange resulting in a total engine failure during the aerial application.NTSB CHI01FA220Accident · 1 fatalField investigationFinal reportMooney M-20R · Eden Prairie, MNThe fractured camshaft gear and the pilot not maintaining aircraft control. Factors relating to this accident were metal fatigue in the camshaft gear teeth, the inadvertent stall, the low airspeed, and the trees.NTSB CHI00LA211Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Saint Vincent, MNthe failure of the engine reduction gear assembly. Factors were the low altitude when the failure occurred and the crops.NTSB CHI00LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Minneapolis, MNthe failure of the engine and the unsuitable terrain for landing encountered by the pilot-in-command. Factors to the accident were the fracture of the crankshaft due to fatigue, excessive main bearing wear, and the swampy terrain condition.NTSB CHI97IA127Incident · No injuriesIncident investigationFinal reportCessna T210 · Winona, MNLoss of engine power due to improper maintenance installation.NTSB CHI96LA186Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Crookston, MNcatastrophic engine failure.NTSB CHI96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Thief Rvr Falls, MNA ruptured oil line, which resulted in oil exhaustion and subsequent loss of engine power.NTSB CHI96LA093Accident · No injuriesLimited investigationFinal reportCessna 172 · Worthington, MNProgressive failure of the engine, beginning with failure of the left magneto, which resulted in preignition or detonation, a burned hole in the #3 piston, subsequent oil exhaustion, and failure of the #1 and #2 connecting rods.NTSB CHI95LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Int'L Falls, MNengine oil exhaustion due to a frozen crankcase breather line and noncompliance with an airworthiness directive.NTSB CHI93LA303Accident · No injuriesLimited investigationFinal reportSchweizer G167B · Borup, MNthe loss of engine power due to a cracked cylinder head.NTSB CHI93LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Felton, MNThe pilot-in-command's failure to maintain airspeed. Factors contributing to the accident were a cracked carburetor float, fuel starvation, and the failure to perform an annual inspection.NTSB CHI93LA219Accident · No injuriesLimited investigationFinal reportBeech B19 · Victoria, MNThe loss of engine power due to a jammed carburetor float and the inability of the pilot to maintain clearance during the emergency landing.NTSB CHI93DER02Accident · No injuriesFinal reportMiller Quickie · Glencoe, MNThe disconnection of the ignition switch wiring.NTSB CHI93LA147Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Middle River, MNThe total failure of the ignition system's magneto.NTSB CHI92LA216Accident · No injuriesLimited investigationFinal reportCessna 150H · Bowlus, MNThe fracture of the number four cylinder's connecting rod cap.NTSB CHI92LA071Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Grand Rapids, MNThe pilot's lack of familiarity with aircraft systems which resulted in his failure to extend the landing gear by the alternate system. A factor was the loss of engine power.NTSB CHI92LA034Accident · Serious injuriesLimited investigationFinal reportAero Commander 685 · Brainerd, MNAn engine failure due to a seized fuel pump rotor shaft.NTSB CHI91DER04Accident · No injuriesFinal reportBellanca Eagle DW-1 · Hector, MNThe loss of engine power due to the total failure of a connecting rod. Related factors are the low maneuvering altitude and the unsuitable (muddy) terrain encountered during the forced landing.NTSB MKC90LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Crane Lake, MNFailure of the connecting rod assembly. Factors related to the accident were: terrain conditions in the emergency landing area.NTSB MKC89LA200Accident · No injuriesLimited investigationFinal reportHughes 269C · Bloomington, MNFailure of the engine crankshaft. The light conditions at dawn and the vehicles were considered to be contributing factors.NTSB MKC89LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chanhassen, MNEngine assembly dowell pin sheared causing total powerplant failure and inadequate visual lookout by the driver of the ground vehicle.NTSB MKC89LA184Accident · Minor injuriesLimited investigationFinal reportDormoy TKD Bathtub · Carlisle, MNFailure of the mixture control cable and inadequate maintenance (repair) by the pilot. The terrain conditions were considered to be contributing factors.NTSB MKC89LA176Accident · No injuriesLimited investigationFinal reportBell 206-B2 · Sebeka, MNPower plant failure due to a fracture of the first stage turbine wheel, resulting in an uncontrolled autorotation.NTSB MKC89LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Sauk Rapids, MNFailure of the pilot to properly secure the oil cap when he serviced the aircraft and oil starvation. Contributing factors were the terrain conditions.NTSB CHI88LA235Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Detroit Lakes, MNDuring the initial climbout, as the aircraft climbed through approximately 200' AGL, the powerplant failed completely. The pilot executed a forced landing in an plowed field, substantially damaging the aircraft. Post-accident examination of the engine…NTSB CHI88DER08Accident · Serious injuriesFinal reportCessna T337D · Jacobson, MNDuring the climb from takeoff, the front engine sustained a total power loss due to a fuel leak. The pilot secured the engine, however was unable to maintain altitude, losing about 50 ft per minute. Due to a thunderstorm at the departure airport, he elected…NTSB CHI88DER03Accident · No injuriesFinal reportCessna 172K · Mora, MNDrg flt, one of the plts demonstrated a negative 'g' maneuver by entering a climb, then making a 'push over' to a descent. He throttled back on the back side of the maneuver to maintain airspeed. When the throttle was readvanced, there was no eng response.…NTSB CHI88LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNThe student pilot was making the fourth leg of a solo cross country flight totalling 314 nautical miles. Although he departed with full fuel, none was added during the trip. The aircraft experienced a power failure, due to fuel exhaustion, approximately five…NTSB CHI88DER01Accident · No injuriesFinal reportPiper PA-22 · Mcgrath, MNDuring a solo cross-country flight, the aircraft sustained a power loss due to failure of the #3 connecting rod. Subsequently, the student pilot made an emergency landing in a swamp and the aircraft was damaged.NTSB CHI87LA182Accident · No injuriesLimited investigationFinal reportPiper J3 · Vermillion Lake, MNWhile attempting to return to land after the loss of power, the right wing tip hit the water and the aircraft flipped upside down into the lake. According to a mechanic who inspected the aircraft after the accident, the coils and condensers on both magnetos…NTSB CHI87IA100Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Minneapolis, MNThe aircraft landed uneventfully after the right engine failed during a descent. The shutdown occurred after failed antirotation pins allowed gas loads to drive normally stationary third stage vane clusters in the low pressure turbine area. Rotation of the…NTSB CHI85LA283Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Roseau, MNThe aircraft had been airborne about 15 min engaged in ag spray operations when the pilot described hearing a loud band. Engine power decreased to idle. Pilot ld in soft soil and nosed over inverted. Exam disclosed #2 piston had failed.NTSB CHI85LA220Accident · No injuriesLimited investigationFinal reportCessna 150H · Montevideo, MNThe purpose of the flt was to demonstrate the acft to a possible buyer. While taking off, the eng lost power shortly after the acft lifted off at about mid-field. The plt attempted to turn the acft & land on a cross-runway. However, due to his low speed & low…NTSB CHI85LA144Accident · No injuriesLimited investigationFinal reportChampion 7EC · Lake Elmo, MNOn takeoff, at about 150 ft AGL, all power was lost and the pilot executed a forced landing on the airport. Post-accident inspection revealed contamination in the fuel manifold valve.NTSB CHI85LA099Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Alexandria, MNThe acft on a ferry flt after an annual insp was on to climb 100 ft AGL when power began to deteriorate while manuvering to ld on an adjacent runway the acft struck a VASI installation and ground impacted no 5 lower spark plug improper installationNTSB CHI84LA116Accident · Minor injuriesLimited investigationFinal reportNavion A · Newport, MNThe acft engine failed when the plt applied carburator heat to try to 'cure' a rough running engine. Post accident investigation revealed a hole in the left muffler and shroud allowing burnt exhaust gases to enter the carburetor when carburetor heat was…NTSB CHI84LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Northfield, MNThe plt stated that while enroute at an alt of 3000 ft MSL the eng failed. He also stated that all attempts to restart the eng failed so he proceeded to make an emergency landing. Investigation revealed a manufacturing defect in the left magneto; the body…NTSB CHI83LER02Accident · No injuriesFinal reportCessna T188C · Olivia, MNDuring takeoff the eng lost power & the acft crashed landed collapsing the gear. The crankshaft, P/N631716, had broken in the cheek area between #2 & #3 crank throws. 1 month prior to this accident the acft had collided with a fence. Afterinstalling a new…NTSB CHI83LA252Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Blackduck, MNThe acft made a hard landing in an alfalfa field after loss of engine power. During an enroute portion of this flt the pilot stated that oil consumption was excessive. He planned an intermediate stop for that reason. Before reaching the intermediate stop the…NTSB CHI83LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Ely, MNAbout 2 min after takeoff, at about 1,000 ft AGL, the eng siezed. The plt then glided onto a frozen lake. The acft did not have a current annual inspection. The last oil change recorded was during the annual on 7/15/81. Engine teardown revealed severe…NTSB CHI82DA301Accident · No injuriesFinal reportHiller 12E · Palisade, MNAircraft lost power, pilot autorotated at 20 feet AGL. Made hard forced landing and aircraft rolled over. Piston rod failed because cap bolt was undertorqued.NTSB CHI82DA067Accident · No injuriesFinal reportPiper PA-28-140 · Lakerville, MNWhile on downwind, the pilot moved the fuel selector to what he believed was the left tank position. He also moved the throttle to idle to simulate an engine failure. He extended his pattern to allow time for another pilot to back-taxi down the runway to the…