Skip to content

NTSB investigations: Lycoming I0360 series, IA

39 cases on aircraft whose registry engine model is Lycoming I0360 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

19672026

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 ('41515')) 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 ('41515'))
  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 ('41515'))
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 CEN26LA309Accident · No injuriesClass 4 · LimitedInvestigation openMooney M20E · West Branch, IASep 2, 2026 · N55GA · Substantial damage NTSB GAA16CA501Accident · No injuriesData collectionFinal reportPiper PA28R · Ottumwa, IAThe pilot receiving instruction's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a simulated engine failure and landing, which resulted in an aerodynamic stall. Contributing to the accident was the…Sep 21, 2016 · N3803T · Substantial damage NTSB GAA16CA093Accident · No injuriesData collectionFinal reportCessna 172 · Newton, IAThe pilot's failure to maintain airplane control during the takeoff, resulting in a runway excursion, and airplane nose over.Jan 2, 2016 · N947SP · Substantial damage NTSB CEN13CA529Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluff, IAThe student pilot's loss of directional control during takeoff.Sep 4, 2013 · N368ES · Substantial damage NTSB CEN13CA289Accident · No injuriesData collectionFinal reportCessna 172S · Ankeny, IAThe student pilot's improper flare which resulted in a hard landing.May 14, 2013 · N947SP · Substantial damage NTSB CEN12CA402Accident · No injuriesData collectionFinal reportSchweizer TH55A/269A · Grinnell, IAThe pilot’s inadequate compensation for the wind during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.Jun 26, 2012 · N488MC · Substantial damage NTSB CEN12CA213Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluffs, IAThe student pilot’s improper flare and inadequate recovery from a bounced landing, which resulted in a loss of directional control.Mar 24, 2012 · N368ES · Substantial damage NTSB CHI05LA083Accident · 1 fatalLimited investigationFinal reportMooney M20E · Bloomfield, IAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin. The low altitude was a factor.Mar 28, 2005 · N6092Q · Destroyed NTSB CHI04LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Dubuque, IAThe flight instructor's inadequate in-flight planning/decision which resulted in ice accretion on the airframe, and his failure to maintain adequate airspeed resulting in a stall. Contributing factors were the ice contamination, the aircraft's low altitude…Mar 9, 2004 · N105FS · Substantial damage NTSB CHI01LA178Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28A · Eldridge, IAThe inadequate autorotation and disregarded wind information by the pilot. Factors were the gusting tailwind and the loss of engine power for undetermined reasons.Jun 19, 2001 · N612B · Substantial damage NTSB MKC87FA106Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Sioux City, IAThe PIC had telephoned the fss at huron, s.d. for enr wx to Sioux City, IA, fm Sioux falls, s.d., late the evening of may 20. The fcst indicated IFR flt cond's with intermittent trsms along the rte throughout the fcst period. The PIC dptd Sioux falls, s.d. at…May 21, 1987 · N4982J · Destroyed NTSB MKC84LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Carlisle, IAThe pilot said the fuel gauges read full on the ground but as he leveled off in cruise they dropped to a reading of much less than full. The acft ran out of fuel short of destination. The pilot blamed the flu and fatigue for his oversight.Oct 16, 1983 · N2825T · Substantial damage NTSB MKC83LA002Accident · No injuriesLimited investigationFinal reportBeech C24R · Centerville, IAThe pilot reported that the approach was a little high and fast, then the right tire blew out on touchdown. He stated that power was added to maintain directional control, and he was unable to stop at the end of the runway. However, witnesses indicated that…Oct 2, 1982 · N525SB · Substantial damage NTSB MKC82FCD09Accident · Serious injuriesFinal reportHughes 269B · Tipton, IAThe helicopter crashed during takeoff on a flight to pollenate corn. The pilot reported that he made a running takeoff across the runway. He stated that the helicopter became airborne at the north edge of the runway, but started to settle as it went over the…Jul 29, 1982 · N9357F · Substantial damage NTSB MKC81FCD34Accident · Serious injuriesClosedHughes 269B · Marion, IAAug 13, 1981 · N9357F · Substantial damage NTSB MKC81FA044Accident · 5 fatalClosedPiper PA-28R · Colo, IAJul 25, 1981 · N16328 · Destroyed NTSB MKC81FCD17Accident · No injuriesClosedMooney M20J · Norwalk, IAApr 23, 1981 · N4452H · Substantial damage NTSB MKC81FCD02Accident · No injuriesClosedEntrom F-28A · Carson, IANov 23, 1980 · N23HC · Substantial damage NTSB MKC80FCD11Accident · No injuriesClosedPiper PA-28R · Ankeny, IAJan 27, 1980 · N57305 · Substantial damage NTSB MKC79FCD16Accident · Minor injuriesClosedMooney M20E · Cresco, IAApr 20, 1979 · N7115U · Substantial damage NTSB MKC78FCD31Accident · No injuriesClosedPiper PA-28R · Iowa City, IAMay 30, 1978 · N2895T · Substantial damage NTSB MKC78DCD11Accident · No injuriesClosedBeech A24 · Des Moines, IAFeb 15, 1978 · N6927Q · Substantial damage NTSB MKC77DCD37Accident · No injuriesClosedHughes 269B · Hawkeye, IAJun 29, 1977 · N9357F · Substantial damage NTSB MKC77FCD20Accident · No injuriesClosedPiper PA-28 · Oskaloosa, IAMay 22, 1977 · N4646J · Substantial damage NTSB MKC76FCD02Accident · No injuriesClosedPiper PA-28R · Council Bluffs, IAJul 17, 1975 · N4970S · Substantial damage NTSB MKC75FCD33Accident · No injuriesClosedMooney M20F · Davenport, IAFeb 9, 1975 · N3498N · Substantial damage NTSB MKC75PCD31Accident · No injuriesClosedPiper PA-28R · Burlington, IAJan 3, 1975 · N2989R · Substantial damage NTSB MKC75FCD22Accident · No injuriesClosedHughes 269B · Waterloo, IAOct 30, 1974 · N9487F · Substantial damage NTSB MKC73FCD61Accident · No injuriesClosedEnstrom F-28A · Altoona, IAMay 4, 1973 · N2517M · Substantial damage NTSB MKC73DCD13Accident · No injuriesClosedPiper PA-28R · Ottumwa, IAAug 1, 1972 · N3866T · Substantial damage NTSB MKC72DCD24Accident · No injuriesClosedHughes 269A · Nevada, IAAug 13, 1971 · N8892F · Substantial damage NTSB MKC72DCD07Accident · No injuriesClosedMooney M20E · Dubuque, IAJul 3, 1971 · N79341 · Substantial damage NTSB MKC70FCD20Accident · No injuriesClosedPiper PA-28R · Crescent, IAMar 1, 1970 · N7665J · Substantial damage NTSB MKC70D0264Accident · No injuriesClosedPiper PA-28R · Muscatine, IANov 9, 1969 · N4696J · Substantial damage NTSB MKC70I0141Incident · No injuriesClosedBeech B95A · Oskaloosa, IAAug 12, 1969 · N9697Y · Minor damage NTSB MKC68D0517Accident · No injuriesClosedBeech A23-24 · Leon, IAApr 12, 1968 · N7907L · Substantial damage NTSB MKC68D0312Accident · No injuriesClosedMooney 20F · Lamoni, IANov 11, 1967 · N9573M · Substantial damage NTSB MKC68D0084Accident · No injuriesClosedMooney M20E · Sioux City, IAJun 23, 1967 · N5534Q · Substantial damage NTSB MKC67D0367Accident · No injuriesClosedMooney M20E · Bellevue, IAJan 7, 1967 · N79832 · Substantial damage