NTSB investigations
3,823 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 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.
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."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
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 ERA12FA017Accident · 1 fatalField investigationFinal reportLuscombe 8A · Dixie, GAMaintenance personnel’s improper installation of the No. 2 cylinder’s connecting rod, which resulted in the disconnection of the rod and a subsequent loss of engine power.NTSB CEN12LA012Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Easton, MODebris in the fuel system, which resulted in a loss of engine power due to fuel starvation. Also causal was the pilot not maintaining sufficient airspeed, which resulted in an aerodynamic stall.NTSB CEN12LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Vidalia, LAA total loss of engine power likely due to carburetor ice.NTSB CEN12CA006Accident · No injuriesData collectionFinal reportCessna 210A · Wolfe City, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB CEN12LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Centerburg, OHThe pilot's improper pre-flight planning and failure to ensure that there was an adequate fuel supply on board to complete the flight, which resulted in fuel exhaustion. Contributing to the accident was the malfunction of the fuel quantity indicator.NTSB ERA12LA001Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Ridgefield, CTThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN12CA003Accident · Serious injuriesData collectionFinal reportSadler Terry Rans S-7 Courier · Riley, KSA total loss of engine power during takeoff due to fuel starvation as a result of the pilot’s inadequate preflight inspection and failure to ensure that the fuel shutoff valve was turned on before departure.NTSB ERA11CA506Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Montgomery, NYA total loss of engine power due to fuel starvation as a result of the pilots’ inadequate fuel management.NTSB CEN11LA669Accident · Serious injuriesLimited investigationFinal reportOwen Vans RV-10 · Marietta, OHThe in-flight engine fire and loss of engine power due to an improperly installed fuel injector nozzle during a recent engine overhaul.NTSB ERA11LA503Accident · 1 fatalLimited investigationFinal reportCessna 120 · Cordele, GAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN11LA415Accident · Serious injuriesLimited investigationFinal reportBins Tom Kitfox IV · Lafayette, LAThe pilot’s loss of control during a forced landing after a loss of engine power for undetermined reasons during takeoff.NTSB WPR11LA462Accident · No injuriesLimited investigationFinal reportHughes 269C · Ramona, CAThe flight instructor’s failure to follow the proper procedure while demonstrating a practice autorotation, which resulted in a total loss of engine power and subsequent hard landing.NTSB ERA11IA521Incident · No injuriesIncident investigationFinal reportBeech V35 · New Haven, CTThe in-flight fatigue failure of the engine’s crankshaft, which resulted in the separation of the forward portion of the crankshaft and the propeller.NTSB WPR11LA457Accident · No injuriesLimited investigationFinal reportCessna 170 · Pahrump, NVA loss of engine power during the landing approach for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA651Accident · Serious injuriesLimited investigationFinal reportNorth American AT-6 · Nunica, MIThe loss of engine power due to fuel starvation during climbout for undetermined reasons, because postaccident examination of the fuel system did not reveal any discrepancies that would have precluded normal engine operation. Contributing to the accident was…NTSB CEN11WA690Accident · No injuriesForeign investigationPiper PA 28 · Montpellier, FranceOn September 16, 2011, a Piper PA 28, French resistered F-HMAT, was substantially damaged during a forced landing following a loss of engine power near Montpellier, France. Visual meteorological conditions prevailed at the time of the accident. No one was…NTSB WPR11FA453Accident · Serious injuriesField investigationFinal reportDacey Venture · Reno, NVA total loss of engine power during the initial climb due to the pilot’s premature activation of the engine's anti-detonant injection system.NTSB ANC11LA103Accident · No injuriesLimited investigationFinal reportCessna U206G · Beluga, AKThe total loss of engine power for an undetermined reason.NTSB WPR11LA451Accident · No injuriesLimited investigationFinal reportPeter A Land White Lightning · Lancaster, CAA total loss of engine power during the landing approach due to fuel starvation. Contributing to the accident was the airplane’s inaccurate fuel indicator.NTSB CEN11LA636Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Kokomo, INThe loss of engine power following takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA656Accident · No injuriesLimited investigationFinal reportQuicksilver GT400 · Bolingbrook, ILThe loss of engine power for reasons that could not be determined during postaccident examination of the engine or airframe.NTSB CEN11LA635Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A-3 · Waukegan, ILThe pilot’s inadequate preflight inspection of the airplane, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the accident were a malfunctioning fuel gauge and air traffic that prevented an on airport landing.NTSB ANC11LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Galena, AKThe total loss of engine power for undetermined reasons.NTSB CEN11CA633Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Damon, TXThe pilot’s improper fuel management during cruise flight, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR11LA434Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Saratoga, WYA loss of engine power during an attempted go-around for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA11CA485Accident · Minor injuriesData collectionFinal reportHaines Joseph E SHA-GLASAIR · Beaufort, NCThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN11FA625Accident · 1 fatalField investigationFinal reportSocata TBM 700 · Mt. Pleasant, WIThe pilot’s failure to properly trim the airplane’s rudder during cruise flight, which resulted in a prolonged uncoordinated flight condition, unporting of the fuel tank feed line, and subsequent fuel starvation and engine power loss. Contributing to the…NTSB WPR11FA428Accident · 2 fatalField investigationFinal reportVeatch Kitfox · Caldwell, IDThe pilot’s failure to prevent a low-altitude stall and spin following a complete loss of engine power during the initial climb after takeoff.NTSB CEN11FA616Accident · 2 fatalField investigationFinal reportLarson Ken W Christen EAGLE-II · Seward, NEThe pilot’s inadvertent pulling of the mixture control lever on takeoff, which shut down the engine.NTSB ANC11FA093Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · McGrath, AKThe pilot inadvertently switched off the engine magnetos during short final approach, which resulted in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches in the cabin.NTSB WPR11LA423Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters UH-1H · Stockton, CAA total loss of engine power due to the separation of a tooth from the starter-generator drive gear, which resulted in failure of the engine oil pump and subsequent oil starvation.NTSB CEN11CA609Accident · Minor injuriesData collectionFinal reportMooney M20C · Allen, OKA total loss of engine power in flight due to fuel starvation as a result of the pilot’s inadequate fuel management.NTSB ANC11LA099Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Unalaska, AKA loss of engine power in cruise flight for undetermined reasons.NTSB ANC11CA089Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cape Yakataga, AKThe pilot inadvertently switching off the engine magnetos during the initial climb, resulting in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches.NTSB WPR11LA410Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Napa, CAThe pilot’s mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB ERA11LA473Accident · Minor injuriesLimited investigationFinal reportWoolston Glenn E Zenith 701 Stol · Carlton, NYThe pilot’s lack of recognition that the engine was being supplied fuel from only the right tank with the fuel selector in the both position, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the…NTSB CEN11FA599Accident · 4 fatalClass 1 · FieldFinal reportEurocopter AS-350-B2 · Mosby, MOThe pilot's failure to confirm that the helicopter had adequate fuel on board to complete the mission before making the first departure, his improper decision to continue the mission and make a second departure after he became aware of a critically low fuel…NTSB WPR11FA403Accident · No injuriesField investigationFinal reportBeech A23-24 · Palo Alto, CAThe student’s and flight instructor’s mismanagement of the fuel supply, resulting in a total loss of engine power due to fuel starvation.NTSB WPR11LA401Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Cabazon, CAA total loss of left engine power due to the failure of the aft crankshaft counterweight retaining washer for reasons that could not be determined during postaccident examinations.NTSB CEN11LA556Accident · No injuriesLimited investigationFinal reportGrumman G-164A · El Campo, TXSeparation of the No. 3 cylinder exhaust valve rocker arm, which resulted in a loss of engine power.NTSB ERA11LA457Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Graham, NCThe individual's fuel mismanagement, which resulted in fuel exhaustion and a subsequent engine failure. Contributing the accident was the individual’s failure to maintain adequate airspeed following the engine failure, which resulted in an aerodynamic stall.NTSB WPR11LA380Accident · No injuriesLimited investigationFinal reportBeech B36TC · Lemoore, CAA loss of engine power during cruise flight due to maintenance personnel's failure to adequately torque the number 4 cylinder retaining nuts, which resulted in the in-flight separation of the cylinder.NTSB CEN11LA577Accident · Minor injuriesLimited investigationFinal reportCessna 400 · Eastland, TXA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. .NTSB CEN11LA563Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Mansfield, SDThe loss of engine power due to debris in the engine air intake system.NTSB CEN11FA559Accident · Minor injuriesField investigationFinal reportCessna 182C · Boulder, COThe malfunction of the throttle linkage to the induction air box, which resulted in a loss of engine power and subsequent forced landing.NTSB CEN11LA555Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Millsap, TXA sudden loss of engine thrust due to the separation of a propeller blade in cruise flight due to high cycle fatigue.NTSB WPR11LA373Accident · No injuriesLimited investigationFinal reportRotorway Exec · Chino Hills, CAA total loss of engine power due to fuel exhaustion as a result of both the owner's and the pilot's failure to determine or monitor the remaining fuel quantity during the flight. Contributing to the accident was the manufacturer's lack of fuel consumption…NTSB ERA11LA461Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Elizabethtown, NCThe improper securing of a “B” nut on the power turbine control (Py) line by unknown maintenance personnel, which resulted in a total loss of engine power. Contributing to the accident was the pilot's failure to use the manual fuel override switch.NTSB CEN11LA553Accident · No injuriesLimited investigationFinal reportHyde William R Helicycle · Metone, INThe loss of engine power due to fuel starvation as a result of an electrical system failure.NTSB ERA11CA441Accident · No injuriesData collectionFinal reportCessna 172K · Sylacauga, ALA stuck exhaust-valve on the number one cylinder which resulted in a loss of engine power.