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 DEN03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Watkins, COthe pilot's inability [not possible] to control the airplane during landing roll due to the failure of the left brake, and the subsequent inadvertent ground loop.NTSB CHI03LA007Accident · No injuriesLimited investigationFinal reportMadewell EAA-Biplane-P · Forest Lake, MNThe loss of engine power for undetermined reasons. A related factor was the swampy terrain.NTSB LAX02LA268Accident · Serious injuriesLimited investigationFinal reportBreezy RLU-1A · North Las Vegas, NVthe failure of both pilots to maintain an adequate terrain clearance altitude while maneuvering in a canyon.NTSB SEA02LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Newberg, ORA warped right brake disc resulting in a veer to the right during the landing roll, and the aircraft's subsequent collision with a fence. A contributing factor was the fence.NTSB LAX02LA249Accident · Minor injuriesLimited investigationFinal reportArns Spacewalker II · Irvine, CALoss of engine power due to an exhaust system leak and vapor lock.NTSB CHI02LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA22-135 · Lyons, WIFailure of the pilot to maintain a sufficient rate-of-climb and to obtain a safe altitude/clearance from the tree line at end of the runway. Contributing factors were the uphill runway gradient and the trees.NTSB CHI02FA200Accident · No injuriesField investigationFinal reportPiper PA-20 · Oshkosh, WIInadequate visual lookout by both the accident pilot and the pilot of the other airplane. An additional cause is the arrival procedure used which resulted in a congested traffic pattern and the subsequent inadequate visual separation of the airplanes. Factors…NTSB ANC02LA067Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's inadequate weather evaluation, which resulted in a turbulence encounter and subsequent collision with a river embankment during maneuvering flight. A contributing factor was the presence of terrain induced turbulence.NTSB MIA02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Jacksonville, FLThe failure of the solo student/owner to maintain directional control of the airplane during takeoff in a crosswind, which resulted in the airplane veering off the runway, a collision with a runway light, and a ground loop.NTSB CHI02CA196Accident · No injuriesData collectionFinal reportGrenier Acro Sport · Jacksonville, ILThe probable cause of this accident is a failure of the left main landing gear attachment bolt and the subsequent collapse of the left main landing gear. Repeated hard landings was a factor and a lack of recent experience were contributing factors.NTSB ANC02LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane. A factor associated with the accident is a ditch adjacent to the runway.NTSB CHI02LA168Accident · Minor injuriesLimited investigationFinal reportBumgarner CA65 Sky Fly · Warrensburg, MOThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the overload failure of the right main landing gear.NTSB ANC02LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's inadequate compensation for wind conditions, and the excessive use of the airplane's brakes, which resulted in a nose over. A contributing factor to the accident was a wind gust.NTSB LAX02LA197Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Brownsville, CAa loss of engine power for undetermined reasons. Also causal was the pilot's failure to maintain an adequate airspeed during a turn to reverse course back to the runway, resulting in a stall and collision with terrain.NTSB CHI02LA159Accident · 1 fatalLimited investigationFinal reportGalbraith Piel Emeraude · Hot Springs, SDThe loss of engine power due to the connecting rod fatigue failure during takeoff climb.NTSB SEA02LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Payette, IDThe pilot's failure to adequately compensate for the wind conditions during landing resulting in a ground loop/swerve. Wind gusts were a contributing factor.NTSB LAX02LA158Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Reno, NVFailure of the pilot to maintain directional control. A factor was the hump in the runway.NTSB ATL02LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Conway, SCThe failure of the pilot to use proper wind correction technique, resulting in a loss of directional control of the aircraft.NTSB ATL02LA047Accident · No injuriesLimited investigationFinal reportPiper PA -18 · Winter Haven, FLThe pilot's improper flare during an attempted landing on water. A factor was glassy water.NTSB NYC02LA058Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Fremont, OHDamage to the right tire, which resulted in a sudden loss of tire pressure and a loss of directional control.NTSB CHI02LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clear Lake, MNThe loss of engine power for undetermined reasons and the unsuitable terrain for the forced landing. Factors were the low altitude and the fences.NTSB FTW02LA029Accident · No injuriesLimited investigationFinal reportLandoll Vans RV 3-A · Denton, TXthe pilot's failure to perform a preflight inspection, which resulted in a loss of total engine power due to oil starvation. A contributing factor was the lack of suitable training for the forced landing.NTSB SEA02LA010Accident · No injuriesLimited investigationFinal reportFetherolf Hatz CB-1 · Ontario, ORAn improper weld in the landing gear, resulting in separation of the right main landing gear wheel during a normal landing.NTSB ANC01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nenana, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was trees.NTSB SEA01LA141Accident · No injuriesLimited investigationFinal reportTaylor Smith Mini DSA-1 · Sultan, WAThe separation/loss of the bolt and castle nut which connected the elevator bellcrank to the control stick pushrod resulting in a disconnect between the cockpit and the control surface and ultimately, the pilot's total loss of pitch control.NTSB ANC01LA089Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Anchorage, AKAn inadvertent ground loop during the landing roll.NTSB SEA01LA137Accident · No injuriesLimited investigationFinal reportPiper PA-20-135 · Redmond, ORThe pilot's inadequate compensation for wind conditions during landing. A factor was variable winds.NTSB SEA01LA134Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Oregon City, ORThe front seat (pilot-in-command's) inadequate visual lookout during step taxi resulting in the aircraft's collision with a partially submerged log. A contributing factor was the log and it's lack of any conspicuous marking.NTSB DEN01LA117Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Eagle, COthe pilot's inadequate wind evaluation, and his inadequate planning/decision to land with a tailwind, at a density altitude of 13,418 feet. Contributing factors were the tailwind and the high density altitude weather condition.NTSB SEA01LA119Accident · Minor injuriesLimited investigationFinal reportShaub EAA Biplane (P-2) · Zillah, WAThe pilot's failure to maintain directional control. A contributing factor was a tailwind.NTSB LAX01LA206Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Winnemucca, NVThe pilot's failure to obtain weather information or an in-flight advisory that would have described current wind information at the destination airport and his subsequent failure to maintain directional control during landing.NTSB DEN01LA115Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Longmont, COthe pilot's failure to maintain directional control during landing. A contributing factor was the tailwind.NTSB SEA01FA106Accident · 1 fatalField investigationFinal reportPiper PA-12 · Augusta, MTThe pilot's failure to maintain adequate airspeed after takeoff resulting in an inadvertent stall at low a altitude.NTSB NYC01LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Clinton, MDThe pilot's failure to maintain directional control during landing rollout. Factors related to the accident were the pilot's lack of experience in tail-wheeled airplanes, and the wind gusts.NTSB LAX01LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Oxnard, CAThe fracture and separation of the number 3 cylinder exhaust valve head resulting in a loss of engine power and a forced landing. A factor in the accident was the soft field where the forced landing occurred.NTSB DEN01FA082Accident · 2 fatalField investigationFinal reportSandell Zenith CH 200 · Canon City, COthe pilot in command inadvertently allowing the airplane to stall/spin. Contributing factors were the pilot's total lack of experience in airplane make/model, and high wind conditions.NTSB SEA01LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bozeman, MTThe pilot rated passenger's failure to maintain directional control during the landing. A factor was the snow berm which the aircraft rolled into during the landing.NTSB LAX01LA087Accident · 2 fatalLimited investigationFinal reportSutton Tailwind W-8L · Reno, NVThe pilot performed aerobatics at low altitude and failed to maintain clearance from the gound resulting in a collision with the terrain.NTSB NYC01LA070Accident · 1 fatalLimited investigationFinal reportWhittman Tailwind DN-1 · Grafton, WVThe pilot's improper preflight planning, which resulted in fuel exhaustion. A factor was the pilot's lack of familiarity with the airplane.NTSB LAX01LA076Accident · No injuriesLimited investigationFinal reportPurvis/Thorpe T-18 · Chiriaco Summit, CAThe dual student's improper recovery from a bounced landing, his failure to maintain directional control during the go-around, and the flight instructor's inadequate supervision of the go-around attempt.NTSB SEA01LA020Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ontario, ORInadequate remedial action by the first pilot. The student pilot's improper flare while landing was a factor.NTSB MIA00LA269Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Enochville, NCA loss of engine power for undetermined reasons.NTSB ANC00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe pilot's inadequate removal of frost from the airplane, and the inadvertent stall during takeoff. A factor was wind gusts.NTSB CHI00LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Marion, INthe pilot failed to maintain directional control during landing. A factor was the dust devil.NTSB CHI00LA231Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Kirksville, MOthe pilot failed to maintain directional control during landing.NTSB LAX00LA238Accident · No injuriesLimited investigationFinal reportWard Sidewinder · Madera, CAThe pilot's inadequate short field landing procedure and his delayed decision to proceed to an alternate destination, which resulted in fuel exhaustion and a subsequent hard landing during the emergency descent.NTSB DEN00LA111Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dutch John, UTThe pilot's failure to compensate for wind conditions and control the aircraft while landing in gusting wind conditions.NTSB NYC00LA160Accident · Minor injuriesLimited investigationFinal reportBryant/Rhodus LONG-EZ · West Chester, PAWas the failure of the pilot to attain his proper touchdown point. Factors were the downdraft and rising terrain leading to the runway.NTSB SEA00LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Quinault, WAFuel starvation due to the pilot's failure to position the fuel selector valve to the proper/correct position while switching fuel tanks. Factors include unreliable fuel selector valve position detents, having no suitable terrain in which to execute a forced…NTSB ANC00LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor in the accident was a sudden wind shift.