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

15 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, 2001, 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\") = 2001
    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 ANC01LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Skwentna, AKA loss of engine power due to an undetermined reason.Sep 26, 2001 · N8127D · Substantial damageNTSB ANC01LA144Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Mentasta, AKThe pilot's inadequate compensation for wind conditions while landing. Factors associated with the accident were the pilot's inadequate recovery from a bounced landing, and a variable wind.Sep 22, 2001 · N8943 · Substantial damageNTSB ANC01LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe pilot's inadequate evaluation of the wind conditions. A factor in the accident was the presence of a tailwind.Sep 20, 2001 · N7477L · Substantial damageNTSB 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.Sep 4, 2001 · N5129Y · Substantial damageNTSB ANC01LA125Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Sparrevohn, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were rough/uneven terrain, and an overload failure of the main landing gear landing strut.Aug 22, 2001 · N6949B · Substantial damageNTSB ANC01LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Anchorage, AKThe pilot's inadvertent ground loop during the landing roll.Aug 16, 2001 · N3685Z · Substantial damageNTSB ANC01LA112Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Wrangell, AKThe pilot's inadequate evaluation of the weather conditions during a downwind landing at a remote lake. Factors in the accident were a downdraft, rough/uneven terrain, and the pilot's inadequate in-flight planning/decision(s).Aug 11, 2001 · N61AT · Substantial damageNTSB ANC01LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anaktuvuk Pass, AKA failure of the landing gear strut assembly due to corrosion. A factor in the accident was the pilot's inadequate maintenance of the airplane.Aug 6, 2001 · N4167Z · Substantial damageNTSB ANC01LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Wasilla, AKThe pilot's delay in aborting the takeoff roll.Jul 15, 2001 · N78254 · Substantial damageNTSB ANC01LA072Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Petersburg, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was soft terrain.Jun 24, 2001 · N61AT · Substantial damageNTSB ANC01LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Haines, AKThe pilot's selection of unsuitable terrain for takeoff. Factors in the accident were soft terrain, and the pilot's delay in aborting the takeoff.Jun 23, 2001 · N9581W · Substantial damageNTSB 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.Jun 16, 2001 · N9704D · Substantial damageNTSB ANC01LA064Accident · No injuriesLimited investigationFinal reportCessna 172P · Anchorage, AKThe pilot's selection of an unsuitable taxi area during taxi. A factor associated with the accident was a tree.May 21, 2001 · N98426 · Substantial damageNTSB ANC01LA037Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Fairbanks, AKThe flight instructor's inadequate supervision of the flight during the landing flare. A factor in the accident was the student's abrupt airplane control.Feb 16, 2001 · N36266 · Substantial damageNTSB ANC01LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Atmautluak, AKThe pilot's failure to maintain a proper glidepath during final approach. A factor associated with the accident was soft terrain.Jan 3, 2001 · N19771 · Substantial damage