NTSB investigations: Lycoming 0-540 series, IA
66 cases on aircraft whose registry engine model is Lycoming 0-540 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.
Cases per year
| 1964 | 3 |
|---|---|
| 1965 | 4 |
| 1966 | 3 |
| 1967 | 2 |
| 1968 | 4 |
| 1969 | 5 |
| 1970 | 3 |
| 1971 | 5 |
| 1972 | 3 |
| 1973 | 1 |
| 1974 | 7 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 3 |
| 1981 | 3 |
| 1983 | 2 |
| 1984 | 3 |
| 1987 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2000 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2009 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2026 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('41532'))
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 ('41532'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN27LA019Accident · Minor injuriesClass 3 · LimitedInvestigation openPiper PA-28-235 · Cedar Rapids, IANTSB WPR19FA022Accident · 4 fatalClass 2 · FieldFinal reportPiper PA28 · Guthrie Center, IAPilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.NTSB CEN18LA025Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Larchwood, IAThe pilot's loss of situational awareness, which resulted in his failure to maintain adequate clearance from powerlines.NTSB CEN09CA483Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Royal, IAThe pilot's failure to maintain clearance from the crop during an aerial application maneuver.NTSB CHI05FA080Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · West Union, IAThe pilot's failure to abort the takeoff, his failure to maintain adequate airspeed during the takeoff, and the pull-up to avoid obstacles which resulted in an inadvertent stall. Factors associated with the accident were the pilot's failure to maintain…NTSB CHI04FA044Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Brooklyn, IAThe pilot's inadequate planning/decision resulting in VFR flight into IMC, and his failure to maintain terrain clearance resulting in in-flight collision with terrain. Contributing factors to the accident were the pilot's lack of an instrument rating, his…NTSB CHI00LA278Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Des Moines, IAA hydraulic fluid leak which resulted in a landing gear brake fire.NTSB CHI00LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Sully, IAThe pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…NTSB CHI97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Correctionville, IAthe pilot's inadequate compensation for wind conditions, while taxiing, which resulted in loss of aircraft control, an encounter with terrain, and subsequent failure of the left main landing gear. The unfavorable wind condition was a related factor.NTSB CHI95LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Dodge, IAThe pilot's improper IFR procedure. The low ceiling and fog were a factor.NTSB MKC88DCD03Accident · 1 fatalFinal reportPiper PA-25-235 · Eldora, IAPilot was spraying a bean field when a witness saw his aircraft strike the ground. The aircraft then climbed to approximately 200 feet and leveled off. It then began a gentle climb, then entered a spin and desended into the ground. Examination of the aircraft…NTSB MKC88LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Des Moines, IAApprox eight miles from the dest arpt, the PIC experienced partial, then a complete power loss. An emergency lndg was made on a golf course, about one mile short of the dest arpt. Post accident inspection revealed no fuel in any of the four tanks. Damage was…NTSB MKC84FA271Accident · Serious injuriesField investigationFinal reportCessna R182 · Ottumwa, IAThe acft entered IMC weather, the plt became disoriented & cruised without ATC navigational assistance after failing to make radio contact or file a flt plan. The non-instrument rated private plt flew until acft power was lost due to fuel exhaustion. The…NTSB MKC84FCD02Accident · Serious injuriesFinal reportCallair A-9 · Oakland, IAThe pilot was practicing aerial application maneuvers using water as the spray load. He stated that about half way thru his turn to reverse direction, he felt the a/c give a very slight stall warning. He said that he released some back pressure and attempted…NTSB MKC84LA054Accident · No injuriesLimited investigationFinal reportCessna 182 · Marion, IAThe acft collided with a snowbank after swerving during takeoff. The swerve was started when the acft hit a windblown snowdrift which changed the acfts direction. After the collision the acfts nose gear collapsed and the left main gear retracted.NTSB MKC83LA142Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Corning, IAThe acft crashed in a swamp during a forced landing after the engine seized. The pilot noted a lack of oil pressure and rising oil temperature. He dumped his load and began to return to land. The engine began to run rough and soon seized. Post accident…NTSB MKC83LA056Accident · No injuriesLimited investigationFinal reportCessna 182RG · Woodbine, IAPilot checked braking on icy sod runway before takeoff and it seemed to be all right. Upon returning to land the pilot noticed a farmer driving cattle near the landing threshold so he decided to land long instead of going around. Using half flaps he landed…NTSB MKC82DCD03Accident · No injuriesClosedCallair A-9B · Fostoria, IANTSB MKC81IA031Incident · No injuriesClosedPiper PA-32 · St.Ansgar, IANTSB MKC81DCD12Accident · No injuriesClosedPiper PA-24 · Charles City, IANTSB MKC78FCD36Accident · No injuriesClosedPiper PA-23 · Olin, IANTSB MKC78FA053Accident · 4 fatalClosedPiper PA-32 · Denison, IANTSB MKC78FCD21Accident · Minor injuriesClosedPiper PA-28 · Fairfield, IANTSB MKC77DCD39Accident · No injuriesClosedPiper PA-24 · Council Bluffs, IANTSB MKC76DCD52Accident · No injuriesClosedPiper PA-25 · Tipton, IANTSB MKC76FCD12Accident · No injuriesClosedPiper PA-25 · Lenox, IANTSB MKC75FCD21Accident · No injuriesClosedPiper PA-24 · Elkader, IANTSB MKC75FCD13Accident · No injuriesClosedCallair A-9 · Gilmore City, IANTSB MKC75FCD09Accident · No injuriesClosedPiper PA-25 · Storm Lake, IANTSB MKC75FCD02Accident · No injuriesClosedPiper PA-24 · Hillsboro, IANTSB MKC74FCD40Accident · Minor injuriesClosedPiper PA-25 · Unionville, IANTSB MKC74DCD38Accident · No injuriesClosedPiper PA-24 · Urbandale, IANTSB MKC74DCD24Accident · Minor injuriesClosedPiper PA-24 · Dubuque, IANTSB MKC73DCD55Accident · No injuriesClosedPiper PA-28 · Wapello, IANTSB MKC73DCD31Accident · No injuriesClosedPiper PA-32 · Carroll, IANTSB MKC73DCD14Accident · No injuriesClosedPiper PA-28 · Moorland, IANTSB MKC72FCD50Accident · No injuriesClosedPiper PA-32 · Mason City, IANTSB MKC72DCD19Accident · No injuriesClosedPiper PA-25 · Olin, IANTSB MKC72DCD16Accident · No injuriesClosedPiper PA-24 · Estherville, IANTSB MKC71DCD72Accident · No injuriesClosedPiper PA-32 · Kingsley, IANTSB MKC71DCD59Accident · No injuriesClosedPiper PA-32 · Guthrie Cntr, IANTSB MKC71DCD50Accident · No injuriesClosedPiper PA-24 · Iowa City, IANTSB MKC71DCD24Accident · No injuriesClosedCallair A-9 · Paton, IANTSB MKC70DCD17Accident · No injuriesClosedPiper PA-24 · Monticello, IANTSB MKC70DCD03Accident · No injuriesClosedPiper PA-24 · West Union, IANTSB MKC70F0217Accident · No injuriesClosedPiper PA-32 · Carroll, IANTSB MKC70D0185Accident · No injuriesClosedCallair A-9 · Greattinger, IANTSB MKC70D0111Accident · No injuriesClosedPiper PA-32 · Eagle Grove, IANTSB MKC69F0344Accident · No injuriesClosedPiper PA-32 · Chariton, IANTSB MKC69D0350Accident · Minor injuriesClosedPiper PA-25 · Dubuque, IA