NTSB investigations: Lycoming 0-360-A1D, CO
16 cases on aircraft whose registry engine model is Lycoming 0-360-A1D. 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
| 1978 | 1 |
|---|---|
| 1985 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2008 | 2 |
| 2009 | 1 |
| 2011 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 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 ('41504'))
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 ('41504'))
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 CEN22LA179Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Englewood, COThe flight instructor’s inadequate supervision of the student pilot and the student pilot’s loss of directional control during landing, which resulted in a runway excursion.NTSB CEN21LA403Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Gunnison, COThe pilot’s failure to maintain directional control of the airplane after landing with a quartering tailwind.NTSB CEN19LA314Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Colorado Springs, COThe pilot's improper taxi speed and his excessive use of brakes, which resulted in a brake fire and substantial thermal damage to the airplane.NTSB CEN12CA075Accident · No injuriesData collectionFinal reportGlobe GC-1B · Denver, COA loss of engine power due to fuel starvation as a result of a loose fuel line fitting.NTSB CEN09FA147Accident · 1 fatalField investigationFinal reportMooney M20C · Elbert, COThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent loss of control.NTSB DEN08CA146Accident · No injuriesData collectionFinal reportHelie RV-6 · Denver, COThe pilot failed to maintain directional control during landing. Contributing to the accident was the crosswind.NTSB DFW08CA124Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Rifle, COThe pilot's failure to maintain control of the airplane on landing. A factor was the crosswind and wind gusts.NTSB DEN05CA096Accident · No injuriesData collectionFinal reportAviat A-1B · Dove Creek, COthe pilot's failure to maintain airspeed during initial climb which resulted in an inadvertant stall and impact with terrain.NTSB DEN03FA111Accident · 1 fatalField investigationFinal reportHammond Vans RV-6A · La Junta, COthe pilot's failure to maintain airspeed resulting in a stall during the turn from base leg to final approach.NTSB DEN01LA155Accident · No injuriesLimited investigationFinal reportVans RV-6A · Pagosa Springs, COThe pilot's inadequate airplane preflight inspection which led to the subsequent lateral control of the airplane on the ground not being possible. A contributing factor was the unavailability of rudder control due to a headset blocking the rudder control…NTSB DEN99LA058Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Englewood, COThe flight instructor allowed the rotor rpm to decay during an autorotation which resulted in a hard landing.NTSB FTW98LA110Accident · No injuriesLimited investigationFinal reportAviat A-1 · Buena Vista, COThe pilot's failure to maintain directional control of the airplane. Factors were the crosswind changing to a tailwind, and the pilot's lack of experience in the type of aircraft.NTSB FTW94LA201Accident · Minor injuriesLimited investigationFinal reportGamble BD-4 · Leadville, COThe pilot's failure to maintain directional control. Factors were an unreliable airspeed indicator and excessive landing approach airspeed.NTSB DEN89LA126Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Fort Collins, COLoss of engine power for an undetermined reason. The dark night and terrain condition were considered to be contributing factors.NTSB DEN85FA102Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Vail, COThe plt did not obtain a wx briefing, file a flight plan or refuel the acft prior to departing for eagle Colorado. The acft departed at 1800 under VFR cond. The plt reported over minturn co at 2019. Witnesses at Vail co stated that the wx cond were poor from…NTSB DEN78FTE61Accident · No injuriesClosedMooney M20C · Bennett, CO