NTSB investigations, MN
24 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 2 |
| 1994 | 2 |
| 1996 | 2 |
| 1998 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2004 | 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\" = 352)
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" = 352) 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 CHI04CA237Accident · Serious injuriesData collectionFinal reportEnstrom F-28A · Leroy, MNThe partial loss of engine power due to the missing 1/8-27 NPT Allen plug as a result of other maintenance personnel undertorquing the plug. Additionally, the pilot improperly excecuted a run on landing. A factor was the loss of tail rotor effectiveness.NTSB CHI01LA229Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge Center, MNThe pilot not maintaining directional control on the ground during the takeoff roll. Factors relating to this accident were the total failure of the propeller governor and the corn crop.NTSB CHI00LA274Accident · Minor injuriesLimited investigationFinal reportWidner Pietenpol Aircamper · Andover, MNThe trees and the unsuitable terrain for landing encountered during the forced landing. Factors were the side slip to avoid the trees initiated by the pilot, the fractured piston, and the cracked cylinder.NTSB CHI00LA220Accident · Serious injuriesLimited investigationFinal reportFloroski Anderson Kingfisher · Deerwood, MNthe open carburetor heat air box resulting in a loss of engine power, the diminished climb rate and the altitude/clearance not possible by the pilot. Factors were the trees and the bent carburetor heat push-pull rod.NTSB CHI98TA354Accident · No injuriesFinal reportBell 206B-3 · Hinkley, MNLoss of engine power due to failure of the engine governor.NTSB CHI98LA355Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · N. Ottawa Twp., MNA loss of engine power due to a worn piston ring. A related factor was the owner exceeded the manufacturer's recommended engine overhaul.NTSB CHI96FA348Accident · 1 fatalField investigationFinal reportCessna 172F · Saint Clair, MNa loss of power due to the engine's #2 cylinder exhaust valve stuck open, and the pilot's failure to maintain airspeed.NTSB CHI96LA132Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Anoka, MNA loose exhaust system that had become disconnected and blocked, which resulted in partial loss of engine power.NTSB CHI95LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Minneapolis, MNthe pilot's misjudging of distance and airspeed during the approach to landing which resulted in an overrun. Factors associated with the accident were the separation of the exhaust pipe and the pilot's not understanding communications from the air traffic…NTSB CHI94LA243Accident · Serious injuriesLimited investigationFinal reportInman Acro Sport 1 · Albert Lea, MNthe pilot's failure to make a precautionary landing on the remaining runway. Factors in the accident were the blocked fuel injector and inadvertent stall.NTSB CHI91DER13Accident · No injuriesFinal reportBell 47G-3B-1 · Maple Grove, MNThe pilot's failure to maintain directional control of the helicopter during the forced landing. Related factors are the loss of engine power, loss of rotor RPM, the eroded compressor blades, the pilot's operation with known deficiencies in equipment and…NTSB CHI91LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Mankato, MNPartial loss of engine power due to an unlocked engine primer. Factors related to the accident were that the pre takeoff check list was not followed by the pilot and the lack of suitable terrain for the forced landing.NTSB MKC89IA048Incident · No injuriesIncident investigationFinal reportGulfstream Commander 690A · St. Paul, MNThe PIC had prefltd his commander turboprop and prepared for takeoff fm the St. Paul arpt. During the takeoff roll just as the acft was rotated to takeoff attitude, the rt eng failed. The PIC eased the acft back to the rwy, reduced pwr and came to a stop on…NTSB CHI87DER04Accident · Minor injuriesFinal reportPiper PA-32-260 · Pine Center, MNAfter noticing a loss in oil pressure, the pilot initiated an emergency landing in a swamp. The aircraft impacted trees and received substantial damage. The pilot reported minor injuries. Subsequent investigation revealed that the oil sump contained several…NTSB CHI86LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grand Rapids, MNThe CFI and sp were returning from a transition. Enroute the #3 exhaust valve push rod failed. When the CFI smelled 'something burning' she shut down the engine. During the descent struck power lines. Acft ld in swampy terrain and nosed over inverted.NTSB CHI86LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pelican Rapids, MNThe exhaust valve rocker arm #1 cylinder failed in flight. The student pilot descended and landed in a wooded area. After over flying a frozen lake occupied by fishermen. The rocker arm exhibited evidence of fatigue.NTSB CHI85LA275Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Donaldson, MNWhen the plt applied pwr to level off while entering a spray the eng did not produce sufficient pwr to stop the descent. He attempted a run on landing but the uneven terrain caused substantial damage to the helicopter. Inspection of the eng revealed the…NTSB CHI85LA172Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · St. Paul, MNShortly after takeoff, while climbing thru aprx 700 ft AGL, the eng developed a severe vibration & a loud 'clanking' sound. These were followed by a partial loss of power. During a subsequent forced landing, the acft's right wing hit a tree & the nose gear…NTSB CHI84LA241Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Goodridge, MNThe acft was forced to land in a farm pasture after the engine lost power. Post accident examination of the acft revealed that the carburetor heat control was off. The right magneto was found to be very weak. A spark could only be produced at high RPM. The…NTSB CHI83FER01Accident · No injuriesFinal reportGoodyear FG1D · Crystal, MNThe plt reported that during the takeoff roll, there was a slight loss of manifold pressure. This was followed by a loud 'misfire', a futher loss of manifold pressure & a drop in the eng RPM. With an estimated 2000 ft of rwy remaining, he elect to abort &…NTSB CHI83LA255Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Crookston, MNThe acft collided with the ground after takeoff. The pilot said the acft lost power and felt sloppy at about 350 ft AGL.he added power but maximum obtainable was 2000 RPM as opposed to 2300. The pilot said he tried to drop the load but the load remained with…NTSB CHI83LA140Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Princton, MNThe pilot said that at 6000 feet MSL the engine began to miss and got worse. He tried to correct the situation but could not. He requested and was given vectors to the princeton arpt. The arpt was closed at the time due to snow covered ruts on the rnwy and…NTSB CHI82DA276Accident · No injuriesFinal reportPiper PA25-235C · Ada, MNThe pilot sprayed one field and proceeded to the next field about 2 miles away. He stated that he executed a tight 270 deg turn to the right at about 100 ft. he also stated that after about 90 deg through the turn, the aircraft lost power, stalled and…NTSB CHI82DA233Accident · No injuriesFinal reportCessna 150M · Santisgo, MNDuring aerial photo mission engine began to run rough. Pilot headed home but was forced to land enroute. Aircraft swerved and nosed over. Exam of engine showed exhaust valve stuck open.