NTSB investigations: Lycoming 0-320 series, FL
30 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 | 4 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 5 |
| 2019 | 5 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
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 c.\"eventStateOrRegion\" = 'FL' 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 ('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 c."eventStateOrRegion" = 'FL' 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 ('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 ERA26LA186Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172M · Crystal River, FLNTSB ERA25LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Merritt Island, FLThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB ERA24LA270Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Hernando, FLThe pilot’s inadvertent throttle input during landing which resulted in a runway overrun.NTSB ERA22LA437Accident · No injuriesClass 4 · LimitedFinal reportWhiting Cleon Glasair SH-2 · Palmetto, FLThe pilot’s loss of directional control during takeoff roll.NTSB ERA21LA168Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Crystal River, FLThe student pilot’s inadequate compensation for a crosswind during landing, which resulted in a loss of directional control and a runway excursion.NTSB ERA21LA175Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Fort Pierce, FLThe flight instructor’s delayed remedial action and failure to maintain directional control during a crosswind landing, which resulted in a runway excursion.NTSB ERA21LA164Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Miami, FLThe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an aerodynamic stall and impact with terrain. Also causal was the flight instructor’s inadequate remedial action.NTSB ERA20CA093Accident · No injuriesData collectionFinal reportCessna 172 · Crystal River, FLThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and subsequent nose-over.NTSB GAA20CA067Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB GAA20CA050Accident · No injuriesData collectionFinal reportPiper PA 30 · Opa Locka, FLThe pilot receiving instruction's failure to relinquish the flight controls to the flight instructor during a simulated engine failure during takeoff, which resulted in the airplane touching down in a left banking attitude and the landing gear collapsing.NTSB GAA19CA580Accident · No injuriesData collectionFinal reportCessna 172 · Plant City, FLThe student pilot's failure to maintain directional control during the aborted landing, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA362Accident · No injuriesData collectionFinal reportCessna 172 · Tampa, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose-over.NTSB GAA19CA122Accident · No injuriesData collectionFinal reportCessna 172 · Miami, FLThe student pilot's failure to control the airplane's speed and direction during the approach, which resulted in landing long, a runway excursion, and impact with a windsock.NTSB GAA19CA085Accident · Minor injuriesData collectionFinal reportCessna 172 · St. Petersburg, FLThe pilot's failure to remove the gust lock before flight, which resulted in the airplane’s inability to rotate and a subsequent runway overrun. Contributing to the accident was the pilot’s failure to follow the preflight checklist.NTSB GAA19CA081Accident · No injuriesData collectionFinal reportCessna 172 · Inverness, FLThe pilot receiving instruction's failure to maintain directional control during landing.NTSB GAA18CA517Accident · No injuriesData collectionFinal reportChampion 7GCBC · Ocklawaha, FLThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA299Accident · No injuriesData collectionFinal reportCessna 172 · Defuniak Springs, FLThe student pilot’s failure to maintain directional control during the aborted landing.NTSB GAA18CA218Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Pensacola, FLThe pilot’s loss of directional control and long landing in gusting wind conditions due to his shoe getting stuck on the brakes.NTSB GAA17CA348Accident · No injuriesData collectionFinal reportPiper PA 16 · Palatka, FLThe pilot’s failure to maintain directional control during the landing.NTSB GAA17CA081Accident · No injuriesData collectionFinal reportCessna 172 · Destin, FLThe student pilot’s overcorrection with right rudder, which resulted in a loss of directional control, and the flight instructor’s delayed remedial action.NTSB GAA16CA360Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during the landing flare, which resulted in a runway excursion, and impact with a sign.NTSB GAA16CA073Accident · No injuriesData collectionFinal reportCessna 172N · Boca Raton, FLThe pilot's failure to maintain directional control during the landing touchdown resulting in a runway excursion, a collision with an object, and an impact with terrain.NTSB ERA14LA448Accident · No injuriesLimited investigationFinal reportCessna 172M · Leesburg, FLThe flight instructor’s delayed remedial action and his subsequent loss of directional control during landing on a wet runway for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies.NTSB ERA14CA046Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Clewiston, FLThe student pilot's failure to maintain directional control during takeoff.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 ERA10CA078Accident · No injuriesData collectionFinal reportCessna 172 · Panancea, FLThe pilot's failure to maintain directional control during the landing rollout.NTSB NYC08CA193Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was a crosswind.NTSB LAX08CA120Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plant City, FLThe pilot's excessive taxi speed, which led to a loss of control.NTSB MIA08CA069Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control of the airplane during an aborted takeoff.NTSB MIA08CA061Accident · Minor injuriesData collectionFinal reportStephen F. Graves SG-3 · Fort Pierce, FLThe failure of the student to maintain directional control during a cross wind takeoff. A factor in the accident was inadequate supervision by the CFI.