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 CHI96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cleveland, NDfailure of the pilot to maintain sufficient altitude or clearance from trees during an aerial application operation. The wires and trees (obstructions) were related factors.NTSB FTW96LA214Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Akron, COthe pilot's failure to maintain directional control.NTSB LAX96LA195Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Adelanto, CAfuel exhaustion as a result of an improper preflight inspection and operating with a known malfunctioning fuel gauge.NTSB LAX96LA193Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Compton, CAThe pilot of the other aircraft's failure to see and avoid N6WR. A factor in the accident was the narrow, confined nature of the taxiway, which restricted the Stinson pilot's ability to perform clearing turns while taxiing.NTSB CHI96LA137Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Aitkin, MNthe pilot's improper planning/decision, which resulted in his failure (or inability) to adequately compensation for wind conditions. Factors relating to the accident were: the gusty crosswind condition and the snowbank.NTSB LAX96LA167Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Lake Havasu Cty, AZthe pilot-owner's inadequate engine maintenance which resulted in a progressive ignition failure. Factors which contributed to the accident were the dark nighttime light condition and the presence of hidden obstructions in the forced landing area.NTSB MIA96FA115Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Lakeland, FLthe pilot's failure to maintain airspeed (Vs) while turning on approach from base to final resulting in an inadvertent stall.NTSB IAD96LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Waynesville, OHThe pilot's failure to maintain control of the accident aircraft during the landing roll. Factors were the wet portion of the grass runway and the pilot's selection of a landing runway with a 10 knot quartering tailwind.NTSB FTW96LA166Accident · No injuriesLimited investigationFinal reportCessna 182RG · Welsh, LAa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the emergency landing.NTSB FTW96LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Bellville, TXthe pilot's excessive approach/landing airspeed and his failure to perform a go-around.NTSB LAX96FA130Accident · No injuriesField investigationFinal reportBellanca 7GCAA · Los Alamitos, CAthe failure of both pilots to see and avoid each other. Factors were the pilots' failure to use available radar services.NTSB LAX96LA128Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Bishop, CAfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve. The unfavorable wind condition was a related factor.NTSB MIA96IA094Incident · 1 fatalIncident investigationFinal reportPiper PA-31-310 · Charlotte, NCfatal incapacitation of the pilot due to a heart attack.NTSB MIA96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lake City, FLFailure of the pilot to select a fuel tank with adequate fuel for takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb, and improper flare by the pilot during the subsequent forced land.NTSB LAX96LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Paradise, CAThe pilot's attempted flight into known adverse weather conditions.NTSB SEA96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Camas, WAFailure of the pilot to ensure that the landing gear was extended before landing.NTSB FTW96LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Kaufman, TXThe loss of engine power due to a bent push rod and the resultant loss of oil. Factors were the cockpit smoke and the lack of suitable terrain for the forced landing.NTSB ANC96LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Nanwalek, AKThe pilot's inadequate compensation for wind conditions. A factor in the accident was the variable wind.NTSB FTW96LA031Accident · Serious injuriesLimited investigationFinal reportCessna 182TR · Boulder, COThe pilot's failure to determine the amount of fuel aboard the aircraft during preflight, and his failure to refuel the aircraft.NTSB SEA96LA013Accident · No injuriesLimited investigationFinal reportCessna TR182 · Salt Lake City, UTmaintenance personnel improperly installed a landing gear system hydraulic line and the throttle cable which resulted in chaffing and subsequent loss of hydraulic fluid disabling the landing gear extention systems.NTSB SEA96FA010Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Alta, WYthe corrosion, consequent fatigue cracking and ultimate separation of the right wing forward lift strut.NTSB MIA96LA005Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Opa Locka, FLThe pilot's failure to maintain directional control of the airplane on landing resulted in a loss of control, sliding off the runway into a rock collapsing the landing gear.NTSB CHI96LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Thorp, WIthe pilot's failure to abort the takeoff and the premature liftoff which resulted in an inadvertent stall. Factors relating to this accident are improper planning and decision by the pilot, and the tall, wet grass.NTSB ATL96LA003Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Shores, ALLoss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.NTSB SEA95LA225Accident · No injuriesLimited investigationFinal reportCessna TR182 · Richfield, IDThe instructor's failure to use carburetor heat during a simulated engine-out descent. Carburetor icing conditions was a factor.NTSB CHI95LA332Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ludington, MIfuel exhaustion resulting from the pilot's inaccurate fuel calculations and the failure to refuel the airplane prior to takeoff. An additional cause was the stall/mush during the forced landing.NTSB CHI95LA340Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235B · Highland, ILa communication misunderstanding between the tow pilot and the glider pilot. Factors related to the accident were: the tow rope becoming entangled, excessive taxispeed by the tow pilot, and the unavailability of a dispatcher.NTSB LAX95LA348Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Marana, AZthe pilot misjudged clearance from the power lines.NTSB SEA95LA216Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moab, UTThe pilot-in-command's landing long, precluding a go-around and not maintaining a proper descent rate. Factors were trees and the crosswind.NTSB FTW95LA387Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Cibolo, TXThe pilot's improper planning/decision and failure to abort the takeoff, while there was sufficient runway remaining.NTSB SEA95FA199Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Sheridan, WYfuel starvation for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB SEA95LA195Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Ogden, UTthe pilot's failure to use brakes to maintain directional control following a tailwheel steering malfunction. Partial failure of the tailwheel steering system contributed to the accident.NTSB CHI95LA245Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Oklee, MNthe pilot failed to maintain clearance with trees. Factors associated with the accident were the trees and the pilot's diverted attention.NTSB NYC95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Poestenkill, NYthe pilot's decision to continue an approach during which the airplane was high and fast, and his improper recovery from a bounced landing. The pilot's failure to use the seat belt was a factor.NTSB FTW95LA314Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Center, COImproper recovery from a bounced landing by the pilot-in-command. A factor was a premature landing flare.NTSB FTW95LA304Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Stratton, COThe pilot's excessive rate of descent as he initiated the swath run and operation of the aircraft over the maximum allowable gross weight.NTSB MIA95WA179Accident · 1 fatalForeign investigationAero Commander 500 · Treasure Cay, BahamasNTSB LAX95LA253Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Maricopa, AZan undetermined internal failure of the carburetor.NTSB FTW95LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Farmington, NMThe pilot's failure to verify the fuel tank selector position and the resultant fuel starvation induced power loss.NTSB ANC95LA088Accident · No injuriesLimited investigationFinal reportMaule M-5-235 · Palmer, AKThe excessive airspeed maintained by the pilot during the approach and landing, and the pilot's failure to abort the landing, while there was still sufficient runway remaining. A factor relating to the accident was: the pilot's lack of experience in the type…NTSB ATL95LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Summerville, SCThe disconnected carburetor mixture control linkage that resulted in a loss of engine power, and the subsequent collision with trees.NTSB MIA95FA145Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Gainesville, FLThe pilot's loss of aircraft control due to spatial disorientation after continuing the VFR flight into instrument meteorological conditions. Factors relating to the accident were: the existing weather conditions and dark night that contributed to the pilot's…NTSB ATL95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Columbia, SCThe misalignment of the nose gear centering track and roller assemblies which precluded landing gear extension.NTSB MIA95LA144Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Vieques, PRUndetermined.NTSB NYC95LA130Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ashland, VAa loss of engine power due to a subsurface fatigue crack in the crankshaft which led to failure of the crankshaft.NTSB NYC95LA112Accident · Minor injuriesLimited investigationFinal reportHelio H-250 · Clarkson, NYFailure of the engine fuel pump, which resulted in fuel starvation and loss of engine power over an unsuitable landing area. Factors relating to the accident were: the airplane manufacture did not list the use of the installed electric boost pumps, nor did…NTSB ANC95LA055Accident · No injuriesLimited investigationFinal reportMaule M-5-235-C · Anchorage, AKA loss of engine power for an undetermined reason. A factor in the accident was the unsuitable terrain.NTSB MIA95LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · N. Miami Beach, FLInadequate annual inspection by maintenance personnel for failure to identify a hardened oil hose from the oil pump to the oil cooler inlet inside a protective fire sleeve. Additionally, unsuitable terrain encountered during the forced landing contributed to…NTSB SEA95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Anaconda, MTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain clearance from terrain.NTSB FTW95LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · San Antonio, TXThe loss of engine power due to fuel exhaustion as result of a fuel line connector leak. A factor was the lack of suitable terrain for the forced landing.