OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, 2004

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\") = 2004
    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 DEN05TA033Accident · No injuriesFinal reportPiper PA-18-150 · Jal, NMthe pilot's failure to maintain clearance from the power lines. Contributing factors include the power lines, the sun glare, the pilot's reduced visual lookout, the pilot’s improper in-flight planning and decision making and the pilot's failure to perform a…Dec 1, 2004 · N734 · Substantial damageNTSB SEA05FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Grand Ronde, ORThe pilot's failure to maintain clearance from high terrain while maneuvering. A factor contributing to the accident was the high terrain.Oct 15, 2004 · N454FL · DestroyedNTSB ATL04LA195Accident · 2 fatalLimited investigationFinal reportCessna 172L · Gadsden, ALThe flight instructors failure to maintain clearance and his inadequate visual lookout while flying low over a river resulting in an in-flight collision with a wire.Sep 29, 2004 · N4336Q · DestroyedNTSB DEN04LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Spanish Fork, UTthe pilot's improper inflight planning and decision making, and his failure to maintain terrain clearance. Contributing factors were his intentional low altitude flight and maneuvering, the aircraft's climb performance being exceeded, and the trees.Aug 13, 2004 · N6249K · DestroyedNTSB SEA04FA143Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Cle Elum, WAThe pilot's failure to obtain and maintain a safe rate of climb after takeoff, due to his failure to perform pre-takeoff weight/balance and takeoff/climb performance calculations. Factors include a high density altitude environment, and trees off the…Jul 25, 2004 · N1912H · Substantial damageNTSB ATL04LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Cumming, GAThe pilot's failure to obtain takeoff performance data, and his intentional takeoff from a closed and short runway which resulted in an in-flight collision with a tree.Jul 10, 2004 · N56776 · Substantial damageNTSB SEA04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Trego, MTFailure to maintain clearance from trees during the initial climb.Jun 8, 2004 · N7094D · DestroyedNTSB SEA04LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Columbus, MTThe pilot's failure to maintain directional control of the aircraft during the landing and subsequent go-around. Inadequate compensation for the gusting winds and an airport hangar were factors.Jun 5, 2004 · N82172 · Substantial damageNTSB NYC04CA129Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 · Greene, RIThe pilots improper decision to depart with the flaps set to 10 degrees, and his failure to obtain proper airspeed, which resulted in a collision with trees.May 23, 2004 · N7132L · Substantial damageNTSB ATL04FA099Accident · 3 fatalField investigationFinal reportCessna 172N · Moselle, MSThe pilot's failure to maintain clearance and his inadequate visual look-out while maneuvering resulting in an in-flight collision with a radio tower.Apr 24, 2004 · N75812 · Substantial damageNTSB ATL04CA089Accident · No injuriesData collectionFinal reportCessna 172N · Statesboro, GAThe pilot's failure to establish a positive climb and his failure to maintain clearance during a go-around, which resulted in an in-flight collision with trees. A factor was the gusting winds.Apr 3, 2004 · N4874G · Substantial damageNTSB NYC04LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Turner, METhe pilot's misjudgment of speed/distance and the delayed aborted landing. A factor in this accident was the tail wind condition.Mar 14, 2004 · N7872G · Substantial damageNTSB SEA04LA048Accident · No injuriesLimited investigationFinal reportCessna 172N · Gig Harbor, WAThe pilot's failure to follow the published IFR procedure resulting in failure to maintain clearance from objects during an instrument approach. Trees and an inoperative glide slope receiver were factors.Mar 3, 2004 · N75844 · Substantial damageNTSB FTW04LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Angleton, TXThe unqualified person's failure to maintain clearance with the power lines. A contributing factor was the night light conditions.Feb 29, 2004 · N79502 · DestroyedNTSB NYC04CA076Accident · No injuriesData collectionFinal reportCessna 172N · Youngstown, OHAn inadvertent collision with a deer while landing.Feb 23, 2004 · N738EK · Substantial damage