Skip to content

NTSB investigations: Lycoming IO-540 series, MN

19 cases on aircraft whose registry engine model is Lycoming IO-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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19802026

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" = 'MN' 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 ('41530', '41585')) 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\" = 'MN' 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 ('41530', '41585'))
  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" = 'MN' 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 ('41530', '41585'))
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 CEN24LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Pierz, MNThe pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.Sep 30, 2024 · N2032M · Substantial damage NTSB CEN22LA318Accident · Serious injuriesClass 3 · LimitedFinal reportHiller UH12E · Becker, MNThe in-flight failure of the main rotor mast hub due to several undetected fatigue fractures.Jul 6, 2022 · N64272 · Substantial damage NTSB GAA16CA019Accident · No injuriesData collectionFinal reportMaule M 7-235C · Mankato, MNThe pilot's failure to maintain directional control during the go-around, which resulted in a collision with terrain.Oct 11, 2015 · N3180G · Substantial damage NTSB CEN13LA201Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Winsted, MNThe obstruction of the right engine’s induction air system by ice, which resulted in a loss of engine power.Mar 16, 2013 · N6222M · Substantial damage NTSB CEN12FA091Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Hackensack, MNThe helicopter's sudden yaw and subsequent impact with the water for reasons that could not be determined during postaccident examination of the helicopter and its systems.Nov 25, 2011 · N821JV · Substantial damage NTSB CEN10LA556Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Duluth, MNThe pilot's failure to identify and arrest the helicopter's descent due to spatial disorientation.Sep 17, 2010 · N145DM · Destroyed NTSB CHI08LA180Accident · Minor injuriesLimited investigationFinal reportSmith Aerostar 601P · Alexandria, MNThe loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain for the forced landing.Jul 2, 2008 · N601TS · Substantial damage NTSB CHI06CA197Accident · No injuriesData collectionFinal reportCessna 206H · Lutsen, MNThe unsuitable terrain the pilot encountered during takeoff in rough water. A factor was the wave in the rough water.Jul 22, 2006 · N52728 · Substantial damage NTSB CHI96LA317Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · Stewartville, MNthe pilot's improper in-flight planning/decision, which resulted in a failure to reach the proper touchdown point for the landing. The fractured nose gear shimmy damper attaching collar and the jammed nose gear were related factors.Aug 26, 1996 · N801SP · Substantial damage NTSB CHI95LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lakeville, MNThe pilot misjudged distance and altitude during landing.Mar 16, 1995 · N2928A · Substantial damage NTSB CHI93LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-400 · Elbow Lake, MNthe pilot's failure to maintain an adequate visual outlook during aerial application manuevers.May 31, 1993 · N2342Y · Substantial damage NTSB CHI91DER09Accident · No injuriesFinal reportEagle Eagle DW-1 · Windom, MNThe pilot's improper aircraft handling. Related factors are the pilot's inattention and the airplane's deteriorated performance capability.Jun 28, 1991 · N88142 · Substantial damage NTSB CHI91DER04Accident · No injuriesFinal reportBellanca Eagle DW-1 · Hector, MNThe loss of engine power due to the total failure of a connecting rod. Related factors are the low maneuvering altitude and the unsuitable (muddy) terrain encountered during the forced landing.Jun 6, 1991 · N8800W · Substantial damage NTSB CHI85LA336Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Red Lake Falls, MNThe acft contacted wires during an aerial application flt. The plt stated he was maintaining extra alt to avoid tall weeds and the clearance below the wires was misjudged. The wires severed the vertical fin and rudder.Aug 6, 1985 · N2350Y · Substantial damage NTSB CHI84LA254Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Oklee, MNThe plt reported that he had completed spraying 60 acres of land & was beginning a pass in another field. Half way through the spray pass the eng quit. He pulled up to clear a tree & the acft stalled into a field of sunflowers. No mechanical failure or…Jun 22, 1984 · N8810Y · Substantial damage NTSB CHI84LA231Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Oklee, MNThe acft ran off a road into a ditch which destroyed the main landing gear during the forced landing. The plt said oil covered the windshield after takeoff and he could not see well enough to find the airstrip so he landed on the road while looking out the…Jun 12, 1984 · N8801P · Substantial damage NTSB CHI83LA280Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Minneapolis, MNThe acft ran off the end of the rwy and collapsed the nose gear during an aborted takeoff. The acft exceeded the maximum gross weight for takeoff by 190 lbs. Decision to abort was made about 2/3 of the way down the rwy. Braking was good and deceleration…Jun 24, 1983 · N8310L · Substantial damage NTSB CHI81FER26Accident · No injuriesClosedPiper PA-32 · Faribault, MNMar 10, 1981 · N8157R · Substantial damage NTSB MKC80FER26Accident · No injuriesClosedPiper PA-32 · Sauk Centre, MNMar 7, 1980 · N333JD · Substantial damage