NTSB investigations: Lycoming 0-320 series, TX
22 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 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 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\" = 'TX' 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" = 'TX' 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 CEN26LA302Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-22-150 · Brenham, TXNTSB CEN24LA131Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Lubbock, TXThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB CEN24LA071Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Stephenville, TXThe pilot’s failure to maintain directional control during landing that resulted in an impact with terrain.NTSB CEN23FA183Incident · 1 fatalClass 3 · FieldFinal reportRobinson R22 Beta · Brady, TXThe non-certificated pilot’s failure to ensure the collective friction control was adequately engaged during an on-ground engine run, which resulted in the helicopter inadvertently becoming airborne. Contributing to the crash were the pilot’s various physical…NTSB CEN23LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Nacogdoches, TXThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN23LA154Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Terrell, TXThe student pilot’s failure to maintain directional control during landing and the flight instructor’s delayed remedial response.NTSB CEN23LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · San Antonio, TXThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN22LA173Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Tomball, TXThe pilot did not maintain directional control during landing, which led to a runway excursion and nose-over of the airplane.NTSB CEN22LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Plains, TXThe pilot’s failure to maintain control of the airplane during taxi with a strong crosswind.NTSB CEN20CA359Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Corsicana, TXThe student pilot did not maintain control of the airplane during the takeoff roll.NTSB CEN20CA281Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Houston, TXThe flight instructor and student pilot did not properly transfer airplane control during ground rollout, which resulted in the airplane exiting the runway and impacting a ditch.NTSB GAA19CA192Accident · Minor injuriesData collectionFinal reportCessna 172 · Stephenville, TXThe student pilot's improper landing flare, which resulted in a hard landing, and his subsequent failure to maintain directional control in gusting crosswind conditions that exceeded the airplane’s demonstrated crosswind for landing, which resulted in a…NTSB CEN15CA324Accident · Serious injuriesData collectionFinal reportAero Commander 100 · San Antonio, TXThe pilot's improper decision to attempt flight with an unairworthy airplane and improper starting procedure that resulted in an uncontrolled takeoff without the pilot aboard. Contributing was the inoperative airplane battery/engine starter.NTSB CEN14LA451Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Gordonville, TXA loss of directional control during a crosswind landing.NTSB CEN13CA450Accident · No injuriesData collectionFinal reportCessna 172N · Mesquite, TXThe student pilot failed to maintain directional control during the touch-and-go landing and during the subsequent aborted takeoff during crosswind conditions.NTSB CEN13CA222Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot’s failure to maintain airplane control while taking off in gusting wind conditions.NTSB CEN11CA450Accident · Minor injuriesData collectionFinal reportAmerican Champion 7GCBC · Sugar Land, TXThe pilot's failure to maintain directional control during landing.NTSB CEN10CA328Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Arcola, TXThe student pilot’s failure to maintain directional control of the tailwheel-equipped airplane during the landing roll.NTSB CEN10CA192Accident · Minor injuriesData collectionFinal reportStroup Robert RV-6 · Muleshoe, TXThe pilot's failure to maintain directional control during takeoff in strong, gusting winds.NTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.NTSB CEN09CA184Accident · No injuriesData collectionFinal reportMarrero Andres Starduster · San Antonio, TXThe pilot's loss of control during take off. Contributing to the accident was the crosswind component.NTSB DFW08CA151Accident · No injuriesData collectionFinal reportCessna CE-172M · San Antonio, TXThe student pilots improper short field landing procedure and excessive rate of descent. A contributing factor was the student pilots improper recovery from a bounced landing.