NTSB investigations: Lycoming 0-290 series, 1991
22 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\") = 1991
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") = 1991
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 FTW92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Roads, LAThe student pilot's loss of directional control and the resultant ground loop. Factors were the cfi's lack of supervision and the ditch adjacent to the runway.NTSB MIA92LA038Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hilliard, FLPartial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the low ceiling encountered and reduced in-flight planning decision time by the pilot-in-command.NTSB ANC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Stebbins, AKThe pilot's failure to adequately compensate for the wind during landing. Factors were the crosswind and the attempted go aroundNTSB ATL91LA184Accident · 1 fatalLimited investigationFinal reportFischer Wagabond · Rossville, TNThe loss of engine power as a result of carburetor icing.NTSB ANC91LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Anaktuvuk Pass, AKThat the pilot inadvertently stall/spun the airplane to the ground. Contributing to the accident was the pilot's failure to adequately remove the ice/frost from the wings before starting the takeoff.NTSB CHI91LA285Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Creve Coeur, MOA premature liftoff and improper remedial action by the pilot during a takeoff ground run.NTSB CHI91LA271Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Saginaw, MIDirectional control was not maintained by the pilot which resulted in a ground loop. A factor related to the accident was a crosswind.NTSB ANC91LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Eagle River, AKThe pilot's failure to maintain airspeed during climbout and lack of aircraft control. Contributing to the accident was both the downdraft and gusting wind.NTSB ANC91LA120Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Eureka, AKThe pilot-in-command's failure to mantain directional control of the airplane during the takeoff roll. Contributing to the accident was the crosswind.NTSB SEA91LA182Accident · 2 fatalLimited investigationFinal reportPiper PA-20 · Ione, WAInadequate clearance. A factor to the accident was: poor inflight planning.NTSB SEA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chehalis, WAThe pilot's failure to maintain proper runway alignment. Factors include gusty winds and crosswinds.NTSB LAX91LA295Accident · No injuriesLimited investigationFinal reportPiper PA 22 · Duncan, AZThe pilot's failure to maintain a proper airspeed during the approach and an inadvertent entry into a stall/mush which resulted in a hard landing.NTSB ANC91LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Delta Junction, AKWas the pilot-in-command's loss of control during the takeoff run, thereby allowing the airplane to stray from the runway's centerline and to strike some high vegetation.NTSB LAX91LA260Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Sonita, AZA loss of engine power due to a broken piston ring in the number 3 cylinder, which resulted in the aircraft's inability to maintain level flight.NTSB ANC91LA068Accident · No injuriesLimited investigationFinal reportCessna 140 · Kenai, AKThe pilot's failure to maintain directional control. A factor was the gusty wind conditions.NTSB FTW91LA094Accident · No injuriesLimited investigationFinal reportPitts S1C · Houston, TXThe failure of the propeller due to improper installation.NTSB BFO91LA051Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar STP1 · Quinton, VAThe pilot's failure to maintain adequate clearance from a moving aircraft.NTSB SEA91LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Laramie, WYThe pilot's failure to maintain an airspeed above the stall speed for the aircraft. Contributing to the accident was the high density altitude.NTSB SEA91LA091Accident · 1 fatalLimited investigationFinal reportSchwartz Bushby MM-1 · Ephrata, WAThe pilot's loss of control after he initiated a maneuver at low altitude.NTSB SEA91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTThe pilot did not maintain directional control of the airplane during the landing roll. Factors to the accident were: the landing surface was covered with slush, snow was falling and obscured the pilot's vision.NTSB CHI91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Grand Marais, MNFailure of the pilot to maintain directional control. The crosswind and snow covered runway were related factors.NTSB LAX91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe failure of the CFI aboard N25378 to adequately supervise the flight and the dual student pilot's improper use of the normal brakes.