# NTSB investigations, 2011: Maneuvering

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 5 · 250 cases

## Latest cases

- [NTSB ERA12MA122](https://openairdocs.org/ntsb/ERA12MA122.md): Bell 206B · Green Cove Springs, FL · Accident · 3 fatal · Major investigation · Final report · Dec 26, 2011 · N5016M · Destroyed
  > The pilot’s improper decision to continue visual flight into night instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the pilot’s improper decision was his self-induced pressure to complete the trip.
- [NTSB ERA12LA126](https://openairdocs.org/ntsb/ERA12LA126.md): Classic Waco YMF5 · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Dec 26, 2011 · N64JE · Substantial damage
  > The pilot did not ensure that there was sufficient fuel aboard the airplane before initiating the flight, which resulted in temporary fuel starvation and an interruption in engine power during maneuvering. Contributing to the accident was the pilot’s decision…
- [NTSB CEN12LA112](https://openairdocs.org/ntsb/CEN12LA112.md): American Champion 8KCAB · Marysville, OH · Accident · 1 fatal · Limited investigation · Final report · Dec 22, 2011 · N161PC · Substantial damage
  > The pilot’s failure to maintain sufficient altitude from the terrain while performing low-level aerobatics.
- [NTSB CEN12LA109](https://openairdocs.org/ntsb/CEN12LA109.md): Cessna 172R · Denton, TX · Accident · 1 fatal · Limited investigation · Final report · Dec 20, 2011 · N987BT · Substantial damage
  > The pilot's controlled flight into terrain while maneuvering at a low altitude in instrument meteorological conditions. Contributing to the accident was the pilot's decision to perform a circling maneuver in weather below circling minimums instead of flying…
- [NTSB CEN12CA119](https://openairdocs.org/ntsb/CEN12CA119.md): Quicksilver MXL II · Loreauville, LA · Accident · Serious injuries · Data collection · Final report · Dec 18, 2011 · N61202 · Substantial damage
  > The student pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.
- [NTSB WPR12CA069](https://openairdocs.org/ntsb/WPR12CA069.md): Cessna 208 · Mesquite, NV · Accident · Minor injuries · Data collection · Final report · Dec 17, 2011 · N275PM · Substantial damage
  > The pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB WPR12FA066](https://openairdocs.org/ntsb/WPR12FA066.md): Robinson Helicopter R22 Beta · Tucson, AZ · Accident · Serious injuries · Field investigation · Final report · Dec 14, 2011 · N4052G · Substantial damage
  > A loss of engine power due to the pilot's failure to utilize carburetor heat while maneuvering..
- [NTSB WPR12LA065](https://openairdocs.org/ntsb/WPR12LA065.md): Bell 407 · Rock Springs, WY · Accident · Minor injuries · Limited investigation · Final report · Dec 13, 2011 · N8067Z · Substantial damage
  > The unauthorized operation of the helicopter by a non-certificated and unqualified individual who failed to maintain helicopter control.
- [NTSB WPR12FA062](https://openairdocs.org/ntsb/WPR12FA062.md): Crosley Vans RV-8 · Armistead, CA · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2011 · N948RC · Substantial damage
  > The pilot’s failure to maintain clearance from terrain while performing low altitude aerobatic maneuvers.
- [NTSB CEN12FA101](https://openairdocs.org/ntsb/CEN12FA101.md): Piper PA-28-235D · Chickasha, OK · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2011 · N999RR · Substantial damage
  > The non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane. Contributing to the accident was the pilot’s lack of instrument…
- [NTSB CEN12FA100](https://openairdocs.org/ntsb/CEN12FA100.md): Cessna 421C · Sioux Falls, SD · Accident · 4 fatal · Field investigation · Final report · Dec 9, 2011 · N421SY · Substantial damage
  > The pilot’s failure to maintain adequate airspeed after shutting down one engine, which resulted in an inadvertent aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s failure to follow the guidance contained in the pilot’s…
- [NTSB ERA12LA101](https://openairdocs.org/ntsb/ERA12LA101.md): Cessna 172D · Belhaven, NC · Accident · No injuries · Limited investigation · Final report · Dec 4, 2011 · N2344U · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN12FA097](https://openairdocs.org/ntsb/CEN12FA097.md): Piper PA-32-260 · St. Ignace, MI · Accident · 2 fatal · Field investigation · Final report · Dec 4, 2011 · N33315 · Substantial damage
  > The pilot’s decision to initiate visual flight in instrument meteorological conditions and subsequent failure to maintain adequate altitude.
- [NTSB ERA12WA103](https://openairdocs.org/ntsb/ERA12WA103.md): Cessna TU206 · Cerro Escalera, Peru · Accident · 4 fatal · Foreign investigation · Dec 1, 2011 · OB-1299 · Substantial damage
  > On December 1, 2011, about 2048 UTC, a Cessna TU206G, Peruvian registration OB-1299, registered to and operated by Palmas del Espino S.A., collided with mountainous terrain near Cerro Escalera, Peru. Weather conditions at the altitude, location, and time of…
- [NTSB CEN12FA090](https://openairdocs.org/ntsb/CEN12FA090.md): Cessna 182R · Mescalero, NM · Accident · 2 fatal · Field investigation · Final report · Nov 26, 2011 · N9408X · Substantial damage
  > The pilot's intentional attempt to fly into adverse weather, which resulted in an in-flight loss of control. Contributing to the accident was the pilot's lack of instrument experience.
- [NTSB CEN12FA091](https://openairdocs.org/ntsb/CEN12FA091.md): Robinson Helicopter R44 II · Hackensack, MN · Accident · 1 fatal · Field investigation · Final report · Nov 25, 2011 · N821JV · Substantial damage
  > The helicopter's sudden yaw and subsequent impact with the water for reasons that could not be determined during postaccident examination of the helicopter and its systems.
- [NTSB CEN12FA082](https://openairdocs.org/ntsb/CEN12FA082.md): Beech 23 · West Milton, OH · Accident · 1 fatal · Field investigation · Final report · Nov 24, 2011 · N8700M · Substantial damage
  > The non-instrument-rated pilot's decision to attempt a flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and subsequent loss of control of the airplane.
- [NTSB ERA12WA136](https://openairdocs.org/ntsb/ERA12WA136.md): Piper PA36 · Machala, Ecuador · Accident · No injuries · Foreign investigation · Nov 23, 2011 · HCBHJ · Substantial damage
  > On November 23, 2011, about 2000 coordinated universal time, a Piper PA-36-300, Ecuadorian registration HC-BHJ, operated by Aerorient Fumigacion Aerea, was substantially damaged when the pilot made a forced landing following loss of engine power in a banana…
- [NTSB WPR12LA036](https://openairdocs.org/ntsb/WPR12LA036.md): Bell 206B · Woodburn, OR · Accident · Serious injuries · Limited investigation · Final report · Nov 14, 2011 · N16HA · Substantial damage
  > The pilot’s failure to maintain ground clearance while maneuvering with an external load line.
- [NTSB ERA12FA068](https://openairdocs.org/ntsb/ERA12FA068.md): Cirrus Design SR22 · Boynton Beach, FL · Accident · 2 fatal · Field investigation · Final report · Nov 13, 2011 · N661FT · Substantial damage
  > The right seat pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane.
- [NTSB WPR12MA034](https://openairdocs.org/ntsb/WPR12MA034.md): Eurocopter EC 130 B4 · Pukoo, HI · Accident · 5 fatal · Major investigation · Final report · Nov 10, 2011 · N11QV · Substantial damage
  > The pilot's failure to maintain clearance from mountainous terrain while operating in marginal weather conditions, which resulted in the impact of the horizontal stabilizer and lower forward portion of the fenestron with ground and/or vegetation and led to…
- [NTSB ERA12LA070](https://openairdocs.org/ntsb/ERA12LA070.md): Cessna 172RG · Kissimmee, FL · Accident · No injuries · Limited investigation · Final report · Nov 8, 2011 · N5095V · Substantial damage
  > A fatigue failure of the right main landing gear pivot assembly, which prevented the landing gear from extending.
- [NTSB ERA12LA063](https://openairdocs.org/ntsb/ERA12LA063.md): Robinson Helicopter R22 Beta · West Palm Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 5, 2011 · N413RM · Substantial damage
  > The pilot’s failure to maintain airspeed during a low-altitude turn into gusty tailwind conditions, which resulted in a loss of translational lift and settling with power. Contributing to the accident was the pilot's lack of total flight experience.
- [NTSB WPR12CA026](https://openairdocs.org/ntsb/WPR12CA026.md): Ayres S2R-600 · Kahlotus, WA · Accident · Serious injuries · Data collection · Final report · Nov 2, 2011 · N1206S · Substantial damage
  > The pilot’s failure to maintain clearance from the ground due to his distraction with programming a global positioning system receiver.
- [NTSB CEN12RA052](https://openairdocs.org/ntsb/CEN12RA052.md): Bell 206L · Kapuskasing, Canada · Accident · 3 fatal · Class 5 · Foreign · Nov 2, 2011 · C-GDQH · Substantial damage
  > On November 2, 2011, about 0958 eastern daylight time (EDT), a Bell 206L helicopter, Canadian registration C-GDQH, was substantially damaged during an in-flight collision with terrain in Kapuskasing, Ontario, Canada. The pilot and 2 passengers sustained fatal…
- [NTSB WPR12CA025](https://openairdocs.org/ntsb/WPR12CA025.md): Cessna 172K · Florence, MT · Accident · No injuries · Data collection · Final report · Oct 30, 2011 · N7276G · Substantial damage
  > The pilot's failure to maintain clearance from a power line during a low-level flight along a river. Contributing to the accident was the pilot's decision to fly at a low altitude.
- [NTSB ERA12FA052](https://openairdocs.org/ntsb/ERA12FA052.md): Interplane S R O Skyboy · Miami, FL · Accident · 2 fatal · Field investigation · Final report · Oct 29, 2011 · N58784 · Substantial damage
  > The pilot’s failure to maintain control of the airplane while flying at low speed, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the outcome of the accident was the pilot’s decision to operate the airplane…
- [NTSB WPR12LA022](https://openairdocs.org/ntsb/WPR12LA022.md): Mcdonnell Douglas 500D · Colusa, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 2011 · N61PJ · Substantial damage
  > A total loss of engine power while maneuvering at low altitude for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation. Contributing to the accident severity was the…
- [NTSB CEN12FA043](https://openairdocs.org/ntsb/CEN12FA043.md): Hawker Beechcraft 76 · Fort Worth, TX · Accident · Serious injuries · Field investigation · Final report · Oct 26, 2011 · N6018U · Substantial damage
  > The flight instructor's failure to maintain airspeed above the air minimum control airspeed (Vmca), which resulted in a loss of control and impact with terrain. Contributing to the accident was the instructor's failure to follow published procedures to…
- [NTSB ERA12CA050](https://openairdocs.org/ntsb/ERA12CA050.md): Air Tractor AT-301 · McAlpin, FL · Accident · No injuries · Data collection · Final report · Oct 24, 2011 · N3169C · Substantial damage
  > The pilot's misjudgment of the airplane's distance from known transmission lines.
- [NTSB CEN12FA037](https://openairdocs.org/ntsb/CEN12FA037.md): Cirrus Design SR22T · Carrollton, TX · Accident · 1 fatal · Field investigation · Final report · Oct 24, 2011 · N227TX · Substantial damage
  > The pilot's failure to adequately preflight the airplane prior to departure, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA12FA018](https://openairdocs.org/ntsb/ERA12FA018.md): Berger Michael A Waiex · Washington, GA · Accident · 1 fatal · Field investigation · Final report · Oct 22, 2011 · N75654 · Substantial damage
  > The in-flight failure of the aircraft’s Y-tail attachment structure during maneuvering flight due to overload. Contributing to the accident was, the kit manufacturer’s use of 14 CFR Part 23, Appendix A design guidelines intended for a conventional tail…
- [NTSB ERA12LA045](https://openairdocs.org/ntsb/ERA12LA045.md): Graff Wilbur C Bearhawk · Woodrow, WV · Accident · No injuries · Limited investigation · Final report · Oct 18, 2011 · N5456C · Substantial damage
  > The pilot’s delayed use of carburetor heat while operating in conditions conducive to carburetor icing.
- [NTSB CEN12FA025](https://openairdocs.org/ntsb/CEN12FA025.md): Piper PA-28R-200 · Watertown, WI · Accident · No injuries · Field investigation · Final report · Oct 17, 2011 · N300KR · Substantial damage
  > The separation of the number 2 connecting rod from the crankshaft for reasons that could not be determined during postaccident metallurgical examination, which ultimately resulted in a total loss of engine power.
- [NTSB CEN12CA030](https://openairdocs.org/ntsb/CEN12CA030.md): Cessna 172N · Covington, LA · Accident · No injuries · Data collection · Final report · Oct 17, 2011 · N2401E · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during a banner drop, resulting in an aerodynamic stall.
- [NTSB CEN12WA033](https://openairdocs.org/ntsb/CEN12WA033.md): Diamond DA20 · Amurrio, Spain · Accident · 2 fatal · Foreign investigation · Oct 14, 2011 · EC-KDS · Substantial damage
  > On October 14, 2011, at 1040 universal coordinated time, a Diamond DA20-C1 airplane, EC-KDS, sustained substantial damage when it impacted terrain near Amurrio, Spain. The two crewmembers sustained fatal injuries. The accident investigation is under the…
- [NTSB WPR12CA005](https://openairdocs.org/ntsb/WPR12CA005.md): Combs Dale B RV-4 · Madera, CA · Accident · No injuries · Data collection · Final report · Oct 11, 2011 · N506DC · 2 aircraft · Substantial damage
  > The third airplane pilot’s failure to maintain visual contact with the second airplane during the formation flight.
- [NTSB ERA12FA008](https://openairdocs.org/ntsb/ERA12FA008.md): Aviat A-1 · Moyock, NC · Accident · 1 fatal · Field investigation · Final report · Oct 5, 2011 · N11HU · Substantial damage
  > The operation of the airplane by a non-certificated pilot, and his failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.
- [NTSB WPR11FA474](https://openairdocs.org/ntsb/WPR11FA474.md): Poe G L/Poe S Y 540 · Chualar, CA · Accident · 1 fatal · Field investigation · Final report · Sep 30, 2011 · N42GP · Substantial damage
  > The pilot’s incapacitation due either to g-induced loss of consciousness alone or in combination with a cardiac arrhythmia. Contributing to the accident was the pilot’s use of several medications.
- [NTSB ERA11FA512](https://openairdocs.org/ntsb/ERA11FA512.md): Heronimus Kevin A Glasair III · Falls of Rough, KY · Accident · 1 fatal · Field investigation · Final report · Sep 30, 2011 · N43KH · Substantial damage
  > The failure of the propeller power speed reduction unit, which resulted in a loss of engine power at low altitude.
- [NTSB CEN11CA667](https://openairdocs.org/ntsb/CEN11CA667.md): Tompkins Tandem Rocket · Lemars, IA · Accident · Minor injuries · Data collection · Final report · Sep 25, 2011 · N29RT · Substantial damage
  > The pilot's failure to maintain aircraft control while maneuvering.
- [NTSB WPR11CA467](https://openairdocs.org/ntsb/WPR11CA467.md): Robinson R22 Beta · Douglas, WY · Accident · No injuries · Data collection · Final report · Sep 24, 2011 · N3070S · Substantial damage
  > The pilot's failure to maintain yaw control of the helicopter while hover taxiing in gusty wind conditions.
- [NTSB ERA11LA503](https://openairdocs.org/ntsb/ERA11LA503.md): Cessna 120 · Cordele, GA · Accident · 1 fatal · Limited investigation · Final report · Sep 24, 2011 · N3101N · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN11FA666](https://openairdocs.org/ntsb/CEN11FA666.md): Robinson Helicopter R44 · Curren, MI · Accident · 2 fatal · Field investigation · Final report · Sep 24, 2011 · N8324F · Substantial damage
  > The non-instrument-rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in controlled flight into trees and the ground. Contributing to the accident was the pilot's impairment from multiple drugs.
- [NTSB ANC11TA110](https://openairdocs.org/ntsb/ANC11TA110.md): Bell 206 B3 · Seward, AK · Accident · No injuries · Final report · Sep 23, 2011 · N204PA · Substantial damage
  > The pilot's failure to maintain clearance from snow-covered terrain during hover in deteriorating weather and flat light conditions, which resulted in a tail rotor strike.
- [NTSB WPR11LA461](https://openairdocs.org/ntsb/WPR11LA461.md): Bunker RLV-1 · Wells, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 2011 · N49S · Substantial damage
  > The pilot did not maintain clearance from terrain while maneuvering. Contributing to the accident was the pilot’s inadequate in-flight planning.
- [NTSB WPR11LA459](https://openairdocs.org/ntsb/WPR11LA459.md): Mcarthur Steen Skybolt · Greenleaf, ID · Accident · No injuries · Limited investigation · Final report · Sep 19, 2011 · N77VW · Substantial damage
  > Structural failure of the upper left wing during aerobatic flight.
- [NTSB WPR11LA458](https://openairdocs.org/ntsb/WPR11LA458.md): Aviat Pitts S-2B · Redlands, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 2011 · N46BT · Substantial damage
  > The pilot’s failure to maintain airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s impairment from alcohol.
- [NTSB CEN11FA652](https://openairdocs.org/ntsb/CEN11FA652.md): Concannon Milton Radial ROC · Socorro, NM · Accident · 2 fatal · Field investigation · Final report · Sep 19, 2011 · N91TX · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the visual approach to the runway, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s lack of experience in the airplane make and model and the possible sedating…
- [NTSB ERA11FA495](https://openairdocs.org/ntsb/ERA11FA495.md): North American T-28C · Martinsburg, WV · Accident · 1 fatal · Field investigation · Final report · Sep 17, 2011 · N688GR · Substantial damage
  > The pilot's impairment or incapacitation that occurred during a low-altitude aerobatic maneuver due to complications from a recent heart attack, resulting in his inability to maintain control of the airplane. Contributing to the accident was the Federal…

Next page: https://openairdocs.org/ntsb-phases/450/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 = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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