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 IAD05FA052Accident · 2 fatalField investigationFinal reportPiper PA-28R-201 · Green Creek, NJThe flight crew's failure to maintain terrain clearance while executing a practice published instrument approach in night visual meteorological conditions. A factor in the accident was the dark night.NTSB CHI05LA083Accident · 1 fatalLimited investigationFinal reportMooney M20E · Bloomfield, IAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin. The low altitude was a factor.NTSB CHI05FA081Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · West Lafayette, INThe pilot's inadvertent flight into instrument conditions and his not maintaining control of the complex airplane during initial climb. Factors in the accident were the low ceiling, the early dawn condition, and the pilots intentional unauthorized use of the…NTSB LAX05LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Phoenix, AZsubstantial damage to the airplane during an unknown phase of flight for undetermined reasons.NTSB ATL05CA060Accident · Minor injuriesData collectionFinal reportSavage RV-8 · Goldsboro, NCThe pilot's excessive braking during landing roll, which resulted in a nose-over. A factor was the tailwind.NTSB DEN05CA052Accident · No injuriesData collectionFinal reportHughes 269C · Englewood, COthe student pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight. Contributing factors were low rotor rpm, low airspeed, and the instructor's delay in taking remedial action.NTSB DFW05CA050Accident · No injuriesData collectionFinal reportReinhart GP-4 · Fort Worth, TXThe pilot's failure to compensate for the prevailing crosswind. A contributing factor was the crosswind.NTSB MIA05CA048Accident · No injuriesData collectionFinal reportCessna 172SP · Clewiston, FLThe pilot's failure to maintain directional control during landing rollout which resulted in the airplane veering off the runway and colliding into an airport sign.NTSB NYC05LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Smoketown, PAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a parked airplane.NTSB DEN05FA044Accident · 1 fatalField investigationFinal reportCessna 172S · Roswell, NMthe pilot not maintaining control of the aircraft resulting in an uncontrolled descent and collision on a highway. Factors contributing to the accident were the dark night and the pilot experiencing spatial disorientation.NTSB DEN05LA043Accident · No injuriesLimited investigationFinal reportMooney M20E · Telluride, COthe pilot's improper in-flight decision making and inadvertent retraction of the landing gear resulting in a wheels up landing. A contributing factor included the pilot's attention being diverted by the seized engine tachometer.NTSB DFW05LA033Accident · No injuriesLimited investigationFinal reportMooney M20F · Fabens, TXThe loss of engine power as a result of the failure of a connecting rod due to oil starvation/exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL05CA028Accident · No injuriesData collectionFinal reportEnstrom F-28A · Smyrna, TNThe loss of engine power for undetermined reasons, and the pilot's improper flare during forced landing, which resulted in an inflight collision into an open field.NTSB MIA05FA028Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Dubbs, MSThe pilot's inadvertent flight into instrument meteorological conditions and his in-flight loss of control, resulting in overstress of the airframe and subsequent structural failure.NTSB DEN05CA020Accident · No injuriesData collectionFinal reportMooney M20E · Santa Rosa, NMInadequate maintenance inspection which failed to detect the separation of the right P-lead, resulting in a loss of engine power.NTSB MIA05LA019Accident · No injuriesLimited investigationFinal reportScottish Bulldog 120/121 · Jacksonville, FLThe pilot's failure to maintain altitude/clearance with trees resulting in the in-flight collision with a tree, damage to the right main landing gear, and subsequent collapse of the right main landing gear during the emergency landing.NTSB LAX05LA012Accident · No injuriesLimited investigationFinal reportBeech C24R · Cloverdale, CAthe loss of engine power due to fuel starvation from the pilot's inadequate fuel system management and his delay in selecting the fullest fuel tank.NTSB LAX05LA007Accident · 1 fatalLimited investigationFinal reportDeRosier DR-107 · San Diego, CAthe pilot's failure to maintain adequate clearance from terrain while performing low-level aerobatic maneuvers.NTSB DEN05CA007Accident · No injuriesData collectionFinal reportMooney M20E · Broomfield, COthe pilot's improper flare and recovery from a bounced landing during a touch and go maneuver. Contributing factors were the excessive airspeed and descent rate during the approach.NTSB DEN04LA150Accident · No injuriesLimited investigationFinal reportCessna 172S · Broomfield, COthe pilot's improper flare, and the flight instructor's inadequate supervision of the pilot.NTSB CHI04FA290Accident · 3 fatalField investigationFinal reportBeech B95A · Burlington, WIThe improper maintenance of the fuel servo resulting in a loose adjustment nut and subsequent failure of the fuel injection servo which led to a complete loss of power on the right engine. Other causes were the pilot's failure to obtain or maintain minimum…NTSB NYC04CA216Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · New Milford, CTThe pilot's improper flair, which resulted in a nose over.NTSB FTW04LA236Accident · 1 fatalLimited investigationFinal reportLancair 360 · Orange, TXThe pilot's failure to maintain adequate airspeed during takeoff resulting in an inadvertent stall and loss of aircraft control.NTSB NYC04CA206Accident · No injuriesData collectionFinal reportCessna 172S · Mount Gilead, OHThe pilot's inadequate compensation for wind conditions which resulted in a collision with the runway. A factor was the crosswind.NTSB MIA04LA127Accident · No injuriesLimited investigationFinal reportMooney M20F · Brandon, MSA loss of engine power due to the fatigue failure of all studs and/or thru-bolts of the No. 3 cylinder for undetermined reasons causing separation of the cylinder. Contributing to the accident was the unsuitable terrain encountered by the pilot.NTSB CHI04CA237Accident · Serious injuriesData collectionFinal reportEnstrom F-28A · Leroy, MNThe partial loss of engine power due to the missing 1/8-27 NPT Allen plug as a result of other maintenance personnel undertorquing the plug. Additionally, the pilot improperly excecuted a run on landing. A factor was the loss of tail rotor effectiveness.NTSB DEN04LA127Accident · No injuriesLimited investigationFinal reportCessna 172S · Carlsbad, NMthe student pilot's inadequate flare resulting in a hard landing. A contributing factor was the tailwind conditions.NTSB FTW04CA228Accident · No injuriesData collectionFinal reportMooney M20E · San Antonio, TXThe pilot's misjudged distance and his failure to abort the landing. A factor was the prevailing tailwind.NTSB IAD04CA038Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Eliot, METhe pilot's failure to maintain airspeed above stall which resulted in a hard landing and collapse of the landing gear. Also causal was the flight instructor's inadequate supervision.NTSB LAX04CA303Accident · No injuriesData collectionFinal reportRockwell 112TC · Bullhead City, AZthe pilot's failure to extend the landing gear prior to landing. Factors in the accident were the pilot's failure to use a checklist and to verify that the gear were extended.NTSB IAD04LA037Accident · Minor injuriesLimited investigationFinal reportAero Commander 112 · Jackson, OHthe loss of engine power for undetermined reasons over unsuitable terrain.NTSB CHI04CA222Accident · No injuriesData collectionFinal reportMooney M20J · Huntington, INThe pilot's inadequate flare and unsuccessful recovery from a bounced landing, and the pilot's and flight instructor's failure to maintain directional control and airspeed during the subsequent aborted landing, which resulted in a stall. A factor was the…NTSB CHI04CA241Accident · No injuriesData collectionFinal reportCessna 172R · Olathe, KSThe student pilot flared too high and failed to recover from a bounced landing.NTSB ATL04CA165Accident · No injuriesData collectionFinal reportMooney M20F · Brewton, ALA loss of engine power (non-mechanical) for undetermined reasons. A factor was the collision with a fence during emergency landing.NTSB ATL04LA164Accident · 1 fatalLimited investigationFinal reportCessna 172S · Waterloo, ALThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in a stall and subsequent uncontrolled descent and collision into water.NTSB ATL04LA161Accident · No injuriesLimited investigationFinal reportLong Pitts Special S1S · New Bern, NCThe pilot's inadequate compensation for winds and his failure to maintain directional control during a crosswind landing, which resulted in an on-ground collision with an airport sign. A factor was the crosswind condition.NTSB FTW04LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Blackwell, OKThe pilot's failure to maintain directional control and the instructor's inadequate supervision by his delay in taking corrective action during the landing roll.NTSB NYC04FA161Accident · 2 fatalField investigationFinal reportBeech E95 · Atlantic City, NJThe pilot's failure to maintain airplane control while performing a go-around after experiencing a loss of power to the left engine for undetermined reason(s). A factor related to the accident was the loss of power to the left engine.NTSB ATL04CA144Accident · Minor injuriesData collectionFinal reportMooney M-20E · Thomasville, GAThe pilot's misjudgment of the airspeed and distance during approach to land that resulted in an undershoot and the subsequent collision with the ground.NTSB CHI04CA165Accident · No injuriesData collectionFinal reportCessna 172S · Fishers, INThe pilot's inadequate remedial actions after an inadequate landing flare and subsequent hard landing. Additional causes were the pilot-induced porpoise and the collapse of the nose landing gear.NTSB LAX04FA226Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Columbia, CAThe loss of engine power for undetermined reason during takeoff-initial climb, and the pilot's failure to maintain sufficient airspeed to avoid a stall/mush. Factors associated with the accident are an inadvertent stall/mush, and the pilot's failure to abort…NTSB LAX04CA221Accident · No injuriesData collectionFinal reportAmerican Blimp A-1-50 · North Las Vegas, NVthe ground crew's inability to maintain control of the airship and the pilot's inability to obtain a sufficient rate of climb. Contributing to the accident was unfavorable winds.NTSB MIA04LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Everglades City, FLThe failure of the pilot to maintain airspeed during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and impact in a wooded area.NTSB ATL04TA116Accident · 1 fatalFinal reportHughes 269A · Louisburg, NCFatigue failure of the tailboom saddle fitting which resulted in a loss of aircraft control. Also causal was inadequate maintenance due to non-compliance to an airworthiness directive requiring inspection of the saddle fitting. A contributing factor was the…NTSB ATL04CA101Accident · No injuriesData collectionFinal reportBeech D95A · Athens, GAThe pilot's misjudgment of airspeed and distance which resulted in an overshoot of the runway and collision with ground. The tailwind was a factor.NTSB LAX04CA215Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Galt, CAthe pilot under instruction's failure to maintain an adequate airspeed on final and misjudged flare, which resulted in stall/mush and hard landing. The certified flight instructor's inadequate supervision and failure to initiate timely remedial action were…NTSB ATL04CA091Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Delco, NCThe flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation. A factor was the flight instructor's failure to use the checklist.NTSB NYC04LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Elyria, OHA loss of engine power for undetermined reasons.NTSB NYC04FA100Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Harrietstown, NYThe pilot's failure to follow instrument flight rules procedures resulting in a collision with a tree. Factors related to the accident were the dark night conditions, low visibility, and low cloud ceiling.NTSB CHI04LA097Accident · No injuriesLimited investigationFinal reportCessna 172R · Kalamazoo, MIThe air traffic control procedures/directives not followed by tower air traffic controller, the inadequate compensation for wind conditions by the student pilot during landing, the lack of total experience by the student pilot, and the recommended crosswind…