NTSB investigations: Lycoming I0360 series

2,882 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.\"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 ERA11CA052Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cambridge, MDThe commercial pilot’s inadequate flare during landing and the certificated flight instructor's delayed remedial action, which resulted in a hard landing.Oct 23, 2010 · N56101 · Substantial damageNTSB ERA11LA033Accident · No injuriesLimited investigationFinal reportRockwell International 112TC · Waynesboro, GAThe pilot’s deliberate exiting of the airplane by parachute while in flight following a reported flight control malfunction that could not be verified.Oct 21, 2010 · N1154J · Substantial damageNTSB ERA11CA020Accident · Minor injuriesData collectionFinal reportMooney M20E · New Smyrna Beach, FLThe pilot’s inadequate preflight inspection, which resulted in the loss of engine power due to water contaminated fuel.Oct 13, 2010 · N5743Q · Substantial damageNTSB WPR11LA013Accident · No injuriesLimited investigationFinal reportBeech C24 · Blanding, UTThe pilot’s failure to attain a climb gradient sufficient to clear the rising terrain, which resulted in his decision to make a forced landing on a road.Oct 10, 2010 · N5063M · Substantial damageNTSB ERA10CA513Accident · No injuriesData collectionFinal reportPiper PA34 · Northampton, MAThe pilot's improper recovery from a bounced landing.Sep 23, 2010 · N56196 · Substantial damageNTSB WPR10LA456Accident · Serious injuriesLimited investigationFinal reportSavage Savage-Cozy · Aurora, ORThe pilot’s failure to maintain control of the airplane following a loss of engine power in the traffic pattern; the cause of the loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not…Sep 12, 2010 · N9699 · Substantial damageNTSB CEN10CA522Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Berrien Springs, MIThe flight instructor's delayed remedial action, which resulted in a hard landing.Sep 6, 2010 · N404SE · Substantial damageNTSB CEN10FA519Accident · Serious injuriesField investigationFinal reportKwech Glasair RG Super 11S · Lake Elmo, MNThe pilot's failure to maintain control of the airplane during takeoff with gusty wind conditions, which resulted in a collision with terrain.Sep 3, 2010 · N333HK · Substantial damageNTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.Aug 21, 2010 · N123TA · Substantial damageNTSB ERA10LA423Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Eastover, NCThe uncommanded retraction of the nose gear for undetermined reasons and the pilot's improper decision to continue the takeoff after the propeller began to contact the ground.Aug 15, 2010 · N792Y · Substantial damageNTSB CEN10LA432Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Muskegon, MIA loss of engine power for undetermined reasons.Jul 25, 2010 · N24584 · Substantial damageNTSB ERA10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · New Bern, NCInadequate quality control at the fuel servo overhaul facility, which resulted in contamination of the fuel servo and a subsequent loss of engine power due to fuel starvation.Jul 20, 2010 · N8900E · Substantial damageNTSB ERA10FA359Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · North Myrtle Beach, SCThe pilot's failure to maintain aircraft control while maneuvering in instrument meteorological conditions around a thunderstorm. Contributing to the accident was the pilot's lack of recent actual instrument experience.Jul 15, 2010 · N2825A · Substantial damageNTSB ERA10CA358Accident · No injuriesData collectionFinal reportCessna 172 · Fairhope, ALThe student pilot's failure to maintain directional control during a crosswind takeoff.Jul 13, 2010 · N295SP · Substantial damageNTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.Jul 12, 2010 · N527MJ · Substantial damageNTSB CEN10LA381Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Goddard, KSThe pilot did not maintain airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s poor preflight planning.Jul 9, 2010 · N919YA · Substantial damageNTSB WPR10LA340Accident · No injuriesLimited investigationFinal reportMooney M20F · Cottonwood, AZThe pilot’s failure to lower the landing gear prior to landing.Jul 2, 2010 · N6802V · Substantial damageNTSB ERA10CA341Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Farmingdale, NYThe student pilot's failure to maintain directional control during a crosswind landing.Jun 30, 2010 · N388MA · Substantial damageNTSB CEN10CA359Accident · Minor injuriesData collectionFinal reportPiper PA28R · McGregor, TXA total loss of engine power for undetermined reasons. Contributing to the severity of injuries was the airplane's lack of shoulder harnesses.Jun 29, 2010 · N4627J · Substantial damageNTSB WPR10FA330Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Dixon, MTThe pilot’s failure to maintain adequate airspeed and aircraft control while maneuvering, resulting in an aerodynamic stall and collision with mountainous terrain.Jun 27, 2010 · N7581J · Substantial damageNTSB CEN10CA347Accident · No injuriesData collectionFinal reportMooney M20F · Lubbock, TXThe student pilot's failure to maintain control during a go-around.Jun 26, 2010 · N3495X · Substantial damageNTSB ERA10CA350Accident · No injuriesData collectionFinal reportCessna 172S · Salisbury, MDThe student pilot's improper recovery from a bounced landing.Jun 25, 2010 · N2373K · 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 CEN10LA303Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Kingfisher, OKThe pilot's inadequate airspeed while landing, which led to an aerodynamic stall and a hard landing.Jun 6, 2010 · N7559J · Substantial damageNTSB WPR10CA270Accident · No injuriesData collectionFinal reportBeech C24R · Boise, IDThe pilot's failure to properly configure the landing gear for landing and the flight instructor's inadequate supervision.May 29, 2010 · N23995 · Substantial damageNTSB WPR10CA266Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · St. George, UTThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.May 26, 2010 · N40800 · Substantial damageNTSB WPR10CA230Accident · No injuriesData collectionFinal reportCessna 172S · Palo Alto, CAThe student pilot's failure to maintain directional control and the certified flight instructor’s delayed response to the student pilot's loss of control during the takeoff roll.May 3, 2010 · N796SP · Substantial damageNTSB WPR10LA208Accident · Minor injuriesLimited investigationFinal reportBibbee Cozy Mark IV · North Las Vegas, NVThe airplane's inability to recover from a stall due to the builder's failure to comply with design specifications and update the pilot’s operating handbook, which would have highlighted the discrepancies in the airplane's build-up.Apr 16, 2010 · N68TF · Substantial damageNTSB WPR10LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eliza Island, WAThe total loss of engine power during cruise flight due to the failure of maintenance personnel to tighten a fitting on the propeller governor oil line, which resulted in a loss of engine oil and catastrophic engine failure.Mar 17, 2010 · N1KU · Substantial damageNTSB CEN10CA144Accident · Minor injuriesData collectionFinal reportCessna 172R · Newark, OHThe pilot's failure to maintain directional control during takeoff.Mar 5, 2010 · N391ES · Substantial damageNTSB WPR10LA091Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Camas, WAThe left magneto's broken p-lead, which led to the engine inadvertently starting while the pilot was turning the propeller by hand.Dec 22, 2009 · N973WP · Substantial damageNTSB ERA10FA091Accident · 4 fatalField investigationFinal reportCessna 172S · Kissimmee, FLThe pilot's decision to depart under special VFR flight at night when instrument meteorological conditions prevailed at the departure airport and along the route of flight and his continued VFR flight into instrument meteorological conditions, which resulted…Dec 8, 2009 · N5269X · DestroyedNTSB WPR10CA086Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Nogales, AZThe student's improper landing flare and the flight instructor's inadequate remedial action.Dec 3, 2009 · N2085T · Substantial damageNTSB ERA10FA074Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Wappinger, NYA total loss of engine power due to a delamination of the No. 3 connecting rod bearing. Contributing to the accident was the inadequate maintenance inspection of the engine oil system.Nov 22, 2009 · N345AT · Substantial damageNTSB ERA10LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hammonton, NJA total loss of engine power due to a blocked fuel vent.Nov 21, 2009 · N909CW · Substantial damageNTSB ERA10CA067Accident · No injuriesData collectionFinal reportRobert Wood Thorp T18 · Newburgh, NYThe pilot's failure to maintain directional control during the landing rollout.Nov 16, 2009 · N335BW · Substantial damageNTSB ERA10FA062Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Dennisville, NJThe non-instrument-rated pilot's decision to depart into known instrument meteorological conditions, which resulted in his spatial disorientation and overcontrol of the airplane and the subsequent in-flight structural failure. Contributing to the accident was…Nov 14, 2009 · N4499T · Substantial damageNTSB WPR10CA038Accident · No injuriesData collectionFinal reportMooney M20F · Palm Springs, CAThe pilot's inadequate compensation for gusty crosswind conditions and his failure to maintain directional control.Oct 29, 2009 · N400EB · Substantial damageNTSB CEN09LA558Accident · No injuriesLimited investigationFinal reportHughes 269C · Arapahoe, NEA sudden vibration for undetermined reasons.Sep 2, 2009 · N58163 · Substantial damageNTSB ERA09CA495Accident · No injuriesData collectionFinal reportUnderland/Grothe/Finstrom Mmii (Must · Lantana, FLThe delay by both pilots to abort the takeoff resulting in a runway overrun. Contributing to the accident was the unintentional forward movement of the pilot's seat resulting in interference with the control stick.Aug 29, 2009 · N7798R · Substantial damageNTSB WPR09LA417Accident · No injuriesLimited investigationFinal reportPiper PA28R · Wendover, UTThe failure of the pilot to attain and maintain an airspeed sufficient for normal landing gear retraction during initial climb. Contributing to the accident was the pilot's failure to use the airplane's manual override landing gear system, misidentifying that…Aug 27, 2009 · N4837T · Substantial damageNTSB WPR09LA401Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gerlach, NVThe pilot’s delay in aborting the takeoff, resulting in a runway excursion.Aug 9, 2009 · N32105 · Substantial damageNTSB ERA09LA441Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Suffolk, VAA loss of engine power due to fuel exhaustion as a result of the pilot’s failure to accurately calculate the fuel required for the flight. Contributing to the accident was a malfunction of the fuel quantity indicators.Aug 3, 2009 · N3549N · Substantial damageNTSB ANC09CA070Accident · No injuriesData collectionFinal reportDressen Donald L Back Count · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground-loop and substantial damage to the airplane.Jul 19, 2009 · N425BC · Substantial damageNTSB WPR09CA345Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Tucson, AZA hard landing or abnormal runway contact by one or both pilots.Jul 14, 2009 · N3953T · Substantial damageNTSB CEN09IA416Incident · No injuriesIncident investigationFinal reportMooney M20J · Midland, TXThe pilot’s failure to ensure the airplane was properly configured, which resulted in a wheels-up landing.Jul 6, 2009 · N201FD · Minor damageNTSB CEN09LA424Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Racine, WIThe pilot's improper landing flare that resulted in a hard landing and subsequent separation of the airplane's sponson.Jul 4, 2009 · N56LA · Substantial damageNTSB 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 ERA09FA345Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Scotia, NYThe flight instructor's failure to ensure that the airplane was properly configured for a short field takeoff, and his decision to not abort the takeoff.Jun 14, 2009 · N3226R · Substantial damageNTSB CEN09LA285Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Metropolis, ILA total loss of engine power for undetermined reasons.May 10, 2009 · N1348J · Substantial damage