NTSB investigations: Lycoming I0360 SER A&C
647 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C. 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 ('41511'))
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 ('41511'))
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 GAA16CA386Accident · No injuriesData collectionFinal reportCessna 172 · Chesterfield, MOThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.NTSB ERA16CA246Accident · No injuriesData collectionFinal reportMooney M20 · Clifton, TNThe flight's encounter with unforecast extreme turbulence, which resulted in a loss of airplane control and structural damage.NTSB GAA16CA323Accident · Minor injuriesData collectionFinal reportMooney M20 · Reedsburg, WIThe pilot's long landing and failure to stop the airplane on the runway, resulting in an overrun, impact with a fence, and substantial damage to the airplane.NTSB GAA16CA310Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA 4 · Greers Ferry, ARThe amphibious airplane pilot's incorrect pitch attitude during landing on choppy water, which resulted in a nose over, and substantial damage to the fuselage.NTSB ERA16LA212Accident · Serious injuriesLimited investigationFinal reportPiper PA28RT · Taylorsville, KYThe pilot's improper decision to continue a takeoff with a partial loss of engine power that occurred early in the takeoff roll. The reason for the partial loss of engine power could not be determined because postaccident fire damage to the engine precluded…NTSB GAA16CA288Accident · No injuriesData collectionFinal reportCessna 172 · Henderson, ARThe pilot's decision to abort the takeoff, which resulted in a hard landing and nose landing gear collapse.NTSB GAA16CA253Accident · No injuriesData collectionFinal reportCessna 172 · Shawnee, OKThe pilot's failure to remain a safe distance from obstacles while taxiing to parking, resulting in the airplane's wing striking a light pole.NTSB ERA16LA177Accident · No injuriesLimited investigationFinal reportMaher Daniel J Velocity · Worcester, MAThe overstress failure of the nose landing gear fork assembly.NTSB ERA16FA127Accident · 2 fatalField investigationFinal reportSheahen Dane E RV-8 · Clermont, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing; which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the fatigue failure of the crankshaft for reasons that could…NTSB OPS16IA009IncidentClass 3 · IncidentFinal reportCessna 172S · Honolulu, HIThe air traffic controller's decision to clear an aircraft to land on a runway occupied by another aircraft that had previously been instructed to line up and wait. Contributing to the runway incursion was the failure of the air traffic controller to visually…NTSB GAA16CA131Accident · No injuriesData collectionFinal reportFoxworthy Roy Christen Eagle · Bell City, LAThe pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a runway excursion and a nose over.NTSB GAA16LA100Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28 · Ritter Butte, ORThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain.NTSB CEN16LA092Accident · No injuriesLimited investigationFinal reportCessna 172R · Sulfur Springs, TXThe student pilot’s failure to maintain directional control during landing.NTSB ANC16LA011Accident · 1 fatalLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's intentional flight into a building.NTSB ERA15LA366Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bally, PAThe pilot's failure to maintain altitude during low-level aerobatic maneuvers. Contributing to the accident were the pilot's improper decision to attempt the low-level aerobatic maneuvers and his impairment due to psychiatric conditions and the medications he…NTSB ERA15LA341Accident · Minor injuriesClass 2 · LimitedFinal reportPiper PA 28RT-201 · Russell Springs, KYMaintenance personnel’s inadequate fuel injection servo maintenance due to an out-of-date AD list, which resulted in the fuel injection servo plug backing out of the threaded plug hole on the regulator cover of the fuel injection servo and subsequent total…NTSB GAA15CA161Accident · No injuriesData collectionFinal reportCessna 172S · Galesburg, ILFirewall damage reported by maintenance personnel that occurred during an unknown phase of flight, because the accident flight and pilot could not be determined.NTSB GAA15CA086Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA 4 200 · Glenwood, MNThe pilot's improper lateral/ bank level off during the landing flare, which resulted in the right wing impacting the water and a subsequent loss of control.NTSB ERA15LA177Accident · No injuriesLimited investigationFinal reportMooney M20J · Allentown, PAA total loss of engine power during takeoff due to an interruption of fuel flow to the engine. The reason for the interruption of the fuel flow could not be determined during postaccident examination and testing.NTSB ERA15LA172Accident · No injuriesClass 3 · LimitedFinal reportMerian Richard F RV 8 · Tuscaloosa, ALThe RV-8 pilot's failure to maintain adequate clearance from the RV-6 while maneuvering during an air show, which resulted in a midair collision.NTSB ERA15CA150Accident · No injuriesData collectionFinal reportCessna 172S · Richmond, VAThe student pilot's inadequate landing flare which resulted in a hard landing and substantial damage to the airplane.NTSB WPR15CA115Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Phoenix, AZThe pilot under instruction's inadvertent retraction of the landing gear during the landing rollout.NTSB WPR15LA113Accident · No injuriesLimited investigationFinal reportMooney M20E - NO Series · Bakersfield, CAThe collapse of all three landing gear during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR15LA014Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Big Bear, CAA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN14LA507Accident · 2 fatalLimited investigationFinal reportManweiller Acro Sport II · Middletown, OHThe failure of the flying pilot to maintain airplane control after an aerodynamic stall/spin occurred during the aerobatic maneuver following a reported intermittent loss of engine power for reasons that could not be determined during postaccident…NTSB WPR14FA348Accident · 1 fatalField investigationFinal reportCliff Starduster II SA300 · Placerville, CAThe pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions following a partial loss of engine power for reasons that could not be determined, because postaccident examination of the airframe and engine did not reveal…NTSB ERA14LA336Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Titusville, FLThe pilot's failure to secure the fuel strainer drain during the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR14FA243Accident · 2 fatalField investigationFinal reportDittenber Thomas J Auriga · Echo Bay, NVThe pilot's failure to maintain airplane control while maneuvering for landing to an unlit runway in dark night conditions.NTSB WPR14CA193Accident · No injuriesData collectionFinal reportKalman George Lancair 360 · Grand Canyon, AZThe pilot's inadequate flare, which resulted in a hard landing.NTSB CEN14CA236Accident · No injuriesData collectionFinal reportMorris Thomas Lee Stolp Strdstr SA300 · Lincoln, NEThe pilot's loss of directional control while landing in gusty crosswinds in a tail wheel equipped airplane.NTSB ERA14FA182Accident · 2 fatalField investigationFinal reportMonroe Dennis RV-7 · Summerfield, FLThe pilot's failure to maintain airplane control while maneuvering at a low airspeed, which resulted in an aerodynamic stall, and his decision to maneuver at an altitude that did not allow an adequate margin to recover from a stall.NTSB WPR14CA129Accident · No injuriesData collectionFinal reportPartenavia P 68 Observer · Molokai, HIThe pilot's inadequate decision to continue an unstable approach in dark night conditions, which resulted in a collision with trees and hard landing.NTSB ERA14CA127Accident · Minor injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe pilot's failure to maintain directional control while landing.NTSB WPR14CA095Accident · No injuriesData collectionFinal reportHallendorf Tom RV 6 · Sacramento, CAThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.NTSB CEN14CA088Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Bowling Green, OHA bird strike during takeoff.NTSB WPR14CA011Accident · Serious injuriesData collectionFinal reportMooney M20J · Sedona, AZThe pilot's inadequate flare which resulted in a bounced landing and subsequent loss of aircraft control during an aborted landing.NTSB WPR13LA407Accident · No injuriesLimited investigationFinal reportMooney M20J · Lund, NVThe pilot’s failure to monitor the environment, which led to a collision with power lines during climbout. Contributing to the accident was the loss of engine power during low-altitude flight for reasons that could not be determined because postaccident…NTSB ERA13CA378Accident · Minor injuriesData collectionFinal reportCessna 172R · Shelter Island, NYThe pilot did not attain the proper touchdown point on the runway, which resulted in a runway excursion.NTSB ERA13LA374Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Marco Island, FLThe pilot’s improper pitch trim setting before takeoff, which resulted in the airplane’s rapid, nose-high pitch at takeoff and the pilot’s subsequent loss of control.NTSB ERA13CA371Accident · No injuriesData collectionFinal reportCessna 172S · Manassas, VAThe student pilot’s improper recovery from a bounced landing.NTSB ERA13CA350Accident · No injuriesData collectionFinal reportCessna 172S · Portsmouth, NHThe pilot’s inadequate preflight inspection resulting in his failure to remove the pin he used to lock the flight controls in place of the approved control lock.NTSB WPR13CA355Accident · No injuriesData collectionFinal reportMooney M20F · Helena, MTThe flight instructor's delayed decision to instruct the pilot to abort the landing which resulted in a runway excursion and collision with a fence.NTSB CEN13LA370Accident · No injuriesLimited investigationFinal reportMooney M20J · El Reno, OKA loss of engine power, which resulted from the failure of the magneto assembly for reasons that could not be determined during postaccident examinations.NTSB ERA13LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Clearwater, FLA total loss of engine power for reasons that could not be determined because neither postaccident visual examinations nor test runs of the engine revealed any anomalies that would have precluded normal operation.NTSB WPR13FA269Accident · 2 fatalField investigationFinal reportGraves SH-2F · Montague, CAThe pilot’s failure to maintain airplane control while maneuvering for reasons that could not be determined during postaccident testing and examination, which resulted in a stall and subsequent spin.NTSB CEN13CA334Accident · No injuriesData collectionFinal reportBeech C24R · Peyton, COThe pilot’s failure to maintain proper pitch control during takeoff.NTSB CEN13LA261Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Staples, MNThe pilot’s misjudged landing flare, which resulted in a porpoised landing.NTSB ERA13CA172Accident · No injuriesData collectionFinal reportMooney M20J · Springfield, TNThe pilot’s failure to maintain airplane control while landing in gusting wind conditions.NTSB ERA13CA044Accident · No injuriesData collectionFinal reportCessna 172R · Miami, FLThe flight instructor's improper power management during a steep, obstacle-clearance approach, which resulted in a hard landing.NTSB WPR13LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.