NTSB investigations: Lycoming 0-540 series, 2008
38 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\") = 2008
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") = 2008
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 CEN09CA109Accident · No injuriesData collectionFinal reportPiper PA28 · Ely, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the reduced left main landing gear wheel rotation for undetermined reasons and the snow-covered runway.NTSB ERA09WA113Accident · 12 fatalForeign investigationBritten Norman BN-2A MK III · Turks and Caicos, Turks & Caicos IslandsNTSB ERA09LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · New Bern, NCA loss of engine power for undetermined reasons.NTSB WPR09FA038Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Sedona, AZThe partial loss of engine power while maneuvering for undetermined reasons.NTSB ERA09LA051Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · San Juan, PRThe detachment of the forward left servo control tube upper rod end attachment bolt during a hover due to separation of its retaining nut for undetermined reasons.NTSB ERA09LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Plymouth, NCThe Piper Dakota (PA-28-236) pilot's failure to see and avoid the Piper Cherokee (PA-32-260).NTSB WPR09LA013Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Portland, ORAn in-flight engine fire due to the fatigue fracture of an exhaust pipe that resulted from a failure of the pipe's slip joint.NTSB NYC08LA299Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Cumberland, RIThe pilot's improper fuel management practices, which resulted in fuel starvation and a complete power loss. Contributing to the accident was the pilot's misdiagnosis of the situation, and his cessation of trouble-shooting to positively identify and correct…NTSB LAX08LA284Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spotted Bear, MTThe pilot's inadequate compensation for the variable wind conditions and failure to maintain adequate airspeed during landing.NTSB LAX08LA272Accident · 1 fatalLimited investigationFinal reportSocata Rallye 235E · San Martin, CAThe pilot's incapacitation due to severe unrecognized coronary artery disease that resulted in a loss of aircraft control.NTSB LAX08FA267Accident · 1 fatalField investigationFinal reportCessna TR182 · Sahuarita, AZThe pilot’s failure to maintain clearance from mountainous terrain while maneuvering at low altitude for undetermined reasons.NTSB CHI08CA243Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Cosmos, MNThe pilot's failure to maintain clearance from the guide wire while maneuvering on an aerial application flight. Contributing to the accident was the presence of the guide wire.NTSB NYC08CA278Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Dresden, TNThe pilot's failure to maintain the proper altitude/clearance while on final approach.NTSB LAX08LA254Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Jean, NVThe failure of both pilots to see and avoid the other aircraft while maneuvering over the airport.NTSB CHI08CA234Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Lawrenceville, ILThe pilot's misjudged application of the brakes during landing.NTSB CHI08CA206Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Lowell, MIThe inadequate preflight planning/preparation and the short field takeoff procedure not followed by the pilot. An additional cause was the delayed aborted takeoff by the pilot. A contributing factor was the trees.NTSB LAX08LA235Accident · No injuriesLimited investigationFinal reportExtra Flugzeugproduktions-und EA 300/L · San Jose, CAThe pilot of the other airplane's inadequate visual lookout and failure to maintain clearance from another airplane.NTSB MIA08CA143Accident · No injuriesData collectionFinal reportCessna TR182 · Factoryville, PAThe pilot's diverted attention while on final approach and his delay in performing a go-around during the landing roll. Contributing to the accident were sun glare and excessive airspeed.NTSB SEA08LA156Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Bend, ORThe failure of the crankshaft during cruise flight due to fatigue.NTSB DEN08CA115Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Osage Beach, MOThe pilot failed to maintain separation from the parked airplanes while taxiing at an excessive speed for the conditions. Contributing to the accident was the airport personnel's decision to park the airplanes in close proximity to the taxiway.NTSB SEA08CA152Accident · Minor injuriesData collectionFinal reportPiper PA-24-250 · Vernal, UTThe pilot's failure to verify the airplane's fuel quantity during his preflight, resulting in fuel exhaustion. Contributing to the accident was the presence of a vehicle on the road where the pilot executed his forced landing.NTSB DFW08CA160Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Amistad, NMFuel starvation while in cruise flight. Contributing to the accident were incorrect maintenance, the fuel selector movement was impeded and a plowed field.NTSB CHI08FA146Accident · 2 fatalField investigationFinal reportPiper PA28 · Hillsboro, OHThe pilot's failure to maintain control of the airplane due to an in-flight fire as a result of a corrosion hole in the muffler that was not identified by the mechanic. Contributing to the accident was the improper emergency procedure performed for an…NTSB NYC08CA192Accident · Minor injuriesData collectionFinal reportPiper PA-32-260 · Millinocket, METhe pilot’s failure to properly monitor fuel consumption during the flight.NTSB NYC08FA180Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Cruso, NCThe pilot's inadequate preflight planning and inadvertent flight into instrument meteorological conditions with moderate to severe turbulence prevailing. Contributing to the accident were the instrument meteorological conditions and turbulence.NTSB CHI08LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · New Lisbon, WIThe pilot's failure to maintain adequate altitude during a course reversal at the completion of an agricultural spray run.NTSB MIA08CA093Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Ellington, CTThe pilot's failure to perform a go-around when the airplane floated during landing.NTSB CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.NTSB LAX08WA113Accident · Minor injuriesClass 5 · ForeignCessna 182 · San Quintin, MexicoOn April 13, 2008, about 0905 Pacific daylight time, a Cessna 182, N6278T, collided with a greenhouse during the initial climb out from a private airstrip in San Quintin, Mexico. The pilot and three passengers received minor injuries; the airplane was…NTSB LAX08CA106Accident · No injuriesData collectionFinal reportMaule M-5-235C · Monroe, WAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing rollout.NTSB SEA08CA103Accident · Minor injuriesData collectionFinal reportPiper PA-28-236 · Alturas, CAThe pilot's inadequate compensation for the gusty crosswind conditions. The wind gusts were a contributing factor.NTSB LAX08CA111Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Grand Canyon, AZThe pilot's inadequate compensation for the wind conditions and delay in aborting the takeoff. Contributing to the accident were wind gusts and a crosswind.NTSB NYC08LA142Accident · No injuriesLimited investigationFinal reportPiper PA32 · New Albany, MSA loss of engine power for undetermined reasons.NTSB NYC08CA141Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Opa Locka, FLThe entanglement of the hook rope with the rudder horn during banner pickup.NTSB SEA08CA092Accident · No injuriesData collectionFinal reportPiper PA-24 · Bountiful, UTThe pilot's failure to extend the landing gear.NTSB DFW08LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Spring, TXFailure of the pilot to ensure that the fuel system was purged of water prior to flight. Contributing to the severity of injuries was the lack of shoulder restraints.NTSB DFW08LA065Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Antonio, TXSeparation of the turbocharger exhaust stack, which resulted in a loss of engine power.NTSB MIA08CA042Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Atlanta, GAThe failure of the pilot-in-command to maintain directional control of the airplane during landing.