NTSB investigations: Lycoming 0-540 series, 2020
24 cases on aircraft whose registry engine model is Lycoming 0-540 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 | 146 |
|---|---|
| 1965 | 151 |
| 1966 | 150 |
| 1967 | 192 |
| 1968 | 128 |
| 1969 | 110 |
| 1970 | 110 |
| 1971 | 118 |
| 1972 | 115 |
| 1973 | 83 |
| 1974 | 98 |
| 1975 | 83 |
| 1976 | 77 |
| 1977 | 97 |
| 1978 | 78 |
| 1979 | 92 |
| 1980 | 82 |
| 1981 | 80 |
| 1982 | 58 |
| 1983 | 59 |
| 1984 | 51 |
| 1985 | 59 |
| 1986 | 29 |
| 1987 | 47 |
| 1988 | 41 |
| 1989 | 35 |
| 1990 | 39 |
| 1991 | 31 |
| 1992 | 28 |
| 1993 | 26 |
| 1994 | 41 |
| 1995 | 41 |
| 1996 | 41 |
| 1997 | 26 |
| 1998 | 30 |
| 1999 | 35 |
| 2000 | 35 |
| 2001 | 40 |
| 2002 | 52 |
| 2003 | 39 |
| 2004 | 35 |
| 2005 | 39 |
| 2006 | 43 |
| 2007 | 30 |
| 2008 | 38 |
| 2009 | 37 |
| 2010 | 28 |
| 2011 | 37 |
| 2012 | 24 |
| 2013 | 15 |
| 2014 | 31 |
| 2015 | 24 |
| 2016 | 27 |
| 2017 | 25 |
| 2018 | 25 |
| 2019 | 32 |
| 2020 | 24 |
| 2021 | 28 |
| 2022 | 25 |
| 2023 | 30 |
| 2024 | 23 |
| 2025 | 25 |
| 2026 | 23 |
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\") = 2020
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532'))
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") = 2020
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532'))
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 ERA21LA067Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Milton, FLThe pilot’s failure to attain a proper touchdown point and his landing with a high approach speed, which resulted in a runway overrun.NTSB ERA21LA049Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Lititz, PAThe pilot’s inadvertent attempt to takeoff on a taxiway, rather than a runway, which resulted in a collision with a fence during takeoff.NTSB WPR21LA021Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson R44 · Pahrump, NVThe pilot’s failure to maintain helicopter control while hovering low over a body a water while facing into the sun, which resulted in a loss of visual reference and subsequent impact with the lake surface.NTSB ERA21LA019Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Atlanta, GAA partial loss of engine power during takeoff due to a right magneto anomaly, which resulted in the pilot’s decision to abort the takeoff and the subsequent runway excursion.NTSB ERA21LA015Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Friendly, MDThe pilot’s failure to maintain control of the airplane during an aborted landing and the flight instructor’s inadequate remedial action.NTSB CEN21LA010Accident · No injuriesClass 3 · LimitedFinal reportCessna TR182 · Bridgeport, TXThe pilot’s inadequate fuel planning, which led to fuel exhaustion and a subsequent total loss of engine power.NTSB WPR20LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Island Park, IDThe pilot’s failure to maintain directional control during a crosswind landing.NTSB CEN20CA411Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna R182 · Marksville, LAThe pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.NTSB CEN20LA374Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · Walker, MNThe pilot’s impairment from the effects of an undiagnosed brain tumor.NTSB CEN20LA373Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA24 · Midland, MIThe loss of engine power due to fuel starvation.NTSB CEN20LA370Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA24 · Bryan, TXA total loss of engine power on takeoff due to fuel starvation.NTSB CEN20LA361Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Crowley, LAThe failure of the No. 4 cylinder exhaust valve that resulted in a partial loss of engine power. Based on available evidence, the reason for the failed valve was not determined.NTSB CEN20CA356Accident · No injuriesClass 4 · Data collectionFinal reportMaule M5 · Olathe, KSThe pilot's loss of directional control during landing.NTSB ERA20CA282Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA32 · Montauk, NYThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a runway excursion and collision with trees.NTSB ERA20CA267Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Indian Trail, NCThe pilot's failure to attain the proper landing approach speed and touchdown point, which resulted in a runway overrun.NTSB CEN20CA316Accident · Minor injuriesClass 4 · Data collectionFinal reportRobinson R44 · Hebron, NEA loss of engine power due to water contamination in the fuel system. Contributing to the accident was the pilot’s inadequate preflight to sump the fuel tanks prior to flight.NTSB CEN20CA302Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA28 · Grayslake, ILThe pilot’s application of the left brake during landing resulting in a runway excursion.NTSB ERA20LA247Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fort Lauderdale, FLThe failure of both pilots to see and avoid each other while taxiing, which resulted in a ground collision. Contributing to the accident was the tower controller’s failure to provide information to each pilot regarding the position and intention of the other…NTSB CEN20LA208Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Fargo, NDFailure of the engine driven fuel pump which led to a fuel leak and subsequent fire in the engine compartment.NTSB CEN20LA201Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA28 · Carlinville, ILThe pilot’s attempted recovery from a steep descent which inadvertently exceeded the ultimate load factor of the airframe and resulted in a low-level inflight breakup.NTSB ERA20LA195Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · South Boston, VAThe powerplant mechanic’s failure to properly affix the engine crankshaft gear lockplate during overhaul, resulting in a total loss of engine power.NTSB CEN20CA137Accident · No injuriesData collectionFinal reportPiper PA-28-235C · Omaha, NEThe student pilot’s improper landing flare, which resulted in a bounced landing, subsequent loss of directional control, and the airplane going down an embankment.NTSB ERA20FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · Lake City, FLThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and subsequent loss of control at low altitude.NTSB WPR20FA063Accident · 4 fatalClass 3 · FieldFinal reportCessna TR182 · Billings, MTThe pilot’s failure to maintain clearance due to poor decision making in selecting an unsafe altitude during cruise flight.