NTSB investigations, WA
142 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\" = 'WA' 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" = 'WA' 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 SEA95LA096Accident · No injuriesLimited investigationFinal reportCessna A185F · Oroville, WAWater contamination in the fuel, and the pilot's inadequate preflight of the aircraft before flight. Factors related to the accident were: deteriorated seal(s) on the fuel tank cap(s), non-compliance with an airworthiness directive to prevent water leaking…NTSB SEA95LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Tacoma, WAFuel starvation due to an unlocked mixture control that had not been properly rigged. A factor was the ditch in the emergency landing area.NTSB SEA95FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Seattle, WAFuel exhaustion, and the pilot's failure to refuel en route. Factors include a dark night and ditching in the waters of puget sound.NTSB SEA95LA026Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Kent, WAFuel starvation due to the unporting of the useable fuel supply, and the pilot's failure to follow the airplane's published engine starting procedures after the loss of fuel flow during descent. Factors contributing to the accident are the pilot's lack of…NTSB SEA95LA013Accident · No injuriesLimited investigationFinal reportHiller UH-12E4 · Morton, WAA leak in the fuel filler cap and water in the fuel system. A factor to the accident was: inadequate preflight.NTSB SEA94LA217Accident · Minor injuriesLimited investigationFinal reportAllen D. Potts WAG-A-BOND · Benton City, WAFuel starvation and inadequate compensation for wind conditions. A factor to the accident was soft terrain.NTSB SEA94LA176Accident · No injuriesLimited investigationFinal reportBambrick Corben ACE · Arlington, WAFuel starvation due to the builders' inadequate design of the fuel system. Factors include high ambient temperatures during the climb, and a fence in the field where the forced landing took place.NTSB SEA94LA094Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Rimrock, WAFuel exhaustion, the pilot in command's failure to refuel the aircraft, and the inability to successfully execute an auto- rotation landing because of the low altitude.NTSB SEA94LA041Accident · No injuriesLimited investigationFinal reportCessna 150J · Tonasket, WAThe pilot's failure to attain a proper touchdown point. Factors include an inadequate preflight, fuel exhaustion, and an icy landing area.NTSB SEA93FA102Accident · 1 fatalField investigationFinal reportCessna 172C · Darrington, WAFuel exhaustion and the pilot in command's inadequate refueling of the aircraft.NTSB SEA93LA059Accident · No injuriesLimited investigationFinal reportCessna A185F · Inglewood, WAFuel exhaustion, the pilot in command's inadequate preflight, and his failure to flare on landing. A factor contributing to the accident was fog.NTSB SEA93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Spokane, WAInadequate preflight planning/preparation. Factors to the accident were: fuel exhaustion and inadequate fuel consumption calculations.NTSB SEA92LA189Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Concrete, WAThe loss of engine power due to fuel exhaustion, resulting from the IMPR0PER in-flight planning by the pilot in command and his failure to select a proper touchdown point for an emergency forced landing. A factor relating to the accident was the uneven…NTSB SEA92LA184Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Mattawa, WALoss of engine power due to fuel contamination as a result of inadequate maintenance by the operator. A factor contributing to the accident was soft terrain.NTSB SEA92LA141Accident · No injuriesLimited investigationFinal reportBell-World 47D1 · Wenatchee, WACarburetor ice and the pilot in command's not being able to maintain clearance. Factors contributing to the accident were: carburetor icing conditions and tree(s).NTSB SEA92LA073Accident · No injuriesLimited investigationFinal reportEnstrom 280 FX · Mount Vernon, WAA hard landing by the pilot, after a power loss due to fuel exhaustion.NTSB SEA92LA062Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Elbe, WAFuel starvation, improper fuel, improper aircraft servicing (fueling), and clearance not possible. Factors contributing to the accident were: no suitable terrain, low ceilings, dusk and trees.NTSB SEA92LA037Accident · No injuriesLimited investigationFinal reportCessna 150L · Tacoma, WAThe pilot's improper use of remedial action when he encountered carburetor icing. Factors include carburetor ice and carburetor icing conditions.NTSB SEA92FA024Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Everett, WAFuel starvation due to improper procedures by the pilot-in-command. Factors include lack of familiarity with the aircraft, non-functioning flight compartment lights, and non-suitable terrain.NTSB SEA92LA003Accident · No injuriesLimited investigationFinal reportCessna 337A-RG · Snohomish, WAFuel system starvation, due to the pilot's improper fuel tank selection. Factors include procedures not being followed, and inattentiveness.NTSB SEA91FA142Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Goldendale, WAThe pilot's misjudgement of fuel supply.NTSB SEA91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Auburn, WAAn improper fuel selector valve handle, improper selection of the fuel selector position, and the pilot's lack of understanding of the fuel selector position.NTSB SEA91LA083Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Port Orchard, WAThe loss of engine power due to contaminated fuel system.NTSB SEA91FA069Accident · 2 fatalField investigationFinal reportCessna 150G · Kennewick, WAImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and his failure to maintain adequate airspeed, while maneuvering to make a forced landing, which resulted in a stall.NTSB SEA91FA025Accident · Serious injuriesField investigationFinal reportPiper PA31 · Enumclaw, WAFuel exhaustion due to inadequate preflight planning and preparations, and poor inflight planning and decisions. The pilot elected to fly into known adverse weather conditions, and did not calculate fuel consumption for the planned flight.NTSB SEA91LA015Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Port Townsend, WAThe pilot's failure to use carburetor heat which resulted in a loss of engine power and a forced landing.NTSB SEA91LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210K · Everett, WAA loss of engine power for undetermined reasons.NTSB SEA90LA140Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAThe pilot's failure to ensure an adequate supply of fuel, which resulted in fuel exhaustion.NTSB SEA90LA127Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Renton, WALoss of engine power due to fuel starvation. The cause of the accident was the pilot displayed poor inflight planning by not adequately following procedures or directives associated with fuel consumption.NTSB SEA90LA092Accident · No injuriesLimited investigationFinal reportCessna 182A · Tekoa, WAThe pilot turned off the carburetor heat while descending for landing in conditions conducive to carburetor icing.NTSB SEA90LA075Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Pomeroy, WAA malfunctioning fuel injection system and the pilot's attempted operation above certificated maximum gross weight with a known deficiency in this equipment.NTSB SEA90LA051Accident · No injuriesLimited investigationFinal reportCessna 150J · Graham, WALoss of engine power due to fuel exhaustion and inadequate remedial action after bouncing/ballooning during the forced landing. The pilot's inadequate preflight planning/preparation was a factor related to the accident.NTSB SEA90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bremerton, WAFuel exhaustion and inadequate preflight planning.NTSB SEA90LA018Accident · No injuriesLimited investigationFinal reportCessna 140 · Amboy, WALoss of engine power due to carburetor icing.NTSB SEA90LA017Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Vancouver, WAThe pilot's inadvertant leaning of the fuel mixture to near idle cutoff, causing the engine to quit.NTSB SEA89LA174Accident · Serious injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Kapowsin, WAAn undetermined loss of engine power.NTSB SEA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAThe pilot's failure to obtain current in-flight wind information in order to calculate that his remaining fuel supply was adequate to reach his final destination. Contributing was his inadequate preflight planning.NTSB SEA89LA128Accident · No injuriesLimited investigationFinal reportBell 206B · Longview, WAThe pilot inadvertently turning off the engine fuel supply instead of the external load fuel supply. Contributing to the accident was the pilot's failure to jettison the external load during the autorotation.NTSB SEA89FA104Accident · 1 fatalField investigationFinal reportAnderson BD-5 · Everett, WAInadequate maintenance by the pilot/owner/builder, his operation of the aircraft with a known deficiency, and his failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall.NTSB SEA89LA082Accident · No injuriesLimited investigationFinal reportCessna 172 · Woodland, WAThe pilot's poor planning and inadequate calculation of fuel consumption which resulted in fuel exhaustion.NTSB SEA89FA068Accident · 2 fatalField investigationFinal reportLake LA-4-200-EP · Bellevue, WALoss of engine power for an undetermined reason and failure of the instructor pilot (CFI) to maintain control of the aircraft, which resulted in a stall/spin.NTSB SEA89LA012Accident · Serious injuriesLimited investigationFinal reportLaycock Baby Great Lakes · Graham, WAEng lost pwr while in cruise on local flt. Plt attempted to return to field but contacted trees during emerg descent to forced lndg. Investigation revealed presence of water in fuel system. Fuel sediment bowl was automotive type with aviation drain installed.…NTSB SEA89FA002Accident · 2 fatalField investigationFinal reportCessna T210M · Prosser, WAThe flight was on initial climb after takeoff at 400 AGL when the engine quit. During the ensuing forced landing, the aircraft impacted on an interstate highway perpendicular to the roadway, bounced into open pasture land, impacted a rock berm and burst into…NTSB SEA88LA165Accident · No injuriesLimited investigationFinal reportLatham Alco Coupe · Bremerton, WAPlt had about 4 hrs exp in make and model and 116 hrs total pilot time. Flew 'about 2 hrs' on 15 gals fuel and was making touch and go lndgs when power was lost. Acft nosed over during forced lndg in soft terrain. There was no evidence of fuel on board.NTSB SEA88LA144Accident · No injuriesLimited investigationFinal reportCessna 172K · Moses Lake, WAWhile on his first x-country flt in this type aircraft, the pilot decided to land short of the destination due to low fuel. The engine quit from fuel exhaustion during descent. The aircraft nosed over on touchdown in a soft irrigated field one mile from the…NTSB SEA88FA113Accident · Minor injuriesField investigationFinal reportBeech 58P · Bellevue, WAThe plt reported that 20 gallons of fuel was added on may 18 and stated this brought the main tanks up to near full (160 gal). Between that fueling and the acc a total of 6.0 hours were recorded and an additional 80 gallons of fuel was added. Records at the…NTSB SEA88LA070Accident · No injuriesLimited investigationFinal reportCessna 305-A · Arlington, WAShortly after takeoff, at about 200 feet AGL, a total loss of power occurred. A forced landing was made onto a turf field next to the runway. During landing the aircraft nosed over inverted. The pilot stated to FAA inspectors that the aircraft had set outside…NTSB SEA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kennewick, WAAt about 75 feet AGL a total loss of power occurred. The plt landed on the remaining runway but overran the rwy, coming to rest 200 ft beyond the end. During the overrun, the nose gear struck a rock and the acft nosed over. The aircraft's fuel tanks contained…NTSB SEA87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Mount Vernon, WAThe aircraft's engine ceased operating due to fuel exhaustion about five miles short of the destination airport. A field was selected for the landing site. During the landing roll, the aircraft nosed over on freshly plowed terrain.NTSB SEA87FA178Accident · 1 fatalField investigationFinal reportPiper PA-20 · Chelan, WAThe pilot was observed making a engine out landing at his private grass/dirt strip. The dirt strip is located on a plateau with the runway starting at the edge of the plateau. The aircraft impacted in a steep nose down attitude below the runway level on a…