NTSB investigations: Lycoming 0-235 series, FL
34 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 2 |
|---|---|
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1991 | 4 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 1 |
| 2005 | 2 |
| 2006 | 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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
AND 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 ANC06CA091Accident · No injuriesData collectionFinal reportDahlstrom - Piel Emeraude CP-30 · Venice, FLThe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident were a crosswind, and an inadvertent swerve.NTSB MIA06CA047Accident · No injuriesData collectionFinal reportCessna 152 · Lantana, FLThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in the nosegear collapsing, the airplane veering off the runway, and nosing over.NTSB MIA06CA025Accident · No injuriesData collectionFinal reportPiper PA-12 · St. Petersburg, FLThe pilot's failure to maintain directional control during the landing roll resulting in substantial damage during a ground loop.NTSB MIA05CA128Accident · No injuriesData collectionFinal reportCessna 152 · St. Augustine, FLThe failure of the student pilot to maintain directional control during the landing roll resulting in the on-ground encounter with wet grass and subsequent nose over.NTSB MIA03CA174Accident · No injuriesData collectionFinal reportCessna 152 · Ocala, FLthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway, and impacting with a ditch.NTSB MIA02LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe student pilot's failure to maintain control of the airplane during the takeoff roll/run which resulted in the airplane departing the runway and into a ditch where it nosed over incurring substantial damage.NTSB MIA02LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Hialeah, FLThe failure of the pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch and subsequent nose over of the airplane.NTSB ATL02LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Immokalee, FLThe student pilot's failure to maintain directional control while attempting a touch and go landing resulted in an on-ground collision with a ditch. A factor in this accident was the student pilot's lack of experience.NTSB MIA01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student's failure to maintain control of the aircraft during landing due to his improper landing flare height and improper recovery from a bounced landing, resulting in a nose landing gear collapse, and excursion off the runway.NTSB MIA01LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe student pilot's failure to maintain directional control on landing rollout with a crosswind. This resulted in the airplane departing the runway, colliding with a berm/ridge, becoming airborne, and colliding with the terrain in a nose down attitude.NTSB MIA99LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe student pilot's failure to maintain directional control during the landing roll. A related factor was the pilot's diverted attention.NTSB ATL98LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLthe student pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. The gusty crosswind condition was a related factor.NTSB ATL96LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Myers, FLthe student pilot's improper flare to touchdown.NTSB ATL95LA146Accident · No injuriesLimited investigationFinal reportCessna 152A · Sanford, FLThe pilot's failure to maintain directional control during the takeoff portion of a touch and go landing.NTSB MIA95LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · New Port Richey, FLThe pilot landed on the wrong runway. The tailwind contributed to the loss of directional control.NTSB MIA95LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLThe student pilots failure to follow the checklist and assure the door was closed prior to takeoff. Contributing to the accident was the student's diverted attention during the takeoff roll.NTSB MIA94LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Arcadia, FLThe pilot's inadequate compensation for wind conditions. The gusty, crosswind was a factor.NTSB MIA94LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe inadvertent encounter with a water puddle on the runway during takeoff roll which resulted in the pilot losing directional control and running off the side of the runway.NTSB MIA92LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe pilot-in-command's improper use of the rudder controls and brakes. A contributing factor was his lack of total experience.NTSB MIA91LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 7EA · Venice, FLThe pilot's loss of control of the airplane on takeoff ground roll due to his lack of experience and flight time in this type of airplane. A contributing factor is an on-ground encounter with a crosswind.NTSB MIA91LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooksville, FLFailure of the student pilot to maintain directional control of the airplane during the landing roll. Contributing to the accident was his lack of total experience.NTSB MIA91LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · La Belle, FLFailure of the student pilot to maintain directional control during the landing roll. Contributing to the accident was the fact that the pilot diverted his attention when he pulled the parking brake handle to apply the brakes.NTSB MIA90LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Cocoa, FLFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground swerve. Factors related to the accident were the crosswind condition and ditch.NTSB MIA88FA191Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe 25 yr old student plt was practicing take-offs & ldgs on rwy 11L in preparation for his pvt plt flt test. When he departed, about 1.9 hrs prior to the accident, the winds were 090 degs at 13 knts. At the time of the accident the winds had increased to 18…NTSB MIA88LA130Accident · No injuriesLimited investigationFinal reportChampion 7ECA · La Belle, FLDuring the ground run to take off, the unidentified pilot lost control of the acft. It departed the rwy, collided with a fence, nosed over, then came to rest. The identity of the plt has not been determined.NTSB MIA87LA183Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Miramar, FLThe student plt was conducting solo touch & go ldgs when directional control of the acft was lost & the acft left the rwy & collided with a rwy designator sign during the ldg phase.NTSB MIA87LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLThe plt stated that upon landing on runway 22, as he added power to takeoff again the acft started to veer to the left and no matter how much right rudder he used, the acft still veered left and went off the side of the runway into the grass, spun around and…NTSB MIA87LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe acft skidded off the end of the wet grassy runway after touching down about midway down the rwy. The plt stated that in the future, all available rwy should be used. The plt received his private certificate just prior to the accident.NTSB MIA86LA178Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe student plt stated that he was attempting a practice soft-field takeoff from rwy 18. Just prior to rotation the main gear contacted a bump in the airstrip and the acft drifted to the left. The acft continued left where it struck trees alongside the rwy.…NTSB MIA85LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLThe student pilot was practicing touch-&-go landings on rwy 11. Due to a wind shift, the active rwy was changed to rwy 4. The student stated that during his 1st pattern for a landing on rwy 4, his apch was high & fast. As the acft touched down, he lost…NTSB MIA85LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Daytona Beach, FLThe plt stated that during a landing at Daytona Beach, the acft encountered wind shear, he lost directional control & the acft veered off the left side of the rwy into the grass. During the occurrence, the prop struck the ground & the right wing tip was…NTSB MIA85LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Wesley Chapel, FLThe student plt flying N94560 was making her 1st solo touch and go landing when control of the acft was lost. Upon touchdown, N94560 veered left, departed the rwy and collided with N3854D which was being taxied on the grass aprx 20 ft from the rwy.NTSB MIA82DA117Accident · No injuriesFinal reportPiper PA-38-112 · Gainesville, FLThe student pilot stated that on his third landing, the crosswind was more noticeable. During the landing roll, he lost directional control while he was applying brakes. The aircraft went off the runway, collided with a ditch, and was substantially damaged.NTSB MIA82DA076Accident · No injuriesFinal reportCessna 152 · Brooksville, FLThe student pilot was on a solo cross-country flight. While landing at an en route airport, he encountered a gusty, right quartering, headwind. During touchdown, the plane bounced and the pilot applied power. However, he was unable to prevent the plane from…