# NTSB investigations: Takeoff

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 102 of 281 · 14,038 cases

## Cases, newest first

- [NTSB MIA98LA126](https://openairdocs.org/ntsb/MIA98LA126.md): Cessna 172I · Mallards Ldg, GA · Accident · Minor injuries · Limited investigation · Final report · Apr 7, 1998 · N35594 · Substantial damage
  > A deer on the runway which led to the pilot's evasive manuever to avoid the deer.
- [NTSB MIA98LA122](https://openairdocs.org/ntsb/MIA98LA122.md): Brock 162F · Canton, GA · Accident · Serious injuries · Limited investigation · Final report · Apr 7, 1998 · N623LB · Substantial damage
  > the pilot's improper use of throttle and collective pitch during initial takeoff climb, which resulted in a decay of rotor rpm and settling of the helicopter into a lake.
- [NTSB CHI98LA118](https://openairdocs.org/ntsb/CHI98LA118.md): Air Tractor AT-401 · Highmore, SD · Accident · No injuries · Limited investigation · Final report · Apr 3, 1998 · N1008T · Substantial damage
  > the pilot failed to abort the takeoff in a timely manner and could not stop on the runway.
- [NTSB MIA98FA112](https://openairdocs.org/ntsb/MIA98FA112.md): Boeing 727-212 · Fort Lauderdale, FL · Accident · Serious injuries · Field investigation · Final report · Mar 31, 1998 · CFRYS · Minor damage
  > Failure of the No.2 engine low pressure compressor rear tierod. Also contributing to the accident was failure of the manufacturer to apply an antigallant treatment to the tierod's compressor disk lands during manufacture.
- [NTSB CHI98LA112](https://openairdocs.org/ntsb/CHI98LA112.md): Cessna 310J · Hutchinson, KS · Accident · No injuries · Limited investigation · Final report · Mar 31, 1998 · N3020L · Substantial damage
  > the flight instructor's inadequate supervision by failing to ensure that the right throttle had been retarded before re-advancing the right mixture control, which resulted in a loss of directional control, an encounter with soft terrain, and damage to the…
- [NTSB NYC98LA083](https://openairdocs.org/ntsb/NYC98LA083.md): Cessna 140 · Milford Center, OH · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 1998 · N1998N · Substantial damage
  > the pilot's excessive application of brakes during an aborted takeoff roll.
- [NTSB FTW98IA158](https://openairdocs.org/ntsb/FTW98IA158.md): McDonnell Douglas DC-10-10 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Mar 25, 1998 · N1836U · Minor damage
  > The total failure of one main landing gear tire.
- [NTSB LAX98LA128](https://openairdocs.org/ntsb/LAX98LA128.md): Air Tractor AT301 · Imperial, CA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1998 · N7301P · Substantial damage
  > The pilot's selection of the wrong runway, which resulted in a downwind takeoff attempt, and, his failure to obtain/maintain a proper airspeed during the takeoff sequence. The aircraft's gross weight and the prevailing density altitude were factors in the…
- [NTSB FTW98LA168](https://openairdocs.org/ntsb/FTW98LA168.md): Boeing A75N (PT-17) · Grand Junction, CO · Accident · No injuries · Limited investigation · Final report · Mar 24, 1998 · N59448 · Substantial damage
  > Failure by the pilot to maintain control of the aircraft during landing roll. Factors were variable winds and the pilot's lack of recent experience in make and model.
- [NTSB FTW98LA155](https://openairdocs.org/ntsb/FTW98LA155.md): Zito ZMI-A · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 1998 · N669Z · Substantial damage
  > the improper placement of lead ballast by the pilot, resulting in an improper balance of the airplane; and the pilot's excessive control input to correct a nose high attitude, resulting in ground impact.
- [NTSB SEA98FA047](https://openairdocs.org/ntsb/SEA98FA047.md): Aerospatiale SN-601 · Portland, OR · Accident · No injuries · Field investigation · Final report · Mar 19, 1998 · N600RA · Substantial damage
  > The pilot-in-command's decision to attempt takeoff with the right engine inoperative, resulting in his failure to maintain directional control or attain adequate airspeed during the takeoff attempt. Factors included a fractured right engine starter-generator…
- [NTSB LAX98LA121](https://openairdocs.org/ntsb/LAX98LA121.md): Cessna 421B · Show Low, AZ · Accident · No injuries · Limited investigation · Final report · Mar 18, 1998 · N70PD · Substantial damage
  > The pilot's failure to attain the proper alignment on the runway due to the obscuration by snow of the runway and on the airplane's windows.
- [NTSB FTW98LA150](https://openairdocs.org/ntsb/FTW98LA150.md): Piper PA-34-200 · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Mar 12, 1998 · N83DA · Substantial damage
  > the student pilot not understanding the crew briefing, his premature retraction of the landing gear, and the flight instructor's inadequate supervision of the flight. A factor relating to the accident was: the exchange of unclear information due to the…
- [NTSB MIA98LA099](https://openairdocs.org/ntsb/MIA98LA099.md): Pitts S1-S · Zephyrhills, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 11, 1998 · N99PF · Substantial damage
  > the pilot's improper use of flight controls (ailerons) during a touch-and-go landing with a crosswind, resulting in a loss of directional control and subsequent nose over of the airplane. A factor relating to the accident was: the pilot's lack of total…
- [NTSB FTW98LA140](https://openairdocs.org/ntsb/FTW98LA140.md): Air Tractor AT-502B · Lake Village, AR · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1998 · N60762 · Substantial damage
  > The pilot's use of unsuitable terrain for takeoff. A factor was the rough/uneven terrain.
- [NTSB MIA98LA090](https://openairdocs.org/ntsb/MIA98LA090.md): Cessna 337 · Raymond, MS · Accident · Serious injuries · Limited investigation · Final report · Feb 28, 1998 · N1287M · Destroyed
  > the pilot passenger's impairment of judgment and performance due to alcohol, and control interference by the pilot passenger, which resulted in a loss of aircraft control and subsequent in-flight collision with the runway and trees.
- [NTSB FTW98LA135](https://openairdocs.org/ntsb/FTW98LA135.md): Cessna 150G · Lonoke, AR · Accident · No injuries · Limited investigation · Final report · Feb 27, 1998 · N3729J · Substantial damage
  > the flight instructor's selection of unsuitable terrain for takeoff, and his delayed decision to abort the takeoff. A factor relating to the accident was: the soft/wet area on the turf runway.
- [NTSB MIA98LA085](https://openairdocs.org/ntsb/MIA98LA085.md): Piper PA-32-300 · Holly Springs, MS · Accident · No injuries · Limited investigation · Final report · Feb 24, 1998 · N8SX · Substantial damage
  > a total loss of power due to fuel starvation as a result of the pilot's lack of adequate preflight planning and preparation and his failure to adequately refuel his airplane.
- [NTSB FTW98LA132](https://openairdocs.org/ntsb/FTW98LA132.md): Cessna 152 · Norman, OK · Accident · No injuries · Limited investigation · Final report · Feb 20, 1998 · N5128Q · Substantial damage
  > Fuel exhaustion due to the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA98LA036](https://openairdocs.org/ntsb/SEA98LA036.md): Piper PA-17 · Bozeman, MT · Accident · No injuries · Limited investigation · Final report · Feb 15, 1998 · N4835H · Substantial damage
  > The pilot's failure to maintain directional control during takeoff.
- [NTSB MIA98LA077](https://openairdocs.org/ntsb/MIA98LA077.md): Cessna 152 · Georgetown, SC · Accident · Minor injuries · Limited investigation · Final report · Feb 10, 1998 · N25952 · Destroyed
  > the pilot's decision to attempt a takeoff from an unsuitable area of roadway, following a forced landing after the engine had lost power, due to fuel exhaustion; and his failure to maintain clearance from obstructions, while attempting the takeoff. The…
- [NTSB LAX98IA085](https://openairdocs.org/ntsb/LAX98IA085.md): McDonnell Douglas DC-9-51 · Honolulu, HI · Incident · No injuries · Incident investigation · Final report · Feb 9, 1998 · N601AP · Minor damage
  > the disintegration of the No. 6 bearing in the No. 2 engine which resulted in an aborted takeoff. In addition, the malfunction of the slide in the right forward service door was the result of a faulty seal in the inflation system. The inflation gauge had not…
- [NTSB MIA98LA070](https://openairdocs.org/ntsb/MIA98LA070.md): Bell 206B · Miami, FL · Accident · No injuries · Limited investigation · Final report · Feb 3, 1998 · N26EA · Substantial damage
  > The pilot's improper use of flight controls (cyclic) while attempting a takeoff to a hover, which led to an on-ground loss of control (dynamic rollover).
- [NTSB NYC98LA064](https://openairdocs.org/ntsb/NYC98LA064.md): Cessna 182 · East Moriches, NY · Accident · No injuries · Limited investigation · Final report · Feb 1, 1998 · N7275E · Substantial damage
  > the pilot's improper planning/decision, and failure to attain rotation the airplane for lift-off, which led to an aborted takeoff and collision with a fence. The proximity of the fence was a related factor.
- [NTSB LAX98LA083](https://openairdocs.org/ntsb/LAX98LA083.md): Robinson R22 · Oxnard, CA · Accident · No injuries · Limited investigation · Final report · Jan 31, 1998 · N2308X · Substantial damage
  > The pilot's improper use of the collective during the initiation of the rollover, which prevented the recovery from the condition.
- [NTSB SEA98LA030](https://openairdocs.org/ntsb/SEA98LA030.md): Raser Mini 500 · Newberg, OR · Accident · No injuries · Limited investigation · Final report · Jan 28, 1998 · N500YY · Substantial damage
  > a power loss resulting from overtemperature of a cylinder. The pilot's operation with known deficiencies was a factor.
- [NTSB LAX98LA078](https://openairdocs.org/ntsb/LAX98LA078.md): Bellanca 8KCAB · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Jan 27, 1998 · N7921S · Substantial damage
  > The student pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control. A related factor was the crosswind.
- [NTSB LAX98LA084](https://openairdocs.org/ntsb/LAX98LA084.md): Let Blanik L-13 · Prescott Valley, AZ · Accident · No injuries · Limited investigation · Final report · Jan 25, 1998 · N3463 · Substantial damage
  > The failure of the ground crew to correctly attach the tow bridle, which resulted in the pilot's loss of directional control.
- [NTSB ANC98LA016](https://openairdocs.org/ntsb/ANC98LA016.md): Cessna 150 · Pt. Baker, AK · Accident · No injuries · Limited investigation · Final report · Jan 22, 1998 · N5822E · Substantial damage
  > The pilot's failure to maintain directional control.
- [NTSB MIA98FA055](https://openairdocs.org/ntsb/MIA98FA055.md): Cessna 208B · Maiden, NC · Accident · 1 fatal · Field investigation · Final report · Jan 9, 1998 · N913FE · Substantial damage
  > The pilot's failure to remove the control lock prior to takeoff and his failure to abort the takeoff when he was unable to initiate a climb, resulting in the aircraft over running the runway and colliding with trees on the departure end of the runway.…
- [NTSB ANC98LA014](https://openairdocs.org/ntsb/ANC98LA014.md): Douglas DC-6B · Mcgrath, AK · Accident · No injuries · Limited investigation · Final report · Jan 2, 1998 · N861TA · Destroyed
  > The ingestion of snow into the windshield anti-ice system, and the resulting obscured windshield which made runway alignment not possible. Factors associated with this accident were the cold windshield, the reduced performance of the windshield anti-ice…
- [NTSB NYC98LA057](https://openairdocs.org/ntsb/NYC98LA057.md): Cessna 421C · Elkins, WV · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 1997 · N1348T · Destroyed
  > The flight instructor's failure to identify an unsafe runway condition and his delay in aborting the takeoff. Contributing was the aircraft's maximum takeoff weight exceeded, and a snow-covered runway.
- [NTSB CHI98LA065](https://openairdocs.org/ntsb/CHI98LA065.md): Cessna 150M · Sidney, NE · Accident · No injuries · Limited investigation · Final report · Dec 16, 1997 · N3820V · Substantial damage
  > the student pilot's inadequate compensation for the crosswind which resulted in a loss of directional control. Factors associated with the accident were the crosswind, the misunderstood radio communication, and the rough terrain which the airplane encountered.
- [NTSB CHI98LA066](https://openairdocs.org/ntsb/CHI98LA066.md): Cessna 150H · Hillsdale, MI · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 1997 · N23239 · Substantial damage
  > The student pilot's failure to maintain. Contributing were icy conditions on the runway and a snowbank.
- [NTSB FTW98LA082](https://openairdocs.org/ntsb/FTW98LA082.md): Mooney M20 · Pocahontas, AR · Accident · No injuries · Limited investigation · Final report · Dec 13, 1997 · N6159E · Substantial damage
  > failure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in an inadvertent ground swerve. A related factor was: the pilot's lack of recent experience in the make and model of airplane.
- [NTSB NYC98FA041](https://openairdocs.org/ntsb/NYC98FA041.md): Piper PA-32-260 · Pittsville, MD · Accident · 3 fatal · Field investigation · Final report · Dec 12, 1997 · N3448W · Destroyed
  > the pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision and flight in instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude while flying over wooded terrain. Factors…
- [NTSB CHI98LA063](https://openairdocs.org/ntsb/CHI98LA063.md): Beech 1900C · Rockford, IL · Accident · No injuries · Limited investigation · Final report · Dec 10, 1997 · N79GL · Substantial damage
  > improper installation of aileron cables by the maintenance personnel, inadequate inspection by the company's maintenance personnel of maintenance performed, and inadequate preflight by the pilot.
- [NTSB CHI98LA052](https://openairdocs.org/ntsb/CHI98LA052.md): Piper PA-46-350P · Vicksburg, MI · Accident · No injuries · Limited investigation · Final report · Dec 2, 1997 · N6295Z · Substantial damage
  > the pilot's inadequate preflight preparation and his failure to maintain directional control during takeoff. A factor was the uneven runway at the grass airstrip.
- [NTSB IAD98LA014](https://openairdocs.org/ntsb/IAD98LA014.md): Jones Mini 500 · Bluefield, WV · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 1997 · N8015E · Substantial damage
  > Pilot's unfamiliarity with reciprocating engine powered helicopter lead to a reduction in main rotor rpm and subsequent uncontrolled rate of descent with insufficient altitude to recover.
- [NTSB NYC98LA033](https://openairdocs.org/ntsb/NYC98LA033.md): Piper PA-32-300 · Johnstown, PA · Accident · No injuries · Limited investigation · Final report · Nov 26, 1997 · N2202U · Substantial damage
  > the pilot's failure to maintain direction control of the airplane during the takeoff roll. Factors relating to this accident were: the crosswind condition, and snowbank.
- [NTSB NYC98LA032](https://openairdocs.org/ntsb/NYC98LA032.md): Piper PA-28-140 · Middlefield, OH · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 1997 · N1816J · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB LAX98LA044](https://openairdocs.org/ntsb/LAX98LA044.md): Maule M-7-235B · San Martin, CA · Accident · No injuries · Limited investigation · Final report · Nov 24, 1997 · N611BY · Substantial damage
  > The pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control.
- [NTSB SEA98LA015](https://openairdocs.org/ntsb/SEA98LA015.md): Piper PA-22-150 · Newberg, OR · Accident · Serious injuries · Limited investigation · Final report · Nov 22, 1997 · N7528D · Substantial damage
  > The pilots failure to account for the increased drag on the runway during the preflight planning. Factors were the long, wet grass.
- [NTSB CHI98LA053](https://openairdocs.org/ntsb/CHI98LA053.md): McDonnell Douglas DC-9-15 · Syracuse, NY · Accident · No injuries · Limited investigation · Final report · Nov 21, 1997 · N564PC · Substantial damage
  > The pilot's inadequate preflight to ensure that the cargo pallets were properly secured. Also causal was the the improper securing of the pallets.
- [NTSB ATL98LA010](https://openairdocs.org/ntsb/ATL98LA010.md): Cessna 152 · Punta Gorda, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 20, 1997 · N93286 · Substantial damage
  > The flight instructor's improper short field takeoff procedure and his decision to abort the takeoff after rotation.
- [NTSB ANC98LA010](https://openairdocs.org/ntsb/ANC98LA010.md): Piper PA-31-T3 · Tyonek, AK · Accident · No injuries · Limited investigation · Final report · Nov 11, 1997 · N314SC · Substantial damage
  > An on-ground collision with an animal (moose). Factors in the accident were night VFR conditions that restricted the pilot's visual lookout, and the lack of an airport perimeter fence.
- [NTSB SEA98LA012](https://openairdocs.org/ntsb/SEA98LA012.md): Aerostar PA-60-700P · Portland, OR · Accident · No injuries · Limited investigation · Final report · Nov 7, 1997 · N700HS · Substantial damage
  > The pilot's selection of an improper remedial action for an unanticipated yaw excursion during takeoff roll, resulting in the aircraft becoming airborne with inadequate airspeed and consequent loss of aircraft control.
- [NTSB FTW98LA046](https://openairdocs.org/ntsb/FTW98LA046.md): Piper PA-22-150 · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Nov 7, 1997 · N9607D · Substantial damage
  > the pilot's failure to maintain directional control of the airplane during the takeoff roll, due to inadvertently stepping on the brake. A related factor was the pilot's excessive use of rudder for steering.
- [NTSB SEA98LA011](https://openairdocs.org/ntsb/SEA98LA011.md): Cessna 150H · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Nov 6, 1997 · N695NS · Substantial damage
  > The student pilot's failure to maintain directional control.
- [NTSB ANC98LA009](https://openairdocs.org/ntsb/ANC98LA009.md): Cessna 185F · Barrow, AK · Accident · No injuries · Limited investigation · Final report · Oct 31, 1997 · N61500 · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, and his delay in aborting the takeoff. A factor in the accident was the presence of gravel/sand in the takeoff area.

Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=103

## 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 = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?page=102

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