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

14 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, FL per year, 1964–2026: 824 cases
19647
19658
196617
196716
196816
196911
197015
197118
197213
19739
197415
197516
197611
197718
197816
197919
198021
198120
198217
198310
198415
198515
198615
198711
198811
198911
199010
199111
199216
199310
199413
199510
199611
199714
199812
199913
200018
200115
200212
200315
200419
200514
200613
20076
200816
200914
20106
201113
20129
201310
201411
201511
201613
20179
201819
201916
202010
202113
202211
20239
202410
202510
202611

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\" = 'FL' 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 MIA98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Clarksville, FLthe pilot's improper flare and touchdown.Nov 3, 1997 · N4502X · Substantial damageNTSB MIA98LA012Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Pompano Beach, FLThe improper use of collective control by the dual student which prevented the flight instructor from stopping an uncontrolled roll to the left.Oct 17, 1997 · N333PH · Substantial damageNTSB ATL97LA144Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Belleview, FLthe pilot's improper in-flight planning/decision, and his delay in initiating a go-around, which resulted in a hard touchdown, loss of directional control, and collision with objects (fence and trees).Sep 28, 1997 · N3402Z · Substantial damageNTSB ATL97LA105Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeland, FLthe student pilot's inadequate compensation for wind conditions and failure to maintain proper runway alignment during the landing, which resulted in a collision with a runway marker. The rear-quartering tailwind (crosswind) and gusts were related factors.Jul 15, 1997 · N737EV · Substantial damageNTSB MIA97LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sanford, FLFailure of the oil cooler radiator hose which resulted in oil exhaustion and subsequent engine failure. Contributing to the accident was the failure of the FAA to require a recurrent detailed examination and or require those hoses be life limited to prevent…Jun 26, 1997 · N859KW · Substantial damageNTSB MIA97LA183Accident · No injuriesLimited investigationFinal reportBeech B19 · New Smyrna Bch, FLthe private pilot's improper flare, which resulted in a hard landing and subsequent collapse of the left main landing gear and the nose gear.Jun 15, 1997 · N59BW · Substantial damageNTSB ATL97LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Daytona Beach, FLfailure of the pilot of N7617F to comply with an ATC instruction to hold short of a taxiway, and failure of the pilots in both airplanes to see-and-avoid each other's airplane.Jun 11, 1997 · N7617F · 2 aircraft · Substantial damageNTSB MIA97LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · Vero Beach, FLfailure of the pilot to ensure all articles in the aircraft were secured before flight, and subsequently, an oil can becoming lodged under the rudder pedals and preventing her from controlling the aircraft during landing.May 14, 1997 · N9504H · Substantial damageNTSB MIA97LA150Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Key Largo, FLthe pilot's failure to maintain directional control during a crosswind landing, which resulted in an inadvertent ground swerve and collision with bushes and terrain.Apr 27, 1997 · N4141M · Substantial damageNTSB MIA97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Tampa, FLthe pilot's improper compensation for wind conditions and failure to properly flare the airplane for landing. Factors relating to the accident were: the gusty/quartering wind conditions, and the pilot's improper use of flaps for landing.Apr 5, 1997 · N1385U · Substantial damageNTSB MIA97LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Pompano Beach, FLthe pilot's improper flare and improper recovery from a bounced landing, which resulted in overload failure of the nose gear.Mar 27, 1997 · N5123H · Substantial damageNTSB MIA97LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLthe pilot's excessive taxispeed.Mar 4, 1997 · N4345C · Substantial damageNTSB ATL97LA038Accident · No injuriesLimited investigationFinal reportBeech 23 · Palatka, FLfailure of the nose gear for undetermined reason(s).Feb 3, 1997 · N2379L · Substantial damageNTSB MIA97LA071Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Daytona Beach, FLthe student pilot's failure to maintain direction control of the airplane during takeoff. The crosswind was a factor.Jan 22, 1997 · N121ER · Substantial damage