NTSB investigations: Lycoming O-320 series, AK
14 cases on aircraft whose registry engine model is Lycoming O-320 series. 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
| 1965 | 1 |
|---|---|
| 1967 | 1 |
| 1969 | 1 |
| 1976 | 1 |
| 1991 | 1 |
| 2014 | 3 |
| 2019 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2025 | 1 |
| 2026 | 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 ('42389'))
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 ('42389'))
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 ANC26LA065Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18-125 · Wasilla, AKNTSB ANC25LA075Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB ANC24LA006Accident · No injuriesClass 4 · LimitedFinal reportCharles J Kase Kase KUB · Big Lake, AKThe pilot’s selection of an unsuitable landing site that was covered in deep snow.NTSB ANC22LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot’s excessive use of brakes which resulted in a nose-over.NTSB ANC22LA043Accident · Minor injuriesClass 4 · LimitedFinal reportPepperd Greg J Caribou Cruiser · Wasilla, AKThe pilot's overapplication of brakes during landing, which resulted in a nose-over.NTSB GAA19CA388Accident · No injuriesData collectionFinal reportPiper PA18 · Talkeetna, AKThe pilot's improper decision to land on rough, grassy terrain, which resulted in a nose-over.NTSB ANC14CA079Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Susitna, AKThe pilot's inadequate compensation for gusting, variable wind conditions during initial climb after takeoff.NTSB ANC14CA063Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilots excessive use of the airplanes brakes during the landing roll, which resulted in a nose over. Contributing to the accident was the flight instructor's inadequate supervision of the training flight.NTSB ANC14CA018Accident · No injuriesData collectionFinal reportPiper PA 18 · Tanana, AKThe passenger inadvertently interfered with the rudder control pedal, which resulted in a loss of directional control during takeoff.NTSB ANC92LA015Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot's loss of control during final approach when his attention was diverted to trying to operate the vernier throttle. Contributing to the accident was the pilot's lack of familiarity with the aircraft and his failure to maintain directional control of…NTSB ANC76DAH24Accident · No injuriesClosedPiper PA-18 · Gulkana, AKNTSB ANC70D0074Accident · No injuriesClosedPiper PA-18 · Fairbanks, AKNTSB ANC68F0088Accident · No injuriesClosedPiper PA-18 · Gulkana, AKNTSB ANC66F0038Accident · No injuriesClosedPiper PA-18 · Mcgrath, AK