NTSB investigations: Lycoming 0-320 series, AK
18 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Hard landing”. 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
| 1984 | 1 |
|---|---|
| 1988 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1999 | 4 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 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.\"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 ('41508')
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\" = 200))
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 ('41508')
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" = 200))
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 ANC06CA065Accident · No injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate compensation for a tailwind during the landing flare, which resulted in an in-flight collision with snow-covered terrain during an aborted landing. Factors contributing to the accident were a tailwind and rising terrain.NTSB ANC05CA140Accident · No injuriesData collectionFinal reportPiper PA-18 · Nenana, AKThe pilot's improper recovery from a bounced landing during the landing roll, which resulted in a loss of control and a nose over.NTSB ANC05LA001Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe inadequate and unapproved design of the main landing gear assembly by the manufacturer, which resulted in a failure of the main landing gear during landing, and structural damage to the airplane. A factor in the accident was the pilot's misjudged flare.NTSB ANC02LA124Accident · No injuriesLimited investigationFinal reportWilliamson GlaStar · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors in the accident were the pilot's inadequate compensation for the crosswind condition, and the misjudged landing flare.NTSB ANC01LA069Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot's inadequate bounced landing recovery, and his failure to correct for torque/P-factor during an aborted landing.NTSB ANC99LA148Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Sleetmute, AKThe pilot's selection of an unsuitable landing area. A factor in this accident was the rough and uneven gravel bar.NTSB ANC99LA135Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Fairbanks, AKThe pilot's inadvertent stall during the landing flare.NTSB ANC99LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's failure to compensate for the wind conditions and maintain a proper rate of descent during the approach for landing, which resulted in a hard landing, and the subsequent collapse of the right main landing gear strut.NTSB ANC99LA035Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Healy, AKThe pilot's inadequate recovery from a bounced landing. A factor associated with the accident was a snowbank.NTSB ANC96LA057Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe pilot's inadequate compensation for the wind conditions. A factor in the accident was the gusty wind conditions.NTSB ANC95LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aniak, AKThe pilot's misjudged landing flare, which resulted in a hard landing and overload failure of the main landing gear.NTSB ANC95LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Manley Hot Spri, AKThe pilot's failure to correctly compensate for the existing wind conditions. The gusting wind condition was a factor.NTSB ANC94LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nondalton, AKThe pilot's improper flare during the landing touchdown. The pilot's lack of familiarity with the aircraft make and model was a factor in the accident.NTSB ANC94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Aniak, AKThe pilot-in-command's failure to compensate for the wind conditions. The gusty wind was a factor.NTSB ANC91LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Dry Bay, AKThe pilot failed to maintain adequate airspeed and stalled the airplane. Contributing to the accident was the unsuitable terrain on which the pilot chose to land.NTSB ANC91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKThe pilot's failure to maintain adequate airspeed, resulting in a stall, hard landing and collapse of the main landing gear.NTSB ANC88LA102Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Valdez, AKThe private pilot was attempting to land at a remote beach site to join a pilot friend who had landed there earlier in his own airplane. The pilot on the beach had placed a sleeping bag and other items in a hole on the beach to mark it as a landing hazard.…NTSB ANC85LA022Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Anchorage, AKAccording to the plt, he was making an approach over trees that were ten ft high. After passing the trees he 'chopped' the power & the acft landed hard. He noticed the fuselage was buckled just forward of the vertical fin when he exited the acft.