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

10 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, 1997, 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\") = 1997
    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 LAX98LA002Accident · No injuriesLimited investigationFinal reportBlackwell Midget Mustang · Glendale, AZThe pilot's inability to maintain directional control of the aircraft due to the deflation of the right main gear tire. Factors in this accident were the soft sand on the side of the runway and the left crosswind.Oct 2, 1997 · N32JB · Substantial damageNTSB LAX97LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZthe student pilot's failure to maintain directional control of the airplane and proper alignment with the runway during landing.Sep 13, 1997 · N56474 · Substantial damageNTSB LAX97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZThe student's failure to maintain directional control due to excessive use of the rudder, and the instructor's delayed remedial action.Aug 18, 1997 · N57528 · Substantial damageNTSB LAX97LA284Accident · No injuriesLimited investigationFinal reportCessna 152 · San Manuel, AZThe student pilot's improper recovery from a bounced landing, and failure to maintain directional control of the aircraft. A factor related to the accident was the pilot's fatigue from improper rest the evening before the flight.Aug 12, 1997 · N757CS · Substantial damageNTSB LAX97LA271Accident · No injuriesLimited investigationFinal reportMiller S-1 · Cottonwood, AZThe inadequate strength and braking capability of the landing gear and wheel brakes, and the builder's attempt to adapt motorcycle parts to an aircraft application. A factor in this accident was the pilot's lack of familiarity with this experimental aircraft.Aug 4, 1997 · N22RM · Substantial damageNTSB LAX97LA260Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Chandler, AZThe CFI's failure to recognize and correct for a vortex ring state, and his improper use of the flight controls, which resulted in the loss of control and uncontrolled descent.Jul 25, 1997 · N4008D · DestroyedNTSB LAX97LA229Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Page, AZThe pilot's inadequate compensation for crosswind gusts and his failure to maintain directional control.Jul 1, 1997 · N7764D · Substantial damageNTSB LAX97LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZthe pilot's encounter with crosswind gusts beyond the performance capability of the aircraft. A lack of crosswind limit information published in the Cessna 172N Pilot's Operating Handbook for landing and taxiing operations is a factor in the accident.Apr 24, 1997 · N733PM · Substantial damageNTSB LAX97LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZthe student pilot's inadequate compensation for the crosswind condition, and his failure to maintain proper runway alignment.Apr 9, 1997 · N8123E · Substantial damageNTSB LAX97LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZfailure of the student pilot to maintain directional control of the aircraft, and the flight instructor's inadequate supervision of the flight. The student's diverted attention was a related factor.Jan 15, 1997 · N4101E · Substantial damage