NTSB investigations: Lycoming 0-290 series, 1988
19 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\") = 1988
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") = 1988
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 MKC89LA026Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Salisbury, MOThe pilot said shortly after takeoff the engine lost power. He attempted to land on a plowed field, and after rolling about fifty yards on the rough, soft terrain, the aircraft nosed over. Post accident investigation revealed the engine lost power due to fuel…NTSB LAX89LA051Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chino, CAThe plt lost directional control of the acft during the landing roll and ground looped. The flight instructor reported that this was the first landing of the day and that they were staying in the traffic pattern to practice touch and go landings on rwy 26.…NTSB SEA89LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Murphy, IDWhile making a low pass over a snow-covered airstrip, the plt misjudged his altitude. The aircraft's main gear made contact with six inch deep snow, & after traveling aprx 100 ft, the plane nosed over.NTSB ANC89LA010Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Soldotna, AKDuring the landing roll the pilot lost directional control of the airplane. The airplane ground looped on the runway.NTSB NYC88DHA03Accident · No injuriesFinal reportDebarry/Starduster SA100 · Slatington, PAAs the homebuilt acft was climbing thru about 300 ft AGL during initial climb after takeoff, the eng lost power. The plt was able to restart the eng (once), but as he turned the acft back toward the arpt, the eng lost power again. During an emerg landing, the…NTSB CHI88DER09Accident · Serious injuriesFinal reportSmith Miniplane · Superior, WIWhile in normal cruise the aircraft experienced a total loss of engine power. The pilot executed an emergency descent to a forced landing. The aircraft encountered unsuitable terrain which resulted in a hard landing and substantial damage to the aircraft. The…NTSB LAX88LA286Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Parker, AZThe pilot reported that just after tkof from a river the eng was not developing sufficient power to maintain altitude. The pilot made a landing and during the landing roll collided with rough terrain. After the accident, the engine was test run and found to…NTSB ANC88LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chandalar River, AKAfter touchdown on the gravel bar along the side of the River, the pilot lost control and the airplane nosed over on its back.NTSB BFO88LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrisonburg, VAThe plt encountered clouds during a night VFR flight. He decided to make a precautionary lndg on what he thought was a lighted farm landing strip. However, he later learned the strip was actually a row of lighted turkey barns. According to the plt, as he made…NTSB ANC88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Delta Junction, AKThe private pilot reported that he was attempting to land at an unimproved, off-airport landing site near Delta Junction, AK. The landing area that he selected was muddier than he had anticipated, and the airplane decelerated too rapidly and nosed over,…NTSB DEN88LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Forsyth, MTNTSB ANC88DAG05Accident · 2 fatalFinal reportPiper PA-18A · Mcgrath, AKThe airplane crashed approximately 94 miles east of the city of Mcgrath, Alaska. The pilot and passenger were fatally injured and the Piper PA-18 airplane was substantially damaged. The airplane impacted ground in a near vertical attitude near the end of a…NTSB ANC88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot stated that after touchdown on the runway a gust of wind hit the plane pushing the tail to the right and causing the aircraft to ground loop.NTSB SEA88LA111Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Kelso, WAThe plt stated that he selected rnwy 29 in very gusty conditions. He believed the landing was made with no problems. As the acft slowed below 45 mph it suddenly veered to the right. The plt failed to control the drift. The acft departed the runway and…NTSB ANC88FA057Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Wasilla, AKThe private pilot and passenger were making an approach to the Wasilla airport, Wasilla, AK, when the engine lost power. The pilot made a sharp 180 degree turn to try and reach a paved street about 3/4 of a mile short of the runway. The airplane stalled and…NTSB CHI88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Charlotte, MIDuring touchdown in a slight right crosswind, the student pilot inappropriately applied right rudder pressure. The aircraft yawed to the right and left the sod runway, veering into a plowed field. The aircraft struck a furrow and nosed over.NTSB ATL88DMG04Accident · Minor injuriesFinal reportMarrek Smyth Sidewinder · Honea Path, SCNTSB FTW88FA074Accident · 1 fatalField investigationFinal reportCessna 150J · Henderson, TXThe Cessna had just rolled out on base on 3rd or 4th touch go when it collided with a biplane that was not in the traffic pattern. Collision occurred between the outer panel of the left upper wing of the biplane and the rt side of the eng cowling of the…NTSB DEN88FA062Accident · 1 fatalField investigationFinal reportPiper PA-18-125 · Brighton, COThe student pilot was observed by witnesses to 'buzz' the city of Brighton, Colorado. Witnesses stated that N1153A flew over houses and buildings at a very low altitude. The acft was then observed to climb to a high altitude, do a 'wing over' or 'hammerhead'…