Skip to content

NTSB investigations: Lycoming 0-290 series, WY

26 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'WY' 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 ('41506')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'WY' 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 ('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."eventStateOrRegion" = 'WY' 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 ('41506'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 DEN04LA070Accident · No injuriesLimited investigationFinal reportCrimmins Smyth Sidewinder · Natrona, WYfuel starvation due to contamination, resulting in the fuel selector valve becoming totally blocked. Contributing factors were the inadequate conditional inspection, and the lack of nsuitable terrain on which to make a forced landing.May 7, 2004 · N92AC · Substantial damage NTSB DEN03LA091Accident · No injuriesLimited investigationFinal reportChampion 7GC · Casper, WYthe pilot's failure to maintain directional control of the aircraft during the landing. Contributing factors include the inadequate remedial action by the pilot and the pilot's lack of experience in the aircraft.May 30, 2003 · N5923L · Substantial damage 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.Jul 25, 1998 · N1202C · Substantial damage 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.Mar 31, 1998 · N4484E · Substantial damage 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.Sep 19, 1996 · N8789C · Substantial damage 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.Nov 3, 1994 · N7566K · Substantial damage NTSB SEA93LA131Accident · No injuriesLimited investigationFinal reportChampion 7GC · Gillette, WYThe pilot in command's not maintaining directional control and the overload of the left main landing gear. A factor contributing to the accident was the pilot's lack of experience in conventionally geared aircraft.Jun 14, 1993 · N8947R · Substantial damage NTSB SEA91LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Laramie, WYThe pilot's failure to maintain an airspeed above the stall speed for the aircraft. Contributing to the accident was the high density altitude.May 22, 1991 · N2234A · Substantial damage NTSB DEN87DTI02Accident · No injuriesFinal reportBakeng Deuce · Gillette, WYThe plt rprtd that on each of his 1st 3 attempts to land, he began losing directional control during roll-out & went around. On the 4th attempt, he again tried to go around, but the acft swerved off the rwy & ground looped, collapsing the left main gear &…Sep 21, 1987 · N9659A · Substantial damage NTSB DEN86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Worland, WYOn landing, wind gust lifted left wing and tail section. Acft nosed over.Aug 8, 1986 · N1590P · Destroyed NTSB DEN85LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYThe student plt had the acft owner's (employer) permission to use the acft for solo practice toward obtaining his private plt certificate. Plt was ranch employee and knew one ranch manager would be looking for sheep, plt diverted from instructor's…Dec 25, 1984 · N1212A · Substantial damage NTSB DEN83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hulett, WYThe acft struck a deer while landing into the sun at a private ranch strip. The animal was seen just before touchdown but not in time to avoid hitting it.Apr 14, 1983 · N8254C · Substantial damage NTSB DEN82DA105Accident · No injuriesFinal reportPiper PA-20 · Near Rawlins, WYThe pilot stated that he had landed on a blacktop road, but opted to takeoff on a gravel road because of the proximity of reflector posts to the wings. He stepped off the road and estimated that he had about 800 ft for takeoff. The density altitude was about…Jun 19, 1982 · N3411A · Substantial damage NTSB DEN80FTC14Accident · No injuriesClosedPiper PA-18 · Hulett, WYMay 6, 1980 · N8254C · Substantial damage NTSB DEN76DTC31Accident · No injuriesClosedPiper PA-18 · Sheridan, WYApr 13, 1976 · N1112A · Substantial damage NTSB DEN76AD031Accident · 1 fatalClosedPiper PA-18 · Colony, WYFeb 14, 1976 · N1636A · Destroyed NTSB DEN75DTC10Accident · No injuriesClosedPiper PA-18 · Rock Springs, WYNov 28, 1974 · N1379A · Substantial damage NTSB DEN73FTC21Accident · Minor injuriesClosedPiper PA-18A · Bosler, WYMar 18, 1973 · N1385C · Destroyed NTSB DEN71FXT10Accident · No injuriesClosedPiper PA-20 · Evanston, WYSep 15, 1970 · N7414K · Substantial damage NTSB DEN70DXA08Accident · No injuriesClosedPiper PA-18 · Sheridan, WYMar 28, 1970 · N1112A · Substantial damage NTSB DEN70DXA02Accident · No injuriesClosedPiper PA-22 · Guernsey, WYJan 12, 1970 · N2221A · Substantial damage NTSB DEN70D0016Accident · No injuriesClosedPiper PA-22 · Cokeville, WYMay 4, 1969 · N8585C · Substantial damage NTSB DEN66D0282Accident · No injuriesClosedPiper J3C · Big Piney, WYFeb 7, 1966 · N98859 · Substantial damage NTSB DEN66A0019Accident · No injuriesClosedPiper PA-22 · Cheyenne, WYSep 19, 1965 · N629A · Substantial damage NTSB UNK64X1339Accident · No injuriesClosedPiper PA18 · Buffalo Arpt, WYApr 16, 1964 · N7211K · Substantial damage NTSB UNK64X0425Accident · No injuriesClosedPiper PA20 · Glendo, WYFeb 1, 1964 · N4946M · Substantial damage