Skip to content

NTSB investigations: Lycoming 0-290 series, WI

29 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" = 'WI' 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\" = 'WI' 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" = 'WI' 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 CEN25LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Oshkosh, WIThe pilot’s aggressive brake application which resulted in a loss of directional control and a ground loop.Jul 18, 2025 · N7369K · Substantial damage 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.Jul 30, 2008 · N3671A · Substantial damage 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.Jul 24, 2008 · N3149U · Substantial damage NTSB CHI03LA308Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wausau, WIThe excessive free play resulting in a loose tail wheel assembly and a failure of the flight crew to maintain directional control during the landing rollout.Sep 8, 2003 · N5595H · Substantial damage NTSB CHI03LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Prescott, WIThe pilot delaying the go-around and the maneuver to avoid the treeline. Factors to the accident were the treeline and the airplane's low altitude.May 15, 2003 · N2581A · Substantial damage NTSB CHI02LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA22-135 · Lyons, WIFailure of the pilot to maintain a sufficient rate-of-climb and to obtain a safe altitude/clearance from the tree line at end of the runway. Contributing factors were the uphill runway gradient and the trees.Aug 2, 2002 · N3522A · Substantial damage NTSB CHI02FA200Accident · No injuriesField investigationFinal reportPiper PA-20 · Oshkosh, WIInadequate visual lookout by both the accident pilot and the pilot of the other airplane. An additional cause is the arrival procedure used which resulted in a congested traffic pattern and the subsequent inadequate visual separation of the airplanes. Factors…Jul 21, 2002 · N1592A · Substantial damage NTSB CHI99FA311Accident · 1 fatalField investigationFinal reportWalker Breezy · Janesville, WIthe inadvertent stall. A factor relating to this accident was the pilot's excessive climb rate.Aug 27, 1999 · N12BZ · Destroyed 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.Sep 17, 1998 · N4749Z · Substantial damage NTSB CHI94LA237Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Butte Des Mort, WIA delayed remedial action by the instructor. A factor in this accident was a proper airspeed not being attained by the dual student.Jul 20, 1994 · N9843Q · Substantial damage NTSB CHI88DER09Accident · Serious injuriesFinal reportSmith Miniplane · Superior, WIWhile in normal cruise the aircraft experienced a total loss of engine power. The pilot executed an emergency descent to a forced landing. The aircraft encountered unsuitable terrain which resulted in a hard landing and substantial damage to the aircraft. The…Aug 21, 1988 · N39F · Substantial damage NTSB CHI86FEP06Accident · No injuriesFinal reportPatton Pitts S-1C · Hartford, WIThe plt was on an aerobatic competition flt. He reported that after finishing a sequence of aerobatic maneuvers, he returned to the rwy to land. During the landing, the acft was high on final apch & touched down to FAR down the 2100 ft rwy. It then contd off…Jul 19, 1986 · N3507 · Substantial damage NTSB CHI85LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Iola, WIUpon takeoff at approximately 100 ft AGL the pilot experienced a partial power loss which necessitated a forced landing in a soft, wet potato field. The pilot had time to switch fuel tanks and magnetos prior to touchdown, but the power loss remained constant.…Jul 13, 1985 · N1487A · Substantial damage NTSB CHI80FEP40Accident · No injuriesClosedPitts S-1C · Wyocena, WIJul 13, 1980 · N2761 · Substantial damage NTSB CHI79FEP68Accident · No injuriesClosedBakeng Duce · Oskhosh, WIJul 29, 1979 · N9659A · Substantial damage NTSB CHI78FEP51Accident · No injuriesClosedPiper PA-22 · Milwaukee, WIJul 28, 1978 · N8195C · Substantial damage NTSB CHI78DEP38Accident · No injuriesClosedPiper PA-18 · Lake Winnebego, WIJun 15, 1978 · N9843Q · Substantial damage NTSB CHI77FA062Accident · 1 fatalClosedBellanca 7ACA · Oshkosh, WIAug 1, 1977 · N12204 · 2 aircraft · Destroyed NTSB CHI76DEP24Accident · No injuriesClosedPiper PA-20 · Baraboo, WIFeb 8, 1976 · N7354K · Substantial damage NTSB CHI76DEP22Accident · No injuriesClosedPiper PA-22 · Rhinelander, WIJan 15, 1976 · N3347A · Substantial damage NTSB CHI75FER01Accident · Minor injuriesClosedVollmer Sprts · Webster, WIAug 3, 1974 · N4646T · Substantial damage NTSB CHI72FEP37Accident · No injuriesClosedPiper PA-20 · Twin Lakes, WIApr 15, 1972 · N6978K · Substantial damage NTSB CHI70D0012Accident · No injuriesClosedPiper PA-22 · Madison, WIApr 18, 1969 · N3347A · Substantial damage NTSB CHI69D0129Accident · No injuriesClosedPiper PA-22 · Neenah, WIJul 7, 1968 · N2244A · Substantial damage NTSB CHI66F0028Accident · No injuriesClosedPiper PA-20 · Cable, WIMar 6, 1965 · N1145C · 2 aircraft · Substantial damage NTSB CHI65F0041Accident · No injuriesClosedAeronca 7HC · Watertown, WIFeb 27, 1965 · N9818Y · Substantial damage NTSB UNK65X1343Accident · Serious injuriesClosedPiper PA-18 · Tustin, WIJan 24, 1965 · N1021A · Destroyed NTSB UNK65X1053Accident · No injuriesClosedPiper PA22 · Marshfield, WIDec 19, 1964 · N940A · Substantial damage NTSB UNK64X2610Accident · Serious injuriesClosedPiper PA18A · Waupun, WIJul 2, 1964 · N8078C · Destroyed