NTSB investigations: Lycoming 0-235 series, 1992
68 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 | 137 |
|---|---|
| 1965 | 122 |
| 1966 | 98 |
| 1967 | 92 |
| 1968 | 78 |
| 1969 | 54 |
| 1970 | 74 |
| 1971 | 82 |
| 1972 | 73 |
| 1973 | 68 |
| 1974 | 68 |
| 1975 | 69 |
| 1976 | 64 |
| 1977 | 86 |
| 1978 | 152 |
| 1979 | 167 |
| 1980 | 153 |
| 1981 | 147 |
| 1982 | 148 |
| 1983 | 149 |
| 1984 | 148 |
| 1985 | 101 |
| 1986 | 99 |
| 1987 | 120 |
| 1988 | 111 |
| 1989 | 100 |
| 1990 | 86 |
| 1991 | 85 |
| 1992 | 68 |
| 1993 | 73 |
| 1994 | 72 |
| 1995 | 84 |
| 1996 | 74 |
| 1997 | 77 |
| 1998 | 69 |
| 1999 | 58 |
| 2000 | 76 |
| 2001 | 76 |
| 2002 | 67 |
| 2003 | 53 |
| 2004 | 61 |
| 2005 | 72 |
| 2006 | 47 |
| 2007 | 55 |
| 2008 | 46 |
| 2009 | 50 |
| 2010 | 30 |
| 2011 | 36 |
| 2012 | 39 |
| 2013 | 35 |
| 2014 | 19 |
| 2015 | 23 |
| 2016 | 42 |
| 2017 | 33 |
| 2018 | 40 |
| 2019 | 33 |
| 2020 | 30 |
| 2021 | 23 |
| 2022 | 32 |
| 2023 | 25 |
| 2024 | 10 |
| 2025 | 23 |
| 2026 | 15 |
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 year(c.\"eventDate\") = 1992
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 year(c."eventDate") = 1992
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 ATL93LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Atlanta, GAThe student pilot's failure to maintain directional control of the airplane.NTSB NYC93LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Quaker Street, NYThe failure of the pilot to determine runway conditions prior to landing which resulted in the airplane being damaged upon touchdown on the snow covered runway.NTSB FTW93LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Norman, OKThe pilot's failure to refuel the airplane and power loss due to fuel exhaustion. Factors were the dark night and lack of suitable terrain.NTSB MIA93LA026Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Groveland, FLThe pilot's encounter with shifting winds on the takeoff roll, that caused the airplane to overrun the runway. Contributing to the accident was the failure of the pilot in command to perform an aborted takeoff.NTSB MIA93FA025Accident · 1 fatalField investigationFinal reportCessna 152 · Ocala, FLThe pilot-in-command becoming lost and disoriented and his failure to maintain altitude.NTSB ATL93FA030Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Pike Road, ALThe failure of the pilot in command to maintain airspeed during the initial climb, which resulted in an inadvertent stall and collision with the ground. Factors were the inadequate preflight planning and preparation of the pilot in command in that he operated…NTSB FTW93LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · New Orleans, LAHard landing due to the pilot's inadequate flare. A factor was the blocked rudder.NTSB SEA93LA028Accident · No injuriesLimited investigationFinal reportCessna A152 · Tremonton, UTDelayed remedial action. Factors include a tailwind.NTSB BFO93LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Danville, KYThe student pilot's inadequate flare. A factor was the gusty wind.NTSB CHI93LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, MNThe pilot's failure to maintain directional control.NTSB LAX93LA026Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fontana, CAThe noncertificated pilot's unwarranted low flying.NTSB MIA93LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLThe pilot in command's improper flare which resulted in the aircraft ballooning during landing, followed by his improper recovery from the ballooned landing which resulted in the aircraft touching down hard on the nose landing gear causing it to collapse.NTSB CHI93LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsdale, MIInadequate preflight planning in not refueling the aircraft and a poorly planned forced landing by the pilot.NTSB SEA93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Spokane, WAInadequate preflight planning/preparation. Factors to the accident were: fuel exhaustion and inadequate fuel consumption calculations.NTSB LAX93LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Quartzsite, AZEngine failure for an undetermined reason. Contributing to this accident was the rough/uneven terrain.NTSB NYC93LA006Accident · Minor injuriesLimited investigationFinal reportSmitrovich SE-5A Replica · Harwinton, CTA forced landing in unsuitable terrain, following a power loss due to fuel exhaution. Factors related to the accident were the failure of the pilot to refuel the airplane prior to departure and his improper fuel consumption calculations which led to fuel…NTSB ANC93LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Skwentna, AKThe student pilots failure to maintain directional control during a go around. Factors relating to the accident were the soft runway conditions and the inadequacy of training in the maneuver attempted by the student.NTSB NYC93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Heathsville, VAThe improper inflight planning and decision by the student pilot resulting in fuel exhaustion.NTSB ANC92LA174Accident · No injuriesLimited investigationFinal reportPiper PA-18 · New Stuyahok, AKFuel system contamination by water and poor preflight inspection and preparation by the pilot in command. The lack of suitable terrain for an emergency float plane landing was a factor in this accident.NTSB CHI92LA268Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Harvard, ILFailure of the pilot in command to align the accident airplane with the centerline of the runway during landing.NTSB CHI92LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Crete, NEA premature lift-off and failure to perform remedial action. Lack of expereince in short field takeoffs was a factor.NTSB BFO92LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Great Barringto, MAThe pilot's failure to recover from a bounced landing. Factors related to the accident were the pilot's inadequate flare and failure to maintain directional control.NTSB FTW92LA219Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, ARThe pilot's inadequate visual lookout while maneuvering at low altitude.NTSB ANC92LA143Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Harding Lake, AKThe partial loss of engine power for undetermined causes, and the unsuitable terrain.NTSB NYC92LA172Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · West Mifflin, PAThe pilot inadvertently ground looped the airplane which resulted in the main landing gear collapsing. A factor in this accident was the pilot's limited flight time in this make and model airplane.NTSB NYC92LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainville, CTFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The embankment beside the runway was a related factor.NTSB ANC92LA124Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Talarik Creek, AKThe pilot selected unsuitable terrain on which operate.NTSB LAX92FA331Accident · 1 fatalField investigationFinal reportCessna 152 · Maricopa, AZThe pilot exceeded the design stress limits of the airplane structure by attempting an abrupt maneuver at a speed in excess of the maneuvering speed.NTSB NYC92LA140Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · East Liverpool, OHA collision with trees after the pilot failed to maintain directional control during an aborted landing.NTSB LAX92LA324Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Porterville, CAFuel exhaustion due to the student pilot's inadequate preflight and inflight planning, and the failure to refuel the aircraft.NTSB MIA92LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCFailure of the pilot-in-command to maintain adequate wingtip clearance with bushes off the side of the taxiway while taxiing to takeoff.NTSB FTW92LA188Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Carrollton, TXThe pilot's selection of unsuitable terrain. Factors were the failed carburetor de-ice system valve resulting in an inoperative carburetor and the inadequate annual inspection by company maintenance personnel.NTSB ATL92LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Southport, NCThe failure of the pilot to maintain clearance from obstacles. A factor was the dusk lighting condition.NTSB BFO92LA110Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Belmont, NHInadequate in-flight planning/decision by the pilot.NTSB SEA92LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Provo, UTFuel exhaustion due to inadequate fuel supply. Factors include a ditch encountered while landing.NTSB BFO92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chestertown, MDCarburetor ice, due to the pilot's improper use of carburetor heat. Factors related to the accident were: carburetor icing (weather) conditions, and obstructions (houses and utility pole) in the emergency landing area.NTSB FTW92LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marietta, OKEngine power loss for undetermined reasons.NTSB NYC92FA133Accident · 1 fatalField investigationFinal reportCessna 152 · Pleasant Mount, PAThe pilot's decision to perform low altitude maneuvers, resulting in a loss of airplane control and collision with trees. Factors related to the accident were the ostentatious display by the pilot, and his lack of total flight experience.NTSB CHI92LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · East Tawas, MIThe pilot's failure to adequately compensate for the wind conditions and failure to properly flare the airplane. Contributing to the accident was the crosswind condition.NTSB DEN92LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXThe student pilot misjudged his landing and landed short of the runway. A factor was: lack of total experience on the part of the student pilot.NTSB FTW92LA173Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Bryan, TXThe certified flight instructor's misjudging the runway remaining for the aborted landing. Factors were the student pilot's misjudging the touchdown point and inadequate supervision of the approach by the CFI.NTSB ANC92LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Elmendorf Afb, AKThe pilot's failure to maintain directional control. Factors contributing to the accident were his psychological condition.NTSB MIA92LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bradenton, FLThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB FTW92IA158Incident · No injuriesIncident investigationFinal reportPiper PA-31T · Addison, TXThe failure of the pilot-in-command of the PA-38, N2603B, to follow ATC instructions.NTSB FTW92LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Henrietta, TXLoss of engine power from fuel exhaustion and the pilot's failure to refuel the airplane.NTSB LAX92LA226Accident · No injuriesLimited investigationFinal reportCessna 152 · Delano, CAThe failure of the student pilot to adequately compensate for gusting cross wind conditions and his failure to maintain directional control during the landing roll.NTSB SEA92LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt. Pleasant, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: weather (gusts) and terrain (berm).NTSB ANC92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Heiden, AKEngine power loss for undetermined causes. Contributing to the accident was the unsuitable terrain.NTSB ANC92LA081Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Bainbridge, AKCarburetor ice and the pilot's failure to follow procedure. A factor relating to the accident was the rough/uneven terrain in the forced landing area.NTSB CHI92LA159Accident · No injuriesLimited investigationFinal reportBeech 77 · Moline, ILThe student pilot's failure to maintain directional control.