# NTSB investigations, 2011: 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.

Page 1 of 4 · 194 cases

## Latest cases

- [NTSB CEN12LA127](https://openairdocs.org/ntsb/CEN12LA127.md): Fleet Fleet 16B · Marion, TX · Accident · No injuries · Limited investigation · Final report · Dec 30, 2011 · N9753L · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a piece of metal in the fuel line, which blocked fuel flow to the engine.
- [NTSB CEN12LA116](https://openairdocs.org/ntsb/CEN12LA116.md): Piper PA-28-180 · Lebanon, OH · Accident · Serious injuries · Limited investigation · Final report · Dec 28, 2011 · N994NC · Substantial damage
  > The pilot’s inadvertent positioning of the fuel selector valve between the right tank and OFF position, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the inadequate inspection of the fuel valve and…
- [NTSB ERA12FA123](https://openairdocs.org/ntsb/ERA12FA123.md): Aero Commander 560-F · Venice, FL · Accident · 1 fatal · Field investigation · Final report · Dec 26, 2011 · N560WM · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during a single-engine approach, which resulted in an aerodynamic stall. Contributing to the accident was the total loss of power in the left engine due to a failed No. 2 connecting rod bearing.
- [NTSB CEN12FA115](https://openairdocs.org/ntsb/CEN12FA115.md): Beech 19A · McArthur, OH · Accident · 3 fatal · Field investigation · Final report · Dec 24, 2011 · N33SR · Substantial damage
  > The pilot’s failure to maintain airplane control during an attempted go-around.
- [NTSB ERA12FA120](https://openairdocs.org/ntsb/ERA12FA120.md): Cessna 441 · Nashville, PA · Accident · 1 fatal · Field investigation · Final report · Dec 22, 2011 · N48BS · Substantial damage
  > The pilot's failure to maintain minimum control airspeed after a loss of power to the right engine, which resulted in an uncontrollable roll into an inadvertent stall/spin. Contributing to the accident was the failure of the airplane's right engine for…
- [NTSB ANC12CA016](https://openairdocs.org/ntsb/ANC12CA016.md): Cessna 207A · Kwigillingok, AK · Accident · Minor injuries · Data collection · Final report · Dec 21, 2011 · N6480H · Substantial damage
  > The pilot’s decision to continue visual flight into instrument meteorological conditions with moderate icing, which resulted in structural icing and an aerodynamic stall.
- [NTSB DCA12CA023](https://openairdocs.org/ntsb/DCA12CA023.md): University Of Kansas Meridian · McMurdo, AY · Accident · No injuries · Data collection · Final report · Dec 19, 2011 · UNREG · Substantial damage
  > an aerodynamic stall induced by an inadvertent autopilot Home command. The Home command was entered following a loss of the direct radio link due to improperly set failsafe settings, and an unintentional latching of Home mode from an earlier functionality…
- [NTSB WPR12FA067](https://openairdocs.org/ntsb/WPR12FA067.md): Cirrus Design SR22 · Phoenix, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 15, 2011 · N7850P · Substantial damage
  > The pilot's failure to maintain adequate separation behind a corporate jet, which resulted in an encounter with wake turbulence and a subsequent loss of control.
- [NTSB CEN12WA105](https://openairdocs.org/ntsb/CEN12WA105.md): Cessna 177A · Ottawa, Canada · Accident · 2 fatal · Foreign investigation · Dec 15, 2011 · C-FEFQ · Substantial damage
  > On December 14, 2011, at 1920 eastern standard time, a Cessna model 177A, Canadian registration C-FEFQ, collided with terrain 2 nautical miles west of Ottawa Macdonald-Cartier International Airport (CYOW), Ottawa, Canada. The flight had been cleared for the…
- [NTSB CEN12LA110](https://openairdocs.org/ntsb/CEN12LA110.md): Beech 95-B55 · Midland, TX · Accident · No injuries · Limited investigation · Final report · Dec 15, 2011 · N275D · Substantial damage
  > The pilot’s improper fuel management during the flight, which resulted in a total loss of engine power.
- [NTSB CEN12LA102](https://openairdocs.org/ntsb/CEN12LA102.md): Shook Rans S-12 · Festus, MO · Accident · No injuries · Limited investigation · Final report · Dec 8, 2011 · N7138K · Substantial damage
  > The certified flight instructor’s delayed remedial action as the airplane neared an aerodynamic stall/spin. Contributing to the accident was that the student pilot did not maintain adequate airspeed during the go-around attempt.
- [NTSB WPR12LA055](https://openairdocs.org/ntsb/WPR12LA055.md): Piper PA-38-112 · Davis, CA · Accident · No injuries · Limited investigation · Final report · Dec 7, 2011 · N2466D · Substantial damage
  > The pilot's inadequate fuel management, which resulted in a loss of engine power due to fuel starvation.
- [NTSB ERA12IA158](https://openairdocs.org/ntsb/ERA12IA158.md): Cirrus Design SR20 · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Dec 4, 2011 · N486DA · No damage
  > The failure of a crankshaft gear tooth due to fatigue, which resulted in the loss of several additional gear teeth and a subsequent total loss of engine power.
- [NTSB ERA12CA096](https://openairdocs.org/ntsb/ERA12CA096.md): Thompson Tommy W Loehle P5151 · Courtland, AL · Accident · Serious injuries · Data collection · Final report · Dec 4, 2011 · N212WE · Substantial damage
  > The airplane's inadvertent encounter with excessive windshear while on the downwind traffic pattern leg at low altitude, which resulted in the pilot's inability to arrest the airplane’s descent. Contributing to the accident was the pilot's decision to fly the…
- [NTSB CEN12LA095](https://openairdocs.org/ntsb/CEN12LA095.md): Beech F90 · Midland, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 2011 · N90QL · Destroyed
  > The pilot's failure to maintain the recommended airspeed for icing conditions and his subsequent loss of airplane control while flying the airplane under autopilot control in severe icing conditions, contrary to the airplane's handbook. Contributing to the…
- [NTSB WPR12LA057](https://openairdocs.org/ntsb/WPR12LA057.md): Boeing 757-222 · Modesto, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2011 · N547UA · No damage
  > The flight's encounter with known severe turbulence associated with mountain wave activity, which resulted in a flight attendant sustaining a broken ankle.
- [NTSB ERA12FA093](https://openairdocs.org/ntsb/ERA12FA093.md): Wing John R Wittman Tailwind · Fulton, NY · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2011 · N865JT · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to the formation of carburetor ice.
- [NTSB CEN12LA094](https://openairdocs.org/ntsb/CEN12LA094.md): Cessna 305A · Fredericksburg, TX · Accident · No injuries · Limited investigation · Final report · Nov 30, 2011 · N6735Q · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in a subsequent loss of engine power due to fuel starvation.
- [NTSB ERA12IA090](https://openairdocs.org/ntsb/ERA12IA090.md): Cessna 402B · Nantucket, MA · Incident · No injuries · Incident investigation · Final report · Nov 29, 2011 · N303PJ · Minor damage
  > The failure of the right main fuel tank transfer pump, which resulted in a total loss of engine power on the right engine during approach due to fuel starvation, and a subsequent hard landing. Contributing to the incident was the pilot's operation of the…
- [NTSB CEN12FA086](https://openairdocs.org/ntsb/CEN12FA086.md): Piper PA-31-350 · Riverwoods, IL · Accident · 3 fatal · Field investigation · Final report · Nov 29, 2011 · N59773 · Substantial damage
  > The pilot's inadequate preflight planning and in-flight decision-making, which resulted in a loss of engine power due to fuel exhaustion during approach. Contributing to the accident was the pilot's decision to operate an airplane after using illicit drugs.
- [NTSB ERA12CA082](https://openairdocs.org/ntsb/ERA12CA082.md): Cirrus Design SR20 · Brooksville, FL · Accident · No injuries · Data collection · Final report · Nov 22, 2011 · N497DA · Substantial damage
  > The pilot's incorrect identification of the runway, which resulted in an off-airport landing and subsequent collision with objects.
- [NTSB CEN12LA077](https://openairdocs.org/ntsb/CEN12LA077.md): Cessna 152 · Princeton, MN · Accident · No injuries · Limited investigation · Final report · Nov 22, 2011 · N6436P · Substantial damage
  > The inadequate installation of the threaded insert in the No. 2 cylinder spark plug hole by maintenance personnel, which resulted in a loss of engine power during initial climb.
- [NTSB CEN12CA085](https://openairdocs.org/ntsb/CEN12CA085.md): Grumman American AA-5A · Bulverde, TX · Accident · Minor injuries · Data collection · Final report · Nov 22, 2011 · N26067 · Substantial damage
  > The pilot's improper glidepath while on final approach.
- [NTSB ERA12WA089](https://openairdocs.org/ntsb/ERA12WA089.md): Piper PA-28-236 · Mercedes, Argentina · Accident · 2 fatal · Foreign investigation · Nov 21, 2011 · PG-449 · 2 aircraft · Minor damage
  > On November 21, 2011, about 1320 coordinated universal time, a Piper PA-28-236, Argentine Air Force designation PF-449, and a Cessna 152, Argentine registration LV-OOF, collided while on approach to Mercedes Airfield (MRD), Mercedes, Buenos Aires Province,…
- [NTSB ERA12CA080](https://openairdocs.org/ntsb/ERA12CA080.md): Beech V35 · Lusby, MD · Accident · Serious injuries · Data collection · Final report · Nov 20, 2011 · N9569Q · Substantial damage
  > The pilot did not maintain clearance from trees during a night approach.
- [NTSB WPR12FA040](https://openairdocs.org/ntsb/WPR12FA040.md): Cessna T337 · Casper, WY · Accident · 1 fatal · Field investigation · Final report · Nov 18, 2011 · N357 · Substantial damage
  > The pilot's failure to maintain airspeed and airplane control while maneuvering in low visibility and icing conditions.
- [NTSB CEN12LA061](https://openairdocs.org/ntsb/CEN12LA061.md): Cessna 401A · Gladewater, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 12, 2011 · N531MH · Substantial damage
  > The pilot’s failure to maintain control of the airplane during the landing and attempted go-around in a gusty crosswind.
- [NTSB CEN12WA092](https://openairdocs.org/ntsb/CEN12WA092.md): Socata TBM 700 · Lyon, France · Accident · 1 fatal · Foreign investigation · Nov 9, 2011 · N228CX · Substantial damage
- [NTSB OPS12IA122](https://openairdocs.org/ntsb/OPS12IA122.md): Kahului, HI · Incident · No injuries · Incident investigation · Final report · Nov 3, 2011 · No damage
  > Failure of the Honolulu Control Facility controller to issue control instructions necessary to establish and maintain required separation between all three aircraft. Contributing to the losses of separation was inadequate training provided to controllers…
- [NTSB ERA12LA058](https://openairdocs.org/ntsb/ERA12LA058.md): Cessna 172N · Pompano Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 2011 · N739JN · Substantial damage
  > The separation of the throttle cable from its fitting, which resulted in an inability to control engine power. Contributing to the accident was the inadequate maintenance by the owner.
- [NTSB ERA12CA054](https://openairdocs.org/ntsb/ERA12CA054.md): Aeros Trike · Amherst, VA · Accident · Serious injuries · Data collection · Final report · Oct 30, 2011 · N6111F · Substantial damage
  > The student pilot's inadequate aircraft control and improper airspeed while maneuvering to land, which resulted in a stall. Contributing to the accident was the pilot's lack of experience in the make and model of the accident aircraft.
- [NTSB ERA12CA053](https://openairdocs.org/ntsb/ERA12CA053.md): Cessna 172F · Smoketown, PA · Accident · Serious injuries · Data collection · Final report · Oct 28, 2011 · N5613R · Substantial damage
  > The pilot did not maintain a proper approach path, which resulted in a collision with a tree.
- [NTSB ERA12FA021](https://openairdocs.org/ntsb/ERA12FA021.md): Elkind Bruce Cozy MK IV · Lexington, NC · Accident · 1 fatal · Field investigation · Final report · Oct 23, 2011 · N795DB · Substantial damage
  > The pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA12CA019](https://openairdocs.org/ntsb/ERA12CA019.md): Aeronca 7AC · Manassas, VA · Accident · Minor injuries · Data collection · Final report · Oct 22, 2011 · N4300E · Substantial damage
  > The pilot did not maintain adequate airspeed while turning to the downwind leg, which resulted in an aerodynamic stall and spin.
- [NTSB WPR12LA015](https://openairdocs.org/ntsb/WPR12LA015.md): Piper PA46R · Paso Robles, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 2011 · N422HP · Substantial damage
  > A loss of engine power while maneuvering for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA12CA042](https://openairdocs.org/ntsb/ERA12CA042.md): Moyes Bailey Dragonfly · Massey, MD · Accident · Minor injuries · Data collection · Final report · Oct 18, 2011 · N103ST · Substantial damage
  > The pilot did not maintain airspeed during approach to landing, which resulted in an aerodynamic stall.
- [NTSB ERA12FA030](https://openairdocs.org/ntsb/ERA12FA030.md): Cirrus Design SR22 · Danbury, CT · Accident · 1 fatal · Field investigation · Final report · Oct 17, 2011 · N438CP · Substantial damage
  > The pilot did not maintain clearance from a lighted tower during final approach in night visual conditions.
- [NTSB ERA12CA043](https://openairdocs.org/ntsb/ERA12CA043.md): Fehlner-Shelton Aerosport Scamp WTB1 · Grantham, NC · Accident · Minor injuries · Data collection · Final report · Oct 17, 2011 · N25WS · Substantial damage
  > The pilot's inadequate clearance from unmarked power lines while on approach to land at a private airport.
- [NTSB ERA12CA036](https://openairdocs.org/ntsb/ERA12CA036.md): Cessna 172F · Atlanta, GA · Accident · Serious injuries · Data collection · Final report · Oct 17, 2011 · N5419R · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA12WA041](https://openairdocs.org/ntsb/ERA12WA041.md): Bell 412 · Santa Rosa, Venezuela · Accident · Serious injuries · Foreign investigation · Oct 15, 2011 · YVO126 · Substantial damage
  > On October 15, 2011, at 1933 UTC, a Bell 412SP, YV0126, registered to and operated by Electrificacion del Caroni (EDELCA), as a business flight, collided with trees while on approach to Macagua Airport, Santa Rosa, Venezuela. The Venezuelan Government…
- [NTSB ERA12CA027](https://openairdocs.org/ntsb/ERA12CA027.md): Ica Brasov IS-29D2 · Benton, TN · Accident · No injuries · Data collection · Final report · Oct 14, 2011 · N1339X · Substantial damage
  > The pilot's improper in-flight planning, which resulted in a low-altitude traffic pattern entry and subsequent collision with telephone wires.
- [NTSB ERA12FA023](https://openairdocs.org/ntsb/ERA12FA023.md): Socata TBM 700 · Hollywood, FL · Accident · Minor injuries · Field investigation · Final report · Oct 12, 2011 · N37SV · Substantial damage
  > The pilot’s failure to terminate the flight after observing multiple conflicting errors associated with the inaccurate right fuel quantity indication. Contributing to the accident were the total loss of engine power due to fuel starvation from the right tank,…
- [NTSB CEN12CA016](https://openairdocs.org/ntsb/CEN12CA016.md): Cessna 182A · Skiatook, OK · Accident · No injuries · Data collection · Final report · Oct 12, 2011 · N6171B · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.
- [NTSB ERA12CA020](https://openairdocs.org/ntsb/ERA12CA020.md): Cessna 177B · Honesdale, PA · Accident · No injuries · Data collection · Final report · Oct 10, 2011 · N34218 · Substantial damage
  > The pilot’s excessive airspeed during final approach and his delayed decision to abort the landing, resulting in the in-flight collision with trees during the go-around.
- [NTSB CEN12LA015](https://openairdocs.org/ntsb/CEN12LA015.md): Cessna 150L · Vidalia, LA · Accident · No injuries · Limited investigation · Final report · Oct 7, 2011 · N642EZ · Substantial damage
  > A total loss of engine power likely due to carburetor ice.
- [NTSB CEN12FA010](https://openairdocs.org/ntsb/CEN12FA010.md): Brinkerhuff Gerald G Q200 · Holland, MI · Accident · 1 fatal · Field investigation · Final report · Oct 6, 2011 · N2935R · Substantial damage
  > The pilot failed to maintain sufficient altitude during the landing approach, which resulted in the airplane contacting an approach light. Contributing to the accident was the setting sun, which most likely obscured the pilot’s vision.
- [NTSB ERA12LA009](https://openairdocs.org/ntsb/ERA12LA009.md): Cessna 150L · Punta Gorda, FL · Accident · No injuries · Limited investigation · Final report · Oct 5, 2011 · N11280 · Substantial damage
  > The partial loss of engine power due to contamination of the fuel system that was not detected because of the pilot’s inadequate preflight inspection.
- [NTSB ERA12FA007](https://openairdocs.org/ntsb/ERA12FA007.md): Cessna 207A · Matinicus Island, ME · Accident · 1 fatal · Field investigation · Final report · Oct 5, 2011 · N70437 · Substantial damage
  > The pilot’s failure to maintain airplane control during the approach after encountering a gusty crosswind, which resulted in an accelerated stall and uncontrolled descent.
- [NTSB ANC11FA107](https://openairdocs.org/ntsb/ANC11FA107.md): Dehavilland DHC-3T · Kodiak, AK · Accident · 1 fatal · Field investigation · Final report · Sep 24, 2011 · N361TT · Substantial damage
  > The pilot’s failure to maintain clearance from a tree during a low altitude maneuver and his failure to maintain control of the airplane. Contributing to the accident was the pilot’s use of over-the-counter sedating medications.
- [NTSB CEN11FA663](https://openairdocs.org/ntsb/CEN11FA663.md): Thorp T-18 · Plainwell, MI · Accident · 1 fatal · Field investigation · Final report · Sep 23, 2011 · N54WB · Substantial damage
  > The pilot did not maintain clearance from a semitrailer along the approach path.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?year=2011&page=2

## 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."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?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.