Skip to content

NTSB investigations: Lycoming IO-360-A1B6D, TX

18 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

19732026

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" = 'TX' 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\" = 'TX' 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" = 'TX' 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 CEN19LA091Accident · Serious injuriesClass 3 · LimitedFinal reportVan's RV-8 · Horseshoe Bay, TXA total loss of engine power for reasons that could not be determined based on the available information.Feb 15, 2019 · N737MC · Substantial damage NTSB FTW01LA046Accident · No injuriesLimited investigationFinal reportCessna 177RG · Del Rio, TXThe pilot's inadequate compensation for the winds. A factor was the windshear.Jan 5, 2001 · N45373 · Substantial damage NTSB FTW98LA053Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Tomball, TXThe total loss of engine power resulting from the loss of oil and resultant seizure of a cylinder due to inadequate maintenance by maintenance personnel. A factor was the lack of suitable terrain for the forced landing and the low ceiling.Nov 19, 1997 · N88WC · Substantial damage NTSB FTW95FA150Accident · 1 fatalField investigationFinal reportCessna 177RG · Dalhart, TXThe pilot's VFR flight into IMC conditions and the ensuing spatial disorientation. Factors were the pilot's self-induced pressure to reach his destination, his failure to obtain a weather briefing for the flight, and the weather conditions.Mar 30, 1995 · N35917 · Destroyed NTSB FTW94FA057Accident · 3 fatalField investigationFinal reportCessna 177RG · Van Horn, TXThe pilot exceeded the design stress limits of the aircraft after a loss of control which resulted from VFR flight into instrument meteorological conditions. Factors were the weather, the pilot's lack of instrument training and experience, and his failure to…Dec 29, 1993 · N1527H · Destroyed NTSB FTW90LA145Accident · No injuriesLimited investigationFinal reportCessna 177RG · Arlington, TXThe pilot misjudged airplane attitude during the landing flare.Jul 13, 1990 · N2022Q · Substantial damage NTSB FTW86FA063Accident · 1 fatalField investigationFinal reportCessna 177RG · Dallas, TXThe pilot was advised by the FAA weather briefer, prior to flight, against making this flight due to present and forecast weather conditions. After arriving in the general area of his destination the plt observed the weather conditions and commented on thier…Apr 12, 1986 · N8047G · Destroyed NTSB FTW85FA358Accident · No injuriesField investigationFinal reportCessna 177RG · Ennis, TXThe plt could not lower the landing gear through use of the normal gear extension system. He was able to partially lower it through the use of the emergency extension system. Next he made an emergency landing at the departure airport during the hours of…Sep 27, 1985 · N2637V · Substantial damage NTSB FTW82DA337Accident · No injuriesFinal reportCessna 177RG · Afton, TXWhile en route, the piiot encountered severe weather and landed on a paved road. He stated that after about 2 hrs, the weather improved and he decided to taxi to an area where he could takeoff. While taxiing, the left wing struck a tree which pulled the…Aug 18, 1982 · N50038 · Substantial damage NTSB FTW81DRG42Accident · No injuriesClosedCessna 177RG · Austin, TXJun 12, 1981 · N2131Q · Substantial damage NTSB FTW80FPD05Accident · No injuriesClosedCessna 177RG · Fort Worth, TXOct 26, 1979 · N21EB · Substantial damage NTSB FTW79DRA11Accident · No injuriesClosedCessna 177RG · League City, TXMar 19, 1979 · N2740V · Substantial damage NTSB FTW78FRG46Accident · Minor injuriesClosedCessna 177RG · Mc Dade, TXJun 3, 1978 · N2173Q · Substantial damage NTSB FTW77FA066Accident · Minor injuriesClosedBeech C35 · Fort Worth, TXAug 5, 1977 · N726D · 2 aircraft · Substantial damage NTSB FTW77FPA16Accident · No injuriesClosedCessna 177RG · Dallas, TXJun 30, 1977 · N1977Q · Substantial damage NTSB FTW77FPD29Accident · No injuriesClosedCessna 177RG · Abilene, TXJun 15, 1977 · N7236V · Substantial damage NTSB FTW77FRG38Accident · Minor injuriesClosedCessna 177RG · George West, TXApr 17, 1977 · N7515V · Substantial damage NTSB FTW74DQG34Accident · No injuriesClosedCessna 177RG · Lehman, TXNov 24, 1973 · N8015G · Substantial damage