Fatal NTSB investigations: Lycoming IO-360-A1B6D
12 cases on aircraft whose registry engine model is Lycoming IO-360-A1B6D, where the first occurrence was “In flight encounter with weather”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 1 |
| 1993 | 1 |
| 1995 | 3 |
| 1997 | 1 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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."highestInjuryLevel" = 'Fatal'
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 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.NTSB SEA95LA185Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Thompson, UTthe pilot's continued flight into instrument meteorological conditions, and his failure to maintain altitude and clearance from the mountainous terrain. Factors contributing to the accident were the fog, low ceilings, and downdraft.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.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.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…NTSB DEN88FA128Accident · 2 fatalField investigationFinal reportCessna 177RG · Afton, WYThe acft was not certified nor equipped for flt into icing conditions. The plt elected to depart even though he was advised by the crew of a C-182 that had just lndd to stay below the clouds because of icing. After tkof the acft cleared an 11000 ft mtn range…NTSB SEA87FA031Accident · 1 fatalField investigationFinal reportCessna 177RG · Republic, WAA witness observed the acft taxi out ot the rwy in light snow showers and taxi to the north end of the rwy. During the takeoff the area was covered with a heavy snow shower, with winds from the north gusting T0 20-25 mph. The acft was observed to depart to…NTSB LAX87FA014Accident · 2 fatalField investigationFinal reportCessna 177RG · Happy Jack, AZThe non-instrument rated private plt was informed that MVFR weather conditions existed along his planned route of flight. The plt took off & headed into the deteriorating wx. While cruising beneath clouds the acft collided with rapidly rising terrain. The plt…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…NTSB LAX86FA048Accident · 3 fatalField investigationFinal reportCessna 177RG · San Bernardino, CAThe instrument rated plt & his family flew from TX to CA. It was night time upon arrival and the plt did not communicate with any FAA facility. Earlier in the flt, during a refueling stop, the plt had telephoned a friend and his parents to arrange to be…NTSB LAX83FA091Accident · 3 fatalField investigationFinal reportCessna 177RG · Las Vegas, NVThe acft collided with a mountain during a night cross-country. The weather was VMC at takeoff but became IMC later nearthe mountains. A VFR flight plan was filed but never opened. The pilot continued flight into an area of known IMC conditions. He had…NTSB MKC82FA057Accident · 2 fatalField investigationFinal reportCessna 177RG · Ste. Genevieve, MODuring the day of the accident, the pilot received 7 weather briefings which described marginal VFR conditions for his route of flight. At about 1730 CST, he departed Kansas city on a VFR flight plan to farmington, MO. During the flight, he encountered…