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 FTW03LA092Accident · Minor injuriesLimited investigationFinal reportMooney M20J · New Orleans, LAThe loss of engine power as a result of the separation of the magneto assembly due to inadequate maintenance by unknown personnel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX03FA065Accident · Serious injuriesField investigationFinal reportPiper PA-34-200 · Westlake Villag, CAa fatigue crack in the propeller hub due to the inadequate design location of the grease fitting and the chamfering process.NTSB FTW03LA079Accident · No injuriesLimited investigationFinal reportCessna 172S · Springdale, ARThe pilot's failure to maintain directional control while landing. A contributing factor was the prevailing crosswind.NTSB MIA03FA024Accident · 2 fatalField investigationFinal reportAaa Aircraft Leasing 192 · Miami, FLThe inflight fire of undetermined origin, which resulted in pilot incapacitation, loss of aircraft control and an inflight collision with a building.NTSB DEN03LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Tooele, UTthe inadvertent retraction of the landing gear during landing roll by the dual student. Contributing factors included the dual student's lack of familiarity with the aircraft, inadequate supervision by the flight instructor, and improper rigging of the…NTSB LAX03LA029Accident · No injuriesLimited investigationFinal reportMooney M20J · Fullerton, CAThe pilot's inadequate preflight inspection resulting in a loss of engine power due to water contamination of the fuel system.NTSB DEN03LA007Accident · No injuriesLimited investigationFinal reportMooney M20J · Englewood, COthe complete collapse of the landing gear, during landing roll, for undetermined reasons.NTSB MIA03LA001Accident · 1 fatalLimited investigationFinal reportBowers Velocity SR6E · Valkaria, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.NTSB CHI03LA001Accident · No injuriesLimited investigationFinal reportMooney M20J · Chicago, ILThe pilot's inadequate compensation for wind, and his failure to maintain directional control.NTSB MIA02LA166Accident · No injuriesLimited investigationFinal reportBeech C24R · Olar, SCThe pilot's failure to execute the proper remedial action for hydraulic leak fumes in the cockpit, and his decision to perform an immediate precautionary landing to a vacant field, resulting in collision with a tree. A factor in the accident was the…NTSB CHI02FA243Accident · Minor injuriesField investigationFinal reportCorken/Guillet Christen Eagle II · Kaneville, ILLoss of engine power due to an engine bearing failure.NTSB NYC02LA149Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Madison Heights, VAThe pilot's failure to attain the proper touchdown point on the helipad, which resulted in a rollover. A factor in this accident was pilot fatigue.NTSB CHI02CA202Accident · Minor injuriesData collectionFinal reportEckstein RV-6A · Mattawan, MIFailure by the pilot in command to attain a proper touchdown point considering the available runway length. The rough, uneven runway surface and the soft area at the far end of the runway were contributing factors.NTSB MIA02GA137Accident · 3 fatalFinal reportCessna 172S · Tyner, NCThe loss of power for undetermined reasons, and the pilot's failure to maintain airspeed.NTSB ATL02FA137Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Lebanon, TNThe certified flight instructor attempted flight with known deficiencies in equipment, inoperative magneto, and subsequent lost engine power and collided with a transmission line while maneuvering for a forced landing.NTSB CHI02LA154Accident · No injuriesLimited investigationFinal reportMooney M20J · Minneapolis, MNThe pilot's failure to maintain control of the aircraft during an aborted landing.NTSB MIA02FA104Accident · 1 fatalField investigationFinal reportCessna 172S · Lutz, FLThe suicidal act by the pilot resulting in the in-flight collision with trees then the ground. A contributing factor in the accident was the pilot's depression. Findings in the investigation were the pilot's overdose of zolpidem and citalopram before the…NTSB FTW02FA162Accident · 1 fatalField investigationFinal reportCirrus Design SR-20 · Angel Fire, NMThe 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,NTSB IAD02LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norwood, MAThe student pilot's failure to maintain directional control during an aborted landing.NTSB MIA02LA092Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Headland, ALa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB FTW02LA123Accident · No injuriesLimited investigationFinal reportHalfacre Velocity · Cleveland, TXthe pilot's failure to maintain the proper descent rate during the landing flare/touchdown.NTSB FTW02LA108Accident · No injuriesLimited investigationFinal reportMooney M20F · Grapeland, TXThe loss of engine power due to the #2 connecting rod cap separating from the connecting rod. A contributing factor was the limited forward visibility due to oil on the windscreen.NTSB NYC02LA071Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR-20 · Lexington, KYThe pilot's failure to maintain aircraft control. Factors in this accident were the undetermined failure of the turn coordinator, as reported by the pilot, and the instrument meteorological conditions.NTSB ATL02IA065Incident · No injuriesIncident investigationFinal reportBeech C24R · Greenville, MSAn overload failure of the nose gear assembly for undetermined reasons.NTSB LAX02LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Santa Paula, CAThe pilot's selection of the wrong landing runway due to his failure to correctly interpret wind indicators, which resulted in his landing with a tailwind.NTSB NYC02LA053Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, VAThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot improper flare.NTSB SEA02LA031Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glasgow, MTThe pilot's failure to maintain adequate flying airspeed resulting in a stall/mush condition and loss of control at low altitude. A contributing factor was the pilot's distraction from flying the aircraft while attempting to retract the landing gear.NTSB ATL02FA032Accident · 1 fatalField investigationFinal reportCessna 172R · Tampa, FLThe pilot's unauthorized use of an aircraft for the purpose of commiting suicide.NTSB CHI02LA035Accident · No injuriesLimited investigationFinal reportBeech 76 · Greenwood, INthe directional control not maintained by the pilot. A contributing factor was the stuck open intake valve on the left engine.NTSB IAD02LA013Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Leesburg, VAThe pilot's improper stowage of hazardous material.NTSB NYC02LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cattaraugus, NYA separation of the cylinder from the engine for undetermined reason(s). A factor was the hidden ground obstruction (hole) which the airplane struck during the landing roll.NTSB CHI01LA318Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-20 · St. Bonifacius, MNImproper servicing of the airplane by other maintenance personnel, inadequate inspection of the airplane by the other maintenance personnel prior to the airplane's flight, and the unsuitable terrain encountered during the forced landing. Factors relating to…NTSB DEN01FA151Accident · 2 fatalField investigationFinal reportAviat A-1 · Montrose, COthe pilot's intentional abrupt maneuver immediately after takeoff and the subsequent loss of aircraft control. Contributing factors were high density altitude weather conditions, and the airplane improper weight and balance.NTSB MIA01LA227Accident · No injuriesLimited investigationFinal reportCessna 172S · Gadsden, ALthe pilot misjudged the flare, resulting in a hard landing, and impact with the runway.NTSB IAD01FA096Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Rohrersville, MDThe pilot's continued VFR flight into obscured, mountanous terrain. Factors included the rising terrain and weather obscuration.NTSB MIA01LA202Accident · 2 fatalLimited investigationFinal reportLancair 360 · St. Marys, GAThe flight instructor/pilot in command's continued flight into known adverse weather, which resulted in a loss of control, and uncontrolled descent, and the airplane crashing into the Atlantic Ocean.NTSB NYC01LA191Accident · No injuriesLimited investigationFinal reportMooney M20J · East Greenwich, NJThe pilot's premature liftoff which resulted in an inadvertent stall.NTSB ATL01LA071Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Mulberry, FLThe loss of engine power for undetermined reasons. A factor was rough and uneven terrain.NTSB DEN01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bryce Canyon, UTthe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.NTSB MIA01LA175Accident · 1 fatalLimited investigationFinal reportBucker-Jungmann Aero Z-131 · Rupert, GAThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB MIA01FA151Accident · 3 fatalField investigationFinal reportMooney M-20J · Monroe, NCThe pilot in command’s failure to maintain airspeed while maneuvering to avoid objects, resulting in a stall/mush and collision with the terrain during uncontrolled descent. Contributing to the accident was the improper approach to land and his failure to…NTSB CHI01LA138Accident · 1 fatalLimited investigationFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot allowed the airspeed to get too low and inadvertently stalled the airplane.NTSB CHI01FA136Accident · No injuriesField investigationFinal reportCessna 172S · Springfield, MOthe excessive touchdown airspeed by the pilot.NTSB CHI01LA131Accident · 1 fatalLimited investigationFinal reportMadsen Lancair 320 · Valparaiso, INThe pilot not maintaining aircraft control during the initial climb after takeoff and the inadvertent stall/spin. A factor to the accident was the pilot's total lack of experience in accident airplane.NTSB NYC01LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hodgenville, KYThe pilot's failure to maintain runway alignment during landing. A factor in the accident was the pilot's lack of experience in conducting soft field landings.NTSB NYC01WA104Accident · 3 fatalForeign investigationMooney M20E · Saint Mamet, FranceNTSB MIA01LA127Accident · No injuriesLimited investigationFinal reportChristen Industries Eagle II · Alexander City, ALA total loss of engine power during cruise flight due to an internal disconnection in the fuel injector control assembly as a result of a failure of the maintenance facility to follow proper installation procedures, resulting in a forced landing and collision…NTSB IAD01LA042Accident · No injuriesLimited investigationFinal reportCessna 172R · Lawrence, MAThe pilot's improper flare.NTSB FTW01LA090Accident · No injuriesLimited investigationFinal reportMooney M20J · Pecos, TXthe pilot's failure to obtain a proper glide path during landing, which resulted in the airplane's impact with terrain short of the runway. Contributory factors were the open baggage door and the pilot's diverted attention to the open door.NTSB IAD01FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-RT201 · Manassas, VAThe pilot's spatial disorientation due to a night visual illusion. A factor was the dark night condition.