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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA06CA129Accident · Minor injuriesData collectionFinal reportMooney M-20F · Summit, UTThe pilot's failure to maintain clearance from the terrain during a climb. Encounter with a severe downdraft, and mountainous terrain were factors.NTSB CHI06LA157Accident · 1 fatalLimited investigationFinal reportGood RV-6A · Peru, ILFailure of the pilot of the second airplane in the formation to maintain clearance with the lead airplane during the overhead recovery maneuver prior to landing.NTSB 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.NTSB DFW06CA144Accident · No injuriesData collectionFinal reportMooney M20J · Wichita Falls, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the gusty crosswind.NTSB CHI06LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hale, MIThe pilot's inadequate compensation for the crosswind condition and failure to maintain clearance from the tree. Factors were the crosswind and the tree.NTSB ATL06LA083Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Blacksburg, SCThe pilot's failure to abort the takeoff after the airplane failed to achieve adequate airspeed on the takeoff roll for undetermined reasons. This resulted in an abrupt pull up, inadvertent stall, and in flight collision with wires, trees and the ground.NTSB ATL06CA075Accident · No injuriesData collectionFinal reportCessna C172S · Muscle Shoals, ALThe student pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB NYC06CA108Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Chester, CTThe pilot's delayed decision to abort the takeoff, which resulted in an overrun. A factor in the accident was the pilot's inadequate preflight planning.NTSB CHI06LA124Accident · No injuriesLimited investigationFinal reportHughes 269B · Sullivan, OHFatigue failure of the fuselage-to-tail boom cluster fitting, and the secondary failure of the tail rotor drive shaft. An additional cause was the incomplete compliance with an applicable Airworthiness Directive. A factor was the ditch.NTSB 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.NTSB LAX06CA150Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe pilot's misjudged flare resulting in a hard landing and a porpoise pilot induced oscillation.NTSB MIA06FA098Accident · 2 fatalField investigationFinal reportBeech A24R · Okeechobee, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation and an in-flight break up. Contributing to the accident were the dark night and thunderstorms.NTSB MIA06CA097Accident · Minor injuriesData collectionFinal reportLake LA-4-200 · Lake Wales, FLThe pilot's failure to abort the takeoff resulting in an overrun of the runway and encounter with terrain.NTSB CHI06CA130Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Brook, INThe pilot's intentional decision to leave the helicopter unattended with the engines running which resulted in a dynamic rollover. The inadvertent dynamic rollover was a factor.NTSB NYC06LA101Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Norwood, MAImproper maintenance, which resulted in a fatigue fracture of the dual magneto mounting flange, and a subsequent loss of engine power.NTSB SEA06CA081Accident · No injuriesData collectionFinal reportCessna 172 S · Malad City, IDThe private pilot's improper touchdown point during landing and the certified flight instructors delayed remedial action. Ditches and fences were factors in the accident.NTSB LAX06CA136Accident · No injuriesData collectionFinal reportCessna 172 · Wickenburg, AZthe pilot's failure to maintain directional control.NTSB 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.NTSB NYC06CA077Accident · No injuriesData collectionFinal reportCessna 172S · Atlantic City, NJThe pilot's failure to obtain a proper touchdown point, which resulted in an overrun of the runway.NTSB 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.NTSB ANC06CA019Accident · No injuriesData collectionFinal reportKenetic Mountain Goat · Palmer, AKThe pilot's selection of unsuitable terrain for taxi, which resulted in the airplane nosing over while taxiing after landing. A factor associated with the accident was the rough and uneven terrain.NTSB DFW06CA032Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Anahuac, TXThe student pilot's loss of directional control during the landing. A contributing factor was the flight instructor' delayed remedial action.NTSB MIA06LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Heathrow, FLA partial loss of engine power due to undetermined reasons resulting in a forced landing in a residential area.NTSB LAX06LA032Accident · No injuriesLimited investigationFinal reportCessna 172R · Ramona, CAthe student pilot's failure to maintain directional control during the landing.NTSB MIA06LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Opa-Locka, FLThe failure of the pilot-in-command/CFI to maintain control of the airplane and his inattentiveness to the altitude while troubleshooting the landing gear system resulting in the in-flight collision with terrain.NTSB CHI06LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Portland, INThe pilot's decision to operate the helicopter with a known engine deficiency, the loss of engine power due to the connecting rod failure, and the pilot's failure to maintain directional control during landing. A factor to the accident was the corn crop and…NTSB NYC06CA014Accident · Minor injuriesData collectionFinal reportBeechcraft BE-24R · Esperance, NYThe pilot's failure to maintain directional control during landing.NTSB LAX06LA006Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R-22 Beta II · Eagar, AZThe pilots' inadequate in-flight planning, which led the helicopter toward rising terrain in excess of the performance capability of the helicopter. Contributing factors were the high density altitude, and the rapidly rising terrain.NTSB ATL06CA001Accident · Minor injuriesData collectionFinal reportBeech D-95A · Greensboro, NCThe pilot mistakenly shut down the operating engine when the passenger interfered with the rudder pedals as he attempted to identify the inoperative engine.NTSB DEN05CA145Accident · No injuriesData collectionFinal reportCessna 172S · Cedar City, UTthe student pilot's failure to maintain aircraft control during the landing. Factors contributing to the accident were the improper flare and improper recovery from a bounced landing.NTSB SEA05CA168Accident · No injuriesData collectionFinal reportHughes 269A · Ashland, ORThe inability of the dual student to maintain directional control of the helicopter during the landing roll when the left skid sank into an area of thick, soft, sticky tar, and the instructor pilot's improper decision to perform a full-down autorotational…NTSB IAD05CA120Accident · No injuriesData collectionFinal reportCessna 172S · White Plains, NYThe pilot's improper recovery from a bounced landing.NTSB CHI05FA199Accident · 1 fatalField investigationFinal reportGlasair GS-2 · Wautoma, WIthe abrupt maneuver that was performed while failing to maintain airpeed, resulting in a stall, and uncontrolled impact with the ground without sufficient altitude to recover.NTSB IAD05CA104Accident · No injuriesData collectionFinal reportCessna 172S · Charlottesville, VAThe student pilot's improper flare which resulted in a hard landing.NTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.NTSB ATL05CA114Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Daytona Beach, FLThe private pilots improper landing flare. Factors were flight instructors inadequate supervision, and landing crosswind.NTSB 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).NTSB LAX05LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Happy Jack, AZThe fracture/separation of an engine intake valve during cruise flight, which resulted in a partial loss of engine power and a forced landing.NTSB LAX05CA207Accident · No injuriesData collectionFinal reportCessna 172R · Santa Maria, CAthe student pilot's improper flare and recovery from a bounced landing.NTSB LAX05LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Carlsbad, CAthe other pilot's inadequate visual lookout and failure to maintain separation while taxiing.NTSB IAD05LA072Accident · Serious injuriesLimited investigationFinal reportWeiss Vans RV-8 · Canandaigua, NYPartial blocking of the flight controls by unsecured items in the cockpit, which resulted in a loss of control during takeoff.NTSB ATL05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Louisburg, NCThe pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent loss of control and collision with the ground.NTSB ATL05CA088Accident · No injuriesData collectionFinal reportCessna 172 · Raleigh, NCThe pilot's failure to maintain adequate obstacle clearance during initial climb, which resulted in an in-flight collision with treesNTSB IAD05FA067Accident · 4 fatalField investigationFinal reportCessna 172S · Brooklyn, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.NTSB CHI05CA124Accident · No injuriesData collectionFinal reportCessna 172S · Port Huron, MIThe pilot not performing a go-around and misjudging the flare leading to a hard landing.NTSB LAX05CA181Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Tucson, AZthe improper flare by an undetermined crewmember, which resulted in a hard landing.NTSB NYC05FA075Accident · 2 fatalField investigationFinal reportCessna 172R · Armonk, NYThe flight instructor's failure to maintain the proper altitude\clearance during the approach, which resulted in an in-flight collision with trees. Factors in this accident were low ceilings, fog, and gusty wind conditions.NTSB IAD05CA056Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA40 · Leesburg, VAThe pilot's failure to maintain directional control. Factors contributing to the accident were the pilots lack of experience, and the uphill terrain.NTSB DFW05FA099Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Jefferson, TXThe pilot's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.NTSB CHI05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Kalamazoo, MIThe pilot's failure to maintain directional control and the excessive taxispeed.