NTSB investigations: Lycoming 0-290 series, 2001
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\") = 2001
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") = 2001
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 FTW02LA029Accident · No injuriesLimited investigationFinal reportLandoll Vans RV 3-A · Denton, TXthe pilot's failure to perform a preflight inspection, which resulted in a loss of total engine power due to oil starvation. A contributing factor was the lack of suitable training for the forced landing.NTSB SEA02LA010Accident · No injuriesLimited investigationFinal reportFetherolf Hatz CB-1 · Ontario, ORAn improper weld in the landing gear, resulting in separation of the right main landing gear wheel during a normal landing.NTSB ANC01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nenana, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was trees.NTSB SEA01LA141Accident · No injuriesLimited investigationFinal reportTaylor Smith Mini DSA-1 · Sultan, WAThe separation/loss of the bolt and castle nut which connected the elevator bellcrank to the control stick pushrod resulting in a disconnect between the cockpit and the control surface and ultimately, the pilot's total loss of pitch control.NTSB ANC01LA089Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Anchorage, AKAn inadvertent ground loop during the landing roll.NTSB SEA01LA137Accident · No injuriesLimited investigationFinal reportPiper PA-20-135 · Redmond, ORThe pilot's inadequate compensation for wind conditions during landing. A factor was variable winds.NTSB SEA01LA134Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Oregon City, ORThe front seat (pilot-in-command's) inadequate visual lookout during step taxi resulting in the aircraft's collision with a partially submerged log. A contributing factor was the log and it's lack of any conspicuous marking.NTSB DEN01LA117Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Eagle, COthe pilot's inadequate wind evaluation, and his inadequate planning/decision to land with a tailwind, at a density altitude of 13,418 feet. Contributing factors were the tailwind and the high density altitude weather condition.NTSB SEA01LA119Accident · Minor injuriesLimited investigationFinal reportShaub EAA Biplane (P-2) · Zillah, WAThe pilot's failure to maintain directional control. A contributing factor was a tailwind.NTSB LAX01LA206Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Winnemucca, NVThe pilot's failure to obtain weather information or an in-flight advisory that would have described current wind information at the destination airport and his subsequent failure to maintain directional control during landing.NTSB DEN01LA115Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Longmont, COthe pilot's failure to maintain directional control during landing. A contributing factor was the tailwind.NTSB SEA01FA106Accident · 1 fatalField investigationFinal reportPiper PA-12 · Augusta, MTThe pilot's failure to maintain adequate airspeed after takeoff resulting in an inadvertent stall at low a altitude.NTSB NYC01LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Clinton, MDThe pilot's failure to maintain directional control during landing rollout. Factors related to the accident were the pilot's lack of experience in tail-wheeled airplanes, and the wind gusts.NTSB LAX01LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Oxnard, CAThe fracture and separation of the number 3 cylinder exhaust valve head resulting in a loss of engine power and a forced landing. A factor in the accident was the soft field where the forced landing occurred.NTSB DEN01FA082Accident · 2 fatalField investigationFinal reportSandell Zenith CH 200 · Canon City, COthe pilot in command inadvertently allowing the airplane to stall/spin. Contributing factors were the pilot's total lack of experience in airplane make/model, and high wind conditions.NTSB SEA01LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bozeman, MTThe pilot rated passenger's failure to maintain directional control during the landing. A factor was the snow berm which the aircraft rolled into during the landing.NTSB LAX01LA087Accident · 2 fatalLimited investigationFinal reportSutton Tailwind W-8L · Reno, NVThe pilot performed aerobatics at low altitude and failed to maintain clearance from the gound resulting in a collision with the terrain.NTSB NYC01LA070Accident · 1 fatalLimited investigationFinal reportWhittman Tailwind DN-1 · Grafton, WVThe pilot's improper preflight planning, which resulted in fuel exhaustion. A factor was the pilot's lack of familiarity with the airplane.NTSB LAX01LA076Accident · No injuriesLimited investigationFinal reportPurvis/Thorpe T-18 · Chiriaco Summit, CAThe dual student's improper recovery from a bounced landing, his failure to maintain directional control during the go-around, and the flight instructor's inadequate supervision of the go-around attempt.