NTSB investigations: Lycoming 0-235 series, ID
52 cases on aircraft whose registry engine model is Lycoming 0-235 series. 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
| 1964 | 2 |
|---|---|
| 1966 | 1 |
| 1968 | 3 |
| 1970 | 2 |
| 1971 | 5 |
| 1972 | 1 |
| 1975 | 2 |
| 1977 | 2 |
| 1979 | 3 |
| 1980 | 3 |
| 1982 | 2 |
| 1984 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 4 |
| 2007 | 1 |
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 2 |
| 2021 | 1 |
| 2023 | 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.\"eventStateOrRegion\" = 'ID' 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'))
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" = 'ID' 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'))
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 WPR26LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Dixie, IDThe pilot's delayed decision to initiate a go-around and subsequent failure to maintain clearance from rising terrain.NTSB WPR24LA027Accident · No injuriesClass 4 · LimitedFinal reportKitfox S5 · Ririe, IDThe pilot’s inadvertent excessive use of brakes which resulted in a nose-over.NTSB WPR21LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Coeur d' Alene, IDThe student pilot’s failure to maintain directional control during the landing roll, and the flight instructors delayed remedial action which resulted in a runway excursion and collision with terrain.NTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.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 GAA15CA184Accident · No injuriesData collectionFinal reportPiper PA 12 · Buhl, IDThe student/instructed pilot lost directional control during the landing roll, resulting in a runway excursion, and ground loop.NTSB WPR13CA323Accident · Minor injuriesData collectionFinal reportCessna 152 · Kamiah, IDThe student pilot’s failure to maintain aircraft control during the initial climb, which resulted in a collision with a powerline.NTSB WPR12CA401Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Lewiston, IDThe pilot’s inadequate postmaintenance and preflight inspections, which resulted in the separation of the left main wheel after takeoff. Contributing to the accident was the improperly secured left main wheel spindle nut.NTSB WPR11CA262Accident · No injuriesData collectionFinal reportCessna 152 · Idaho Falls, IDThe pilot's inadequate landing flare and improper bounced landing recovery.NTSB WPR09CA392Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Kamiah, IDThe failure of the student pilot to maintain directional control during landing.NTSB WPR09CA274Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Grangeville, IDThe pilot's failure to maintain clearance from an obstacle during taxi.NTSB SEA07CA065Accident · No injuriesData collectionFinal reportPiper PA-12 · Lewiston, IDthe inadvertent use of the rudder by the passenger, which resulted in an inadvertent ground loop.NTSB SEA05FA181Accident · 2 fatalField investigationFinal reportPiper PA-14 · Challis, IDThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. A contributing factor was the pilot's diverted attention while spotting/locating Rocky Mountain Bighorn sheep.NTSB SEA05CA156Accident · No injuriesData collectionFinal reportPiper PA-20-115 · Weiser, IDThe pilot's failure to maintain directional control during the landing roll, and his application of excessive braking as the aircraft started to depart the side of the runway.NTSB SEA05CA150Accident · No injuriesData collectionFinal reportAmerican Champion 7ECA · Hailey, IDThe pilot's inadequate recovery from a bounced landing and his failure to maintain directional control during the landing roll. Factors include a crosswind, and soft terrain just off the side of the runway surface.NTSB SEA05LA134Accident · 1 fatalLimited investigationFinal reportJones Long EZ · Marsing, IDThe pilot's failure to maintain airspeed during landing, and his subsequent delay in attempting a recovery from a bounced landing. A contributing factor was the taxiway berm.NTSB SEA04LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jerome, IDThe pilot's failure to refuel the airplane resulting in fuel exhaustion and the loss of power during descent for landing. Factors contributing to the accident were the soft terrain and the forced landing site.NTSB SEA03LA017Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Rigby, IDThe pilot's selection of a fuel tank with inadequate fuel resulting in fuel starvation and a complete power loss during the initial climb. A contributing factor was the ditch which the aircraft impacted during the forced landing resulting in the collapse of…NTSB SEA99FA176Accident · 2 fatalField investigationFinal reportCessna 152 · Coeur d'Alene, IDThe flight crew's failure to maintain adequate airspeed, resulting in a stall and uncontrolled collision with terrain. A factor was mountainous/hilly terrain.NTSB SEA98LA043Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Dubois, IDThe student pilot's misjudgment of altitude/clearance and overloading of the nose gear. A contributing factor was the snow-covered turf runway.NTSB SEA93LA077Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Burley, IDLanding on the wrong runway and an improper touchdown. Lack of total experience in type of operation was a factor.NTSB SEA91LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Blackfoot, IDThe pilot did not adequately recover from a bounced landing. Factors were improper airspeed and lack of total expereince.NTSB SEA87LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Sun Valley, IDAfter landing touchdown, plt encountered swirling winds. Acft drifted left and into airport boundary (cyclone-type) fence.NTSB SEA86LA222Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sandpoint, IDThe plt lost directional control of the acft for unknown reasons during the landing roll and a ground loop resulted.NTSB SEA85LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Aberdeen, IDAccording to the solo student plt, while accelerating through 40 KTS during takeoff the acft began to drift to the left. The acft departed the rwy, rolled through two fences and nosed over in the soft ground.NTSB SEA84LA073Accident · No injuriesLimited investigationFinal reportCessna 152II · Preston, IDThe solo student plt was making a takeoff after a touch-and-go landing. The acft swerved to the left, collided with a snowbank, and nosed over.NTSB SEA83LA001Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Salmon, IDThe plt reported that the strip had about 1,500 ft of usable length, the remaining 3,050 ft consisted of unpacked snow &slush. The usable width of the first 1,500 ft was reported as 8-12 ft. at the time of takeoff the first 1,500 ft was covered with hard…NTSB SEA82DA088Accident · No injuriesFinal reportPiper PA-38-112 · Oakley, IDAt about 1045 MDT, the pilot departed ogden, ut on a solo, cross-country flight to jackpot, NV, pocatello, ID and return. While en route to jackpot, he encountered turbulence and decreasing visibility over a mountainous area and descended from 8500 ft MSL to…NTSB SEA81FA011Accident · 2 fatalClosedPiper PA-12 · Rexburg, IDNTSB SEA80FYP37Accident · Serious injuriesClosedGrum-Amer AA-1B · Coeur D'Alene, IDNTSB SEA80DYP12Accident · No injuriesClosedPiper PA-38 · Sandpoint, IDNTSB SEA80DYA02Accident · No injuriesClosedAmer Avco AA1-C · Rexburg, IDNTSB SEA79FA046Accident · 1 fatalClosedPiper PA-38 · Bellevue, IDNTSB SEA79DYA08Accident · No injuriesClosedAmer Avco AA1-C · Rexburg, IDNTSB SEA77DYA23Accident · No injuriesClosedPiper PA-12 · Marsing, IDNTSB SEA77DYP18Accident · No injuriesClosedBellanca 7ECA · Orofino, IDNTSB SEA7KDYA40Accident · No injuriesClosedPiper PA-12 · Homedale, IDNTSB SEA75DYA38Accident · No injuriesClosedPiper PA-22 · Gooding, IDNTSB SEA73DYA08Accident · No injuriesClosedAeronca 11AC · Rupert, IDNTSB SEA72FYA17Accident · No injuriesClosedAmer Avco AA-1A · Emmett, IDNTSB SEA72DYA15Accident · No injuriesClosedChampion 7GCAA · Idaho Falls, IDNTSB SEA72DYA02Accident · No injuriesClosedPiper PA-12 · Wendell, IDNTSB SEA71DYA39Accident · No injuriesClosedPiper PA-11 · Newdale, IDNTSB SEA71DXM29Accident · No injuriesClosedCessna 140 · Atomic City, IDNTSB SEA71DWG35Accident · No injuriesClosedPiper PA-22 · Hayden Lake, IDNTSB SEA71FXM09Accident · Serious injuriesClosedPiper PA-12 · Rigby, IDNTSB SEA69D0088Accident · No injuriesClosedPiper PA-16 · Sandpoint, IDNTSB SEA68D0309Accident · No injuriesClosedPiper PA-12 · Grangeville, IDNTSB SEA68D0255Accident · No injuriesClosedPiper PA-12 · Driggs, IDNTSB SEA66D0279Accident · No injuriesClosedPiper PA-22 · Boise, ID