NTSB investigations: Lycoming 0-290 series, 2021
14 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\") = 2021
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") = 2021
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 CEN22LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Tahlequah, OKA loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.NTSB CEN21LA469Accident · Minor injuriesClass 4 · LimitedFinal reportMeuer SA900 V-STAR · Kokomo, INThe pilot’s failure to maintain adequate speed and altitude during final approach, which resulted in an off field landing short of the runway and a subsequent nose over.NTSB ERA21LA392Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Greensboro, GAThe pilot’s inadequate preflight planning and fuel system inspection, which resulted in fuel exhaustion.NTSB ANC21LA082Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Soldotna, AKThe pilot’s failure to maintain directional control during landing, which resulted in a ground-loop.NTSB CEN21LA390Accident · Minor injuriesClass 3 · LimitedFinal reportMantooth Thorp T-18 · San Antonio, TXThe loss of engine power after takeoff for undetermined reasons.NTSB CEN21LA332Accident · No injuriesClass 4 · LimitedFinal reportMadera RV-3 · Jacksonville, ILThe pilot’s improper flare during landing which resulted in an attempted go-around, loss of control, and aerodynamic stall.NTSB WPR21LA281Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Cascade, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with terrain.NTSB WPR21LA257Accident · No injuriesClass 4 · LimitedFinal reportWheeler C / Wheeler K Lancair 235 · Borrego Springs, CAThe pilot’s failure to maintain airplane control during a crosswind landing which resulted in an impact with terrain.NTSB WPR21FA233Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-22-135 · White City, ORThe pilot’s failure to maintain control of the airplane during a go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s impairment due to his medical conditions and the effects of his medications.NTSB CEN21LA217Accident · No injuriesClass 4 · LimitedFinal reportSmith Miniplane DSA-1 · Fulton, MOThe pilot’s failure to maintain control of the airplane during landing in gusty crosswinds.NTSB WPR21LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Eastsound, WAThe pilot’s failure to maintain directional control during the landing roll with a tailwind, which resulted in a landing gear collapse and collision with terrain.NTSB ANC21LA021Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff in gusty tailwind conditions, which resulted in a runway excursion and nose down.NTSB ERA21LA131Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Lake Placid, FLThe pilot’s failure to ensure that the aft seat cushion was adequately secured, which resulted in its movement, subsequent interference with the flight controls, and a hard landing.NTSB WPR21LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20-135 · Riverside, UTA failure of the throttle control during a landing roll, which resulted in a loss of control and collision with a fence.