NTSB investigations: Lycoming IO-320 series
24 cases on aircraft whose registry engine model is Lycoming IO-320 series, where the defining event was Loss of control on ground. 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 per year
| 2008 | 2 |
|---|---|
| 2010 | 2 |
| 2011 | 2 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2025 | 2 |
Where
Open the mapLatest cases
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '230'))
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 WPR26LA007Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Gila Bend, AZThe pilot’s improper throttle input and failure to maintain aircraft control during landing.NTSB ERA25LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Anderson, SCThe pilots’ overcorrection during the landing roll which resulted in a loss of directional control and runway excursion. Contributing was the flight instructor’s inability to correct the pilot’s actions because due to brakes only being installed on the…NTSB CEN24LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Alamosa, COThe pilot’s failure to maintain directional control during landing with an excessive touchdown speed that resulted in a loss of control and impact with terrain.NTSB ERA23LA069Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7KCAB · Accident, MDThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB CEN22LA327Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Gordon, NEThe pilot’s loss of control while landing a tailwheel-equipped airplane with a gusty crosswind.NTSB ERA22LA336Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7KCAB · East Haddam, CTThe pilot's failure to maintain directional control during the landing.NTSB ERA22LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Newport Richie, FLA loss of directional control on landing for undetermined reasons.NTSB GAA19CA041Accident · No injuriesData collectionFinal reportVans RV 6 · Paola, KSThe pilot's failure to maintain directional control, which resulted in a runway excursion during the aborted landing and subsequent impact with vegetation and a nose-over.NTSB GAA18CA381Accident · No injuriesData collectionFinal reportPiper PA 30 · Goodyear, AZThe pilot receiving instruction’s failure to maintain directional control during the landing roll.NTSB GAA18CA055Accident · No injuriesData collectionFinal reportBellanca 8KCAB · El Dorado, MOThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA515Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Winnemucca, NVThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent loss of airplane control during an attempted aborted landing.NTSB GAA17CA396Accident · No injuriesData collectionFinal reportChampion 7KCAB · Cottonwood, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA16CA341Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Freemont Island, UTThe flight instructor's failure to maintain directional control during the landing roll, resulting in an impact with an unknown object during aborted landing and consequent ground impact.NTSB WPR15LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA30 - NO Series · Red Bluff, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and collision with terrain.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.NTSB CEN15CA213Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Mesquite, TXThe pilot's loss of directional control while landing in gusting crosswind conditions, which exceeded the airplane's maximum demonstrated crosswind velocity.NTSB WPR14CA366Accident · Minor injuriesData collectionFinal reportBellanca 8KCAB · Black Rock City, NVThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's disorientation as a result of dust which reduced visibility.NTSB ERA14LA133Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Allentown, PAThe flight instructor’s failure to maintain directional control during the landing.NTSB ERA11CA385Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe student pilot's failure to maintain aircraft control following a bounced landing.NTSB CEN11CA288Accident · No injuriesData collectionFinal reportPiper PA-30 · Austin, TXThe pilot’s loss of directional control during landing which resulted in a runway excursion.NTSB WPR10CA425Accident · No injuriesData collectionFinal reportChris W Kleen RV-6 · Coeur D'Alene, IDThe pilot’s inadequate compensation for the crosswind that resulted in a loss of directional control.NTSB CEN10CA516Accident · No injuriesData collectionFinal reportChampion 7KCAB · North Fork, NEThe student pilot's loss of directional control during landing, which resulted in a ground loop.NTSB DFW08CA141Accident · No injuriesData collectionFinal reportPiper PA-30 · Houston, TXThe pilot's loss of directional control during the landing. A contributing factor was the flight instructor's delayed remedial action.NTSB NYC08CA105Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlanta, GAThe pilot's failure to maintain directional control during the landing roll.