Skip to content

NTSB investigations: Lycoming IO-320 series, NC

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

19642026

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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ERA23FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Winston-Salem, NCContamination and/or misalignment of the regulator section of the right engine’s fuel servo, which resulted in excessive idle fuel flow and a total loss of engine power. Also causal was the pilot's failure to land immediately on the nearest runway at the…Nov 19, 2022 · N7295Y · Substantial damage NTSB ERA15LA358Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Manteo, NCThe inadvertent lodging of the banner-tow cable between the right elevator and horizontal stabilizer after the pilot threw the grapple hook out the window, which resulted in the loss of pitch control and the airplane’s subsequent impact with water.Sep 14, 2015 · N86705 · Substantial damage NTSB ATL98LA118Accident · No injuriesLimited investigationFinal reportPiper PA-30-39 · Greenville, NCA loose wiring connection at the landing gear motor relay that prevented the electrical extension of the landing gear.Aug 20, 1998 · N7298Y · Substantial damage NTSB MIA97FA049Accident · 1 fatalField investigationFinal reportPiper PA-30 · Goldsboro, NCThe pilot's failure to follow instrument approach procedures during numerous instrument approaches and missed approaches which resuled in a total loss of engine power on both engines due to fuel exhaustion. Factors contributing to the accident were: the…Dec 28, 1996 · N8220Y · Destroyed NTSB ATL87LA139Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Raleigh, NCThe pilot failed to maintain a proper descent rate on the approach for landing. He said the right engine failed to respond when he added power to arrest the rate of descent and thereafter, he applied full power to either go-around or land further down the…May 16, 1987 · N7937Y · Substantial damage NTSB ATL86LA050Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Charlotte, NCPlt reported loss of power on the right eng at about 20 ft alt on takeoff. The acft veered right, the plt aborted the takeoff and touched down on the right side of rwy. The acft struck a mound of dirt and the ldg gear collapsed. The takeoff was initiated from…Jan 7, 1986 · N47KB · Substantial damage NTSB ATL83LA051Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Atkinson, NCThe pilot decided to land on a private strip due to strong gusty winds and thunderstorms. The pilot landed without incident and began to back taxi on the runway when the left main landing gear went into a mud hole off the side of the runway. The aircraft…Dec 5, 1982 · N57423 · Substantial damage NTSB ATL80FA084Accident · 2 fatalClosedBellanca 7KCAB · Lake Norman, NCAug 10, 1980 · N1644G · Destroyed NTSB IAD75DKM07Accident · No injuriesClosedPiper PA-30 · Asheville, NCJul 29, 1974 · N7910Y · Substantial damage NTSB IAD75DKM06Accident · No injuriesClosedPiper PA-30 · Charlotte, NCJul 20, 1974 · N7660Y · Substantial damage NTSB IAD74DKM08Accident · No injuriesClosedPiper PA-30 · High Point, NCJul 13, 1973 · N7528Y · Substantial damage NTSB IAD73FKM33Accident · Serious injuriesClosedPiper PA-30 · Arden, NCApr 17, 1973 · N8684Y · Substantial damage NTSB IAD71FKM32Accident · No injuriesClosedChampion 7KCAB · Concord, NCMar 30, 1971 · N7542F · Substantial damage NTSB DIA68F0051Accident · No injuriesClosedPiper PA-30 · Morganton, NCAug 12, 1967 · N8174Y · Substantial damage NTSB DIA68F0052Accident · No injuriesClosedPiper PA-30 · Greensboro, NCJul 23, 1967 · N7512Y · Substantial damage NTSB DIA68D0044Accident · No injuriesClosedPiper PA-30 · Boone, NCJul 10, 1967 · N7528Y · Substantial damage NTSB UNK65X0624Accident · No injuriesClosedPiper PA30 · Henderson, NCNov 8, 1964 · N7185Y · Substantial damage NTSB UNK64X0851Accident · No injuriesClosedPiper PA30 · Wilmington, NCMar 8, 1964 · N7136Y · Substantial damage