NTSB investigations, 2010

259 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\") = 2010
    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 ERA10GA320Accident · 3 fatalFinal reportCessna T210L · Lock Haven, PAThe total loss of engine power resulting from the fatigue failure of the engine's number 2 cylinder exhaust valve. The fatigue failure was due to valve guide wear that led to excessive clearance between the valve and valve guide. Contributing to the accident…Jun 21, 2010 · N30266 · Substantial damageNTSB CEN10CA330Accident · No injuriesData collectionFinal reportTaylorcraft DCO-65 · Akron, OHThe loss of engine power for undetermined reasons.Jun 20, 2010 · N61720 · Substantial damageNTSB CEN10CA326Accident · Minor injuriesData collectionFinal reportRemos G3/600 · Trinidad, COA total loss of engine power in flight due to fuel exhaustion for unknown reasons.Jun 19, 2010 · N134LS · Substantial damageNTSB ERA10LA325Accident · Minor injuriesLimited investigationFinal reportSchleicher ASH26 · Shelbyville, TNA complete loss of electrical and engine power over unsuitable terrain due to a cannon plug that became disconnected for undetermined reasons.Jun 18, 2010 · N26EL · Substantial damageNTSB ERA10LA317Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAA total loss of engine power during final approach due to fuel starvation as a result of the pilot’s delayed configuration of the airplane for landing.Jun 18, 2010 · N401TE · Substantial damageNTSB ERA10LA316Accident · Minor injuriesLimited investigationFinal reportMcculloch Jerry RV-4 · Pageland, SCMaintenance personnel’s improper installation and inspection of the crankshaft idler gear, which resulted in a loss of engine power.Jun 17, 2010 · N418GM · Substantial damageNTSB CEN10FA322Accident · 3 fatalField investigationFinal reportPiper PA-23 · Rochester, MNThe loss of engine power and the pilot's subsequent loss of control for undetermined reasons.Jun 17, 2010 · N7SE · Substantial damageNTSB ERA10LA314Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Sandersville, GAA total loss of engine power for undetermined reasons.Jun 16, 2010 · N84362 · Substantial damageNTSB CEN10CA332Accident · No injuriesData collectionFinal reportPiper J3C-65 · Hot Springs, ARA total loss of engine power due to fuel starvation as a result of the pilot's inadvertent closure of the fuel valve. Contributing to the accident were the unmarked fuel shutoff valve and the pilot's inexperience in the accident airplane.Jun 14, 2010 · N70906 · Substantial damageNTSB CEN10CA317Accident · No injuriesData collectionFinal reportBell 47G · Plymouth, MIThe pilot's failure to use carburetor heat, which led to carburetor icing and a loss of engine power following takeoff.Jun 13, 2010 · N47WK · Substantial damageNTSB WPR10CA285Accident · No injuriesData collectionFinal reportTexas Helicopter OH-13E/M74 · Los Banos, CAA loss of engine power due to fuel exhaustion and the pilot's failure to verify the fuel quantity onboard.Jun 11, 2010 · N38110 · Substantial damageNTSB WPR10LA284Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Ontario, CAA loss of engine power due to the in-flight separation of the 1-3-5 cylinder induction tube elbow, which was caused by the improper installation of the induction tube elbow by maintenance personnel.Jun 10, 2010 · N121HJ · Substantial damageNTSB CEN10CA313Accident · No injuriesData collectionFinal reportLuscombe 8F · Shell Knob, MOA total loss of engine power for undetermined reasons.Jun 10, 2010 · N9932C · Substantial damageNTSB ERA10LA307Accident · No injuriesLimited investigationFinal reportCessna 210L · Tampa, FLThe total loss of engine power due to inadequate torgue on the crankcase bolts. Contributing to the accident was the inadequate inspection performed 19.5 hours prior to the accident.Jun 9, 2010 · N2263S · Substantial damageNTSB WPR10CA283Accident · No injuriesData collectionFinal reportBell 47G-4A · Shaw Island, WAThe passenger's inadvertent movement of the mixture control during climb, resulting in a loss of engine power.Jun 8, 2010 · N7069J · Substantial damageNTSB CEN10LA306Accident · No injuriesLimited investigationFinal reportCessna 177RG · Marietta, OHThe total loss of engine power due to the fatigue failure of the No. 2 cylinder attachment fasteners as a result of improper engine overhaul practices.Jun 7, 2010 · N2016Q · Substantial damageNTSB WPR10LA280Accident · No injuriesLimited investigationFinal reportBeech F33 · Marana, AZThe loss of engine power while maneuvering to land for undetermined reasons.Jun 5, 2010 · N1565A · Substantial damageNTSB WPR10CA278Accident · No injuriesData collectionFinal reportRobinson R22 · La Verne, CAA loss of engine power due to the pilot's inadvertent movement of the mixture control.Jun 5, 2010 · N7028U · Substantial damageNTSB ERA10LA297Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Rockohoma, NYThe pilot's inadequate preflight inspection which resulted in a total loss of engine power during the initial climb due to fuel contamination.Jun 5, 2010 · N1958W · Substantial damageNTSB CEN10LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pollard, ARA loss of engine power for undetermined reasons.Jun 4, 2010 · N6083G · Substantial damageNTSB CEN10CA297Accident · Minor injuriesData collectionFinal reportCessna 180 · Humble, TXA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.Jun 3, 2010 · N154JD · Substantial damageNTSB WPR10FA277Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Spokane, WAA 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 and the student pilot's failure to maintain main rotor rpm.…Jun 2, 2010 · N522SA · Substantial damageNTSB WPR10LA272Accident · No injuriesLimited investigationFinal reportEagle Eagle DW-1 · Waterville, WAA worn wire in the magneto system, which allowed intermittent grounding and a loss of engine power.Jun 1, 2010 · N8815U · Substantial damageNTSB ERA10LA294Accident · Minor injuriesLimited investigationFinal reportSwanson RV-9A · Ashland, VAThe pilot's failure to obtain the proper touchdown point during a forced landing in gusting wind. Contributing to the accident was a total loss of engine power, likely due to carburetor ice.Jun 1, 2010 · N858JK · Substantial damageNTSB ERA10LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Dania Beach, FLThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Jun 1, 2010 · N1435F · Substantial damageNTSB WPR10CA267Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Palo Alto, CAA total loss of engine power on final approach due to fuel starvation as a result of the pilot's inadequate fuel management.May 29, 2010 · N2865M · Substantial damageNTSB CEN10LA281Accident · No injuriesLimited investigationFinal reportCessna 140 · Atchison, KSThe loss of engine power for undetermined reasons.May 29, 2010 · N76287 · Substantial damageNTSB CEN10LA276Accident · 2 fatalLimited investigationFinal reportCovell Kevin Scott Vans RV-4 · Collinsville, OKA loss of engine power shortly after takeoff for undetermined reasons. Contributing to the accident was the pilot's decision to make a 180-degree turn at low level.May 29, 2010 · N74RV · Substantial damageNTSB ERA10LA284Accident · Minor injuriesLimited investigationFinal reportCessna 337G · High Springs, FLThe pilot's failure to follow the published engine-out procedures after a total loss of power in the rear engine. Contributing to the accident was the inadequate maintenance and inspection of the engine by the pilot and maintenance personnel.May 27, 2010 · N72268 · Substantial damageNTSB ERA10FA283Accident · 1 fatalField investigationFinal reportSchweizer 269C-1 · Boxborough, MAThe FAA inspector's rapid reduction of power which resulted in a loss of engine power and his decision to initiate a turn during the autorotation without sufficient altitude to clear obstacles. Contributing to the accident was the FAA’s lack of comprehensive…May 26, 2010 · N73SJ · Substantial damageNTSB WPR10LA251Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Benson, AZA loss of engine power due to fuel starvation as a result of a loss of fuel pressure caused by the fuel pump screws being loose. Contributing to the accident was inadequate maintenance.May 21, 2010 · N6630X · Substantial damageNTSB WPR10LA248Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Arbuckle, CAInsufficient clamping force to the connecting rod bolt, which resulted in looseness in the connecting rod bearing area that led to the fatigue fracture of the connecting rod and a subsequent loss of engine power.May 19, 2010 · N580TP · Substantial damageNTSB WPR10LA247Accident · No injuriesLimited investigationFinal reportAyres S2R · Glenn, CALoss 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.May 18, 2010 · N29254 · Substantial damageNTSB CEN10CA254Accident · No injuriesData collectionFinal reportNelson Steven Paul WAG-AEROSPORTSMAN2+2 · Milica, MNA loss of engine power due to fuel starvation as a result of the pilot's inadequate in-flight fuel management.May 17, 2010 · N124SN · Substantial damageNTSB CEN10LA253Accident · No injuriesLimited investigationFinal reportDearmond Clint RV-6A · Sheboygan, WIThe loss of engine power due to a fuse failure in the ignition system.May 16, 2010 · N1257E · Substantial damageNTSB ERA10TA261Accident · No injuriesFinal reportBell 407 · Abingdon, VAThe improper repair of an engine component by a repair facility, which resulted in a complete loss of engine power. Contributing to the accident was the failure of the repair facility to recognize that an improper repair had been accomplished, which allowed…May 11, 2010 · N31VA · Substantial damageNTSB ERA10CA258Accident · Serious injuriesData collectionFinal reportMoynahan Moynahan Pitts S-1S · Newnan, GAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight fuel planning.May 9, 2010 · N5FM · Substantial damageNTSB CEN10LA245Accident · Minor injuriesLimited investigationFinal reportGross Cozy · Pine Bluff, ARThe inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.May 9, 2010 · N144TJ · Substantial damageNTSB CEN10LA242Accident · No injuriesLimited investigationFinal reportJorritsma Jerrold S Berkut · Loveland, COA loss of engine power due to a malfunction of the fuel controller resulting in a compressor stall.May 9, 2010 · N3255U · Substantial damageNTSB WPR10LA232Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Mendon, UTA loss of engine power due to a failure of the magnetos as a result of inadequate maintenance.May 7, 2010 · N393LE · Substantial damageNTSB CEN10CA246Accident · No injuriesData collectionFinal reportCarlesimo Glasair III T · Lynwood, ILA loss of engine power due to fuel starvation as a result of the pilot's failure to follow the pre-landing checklist and verifying the position of the fuel selector.May 7, 2010 · N713MJ · Substantial damageNTSB CEN10LA241Accident · Minor injuriesLimited investigationFinal reportHager Clinton Ray Vans RV-8 · Prague, OKThe in-flight separation of a propeller blade for undetermined reasons.May 6, 2010 · N127TT · Substantial damageNTSB WPR10LA235Accident · No injuriesLimited investigationFinal reportBeech 35 · South Bend, WAA loss of engine power during takeoff for undetermined reasons, which resulted in a runway overrun.May 2, 2010 · N3174V · Substantial damageNTSB CEN10LA235Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · El Paso, TXA loss of engine power for undetermined reasons.Apr 30, 2010 · N3692Q · Substantial damageNTSB ERA10LA248Accident · Minor injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415-C · LaGrange, GAA loss of engine power due to the pilot's inadequate preflight inspection and his failure to ensure that the fuel tank shut-off valve was open resulting in fuel starvation.Apr 28, 2010 · N87172 · Substantial damageNTSB WPR10LA214Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Madera, CAA loss of engine power for undetermined reasons.Apr 23, 2010 · N4450 · Substantial damageNTSB CEN10LA222Accident · Serious injuriesLimited investigationFinal reportCross-Capps Breezy · Livingston, TXA loss of engine power for undetermined reasons.Apr 23, 2010 · N125RT · Substantial damageNTSB ERA10CA240Accident · No injuriesData collectionFinal reportGrumman G164 · Hampton, GAA total loss of engine power during a go-around due to fuel exhaustion as a result of the pilot's inadequate preflight planning.Apr 22, 2010 · N654U · Substantial damageNTSB WPR10LA210Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Tooele, UTThe complete loss of power in one engine due to fuel starvation as a result of the pilot's failure to reposition the cross-feed valve prior to takeoff and the flight instructor's failure to monitor the pilot's actions. Contributing to the accident was the…Apr 21, 2010 · N331GP · Substantial damageNTSB CEN10LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Alpine, TXA total loss of engine power for undetermined reasons.Apr 21, 2010 · N9197F · Substantial damage