NTSB investigations: Lycoming 0-540 series
3,541 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, newest first
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 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 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 ATL04CA160Accident · No injuriesData collectionFinal reportPiper PA 25 · Foley, ALThe pilot's failure to maintain airspeed during climbout which resulted in a stall while maneuvering to pick up a banner.NTSB LAX04CA263Accident · No injuriesData collectionFinal reportCessna R182 · California City, CAthe pilot's failure to lower the landing gear. A contributing factor was the pilot's distraction while on final approach.NTSB SEA04LA118Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Miles City, MTThe pilot's failure to maintain directional control of the aircraft during the landing roll resulting in a main landing gear collapse.NTSB ATL04CA135Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Gulf Shores, ALThe pilot's failure to maintain airspeed that resulted in a stall and the subsequent collision with the ground.NTSB IAD04FA025Accident · 2 fatalField investigationFinal reportRobinson R-44 · Killingly, CTThe pilot in command's intentional flight into instrument meteorological flight conditions, and his failure to maintain obstacle clearance which resulted in a controlled descent into trees. Factors included the pilot's inadequate weather evaluation, low cloud…NTSB LAX04LA240Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's failure to maintain a proper pitch attitude during tow operations and his failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.NTSB CHI04CA139Accident · No injuriesData collectionFinal reportCessna TR182 · Hamberg, NDThe pilot's inadequate in-flight planning/decision and his misjudgment of speed and distance.NTSB DEN04CA073Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Flagler, COthe pilot's improper in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Factors contributing to the accident were the low altitude, low airspeed, and the inoperative fuel quantity gauge.NTSB MIA04FA086Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Venice, FLFailure of the pilot to recover from an improper landing flare resulting in his failure to maintain airspeed (Vs), an inadvertant stall, loss of control, and inflight collision with terrain during an uncontrolled descent.NTSB IAD04FA017Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · North Lima, OHThe pilot's failure to maintain a safe altitude clearance from trees. Factors included the night lighting conditions and the pilot's diminished night vision capability.NTSB ANC04LA043Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · West Palm Beach, FLThe incorrect assembly of the fuel selector valve by maintenance personnel, and the pilot's failure to make a precautionary landing to assess the fuel situation and lack of movement of the right fuel tank indicator. which resulted in fuel starvation and the…NTSB MIA04LA061Accident · No injuriesLimited investigationFinal reportRobinson R44 · Ocala, FLThe failure of the pilot to maintain control of the helicopter following a reported loss of engine power after picking up to a hover from a dolly.NTSB SEA04LA056Accident · No injuriesLimited investigationFinal reportCessna R182 · Bremerton, WAThe pilot's failure to maintain directional control which resulted in a loss of control and subsequent wing strike with terrain. A contributing factor was the soft terrain.NTSB CHI04LA078Accident · No injuriesLimited investigationFinal reportCessna R182 · Elberfeld, INThe in-flight and on-ground fires in the cabin and engine compartment for undetermined reasons during the flight's cruise and emergency landing.NTSB NYC04LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Collegeville, PAThe pilot's failure to maintain clearance from trees during approach to the runway. Factors in the accident were the dark night and snowbank.NTSB FTW04LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Knox City, TXThe pilot's attempt to land on terrain not suitable for landing. A contributing factor was the soft terrain.NTSB FTW04FA057Accident · 1 fatalField investigationFinal reportCessna 182RG · El Dorado, ARThe loss of engine power as a result of loss of engine oil due to the failure of the oil filter converter plate gasket and the noncompliance to an airworthiness directive. Contributing factors were the lack of suitable terrain for the forced landing and the…NTSB MIA04CA041Accident · No injuriesData collectionFinal reportMaule M-7-235B · Fort Lauderdale, FLThe pilot's failure to maintain aircraft control. A factor in this accident was the improper use of full flaps.NTSB CHI04FA044Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Brooklyn, IAThe pilot's inadequate planning/decision resulting in VFR flight into IMC, and his failure to maintain terrain clearance resulting in in-flight collision with terrain. Contributing factors to the accident were the pilot's lack of an instrument rating, his…NTSB ANC04LA014Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Larson Bay, AKThe loss of engine power for an unknown reason while maneuvering, which resulted in the pilot ditching the airplane. Factors contributing to the accident were a low ceiling and a snow squall.NTSB NYC04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kutztown, PAThe pilot's inadvertent retraction of the landing gear on the ground.NTSB FTW04LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sweetwater, TXthe loss of engine power due to a failure of the crankshaft bolt. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL04LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Troy, ALThe certified flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation resulting in a forced landing, in-flight collision with trees and ground.NTSB LAX04LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mesa, AZthe pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall. Also causal, was the pilot's inadequate preflight and failure to secure the right side of the engine cowling prior to departure.NTSB DEN03LA156Accident · No injuriesLimited investigationFinal reportCessna R182 · Cedar City, UTthe nose wheel separating from the airplane during the precautionary landing. Factors contributing to the accident were the missing nose gear axle through-bolt and the missing cotter pin.NTSB CHI03LA315Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Chanute, KSThe pilot 's inadequate in-flight planning/decision which resulted in both his in-flight encounter with weather, and the loss of power due to fuel exhaustion. Factors associated with the accident were the night conditions, fog, and the pilot becoming lost and…NTSB MIA03LA177Accident · Minor injuriesLimited investigationFinal reportBritten-Norman BN-2A-27 · Cayey, PRThe loss of power on the left engine and partial lost of power on the right engine for undetermined reasons resulting in a force landing and impact with wires, tree, and terrain during subsequent force landing.NTSB CHI03LA272Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Brandon, WIThe pilot failed to maintain clearance from the corn crop during an aerial application maneuver. Additional factors were the terrain induced turbulence and the corn crop.NTSB MIA03LA162Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · West Palm Beach, FLThe poor judgment by the pilot-in-command of the airplane for his initiation of takeoff after the helicopter pilot had announced intention to perform a 180-degree autorotation to the runway, and the failure of both pilots to maintain visual lookout resulting…NTSB CHI03LA263Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Sparta, MIThe loss of engine power due to fuel exhaustion and the inadvertent stall/spin encountered. The inadequate fuel supply, airspeed not being maintained, low altitude, and terrain were factors to the accident.NTSB CHI03LA258Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Litchfield, ILAn animal wandered onto the runway and collided with the airplane. A factor was the night light condition.NTSB ATL03LA123Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Greenville, NCThe pilot's failure to maintain directional control after an aborted landing and subsequent collision with an airport runway sign.NTSB CHI03LA227Accident · 1 fatalLimited investigationFinal reportUllrich Auriga FT · Aberdeen, SDA loss of engine power due to the lack of design fuel pressure for undetermined reasons.NTSB MIA03LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Plantation, FLThe pilot's improper preflight planning and failure to refuel before the flight, which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.NTSB CHI03FA219Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Jackson, MNThe pilot's intentional flight into terrain as an act of suicide.NTSB MIA03LA145Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Fort Pierce, FLThe pilot's failure to maintain directional control of the airplane during landing roll resulting in collision with trees after the airplane departed the runway.NTSB MIA03WA147Accident · 1 fatalForeign investigationPiper PA-23-235 · Freeport, BahamasNTSB LAX03LA235Accident · No injuriesLimited investigationFinal reportRobinson R44 · Happy Jack, AZthe partial loss of engine power due to an excessively lean mixture for undetermined reasons during cruise flight.NTSB WAS03WA014Accident · 4 fatalForeign investigationCessna 182 RG · Pianello/Carena, SwitzerlandNTSB SEA03LA120Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moses Lake, WAAn improper flare which resulted in a bounced landing during landing. The pilot's failure to maintain aircraft control and soft terrain were factors which eventually led to the aircraft nosing over.NTSB ATL03FA111Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Rockvale, TNLoss of engine power for undetermined reasons.NTSB ATL03LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Hatteras, NCThe pilot's failure to maintain directional control during the landing roll. A factor was a go-around not performed.NTSB SEA03LA098Accident · No injuriesLimited investigationFinal reportCessna R182 · Kent, WAThe failure of the flaps to operate properly for undetermined reasons during the initial climb and subsequent aborted takeoff. A factor was the collapse of the main landing gear due to an inadequate amount of time for the gear extension process to be…NTSB MIA03LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Hammock, FLThe insufficient information provided to the pilot by the mechanic that installed the auxiliary fuel tank for his failure to install a placard to indicate that both fuel on/off valves should not be on at the same time resulting in a total loss of engine power…NTSB LAX03LA190Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fallon, NVThe pilot's inadequate preflight and his mismanagement of the fuel supply by his failure to switch fuel tanks.NTSB FTW03LA163Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Brazos Blk 532undetermined, aircraft not recovered.NTSB NYC03LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA32-260 · Huntington, WVThe pilot's failure to position the fuel selector to a tank with adequate fuel for the flight, which resulted in a power loss due to fuel starvation and the subsequent forced landing.NTSB MIA03LA111Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Meade, FLThew failure of the pilot to abort the takeoff after travelling past the estimated point of liftoff, and failure of the pilot to maintain airspeed during the initial climb resulting in inadvertent stall and uncontrolled descent with subsequent impact onto the…NTSB NYC03LA093Accident · No injuriesLimited investigationFinal reportCessna R182 · Monticello, NYThe pilot's premature raising of the flaps during the aborted landing. A factor in this accident was the crosswind condition.NTSB LAX03FA142Accident · 2 fatalField investigationFinal reportCessna TR182 · Eagleville, CAthe pilot's encounter with mountain wave activity with downdrafts and severe turbulence, which resulted in a loss of airplane control and impact with terrain. Contributing to the accident was the pilot's improper decision to continue flight into an area of…