# NTSB investigations, 2002, MN: Approach

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 DCA03MA008](https://openairdocs.org/ntsb/DCA03MA008.md): Beech King Air 100 · Eveleth, MN · Accident · 8 fatal · Class 1 · Major · Final report · Oct 25, 2002 · N41BE · Destroyed
  > The flight crew's failure to maintain adequate airspeed, which led to an aerodynamic stall from which they did not recover.
- [NTSB CHI03LA008](https://openairdocs.org/ntsb/CHI03LA008.md): Cessna 175B · Lake Elmo, MN · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 2002 · N8161T · Destroyed
  > The pilot's failure to maintain aircraft control. Factors to the accident included the gusting wind conditions and the encountered windshear, which resulted in the inadvertent stall at a low altitude and subsequent in-flight collision with the transmission…
- [NTSB CHI03LA007](https://openairdocs.org/ntsb/CHI03LA007.md): Madewell EAA-Biplane-P · Forest Lake, MN · Accident · No injuries · Limited investigation · Final report · Oct 9, 2002 · N21WL · Substantial damage
  > The loss of engine power for undetermined reasons. A related factor was the swampy terrain.
- [NTSB CHI03LA005](https://openairdocs.org/ntsb/CHI03LA005.md): Cessna 172L · Fish Lake, MN · Accident · No injuries · Limited investigation · Final report · Oct 5, 2002 · N713SX · Substantial damage
  > The altitude/clearance not maintained while maneuvering on short final for landing on the lake. The glassy water was a contributing factor.
- [NTSB CHI03LA034](https://openairdocs.org/ntsb/CHI03LA034.md): Waco UPF-7 · Owatonna, MN · Accident · No injuries · Limited investigation · Final report · Oct 1, 2002 · N32039 · Substantial damage
  > The remedial action not performed by the certified flight instructor (CFI) during the bounced landing and directional control not maintained during the go-around by CFI. Contributing factors were the CFIs preflight planning/preparation in placing the dual…
- [NTSB CHI02LA299](https://openairdocs.org/ntsb/CHI02LA299.md): Piper PA-28-140 · Moorhead, MN · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 2002 · N9714W · Substantial damage
  > The inadequate fuel management by the certified flight instructor.
- [NTSB CHI02LA271](https://openairdocs.org/ntsb/CHI02LA271.md): Cessna 152 · Brooklyn Park, MN · Accident · No injuries · Limited investigation · Final report · Sep 5, 2002 · N48969 · Substantial damage
  > The pilot's inadequate preflight preparation/planning, which resulted in fuel exhaustion and the loss of engine power. A factor to the accident was the power transmission line and the trees.
- [NTSB CHI02LA209](https://openairdocs.org/ntsb/CHI02LA209.md): Beech S35 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Jul 24, 2002 · N6162G · Substantial damage
  > The proper glide path not obtained/maintained by the pilot. The approach lights were a contributing factor.
- [NTSB CHI02LA135](https://openairdocs.org/ntsb/CHI02LA135.md): Mooney M20F · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · May 10, 2002 · N976SB · Substantial damage
  > The pilot did not attain a proper climb rate during the go-around and the intentional wheels up landing. Factors associated with the accident were the inability of the pilot to maintain directional control of the airplane during the landing and the parked…

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

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=MN&year=2002

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