# NTSB investigations, WI: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 9 · 424 cases

## Latest cases

- [NTSB CEN26LA319](https://openairdocs.org/ntsb/CEN26LA319.md): Beech K35 · Wausau, WI · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 13, 2026 · N6071E · Substantial damage
  > On September 12, 2026, about 2049 central daylight time, a Beech K35 airplane, N6071E, was substantially damaged when it was involved in an accident near Wausau, Wisconsin. The pilot and passenger suffered minor injuries. The flight was operated as a Title 14…
- [NTSB CEN26LA263](https://openairdocs.org/ntsb/CEN26LA263.md): Piper PA24 · Baraboo, WI · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 16, 2026 · N8606P · Substantial damage
  > On July 16, 2026, about 1508 central daylight time, a Piper PA-24-260 airplane, N8606P, sustained substantial damage when it was involved in an accident near Baraboo, Wisconsin. The pilot sustained serious injuries. The airplane was operated as a Title 14…
- [NTSB CEN26LA094](https://openairdocs.org/ntsb/CEN26LA094.md): Cessna 172K · Amery, WI · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 16, 2026 · N79118 · Substantial damage
  > On January 16, 2026, about 1130 central standard time, a Cessna 172 airplane, N79118, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN26FA050](https://openairdocs.org/ntsb/CEN26FA050.md): Socata TBM 700 · Monroe, WI · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 24, 2025 · N700PT · Substantial damage
  > On November 24, 2025, about 1713 central standard time (CST), a Socata TBM 700 airplane, N700PT, was destroyed when it was involved in an accident near Monroe, Wisconsin. The pilot and pilot-rated passenger sustained fatal injuries. The airplane was operated…
- [NTSB CEN25LA249](https://openairdocs.org/ntsb/CEN25LA249.md): Piper J3C-65 · Howard, WI · Accident · No injuries · Class 4 · Limited · Final report · Jul 13, 2025 · N88220 · Substantial damage
  > The pilot’s failure to maintain control of the airplane while on approach to land.
- [NTSB CEN25LA211](https://openairdocs.org/ntsb/CEN25LA211.md): Cessna U206 · Falun, WI · Accident · No injuries · Class 4 · Limited · Final report · Jun 18, 2025 · N932DB · Substantial damage
  > The pilot experiencing the featureless terrain illusion during the approach which gave the perception that the airplane was at a higher altitude over the glassy water surface than it was, resulting in the airplane impacting the water.
- [NTSB CEN25LA196](https://openairdocs.org/ntsb/CEN25LA196.md): Gallow Daniel A Kitfox Classic IV · Waupaca, WI · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 5, 2025 · N755SD · Substantial damage
  > The pilot’s failure to maintain adequate air speed during final approach, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB CEN25LA035](https://openairdocs.org/ntsb/CEN25LA035.md): De Havilland DHC-1 · East Troy, WI · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 6, 2024 · N420TD · Substantial damage
  > The pilot’s inadequate fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the inaccurate fuel gauge.
- [NTSB CEN24FA277](https://openairdocs.org/ntsb/CEN24FA277.md): Lancair ES · Oshkosh, WI · Accident · 2 fatal · Class 3 · Field · Final report · Jul 22, 2024 · N18BG · Destroyed
  > The pilot’s failure to maintain adequate airspeed which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall while maneuvering for traffic spacing.
- [NTSB CEN23FA333](https://openairdocs.org/ntsb/CEN23FA333.md): Rotorway 162F · Oshkosh, WI · Accident · 2 fatal · Class 3 · Field · Final report · Jul 29, 2023 · N193AZ · 2 aircraft · Destroyed
  > The failure of the gyroplane pilot to see and avoid the helicopter while maneuvering in the traffic pattern. Contributing to the accident was the gyroplane pilot’s performance of a prohibited maneuver in the traffic pattern.
- [NTSB CEN23LA037](https://openairdocs.org/ntsb/CEN23LA037.md): Fairchild SA227-AT · Pewaukee, WI · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 15, 2022 · N247DH · Substantial damage
  > The flight crew’s failure to maintain adequate airspeed and their exceedance of the airplane’s critical angle of attack during the instrument approach, which resulted in an aerodynamic stall. Contributing to the accident was an undetermined anomaly in the…
- [NTSB ERA22FA399](https://openairdocs.org/ntsb/ERA22FA399.md): Conway Philip J Glasair Super II SFT · Bay City, WI · Accident · 2 fatal · Class 3 · Field · Final report · Sep 6, 2022 · N11HC · Substantial damage
  > The continuation of a poorly-flown, unstabilized approach and the flight instructor’s failure to direct a discontinuance of that approach, resulting in a collision with terrain during turn to final.
- [NTSB CEN22LA305](https://openairdocs.org/ntsb/CEN22LA305.md): Bell 206B · East Troy, WI · Accident · No injuries · Class 4 · Limited · Final report · Jul 1, 2022 · N882NY · Substantial damage
  > The pilot’s improper fuel management that resulted in fuel exhaustion and a loss of engine power.
- [NTSB CEN22LA220](https://openairdocs.org/ntsb/CEN22LA220.md): Grumman American Avn. AA-1B · River Falls, WI · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 1, 2022 · N6298L · Substantial damage
  > The student pilot’s and flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN22LA141](https://openairdocs.org/ntsb/CEN22LA141.md): Cessna 150M · Brodhead, WI · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 13, 2022 · N63246 · Substantial damage
  > A loss of engine power due to the fatigue fracture of the No. 1 cylinder’s rocker shaft bosses, which resulted in a forced landing into uneven terrain.
- [NTSB CEN21LA333](https://openairdocs.org/ntsb/CEN21LA333.md): Boeing E75 · Baraboo, WI · Accident · No injuries · Class 4 · Limited · Final report · Jul 23, 2021 · N51CF · Substantial damage
  > The pilot’s failure to maintain clearance from the fence while on final approach.
- [NTSB CEN21LA222](https://openairdocs.org/ntsb/CEN21LA222.md): Flight Design Ctls · Racine, WI · Accident · Minor injuries · Class 3 · Limited · Final report · May 18, 2021 · N521CT · Destroyed
  > The fatigue failure of the carburetor throttle control cable, which resulted in a partial loss of engine control.
- [NTSB CEN20LA179](https://openairdocs.org/ntsb/CEN20LA179.md): Cessna P210 · Burlington, WI · Accident · 1 fatal · Class 3 · Limited · Final report · May 15, 2020 · N1JA · Substantial damage
  > The pilot did not maintain a safe altitude during the visual approach, and subsequently lost control which resulted an impact with trees and terrain.
- [NTSB CEN19LA045](https://openairdocs.org/ntsb/CEN19LA045.md): Brandt Sonex · Lodi, WI · Accident · Serious injuries · Limited investigation · Final report · Dec 15, 2018 · N393SX · Substantial damage
  > The pilot's failure to maintain proper alignment with the runway during final approach, which resulted in impact with a tree.
- [NTSB GAA19CA096](https://openairdocs.org/ntsb/GAA19CA096.md): Beech 36 · Hartford, WI · Accident · No injuries · Data collection · Final report · Dec 12, 2018 · N6650M · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and impact with terrain during landing in icing conditions.
- [NTSB GAA18CA490](https://openairdocs.org/ntsb/GAA18CA490.md): Cessna 172 · DePere, WI · Accident · Serious injuries · Data collection · Final report · Aug 14, 2018 · N1085U · Substantial damage
  > The pilot’s failure to maintain lateral control and his subsequent failure to maintain the runway heading during an attempted go-around, which resulted in impact with trees.
- [NTSB CEN18CA291](https://openairdocs.org/ntsb/CEN18CA291.md): Quad City Challenger · Oshkosh, WI · Accident · No injuries · Data collection · Final report · Jul 23, 2018 · N1666R · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during the base to final turn and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB CEN18FA216](https://openairdocs.org/ntsb/CEN18FA216.md): Cessna T182T · Monroe, WI · Accident · 4 fatal · Field investigation · Final report · Jun 10, 2018 · N1880B · Destroyed
  > Spatial disorientation resulting in a loss of control during the missed approach conducted in instrument meteorological conditions. Contributing to the accident was the pilot's decision to execute an instrument approach in weather conditions that were below…
- [NTSB CEN18LA115](https://openairdocs.org/ntsb/CEN18LA115.md): Messerschmitt-Bolkow-Blohm BK 117 B-2 · Sheboygan, WI · Accident · No injuries · Limited investigation · Final report · Mar 5, 2018 · N1174U · Substantial damage
  > The restricted cyclic control movement for reasons that could not be determined because postaccident examination and testing of the cyclic control system did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal…
- [NTSB GAA18CA058](https://openairdocs.org/ntsb/GAA18CA058.md): Cessna 182 · Black River Falls, WI · Accident · No injuries · Data collection · Final report · Nov 27, 2017 · N8128M · Substantial damage
  > The student pilot’s failure to maintain lateral control of the high-performance airplane during the go-around in crosswind conditions.
- [NTSB CEN18LA038](https://openairdocs.org/ntsb/CEN18LA038.md): Piper / Laudeman J3C 65 · Palmyra, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 2017 · N11188 · Substantial damage
  > The pilot’s inadvertent pulling of the fuel shutoff valve, which resulted in a total loss of engine power and a subsequent forced landing into trees. Contributing to the pilot’s inadvertent pulling of the fuel shutoff valve were habit patterns he had…
- [NTSB CEN17LA307](https://openairdocs.org/ntsb/CEN17LA307.md): Pegasus Quantum · Fort Atkinson, WI · Accident · 2 fatal · Limited investigation · Final report · Aug 9, 2017 · N56092 · Substantial damage
  > The student pilot's failure to maintain aircraft control during a go-around, which resulted in impact with water. Contributing to the accident was the non-instructor sport pilot's decision to allow the student pilot to fly the aircraft.
- [NTSB GAA17CA412](https://openairdocs.org/ntsb/GAA17CA412.md): Mooney M20C · Washington Island, WI · Accident · No injuries · Data collection · Final report · Jul 15, 2017 · N9303V · Substantial damage
  > The pilot's failure to maintain a proper approach path, which resulted in impact with trees.
- [NTSB CEN17FA231](https://openairdocs.org/ntsb/CEN17FA231.md): Gefa-Flug AS-105-GD · Hartford, WI · Accident · Serious injuries · Field investigation · Final report · Jun 15, 2017 · G-SUNA · Destroyed
  > The overpressurization failure of the airship envelope as a result of the airship's encounter with gusty wind conditions and thermal activity. Contributing to the accident was the jammed Plexiglass venting panel.
- [NTSB CEN17CA114](https://openairdocs.org/ntsb/CEN17CA114.md): Cessna 340A · Waukesha, WI · Accident · No injuries · Data collection · Final report · Feb 25, 2017 · N255BC · Substantial damage
  > The pilot’s decision to fly in in conditions conducive to structural icing and her subsequent failure to maintain airplane control during the instrument approach.
- [NTSB CEN17LA037](https://openairdocs.org/ntsb/CEN17LA037.md): Johnson Kenneth R Stol CH 801 · Royalton, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 6, 2016 · N801KJ · Destroyed
  > The loss of control during approach for reasons that could not be determined due to postimpact fire damage.
- [NTSB GAA17LA090](https://openairdocs.org/ntsb/GAA17LA090.md): Piper PA28R · Watertown, WI · Accident · No injuries · Limited investigation · Final report · Nov 5, 2016 · N300KR · Substantial damage
  > The pilot’s failure to attain a proper glidepath on approach for landing, which resulted in impact with trees. Contributing to the accident was a partial, temporary loss of engine power for reasons that could not be determined because postaccident examination…
- [NTSB CEN16FA373](https://openairdocs.org/ntsb/CEN16FA373.md): Cessna 182 · Ephraim, WI · Accident · 2 fatal · Field investigation · Final report · Sep 19, 2016 · N2012F · Destroyed
  > The pilot's improper decision to execute a maneuvering approach at low altitude during night conditions, which resulted in controlled flight into terrain.
- [NTSB CEN16LA294](https://openairdocs.org/ntsb/CEN16LA294.md): Bell 47G 2 · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Jul 30, 2016 · N975BH · Substantial damage
  > The loosening and separation of the throttle linkage nut, which resulted in a loss of throttle control and subsequent hard landing after autorotation.
- [NTSB CEN16FA295](https://openairdocs.org/ntsb/CEN16FA295.md): Mooney M20J · Holmen, WI · Accident · 1 fatal · Field investigation · Final report · Jul 28, 2016 · N54PM · Destroyed
  > The pilot's loss of airplane control during an instrument approach. Contributing to the accident was the pilot's lack of instrument flight proficiency.
- [NTSB CEN16LA283](https://openairdocs.org/ntsb/CEN16LA283.md): Bristell E-LSA · Oshkosh, WI · Accident · Serious injuries · Limited investigation · Final report · Jul 24, 2016 · N167BL · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack on short final approach, which resulted in an inadvertent aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot’s distraction with other traffic in the…
- [NTSB CEN15LA333](https://openairdocs.org/ntsb/CEN15LA333.md): Cessna 182 · Watertown, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2015 · N1685R · Substantial damage
  > The total loss of engine power due to carburetor icing.
- [NTSB CEN15FA311](https://openairdocs.org/ntsb/CEN15FA311.md): Piper PA-46-310P · Oshkosh, WI · Accident · Serious injuries · Field investigation · Final report · Jul 22, 2015 · N4BP · Substantial damage
  > The pilot's failure to perform a go-around after receiving a modified landing clearance and his failure to maintain adequate airspeed while maneuvering to land, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering…
- [NTSB CEN15LA195](https://openairdocs.org/ntsb/CEN15LA195.md): Quad City Challenger - II · Chippewa Falls, WI · Accident · 1 fatal · Limited investigation · Final report · Apr 11, 2015 · N30796 · Substantial damage
  > The pilot’s incapacitation due to a cardiovascular event, which resulted in a loss of control and subsequent impact with terrain.
- [NTSB CEN15LA020](https://openairdocs.org/ntsb/CEN15LA020.md): Kovars Gary D Zenith Zodiak 601XL · Richland Center, WI · Accident · No injuries · Limited investigation · Final report · Oct 9, 2014 · N601GK · Substantial damage
  > The loss of engine power due to carburetor icing.
- [NTSB CEN14FA396](https://openairdocs.org/ntsb/CEN14FA396.md): Render RV 9A · Oshkosh, WI · Accident · Serious injuries · Field investigation · Final report · Jul 30, 2014 · N82PR · Substantial damage
  > The pilot's failure to establish a stabilized approach and to maintain airspeed during final approach over obstacles resulting in a stall/mush.
- [NTSB CEN14LA443](https://openairdocs.org/ntsb/CEN14LA443.md): Piper PA 28-181 · Waukesha, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 2014 · N9681K · Substantial damage
  > The loss of engine power for reasons that could not be determined because no anomalies were identified during postaccident examination.
- [NTSB CEN13CA316](https://openairdocs.org/ntsb/CEN13CA316.md): Sheldrick John H RV-6 · Brookfield, WI · Accident · No injuries · Data collection · Final report · Jun 4, 2013 · N77GT · Substantial damage
  > The pilot's failure to maintain runway alignment and his failure to recognize that the airplane had drifted away from the runway prior to landing.
- [NTSB CEN13LA016](https://openairdocs.org/ntsb/CEN13LA016.md): Beech A36 · Wausau, WI · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 2012 · N121VP · Substantial damage
  > The pilot's decision to attempt an instrument approach in meteorological conditions below approach minimums and his failure to properly execute a missed approach.
- [NTSB CEN12CA165](https://openairdocs.org/ntsb/CEN12CA165.md): Beech 95-B55 · Lancaster, WI · Accident · No injuries · Data collection · Final report · Feb 17, 2012 · N4624A · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN11CA290](https://openairdocs.org/ntsb/CEN11CA290.md): Cessna 182H · Park Falls, WI · Accident · No injuries · Data collection · Final report · Apr 14, 2011 · N8364S · Substantial damage
  > The student pilot's failure to maintain aircraft control during an aborted landing.
- [NTSB CEN11FA193](https://openairdocs.org/ntsb/CEN11FA193.md): Gulfstream Aerospace GV-SP · Appleton, WI · Accident · No injuries · Field investigation · Final report · Feb 14, 2011 · N535GA · Substantial damage
  > The pilot flying's (PF) decision to land on a shorter-than-recommended runway with a known left hydraulic system failure rather than go around as suggested by the pilot-not-flying, his failure to immediately apply emergency brakes following the detection of…
- [NTSB CEN11CA128](https://openairdocs.org/ntsb/CEN11CA128.md): Cessna 340A · Madison, WI · Accident · No injuries · Data collection · Final report · Dec 21, 2010 · N233DS · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure to check the de-ice fluid level prior to takeoff, which resulted in the failure of the de-ice…
- [NTSB CEN10FA557](https://openairdocs.org/ntsb/CEN10FA557.md): Piper PA-44-180 · Woodruff, WI · Accident · 2 fatal · Field investigation · Final report · Sep 24, 2010 · N570ER · Destroyed
  > The pilot's decision to attempt an instrument approach in turbulent night instrument meteorological conditions with a recently-identified deficiency with his instrument flight proficiency, which resulted in a loss of airplane control as a result of spatial…
- [NTSB CEN10LA529](https://openairdocs.org/ntsb/CEN10LA529.md): Piper Aerostar 601P · Baraboo, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 2010 · N601PP · Substantial damage
  > The pilot's diverted attention during an approach for landing that resulted in an altitude loss and impact with terrain.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=WI&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=WI

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.