NTSB investigations: Lycoming 0-235 series, WA
107 cases on aircraft whose registry engine model is Lycoming 0-235 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.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505'))
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."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505'))
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 SEA90LA162Accident · 1 fatalLimited investigationFinal reportVaden SA102 Cavalier · Tumwater, WAThe pilot's failure to maintain airspeed during takeoff following an engine loss of power. The reason for the loss of power was not determined.NTSB SEA89LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Alderwood Manor, WAInadequate compensation for wind conditions by the student pilot, and inadequate supervision by the instructor pilot (CFI), which resulted in a failure to maintain proper altitude. Factors related to the accident were: unfavorable (variable) wind, downdraft,…NTSB SEA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAThe pilot's failure to obtain current in-flight wind information in order to calculate that his remaining fuel supply was adequate to reach his final destination. Contributing was his inadequate preflight planning.NTSB SEA88LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAStudent pilot executed improper flare resulting in hard landing. This was a solo flt. The student said he was high on final but thought it was okay. When he flared to land the acft dropped to the rwy and bounced. The student said he added power and raised the…NTSB SEA88LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Auburn, WAThe student pilot was practicing touch and go landings. On the eighth landing the aircraft bounced. The pilot stated that he lost control of the aircraft during the attempted recovery. The aircraft departed the runway and collided with a power company meter.NTSB SEA88LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Lewis, WAThe pilot had just received his fixed wing rating. The pilot stated that he made a hard landing. The aircraft then began to porpoise. On the third bounce the nosegear failed and the aircraft departed the runway. As the aircraft came to rest a small fire…NTSB SEA88LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Roche Harbor, WAPlt was attempting no flap landing on down-sloping narrow runway in variable and gusty wind conds. Hard landing resulted in departure from hard surface, encounter with parallel ditch and rock, and noseover.NTSB SEA88LA053Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Othello, WAThe student pilot encountered gusting winds and lost control of the aircraft during landing roll. The aircraft veered to the right of the runway and struck a parked unoccupied aircraft.NTSB SEA87FA124Accident · 2 fatalField investigationFinal reportBeech 77 · Spokane, WAOn takeoff the aircraft climbed to 50-75 ft AGL, descended in a landing attitude, touched down on the runway near the departure end and took off again. When approaching high obstructions off the end of the runway, the aircraft entered a steep climb, rolled…NTSB SEA87LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Renton, WADuring touch and goes the student plt landed hard and flat. The aircraft then bounced three times and at the end of the third bounce landed on the nose gear and propeller collapsing the nose gear.NTSB SEA86LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Snohomish, WAThe student was attempting to depart with a quartering tailwind. The aircraft was veering to the left of the centerline and the pilot rotated prematurely. The aircraft settled back to the ground to the left of the runway onto uneven terrain. At the time of…NTSB SEA86LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Ellensburg, WAA gust of wind occurred on short final and a loss of airspeed resulted at about 15 feet a.g.l the pilot failed to add power but raised the aircraft's nose to an attitude where he could no longer see the runway. Landing was accomplished to the left of the…NTSB SEA85LA045Accident · No injuriesLimited investigationFinal reportCessna A152 · Deer Park, WADuring landing practice on an instructional flight at an uncontrolled arpt, acft was being taxiied back for takeoff after a full stop landing. Surface was icy and snow-covered. Student was practicing directional control exercise with rudder. Acft skidded and…NTSB SEA85FA030Accident · 2 fatalField investigationFinal reportCessna C-152 · Port Orchard, WALow ceilings, rain, fog were reported in area pt the time of the accident. The student pilot was on a solo x-c, flt plan was filed with help of instru. Wx VFR nr. Acft dep 1104 PST acft crashed abt 1317 no rcrd of des reached or where acft was for 2 hrs. Acft…NTSB SEA84LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Touchet, WAThe acft was departing a pvt airstrip. During takeoff initial climb the eng failed. The pilot attempted to restart the engine but it would not start. During the forced landing the acft struck a fence. The pilot stated that he selected the left tip tank, which…NTSB SEA83LA150Accident · No injuriesLimited investigationFinal reportGulfstream American AA-1A · Sekiu, WAThe acft collided with a fence during an attempted go-around after a loss of directional control during the approach. The pilot stated that a crosswind carried the acft to the rt of the runway which necessitated the go-around. He further stated his airspeed…NTSB SEA83LA146Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Dixie, WAAbout an hour after departure the engine began to run rough. The pilot did a magneto check and noted a drop of 300 RPM. A precautionary landing was made into a field of tall wheat. During landing roll the left main landing gear struck a hole. Examination of…NTSB SEA83FA093Accident · 2 fatalField investigationFinal reportBeech 77 · Renton, WAThe acft was taking off for a 1 hour engine run-in following a top overhaul. After liftoff the engine began a gradual power loss and rough running. The pilot was trying turning back to the runway to land when total power loss occurred. The acft had turned 45…NTSB SEA82DA056Accident · No injuriesFinal reportPiper PA-22-108 · Snohomish, WAThe pilot stated that he kept his speed up and landed farther down the runway than usual due to other traffic. After touchdown he found that the brakes had failed so he attempted to slow down the aircraft by swerving back and forth and finally turning off on…NTSB SEA82AA126Accident · 6 fatalFinal reportCessna 172 · Mercer Island, WAN2428E, a C-172, had departed sea-tac arpt for a VFR flt to snohomish, WA, about 27 mi on the 355 deg radial from the sea-tac VORTAC. It proceeded nnw over the west shore of Mercer Island located approximately 10 mi north of the sea-tac arpt. N761EL, a…NTSB SEA82DYP01Accident · Minor injuriesClosedBellanca 7ECA · Wapato, WANTSB SEA81FA032Accident · No injuriesClosedCessna 152 · Auburn, WANTSB SEA81FA029Accident · Serious injuriesClosedVarieze Rutan · Elma, WANTSB SEA81FA022Accident · No injuriesClosedCessna 152 · Kent, WANTSB SEA80FYP36Accident · No injuriesClosedPiper PA-38 · Stratford, WANTSB SEA80DYP30Accident · No injuriesClosedCessna 152 · Spokane, WANTSB SEA80DYP24Accident · No injuriesClosedPiper PA-12 · Pasco, WANTSB SEA80DYP18Accident · No injuriesClosedPiper PA-18 · Pullman, WANTSB SEA80DYP13Accident · No injuriesClosedPiper PA-22 · Colville, WANTSB SEA80FYE09Accident · Serious injuriesClosedCessna 152 · Freeland, WANTSB SEA79DYM56Accident · No injuriesClosedTailwind W-8 · Goldendale, WANTSB SEA79FYP30Accident · Minor injuriesClosedCessna 152 · Malaga, WANTSB SEA79FYE17Accident · No injuriesClosedCessna 152 · Seattle, WANTSB SEA77FYE21Accident · No injuriesClosedAmer Avco AA-1B · Silvana, WANTSB SEA77FYP12Accident · No injuriesClosedAmer Avco AA-1 · Spokane, WANTSB SEA76FYG56Accident · Minor injuriesClosedPiper PA-16 · Colville, WANTSB SEA76DYE44Accident · Serious injuriesClosedWoodwind A · Lummi Island, WANTSB SEA76FYE23Accident · Serious injuriesClosedPiper PA-22 · Vashon, WANTSB SEA76DYC23Accident · No injuriesClosedAmer Avco AA1-A · Goldendale, WANTSB SEA76FYE21Accident · Serious injuriesClosedAmer Avco AA1-B · Oak Harbor, WANTSB SEA76DYE15Accident · No injuriesClosedAmer Avco AA1 · Hoquiam, WANTSB SEA75AS013Accident · 1 fatalClosedChampion 7ECA · Seattle, WANTSB SEA75FYE05Accident · Minor injuriesClosedCessna 140A · Stanwood, WANTSB SEA74DYE37Accident · No injuriesClosedPiper PA-12 · Blakely Isle, WANTSB SEA73FYE37Accident · 1 fatalClosedCouger 1 · Bremerton, WANTSB SEA73DYE16Accident · No injuriesClosedAmer Avco AA1A · Oak Harbor, WANTSB SEA73DYG05Accident · Minor injuriesClosedPiper PA-11 · Wapato, WANTSB SEA71FYE38Accident · No injuriesClosedChampion 7ECA · Auburn, WANTSB SEA71DWD08Accident · No injuriesClosedPiper PA-16 · Puyallup, WANTSB SEA70F0054Accident · No injuriesClosedCessna 140 · Everett, WA