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

29 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, 1981, 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\") = 1981
    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 ANC82DAG10Accident · No injuriesClosedBellanca 7GCBC · King Salmon, AKNov 20, 1981 · N53851 · Substantial damageNTSB ANC82DAG02Accident · Minor injuriesClosedPiper PA-18 · Iliamna, AKOct 1, 1981 · N9109D · Substantial damageNTSB ANC81DAG92Accident · Serious injuriesClosedPiper PA-18 · Anchorage, AKSep 27, 1981 · N4359A · Substantial damageNTSB ANC81DAD08Accident · No injuriesClosedPiper PA-23 · Yakutat, AKSep 20, 1981 · N4099P · DestroyedNTSB ANC81DAG86Accident · No injuriesClosedPiper PA-18 · Valdez, AKSep 18, 1981 · N3906Z · Substantial damageNTSB ANC81DAA35Accident · No injuriesClosedPiper PA-18 · Hodzona River, AKSep 14, 1981 · N54247 · Substantial damageNTSB ANC81DAG71Accident · No injuriesClosedPiper PA-28 · Seldovia, AKSep 1, 1981 · N6184W · Substantial damageNTSB ANC81DA106Accident · No injuriesClosedCessna U206F · Cantwell, AKSep 1, 1981 · N35937 · Substantial damageNTSB ANC81DAG89Accident · No injuriesClosedPiper PA-18 · Homer, AKAug 31, 1981 · N7513K · Substantial damageNTSB ANC81DAA31Accident · No injuriesClosedPiper PA-18 · Tin City, AKAug 30, 1981 · N82209 · Substantial damageNTSB ANC81DAG66Accident · Serious injuriesClosedBellanca 7GCAA · Sterling, AKAug 16, 1981 · N57653 · Substantial damageNTSB ANC81DAA25Accident · No injuriesClosedPiper PA-18 · Fairbanks, AKAug 16, 1981 · N5087Y · Substantial damageNTSB ANC81DAA28Accident · No injuriesClosedPiper PA-18 · Fairbanks, AKAug 15, 1981 · N7869D · Substantial damageNTSB ANC81FA094Accident · 1 fatalClosedPiper PA-18 · Port Moller, AKAug 9, 1981 · N9664P · DestroyedNTSB ANC81DAG65Accident · No injuriesClosedPiper PA-18A · Canyon Creek, AKAug 9, 1981 · N6760B · Substantial damageNTSB ANC81FA092Accident · 1 fatalClosedPiper PA-18 · Kokiak, AKAug 4, 1981 · N2532C · Substantial damageNTSB ANC81FA084Accident · 3 fatalClosedPiper PA-18 · Cordova, AKJul 27, 1981 · N5987Z · Substantial damageNTSB ANC81DAG61Accident · No injuriesClosedPiper PA-18 · Kenai, AKJul 24, 1981 · N57617 · Substantial damageNTSB ANC81DAG49Accident · Minor injuriesClosedPiper PA-18 · Crooked Creek, AKJul 8, 1981 · N82076 · Substantial damageNTSB ANC81DAG63Accident · No injuriesClosedPiper PA-18 · Copper Center, AKJun 15, 1981 · N3183Z · Substantial damageNTSB ANC81FAA14Accident · No injuriesClosedPiper PA-22 · Fairbanks, AKMay 15, 1981 · N3100Z · Substantial damageNTSB ANC81DA038Accident · No injuriesClosedPiper PA-28 · Minchumina, AKMar 28, 1981 · N43503 · Substantial damageNTSB ANC81FA033Accident · 2 fatalClosedPiper PA-18A · Fairbanks, AKMar 15, 1981 · N8570D · DestroyedNTSB ANC81DA027Accident · No injuriesClosedCessna 172N · Red Devil, AKMar 9, 1981 · N6378D · Substantial damageNTSB ANC81DAG25Accident · No injuriesClosedPiper PA-28 · Anchorage, AKFeb 14, 1981 · N6184W · Substantial damageNTSB ANC81DAG23Accident · No injuriesClosedPiper PA-18 · Wasilla, AKFeb 3, 1981 · N9264D · Substantial damageNTSB ANC81FAA08Accident · No injuriesClosedPiper PA-18 · Galena, AKJan 28, 1981 · N7167B · Substantial damageNTSB ANC81DAG20Accident · No injuriesClosedPiper PA-18 · Copper Center, AKJan 25, 1981 · N1886P · Substantial damageNTSB ANC81DAG18Accident · No injuriesClosedPiper PA-22 · Kenai, AKJan 2, 1981 · N7300D · Substantial damage