NTSB investigations: Lycoming 0-320 series, 2012, AK

26 cases on aircraft whose registry engine model is Lycoming 0-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

19642026
NTSB investigations: Lycoming 0-320 series, 2012, AK per year, 1964–2026: 1,542 cases
196414
196512
196612
196726
196823
196918
197024
197115
197222
197327
197427
197522
197650
197736
197833
197939
198039
198129
198223
198327
198429
198537
198641
198733
198830
198934
199032
199132
199232
199332
199421
199531
199629
199723
199829
199930
200029
200115
200222
200327
200424
200523
200621
200719
200822
200919
201025
201125
201226
201312
201412
201519
201617
201713
201821
201917
202018
202123
202219
202315
202419
202514
202613

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 year(c.\"eventDate\") = 2012
    AND 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'))
  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.

NTSB ANC13FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-18-150 · Kenai, AKUndetermined. The airplane and pilot were not found.Oct 13, 2012 · N444LZ · DestroyedNTSB ANC12CA110Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot's loss of directional control during takeoff in gusting wind conditions from an off-airport site, which resulted in a collision with terrain and a nose over.Sep 21, 2012 · N3802Z · Substantial damageNTSB ANC12LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Talkeetna, AKThe flight instructor's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an inadvertent stall.Sep 17, 2012 · N8433D · Substantial damageNTSB ANC12CA108Accident · No injuriesData collectionFinal reportCessna 172K · Atqasuk, AKThe student pilot's failure to maintain directional control while performing a high-speed taxi in windy conditions.Sep 15, 2012 · N84549 · Substantial damageNTSB ANC12LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Homer, AKThe total loss of engine power for reasons that could not be determined because the engine could not be examined because of the extent of time in salt water.Sep 8, 2012 · N3214D · Substantial damageNTSB ANC12CA101Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Ekwok, AKThe pilot's diverted attention during the initial climb, which resulted in a collision with trees.Sep 5, 2012 · N4127Z · Substantial damageNTSB ANC12LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Coldfoot, AKThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course.Sep 2, 2012 · N82016 · Substantial damageNTSB ANC12FA095Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Homer, AKThe pilot's failure to see and avoid high tension power lines.Aug 31, 2012 · N57511 · Substantial damageNTSB ANC12CA109Accident · No injuriesData collectionFinal reportPiper PA-18 · Healy, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in an aborted takeoff and collision with terrain.Aug 31, 2012 · N1620A · Substantial damageNTSB ANC12CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Aniak, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.Aug 31, 2012 · N3615M · Substantial damageNTSB ANC12CA088Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot's loss of control during the landing roll in gusting wind conditions, which resulted in the airplane nosing over.Aug 15, 2012 · N4001Z · Substantial damageNTSB ANC12CA078Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Talkeetna, AKThe flight instructor's and student pilot's excessive application of brakes during an aborted takeoff, which resulted in a noseover.Jul 20, 2012 · N53977 · Substantial damageNTSB ANC12CA076Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Whittier, AKThe pilot's failure to maintain clearance from brush during landing, which resulted in a loss of control.Jul 18, 2012 · N3764Z · Substantial damageNTSB ANC12CA074Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tynoek, AKThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.Jul 11, 2012 · N4272Z · Substantial damageNTSB ANC12CA071Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's excessive use of brakes during landing, which resulted in a noseover.Jul 6, 2012 · N90974 · Substantial damageNTSB ANC12CA069Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's selection of an unsuitable off-airport landing site, which resulted in a loss of control during the landing roll.Jul 6, 2012 · N623JE · Substantial damageNTSB ANC12CA065Accident · No injuriesData collectionFinal reportPiper PA-22-160 · McGrath, AKThe pilot’s decision to load the airplane in excess of its takeoff capability given the runway conditions, which resulting in a collision with terrain during the initial climb.Jul 3, 2012 · N8635D · Substantial damageNTSB ANC12CA057Accident · No injuriesData collectionFinal reportChampion 7GCB · Tyonek, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering.Jun 23, 2012 · N466RV · Substantial damageNTSB ANC12CA053Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot’s selection of unsuitable terrain for taxi.Jun 17, 2012 · N9488D · Substantial damageNTSB ANC12CA039Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing, which resulted in a ground loop. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.May 14, 2012 · N7257D · Substantial damageNTSB ANC12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Gakona, AKThe pilot’s decision to take off in variable wind conditions, which resulted in a loss of control and the airplane striking an object after takeoff.May 10, 2012 · N999JV · Substantial damageNTSB ANC12CA034Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe student pilot did not maintain sufficient airspeed during a steep turn after takeoff, which resulted in an aerodynamic stall.Apr 30, 2012 · N8976D · Substantial damageNTSB ANC12TA035Accident · No injuriesFinal reportPiper PA-18-150 · Paxon, AKA separation of the right main landing gear suspension strut assembly due to overstress, which resulted in the collapse of the main landing gear while landing.Apr 28, 2012 · N7059 · Substantial damageNTSB ANC12CA030Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fairbanks, AKThe pilot’s loss of directional control during landing. Contributing to the accident was the pilot's decision not to initiate a go-around.Apr 15, 2012 · N7227D · Substantial damageNTSB ANC12FA028Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sleetmute, AKOperation of the airplane by a non-certificated pilot and his failure to maintain adequate airspeed and airplane control, which resulted in an aerodynamic stall.Mar 31, 2012 · N7276D · Substantial damageNTSB ANC12CA022Accident · No injuriesData collectionFinal reportCessna 172I · McCarthy, AKThe pilot lost directional control during landing.Feb 10, 2012 · N46279 · Substantial damage