NTSB investigations: Lycoming 0-540 series
92 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of control - in flight”. 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 LAX94FA058Accident · 3 fatalField investigationFinal reportSiai-Marchetti F-260 · Santa Monica, CAthe dual student pilot's failure to maintain minimum air speed in flight which resulted in an inadvertent stall/spin. Contributing to the accident was the improper weight and balance, inadequate altitude, and inadequate supervision.NTSB FTW93FA132Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Henryetta, OKThe pilot's decision to fly into known adverse weather conditions and the ensuing spatial disorientation. Factors were the weather, and the pilot's decision to fly into IMC with inadequate flight and navigational equipment installed in the aircraft.NTSB NYC93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Pulaski, VAThe improper decision by the non-instrument-rated pilot to continue VFR flight into known instrument meteorological conditions resulting in spatial disorientation and loss of control of the airplane. Factors which contributed to the accident were the actions…NTSB CHI92DTK01Accident · 1 fatalFinal reportPiper PA-25-235 · Iroquois, SDAn improper maneuver and failure to attain level off by the pilot in command while performing aerial application.NTSB LAX92FA151Accident · 1 fatalField investigationFinal reportPiper PA 28-236 · Lebec, CAThe pilot's delayed inflight decision to reverse course to avoid forecast adverse weather conditions. Contributing to the accident was icing conditions and lightning.NTSB DEN92LA031Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Durango, COThe pilot's failure to maintain directional control. A factor was: crosswind.NTSB LAX91LA304Accident · 1 fatalLimited investigationFinal reportPiper PA24-250 · Temple Bar, AZThe pilot's failure to maintain control of the aircraft during an attempted return to runway maneuver and the entry into an inadvertent stall/spin at low altitude. The exact nature of the emergency problem encountered by the pilot is undetermined.NTSB MIA91FA155Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Long Boat Key, FLAn inflight loss of control and subsequent collision with the water for unknown reasons.NTSB ATL91LA048Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Lumberton, NCThe pilot suffered a stroke and lost control of the airplane on final approach.NTSB DEN91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sherman, TXA pilot induced inadvertent stall.NTSB MIA90LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Fajardo, PRFailure of the pilot to maintain vso during the takeoff climb, resulting in the loss of control.NTSB FTW90FA037Accident · 2 fatalField investigationFinal reportChristen Industries Pitts S-2B · La Junta, TXThe pilot's delayed remedial action to recover from the spin and his misjudging of altitude.NTSB MKC89DCA01Accident · 1 fatalFinal reportPiper PA-25-235 · Auxvasse, MOThe pilot-in-command's failure to maintain adequate airspeed, resulting in an inadvertant stall.NTSB BFO89LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Warrenton, VAThe failure of the glider pilot to maintain a proper climb rate during takeoff and the delay in releasing from the towplane after realizing that he was climbing well above the towplane. Contributing to the accident was the updraft encountered after takeoff…NTSB NYC88DFJ04Accident · Serious injuriesFinal reportCallair A-9 · Churchville, NYThe pilot was engaged in aerial application activities. When he started a turn at low altitude to align himself for another spray run the aircraft stalled and struck the terrain.NTSB LAX88FA312Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Camarillo, CAThe pilot decided to operate the aircraft with a known electrical deficiency during night instrument meteorlogical conditions and the decision of the pilot to conduct a flight operation in which he was not certified. Contributing to this accident was the…NTSB BFO88FA068Accident · 2 fatalField investigationFinal reportCessna R182RG · Stevensville, MDThe acft departed bay bridge arpt at aprx 0415 EDT. The passenger, also a plt, was reading back an IFR clearance to ATC when communication ended in the middle of a sentence without any sign of distress. Comparison of ATC and radar tapes indicates that N9997C…NTSB MKC87DPG02Accident · Serious injuriesFinal reportPiper PA-25-235 · Hazen, ARThe pilot stated to a witness that after coming out of his 2nd pass, in the last 1/3 of his procedural turn, the plane stalled and the right wing struck a telephone wire which caused it to swing onto a gravel road. It hit left wing/nose down, bounced, and…NTSB DEN87LA114Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Valley City, NDThe commercial pilot was trying out an acft with the stated intention of leasing it. A takeoff was planned from a stretch of gravel road. During the takeoff ground run, the acft became airborne then touched down in a field, bounced across an intersecting road…NTSB LAX87DVA04Accident · No injuriesFinal reportHiller OH-23G · Delano, CADuring an aerial application flight, the pilot returned to the loading truck for approximately 5 additional gallons of chemical to finish the application. The loader; however, loaded 70 gallons and when the pilot took off the rotor RPM began to bleed off. The…NTSB ANC86LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Stoney River, AKThe pilot stated that after liftoff he failed to maintain airspeed. The aircraft stalled and crashed into the River.NTSB SEA86FA203Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Grangeville, IDA passenger in the acft reported the plt made more than one pass over 'a salt lick', each time coming closer and closer to the trees. On the last pass the acft 'just fell out of the sky', hit the trees, and landed upside down. Fire broke out almost…NTSB CHI86FEM10Accident · Minor injuriesFinal reportPiper PA-25-235 · Ionia, MIDuring initial banner pick-up of a banner towing operation the tow cable fouled the rudder control mechanism. The rudder was jammed and the banner release mechanism failed to operate. The aircraft impacted the ground left wing first and was substantially…NTSB CHI85LA372Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Washington, ILThe plt attempted to takeoff on the 1800 ft long grass airstrip with 3 passengers on board. A 90 deg, 12 kt x-wind was present and the OAT was 91 deg f. after liftoff, the acft settled back on the airstrip and continued off the end into a bean fld where the…NTSB FTW85FQG03Accident · 1 fatalFinal reportPiper PA-25-235 · Morton, TXAfter the plt completed a swath run, the acft entered a rgt climbing maneuver, then rolled wings level. After that, it reportedly began an abrupt climb for aprx 50 to 60 ft, then nosed down & crashed in a steep descent. After impact, the acft was destroyed by…NTSB SEA85LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Cold Meadows, IDThe plt was attempting to land on an airstrip with a density alt of 9000 ft. during a go-around the acft was unable to out climb rising terrain due to the density alt. A departure stall into trees resulted. A post-impact fire destroyed the acft. The plt…NTSB MKC85LA173Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Norcatur, KSThe acft had been spraying for 40 minutes at 2500 ft MSL with a density alt of aprx 4600 ft when it stalled during a turnaround. It then impacted an electric pwr pole followed by the terrain.NTSB LAX85LVA01Accident · No injuriesFinal reportPiper PA28-236 · Porterville, CAWhile on final apch to rwy 30 at Porterville arpt, and as the acft flared for landing, the left wheel and left wing touched the rwy, and the acft bounced into the air, stalled, and crashed just left of the rwy. The plt stated, 'a gust of wind pitched the nose…NTSB NYC85FA029Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Atlantic City, NJThe aircraft was observed in close proximity to another aircraft in the traffic pattern. The pilot extended the downleg leg leg. During the turn to align the aircraft with the runway the pilot suffered a disabling heart attack. Unable to recover the aircraft…NTSB CHI84LA386Accident · No injuriesLimited investigationFinal reportPiper PA25 · Sheboygan, WIPlt initiated takeoff in strong gusty x-wind. Approaching tree line, acft began to sink. Plt turned to avoid trees and stalled acft. Load jettison was too late to aid in stall recovery and acft mushed into ground.NTSB MKC84FCD02Accident · Serious injuriesFinal reportCallair A-9 · Oakland, IAThe pilot was practicing aerial application maneuvers using water as the spray load. He stated that about half way thru his turn to reverse direction, he felt the a/c give a very slight stall warning. He said that he released some back pressure and attempted…NTSB MIA84LA182Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ft. Lauderdale, FLPlt witnesses reported that the acft stalled during the final approach. The plt was not multi-end rated.NTSB MKC84FA164Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Satanta, KSAfter making a swath run, the plt initiated a turn-around in a downwind direction. During the turn, a wing dropped & the acft entered a descent & struck the ground, nose 1st. It then bounced & traveled another 53 ft before stopping & bursting into flames. The…NTSB SEA84FA058Accident · 3 fatalField investigationFinal reportPiper PA-28-J3A5D · Mountaindale, ORThe acft crashed during an instrument approach to hillsboro airport. Witnesses reported seeing the acft below a very low overcast sky condition prior to impact. Examination of the wreckage revealed that the stabilator failed in overload before the point of…NTSB ANC84LA034Accident · Serious injuriesLimited investigationFinal reportHelio H-250 · Iliamna, AKAccording to witnesses, the ski equipped acft took off toward the north. They reported that after taking off, the acft made a tight left turn, then spiraled to the ground. They estimated that the maximum alt was aprx 150 ft. also, they reported that the eng…NTSB NYC84FA053Accident · 2 fatalField investigationFinal reportCessna R182 · Greenwich, CTThe acft collided with trees during an ILS approach to westchester arpt in NY. The weather was IMC and an IFR flt plan was filed. The accident occurred during the 2nd attempt with the 1st ending in a missed approach. It was apparent to thecontroller that the…NTSB CHI84LA048Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Norwalk, OHThe acft made a hard landing while on a cross-country flt. The plt stated that he encountered turbulence below 3000 ft MSL. During the he encountered wind shear which caused him to drop 40 ft onto the rwy. The acft manual states that 'in high wind conditions…NTSB LAX83LA421Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Clearlake, CADuring arrival, the plt made an apch to rwy 30 at night in calm wind conditions. He reported that on final apch, he allowed the airspeed to get low & the acft stalled and struck the ground approximately 300 feet short of the rwy. The rwy was equipped with…NTSB LAX83LA389Accident · Serious injuriesLimited investigationFinal reportPiper PA25-235 · Somerton, AZThe acft collided with the ground during a turn in turbulent air to abort an aerial application mission because of weather. The pilot stated that he had made two passes at the field he was spraying when he noticed the flagman and farmers waving him off due to…NTSB ATL83LA269Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Hopeful, GAThe acft collided with the ground during a turn around while conducting an aerial application operation. The pilot was spraying soy beans and was performing a turn when he stalled the acft without sufficient alt to recover. The pilot said there was no problem…NTSB MIA82FKJ05Accident · 1 fatalFinal reportPiper PA-25 · Jay, FLThe acft stalled during a spraying operation. The plt received his private pilot's certificate approximately four months prior to the accident. He had no flt time logged in a PA-25 & no information could be found to indicate the plt had received any…NTSB FTW82DPG16Accident · Minor injuriesFinal reportCallair A-9 · Hollygrove, ARThe pilot departed the Hollygrove flying service airport, made an immediate left turn, and sank into the trees east of the airport. He managed to dump the full load of chemicals before impact with the trees. The aircraft gave no indicationof any mechanical…