NTSB investigations: Lycoming 0-320 series, AK
13 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Overrun”. 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 |
|---|---|
| 1984 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 2001 | 2 |
| 2002 | 2 |
| 2005 | 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\" = 340))
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" = 340))
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 ANC05CA147Accident · No injuriesData collectionFinal reportCessna 172 · Anchorage, AKThe pilot's misjudgment of distance/speed during landing, which resulted in an overrun, a loss of directional control, and a nose over during the landing roll.NTSB ANC02LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to attain the proper touchdown point on a remote airstrip, and his failure to perform a go-around that resulted in the airplane overrunning the end of the strip. Factors in the accident were the pilot's inadequate evaluation of a tailwind…NTSB ANC02LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Sparrevohn, AKThe pilot's inadequate evaluation of wind conditions while landing, which resulted in a downwind landing and an encounter with rough terrain when the airplane overran the intended landing area. Factors associated with the accident were a tailwind, and rough…NTSB ANC01LA133Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tok, AKThe pilot's failure to abort the landing. Factors associated with the accident were the pilot's selection of an unsuitable landing area, and his failure to attain a proper touchdown point. An additional factor was a ditch.NTSB ANC01LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Wasilla, AKThe pilot's delay in aborting the takeoff roll.NTSB ANC93LA142Accident · No injuriesLimited investigationFinal reportCessna 172 · Black Rapids, AKThe pilot's improper in-flight planning/decision, and his delay in taking remedial action. Factor was the rough, uneven terrain.NTSB ANC93LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Kasigluk, AKThe pilot's improper planning/decision and delay in aborting the takeoff. Factors related to the accident were: loose gravel on the surface of the runway and the snowbank (berm) on the overrun (stopway).NTSB ANC92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Pole, AKPilot's decision to attempt takeoff without removing snow from aircraft surfaces. Factor related to the accident was the snow contaminated wing and other flight surfaces.NTSB ANC90LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's failure to adequately remove snow from the airplane and his delay in aborting the takeoff.NTSB ANC89LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kiana Creek, AKImproper planning/decision by the pilot, and the premature lift-off. Factors related to the accident were: the unfavorable wind condition and the pilot's self-induced pressure.NTSB ANC88LA082Accident · No injuriesLimited investigationFinal reportCessna 172 · Healy, AKThe commercial pilot/flight instructor was attempting to land at a private turf airstrip when she reportedly encountered the outflow from a thunderstorm located about one mile away. She elected to continue with the landing and touched down with a greater than…NTSB ANC84LA195Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tikchik Lodge, AKThe plt attempted a takeoff from a 500 ft sand bar and during the takeoff roll the main landing gear struck soft spots. Realizing the acft was not going to become airborne he closed the throttle attempting to stop in the remaining distance. The acft left the…NTSB ANC83LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Mckinley Park, AKThe plt stated that he was unable to locate the windsock. While on final for rwy 16 'things' did not feel right, but he continued into a long, fast tailwind landing. As he neared the end of the rwy he deliberately groundlooped the acft to avoid going over a…