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 WPR09CA231Accident · Serious injuriesData collectionFinal reportFuhrmann-Super Emeraude Stretched · Peach Springs, AZThe airplane's encounter with turbulence after takeoff, which resulted in an uncontrolled descent and collision with terrain.NTSB ANC09LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Palmer, AKThe non-certificated pilot’s decision to attempt to "ski" atop a water-covered tidal area in an airplane equipped with over-sized main landing gear tires, resulting in a loss of control and a nose over.NTSB ERA09CA246Accident · No injuriesData collectionFinal reportPiper PA20 · Scranton, PAThe pilot’s inadequate compensation for wind conditions during landing. Contributing to the accident was the distraction of smoke in the cockpit.NTSB ERA09LA230Accident · 1 fatalLimited investigationFinal reportChampion 7HC · Centre, ALThe pilot's inability to maintain aircraft control during climb due to an improperly installed rudder pedal control tube.NTSB WPR09CA081Accident · No injuriesData collectionFinal reportParker 77 · Phoenix, AZThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.NTSB WPR09CA031Accident · No injuriesData collectionFinal reportPiper PA-22-135 · San Manuel, AZThe pilot's failure to maintain lateral aircraft control that resulted in collision with terrain during landing.NTSB ERA09CA023Accident · No injuriesData collectionFinal reportPiper PA-20 · Albertville, ALThe pilot’s failure to maintain control of the airplane during the landing roll.NTSB ANC08CA115Accident · No injuriesData collectionFinal reportPiper PA-22 · Fairbanks, AKThe pilot's selection of an unsuitable landing site, resulting in a main landing gear collapse during the landing roll.NTSB LAX08CA285Accident · No injuriesData collectionFinal reportMason Falconar F-11 · Creswell, ORThe pilot's failure to maintain a stabilized approach, inadequate recovery from a bounced landing, and failure to maintain directional control.NTSB SEA08CA186Accident · No injuriesData collectionFinal reportCessna 140A · Lowman, IDThe pilot's failure to maintain directional control during the landing roll.NTSB CHI08FA222Accident · Minor injuriesField investigationFinal reportPiper PA-22 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed while taking off in gusting winds, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CHI08CA207Accident · Minor injuriesData collectionFinal reportTuth RV-3 · Oshkosh, WIThe compensation for wind conditions disregarded by the pilot and the inadequate in-flight planning/decision making by the plot during approach to the destination airport. A contributing factor was the quartering tailwind.NTSB DFW08CA181Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Peyton, COLanding gear collapse during the landing roll for undetermined reasons.NTSB ANC08CA081Accident · Minor injuriesData collectionFinal reportMarvin A. Smith Pietenpol Air Camper · Soldotna, AKThe student pilot's inadequate recovery from a bounced landing.NTSB SEA08CA150Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Logan, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was a crosswind wind gust.NTSB NYC08LA201Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Myrtle Beach, SCA loss of engine power due to thermally-induced failure of a piston. Contributing to the accident was the sustained engine exposure to abnormally high operating temperatures and detonation, and the exceedance of the engine manufacturer's recommended overhaul…NTSB SEA08CA141Accident · No injuriesData collectionFinal reportPiper PA-20 · Fields, ORThe pilot's failure to maintain aircraft control during the approach. Contributing to the accident was a windshear.NTSB CHI08CA148Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Delphi, INThe pilot's inadequate compensation for the gusting crosswind during landing rollout. Contributing to the accident was the gusting crosswind condition.NTSB ANC08CA068Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe pilot's inadequate compensation for a crosswind during landing. Contributing to the accident was the crosswind and an inadvertent ground loop.NTSB DFW08CA113Accident · No injuriesData collectionFinal reportPiper PA-18 · Santa Teresa, NMThe pilot's failure to maintain aircraft control. Contributing to the accident was the strong gusty crosswinds.NTSB DEN08IA080Incident · No injuriesIncident investigationFinal reportHill Hatz CB-1 · Erie, COthe pilot's failure to maintain directional control during landing. A contributing factor was the gusty wind conditions.NTSB DEN08CA063Accident · No injuriesData collectionFinal reportPiper PA-22 · Nickerson, KSthe pilot's failure to maintain directional control during the landing roll resulting in a departure from the runway environment. Contributing to the accident was the soft runway surface.NTSB CHI08CA089Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Scribner, NEThe inadequate compensation for wind conditions and the directional control not obtained/maintained by the pilot during landing. A contributing factor was the crosswind.NTSB SEA08CA039Accident · No injuriesData collectionFinal reportPiper PA-18A-135 · Yelm, WAThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing roll. Contributing factors were the rough/uneven terrain and log.NTSB MIA08CA011Accident · Serious injuriesData collectionFinal reportSmith Miniplane DSA-1 · Alburgh, VTThe pilot's failure to maintain control of the airplane during aerobatic maneuvers which resulted in a loss of control and in-flight collision with trees.NTSB ANC08CA009Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Pilot Point, AKThe pilot's inadequate compensation for wind conditions during an attempted go-around, which resulted in a loss of control, and an in-flight collision with terrain. Factors associated with the accident were gusty, high winds.NTSB NYC07LA241Accident · Serious injuriesLimited investigationFinal reportEverson Sidewinder · Pensacola, FLThe pilot's failure to attain the proper touchdown point while landing.NTSB CHI07CA274Accident · No injuriesData collectionFinal reportCessna 140 · Grant, NEThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gust, and ditch.NTSB CHI07CA229Accident · Serious injuriesData collectionFinal reportNetz KIS TR2 · Willow Springs, MOThe improper installation of the aileron control pushrod which led to a separation of the pushrod and subsequent loss of aircraft control. A factor was the pilot not being able to control the airplane after the pushrod separation.NTSB MIA07CA118Accident · No injuriesData collectionFinal reportPiper PA-20-135 · State College, PAThe failure of the pilot to maintain directional control of the airplane.NTSB CHI07LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Johnson, NEThe failure of the left wing's lift strut, which resulted in the separation of the left wing, and the subsequent airplane control not being possible. Factors were the overdue annual inspection, the overdue compliance with an Airworthiness Directive on the…NTSB SEA07CA185Accident · Minor injuriesData collectionFinal reportHammer Thorp T-18 · Everett, WAExcessive airspeed during a return for landing which resulted in an overrun. An unlatched canopy, a proper touchdown point not attained and rough terrain were factors.NTSB CHI07CA119Accident · No injuriesData collectionFinal reportJohnson-Whittman Tailwind JW9L · Saginaw, MIThe pilot's failure to maintain the proper glidepath and clearance from a fence while on final approach.NTSB SEA07CA099Accident · No injuriesData collectionFinal reportBarnett MA-5 Charger · San Martin, CACarburetor icing conditions which resulted in a loss of engine power during the base turn to final approach. The pilot's inadequate preflight planning/preparation for the flight was a factor.NTSB SEA07LA093Accident · No injuriesLimited investigationFinal reportChampion 7ECA · East Wenatchee, WASeparation of the left main landing gear shock absorbing strut during takeoff. A missing screw was a factor.NTSB SEA07CA086Accident · No injuriesData collectionFinal reportPiper PA-22 · Enumclaw, WAThe pilot's failure to apply carburetor heat during cruise flight. Factors include ambient weather conditions that were conducive to carburetor icing, and soft, muddy terrain at the location where the pilot attempted the power-off forced landing.NTSB ANC07LA015Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of directional control on the ground, and the wing impacting the snow-covered terrain. A factor associated with the accident was the snow-covered terrain.NTSB ANC07CA004Accident · No injuriesData collectionFinal reportPiper PA-20-135 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and encounter with terrain. Factors associated with the accident were the ground loop and inadequate main wheel brakes.NTSB ANC06LA140Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot's failure to refuel the airplane before departure, which resulted in fuel exhaustion, and a total loss of engine power during cruise flight. Factors contributing to the accident were an inaccurate fuel tank indication on one of the two fuel tanks,…NTSB ANC06CA128Accident · No injuriesData collectionFinal reportPiper PA-18 · Aniak, AKThe pilot's inadequate compensation for wind conditions during the takeoff initial climb, which resulted in a loss of control and in-flight collision with terrain. A factor contributing to the accident was a windshear.NTSB ANC06LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Chugiak, AKThe pilot's failure to properly preflight the airplane and remove all water from the fuel system, which resulted in a loss of engine power during takeoff/initial climb, and subsequent loss of control. Factors associated with the accident are the pilot's…NTSB CHI06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-22-135 · Nebraska City, NEThe pilot's failure to maintain directional control during the landing rollout and the resulting ground loop. A contributing factor was the excessive tail wheel steering (rudder) input by the pilot.NTSB ANC06LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor associated with the accident was the rocky terrain.NTSB SEA06CA113Accident · No injuriesData collectionFinal reportPiper PA-20 · Salt Lake City, UTAn improper flare and the pilot's failure to maintain directional control during the landing which resulted in the aircraft nosing over. Delayed remedial action was a factor.NTSB DFW06CA107Accident · No injuriesData collectionFinal reportPiper PA-22 · Tecumseh, OKThe pilot's failure to maintain clearance from the trees. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.NTSB CHI06LA100Accident · No injuriesLimited investigationFinal reportPiper PA-20 · South St. Paul, MNThe pilot's failure to maintain directional control during landing roll, which resulted in the collapse of the right main landing gear. A factor associated with the accident was a tailwind.NTSB SEA06CA061Accident · No injuriesData collectionFinal reportPiper PA-18 · Saint Paul, ORThe pilot's failure to maintain a proper glide path on final approach to landing resulting in a nose over. A factor was the loose gravel/sandy condition.NTSB SEA06CA062Accident · No injuriesData collectionFinal reportPiper PA-18A · Shady Cove, ORThe pilot's improper installation of the control stick during maintenance, which resulted in the control stick becoming disconnected during the initial takeoff climb, resulting in a loss of control and in-flight collision with the ground.NTSB ANC06CA013Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground collision with trees during the landing roll. Factors associated with the accident were the icy and snow-covered terrain.NTSB CHI06CA044Accident · No injuriesData collectionFinal reportMendenhall Lancair 235 · Medina, OHThe pilot's failure to maintain directional control during landing due to an icy runway. Factors to the accident were the ice/snow contaminated runway surface, snow bank, and the pilot's lack of familiarity with the accident airplane.