NTSB investigations, 1986, WI

21 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1986, WI per year, 1964–2026: 950 cases
196428
196528
196631
196744
196832
196932
197025
197122
197225
197331
197429
197517
197619
197719
197831
197926
198022
198130
198211
198313
198413
198523
198621
198711
198811
198913
19908
199111
19929
199312
199413
19957
19968
199710
199811
199913
200010
20016
20028
200311
20048
200515
20066
200714
200810
20098
20108
20115
201216
20133
20147
201510
20168
20178
20186
20195
20208
20218
20229
20239
202412
202517
20266

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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\") = 1986
    AND c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
  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 CHI87LA059Accident · No injuriesLimited investigationFinal reportCessna 172H · Mosinee, WIThe CFI stated that while in the landing configuration, over the apch end of the rwy, the student excessively flared the acft and it stalled with the right wing contacting the rwy. According to the CFI, power was added but it was too late to 'save the…Dec 30, 1986 · N3220L · Substantial damageNTSB CHI87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, WIWhile practicing touch & go landings, the student plt reports, the acft 'suddenly dropped' resulting in a hard landing. The acft then porpoised separating the nose gear and skidding to a stop off the rwy.Dec 26, 1986 · N4325E · Substantial damageNTSB CHI87IA039Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Madison, WIAircraft slid off the right side the runway during the rollout from a cross wind landing and struck 6 runway edge lights causing minor damage to the inboard trailing edge of the right flap. At the time of the incident there was 1/2 inch of snow on the runway…Dec 2, 1986 · N786NC · Minor damageNTSB CHI87LA034Accident · Serious injuriesLimited investigationFinal reportRaven S-66A · Baldwin, WIWhile landing, the passengers were instructed to stay to the side of the basket and hold on. However, one passenger moved toward the center of the basket and hit a video camera with her leg. During the occurrence, her leg was fractured between the knee and…Nov 2, 1986 · N4196N · No damageNTSB CHI87LA014Accident · No injuriesLimited investigationFinal reportBeech V35A · La Pointe, WIThe acft struck a deer during the landing flare. The plt was able to maintain control of the acft and complete the landing even though the acft sustained substantial damage to the right wing and its associated structure.Oct 24, 1986 · N8360N · Substantial damageNTSB CHI87LA008Accident · No injuriesLimited investigationFinal reportCessna 177 · Waukesha, WIAccording to the plt, it was a normal flight and approach to rwy 18. On touchdown, the acft nose dropped and the acft bounced three of four times. The plt stated that he immediately added pwr and became airborne, but a vibration caused him to cut pwr and land…Oct 22, 1986 · N3436T · Substantial damageNTSB CHI86FER18Accident · No injuriesFinal reportShanks/Becker Acro Sport · New Richmond, WIAccording to the pilot during landing rollout his left wing encountered three to four foot high grass growing up to the edge of the turf runway. The aircraft then veered off into a ditch. The runway involved is 2100 feet long and 75 feet wide.Sep 1, 1986 · N2263V · Substantial damageNTSB CHI86FA199Accident · No injuriesField investigationFinal reportCessna 177 · Oshkosh, WIA spl tfc management program was in effect for an annual eaa fly-in, & a waiver to FAA handbook 7110.65D was in effect which allowed for reduced sepn btn acft opng at wittman fld. As 2 acft were lndg, the plt of the 1st acft (Cessna 177, N17204) was told to…Aug 5, 1986 · N17204 · 2 aircraft · Substantial damageNTSB CHI86LA196Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Mosinee, WIFollowing departure from oshkosh, WI, the plt proceeded directly to central Wisconsin airport, Mosinee, WI, at aprx 2500 ft MSL. After receiving an arpt advisory from the central Wisconsin UNICOM, the plt landed on rwy 26. According to the plt, a 30-35 deg…Aug 3, 1986 · CGHGF · Substantial damageNTSB CHI86LA188Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Winneconne, WIWhile landing, the plt failed to maintain directional control. Subsequently, the acft went off the right side of the rwyand entered a skid. The left main gear collapsed, then the nose gear collapsed.Jul 27, 1986 · N4865V · Substantial damageNTSB CHI86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dodgeville, WIAccording to the pilot, his brakes failed and he was unable to stop before going off the end of the runway and over a 30 foot embankment. During an inspection, the brakes and braking system were found to be free of any defects and in proper working order.…Jul 26, 1986 · N80510 · Substantial damageNTSB CHI86FEP06Accident · No injuriesFinal reportPatton Pitts S-1C · Hartford, WIThe plt was on an aerobatic competition flt. He reported that after finishing a sequence of aerobatic maneuvers, he returned to the rwy to land. During the landing, the acft was high on final apch & touched down to FAR down the 2100 ft rwy. It then contd off…Jul 19, 1986 · N3507 · Substantial damageNTSB CHI86LA150Accident · No injuriesLimited investigationFinal reportCessna 182F · Hillsboro, WIThe pilot stated that following touchdown a gust of wind caused the aircraft to balloon back into the air. The second touchdown was in a crab angle and the aircraft began to slide sideways. The right wing struck the runway just as the aircraft departed the…Jun 3, 1986 · N3567Y · Substantial damageNTSB CHI86LA148Accident · No injuriesLimited investigationFinal reportCessna 182K · Durand, WIAccording to the pilot, winds at the time of the accident were out of the southwest at 10 gusting to 15 knots. He stated that upon landing on runway 18, the aircraft lifted slightly and rotated approximately 10 degrees to the right. It then ran off the edge…Jun 1, 1986 · N2669Q · Substantial damageNTSB CHI86LA145Accident · No injuriesLimited investigationFinal reportCessna 182P · Platteville, WIThe plt landed the acft on rwy 7 which was wet. Winds at the time were from 120 degs at 12 KTS. The plt stated that the wind caused the acft to skid and travel off the left side of the rwy. The acft nosed over after contacting soft soil alongside the rwy.May 27, 1986 · N84118 · Substantial damageNTSB CHI86LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Webster, WIDuring an attempted go-around after a bounced crosswind landing, pilot failed to maintain a proper ground track and the aircraft collided with trees.May 10, 1986 · N8239E · Substantial damageNTSB CHI86LA123Accident · No injuriesLimited investigationFinal reportCessna 182 · Augusta, WIThe pilot made his approach to runway 27 after noticing that the winds were from the north northwest. He said the made his approach at 80 KTS because of the crosswind. After touching down beyond his intended touchdown area he felt he would not clear the trees…Apr 21, 1986 · N94586 · Substantial damageNTSB CHI86LA110Accident · No injuriesLimited investigationFinal reportCessna 172MM · Middleton, WIThe 94 hour private pilot was attempting a landing with a crosswind component of 90 degrees and a wind velocity of 15 to 18 KTS gusting to 22 KTS when he touched down with the right main gear & 2 feet off the right side of the runway. The right main gear came…Mar 28, 1986 · N20866 · Substantial damageNTSB CHI86LA095Accident · No injuriesLimited investigationFinal reportCessna 172C · Waupun, WIDrg arrival for a x-wind landing, the plt made a high apch & used full flaps to steepen his dscnt over trees near the apch end of the rwy. He stated that the touchdown was normal, but before he could raise the flaps, the x-wind pushed the plane to the left.…Mar 1, 1986 · N1636Y · Substantial damageNTSB CHI86LA078Accident · No injuriesLimited investigationFinal reportMooney M20-K · Madison, WIA gear up landing was performed by the pilot. He stated that he was distracted by an airliner ahead of him in the pattern and did not consult his before landing checklist. He also stated that he had not flown much in the last three months.Jan 26, 1986 · N1156C · Substantial damageNTSB CHI86LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Baraboo, WIThe plt attempted a x-wind landing that was beyond his capabilities. He stated that if the x-wind was excessive he intended to divert to another arpt with a more favorable runway. At touchdown the aircraft drifted right into a two foot high snow bank off the…Jan 25, 1986 · N46675 · Substantial damage