Skip to content

NTSB investigations: Lycoming 0-235 series, IA

50 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 per year

19642026

NTSB investigations: Lycoming 0-235 series, IA per year, 1964–2026: 50 cases
1964	2
1965	3
1966	2
1967	3
1968	1
1969	3
1970	2
1971	2
1972	1
1973	1
1974	1
1975	3
1977	1
1978	1
1979	4
1980	1
1981	2
1982	2
1983	1
1984	2
1985	1
1986	2
1988	1
1989	1
1993	2
1994	1
1998	2
2005	1
2012	1

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" = 'IA' 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\" = 'IA' 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" = 'IA' 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 CEN12CA503Accident · No injuriesData collectionFinal reportPiper PA-16 · Keokuk, IAThe pilot’s loss of directional control during the landing roll in a variable crosswind, which resulted in a runway excursion.Jul 29, 2012 · N6834K · Substantial damage NTSB CHI06CA049Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Spirit Lake, IAThe pilot using an unsuitable runway and not maintaining directional control during the landing leading to the nose over on impact with snow. A factor was the snow that remained on the runway after plowing.Dec 21, 2005 · N4680Z · Substantial damage NTSB CHI99FA052Accident · 1 fatalField investigationFinal reportCessna 152 · Sherrill, IAthe pilot continued flying with a known discrepancy and he failed to maintain airspeed and lost control of the airplane while attempting a forced landing. Factors included the tailwind and the undetermined loss of power.Dec 17, 1998 · N5314B · Destroyed NTSB CHI99LA034Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Carrol, IAthe pilot's inadequate preflight inpection of the fuel tanks and filler neck caps before departure. Factors associated with this accident were the leaking right wing fuel tank filler cap and fuel exhaution.Nov 22, 1998 · N92585 · Substantial damage NTSB CHI94LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAthe student pilot's improper recovery from a bounced landing. The student pilot's lack of total flight experience was a factor.Mar 25, 1994 · N89761 · Substantial damage NTSB CHI93LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, IAthe failure of the pilot to refuel prior to fuel exhaustion.Aug 2, 1993 · N49899 · Substantial damage NTSB CHI93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Lineville, IACarburetor ice as a result of the pilot-in-command's improper use of carburetor heat.Jan 19, 1993 · N60SX · Substantial damage NTSB MKC90LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Toledo, IAThe pilot became lost/disorientated and attempted a landing at the wrong airport. Factors related to the accident were: darkness, unfavorable wind condition, and the student pilot's lack of experience in the type of operation.Nov 7, 1989 · N6449M · Substantial damage NTSB MKC88LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, IAArriving at the destination apt, on a solo cross country flt, the plt said UNICOM advised a landing on rwy 18. The local fss reported the winds to be out of the northwest favoring runway 36. The plt elected to land on rnwy 18 based on the UNICOM advisory, and…Sep 6, 1988 · N5458P · Substantial damage NTSB MKC86LA185Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Onawa, IAThe student plt was making touch-&-go landings while on a supervised solo flt. During her 3rd landing, the acft touched down hard & bounced, then after touching down again, it went off the left side of the rwy, hit a ditch & was damaged.Sep 3, 1986 · N45986 · Substantial damage NTSB MKC86FCD02Accident · Serious injuriesFinal reportPiper PA18 · Sloan, IAThe acft stalled during a low alt steep turn immediately after takeoff. The acft collided with the ground aprx 300 ft east of the rwy. No malfunctions in equipment were found. The plt stated that he was turning steeply to avoid another acft. Statements of two…Jun 24, 1986 · N243T · Substantial damage NTSB MKC85LA224Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Council Bluffs, IAOn climbout fm the Council Bluffs airport the plt reported a loss of engine power and the engine quitting. The plt attempted an air restart but was too low to the grnd to continue. The plt weaved in and out of trees during his descent finally impacting the…Sep 30, 1985 · N1008E · Substantial damage NTSB MKC85LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Burlington, IAAccording to the pilot the descent into the traffic pattern was late and the base turn performed early leaving the acft high on final. As a result, an excessive rate of descent developed on short final. The high descent rate and diminishing daylight led the…Nov 12, 1984 · N2454B · Substantial damage NTSB MKC84FA234Accident · 2 fatalField investigationFinal reportSims - Basset Varieze · Clarinda, IAWitnesses observed a ground run of aprx 2000 ft before lift-off was achieved after which the acft appeared to climb laboriously to about 100 ft AGL. Acft then executed steep, descending rt turn of about 240 degrees back toward the arpt. Acft collided with pwr…Jul 27, 1984 · N4229G · Destroyed NTSB MKC84LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Clear Lake, IAThe student plt was on a x-country flt that had originated at ames, IA. While enroute, he had landed at carroll, IA, but did not refuel. He stated that he was on a long, right base leg to land on rwy 12 at the mason city muni arpt when the eng began loosing…Oct 9, 1983 · N69035 · Substantial damage NTSB MKC83LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAStudent pilot tried to contact tower on incorrect frequency. Approach was high and long. Stalled aircraft 25 feet AGL half way down runway.Nov 16, 1982 · N68138 · Substantial damage NTSB MKC82DA060Accident · No injuriesFinal reportPiper PA-38-112 · Dubuque, IAThe student pilot was on a solo cross-country flight. After arriving at Dubuque, he landed on runway 18. The student stated that the wind was from 230 degrees at 16, gusting 23 knots. He reported that during the landing, the plane was lifted off two times by…Apr 24, 1982 · N2586B · Substantial damage NTSB MKC81FA022Accident · 2 fatalClosedAmer Avco AA-1A · Council Bluffs, IAFeb 25, 1981 · N332A · Destroyed NTSB MKC81FCD07Accident · No injuriesClosedPiper PA-38 · Cedar Rapids, IAJan 23, 1981 · N2531C · Substantial damage NTSB MKC80DCD28Accident · No injuriesClosedBellanca 7ECA · Boone, IAJul 31, 1980 · N5068Y · Substantial damage NTSB MKC80DCD05Accident · No injuriesClosedPiper PA-22 · Des Moines, IAOct 27, 1979 · N8194C · 2 aircraft · Substantial damage NTSB MKC79DCD40Accident · No injuriesClosedCessna 152 · Oxford, IASep 12, 1979 · N65465 · Substantial damage NTSB MKC79DCD35Accident · No injuriesClosedCessna 152 · Mt Pleasant, IAAug 27, 1979 · N24366 · Substantial damage NTSB MKC79DCD29Accident · No injuriesClosedPiper PA-38 · Ladora, IAJul 10, 1979 · N2313A · Substantial damage NTSB MKC79FCD04Accident · No injuriesClosedCessna 152 · Muscatine, IADec 10, 1978 · N49159 · Substantial damage NTSB MKC77DCD49Accident · No injuriesClosedPiper PA-12 · Denison, IASep 13, 1977 · N2758M · Substantial damage NTSB MKC76DCD23Accident · No injuriesClosedChampion 7ECA · Mediapolis, IADec 21, 1975 · N3057G · Substantial damage NTSB MKC76FCD16Accident · Minor injuriesClosedPiper PA-22 · Kalona, IAOct 15, 1975 · N5520Z · Substantial damage NTSB MKC76FCD12Accident · No injuriesClosedGrum Amer AA-1B · Boone, IASep 10, 1975 · N9650L · Substantial damage NTSB MKC74DCD28Accident · No injuriesClosedPiper PA-20 · Waterloo, IAApr 26, 1974 · N7420K · Substantial damage NTSB MKC73DCD66Accident · No injuriesClosedPiper PA-12 · Davenport, IAMay 13, 1973 · N4014M · Substantial damage NTSB MKC73AK020Accident · 1 fatalClosedAmer Avco AA-1A · Waterloo, IASep 3, 1972 · N9377L · Minor damage NTSB MKC72FGD29Accident · No injuriesClosedAmer Avco AA-1 · Blakesburg, IASep 5, 1971 · N5973L · Substantial damage NTSB MKC72FCD01Accident · Minor injuriesClosedPiper PA-22 · Knoxville, IAJul 7, 1971 · N4545Z · Substantial damage NTSB MKC70DCD08Accident · No injuriesClosedPiper PA-16 · Carlisle, IAJan 24, 1970 · N5932H · Substantial damage NTSB MKC70FCD09Accident · No injuriesClosedPiper PA-14 · Gravity, IAJan 9, 1970 · N5184H · Substantial damage NTSB MKC70F0218Accident · No injuriesClosedPiper PA-22 · Cedar Falls, IASep 27, 1969 · N5970Z · Substantial damage NTSB MKC70F018OAccident · Serious injuriesClosedBreezy 17A · Washington, IASep 10, 1969 · N1683 · Minor damage NTSB MKC69F0428Accident · Serious injuriesClosedPiper PA-16 · Adel, IAMay 11, 1969 · N5710H · Destroyed NTSB MKC69D0037Accident · No injuriesClosedPiper PA-22 · Rockwell, IAJun 29, 1968 · N5333Z · Substantial damage NTSB MKC68D0098Accident · No injuriesClosedPiper PA-22 · Des Moines, IAAug 3, 1967 · N4526Z · Substantial damage NTSB MKC67D0571Accident · No injuriesClosedPiper PA-22 · Ankeny, IAMay 1, 1967 · N4526Z · Substantial damage NTSB MKC67D0565Accident · No injuriesClosedPiper PA-12 · Mantelle, IAApr 24, 1967 · N3448M · Substantial damage NTSB MKC67D0289Accident · No injuriesClosedPiper PA-22 · Manson, IAOct 23, 1966 · N5333Z · Substantial damage NTSB MKC67F0124Accident · No injuriesClosedPiper PA-12 · Allison, IAAug 14, 1966 · N2674M · Substantial damage NTSB MKC66F0322Accident · Minor injuriesClosedPiper PA-12 · Fort Dodge, IANov 2, 1965 · N3812M · Substantial damage NTSB MKC66F0248Accident · Minor injuriesClosedPiper PA-12 · Lemars, IAOct 9, 1965 · N4035M · Substantial damage NTSB MKC66D0213Accident · No injuriesClosedPiper PA-12 · Marion, IAAug 23, 1965 · N7502H · Substantial damage NTSB UNK65X0472Accident · No injuriesClosedPiper PA22 · What Cheer, IAOct 29, 1964 · N4556Z · Substantial damage NTSB UNK64X3200Accident · Minor injuriesClosedPiper PA16 · Grimes, IAAug 3, 1964 · N5728H · Substantial damage