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 NYC01LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Keene, NHThe pilot's failure to maintain directional control during the landing roll. A factor included the patchy snow on the runway.NTSB CHI01LA092Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIAircraft control not maintained by the student pilot during the takeoff roll. Factors to the accident were the student pilot's lack of experience and the snowbank.NTSB IAD01LA023Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJthe pilot's failure to maintain proper runway alignment during landing. Factors in the accident were the night lighting and the snow bank.NTSB CHI01IA047Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Cloud, MNthe fatigue failure of the propeller blade during the initial takeoff climb. The failure was a result of a material defect, which occurred during the manufacturing process and the manufacturers failure to detect the defect.NTSB DEN01LA014Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Longmont, COthe total failure of the left main gear strut during the landing roll. A contributing factor was the 6-foot high snow bank that the airplane impacted when it left the runway.NTSB MIA01LA018Accident · No injuriesLimited investigationFinal reportMooney M-20J · Deland, FLthe dual student's improper use of the brakes and the flight instructor's inadequate supervision which resulted in a loss of directional control and a subsequent ground swerve during which the aircraft exited the runway and collided with a runway sign.NTSB LAX01FA023Accident · 2 fatalField investigationFinal reportMooney M-20J · Wheaton Springs, CAThe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in the in-flight collision with mountainous terrain.NTSB CHI00LA287Accident · No injuriesLimited investigationFinal reportCessna 172R · New Lenox, ILThe pilot's failure to maintain directional control during landing. Factors to the accident were the pipe that was struck, the crosswind, and the pilot's runway selection.NTSB DEN00LA139Accident · No injuriesLimited investigationFinal reportFudold Avid - Magnum · Walden, COThe pilot's inadvertent stall/mush during a go-around attempt. A contributing factor was the high density altitude weather condition.NTSB NYC00FA118Accident · 5 fatalField investigationFinal reportMooney M20J · Norton, VAThe pilot's improper weather evaluation, which resulted in a loss of aircraft control. Factors in this accident were icing conditions, and aircraft loading which exceed the airplane's weight and balance limitations.NTSB CHI00LA115Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIthe student pilot's failure to maintain directional control of the airplane during the landing. Factors associated with the accident were the misjudged landing flare, the student's lack of total experience, the runway lights, and the runway signs.NTSB ATL00FA024Accident · 2 fatalField investigationFinal reportMooney M20J · Odessa, FLThe pilot's failure to maintain a safe altitude and his failure to attain the proper touchdown point during landing. A factor was the utility pole.NTSB FTW00LA060Accident · No injuriesLimited investigationFinal reportCessna 172R · Angleton, TXThe pilot's failure to maintain control of the airplane during landing. A factor was the gust of wind.NTSB NYC00LA054Accident · No injuriesLimited investigationFinal reportMooney 20J · New Milford, CTFailure of 3 of the 4 connecting rods for an undetermined reason.NTSB DEN00LA017Accident · No injuriesLimited investigationFinal reportCessna 172R · Logan, UTThe pilot's improper flare and improper recovery from a bounced landing.NTSB LAX00LA002Accident · No injuriesLimited investigationFinal reportZdybel Glasair FT · Rio Linda, CAFuel starvation due to the owner/builder's improper installation of the fuel selector valve, and, his failure to placard the operating positions of the valve handle.NTSB NYC99LA225Accident · No injuriesLimited investigationFinal reportPiper PA-28-201RT · Toms River, NJThe pilot's failure to obtain proper clearance over an obstacle.NTSB NYC00WA172Accident · No injuriesForeign investigationLake LA-4-200 · Lake Puruvesi, FinlandNTSB MIA99LA216Accident · No injuriesLimited investigationFinal reportCessna 172R · Savannah, GAThe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing, resulting in the airplane running off the runway and colliding with a runway sign.NTSB CHI99LA280Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Gainesville, MOthe inadequate preflight planning/preparation by the pilot and all available runway exceeded by the pilot. The trees and power lines were contributing factors.NTSB CHI99LA283Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILthe pilot's misjudged landing flare and his inadequate recovery from the bounced landing.NTSB ATL99LA114Accident · No injuriesLimited investigationFinal reportMaule M-5-200 · St.Simons, GAThe inadequate installation of the magneto assembly by other maintenance personnel that in resulted the separation from the engine and the subsequent loss of engine power. A factor was the swampy terrain condition.NTSB MIA99LA178Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Charlotte, NCThe pilot misjudged the flare during the landing.NTSB MIA99LA165Accident · Serious injuriesLimited investigationFinal reportSchmidt Airshark II · Peachtree City, GAThe failure of the pilot to follow appropriate wake turbulence avoidance procedures, and wait an adequate amount of time prior to taking off behind a corporate jet.NTSB MIA99LA127Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Pensacola, FLThe pilot's inability to maintain directional control due to failure of the main landing gear, and partial electrical system failure for undetermined reasons.NTSB CHI99LA122Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Vienna, ILThe worn ignition points/cam follower assembly, and uneven landing terrain.NTSB DEN99LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Colorado Sprngs, COThe pilot's failure to maintain directional control of the aircraft during landing touchdown. A factor was the sign.NTSB CHI99LA071Accident · No injuriesLimited investigationFinal reportCessna 172R · Chesterfield, MOthe instructor pilot's failure to maintain aircraft control. Factors contributing to this accident were the snow covered grassy field area along the side of the runway and the pile of snow.NTSB NYC99LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-24R · Farmingdale, NYThe pilot's inadequate preflight examination of the airplane, which resulted in a power loss due to fuel contamination.NTSB CHI99LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Cahokia, ILthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the quartering tailwind and the ditch that the airplane contacted.NTSB CHI98LA316Accident · Minor injuriesLimited investigationFinal reportWakely DR-107 · Stanton, MNthe pilot's misjudging recovery from a bounced landing. Factors were the partial failure of the propeller and a crop field.NTSB MIA98LA207Accident · No injuriesLimited investigationFinal reportMooney M-20J · Alexander City, ALThe pilot's failure to maintain directional control of the airplane during landing rollout and attempted go-around, resulting in departure from the runway and collision with adjacent brush and trees.NTSB FTW98LA281Accident · Minor injuriesLimited investigationFinal reportRockwell Commander 112 · Las Vegas, NMThe pilot's improper preflight planning/preparation for a cross country flight resulting in fuel exhaustion and subsequent loss of engine power. Factors were, unsuitable terrain, lack of total aviation experience, and lack of total experience in make/model of…NTSB CHI98LA209Accident · 1 fatalLimited investigationFinal reportTillman Christen II · Howell, MIthe pilot not maintaining aircraft control during the go-around maneuver. A factor in this accident was the pilot s lack of recent experience in the accident airplane.NTSB FTW98LA207Accident · No injuriesLimited investigationFinal reportSchrack Starduster TOO · Hilltop Lakes, TXThe pilot's failure to obtain/maintain the proper descent rate which resulted in a hard landing.NTSB NYC98FA095Accident · 1 fatalField investigationFinal reportMooney M20J · Bridgeport, CTThe pilot's failure to maintain control of the airplane during night instrument meteorological conditions. Contributing factors were dark night conditions, low ceilings, rain, and his decision to divert to an airport under instrument meteorological conditions…NTSB NYC98LA072Accident · No injuriesLimited investigationFinal reportMooney M20J · Avoca, PAa bird strike.NTSB MIA98LA078Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Sarasota, FLinadequate clearance and fretting wear of the fitting/beam attachment to the angle/top beam, due to inadequate design, which resulted in fatigue and subsequent failure of the fitting/beam attachment ear.NTSB CHI98LA009Accident · No injuriesLimited investigationFinal reportBrown AIR Shark III · Green Bay, WIthe pilot's improper flare, which resulted in a hard landing, subsequent failure of the left main landing gear, and his inability to maintain directional control. Factors related to the accident were: the runway light, and soft terrain.NTSB LAX97FA272Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Hesperia, CAfailure of the pilot to see-and-avoid high voltage power lines, while coping with a lack of engine power during a go-around in a high density altitude condition. Factors relating to the accident were: high density altitude that resulted in a normal reduction…NTSB MIA97LA202Accident · 1 fatalLimited investigationFinal reportDFL Holdings Tango · Keystone, FLan in-flight loss of control for undetermined reasons.NTSB FTW97LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Whitewright, TXThe pilot's selection of an unsuitable area for takeoff. A factor was the dirt bank (terrace).NTSB SEA97LA122Accident · No injuriesLimited investigationFinal reportNoe SA-300 · Bountiful, UTthe pilot's failure to maintain directional control of the airplane. Related factors include: an area of standing water on a portion of the runway, and soft terrain just off the edge of the runway.NTSB CHI97LA142Accident · No injuriesLimited investigationFinal reportMooney M20F · Wheeling, ILbinding of the number four exhaust valve, which resulted in a partial power loss. A factor was the ravine.NTSB FTW97LA086Accident · Serious injuriesLimited investigationFinal reportMahan Starduster II · Atlanta, TXimproper maintenance by unknown person(s), which resulted in the failure of the throttle cable and a substantial loss of engine power. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB ANC97LA004Accident · Serious injuriesLimited investigationFinal reportBurns Burn Experimental · Sitka, AKthe pilot's failure to follow the checklist and secure the cockpit door/canopy.NTSB LAX96LA336Accident · No injuriesLimited investigationFinal reportPitts S-1S · Reno, NVThe pilot of N230MP inadequate visual lookout while landing on a runway occupied by another known aircraft. A factor in the accident was the procedure to allow simultaneous landings by aircraft on the same runway.NTSB FTW96LA357Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Lubbock, TXinadequate maintenance by maintenance personnel, which resulted in a total loss of engine power when the magneto disengaged from the engine. A related factor was the lack of suitable terrain for a forced landing.NTSB IAD96FA126Accident · 1 fatalField investigationFinal reportAerotek Pitts Special S-1S · Pittsburgh, PAThe pilot's utilization of airspeeds greater than the manufacturer recommended maneuvering airspeeds which exceed the design limits of the airplane and resulted in the subsequent failure of the wing spar.NTSB MIA96LA120Accident · No injuriesLimited investigationFinal reportMooney M20C · St Augustine, FLinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplane. A factor relating to the accident was: the lack of traffic pattern position reports from the Christian Eagle, due to the…