NTSB investigations: Lycoming IO-360-L2A
404 cases on aircraft whose registry engine model is Lycoming IO-360-L2A. 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 ('41597'))
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 ('41597'))
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 WPR09LA098Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Oceanside, CAA defective alternator wire splice that resulted in an intermittent electrical system malfunction and erroneous fuel gauge readings, and, a loss of engine power for an undetermined reason.NTSB ERA09CA119Accident · No injuriesData collectionFinal reportCessna 172SP · Lancaster, NYThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was the student pilot's lack of solo flight experience and the snow bank located off the left side of the runway.NTSB ERA09CA110Accident · No injuriesData collectionFinal reportCessna 172R · Morristown, NJThe flight instructor's failure to execute a missed approach when insufficient runway remained for landing. Contributing to the accident were the low ceiling and visibility conditions.NTSB ERA09LA064Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Groton, CTThe student pilot’s failure to maintain a proper descent profile to avoid trees during the night visual approach and the flight instructor’s inadequate oversight.NTSB ERA09CA063Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe student pilot's inadequate compensation for winds during landing.NTSB ERA09CA041Accident · Serious injuriesData collectionFinal reportCessna 172 · Frederick, MDThe passenger’s failure to avoid the rotating propeller after exiting the airplane. Contributing to the accident was the pilot’s failure to include deplaning procedures as part of the passenger safety briefing.NTSB ERA09CA035Accident · No injuriesData collectionFinal reportCessna 172 · Asheville, NCThe student pilot’s improper recovery from a bounced landing.NTSB WPR09CA273Accident · No injuriesData collectionFinal reportCessna 172S · Compton, CAThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB CEN09CA002Accident · No injuriesData collectionFinal reportCessna 172 · Alton, ILThe student pilot's failure to maintain directional control during landing. A contributing factor was the presence of the sign struck during the runway excursion.NTSB LAX08FA301Accident · Serious injuriesField investigationFinal reportCessna 172S · Fullerton, CAThe pilot's failure to follow the takeoff checklist and verify the proper flap setting before takeoff.NTSB NYC08CA282Accident · No injuriesData collectionFinal reportCessna 172 · Charlottesville, VAThe pilot's improper flare while landing. Contributing to the accident was the gusty wind condition.NTSB MIA08CA165Accident · No injuriesData collectionFinal reportCessna 172S · Monroeville, ALThe pilot's inadequate compensation for winds during landing. Contributing to the accident was a wind gust.NTSB LAX08FA261Accident · 1 fatalField investigationFinal reportCessna 172S · Incline Village, NVThe pilot's decision to initiate a flight for which he was neither approved nor qualified and his failure to maintain terrain clearance during the flight. Contributing to the accident were the dark night, the mountainous terrain, and the pilot's medical…NTSB LAX08LA283Accident · No injuriesLimited investigationFinal reportCessna 172 · Honolulu, HIThe flight's encounter with the jet wash from a parked commercial airplane while taxiing for takeoff.NTSB OPS08IA010Incident · No injuriesIncident investigationFinal reportCessna 172 · Teterboro, NJProbable Cause The probable cause of this incident was the TEB ground controller's failure to direct N316AS to hold short of runway 24 when issuing taxi instructions to the aircraft as required FAA Order 7110.65, paragraph 3-7-2 (2a); Taxi and Ground Movement…NTSB LAX08LA191Accident · 2 fatalLimited investigationFinal reportCessna 172S · Oceanside, CAFailure of the pilot to regain airplane control during an intentional stall/spin maneuver.NTSB MIA08CA124Accident · No injuriesData collectionFinal reportCessna 172S · Orangeburg, SCThe pilot's failure to obtain the proper touchdown point on landing.NTSB NYC08CA214Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe student pilot's improper flare.NTSB LAX08LA179Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Beaver, UTThe pilot's failure to attain and maintain an adequate airspeed during the initial climb as a result of his inadequate preflight planning and improper use of the mixture control. Contributing to the accident were the tailwind and high density altitude.NTSB NYC08CA187Accident · No injuriesData collectionFinal reportCessna 172SP · Homestead, FLThe student pilot's improper flare. Contributing to the accident was the flight instructor's inadequate remedial action.NTSB MIA08CA092Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe student pilot's improper recovery from a bounced landing.NTSB LAX08CA102Accident · No injuriesData collectionFinal reportCessna 172S · Gualala, CAThe pilot's decision not to use all of the available runway, his premature rotation and failure to obtain and maintain an adequate airspeed to continue the takeoff that resulted in a stall/mush, an aborted takeoff, a runway overrun, and a collision with…NTSB LAX08CA124Accident · No injuriesData collectionFinal reportCessna 172S · San Luis Obispo, CAThe pilot's inadequate landing flare, resulting in a hard landing. Contributing to the accident was the gusty wind condition.NTSB CHI08CA091Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe pilot's misjudgment of the landing flare and her inadequate recovery from the bounced landing.NTSB MIA08CA056Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe student pilot's inadequate recovery from a bounced landing.NTSB MIA08CA068Accident · No injuriesData collectionFinal reportCessna 172S · Westiminster, MDThe student pilot's improper flare.NTSB SEA08CA052Accident · No injuriesData collectionFinal reportCessna 172S · Fullerton, CAThe pilot's failure to maintain clearance while taxiing. Contributing to the accident was the pilot's diverted attention.NTSB LAX08FA023Accident · 1 fatalField investigationFinal reportCessna 172S · Palm Springs, CAThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb, and his impairment from alcohol.NTSB CHI08CA029Accident · No injuriesData collectionFinal reportCessna 172R · Brookings, SDThe student pilot's failure to maintain directional control during takeoff roll. Contributing to the accident was the student pilot's lack of solo flight experience and the runway sign.NTSB CHI07CA308Accident · No injuriesData collectionFinal reportCessna 172 SP · Heath, OHThe improper flare and inadequate recovery from a bounced landing by the student pilot. A factor was the student pilot's lack of experience.NTSB DFW07CA210Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's failure to compensate for existing conditions while landing. A contributing factor was the prevailing crosswind.NTSB DFW07LA207Accident · No injuriesLimited investigationFinal reportCessna 172S · Tyler, TXThe pilot's failure to maintain control of the airplane during takeoff. A contributing factor was the encounter with wake turbulence.NTSB SEA07CA243Accident · No injuriesData collectionFinal reportCessna 172S · Bakersfield, CAThe student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with a taxiway sign.NTSB DEN07CA154Accident · No injuriesData collectionFinal reportCessna 172R · Fort Collins, COThe student pilot's improper flare and recovery from a bounced landing.NTSB SEA07CA207Accident · No injuriesData collectionFinal reportCessna 172S · Pahokee, FLThe student pilot's improper flare during the landing which resulted in a hard landing. The student pilot's failure to relinquish control of the aircraft, the flight instructors inadequate supervision and not being able to recover control of the aircraft from…NTSB ATL07CA105Accident · No injuriesData collectionFinal reportCessna 172S · Beverly, MAThe pilot's improper flare, which resulted in a hard landing and nose gear collapse. A contributing factor was the wind gust.NTSB LAX07CA202Accident · No injuriesData collectionFinal reportCessna 172S · Spanish Fork, UTThe pilot's misjudged landing flare resulting in a porpoise and hard touchdown.NTSB LAX07CA199Accident · No injuriesData collectionFinal reportCessna 172S · Santa Barbara, CAthe pilot's failure to maintain directional control.NTSB LAX07CA193Accident · No injuriesData collectionFinal reportCessna 172S · Jacksonville, FLthe student pilot's failure to maintain directional control.NTSB ATL07CA093Accident · No injuriesData collectionFinal reportCessna 172S · Batavia, NYThe student pilot's failure to flare the airplane during landing resulting in a hard landing.NTSB NYC07CA131Accident · No injuriesData collectionFinal reportCessna 172S · Raleigh-Durham, NCThe pilot's improper recovery from a bounced landing.NTSB LAX07CA185Accident · Minor injuriesData collectionFinal reportCessna 172S · Wendover, UTThe pilot's failure to maintain directional control during the landing roll.NTSB NYC07CA116Accident · No injuriesData collectionFinal reportCessna 172S · Asheville, NCThe pilot's improper landing flare which resulted in a hard landing. A factor in the accident was the visual illusion experienced by the pilot from landing on a long, wide runway.NTSB LAX07CA171Accident · No injuriesData collectionFinal reportCessna 172S · Payson, AZThe pilot's inadequate in-flight planning/decision, excessive airspeed on final approach, and failure to execute a go-around resulting in a misjudged flare and hard landing.NTSB CHI07LA164Accident · No injuriesLimited investigationFinal reportCessna 172R · Chesterfield, MOInadequate flare during landing. The induced oscillation, not performing a go-around, the pilot's lack of experience and the failure to perform remedial action were factors.NTSB SEA07CA120Accident · No injuriesData collectionFinal reportCessna 172R · Livermore, CAThe pilot's improper flare during landing.NTSB LAX07CA101Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZthe student pilot's failure to maintain directional during the landing rollout and the certified flight instructor's inadequate supervision.NTSB MIA07CA045Accident · No injuriesData collectionFinal reportCessna 172S · Sanford, FLThe inadvertent inflight collision with a bird resulting in damage to the airplane and the pilot having limited control capability.NTSB MIA07CA019Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna, FLThe student pilot's improper recovery from a bounced landing.NTSB DFW07FA019Accident · 2 fatalField investigationFinal reportCessna 172S · Hominy, OKThe pilot's continued cruise flight into adverse weather conditions, and his failure to maintain clearance from terrain. Contributing factors were the dark night conditions, and the low ceilings.