NTSB investigations: Lycoming IO-360-A1B6D
11 cases on aircraft whose registry engine model is Lycoming IO-360-A1B6D, where the first occurrence was “Loss of control - on ground/water”. 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
| 1983 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 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.\"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\" = 260))
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."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" = 260))
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 SEA07LA187Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fresno, CAThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB NYC05LA070Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Warren, PAThe pilot's failure to follow the balked landing checklist while attempting to abort a landing. Factors in the accident were his failure to maintain directional control during the landing, and a gust of wind.NTSB LAX04CA231Accident · No injuriesData collectionFinal reportGlenn L Smith RV-8 · Boulder City, NVthe pilot's failure to maintain directional control of the airplane. Contributing to the accident was a sudden wind shift.NTSB LAX03LA136Accident · No injuriesLimited investigationFinal reportCessna 177RG · Redding, CAThe pilot's improper engine starting procedures, and his failure to maintain clearance with a parked airplane, resulting in a collision with the parked and unoccupied airplane.NTSB DEN01LA160Accident · No injuriesLimited investigationFinal reportCessna 177RG · St. George, UTbrake system failure for reasons undetermined, which resulted in a loss of control on landing.NTSB IAD96LA093Accident · No injuriesLimited investigationFinal reportCessna 177RG · Westminster, MDThe pilot-in-command's failure to maintain control of the airplane during landing. A factor in this accident was the CFI-rated pilot/passenger's inattention.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.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.NTSB LAX85LA207Accident · No injuriesLimited investigationFinal reportCessna 177 · Chinle, AZThe aircraft landed on runway 17. The winds were form 220 degrees gusting to 30-35 knot. The pilot stated that, as he came by a quonset hangar, the aircraft was struck by a gust of wind from the right front quarter. The aircraft weather-vaned into the wind…NTSB CHI85LA117Accident · No injuriesLimited investigationFinal reportCessna 177RG · Janesville, WIThe acft collided with a snowbank during lndg. An investigation by a qualified A&P mech found the lock-o-seal in the master cylinder had improper clearance. Lack of proper clearence restricted return flow of brake fluid to the reservoir. This led to locking…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…