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 FTW97LA038Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Westcliffe, COfailure of the pilot to maintain directional control during the landing.NTSB SEA97LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ogden, UTthe pilot's inadequate compensation for wind conditions, while landing, which resulted in a loss of directional control and an inadvertent ground swerve. The crosswind was a related factor.NTSB ATL97LA003Accident · Serious injuriesLimited investigationFinal reportHarper W-8 Tailwind · Macclenny, FLthe pilot's inadequate preflight inspection, which resulted in loss of engine power due to fuel contamination.NTSB FTW97LA017Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boulder, COthe pilot's failure to maintain directional control and his improper use of rudder. A factor was the pilot's lack of total experience in the make and model of airplane.NTSB CHI97LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Silver Lake, INfuel starvation due to an inadequate preflight and the pilot performed a low altitude maneuver which prevented him from selecting suitable terrain for landing. Additional factors included the loose fuel cap, fuel siphoning, and unreliable fuel gauges.NTSB FTW97FA002Accident · 1 fatalField investigationFinal reportBell EAA Biplane P · Manzanola, COfailure of the pilot to maintain sufficient altitude/clearance above the terrain, while performing a low altitude maneuver. A factor relating to the accident was the pilot's lack of familiarity with this make and model of aircraft.NTSB CHI96LA344Accident · Minor injuriesLimited investigationFinal reportRozendaal Smith Innovation · Hampton, IAthe pilot's failure to refuel the airplane and his improper decision to perform a low altitude manuever with a low fuel supply.NTSB SEA96LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Gillette, WYfailure of the pilot to see-and-avoid the obstruction (power line). The powerline was a related factor.NTSB ANC96LA166Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chitina, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident is the rough and uneven landing site.NTSB ANC96LA169Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Northway, AKThe pilot's premature lift-off. A factor associated with the accident was the rough and uneven airstrip.NTSB CHI96LA299Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Portland, INthe aircraft ground looped when the pilot lost control of the aircraft during landing.NTSB SEA96LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Astoria, ORfailure of the carburetor heat box flapper valve, and the resultant air flow restriction to the carburetor. A factor relating to the accident was: high vegetation in the area where the forced landing was executed.NTSB MIA96LA190Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Georgetown, SCfailure of the pilot to see-and-avoid an obstruction on the ground (inadequate visual lookout) during a precautionary landing, which resulted in a collapsed nose gear and subsequent nose over. Factors relating to the accident were: the adverse weather…NTSB FTW96LA308Accident · No injuriesLimited investigationFinal reportDearinger Duce · Corning, ARThe pilot's failure to arrest his rate of descent and his improper recovery from a bounced landing.NTSB FTW96LA301Accident · No injuriesLimited investigationFinal reportMyers Smythe Sidewinder · El Dorado, ARthe pilot's failure to attain the correct touchdown point. Factors were: hydroplaning due to the wet runway, and the berm in the overrun area.NTSB CHI96LA229Accident · Minor injuriesLimited investigationFinal reportHewitt Cassutt 3M · Vermillion, SDthe failure of the unapproved fuel pump.NTSB ATL96LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calhoun, GAthe pilot's failure to maintain directional control during landing.NTSB LAX96LA240Accident · 1 fatalLimited investigationFinal reportExperimental Mini Mustang · Page, AZthe pilot's inadequate compensation for crosswind conditions, and his failure to maintain control of the aircraft. A factor relating to the accident was: the gusty/crosswind condition.NTSB ANC96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe obstruction of the left rudder pedal and brake by the battery cable.NTSB SEA96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Pasco, WAthe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve and collapse of the left main gear.NTSB NYC96LA109Accident · Minor injuriesLimited investigationFinal reportMcCall WATCHA-MCCALL-IT · Steamburg, NYthe pilot/owner's failure to ensure adequate maintenance/inspection of the airplane; and a loose fuel line fitting, which resulted in a subsequent fuel leak, fuel starvation, and loss of engine power. Factors relating to the accident were: the pilot's…NTSB LAX96LA193Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Compton, CAThe pilot of the other aircraft's failure to see and avoid N6WR. A factor in the accident was the narrow, confined nature of the taxiway, which restricted the Stinson pilot's ability to perform clearing turns while taxiing.NTSB SEA96LA090Accident · Serious injuriesLimited investigationFinal reportMiller MA-5 Charger · Kennewick, WAfailure of the pilot to maintain adequate airspeed, during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's lack of total and recent flight experience.NTSB ATL96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Cochran, GAfailure of the flight instructor (CFI) to maintain directional control of the airplane during takeoff, when the airplane encountered an uneven area on the airstrip and becoming airborne prematurely; and his failure to maintain clearance (or altitude) from…NTSB IAD96LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Dover, DEthe overhaul maintenance personnel's improper major overhaul procedure (improper torque on the engine block center through bolts), which resulted in an in flight loss of engine power. A related factor was the lack of suitable terrain available for a forced…NTSB ANC96LA037Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cantwell, AKThe undetermined loss of engine power and lack of suitable terrain to make a forced landing.NTSB MIA96LA091Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · Merritt Island, FLThe pilot's inadequate compensation for crosswind conditions during the landing roll, which resulted in a loss of directional control and an inadvertent ground swerve. The crosswind was a related factor.NTSB FTW96LA112Accident · No injuriesLimited investigationFinal reportMasnic SKY Hopper II · Edgewood, NMthe pilot exceeding the airplane's crosswind component which led to his inability to compensate for the crosswind conditions. A factor was the gusty winds.NTSB NYC96LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Auburn, METhe pilot's improper planning/decision and failure to attain proper alignment with the landing area. Factors relating to the accident were: darkness, and the inoperative radio transmitter, which precluded the pilot from activating the runway lights.NTSB FTW96FA085Accident · 1 fatalField investigationFinal reportSemple Smyth Sidewinder · Oklahoma City, OKThe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power, and his failure to maintain sufficient airspeed while coping with the emergency, which resulted in and inadvertent stall and subsequent spin.…NTSB SEA96LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22 · La Grande, ORThe pilot's poor judgment in attempting flight in the existing wind conditions.NTSB MIA96LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Fort Lauderdale, FLThe pilot's failure to follow procedures, resulting in the airplane being landed with the landing gear in the up position.NTSB LAX96LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Davis, CAthe pilot's failure to maintain directional control during the takeoff roll by diverting his attention.NTSB LAX96LA020Accident · No injuriesLimited investigationFinal reportPitts Special S-1C · San Carlos, CAthe pilot's misjudged landing approach, failure to achieve the proper touchdown point, and his delayed decision to abort the landing.NTSB LAX96LA019Accident · Serious injuriesLimited investigationFinal reportEaa Chapter 163 Breezy RLU-1A · Henderson, NVthe pilot's failure to maintain a proper cruise altitude and his inadequate in-flight planning. Contributing factors were encountering rising terrain and a downdraft.NTSB LAX96LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Battle Mountain, NVthe pilot's failure to see and avoid utility transmission wires suspended across the final approach flight path.NTSB ANC95FA157Accident · 1 fatalField investigationFinal reportPiper L-21A · Kaktovik, AKThe pilot's failure to maintain adequate altitude/clearance from mountainous terrain.NTSB MIA95GA178Accident · 2 fatalFinal reportPiper L-21A · Lorida, FLThe pilot's failure to maintain airspeed while his attention was diverted.NTSB ANC95FA095Accident · 1 fatalField investigationFinal reportPiper PA-18 · Nulato, AKThe pilot's failure to maintain adequate airspeed and clearance (altitude) above the water, while maneuvering at low altitude. A factor related to the accident was: the pilot's improper decision to allow a passenger to accompany the flight without a seat belt.NTSB ANC95LA096Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Homer, AKThe pilot's improper (excessive) use of the brakes after the airplane crested the landing site's crown and started downhill.NTSB SEA95LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Laurel, MTThe selection of unsuitable terrain for landing. A factor to the accident was tall vegetation.NTSB CHI95LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Hutchinson, MNthe pilot's not maintaining aircraft control. A factor was the crosswind condition.NTSB FTW95LA171Accident · No injuriesLimited investigationFinal reportChampion 7GC · Paragould, ARThe student pilot's failure to maintain directional control, resulting in an inadvertent groundloop. A factor was the instructor's inadequate supervision.NTSB FTW95LA169Accident · No injuriesLimited investigationFinal reportStembridge Spezio · Duncan, OKThe pilot's improper compensation for the wind conditions. A factor was gusty winds.NTSB SEA95LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Klamath Falls, ORThe pilot-in-command's failure to maintain directional control during takeoff, resulting in a ground loop.NTSB MIA95FA021Accident · 2 fatalField investigationFinal reportPiper PA-18 · Bainbridge, GAInadvertent stall/spin and altitude inadequate for recovery by the pilot-in-command (CFI).NTSB SEA95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Gillette, WYThe pilot in command's failure to maintain clearance with terrain. Factors contributing were the snow covered terrain and low ceiling resulting in poor contrast.NTSB LAX94FA360Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Winslow, AZthe pilot's inadvertent stall and uncontrolled descent into the ground from a low altitude while scouting for game.NTSB CHI94LA319Accident · Serious injuriesLimited investigationFinal reportSnider CP328 Super Emeraude · Painton, MOin flight delamination and subsequent failure of the hand carved wooden propeller.NTSB ANC94LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chickaloon, AKThe pilot's inadequate in-flight planning and a failure to maintain directional control of the airplane. Factors were the rising, rough/uneven terrain and the tailwind.