OpenAirDocs.org

NTSB investigations, 1987

7 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.

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\") = 1987
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 160)
  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 CHI88LA004Accident · No injuriesLimited investigationFinal reportCessna 150H · Elroy, WIUpon attempting his tenth touch and go the student pilot noticed, prior to touchdown, that the aircraft was to the right of the runway. In an attempt to realign himself with the runway the pilot stated he 'lowered' the left wing. The left wing then struck the…Oct 11, 1987 · N50124 · Substantial damageNTSB MIA87LA221Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · St.Augustine, FLDuring the water takeoff run the plt's forward visibility was momentarily lost as he rotated the acft onto the step. When visibility was regained he realized that the acft was headed towards the shoreline & turned to avoid it during which the rt wing tip was…Aug 2, 1987 · N2878P · Substantial damageNTSB MKC87LA129Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Bull Shoals, ARThe pilot stated the winds were four to five mph from the sw as he departed and he could see thunderstorms four or five miles to the west. He overflew his destination when he saw large waves on the water. He landed in a smooth-water cove and was taxiing…Jun 28, 1987 · N9161C · Substantial damageNTSB FTW87LA125Accident · No injuriesLimited investigationFinal reportQuickie Q2 · Sherman, TXThe pilot stated that during the takeoff run the left side of the aircraft appeared to be developing more lift than the right. The right wing tip dragged, causing the aircraft to veer to the right side into the mud where it flipped inverted before stopping.…May 25, 1987 · N85Q · Substantial damageNTSB MKC87LA089Accident · No injuriesLimited investigationFinal reportCessna 172E · Moorhead, IAAccording to FAA statements, the pilot was attempting a takeoff from a taxiway when a wing dipped. The pilot then lost control as the wing dragged, causing the aircraft to ground loop/swerve onto the terrain. The nose gear tire blew during the swerve and the…Apr 23, 1987 · N3777S · Substantial damageNTSB FTW87LA048Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alpine, TXStudent pilot on solo flight attempted takeoff in strong gusty winds and dragged left wing tip on runway. Pilot leveled wings and attempted to land aircraft but departed left side of runway and collided with ditch.Jan 24, 1987 · N2592C · Substantial damageNTSB LAX87LA078Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Oakland, CAA Champion 7EC went out of control during the takeoff initial climb. The aircraft dragged a wing during takeoff ground run. The pilot was observed looking back towards the runway during the initial climb. The aircraft stalled and descended uncontrolled to the…Jan 9, 1987 · N7515E · Substantial damage