NTSB investigations, WI
110 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases, newest first
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\" = 'WI' 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" = 'WI' 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 CHI91LA060Accident · No injuriesLimited investigationFinal reportCessna 150D · Ft. Atkinson, WIThe pilot's failure to refuel. A factor was unsuitable terrain for landing.NTSB CHI90DEP11Accident · Minor injuriesFinal reportVarga Kachina 2150A · Neenah, WIThe pilot's misjudgement of the fuel supply, and his failure to refuel the aircraft. Contributing to the accident was the unsuitable, soft terrain encountered.NTSB CHI90LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFuel exhaustion. Contributing factor was the unsuitable terrain.NTSB CHI90DEP10Accident · No injuriesFinal reportBrose Cirrus VK-30 · Baraboo, WIThe pilot's inadequate preflight and misjudgement of the amount of fuel on board, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. The inoperative fuel totalizer was a related factor.NTSB CHI90FA208Accident · Serious injuriesField investigationFinal reportLockheed 12A · Oshkosh, WIThe inadequate emergency procedure(s) by the pilot in command following a loss of engine power for undetermined reasons(s).NTSB CHI90LA164Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Cornell, WIThe pilot's inadequate preflight resulted in a loss of engine power due to contamination in the fuel system.NTSB CHI90LA157Accident · Minor injuriesLimited investigationFinal reportBeech K-35 · Oshkosh, WIFuel mismanagement.NTSB CHI90DEP03Accident · No injuriesFinal reportJames A Nelson ZEN AIR CH701 · Raymond, WIManufacturer's inadequate design of the fuel drain. Contributing was the pilot-in-command's disregarding the fuel supply which resulted in fuel exhaustion.NTSB CHI90LA046Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lacrosse, WIThe student pilot's improper pre-flight planning/preparation, which did not include a plan to refuel the aircraft as necessary. The student pilot's lack of total experience contributed to this accident, as did the cfi's inadequate supervision of the student.NTSB CHI90LA035Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Barron, WIImproper use of the carburetor heat by the pilot and subsequent carburetor ice. Contributing factors were: carburetor icing conditions, slick (wet/snow covered) runway, and trees/brush near the departure end of the runway.NTSB CHI89FA150Accident · No injuriesField investigationFinal reportProspector FK-1 · Chilton, WIThe pilot's poor in flight planning in that he diverted his attention and continued the flight beyond the original period planned. Before takeoff the pilot was aware of his fuel endurance.NTSB CHI89DEP09Accident · No injuriesFinal reportCabrinha/Free Spirit 412 · Waukesha, WIThe plt became lost/disoriented and allowed fuel exhaustion to occur before accomplishing remedial action. Factors related to the accident were: the adverse environmental conditions and the road sign and vehicles in the emergency landing area.NTSB CHI89LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Iola, WIThe improper preflight planning by the pilot in command resulting in the airplane fuel quantity being near the unusable quantity which resulted in total loss of engine power due to fuel starvation while maneuvering. Contributing to the accident was the pilots…NTSB CHI89DEP06Accident · Minor injuriesFinal reportAeronca 15AC · Fort Atkinson, WIWater contamination of the fuel and the pilot's inadequate preflight. Factors related to the accident were: lack of suitable terrain for a forced landing & trees.NTSB CHI89LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Necedah, WIPilot-in-command's improper use of the fuel selector.NTSB CHI89DEP05Accident · Minor injuriesFinal reportPiper PA-25-235 · Suring, WIImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel. Factors related to th accident were: the lack of suitable terrain and trees in the emergency landing area.NTSB CHI89LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Osceola, WIInadequate preflight by the student pilot, inadequate supervision (to assure a proper preflight) by the instructor pilot (CFI), and water contamination of the fuel. The terrain was considered to be a contributing factor.NTSB CHI88LA232Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Watertown, WIThe pilot in command's improper selection of the fuel tank, and his subsequent failure to maintain control of the aircraft.NTSB CHI88DEP10Accident · No injuriesFinal reportPiper PA-25-235 · Beaver Dam, WIWhile in cruise flight the aircraft experienced a total loss of power due to fuel exhaustion. The pilot stated that there were no good landing areas available, so he elected to make the emergency landing in a marsh. The aircraft landed hard and sustained…NTSB CHI88FAMS2Accident · Serious injuriesMissing aircraftFinal reportMooney M20K · Racine, WIEngine failure due to fuel starvation.NTSB CHI88DEP08Accident · No injuriesFinal reportMonnett Sonerai II · Wisc Rapids, WIThe plt rprtd that drg takeoff, the eng lost power as the acft was climbing thru about 200' AGL. An emerg lndg was made in the best available area, which was a golf course on rolling terrain. Drg the lndg roll, the plt applied brakes, but was unable to stop…NTSB CHI88DEP07Accident · No injuriesFinal reportCessna 182B · Burlington, WIDrg a normal dscnt, in preparation to land, the eng lost all power. The plt made an emerg landing, but drg the landing roll-out, the nosewheel enctrd soft, uneven terrain & the acft nosed over. No fuel was found in the fuel tanks or carburetor float bowl, but…NTSB CHI88LA142Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Kenosha, WIThe pilot was picking up the aircraft after being serviced when approximately 20 minutes after taking off the engine quit. The pilot was forced to make an emergency landing in a field. During the landing sequence the aircraft contacted some trees at the edge…NTSB CHI88LA125Accident · Minor injuriesLimited investigationFinal reportCessna TU206B · Ellsworth, WIDuring cruise flight the pilot experienced an engine failure which he believed to be caused by fuel exhaustion, and executed a forced landing in unsuitable terrain. Post accident inspection revealed that the left fuel tank contained 23 gallons of fuel at the…NTSB CHI88LA116Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · La Crosse, WINTSB CHI88LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Mt. Pleasant, WIThe stu plt climbed to 1600 ft MSL aft tkof. Shortly aft level off, the engine stopped. He attempted an air start without success. During the forced lndg the nose wheel dug in and the acft nosed over in the soft soil. During a post crash interview, the stu…NTSB CHI87FA187Accident · No injuriesField investigationFinal reportPiper PA-28 · Fairwater, WIWhen the plt attempted to add pwr to level off from a dscnt, the eng did not respond. He then applied carb heat & tried to restart the eng, but to no avail. During an emerg landing, the acft touched down with a tailwind, struck a fence & skidded to a stop in…NTSB CHI87LA131Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Neillsville, WIA student & instructor (CFI) were on a dual x-country flt fm elroy to Neillsville & rtrn. The flt to Neillsville was uneventfull. After the acft was on the gnd aprx 20 min, hot starting procedures were used to start the eng for the rtrn flt. Eng runup &…NTSB CHI87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Oshkosh, WIAccording to the plt, at aprx 1800 feet 'the engine abruptly quit with no runon or sputter' following takeoff from rwy 18 at Oshkosh, WI. The plt stated that he banked the acft back to the airport, but the aileron controls became jammed or 'frozen'. According…NTSB CHI86LA214Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Menominee Falls, WIThe plt stated that the eng had quit 3 times in the past 2 weeks. The purpose of the flt was to insure that the eng was working properly. During takeoff, it lost power at about 100 ft AGL. The plt tried to turn & land on the sw part of the arpt. However, a…NTSB CHI86FA192Accident · No injuriesField investigationFinal reportCessna 177RG · Oshkosh, WIThe IFR flt experienced an engine failure during the landing apch to the destination aprt in Oshkosh, WI, and the plt ditched the acft in lake winnebago. Exam of the acft showed that the eng failed due to fuel exhaustion. The plt reported there were 60…NTSB CHI86FEP04Accident · No injuriesFinal reportDay Skybolt DB · Wisconsin Rapid, WIThe plt thought he had sufficient fuel for a 'short trip around the pattern.' However, shortly after taking off from rwy 29, the eng began to lose power. The plt attempted to land on rwy 2, but all power was lost & he was unable to reach the rwy. He landed…NTSB CHI86FEP03Accident · Minor injuriesFinal reportSteinorth Extra Long EZ · Kenosha, WIDuring an apch to land, the eng of the home built acft lost power. The plt tried to restart the eng by using the ignition switch, but was unable. He turned to land in a pasture, but the acft hit an electrical wire & came to rest in a row of trees. The plt…NTSB CHI86LA053Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glidden, WIThe aircraft collided with powerlines while attempting a power off landing after engine stoppage. The fuel tanks were inspected and there was no fuel in the right tanks and only a small quantity in the lft tank. The engine was tested and found to function…NTSB CHI86FA017Accident · 1 fatalField investigationFinal reportBell 47G-5 · Plainfield, WIThe acft crashed into trees and nosed into the wooded terrain after a loss of powr. The helicopter had been refueled the day before the acc. Normal fuel load was 20 gals. The plt had sprayed 20 acres & flown 9 miles to another field to spray but aborted due…NTSB CHI85FA325Accident · No injuriesField investigationFinal reportPiper PA-28-181 · Eureka, WIPrior to takeoff the pilot calculated that with 48 gallons of fuel he could make the four hour flight to oshkosh with one hour of fuel to spare. Upon arriving at a point 25 mi sw of oshkosh he received a request to descend 1200 ft, a request to climb 1200 ft…NTSB CHI85LA324Accident · No injuriesLimited investigationFinal reportBoeing E75 · Delavan, WIThe acft nosed over during a forced lndg after the eng quit. The plt said he ran out of fuel.NTSB CHI85LA307Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Sheboygan, WIThe acft collided with a ditch during a forced landing following a loss of power in cruise flt. The plt reported he switched the fuel selector from the left to the right tank, & after aprx 3 minutes, a total loss of power was experienced. He stated that…NTSB CHI85LA304Accident · Serious injuriesLimited investigationFinal reportCessna 210H · Burlington, WIPilot estimated 15 gals of fuel at preflt. After 15 min grd delay due to traffic pilot tookoff and climbed to 2,500'MSL. After cruising 22 nmi the engine quit due to fuel exhaustion. During attempt to ld in corn field pilot attempted to stretch his glide and…NTSB CHI85LA279Accident · No injuriesLimited investigationFinal reportCessna 150F · Fond Du Lac, WIThe acft nosed over in soft terrain 1/4 mile short of the rwy at fon du lac arpt following a total loss of pwr. The flt departed henderson, KY, at 1510 CDT with 26 gallons of fuel and the pwr loss occurred at 1925 CDT, 4 hrs and 15 minsafter departure. Post…NTSB CHI85LA264Accident · No injuriesLimited investigationFinal reportCessna 172H · Coleman, WIThe pilot departed on a short x-country flt. Stated fuel aboard was 8 gls. Pilot diverted from drct flt and ran out of fuel after one hour airborne. Ld in farm field. Struck a post with resultant sub damage to airframe.NTSB CHI85LA192Accident · No injuriesLimited investigationFinal reportCessna A152 · West Bend, WIPlt departed fondulac, WI, with full fuel (24.5 gallons usable) and flew aprx 25 miles south where 2 1/2 hrs were spent taking aerial photographs. Flt then proceeded aprx 60 miles to manitowoc, WI where a landing was made. Departure was then made with aprx 9…NTSB CHI84LA339Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Washington Is., WIThe acft stalled and crashed after the engine lost power at about 50 ft AGL during takeoff. The acft caught fire after touchdown. The fire consumed the cockpit and cabin. An examination of wreckage showed the fuel selector on the left tank. The left tank had…NTSB CHI84LA316Accident · No injuriesLimited investigationFinal reportCessna 150H · Menomonie, WIThe plt was disoriented during a x-country and circled the wrong area looking for an arpt until low fuel demanded a landing. During the approach the engine quit and the acft nosed over in a bean field during landing.NTSB CHI84FA303Accident · 3 fatalField investigationFinal reportCessna 421 · Birchwood, WIDuring flt, the plt transmitted to ARTCC 'we've got a problem, we're losing altitude.' The controller provided a vector to the nearest arpt, but shortly after that, the plt stated that he would not be able to reach the arpt. The plt did not inform ARTCC of…NTSB CHI84LA174Accident · Serious injuriesLimited investigationFinal reportGable Sonerai II · Berlin, WIThis homebuilt acft stalled during a forced landing after an engine failure. The plt reported that the engine temperature went to 650 degrees which was an overheat condition. The plt stated that he tried to return to the arpt but stalled 20 ft short of rwy 27…NTSB CHI84LA166Accident · Minor injuriesLimited investigationFinal reportGrumman AA5A · Cudahy, WIThe acft struck a storage shed while attempting to reach a golf course during an emergency landing in gusty wind conditions. There were no visible signs or odor of fuel at the accident site. When the acft was inspected the carburetor and fuel sumps were…NTSB CHI84LA164Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Bloomer, WIPlt failed to visually check fuel tanks after they were refueled. On the second leg of a x-country fuel exhaustion occurred. The acft nosed over during the forced landing on soft terrain.NTSB CHI84LA161Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa City, WIAfter takeoff, the plt had made 2 turns & had attained an alt of about 200 ft AGL when the eng sputtered & lost power. He was unable to turn & land on the rwy, but continued straight ahead to avoid houses & trees. During an emergency landing, the acft…NTSB CHI84LA132Accident · Minor injuriesLimited investigationFinal reportCessna 337A · Genesee, WIThe acft made a forced landing after the engine lost power. The acft was inspected after the accident and found to contain no usable fuel. When the fuel was drained from the auxiliary tanks, the fuel quantity indicators showed five gallons in each tank.