# 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 25 of 412 · 20,559 cases

## Cases, newest first

- [NTSB CEN18LA317](https://openairdocs.org/ntsb/CEN18LA317.md): Cessna 120 · Pomona, MO · Accident · No injuries · Limited investigation · Final report · Aug 6, 2018 · N76524 · Substantial damage
  > The pilot's inadequate fuel management, which resulted in fuel starvation and a forced landing.
- [NTSB ERA18LA211](https://openairdocs.org/ntsb/ERA18LA211.md): Schweizer SGS233 · Churchville, MD · Accident · No injuries · Limited investigation · Final report · Aug 5, 2018 · N2832H · Substantial damage
  > The pilots' decision to take off from a wet, upsloping turf runway with a quartering tailwind and elevated density altitude conditions, which degraded takeoff and climb performance and resulted in the glider flight instructor's decision to discontinue the…
- [NTSB GAA18CA471](https://openairdocs.org/ntsb/GAA18CA471.md): Cessna 172 · Dowagiac, MI · Accident · Minor injuries · Data collection · Final report · Aug 4, 2018 · N8994V · Substantial damage
  > The pilot's failure to maintain bank control during takeoff.
- [NTSB GAA18CA469](https://openairdocs.org/ntsb/GAA18CA469.md): Rans S7 · Kenai, AK · Accident · Minor injuries · Data collection · Final report · Aug 4, 2018 · N8443B · Substantial damage
  > The pilot's exceedance of the airplane's climb capability due to his use of full flaps during a short-field takeoff, his failure to attain a positive climb rate after takeoff, and his exceedance of the airplane’s critical angle of attack, which resulted in an…
- [NTSB ERA18FA208](https://openairdocs.org/ntsb/ERA18FA208.md): Champion 8GCBC · Foley, AL · Accident · 2 fatal · Field investigation · Final report · Aug 4, 2018 · N424A · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall and spin at an altitude that was too low for recovery.
- [NTSB ANC18WA062](https://openairdocs.org/ntsb/ANC18WA062.md): Cessna 180 · Gold Bridge, Canada · Accident · 2 fatal · Foreign investigation · Aug 1, 2018 · C-FCDQ · Substantial damage
  > On August 1, 2018, about 1245 Pacific daylight time, a Canadian registered float-equipped Cessna 180, C-FCDQ, operated by Fort Langley Air Ltd., was substantially damaged after impacting the surface of Lake Tyaughton, British Columbia, shortly after takeoff.…
- [NTSB WPR18LA205](https://openairdocs.org/ntsb/WPR18LA205.md): Cessna 177 · San Diego/El Cajon, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 28, 2018 · N3477T · Substantial damage
  > The pilot’s inadequate preflight planning, which resulted in his exceedance of the airplane's maximum gross weight, which lead to the airplane's poor climb performance, and a subsequent loss of control and impact with terrain.
- [NTSB ERA18WA219](https://openairdocs.org/ntsb/ERA18WA219.md): Cessna 210 · Sao Felix do Xingu, Brazil · Accident · 3 fatal · Foreign investigation · Jul 27, 2018 · PP-MMR · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on July 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…
- [NTSB ERA18FA200](https://openairdocs.org/ntsb/ERA18FA200.md): Piper PA24 · Palatka, FL · Accident · 2 fatal · Field investigation · Final report · Jul 27, 2018 · N6427P · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and a loss of control.
- [NTSB CEN18LA301](https://openairdocs.org/ntsb/CEN18LA301.md): Flightstar SC II · Painesville, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 2018 · N953RJ · Substantial damage
  > The student pilot’s failure to maintain an airspeed below flight speed during a practice taxi run, which resulted in the airplane inadvertently becoming airborne. Once airborne, the reduced engine power due to an improper propeller pitch setting and…
- [NTSB GAA18CA454](https://openairdocs.org/ntsb/GAA18CA454.md): Cessna 172 · Meadow Lakes, AK · Accident · No injuries · Data collection · Final report · Jul 25, 2018 · N171Q · Substantial damage
  > The pilot’s selection of the wrong fuel tank for departure, which resulted in fuel starvation and the subsequent total loss of engine power.
- [NTSB ERA18FA197](https://openairdocs.org/ntsb/ERA18FA197.md): Piper PA32R · Lincolnton, NC · Accident · 2 fatal · Field investigation · Final report · Jul 24, 2018 · N38523 · Substantial damage
  > The noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing the accident was the pilot's self-induced pressure to complete…
- [NTSB WPR18FA200](https://openairdocs.org/ntsb/WPR18FA200.md): De Havilland DH112 Venom · Sheboygan, WI · Accident · 1 fatal · Field investigation · Final report · Jul 20, 2018 · N747J · Destroyed
  > The airplane's encounter with wake turbulence from the lead airplane in the formation flight, which resulted in a compressor stall and the airplane's subsequent inability to climb.
- [NTSB WPR18LA204](https://openairdocs.org/ntsb/WPR18LA204.md): Microlites Ptyltd Dragonfly B · Buckley, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 19, 2018 · N7008Z · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ANC18FA055](https://openairdocs.org/ntsb/ANC18FA055.md): De Havilland DHC-2 · Willow, AK · Accident · 1 fatal · Class 2 · Field · Final report · Jul 19, 2018 · N9878R · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack during departure climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the airplane beyond its allowable gross weight and center…
- [NTSB CEN18WA279](https://openairdocs.org/ntsb/CEN18WA279.md): Cessna 150 · Tortola, British Virgin Islands · Accident · 1 fatal · Foreign investigation · Jul 18, 2018 · N66778 · Substantial damage
- [NTSB WPR18FA198](https://openairdocs.org/ntsb/WPR18FA198.md): Ryan Navion · Truckee, CA · Accident · 2 fatal · Field investigation · Final report · Jul 17, 2018 · N5329K · Substantial damage
  > A loss of engine power for reasons that could not be determined.
- [NTSB WPR18LA196](https://openairdocs.org/ntsb/WPR18LA196.md): Cassutt Iiim · Rosamond, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 14, 2018 · N43SJ · Substantial damage
  > The pilot's failure to maintain adequate airspeed during a low-altitude maneuver after a partial loss of engine power, which resulted in exceedance of the airplane’s critical angle of attack and a subsequent accelerated stall. Contributing to the accident was…
- [NTSB ERA18WA207](https://openairdocs.org/ntsb/ERA18WA207.md): Aero Eli Servizi Yo-Yo 222 · Musile del Piave, Italy · Accident · 1 fatal · Foreign investigation · Jul 13, 2018 · I-C881 · Destroyed
  > The government of Italy has notified the NTSB of an accident involving a Aero Eli Servizi Yo-Yo 222 helicopter that occurred on July 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…
- [NTSB CEN18WA261](https://openairdocs.org/ntsb/CEN18WA261.md): Robinson R44 Raven I · Kanaš, Slovakia · Accident · 1 fatal · Foreign investigation · Jul 7, 2018 · OM-TTM · Destroyed
  > On July 7, 2018, at 1640 coordinated universal time, a Robinson R22 Raven 1, OM-TTM, impacted powerlines during takeoff near Kanaš, Slovak Republic. The helicopter was destroyed. The pilot sustained fatal injuries. The flight was originating at the time of…
- [NTSB WPR18FA188](https://openairdocs.org/ntsb/WPR18FA188.md): Hughes 369 · Majuro · Accident · 2 fatal · Field investigation · Final report · Jul 4, 2018 · N8648F · Destroyed
  > The pilot's failure to maintain clearance above the surface of the ocean.
- [NTSB ERA18LA181](https://openairdocs.org/ntsb/ERA18LA181.md): Beech 35B33 · Berlin, MD · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 29, 2018 · N9745Y · Substantial damage
  > The failure of the No. 3 cylinder exhaust valve, which resulted in the total loss of engine power during takeoff.
- [NTSB ANC18LA051](https://openairdocs.org/ntsb/ANC18LA051.md): Piper PA18 · Anchorage, AK · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 29, 2018 · N7675D · Substantial damage
  > The total loss of engine power due to fuel starvation for reasons that could not be determined, which resulted in impact with and subsequent sliding across terrain.
- [NTSB ERA18FA180](https://openairdocs.org/ntsb/ERA18FA180.md): Cessna 150J · Manteo, NC · Accident · 1 fatal · Field investigation · Final report · Jun 27, 2018 · N60111 · Destroyed
  > A loss of control due to the banner tow rope becoming entangled with the left horizontal stabilizer in crosswind conditions.
- [NTSB ERA18FA174](https://openairdocs.org/ntsb/ERA18FA174.md): Cessna 172 · Diamondhead, MS · Accident · 1 fatal · Field investigation · Final report · Jun 22, 2018 · N7239Q · Destroyed
  > The student pilot's failure to retract the flaps following landing and the stall/mush that resulted during the subsequent full-flap takeoff and initial climb.
- [NTSB ERA18LA172](https://openairdocs.org/ntsb/ERA18LA172.md): Mooney M20J · Monroe, NC · Accident · No injuries · Limited investigation · Final report · Jun 19, 2018 · N201FD · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA18LA169](https://openairdocs.org/ntsb/ERA18LA169.md): Cessna 172D · Quinton, VA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 16, 2018 · N2777U · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN18LA228](https://openairdocs.org/ntsb/CEN18LA228.md): RGJ Johnson AIR CAM · Greenwood, IL · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2018 · N81047 · Destroyed
  > The pilot's decision to take off with insufficient runway available and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB WPR18FA171](https://openairdocs.org/ntsb/WPR18FA171.md): Beech A35 · Hesperia, CA · Accident · 2 fatal · Class 2 · Field · Final report · Jun 15, 2018 · N580B · Destroyed
  > The pilot's failure to maintain airplane control during an attempted return to the airport following the separation of the spinner bulkhead during takeoff as a result of fatigue cracking. Contributing to the accident was the pilot's improper decision to fly…
- [NTSB ANC18LA046](https://openairdocs.org/ntsb/ANC18LA046.md): Cessna 180K · Ambler, AK · Accident · Serious injuries · Limited investigation · Final report · Jun 15, 2018 · N2957K · Substantial damage
  > The pilot's selection of an unsuitable takeoff area with unfavorable wind conditions, which resulted in the airplane’s inability to maintain a climb.
- [NTSB CEN18LA223](https://openairdocs.org/ntsb/CEN18LA223.md): Aeronca 7BCM · Eureka Springs, AR · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 14, 2018 · N9098C · Substantial damage
  > The pilot’s failure to maintain adequate airspeed following a partial loss of engine power after takeoff for undetermined reasons, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.
- [NTSB ERA18LA165](https://openairdocs.org/ntsb/ERA18LA165.md): Cessna 182 · Arecibo, PR · Accident · Serious injuries · Limited investigation · Final report · Jun 10, 2018 · N3889D · Substantial damage
  > Maintenance personnel's failure to properly apply torque to the engine through bolts, which ultimately resulted in the crankshaft failure and the total loss of engine power.
- [NTSB GAA18CA345](https://openairdocs.org/ntsb/GAA18CA345.md): Cessna 172 · Danbury, CT · Accident · No injuries · Data collection · Final report · Jun 9, 2018 · N383ME · Substantial damage
  > A collision with a bird during initial climb.
- [NTSB CEN18LA221](https://openairdocs.org/ntsb/CEN18LA221.md): Beech 58 · Baton Rouge, LA · Accident · No injuries · Limited investigation · Final report · Jun 8, 2018 · N190RS · Substantial damage
  > The improper insulation of the anticollision light wiring, which resulted in the ignition of combustible fuel vapors in the outboard section of the right wing; the source of the fuel leak could not be determined due to fire damage.
- [NTSB ERA18LA162](https://openairdocs.org/ntsb/ERA18LA162.md): Bryan C L/Labrash R D Searey · Englewood, FL · Accident · No injuries · Limited investigation · Final report · Jun 7, 2018 · N907CB · Substantial damage
  > The partial loss of engine power due to carburetor icing.
- [NTSB ERA18WA159](https://openairdocs.org/ntsb/ERA18WA159.md): Cessna 421B · Rock Sound, Bahamas · Accident · 3 fatal · Foreign investigation · Jun 5, 2018 · N421MM · Destroyed
- [NTSB ANC18FA041](https://openairdocs.org/ntsb/ANC18FA041.md): Mason Hal J Kitfox Model 1 · Salem, OR · Accident · 1 fatal · Field investigation · Final report · Jun 4, 2018 · N375KF · Substantial damage
  > The student pilot's improper decision to operate an airplane for which he was not endorsed to fly solo and in which he had limited experience or training, and his subsequent loss of airplane control after takeoff.
- [NTSB ANC18LA040](https://openairdocs.org/ntsb/ANC18LA040.md): Piper PA 18-150 · Wasilla, AK · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 2018 · N624MW · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN18FA204](https://openairdocs.org/ntsb/CEN18FA204.md): Cirrus SR22 · Midland, TX · Accident · 2 fatal · Field investigation · Final report · Jun 1, 2018 · N670SR · Destroyed
  > An inadvertent stall, resulting in an uncontrollable descent and impact with terrain. Contributing to the accident was the high density altitude.
- [NTSB WPR18FA155](https://openairdocs.org/ntsb/WPR18FA155.md): North American SNJ 2 · Melville, NY · Accident · 1 fatal · Field investigation · Final report · May 30, 2018 · N62382 · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall, spin, and subsequent impact with terrain.
- [NTSB GAA18CA313](https://openairdocs.org/ntsb/GAA18CA313.md): Cessna 172 · Payson, AZ · Accident · No injuries · Data collection · Final report · May 30, 2018 · N780JA · Substantial damage
  > The pilot’s failure to maintain yaw control during a short-field takeoff in high-density altitude conditions.
- [NTSB GAA18CA308](https://openairdocs.org/ntsb/GAA18CA308.md): Cirrus Design SR22 · Cedar Key, FL · Accident · No injuries · Data collection · Final report · May 28, 2018 · N269DW · Substantial damage
  > The airplane’s collision with multiple birds during initial climb, which damaged the propeller and resulted in a subsequent aerodynamic stall because the airspeed could not be maintained.
- [NTSB ERA18WA212](https://openairdocs.org/ntsb/ERA18WA212.md): Cessna 172 · Macas, Ecuador · Accident · No injuries · Foreign investigation · May 28, 2018 · HC-BTS · Substantial damage
  > The government of Ecuador has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on May 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…
- [NTSB WPR18FA150](https://openairdocs.org/ntsb/WPR18FA150.md): Morrison Marvin E JR RV 6A · Petaluma, CA · Accident · 2 fatal · Field investigation · Final report · May 27, 2018 · N4269Y · Substantial damage
  > A partial loss of engine power during initial climb after takeoff due to a loose left magneto, and the pilot's decision to turn back to the airport and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin and…
- [NTSB CEN18WA196](https://openairdocs.org/ntsb/CEN18WA196.md): Avid Avid Flyer · Granada, Spain · Accident · 1 fatal · Foreign investigation · May 26, 2018 · EC-YFP · Substantial damage
  > On May 26, 2018, at 1030 UTC, an Avid Flyer Stol, EC-YFP, encountered a loss of climb during initial climb out and subsequent impact with terrain near Loja Aerodrome, Granada, Spain. The experimental airplane was destroyed; the pilot suffered serious injuries…
- [NTSB WPR18LA147](https://openairdocs.org/ntsb/WPR18LA147.md): Bell UH 1H · Olympia, WA · Accident · Serious injuries · Class 3 · Limited · Final report · May 25, 2018 · N111DR · Substantial damage
  > A loss of tail rotor thrust due to the improper installation of the tail rotor assembly by maintenance personnel resulted in the pilot’s inability to maintain control of the helicopter as he began transition into forward flight from a hover, which resulted in…
- [NTSB GAA18CA343](https://openairdocs.org/ntsb/GAA18CA343.md): American AA · Port Orange, FL · Accident · Serious injuries · Data collection · Final report · May 24, 2018 · N5787L · Substantial damage
  > The pilot’s inadequate preflight inspection of the fuel, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB ENG18RA029](https://openairdocs.org/ntsb/ENG18RA029.md): Boeing 767 · Kumamoto, Japan, Japan · Incident · No injuries · Foreign investigation · May 24, 2018 · JA8980 · Minor damage
  > The Japan Transportation Safety Board (JTSB) has notified the NTSB of an incident involving a B767-300 that occurred May 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex 13…
- [NTSB ERA18FA152](https://openairdocs.org/ntsb/ERA18FA152.md): Cessna 140 · Daytona Beach, FL · Accident · 1 fatal · Field investigation · Final report · May 22, 2018 · N89864 · Destroyed
  > The pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation during the initial climb, and his failure to maintain adequate airspeed while turning back to the runway, which resulted in an exceedance of the…
- [NTSB CEN18FA186](https://openairdocs.org/ntsb/CEN18FA186.md): James Donald Baker Zenith · Bolivar, MO · Accident · 1 fatal · Field investigation · Final report · May 22, 2018 · N622DP · Destroyed
  > The pilot's failure to maintain airplane control after takeoff.

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

## 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=25

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