NTSB investigations: Lycoming 0-320 series, 2006, AZ

11 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, 2006, AZ per year, 1964–2026: 383 cases
19647
19656
19666
19675
19687
19693
19707
197111
19723
19736
19744
19757
19769
19775
197814
19799
19809
198110
198214
19832
19842
19857
19867
19872
19882
19899
19906
19918
19924
19933
19946
19955
19964
199710
19988
19995
20006
20017
200213
20036
20046
20059
200611
200710
20087
20096
20104
20113
201210
20135
20147
20151
20161
20173
20184
20194
20204
20216
20225
20234
20244
20251
20264

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\") = 2006
    AND c.\"eventStateOrRegion\" = 'AZ' 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 LAX07CA038Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Grand Canyon, AZThe pilot's inadequate compensation for the crosswind condition during the landinf roll which resulted in a loss of control and an on ground collision with a berm.and failure to maintain directional control.Nov 19, 2006 · N8477F · Substantial damageNTSB LAX07LA025Accident · 2 fatalLimited investigationFinal reportOlson Vans RV-6 · Rio Verde, AZThe pilot's failure to maintain clearance from power lines while intentionally flying at a low altitude.Nov 2, 2006 · N606RV · Substantial damageNTSB LAX07LA011Accident · Minor injuriesLimited investigationFinal reportMorrisey 2150A · Chandler, AZLoss of engine power during cruise flight due to a crack in the oil cooler and subsequent loss of engine oil.Oct 18, 2006 · N5114V · Substantial damageNTSB LAX07CA007Accident · No injuriesData collectionFinal reportCessna 172P · Glendale, AZthe student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.Oct 6, 2006 · N97811 · Substantial damageNTSB LAX06LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Eagar, AZthe flight instructor's failure to attain and maintain the proper climb airspeed, which resulted in a stall/mush.May 26, 2006 · N6309W · Substantial damageNTSB LAX06CA162Accident · No injuriesData collectionFinal reportBeech BE23 · Kingman, AZthe student pilot's failure to attain/maintain a proper glide path, which resulted in an encounter with wake turbulence and subsequent hard landing.May 5, 2006 · N8750M · Substantial damageNTSB LAX06CA144Accident · No injuriesData collectionFinal reportAviat A-1B · Chandler, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout. A contributing factor was the pilot's excessive use of the flight controls.Apr 22, 2006 · N143HP · Substantial damageNTSB ANC06CA034Accident · No injuriesData collectionFinal reportPiper PA-22 · Grand Canyon, AZThe pilot's improper recovery from a bounced landing during touchdown, which resulted in a loss of control and encounter with terrain. Factors associated with the accident are the pilot's misjudged flare, and a gusty wind.Mar 26, 2006 · N6123D · Substantial damageNTSB LAX06CA122Accident · No injuriesData collectionFinal reportCessna 172P · Sedona, AZThe pilot's failure to maintain an adequate clearance from obstructions and diverted attention while taxiing.Feb 25, 2006 · N64423 · Substantial damageNTSB LAX06CA117Accident · No injuriesData collectionFinal reportCessna 172M · Prescott, AZthe pilot's inadequate compensation for the crosswind conditions and his failure to maintain directional control.Feb 17, 2006 · N13514 · Substantial damageNTSB LAX06CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Maricopa, AZThe pilot's failure to maintain directional control during landing rollout. A factor was the soft dirt adjacent to the runway.Jan 29, 2006 · N62712 · Substantial damage