NTSB investigations: Lycoming I0360 series
2,882 cases on aircraft whose registry engine model is Lycoming I0360 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 ('41515'))
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 ('41515'))
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 SEA97LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Pocatello, IDinadequate remedial action of the pilot-in-command (CFI). Related factors include: the dual student's failure to maintain the proper airspeed and descent rate.NTSB LAX97LA188Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Henderson, NVthe pilot's attempt to land the aircraft under crosswind conditions that exceeded the performance capability of the aircraft.NTSB NYC97LA089Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Pottstown, PAwas the flight instructor's diverted attention while standing on the wing behind a turning propeller, which resulted in his departure from the wing, forward into the turning propeller.NTSB SEA97FA106Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Tigard, ORThe pilot's failure to properly manage the aircraft fuel supply, which led to fuel exhaustion of the right tank and subsequent fuel starvation/power loss of the engine during the final approach. Factors contributing to the accident were the lack of sufficient…NTSB FTW97LA153Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Marietta, OKThe pilot's inadequate short field takeoff. A factor was the pilot's lack of recent experience in short field takeoffs from a grass/turf runway.NTSB LAX97LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Continental, AZloss of engine power as a result of detonation in the number 2 cylinder for undetermined reasons. A factor in the accident was the unsuitable nature of the forced landing area.NTSB FTW97LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Thibodaux, LAThe failure of maintenance personnel to comply with an airworthiness directive which specified the correct type of oil quick drain valve for this airplane, the installation of an incorrect oil quick drain valve by maintenance personnel, and the subsequent…NTSB LAX97WA109Accident · No injuriesForeign investigationPiper PA-28 · Mulege, MexicoNTSB CHI97LA055Accident · No injuriesLimited investigationFinal reportBeech D95A · Olathe, KSthe pilot improperly selecting the 'off' position on the left engine fuel selector valve, his failure to verify the fuel selector valve's proper position prior to landing, and his inability to obtain best rate-of-climb single-engine speed.NTSB ATL97LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lebanon, TNThe pilot's improper short, soft field takeof. A factor was the pilot's poor in-flight decision to operate over an overcast until near the airplane's maximum endurance.NTSB ATL97LA025Accident · No injuriesLimited investigationFinal reportBeech BE-24R · Doraville, GAThe loss of engine power for undetermined reasons.NTSB ATL97LA020Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · St. Petersburg, FLFuel exhaustion for undetermined reasons.NTSB NYC97LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Norwood, MAfailure of the pilot to perform a go-around, when an animal obstructed the runway; and his failure to maintain clearance from an obstruction (VASI). Factors relating to the accident were: darkness, an animal (deer) on the runway, and the proximity of the…NTSB LAX97FA032Accident · 5 fatalField investigationFinal reportPiper PA-34-200 · Halawa, HIthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his failure to maintain sufficient clearance and/or altitude from mountainous terrain. Factors related to the accident were: darkness, adverse weather conditions, and…NTSB ATL97LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Olive Branch, MSThe farmer's failure to maintain security of his livestock/animals.NTSB CHI96LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Chesterfield, MOimproper flare by the dual student during the landing, and delayed remedial action by the flight instructor (CFI).NTSB NYC96LA186Accident · No injuriesLimited investigationFinal reportMooney M20K · Islip, NYloss of engine power for undetermined reason(s), which resulted in an emergency/wheels-up landing.NTSB NYC96WA191Accident · 1 fatalForeign investigationLake LA-4 · Azores, PortugalNTSB LAX96LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oxnard, CAthe instructor's inadequate supervision of the flight, and his delay in taking the controls and initiating a go-around. The student pilot's failure to maintain runway alignment and the proximity of the runway remaining marker were related factors.NTSB FTW96LA375Accident · No injuriesLimited investigationFinal reportHughes 269B · Frisco, TXThe pilot's improper touchdown procedure.NTSB SEA96LA204Accident · No injuriesLimited investigationFinal reportPrice Acro Sport II · Coeur D'Alene, IDthe pilot's improper inflight planning/decision, and his failure to properly monitor (manage) the fuel supply, which resulted in fuel exhaustion and a subsequent forced landing. Soft terrain in the forced landing area was a related factor.NTSB IAD96LA135Accident · No injuriesLimited investigationFinal reportMooney M20F · Hanover, PAthe pilot's delay in aborting the landing. Factors related to the accident were: the lack of braking action on the wet grass runway, the pilot's lack of experience in the make and model of airplane, and the sign near the departure end of the runway.NTSB MIA96LA205Accident · No injuriesLimited investigationFinal reportHampson Velocity · Dublin, GAthe failure of the exhaust of the cylinder Nos. 2 and 4 at each exhaust flange for undetermined reasons. The unsuitable terrain encountered during the forced landing was a factor.NTSB FTW96LA305Accident · No injuriesLimited investigationFinal reportStol UC-1 · Princeton, TXimproper adjustment of the left propeller governor which resulted in uncommanded feathering of the left propeller. Factors were: the airplane's inadequate engine out performance and the lack of suitable terrain for the forced landing.NTSB LAX96LA347Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Palm Springs, CAthe failure of a propeller blade as a result of undetected in-service mechanical damage that caused a stress point that progressed to a point of failure.NTSB LAX96LA256Accident · No injuriesLimited investigationFinal reportMooney M20E · Rio Linda, CAThe pilot's failure to attain/maintain the proper approach airspeed, his failure to attain the proper runway touchdown point, and his failure to initiate a go-around when a landing overshoot became apparent. A factor in the accident was the airport…NTSB LAX96LA242Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Avalon, CAThe failure of the left brake for undetermined reasons.NTSB SEA96FA130Accident · 1 fatalField investigationFinal reportHughes 269C · Eldon, WAfatigue failure of the connecting rod cap, which resulted in loss of engine power and ditching at sea.NTSB LAX96LA217Accident · No injuriesLimited investigationFinal reportHughes 269B · Georgetown, CAloss of engine power for undetermined reason(s), while practicing an autorotation, which resulted in a forced landing; and the flight instructor's misjudged landing flare during the emergency autorotation/landing.NTSB IAD96FA074Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Sunapee, NHthe pilot's failure to maintain control of the airplane. Factors in this accident were: the pilot's lack of currency in type and model airplane, and not following the requirement for the pilot to have a flight instructor onboard during water landings.NTSB CHI96LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lafayette, INthe flight instructor's inadequate supervision and the dual student's failure to extend the landing gear. Factors were the distraction of the flight instructor and the student's failure to use checklist procedures.NTSB MIA96LA132Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · Reidsville, NCthe pilot failed to maintain control of the airplane while performing an acrobatic maneuver.NTSB ATL96LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Nashville, TNthe failure of the pilot of the Piper PA-28, N26046, to visually clear the intended taxi course.NTSB ATL96LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Birmingham, ALthe pilot's failure to maintain directional control during landing,NTSB MIA96LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Boca Raton, FLthe partial loss of engine power due to the fatigue failure of the number 3 cylinder hold down studs and nut. A factor was the pilot'e evasive maneuver to avoid golphers on a golf course.NTSB BFO96FA034Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Louisville, KYfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall, loss of altitude, and subsequent collision with obstructions (utility pole and supporting cable).NTSB LAX96LA100Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Folsom Lake, CAthe flight instructor's inadequate supervision of the dual student and improper remedial action. A factor relating to the accident was: failure of the student pilot to maintain directional control.NTSB MIA96LA038Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Memphis, TNThe pilot's and ground personnel's improper starting procedure. Contributing to the accident were the communications being not understood and inadequate training for both the pilot and ground personnel.NTSB LAX96LA055Accident · No injuriesLimited investigationFinal reportSchafer Lancair 360 · Mesa, AZfailure of the nose gear strut, during landing.NTSB BFO96LA023Accident · No injuriesLimited investigationFinal reportBeech A23-24 · New Carlisle, OHthe pilot-in-command's failure to reach the proper touchdown point. Related factors were the pilot's failure to obtain/maintain the proper glidepath during the approach, and the rough/uneven terrain encountered after the airplane touched down short of the…NTSB FTW96LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Dibble, OKan overload failure of the #1 connecting rod bolt and resulting connecting rod fatigue failure. A factor was the lack of suitable terrain for the forced landing.NTSB MIA96LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Covington, GAthe pilot's failure to divert to an alternate airport after recognizing a low fuel state existed and his delay to declare an emergency with ATC. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB ATL95LA175Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Hoover, ALThe pilot's failure to maintain directional control when he positioned the helicopter in a hover so as to induce a loss of tail rotor effectiveness.NTSB MIA95LA209Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Kissimmee, FLThe pilot-in-command's decision to allow the student to land long and not use all the available runway and his delay in aborting the takeoff resulting in a runway overrun.NTSB FTW95LA354Accident · No injuriesLimited investigationFinal reportBeech C24R · Mineola, TXThe pilot's inadequate preflight planning/preparation, and his failure to obtain the required aircraft performance data for the flight. A factor was the high density altitude.NTSB CHI95LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Wheeling, ILthe pilot's abrupt raising of the flaps during the attempted go-around and the resulting stall.NTSB LAX95LA268Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Paula, CAfuel exhaustion due to the pilot's failure to perform preflight fuel consumption calculations, and his failure to refuel the aircraft.NTSB NYC95LA149Accident · No injuriesLimited investigationFinal reportMooney 20E · Burlington, CTthe pilot's failure to extend the landing gear resulting in a wheels up landing. A factor relating to the accident was the inoperative gear warning horn.NTSB NYC95IA164Incident · No injuriesIncident investigationFinal reportEnstrom F-28A · Philadelphia, PAthe pilot's failure to maintain aircraft control resulting in a collision with the water.NTSB SEA95LA141Accident · No injuriesLimited investigationFinal reportMooney M20E · Ronan, MTDirectional control was not maintained. Factors to the accident were a rough/uneven airstrip and tall vegetation.