NTSB investigations: Lycoming 0-320 series, CA
24 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Loss of control in flight. 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 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 3 |
| 2018 | 4 |
| 2019 | 5 |
| 2021 | 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\" = 'CA' 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\" = '240'))
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" = 'CA' 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" = '240'))
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 WPR21LA311Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Kernville, CAThe pilot’s failure to maintain airplane control during landing after an encounter with a wind gust which resulted in a collision with trees.NTSB WPR19FA262Accident · 1 fatalClass 3 · FieldFinal reportCessna 177 · Torrance, CAThe pilot’s failure to maintain adequate airspeed and exceedance of the aircraft's critical angle of attack while turning during climb out, which resulted in an aerodynamic stall.NTSB WPR19FA163Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Antioch, CAA loss of control while conducting low-altitude, high-speed maneuvers.NTSB GAA19CA333Accident · No injuriesData collectionFinal reportPiper PA22 · Riverside, CAThe pilot's failure to the maintain the runway heading during landing with a crosswind, which resulted in impact with runway lighting and a subsequent ground loop during the landing roll.NTSB GAA19CA247Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper retraction of the flaps during a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR19LA100Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Watsonville, CAThe pilot’s loss of airplane control during a go-around for reasons that could not be determined based on available evidence.NTSB GAA18CA542Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe student pilot's failure to maintain lateral control during the aborted landing.NTSB GAA18CA232Accident · No injuriesData collectionFinal reportCessna 172 · San Jose, CAThe student pilot’s failure to maintain the runway heading during the approach to land, and the flight instructor’s delayed remedial action.NTSB GAA18CA201Accident · Minor injuriesData collectionFinal reportCessna 172 · Livermore, CAThe student pilot’s failure to maintain runway centerline and flight instructor’s delayed remedial action during landing.NTSB WPR18CA072Accident · Minor injuriesData collectionFinal reportCessna 172P · Cloverdale, CAThe pilot's failure to maintain airplane control during the approach and his delayed decision to go around.NTSB WPR17FA029Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Glamis, CAThe pilot's improper decision to attempt a downwind landing and his failure to maintain adequate airspeed while maneuvering during a go-around and subsequent landing attempt, which resulted in exceedance of the airplane's critical angle of attack and an…NTSB GAA17CA035Accident · Minor injuriesData collectionFinal reportPiper PA 28 · Fresno, CAThe pilot’s exceedance of the airplane’s critical angle of attack during departure due to being distracted by looking for his phone.NTSB WPR16FA126Accident · 1 fatalField investigationFinal reportPiper PA 23-150 · Hayward, CAThe failure of the left engine due to water contamination and the pilot's subsequent failure to maintain single-engine minimum control airspeed, which resulted in an uncontrolled descent. Contributing to the accident was the pilot's lack of total and recent…NTSB GAA16CA002Accident · No injuriesData collectionFinal reportCessna 172 · Avalon, CAThe pilot's exceedance of the critical angle of attack in turbulent and downdraft conditions, which resulted in an aerodynamic stall and collision with terrain on final approach.NTSB GAA15CA276Accident · No injuriesData collectionFinal reportPiper PA 28 · Van Nuys, CAThe pilot's failure to compensate for turbulence during the landing flare, which resulted in a hard landing and runway excursion.NTSB WPR14CA354Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain helicopter control during a practice hover. Contributing to the accident was the flight instructor's delayed remedial reaction.NTSB WPR14CA122Accident · No injuriesData collectionFinal reportCessna 172M · Ramona, CAThe student pilot's inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB WPR14LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAThe flight instructor’s inadequate compensation for the gusting crosswind conditions during landing, which resulted in a loss of airplane control.NTSB WPR14FA078Accident · 2 fatalField investigationFinal reportCessna 172K · Fresno, CAThe pilot’s failure to maintain adequate clearance from trees while on approach, which subsequently led to a loss of airplane control. Also causal was the pilot’s continued operation of the airplane at night with a diagnosed medical condition that degraded…NTSB WPR13FA370Accident · 2 fatalField investigationFinal reportChampion 7GCAA · Paradise, CAThe pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.NTSB WPR10LA307Accident · 1 fatalLimited investigationFinal reportCessna 172N · Angels Camp, CAThe pilot’s failure to maintain airplane control while maneuvering.NTSB WPR09LA419Accident · 2 fatalLimited investigationFinal reportJames B. Taplin RV-6 · Orland, CAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin.NTSB LAX08FA109Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · San Dimas, CAA loss of engine power in the left engine due to fuel starvation as a result of the pilot's inadequate preflight inspection and the pilot's failure to abort the takeoff following the power loss.NTSB SEA08CA088Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Tracy, CAThe flight instructor's inadequate compensation for the tailwind condition and failure to maintain adequate airspeed that led to an inadvertent stall.