NTSB investigations: Lycoming O-360 series, ID
14 cases on aircraft whose registry engine model is Lycoming O-360 series. 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
| 2002 | 1 |
|---|---|
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2009 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2023 | 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.\"eventStateOrRegion\" = 'ID' 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 ('41575'))
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" = 'ID' 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 ('41575'))
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 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 WPR23LA265Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Emmett, IDThe instructor’s failure to maintain airspeed during a simulated turning autorotation, which resulted in a hard landing.NTSB WPR20CA140Accident · No injuriesData collectionFinal reportRobinson R22 · Caldwell, IDThe flight instructor's failure to set the proper rotor rpm during a practice autorotation, which led to his failure to maintain a proper descent rate and resulted in a hard, bounced landing.NTSB WPR19LA120Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 225 DD · McCall, IDA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA16CA524Accident · Minor injuriesData collectionFinal reportVan Hoomissen Gerald J Murphy Elite · Nordman, IDThe floatplane pilot's improper landing flare during landing on choppy water with a tailwind, which resulted in a nose-over. Contributing to the accident was the pilot's failure to determine the wind direction before landing.NTSB WPR12LA289Accident · No injuriesLimited investigationFinal reportCox PA 18 · Soldier Bar, IDThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and the airplane nosing over.NTSB WPR12CA041Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Ashton, IDThe student pilot’s poor decision-making when he decided to land on a snowy grass airstrip, which resulted in an encounter with deep snow during the landing roll and a subsequent nose-over.NTSB WPR11LA436Accident · No injuriesLimited investigationFinal reportTubbs S/Performance PA-18 225DD · Mile Hi Landing Strip, IDThe collapse of the left landing gear during landing for undetermined reasons.NTSB WPR10CA042Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Marsing, IDThe pilot's failure to maintain adequate main rotor rpm during the approach and subsequent go-around and the certified flight instructor's inadequate supervision of the flight.NTSB WPR09LA314Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Lewiston, IDA loss of engine power while in cruise flight for undetermined reasons.NTSB SEA06CA070Accident · No injuriesData collectionFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control and subsequent nose over. Contributing factors were the tailwind and the soft snow-covered terrain.NTSB SEA05CA182Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Boise, IDInadequate communications between the certified flight instructor and student pilot, and the student pilot's delay in relinquishing controls resulting in a hard landing during a practice autorotation.NTSB SEA03LA167Accident · No injuriesLimited investigationFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain control of the aircraft during the landing roll. A contributing factor was the dust devil.NTSB SEA02LA183Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18 · Gannett, IDThe pilot's excessive braking during the landing rollout.