OpenAirDocs.org

NTSB investigations: Lycoming 0-320 series, WA

14 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Hard landing”. 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\" = 'WA' 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\" = 200))
  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 SEA02LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Spokane, WAThe flight instructor's delay of the remedial action necessary to correct for the student pilot's error during the landing flare. Factors include the student pilot's misjudgment of the aircraft's height above the runway when he initiated the flare.Sep 28, 2002 · N132ND · Substantial damageNTSB SEA00LA041Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe pilot's improper decision to attempt a go-around, then attempt to stop on the wet grass. Factors include variable winds, the pilot's inadequate compensation for the winds conditions, his inadequate recovery from a bounced landing, wet grass along the side…Jan 31, 2000 · N3433T · DestroyedNTSB SEA99LA084Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Easton, WAThe flight instructor's delayed remedial action. Factors include the student allowing the aircraft to climb too steeply at too low an airspeed, and the soft/rough terrain on which the aborted takeoff took place.Jun 14, 1999 · N62800 · Substantial damageNTSB SEA96LA077Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAthe pilot's misjudgment of the aircraft's altitude above the runway and failure to flare for landing. Darkness (bright night) was a related factor.Apr 4, 1996 · N51380 · Substantial damageNTSB SEA94LA184Accident · No injuriesLimited investigationFinal reportBlack RV-4 · Twisp, WAProper descent rate was not maintained during approach.Jul 17, 1994 · N144US · Substantial damageNTSB SEA94LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Seattle, WAThe student's improper flare for landing and the instructor's delayed remedial action.Mar 11, 1994 · N52807 · Substantial damageNTSB SEA92LA107Accident · Serious injuriesLimited investigationFinal reportDonald E. Crocker RV-6 · Vancouver, WAAn improper recovery from a bounced landing which resulted in an aerodynamics stall.May 23, 1992 · N116DC · Substantial damageNTSB SEA91LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAA hard landing due to the pilot's midjudgement of his touchdown.Mar 9, 1991 · N64599 · Substantial damageNTSB SEA89LA145Accident · No injuriesLimited investigationFinal reportCessna 177 · Fall City, WAThe pilot misjudged his landing flare and then did not properly recover from the resulting bounce.Jul 31, 1989 · N3448T · Substantial damageNTSB SEA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Renton, WAThe student pilot was returning from a long solo cross country. The runway was undergoing construction. 2,300 feet remained for landing. Landing needed to be accomplished over barriers. The student pilot had approach flaps set. The tower asked the pilot to…Sep 29, 1988 · N5896W · Substantial damageNTSB SEA87LA175Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Tukwila, WAWhile attempting to land in a field and at about 3 feet AGL, the pilot attempted to secure the right cabin door. Due to the distraction the pilot allowed the rear skids to contact the ground and a hard landing resulted.Aug 23, 1987 · N8379Z · Substantial damageNTSB SEA85LA129Accident · No injuriesLimited investigationFinal reportRobinson R22 · Port Orchard, WAThe instructor plt (CFI) with only 358 hrs total flt time was demonstrating an autorotation with a power recovery. During the recovery, the CFI failed to fully regain RPM & the helicopter settled to the surface. With a low rotor RPM, there was a loss of tail…Jun 9, 1985 · N8490D · Substantial damageNTSB SEA85LA075Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bremerton, WAThe acft bounced during landing and adequate recovery was not made. The acft came to rest inverted.Mar 15, 1985 · N5033W · Substantial damageNTSB SEA82DA031Accident · No injuriesFinal reportCessna 172N · Redmond, WAThe student and instructor were practicing water landings on lake sammamish near Redmond, WA. The winds were initially calm. On the second landing, it was noted that the wind began to pick up. Reportedly, wind shear was encountered during final approach for…Feb 28, 1982 · N4787E · Substantial damage