NTSB investigations: Lycoming 0-540 series, AK
115 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, newest first
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\" = 'AK' 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" = 'AK' 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 ANC96LA018Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Nanwalek, AKThe pilot's inadequate compensation for wind conditions. A factor in the accident was the variable wind.NTSB ANC95LA088Accident · No injuriesLimited investigationFinal reportMaule M-5-235 · Palmer, AKThe excessive airspeed maintained by the pilot during the approach and landing, and the pilot's failure to abort the landing, while there was still sufficient runway remaining. A factor relating to the accident was: the pilot's lack of experience in the type…NTSB ANC95LA055Accident · No injuriesLimited investigationFinal reportMaule M-5-235-C · Anchorage, AKA loss of engine power for an undetermined reason. A factor in the accident was the unsuitable terrain.NTSB ANC94LA050Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Fairbanks, AKThe failure of the pilot to abort the takeoff when her foot interfered and restricted the movement of the rudder control system.NTSB ANC94LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKFuel starvation from water and/or ice crystals in the fuel system. A factor in the accident was the improper preflight of the fuel sumps by the pilot-in-command.NTSB ANC93LA159Accident · 1 fatalLimited investigationFinal reportMorgan Steen Skybolt MI-2 · Nome, AKThe pilot delayed in recovering from the aerobatic maneuver.NTSB ANC90LA019Accident · No injuriesLimited investigationFinal reportMaule M-5 · Becky Lake, AKFatigue failure of the ski attach fitting due to being fabricated locally from the wrong steel which resulted in the airplane nosing over.NTSB ANC89LA171Accident · Minor injuriesLimited investigationFinal reportHelio H-250 · Near Iliamna, AKInadequate preflight planning/preparation by the pilot and his continued flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness and adverse weather conditions.NTSB ANC89LA149Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Fairbanks, AKThe pilot was taxiing too fast to negotiate a bend in the river. Trees & the river bank were contributing factors.NTSB ANC88LA144Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Porcupine Butte, AKThe plt rprtd he landed harder than he intended from about 3 to 5 ft above the ground. The right main gear collapsed & the acft veered to the right. Subsequently, the left main gear collapsed & the acft came to rest off the airstrip.NTSB ANC88LA132Accident · No injuriesLimited investigationFinal reportMaule M-5-235 · Fairbanks, AKThe commercial pilot had dropped two hunters off at their campsite, and was taxiing for takeoff on an unlighted gravel bar at dusk. He misjudged the end of the gravel bar in the fading light and taxied off a four foot embankment.NTSB ANC88LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Sand Point, AKThe pilot reported that the aircraft had high oil temp and moderate vibrations. The aircraft was landed at Sand Point and a company mechanic arrived to inspect the aircraft. The oil quantity was checked and a run-up performed. The mechanic reported that no…NTSB ANC88FA059Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Skwentna, AKThe on-demand air taxi flight with the pilot and two passengers struck the rock face of a mountain at the 8600 foot level. According to witnesses at the time of the accident the weather conditions were poor and visibility was less than one-half mile. The…NTSB ANC88LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKThe pilot had selected the left auxiliary fuel tank for takeoff. During the climbout the engine quit; the aircraft crashed short of a private airstrip. The pilot stated that he ran the left auxiliary fuel tank dry and did not select another fuel tank with the…NTSB ANC87LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Anchorage, AKThe pilot stated that she departed the airport with only one quarter tank of fuel; on final approach to the runway the engine quit. The owner stated there was less than ten (10) gallons on board the aircraft prior to take off.NTSB ANC86LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Stoney River, AKThe pilot stated that after liftoff he failed to maintain airspeed. The aircraft stalled and crashed into the River.NTSB ANC86FA074Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Volkmar Lake, AKAfter touchdown the pilot lost directional control of the aircraft causing the right wingtip to strike the water. The aircraft then rolled over and sank. The PIC was operating the aircraft and carrying passengers with only student pilot certificate.NTSB ANC85LA188Accident · 2 fatalLimited investigationFinal reportMaule M-5-235C · Mccarthy, AKThe pilot departed a sand bar near the bernard glacier on 8/8/85, and never returned to pick up the passenger he had dropped off earlier. On 8/12/91 the wreckage was found by hunters at 61-11N 141-42W at the 1,000-FT level in mountainous terrain. The wreckage…NTSB ANC85LA119Accident · No injuriesLimited investigationFinal reportHelio 250 · Anchorage, AKThe plt reported that he took off downwind with a heavily loaded acft. He estimated the wind was from the north at 4 gusting to 6 KTS. He stated that after climbing about 100 ft, the acft began to mush as he began retracting the flaps. Subsequently, it…NTSB ANC85LA019Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKThe plt stated during two telephone interviews that he hit trees during takeoff and then continued his two hour flt to to the homer arpt. The left wing was damaged and both left and right sides of the horizontal stabilizer were crushed andbent up about 19…NTSB ANC84LA121Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Anchorage, AKThe pilot lost control during landing, the acft ground looped and both main landing gear collapsed.NTSB ANC84LA107Accident · No injuriesLimited investigationFinal reportMaule M-5 · Anchorage, AKThe plt reported that when he landed on campbell lake, the left float hit a submerged object. The acft then yawed to the left, banked to the right & went over on its top. Campbell lake was used as a private sea-plane base & was located within the city limits…NTSB ANC84FA092Accident · Minor injuriesField investigationFinal reportMaule M-5-235C · Anchorage, AKThe acft traveled forward into a parked acft after the plt hand propped it to start the engine. A pax who had 'a few hours', according to the plt, was inside the acft to hold the foot brake pedals. The plt said the battery was too low tostart the acft engine…NTSB ANC84FA072Accident · No injuriesField investigationFinal reportPiper PA-28-235 · Egegik, AKThe acft crashed during a forced landing on unsuitable terrain. The plt said the acft engine lost oil-pressure about 20 minutes after takeoff and he turned toward the closest arpt. The engine operated a few minutes and then stopped. The acft was landed off…NTSB ANC84LA041Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Mcgrath, AKThe pilot told flight service personnel that the aircraft struck the ground while circling. His passenger was attemptingto photograph something on the ground.NTSB ANC84LA034Accident · Serious injuriesLimited investigationFinal reportHelio H-250 · Iliamna, AKAccording to witnesses, the ski equipped acft took off toward the north. They reported that after taking off, the acft made a tight left turn, then spiraled to the ground. They estimated that the maximum alt was aprx 150 ft. also, they reported that the eng…NTSB ANC82DA088Accident · No injuriesFinal reportPiper PA-32-260 · Naknek, AKAt the point of rotation the acft struck a large puddle of water causing a reduction in speed. The acft continued down the rwy approximately another 150 ft at 5 ft AGL when it became evident that further flight was impossible. The takeoff was aborted & the…NTSB ANC82FAA07Accident · 2 fatalFinal reportMaule M-5 · Fairbanks, AKEarlier in the day the plt returned from a flt after experiencing a rough running eng & changed the spark plugs. The acft again departed the chena marina arpt. Witnesses observed the acft level off approximately 300 to 350 ft AGL. One witness observed the…NTSB ANC81DAG80Accident · No injuriesClosedMaule M-5 · Iliamna, AKNTSB ANC81DAG62Accident · Minor injuriesClosedPiper PA-28 · Iliamna, AKNTSB ANC81DAG55Accident · Minor injuriesClosedMaule M-5 · Alexander Crk, AKNTSB ANC81DAG44Accident · No injuriesClosedMaule M-5 · Anchorage, AKNTSB ANC81DAG45Accident · No injuriesClosedMaule M-5 · Eagle River, AKNTSB ANC81DAG43Accident · No injuriesClosedMaule M-5 · Zachery Bay, AKNTSB ANC81FAA16Accident · No injuriesClosedMaule M5 · North Pole, AKNTSB ANC81DAA13Accident · Serious injuriesClosedMaule M-5 · Totatlanika, AKNTSB ANC81DAG29Accident · No injuriesClosedMaule M-5 · New Stuyahok, AKNTSB ANC80DAA27Accident · No injuriesClosedMaule M-5 · Big Delta, AKNTSB ANC80DAG22Accident · No injuriesClosedHelio Acft H-250 · Anchorage, AKNTSB ANC79FA067Accident · 3 fatalClosedRallye 235GT · Kodiak, AKNTSB ANC78FAA39Accident · No injuriesClosedMaule M-5 · Kotzbue, AKNTSB ANC78FA079Accident · 1 fatalClosedMaule M-5 · Sterling, AKNTSB ANC78DAH22Accident · Minor injuriesClosedHelio Acft H-250 · Holy Cross, AKNTSB ANC78DAA36Accident · Minor injuriesClosedPiper PA-25 · Tanana, AKNTSB ANC77FA062Accident · 1 fatalClosedBrittnorman BN-2H · Ruby, AKNTSB ANC77FAD06Accident · Minor injuriesClosedPiper PA-24 · Juneau, AKNTSB ANC76AA068Accident · No injuriesClosedPiper PA-32 · Stevens Vlg, AKNTSB ANC76DAG69Accident · No injuriesClosedHelio Acft H-250 · St.Marys, AKNTSB ANC76FAG62Accident · No injuriesClosedHelio Acft H-250 · Anchorage, AKNTSB ANC76AA042Accident · No injuriesClosedHelio Acft H-250 · Teller, AK