NTSB investigations: Lycoming O&VO-360 series, CA

547 cases on aircraft whose registry engine model is Lycoming O&VO-360 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 ('41514'))
  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 WPR12LA128Accident · No injuriesLimited investigationFinal reportBeech 76 · Rio Linda, CAA loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat during descent while operating in an area conducive to carburetor icing.Mar 11, 2012 · N6697L · Substantial damageNTSB WPR12CA083Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Barbara, CAThe pilot did not maintain directional control during takeoff.Jan 26, 2012 · N4297S · Substantial damageNTSB WPR12CA061Accident · No injuriesData collectionFinal reportGrumman AA5 · Furnace Creek, CAThe pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.Dec 10, 2011 · N28870 · Substantial damageNTSB WPR12LA052Accident · No injuriesLimited investigationFinal reportBeech 76 · San Carlos, CAThe collapse of the right main landing gear during the turn off the runway due to the failure of the A-frame assembly.Dec 2, 2011 · N23852 · Substantial damageNTSB WPR11CA418Accident · Minor injuriesData collectionFinal reportChristen Industries A-1 · Dorris, CAThe pilot’s failure to maintain lateral aircraft control while taking off with a gusting crosswind.Aug 30, 2011 · N2868A · Substantial damageNTSB WPR11CA066Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Coalinga, CAThe pilot's failure to remove the gust lock prior to takeoff.Nov 26, 2010 · N74400 · Substantial damageNTSB WPR10LA465Accident · No injuriesLimited investigationFinal reportMooney M20C · Visalia, CAA partial loss of engine power during takeoff, which resulted from the failure of the spark plug retention mechanism.Sep 21, 2010 · N6090Q · 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 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 WPR10LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Apple Valley, CAThe pilot's loss of directional control during the landing roll and the check airman’s delayed remedial response.Jan 8, 2010 · N29285 · 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 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 WPR09LA046Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Monterey, CAThe pilot's inadequate fuel system management and inflight planning that led to a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to use the landing checklist.Nov 26, 2008 · N2383R · Substantial damageNTSB SEA08CA199AccidentData collectionFinal reportCessna 177B · Truckee, CAThe pilot's improper decision to take off in a heavily loaded airplane under the ambient conditions that existed at the time. Contributing to the accident was the mountainous/hilly terrain, a high density altitude, gusty winds and downdrafts.Sep 14, 2008 · N30692 · Substantial damageNTSB LAX08LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Moorpark, CAA partial loss of engine power due to the disconnection of the throttle control cable from the throttle arm due to the operator's improper maintenance. Contributing to the accident was unsuitable terrain for a forced landing.Jul 9, 2008 · N9627B · Substantial damageNTSB SEA08LA158Accident · 1 fatalLimited investigationFinal reportMauck RV-6A · Sierraville, CAThe pilot's failure to maintain clearance with trees and terrain while maneuvering Contributing to the accident was the reduced visibility in the area due to smoke.Jul 2, 2008 · N27WR · Substantial damageNTSB LAX08CA194Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Angwin, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.Jun 21, 2008 · N1993F · Substantial damageNTSB LAX08CA171Accident · No injuriesData collectionFinal reportPiper Cub Crafters PA-18-150 · Fall RiverMills, CAThe pilot's selection of an unsuitable takeoff/landing area.Jun 9, 2008 · N273CC · Substantial damageNTSB LAX08FA068Accident · 3 fatalField investigationFinal reportMooney M20C · Riverside, CAThe pilot's failure to maintain airspeed and aircraft control, resulting in an aerodynamic stall.Feb 28, 2008 · N591BB · DestroyedNTSB SEA08LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Piru, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and dark night conditions.Feb 9, 2008 · N2922X · Substantial damageNTSB SEA08LA057Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Sonoma, CAThe departing pilot's inadequate visual lookout.Jan 1, 2008 · N8037W · 2 aircraft · Minor damageNTSB SEA08LA029Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Byron, CAThe failure of the right main landing gear aft trunnion attach fitting due to overload during the landing roll.Nov 14, 2007 · N274ER · Substantial damageNTSB LAX08CA016Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Long Beach, CAThe student pilot's improper execution of low rotor rpm procedures. Contributing to the accident was the flight instructor's inadequate supervision, failure to guard the throttle, and failure to take immediate remedial action.Oct 24, 2007 · N7188S · Substantial damageNTSB SEA07CA268Accident · No injuriesData collectionFinal reportMooney M20D · Placerville, CAThe pilot's failure to extend the landing gear prior to landing. A contributing factor was the pilots impaired performance.Sep 12, 2007 · N1229X · Substantial damageNTSB SEA07LA141Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Rosamond, CAThe pilot's failure to abort the takeoff due to lack of airplane climb performance, which resulted in a collision with terrain.Jun 1, 2007 · N5231L · Substantial damageNTSB LAX07CA098Accident · No injuriesData collectionFinal reportMooney M20D · Visalia, CAThe pilot's inadequate in-flight fuel system management, which resulted in fuel starvation and a loss of engine power.Mar 3, 2007 · N6628U · Substantial damageNTSB LAX07CA050Accident · No injuriesData collectionFinal reportRobinson R22B · Redding, CAThe student's misjudged landing flare, the instructor's inadequate supervision of the flight, and the instructor's failure to maintain adequate rotor rpm.Nov 27, 2006 · N7198N · Substantial damageNTSB LAX07LA020Accident · Serious injuriesLimited investigationFinal reportAero Commander 112 · Chino, CAA loss of engine power during the initial climb after takeoff due to blocked fuel vent lines that resulted in fuel starvation. Contributing to the accident was an inadequate preflight inspection by the pilot-in-command (CFI).Oct 23, 2006 · N1022J · Substantial damageNTSB LAX07LA004Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Oakdale, CAA total loss of engine power resulting from lubrication deprivation for undetermined reasons.Oct 8, 2006 · N39ER · Substantial damageNTSB LAX07CA013Accident · No injuriesData collectionFinal reportAviat A-1A · Woodlake, CAthe collapse of the landing gear during the landing roll out due to an encounter with rough uneven terrain. Also causal was the pilot's in-flight decision to land on the unsuitable mountainous uneven terrain with hidden obstructions.Oct 7, 2006 · N40AW · Substantial damageNTSB LAX06LA298Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Auburn, CAthe fatigue failure of the elevator's control rod due to inadequate lubrication. Contributing factors were the inadequate maintenance and the owner-pilot's failure to comply with an airworthiness directive.Sep 20, 2006 · N5577Q · Substantial damageNTSB LAX06CA223Accident · No injuriesData collectionFinal reportPiper PA28-181 · Dorris, CAthe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall/mush. A contributing factor was the high density altitude.Jul 3, 2006 · N6413C · Substantial damageNTSB LAX06CA217Accident · No injuriesData collectionFinal reportBeech 76 · El Cajon, CAthe failure of the "A" frame tube, which caused the left main landing gear to collapse.Jun 27, 2006 · N6720T · Substantial damageNTSB LAX06CA216Accident · Minor injuriesData collectionFinal reportEklund Thorp T-18 · San Andreas, CAthe pilot's misjudged airspeed and distance during the approach, and his failure to initiate a timely go-around, which resulted in a landing overrun.Jun 27, 2006 · N181RE · Substantial damageNTSB LAX06LA205Accident · No injuriesLimited investigationFinal reportCessna 177B · Redwood City, CAA collision with water for undetermined reasons.Jun 17, 2006 · N35058 · Substantial damageNTSB LAX06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Columbia, CAthe pilot's failure to maintain directional control during the landing roll.May 3, 2006 · N441MA · Substantial damageNTSB LAX06LA147Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Creston, CAThe pilot's failure to maintain an adequate clearance from obstacles while intentionally flying at a low altitude.Apr 23, 2006 · N96088 · Substantial damageNTSB LAX06CA272Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Coalinga, CAthe pilot's misjudged landing flare, which resulted in a bounced landing, and his inadequate recovery technique that led to a hard landing.Apr 8, 2006 · N8068J · Substantial damageNTSB ANC06LA022Accident · No injuriesLimited investigationFinal reportPiper PA-24 · El Cajon, CAThe student pilot's failure to maintain directional control during takeoff, which resulted in an on ground collision with a sign, and the collapse of the main landing gear.Mar 5, 2006 · N6094P · Substantial damageNTSB LAX06LA111Accident · Minor injuriesLimited investigationFinal reportBeech C23 · San Jose, CAfuel starvation due to the pilot's improper fuel system management and failure to select the proper fuel tank. A factor was the rough, uneven terrain.Feb 12, 2006 · N3724Z · Substantial damageNTSB LAX06FA106Accident · 3 fatalField investigationFinal reportCessna 172RG · El Cajon, CAThe pilots of both airplanes failure to maintain an adequate visual lookout due to their relative flight paths, which limited the available visual cues. Factors were the failure of the air traffic controller(s) to issue a conflict alert to the Cessna 172RG…Feb 9, 2006 · N9531B · 2 aircraft · DestroyedNTSB LAX06LA068Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Hopland, CAThe non-instrument rated pilot's failure to maintain clearance with terrain, which resulted in a controlled flight into terrain. Contributing factors were the dark night conditions and the low clouds.Dec 25, 2005 · N3953R · DestroyedNTSB LAX06CA050Accident · Minor injuriesData collectionFinal reportMooney M20A · China Lake, CAfuel exhaustion due to the pilot's inadequate in-flight planning and fuel consumption calculations.Dec 2, 2005 · N6004X · Substantial damageNTSB LAX05CA301Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Petaluma, CAa loss of engine power due to fuel exhaustion.Sep 17, 2005 · N8103X · Substantial damageNTSB LAX05CA291Accident · No injuriesData collectionFinal reportRobinson R22 · Santa Clarita, CAthe pilot's improper use of the collective control while attempting to free the right skid, which induced a dynamic rollover.Sep 8, 2005 · N8348T · Substantial damageNTSB LAX05FA290Accident · 2 fatalField investigationFinal reportCessna 172RG · Avalon, CAan in-flight loss of control for undetermined reasons.Sep 7, 2005 · N9636B · DestroyedNTSB LAX05LA247Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Fallbrook, CAThe pilot's failure to maintain directional control during the landing rollout.Jul 29, 2005 · N6121N · Substantial damageNTSB LAX05LA245Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Oroville, CAa binding and/or activation of the brakes that lead to an inadvertent nose over. The underlying root cause of the brake binding/activation could not be determined.Jul 26, 2005 · N87008 · Substantial damageNTSB LAX05LA241Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Beaumont, CAthe pilot's failure to maintain an adequate airspeed while maneuvering that led to an inadvertent stall/mush. The pilot's delayed decision to release the banner was also causal.Jul 21, 2005 · N629AP · Substantial damage