NTSB investigations: Lycoming 0-290 series, 1992
17 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\") = 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 ('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") = 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 ('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 LAX93LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Herald, CAThe failure of the pilot to maintain a proper descent rate and his failure to take timely remedial action to correct a high sink rate prior to colliding with the ground.NTSB CHI93LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Weeping Water, NEThe pilot's failure to maintain directional control.NTSB SEA92LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Troutdale, ORSeparation of the number 3 cylinder exhaust valve head and overloading of the nose gear strut. A factor contributing to the accident was the uneven terrain.NTSB CHI92LA296Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Plattsmouth, NEThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control.NTSB ANC92LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Kasilof, AKThe pilot in command's inadvertant power off stall entry resulting in the collision with the terrain.NTSB SEA92LA200Accident · Minor injuriesLimited investigationFinal reportYork Y2 · Mountain Home, IDThe pilot's failure to maintain directional control. Factors include gusty crosswinds.NTSB SEA92LA186Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Morgan, UTPoor inflight planning/decision by the pilot in command. Factors contributing to the accident were: the gravel/dirt bank, night environmental conditions, and runway lighting unavailable.NTSB ANC92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot failed to maintain directional control of the airplane during the landing roll. Contributing factors were the unfavorable wind, the trees, and the fence.NTSB NYC92LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot diverted his attention from flying the airplane and did not maintain a visual lookout, which resulted in a collision with trees.NTSB LAX92LA318Accident · No injuriesLimited investigationFinal reportChapuis Spezio Sport · Wells, NVThe pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain directional control of the aircraft. A factor in the accident was the variable and gusty nature of the wind conditions at the airport.NTSB ANC92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKThe pilot's improper preflight planning/decision, and his delayed aborted takeoff. Contributing was the pilot's failure to use the airplane performance data.NTSB ANC92LA098Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kantishna, AKThe pilot in command's excessive taxi speed. Factors relating to the accident were the crosswind and dusk light conditions.NTSB CHI92DEE02Accident · Serious injuriesFinal reportVandenbos/Thorp T-18 · Schaumburg, ILShorting of condensers on both magnetos. A factor was inadequate maintenance servicing of the airplane by other maintneance personnel.NTSB ANC92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Alexander Creek, AKThe pilot's failure to maintain directional control during landing flare/touchdown. A factor relating to the accident was the crosswind weather condition.NTSB CHI92LA156Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Greenwood, ILExcessive application of the brakes during landing roll.NTSB ANC92LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Twin Hills, AKDirectional control was not maintained. A factor to the accident was: a bird.NTSB ANC92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18A-135 · Paxson, AKThe pilot failed to attain & maintain takeoff airspeed. Factors to the accident were: takeoff was performed with a tailwind, and inadequate remedial action.