Skip to content

NTSB investigations: Lycoming IO-320 series, GA

27 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

19662026

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" = 'GA' 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\" = 'GA' 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" = 'GA' 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 ERA23FA274Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-30 · Claxton, GAThe flight crew’s improper fuel management, which resulted in the airplane’s right engine being starved of fuel and its subsequent total loss of power.Jun 25, 2023 · N7240Y · Substantial damage NTSB ERA16LA092Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Dublin, GAThe pilot’s inadvertent retraction of the landing gear during the landing roll following a landing approach in gusting wind conditions.Jan 18, 2016 · N68X · Substantial damage NTSB NYC08CA315Accident · No injuriesData collectionFinal reportPiper PA-30 · Jefferson, GAThe pilot's failure to follow the airplane manufacturer's landing gear failure and emergency extension procedures. Contributing to the accident was a malfunction of the landing gear system for undetermined reasons.Sep 18, 2008 · N7195Y · Substantial damage NTSB NYC08CA105Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlanta, GAThe pilot's failure to maintain directional control during the landing roll.Feb 19, 2008 · N8202Y · Substantial damage NTSB ATL06LA079Accident · 1 fatalLimited investigationFinal reportTaylor Skybolt · Sharpsburg, GAThe pilot's loss of control while conducting aerobatic flight. Factors in the accident were the pilot's ostentatious display, and lack of recent and total experience in type of operation.May 14, 2006 · N78BJ · Destroyed NTSB ATL02LA167Accident · No injuriesLimited investigationFinal reportPiper PA-30-30 · Winder, GAThe pilot's failure to maintain directional control during landing roll which resulted in the subsequent collision with an airport sign and the collapse of the main landing gear. the pilot's improper recovery from a bounced landing was a contributing factor.Sep 7, 2002 · N7817Y · Substantial damage NTSB ATL97LA018Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Cartersville, GAthe flight instructor's (CFI's) inadequate supervision by failing to ensure that directional control of the aircraft was maintained, during a simulated engine failure. The student pilot's delay in performing the appropriate single-engine emergency procedure…Nov 11, 1996 · N7392Y · Substantial damage NTSB ATL92LA001Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Cartersville, GAThe failure of the pilot to maintain control of the aircraft during the landing roll and the improper remedial action taken by the pilot to regain control of the airplane.Oct 3, 1991 · N5282X · Substantial damage NTSB ATL84FA118Accident · No injuriesField investigationFinal reportPiper PA 31-350 · Atlanta, GAThe aircrews of a Piper PA-31, N62849, & a Piper PA-30, N7047Y, proceeded to taxi at dawn from a cargo ramp to rwy 26. Their taxi route was down a parallel taxiway. The PA-31 plt stopped at a glide slope hold line which was located near the end of the…Mar 7, 1984 · N62849 · 2 aircraft · Substantial damage NTSB ATL83LA323Accident · No injuriesLimited investigationFinal reportBellanca 8-KCAB-150 · Kennesaw, GABoth aircraft were taxiing simultaneously, in opposite directions on the single parallel taxiway. N5500C was east bound for takeoff. N69113 was westbound on the taxiway after landing on runway 27 and a turn onto the taxiway. The pilot of N5500C stated that…Aug 12, 1983 · N5500C · 2 aircraft · Substantial damage NTSB ATL80FLA10Accident · No injuriesClosedPiper PA-30 · Valdosta, GAAug 28, 1980 · N8353Y · Substantial damage NTSB MIA80FKG22Accident · No injuriesClosedPiper PA-30 · Gainesville, GAMar 16, 1980 · N7858Y · Substantial damage NTSB MIA79DKG45Accident · No injuriesClosedPiper PA-30 · Jefferson, GAMay 30, 1979 · N7555Y · Substantial damage NTSB MIA79FKG37Accident · Serious injuriesClosedPiper PA-30B · Ball Ground, GAMay 11, 1979 · N8152Y · Destroyed NTSB MIA75FKG67Accident · No injuriesClosedPiper PA-30 · Patterson, GAApr 14, 1975 · N7873Y · Substantial damage NTSB MIA74FKG55Accident · No injuriesClosedPiper PA-30 · Atlanta, GAMar 5, 1974 · N99EJ · Substantial damage NTSB MIA74FKG23Accident · No injuriesClosedPiper PA-30 · Sylvania, GASep 2, 1973 · N7902Y · Substantial damage NTSB MIA74FKG20Accident · No injuriesClosedPiper PA-30 · Jesup, GAAug 12, 1973 · N7695Y · Substantial damage NTSB MIA73FKG65Accident · No injuriesClosedChampion 7KCAB · Albany, GAFeb 24, 1973 · N6345N · Substantial damage NTSB MIA71AM063Accident · Minor injuriesClosedPiper PA-30 · Atlanta, GAJan 30, 1971 · N7632Y · Substantial damage NTSB MIA71FKG33Accident · No injuriesClosedChampion 7KCAB · Savannah, GAAug 27, 1970 · N6300N · Substantial damage NTSB MIA71FKG18Accident · No injuriesClosedPiper PA-30 · Valdosta, GAAug 8, 1970 · N8326Y · Substantial damage NTSB MIA71DKC01Accident · No injuriesClosedMustang II · St Simons Isl, GAJul 6, 1970 · N1388 · Substantial damage NTSB MIA70F0212Accident · No injuriesClosedPiper PA-30 · Chamblee, GAJul 6, 1969 · N7376Y · Substantial damage NTSB MIA68A0108Accident · 2 fatalClosedPiper PA-30 · Statesboro, GAJun 17, 1968 · N7603Y · Destroyed NTSB MIA68F0327Accident · No injuriesClosedPiper PA-30 · Chamblee, GAOct 30, 1967 · N7615Y · Substantial damage NTSB MIA67D0196Accident · No injuriesClosedPiper PA-30 · Milledgeville, GASep 20, 1966 · N8123Y · Substantial damage