NTSB investigations: Lycoming 0-320 series, 2011
24 cases on aircraft whose registry engine model is Lycoming 0-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 | 41 |
|---|---|
| 2009 | 32 |
| 2010 | 27 |
| 2011 | 24 |
| 2012 | 29 |
| 2013 | 28 |
| 2014 | 22 |
| 2015 | 21 |
| 2016 | 15 |
| 2017 | 28 |
| 2018 | 37 |
| 2019 | 31 |
| 2020 | 34 |
| 2021 | 30 |
| 2022 | 31 |
| 2023 | 29 |
| 2024 | 22 |
| 2025 | 16 |
| 2026 | 17 |
Where
Latest 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 year(c.\"eventDate\") = 2011
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
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 year(c."eventDate") = 2011
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
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 CEN12CA099Accident · No injuriesData collectionFinal reportCessna 172N · Wauseon, OHThe student pilot's loss of directional control during landing.NTSB WPR12CA028Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll.NTSB CEN12CA042Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · West Fargo, NDThe pilot's excessive use of brakes during the landing roll before the tailwheel had made sustained contact with the runway.NTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.NTSB CEN12CA005Accident · No injuriesData collectionFinal reportCampbell John Mustang II · Brush, COThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.NTSB ERA11CA487Accident · Serious injuriesData collectionFinal reportKaribian Hurant Thorp T-18 · Panama City, FLThe pilot's selection of an unsuitable landing site, which resulted in a collision with a culvert.NTSB WPR11CA402Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Emmett, IDThe pilot's failure to maintain directional control during landing.NTSB ANC11CA076Accident · Minor injuriesData collectionFinal reportPiper PA-18-135 · Coldfoot, AKThe pilot's inadvertent application of the right brake pedal during the landing roll, which resulted in a nose-over.NTSB CEN11CA450Accident · Minor injuriesData collectionFinal reportAmerican Champion 7GCBC · Sugar Land, TXThe pilot's failure to maintain directional control during landing.NTSB WPR11CA293Accident · No injuriesData collectionFinal reportAviat A-1B · Livermore, CAThe pilot's failure to maintain directional control during a go-around.NTSB WPR11CA235Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Yakima, WAThe pilot’s failure to maintain directional control upon landing.NTSB ERA11CA315Accident · No injuriesData collectionFinal reportMorrisey 2150A · Cambridge, MDThe pilot's loss of directional control during landing on a soft, turf runway.NTSB CEN11CA354Accident · No injuriesData collectionFinal reportHenry Slosing Lanceair · Albuqurque, NMThe pilot’s loss of directional control while landing in gusty conditions.NTSB ANC11CA035Accident · No injuriesData collectionFinal reportPiper PA-18A · Coldfoot, AKThe pilot's failure to maintain control of the airplane while taxiing in gusty wind conditions.NTSB WPR11CA212Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN11CA306Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Crosby, NDThe pilot’s failure to maintain directional control of the airplane during the crosswind landing.NTSB CEN11CA261Accident · No injuriesData collectionFinal reportCessna 172N · Colorado Springs, COThe pilot loss of directional control during landing in gusty crosswind conditions.NTSB CEN11CA271Accident · No injuriesData collectionFinal reportCessna 172N · Appleton, WIThe student pilot's failure to maintain directional control of the airplane during takeoff.NTSB CEN11CA236Accident · No injuriesData collectionFinal reportPiper PA-22-150 · South St. Paul, MNThe pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB WPR11LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Twin Falls, IDThe pilot’s failure to compensate for the wind, which resulted in the airplane being blown over after completion of the landing roll.NTSB CEN11CA184Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe student pilot's failure to maintain directional control of the airplane during the takeoff.NTSB CEN11CA181Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lansing, ILThe pilot’s loss of directional control during the landing.NTSB ERA11CA138Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's loss of directional control during the landing rollout, resulting in a runway excursion.NTSB ERA11CA115Accident · No injuriesData collectionFinal reportCessna 172N · Lebanon, TNThe student pilot´s failure to maintain directional control during an aborted takeoff, resulting in a runway excursion.