# 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 2 of 12 · 580 cases

## Cases, newest first

- [NTSB CEN14CA515](https://openairdocs.org/ntsb/CEN14CA515.md): Cessna 150J · Brookfield, WI · Accident · Minor injuries · Data collection · Final report · Sep 22, 2014 · N50889 · Substantial damage
  > The pilot's inadequate maintenance and preflight of the airplane which resulted in a total loss of engine power due to oil starvation.
- [NTSB CEN14LA241](https://openairdocs.org/ntsb/CEN14LA241.md): Kinsler Arthur Paul Kinsler Lancair/Mkii · Crivitz, WI · Accident · Serious injuries · Limited investigation · Final report · May 6, 2014 · N246AK · Substantial damage
  > The improper installation of the hose fuel fitting, which resulted in the fitting becoming disconnected and the subsequent loss of engine power due to fuel starvation.
- [NTSB CEN14IA085](https://openairdocs.org/ntsb/CEN14IA085.md): Beech E90 · Eau Claire, WI · Incident · No injuries · Incident investigation · Final report · Dec 11, 2013 · N60BA · Minor damage
  > The failure of the copilot’s windshield inner layer due to a peel chip that developed as a result of mechanical and thermal expansion stresses.
- [NTSB CEN14LA036](https://openairdocs.org/ntsb/CEN14LA036.md): Cessna 182L · Superior, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2013 · N70520 · 2 aircraft · Destroyed
  > The failure of the pilot who was flying the trail airplane to maintain separation from the lead airplane. Contributing to the accident was the inadequate pilot training for formation skydiving operations.
- [NTSB CEN13FA440](https://openairdocs.org/ntsb/CEN13FA440.md): Phelps Kitfox III · Oshkosh, WI · Accident · No injuries · Field investigation · Final report · Jul 28, 2013 · N873RX · Substantial damage
  > The degraded fuel line, which prevented fuel from the left tank from reaching the header tank and resulted in the loss of engine power due to fuel starvation.
- [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 CEN13LA330](https://openairdocs.org/ntsb/CEN13LA330.md): Cessna TP206B · Sturgeon Bay, WI · Accident · No injuries · Limited investigation · Final report · Jun 1, 2013 · N3350J · Substantial damage
  > The pilot’s improper reselection of the left fuel tank, which had an obstructed vent system and resulted in a total loss of engine power during the approach for landing.
- [NTSB CEN13CA175](https://openairdocs.org/ntsb/CEN13CA175.md): Cessna 177 · Elcho, WI · Accident · Minor injuries · Data collection · Final report · Feb 17, 2013 · N30227 · Substantial damage
  > The pilot's inadequate preflight and in-flight fuel management, which led to a total loss of engine power due to fuel exhaustion.
- [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 CEN12LA582](https://openairdocs.org/ntsb/CEN12LA582.md): Waco UPF-7 · Jim Falls, WI · Accident · No injuries · Limited investigation · Final report · Aug 27, 2012 · N32011 · Substantial damage
  > The blockage of the right fuel tank vent, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN12LA539](https://openairdocs.org/ntsb/CEN12LA539.md): Gn-1 Aircamper Mathes · Burlington, WI · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 2012 · N31TM · Substantial damage
  > The pilot's improper installation of the propeller bolts, which resulted in the in-flight separation of the propeller.
- [NTSB CEN12LA182](https://openairdocs.org/ntsb/CEN12LA182.md): Piper PA-22-150 · East Troy, WI · Accident · No injuries · Limited investigation · Final report · Mar 5, 2012 · N6849B · Substantial damage
  > The pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [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 CEN12LA074](https://openairdocs.org/ntsb/CEN12LA074.md): Beech S35 · Elkhart Lake, WI · Accident · No injuries · Limited investigation · Final report · Nov 15, 2011 · N5858S · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN12LA060](https://openairdocs.org/ntsb/CEN12LA060.md): Cessna 180 · Eau Claire, WI · Accident · No injuries · Limited investigation · Final report · Nov 12, 2011 · N3606C · Substantial damage
  > The pilot’s disorientation during a night flight, which resulted in an off-airport landing, and his inadequate directional control during the landing roll. Contributing to the accident was the loss of the airplane’s electrical system power.
- [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 CEN11LA430](https://openairdocs.org/ntsb/CEN11LA430.md): Piper PA-28-180 · Barron, WI · Accident · No injuries · Limited investigation · Final report · Jun 29, 2011 · N9002J · Substantial damage
  > The loss of engine power, which resulted from fuel exhaustion due to the pilot's inadequate in-flight planning.
- [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 CEN11LA085](https://openairdocs.org/ntsb/CEN11LA085.md): Embraer EMB-135LR · Milwaukee, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 30, 2010 · N12530 · No damage
  > An in-flight encounter with turbulence during cruise flight, which resulted in a serious injury to a flight attendant.
- [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 CEN10CA525](https://openairdocs.org/ntsb/CEN10CA525.md): Weber Acro Sport II · Plum City, WI · Accident · Minor injuries · Data collection · Final report · Sep 5, 2010 · N819WW · Substantial damage
  > The pilot’s improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN10LA433](https://openairdocs.org/ntsb/CEN10LA433.md): Beech H35 · Green Lake, WI · Accident · No injuries · Limited investigation · Final report · Jul 25, 2010 · N5443D · Substantial damage
  > A total loss of engine power during descent due to the overhaul facility’s inadequate maintenance.
- [NTSB CEN10LA253](https://openairdocs.org/ntsb/CEN10LA253.md): Dearmond Clint RV-6A · Sheboygan, WI · Accident · No injuries · Limited investigation · Final report · May 16, 2010 · N1257E · Substantial damage
  > The loss of engine power due to a fuse failure in the ignition system.
- [NTSB CEN10LA123](https://openairdocs.org/ntsb/CEN10LA123.md): Cessna 172N · Genoa City, WI · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 2010 · N24CV · Substantial damage
  > A total loss of engine power due to the failure of the bolts that held in place the connecting rods to the engine's No. 3 and No. 4 cylinders as a result of the engine overhaul facility's improper installation of the bolts during a recent overhaul.
- [NTSB CEN10IA059](https://openairdocs.org/ntsb/CEN10IA059.md): Piper PA-46-310P · Elk Mound, WI · Incident · No injuries · Incident investigation · Final report · Nov 13, 2009 · N667PC · Minor damage
  > The loss of engine power due to component failure from excessive heating of the engine connecting rod journals.
- [NTSB CEN09LA487](https://openairdocs.org/ntsb/CEN09LA487.md): Cessna 177RG · Black River Falls, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 2009 · N2108Q · Substantial damage
  > The loss of engine power during cruise due to the number two cylinder piston connecting rod failure for undetermined reasons.
- [NTSB CEN09CA477](https://openairdocs.org/ntsb/CEN09CA477.md): Cessna A185F · River Falls, WI · Accident · No injuries · Data collection · Final report · Jul 30, 2009 · N989DM · Substantial damage
  > The pilot not checking the security of the fuel caps prior to flight leading to fuel exhaustion and the subsequent non-mechanical loss of engine power during descent.
- [NTSB CEN09CA407](https://openairdocs.org/ntsb/CEN09CA407.md): Remos G-3/6000 · Oshkosh, WI · Accident · No injuries · Data collection · Final report · Jul 1, 2009 · N261RA · Substantial damage
  > A total loss of total engine power due to fuel exhaustion as a result of the instructor pilot's inadequate preflight inspection. Contributing to the accident was the creased fuel quantity tube.
- [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 CHI08LA230](https://openairdocs.org/ntsb/CHI08LA230.md): Cessna 172RG · Tomahawk, WI · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 2008 · N6520R · Substantial damage
  > A total loss of engine power due to a loss of all of the engine's oil as a result of the safety wire on the governor idler gear shaft's oil plug breaking, leading to the oil plug coming unscrewed. Contributing to the accident was the lack of a suitable area…
- [NTSB CHI08CA203](https://openairdocs.org/ntsb/CHI08CA203.md): Enstrom F28F · Amberg, WI · Accident · No injuries · Data collection · Final report · Jul 23, 2008 · N8626E · Substantial damage
  > The unsuitable terrain encountered by the pilot during a forced landing following a loss of engine power due to a cylinder head separation. Contributing to the accident was the tree.
- [NTSB CHI08CA188](https://openairdocs.org/ntsb/CHI08CA188.md): Cessna 177A · Rhinelander, WI · Accident · No injuries · Data collection · Final report · Jul 1, 2008 · N2295Y · Substantial damage
  > The loss of engine power for an undetermined reason. A factor was the berm encountered during the forced landing.
- [NTSB CHI08CA145](https://openairdocs.org/ntsb/CHI08CA145.md): Cessna 150 · New Berlin, WI · Accident · No injuries · Data collection · Final report · May 30, 2008 · N3130V · Substantial damage
  > The loss of engine power due to the pilot's failure to use the carburetor heat during the flight. Contributing factors included the carburetor icing conditions and the trees.
- [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 CHI08CA114](https://openairdocs.org/ntsb/CHI08CA114.md): Bardouche Quad City Ultralight · Pulaski, WI · Accident · Minor injuries · Data collection · Final report · Apr 4, 2008 · N423V · Substantial damage
  > The loss of engine power during cruise due to the separation of the spark plug because of the loose threads. Contributing to the accident was trees.
- [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 CHI08CA019](https://openairdocs.org/ntsb/CHI08CA019.md): Bell 47G-2A · Wautoma, WI · Accident · No injuries · Data collection · Final report · Oct 17, 2007 · N73223 · Substantial damage
  > The pilot's failure to maintain control of the helicopter resulting from a distraction in the cockpit. A contributing factor was the distraction due to the dog in the cockpit.
- [NTSB CHI07LA204](https://openairdocs.org/ntsb/CHI07LA204.md): Cessna 182K · Edgerton, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 2007 · N2579R · Substantial damage
  > The reported non-mechanical loss of engine power for undetermined reasons during cruise and the excessive airspeed the pilot maintained during the approach for the forced landing. Factors were the loss of electrical power during cruise and the high vegetation…
- [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 CHI06LA031](https://openairdocs.org/ntsb/CHI06LA031.md): Piper PA-28-181 · Milwaukee, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 2005 · N2241P · Substantial damage
  > The loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement. Factors to the accident included the pilot's impairment due to alcohol, the FAA's inadequate oversight when it issued the pilot a second class medical certificate,…
- [NTSB ENG06IA001](https://openairdocs.org/ntsb/ENG06IA001.md): Cessna Citation 650 · Madison, WI · Incident · No injuries · Incident investigation · Final report · Oct 9, 2005 · N175DP · Minor damage
  > The inadequate design of the engine's interstage transition duct that yielded after the LPT stage 3 blades had separated and allowed the uncontained release of turbine debris. A contributing factor was the separation of a turbine blade.
- [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 CHI05FA077](https://openairdocs.org/ntsb/CHI05FA077.md): Bombardier CL-600-2B19 · Milwaukee, WI · Accident · No injuries · Field investigation · Final report · Mar 12, 2005 · N8932C · Substantial damage
  > the captain's failure to adequately compensate for the crosswind conditions, and his failure to maintain directional control during landing. Contributing factors include the captain's failure to land at the nearest suitable airport after an in-flight…
- [NTSB CHI05LA067](https://openairdocs.org/ntsb/CHI05LA067.md): Cessna 152 · Sturtevant, WI · Accident · No injuries · Limited investigation · Final report · Feb 3, 2005 · N68714 · Substantial damage
  > The pilot's failure to identify the electrical system failure and to maintain adequate airspeed during the landing approach. Factors associated with the accident were the electrical system failure, the snow covered terrain, and the pilot's lack of experience.
- [NTSB CHI05CA052](https://openairdocs.org/ntsb/CHI05CA052.md): Piper PA-32R-300 · Cumberland, WI · Accident · Minor injuries · Data collection · Final report · Jan 12, 2005 · N427KP · Substantial damage
  > The pilot could not maintain altitude or airspeed due to airframe icing as a result of the pilot flying into known adverse weather and failing to comply with the airplane's icing limitation. Factors included the icing conditions and the ice accumulation on…
- [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 CHI05CA032](https://openairdocs.org/ntsb/CHI05CA032.md): Olson Sonex · Oconomowoc, WI · Accident · Serious injuries · Data collection · Final report · Nov 21, 2004 · N478SX · Substantial damage
  > The loss of engine power due to a fatigue fracture of the crankshaft. An additional cause to the accident was the pilot/builder's failure to verify the dimensions of the shrink-fit crankshaft components prior reassembling the engine. A factor to the accident…
- [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…

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

## 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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=2&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.
