NTSB investigations: Lycoming 0-290 series, 1987
21 cases on aircraft whose registry engine model is Lycoming 0-290 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 | 92 |
|---|---|
| 1965 | 75 |
| 1966 | 71 |
| 1967 | 70 |
| 1968 | 47 |
| 1969 | 49 |
| 1970 | 51 |
| 1971 | 45 |
| 1972 | 49 |
| 1973 | 35 |
| 1974 | 43 |
| 1975 | 28 |
| 1976 | 38 |
| 1977 | 39 |
| 1978 | 45 |
| 1979 | 30 |
| 1980 | 19 |
| 1981 | 22 |
| 1982 | 29 |
| 1983 | 29 |
| 1984 | 24 |
| 1985 | 27 |
| 1986 | 15 |
| 1987 | 21 |
| 1988 | 19 |
| 1989 | 15 |
| 1990 | 15 |
| 1991 | 22 |
| 1992 | 17 |
| 1993 | 15 |
| 1994 | 12 |
| 1995 | 15 |
| 1996 | 31 |
| 1997 | 6 |
| 1998 | 21 |
| 1999 | 18 |
| 2000 | 14 |
| 2001 | 19 |
| 2002 | 24 |
| 2003 | 18 |
| 2004 | 12 |
| 2005 | 19 |
| 2006 | 11 |
| 2007 | 14 |
| 2008 | 18 |
| 2009 | 17 |
| 2010 | 11 |
| 2011 | 14 |
| 2012 | 17 |
| 2013 | 10 |
| 2014 | 11 |
| 2015 | 13 |
| 2016 | 6 |
| 2017 | 12 |
| 2018 | 10 |
| 2019 | 10 |
| 2020 | 14 |
| 2021 | 14 |
| 2022 | 8 |
| 2023 | 14 |
| 2024 | 6 |
| 2025 | 9 |
| 2026 | 9 |
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 ('41506'))
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 ('41506'))
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 MIA88FA063Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Geneva, ALPrior to the acdnt, a witness saw the acft flying across an open field at a very low alt. Subsequently, it collided with the tops of several pine trees at about 90 to 95 ft AGL, then it crashed to the ground. No preimpact part failure or malfunction was…NTSB MIA88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Daytona Beach, FLAlthough the plt stated that he performed a preflt & eng runup prior to departure with no problem noted, shortly after takeoff, while climbing through 350 ft, the engine RPM dropped to & stayed between 1500 & 1600. The plt was unable to maintain altitude…NTSB DEN88LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Monte Vista, COThe plt attempted to take off on a frost-covered, pvt airstrip. Witnesses observed the aircraft become airborne before it settled back down to the ground. Control of the acft was lost and the acft nosed over.NTSB MIA88LA039Accident · No injuriesLimited investigationFinal reportPitts S-1C · Clearwater, FLThe plt stated that on landing roll, as he added power to go around, he lost control of the aircraft, ran off the runway, flipped over and came to rest inverted. The torque of the relatively powerful engine added to the control problems in this short fuselage…NTSB LAX88DXQ01Accident · Serious injuriesFinal reportPugh LONG-EZ · Newell, CABefore taking off, the plt noted that the wind sock was 'whipping & was about 3/4 full.' He said that after takeoff, he made a flyby at about 50' AGL, with an airspeed of about 150 mph. He then entered a steep climbing right turn. The plt estimated that at…NTSB MKC88FA007Accident · 2 fatalField investigationFinal reportChampion Aeronca 7GC · Columbia, MOWitnesses reported the pilot had planned to practice 'taildragger' takeoffs and landings. They reported the aircraft operated routinely from engine start through the final approach segment of a VFR traffic pattern. While stabilized at about 400 ft AGL on…NTSB DEN88FA001Accident · 1 fatalField investigationFinal reportPiper PA-18-125 · Miles City, MTA cattle rancher was flying his aircraft looking for stray cattle and checking the condition of the ranch. He was at approximately 300 feet AGL when he spotted cattle that had strayed off the ranch. The pilot turned to get a better view of the cattle and flew…NTSB ANC88LA001Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Fairbanks, AKThe plt stated that during tkof roll he lost directional ctl of the acft which caused it to exit the rwy. It then struck a rwy light and nosed over.NTSB DEN87DTI02Accident · No injuriesFinal reportBakeng Deuce · Gillette, WYThe plt rprtd that on each of his 1st 3 attempts to land, he began losing directional control during roll-out & went around. On the 4th attempt, he again tried to go around, but the acft swerved off the rwy & ground looped, collapsing the left main gear &…NTSB SEA87LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · John Day, ORPlt departed hay field in hi density alt conds. The pilot was unable to clear trees and stalled/mushed into terrain, collapsing gear and colliding with trees.NTSB ANC87LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gold King, AKThe pilot stated that during the take off roll he lost directional control of the aircraft causing the aircraft to exit the strip into a row of trees.NTSB ANC87LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Iowa Ridge, AKThe pilot was awakened in the night at his hunting camp by strong winds estimated at 70 - 80 mph. His airplane came loose at its tie-down and he elected to try and fly it to a safer location. Shortly after take off he lost control of the airplane and crashed.…NTSB ANC87LA129Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Montague Island, AKThe plt was making an apch for a soft/short field landing at a strip which paralleled the ocean shoreline on Montague Island. He stated that when he came in to land, he misjudged the height & position of bushes nr the apch end of the strip. Subsequently, the…NTSB ANC87LA133Accident · No injuriesLimited investigationFinal reportChampion 7GC · Central, AKThe pilot stated that he was attempting to land in gusty, crosswind conditions and lost control of the airplane. He said the accident could have been avoided by choosing a different airport with less crosswind, or by initiating a go-around when he first…NTSB ANC87LA123Accident · Minor injuriesLimited investigationFinal reportChampion 7HC · Seward, AKThe pilot lost directional control on landing and veered to the right side of the runway. The aircraft then struck a small mound and nosed over on its back. The pilot stated that he landed with a 7 to 10 knot tailwind.NTSB CHI87DEV03Accident · No injuriesFinal reportPiper PA-22 · Roanoke, ILAfter developing an oil leak the pilot elected to make a precautionary landing. The aircraft encountered rough terrain on touchdown and collapsed the nose gear and nosed over. The pilot and one passenger reported no injuries, however the aircraft was…NTSB FTW87LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Tulsa, OKDrg the initial climb after takeoff, the acft's eng lost pwr. The plt landed the acft on a median in a residential & shopping area, where it nosed over. An exam & an opnl check of the eng revealed no reason for the loss of pwr.NTSB LAX87DUJ06Accident · 1 fatalFinal reportDavis Midget Mustang · Kirkland, AZDuring a low level aerobatic flight, the aircraft collided with the terrain after completing a roll. There were no mechanical failures or malfunctions reported. The plt performed the last roll in view of two friends driving in a car near the acc scene.…NTSB ANC87LA092Accident · No injuriesLimited investigationFinal reportPiper J-3 · Lake Creek, AKThe pilot stated he touchdowned on a gravel bar and shortly after touchdown he lost control of the aircraft causing the aircraft to nose over on its back.NTSB ATL87DEI04Accident · Minor injuriesFinal reportButler EAA Biplane 1 · Orrville, OHAcft lost power and was landed in a corn field. Left main gear collapsed and acft flipped onto its back. Mixture cable set screw on carburetor was found loose allowing mixture to vibrate to lean position. Earlier in the day the PIC had replaced the carburetor.NTSB SEA87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Seattle, WADuring landing roll with a crosswind from the right a ground loop occurred. The pilot had just completed a solo cross country flight. The wind was from 210 degrees at 9 knots. The pilot was landing on runway 13L.