Skip to content

NTSB investigations: Lycoming 0-235 series, WI

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

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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 ('41505')) 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 ('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" = '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 ('41505'))
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 CHI84LA267Accident · No injuriesLimited investigationFinal reportCessna 152 · Park Falls, WIThe plt reported that during his preflt run-up, everything seemed normal. Using short field takeoff procedures, he rotated at 40 KTS & reached an alt of about 10 ft AGL. However, he stated that the acft did not want to accelerate to the best angle of climb…Jun 26, 1984 · N757DR · Substantial damage NTSB CHI84LA210Accident · Minor injuriesLimited investigationFinal reportWagner Cuby WAG-A-BOND · Lyons, WIThe plt noticed '...a little power loss...' After takeoff at about 550 AGL. He turned downwind & flew a normal traffic pattern, but at a lower altitude. The acft stalled during the base turn. The plt stated that the loss of power was due to the mixture…May 27, 1984 · N34WA · Substantial damage NTSB CHI84LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Ft Atkinson, WIThe acft stalled during a short field takeoff after a landing during which full up trim was used. The student plt did not use a checklist or reset the trim prior to takeoff.May 4, 1984 · N25583 · Substantial damage NTSB CHI84LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Milwaukee, WIThe student plt stated that the acft bounced on the first touchdown and then contacted the rwy with the nose gear. Afterthe nose gear collapsed the acft nosed over.Feb 22, 1984 · N5355P · Substantial damage NTSB CHI84LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Lone Rock, WIDuring the takeoff following a touch and go landing the acft swerved to the left and collided with a snowbank. The plt said he reached for the carburetor heat control and flap handle as the acft swerved. After the collision the acft nosed over.Jan 31, 1984 · N25216 · Substantial damage NTSB CHI84LA088Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Holman, WIAfter flying in the local area for aprx 40 minutes the plt decided to shoot a landing at an airpark before returning to his home arpt. The plt stated that he applied carb heat on the downwind leg and then returned it to off position. He flew the remainder of…Jan 18, 1984 · N9555T · Substantial damage NTSB CHI83FA351Accident · No injuriesField investigationFinal reportSwain Rutan Longeze · Oshkosh, WIThe acft nosed over during a forced landing after a power loss. The acft collided with tall corn during the landing rolland swerved into the corn. Examination of the carburetor revealed pieces of a soft brownish-white somewhat elastic substance in the float…Aug 2, 1983 · N4ZZ · Substantial damage NTSB CHI83LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Milwaukee, WIDuring landing the pax had her legs positioned in such a manner that they interfered with the movement of the yoke. When the plt requested she clear the yoke, she put her left foot on the rudder pedal/brake causing the acft to veer off the left side of the…Jun 13, 1983 · N6566P · Substantial damage NTSB CHI83LA245Accident · No injuriesLimited investigationFinal reportAeronca 7ECA · Wentworth, WIThe CFI stated that he gave the student a simulated emergency landing. When the acft was about 10-20 ft above the ground a gust of wind caught the acft. The acft dropped suddenly and hit the ground. The landing gear folded and the fuselage and wing tips were…Jun 8, 1983 · N2563F · Substantial damage NTSB CHI83LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · New Richmond, WIThe student pilot on his 2nd solo flt made a hard landing which collapsed the nose gear. This was the 1st landing of theflight and the pilot touched down nose gear first. The nose gear collapsed and folded backward. The underside of the cowling was bent, the…May 17, 1983 · N67613 · Substantial damage NTSB CHI82DA309Accident · No injuriesFinal reportCessna 152 · Boyceville, WISolo student pilot on 2nd takeoff after a delay aborted the takeoff. During abort he lost control and ground- looped into a pile of logs. The aircraft then nosed over.Aug 12, 1982 · N25325 · Substantial damage NTSB CHI82DA138Accident · No injuriesFinal reportCessna 152 · New London, WIThe pilot elected to land on a private strip he was not familiar with. He was not aware of the 3-4 inches of standing water on the sod surface when he touched down. The aircraft nosed over during landing roll.Apr 28, 1982 · N68710 · Destroyed NTSB CHI82DA083Accident · No injuriesFinal reportCessna 152 · Milwaukee, WIThe student was practicing touch and go landings on a snow covered runway. After applying power for takeoff during the third touch and go, the aircraft veered left and hit a snowbank.Mar 5, 1982 · N6125B · Substantial damage NTSB CHI82DEP14Accident · No injuriesClosedCessna 152 · Pewaukee, WIDec 16, 1981 · N6464L · Substantial damage NTSB CHI82DEP11Accident · No injuriesClosedCessna 152 · Monroe, WINov 29, 1981 · N47808 · Substantial damage NTSB CHI81DEP07Accident · No injuriesClosedBellanca 7ECA · Neenah, WIOct 27, 1981 · N1195E · Substantial damage NTSB CHI82DEP06Accident · No injuriesClosedCessna 152 · Monroe, WIOct 24, 1981 · N4609B · Substantial damage NTSB CHI81DEP33Accident · No injuriesClosedCessna 152 · Milwaukee, WIJul 11, 1981 · N5355P · Substantial damage NTSB CHI81DEP28Accident · No injuriesClosedCessna 152 · Pewaukee, WIJun 26, 1981 · N48990 · Substantial damage NTSB CHI81FEP19Accident · No injuriesClosedPiper PA-12 · Spring Green, WIMay 25, 1981 · N78459 · Substantial damage NTSB CHI81DER34Accident · No injuriesClosedCessna 152 · Boyceville, WIMay 1, 1981 · N67613 · Substantial damage NTSB CHI81DEP15Accident · No injuriesClosedCessna 152 · Middleton, WIApr 7, 1981 · N4777H · Substantial damage NTSB CHI81DEP08Accident · No injuriesClosedCessna 152 · Baraboo, WIJan 15, 1981 · N65549 · Substantial damage NTSB CHI80DEP37Accident · No injuriesClosedCessna 152 · Platteville, WIMay 12, 1980 · N25990 · Substantial damage NTSB CHI80DEP28Accident · No injuriesClosedCessna 152 · Tilden, WIMay 4, 1980 · N757SV · Substantial damage NTSB CHI80DEP23Accident · No injuriesClosedPiper PA-12 · Mount Vernon, WIApr 22, 1980 · N3181M · Substantial damage NTSB CHI80FEP04Accident · Minor injuriesClosedCessna 152 · Lake Geneva, WIOct 19, 1979 · N714VN · Substantial damage NTSB CHI79DEP32Accident · No injuriesClosedCessna 152 · Eau Claire, WIFeb 26, 1979 · N89048 · Substantial damage NTSB CHI79DEP30Accident · No injuriesClosedCessna 152 · Hartford, WIFeb 19, 1979 · N757PG · Substantial damage NTSB CHI79DEP19Accident · No injuriesClosedGrumman AA-1C · Madison, WIDec 26, 1978 · N9649U · Substantial damage NTSB CHI78FEP47Accident · 1 fatalClosedChampion 7ECA · Howard, WIAug 13, 1978 · N9681S · Substantial damage NTSB CHI77DEP46Accident · No injuriesClosedGrum Amer AA1B · Waunakee, WIJul 25, 1977 · N9698L · Substantial damage NTSB CHI77DEP11Accident · No injuriesClosedPiper PA-22 · West Bend, WIDec 21, 1976 · N5835Z · Substantial damage NTSB CHI76DEP26Accident · No injuriesClosedPiper PA-18 · Milwaukee, WIFeb 23, 1976 · N326T · Substantial damage NTSB CHI75FEP68Accident · Serious injuriesClosedGrum Amer AA1 · Delavan, WIJun 12, 1975 · N6543L · Substantial damage NTSB CHI75AC086Accident · No injuriesClosedPiper PA-16 · Janesville, WIMay 10, 1975 · N5382H · 2 aircraft · Minor damage NTSB CHI74DEP45Accident · No injuriesClosedAmer Avco AA1-A · Brodhead, WIApr 27, 1974 · N9394L · Substantial damage NTSB CHI74FEP41Accident · No injuriesClosedAmer Avco AA-1B · Waunakee, WIApr 15, 1974 · N9621L · Substantial damage NTSB CHI72DEP47Accident · No injuriesClosedChampion 7ECA · Dousman, WIJun 6, 1972 · N11852 · Substantial damage NTSB CHI71DDJ37Accident · No injuriesClosedPiper PA-22 · Platteville, WIJan 20, 1971 · N4990Z · Substantial damage NTSB CHI71DDJ25Accident · No injuriesClosedPiper PA-22 · Niagara, WIOct 6, 1970 · N5815Z · Substantial damage NTSB CHI69D0294Accident · Minor injuriesClosedPiper PA-22 · Platteville, WIAug 9, 1968 · N4990Z · Substantial damage NTSB CHI68D0580Accident · No injuriesClosedPiper PA-22 · Platteville, WIFeb 3, 1968 · N4990Z · Substantial damage NTSB CHI68D0385Accident · No injuriesClosedPiper PA-18 · Beaver Dam, WIOct 21, 1967 · N326T · Substantial damage NTSB CHI67D0524Accident · No injuriesClosedPiper PA-22 · Eleva, WIMar 14, 1967 · N5315Z · Substantial damage NTSB MKC67D0479Accident · No injuriesClosedChampion 7GCBC · Osceola, WIFeb 27, 1967 · N5189T · Substantial damage NTSB CHI67D0014Accident · No injuriesClosedPiper PA22 · Janesville, WIMay 30, 1966 · N5156Z · Substantial damage NTSB CHI66D0593Accident · No injuriesClosedPiper PA-22 · Janesville, WIJan 30, 1966 · N5815Z · Substantial damage NTSB CHI66F0364Accident · No injuriesClosedPiper PA-12 · Dallas, WIJul 4, 1965 · N4227M · Substantial damage NTSB CHI65F0172Accident · No injuriesClosedPiper PA-22 · Eau Claire, WIApr 2, 1965 · N5272Z · Substantial damage