NTSB investigations: Lycoming 0-235 series, FL
16 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2005 | 2 |
| 2007 | 1 |
Where
Latest 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\" = 250))
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" = 250))
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 NYC08CA047Accident · No injuriesData collectionFinal reportCessna 152 · Venice, FLThe student pilot's improper recovery from a bounced landing.NTSB MIA06LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Opa-Locka, FLThe failure of the pilot-in-command to maintain airspeed following a reported loss of engine power, resulting in a stall/mush, uncontrolled descent, and in-flight collision with terrain. Factors in the accident were the pilot's intentional operation of the…NTSB MIA05FA152Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Freeport, FLThe failure of the pilot to maintain airspeed resulting in inadvertent stall, uncontrolled descent, and in-flight collision with terrain.NTSB ATL02LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Clewiston, FLThe student pilot's inadequate compensation for wind, and failure to maintain directional control. A contributing factor was a crosswind.NTSB MIA00LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLthe flight instructor's inadequate supervision of the student pilot by allowing the student to fly in gusty wind conditions with excessive crosswinds that resulting in the student pilot not maintaining control and nosing the aircraft over.NTSB MIA95LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLThe failure of the pilot to maintain directional control during a go-around from a bounced landing.NTSB MIA95LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLThe failure of the student pilot to maintain directional control during landing. A contributing factor was the delayed remedial action to attempt a go-around.NTSB MIA94FA114Accident · 1 fatalField investigationFinal reportPiper PA-12 · Merritt Island, FLThe loss of elevator control due to jamming by the tow rope which prevented the pilot from being able to control the airplane.NTSB MIA90LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Zephyrhills, FLThe student pilot not obtaining the current wind information which resulted in selecting the wrong runway for landing; improper recovery from a bounced landing. Contributing factor(s) was: the student pilot's lack of experience and the tailwind conditions.NTSB MIA89LA250Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fernandina Bch, FLThe private pilot's failure to maintain airspeed on final approach, which resulted in a stall/mush. The turbulence was a related factor.NTSB MIA88LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco Island, FLWhile on an instructional flt prior to touchdown on rwy 17, the flt was advised that the winds were from 110 degrees at 15 KTS with gusts to 20. The CFI stated that the aircraft was slow on final apch. With 20 degrees of flaps lowered, the acft was blown off…NTSB MIA87FA213Accident · Serious injuriesField investigationFinal reportCessna 152 · Hollywood, FLWhile in the traffic pattern on an instructional flt, the instructor (CFI) elected to demonstrate a short field lndg, followed by a short field takeoff. The student rprtd that after lift-off on the short field takeoff, the CFI flew the acft to a nose hi…NTSB MIA87LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Venice, FLFull flap x-wind take off & landings were being conducted on rwy 13 with the winds at 210 to 220 degs at 10 KTS, or a right x-wind component of 80 to 90 degs. The student plt permitted the acft to get too slow while about 10 ft above the ground. A high sink…NTSB MIA86FA252Accident · 2 fatalField investigationFinal reportCessna 152II · Clewiston, FLPurpose of the flt was to spot stray cattle. The acft made a low pass after chasing a cow. According to witnesses, the acft stalled and descended to ground impact during the pull-up maneuver following the low pass.NTSB MIA84FA240Accident · 1 fatalField investigationFinal reportCessna 152 · Pembroke Pines, FLOne min and 20 seconds after being cleared for takeoff, the plt transmitted on tower freq that he was 'coming in for a landing.' The acft was observed to bank to the left, enter a steep descent from 200 to 300 ft AGL & crash. An intense post-crash fire…NTSB MIA84FA044Accident · 1 fatalField investigationFinal reportCessna 152 · Venice, FLThis was the first flt for the prospective student plt. He stated that during the second trafic pattern over the gulf, the acft appeared to hit a gust of wind, pitched up, & entered a spin. Winds were gusting 27 KTS, & severe wx was forecast & arrived later…