# NTSB investigations, 2011: Takeoff

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 · 188 cases

## Latest cases

- [NTSB WPR12LA070](https://openairdocs.org/ntsb/WPR12LA070.md): Ryan Navion · Concord, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2011 · N4398K · Substantial damage
  > The pilot's inadequate preflight inspection of the airplane and the subsequent total loss of engine power as a result of debris and water contamination in the fuel system.
- [NTSB CEN12LA114](https://openairdocs.org/ntsb/CEN12LA114.md): Southern Powered Parachute Condor · Rogersville, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 25, 2011 · UNREG · Substantial damage
  > The pilot's inadequate preflight inspection of the takeoff area, which resulted in a loss of control due to the binding of the parachute's lines.
- [NTSB ERA12CA118](https://openairdocs.org/ntsb/ERA12CA118.md): Cessna 120 · Montague, MA · Accident · No injuries · Data collection · Final report · Dec 17, 2011 · N89809 · Substantial damage
  > The pilot's delay in performing a rejected takeoff after experiencing an intermittent loss of engine power, which resulted in a runway excursion.
- [NTSB ERA12FA107](https://openairdocs.org/ntsb/ERA12FA107.md): Shaw Douglas Wayne Rans S 7 · Somerville, TN · Accident · 1 fatal · Field investigation · Final report · Dec 11, 2011 · N347DS · Substantial damage
  > The pilot's incapacitation due to a ruptured berry aneurysm during takeoff.
- [NTSB DCA13WA052](https://openairdocs.org/ntsb/DCA13WA052.md): Beech 1900 · Goose Bay, Canada · Incident · No injuries · Foreign investigation · Dec 10, 2011 · C-GLHO · No damage
  > On 10 December 2011, at 1028 Newfoundland Standard Time, an Exploits Valley Air Services Hawker Beechcraft 1900D aircraft (registration C-GLHO, serial number UE-266), operating as Air Canada Express flight EV7645, was conducting a scheduled passenger flight…
- [NTSB DCA12WA018](https://openairdocs.org/ntsb/DCA12WA018.md): Boeing 737 · Seoul, South Korea · Incident · No injuries · Foreign investigation · Dec 4, 2011 · HL-7796 · Minor damage
  > The Korean Aviationand Railway Accident Investigation Board (ARAIB) has notified the NTSB of an accident involving a Boeing 737 that occurred on December 4, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB investigation under…
- [NTSB ERA12CA094](https://openairdocs.org/ntsb/ERA12CA094.md): Nuse George F1H Rocket · Caroleen, NC · Accident · No injuries · Data collection · Final report · Dec 2, 2011 · N295JS · Substantial damage
  > The pilot did not maintain directional control during takeoff at night due to his distraction with a dropped flashlight, and he delayed his decision to abort the takeoff.
- [NTSB OPS12IA167](https://openairdocs.org/ntsb/OPS12IA167.md): Learjet 45 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Dec 1, 2011 · N570AM · 2 aircraft · No damage
  > The tower local controller did not ensure that the runway was clear of conflict before directing the B737 to cross the runway, and other air traffic control personnel did not effectively intervene when the separation between the two airplanes became…
- [NTSB DCA12WA019](https://openairdocs.org/ntsb/DCA12WA019.md): Gulfstream American G 1159 · Huambo, Angola · Accident · No injuries · Foreign investigation · Nov 26, 2011 · N811DE · Substantial damage
  > On November 26, 2011, about 1300 UTC, N811DE, a Grumman G-1159 Gulfstream G-II, a private flight operated by Wings Over Africa, was involved in a runway excursion following a rejected takeoff. None of the 10 persons aboard were injured. The aircraft was…
- [NTSB CEN12FA073](https://openairdocs.org/ntsb/CEN12FA073.md): Skykits Savannah VGW · Plato Center, IL · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2011 · N61XT · Substantial damage
  > The noncertificated pilot’s decision to fly the airplane without receiving any flight instruction in the airplane, which resulted in his failure to maintain sufficient airspeed during takeoff and the subsequent aerodynamic stall.
- [NTSB ERA12LA077](https://openairdocs.org/ntsb/ERA12LA077.md): Ercoupe 415-C · Mulberry, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 2011 · N99168 · Substantial damage
  > The pilot’s failure to abort the takeoff after recognizing the airplane’s poor performance during the takeoff roll. Contributing to the passenger’s injuries was the pilot’s failure to provide a briefing on the use of the lapbelt, which delayed the passenger’s…
- [NTSB CEN12LA071](https://openairdocs.org/ntsb/CEN12LA071.md): Juve Richard G Zodiac CH601 HDS · Clinton, AR · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2011 · N274 · Substantial damage
  > The inadvertent opening of the canopy during takeoff due to the improperly repaired forward canopy latch mechanism, which did not fully secure the canopy.
- [NTSB WPR12CA038](https://openairdocs.org/ntsb/WPR12CA038.md): Cessna 172S · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Nov 12, 2011 · N24350 · Substantial damage
  > The student pilot's inadequate directional control during takeoff.
- [NTSB ERA12WA092](https://openairdocs.org/ntsb/ERA12WA092.md): Piper PA-25 · Meteropolitana, Chile · Accident · No injuries · Foreign investigation · Nov 11, 2011 · CC-ABM · Substantial damage
  > On November 11, 2011, at 1345 UTC, a Piper PA-25-260, Chilean registration CC-ABM, registered to and operated by Sociedad De Ttrabajos Aeros Aeropacifico LTDA as a personal flight experienced a partial loss of engine power on initial takeoff climb, in the…
- [NTSB CEN12LA059](https://openairdocs.org/ntsb/CEN12LA059.md): Cessna 172M · Sturgis, SD · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 2011 · N13584 · Substantial damage
  > The student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.
- [NTSB CEN12WA223](https://openairdocs.org/ntsb/CEN12WA223.md): Piper PA-31 · Cottens, Switzerland · Accident · 1 fatal · Foreign investigation · Nov 10, 2011 · HB-LOT · Destroyed
  > The accident investigation is under the jurisdiction and control of the Swiss government. This report is for informational purposes only and contains only information released by or obtained from the Swiss government or the Swiss Accident Investigation Board.…
- [NTSB WPR12CA033](https://openairdocs.org/ntsb/WPR12CA033.md): Casler Scott CX-4 · San Carlos, AZ · Accident · No injuries · Data collection · Final report · Nov 9, 2011 · N5089Q · Substantial damage
  > The pilot's inadequate directional control during takeoff.
- [NTSB ERA12WA067](https://openairdocs.org/ntsb/ERA12WA067.md): Cessna 402 · Quibdo, Colombia · Incident · No injuries · Foreign investigation · Nov 4, 2011 · HK4417 · Minor damage
  > On November 4, 2011, about 1640 UTC, a Cessna 402C, Colombian registration HK4417, registered to and operated by AeroEjecutivos De Antioquia S.A. experienced collapse of the left main landing gear during the takeoff roll from El Carano Airport (SKUI), Quibdo,…
- [NTSB CEN12LA056](https://openairdocs.org/ntsb/CEN12LA056.md): Cessna 182K · Branson West, MO · Accident · No injuries · Limited investigation · Final report · Oct 30, 2011 · N2893R · Substantial damage
  > The pilot's failure to ensure that his seat was in a locked position before takeoff, which resulted in the seat sliding rearward and the subsequent loss of directional control.
- [NTSB DCA12WA007](https://openairdocs.org/ntsb/DCA12WA007.md): Boeing 737 - 800 · Faro, Portugal · Accident · No injuries · Foreign investigation · Oct 24, 2011 · EI-DPA · Substantial damage
  > TheAir AccidentInvestigation Unit (AAIU) ofIrelandhas notified the NTSB of an accidentinvolving a B737-8AS that occurred on October 20, 2011. The NTSBhas appointed a U.S. Accredited Representative to assist the AAIU investigationunder the provisions of ICAO…
- [NTSB ERA12CA040](https://openairdocs.org/ntsb/ERA12CA040.md): Engineering & Research 415-C · Mebane, NC · Accident · No injuries · Data collection · Final report · Oct 16, 2011 · N3760H · Substantial damage
  > The pilot's delay in aborting the takeoff.
- [NTSB OPS12IA041](https://openairdocs.org/ntsb/OPS12IA041.md): Cessna 172S · Daytona Beach, FL · Incident · No injuries · Incident investigation · Final report · Oct 15, 2011 · N488ER · 2 aircraft · No damage
  > The departing pilot's incorrect runway selection and non-compliance with an air traffic control clearance. Contributing to the incident was the air traffic controller's inadequate monitoring of the departing aircraft to ensure that the pilot complied with the…
- [NTSB CEN12CA029](https://openairdocs.org/ntsb/CEN12CA029.md): Hunt Sparrowhawk · Blair, NE · Accident · Minor injuries · Data collection · Final report · Oct 15, 2011 · N29HT · Substantial damage
  > The pilot/builder’s inadequate installation of a nosewheel steering component, which resulted in a shimmy and a loss of directional control during the takeoff roll.
- [NTSB WPR12FA010](https://openairdocs.org/ntsb/WPR12FA010.md): DG Flugzeugbau DG 1000S · Cle Elum, WA · Accident · 1 fatal · Field investigation · Final report · Oct 13, 2011 · N7760A · Substantial damage
  > The pilot’s failure to maintain airspeed and control after takeoff, which resulted in an aerodynamic stall.
- [NTSB ENG12IA001](https://openairdocs.org/ntsb/ENG12IA001.md): Boeing 757-251 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Oct 10, 2011 · N553NW · Minor damage
  > the return to service of overhauled airplane engine parts with undetected fatigue cracks, resulting in complete loss of engine power and uncontained engine failure. A contributing factor was the inadequate diffuser and HPT case inspection procedure.
- [NTSB ERA12CA022](https://openairdocs.org/ntsb/ERA12CA022.md): Aeronca 0-58A · Westmoreland, TN · Accident · No injuries · Data collection · Final report · Oct 9, 2011 · N46513 · Substantial damage
  > The pilot's inadequate visual lookout and failure to maintain clearance from an obstacle during takeoff.
- [NTSB ERA12LA016](https://openairdocs.org/ntsb/ERA12LA016.md): Cessna 180J · Norfolk, VA · Accident · No injuries · Limited investigation · Final report · Oct 5, 2011 · N180RN · Substantial damage
  > The pilot's inability to maintain directional control during takeoff for undetermined reasons. Contributing to the accident was the pilot's delayed decision to abort the takeoff.
- [NTSB ERA12CA013](https://openairdocs.org/ntsb/ERA12CA013.md): Loehle Loehle P-40 · Tullahoma, TN · Accident · Minor injuries · Data collection · Final report · Oct 3, 2011 · N414L · Substantial damage
  > The pilot's delayed decision to abort the takeoff.
- [NTSB CEN12CA003](https://openairdocs.org/ntsb/CEN12CA003.md): Sadler Terry Rans S-7 Courier · Riley, KS · Accident · Serious injuries · Data collection · Final report · Oct 1, 2011 · N2417T · Substantial damage
  > A total loss of engine power during takeoff due to fuel starvation as a result of the pilot’s inadequate preflight inspection and failure to ensure that the fuel shutoff valve was turned on before departure.
- [NTSB ERA11CA505](https://openairdocs.org/ntsb/ERA11CA505.md): Robinson Helicopter R44 · Clearwater, FL · Accident · Minor injuries · Data collection · Final report · Sep 27, 2011 · N982DH · Substantial damage
  > The certified flight instructor's delayed remedial action, which resulted in a loss of control and subsequent rollover.
- [NTSB ANC11CA112](https://openairdocs.org/ntsb/ANC11CA112.md): Cessna 180 · Haines, AK · Accident · No injuries · Data collection · Final report · Sep 27, 2011 · N3126D · Substantial damage
  > The pilot's loss of directional control during takeoff in a float-equipped airplane for an undetermined reason, which resulted in the airplane colliding with trees and the shore.
- [NTSB ANC11CA113](https://openairdocs.org/ntsb/ANC11CA113.md): Piper PA-12 · Talkeetna, AK · Accident · No injuries · Data collection · Final report · Sep 26, 2011 · N2945M · Substantial damage
  > The pilot’s decision to take off from an off-airport site in variable wind.
- [NTSB ERA11FA504](https://openairdocs.org/ntsb/ERA11FA504.md): Hutchinson Kenneth A Velocity RG · Sanford, NC · Accident · 1 fatal · Field investigation · Final report · Sep 25, 2011 · N360TV · Substantial damage
  > The pilot/owner's intentional flight of his airplane with known mechanical discrepancies (frozen turbocharger waste gate), which resulted in a partial loss of engine power and subsequent collision with trees and terrain shortly after takeoff. Contributing to…
- [NTSB ANC11CA106](https://openairdocs.org/ntsb/ANC11CA106.md): Piper PA-12 · Beluga, AK · Accident · No injuries · Data collection · Final report · Sep 23, 2011 · N78564 · Substantial damage
  > The pilot's decision to take off uphill into rising terrain.
- [NTSB ANC11CA096](https://openairdocs.org/ntsb/ANC11CA096.md): Cessna 170B · Fairbanks, AK · Accident · No injuries · Data collection · Final report · Sep 20, 2011 · N2810C · Substantial damage
  > The pilot's failure to maintain control of the airplane while taking off with a gusting crosswind.
- [NTSB ERA11LA496](https://openairdocs.org/ntsb/ERA11LA496.md): Aero Adventure Zephyr II · Sylacauga, AL · Accident · 1 fatal · Limited investigation · Final report · Sep 18, 2011 · N3577F · Substantial damage
  > The pilot's incapacitation due to a heart attack during takeoff, which led to an in-flight loss of airplane control.
- [NTSB CEN11LA651](https://openairdocs.org/ntsb/CEN11LA651.md): North American AT-6 · Nunica, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 2011 · N217RK · Substantial damage
  > The loss of engine power due to fuel starvation during climbout for undetermined reasons, because postaccident examination of the fuel system did not reveal any discrepancies that would have precluded normal engine operation. Contributing to the accident was…
- [NTSB ANC11CA105](https://openairdocs.org/ntsb/ANC11CA105.md): Piper PA-18-150 · Bethel, AK · Accident · No injuries · Data collection · Final report · Sep 17, 2011 · N82907 · Substantial damage
  > The pilot's delayed decision to abort the takeoff.
- [NTSB ANC11CA102](https://openairdocs.org/ntsb/ANC11CA102.md): Cessna 180 · Ambler, AK · Accident · No injuries · Data collection · Final report · Sep 13, 2011 · N9019C · Substantial damage
  > The pilot's decision to takeoff with a tailwind, which resulted in a runway excursion.
- [NTSB CEN11LA642](https://openairdocs.org/ntsb/CEN11LA642.md): Piper PA16 · Muskegan, MI · Accident · No injuries · Limited investigation · Final report · Sep 11, 2011 · N5383H · Substantial damage
  > The pilot's loss of directional control during the takeoff roll and the flight instructor's inability to apply remedial action due to the opposite corrective control inputs by the pilot.
- [NTSB ANC11CA094](https://openairdocs.org/ntsb/ANC11CA094.md): Piper PA-12 · North Pole, AK · Accident · No injuries · Data collection · Final report · Sep 5, 2011 · N78463 · Substantial damage
  > The pilot's failure to maintain adequate airspeed during takeoff, resulting in an aerodynamic stall and collision with the water.
- [NTSB WPR11FA424](https://openairdocs.org/ntsb/WPR11FA424.md): Consolidated Aeronautics Lake LA-4-200 · Lakeport, CA · Accident · Serious injuries · Field investigation · Final report · Sep 2, 2011 · N80033 · Substantial damage
  > The pilot's decision to continue the takeoff with reduced engine power, which resulted in a collision with terrain during the takeoff initial climb. Contributing to the accident was the partial loss of engine power for reasons that could not be determined…
- [NTSB WPR11CA418](https://openairdocs.org/ntsb/WPR11CA418.md): Christen Industries A-1 · Dorris, CA · Accident · Minor injuries · Data collection · Final report · Aug 30, 2011 · N2868A · Substantial damage
  > The pilot’s failure to maintain lateral aircraft control while taking off with a gusting crosswind.
- [NTSB CEN11LA610](https://openairdocs.org/ntsb/CEN11LA610.md): Grumman Acft ENG Cor-Schweizer G-164A · Monette, AR · Accident · No injuries · Limited investigation · Final report · Aug 29, 2011 · N48378 · Substantial damage
  > The fracture of the throttle cable in tensile overstress because of wear damage, which resulted in the partial loss of engine power.
- [NTSB CEN11LA601](https://openairdocs.org/ntsb/CEN11LA601.md): Van's RV-12 · Windom, MN · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 2011 · N73712 · Substantial damage
  > The pilot's loss of airplane control after liftoff due to his distraction with the unsecured canopy, which he did not lock before takeoff.
- [NTSB CEN11WA617](https://openairdocs.org/ntsb/CEN11WA617.md): Robinson R44 · St. Ferdinand, Canada · Accident · 4 fatal · Foreign investigation · Aug 28, 2011 · C-GEBY · Substantial damage
  > On August 27, 2011, at 2115 eastern daylight time, a Robinson R44 helicopter, C-GEBY, sustained substantial damage when it impacted terrain shortly after takeoff near St. Ferdinand, Quebec, Canada. The pilot and three passengers sustained fatal injuries. The…
- [NTSB CEN11CA600](https://openairdocs.org/ntsb/CEN11CA600.md): Cessna 182C · Grand Marais, MN · Accident · No injuries · Data collection · Final report · Aug 27, 2011 · N9011T · Substantial damage
  > The pilot's delayed decision to land the airplane when he realized the airplane's performance was insufficient to clear approaching terrain during the initial climb after takeoff. Contributing to the accident was the pilot's inadequate preflight planning.
- [NTSB CEN11CA662](https://openairdocs.org/ntsb/CEN11CA662.md): Piper PA-30 · Saguache, CO · Accident · No injuries · Data collection · Final report · Aug 26, 2011 · N75BA · Substantial damage
  > The pilot's failure to maintain airplane control during the aborted takeoff.
- [NTSB CEN11CA627](https://openairdocs.org/ntsb/CEN11CA627.md): Robinson Helicopter R44 · Batesville, TX · Accident · No injuries · Data collection · Final report · Aug 26, 2011 · N99FJ · Substantial damage
  > The pilot’s inadequate preflight inspection that failed to ensure all tie-down clamps were removed prior to takeoff, which resulted in the helicopter’s dynamic rollover.
- [NTSB CEN11FA597](https://openairdocs.org/ntsb/CEN11FA597.md): Nichols Lancair 235 · Heath, OH · Accident · 1 fatal · Field investigation · Final report · Aug 25, 2011 · N777BN · Destroyed
  > The pilot's failure to obtain adequate familiarization with the accident airplane type before the accident flight, which resulted in his failure to maintain airplane control during takeoff.

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

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