# NTSB investigations, 2002, MN: Takeoff

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 CHI03LA015](https://openairdocs.org/ntsb/CHI03LA015.md): Cessna 172 · St. Paul, MN · Accident · No injuries · Limited investigation · Final report · Oct 29, 2002 · N848SP · Substantial damage
  > The student pilot failed to maintain directional control. A factor was the runway sign.
- [NTSB CHI02LA276](https://openairdocs.org/ntsb/CHI02LA276.md): Cessna T188C · Olivia, MN · Accident · No injuries · Limited investigation · Final report · Sep 10, 2002 · N9432J · Substantial damage
  > The fouled spark plugs and the terrain condition encountered during the aborted takeoff.
- [NTSB CHI02IA270](https://openairdocs.org/ntsb/CHI02IA270.md): Fokker 100 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · Sep 5, 2002 · N1473K · Minor damage
  > The improper installation of the #2 main landing gear wheel, including the axle nut not being properly torqued and safetied, which resulted in the wheel separation during takeoff.
- [NTSB CHI02LA261](https://openairdocs.org/ntsb/CHI02LA261.md): Mooney M20C · Warroad, MN · Accident · No injuries · Limited investigation · Final report · Aug 25, 2002 · N9274V · Substantial damage
  > The loss of engine power due to the failure of the muffler baffles which blocked the exhaust system. A factor to the accident was the treeline.
- [NTSB CHI02LA235](https://openairdocs.org/ntsb/CHI02LA235.md): Cessna 185B · Brainerd, MN · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 2002 · N11LP · Substantial damage
  > The pilot's evasive maneuver to avoid obstacle clearance, resulting in a premature lift off with inadequate airspeed followed by a stall. The presence of the boat was a factor.
- [NTSB CHI02LA221](https://openairdocs.org/ntsb/CHI02LA221.md): Air Tractor 301 · Ulen, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 2002 · N3167P · Substantial damage
  > The pilot not performing an aborted takeoff. A factor was the soybean crop.
- [NTSB CHI02LA208](https://openairdocs.org/ntsb/CHI02LA208.md): Schweizer 269C-1 · Askov, MN · Accident · No injuries · Limited investigation · Final report · Jul 20, 2002 · N897TH · Substantial damage
  > Directional control not obtained/maintained during the aborted takeoff.
- [NTSB CHI02LA156](https://openairdocs.org/ntsb/CHI02LA156.md): Hale Kitfox Model III · Fairmont, MN · Accident · No injuries · Limited investigation · Final report · Jul 4, 2002 · N76WH · Substantial damage
  > Failure by the pilot to obtain adequate clearance from the tree line, as well as a failure to abort the takeoff in a timely manner. A contributing factor was the tree line.
- [NTSB CHI02LA141](https://openairdocs.org/ntsb/CHI02LA141.md): Cessna A185E · Grand Marais, MN · Accident · No injuries · Limited investigation · Final report · May 23, 2002 · N4747Q · Substantial damage
  > The pilot displayed inadequate compensation for the wind conditions that existed at the time of the accident and directional control was not maintained. A factor associated with the accident was the crosswind weather condition.
- [NTSB CHI02LA065](https://openairdocs.org/ntsb/CHI02LA065.md): Piper PA-18 · Clear Lake, MN · Accident · No injuries · Limited investigation · Final report · Jan 20, 2002 · N7113K · Substantial damage
  > The loss of engine power for undetermined reasons and the unsuitable terrain for the forced landing. Factors were the low altitude and the fences.
- [NTSB CHI02LA062](https://openairdocs.org/ntsb/CHI02LA062.md): Wolter Avid Flyer · Rush City, MN · Accident · 1 fatal · Limited investigation · Final report · Jan 12, 2002 · N4047M · Substantial damage
  > The unqualified pilot inadvertently stalled the airplane. A factor was the unqualified pilot's lack of total experience.

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

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