NTSB investigations: Lycoming 0-360-A1D, AK
16 cases on aircraft whose registry engine model is Lycoming 0-360-A1D. 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
| 1980 | 1 |
|---|---|
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2000 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2014 | 1 |
| 2018 | 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.\"eventStateOrRegion\" = 'AK' 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 ('41504'))
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" = 'AK' 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 ('41504'))
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 ANC18FA045Accident · 1 fatalField investigationFinal reportCessna 175 · Anchorage, AKThe failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.NTSB ANC14CA061Accident · No injuriesData collectionFinal reportAviat A 1 · Ketchikan, AKThe pilot's decision to takeoff from a remote mountain lake in variable wind. Contributing to the accident was the pilots delayed decision to abort the takeoff.NTSB ANC11CA054Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Nikiski, AKThe pilot's improper use of brakes during landing.NTSB ANC10TA080Accident · No injuriesFinal reportAviat A-1B · Bettles Field, AKThe pilot's selection of an unsuitable off-airport landing site for a precautionary landing.NTSB ANC10CA066Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to maintain directional control after encountering a crosswind during landing.NTSB ANC09TA092Accident · No injuriesFinal reportAviat A-1B · Gulkana, AKThe pilot's excessive use of brakes during an off-airport landing, resulting in the airplane nosing over.NTSB ANC05LA117Accident · No injuriesLimited investigationFinal reportAviat A-1 · Anchorage, AKThe flight instructor's inadequate supervision of the dual student, and his failure to maintain control of the airplane. A factor associated with the accident was the dual student's excessive application of the brakes.NTSB ANC04LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · McGrath, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor contributing to the accident was the presence of soft tundra.NTSB ANC03LA104Accident · No injuriesLimited investigationFinal reportAviat A-1A · Sitka, AKThe pilot's delay in aborting the takeoff, which resulted in a collision with the shoreline during an aborted takeoff.NTSB ANC02LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Fairbanks, AKThe pilot's failure to maintain clearance from objects while maneuvering. A factor associated with the accident is an undetermined object.NTSB ANC01LA014Accident · No injuriesLimited investigationFinal reportAviat A-1 · Anchorage, AKThe pilot's inadequate compensation for a bounced landing, and failure to maintain directional control of the airplane. A factor in the accident was flat lighting conditions.NTSB ANC00LA129Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Anchorage, AKThe pilot's inadequate compensation for high, gusty wind conditions during water taxi. Factors associated with the accident are high and gusty wind conditions.NTSB ANC95LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKFailure of the pilot to maintain adequate altitude/clearance from terrain, during a low pass over a prospective (off-airport) landing area. Factors relating to the accident were: rain and rising/uneven terrain.NTSB ANC94LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Fort Yukon, AKThe fatigue failure of the right main landing gear spring.NTSB ANC93LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Katmai, AKThe unsuitable terrain selected by the pilot-in-command. Factor was soft terrain condition.NTSB ANC80DAG54Accident · No injuriesClosedBellanca 8GCBC · Kashwitna Riv, AK