# Final NTSB investigations, MN: Unknown

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 CEN23LA376](https://openairdocs.org/ntsb/CEN23LA376.md): Sixchuter Spirit XL · Hovland, MN · Accident · 1 fatal · Class 4 · Limited · Final report · Aug 18, 2023 · N538DR · Destroyed
  > The collision with the lake by a noncertificated pilot for reasons that could not be determined.
- [NTSB CEN20LA392](https://openairdocs.org/ntsb/CEN20LA392.md): Cessna 172 · Cottage Grove, MN · Accident · 3 fatal · Class 3 · Limited · Final report · Sep 13, 2020 · N8488L · Destroyed
  > A steep descent and impact with terrain for reasons that could not be determined based on the available information.
- [NTSB CEN18FA083](https://openairdocs.org/ntsb/CEN18FA083.md): Skwira Matthew J W-10 Tailwind · Sauk Centre, MN · Accident · 1 fatal · Field investigation · Final report · Jan 23, 2018 · N251WT · Substantial damage
  > Impact with terrain for reasons that could not be determined based on the available information.
- [NTSB CEN12FAMS1](https://openairdocs.org/ntsb/CEN12FAMS1.md): Piper PA-31-325 · Duluth, MN · Accident · 1 fatal · Missing aircraft · Final report · Jun 8, 2012 · N174BH · Substantial damage
  > Undetermined because the airplane was not found.
- [NTSB CHI03LA269](https://openairdocs.org/ntsb/CHI03LA269.md): Holden Pulsar · Willmar, MN · Accident · 2 fatal · Limited investigation · Final report · Aug 16, 2003 · N78DT · Destroyed
  > The pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.
- [NTSB CHI91FA116](https://openairdocs.org/ntsb/CHI91FA116.md): Mooney M-20C · Prior Lake, MN · Accident · 1 fatal · Field investigation · Final report · Mar 26, 1991 · N9692M · Destroyed
  > Failure to maintain airspeed while executing a forced landing. Factors related to the accident were the pilot's improper inflight planning/decision, and fuel exhaustion.
- [NTSB CHI90FA185](https://openairdocs.org/ntsb/CHI90FA185.md): Piper PA-28-140 · Grand Marais, MN · Accident · 3 fatal · Field investigation · Final report · Jul 14, 1990 · N6146W · Destroyed
  > Poor judgement of the pilot due to his impairment from consumption of alcohol, and his failure to maintain control of the aircraft. A factor related to the accident was: pilot fatigue due to lack of sleep.
- [NTSB CHI88FA153](https://openairdocs.org/ntsb/CHI88FA153.md): Piper PA-38-112 · Hamm Lake, MN · Accident · 2 fatal · Field investigation · Final report · Jul 3, 1988 · N2485N · Destroyed
  > Loss of control in flight, either by the student or by the instructor, at an altitude insufficient to allow for a recovery, by the flight instructor, before the resulting out of control descent caused the accident airplane to strike the terrain.
- [NTSB CHI87FA083](https://openairdocs.org/ntsb/CHI87FA083.md): Cessna 172N · Fergus Falls, MN · Accident · 4 fatal · Field investigation · Final report · Feb 12, 1987 · N734MV · Destroyed
  > Following a 1.5 hour personal flight at night, the aircraft crashed into the side of a low hill near the destination airport. Although the pilot had a total of 6 hours of night time, most of his solo night time was during this last flight. Hazy VFR conditions…
- [NTSB MKC78FA066](https://openairdocs.org/ntsb/MKC78FA066.md): Cessna 172N · Blaine, MN · Accident · 2 fatal · Closed · Aug 20, 1978 · N733SD · Destroyed
- [NTSB MKC67A0067](https://openairdocs.org/ntsb/MKC67A0067.md): Hughes 269B · Federal Dam, MN · Accident · 2 fatal · Closed · May 12, 1967 · N700 · Destroyed
- [NTSB UNK64X0416](https://openairdocs.org/ntsb/UNK64X0416.md): Taylorcraft BC12D · Henning Minn, MN · Accident · 2 fatal · Closed · Feb 1, 1964 · N96885 · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb-phases/990/cases?state=MN&status=final

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