# NTSB investigations, 1997, WI: Landing

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 CHI98LA043](https://openairdocs.org/ntsb/CHI98LA043.md): Piper PA-28RT-201T · Janesville, WI · Accident · No injuries · Limited investigation · Final report · Nov 22, 1997 · N8315S · Substantial damage
  > the dual student's failure to obtain the proper touchdown point, and the instructor's failure to provide adequate supervision of the flight. Factors associated with the accident were: inadequate altitude, the student's diverted attention, the snowbank, and…
- [NTSB CHI98LA019](https://openairdocs.org/ntsb/CHI98LA019.md): Piper J3L-65 · Reeseville, WI · Accident · No injuries · Limited investigation · Final report · Oct 18, 1997 · N33252 · Substantial damage
  > failure of the normal braking system, due to a low level of brake fluid. Factors relating to the accident were: inadequate inspection of the aircraft by other maintenance personnel, the pilot's failure to check the brakes after brake maintenance/inspection,…
- [NTSB CHI98LA009](https://openairdocs.org/ntsb/CHI98LA009.md): Brown AIR Shark III · Green Bay, WI · Accident · No injuries · Limited investigation · Final report · Oct 6, 1997 · N42AE · Substantial damage
  > the pilot's improper flare, which resulted in a hard landing, subsequent failure of the left main landing gear, and his inability to maintain directional control. Factors related to the accident were: the runway light, and soft terrain.
- [NTSB CHI97LA243](https://openairdocs.org/ntsb/CHI97LA243.md): Cessna 182P · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Aug 3, 1997 · N125MW · Substantial damage
  > wake turbulence from another airplane encountered at an altitude which precluded regaining control of the airplane by the pilot.
- [NTSB CHI97LA246](https://openairdocs.org/ntsb/CHI97LA246.md): Young RV-4 · Sparta, WI · Accident · No injuries · Limited investigation · Final report · Aug 1, 1997 · N654Y · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and his improper recovery from a bounced landing, which resulted in an improper flare and hard landing. The gusty wind was a related factor.
- [NTSB CHI97LA242](https://openairdocs.org/ntsb/CHI97LA242.md): Boeing B75N1 · Lone Rock, WI · Accident · No injuries · Limited investigation · Final report · Jul 30, 1997 · N75939 · Substantial damage
  > a locked right brake which resulted in the pilot's inability to maintain direction control of the airplane during the landing roll.
- [NTSB CHI97LA141](https://openairdocs.org/ntsb/CHI97LA141.md): Cessna 172N · Madison, WI · Accident · No injuries · Limited investigation · Final report · May 16, 1997 · N738LM · Substantial damage
  > the pilot's inadequate compensation for wind conditions which resulted in a loss of directional control of the airplane. Factors associated with the accident were the gusty, crosswind conditions and the VASI lights.
- [NTSB CHI97LA131](https://openairdocs.org/ntsb/CHI97LA131.md): Piper PA-12 · Sheboygan, WI · Accident · No injuries · Limited investigation · Final report · May 13, 1997 · N712MW · Substantial damage
  > the pilot's failure to maintain control of the airplane during the landing roll. A factor associated with the accident was the sudden change in wind conditions.
- [NTSB CHI97LA112](https://openairdocs.org/ntsb/CHI97LA112.md): Luscombe 8E · Wautoma, WI · Accident · No injuries · Limited investigation · Final report · Apr 15, 1997 · N26SH · Substantial damage
  > the pilot's improper use of the throttle. Factors were a crosswind and soft terrain.
- [NTSB CHI97LA099](https://openairdocs.org/ntsb/CHI97LA099.md): Piper PA-22 · Oshkosh, WI · Accident · Minor injuries · Limited investigation · Final report · Apr 4, 1997 · N9231D · Substantial damage
  > the pilot's inadequate compensation for the wind conditions, and his failure to maintain proper runway alignment, which resulted in a subsequent nose over. The gusty crosswind condition was a related factor.

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

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

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