NTSB investigations, 1983, WI

13 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1983, 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\") = 1983
    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 CHI84LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hayward, WIThe acft collided with a snow bank during the landing roll and nosed over. The rwy was covered with snow and was slick. The solo student plt said he landed with more airspeed than normal and the acft started to go to the left on the rwy. The plts attempted…Dec 18, 1983 · N25687 · Substantial damageNTSB CHI83LA433Accident · No injuriesLimited investigationFinal reportCessna 150 · Spring Brook, WIThe student pilot landed the acft and bounced until it nosed over. The student had made 2 or 3 successful touch and go landings. On the last approach the sun blinded the student but he continued the approach. The acft was flared too high and bounced before…Sep 19, 1983 · N3069S · Substantial damageNTSB CHI83LA394Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Watertown, WIThe plt lost directional control during the landing roll & the acft struck 3 landing lights. The left gear collapsed & there was substantial damage to the left wing. The pilot stated that his landing light was inoperative during the landing and lack of…Aug 28, 1983 · N9346C · Substantial damageNTSB CHI83LA423Accident · No injuriesLimited investigationFinal reportBeemer Pitts S-1C · Portage, WIThe acft had just been purchased & was being ferried to palatka, FL. During the landing roll at an en route arpt, the acft ground looped, and subsequently, came to rest inverted. The plt stated that this was his 1st landing in the pitts S-10 & that he was…Aug 6, 1983 · N46807 · Substantial damageNTSB CHI83LA367Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Franksville, WIThe acft was intentionally groundlooped as the acft was not stopping at the runways end. The pilot said the brakes malfunctioned. The mechanic who worked on the acft after the accident said brakes were available even though brake fluidwas low. The mechanic…Aug 6, 1983 · N2843Z · Substantial damageNTSB CHI83FA362Accident · Minor injuriesField investigationFinal reportGrumman Scan Type 30 · Fond Du Lac, WIAfter takeoff, the aircrew flew to the southern end of lake winnebago where they made several uneventful water landings. They estimated that the wind was from the northeast at 5 to 6 KTS. The water was described as smooth with only small ripples. On the 6th…Aug 5, 1983 · N7775C · DestroyedNTSB CHI83LA323Accident · No injuriesLimited investigationFinal reportCessna 150 · Wilmot, WIThe acft collided with a tree during a go-around. The pilot added full flaps as the rwy was approached. During the flare the acft ballooned and bounced. A go-around was started but the flaps were not raised. The acft did notachieve enough climb to clear the…Jul 19, 1983 · N714PJ · Substantial damageNTSB CHI83LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Milwaukee, WIDuring landing the pax had her legs positioned in such a manner that they interfered with the movement of the yoke. When the plt requested she clear the yoke, she put her left foot on the rudder pedal/brake causing the acft to veer off the left side of the…Jun 13, 1983 · N6566P · Substantial damageNTSB CHI83LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · New Richmond, WIThe student pilot on his 2nd solo flt made a hard landing which collapsed the nose gear. This was the 1st landing of theflight and the pilot touched down nose gear first. The nose gear collapsed and folded backward. The underside of the cowling was bent, the…May 17, 1983 · N67613 · Substantial damageNTSB CHI83LA188Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Platteville, WIDuring arrival, the plt entered the traffic pattern to land on rwy 27 in x-wind conditions. The rwy was 2200 ft long & was wet from light rain. After making 2 go-arounds, a landing was made on the 3rd apch. The plt reported that the braking was poor to nil.…Apr 26, 1983 · N5548P · Substantial damageNTSB CHI83LA173Accident · Minor injuriesLimited investigationFinal reportGrumman G-44 · Fond Du Lac, WIThe pilot became preoccupied with a minor electrical problem and did not raise the landing gear before making a landing on water. Upon water contact, the landing gear effected enough drag to nose the aircraft over.Apr 19, 1983 · N99431 · Substantial damageNTSB CHI83FA139Accident · No injuriesField investigationFinal reportBeech 58 · Miwaulkee, WIThe plt reported that he noted a fairly loud sound as the landing gear locked in the up position. Later, he was unable to extend the gear with either the normal or emergency systems. The circuit breaker would pop each time he tried the normal system. The…Mar 16, 1983 · N6838S · Substantial damageNTSB CHI83LA074Accident · No injuriesLimited investigationFinal reportCessna 140 · Springbrook, WIThe acft collided with a four ft snowbank at the rwy threshold during landing. This was a dual instructional flt with the student in the right seat. The CFI had made no landings in this make and model of acft in the previous 90 days. The pilot stated that due…Jan 1, 1983 · N89399 · Substantial damage