NTSB investigations: Lycoming O-360 series, CO
12 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
| 1966 | 1 |
|---|---|
| 1969 | 1 |
| 2003 | 1 |
| 2005 | 3 |
| 2007 | 3 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
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\" = 'CO' 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" = 'CO' 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 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 CEN11CA550Accident · Serious injuriesData collectionFinal reportAttaway Robert H RV6A · Colorado Springs, COThe pilot's failure to maintain control while 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 DEN08CA046Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Pueblo, COthe pilot's failure to maintain aircraft control resulting in a hard landing.NTSB DEN07CA131Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Erie, COThe student pilot's failure to maintain rotor rpm resulting in a loss of aircraft control during a simulated 180 degree auto-rotation. Contributing to the accident was the inadequate flight status supervision by the flight instructor and the student pilot's…NTSB DEN07CA072Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Broomfield, COThe instructor's failure to maintain aircraft control. A contributing factor was the windshear.NTSB DEN06CA012Accident · No injuriesData collectionFinal reportKucklick Hiperbipe · Watkins, COthe pilot's failure to maintain aircraft control during the landing resulting in a impact with a runway light and ground loop.NTSB DEN05LA130Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Falcon, COthe pilot's failure to maintain control of the helicopter while conducting a hovering maneuver.NTSB DEN05LA115Accident · No injuriesLimited investigationFinal reportHepperlen RV-8 · Durango, COthe pilot's failure to maintain directional control during the ground roll.NTSB DEN04LA030Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Broomfield, COthe flight instructor's failure to maintain aircraft control. Contributing to the accident was the wind gust.NTSB DEN70D0042Accident · No injuriesClosedCessna 150G · Longmont, CONTSB DEN67D0167Accident · No injuriesClosedCessna 150 · Logmont, CO