# NTSB investigations, WI: Initial climb

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 8 · 394 cases

## Latest cases

- [NTSB CEN26LA277](https://openairdocs.org/ntsb/CEN26LA277.md): Taylorcraft BC12-D · Boyceville, WI · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 2, 2026 · N43665 · Substantial damage
  > On August 2, 2026, about 1223 central daylight time, a Taylorcraft BC12-D airplane, N43665 was substantially damaged when it was involved in an accident near Boyceville, Wisconsin. Both the pilot and passenger were seriously injured. The airplane was operated…
- [NTSB CEN24LA337](https://openairdocs.org/ntsb/CEN24LA337.md): Piper PA-28-140 · East Troy, WI · Accident · No injuries · Class 3 · Limited · Final report · Sep 2, 2024 · N32435 · Substantial damage
  > The pilot/mechanic’s improper torquing of the fuel hose fitting while replacing the fuel pump, which allowed air to enter the fuel system and resulted in a loss of engine power during initial climb. Contributing to the accident was the pilot/mechanic’s…
- [NTSB CEN24LA245](https://openairdocs.org/ntsb/CEN24LA245.md): Raytheon A36 · Land O' Lakes, WI · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 30, 2024 · N47RT · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB CEN23FA320](https://openairdocs.org/ntsb/CEN23FA320.md): Heath V-Strut · Oshkosh, WI · Accident · Minor injuries · Class 3 · Field · Final report · Jul 25, 2023 · N9549 · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB CEN23LA272](https://openairdocs.org/ntsb/CEN23LA272.md): Six Chuter SR7 XL · Chetek, WI · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 2, 2023 · N6365A · Substantial damage
  > The pilot’s failure to maintain aircraft control during initial climb which resulted in an impact with a pole, trees, and terrain.
- [NTSB CEN23LA250](https://openairdocs.org/ntsb/CEN23LA250.md): Champion 7EC · Waunakee, WI · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 21, 2023 · N80461 · Substantial damage
  > A total loss of engine power during the initial takeoff climb due to a worn manual fuel primer pump locking mechanism, which resulted in an unlocked primer and an overly rich fuel mixture.
- [NTSB CEN23LA133](https://openairdocs.org/ntsb/CEN23LA133.md): Beech F33A · Hilbert, WI · Accident · No injuries · Class 4 · Limited · Final report · Feb 6, 2023 · N1074W · Substantial damage
  > The pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN22LA258](https://openairdocs.org/ntsb/CEN22LA258.md): Eurocopter Deutschland EC 135 P2+ · Waukesha, WI · Accident · No injuries · Class 3 · Limited · Final report · Jun 18, 2022 · N226SA · Substantial damage
  > The separation and subsequent ingestion of the fenestron fairing cover into the fenestron blades for undetermined reasons.
- [NTSB CEN21FA345](https://openairdocs.org/ntsb/CEN21FA345.md): Piper J3C-65 · Hartford, WI · Accident · 1 fatal · Class 3 · Field · Final report · Jul 31, 2021 · N42522 · Substantial damage
  > The flight crew’s exceedance of the airplane’s critical angle of attack during a simulated engine failure during initial climb after takeoff, which led to an aerodynamic stall/spin and loss of control. Contributing to the severity of the occupants’ injuries…
- [NTSB CEN21FA130](https://openairdocs.org/ntsb/CEN21FA130.md): Velocity Vtwin · Janesville, WI · Accident · 2 fatal · Class 3 · Field · Final report · Feb 16, 2021 · N13VT · Substantial damage
  > The exceedance of the maximum airspeed for flight with the landing gear extended, which resulted in a separation of the right main landing gear door that subsequently impacted the right propeller and resulted in a total loss of right engine power.…
- [NTSB CEN20LA329](https://openairdocs.org/ntsb/CEN20LA329.md): Piper PA22 · Burlington, WI · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 9, 2020 · N6849B · Substantial damage
  > A partial loss of engine power due to the formation of carburetor ice while on the ground, which resulted in reduced climb capability and impact with trees during the initial climb.
- [NTSB CEN19FA276](https://openairdocs.org/ntsb/CEN19FA276.md): Shirley Carl Sportcopter Vortex · Viroqua, WI · Accident · 1 fatal · Class 2 · Field · Final report · Aug 19, 2019 · N634SC · Destroyed
  > The noncertificated pilot's loss of control of the gyrocopter after a total loss of engine power due to seizure of the crankshaft bearings. Contributing to the accident were the insufficient maintenance of the engine and the pilot's lack of gyrocopter flight…
- [NTSB WPR18FA200](https://openairdocs.org/ntsb/WPR18FA200.md): De Havilland DH112 Venom · Sheboygan, WI · Accident · 1 fatal · Field investigation · Final report · Jul 20, 2018 · N747J · Destroyed
  > The airplane's encounter with wake turbulence from the lead airplane in the formation flight, which resulted in a compressor stall and the airplane's subsequent inability to climb.
- [NTSB CEN16CA383](https://openairdocs.org/ntsb/CEN16CA383.md): Mooney M20D · Brodhead, WI · Accident · Minor injuries · Data collection · Final report · Sep 11, 2016 · N6919U · Substantial damage
  > The pilot's loss of airplane control during initial climb due to an excessively nose-high attitude. Contributing to the accident was the pilot's failure to properly set the elevator trim before takeoff in accordance with the Before Takeoff checklist.
- [NTSB CEN16LA296](https://openairdocs.org/ntsb/CEN16LA296.md): Ryan Navion B · Manitowoc, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 2016 · N5294K · Substantial damage
  > A leak in the gascolator due to degraded rubber gaskets, which allowed air to enter the fuel system and resulted in fuel starvation and a total loss of engine power during takeoff.
- [NTSB GAA16CA067](https://openairdocs.org/ntsb/GAA16CA067.md): Taylorcraft BC12 65 · New Lisbon, WI · Accident · Minor injuries · Data collection · Final report · Nov 2, 2015 · N33939 · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack, resulting in an inadvertent aerodynamic stall and impact with terrain.
- [NTSB CEN15LA279](https://openairdocs.org/ntsb/CEN15LA279.md): Mooney M20K · Sheboygan, WI · Accident · No injuries · Limited investigation · Final report · Jun 21, 2015 · N1168Z · Substantial damage
  > Oil starvation due to preignition in the No. 5 cylinder as a result of failed spark plugs; the top and sides of the piston head were eroded, which allowed the exhaust gases caused by the preignition to pressurize the crankcase and force engine oil out of the…
- [NTSB CEN15LA242](https://openairdocs.org/ntsb/CEN15LA242.md): Bellanca 8KCAB · Superior, WI · Accident · No injuries · Limited investigation · Final report · May 27, 2015 · N102EC · Substantial damage
  > A stuck aileron due to a battery that had become jammed in the aileron bell crank.
- [NTSB CEN13CA543](https://openairdocs.org/ntsb/CEN13CA543.md): Taylorcraft BL 65 · Chippewa Falls, WI · Accident · Serious injuries · Data collection · Final report · Sep 8, 2013 · N23683 · Substantial damage
  > The loss of engine power after takeoff due to carburetor icing.
- [NTSB CEN13LA502](https://openairdocs.org/ntsb/CEN13LA502.md): Anderas Tiger Moth R80 · New Franken, WI · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 2013 · N927TM · Substantial damage
  > The loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13LA460](https://openairdocs.org/ntsb/CEN13LA460.md): Snyder Todd W Titan Tornado 1 · Wild Rose, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2013 · N70786 · Substantial damage
  > The improperly secured spark plug, which resulted in a total loss of engine power.
- [NTSB CEN13LA216](https://openairdocs.org/ntsb/CEN13LA216.md): Cessna 172 · Wonewoc, WI · Accident · No injuries · Limited investigation · Final report · Apr 1, 2013 · N8033B · Substantial damage
  > The restricted vented fuel cap and obstructed fuel vent lines, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN12LA530](https://openairdocs.org/ntsb/CEN12LA530.md): Williams John T-51 Mustang · Oshkosh, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 2012 · N151TA · Substantial damage
  > The separation of an engine cooling hose from the radiator.
- [NTSB CEN12CA469](https://openairdocs.org/ntsb/CEN12CA469.md): Purtee Kevin M Pietenpol Aircamper · Broadhead, WI · Accident · Serious injuries · Data collection · Final report · Jul 22, 2012 · N899KP · Substantial damage
  > The pilot's failure to adequately remove water-contaminated fuel during the preflight inspection, which resulted in a total loss of engine power during takeoff, and his decision to initiate a turn back to the runway with insufficient airspeed, which resulted…
- [NTSB CEN11FA562](https://openairdocs.org/ntsb/CEN11FA562.md): Air Tractor AT-301 · Nekoosa, WI · Accident · No injuries · Field investigation · Final report · Aug 4, 2011 · N4345S · Substantial damage
  > A total loss of engine power during initial climb for undetermined reasons.
- [NTSB CEN11LA536](https://openairdocs.org/ntsb/CEN11LA536.md): Bellanca 14-13 · Stoughton, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2011 · N74260 · Substantial damage
  > The pilot’s improper preflight planning and his failure to gain proper airspeed during takeoff from a grass airstrip resulting in a stall, the loss of control, and subsequent impact with the trees. Contributing to the accident was the pilot operating the…
- [NTSB CEN11LA506](https://openairdocs.org/ntsb/CEN11LA506.md): Gottschalk John R John 1 · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Jul 25, 2011 · N559RD · Substantial damage
  > The pilot's inadequate preflight planning, which led to the power required exceeding the power available and resulted in a loss of lift and subsequent hard landing.
- [NTSB CEN11LA522](https://openairdocs.org/ntsb/CEN11LA522.md): Cessna 172B · Middleton, WI · Accident · No injuries · Limited investigation · Final report · Jul 23, 2011 · N7624X · Substantial damage
  > The total loss of engine power during climb after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN11FA433](https://openairdocs.org/ntsb/CEN11FA433.md): Klemp Gregory J Challenger II · Neshkoro, WI · Accident · 1 fatal · Field investigation · Final report · Jun 30, 2011 · N12911 · Substantial damage
  > The total loss of engine power during the initial climb due to a cold seizure as a result of a broken fan V-belt. Contributing to the accident was the passenger's interference with the flight controls during the forced landing.
- [NTSB CEN11LA448](https://openairdocs.org/ntsb/CEN11LA448.md): Cessna 140 · Burlington, WI · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2011 · N2332V · Substantial damage
  > The improper installation of the fuel selector indicator handle, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN11LA429](https://openairdocs.org/ntsb/CEN11LA429.md): Keesler W8 Tailwind · Oshkosh, WI · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 2011 · N56PK · Substantial damage
  > The loss of engine power during initial climb for undetermined reasons.
- [NTSB CEN11FA310](https://openairdocs.org/ntsb/CEN11FA310.md): Jurmu Stol CH701 · Pulaski, WI · Accident · 1 fatal · Field investigation · Final report · Apr 29, 2011 · N701MJ · Substantial damage
  > The pilot did not maintain control of the airplane during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of recent flight experience.
- [NTSB CEN09CA537](https://openairdocs.org/ntsb/CEN09CA537.md): Rewey William M CH 801 · Cottage Grove, WI · Accident · No injuries · Data collection · Final report · Aug 23, 2009 · N171WR · Substantial damage
  > A total loss of engine power during initial climb due to fuel starvation from a blocked fuel screen that resulted from the pilot/owner's inadequate inspection and maintenance of the fuel system.
- [NTSB CEN09LA263](https://openairdocs.org/ntsb/CEN09LA263.md): Laseure Sonerai II · Grantsburg, WI · Accident · 1 fatal · Limited investigation · Final report · Apr 22, 2009 · N232PE · Destroyed
  > The pilot's failure to maintain airspeed during initial climb which resulted in a stall/spin. Contributing to the accident was the degraded engine performance.
- [NTSB CHI08CA287](https://openairdocs.org/ntsb/CHI08CA287.md): Cessna 172M · Three Lakes, WI · Accident · Minor injuries · Data collection · Final report · Sep 1, 2008 · N12809 · Substantial damage
  > The pilot's failure to attain sufficient altitude to avoid the trees during initial climb. Contributing to the accident were the pilot's failure to ensure the security of the entrance door before takeoff and the unintentional opening of the door.
- [NTSB CHI08FA222](https://openairdocs.org/ntsb/CHI08FA222.md): Piper PA-22 · Oshkosh, WI · Accident · Minor injuries · Field investigation · Final report · Jul 30, 2008 · N3671A · Substantial damage
  > The pilot's failure to maintain adequate airspeed while taking off in gusting winds, which resulted in an aerodynamic stall and subsequent loss of control.
- [NTSB CHI08CA226](https://openairdocs.org/ntsb/CHI08CA226.md): American AA-1A · Grantsburg, WI · Accident · Minor injuries · Data collection · Final report · Jul 22, 2008 · N9483L · Substantial damage
  > A loss of engine power for an undetermined reason.
- [NTSB CHI08FA135](https://openairdocs.org/ntsb/CHI08FA135.md): Piper PA-28-140 · Stevens Point, WI · Accident · 2 fatal · Field investigation · Final report · May 12, 2008 · N1813T · Substantial damage
  > The partial loss of engine power for undetermined reasons.
- [NTSB CHI08CA127](https://openairdocs.org/ntsb/CHI08CA127.md): Cessna 140 · Burlington, WI · Accident · Minor injuries · Data collection · Final report · May 9, 2008 · N89307 · Substantial damage
  > A loss of engine power for undetermined reasons. Contributing to the accident was the low altitude at the time of the loss of engine power.
- [NTSB CHI07LA238](https://openairdocs.org/ntsb/CHI07LA238.md): Swanson Aventura II · Lakewood, WI · Accident · 1 fatal · Limited investigation · Final report · Jul 28, 2007 · N914JS · Substantial damage
  > The pilot's excessive pull up, his not maintaining airspeed, and the inadvertent stall resulting in the loss of control. A factor contributing to the accident was the trees.
- [NTSB CHI07LA177](https://openairdocs.org/ntsb/CHI07LA177.md): Cessna 172M · Rio Creek, WI · Accident · Serious injuries · Limited investigation · Final report · Jun 24, 2007 · N4422R · Substantial damage
  > The pilot's improper aircraft weight and balance, and his failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb.
- [NTSB CHI05CA204](https://openairdocs.org/ntsb/CHI05CA204.md): Wilson Acrolite 1T · Oshkosh, WI · Accident · Minor injuries · Data collection · Final report · Jul 29, 2005 · C-IAVT · Substantial damage
  > The partial loss of engine power due to an obstructed carburetor fuel metering jet. Factors to the accident included the low altitude at which the loss of engine power occurred, the contamination of the fuel system from degraded automobile-style fuel lines,…
- [NTSB CHI04FA290](https://openairdocs.org/ntsb/CHI04FA290.md): Beech B95A · Burlington, WI · Accident · 3 fatal · Field investigation · Final report · Sep 30, 2004 · N1703Y · Destroyed
  > The improper maintenance of the fuel servo resulting in a loose adjustment nut and subsequent failure of the fuel injection servo which led to a complete loss of power on the right engine. Other causes were the pilot's failure to obtain or maintain minimum…
- [NTSB CHI04LA265](https://openairdocs.org/ntsb/CHI04LA265.md): Kenny Mariner-MF Boat · Eagle River, WI · Accident · Serious injuries · Limited investigation · Final report · Sep 21, 2004 · N744PK · Substantial damage
  > The pilot's inability to maintain control of the aircraft during flight for undetermined reasons.
- [NTSB CHI04LA253](https://openairdocs.org/ntsb/CHI04LA253.md): Williams Glastar GS-1 · Hayward, WI · Accident · Serious injuries · Limited investigation · Final report · Sep 10, 2004 · N501YR · Substantial damage
  > The pilot's failure to adequately compensate for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusty wind condition.
- [NTSB CHI04LA167](https://openairdocs.org/ntsb/CHI04LA167.md): Beech 200 · Green Bay, WI · Accident · No injuries · Limited investigation · Final report · Jun 30, 2004 · N432FA · Substantial damage
  > The loss of engine power after takeoff for an undetermined reason.
- [NTSB CHI04LA147](https://openairdocs.org/ntsb/CHI04LA147.md): North American T-28C · Manitowoc, WI · Accident · No injuries · Limited investigation · Final report · Jun 4, 2004 · N404DK · Substantial damage
  > Failure of the number 4 piston articulating rod resulting in a complete loss of engine power during initial climb. The ditch was a contributing factor.
- [NTSB CHI04CA118](https://openairdocs.org/ntsb/CHI04CA118.md): Piper PA-12 · Hartford, WI · Accident · No injuries · Data collection · Final report · May 9, 2004 · N2368M · Substantial damage
  > The loss of engine power for undetermined reasons. A factor to the accident was the soft terrain encountered during the forced landing.
- [NTSB CHI03FA239](https://openairdocs.org/ntsb/CHI03FA239.md): Gerlach Skyraider II · Oshkosh, WI · Accident · No injuries · Field investigation · Final report · Aug 2, 2003 · N1068S · Substantial damage
  > The pilot's failure to abort the takeoff, his improper use of flaps during the takeoff, and his failure to attain sufficient airspeed resulting in an inadvertent stall and subsequent impact with a road.
- [NTSB CHI03IA153](https://openairdocs.org/ntsb/CHI03IA153.md): Beech 1900D · Milwaukee, WI · Incident · No injuries · Incident investigation · Final report · Jun 7, 2003 · N901SK · Minor damage
  > Failure of the aileron sprocket assembly at the sprocket-to-shaft braze joint. Contributing factors were the improper braze procedure used by the part manufacturer at the time of fabrication which resulted in an inferior quality joint and the inadequate…

Next page: https://openairdocs.org/ntsb-phases/350/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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/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.