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 ANC00LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mccarthy, AKThe pilot's inadequate compensation for the gusty wind conditions. A factor associated with the accident was the wind gusts.NTSB NYC00LA114Accident · No injuriesLimited investigationFinal reportLoomis Sidewinder · Cincinnati, OHA partial power loss for undetermined reasons.NTSB LAX00LA150Accident · Minor injuriesLimited investigationFinal reportTaylor Smith Witman W-10 · Riverside, CAfailure of the pilot to recover from a bounced landing resulting in a loss of directional control and collision with a fence.NTSB CHI00LA099Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Ft. Leavenworth, KSthe pilot of N51933 did not see and maintain clearance from N9570E. A factor associated with the accident was the pilot of N51933's restricted forward visibility during the landing due to the tailwheel configuration. An additional factor was the pilot of…NTSB LAX00LA058Accident · No injuriesLimited investigationFinal reportO'Hara Bob Bakeng Duce · Carson City, NVThe pilot's misjudged distance/altitude during final approach to landing, which led to an undershoot and subsequent collision with obstacles.NTSB NYC00LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Wales, MEFuel exhaustion due to a blocked fuel feed line.NTSB FTW00LA031Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Rose Hill, TXThe pilot's failure to maintain directional control during takeoff roll, which resulted in an inadvertent ground loop.NTSB FTW00LA015Accident · 2 fatalLimited investigationFinal reportSturges Spezio Sport · Mathis, TXthe pilot's failure to maintain clearance with the power lines while maneuvering.NTSB NYC00LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Hoffmeister, NYThe pilot failure to maintain directional control while step-taxiing. A factor in the accident was gusty winds.NTSB NYC99LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Andover, NJFatigue failure of the crankshaft.NTSB CHI99FA311Accident · 1 fatalField investigationFinal reportWalker Breezy · Janesville, WIthe inadvertent stall. A factor relating to this accident was the pilot's excessive climb rate.NTSB CHI99FA213Accident · 1 fatalField investigationFinal reportLarson Smith Miniplane DSA-1 · Blackduck, MNAircraft control not being maintained by the pilot. Factors to the accident were the aerobatic maneuvers being flown by the pilot and the encountered spiral.NTSB SEA99LA103Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Billings, MTThe separation of the left main landing gear shock strut for undetermined reasons.NTSB FTW99FA171Accident · 1 fatalField investigationFinal reportHeilig-Reading Emeraude CP 301A · Altus, ARThe pilot's failure to maintain clearance with a wire, during an approach to a private airstrip.NTSB FTW99LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Panhandle, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the noise heard by the pilot that resulted in his decision to execute a precautionary landing.NTSB DEN99LA091Accident · Serious injuriesLimited investigationFinal reportCrozier Emeraude · Delta, COThe pilot's failure to maintain directional control. Factors were the gusty tailwind and crosswinds reported, and the pilot's total lack of aeronautical experience.NTSB ANC99LA062Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe inadequate preflight by the pilot, who left the rudder gust lock installed, making directional control not possible.NTSB CHI99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-L21B · Vincennes, INthe pilot's failure to maintain directional control after landing. Factors which contributed to this accident were the pilot's long touchdown, the rough area on the runway, and the wheat field.NTSB LAX99LA171Accident · Minor injuriesLimited investigationFinal reportWidner RV-3A · Casa Grande, AZThe pilot's inadequate compensation for the existing crosswind condition and his subsequent failure to maintain directional control during the takeoff roll. The pilot's distraction in looking for the aircraft which announced an intention to land in the…NTSB ANC99LA054Accident · No injuriesLimited investigationFinal reportPiper PA-18 · King Salmon, AKThe pilot's failure to maintain directional control. A factor associated with the accident was an inadvertent ground loop.NTSB LAX99LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Novato, CAThe failure of the pilot to adequately compensate for the wind conditions and to maintain directional control of the aircraft while landing. A factor is the airport's failure to follow proper procedure in ensuring adequate obstacle and object free clearance…NTSB FTW99LA087Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Fort Worth, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop/swerve. A factor was the crosswind.NTSB ATL99LA028Accident · Minor injuriesLimited investigationFinal reportSid Champion Jurca MJ-5 · Madison, MSA loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.NTSB ANC98LA158Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mcgrath, AKThe failure of the pilot to maintain directional control during takeoff. Factors involved in the accident were a crosswind, and the trees adjacent to the takeoff area.NTSB CHI98LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Janesville, WIthe pilot's failure to land the airplane at a proper touchdown point on the runway. A factor was the excessive rate of descent which developed on final approach.NTSB LAX98LA285Accident · No injuriesLimited investigationFinal reportMohr EAA Biplane P · Gilroy, CAFailure of the pilot to adequately compensate for the existing crosswind.NTSB LAX98LA266Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Rio Vista, CAFailure of the pilot to adequately compensate for the existing wind condition and maintain directional control on rollout.NTSB SEA98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Columbus, MTPartial loss of power for undetermined reasons. Factors include the pilot's selection of unsuitable terrain for a precautionary landing.NTSB FTW98LA332Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Rock Springs, WYThe pilot's failure to maintain directional control, and an inadvertent ground loop/swerve.NTSB CHI98LA247Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Nehawka, NEthe pilot's improper fuel management and his improper use of the fuel tank selector. Factors were fuel starvation and crops.NTSB ANC98LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's failure to identify an unsafe/hazardous condition. A related factor was the ditch.NTSB LAX98FA208Accident · 1 fatalField investigationFinal reportFrandsen Midget Mustang MM-1 · Tracy, CAinadequate maintenance/inspection by the owner/pilot that resulted in an obstructed fuel vent system and a subsequent loss of engine power during takeoff.NTSB ANC98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Anchorage, AKThe pilot's inadvertent ground loop.NTSB IAD98LA058Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Winchester, VAImproper flare. A related factor was the pilot's diverted attention.NTSB SEA98LA067Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Arlington, WAThe pilot's failure to maintain directional control during the landing roll, and his delayed remedial action when the aircraft started to drift off the side of the runway.NTSB MIA98LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · St. Petersburg, FLThe intentional operation of the airplane by the pilot and the company/operator with the known deficiencies in equipment (worn carburetor). Also, the poor preflight planning by the pilot for his failure to recognize that the carburetor heat control was…NTSB IAD98FA044Accident · 2 fatalField investigationFinal reportPiper PA-20 · Beaver Falls, PAThe pilot's failure to maintain aircraft control, and his failure to attain adequate airspeed, which resulted in a stall. Contributing was the pilot's lack of familiarity with the airplane, and his misjudgment of wind information which resulted in a tailwind…NTSB FTW98LA169Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Wright, WYThe pilot's use of unsuitable terrain for takeoff. Factors were snow and rock covered terrain, inadequate aircraft preflight, improper aircraft servicing, and the fuel contaminated by water.NTSB ATL98LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hampton, GAThe pilot's failure to maintain directional control during a full stop landing roll.NTSB SEA98LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kalispell, MTThe pilot's failure to maintain adequate crosswind correction during landing. A factor was a crosswind.NTSB ANC98LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's continued VFR over-the-top operation, becoming lost/disoriented, his inadequate in-flight planning/decision making, and subsequent fuel exhaustion. Factors in the accident were the presence of a cloud layer below the pilot's selected altitude, the…NTSB FTW98FA101Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Wooster, ARthe pilot's failure to maintain clearance with trees during an aborted landing. A contributing factor was the pilot's delayed decision to abort the long landing.NTSB FTW98LA087Accident · No injuriesLimited investigationFinal reportStarduster SA-100 · Roland, ARThe pilot's inadvertent encounter with soft, wet grass during landing.NTSB ANC98LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Naknek, AKThe loss of engine power due to the pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB ANC97LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's misjudgment of the touchdown point, which led to undershoot and the airplane nosing over.NTSB ANC97LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Healy, AKthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane and runway alignment. Factors relating to the accident were: the crosswind, and the proximity of a creek (ravine) to the runway.NTSB FTW97LA179Accident · Serious injuriesLimited investigationFinal reportCallair A2A · Grants, NMInadvertent stall. Factors were the ground depression, the high density altitude, and a lack of recent experience in the make and model of aircraft.NTSB LAX97LA171Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAthe pilot's failure to obtain and/or maintain adequate airspeed during initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. A factor relating to the accident was: the degraded climb performance due to an…NTSB NYC97LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Clayton Lake, MEthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an inadvertent stall, and uncontrolled descent to the frozen lake surface.NTSB NYC97LA020Accident · No injuriesLimited investigationFinal reportZukowski EAA Biplane · Williamsport, PAthe pilot's inadequate preflight preparation, which resulted in opening of the unsecured canopy during the takeoff roll, and subsequent loss of directional control and a nose over. A factor was: the pilot's failure to use a checklist.