NTSB investigations: Lycoming I0360 series, CA

299 cases on aircraft whose registry engine model is Lycoming I0360 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 ('41515'))
  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 WPR09LA298Accident · No injuriesLimited investigationFinal reportSimmons Vans RV-8A · Cameron Park, CAThe pilot's failure to maintain directional control of the airplane while landing with gusting winds.Jun 19, 2009 · N773JM · Substantial damageNTSB WPR09FA133Accident · 2 fatalField investigationFinal reportMooney M20E · Rio Linda, CAA partial loss of engine power for undetermined reasons and the pilot's failure to maintain an adequate airspeed while maneuvering during the initial climb, which resulted in a stall/spin.Feb 28, 2009 · N3463X · Substantial damageNTSB WPR09CA132Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Fallbrook, CAThe pilot's improper use of the brakes and his failure to maintain control of the airplane during landing rollout.Feb 28, 2009 · N4290T · Substantial damageNTSB WPR09FA019Accident · 3 fatalField investigationFinal reportMooney M20J · Avalon, CAThe pilot's failure to maintain aircraft control during takeoff for undetermined reasons. Contributing to the accident was the pilot's failure to abort the takeoff while sufficient runway remained to stop.Oct 20, 2008 · N201EN · DestroyedNTSB LAX08LA121Accident · No injuriesLimited investigationFinal reportCessna 172R · S. Lake Tahoe, CAThe pilot's improper flare and subsequent hard landing. Contributing to the accident were the gusty winds and the high density altitude.Apr 19, 2008 · N2384L · Substantial damageNTSB SEA07CA182Accident · No injuriesData collectionFinal reportCessna 172S · Long Beach, CAThe pilot's improper recovery from a bounced landing which resulted in an inadvertent stall and a hard landing. The crosswind was a factor.Jun 25, 2007 · N137RJ · Substantial damageNTSB LAX07LA186Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Upland, CAFailure of the pilot under instruction to maintain the minimum single engine control airspeed (air) and directional control while turning to final approach. Also causal was the flight instructor's inadequate supervision and delayed remedial actions.Jun 4, 2007 · N4463T · Substantial damageNTSB LAX07FA080Accident · 1 fatalField investigationFinal reportMooney M20J · Ranchita, CAThe pilot's failure to maintain terrain clearance during a cruise descent. Contributing to the accident were the dark night lighting conditions and the mountainous terrain.Feb 4, 2007 · N201RV · Substantial damageNTSB SEA07LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fresno, CAThe design stress limits of the airframe were exceeded by an unknown pilot.Dec 21, 2006 · N4666J · Substantial damageNTSB SEA07FA035Accident · 3 fatalField investigationFinal reportBeech D95A · Gilroy, CAThe certified flight instructor's failure to maintain directional control of the airplane and inadequate supervision of the flight, which resulted in a stall/spin.Dec 18, 2006 · N144PG · DestroyedNTSB LAX06CA191Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Alpine, CAa loss of engine power due to the aviation maintenance technician's failure to install the correct oil sump quick drain, which resulted in the inadvertent draining of engine oil during flight.Jun 4, 2006 · N4438T · Substantial damageNTSB LAX06CA160Accident · No injuriesData collectionFinal reportBeech C24R · Sacramento, CAthe pilot's failure to complete and verify the prelanding checklist and extend the landing gear, which resulted in a gear up landing. A contributing factor was the pilot's diverted attention during the approach.Apr 29, 2006 · N2074P · Substantial damageNTSB LAX06FA133Accident · 1 fatalField investigationFinal reportRockwell 112 TCA · La Canada, CAThe pilot's failure to maintain aircraft control and an adequate airspeed during climb to cruise that led to a stall/spin. Contributing to the accident were the clouds and the pilot's physiological state.Mar 30, 2006 · N4641W · DestroyedNTSB LAX06CA118Accident · Serious injuriesData collectionFinal reportMooney M20F · Willits, CAThe pilot's failure to maintain visual contact with the runway at night, which resulted in a descent below the proper glide path and a collision with a tree. Also causal was the flight instructor's inadequate supervision of the flight.Feb 17, 2006 · N9704M · Substantial damageNTSB LAX06LA032Accident · No injuriesLimited investigationFinal reportCessna 172R · Ramona, CAthe student pilot's failure to maintain directional control during the landing.Nov 13, 2005 · N23899 · Substantial damageNTSB LAX05FA213Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Mt. Shasta, CAThe pilot's continued cruise flight into instrument meteorological conditions, which resulted in the pilot's controlled flight into high mountainous terrain (CFIT).Jun 18, 2005 · N4506J · DestroyedNTSB LAX05CA207Accident · No injuriesData collectionFinal reportCessna 172R · Santa Maria, CAthe student pilot's improper flare and recovery from a bounced landing.Jun 12, 2005 · N2384L · Substantial damageNTSB LAX05LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Carlsbad, CAthe other pilot's inadequate visual lookout and failure to maintain separation while taxiing.Jun 10, 2005 · N1126U · 2 aircraft · Minor damageNTSB LAX05LA012Accident · No injuriesLimited investigationFinal reportBeech C24R · Cloverdale, CAthe loss of engine power due to fuel starvation from the pilot's inadequate fuel system management and his delay in selecting the fullest fuel tank.Oct 22, 2004 · N18942 · Substantial damageNTSB LAX05LA007Accident · 1 fatalLimited investigationFinal reportDeRosier DR-107 · San Diego, CAthe pilot's failure to maintain adequate clearance from terrain while performing low-level aerobatic maneuvers.Oct 15, 2004 · N31SH · Substantial damageNTSB LAX04FA226Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Columbia, CAThe loss of engine power for undetermined reason during takeoff-initial climb, and the pilot's failure to maintain sufficient airspeed to avoid a stall/mush. Factors associated with the accident are an inadvertent stall/mush, and the pilot's failure to abort…May 31, 2004 · N7626J · DestroyedNTSB LAX04CA215Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Galt, CAthe pilot under instruction's failure to maintain an adequate airspeed on final and misjudged flare, which resulted in stall/mush and hard landing. The certified flight instructor's inadequate supervision and failure to initiate timely remedial action were…Apr 25, 2004 · N169JP · Substantial damageNTSB LAX04FA139Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Pine Mtn Club, CAThe pilot's continued visual flight into adverse weather conditions at night, which resulted in an in-flight collision with mountainous terrain. The pilot's failure to obtain preflight weather information for the route of flight was also causal.Feb 28, 2004 · N7687J · DestroyedNTSB LAX04LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hollister, CAthe student pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight.Feb 13, 2004 · N55073 · Substantial damageNTSB LAX04LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · California City, CAthe pilot's decision to continue taxiing during dark night conditions without an operable taxi/landing light or taxiway lights and his failure to maintain taxiway alignment. Contributing factors to the accident were the dark night light conditions, the failed…Jan 7, 2004 · N3820T · Substantial damageNTSB LAX04FA061Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Chino Hills, CAthe pilot's inadequate in-flight planning/decision by which he conducted VFR flight into night instrument meteorological conditions. Mountainous terrain, dark night conditions and the pilot's failure to obtain a preflight weather briefing are contributing…Dec 8, 2003 · N16264 · DestroyedNTSB LAX04LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Pacoima, CAthe pilot's failure to maintain an adequate glide path on final approach and his failure to ensure adequate clearance from obstacles. The dark night was a factor.Oct 25, 2003 · N15192 · Substantial damageNTSB LAX04CA013Accident · No injuriesData collectionFinal reportCleveland Orson Starduster II SA-300 · Stockton, CAthe pilot's inadequate visual lookout resulted in his failure to maintain clearance from the parked airplane.Oct 14, 2003 · N379C · Substantial damageNTSB LAX03LA112Accident · No injuriesLimited investigationFinal reportCessna 172R · Thermal, CAthe student pilot's failure to use aileron controls to compensate for the known crosswind and failure to maintain directional control during the landing rollout.Mar 11, 2003 · N4201Y · Substantial damageNTSB LAX03FA078Accident · 2 fatalField investigationFinal reportBeech D95A · Lancaster, CAa loss of aircraft control due to the instructor pilot's incapacitation by seizure activity as a result of his undiagnosed cancer, and his use of a medication that can increase seizure risk.Jan 31, 2003 · N5639S · DestroyedNTSB LAX02FA288Accident · 3 fatalField investigationFinal reportMooney M-20E · Carlsbad, CAfailure of the pilots of both airplanes to maintain an adequate visual lookout and to see and avoid each other. A contributing factor was the failure of the controller to detect and resolve the conflict between the airplanes.Sep 17, 2002 · N7199U · 2 aircraft · DestroyedNTSB LAX02LA256Accident · Minor injuriesLimited investigationFinal reportDodd RV-4 · Tehachapi, CAthe owner/builder's improperly fabricated and installed fuel line, which cracked at the point of the flare, resulting in a fuel leak and loss of engine power during the takeoff climb. A contributing factor was the soft terrain that jammed the landing gear…Aug 21, 2002 · N62VR · Substantial damageNTSB LAX02FA255Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Echo Summit, CAThe pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,Aug 19, 2002 · N7794C · DestroyedNTSB LAX02LA187Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Placerville, CAA loss of engine power due to the pilot's inadequate in-flight planning/decision which led to fuel exhaustion.Jun 8, 2002 · N1285X · Substantial damageNTSB LAX02LA184Accident · No injuriesLimited investigationFinal reportCessna 172S · Monterey, CAThe pilot was unfamiliar with the airplane's systems and failed to set the elevator trim in accordance with the published checklist.Jun 6, 2002 · N748SP · Substantial damageNTSB LAX02LA130Accident · No injuriesLimited investigationFinal reportCessna 172S · Palm Springs, CAThe pilot lost directional control and collided with a runway edge light and taxiway sign.Apr 3, 2002 · N627SP · Substantial damageNTSB LAX02LA115Accident · No injuriesLimited investigationFinal reportCessna 172R · Camarillo, CAThe pilot's failure to maintain directional control.Mar 25, 2002 · N2630U · Substantial damageNTSB LAX02LA129Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Redlands, CAThe pilot failed to compensate for the wind condtions when he encountered an updraft followed by a downdraft.Mar 20, 2002 · N5060T · Substantial damageNTSB LAX01LA281Accident · 2 fatalLimited investigationFinal reportJohnson Lancair 360 · Placerville, CAIn-flight loss of control for undetermined reasons.Aug 17, 2001 · N417DJ · DestroyedNTSB LAX01LA203Accident · No injuriesLimited investigationFinal reportMooney M20J · Jackson, CAFailure of the pilot to maintain proper airspeed for landing and airplane control with an existing crosswind. A contributing factor was the distraction of the pilot by a yelling passenger.Jun 9, 2001 · N4235H · Substantial damageNTSB LAX01LA173Accident · No injuriesLimited investigationFinal reportAero Commander 112A · Riverside, CAFailure of the pilot to maintain directional control of the airplane during the landing roll. A factor was the worn nose wheel steering assembly.May 5, 2001 · N1159J · Substantial damageNTSB LAX00LA214Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Upland, CAThe failure of the pilot-in-command to maintain directional control of the aircraft on takeoff after the cabin door became ajar.Jun 3, 2000 · N9207V · Substantial damageNTSB LAX00LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Big Bear City, CAThe pilot's selection of a final approach airspeed in variance with the manufacturer's recommendations, which was too slow for the gusty and variable crosswind conditions, which resulted in a stall/mush and a hard landing.Feb 27, 2000 · N15202 · Substantial damageNTSB LAX00LA060Accident · No injuriesLimited investigationFinal reportPitts S-2B · Santa Ana, CAThe failure of the pilot of the other airplane to maintain an adequate obstruction clearance while taxiing.Dec 23, 1999 · N87WA · 2 aircraft · Minor damageNTSB LAX99LA287Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Emigrant Gap, CAThe fatigue failure and separation of the number three cylinder due to the cylinder overhaul facility's improper inspection and quality control processes.Aug 28, 1999 · N4201S · Substantial damageNTSB LAX99LA035Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Upland, CALoss of engine power due to water contaminated fuel and the pilot's inadequate preflight inspection of the airplane. A factor was the failure of the owner/pilot to properly maintain the airplane.Nov 19, 1998 · N3500X · DestroyedNTSB LAX98LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Baker, CAA loss of engine power for undetermined reasons.Jul 23, 1998 · N222LC · Substantial damageNTSB LAX98FA189Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Lytle Creek, CAthe pilot's intentional VFR descent into instrument meteorological conditions, resulting in a collision with mountainous terrain.Jun 8, 1998 · N16344 · DestroyedNTSB LAX98LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Hollister, CAThe failure of the instructors and dual students in both aircraft to maintain an adequate visual lookout, which resulted in their combined failures to see and avoid each other. Inadequate supervision of the two flights by the respective instructor pilots were…May 17, 1998 · N36574 · 2 aircraft · Substantial damageNTSB LAX96LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oxnard, CAthe instructor's inadequate supervision of the flight, and his delay in taking the controls and initiating a go-around. The student pilot's failure to maintain runway alignment and the proximity of the runway remaining marker were related factors.Sep 7, 1996 · N41331 · Substantial damage