OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, ID

13 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - on ground/water”. 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 c.\"eventStateOrRegion\" = 'ID' 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')
      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\" = 260))
  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 SEA07CA034Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors include icy runway conditions and a snow berm adjacent to the runway.Dec 17, 2006 · N19698 · Substantial damageNTSB SEA05CA043Accident · No injuriesData collectionFinal reportCessna 172N · Idaho Falls, IDThe student pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight. A contributing factor was the deep snow beside the runway.Feb 3, 2005 · N5204K · Substantial damageNTSB SEA01LA151Accident · No injuriesLimited investigationFinal reportPitts Special SC-1 · Jerome, IDThe pilot's failure to maintain directional control during landing. Factors included: an incorrectly manufactured or adjusted rudder travel setting, resulting in restricted movement of the left brake; the mechanic's failure to adjust the rudder travel to the…Aug 15, 2001 · N8351 · Substantial damageNTSB SEA99LA132Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Creek, IDThe pilot-in-command's improper remedial action (continued takeoff). Contributing factors were the tree and control interference (inadvertent brake activation) by the passenger..Jul 31, 1999 · N6741L · Substantial damageNTSB SEA96LA055Accident · No injuriesLimited investigationFinal reportCessna 172P · Salmon, IDfailure of the pilot to maintain directional control during the landing, which resulted in a ground swerve. A factor relating to the accident was: the rock pile to the left of the runway.Feb 15, 1996 · N96879 · Substantial damageNTSB SEA95LA149Accident · No injuriesLimited investigationFinal reportEdwin J. Estenson RV-4 · Elk River, IDThe pilot failed to maintain directional control. The tall vegetation was a factor.Jul 15, 1995 · N90EE · Substantial damageNTSB SEA94LA215Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hailey, IDThe pilot's inadequate compensation for wind conditions. A factor to the accident was a tailwind.Aug 18, 1994 · N7789P · Substantial damageNTSB SEA94LA139Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Melba, IDThe pilot's inadequate remedial action, and his excessive brake application. Factors include improper recovery from a bounced landing, and a crosswind.Jun 3, 1994 · N2926Z · Substantial damageNTSB SEA90LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Lewiston, IDThe failure of a nose landing gear fork, which resulted in the pilot's loss of directional control, and a nose-over after an excursion from the runway.Sep 9, 1990 · N9895V · Substantial damageNTSB SEA88LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172M · St. Anthony, IDDuring landing onto the 50 foot wide snow covered runway, directional control was lost with the aircraft drifting to the left of the runway, striking a snow berm, and then nosing over inverted.Jan 27, 1988 · N2320E · Substantial damageNTSB SEA86LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Twin Falls, IDWhile landing for the fifth and final touch and go, the pilot touched down at about midfield, due to too high of an approach. Rather than go-around, the pilot selected heavy braking. The aircraft then veered to the right, struck a mound of dirt sheering off…Apr 28, 1986 · N3580Q · Substantial damageNTSB SEA86LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · American Falls, IDThe student pilot was attempting to make a touch and go, when the aircraft veered to the left of the runway and struck an embankment. The student failed to use enough right rudder to maintain directional control. The runway's width is 50 feet.Mar 3, 1986 · N6486J · Substantial damageNTSB SEA82DA051Accident · Minor injuriesFinal reportCessna 172N · Pocatello, IDThe pilot stated that the aircraft encountered a gust of wind shortly after commencing takeoff roll which moved it directly across the runway. Initially the pilot maintained full power while attempting to regain control of the aircraft however shortly…Apr 11, 1982 · N1075F · Destroyed