# 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 103 of 281 · 14,038 cases

## Cases, newest first

- [NTSB CHI98LA026](https://openairdocs.org/ntsb/CHI98LA026.md): Learjet 35A · Sheboygan, WI · Accident · No injuries · Limited investigation · Final report · Oct 29, 1997 · N62MB · Substantial damage
  > a deer that ran in front of the airplane during the takeoff phase. A factor in this accident was the lack of an airport perimeter fence to prevent deer from getting onto the runway.
- [NTSB FTW98LA029](https://openairdocs.org/ntsb/FTW98LA029.md): Cessna 185C · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Oct 23, 1997 · N725 · Substantial damage
  > the pilot's improper preflight of the airplane, by failing to properly set the elevator trim for takeoff, and his improper use use of the elevator flight controls. A related factor was: the pilot's lack of recent experience in the make and model of airplane.
- [NTSB SEA98LA005](https://openairdocs.org/ntsb/SEA98LA005.md): Piper PA-28-151 · Vashon, WA · Accident · No injuries · Limited investigation · Final report · Oct 19, 1997 · N5987F · Substantial damage
  > A misjudged soft field takeoff. Factors include wet grass.
- [NTSB FTW98LA015](https://openairdocs.org/ntsb/FTW98LA015.md): Sego Tool Hawk H2X · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Oct 15, 1997 · N4412X · Substantial damage
  > The pilot's failure to maintain aircraft control. Contributing was the inadequate design of the flight control systems, resulting in slow response to pilot input.
- [NTSB NYC98LA007](https://openairdocs.org/ntsb/NYC98LA007.md): Cessna 120 · Prince George, VA · Accident · No injuries · Limited investigation · Final report · Oct 6, 1997 · N1856N · Substantial damage
  > The pilot's failure to attain takeoff climb, and his delay in aborting the takeoff. A contributing factor was soft terrain.
- [NTSB FTW98LA143](https://openairdocs.org/ntsb/FTW98LA143.md): Aerostar S-60A · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Oct 6, 1997 · N63459 · Substantial damage
  > the pilot's failure to maintain control of the balloon.
- [NTSB NYC98LA008](https://openairdocs.org/ntsb/NYC98LA008.md): Boeing Stearman PT-17 · Elkton, MD · Accident · No injuries · Limited investigation · Final report · Oct 5, 1997 · N49760 · 2 aircraft · Substantial damage
  > The inadequate lookout by the pilot of the Cessna and his failure to maintain adequate clearance between his airplane and the active runway. A factor in the accident was the lack of taxiway hold signs or lines.
- [NTSB LAX98LA003](https://openairdocs.org/ntsb/LAX98LA003.md): Cessna 185F · Oakland, CA · Accident · No injuries · Limited investigation · Final report · Oct 5, 1997 · N17SR · Substantial damage
  > The pilot's inadequate compensation for the existing crosswind condition, which resulted in a loss of directional control.
- [NTSB MIA98LA004](https://openairdocs.org/ntsb/MIA98LA004.md): Piper J3C-65 · Trenton, GA · Accident · No injuries · Limited investigation · Final report · Oct 4, 1997 · N30236 · Substantial damage
  > failure of the pilot to abort the takeoff, when he observed an indication of less than full engine power on the tachometer from the beginning of the takeoff roll. Factors relating to the accident were: the inadequate preflight planning and preparation by the…
- [NTSB CHI98LA008](https://openairdocs.org/ntsb/CHI98LA008.md): Boeing B75N1 · Cloverdale, IN · Accident · No injuries · Limited investigation · Final report · Oct 4, 1997 · N75511 · 2 aircraft · Substantial damage
  > the Boeing pilot failed to identify the Waco airplane on the runway before initiating a takeoff. Factors related to the accident were: the restricted forward visibility of both pilots due to the tailwheel configurations of both airplanes.
- [NTSB MIA97LA252](https://openairdocs.org/ntsb/MIA97LA252.md): Cessna A188B · Greenwood, MS · Accident · No injuries · Limited investigation · Final report · Sep 30, 1997 · N731RP · Destroyed
  > The intentional operation of the airplane from an unsuitable takeoff area by the pilot-in-command and inadvertent rotation of the airplane after encountering rising terrain on the runway.
- [NTSB ANC97LA158](https://openairdocs.org/ntsb/ANC97LA158.md): Pilatus PC-6-350 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Sep 30, 1997 · N4911 · Substantial damage
  > An underspeed of the propeller system.
- [NTSB ANC97LA157](https://openairdocs.org/ntsb/ANC97LA157.md): Cessna 180 · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Sep 30, 1997 · N4900A · Substantial damage
  > The distorted/misaligned main landing gear, and an improper maintenance repair of the main landing gear. A factor associated with the accident was rough and uneven terrain.
- [NTSB MIA97LA251](https://openairdocs.org/ntsb/MIA97LA251.md): Cessna 170 · Troy, NC · Accident · No injuries · Limited investigation · Final report · Sep 29, 1997 · N2554V · Substantial damage
  > delay of the pilot to abort the takeoff after noting sluggish acceleration during the takeoff roll. Factors relating to the accident were: improper timing of the magneto(s), and a malfunction of the carburetor.
- [NTSB SEA97IA219](https://openairdocs.org/ntsb/SEA97IA219.md): Boeing 737-3T0 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Sep 27, 1997 · N13331 · No damage
  > Separation of the ABSB-4 aileron bus cable, resulting in reduced lateral controllability of the aircraft. Related factors were wear in the cable and inadequate inspection of the cable by company maintenance personnel.
- [NTSB ATL97LA140](https://openairdocs.org/ntsb/ATL97LA140.md): Cessna 172N · Greenville, SC · Accident · No injuries · Limited investigation · Final report · Sep 25, 1997 · N738SZ · Substantial damage
  > the pilot's improper use of the elevator control and delayed liftoff during takeoff, which resulted in an inadvertent porpoise, collision with the runway, and collapse of the nose gear as he aborted the takeoff.
- [NTSB FTW97LA356](https://openairdocs.org/ntsb/FTW97LA356.md): Sikorsky S-76A · Patterson, LA · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 1997 · N517AL · Substantial damage
  > failure of the copilot to maintain a positive rate of climb after takeoff, which led to an inadvertent descent and collision with a crop of sugar cane and the ground. Factors relating to the accident were: darkness, fog, and the pilot-in-command's inadequate…
- [NTSB MIA97LA244](https://openairdocs.org/ntsb/MIA97LA244.md): Maule M-7-235 · Louisville, MS · Accident · No injuries · Limited investigation · Final report · Sep 14, 1997 · N5662S · Substantial damage
  > The failure of the pilot to assure that the rudder trim was properly set for takeoff and his delay in aborting the takeoff when the airplane yawed to the left during the early portion of the takeoff roll.
- [NTSB FTW97LA349](https://openairdocs.org/ntsb/FTW97LA349.md): AS+ AC-4B · Sundance, WY · Accident · No injuries · Limited investigation · Final report · Sep 14, 1997 · N3021 · Substantial damage
  > improper planning/decision by the pilot, which led to a snag and sudden slack in the tow rope, and necessitated an aborted launch (emergency landing) after initial liftoff. This in turn led to an inadvertent stall, a wing drop, and the left wing tip dragging…
- [NTSB CHI97LA288](https://openairdocs.org/ntsb/CHI97LA288.md): Beech 35-C33A · Amana, IA · Accident · No injuries · Limited investigation · Final report · Sep 7, 1997 · N5729V · Substantial damage
  > the pilot's improper planning/decision. The fence (location) was a related factor.
- [NTSB ANC97LA140](https://openairdocs.org/ntsb/ANC97LA140.md): Cessna U206F · King Salmon, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1997 · N7032Q · Destroyed
  > the pilot's selection of an unsuitable takeoff area. Factors were the sand bar and the pilot's failure to use all available waterway for the takeoff.
- [NTSB ATL97LA126](https://openairdocs.org/ntsb/ATL97LA126.md): Gulfstream-Schweizer G-164C · Beaufort, NC · Accident · No injuries · Limited investigation · Final report · Aug 28, 1997 · N585CK · Substantial damage
  > failure of the pilot to ensure the tailwheel was properly locked, while taking off on an asphalt runway, which led to loss of directional control and a ground swerve.
- [NTSB LAX97IA300](https://openairdocs.org/ntsb/LAX97IA300.md): Airbus Industrie A300 B4-203 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Aug 24, 1997 · N862PA · Minor damage
  > Separation of the landing gear tire tread and subsequent ingestion of the tread into the intake of the engine.
- [NTSB ANC97LA130](https://openairdocs.org/ntsb/ANC97LA130.md): Cessna 170A · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1997 · N9540A · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and overload failure of the right main landing gear. Factors related to the accident were: the…
- [NTSB IAD97LA113](https://openairdocs.org/ntsb/IAD97LA113.md): Haines Revolution Mini 500 · N Philadelphia, OH · Accident · No injuries · Limited investigation · Final report · Aug 23, 1997 · N7240E · Substantial damage
  > A leak on the exhaust manifold which resulted in a loss of engine power.
- [NTSB ANC97LA128](https://openairdocs.org/ntsb/ANC97LA128.md): Helio H-295 · Fort Yukon, AK · Accident · No injuries · Limited investigation · Final report · Aug 23, 1997 · N6465V · Substantial damage
  > failure of the pilot to maintain directional control of the airplane, which resulted in a swerve and collision with a tree as the pilot continued the takeoff, subsequently jamming the stabilator and causing the plane to crash in water.
- [NTSB FTW97LA315](https://openairdocs.org/ntsb/FTW97LA315.md): Piper PA-28-180 · Gila, NM · Accident · No injuries · Limited investigation · Final report · Aug 19, 1997 · N9455J · Substantial damage
  > the pilot's impairment of judgment and performance due to alcohol, and his failure to maintain directional control of the airplane, which resulted in a ground swerve, and collision with vegetation (cactus) and a fence. Related factors were: the soft runway…
- [NTSB CHI97LA263](https://openairdocs.org/ntsb/CHI97LA263.md): Grumman G-164B · Burlington, WI · Accident · No injuries · Limited investigation · Final report · Aug 16, 1997 · N7016Y · Substantial damage
  > the deer which contacted the airplane.
- [NTSB ANC97LA123](https://openairdocs.org/ntsb/ANC97LA123.md): Champion 7ECA · Kaktovik, AK · Accident · No injuries · Limited investigation · Final report · Aug 14, 1997 · N5507H · Substantial damage
  > The pilot's selection of an unsuitable takeoff area. A factor related to the accident was the rocky terrain.
- [NTSB LAX97LA281](https://openairdocs.org/ntsb/LAX97LA281.md): Aerospatiale TB-20 · Borrego, CA · Accident · No injuries · Limited investigation · Final report · Aug 10, 1997 · N577JL · Substantial damage
  > The pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain runway alignment during the takeoff roll.
- [NTSB SEA97LA183](https://openairdocs.org/ntsb/SEA97LA183.md): Cessna 150M · Stanley, ID · Accident · No injuries · Limited investigation · Final report · Aug 8, 1997 · N704AA · Substantial damage
  > The pilot's failure to attain rotation speed. The pilot's failure to maintain aircraft control and rough runway conditions were factors.
- [NTSB LAX97FA276](https://openairdocs.org/ntsb/LAX97FA276.md): Lockheed L-1011-385-1-15 · Honolulu, HI · Accident · Serious injuries · Field investigation · Final report · Aug 8, 1997 · N740DA · Minor damage
  > the cumulative distance taxied immediately prior to takeoff that precipitated an excessive heat buildup in the tires and resulted in the bead separation of a single tire during the takeoff roll. The absence of cockpit procedures/directives or monitoring…
- [NTSB DCA97MA059](https://openairdocs.org/ntsb/DCA97MA059.md): Douglas DC-8-61 · Miami, FL · Accident · 5 fatal · Class 1 · Major · Final report · Aug 7, 1997 · N27UA · Destroyed
  > The airplane being misloaded to produce a more aft center of gravity and a correspondingly incorrect stabilizer trim setting that precipitated an extreme pitch-up at rotation, was (1) the failure of Fine Air to exercise operational control over the cargo…
- [NTSB CHI97LA234](https://openairdocs.org/ntsb/CHI97LA234.md): Rutan Defiant · Alma, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 1997 · N20SR · Destroyed
  > the pilot did not perform an adequate preflight check and he did not perform the takeoff checklist. Factors included the pilot's inadequate design of the safety latch and the canopy inadvertently deploying.
- [NTSB ANC97LA115](https://openairdocs.org/ntsb/ANC97LA115.md): Bell 206-LIII · Wasilla, AK · Accident · Minor injuries · Limited investigation · Final report · Aug 1, 1997 · N94TA · Substantial damage
  > The pilot's inadvertent dynamic rollover during liftoff. Factors associated with the accident were soft terrain and a snagged landing gear skid.
- [NTSB SEA97LA179](https://openairdocs.org/ntsb/SEA97LA179.md): Cessna 180B · Spanish Fork, UT · Accident · No injuries · Limited investigation · Final report · Jul 30, 1997 · N929AE · Substantial damage
  > The pilot's inadequate compensation for the crosswind. A factor was the crosswind.
- [NTSB FTW97LA289](https://openairdocs.org/ntsb/FTW97LA289.md): Cessna 172P · La Porte, TX · Accident · No injuries · Limited investigation · Final report · Jul 29, 1997 · N52336 · Substantial damage
  > failure of the pilot to maintain directional control of the airplane during the takeoff roll, as he attempted to close and lock the left cabin window. Factors relating to the accident were: the pilot's failure to follow the before takeoff checklist (secure…
- [NTSB FTW97LA288](https://openairdocs.org/ntsb/FTW97LA288.md): Schleicher ASW-20 · Briggs, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 1997 · N37VV · Substantial damage
  > The pilot's failure to maintain aircraft control. A factor was the high vegetation on the side of the runway.
- [NTSB ANC97LA110](https://openairdocs.org/ntsb/ANC97LA110.md): Cessna 185 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Jul 23, 1997 · N9855X · Substantial damage
  > The pilots failure to maintain terrain clearance during the downslope, downwind, high altitude, takeoff. Factors were the snow and lighting conditions, and the tailwind takeoff.
- [NTSB SEA97LA174](https://openairdocs.org/ntsb/SEA97LA174.md): Bell 47G-3B1 · Idaho Falls, ID · Accident · No injuries · Limited investigation · Final report · Jul 22, 1997 · N3069G · Substantial damage
  > The pilot-in-command's failure to verify the proper chemical and fuel load aboard prior to takeoff. Factors contributing to the accident were: excessive fuel and chemical loading by ground personnel, tailwind conditions, and high density altitude.
- [NTSB FTW97LA279](https://openairdocs.org/ntsb/FTW97LA279.md): Cessna 180 · Carlisle, AR · Accident · No injuries · Limited investigation · Final report · Jul 22, 1997 · N9320C · Substantial damage
  > the pilot's failure to maintain directional control of the airplane during the takeoff roll (at night).
- [NTSB ATL97LA111](https://openairdocs.org/ntsb/ATL97LA111.md): Avid IV · Memphis, TN · Accident · No injuries · Limited investigation · Final report · Jul 21, 1997 · N913R · Substantial damage
  > The pilot's failure to maintain control of the aircraft during takeoff. A factor in the accident was the repositioning of the control stick.
- [NTSB SEA97LA170](https://openairdocs.org/ntsb/SEA97LA170.md): Cessna 172M · Donnelly, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1997 · N1418U · Substantial damage
  > The pilot's failure to perform proper preflight planning for the flight, and his failure to obtain/maintain clearance from trees during takeoff. Factors contributing to the accident include the pilot's delayed remedial action, his improper use of flaps, and…
- [NTSB FTW97LA275](https://openairdocs.org/ntsb/FTW97LA275.md): Eichman Aerobat III · Brownsville, TX · Accident · 1 fatal · Limited investigation · Final report · Jul 20, 1997 · N17638 · Substantial damage
  > inadequate design by the pilot/builder/designer. Related factors were: the porpoise that was encountered by the pilot during the takeoff, and the subsequent jammed rudder.
- [NTSB CHI97LA216](https://openairdocs.org/ntsb/CHI97LA216.md): Schweizer SGS 2-8 · Menominee Falls, WI · Accident · Serious injuries · Limited investigation · Final report · Jul 20, 1997 · N79106 · Substantial damage
  > the slippage of the glider launch equipment (winch). Factors were the pilot's encounter with a stall/spin and the lack of possibility for remedial action to avoid impact with the terrain.
- [NTSB ATL97LA108](https://openairdocs.org/ntsb/ATL97LA108.md): Cessna 152 · Arcadia, FL · Accident · No injuries · Limited investigation · Final report · Jul 20, 1997 · N152DG · Substantial damage
  > failure of the right nose wheel steering linkage. The close proximity of the fence was a related factor.
- [NTSB ANC97LA107](https://openairdocs.org/ntsb/ANC97LA107.md): Piper PA-18-150 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Jul 20, 1997 · N6822L · Destroyed
  > The pilot's failure to maintain aircraft control during takeoff. Factors were the intentional relinquishing of controls by the pilot, and interference with the rudder controls by the nonpilot passenger.
- [NTSB IAD97LA101](https://openairdocs.org/ntsb/IAD97LA101.md): Piper PA-28R-180 · Edgartown, MA · Accident · No injuries · Limited investigation · Final report · Jul 19, 1997 · N4530J · Substantial damage
  > The pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Related factors were the crosswind, wind gusts and high vegetation.
- [NTSB ANC97LA106](https://openairdocs.org/ntsb/ANC97LA106.md): de Havilland DHC-2 · Alagnak River, AK · Accident · No injuries · Limited investigation · Final report · Jul 19, 1997 · N68084 · Substantial damage
  > A partial loss of engine power for an undetermined reason, and the pilot's intentional operation of the airplane with known deficiencies.
- [NTSB FTW97LA273](https://openairdocs.org/ntsb/FTW97LA273.md): Christen Industries Pitts S-2B · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Jul 18, 1997 · N5351N · Substantial damage
  > Inaccurate compensation for wind conditions and improper recovery from a bounced landing by the CFI pilot in command. A factor was a crosswind.

Next page: https://openairdocs.org/ntsb-phases/300/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 = 300)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/300/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.