# NTSB investigations, 2004, 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.

## Latest cases

- [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…
- [NTSB CHI05CA006](https://openairdocs.org/ntsb/CHI05CA006.md): Piper PA-28-160 · Altoona, WI · Accident · No injuries · Data collection · Final report · Oct 18, 2004 · N5520W · Substantial damage
  > The pilot's inadequate fuel management leading to the fuel starvation in the left tank during the flight's descent. A factor was the impacted power line.
- [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 CHI04CA191](https://openairdocs.org/ntsb/CHI04CA191.md): Aerostar RX-7 · Wausau, WI · Accident · Serious injuries · Data collection · Final report · Jul 25, 2004 · N7144Y · No damage
  > The pilot's inability to compensation for the turbulence and wind conditions. Contributing factors were the variable winds and the turbulence.
- [NTSB CHI04CA138](https://openairdocs.org/ntsb/CHI04CA138.md): Merkel Acro Sport II · Beloit, WI · Accident · No injuries · Data collection · Final report · Jun 5, 2004 · N796DM · Substantial damage
  > Inaccurate fuel consumption calculations which resulted in fuel exhaustion. Factors associated with the accident were the pilot's continued flight with an inoperable fuel quantity indicator and the wires which the airplane contacted during the forced landing.
- [NTSB CHI04LA104](https://openairdocs.org/ntsb/CHI04LA104.md): Cessna 172M · New Munster, WI · Accident · No injuries · Limited investigation · Final report · Apr 10, 2004 · N73213 · 2 aircraft · Substantial damage
  > Visual lookout not maintained by the pilots of both airplanes.
- [NTSB CHI04LA084](https://openairdocs.org/ntsb/CHI04LA084.md): Boeing 757-200 · Janesville, WI · Accident · Serious injuries · Limited investigation · Final report · Mar 1, 2004 · N516UA · No damage
  > The unexpected encounter with convective turbulence.

## 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 year(c."eventDate") = 2004
  AND 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?state=WI&year=2004

---
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.
