NTSB investigations, 1986, WI

9 cases where the first occurrence was “Loss of control - on ground/water”.

Cases per year

19822026
NTSB investigations, 1986, WI per year, 1982–2026: 127 cases
19826
19835
19844
19859
19869
19873
19887
19896
19901
19915
19924
19939
19944
19953
19965
19975
19984
19998
20005
20012
20023
20034
20042
20056
20063
20075

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\") = 1986
    AND c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
    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\" = 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 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 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 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 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 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 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