NTSB investigations: Lycoming IO-360-A1B6D, GA
13 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.
Cases per year
| 1976 | 1 |
|---|---|
| 1978 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1998 | 2 |
| 2005 | 1 |
| 2007 | 1 |
| 2011 | 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\" = 'GA' 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" = 'GA' 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" 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 ERA23LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Dacula, GAAn in-flight collision with a bird while on approach.NTSB ERA21LA105Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Richmond Hill, GAThe pilot’s mismanagement of the fuel supply, which resulted in fuel starvation.NTSB ERA12FA084Accident · 3 fatalField investigationFinal reportCessna 177RG · Tallapoosa, GAThe failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.NTSB NYC07LA182Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Kennesaw, GAThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion during approach.NTSB ATL06LA028Accident · Serious injuriesLimited investigationFinal reportCessna 177-RG · Locust Grove, GAThe total loss of engine power due to failure of the No.1 connecting rod bearing and separation of the No. 1 connecting rod.NTSB MIA98LA242Accident · No injuriesLimited investigationFinal reportCessna 177RG · Covington, GAslippage of the No. 3 connecting rod bearing resulting in blockage of the oil port, oil starvation, and subsequent connecting rod failure. A factor was the fence.NTSB MIA98LA073Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Cumming, GAThe pilot's misjudgment of distance and airspeed, and his failure to attain the proper touchdown point.NTSB ATL93LA154Accident · No injuriesLimited investigationFinal reportCessna 177RG · Valdosta, GAThe pilot's inadequate evaluation of inflight weather conditions which resulted in the inflight encounter with severe turbulence and subsequent overstress of the airframe.NTSB ATL89IA104Incident · No injuriesIncident investigationFinal reportCessna 177RG · Savannah, GAFatigue-induced fracture of the main landing gear actuator rod end.NTSB ATL86LA047Accident · No injuriesLimited investigationFinal reportCessna 177RG · Atlanta, GAThe aircraft landed hard resulting in substantial damage to the aircraft. This was following a final approach which was flown high and fast. The aircraft was observed to stall approximatel 10 ft above the runway and land on the nose gear.NTSB ATL83FA313Accident · Serious injuriesField investigationFinal reportCessna 177RGII · Atlanta, GAJust before rotation & during climbout from rwy 26L the eng started surging. The acft made a left turn, into the wind, & the student plt attempted to land on rwy 8R. The acft became misaligned, overshot the rwy, & made a hard landing in the grass about 200 ft…NTSB MIA78FKG48Accident · No injuriesClosedCessna 177RG · Newman, GANTSB MIA76FKH06Accident · Minor injuriesClosedCessna 177RG · Dahonega, GA