# NTSB investigations, 2000, MN: 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 CHI01LA045](https://openairdocs.org/ntsb/CHI01LA045.md): Larson Aero COMP-6 · Brainerd, MN · Accident · No injuries · Limited investigation · Final report · Dec 8, 2000 · N4334Z · Substantial damage
  > The pilot's inadequate preflight of the airplane which resulted in fuel exhaustion. Factors associated with the accident were the loose fuel cap and the snow covered terrain.
- [NTSB CHI00LA274](https://openairdocs.org/ntsb/CHI00LA274.md): Widner Pietenpol Aircamper · Andover, MN · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 2000 · N89JW · Destroyed
  > The trees and the unsuitable terrain for landing encountered during the forced landing. Factors were the side slip to avoid the trees initiated by the pilot, the fractured piston, and the cracked cylinder.
- [NTSB CHI00FA185](https://openairdocs.org/ntsb/CHI00FA185.md): Piper PA-30 · Duluth, MN · Accident · 3 fatal · Field investigation · Final report · Jul 8, 2000 · N7213Y · Destroyed
  > loss of control in flight for undetermined reason(s).
- [NTSB CHI00FA180](https://openairdocs.org/ntsb/CHI00FA180.md): Cessna 152 · Brownton, MN · Accident · 1 fatal · Field investigation · Final report · Jul 2, 2000 · N757SL · Destroyed
  > In flight collision with the terrain for undetermined reason.
- [NTSB CHI00LA179](https://openairdocs.org/ntsb/CHI00LA179.md): Norton Volksplane VP-1 · Waconia, MN · Accident · 1 fatal · Limited investigation · Final report · Jul 1, 2000 · N256DN · Destroyed
  > the inadvertent stall by the pilot. The low attitude at the time of the stall was a contributing factor.
- [NTSB CHI00LA211](https://openairdocs.org/ntsb/CHI00LA211.md): Piper PA-36-285 · Saint Vincent, MN · Accident · No injuries · Limited investigation · Final report · Jun 30, 2000 · N11A · Substantial damage
  > the failure of the engine reduction gear assembly. Factors were the low altitude when the failure occurred and the crops.
- [NTSB CHI00FA111](https://openairdocs.org/ntsb/CHI00FA111.md): Bell 222U · St. Paul, MN · Accident · No injuries · Field investigation · Final report · Apr 14, 2000 · N225LL · Substantial damage
  > The loss of clamp-up force between the transmission case and the pylon mounted actuator support assembly which resulted in fatigue failure of the threaded studs and dowel pins, the failure of the flight control system, helicopter control not being possible…
- [NTSB CHI00LA103](https://openairdocs.org/ntsb/CHI00LA103.md): Piper PA-28-140 · Pine City, MN · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 2000 · N54454 · Substantial damage
  > A loss of engine power due to the failure of the number four cylinder's exhaust valve spring and exhaust valve. Contributing to the accident were, the barbwire fence and the clump of high vegetation encountered by the airplane.

## 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") = 2000
  AND c."eventStateOrRegion" = 'MN' 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=MN&year=2000

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