Skip to content

NTSB investigations: Lycoming IO-360-A1B6D, CO

16 cases on aircraft whose registry engine model is Lycoming IO-360-A1B6D. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19752026

Where

Latest cases

Query with SQL

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 ('41593')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('41593'))
  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 ('41593'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 DEN01LA119Accident · No injuriesLimited investigationFinal reportCessna 177RG · Broomfield, COfailure of the nose landing gear hydraulic UP hose, which resulted in a wheels-up landing..Jul 1, 2001 · N2129Q · Substantial damage NTSB FTW96LA393Accident · No injuriesLimited investigationFinal reportCessna 177RG · Boulder, COFailure of the flight instructor to maintain airspeed above stall speed during initial climb and loss of control on the ground after aborting the takeoff. Factors were inadequate preflight planning and preparation, inaccurate weather evaluation, and high…Sep 21, 1996 · N7568V · Substantial damage NTSB FTW96LA384Accident · No injuriesLimited investigationFinal reportCessna 177RG · Colorado Sprngs, COThe improper installation of the propeller governor by company maintenance personnel, resulting in the total loss of oil and engine seizure. Factors were the pilot's misjudgment of altitude and airspeed, causing him to make a forced landing on unsuitable…Sep 11, 1996 · N2797V · Substantial damage NTSB FTW95FA111Accident · 1 fatalField investigationFinal reportCessna 177RG · Larkspur, COThe pilot's decision to continue VFR flight into instrument meteorological conditions after being advised that VFR flight was not recommended. The weather and dark night were factors in the accident.Feb 9, 1995 · N33MR · Destroyed NTSB FTW94LA088Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Longmont, COAn inadvertent stall due to improper preflight and the pilot's failure to adequately remove ice from the aircraft. A factor was airframe icing.Mar 1, 1994 · N2181Q · Substantial damage NTSB FTW94FA059Accident · Serious injuriesField investigationFinal reportCessna 177RG · La Veta, COThe pilot's improper inflight decision to enter a mountain pass at an inadequate altitude, causing the aircraft's climb performance to be exceeded. Factors were turbulence and downdrafts.Jan 1, 1994 · N53049 · Destroyed NTSB DEN92LA059Accident · No injuriesLimited investigationFinal reportCessna 177RG · Gunnison, COThe pilot's failure to maintain directional control. Factor(s) included: fuel exhaustion and the misjudging of fuel consumption calculations.Jun 14, 1992 · N52658 · Substantial damage NTSB DEN92LA037Accident · No injuriesLimited investigationFinal reportCessna 177RG · Durango, COA total loss of power due to a mechanical failure of the engine. Factors were: rough and uneven snow covered terrain.Feb 23, 1992 · N2550V · Substantial damage NTSB DEN91LA052Accident · No injuriesLimited investigationFinal reportCessna 177RG · Colorado Spring, COThe pilot's failure to maintain directional control of the aircraft. The gusty/quartering crosswind was a related factor.Mar 18, 1991 · N1950Q · Substantial damage NTSB DEN89LA183Accident · No injuriesLimited investigationFinal reportCessna 177RG · Brighton, COFailure of the landing gear down lock, which allowed the landing gear to collapse during the landing.Aug 4, 1989 · N8203G · Substantial damage NTSB DEN88LA190Accident · No injuriesLimited investigationFinal reportCessna 177RG · Broomfield, COThe commercial plt was practicing short field landings from the right seat on a 7,498 x 100 ft asphalt rwy. The plt said he encountered a thermal at 10 ft AGL and stalled the airplane. He reported that the acft hit harder than he expected and bounced twice.…Aug 18, 1988 · N53049 · Substantial damage NTSB DEN87LA001Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Glenwood Spring, COWhile on takeoff the acft became airborne, settled back onto the rwy, ran off the end of the rwy into a 150 foot deep river gorge, and impacted in the river.Oct 6, 1986 · N33215 · Destroyed NTSB DEN84LA026Accident · No injuriesLimited investigationFinal reportCessna 177RG · Durango, COThe acft ran off the right side of the rwy and collided with rwy lights during landing. The plt said he landed on the right side because the left side was being seal coated. Proper alignment was not maintained and the acft's right landing gear dropped off the…Nov 17, 1983 · N52050 · Substantial damage NTSB DEN82DA035Accident · No injuriesFinal reportCessna 177RG · 7 Miles N. Of S, COIn order to slow the aircraft down during flight the pilot lowered 15 degrees of flaps. As the flaps were transitioning down the pilot stated he heard a "pop sound" which was not normal. He then decided to make a precautionary landing on a dirt road. During…Feb 18, 1982 · N33NF · Substantial damage NTSB DEN81FTE08Accident · No injuriesClosedCessna 177RG · Boulder, CODec 5, 1980 · N2702V · Substantial damage NTSB DEN76ID013Incident · 1 fatalClosedCessna 177 · Loveland, COAug 29, 1975 · N2181Q · Minor damage