NTSB investigations: Lycoming O-360 series
24 cases on aircraft whose registry engine model is Lycoming O-360 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 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2012 | 3 |
| 2015 | 1 |
| 2017 | 2 |
| 2018 | 5 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
| 2026 | 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 ('41575')
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 ('41575')
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 WPR26LA156Accident · No injuriesClass 4 · LimitedFinal reportMarshall Daniel R L-21 · Cody, WYThe pilot's failure to maintain control of the airplane during the landing rollout, which resulted in a nose-over.NTSB CEN26LA117Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · De Smet, SDThe pilot’s failure to maintain directional control during landing.NTSB ERA25LA015Accident · No injuriesClass 4 · LimitedFinal reportAviat A1 · Rowlesburg, WVThe pilot’s failure to maintain directional control during the landing roll, resulting in the on-ground collision with trees.NTSB WPR24LA008Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Caldwell, IDThe pilot’s failure to maintain directional control during landing, resulting in a roll over.NTSB CEN22LA316Accident · Minor injuriesClass 4 · LimitedFinal reportPiper/Cub Crafters PA-18-150 · Llano, TXThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.NTSB CEN22LA097Accident · No injuriesClass 3 · LimitedFinal reportAviat A-1B · Matagorda Island, TXThe pilot’s loss of directional control during an intentional off-airport landing.NTSB GAA18CA577Accident · No injuriesData collectionFinal reportAviat A1 · Grand Island, NEThe pilot’s failure to maintain directional control during the landing roll in tailwind and crosswind conditions. Contributing to the accident was the pilot’s fatigue.NTSB GAA18CA480Accident · No injuriesData collectionFinal reportPiper PA18 · Raton, NMThe pilot's loss of directional control during the landing roll.NTSB CEN18LA295Accident · Serious injuriesLimited investigationFinal reportVans RV7A · Princeton, MNA flat nosewheel tire, which resulted in the pilot’s inability to maintain directional control on landing.NTSB GAA18CA336Accident · No injuriesData collectionFinal reportAviat A 1 · Renton, WAThe pilot’s inadequate crosswind correction, which resulted in the right wing impacting the water’s surface.NTSB GAA18CA206Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Edgewood, NMThe pilot’s failure to maintain directional control of the airplane during landing.NTSB GAA17CA451Accident · No injuriesData collectionFinal reportMark Goldberg Bearhawk Patrol · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.NTSB GAA17CA228Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Willow, AKThe airplane's left main ski's collision with a submerged frozen sand berm.NTSB GAA15CA264Accident · No injuriesData collectionFinal reportAviat A1 · Rock Springs, WYThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR12LA348Accident · No injuriesLimited investigationFinal reportSantana PA-18 Replica · Ronan, MTA jammed tailwheel assembly, which resulted in the pilot’s inability to maintain directional control upon landing.NTSB ERA12CA284Accident · No injuriesData collectionFinal reportTiger AG-5B · Lincoln Park, NJThe pilot's failure to maintain directional control during a go-around in a crosswind.NTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.NTSB WPR10CA358Accident · No injuriesData collectionFinal reportAviat A-1B · Casper, WYThe pilot's failure to maintain directional control during landing.NTSB CEN10CA366Accident · No injuriesData collectionFinal reportAviat A-1B · Centennial, COThe student pilot's failure to maintain directional control and the certified flight instructor's delay in remedial action.NTSB ERA10CA083Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 · Indian Key, FLThe pilot's failure to secure the collective control prior to departing the helicopter, which resulted in an unmanned departure and subsequent crash of the helicopter.NTSB ERA10CA064Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pahokee, FLThe pilot’s failure to maintain control of the helicopter.NTSB WPR09CA127Accident · No injuriesData collectionFinal reportCub Crafters PA-18-150 · Buckeye, AZThe pilot's failure to maintain directional control.NTSB CHI08CA289Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Crookston, MNThe pilot's failure to maintain directional control during landing and the flight instructor's delayed remedial action.NTSB ANC08CA105Accident · Minor injuriesData collectionFinal reportWalker AK Bush Flyer · Deadhorse, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor contributing to the accident was a tailwind.