NTSB investigations: Lycoming 0-235 series, CA

494 cases on aircraft whose registry engine model is Lycoming 0-235 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505'))
  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 WPR13CA065Accident · No injuriesData collectionFinal reportBellanca 7ECA · Tehachapi, CAThe non-instrument-rated pilot's continued descent into instrument meteorological conditions during the landing approach and his loss of situational awareness, which resulted in a collision with terrain.Dec 8, 2012 · N8595V · Substantial damageNTSB WPR13CA032Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAThe student pilot's improper landing flare and recovery from a bounced landing.Oct 29, 2012 · N48340 · Substantial damageNTSB WPR13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Corona, CATotal loss of engine power during the landing approach due to insect debris in the carburetor metering valve, which resulted in fuel starvation.Oct 13, 2012 · N4309E · Substantial damageNTSB WPR12CA350Accident · No injuriesData collectionFinal reportCessna 152 · Eastvale, CAThe failure of both pilots to ensure that no water was present in the fuel, which resulted in a complete loss of engine power and a forced off-field landing.Aug 10, 2012 · N94185 · Substantial damageNTSB WPR12LA055Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Davis, CAThe pilot's inadequate fuel management, which resulted in a loss of engine power due to fuel starvation.Dec 7, 2011 · N2466D · Substantial damageNTSB WPR11LA443Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAThe flight instructor’s delayed remedial action and failure to maintain airplane control while performing a simulated aborted landing.Sep 6, 2011 · N4649L · Substantial damageNTSB WPR11FA344Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Corona, CAAn aggressive flight maneuver performed by the pilot during low altitude flight, which resulted in an aerodynamic stall.Jul 23, 2011 · N34299 · Substantial damageNTSB WPR11LA318Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frazier Park, CAThe pilot’s geographic disorientation, which resulted in an off-airport precautionary landing in soft terrain and a subsequent nose over.Jul 8, 2011 · N4901Z · Substantial damageNTSB WPR10CA390Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe pilot’s failure to maintain aircraft control during final approach, resulting in a hard landing.Aug 8, 2010 · N6165M · Substantial damageNTSB WPR10FA325Accident · 1 fatalField investigationFinal reportCessna 152 · Venice, CAThe pilot's failure to maintain adequate airspeed and airplane control during initial climb, which resulted in an aerodynamic stall/spin and subsequent impact with the ground.Jul 2, 2010 · N94838 · Substantial damageNTSB WPR10CA263Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper recovery from a bounced landing.May 25, 2010 · N69254 · Substantial damageNTSB WPR10FA078Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Ojai, CAAirspeed was not maintained, which resulted in a loss of control and the airplane entering into a stall/spin to the ground. Contributing to the accident was a loss of engine power due to carburetor icing.Dec 10, 2009 · N2463K · 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 WPR09CA430Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear strut.Aug 31, 2009 · N5155B · Substantial damageNTSB WPR09FA398Accident · 2 fatalField investigationFinal reportCessna 152 · Hesperia, CAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall/spin. Also causal was the failure of the left magneto due to improper assembly of the drive gear during installation on the…Aug 16, 2009 · N67361 · Substantial damageNTSB WPR09LA380Accident · Serious injuriesLimited investigationFinal reportDavenport DAVE-EZ · Santa Monica, 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.Aug 2, 2009 · N7CE · Substantial damageNTSB WPR09LA293Accident · 2 fatalLimited investigationFinal reportChampion 7ECA · Lake Elsinore, CAA loss of airplane control for undetermined reasons.Jun 17, 2009 · N8339V · Substantial damageNTSB WPR09LA205Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAA partial loss of engine power during takeoff due to carbon fouling of a spark plug.Apr 20, 2009 · N48259 · Substantial damageNTSB WPR09FA200Accident · 2 fatalField investigationFinal reportChampion 7ECA · San Jose, CAThe pilot's failure to maintain airspeed while maneuvering within a canyon in mountainous terrain, which resulted in an inadvertent stall/spin.Apr 18, 2009 · N5174X · Substantial damageNTSB WPR09LA124Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Salinas, CAThe pilot's failure to maintain clearance from a wire while intentionally maneuvering at a low altitude.Feb 22, 2009 · N2835G · 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 WPR09CA073Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAThe student pilot's failuire to maintain directional control during takeoff.Jan 5, 2009 · N45969 · DestroyedNTSB WPR09LA040Accident · 1 fatalLimited investigationFinal reportCessna 152 · Atwater, CAThe second pilot's failure to see and avoid the rotating propeller after exiting the airplane.Nov 16, 2008 · N45994 · No damageNTSB WPR09CA030Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Friant, CAThe student pilot's failure to execute a go-around in timely manner, which resulted in a collision with terrain. Also causal was the instructor's inadequate supervision of the flight and delayed remedial actions.Oct 31, 2008 · N2346G · Substantial damageNTSB LAX08LA299Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAThe loss of engine power during takeoff for undetermined reasons.Sep 22, 2008 · N271RJ · Substantial damageNTSB SEA08CA198Accident · No injuriesData collectionFinal reportCessna 152 · Columbia, CAThe student pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot's improper use of the throttle control.Sep 13, 2008 · N24342 · 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 LAX08LA211Accident · 1 fatalLimited investigationFinal reportCessna 152 · Piru, CAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.Jul 2, 2008 · N25490 · DestroyedNTSB SEA08CA125Accident · No injuriesData collectionFinal reportCessna 152 · Redding, CAThe pilot's misjudged landing flare, which resulted in a hard landing.May 6, 2008 · N68353 · Substantial damageNTSB LAX08CA090Accident · No injuriesData collectionFinal reportCessna 152 · El Cajon, CAthe student pilot's inadequate compensation for gusty, crosswind conditions, and failure to maintain an adequate airspeed.Apr 1, 2008 · N64938 · Substantial damageNTSB LAX08LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CALoss of engine power during the takeoff initial climb due to lack of compression to a cylinder.Feb 1, 2008 · N49811 · Substantial damageNTSB SEA08CA056Accident · No injuriesData collectionFinal reportPiper PA-12 · Santa Ana, CAThe failure of the student to maintain directional control during landing and the flight instructor's inadequate supervision of the flight.Dec 31, 2007 · N2800D · Substantial damageNTSB LAX08CA037Accident · No injuriesData collectionFinal reportCessna 152 · Turlock, CAThe pilot's delayed decision to abort the landing, which resulted in a runway overrun.Oct 31, 2007 · N64994 · Substantial damageNTSB LAX07LA209Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tracy, CAThe pilot's improper recovery from a bounced landing and his failure to maintain directional control during the landing roll. Contributing to the accident were the operator's inadequate engine maintenance, which precipitated the loss of engine power, the…Jul 8, 2007 · N95038 · Substantial damageNTSB SEA07CA149Accident · No injuriesData collectionFinal reportPiper PA-16 · Esparto, CAThe pilot's misjudgment of altitude resulting in an undershoot. Factors included the berm and the wind gusts.Jun 11, 2007 · N5641H · Substantial damageNTSB SEA07CA130Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH 2000 · Merced, CAThe student pilot's inadvertent stall/mush during a simulated power loss after takeoff and the flight instructor's delayed remedial action, which resulted in a hard landing. A contributing factor was the flight instructor's lack of familiarity with the…May 15, 2007 · N363AM · Substantial damageNTSB LAX07CA157Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Mariposa, CAThe pilot's failure to maintain clearance from a vehicle while taxiing.May 11, 2007 · N2539D · Substantial damageNTSB SEA07CA103Accident · Minor injuriesData collectionFinal reportCessna 152 · Oak Glen, CAThe flight instructors failure to maintain clearance from trees while maneuvering. Contributing factors were the downdraft weather condition, and the tree.Apr 17, 2007 · N49902 · DestroyedNTSB SEA07CA091Accident · No injuriesData collectionFinal reportAC Mfg & Dev't CH 2000 · Madera, CAThe improper flare which resulted in a hard landing and porpoise.Apr 3, 2007 · N368AM · Substantial damageNTSB LAX07CA112Accident · No injuriesData collectionFinal reportCaywood Long-Ez · El Cajon, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.Mar 16, 2007 · N829CL · Substantial damageNTSB LAX07CA105Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Groveland, CAthe pilot's failure to maintain directional control.Mar 12, 2007 · N2489P · Substantial damageNTSB LAX07CA076Accident · No injuriesData collectionFinal reportCessna 152 · Aptos, CAthe student pilot's becoming lost and disoriented that resulted in an improper in-flight decision to make a precautionary landing in an unsuitable open field.Jan 30, 2007 · N25932 · Substantial damageNTSB LAX07LA016Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Prunedale, CATotal loss of engine power due to failure of connecting rod cap during cruise flight for undetermined reasons.Oct 22, 2006 · N45929 · Substantial damageNTSB LAX06LA230Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAa loss of engine power due to the failure of maintenance personnel to tighten the top spark plugs, and install the leads for the ignition harness to the top spark plugs.Jul 14, 2006 · N25512 · Substantial damageNTSB LAX06LA235Accident · Minor injuriesLimited investigationFinal reportAlfred Long-EZ · Hesperia, CAThe pilot's failure to maintain the proper glide path on final approach as a result of the visual illusions created by a narrow, upsloping runway.Jul 11, 2006 · N1014A · Substantial damageNTSB LAX06CA209Accident · No injuriesData collectionFinal reportCessna 152 · Concord, CAthe student pilot's unstabilized approach, misjudged landing flare, inadequate recovery from a bounced landing, and failure to maintain directional control. A contributing factor to the accident was the in-flight distraction.Jun 22, 2006 · N5534M · Substantial damageNTSB LAX06CA146Accident · Minor injuriesData collectionFinal reportGrumman American AA-1C · San Diego, CAThe pilot's failure to maintain adequate airspeed, which resulted in a stall during initial climb. A contributing factor was his diverted attention.Apr 23, 2006 · N9756U · DestroyedNTSB LAX06CA143Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAthe failure of the student and certified flight instructor to maintain directional control and obtain/maintain an adequate airspeed during the attempted go-around. The flight instructor's inadequate supervision of the flight was also causal.Apr 20, 2006 · N757GF · Substantial damageNTSB LAX06CA079Accident · No injuriesData collectionFinal reportCessna 152 · Rancho Murieta, CAfuel contamination (water) due to the inadequate preflight by both pilots, which failed to detect the residual water contamination in fuel system. A factor in the accident was the soft terrain condition at the forced landing site.Jan 4, 2006 · N49391 · Substantial damageNTSB LAX05FA296Accident · 2 fatalField investigationFinal reportCessna 152 · Lakewood, CAthe certified flight instructor's failure to maintain an adequate airspeed resulting in a stall and loss of control. Also causal was the engine's loss of partial power due to inadequate maintenance, worn spark plugs, worn pistons, and broken piston rings.Sep 11, 2005 · N6565L · Destroyed