OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, 1997

15 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with object”. 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

19822026

Where

Open the map

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
  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 FTW98LA075Accident · 1 fatalLimited investigationFinal reportCessna 172M · Monticello, UTThe pilot's failure to maintain adequate altitude and clearance from obstacles. Also causal was the pilot becoming lost and disoriented. Contributing factors were his lack of familiarity with the geographical area, lack of experience, night conditions, and…Dec 24, 1997 · N1596V · Substantial damageNTSB CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.Dec 13, 1997 · N5454S · DestroyedNTSB IAD97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Zanesville, OHThe pilot's failure to perform the published short/soft field takeoff procedures.Sep 27, 1997 · N6308W · DestroyedNTSB FTW97FA345Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Ethel, LAThe pilot's failure to maintain clearance. Related factors were the pilot's impairment due to alcohol and night conditions.Sep 13, 1997 · N14255 · Substantial damageNTSB SEA97LA208Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTthe pilot passenger failed to maintain clearance from the power line.Sep 9, 1997 · N5500L · Substantial damageNTSB CHI97LA227Accident · Minor injuriesLimited investigationFinal reportKearns RV-6 · Harrisburg, ILThe pilot's failure to maintain adequate clearance. A factor was the marked transmission wire.Jul 27, 1997 · N35K · Substantial damageNTSB SEA97LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Donnelly, IDThe pilot's failure to perform proper preflight planning for the flight, and his failure to obtain/maintain clearance from trees during takeoff. Factors contributing to the accident include the pilot's delayed remedial action, his improper use of flaps, and…Jul 20, 1997 · N1418U · Substantial damageNTSB MIA97LA199Accident · No injuriesLimited investigationFinal reportSloan RV-6 · Muscle Shoals, ALthe pilot's failure to see-and-avoid the bales of hay duirng the takeoff roll, which resulted in an in-flight collision with a bale at liftoff and subsequent in-flight collision with terrain.Jun 28, 1997 · N626BA · Substantial damageNTSB NYC97LA117Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Harrisonburg, VAthe pilot's failure to obtain the proper touchdown point. A contributing factor was the transmission line.Jun 15, 1997 · N2537Z · Substantial damageNTSB CHI97LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Arcadia, INimproper planning/decision by the pilot. Factors related to the accident were: the pilot's selection of the wrong runway for takeoff, and the resultant tailwind.May 24, 1997 · N5892W · DestroyedNTSB CHI97LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Flushing, MIthe pilot's misjudgment of distance and speed on final approach, his failure to attain the proper touchdown point for landing, and his delay in initiating a go-around (aborted landing). Factors related to the accident were: darkness, and the proximity of…May 18, 1997 · N625EE · Substantial damageNTSB SEA97LA059Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Madras, ORThe pilot's inadvertent visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors include the pilot's improper decision to fly under a low ceiling while in mountainous/hilly terrain, and his encounter with fog and low clouds…Feb 7, 1997 · N5618J · Substantial damageNTSB IAD97LA046Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHthe pilot's failure to maintain proper altitude during the approach at night. Related factors were: darkness, and the pilot's lack of night flying experience.Feb 4, 1997 · N62332 · Substantial damageNTSB ATL97LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · Wiggins, MSthe student pilot misjudged rotor blade clearance from a utility pole, which resulted in a collision. The proximity of the pole was a related factor.Jan 31, 1997 · N8319T · Substantial damageNTSB FTW97LA085Accident · No injuriesLimited investigationFinal reportCessna 172N · Steamboat Spgs, COFailure of the flight instructor and the dual student to maintain an adequate visual lookout. Factors were the flight instructor's inadequate supervision of the flight, inadequate altitude in which to clear obstacles, and the dual student's lack of…Jan 17, 1997 · N739QE · Destroyed