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

Page 1 of 6 · 287 cases

## Latest cases

- [NTSB CEN12LA118](https://openairdocs.org/ntsb/CEN12LA118.md): Piper PA-32-260 · Elk Rapids, MI · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 2011 · N997TB · Substantial damage
  > The loss of engine power due to the failure of the exhaust valve.
- [NTSB ERA12WA133](https://openairdocs.org/ntsb/ERA12WA133.md): Piper PA28 · Andres Bello,Tachira, Venezuela · Accident · 2 fatal · Foreign investigation · Dec 29, 2011 · HK3934 · Substantial damage
  > On December 29, 2011, about 1415 universal coordinated time, a Piper PA28-161, Columbian registration HK3934, was substantially damaged when it impacted terrain while in cruise flight near Andres Bello, Tachira, Venezuela. The two pilots were fatally injured.…
- [NTSB WPR12CA072](https://openairdocs.org/ntsb/WPR12CA072.md): Schweizer SGS 1-26B · Murrieta, CA · Accident · No injuries · Data collection · Final report · Dec 28, 2011 · N8641R · Substantial damage
  > The glider's encounter with insufficient atmospheric lift to maintain soaring flight.
- [NTSB ERA12CA119](https://openairdocs.org/ntsb/ERA12CA119.md): Hughes 369D · Fall Branch, TN · Accident · No injuries · Data collection · Final report · Dec 21, 2011 · N500TN · Substantial damage
  > The pilot's improper decision to continue a visual flight into instrument meteorological conditions, which resulted in a wire strike.
- [NTSB ERA12FA115](https://openairdocs.org/ntsb/ERA12FA115.md): Socata TBM 700 · Morristown, NJ · Accident · 5 fatal · Field investigation · Final report · Dec 20, 2011 · N731CA · Destroyed
  > The airplane’s encounter with unforecasted severe icing conditions that were characterized by high ice accretion rates and the pilot's failure to use his command authority to depart the icing conditions in an expeditious manner, which resulted in a loss of…
- [NTSB WPR12LA064](https://openairdocs.org/ntsb/WPR12LA064.md): Piper PA-22 · Friday Harbor, WA · Accident · No injuries · Limited investigation · Final report · Dec 13, 2011 · N1810P · Substantial damage
  > A total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12FA059](https://openairdocs.org/ntsb/WPR12FA059.md): Vans RV7 - A · Surprise, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2011 · N724WD · Substantial damage
  > An electrical or engine electronic problem, which resulted in a loss of engine power, followed by a low-altitude stall.
- [NTSB ERA12WA113](https://openairdocs.org/ntsb/ERA12WA113.md): Robinson R44 · Sao Bento do Sul, Brazil · Accident · 1 fatal · Foreign investigation · Dec 9, 2011 · PR-KLA · Substantial damage
  > On December 9, 2011 at 1630 universal coordinated time, a Robinson R44, Brazilian registration PR-KLA, operated by SASH Locacao de Veiculos LTDA, as a personal flight, impacted terrain in the vicinity of Fazenda Coqueiros, Sao Bento do Sul, Santa Catarina,…
- [NTSB WPR12FA058](https://openairdocs.org/ntsb/WPR12FA058.md): Piper PA-28R-200 · Coupeville, WA · Accident · 1 fatal · Field investigation · Final report · Dec 8, 2011 · N2611R · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB DCA12MA020](https://openairdocs.org/ntsb/DCA12MA020.md): Eurocopter France AS350B2 · Las Vegas, NV · Accident · 5 fatal · Class 1 · Major · Final report · Dec 8, 2011 · N37SH · Destroyed
  > Sundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…
- [NTSB CEN12LA111](https://openairdocs.org/ntsb/CEN12LA111.md): Curtiss Wright P40M · Batavia, OH · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 2011 · N5813 · Substantial damage
  > A loss of engine power due to failure of the engine oil cooler and subsequent oil starvation to the engine.
- [NTSB ERA12WA104](https://openairdocs.org/ntsb/ERA12WA104.md): Piper PA28 · Bogota, Colombia · Accident · No injuries · Foreign investigation · Dec 6, 2011 · HK2308 · Substantial damage
  > On December 6, 2011, about 1815 Universal Coordinated Time (UTC), a Piper PA-28-236, Columbian registration HK2308, operated by Aeroclub de Colombia, incurred substantial damage to the left wing and separated the left main gear when it collided with a tree…
- [NTSB CEN12FA098](https://openairdocs.org/ntsb/CEN12FA098.md): Socata TB21 · Silverton, CO · Accident · 4 fatal · Field investigation · Final report · Dec 3, 2011 · N25153 · Substantial damage
  > The non-instrument-rated pilot’s decision to embark on a flight through forecasted instrument meteorological conditions (IMC), and his subsequent flight into IMC, which resulted in the pilot’s spatial disorientation and subsequent maneuvering of the airplane…
- [NTSB WPR12LA053](https://openairdocs.org/ntsb/WPR12LA053.md): Boeing 737-7H4 · Oakland, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 2011 · N261WN · No damage
  > The flight crew’s flight into known severe turbulence associated with mountain wave activity.
- [NTSB ERA12IA097](https://openairdocs.org/ntsb/ERA12IA097.md): Cessna 560XL · Ocoee, FL · Incident · No injuries · Incident investigation · Final report · Dec 2, 2011 · N576CS · No damage
  > Water contamination in the pitch trim actuators.
- [NTSB CEN12IA096](https://openairdocs.org/ntsb/CEN12IA096.md): Bell Helicopter Textron Canada 407 · Gulf Of Mexico · Incident · No injuries · Incident investigation · Final report · Dec 1, 2011 · N435PH · No damage
  > The failure of the compressor section No. 2 bearing due to false brinnelling and fatigue.
- [NTSB CEN12FA088](https://openairdocs.org/ntsb/CEN12FA088.md): Piper PA-31 · New Orleans, LA · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2011 · N6485L · Minor damage
  > The pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.
- [NTSB ANC12FA009](https://openairdocs.org/ntsb/ANC12FA009.md): Cessna 207 · Chuathbaluk, AK · Accident · 1 fatal · Field investigation · Final report · Nov 29, 2011 · N1673U · Substantial damage
  > The pilot’s loss of situational awareness after an inadvertent encounter with instrument meteorological conditions, which resulted in an in-flight collision with tree-covered terrain.
- [NTSB ERA12LA087](https://openairdocs.org/ntsb/ERA12LA087.md): Smith Miniplane DSA-4 · Hernando, FL · Accident · No injuries · Limited investigation · Final report · Nov 27, 2011 · N1321 · Substantial damage
  > The pilot's failure to apply carburetor heat while descending in conditions conducive to carburetor icing, which resulted in carburetor icing and a subsequent total loss of engine power.
- [NTSB ERA12WA105](https://openairdocs.org/ntsb/ERA12WA105.md): Cirrus SR20 · Minas Gerias, Brazil · Accident · 2 fatal · Foreign investigation · Nov 26, 2011 · PR-LJL · Substantial damage
  > On November 26, 2011, about 1300 universal coordinated time, a Cirrus SR20, Brazilian registration PR-LJL, operated by a private individual, was substantially damaged when it impacted terrain in Carmo do Cajuri Municipality, Minas Gerais, Brazil. The pilot…
- [NTSB ERA12FA084](https://openairdocs.org/ntsb/ERA12FA084.md): Cessna 177RG · Tallapoosa, GA · Accident · 3 fatal · Field investigation · Final report · Nov 26, 2011 · N5AW · Substantial damage
  > The failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.
- [NTSB CEN12FA083](https://openairdocs.org/ntsb/CEN12FA083.md): Cirrus Design SR20 · Crystal Lake, IL · Accident · 4 fatal · Field investigation · Final report · Nov 26, 2011 · N223CD · Substantial damage
  > The noninstrument-rated pilot's decision to continue flight in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane.
- [NTSB WPR12MA046](https://openairdocs.org/ntsb/WPR12MA046.md): Rockwell 690 · Apache Junction, AZ · Accident · 6 fatal · Major investigation · Final report · Nov 24, 2011 · N690SM · Destroyed
  > The pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…
- [NTSB ERA12LA085](https://openairdocs.org/ntsb/ERA12LA085.md): Piper PA 46-350P · Caribbean Sea, A1 · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 2011 · N534P · Substantial damage
  > The total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered. Contributing to the accident was the pilot’s failure to comply with the airplane and engine limitations, and his decision to…
- [NTSB CEN12FA080](https://openairdocs.org/ntsb/CEN12FA080.md): Diamond Aircraft Ind DA 20-C1 · Bern, WI · Accident · 1 fatal · Field investigation · Final report · Nov 24, 2011 · N203MK · Substantial damage
  > The non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.
- [NTSB ANC12CA010](https://openairdocs.org/ntsb/ANC12CA010.md): Cessna A185F · Talkeetna, AK · Accident · No injuries · Data collection · Final report · Nov 23, 2011 · N121EE · Substantial damage
  > A broken wheel/ski clevis pin, which allowed the ski to pivot upward and strike the right wing lift strut.
- [NTSB ERA12WA102](https://openairdocs.org/ntsb/ERA12WA102.md): Cessna 210 · Alto Alegre, Brazil · Accident · 1 fatal · Foreign investigation · Nov 22, 2011 · PT-IOT · Substantial damage
  > On November 22, 2011, at 1740 universal time coordinated, a Cessna Aircraft, Model 210L, Brazilian registration PT-IOT, impacted the ground after reporting an engine failure near Aldeia Hali Katu, in the Alto Alegre Municipality, Roraima, Brazil. The airplane…
- [NTSB ERA12FA074](https://openairdocs.org/ntsb/ERA12FA074.md): Beech 95-C55 · Ulysses, PA · Accident · Serious injuries · Field investigation · Final report · Nov 17, 2011 · N54552 · Substantial damage
  > The total loss of left engine power due to fuel starvation, and the pilot’s improper configuration of the fuel system during remedial actions, which resulted in fuel starvation of the right engine. Contributing to the accident was the pilot’s incomplete…
- [NTSB CEN12FA072](https://openairdocs.org/ntsb/CEN12FA072.md): Piper PA-28-180 · Perryville, AR · Accident · 4 fatal · Field investigation · Final report · Nov 17, 2011 · N7746W · Substantial damage
  > The pilot's loss of control in flight.
- [NTSB WPR12LA039](https://openairdocs.org/ntsb/WPR12LA039.md): Williams Helicopter UH-1H · Grand Canyon, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 2011 · N502AW · Substantial damage
  > The loss of main rotor power due to a main rotor transmission failure from a lack of lubrication.
- [NTSB CEN12LA074](https://openairdocs.org/ntsb/CEN12LA074.md): Beech S35 · Elkhart Lake, WI · Accident · No injuries · Limited investigation · Final report · Nov 15, 2011 · N5858S · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN12LA060](https://openairdocs.org/ntsb/CEN12LA060.md): Cessna 180 · Eau Claire, WI · Accident · No injuries · Limited investigation · Final report · Nov 12, 2011 · N3606C · Substantial damage
  > The pilot’s disorientation during a night flight, which resulted in an off-airport landing, and his inadequate directional control during the landing roll. Contributing to the accident was the loss of the airplane’s electrical system power.
- [NTSB CEN12CA079](https://openairdocs.org/ntsb/CEN12CA079.md): Beech 95-B55 (T42A) · College Station, TX · Accident · Minor injuries · Data collection · Final report · Nov 10, 2011 · N8188R · Substantial damage
  > The total loss of engine power from both engines, which resulted from fuel exhaustion due to the pilot’s inadequate pre-flight preparation.
- [NTSB WPR12FA031](https://openairdocs.org/ntsb/WPR12FA031.md): Cessna 182Q · Lake Havasu City, AZ · Accident · 3 fatal · Field investigation · Final report · Nov 7, 2011 · N4701N · Substantial damage
  > The pilot's continued cruise flight into cloudy conditions at night, which resulted in a loss of airplane control due to spatial disorientation.
- [NTSB ERA12CA059](https://openairdocs.org/ntsb/ERA12CA059.md): Beech F33A · Chesterfield, VA · Accident · Minor injuries · Data collection · Final report · Nov 2, 2011 · N833 · Substantial damage
  > A total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management.
- [NTSB ERA12FA057](https://openairdocs.org/ntsb/ERA12FA057.md): Eckenrode Carl J Vans RV-6 · Taylorsville, GA · Accident · 1 fatal · Field investigation · Final report · Nov 1, 2011 · N262MA · Substantial damage
  > The airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane and the pilot’s medical history did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN12IA050](https://openairdocs.org/ntsb/CEN12IA050.md): Nusbaum Vaquero · Hebron, IL · Incident · No injuries · Incident investigation · Final report · Nov 1, 2011 · N30CY · No damage
  > The pilot’s operation of the airplane with known medical conditions and his subsequent heart attack during the flight.
- [NTSB CEN12CA051](https://openairdocs.org/ntsb/CEN12CA051.md): Downer Bellanca 14-19-2 · Borger, TX · Accident · Minor injuries · Data collection · Final report · Nov 1, 2011 · N711W · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident was the pilot’s diverted attention with the broken fuel gauge knob.
- [NTSB ERA12CA055](https://openairdocs.org/ntsb/ERA12CA055.md): Tacchi Torello F Vans Aircraft RV10 · Folkston, GA · Accident · No injuries · Data collection · Final report · Oct 30, 2011 · N968TP · Substantial damage
  > The pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ANC12FA006](https://openairdocs.org/ntsb/ANC12FA006.md): Eurocopter AS 350 B2 · Iliamna, AK · Accident · 1 fatal · Field investigation · Final report · Oct 30, 2011 · N165EH · Destroyed
  > The pilot's loss of control due to sudden medical impairment or incapacitation.
- [NTSB WPR12LA023](https://openairdocs.org/ntsb/WPR12LA023.md): Cessna 185 · Prineville, OR · Accident · No injuries · Limited investigation · Final report · Oct 28, 2011 · N520YH · Substantial damage
  > A total loss of engine power due to fuel starvation, which resulted from the pilot inadvertently leaving the fuel selector set to the left tank. Contributing to the accident was the pilot’s deviation from his normal habit pattern and his failure to refer to…
- [NTSB DCA12WA010](https://openairdocs.org/ntsb/DCA12WA010.md): Boeing 777 - 200 · Nani, Kenya · Accident · No injuries · Foreign investigation · Oct 28, 2011 · A7-BBD · No damage
  > On October 28, 2011 about 1544 hours UTC, a Boeing 777-200LR, registration number A7-BBD, operated by Qatar Airways, encountered inflight turbulence, during cruise flight near Nani, Kenya. A cabin crew member received serious injuries. The flight originated…
- [NTSB WPR12FA021](https://openairdocs.org/ntsb/WPR12FA021.md): Cessna 182R · Lexington, OR · Accident · 1 fatal · Field investigation · Final report · Oct 27, 2011 · N6545E · Substantial damage
  > The pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.
- [NTSB WPR12FA020](https://openairdocs.org/ntsb/WPR12FA020.md): Piper PA-44-180 · St. Paul, OR · Accident · 1 fatal · Field investigation · Final report · Oct 25, 2011 · N3062H · 2 aircraft · Substantial damage
  > The pilot was unable to see the other aircraft to avoid a collision.
- [NTSB CEN12CA035](https://openairdocs.org/ntsb/CEN12CA035.md): Houts Avid Mark IV · Hibbing, MN · Accident · Minor injuries · Data collection · Final report · Oct 21, 2011 · N43280 · Substantial damage
  > The improper installation of a hose clamp, which resulted in an oil line rupture and subsequent loss of engine oil pressure.
- [NTSB WPR12WA186](https://openairdocs.org/ntsb/WPR12WA186.md): Piper PA-34-220T · Karachi, Pakistan · Accident · No injuries · Foreign investigation · Oct 20, 2011 · AP_BDK · Substantial damage
  > On October 20, 2011, at 1138 local time, a Piper PA-34-220T, Pakistan registry AP-BDK, was substantially damaged during a forced landing following a dual engine failure while in cruise flight. The aircraft was operated by M/S Schon Air Limited of Karachi,…
- [NTSB ERA12CA044](https://openairdocs.org/ntsb/ERA12CA044.md): Boeing 767-2B7 · New York, NY · Accident · Serious injuries · Data collection · Final report · Oct 20, 2011 · N253AY · No damage
  > The passenger's lack of compliance with the illuminated seatbelt sign, which resulted in her injury during a turbulence encounter.
- [NTSB ERA12LA033](https://openairdocs.org/ntsb/ERA12LA033.md): Cessna R172K · Williamsburg, VA · Accident · No injuries · Limited investigation · Final report · Oct 17, 2011 · N758GY · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12FA012](https://openairdocs.org/ntsb/WPR12FA012.md): Beech E33 · Daggett, CA · Accident · 3 fatal · Field investigation · Final report · Oct 16, 2011 · N7011N · Substantial damage
  > A loss of engine power due to the separation of a connecting rod, and the pilot's failure to maintain airplane control during a sudden maneuver to avoid power lines during the descent, which resulted in an unrecoverable aerodynamic stall and subsequent spin.…
- [NTSB CEN12FA021](https://openairdocs.org/ntsb/CEN12FA021.md): Piper PA-28-140 · Guthrie, OK · Accident · 1 fatal · Field investigation · Final report · Oct 16, 2011 · N6085W · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.

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

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