# Fatal NTSB investigations, WI: Enroute

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 3 · 144 cases

## Latest cases

- [NTSB CEN27FA016](https://openairdocs.org/ntsb/CEN27FA016.md): Piper PA 46-350P · Reedsburg, WI · Accident · 6 fatal · Class 3 · Field · Preliminary report · Oct 14, 2026 · N931TT · Destroyed
  > On October 13, 2026, about 2130 central daylight time, a Piper Aircraft PA-46-350P JetProp DLX airplane, N931TT, was destroyed when it was involved in an accident near Reedsburg, Wisconsin. The pilot, the pilot-rated passenger, and the four passengers…
- [NTSB CEN24FA024](https://openairdocs.org/ntsb/CEN24FA024.md): Lancair 320 · Manitowoc, WI · Accident · 1 fatal · Class 3 · Field · Final report · Oct 25, 2023 · N320P · Substantial damage
  > The pilot’s decision to continue the visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from trees and terrain during an unapproved instrument approach. Contributing to the accident was the pilot’s…
- [NTSB CEN23FA239](https://openairdocs.org/ntsb/CEN23FA239.md): Mooney M20R · Watertown, WI · Accident · 2 fatal · Class 3 · Field · Final report · Jun 14, 2023 · N1025C · Destroyed
  > The pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions. Contributing to the accident was the pilot’s impairment from the prohibited substance; however, the extent of impairment could not be determined.
- [NTSB CEN22FA021](https://openairdocs.org/ntsb/CEN22FA021.md): Beech B36TC · Lena, WI · Accident · 1 fatal · Class 3 · Field · Final report · Oct 27, 2021 · N75RM · Substantial damage
  > Impairment and subsequent incapacitation of the pilot for reasons that could not be determined. The incapacitation resulted in a loss of engine power due to fuel starvation. Likely contributing was pilot hypoxia due to altitude exposure, possibly worsened by…
- [NTSB CEN22FA013](https://openairdocs.org/ntsb/CEN22FA013.md): New Glasair Glastar · Waukesha, WI · Accident · 2 fatal · Class 3 · Field · Final report · Oct 12, 2021 · N628RS · Destroyed
  > The noninstrument-rated pilot’s decision to depart and continue flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB CEN21FA459](https://openairdocs.org/ntsb/CEN21FA459.md): Rockwell International 690B · Hiles, WI · Accident · 3 fatal · Class 3 · Field · Final report · Sep 28, 2021 · N690LS · Destroyed
  > The pilot’s failure to maintain adequate airspeed, which caused the airplane to exceed its critical angle of attack and enter an inadvertent stall and spin.
- [NTSB CEN19FA018](https://openairdocs.org/ntsb/CEN19FA018.md): Eurocopter AS350 · Odanah, WI · Accident · 1 fatal · Field investigation · Final report · Oct 29, 2018 · N910S · Destroyed
  > The pilot's loss of helicopter control for undetermined reasons.
- [NTSB CEN18FA149](https://openairdocs.org/ntsb/CEN18FA149.md): Eurocopter AS 350 B2 · Hazelhurst, WI · Accident · 3 fatal · Field investigation · Final report · Apr 27, 2018 · N127LN · Destroyed
  > The pilot's loss of helicopter control as a result of fatigue during cruise flight at night.
- [NTSB CEN17FA248](https://openairdocs.org/ntsb/CEN17FA248.md): Cessna 421C · Catawba, WI · Accident · 6 fatal · Field investigation · Final report · Jul 1, 2017 · N2655B · Destroyed
  > A loss of control and subsequent in-flight breakup for reasons that could not be determined based on the available information.
- [NTSB CEN15FA315](https://openairdocs.org/ntsb/CEN15FA315.md): Sanford Zenith CH 601XL · Bristol, WI · Accident · 2 fatal · Field investigation · Final report · Jul 25, 2015 · N9601 · Substantial damage
  > The pilot’s failure to maintain airspeed and airplane control following a loss of engine power during cruise flight. Contributing to the accident was the installation of ignition system coils that were not engine-manufacturer replacement parts, which…
- [NTSB CEN15FA119](https://openairdocs.org/ntsb/CEN15FA119.md): Cessna 182L · Owen, WI · Accident · 1 fatal · Field investigation · Final report · Jan 26, 2015 · N3181R · Substantial damage
  > The flight instructor's decision to initiate flight into forecasted icing conditions in an airplane that was not certified or equipped for flight into icing conditions, which resulted in significant structural ice accumulation to the extent that the airplane…
- [NTSB CEN15FA027](https://openairdocs.org/ntsb/CEN15FA027.md): Cessna T210M · Bay City, WI · Accident · 1 fatal · Field investigation · Final report · Oct 24, 2014 · N761SU · Destroyed
  > The non-instrument rated pilot’s continued visual flight into instrument flight rules conditions, which resulted in an in-flight loss of control.
- [NTSB CEN13FA438](https://openairdocs.org/ntsb/CEN13FA438.md): Piper PA-28R-200 · Lake Michigan, WI · Accident · 2 fatal · Field investigation · Final report · Jul 27, 2013 · N1549X · Destroyed
  > An encounter with wake turbulence, which resulted in the pilot’s loss of control of the airplane and its subsequent in-flight breakup. Contributing to the accident was the approach controller’s failure to issue a wake turbulence advisory to the pilot.
- [NTSB CEN12FA617](https://openairdocs.org/ntsb/CEN12FA617.md): Beech A36 · Kansasville, WI · Accident · 1 fatal · Field investigation · Final report · Sep 9, 2012 · N3224G · Substantial damage
  > In-flight loss of control for reasons that could not be determined because postaccident examination of the pilot and testing of the airplane did not reveal any anomalies that would have led to the loss of control.
- [NTSB CEN12FA080](https://openairdocs.org/ntsb/CEN12FA080.md): Diamond Aircraft Ind DA 20-C1 · Bern, WI · Accident · 1 fatal · Field investigation · Final report · Nov 24, 2011 · N203MK · Substantial damage
  > The non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.
- [NTSB CEN11FA625](https://openairdocs.org/ntsb/CEN11FA625.md): Socata TBM 700 · Mt. Pleasant, WI · Accident · 1 fatal · Field investigation · Final report · Sep 5, 2011 · N850SY · Substantial damage
  > The pilot’s failure to properly trim the airplane’s rudder during cruise flight, which resulted in a prolonged uncoordinated flight condition, unporting of the fuel tank feed line, and subsequent fuel starvation and engine power loss. Contributing to the…
- [NTSB CEN11FA240](https://openairdocs.org/ntsb/CEN11FA240.md): Cessna 150D · Baraboo, WI · Accident · 2 fatal · Field investigation · Final report · Mar 20, 2011 · N4178U · Substantial damage
  > The student pilot’s inadequate preflight planning and his decision to continue the flight into instrument meteorological conditions, which resulted in a subsequent loss of airplane control.
- [NTSB CEN11LA050](https://openairdocs.org/ntsb/CEN11LA050.md): Mcfarland Bill Challenger II · Praire Du Sac, WI · Accident · 1 fatal · Limited investigation · Final report · Nov 1, 2010 · N448WM · Substantial damage
  > The separation of the fuselage-mounted wing strut attachment fitting for an undetermined reason, which resulted in the separation of the left wing of the airplane.
- [NTSB CEN09FA340](https://openairdocs.org/ntsb/CEN09FA340.md): Gulfstream American AA-5B · Humbird, WI · Accident · 2 fatal · Field investigation · Final report · Jun 7, 2009 · N448DM · Substantial damage
  > The pilot's decision to attempt a visual flight rules flight into an area of known instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB CEN09FA146](https://openairdocs.org/ntsb/CEN09FA146.md): Cirrus Design SR20 · Menomonie, WI · Accident · 3 fatal · Field investigation · Final report · Jan 31, 2009 · N495LV · Destroyed
  > The pilot's failure to maintain control of the airplane while flying at night in instrument meteorological conditions.
- [NTSB CHI08FA293](https://openairdocs.org/ntsb/CHI08FA293.md): Robinson R44 II · Kenosha, WI · Accident · 2 fatal · Field investigation · Final report · Sep 21, 2008 · N999ZD · Destroyed
  > The pilots failure to maintain clearance from terrain resulting in an in-flight collision with a house. Contributing to the accident was the night instrument meteorological conditions (IMC) and the pilot's lack of experience of flying in IMC.
- [NTSB CHI08FA128](https://openairdocs.org/ntsb/CHI08FA128.md): Eurocopter Deutschland EC 135 T2+ · La Crosse, WI · Accident · 3 fatal · Field investigation · Final report · May 11, 2008 · N135UW · Destroyed
  > The pilot’s failure to maintain clearance from trees along the top of a ridgeline due to inadequate preflight planning, insufficient altitude, and the lack of a helicopter terrain awareness and warning system. Member Sumwalt did not approve this brief and…
- [NTSB CHI08FA054](https://openairdocs.org/ntsb/CHI08FA054.md): Piper PA-32R-300 · Warrens, WI · Accident · 1 fatal · Field investigation · Final report · Dec 21, 2007 · N1919H · Destroyed
  > The decision by the pilot to fly into known adverse weather, and the pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors include the clouds and the night conditions.
- [NTSB CHI07MA160](https://openairdocs.org/ntsb/CHI07MA160.md): Cessna 550 · Milwaukee, WI · Accident · 6 fatal · Class 1 · Major · Final report · Jun 4, 2007 · N550BP · Destroyed
  > The National Transportation Safety Board determines that the probable cause of this accident was the pilots’ mismanagement of an abnormal flight control situation through improper actions, including failing to control airspeed and to prioritize control of the…
- [NTSB CHI05FA180](https://openairdocs.org/ntsb/CHI05FA180.md): Piper PA-28-181 · Lake Michigan, WI · Accident · 1 fatal · Field investigation · Final report · Apr 26, 2005 · N5360F · Substantial damage
  > The pilot's inaccurate preflight planning and his delayed en route decision to make a fuel stop, which resulted in the loss of engine power due to fuel exhaustion and subsequent ditching.
- [NTSB CHI05FA048](https://openairdocs.org/ntsb/CHI05FA048.md): Beech S35 · Herman, WI · Accident · 2 fatal · Field investigation · Final report · Dec 25, 2004 · N5631K · Substantial damage
  > The installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…
- [NTSB CHI05FA016](https://openairdocs.org/ntsb/CHI05FA016.md): Cessna P210N · Wautoma, WI · Accident · 2 fatal · Field investigation · Final report · Oct 26, 2004 · N5485W · Destroyed
  > The pilot not maintaining airplane control during cruise flight in instrument meteorological conditions after reporting a loss of gyros leading to his exceeding the design load limits of the wings. Factors were the clouds, the deteriorated vacuum manifold…
- [NTSB CHI04LA256](https://openairdocs.org/ntsb/CHI04LA256.md): Claxton S-12 · Oconomowoc, WI · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 2004 · UNREG · Destroyed
  > The loss of engine power due to the seizure of the pistons and the pilot's failure to maintain airspeed which resulted in an inadvertent stall. The previous damage to the pistons due to earlier seizure occurrences was a factor.
- [NTSB CHI04LA243](https://openairdocs.org/ntsb/CHI04LA243.md): Boeing A75 · Wisconsin Rapid, WI · Accident · 1 fatal · Limited investigation · Final report · Aug 28, 2004 · N86600 · Substantial damage
  > The pilot's improper in-flight decision when he decided to fly at a low altitude over the river and failed to maintain clearance from the power lines. A factor was the wires.
- [NTSB CHI04FA203](https://openairdocs.org/ntsb/CHI04FA203.md): Knoepflein Lancair Legacy 2000 · Madison, WI · Accident · 1 fatal · Field investigation · Final report · Aug 1, 2004 · N98SN · Destroyed
  > A loss of engine power due to high engine temperatures which resulted in a failure of the number three piston, the pilot's continued operation of the airplane with known high temperature problems, the pilot's poor inflight planning, and the pilot's failure to…
- [NTSB CHI03LA201](https://openairdocs.org/ntsb/CHI03LA201.md): McIlraith Sea Rey · Tomah, WI · Accident · 2 fatal · Limited investigation · Final report · Jul 5, 2003 · N216ST · Destroyed
  > The loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed resulting in a stall/spin during the forced landing.
- [NTSB CHI02FA247](https://openairdocs.org/ntsb/CHI02FA247.md): Cessna 172N · Shell Lake, WI · Accident · 1 fatal · Field investigation · Final report · Aug 14, 2002 · N4731D · Destroyed
  > The pilot's failure to refuel the airplane prior to departure leading to fuel exhaustion during the flight, the inadequate preflight/inflight planning, and the unsuitable terrain encountered by the pilot during the forced landing attempt. Contributing factors…
- [NTSB CHI02FA049](https://openairdocs.org/ntsb/CHI02FA049.md): Robinson R44 · Waukesha, WI · Accident · 1 fatal · Field investigation · Final report · Dec 13, 2001 · N7007F · Destroyed
  > The pilot's continued flight into adverse weather and not maintaining altitude/clearance from the static line during cruise flight. Factors were the static wire, the darkness of night, the low ceiling, and the vehicle.
- [NTSB CHI01FA329](https://openairdocs.org/ntsb/CHI01FA329.md): Cessna 414 Riley Super-8 · Marshfield, WI · Accident · 3 fatal · Field investigation · Final report · Sep 29, 2001 · N414NG · Destroyed
  > The pilot's failure to maintain adequate airspeed (Vmc) which resulted in a loss of control. Contributing factors were the improper in-flight planning/decision not to land at a closer airport and the lack of recent experience in multiengine airplanes by the…
- [NTSB CHI00FA262](https://openairdocs.org/ntsb/CHI00FA262.md): Bell OH-58C · Watertown, WI · Accident · 2 fatal · Field investigation · Final report · Aug 19, 2000 · N626SF · Destroyed
  > The spatial disorientation by the pilot during continued flight into instrument conditions and the inadequate surveillance by the operator. The inoperative attitude indicator and night conditions were contributing factors.
- [NTSB CHI00FA227](https://openairdocs.org/ntsb/CHI00FA227.md): Cessna 182A · Sauk City, WI · Accident · 4 fatal · Field investigation · Final report · Jul 28, 2000 · N4742D · Destroyed
  > VFR flight into IMC encountered by the pilot and exceeding the design limits of the aircraf. A factor was flight to a destination alternate not performed by the pilot.
- [NTSB CHI98FA349](https://openairdocs.org/ntsb/CHI98FA349.md): Beech 58 · Oakdale, WI · Accident · 3 fatal · Field investigation · Final report · Sep 16, 1998 · N4574Q · Destroyed
  > The installation of the door seal inflation system by company personnel. An additional cause was the emergency procedures not followed by the pilot-in-command. A contributing factor was the trees.
- [NTSB CHI98FA356](https://openairdocs.org/ntsb/CHI98FA356.md): Cessna 310R · Seymour Twp., WI · Accident · 2 fatal · Field investigation · Final report · Sep 1, 1998 · N5056J · 2 aircraft · Destroyed
  > the pilots of both airplanes not maintaining visual separation from the other airplane.
- [NTSB CHI98FA343](https://openairdocs.org/ntsb/CHI98FA343.md): Piper PA-22-150 · Beaver Dam, WI · Accident · 2 fatal · Field investigation · Final report · Aug 28, 1998 · N2931Z · Destroyed
  > The continued flight into adverse weather conditions and aircraft control not maintained by the pilot-in-command. Contributing factors were the improper preflight planning/preparation and lack of certification by the pilot-in-command in addition to the…
- [NTSB CHI98FA344](https://openairdocs.org/ntsb/CHI98FA344.md): Cessna A185F · Phillips, WI · Accident · 2 fatal · Field investigation · Final report · Aug 4, 1998 · N888KS · Destroyed
  > The pilot's failure to maintain adequate altitude/clearance with trees. Contributing factors were fog, rain showers, and the trees.
- [NTSB CHI98FA287](https://openairdocs.org/ntsb/CHI98FA287.md): Navion A · Coloma, WI · Accident · 1 fatal · Field investigation · Final report · Aug 1, 1998 · N8991H · Destroyed
  > Failure of the pilot to maintain proper altitude, and his failure to maintain adequate visual lookout to see and avoid obstructions. The transmission wire was a contributing factor.
- [NTSB CHI98FA153](https://openairdocs.org/ntsb/CHI98FA153.md): Commander 114-B · Lagrange, WI · Accident · 4 fatal · Field investigation · Final report · May 15, 1998 · N6059C · Destroyed
  > the pilot not maintaining aircraft control during cruise flight and exceeding the airplane's design stress limits. Factors in this accident was the pilot's lack of total experience in the airplane and the clouds.
- [NTSB CHI97FA245](https://openairdocs.org/ntsb/CHI97FA245.md): Peck Osprey 2 · Poygen, WI · Accident · 2 fatal · Field investigation · Final report · Aug 4, 1997 · N4442C · Destroyed
  > A loss of control in flight for undetermined reasons.
- [NTSB CHI97LA239](https://openairdocs.org/ntsb/CHI97LA239.md): Briegleb BG-12A · Superior, WI · Accident · 1 fatal · Limited investigation · Final report · Aug 2, 1997 · N5516V · Destroyed
  > the separation of the wing from the glider for undetermined reasons.
- [NTSB CHI97FA084](https://openairdocs.org/ntsb/CHI97FA084.md): Douglas DC-3C/BT-67R · Newton, WI · Accident · 4 fatal · Field investigation · Final report · Mar 15, 1997 · TZ389 · 2 aircraft · Destroyed
  > failure of the Beech A36 pilot to maintain clearance from the modified Douglas DC-3, while positioning the A36 for photography of the DC-3.
- [NTSB CHI96FA278](https://openairdocs.org/ntsb/CHI96FA278.md): Lancair 320 · Fond Du Lac, WI · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1996 · N320L · Destroyed
  > the fatigue in the propeller flange with soft material and oversized lightening holes. A factor was the pilot's inability to maintain control of the aircraft due to the exceeded weight and balance which led to a stall/spin.
- [NTSB CHI96FA113](https://openairdocs.org/ntsb/CHI96FA113.md): Piper PA-32 · Milwaukee, WI · Accident · 1 fatal · Field investigation · Final report · Jan 17, 1996 · N3326Q · Destroyed
  > Inadequate maintenance and inspection in that the Airworthiness Directive which applied to the fuel pump had not been complied with. A factor was the pilot was unable to reach land.
- [NTSB CHI96FA029](https://openairdocs.org/ntsb/CHI96FA029.md): Piper PA-28-151 · Fond Du Lac, WI · Accident · 2 fatal · Field investigation · Final report · Nov 11, 1995 · N161FS · Destroyed
  > the pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain altitude. Factors included the weather obscuration due to snow and fog, the dark night, and the pilot's lack of recent night flight time.
- [NTSB CHI95FA310](https://openairdocs.org/ntsb/CHI95FA310.md): Champion 7GCB · Howard, WI · Accident · 1 fatal · Field investigation · Final report · Sep 3, 1995 · N9838Y · Destroyed
  > a loss of engine power due to water-contaminated fuel and the pilot's inadequate preflight.
- [NTSB CHI95FA259](https://openairdocs.org/ntsb/CHI95FA259.md): Piper PA-28-181 · Fifield, WI · Accident · 2 fatal · Field investigation · Final report · Aug 4, 1995 · N4484F · Destroyed
  > the pilot's attempted visual flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control. A factor was the fog.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?fatal=1&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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?fatal=1&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
