NTSB investigations: Lycoming IO-360-A1B6D
10 cases on aircraft whose registry engine model is Lycoming IO-360-A1B6D, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2003 | 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\" = 130))
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" = 130))
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 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.NTSB DEN01LA119Accident · No injuriesLimited investigationFinal reportCessna 177RG · Broomfield, COfailure of the nose landing gear hydraulic UP hose, which resulted in a wheels-up landing..NTSB SEA01LA075Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Seattle, WAthe reverse rigging of the aileron flight control system resulting in aileron deflections opposite that of the pilot's inputs which lead to an uncontrolled descent into the terrain. Factors include the pilot's failure to detect the misrigged ailerons during…NTSB MIA99LA194Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Jasper, ALthe pilot inadvertently became disoriented and misjudged his position on the runway/airport, which resulted in him turning the airplane too soon, and subsequently impacting with a tree. Factors in this accident were a loss of electrical power for undetermined…NTSB ATL89IA104Incident · No injuriesIncident investigationFinal reportCessna 177RG · Savannah, GAFatigue-induced fracture of the main landing gear actuator rod end.NTSB CHI88LA167Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Mankato, MNAs the pilot leveled off at his intended cruise altitude, he noted a loss of oil pressure, then saw oil spread up over the windshield, restricting his visibility. The pilot performed emergency procedures, and began descending to the nearest airport. During…NTSB ATL86FMG04Accident · No injuriesFinal reportCessna 177RG · Kenansville, NCThe acft contacted two piles of dirt during a gear-up landing. The plt took off with intensions of practicing touch and go landings. On the second apch, the plt was unable to fully extend the landing gear. The plt had one passenger check the hydraulic fluid…NTSB ATL83IA234Incident · No injuriesIncident investigationFinal reportCessna 177RG · Ozark, ALWhile in cruise flight the engine failed to respond to throttle movement due to the throttle linkage being loose. Forced landing was made to a pasture.NTSB ATL83FA008Accident · No injuriesField investigationFinal reportCessna 177RG · Montgomery, ALAfter advancing the throttle about 1/2 of its travel to commence the takeoff roll, the plt heard a loud explosion & felt a violent shaking of the acft. The eng quit & the acft swerved to the right side of the rwy. Post crash examinationrevealed that one…NTSB SEA82IA170Incident · No injuriesIncident investigationFinal reportCessna 177RG · Cashmere, WAWhile descending through 7500 ft the pilot observed smoke entering the cockpit from the instrument panel area. An attempt was made to isolate the source by shutting off various electrical components. The smoke continued to appear intermittently before the…