NTSB investigations: Lycoming 0-235 series, 2021
23 cases on aircraft whose registry engine model is Lycoming 0-235 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 | 137 |
|---|---|
| 1965 | 122 |
| 1966 | 98 |
| 1967 | 92 |
| 1968 | 78 |
| 1969 | 54 |
| 1970 | 74 |
| 1971 | 82 |
| 1972 | 73 |
| 1973 | 68 |
| 1974 | 68 |
| 1975 | 69 |
| 1976 | 64 |
| 1977 | 86 |
| 1978 | 152 |
| 1979 | 167 |
| 1980 | 153 |
| 1981 | 147 |
| 1982 | 148 |
| 1983 | 149 |
| 1984 | 148 |
| 1985 | 101 |
| 1986 | 99 |
| 1987 | 120 |
| 1988 | 111 |
| 1989 | 100 |
| 1990 | 86 |
| 1991 | 85 |
| 1992 | 68 |
| 1993 | 73 |
| 1994 | 72 |
| 1995 | 84 |
| 1996 | 74 |
| 1997 | 77 |
| 1998 | 69 |
| 1999 | 58 |
| 2000 | 76 |
| 2001 | 76 |
| 2002 | 67 |
| 2003 | 53 |
| 2004 | 61 |
| 2005 | 72 |
| 2006 | 47 |
| 2007 | 55 |
| 2008 | 46 |
| 2009 | 50 |
| 2010 | 30 |
| 2011 | 36 |
| 2012 | 39 |
| 2013 | 35 |
| 2014 | 19 |
| 2015 | 23 |
| 2016 | 42 |
| 2017 | 33 |
| 2018 | 40 |
| 2019 | 33 |
| 2020 | 30 |
| 2021 | 23 |
| 2022 | 32 |
| 2023 | 25 |
| 2024 | 10 |
| 2025 | 23 |
| 2026 | 15 |
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 ('41505'))
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 ('41505'))
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 WPR22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Mojave, CAThe pilot’s failure to maintain airplane control during an encounter with a wind gust during taxi.NTSB WPR22LA061Accident · 1 fatalClass 3 · LimitedFinal reportMoul Willis RV-3 · Bermuda Dunes, CAThe pilot’s improper positioning of the fuel shutoff valve, which resulted in a loss of engine power, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.NTSB ERA22LA080Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Labelle, FLThe pilot’s improper fuel system modification, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN22LA025Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Cresson, TXThe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with trees.NTSB CEN22LA027Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · La Porte, TXA total loss of engine power due to the failure of the carburetor float assembly.NTSB CEN22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe student pilot’s failure to maintain aircraft control during the final approach resulting in a bounced landing.NTSB CEN22LA005Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Houston, TXThe pilot’s improper application of brakes during landing.NTSB ANC21LA096Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-14 · Chickaloon, AKA total loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB CEN21LA417Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Olive Branch, MSThe airplane’s impact with a bird while on approach.NTSB ANC21LA077Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Nikolai, AKThe pilot’s loss of control on go-around in gusting crosswind conditions. Contributing to accident was the pilot’s decision to attempt to land at a short off-airport landing site with a malfunctioning airspeed indicator.NTSB CEN21LA413Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Stow, OHThe airplane’s impact with a deer during a night landing.NTSB CEN21FA380Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Adrian, MOThe pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and impact with terrain.NTSB ANC21LA071Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-14 · Tyonek, AKThe pilot’s failure to maintain directional control and adequate airspeed during takeoff which resulted in a collision with a river. Contributing to the accident was the pilot’s improper decision to load the airplane above its maximum allowable gross weight.NTSB WPR21LA316Accident · No injuriesClass 3 · LimitedFinal reportBeech 77 · Stanley, NMA loss of engine performance due to lead fouling of the lower spark plugs, which resulted in an off airport forced landing.NTSB CEN21LA311Accident · Minor injuriesClass 4 · LimitedFinal reportEslinger C W/Eslinger S M Cassutt · Pryor, OKThe pilot’s high flare and failure to execute a go-around which resulted in a hard landing and runway excursion.NTSB ERA21FA274Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · St. Augustine, FLThe flight instructor’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall during the landing approach.NTSB CEN21FA290Accident · 2 fatalClass 3 · FieldFinal reportAmerican AA-1A · Cleburne, TXThe canopy moving fully open during flight, which resulted in the pilot’s distraction and a subsequent aerodynamic stall/spin and loss of control.NTSB WPR21FA232Accident · 1 fatalClass 3 · FieldFinal reportKitfox Series 6 · Likely, CAThe pilot’s poor decision making in attempting a takeoff from a field with high vegetation and a high-density altitude, which resulted in decreased takeoff performance and impact with terrain.NTSB CEN21LA278Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Bridgeport, TXThe pilot’s inaccurate estimate of the fuel level during his preflight inspection, which resulted in fuel exhaustion during cruise flight and a total loss of engine power.NTSB WPR21LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Coeur d' Alene, IDThe student pilot’s failure to maintain directional control during the landing roll, and the flight instructors delayed remedial action which resulted in a runway excursion and collision with terrain.NTSB ANC21LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Gakona, AKThe pilot’s decision to initiate a flight with a failed mixture control cable which resulted in a total loss of engine power.NTSB CEN21LA204Accident · 1 fatalClass 3 · LimitedFinal reportPiper J3C-65 · Slaughter, LAA total loss of engine power for reasons that could not be determined from the available evidence.NTSB WPR21LA118Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-1B · St Johns, AZThe pilot’s decision to operate with a demonstrated crosswind velocity above the airplane’s performance capabilities which resulted in a loss of airplane control and collision with terrain.