NTSB investigations: Lycoming 0-360-A1D
256 cases on aircraft whose registry engine model is Lycoming 0-360-A1D. 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 ('41504'))
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 ('41504'))
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 ERA14LA382Accident · Minor injuriesLimited investigationFinal reportJackson Jeremiah D Vans RV6A · West Palm Beach, FLThe pilot’s excessive landing speed, which resulted in a runway excursion and noseover. Contributing to the accident was a partial loss of engine power during an attempted go-around for reasons that could not be determined because no anomalies were identified…NTSB ANC14CA061Accident · No injuriesData collectionFinal reportAviat A 1 · Ketchikan, AKThe pilot's decision to takeoff from a remote mountain lake in variable wind. Contributing to the accident was the pilots delayed decision to abort the takeoff.NTSB WPR13LA336Accident · No injuriesLimited investigationFinal reportWester/Steiger Glastar · Independence, ORThe total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB ERA13LA238Accident · No injuriesLimited investigationFinal reportSteele Ralph Bruce Steen Skybolt · Windsor, NCThe pilot's decision to initiate an aerobatic maneuver with insufficient altitude to recover before ground impact.NTSB WPR12FA420Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Strawberry, AZThe flight instructor's and the evaluator's failure to divert at an appropriate time during cruise flight, which resulted in the airplane's inability to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was the flight…NTSB ERA12FA514Accident · 2 fatalField investigationFinal reportSocata TB 10 · Shirley, NYThe pilot/owner's operation of the airplane with known deficiencies, and the mechanic's failure to reattach the mixture control cable to the mixture control arm following maintenance of the carburetor.NTSB WPR12LA146Accident · No injuriesLimited investigationFinal reportJacobs RV-6A · Bow, WAThe total loss of engine power due to fuel starvation as a result of the pilot’s mismanagement of the fuel supply.NTSB CEN12LA087Accident · No injuriesLimited investigationFinal reportAviat A-1B · Gainesville, TXThe right main gear tire contacting the brake caliper, which resulted in an uncommanded brake effect on the wheel.NTSB CEN12CA075Accident · No injuriesData collectionFinal reportGlobe GC-1B · Denver, COA loss of engine power due to fuel starvation as a result of a loose fuel line fitting.NTSB ERA11LA403Accident · Serious injuriesLimited investigationFinal reportMurphy Elite · Batavia, NYThe pilot's failure to maintain control of the airplane during takeoff.NTSB ANC11CA054Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Nikiski, AKThe pilot's improper use of brakes during landing.NTSB WPR11LA207Accident · No injuriesLimited investigationFinal reportDavison RV-7A · Marsing, IDA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA11CA250Accident · No injuriesData collectionFinal reportAviat A-1B · Burgaw, NCThe pilot's inadvertent application of brakes during the landing rollout.NTSB ERA11CA134Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Sebago Lake, METhe pilot’s initiation of a right turn with insufficient altitude remaining during an aborted landing resulting in a collision with the landing surface.NTSB CEN11CA167Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Anoka, MNThe student pilot's control inputs that resulted in an inadvertent dynamic rollover and the CFI's inadequate supervision of the flight.NTSB WPR11CA084Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot's failure to maintain clearance from obstacles while taxiing.NTSB ANC10TA080Accident · No injuriesFinal reportAviat A-1B · Bettles Field, AKThe pilot's selection of an unsuitable off-airport landing site for a precautionary landing.NTSB ANC10CA066Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to maintain directional control after encountering a crosswind during landing.NTSB WPR10LA370Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Walla Walla, WAThe pilot's partial incapacitation during cruise flight and his subsequent inadequate fuel management, which resulted in fuel starvation.NTSB CEN10CA350Accident · No injuriesData collectionFinal reportAviat A-1B · Idabell, OKThe pilot's failure to maintain directional control during a go-around.NTSB CEN10CA209Accident · No injuriesData collectionFinal reportTrue Flight Holdings AA-5B · Muskegon, MIThe inadvertent in-flight collision with a goose.NTSB WPR10CA088Accident · No injuriesData collectionFinal reportAviat A1-A · West Jordon, UTThe pilot's failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB ANC09TA092Accident · No injuriesFinal reportAviat A-1B · Gulkana, AKThe pilot's excessive use of brakes during an off-airport landing, resulting in the airplane nosing over.NTSB WPR09CA406Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s inadequate compensation for the crosswind condition and failure to maintain directional control during landing.NTSB WPR09CA375Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Troutdale, ORThe flight instructor's failure to maintain adequate main rotor RPM.NTSB CEN09LA311Accident · 2 fatalLimited investigationFinal reportThornton RV-6A · Plainwell, MIThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB WPR09LA153Accident · 1 fatalLimited investigationFinal reportHowes RV-6 · Paulden, AZA total loss of engine power due to oil starvation as a result of a leak from the inadequate weld repair of a high-pressure oil line. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering that resulted in a stall during an…NTSB CEN09FA147Accident · 1 fatalField investigationFinal reportMooney M20C · Elbert, COThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent loss of control.NTSB WPR09LA032Accident · 1 fatalLimited investigationFinal reportUniversal Globe · Wallace, CAThe pilot's incapacitation during cruise for unknown reasons that resulted in a loss of aircraft control.NTSB WPR09CA023Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Temecula, CAThe certified flight instructor's failure to maintain adequate rotor rpm during a simulated approach to landing under variable wind, and high density altitude conditions.NTSB DFW08CA227Accident · No injuriesData collectionFinal reportCessna 172RG · Almogordo, NMThe pilot's failure to extend the airplane's landing gear before landing.NTSB DEN08CA146Accident · No injuriesData collectionFinal reportHelie RV-6 · Denver, COThe pilot failed to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB DFW08CA180Accident · Minor injuriesData collectionFinal reportMooney M20 · Rogers, ARThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning/decision.NTSB LAX08CA199Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot's inadequate recovery from a bounced landing and failure to maintain directional control.NTSB DFW08CA124Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Rifle, COThe pilot's failure to maintain control of the airplane on landing. A factor was the crosswind and wind gusts.NTSB LAX08CA076Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was the crosswind condition.NTSB DFW08CA042Accident · No injuriesData collectionFinal reportVans RV-6 · Stringer, MSThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA08LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Phoenix, AZThe failure of the solo student pilot operating the other airplane to maintain clearance while taxiing for takeoff.NTSB MIA08FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Walthourville, GAThe non-instrument rated pilot's loss of control at night in marginal night VFR operations due to spatial disorientation. A factor in the accident was the pilot's improper decision to continue the flight.NTSB CHI07CA269Accident · No injuriesData collectionFinal reportAviat A-1 · Kellys Island, OHThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the pole, hangar, and crosswind.NTSB ATL07CA091Accident · No injuriesData collectionFinal reportBeech C-23 · Plainville, CTThe pilot's improper use of rudder and brakes on landing roll out resulting in a loss of directional control, and collapse of the main landing gear.NTSB DFW07LA124Accident · 1 fatalLimited investigationFinal reportAdams RV-6A · Boerne, TXThe pilot's failure to maintain the best angle of climb speed resulting in an inadvertent stall. A contributing factor was the high density altitude.NTSB SEA07LA249Accident · 1 fatalLimited investigationFinal reportCessna 177 · Pinecliff, WAThe pilot's failure to maintain clearance from the trees while maneuvering in mountainous terrain. Factors include the mountainous terrain, low ceilings, and trees in the area where the pilot was maneuvering.NTSB NYC07CA120Accident · Serious injuriesData collectionFinal reportMaule MXT-7-180A · St Petersburg, FLThe pilot's failure to obtain the proper climb rate to clear an obstacle after aborting the landing. Factors in the accident were the pilot's failure to maintain directional control during landing, which prompted the aborted landing, and a wind gust.NTSB CHI07LA121Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Sidney, OHThe total loss of engine power during initial climb due to oil starvation as a result of improper maintenance. The fixed base operator's failure to advise the pilot that the engine had been operated without oil in the engine and soft terrain were factors.NTSB SEA07LA062Accident · No injuriesLimited investigationFinal reportCessna 172RG · Daytona Beach, FLThe fracture and failure of the right landing gear actuator, which resulted in a gear collapse during the landing roll.NTSB MIA07LA026Accident · No injuriesLimited investigationFinal reportLingwall Rebich-Pitts · Naples, FLThe experimental airplane's pilot inadequate visual lookout while taxiing for takeoff, which resulted in an on-ground collision with a Piper airplane which was standing with its engine operating in the runup area.NTSB DEN06LA113Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Santa Fe, NMthe pilot's improper decision to continue the attempted takeoff when Vx airspeed was not obtained, and failure to abort the takeoff during ground roll which resulted in an impact on the remaining runway with the landing gear retracted. A contributing factor…NTSB NYC06LA193Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Egg Harbor Twp, NJThe pilot's failure to utilize carburetor heat during the descent, which resulted in the formation of carburetor ice and subsequent engine failure. A factor in the accident was the carburetor icing conditions.NTSB ATL06LA110Accident · 1 fatalLimited investigationFinal reportArter RV6 · Hartselle, ALThe pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and collision with trees and the ground. Factor in the accident were the pilot's ostentatious display and impairment due to alcohol.