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

## Cases, newest first

- [NTSB CHI98LA047](https://openairdocs.org/ntsb/CHI98LA047.md): Hall RV-6 · Blair, NE · Accident · No injuries · Limited investigation · Final report · Nov 25, 1997 · N36AH · Substantial damage
  > a fatigue failure of the torque tube outside of the weld and the fractured pilot's side left rudder pedal.
- [NTSB FTW98LA058](https://openairdocs.org/ntsb/FTW98LA058.md): Gulfstream-Schweizer G-164B · Lecompte, LA · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 1997 · N2LU · Substantial damage
  > a loose battery cover, due to improper installation by maintenance personnel, that became jammed with an elevator control rod and restricted the movement of the elevator control system, which subsequently led to an uncontrolled impact with a tree, shortly…
- [NTSB ATL98LA012](https://openairdocs.org/ntsb/ATL98LA012.md): Roebuck Rans S-10 Sakota · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Nov 22, 1997 · N803DR · Substantial damage
  > the airplane builder's improper routing of vinyl/plastic cooling/vent line(s) for the engine oil system, and improper materials supplied by the manufacturer, which led to overheating of the line(s) in the engine compartment and an in-flight fire.
- [NTSB FTW98TA052](https://openairdocs.org/ntsb/FTW98TA052.md): Cessna 310J · Beaumont, TX · Accident · Serious injuries · Final report · Nov 19, 1997 · N156SD · Destroyed
  > The pilot's failure to maintain control for undetermined reasons. A factor may have been an encounter with wake turbulence.
- [NTSB FTW98LA050](https://openairdocs.org/ntsb/FTW98LA050.md): Cessna 172G · Van, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1997 · N202EX · Substantial damage
  > fuel starvation, resulting from restricted carburetor float travel, due to improper maintenance installation. The encounter with a power line was related factor.
- [NTSB CHI98LA038](https://openairdocs.org/ntsb/CHI98LA038.md): Cessna 150 · Plymouth, IN · Accident · No injuries · Limited investigation · Final report · Nov 17, 1997 · N50579 · Substantial damage
  > the pilot's failure to maintain control of the airplane during the crosswind, soft field takeoff. Factors in this accident were the pilot not following the airplane manufacturer's recommended takeoff procedures by lowering the flaps, and the crosswind.
- [NTSB LAX98LA038](https://openairdocs.org/ntsb/LAX98LA038.md): Adams Sonerai II · Kingman, AZ · Accident · 1 fatal · Limited investigation · Final report · Nov 16, 1997 · N27KF · Destroyed
  > The complete loss of engine power for undetermined reasons. A factor in the accident was the rough nature of the landing site terrain.
- [NTSB SEA98LA014](https://openairdocs.org/ntsb/SEA98LA014.md): Piper PA-18-150 · Battle Ground, WA · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 1997 · N1668P · Substantial damage
  > The owner/pilot's failure to properly install the fuel selector valve after removal, subsequently leading to a false indication on the valve selector handle. This led to the pilot unintentionally closing the valve and starving the engine of fuel during the…
- [NTSB LAX98FA039](https://openairdocs.org/ntsb/LAX98FA039.md): Mooney M20 · Big Bear, CA · Accident · 2 fatal · Field investigation · Final report · Nov 15, 1997 · N5231B · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (VMC), which led to spatial disorientation, loss of aircraft control, and an uncontrolled descent into terrain. Related factors were: the adverse weather conditions, the pilot's lack of…
- [NTSB MIA98LA030](https://openairdocs.org/ntsb/MIA98LA030.md): Cessna 150M · Ormond Beach, FL · Accident · No injuries · Limited investigation · Final report · Nov 13, 1997 · N6062K · Substantial damage
  > a loss of engine power for undetermined reasons.
- [NTSB MIA98LA028](https://openairdocs.org/ntsb/MIA98LA028.md): Cessna 182A · Parkton, NC · Accident · No injuries · Limited investigation · Final report · Nov 9, 1997 · N5883B · Substantial damage
  > improper installation of an auto battery cable which led to an in-flight fire due to the chaffed cable.
- [NTSB MIA98LA029](https://openairdocs.org/ntsb/MIA98LA029.md): Cessna 172P · Naples, FL · Accident · No injuries · Limited investigation · Final report · Nov 8, 1997 · N97074 · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB ANC98MA008](https://openairdocs.org/ntsb/ANC98MA008.md): Cessna 208B · Barrow, AK · Accident · 8 fatal · Major investigation · Final report · Nov 8, 1997 · N750GC · Destroyed
  > The pilot's disregard for lateral fuel loading limits, his improper removal of frost prior to takeoff, and the resulting inadvertent stall/spin. Factors involved in this accident were the improper asymmetrical fuel loading which reduced lateral aircraft…
- [NTSB FTW98LA045](https://openairdocs.org/ntsb/FTW98LA045.md): Beech J35 · Provo, UT · Accident · No injuries · Limited investigation · Final report · Nov 5, 1997 · N171Y · Substantial damage
  > the pilot's failure to properly position the fuel tank selector to a tank with adequate fuel, which resulted in fuel starvation, and a subsequent forced landing due to lack of engine power. His failure (or inability) to extent the gear for landing was a…
- [NTSB FTW98LA048](https://openairdocs.org/ntsb/FTW98LA048.md): Cessna 150F · Brigham City, UT · Accident · No injuries · Limited investigation · Final report · Nov 1, 1997 · N7934F · Substantial damage
  > failure of the pilot to maintain lateral (or vertical) clearance from a tree, during takeoff. Related factors were: the tree, and the pilot's improper use of flaps.
- [NTSB FTW98LA038](https://openairdocs.org/ntsb/FTW98LA038.md): Piper PA-23-250 · Galveston, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 1997 · N40201 · Substantial damage
  > inadequate maintenance and/or preflight inspection of the airplane, and subsequent blockage of the fuel filters, which led to fuel starvation, partial loss of engine power in both engines, and a forced landing. A related factor was the lack of suitable…
- [NTSB CHI98LA037](https://openairdocs.org/ntsb/CHI98LA037.md): Piper PA-32-260 · Lakeville, MN · Accident · No injuries · Limited investigation · Final report · Oct 31, 1997 · N3359W · Substantial damage
  > fuel starvation due a deteriorated grommet in an Adel clamp, and a loose mixture control cable.
- [NTSB CHI98LA024](https://openairdocs.org/ntsb/CHI98LA024.md): Beech 23 · Salina, KS · Accident · No injuries · Limited investigation · Final report · Oct 27, 1997 · N843KS · Substantial damage
  > the student pilot's excessive pull-up and the flight instructor's inadequate supervision during a simulated engine failure after takeoff, resulting in a stall/mush onto the runway.
- [NTSB LAX98LA021](https://openairdocs.org/ntsb/LAX98LA021.md): Revolution MINI-500 · Long Beach, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 1997 · N7234Y · Destroyed
  > loss of engine power and low rotor rpm for undeterminted reasons. The factory representative's recommendation to reduce the main rotor low pitch stop (from -1.8 degree to -0.5 degree) may have been a related factor.
- [NTSB NYC98LA019](https://openairdocs.org/ntsb/NYC98LA019.md): Piper PA-34-220T · Philadelphia, PA · Accident · No injuries · Limited investigation · Final report · Oct 24, 1997 · N8371H · Substantial damage
  > the pilot's failure to check the elevator trim prior to takeoff, and his failure to retard the power in a timely manner after touchdown.
- [NTSB SEA98LA003](https://openairdocs.org/ntsb/SEA98LA003.md): Champion 7EC · Galata, MT · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 1997 · CFOJT · Substantial damage
  > The pilot's failure to adequately perform preflight planning (prior to the precautionary landing and prior to the subsequent takeoff), his selection of an unsuitable takeoff area, and his failure to maintain altitude/clearance from the fence during the…
- [NTSB ATL98FA002](https://openairdocs.org/ntsb/ATL98FA002.md): Beech 95-B55 · Kennesaw, GA · Accident · 1 fatal · Field investigation · Final report · Oct 15, 1997 · N315K · Destroyed
  > the pilot's improper emergency procedures and subsequent loss of aircraft control, while attempting to maneuver for a precautionary landing. A factor relating to the accident was: partial loss of power in one or both engines for undetermined reason(s).
- [NTSB NYC98LA011](https://openairdocs.org/ntsb/NYC98LA011.md): Schweizer SGS1-26A · Fairfield, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 13, 1997 · N1154N · Minor damage
  > The improper installation of the elevator cables and elevator control bell-crank by the pilot, and an inadequate annual inspection by the mechanic. Also causal was the pilot's inadequate preflight of the flight controls prior to takeoff.
- [NTSB MIA98TA011](https://openairdocs.org/ntsb/MIA98TA011.md): Cessna 172P · Wiggins, MS · Accident · Minor injuries · Final report · Oct 12, 1997 · N945SM · Substantial damage
  > Loss of engine power for undetermined reasons resulting in a forced landing on unsuitable terrain and the aircraft nosing over during landing roll.
- [NTSB MIA98FA010](https://openairdocs.org/ntsb/MIA98FA010.md): Piper PA-28-180 · Knoxville, TN · Accident · 3 fatal · Field investigation · Final report · Oct 12, 1997 · N15331 · Destroyed
  > failure of the pilot to maintain control of the airplane, while climbing after takeoff, which resulted in an uncontrolled descent and impact with the water.
- [NTSB NYC98FA009](https://openairdocs.org/ntsb/NYC98FA009.md): Piper PA-28R-180 · Morganville, NJ · Accident · 4 fatal · Field investigation · Final report · Oct 11, 1997 · N3981T · Destroyed
  > The inadequate maintenance by the flying club and maintenance facility, which resulted in a takeoff with a partially blocked fuel injector nozzle and the failure of the landing gear to retract after takeoff. This resulted in the pilot's diverted attention and…
- [NTSB IAD98LA004](https://openairdocs.org/ntsb/IAD98LA004.md): Ford RV-4 · Dansville, NY · Accident · No injuries · Limited investigation · Final report · Oct 8, 1997 · N17PQ · Substantial damage
  > The internal mechanical failure of the engine driven fuel pump which resulted in a loss of engine power.
- [NTSB FTW98LA013](https://openairdocs.org/ntsb/FTW98LA013.md): Piper PA-18-150 · Folsum, NM · Accident · No injuries · Limited investigation · Final report · Oct 6, 1997 · N83454 · Substantial damage
  > the pilot's failure to maintain aircraft control during takeoff, which resulted in a stall/mush. A related factor was the crosswind condition.
- [NTSB CHI98LA015](https://openairdocs.org/ntsb/CHI98LA015.md): Reed-Madsen Taylor Bird · Humboldt, IA · Accident · No injuries · Limited investigation · Final report · Oct 5, 1997 · N12121 · Substantial damage
  > the failure of the pilot-in-command to attain airspeed and maintain control of the aircraft, resulting in a stall/mush.
- [NTSB MIA98LA005](https://openairdocs.org/ntsb/MIA98LA005.md): Cessna P172D · Umatilla, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 4, 1997 · N8582X · Substantial damage
  > The improper fuel tank selector position by the pilot-in-command resulting in the total loss of engine power due to fuel starvation.
- [NTSB MIA98LA003](https://openairdocs.org/ntsb/MIA98LA003.md): Cessna 182G · Jackson, MS · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1997 · N3434S · Substantial damage
  > A partial loss of engine power during the initial climb due to a blockage of the induction system by a piece of gasket material.
- [NTSB FTW98LA006](https://openairdocs.org/ntsb/FTW98LA006.md): Air Tractor AT-602 · Plains, TX · Accident · No injuries · Limited investigation · Final report · Oct 3, 1997 · N602GB · Substantial damage
  > The pilot's improper decision to initiate takeoff with a vehicle on the runway.
- [NTSB CHI98LA003](https://openairdocs.org/ntsb/CHI98LA003.md): Beech E18S · Lake Elmo, MN · Accident · No injuries · Limited investigation · Final report · Oct 2, 1997 · N916TM · Substantial damage
  > the pilot's failure identify the unsafe condition (vortex turbulence) which existed due to departing airplane and his subsequent inability to control the airplane once encountering the turbulence.
- [NTSB ANC97FA159](https://openairdocs.org/ntsb/ANC97FA159.md): de Havilland DHC-2 · Ketchikan, AK · Accident · 1 fatal · Field investigation · Final report · Sep 30, 1997 · N4787C · Destroyed
  > The pilot's excessive climb and turning maneuver at low altitude, the pilot's inadvertent stall, and the intentional operation of the airplane with the required stall warning system disabled. Factors associated with this accident were the pilot's…
- [NTSB SEA97LA218](https://openairdocs.org/ntsb/SEA97LA218.md): Piper PA-18-150 · Dixie, ID · Accident · Serious injuries · Limited investigation · Final report · Sep 28, 1997 · N7153Z · Substantial damage
  > Shifting of a briefcase stored behind the pilot's seat to a position where it obstructed movement of the rudder pedals, resulting in loss of directional control capability. A factor was trees adjacent to the airstrip.
- [NTSB IAD97LA124](https://openairdocs.org/ntsb/IAD97LA124.md): Piper PA-28-140 · Zanesville, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1997 · N6308W · Destroyed
  > The pilot's failure to perform the published short/soft field takeoff procedures.
- [NTSB LAX97FA330](https://openairdocs.org/ntsb/LAX97FA330.md): Ryan Navion B · Pacoima, CA · Accident · 2 fatal · Field investigation · Final report · Sep 26, 1997 · N5241K · Destroyed
  > the dual student's improper positioning of the fuel selector and the CFI's inadequate supervision, which led to a takeoff with the auxiliary fuel tank selected and resulted in fuel starvation. A contributing factor was the position of the nomenclature on the…
- [NTSB FTW97LA364](https://openairdocs.org/ntsb/FTW97LA364.md): Bell 206B2 · Anahuac, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 25, 1997 · N59396 · Destroyed
  > the pilot's inability to maintain control of the helicopter after encountering a dynamic rollover due to entanglement of the external load cable with the left landing gear skid.
- [NTSB CHI97FA300](https://openairdocs.org/ntsb/CHI97FA300.md): Beech T34B · Fremont, MI · Accident · 2 fatal · Field investigation · Final report · Sep 25, 1997 · N777SU · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in a stall. Also causal was the pilot's ostentatious display.
- [NTSB FTW97IA363](https://openairdocs.org/ntsb/FTW97IA363.md): Boeing 737-200RS · Salt Lake City, UT · Incident · Minor injuries · Incident investigation · Final report · Sep 24, 1997 · N205AU · Minor damage
  > The captain's failure to maintain directional control during landing roll. Factors were the loss of hydraulic pressure in the 'A' hydraulic system, the thrust reverser failure on the number one engine, and flight crew coordination not being maintained.
- [NTSB SEA97LA214](https://openairdocs.org/ntsb/SEA97LA214.md): Cessna 172RG · Monroe, WA · Accident · No injuries · Limited investigation · Final report · Sep 23, 1997 · N64ML · Substantial damage
  > The failure of the flight instructor to adequately perform remedial action, and her failure to abort the takeoff. Factors contributing to the accident include the premature rotation of the airplane by the dual student, the failure of the dual student to…
- [NTSB ANC97LA154](https://openairdocs.org/ntsb/ANC97LA154.md): Cessna 170B · Lime Village, AK · Accident · No injuries · Limited investigation · Final report · Sep 23, 1997 · N1831C · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff.
- [NTSB NYC97LA184](https://openairdocs.org/ntsb/NYC97LA184.md): Cessna 150L · Easton, NY · Accident · Serious injuries · Limited investigation · Final report · Sep 21, 1997 · N6865G · Substantial damage
  > mechanical binding of the number three exhaust valve, and the pilot/owner's improper planning/decision by failing to ensure the engine was operating properly before takeoff. A related factor was: the pilot/owner's failure to ensure that annual maintenance was…
- [NTSB LAX97FA328](https://openairdocs.org/ntsb/LAX97FA328.md): Beech C23 · Torrance, CA · Accident · 4 fatal · Field investigation · Final report · Sep 21, 1997 · N543JL · Destroyed
  > The failure of the pilot to attain and maintain adequate airspeed during the initial takeoff climb, which resulted in a stall/spin and subsequent collision with a building.
- [NTSB ATL97LA138](https://openairdocs.org/ntsb/ATL97LA138.md): Champion 7ECA · Fairview, NC · Accident · No injuries · Limited investigation · Final report · Sep 21, 1997 · N1817G · Substantial damage
  > fuel contamination, and the pilot's inadequate preflight of the airplane. A factor relating to the accident was: an inability to attain a proper touchdown point, which led to the runway overrun.
- [NTSB ANC97LA153](https://openairdocs.org/ntsb/ANC97LA153.md): Cessna 185E · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Sep 21, 1997 · N70122 · Substantial damage
  > The loss of engine power due to water contaminated fuel, and the pilot's inadequate preflight inspection of the airplane. A factor associated with the accident was the lack of suitable terrain for a forced landing.
- [NTSB IAD97LA120](https://openairdocs.org/ntsb/IAD97LA120.md): Piper PA-28R-180 · Danbury, CT · Accident · Serious injuries · Limited investigation · Final report · Sep 18, 1997 · N3102R · Destroyed
  > The pilot's improper planning/decision to not use actual occupant weights and compute takeoff data, which resulted in an overweight takeoff towards rising terrain.
- [NTSB FTW97LA351](https://openairdocs.org/ntsb/FTW97LA351.md): Brashears MONERAI-S · Artesia, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 1997 · N5575S · Substantial damage
  > the pilot's improper handling of the aircraft during takeoff, which resulted in an inadvertent stall and collision with the terrain. A factor relating to the accident was: the pilot's lack of recent flight experience in the make and model of aircraft.
- [NTSB FTW97FA348](https://openairdocs.org/ntsb/FTW97FA348.md): Bellanca 7GCBC · Telluride, CO · Accident · 2 fatal · Field investigation · Final report · Sep 14, 1997 · N86708 · Destroyed
  > failure of the pilot to maintain adequate airspeed, while climbing after takeoff, which resulted in an inadvertent stall/spin and collision with terrain. Factors relating to the accident included: the pilot allowing the maximum gross weight limit of the…
- [NTSB LAX97GA325](https://openairdocs.org/ntsb/LAX97GA325.md): Bell 205A-1 · Sequim, WA · Accident · 3 fatal · Final report · Sep 12, 1997 · N90HJ · Destroyed
  > the pilot's intentional flight into known adverse weather conditions in mountainous terrain.

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

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

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