NTSB investigations: Lycoming IO-360-L2A
34 cases on aircraft whose registry engine model is Lycoming IO-360-L2A, where the defining event was Abnormal runway contact. 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 per year
| 2009 | 3 |
|---|---|
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 7 |
| 2017 | 5 |
| 2018 | 4 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 1 |
Where
Open the mapLatest cases
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '090'))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '090'))
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 CEN26LA133Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Denver, COThe solo student pilot's improper landing flare and subsequent improper recovery from a bounced landing which resulted in substantial damage to the airplane.NTSB WPR25LA105Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Cottonwood, AZThe pilot undergoing instructions’ loss of aircraft control during landing, and the flight instructor’s failure to promptly intervene.NTSB CEN24LA379Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Janesville, WIThe student pilot’s improper flare and the flight instructor’s delayed remedial action that resulted in a hard, bounced landing.NTSB ERA24LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Elizabeth City, NCThe pilot’s improper flare and subsequent improper recovery from a bounced landing.NTSB ERA23LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Sanford, FLThe pilot's unstable approach, which resulted in a hard landing and impact with a runway threshold light. Also causal was the flight instructor’s failure to take remedial action to prevent the hard landing.NTSB WPR22LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · San Carlos, CAThe pilot’s improper landing flare which resulted in a bounced landing.NTSB ERA22LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Palm Coast, FLThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing, resulting in a hard landing and substantial damage to the lower fuselage and firewall.NTSB GAA18CA340Accident · No injuriesData collectionFinal reportCessna 172 · Hillsboro, TXThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent porpoise.NTSB GAA18CA294Accident · No injuriesData collectionFinal reportCessna 172 · Palo Alto, CAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA163Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe pilot’s improper landing flare, which resulted in substantial damage.NTSB GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.NTSB GAA18CA085Accident · No injuriesData collectionFinal reportCessna 172 · Park Rapids, MNThe student pilot’s improper landing flare, which resulted in the propeller striking the ground.NTSB GAA18CA046Accident · No injuriesData collectionFinal reportTextron 172 · Columbus, OHThe student pilot’s improper landing flare, which resulted in a porpoise.NTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA17CA470Accident · No injuriesData collectionFinal reportCessna 172 · Carlsbad, CAThe student pilot’s improper landing flare in gusting wind conditions.NTSB GAA17CA300Accident · No injuriesData collectionFinal reportCessna 172 · Clarksville, TNThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard, porpoised landing.NTSB GAA17CA104Accident · No injuriesData collectionFinal reportCessna 172 · Palm Coast, FLThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.NTSB GAA16CA421Accident · No injuriesData collectionFinal reportCessna 172 · Oak Island, NCThe pilot's failure to maintain pitch control during the landing flare, which resulted in a hard landing and substantial damage to the firewall.NTSB GAA16CA268Accident · No injuriesData collectionFinal reportCessna 172 · Newport News, VAThe student pilot's incorrect pitch control during the landing flare, which resulted in abnormal runway contact and a substantially damaged firewall.NTSB GAA16CA219Accident · No injuriesData collectionFinal reportCessna 172 · Mesa, AZThe student pilot's failure to maintain pitch control during the landing flare, which resulted in an abnormal runway contact, porpoise, nose gear collapse, runway excursion, and impact with terrain.NTSB GAA16CA188Accident · No injuriesData collectionFinal reportCessna 172 · Payson, AZThe student pilot's failure to maintain pitch control during the landing flare, resulting in the subsequent porpoise during landing and substantial damage to the firewall.NTSB GAA16CA187Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe failure of the student pilot to maintain pitch control while landing, which resulted in a hard landing, loss of directional control, and runway excursion.NTSB GAA16CA114Accident · No injuriesData collectionFinal reportCessna 172 · Merritt Island, FLThe student pilot's improper flare which resulted in a porpoise, runway excursion, and nose over.NTSB GAA16CA048Accident · No injuriesData collectionFinal reportCessna 172 · Mesa, AZThe pilot's failure to maintain pitch control during landing, resulting in a porpoise, and firewall damage.NTSB GAA15CA026Accident · No injuriesData collectionFinal reportCessna 172S · Vernal, UTThe student pilot's failure to maintain attitude control during landing flare.NTSB WPR15CA028Accident · No injuriesData collectionFinal reportCessna 172 - S · Hawthorne, CAThe pilot's improper flare which resulted in a loss of aircraft control and subsequent hard landing.NTSB WPR14CA351Accident · No injuriesData collectionFinal reportCessna 172S · Santa Ynez, CAThe student pilot's inadequate flare and loss of aircraft control during landing, which resulted in multiple bounces.NTSB ERA14CA078Accident · No injuriesData collectionFinal reportCessna 172S · Miami, FLThe pilot's improper flare during a gusty, crosswind landing.NTSB ERA13CA395Accident · No injuriesData collectionFinal reportCessna 172S · Fort Lauderdale, FLThe student pilot’s failure to apply power to go-around following a bounced landing resulting in abnormal runway contact and collapse of the nose landing gear.NTSB ERA12CA496Accident · Minor injuriesData collectionFinal reportCessna 172S · Culpeper, VAThe pilot’s failure to maintain directional control during an attempted takeoff.NTSB ERA10CA512Accident · No injuriesData collectionFinal reportCessna 172R · Hampton, VAThe student pilot's inadequate landing flare and improper recovery from a bounced landing. Contributing to the accident was the student’s decision to land with a tailwind.NTSB CEN09LA579Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Park Rapids, MNThe pilot's failure to maintain a proper climb rate during a night takeoff.NTSB CEN09LA586Accident · No injuriesLimited investigationFinal reportCessna 172S · Duluth, MNThe pilot's failure to maintain aircraft control during landing, resulting in a hard landing and a propeller strike with the ground.NTSB CEN09CA495Accident · No injuriesData collectionFinal reportCessna 172S · New Braunfels, TXThe student pilot's improper flare resulting in a bounced landing.