NTSB investigations: Lycoming 0-235 series, 1987
120 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\") = 1987
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") = 1987
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 MIA88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLEn route to the destination during a cross country flt, the acft was diverted to an alternate arpt due to weather conditions below minimums. Unable to land at the alternate due to poor visibility the non-instrument rated plt requested vectors to the…NTSB DEN88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Las Cruces, NMWhile practicing crosswind landings the instructor stated that the student touched down normally with aprx 5 knot crosswind. Upon touch down, the right main landing gear separated from the acft causing substantial damage. There were no injuries and no fire.…NTSB CHI88LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILThe plt returned to the arpt after dark & noted there was an excessive x-wind for the active rwy. He elected to land on the unlighted grass rwy (rwy 14) which was aligned more favorably with the wind. He thought that on final apch, he had aligned the acft…NTSB LAX88LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Dunsmuir, CAA Piper PA-38-112 collided with terrain while on a night VFR cross country flight. Night instrument meteorological conditions prevailed at the time and no flight plan was filed. The pilot received a weather briefing prior to departure. His destination weather…NTSB MIA88LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Antonio, FLThe student plt became lost while on a solo x-c training flt. He attempted to contact his non control tower destination airport via UNICOM. He stated that he flew around for 20 or 25 mins attempting to make UNICOM contact & was unsuccessful in doing so. He…NTSB SEA88LA025Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Cornelius, ORThe pilot was attempting to land in a field near a farmhouse. On final approach the pilot cleared large power lines, but had not seen small power lines ahead and below the aircraft. The aircraft struck the power lines in flight with the nose gear. The…NTSB NYC88LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Mendham, NJThe flight instructor had simulated an engine failure. The instructor pulled the throttle to idle and the student went through the checklist procedure for emergency landing. When the student plt applied power for the go-around the engine restarted for about…NTSB MIA88LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Zephyrhills, FLAfter successful completion of 6 dual touch-and-go landings, the student plt departed to perform 3 touch-and-go landings for her first solo flight. The instructor plt stated that the apch to the first landing appeared to be low & after touchdown, the acft…NTSB DEN88LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe recently certificated private plt was taxiing his acft to rwy 9 for a night takeoff. Another acft began its takeoff roll on rwy 9. As a courtesy, the taxiing plt switched off his taxi light so as not to blind the other plt. The taxiing plt used the glow…NTSB NYC88LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chatham, MAThe duration of the pleasure flight was about 25 minutes and was uneventful. The pilot made the approach and entered the traffic pattern in the standard manner and radioed UNICOM of her intentions to land. The pilot stated that she landed longer than usual…NTSB NYC88LA026Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Argyle, NYThe flight was returning to cheney farm field for landing when the pilot came in too high and fast. He added power, banked left and started a go around. At this time the engine backfired and started missing. During the emergency landing in a pasture the…NTSB NYC88LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Pepperell, MAA student pilot on a cross country training flight experienced fuel exhaustion at about 3500 feet. The pilot stated that when the engine lost power he contacted approach control on 121.5 but did not have sufficient altitude to make it to an airport. The…NTSB FTW88LA020Accident · No injuriesLimited investigationFinal reportCessna 152 · New Caney, TXAcft took off in marginal VFR conditions on a pipeline patrol flt. En route, the plt encountered deteriorating wx conditions and experienced a rough running eng, due to what he suspected was carb ice. His attempts to remedy the roughness were unsuccessful and…NTSB ATL88LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with the…NTSB NYC88LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Hammondsport, NYShortly after takeoff, the Piper PA-12 experienced a loss of power and made an off airport landing. During the landing, the aircraft impacted in a corn field. Examination of the aircraft did not disclose any malfunctions or mechanical failures. Auto fuel was…NTSB ATL88LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, NCThe student plt became lost on the return leg of his 1st solo cross-country flt. He elected to make a precautionary ldg in a plowed field after observing the acft fuel gauges indicating near empty. The acft nosewheel sank into soft dirt during rollout and the…NTSB ATL88LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hampton, GAThe CFI rptd that the student flared the airplane about 50 ft abv the rwy and stalled it; the airplane dropped to the rwy and bounced. He assumed control of the airplane from the student and attempted to prevent a crosswind from blowing the airplane to the…NTSB ANC88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Skwentna, AKThe acft collided with a tree stump during a short field landing. The plt stated that the stump was hidden by tall grass. No official information is published abt the johnson airstrip.NTSB DEN88LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Tremonton, UTThe student plt flew to the first stop on his cross country training flight. He misread the windsock and landed downwind on runway 17. After touchdown the pilot lost control of the aircraft and taxied off the left side of the runway, hit a fence and a tree…NTSB NYC87LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, CTThe plt of Cessna 152, N93193, taxied for takeoff with the intentions of using rwy 24. At about the same time, a navy H-53 (Sikorsky) helicopter entered a pattern to land on rwy 24. With the heavy helicopter apchg to land, the Cessna plt accepted an offer to…NTSB CHI87LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Joliet, ILThe aircraft landed on what the pilot thought was a runway. He stated that on short final the aircraft floated before touching down and consequently there was not enough room to make a go-around. After touchdown, he braked hard and the aircraft swerved left…NTSB ATL87LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Winston Salem, NCThe student pilot was performing touch and go landings as part of his supervised solo training. The aircraft landed hard and bounced twice before coming to rest with a collapsed nose gear. Examination of the airframe disclosed extensive crushing damage to the…NTSB LAX87FA341Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Sonoma, CAThe 70-hour student plt had recently passed the pvt plt written exam & had completed most of the flt trng for certification. He was looking forward to becoming a licensed plt. While on a personal flt, the plt flew over his brother's residence & was observed…NTSB LAX87LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Monterey, CAWhile landing at the destination, the airplane bounced, then after it touched down the second time, the nose gear failed. During the landing roll-out, the airplane settled on its nose cowling. No previous airframe problem was evident.NTSB ANC87LA156Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Valdez, AKThe pilot stated that he was landing at an unimproved, off airport site when the main gear hit a hole during the landing roll and the aircraft nosed over.NTSB ANC87FA153Accident · 3 fatalField investigationFinal reportPiper PA-12 · Shaw Creek, AKThe private pilot was transporting passengers incidental to the operation of his lodge. According to witnesses, it was common for pilots to use that portion of the highway for takeoffs and landings. According to the husband of one of the fatally injured…NTSB FTW87LA212Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Roby, TXAfter aprx 3.3 hrs of flt, the eng lost power from fuel exhaustion. The plt rprtd that when he made a forced landing in a field, the nose tire dug in the ground & the acft nosed over. Also, he stated that he did not top off the fuel tanks before departing on…NTSB CHI87LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · New Lenox, ILThe accident occurred on a local training flight. At 3500 ft MSL the eng failed. The student plt landed at a near-by arpt but bounced on touchdown, veered off the rnwy and nosed over. Eng exam disclosed broken primary venturi in carb.NTSB ANC87LA151Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Salcha, AKThe private pilot was unable to maintain directional control of the acft when he encountered a quartering crosswind gust on final approach. The left wing collided with brush and small trees along side of the unattended airstrip. The pilot rptd the wind…NTSB ATL87DEI12Accident · No injuriesFinal reportTomishin W-8 · Painesville, OHThe plt/owner of the homebuilt aircraft was making a local flight to determine the flt characteristics with a larger wing installed on the acft. The plt reported that while in flight an oil leak developed from the area of the propeller. The oil coated the…NTSB ANC87LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Glennallen, AKThe pilot related that he ran out of fuel enroute to his planned refueling stop and made an emergency landing on a highway, substantially damaging the airplane. He said that the enroute portion of his flight took much longer than anticipated due to strong…NTSB LAX87LA321Accident · No injuriesLimited investigationFinal reportCessna 152C · Upland, CAThe dual instruction flight completed 2 full stop landings on runway 06 at the cable airport. On the next takeoff the flight encountered a downdraft after turning on the crosswind leg. The instructor pilot took the controls and turned to the downwind leg but…NTSB ANC87LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kwethluk, AKThe pilot stated that he was flying a search and rescue mission for a missing aircraft when he noticed that his airspeed indicator was not working. He landed on a lake in gusty wind conditions to correct the problem. During the ensuing takeoff attempt, a gust…NTSB CHI87LA206Accident · No injuriesLimited investigationFinal reportCessna 152 · Phillips, WIDuring the takeoff phase of a touch and go landing the student pilot lost directional control of the aircraft. The aircraft exited the runway to the left, struck a ditch and overturned. The student's instructor, who was a witness to the accident states that…NTSB ANC87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-12-150 · Little Delta, AKThe pilot stated that he was taking off downhill with a 10 knot tailwind. At that time the pilot lost directional control of the aircraft causing the aircraft to stall. The aircraft settled into brush and nosed over.NTSB LAX87LA313Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Buckeye, AZA Piper PA-38-112 landed hard on the runway while on a VFR training flight. The certificated flight instructor (CFI) indicated that the student pilot made an abrupt aft yoke (up elevator) application during the landing flare. The aircraft ballooned…NTSB LAX87LA308Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Ehrenberg, AZWhile on a x-country flt, the student plt elected to land on a road aprx 12 mi short of his destn to 'check on a job.' He said he was familiar with the road & decided to make a straight-in apch w/o first flying over it to look for obstructions. After making…NTSB ANC87LA125Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Homer, AKThe pilot stated after the landing rollout he lost directional control of the aircraft causing a groundloop on the runway. This landing was the first full stall landing of the flight.NTSB LAX87LA301Accident · No injuriesLimited investigationFinal reportCessna 152 · Madera, CAAfter the aircraft was flown for 3 hours and 30 minutes the engine failed. The aircraft entered a forced landing approach to an open field. The aircraft landed hard and nosed over onto its back. Ground witnesses who were on scene shortly after the accident…NTSB LAX87FA296Accident · No injuriesField investigationFinal reportCessna 152 · Palo Alto, CAA midair collision occurred abt 2.8 mi west of Palo Alto arpt (pao) as Cessna 152, N152SC, was on a left x-wnd dep fm rwy 30 & Mooney 20J, N5201Y was transitting the arpt traffic area (ata) fm se to NE & dscndg fm 2400' to 1500'. N152SC was on twr freq.…NTSB ANC87LA114Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Central, AKDuring an interview in the hospital with the passenger who was the pilot's son, he stated to the FAA inspector that his dad was low level flying when the aircraft struck a tree. The pilot lost control of the aircraft and crashed. At the time of the accident…NTSB DEN87LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Watkins, COThe plt was practicing touch-and-go landings on rwy 26. He estimated the wind to be 180 deg at 8 KTS. The plt said that on the third landing attempt, a 15 kt gust of wind caused the acft to drift to the right. He attempted to correct with left aileron and…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 MKC87LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, MOThe instructor and the student were making a landing on a short grass runway. The instructor stated they landed fast and were not able to stop. He considered a go-around but decided sufficient runway did not remain to perform the go-around. The airplane…NTSB CHI87LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit, MIOn touchdown the aircraft ballooned and bounced up about 5-7 feet off the runway. The aircraft then landed on the nose wheel and the prop struck the ground.NTSB FTW87LA171Accident · No injuriesLimited investigationFinal reportCessna 152 · Graham, TXThe approximate half tanks of fuel which the student pilot reportedly observed on board during his preflight inspection (and which should have been on board at that time) apparently leaked out through the broken fuel line fitting at the carburetor while the…NTSB CHI87LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Savoy, ILA student pilot was on his initial solo flight and had been instructed to do touch and go landings. On his second landing he did not achieve a proper flare attitude, the aircraft touched down flat and fast and began to porpoise. After approximately three…NTSB ATL87DEI10Accident · No injuriesFinal reportCessna 152 · Kent, OHThe student plt was on his third solo flight. As he was flaring to land, the aircraft ballooned twice and he initiated a recovery by adding power. However, the airplane settled and contacted the runway with the nosewheel first, damaging an engine mount &…NTSB ATL87LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Middlefield, OHThe student plt's seat slid back during the takeoff roll, following a touch-and-go ldg. The student lost directional control and the airplane ran off the left side of the rwy. The airplane impacted a ditch and nosed over. Post-crash exam of the seat assy by a…NTSB ANC87FA095Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Sheep Mountain, AKThe pilot and his two passengers took off in a two place Piper PA-18 from a glacier after doing repair work on an aircraft that had crashed there earlier. Weather conditions were deteriorating as they approached their destination airstrip located in a nearby…