NTSB investigations, 2008

255 cases where the sequence of events included Loss of engine power (total).

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 year(c.\"eventDate\") = 2008
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB ANC08LA126Accident · No injuriesLimited investigationFinal reportPiper PA-19 · Palmer, AKA total loss of engine power for an undetermined reason.Sep 20, 2008 · N3267Y · Substantial damageNTSB DFW08CA236Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Augusta, KSA loose oil line that resulted in a total loss of engine oil, causing the engine to cease.Sep 18, 2008 · N6822J · Substantial damageNTSB CHI08IA294Incident · No injuriesIncident investigationFinal reportIndus T-211 Thorpedo · La Porte, INA loss of engine power due to fuel exhaustion as a result of siphoning from the fuel filler neck and cap. Contributing to the incident were the fuel over-servicing which resulted in the siphoning condition, and the ASTM standards which allowed for the fuel…Sep 18, 2008 · N107JF · Minor damageNTSB CHI08CA284Accident · No injuriesData collectionFinal reportFleet 2 · Leroy, OHThe loss of engine power due to the propeller hub failure during a low-level maneuver. Contributing to the accident were the trees encountered during the forced landing.Sep 17, 2008 · N764V · Substantial damageNTSB CHI08CA283Accident · Minor injuriesData collectionFinal reportMooney M20C · Bolingbrook, ILThe non-mechanical loss of engine power due to the pilot's incorrect positioning of the fuel tank selector prior to takeoff and the subsequent fuel starvation during takeoff.Sep 17, 2008 · N5651Q · Substantial damageNTSB DFW08FA228Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Wichita Falls, TXThe pilot's failure to maintain safe flying airspeed resulting in an inadvertent stall during the forced landing. Contributing to the accident was the loss of engine power due to carburetor icing.Sep 14, 2008 · N571JH · Substantial damageNTSB MIA08CA192Accident · No injuriesData collectionFinal reportBeech G-36 · Erie, PAThe pilot's improper landing flare resulting in a hard landing. Contributing to the accident was the pilot's improper preflight inspection of the fuel caps and his improper inflight fuel management, which led to a loss of engine power.Sep 11, 2008 · N710ND · Substantial damageNTSB LAX08LA292Accident · No injuriesLimited investigationFinal reportCessna T210N · Oakland, CAA loss of engine power while maneuvering due to the disintegration of the number two main bearing, which resulted in a fracture of the crankshaft. Contributing to the accident was inadequate maintenance.Sep 10, 2008 · N6278C · Substantial damageNTSB CHI08CA280Accident · Minor injuriesData collectionFinal reportCessna 150G · Urbana, OHA loss of engine power due to carburetor ice. Contributing to the accident were environmental conditions conducive to carburetor icing.Sep 10, 2008 · N3899J · Substantial damageNTSB ANC08CA121Accident · No injuriesData collectionFinal reportCessna 170 · Ruby, AKThe pilot's failure to use carburetor heat, while operating at a reduced engine power while maneuvering in carburetor icing conditions.Sep 9, 2008 · N2690V · Substantial damageNTSB NYC08LA311Accident · No injuriesLimited investigationFinal reportMooney M20J · Hackettstown, NJThe pilot's failure to adhere to the airplane manufacturer's published preflight inspection procedures, enabling water to remain undetected in the fuel system, which resulted in a complete loss of engine power immediately after takeoff.Sep 8, 2008 · N301KC · Substantial damageNTSB MIA08LA186Accident · No injuriesLimited investigationFinal reportTetrault Ronad Team Mini Max 1500R · Berkley, MAThe total loss of engine power due to the contamination of the combustion cylinders.Sep 7, 2008 · N43436 · Substantial damageNTSB NYC08LA306Accident · No injuriesLimited investigationFinal reportBeech G35 · Knoxville, TNThe pilot's improper fuel consumption calculations which resulted in total loss of engine power due to fuel exhaustion.Sep 6, 2008 · N4403D · Substantial damageNTSB DFW08LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Orange Grove, TXA total loss of engine power due to an improperly installed intake manifold tube.Sep 5, 2008 · N8979X · Substantial damageNTSB CHI08LA274Accident · Minor injuriesLimited investigationFinal reportSadler Vampire · Findlay, OHA total loss of engine power due to the failure of the reduction drive assembly as a result of excessive wear and high temperatures. Contributing to the accident were the pilot's lack of total experience in the airplane and the unsuitable terrain for a forced…Sep 3, 2008 · N333SV · Substantial damageNTSB SEA08LA195Accident · Minor injuriesLimited investigationFinal reportLancair Propjet · Camarillo, CAThe loss of engine power due to air within the fuel system.Sep 2, 2008 · N750PJ · Substantial damageNTSB NYC08LA299Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Cumberland, RIThe pilot's improper fuel management practices, which resulted in fuel starvation and a complete power loss. Contributing to the accident was the pilot's misdiagnosis of the situation, and his cessation of trouble-shooting to positively identify and correct…Sep 1, 2008 · N5529J · Substantial damageNTSB DFW08LA223Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Uvalde, TXA total loss of engine power due to the improper use of unauthorized replacement parts in the engine and repeated operation of the engine in an over-temperature condition.Sep 1, 2008 · N8472V · Substantial damageNTSB SEA08LA193Accident · Serious injuriesLimited investigationFinal reportWasson Loehle Loehle P-40 · Oregon City, ORThe loss of total engine power due to a cold seizure.Aug 31, 2008 · N510JW · Substantial damageNTSB ANC08LA113Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Galena, AKThe en route loss of engine power due to a mechanic's failure to tighten a fuel line fitting, which became disconnected in flight.Aug 31, 2008 · N4886U · Substantial damageNTSB SEA08LA191Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Burbank, CAThe pilot's improper preflight and in-flight planning, which resulted in fuel exhaustion. Contributing to the accident were the pilot's loss of situational awareness while conducting the normal and emergency checklists during his turn from base to final…Aug 30, 2008 · N172ST · Substantial damageNTSB NYC08FA298Accident · 1 fatalField investigationFinal reportMooney M20C · Lawrenceburg, TNA loss of engine power due to fuel exhaustion.Aug 30, 2008 · N6480U · Substantial damageNTSB CHI08CA275Accident · No injuriesData collectionFinal reportCessna 150H · Bay City, MIThe loss of engine power during descent due to carburetor icing. Contributing to the accident was the collapse of the nose landing gear due to rough terrain.Aug 30, 2008 · N23461 · Substantial damageNTSB SEA08LA190Accident · 1 fatalLimited investigationFinal reportLien Zodiac 601 XL · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control after the engine experienced a loss of power. Contributing to the accident was the mixture control arm separating from the fuel metering valve shaft.Aug 29, 2008 · N9881T · Substantial damageNTSB LAX08FA286Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Las Vegas, NVA loss of power in the right engine due to an in-flight fuel-fed fire in the right engine compartment that, while the exact origin could not be determined, was likely related to the right engine-driven fuel pump, its fuel supply line, or fitting. Contributing…Aug 28, 2008 · N212HB · Substantial damageNTSB NYC08CA295Accident · No injuriesData collectionFinal reportCessna 182A · Danielson, CTFuel exhaustion due to the pilot’s inadequate fuel consumption calculations.Aug 27, 2008 · N169DP · Substantial damageNTSB CHI08CA266Accident · No injuriesData collectionFinal reportAir Tractor AT-301A · Jasper, MNThe pilot's failure to assure the primer control was locked during the aircraft preflight. Factors associated with the accident were the low altitude at which the airplane was operating, the fence, the roadway, and the ditch.Aug 25, 2008 · N3654T · Substantial damageNTSB DFW08CA214Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Keller, TXThe pilot's inadequate preflight inspection of the airplane which resulted in an attempted takeoff without fuel present in the selected fuel tank.Aug 24, 2008 · N7653B · Substantial damageNTSB CHI08CA264Accident · No injuriesData collectionFinal reportCessna 172 · Pullman, MIA complete loss of engine power for undetermined reasons. A contributing factor was the rough terrain encountered during the forced landing.Aug 24, 2008 · N3901R · Substantial damageNTSB DFW08CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Wisner, LAThe loss of engine power for undetermined reasons.Aug 22, 2008 · N2391Z · Substantial damageNTSB DFW08CA211Accident · No injuriesData collectionFinal reportMurray Frank H DA5B · Odessa, TXFailure of the intake manifold when the flexible connectors disconnected from the carburetor after a turbulence encounter. Contributing to the accident was insuitable terrain for a forced landing.Aug 21, 2008 · N1002W · Substantial damageNTSB LAX08LA271Accident · No injuriesLimited investigationFinal reportHawker Sea Fury TMK 20 · Reno, NVA ruptured center balance diaphragm that resulted in a loss of engine power during final approach and subsequent forced landing on a desert floor.Aug 20, 2008 · N51SF · Substantial damageNTSB DFW08LA210Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caldwell, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's failure to secure the right wing's fuel cap, leading to fuel being siphoned from the tank during flight.Aug 20, 2008 · N92780 · Substantial damageNTSB SEA08FA185Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Olalla, WAThe complete loss of engine power due to the accumulation of ice in the carburetor as a result of the pilot's failure to use carburetor heat.Aug 17, 2008 · N301MA · DestroyedNTSB SEA08CA180Accident · No injuriesData collectionFinal reportCessna 177 · Glendale, AZThe loss of engine power due to vapor lock. Contributing to the accident was the high atmospheric temperature.Aug 17, 2008 · N29304 · Substantial damageNTSB NYC08LA280Accident · Minor injuriesLimited investigationFinal reportSocata MS894A · Fulton, NYA loss of engine power due to fatigue failure of the crankshaft and the No. 3 engine cylinder connecting rod as a result of improper machining of the engine crankshaft during engine overhaul by maintenance personnel.Aug 16, 2008 · N31BF · Substantial damageNTSB CHI08CA257Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Luverne, MNThe failure of the compressor turbine blades which resulted in the loss of power. Factors associated with the accident were the low altitude and the trees.Aug 16, 2008 · N7307W · Substantial damageNTSB CHI08CA255Accident · No injuriesData collectionFinal reportCessna 182C · Sparta, ILThe pilot's inadequate preflight/planning which resulted in the failure to assure an adequate fuel supply for the flight and the improper flare during the landing. Contributing to the accident was the ditch that the airplane contacted.Aug 16, 2008 · N8643T · Substantial damageNTSB DFW08CA207Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Abbeville, LAA total loss of engine power for undetermined reasons. Contributing to the accident was unsuitable terrain for a forced landing.Aug 15, 2008 · N8323R · Substantial damageNTSB CHI08CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301B · Monticello, IAPoor preflight planning in that the pilot failed to assure an adequate fuel supply was on board for the flight which resulted in fuel exhaustion. Factors associated with the accident were the low altitude of the airplane when the loss of power occurred and…Aug 13, 2008 · N3161D · Substantial damageNTSB SEA08CA177Accident · Minor injuriesData collectionFinal reportAnglin RV-6 · Puyallup, WAThe complete loss of engine power for undetermined reasons. Contributing to the accident were hidden obstructions (tree stumps) in the field of long grass within which the pilot executed his forced landing.Aug 12, 2008 · N14JA · Substantial damageNTSB SEA08CA176Accident · Minor injuriesData collectionFinal reportCessna 210E · Auburn, WAA catastrophic engine failure due to the partial blockage of the lubricating oil galley in one of the crankshaft connecting rod journals, leading to the failure of the connecting rod cap.Aug 12, 2008 · N98KC · Substantial damageNTSB LAX08CA264Accident · Minor injuriesData collectionFinal reportCessna 152 · Oceanside, CAA loss of engine power due to fuel exhaustion that was caused by the pilot's inadequate fuel consumption calculations and failure to refuel the airplane en route.Aug 10, 2008 · N46974 · Substantial damageNTSB CHI08CA250Accident · No injuriesData collectionFinal reportPiper J-3 · North Branch, MNThe loss of engine power as a result of oil starvation to the number one rod bearing and number one connecting rod. Contributing to the accident was the rough terrain.Aug 10, 2008 · N42080 · Substantial damageNTSB CHI08CA246Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Turton, SDThe failure of the starter generator which resulted in the subsequent loss of engine power. Contributing to the accident were the low altitude at which the airplane was operating, the tall grass, and the ditch.Aug 10, 2008 · N9078G · Substantial damageNTSB CHI08CA242Accident · No injuriesData collectionFinal reportSchweizer G-164A · Jefferson, IAThe loss of engine power for an undetermined reason and the unsuitable terrain encountered during the forced landing. The corn crop was a factor.Aug 8, 2008 · N73PB · Substantial damageNTSB CHI08CA240Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Salem, IAThe loss of engine power for an undetermined reason. Contributing to the accident was the high grass encountered during the landing roll.Aug 7, 2008 · N48412 · Substantial damageNTSB DEN08CA134Accident · No injuriesData collectionFinal reportEnstrom 280FX · Aurora, COThe pilot's improper planning and decision making resulting in the loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's premature application of collective resulting in a hard landing and substantial damage.Aug 6, 2008 · N285SH · Substantial damageNTSB NYC08LA270Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Brownsboro, ALThe pilot’s failure to ensure the fuel valve was on prior taxi and takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following loss of engine power due to fuel starvation.Aug 5, 2008 · N7820H · Substantial damageNTSB ANC08LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Aniak, AKA partial loss of engine power during takeoff due to a failure of the left engine's turbocharger as a result of the failure of a turbine shaft bearing. Contributing to the accident was unsuitable terrain for a forced landing.Aug 4, 2008 · N40YR · Substantial damage