# NTSB investigations: 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 48 of 412 · 20,559 cases

## Cases, newest first

- [NTSB WPR11FA166](https://openairdocs.org/ntsb/WPR11FA166.md): Beech 200 · Long Beach, CA · Accident · 5 fatal · Field investigation · Final report · Mar 16, 2011 · N849BM · Substantial damage
  > The pilot's failure to maintain directional control of the airplane during a momentary interruption of power from the left engine during the initial takeoff climb. Contributing to the accident was the power interruption due to water contamination of the fuel,…
- [NTSB OPS11IA410](https://openairdocs.org/ntsb/OPS11IA410.md): Boeing 757-232 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Mar 11, 2011 · N693DL · No damage
  > The air traffic controllers’ failure to adhere to required radar identification procedures, which resulted in loss of separation between the departing Boeing 757 and three other airplanes. Contributing to the incident was the pilots’ inadequate preflight…
- [NTSB WPR11FA153](https://openairdocs.org/ntsb/WPR11FA153.md): Volin Kitfox Classic IV · Myrtle Creek, OR · Accident · Serious injuries · Field investigation · Final report · Mar 4, 2011 · N4374K · Substantial damage
  > The pilot's encounter with a windshear/downdraft that exceeded the climb performance capabilities of the airplane.
- [NTSB ERA11WA362](https://openairdocs.org/ntsb/ERA11WA362.md): Cessna 152 · Kingston, Jamaica · Accident · Minor injuries · Foreign investigation · Mar 4, 2011 · 6Y-JGA · Substantial damage
  > On March 4, 2011, about 1000 eastern standard time, a Cessna 152, Jamaican registration 6Y-JGA, was substantially damaged during a forced landing, following a total loss of engine power during initial climb from Norman Manley International Airport (MKJP),…
- [NTSB CEN11LA186](https://openairdocs.org/ntsb/CEN11LA186.md): Gadbois Eugene W Apex CROSS-5 · Lago Vista, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 11, 2011 · N751EW · Substantial damage
  > The simultaneous loss of engine and electrical power after takeoff for undetermined reasons.
- [NTSB DCA11WA024](https://openairdocs.org/ntsb/DCA11WA024.md): Raytheon Hawker · Sulaimanyia, Iraq · Accident · 7 fatal · Foreign investigation · Feb 4, 2011 · OD-SKY · Destroyed
  > On February 4, 2011 about 1449 UTC, OD-SKY, a Hawker Beechcraft HS-850XP, registered to Club Aviation S.A.L and operated by Sky Lounge services S.A.L., crashed during the initial takeoff climb at Suliamaniyah International Airport, Iraq. The 3 crew members…
- [NTSB CEN11LA169](https://openairdocs.org/ntsb/CEN11LA169.md): Cessna 172P · Chesapeake, OH · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 2011 · N55212 · Substantial damage
  > The partial loss of engine power due to carburetor icing and the pilot’s delayed use of carburetor heat and failure to attain the proper touchdown point on the runway during the precautionary landing.
- [NTSB CEN11LA161](https://openairdocs.org/ntsb/CEN11LA161.md): Piper PA-28-235 · Matador, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 2011 · N9478W · Substantial damage
  > The loss of engine power during initial climb for undetermined reasons.
- [NTSB ERA11LA114](https://openairdocs.org/ntsb/ERA11LA114.md): Diamond Aircraft Ind DA 20-A1 · Pompano Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 14, 2011 · N840DF · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ERA11WA119](https://openairdocs.org/ntsb/ERA11WA119.md): Avions Robin DR400 · Guidonia Montecelio, Italy · Accident · 1 fatal · Foreign investigation · Jan 11, 2011 · I-ITAV · Destroyed
  > On January 11, 2011, about 1430 universal coordinated time, an Avions Pierre Robin, DR400/180R, Italian registration I-ITAV, crashed during takeoff, while towing a glider, and was destroyed by fire. The airplane was departing Guidonia Airport (LIRG), Guidonia…
- [NTSB WPR11LA095](https://openairdocs.org/ntsb/WPR11LA095.md): Piper PA-22-150 · Lopez, WA · Accident · No injuries · Limited investigation · Final report · Jan 9, 2011 · N5850D · Substantial damage
  > A loss of engine power during initial climb for undetermined reasons.
- [NTSB CEN11WA159](https://openairdocs.org/ntsb/CEN11WA159.md): Beech B200 · Montpellier, France · Incident · Minor injuries · Foreign investigation · Jan 7, 2011 · F-GMPO · Minor damage
  > The accident investigation is under the jurisdiction and control of the French government. This report is for informational purposes only and contains only information released by or obtained from the French government or Bureau d’Enquêtes et d’Analyses.…
- [NTSB CEN11FA141](https://openairdocs.org/ntsb/CEN11FA141.md): Columbia Aircraft Mfg LC41-550FG · Midlothian, TX · Accident · 2 fatal · Field investigation · Final report · Jan 5, 2011 · N1393T · Substantial damage
  > The engine's loss of power during takeoff for reasons that could not be determined because no engine anomalies were discovered during the postaccident examination.
- [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.

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=49

## 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 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?page=48

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