NTSB investigations, MN
112 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 5 |
| 1984 | 6 |
| 1985 | 9 |
| 1986 | 8 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 6 |
| 1990 | 11 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 8 |
| 1995 | 1 |
| 1996 | 5 |
| 1997 | 1 |
| 1998 | 5 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 6 |
| 2005 | 3 |
| 2006 | 2 |
| 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\" = '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\" = 353)
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" = 353) 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 CHI07CA263Accident · Minor injuriesData collectionFinal reportCessna 180 · Princeton, MNThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A factor was the fuel siphoning from the right fuel tank.NTSB CHI06LA191Accident · No injuriesLimited investigationFinal reportCessna 120 · Laporte, MNThe inadequate preflight planning/preparation by the pilot and the loss of engine power due to fuel exhaustion during takeoff. A contributing factor was the runway marker.NTSB CHI06CA107Accident · No injuriesData collectionFinal reportCessna 150 · Sandstone, MNThe total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A contributing factor was the unsuitable terrain encountered during the forced landing.NTSB CHI06LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Marshall, MNA loss of engine power in both engines while on approach due to fuel exhaustion and the pilot's inaccurate fuel consumption calculations leading to him refueling the outboard tanks only.NTSB CHI06CA004Accident · Minor injuriesData collectionFinal reportCessna 172M · Lake Elmo, MNThe pilot's inadequate recovery from a bounced landing, which resulted in an overload failure of the nose landing gear. Contributing to the accident was a loss of engine power due to fuel exhaustion as a result of inadequate preflight planning by the pilot.NTSB CHI05TA251Accident · No injuriesFinal reportCessna 182R · New Ulm, MNThe loss of engine power for undetermined reasons resulting in a forced landing. A contributing factor was the soft terrain condition.NTSB CHI05CA005Accident · No injuriesData collectionFinal reportBuss Rotorway Exec · Eden Prairie, MNThe pilot's inadvertent deactivation of the battery switch leading to the helicopter's loss of engine power on base leg. A factor was the crops he encountered during the emergency landing.NTSB CHI04CA252Accident · No injuriesData collectionFinal reportCessna T310R · Marshall, MNThe pilot rated passenger selecting an improper fuel selector position, and the pilot in command not verifying the fuel selector position which resulted in fuel starvation. Contributing factors were the pilot's failure to feather the right engine propeller…NTSB CHI04CA143Accident · No injuriesData collectionFinal reportCessna 150F · Forest Lake, MNThe pilot's inaccurate fuel consumption calculations which resultied in fuel exhaustion and loss of engine power. Factors associated with the accident were the dark light conditions and the water on which the forced landing was made.NTSB CHI04CA122Accident · No injuriesData collectionFinal reportCessna 180J · South St. Paul, MNThe total loss of engine power during takeoff climb due to fuel starvation as a result of the pilot's failure to follow the aircraft's checklist and leaving the fuel selector in the OFF positon.NTSB CHI04CA108Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Minneapolis, MNThe pilot not verifying the position of the fuel selector prior to the takeoff, resulting in the loss of engine power during initial climb due to fuel starvation. Factors to the accident were the power pole and the trees.NTSB CHI04CA105Accident · Minor injuriesData collectionFinal reportCessna A185E · Hastings, MNThe pilot not verifying the fuel selector valve's position during the preflight leading to the fuel starvation and subsequent loss of engine power during the flight's initial climb.NTSB CHI03LA223Accident · No injuriesLimited investigationFinal reportCessna 172H · Red Wing, MNThe pilot's failure to follow the checklist resulting in fuel starvation and subsequent loss of engine power.NTSB CHI02LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Moorhead, MNThe inadequate fuel management by the certified flight instructor.NTSB CHI02LA129Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Watertown, MNThe improper fuel management by the pilot which resulted in fuel starvation and subsequent loss of engine power. Contributing to the accident was the soft terrain in which the forced landing was completed.NTSB CHI01LA179Accident · Serious injuriesLimited investigationFinal reportCessna T310P · St. Cloud, MNthe fuel starvation. Fuel management by the pilot was an additional cause. The muddy terrain was a contributing factor.NTSB CHI01LA115Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180AC · Buffalo, MNthe water contamination of the aircraft's fuel system and the inadequate preflight performed by the pilot. The muddy terrain was a contributing factor.NTSB CHI01LA045Accident · No injuriesLimited investigationFinal reportLarson Aero COMP-6 · Brainerd, MNThe pilot's inadequate preflight of the airplane which resulted in fuel exhaustion. Factors associated with the accident were the loose fuel cap and the snow covered terrain.NTSB CHI00FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Brownton, MNIn flight collision with the terrain for undetermined reason.NTSB CHI99LA130Accident · No injuriesLimited investigationFinal reportBell 206B · Cloquet, MNThe pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power. Related factors were the pole and dusk light conditions.NTSB CHI98LA338Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Int'L Falls, MNinaccurate preflight planning which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. A factor associated with the accident was the tree which the airplane contacted during the forced landing.NTSB CHI98LA334Accident · No injuriesLimited investigationFinal reportCulver-Revolution Mini 500 · Eden Prairie, MNa design change to the fuel tank filler neck sealant made by the owner/builder of the helicopter. Factors associated with this accident were an improper sealant material used by the owner/builder and an autorotation was not possible by the pilot due to the…NTSB CHI98LA331Accident · No injuriesLimited investigationFinal reportCessna 172N · Detroit Lakes, MNAn inadequate preflight inspection by the pilot which resulted in fuel exhaustion and subsequent loss of engine power.NTSB CHI98LA291Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Plainview, MNThe pilot's not achieving the proper descent rate prior to touchdown. A factor related to the accident was fuel starvation due to a low fuel level.NTSB CHI98LA157Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Tower, MNthe pilot's inadequate preflight of the airplane's fuel system, and fuel exhaustion, which resulted in a loss of engine power, due to an inadequate supply of fuel.NTSB CHI97LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Franklin, MNThe pilot's inadequate inflight planning and his fuel mismanagement, which resulted in fuel exhaustion and the loss of engine power. A contributing factor with this accident was a frost blocked cockpit windshield.NTSB CHI96LA331Accident · No injuriesLimited investigationFinal reportCessna 182 · Eden Prairie, MNthe pilot's misjudging the fuel supply and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.NTSB CHI96LA226Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 Viking · Alexandria, MNthe flight instructor's failure to assure a proper fuel tank selector position. Factors associated with the accident were improper preflight preparation and complacency by the flight instructor.NTSB CHI96LA195Accident · No injuriesLimited investigationFinal reportCessna 150M · Red Wing, MNthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply. A factor relating to the accident was: soft terrain in the emergency landing area.NTSB CHI96LA129Accident · Minor injuriesLimited investigationFinal reportCessna T310Q · Minneapolis, MNthe inadequate fuel supply for the intended flight which resulted in fuel exhaustion. Factors related to the accident were the pilot operating the airplane with an inoperative fuel gauge and the embankment which the airplane traveled down during the forced…NTSB CHI96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Paul, MNthe pilot's failure to assure an adequate fuel supply for the flight which resulted in fuel exhaustion. A factor associated with the accident was the signs contacted by the airplane during the forced landing.NTSB CHI95LA311Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Staples, MNthe pilot's delay in the application of carburetor heat, which resulted in carburetor ice, loss of engine power, and a subsequent forced landing in a swampy area. The carburetor icing (weather) condition was a related factor.NTSB CHI94LA336Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNAn inadequate pre-flight inspection by the pilot when he did not insure that all the water was drained from the airplane's fuel tanks. Factors associated with this accident were contaminated fuel and powerlines.NTSB CHI94DER03Accident · Serious injuriesFinal reportSmart CP 301 · Remer, MNthe failure of the alternator/electrical system, and subsequent total loss of engine power during cruise flight over wooded terrain.NTSB CHI94LA244Accident · No injuriesLimited investigationFinal reportMontana Coyote · Blaine, MNthe loss of engine power due to the blocked vent line.NTSB CHI94LA232Accident · No injuriesLimited investigationFinal reportCessna 180 · Battle Lake, MNloss of engine power due to fuel exhaustion which resulted from inaccurate fuel consumption calculations. A factor related to the accident was the inaccurately placarded fuel tanks.NTSB CHI94LA224Accident · No injuriesLimited investigationFinal reportCessna 150 · Andover, MNthe flight instructor's improper procedures and directives by electing to pull the mixture control to the 'off' position during simulated emergency procedures. A factor associated with the accident is the existence of weather conditions conducive to…NTSB CHI94LA219Accident · No injuriesLimited investigationFinal reportCessna 150M · Waseca, MNinadequate preflight planning/preparation and the pilot's failure to refuel the airplane. Factors related to the accident were a poorly planned forced landing approach and high vegetation.NTSB CHI94LA163Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Kettle River, MNThe pilot's improper use of carburetor heat and the lack of suitable terrain for a forced landing. The carburetor icing weather condition was a factor.NTSB CHI94LA144Accident · No injuriesLimited investigationFinal reportHelio H-800 · Foley, MNThe pilot-in-command's failure to perform accurate fuel consumption calculations. A factor was the soft gravel road landing area.NTSB CHI94LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Little Falls, MNan improper preflight by the pilot-in-command and the pilot's failure to maintain airspeed during a turn. A factor associated with the accident was contaminated fuel.NTSB CHI94LA059Accident · No injuriesLimited investigationFinal reportBeech C23 · Eden Prairie, MNan inadequate preflight by both the CFI and student pilot. Factors contributing to the accident was poor communications between the CFI and student pilot, and hilly terrain.NTSB CHI93LA300Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Ortonville, MNthe pilot's failure to refuel prior to fuel exhaustion.NTSB CHI93LA184Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Ely, MNthe pilot's decision to continue flight with a known deficiency in the airplane's hydraulic system. Factors associated with the accident are the loss of power in the left engine due to fuel contamination, and a leak in the hydraulic system.NTSB CHI93LA037Accident · 1 fatalLimited investigationFinal reportCessna 172 · Elk River, MNFailure of the pilot to refuel the airplane before the flight.NTSB CHI93LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNThe pilot's failure to select a proper fuel selector position.NTSB CHI92DER01Accident · Serious injuriesFinal reportGoehring Quickie · So. St. Paul, MNA loss of engine power due to carburetor ice. The lack of suitable terrain for the forced landing was a factor.NTSB CHI92LA163Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, MNThe pilot's improper preflight inspection.NTSB CHI91LA250Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Loman, MNFuel exhaustion due to fuel consumption calculations misjudged by the pilot.NTSB CHI91LA206Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlos, MNThe pilot's failure to use adequate carburetor heat. Factors to the accident were the carburetor icing conditions and the wires.