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 CEN20LA342Accident · Minor injuriesClass 3 · LimitedFinal reportSiebel Auriga · Rockford, ILThe total loss of engine power for reasons that could not be determined based on available information.NTSB ERA20CA250Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Auburn, METhe student pilot's improper landing flare, which resulted in a hard landing on the nosegear and nosegear collapse.NTSB CEN20LA252Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Denver, COThe total loss of engine power during climbout due to fuel starvation. Contributing to the accident was the pilot’s inadequate fuel planning.NTSB WPR20CA167Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Las Vegas, NVThe student pilot's failure to maintain directional control of the airplane during a soft-field takeoff and the flight instructor's delayed remedial action.NTSB CEN20CA195Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Houma, LAThe pilot's failure to maintain adequate clearance from a ground obstacle during landing.NTSB ERA20CA128Accident · Minor injuriesData collectionFinal reportStolp Starduster Acroduster II SA750 · Senoia, GAThe pilot's failure to see and avoid trees while maneuvering at low altitude, which resulted in a loss of airplane control.NTSB ERA20FA101Accident · 2 fatalClass 3 · FieldFinal reportMooney M20J · Bartow, FLThe pilot’s exceedance of the airplane's critical angle of attack and subsequent aerodynamic stall and spin at low altitude due to a possible distraction in the cockpit for which the reason was undetermined.NTSB ANC19LA051Accident · No injuriesClass 3 · LimitedFinal reportLake LA-4-200 · Girdwood, AKThe pilot's loss of directional control while landing, which resulted in a runway excursion and collision with terrain.NTSB CEN19LA226Accident · Minor injuriesClass 3 · LimitedFinal reportCashen Super Acro Sport · Detroit Lakes, MNAn open circuit in the engine's electrical switch box, which resulted in a partial loss of engine power and subsequent forced landing.NTSB CEN19LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Ypsilanti, MIThe pilot's premature movement of the landing gear selector to the "up" position during takeoff, which allowed the landing gear to retract before a positive climb rate was established, and the lack of a positive climb rate, which led to the airplane settling…NTSB CEN19FA212Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Oxford, MSThe student pilot's failure to maintain airplane control during a go around with a tailwind, which resulted in an uncontrolled descent and impact with terrain.NTSB CEN19FA139Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Moose Lake, MNThe pilot’s failure to maintain control of the airplane after departing into a snowstorm.NTSB GAA19CA282Accident · No injuriesData collectionFinal reportCessna 172 · Edwards Air Force Base, CAAn undetermined event, which resulted in substantial damage to the airplane for reasons that could not be determined based on the available evidence.NTSB GAA19CA130Accident · No injuriesData collectionFinal reportCessna 172 · Hanover, VAThe student pilot's improper decision to release the seat latch to adjust the seat position during taxi, which resulted in his inability to reach the rudder or brake pedals and a subsequent loss of directional control and impact with a ditch and fence.NTSB GAA19CA119Accident · No injuriesData collectionFinal reportCessna 172 · Sugar Land, TXThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a sign.NTSB GAA19CA079Accident · No injuriesData collectionFinal reportPilatus PC12 · Mesa, AZThe other pilot's failure to follow the air traffic controller’s instructions and his subsequent failure to maintain adequate lookout to see and avoid the other airplane on the taxiway.NTSB ERA19LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Lake City, FLThe pilot's failure to attain adequate airspeed before attempting the takeoff with a tailwind, which resulted in the airplane being unable to sustain flight.NTSB GAA18CA511Accident · No injuriesData collectionFinal reportMooney M20J · Rochester, NHThe pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA505Accident · No injuriesData collectionFinal reportCessna 172 · Churchville, MDThe pilot's failure to maintain directional control after landing left of the runway centerline, which resulted in a runway excursion and impact with a power box.NTSB CEN18WA312Accident · 1 fatalForeign investigationSteen Skybolt · Fratauti, RomaniaNTSB WPR18FA195Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Deer Park, WAAn in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.NTSB WPR18LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Phoenix, AZA total loss of engine power due to crankshaft failure as the result of a subsurface fatigue crack.NTSB GAA18CA326Accident · No injuriesData collectionFinal reportCessna 172 · Westminster, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ANC18FA028Accident · 1 fatalField investigationFinal reportMooney M20J · Petaluma, CAThe pilot's failure to maintain adequate airspeed while departing in instrument meteorological conditions, moderate turbulence, and low-level wind shear, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall.NTSB ERA18LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Key West, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB GAA18CA145Accident · No injuriesData collectionFinal reportPiper PA28R · Milton-Freewater, ORThe pilot receiving instruction’s and flight instructor’s improper decision to enter a canyon surrounded by steep rising terrain and their subsequent failure to maintain clearance from terrain while maneuvering at a low altitude.NTSB WPR18CA085Accident · No injuriesData collectionFinal reportMooney M20J · Newport, ORThe pilot's improper approach and landing flare in dark night, which resulted in a bounced landing.NTSB ERA18LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Babylon, NYThe partial loss of engine power after a simulated engine failure for reasons that could not be determined because a postaccident examination and an engine test run did not reveal any anomalies that would have precluded normal operation.NTSB WPR18CA059Accident · No injuriesData collectionFinal reportCessna 182 · Santa Ana, CAThe pilot’s failure to follow ground control instructions and to see and avoid ground obstacles while taxiing.NTSB ANC18LA013Accident · No injuriesLimited investigationFinal reportCessna 172R · Huntingdon, TNA total loss of engine power for reasons that could not be determined because a postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ANC18LA014Accident · No injuriesLimited investigationFinal reportCessna 172 · Miami, FLThe pilot's decision to continue the landing after a loss of visual cues during a night landing.NTSB GAA18CA074Accident · No injuriesData collectionFinal reportCessna 172 · Bowie, MDThe pilot’s failure to maintain situational awareness during the approach to land. Contributing to the accident was the pilot’s distraction by the instrument panel during the approach.NTSB CEN18FA030Accident · 1 fatalField investigationFinal reportTemco GC 1B · Pineville, LAThe loss of engine power due to fuel starvation, which resulted from the unporting of the fuel during a right turn due to the auxiliary fuel tanks' improper configuration.NTSB WPR18FA011Accident · 1 fatalField investigationFinal reportPeterson Lancair Legacy · Bowie, AZAn in-flight loss of control due to a bird strike.NTSB ERA18LA010Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A24 · Manteo, NCThe failure of maintenance personnel to properly secure wiring during an electrical component installation, which resulted in arcing and smoke in the cockpit. Contributing to the outcome was the flight instructor's failure to attain a proper descent rate…NTSB GAA17CA535Accident · No injuriesData collectionFinal reportMooney M20J · Whitesburg, GAThe pilot’s unstabilized approach while landing with a tailwind and his subsequent failure to go around, which resulted in a hard landing.NTSB ERA17LA306Accident · No injuriesLimited investigationFinal reportKerr Gerald Velocity SUV · St. Petersburg, FLThe pilot's misjudgment of the airplane’s speed and the distance remaining during landing and his improper decision to not abort the landing.NTSB GAA17CA484Accident · No injuriesData collectionFinal reportConstrucciones Aeronauticas C.A.S.A. 1.131 · Ocean City, NJThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA17LA264Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA 4 · Orlando, FLA loss of directional control during taxi operations for reasons that could not be determined based on the available information, which resulted in the airplane rolling into a ditch.NTSB GAA17CA425Accident · No injuriesData collectionFinal reportPiper PA28R · Bowling Green, OHThe pilot’s and flight instructor’s failure to extend the landing gear.NTSB OPS17IA021IncidentClass 3 · IncidentFinal reportCessna 172S · New Orleans, LAThe air traffic controller not following Federal Aviation Administration directives to establish sequencing and spacing between aircraft operating to the same runway.NTSB GAA17CA211Accident · No injuriesData collectionFinal reportMooney M20J · Cedar Key, FLThe pilot’s failure to follow the manufacturer’s go-around procedure, which resulted in an aerodynamic stall.NTSB ERA17FA139Accident · 2 fatalField investigationFinal reportMooney M20J · Aberdeen, MSThe pilot's failure to maintain clearance from terrain after takeoff in dark night conditions for reasons that could not be determined based on the available information.NTSB GAA17CA161Accident · No injuriesData collectionFinal reportPiper PA 28R · Phoenix, AZAn in-flight collision with a bird.NTSB ERA17LA031Accident · Minor injuriesLimited investigationFinal reportHaddow William H Pitts Special S 1 · New Bern, NCA loss of biplane control during aerobatic maneuvers for reasons that could not be determined because a portion of the biplane's flight control system was not recovered and could not be tested.NTSB GAA16CA523Accident · No injuriesData collectionFinal reportCessna 172 · Tooele, UTThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB CEN16LA374Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Bowling Green, OHThe pilots’ failure to complete the Emergency Landing Gear Extension checklist and maintenance personnel’s failure to correctly repair spliced wires on the left main landing gear down limit switch, which prevented the pilots from knowing whether the gear was…NTSB CEN16CA319Accident · No injuriesData collectionFinal reportCessna 172S · Arlington, TXThe student pilot's improper recovery from a bounced landing.NTSB CEN16FA295Accident · 1 fatalField investigationFinal reportMooney M20J · Holmen, WIThe pilot's loss of airplane control during an instrument approach. Contributing to the accident was the pilot's lack of instrument flight proficiency.NTSB WPR16CA145Accident · Minor injuriesData collectionFinal reportBeech 19A · Helena, MTThe pilot's failure to reposition the fuel selector valve to the on position prior to takeoff resulting in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.