# NTSB investigations, 2010: Initial climb

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

## Latest cases

- [NTSB ERA11LA103](https://openairdocs.org/ntsb/ERA11LA103.md): Cessna 152 · Wimauma, FL · Accident · No injuries · Limited investigation · Final report · Dec 31, 2010 · N28BA · Substantial damage
  > The mechanic/pilot's failure to detect a visible exhaust gas leak and cracked cylinder head immediately prior to the accident flight, which resulted in a partial loss of engine power during initial climb. Contributing to the accident was an inadequate…
- [NTSB WPR11LA080](https://openairdocs.org/ntsb/WPR11LA080.md): Schaefer Kitfox 4 · Glendale, AZ · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 2010 · N95FT · Substantial damage
  > The pilot's failure to recognize the onset of and to prevent an aerodynamic stall at low altitude. Contributing to the accident were the manufacturer’s conflicting guidance about the power setting for takeoff and the pilot’s decision to conduct a…
- [NTSB ERA11FA094](https://openairdocs.org/ntsb/ERA11FA094.md): Piper PA-28-151 · Spencer, MA · Accident · 1 fatal · Field investigation · Final report · Dec 22, 2010 · N30ZZ · Substantial damage
  > The in-flight collision with a tree while returning to land for undetermined reasons.
- [NTSB ERA11WA088](https://openairdocs.org/ntsb/ERA11WA088.md): Piper PA-32R-301T · Roma, Italy · Accident · 1 fatal · Foreign investigation · Dec 8, 2010 · N58SE · Destroyed
  > On December 8, 2010, at 1443 UTC, a Piper PA-32R-301T, N58SE, registered to Aircraft Guaranty Title Corporation Trustee,collided with a bus depot after departing runway 34 from Roma Urbe Airport (LIRU), Roma, Italy. The airplane had been recently purchased by…
- [NTSB WPR11LA071](https://openairdocs.org/ntsb/WPR11LA071.md): Boeing 767 · Pago Pago, Antarctica · Accident · Serious injuries · Limited investigation · Final report · Dec 3, 2010 · N584HA · No damage
  > The airplane’s encounter with convectively-induced turbulence, which resulted in serious injury to one flight attendant.
- [NTSB ERA11LA079](https://openairdocs.org/ntsb/ERA11LA079.md): Easler Kelly Rans S6ES · St. Augustine, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 2010 · N26PP · Substantial damage
  > A total loss of engine power during initial climb for undetermined reasons.
- [NTSB CEN11CA098](https://openairdocs.org/ntsb/CEN11CA098.md): Air Tractor AT-602 · Gregory, AR · Accident · No injuries · Data collection · Final report · Dec 2, 2010 · N9145H · Substantial damage
  > The pilot’s inadequate preflight inspection and failure to detect water contaminated fuel, which resulted in a loss of engine power during takeoff.
- [NTSB CEN11WA094](https://openairdocs.org/ntsb/CEN11WA094.md): Cessna F150 · Linköping, Sweden · Accident · 1 fatal · Foreign investigation · Dec 1, 2010 · SE-IGU · Substantial damage
  > On December 1, 2010, at 1711 coordinate universal time, a Cessna F150H, SE-IGU, was substantially damaged upon impact with terrain after initial takeoff from the Linköping Airport (ESSL), Linköping, Sweden. The pilot was fatally injured. The airplane was…
- [NTSB WPR11FA059](https://openairdocs.org/ntsb/WPR11FA059.md): Mooney M20R · Hollister, CA · Accident · 1 fatal · Field investigation · Final report · Nov 25, 2010 · VH-PPA · Substantial damage
  > The pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.
- [NTSB CEN11LA078](https://openairdocs.org/ntsb/CEN11LA078.md): Swiezy Glasair SHA · North Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Nov 19, 2010 · N729RS · Substantial damage
  > The pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and hard landing.
- [NTSB WPR11FA045](https://openairdocs.org/ntsb/WPR11FA045.md): Eurocopter AS350B2 · Pacoima, CA · Accident · No injuries · Field investigation · Final report · Nov 12, 2010 · N1231A · Substantial damage
  > The contamination of a spool bearing in the power turbine governor during manufacture, which led to the bearing’s failure in flight, a subsequent loss of engine power during departure, and the resultant hard landing.
- [NTSB ERA11FA054](https://openairdocs.org/ntsb/ERA11FA054.md): Piper PA-44-180 · West Palm Beach, FL · Accident · 4 fatal · Field investigation · Final report · Nov 11, 2010 · N883FT · Substantial damage
  > The failure of both the pilot and the certified flight instructor to ensure that the left fuel selector was in the on position for takeoff and their failure to follow the proper procedures when the left engine lost power shortly after takeoff, resulting in an…
- [NTSB CEN11CA062](https://openairdocs.org/ntsb/CEN11CA062.md): Cessna 172 · Pineville, LA · Accident · No injuries · Data collection · Final report · Nov 9, 2010 · N9747L · Substantial damage
  > The pilot/mechanic’s improper inspection of the airplane following the engine installation.
- [NTSB ERA11LA049](https://openairdocs.org/ntsb/ERA11LA049.md): Airborne Classic · Stow, MA · Accident · Serious injuries · Limited investigation · Final report · Nov 6, 2010 · N582YA · Substantial damage
  > The operator's inadequate engine maintenance, which resulted in a total loss of engine power. Contributing to the accident was the pilot's decision to conduct a downwind takeoff.
- [NTSB DCA11WA008](https://openairdocs.org/ntsb/DCA11WA008.md): Beech 1900 · Karachi, Pakistan · Accident · 21 fatal · Foreign investigation · Nov 5, 2010 · AP-BJD · Destroyed
  > On November 5, 2010, a JS Air Pakistan, a Hawker Beechcraft B-1900, registration AP-BJD, crashed shortly after takeoff from Karachi-Jinnah International Airport (KHI), Karachi, Pakistan. All 17 passengers and 4 crewmembers onboard were fatally injured, and…
- [NTSB CEN11LA049](https://openairdocs.org/ntsb/CEN11LA049.md): Luscombe 8A · Schaumburg, IL · Accident · 1 fatal · Limited investigation · Final report · Nov 1, 2010 · N71823 · Substantial damage
  > The pilot did not maintain airspeed following a loss of engine power during takeoff climb, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power due to the unlocked engine primer.
- [NTSB CEN11LA045](https://openairdocs.org/ntsb/CEN11LA045.md): Walker Kenneth Sonex · San Angelo, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 29, 2010 · N234KS · Substantial damage
  > The pilot's loss of airplane control. Contributing to the accident was the pilot's impairment due to alcohol.
- [NTSB CEN11LA043](https://openairdocs.org/ntsb/CEN11LA043.md): Piper PA46-500TP · Port Mansfield, TX · Accident · No injuries · Limited investigation · Final report · Oct 29, 2010 · N234PM · Substantial damage
  > The total loss of engine power for undetermined reasons because examination of the airframe and engine did not reveal any anomalies that would have contributed to the loss of engine power.
- [NTSB CEN11CA047](https://openairdocs.org/ntsb/CEN11CA047.md): Aardema Robert John 1 Aardema RAG WNG SP · Oshtemo, MI · Accident · No injuries · Data collection · Final report · Oct 29, 2010 · N768BA · Substantial damage
  > The failure of the ignition system wiring, which resulted in a total loss of engine power.
- [NTSB CEN11LA041](https://openairdocs.org/ntsb/CEN11LA041.md): Donegan Benton Kitfox II · Seguin, TX · Accident · 1 fatal · Limited investigation · Final report · Oct 27, 2010 · N8700T · Substantial damage
  > The pilot’s failure to ensure adequate fuel on board and subsequent failure to maintain airplane control following an engine failure due to fuel exhaustion.
- [NTSB CEN11IA106](https://openairdocs.org/ntsb/CEN11IA106.md): Piper PA-46-500TP · Olathe, KS · Incident · No injuries · Incident investigation · Final report · Oct 21, 2010 · N767TP · No damage
  > The loss of engine power for undetermined reasons.
- [NTSB ERA11CA077](https://openairdocs.org/ntsb/ERA11CA077.md): Antares MA-33M R582 · Rising Fawn, GA · Accident · Serious injuries · Data collection · Final report · Oct 17, 2010 · N49FP · Substantial damage
  > The student pilot's failure to relinquish control of the weight-shift control aircraft to the certified flight instructor, which resulted in an inadvertent stall.
- [NTSB ERA11LA022](https://openairdocs.org/ntsb/ERA11LA022.md): Newcomer RV6 · Monticello, GA · Accident · 2 fatal · Limited investigation · Final report · Oct 16, 2010 · N13KN · Substantial damage
  > The pilot's loss of aircraft control during the initial climb.
- [NTSB ERA11CA020](https://openairdocs.org/ntsb/ERA11CA020.md): Mooney M20E · New Smyrna Beach, FL · Accident · Minor injuries · Data collection · Final report · Oct 13, 2010 · N5743Q · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in the loss of engine power due to water contaminated fuel.
- [NTSB CEN11CA071](https://openairdocs.org/ntsb/CEN11CA071.md): Grumman G-164 · Michigan, ND · Accident · No injuries · Data collection · Final report · Oct 11, 2010 · N554Y · Substantial damage
  > The pilot's failure to abort the takeoff roll following a noticeable loss of engine power due to low engine compression and a magneto failure.
- [NTSB WPR11LA013](https://openairdocs.org/ntsb/WPR11LA013.md): Beech C24 · Blanding, UT · Accident · No injuries · Limited investigation · Final report · Oct 10, 2010 · N5063M · Substantial damage
  > The pilot’s failure to attain a climb gradient sufficient to clear the rising terrain, which resulted in his decision to make a forced landing on a road.
- [NTSB ERA11LA009](https://openairdocs.org/ntsb/ERA11LA009.md): Cessna 182P · Columbia, SC · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 2010 · N21415 · Substantial damage
  > A total loss of engine power due to a loss of lubrication after the engine experienced a piston ring failure for undetermined reasons.
- [NTSB WPR11FA002](https://openairdocs.org/ntsb/WPR11FA002.md): Cessna 310 · Avalon, CA · Accident · Serious injuries · Field investigation · Final report · Oct 3, 2010 · N310XX · Substantial damage
  > The pilot's improper setting of the left engine fuel selector valve, which resulted in fuel starvation of the left engine immediately after takeoff. Contributing to the accident was the pilot's decision to try to depart ahead of developing weather, which…
- [NTSB CEN11LA001](https://openairdocs.org/ntsb/CEN11LA001.md): Cessna 172D · Durango, CO · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 2010 · N2593 · Substantial damage
  > A total loss of engine power due to the pilot inadvertently moving the fuel selector to the OFF position. Contributing to the accident was the pilot's unfamiliarity with this model accident airplane.
- [NTSB ERA11WA004](https://openairdocs.org/ntsb/ERA11WA004.md): Cessna 185 · Nazca, Peru · Accident · 6 fatal · Foreign investigation · Oct 2, 2010 · OB-1808 · Substantial damage
  > On October 2, 2010, about 2102 Universal Coordinated Time (UTC), a Cessna 185, Peruvian registration OB-1808, operated by Air Nasca S.A.C., on a commercial air tour flight, was substantially damaged, when it impacted terrain after a loss of power during…
- [NTSB CEN11CA016](https://openairdocs.org/ntsb/CEN11CA016.md): Kevin Wilkinson Easy Eagle 1 · Central City, NE · Accident · Minor injuries · Data collection · Final report · Oct 2, 2010 · N44KW · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB CEN11CA002](https://openairdocs.org/ntsb/CEN11CA002.md): Gingerich Alton & Slagel Dean Christavia MK 1 · Nappanee, IN · Accident · No injuries · Data collection · Final report · Oct 1, 2010 · N9049S · Substantial damage
  > The total loss of engine power for undetermined reasons.
- [NTSB CEN10LA586](https://openairdocs.org/ntsb/CEN10LA586.md): Cessna 175 · Deming, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 2010 · N9431B · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB CEN10LA573](https://openairdocs.org/ntsb/CEN10LA573.md): Cessna 152 · Tea, SD · Accident · No injuries · Limited investigation · Final report · Sep 24, 2010 · N5364H · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.
- [NTSB CEN10CA549](https://openairdocs.org/ntsb/CEN10CA549.md): Cessna 182D · Houston, TX · Accident · No injuries · Data collection · Final report · Sep 20, 2010 · N9071X · Substantial damage
  > The loss of engine power during the initial climb due to decreased engine oil quantity and pressure as a result of the engine's oil cap not being adequately secured.
- [NTSB ERA10WA489](https://openairdocs.org/ntsb/ERA10WA489.md): Piper PA-31-350 · South Bimini, Bahamas · Accident · No injuries · Foreign investigation · Sep 19, 2010 · N84859 · Substantial damage
  > On September 19, 2010, at 1440 eastern daylight time, a Piper PA31-350, N84859, registered to Spirit Air Inc, and operated by Pioneer Air Services was on initial climb out when the lower half of the main cabin door came open. The pilot reversed his course and…
- [NTSB ERA10LA486](https://openairdocs.org/ntsb/ERA10LA486.md): Piper PA-28R-200 · Barnwell, SC · Accident · No injuries · Limited investigation · Final report · Sep 19, 2010 · N799SQ · Substantial damage
  > The failure of the No. 1 connecting rod end cap for undetermined reasons, which resulted in a total loss of engine power.
- [NTSB ERA10LA484](https://openairdocs.org/ntsb/ERA10LA484.md): Bell OH-58A · Covington, TN · Accident · No injuries · Limited investigation · Final report · Sep 18, 2010 · N38FA · Substantial damage
  > A loss of engine power due to contamination of the helicopter's fuel supply.
- [NTSB CEN10LA571](https://openairdocs.org/ntsb/CEN10LA571.md): Ca Tecnam P2004 Bravo · Mason, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 2010 · N508LM · Substantial damage
  > A total loss of engine power for undetermined reasons, which resulted in a forced landing to a bean field.
- [NTSB CEN10LA556](https://openairdocs.org/ntsb/CEN10LA556.md): Robinson Helicopter R44 II · Duluth, MN · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 2010 · N145DM · Destroyed
  > The pilot's failure to identify and arrest the helicopter's descent due to spatial disorientation.
- [NTSB OPS10IA574](https://openairdocs.org/ntsb/OPS10IA574.md): Airbus Industrie A320-214 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · Sep 16, 2010 · N122US · 2 aircraft · No damage
  > The Local North Controller's issuance of a left-turn heading to the Airbus without establishing the position and heading of the Beech. Contributing to the incident was the Local South Controller's distraction with a ground movement operation and lack of…
- [NTSB ANC10LA094](https://openairdocs.org/ntsb/ANC10LA094.md): Piper PA-18 · Dillingham, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 2010 · N9699P · 2 aircraft · Substantial damage
  > Both pilots’ failure to see and avoid each other during initial climb, resulting in a midair collision. Contributing to the accident was the pilot of N9699P’s inability to use his airplane's radio for air traffic advisories.
- [NTSB ANC10LA087](https://openairdocs.org/ntsb/ANC10LA087.md): Cessna 185A · Paxson, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 12, 2010 · N4038Y · Substantial damage
  > The pilot's decision to make a climbing turn close to the ground in gusting wind at a low airspeed, resulting in a loss of control and collision with terrain.
- [NTSB ANC10CA090](https://openairdocs.org/ntsb/ANC10CA090.md): Cessna 150L · Kenai, AK · Accident · No injuries · Data collection · Final report · Sep 12, 2010 · N1612Q · Substantial damage
  > The pilot's decision to takeoff from a remote lake after overloading the airplane. Contributing to the accident was the pilot's lack of a seaplane rating.
- [NTSB ERA10LA475](https://openairdocs.org/ntsb/ERA10LA475.md): Cessna 150 · Fayetteville, WV · Accident · Serious injuries · Limited investigation · Final report · Sep 10, 2010 · N7922E · Substantial damage
  > A loss of engine power due to the failure of the left magneto system’s distributor gear as a result of the improper maintenance of the magnetos by maintenance personnel.
- [NTSB WPR10FA449](https://openairdocs.org/ntsb/WPR10FA449.md): Piper PA-32RT-300 · Las Vegas, NV · Accident · 2 fatal · Field investigation · Final report · Sep 6, 2010 · N36072 · Substantial damage
  > The pilot's inability to maintain a positive rate of climb after takeoff for undetermined reasons.
- [NTSB CEN10WA534](https://openairdocs.org/ntsb/CEN10WA534.md): Cessna 208 · Pointe a Pitre, Guadeloupe · Accident · Minor injuries · Foreign investigation · Sep 5, 2010 · F-OIXZ · Substantial damage
  > On September 5, 2010, at 1919 coordinated universal time, a Cessna 208B, French registered F-OIXZ, operated by Tropic Airlines, was substantially damaged during a forced landing near Pointe a Pitre, Guadeloupe. Visual meteorological conditions prevailed at…
- [NTSB OPS10IA538](https://openairdocs.org/ntsb/OPS10IA538.md): Boeing 737-7H4 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Sep 4, 2010 · N907WN · 2 aircraft · No damage
  > Failure of the air traffic controller to exercise positive control of the situation by issuing clear and timely control instructions to the helicopter pilot. Contributing to the incident was delay by the helicopter pilot in responding to instructions issued…
- [NTSB ERA10FA464](https://openairdocs.org/ntsb/ERA10FA464.md): Cessna 150H · DeLand, FL · Accident · 2 fatal · Field investigation · Final report · Sep 4, 2010 · N23471 · Substantial damage
  > The pilot's failure to maintain adequate airspeed and airplane control during the initial climb, which resulted in an aerodynamic stall, wire strike, and subsequent impact with the ground.
- [NTSB ERA10LA463](https://openairdocs.org/ntsb/ERA10LA463.md): Quicksilver MX-2 · Lake City, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 2010 · N7108Z · Substantial damage
  > A partial loss of engine power for undetermined reasons.

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?year=2010&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") = 2010
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?year=2010

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