# NTSB investigations, 2011, MN: 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 CEN12LA113](https://openairdocs.org/ntsb/CEN12LA113.md): Cessna 182J · St. Paul, MN · Accident · No injuries · Limited investigation · Final report · Dec 26, 2011 · N2618F · Substantial damage
  > The pilot's decision to land on a runway with a gusting, quartering tailwind and his inadequate compensation for the wind, which resulted in a hard landing.
- [NTSB CEN12CA065](https://openairdocs.org/ntsb/CEN12CA065.md): Cessna 182J · Alexandria, MN · Accident · No injuries · Data collection · Final report · Nov 12, 2011 · N3051F · Substantial damage
  > The pilot's failure to maintain directional control during the night landing.
- [NTSB CEN12CA044](https://openairdocs.org/ntsb/CEN12CA044.md): Aviat A-1 · Wolverton, MN · Accident · No injuries · Data collection · Final report · Oct 20, 2011 · N93HU · Substantial damage
  > The pilot's inadvertent excessive braking during the landing roll due to momentary pain.
- [NTSB CEN12CA009](https://openairdocs.org/ntsb/CEN12CA009.md): Robinson Helicopter R22 Beta · Hibbing, MN · Accident · No injuries · Data collection · Final report · Oct 4, 2011 · N4170M · Substantial damage
  > The private pilot's failure to maintain control of the helicopter during the landing flare.
- [NTSB CEN11CA624](https://openairdocs.org/ntsb/CEN11CA624.md): Cessna 172S · Bemidji, MN · Accident · No injuries · Data collection · Final report · Sep 5, 2011 · N548ND · Substantial damage
  > The student pilot's improper flare, which resulted in a hard landing.
- [NTSB CEN11CA398](https://openairdocs.org/ntsb/CEN11CA398.md): Lindstrand LBL120A · Le Center, MN · Accident · Serious injuries · Data collection · Final report · Jun 17, 2011 · N5595L · Substantial damage
  > The failure of the passenger to follow the pilot's instructions during landing, which caused the pilot to be ejected from the balloon and sustain serious injuries.
- [NTSB CEN11LA328](https://openairdocs.org/ntsb/CEN11LA328.md): Piper PA-18 · Fredenberg Township, MN · Accident · No injuries · Limited investigation · Final report · May 7, 2011 · N195T · Substantial damage
  > The pilot's inadequate directional control during a crosswind landing.
- [NTSB CEN11TA279](https://openairdocs.org/ntsb/CEN11TA279.md): Rockwell International 500-S · Eden Prairie, MN · Accident · No injuries · Final report · Apr 8, 2011 · N51RF · Substantial damage
  > The pilot's inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.
- [NTSB CEN11LA183](https://openairdocs.org/ntsb/CEN11LA183.md): Piper PA-28-161 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Feb 12, 2011 · N536PU · Substantial damage
  > The pilot's loss of directional control during the landing.

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

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