NTSB investigations: Lycoming 0-235 series
37 cases on aircraft whose registry engine model is Lycoming 0-235 series, 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 | 3 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2016 | 6 |
| 2017 | 2 |
| 2018 | 7 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 1 |
| 2025 | 2 |
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 ('41505')
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 ('41505')
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 ERA25LA334Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pottstown, PAThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in substantial damage to the engine mounts.NTSB CEN25LA134Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing. Contributing to the accident was the gusty crosswind and windshear during landing.NTSB CEN21LA311Accident · Minor injuriesClass 4 · LimitedFinal reportEslinger C W/Eslinger S M Cassutt · Pryor, OKThe pilot’s high flare and failure to execute a go-around which resulted in a hard landing and runway excursion.NTSB ERA20LA337Accident · No injuriesClass 4 · LimitedFinal reportLancair 235 · Chester, CTThe pilot's unstable approach, which resulted in a hard landing, and the separation of the left main landing gear.NTSB WPR20CA316Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Pacific City, ORA loss of directional control during landing for reasons that could not be determined due to lack of available evidence.NTSB ERA20CA225Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper landing flare, and failure to recover from the ensuing bounced landing, which resulted in a subsequent nose landing gear collapse.NTSB ERA20CA147Accident · No injuriesData collectionFinal reportZenair CH 2000 · Ocala, FLThe student pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the nosewheel collapsing.NTSB GAA20CA086Accident · No injuriesData collectionFinal reportCessna 152 · Sherman/Dennison, TXThe pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA19CA556Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe student pilot's improper landing flare, which resulted in a porpoised landing and a nose landing gear collapse.NTSB GAA19CA006Accident · No injuriesData collectionFinal reportZenair CH 2000 · Topeka, KSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent runway excursion.NTSB GAA18CA461Accident · No injuriesData collectionFinal reportCessna 152 · Oak Harbor, WAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA18CA427Accident · Minor injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot’s inadvertent encounter with thunderstorm conditions and her failure to maintain a proper landing flare in a crosswind, which resulted in a bounced landing.NTSB GAA18CA500Accident · No injuriesData collectionFinal reportCessna 152 · Sacramento, CAThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA18CA350Accident · No injuriesData collectionFinal reportCessna 152 · Denison, TXThe student pilot’s improper landing flare in crosswind conditions, which resulted in a hard, bounced landing.NTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.NTSB GAA18CA261Accident · Minor injuriesData collectionFinal reportZenair CH 2000 · Naples, FLThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB ERA17CA221Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA17CA173Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe student pilot’s loss of directional control.NTSB GAA16CA431Accident · No injuriesData collectionFinal reportCessna 152 · Hillsboro, ORThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the engine mount.NTSB GAA16CA407Accident · No injuriesData collectionFinal reportCessna 152 · Scappoose, ORThe student pilot's failure to maintain pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard landing/abnormal runway contact, a partial nose wheel collapse and substantial damage to the firewall.NTSB ERA16CA303Accident · No injuriesData collectionFinal reportCessna 152G · Augusta, METhe pilot's failure to compensate for the gusting wind conditions during a short-field landing and the designated pilot examiner's delayed remedial action, which resulted in the wing tip contacting the runway during the go-around.NTSB GAA16CA209Accident · No injuriesData collectionFinal reportCessna 152 · Palo Alto, CAThe student pilot's decision to takeoff in wind conditions that exceeded his certificated flight instructor's maximum wind endorsement, and the student pilot's failure to maintain pitch control during the touchdown, resulting in abnormal runway contact, and…NTSB GAA16CA211Accident · No injuriesData collectionFinal reportCessna 152 · Hayward, CAThe student pilot's high descent rate during the landing flare, which resulted in a hard landing, nose landing gear collapse, and runway excursion during an aborted landing.NTSB GAA16CA116Accident · No injuriesData collectionFinal reportCessna 152 · Durant, OKThe pilot's failure to maintain pitch control during the landing, resulting in a porpoise.NTSB ANC14CA072Accident · No injuriesData collectionFinal reportPiper PA 12 · Talkeetna, AKThe pilot's inadequate recovery from a bounced landing, resulting in a runway excursion and collision with trees.NTSB ERA13LA379Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe use of an improper nose landing gear through bolt, which decreased the overall strength of the gear and resulted in overload failure during a hard landing. Contributing to the accident was the student pilot's inadequate landing flare, which resulted in…NTSB WPR13CA166Accident · No injuriesData collectionFinal reportBellanca 7ECA · Sonoma, CAThe student pilot’s failure to maintain directional control during the touchdown and landing roll.NTSB CEN12LA386Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Walnut Ridge, ARThe pilot's failure to maintain aircraft control after encountering a whirlwind or dust-devil during the landing flare.NTSB WPR11LA443Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAThe flight instructor’s delayed remedial action and failure to maintain airplane control while performing a simulated aborted landing.NTSB CEN11CA677Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Monte Vista, COThe student pilot's loss of control while landing, which resulted in a ground loop.NTSB CEN11CA278Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot's improper recovery from a bounced landing.NTSB ERA10CA380Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe student pilot’s improper recovery from a bounced landing.NTSB WPR10CA263Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper recovery from a bounced landing.NTSB ERA10CA249Accident · No injuriesData collectionFinal reportCessna 152 · Cross City, FLThe pilot's inadequate compensation for the crosswind condition resulting in the loss of directional control while landing.NTSB WPR09CA430Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear strut.NTSB ERA09CA373Accident · No injuriesData collectionFinal reportCessna 152 · Mt. Pleasant, SCThe pilot's improper recovery from a bounced landing.NTSB ERA09CA181Accident · No injuriesData collectionFinal reportCessna 152 · Crystal River, FLThe student pilot's improper recovery from a bounced landing.