Skip to content

NTSB investigations: Lycoming IO-320 series, AK

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

19712026

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" = '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 ('41509')) 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\" = '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 ('41509'))
  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 ('41509'))
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 WPR21LA328Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKThe pilot’s inability to maintain control of the airplane during taxi after it encountered the prop wash from a larger airplane that was conducting a high-power engine run on the same taxiway.Aug 20, 2021 · N89ZW · Substantial damage NTSB WPR20LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA30 · Homer, AKThe pilot’s improper flare which resulted in a hard bounced landing and runway excursion.Sep 12, 2020 · N7669Y · Substantial damage NTSB WPR17FA108Accident · 2 fatalField investigationFinal reportPiper PA 30 · Haines, AKThe pilot's decision to turn toward the inoperative engine after conducting a low-level pass, which resulted in an aerodynamic stall at too low an altitude to recover. Contributing to the accident was the pilot's decision to perform the flight and the engine…May 27, 2017 · N7376Y · Substantial damage NTSB ANC15CA014Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Talkeetna, AKThe pilot's failure to maintain control of the airplane during takeoff from an icy surface in gusty wind conditions.Mar 8, 2015 · N5348T · Substantial damage NTSB ANC07CA030Accident · No injuriesData collectionFinal reportPiper PA-22 · Soldotna, AKThe pilot's failure to compensate for a crosswind during the landing roll, which resulted in a loss of control, an encounter with a muddy berm, and a nose over. A factor in the accident was a crosswind.Apr 24, 2007 · N3579A · Substantial damage NTSB ANC05CA134Accident · No injuriesData collectionFinal reportChampion 7KCAB · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. A factor contributing to the accident was a depression/ditch in the landing surface.Sep 3, 2005 · N63995 · Substantial damage NTSB ANC02LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during an aborted landing, which resulted in an in-flight collision with a culvert. A factor associated with the accident was a wind gust.Aug 1, 2002 · N4948 · Substantial damage NTSB ANC01LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Palmer, AKThe pilot's excessive use of brakes during the landing roll.Aug 19, 2001 · N9963Q · Substantial damage NTSB ANC00LA070Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Palmer, AKThe pilot's inadequate compensation for wind conditions. A factor associated in the accident was a variable wind.Jun 14, 2000 · N9963Q · Substantial damage NTSB ANC96LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Skwentna, AKthe pilot's improper planning/decision. Related factors were: the terrain condition, unfavorable (lee-side) wind, and trees.Sep 15, 1996 · N9033L · Substantial damage NTSB ANC95LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Lake, AKThe pilot's failure to maintain a proper rate of descent during the approach to land, and his misjudgment of altitude to flare for landing on glassy water. The glassy water condition was a related factor.Sep 2, 1995 · N9033L · Substantial damage NTSB ANC90LA004Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Montague Island, AKSelection of unsuitable terrain by the pilot. Contributing factors were: rough terrain, gusty winds, high vegetation, and trees.Oct 8, 1989 · N5222X · Substantial damage NTSB ANC85FA146Accident · 2 fatalField investigationFinal reportPiper PA-30 · Kodiak, AKDuring a wx briefing at 0719 adt, the plt was advised that VFR flt was not recommended. Later, at 0827. He called the fss to update his wx & filed an IFR clearance. At 0938, the acft departed anchorage. During arrival at Kodiak, the acft was cleared for an…Aug 5, 1985 · N7811Y · Destroyed NTSB ANC85LA126Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Glennallen, AKThe pilot-in-command made a low pass over the airstrip from south to north and UP0N reaching the departure end began a right hand turn at 50 to 75 foot above ground level. Upon reaching 30 to 40 degrees angle of bank, he lost control of the airplane.…Jul 19, 1985 · N9045L · Substantial damage NTSB ANC84FA190Accident · Serious injuriesField investigationFinal reportBellanca 8KCAB · Ouzinkie, AKPlt completed 5 turn spin, cockpit began filling with smoke. Electrical equipment was turned off and plt was descending for precautionary landing when elevator control was lost. Acft settled into 75 ft tall trees. Source of fire which resulted in battery…Sep 17, 1984 · N8592 · Substantial damage NTSB ANC76FAA35Accident · No injuriesClosedBellanca 7KCAB · Fairbanks, AKMay 7, 1976 · N5280X · Substantial damage NTSB ANC72DAG88Accident · No injuriesClosedPiper PA-22 · Seldovia, AKJan 17, 1972 · N3579A · Substantial damage NTSB ANC71FAG68Accident · No injuriesClosedChampion 7KCAB · Anchorage, AKFeb 15, 1971 · N9045L · Substantial damage