Skip to content

NTSB investigations: Lycoming IO-360-A1B6D, FL

21 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

19742026

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" = 'FL' 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\" = 'FL' 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" = 'FL' 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 ERA23LA197Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Crestview, FLThe total loss of engine power due to the loosening and separation of the No. 1 connecting rod cap nuts in flight, resulting in catastrophic internal engine damage. Contributing to the accident was the pilot/owner’s failure to comply with the engine…Apr 14, 2023 · N7542V · Substantial damage NTSB ERA20CA276Accident · No injuriesClass 4 · Data collectionFinal reportCessna 177RG · Lakeland, FLThe pilot’s failure to maintain control of the airplane during the attempted engine start.Jul 26, 2020 · N2629V · Substantial damage NTSB NYC08CA126Accident · No injuriesData collectionFinal reportMorrison Vans RV-8 · Port Orange, FLThe airplane's inadvertent encounter with a crosswind gust during the landing roll, which resulted in the pilot's loss of directional control.Mar 3, 2008 · N781RV · Substantial damage NTSB MIA08CA054Accident · Serious injuriesData collectionFinal reportCessna 177RG · Tallahassee, FLPilot's inaccurate fuel management resulting in fuel exhaustion.Feb 9, 2008 · N52495 · Substantial damage NTSB MIA04FA076Accident · 2 fatalField investigationFinal reportCessna 177RG · Tampa, FLImproper maintenance by other maintenance personnel, and the reinstallation of an unserviced magneto during an engine overhaul, which resulted in the magneto malfunctioning, a loss of engine power, and the airplane being ditched into the water.Apr 20, 2004 · N1910Q · Substantial damage NTSB MIA03LA101Accident · No injuriesLimited investigationFinal reportCessna 177-RG · Clearwater, FLThe pilot's failure to maintain directional control during landing roll resulting in the failure and separation of the right main landing gear, partial collapse of the nose landing gear, and substantial damage to the airplane.Apr 28, 2003 · N8015G · Substantial damage NTSB MIA00FA126Accident · 1 fatalField investigationFinal reportCessna 177RG · Chipley, FLThe failure of the pilot to maintain runway alignment during the initial climb from the grass airstrip. Also, the excessive pull-up by the pilot and inadvertent stall. Findings in the investigation were 1) in-flight collision with the tops of trees and 2) the…Apr 3, 2000 · N1997Q · Substantial damage NTSB MIA97FA249Accident · 2 fatalField investigationFinal reportCessna 177RG · Sebring, FLcontinued flight by the pilot into adverse weather conditions, and his failure to maintain aircraft control, which resulted in an uncontrolled descent until impact in a lake. The adverse weather condition (thunderstorm) was a related factor.Sep 19, 1997 · N2562V · Destroyed NTSB ATL96LA093Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lake Placid, FLmaintenance personnel's failure to properly torque the cylinder installation bolts.Jun 16, 1996 · N2186Q · Substantial damage NTSB MIA91LA009Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · De Funiak Spgs, FLThe loose fuel cap and failure of the pilot to assure the aircraft was properly preflighted, which resulted in fuel siphoning and subsequent fuel exhaustion. Factors related to the accident were: faulty fuel quantity gages, the pilot's decision to fly with…Oct 14, 1990 · N52838 · Substantial damage NTSB MIA90LA030Accident · No injuriesLimited investigationFinal reportCessna 177RG · Mims, FLA worn throttle control assembly that had failed.Nov 21, 1989 · N7628V · Substantial damage NTSB MIA86LA170Accident · No injuriesLimited investigationFinal reportCessna 177RG · Jacksonville, FLThe plt stated that the landing gear indicator light showed the gear to be down & locked. When the acft touched down the landing gear collasped and the acft slid to a stop. Post crash examination of the landing gear showed it to operate normally in all modes.…May 30, 1986 · N1888Q · Substantial damage NTSB MIA85LA258Accident · No injuriesLimited investigationFinal reportCessna 177RG · Ormond Beach, FLThe plt stated that he forgot to extend the landing gear prior to touchdown while on a test flight after maintainence work was performed on the acft.Sep 17, 1985 · N52637 · Substantial damage NTSB MIA83LA028Accident · No injuriesLimited investigationFinal reportCessna 177RG · Pensacola, FLAccording to the pilot, shortly after liftoff the engine lost power and he aborted the takeoff. The aircraft overran the end of the runway and collided with uneven terrain.Nov 14, 1982 · N2699V · Substantial damage NTSB MIA82DA086Accident · No injuriesFinal reportCessna 177RG · Jacksonville, FLThe pilot stated that he became distracted by radio communications with the control tower and forgot to lower the landing gear prior to landing.Mar 25, 1982 · N1964Q · Substantial damage NTSB MIA80FKT08Accident · No injuriesClosedCessna 177RG · Boca Raton, FLDec 11, 1979 · N2010Q · Substantial damage NTSB MIA79DA076Accident · No injuriesClosedCessna 177RG · Pensacola, FLApr 26, 1979 · N45133 · Substantial damage NTSB MIA77DLA30Accident · No injuriesClosedCessna 177RG · Galliver, FLMay 21, 1977 · N1884Q · Substantial damage NTSB MIA77FLA09Accident · No injuriesClosedCessna 177RG · Pensacola, FLDec 8, 1976 · N1521H · Substantial damage NTSB MIA76FLA31Accident · No injuriesClosedCessna 177RG · Jacksonville, FLJan 28, 1976 · N2199Q · Substantial damage NTSB MIA74FLD55Accident · No injuriesClosedCessna 177RG · St Petersburg, FLJan 23, 1974 · N1830Q · Substantial damage