NTSB investigations: Lycoming 0-290 series
1,553 cases on aircraft whose registry engine model is Lycoming 0-290 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 ('41506'))
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 ('41506'))
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 CHI05LA276Accident · 1 fatalLimited investigationFinal reportStits Playboy SA3B Lightning · Kimball, NEThe inadvertent stall and low airspeed by the pilot following takeoff. Contributing factors were the low altitude at the time of occurrence, the high density altitude, and the propeller.NTSB ANC05CA139Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in an inadvertent stall/mush, and subsequent in-flight collision with trees. A factor contributing to the accident was a tailwind.NTSB SEA05CA186Accident · No injuriesData collectionFinal reportPiper PA-22 (20) · McCall, IDThe pilot's failure to maintain airspeed during takeoff. A wire fence was a factor in the accident.NTSB ATL05CA151Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 · N. Myrtle Beach, SCThe loss of engine power due to the pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice.NTSB ATL05CA146Accident · No injuriesData collectionFinal reportPiper 22 · Archdale, NCThe pilot's failure to maintain directional control during landing roll, which resulted in a nose over.NTSB CHI05CA193Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Plainwell, MIThe loss of engine power on downwind due to carburetor icing, and the unsuitable terrain the pilot encountered during the forced landing. A factor was the soft terrain.NTSB ANC05CA091Accident · No injuriesData collectionFinal reportPiper PA-20 · Nome, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in the collapse of the main landing gear, and a nose over. A factor associated with the accident was a crosswind.NTSB CHI05CA169Accident · Minor injuriesData collectionFinal reportKelley Volmer Amphibian B · Nauvoo, ILThe pilot's failure to maintain appropriate airspeed during landing, which resulted in a stall/mush condition and hard landing.NTSB LAX05CA212Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Pine Valley, CAThe pilot's delay in aborting the takeoff and excessive brake application. A contributing factor was the downsloping terrain used for the landing and takeoff.NTSB ANC05CA080Accident · No injuriesData collectionFinal reportPiper PA-18 · Delta Junction, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an overrun. A factor contributing to the accident was rough and uneven terrain.NTSB ANC05LA073Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Palmer, AKThe pilot's misjudged distance and speed, which resulted in an overrun during the landing roll, and subsequent nose over. Factors contributing to the accident were a tailwind and a short landing area.NTSB ATL05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Thomaston, GAThe unapproved repair of the tailwheel rudder arm assembly, which resulted in an overload failure during touchdown and subsequent loss of control of the airplane and on-ground collision with an object.NTSB DEN05FA124Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Kremmling, COthe pilot's failure to maintain clearance from terrain.NTSB ATL05CA059Accident · No injuriesData collectionFinal reportEcker Starduster 1 · Millington, TNThe malfunction of the left main landing gear wheel brake during landing roll on a grassy area, resulting in a nose over.NTSB ANC05LA042Accident · No injuriesLimited investigationFinal reportPiper J-5A · Kenai, AKThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a collision with a snow berm during the landing flare. Factors contributing to the accident were flat light conditions, the presence of a snow berm along the edge of a…NTSB ATL05CA054Accident · No injuriesData collectionFinal reportPiper PA-22 · Holly Ridge, NCThe CFI's improper use of the rudder control and normal braking during the landing roll that resulted in the collapse of the nose gear assembly.NTSB SEA05LA039Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lewiston, IDThe pilot's failure to maintain directional control during the landing roll. Wind gusts and the pilot's inadequate compensation for wind conditions were factors.NTSB CHI05CA036Accident · No injuriesData collectionFinal reportSpaulding Tailwind W-8 · Davey, NEThe loss of engine power due to the loss of oil pressure as a result of the pilot's failure to properly install the oil line to the oil cooler. A factor was the rough terrain.NTSB DEN04LA133Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hayden, COthe pilot's failure to maintain aircraft control during landing. Contributing factors include the excessive crosswind component, and the gusty wind conditions.NTSB ANC04LA100Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Cordova, AKThe pilot's failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a runway marker sign. A factor contributing to the accident was sunglare in the pilot's eyes.NTSB LAX04CA286Accident · No injuriesData collectionFinal reportPiper PA-20 · Glendale, AZthe pilot's failure to maintain directional control during the takeoff roll.NTSB CHI04CA115Accident · No injuriesData collectionFinal reportVilleneuve RV-3 · Mayetta, KSThe pilot failed to maintain airspeed and aircraft control during final approach, which resulted in a stall/mush flight condition. A factor to the accident was the crosswind and the trees.NTSB DEN04LA070Accident · No injuriesLimited investigationFinal reportCrimmins Smyth Sidewinder · Natrona, WYfuel starvation due to contamination, resulting in the fuel selector valve becoming totally blocked. Contributing factors were the inadequate conditional inspection, and the lack of nsuitable terrain on which to make a forced landing.NTSB SEA04LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Laurel, MTThe pilot's failure to maintain adequate clearance/altitude while maneuvering resulting in the inadvertent in-flight collision with water/terrain.NTSB ANC04LA041Accident · No injuriesLimited investigationFinal reportChampion 7GC · Wasilla, AKThe flight instructor's inadequate supervision of the student pilot which resulted in a loss of directional control during the takeoff roll, and subsequent collision with a ditch. A factor contributing to the accident was the student pilot's failure to…NTSB CHI04LA073Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Memphis, MODirectional control not maintained by the flight instructor during the landing roll. The snow on the edge of the runway, and the wind gusts were factors.NTSB LAX04LA110Accident · 1 fatalLimited investigationFinal reportTailwind W-8 · San Pedro, CAThe pilot's incapacitation during descent, which resulted in a loss of control and an in-flight collision with water.NTSB ATL04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Indian Trail, NCThe pilot's attempted lift off without adequate airspeed resulting in a stall/mush and collision with trees while transitioning from an aborted landing to takeoff climb. A factor was the crosswind condition.NTSB ANC04LA019Accident · Minor injuriesLimited investigationFinal reportGothard Super Cuby · Palmer, AKThe loss of engine power after takeoff for an undetermined reason, which resulted in a forced landing and in-flight collision with trees.NTSB ATL04LA064Accident · 1 fatalLimited investigationFinal reportAtkinson SA 102.5 · Trenton, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent in-flight collision with terrain.NTSB SEA04LA021Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Emmett, IDBrake failure as a result of inadequate hydraulic (brake) fluid in the aircraft's closed brake system. Contributing factors were the pilot's overall lack of experience in the aircraft make/model, the cold soaked brake system due to the low temperatures, and…NTSB ANC04LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Bethel, AKThe pilot's delayed application of carburetor heat, which resulted in a loss of engine power, and subsequent forced landing. Factors associated with the accident were weather conditions conducive to carburetor icing, and the lack of suitable terrain for a…NTSB LAX04LA033Accident · Serious injuriesLimited investigationFinal reportDavidson-Thorpe T-18 · Coalinga, CAthe pilot's improper recovery from a bounced landing, and hi failure to maintain directional control during landing rollout.NTSB LAX04CA026Accident · No injuriesData collectionFinal reportPiper PA-20 · Petaluma, CAthe pilot's inadequate compensation for a crosswind condition and failure to maintain directional control that resulted in a ground loop.NTSB SEA03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cle Elum, WAAn undershoot due to the pilot's failure to maintain a proper glide path on final approach to landing. A factor was the gravel.NTSB ANC03LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nenana, AKThe loss of engine power during cruise flight for an undetermined reason, which resulted in a forced landing and an in-flight collision with trees.NTSB CHI03LA308Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wausau, WIThe excessive free play resulting in a loose tail wheel assembly and a failure of the flight crew to maintain directional control during the landing rollout.NTSB CHI03LA304Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Atwood, ILThe pilot's failure to correctly identify the location of the airport. Factors to the accident include the pilot flying while fatigued, which contributed to his misidentification of the runway, and the rough/uneven soybean field.NTSB DEN03LA144Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Longmont, COSeparation of the landing gear tire valve stem resulting in the left main tire deflating, and the pilot's inability to maintain aircraft control.NTSB ANC03LA079Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane's collision with a ditch, and the collapse of the main landing gear.NTSB SEA03WA114Accident · 2 fatalForeign investigationPiper PA-12 · Nimpo Lake, BC, CanadaNTSB DEN03LA091Accident · No injuriesLimited investigationFinal reportChampion 7GC · Casper, WYthe pilot's failure to maintain directional control of the aircraft during the landing. Contributing factors include the inadequate remedial action by the pilot and the pilot's lack of experience in the aircraft.NTSB LAX03LA169Accident · Minor injuriesLimited investigationFinal reportCallahan Rebel · Clearlake, CAfuel starvation due to the pilot's inadequate preflight inspection and failure to correctly position the right fuel valve. Also causal was the pilot's failure to use the checklist.NTSB CHI03LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Prescott, WIThe pilot delaying the go-around and the maneuver to avoid the treeline. Factors to the accident were the treeline and the airplane's low altitude.NTSB NYC03GA094Accident · 1 fatalFinal reportPiper PA-18-150 · Ashland, METhe pilot's impairment due to over-the-counter medications, which resulted in a loss of aircraft control while maneuvering.NTSB ANC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Palmer, AKThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in an inadvertent ground loop and collapse of the left main landing gear.NTSB MIA03LA087Accident · No injuriesLimited investigationFinal reportPool Pool Jungster I · Fernandina Beac, FLThe pilot's failure to maintain control during the landing flare/touchdown while attempting a crosswind landing resulting in the left wing impacting the ground, and a collision with runway lights during the attempted recovery.NTSB ANC03LA016Accident · No injuriesLimited investigationFinal reportPiper J5A · Soldotna, AKThe pilot's failure to remove all water from the airplane's fuel supply during the preflight inspection, which resulted in a loss of engine power and subsequent hard landing.NTSB FTW03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Big Spring, TXthe failure of both pilots to maintain visual separation with each other. Factors were the Cessna pilot's inability to listen to or make radio transmissions and the Piper pilot's nonstandard traffic pattern.NTSB ANC03CA008Accident · No injuriesData collectionFinal reportPiper PA-22 · Palmer, AKThe premature liftoff by the pilot during takeoff, which resulted in on ground encounter with terrain when the airplane settled onto rocks. A contributing factor in the accident was an unfavorable wind.