NTSB investigations, CA

333 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    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 WPR10LA408Accident · No injuriesLimited investigationFinal reportBeech V35B · Sacramento, CAA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to ensure that the fuel cap was secured during the preflight inspection.Aug 16, 2010 · N67311 · Substantial damageNTSB WPR10LA396Accident · No injuriesLimited investigationFinal reportGrumman G164 · Tracy, CAA total loss of engine power while maneuvering due to an internal catastrophic failure to the master rod and piston connecting rod links.Aug 11, 2010 · N6781K · Substantial damageNTSB WPR10FA387Accident · Minor injuriesField investigationFinal reportPZL Mielec M18 · Meridian, CALong-term deterioration of multiple engine fuel vaporizers that led to material failure of multiple turbine blades, which resulted in a complete loss of engine power. Contributing to the accident were the exceedance of specified engine inspection intervals…Aug 6, 2010 · N70461 · Substantial damageNTSB WPR10FA385Accident · Minor injuriesField investigationFinal reportPiper PA-24-260C · Ridgecrest, CAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management during cruise flight.Aug 5, 2010 · N9365P · Substantial damageNTSB WPR10LA345Accident · No injuriesLimited investigationFinal reportCessna 177 · Chino, CAThe pilot’s inadequate fuel planning which resulted in a loss of engine power during cruise flight due to fuel exhaustion.Jul 11, 2010 · N3295T · Substantial damageNTSB WPR10CA311Accident · No injuriesData collectionFinal reportCessna 172F · Rancho Murieta, CAA total loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Jul 8, 2010 · N8793U · Substantial damageNTSB WPR10LA316Accident · No injuriesLimited investigationFinal reportMcGlashan T-51 Mustang · Columbia, CAA loss of engine power during approach due to thermal damage to the engine's electronic ignition module. Contributing to the accident was the builder’s placement of the ignition module near the engine’s exhaust.Jun 27, 2010 · N751RM · Substantial damageNTSB WPR10CA348Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Moreno Valley, CAA total loss of engine power due to fuel exhaustion.Jun 26, 2010 · N8118A · 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 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 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 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 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 WPR10LA111Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Napa, CAA loss of engine power due to fuel starvation as a result of the unintentional movement of the fuel selector valve beyond its stops during takeoff initial climb resulting in restricted fuel flow.Jan 14, 2010 · N2332H · Substantial damageNTSB WPR10LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Corona, CAA loss of engine power for undetermined reasons.Dec 17, 2009 · N8520U · Substantial damageNTSB WPR10LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · San Jose, CAA total loss of engine power due to water contamination in the fuel system as a result of the pilot's inadequate preflight inspection.Dec 15, 2009 · N9547D · Substantial damageNTSB WPR10LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAA total loss of engine power for undetermined reasons.Dec 8, 2009 · N2539D · Substantial damageNTSB WPR10LA063Accident · 1 fatalLimited investigationFinal reportBudd Lancair Legacy · Watsonville, CAA loss of engine power due to oil starvation and the pilot's failure to maintain airspeed while approaching the landing area resulting in an aerodynamic stall, rapid descent, and collision with terrain.Nov 21, 2009 · N7JX · Substantial damageNTSB WPR10LA053Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Chico, CAA loss of engine power during final approach for undetermined reasons.Nov 11, 2009 · N9617Y · Substantial damageNTSB WPR10LA014Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Franklin, CAA total loss of engine power due to fuel starvation, as a result of the certified flight instructor's improper fuel system management.Oct 10, 2009 · N649BV · Substantial damageNTSB WPR09LA460Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Valley Center, CAThe failure of the engine’s camshaft due to fatigue of unknown origin.Sep 20, 2009 · N4174P · Substantial damageNTSB WPR09LA452Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Santa Paula, CAA total loss of engine power during takeoff for undetermined reasons.Sep 16, 2009 · N326DW · Substantial damageNTSB WPR09LA431Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oroville, CAA total loss of engine power for undetermined reasons.Sep 4, 2009 · N2482R · DestroyedNTSB WPR09LA412Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Santa Barbara, CAA loss of power during approach due to fuel exhaustion for undetermined reasonsAug 23, 2009 · N8775P · Substantial damageNTSB WPR09LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Firebaugh, CAA total loss of engine power due to fuel exhaustion that was due to the failure of company ground personnel to refuel the airplane. Contributing to the accident was unsuitable terrain for a forced landing.Jul 29, 2009 · N23189 · Substantial damageNTSB WPR09LA369Accident · Minor injuriesLimited investigationFinal reportBrown Michael Kitfox IV · Escondido, CAA total loss of power due to an oil exhaustion induced seizure of the engine. The pilot's decision to continue flight to the original destination after becoming aware of the in-flight oil leak instead of landing at an intermediate airport to investigate the…Jul 25, 2009 · N6140S · Substantial damageNTSB WPR09LA355Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Truckee, CAA loss of engine power during initial climb for undetermined reasons.Jul 18, 2009 · N9772Y · Substantial damageNTSB WPR09LA337Accident · Minor injuriesLimited investigationFinal reportEngineering & Research 415C · Corona, CAA total loss of engine power during cruise flight for undetermined reasons.Jul 11, 2009 · N87295 · Substantial damageNTSB WPR09LA340Accident · No injuriesLimited investigationFinal reportBender Kitfox · Valencia, CAThe failure and separation of a propeller blade for undetermined reasons.Jul 7, 2009 · N926JB · Substantial damageNTSB WPR09LA312Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Lakeport, CAA loss of engine power while maneuvering for undetermined reasons.Jun 25, 2009 · N515DG · Substantial damageNTSB WPR09LA237Accident · No injuriesLimited investigationFinal reportCessna U206E · Oroville, CAA total loss of engine power during cruise flight due to an excessively lean mixture for undetermined reasons.May 10, 2009 · N1457M · Substantial damageNTSB WPR09LA230Accident · Minor injuriesLimited investigationFinal reportCessna T210G · Santa Rosa, CAA total loss of engine power on final approach for undetermined reasons.May 7, 2009 · N2722T · Substantial damageNTSB WPR09LA215Accident · No injuriesLimited investigationFinal reportStanton Glastar · Redding, CAA loss of engine power during cruise for undetermined reasons.Apr 25, 2009 · N518PV · Substantial damageNTSB WPR09LA214Accident · No injuriesLimited investigationFinal reportCessna T210M · Hanford, CAA loss of engine power during descent due to fuel starvation as a result of the pilot's improper fuel management. Contributing to the accident was the pilot's failure to use the correct fuel flow performance chart.Apr 24, 2009 · N6584B · Substantial damageNTSB WPR09LA208Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Groveland, CAA loss of engine power for undetermined reasons.Apr 22, 2009 · N8124R · Substantial damageNTSB WPR09LA195Accident · Serious injuriesLimited investigationFinal reportSungkwon Kim LONG-EZE · Dunsmuir, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control during the forced landing.Apr 14, 2009 · N342MS · Substantial damageNTSB WPR09LA177Accident · Minor injuriesLimited investigationFinal reportCessna 337G · Baker, CAA total loss of engine power for undetermined reasons.Apr 2, 2009 · N222G · Substantial damageNTSB WPR09LA170Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Madera, CAA total loss of engine power during the initial climb due to fuel exhaustion as a result of the pilot's failure to properly monitor the airplane's fuel quantity and to correctly ascertain the fuel on board the airplane prior to takeoff.Mar 28, 2009 · N2445S · Substantial damageNTSB WPR09LA169Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · San Carlos, CAA total loss of engine power during the initial climb for undetermined reasons.Mar 28, 2009 · N9249W · Substantial damageNTSB WPR09LA166Accident · Serious injuriesLimited investigationFinal reportReimus Sonex FR1 · Paso Robles, CAA total loss of engine power during cruise flight due to the pilot/builder’s failure to follow the engine manufacturer’s maintenance instructions and apply the correct torque to the rocker arm nuts during maintenance.Mar 25, 2009 · N1006N · Substantial damageNTSB WPR09LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Firebaugh, CAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning and monitoring.Mar 24, 2009 · N1857H · Substantial damageNTSB WPR09LA161Accident · No injuriesLimited investigationFinal reportBrown Barnett J4B · Sheridan, CAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Mar 20, 2009 · N35JB · Substantial damageNTSB WPR09LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Oceanside, CAA total loss of engine power in flight due to the fatigue failure of the No. 4 cylinder.Mar 8, 2009 · N2478B · Substantial damageNTSB WPR09CA137Accident · No injuriesData collectionFinal reportRudolph Ralph Monroe Starlite · Coachella, CAA total loss of engine power due to oil starvation to the rear crankshaft journal.Mar 2, 2009 · N180RR · Substantial damageNTSB WPR09GA119Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 600 · San Clemente, CAFailure of the engine’s number two bearing during cruise flight, which resulted in a loss of engine power.Feb 20, 2009 · N608BP · Substantial damageNTSB WPR09LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Turlock, CAThe loss of engine power due to carburetor icing resulting from the pilot's failure to apply carburetor heat. Contributing to the accident was the instructor's inadequate supervision of the flight.Feb 18, 2009 · N48761 · Substantial damageNTSB WPR09FA102Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF-260C · Santa Monica, CAThe pilot’s failure to select the proper fuel tank for takeoff, which resulted in a loss of engine power. Contributing to the accident was the pilot's failure to maintain aircraft control while attempting a return to runway maneuver.Jan 29, 2009 · N688C · Substantial damageNTSB WPR09CA103Accident · No injuriesData collectionFinal reportAeronca 7BC · Half Moon Bay, CAA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to perform an accurate visual fuel quantity check prior to initiating the flight.Jan 29, 2009 · N2805E · Destroyed