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

## Cases, newest first

- [NTSB ANC97LA103](https://openairdocs.org/ntsb/ANC97LA103.md): Piper PA-22 · Fairbanks, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1997 · N4520A · Substantial damage
  > The pilot's initiation of an abrupt, evasive maneuver, and his failure to maintain directional control of the airplane. Factors in the accident were an undetermined object crossing the runway and the passenger's rudder control interference during the evasive…
- [NTSB MIA97LA204](https://openairdocs.org/ntsb/MIA97LA204.md): Moran Teenie TWO · Pinehurst, NC · Accident · No injuries · Limited investigation · Final report · Jul 4, 1997 · N9753 · Substantial damage
  > The pilot's decision to takeoff with a tailwind and improper recovery from a bounced landing. This resulted in a premature lift off, in-flight collision with terrain, on-ground loss of directional control, and subsequent on-ground collision with a taxiway…
- [NTSB LAX97LA231](https://openairdocs.org/ntsb/LAX97LA231.md): Cessna P206B · Desert Center, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1997 · N4733F · Destroyed
  > The pilot's unexpected encounter with dust devils during the takeoff ground roll.
- [NTSB LAX97LA230](https://openairdocs.org/ntsb/LAX97LA230.md): Beech 95-B55 · Beaumont, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1997 · N2031W · Substantial damage
  > the pilot's inadvertent movement of the propeller controls, instead of the throttle levers, which resulted in an inadvertent dual engine shutdown. Factors relating to the accident were: the pilot's failure to properly secure the door during preflight, and his…
- [NTSB LAX97LA233](https://openairdocs.org/ntsb/LAX97LA233.md): Cessna 152 · Madera, CA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1997 · N64954 · Substantial damage
  > the student pilot's failure to maintain runway alignment during takeoff.
- [NTSB ATL97LA102](https://openairdocs.org/ntsb/ATL97LA102.md): Piper PA-38-112 · Smithfield, NC · Accident · No injuries · Limited investigation · Final report · Jul 1, 1997 · N2600N · Substantial damage
  > an animal (deer) on the runway. Factors associated with the accident were: the light condition at dusk, and failure or inability of the flight crew to see the deer in time to avoid a collision.
- [NTSB LAX97LA227](https://openairdocs.org/ntsb/LAX97LA227.md): Burkhart Grob G-103-TWIN II · Jacumba, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1997 · N18AG · Substantial damage
  > The pilot's abrupt rotation, which resulted in the breaking of the tow rope. A factor was the low altitude when the tow rope broke, precluding a landing on the runway.
- [NTSB IAD97LA094](https://openairdocs.org/ntsb/IAD97LA094.md): Piper PA-28-161 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1997 · N80964 · Destroyed
  > The pilot's failure to comply with the airplane's takeoff checklist and his delayed decision to abort the takeoff.
- [NTSB ANC97LA094](https://openairdocs.org/ntsb/ANC97LA094.md): Helio H295 · Ekwok, AK · Accident · No injuries · Limited investigation · Final report · Jun 29, 1997 · N6343V · Substantial damage
  > The pilot's selection of an unsuitable area for takeoff.
- [NTSB MIA97LA199](https://openairdocs.org/ntsb/MIA97LA199.md): Sloan RV-6 · Muscle Shoals, AL · Accident · No injuries · Limited investigation · Final report · Jun 28, 1997 · N626BA · Substantial damage
  > the pilot's failure to see-and-avoid the bales of hay duirng the takeoff roll, which resulted in an in-flight collision with a bale at liftoff and subsequent in-flight collision with terrain.
- [NTSB CHI97LA185](https://openairdocs.org/ntsb/CHI97LA185.md): Pzl-Mielec M-18A · Manito, IL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1997 · N7015N · Substantial damage
  > loss of engine power for undetermined reason(s).
- [NTSB FTW97LA235](https://openairdocs.org/ntsb/FTW97LA235.md): Piper PA-28RT-201 · Whitewright, TX · Accident · No injuries · Limited investigation · Final report · Jun 25, 1997 · N8326S · Substantial damage
  > The pilot's selection of an unsuitable area for takeoff. A factor was the dirt bank (terrace).
- [NTSB CHI97LA184](https://openairdocs.org/ntsb/CHI97LA184.md): Weatherly 201C · Buffalo, ND · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1997 · N1299W · Substantial damage
  > the pilot's inadequate preflight planning/preparation, and his failure to maintain directional control of the airplane. Water on the runway and the soft terrain were related factors.
- [NTSB MIA97LA195](https://openairdocs.org/ntsb/MIA97LA195.md): Air Tractor AT-502 · Tunica, MS · Accident · No injuries · Limited investigation · Final report · Jun 24, 1997 · N45461 · Substantial damage
  > The pilots poor preflight planning preparation for attempting to takeoff with a tailwind and with the hopper loaded 3/4 full during a 93degree F., day at a density altitude of 2,400 feet.
- [NTSB FTW97LA233](https://openairdocs.org/ntsb/FTW97LA233.md): Grumman G-164B · Swifton, AR · Accident · No injuries · Limited investigation · Final report · Jun 24, 1997 · N6740Q · Destroyed
  > the pilot's improper planning/decision. Factors relating to the accident were: the pilot's lack of recent experience in type of airplane, the weather condition (high temperature and tailwind), and the proximity of the fence and trees to the runway.
- [NTSB SEA97LA149](https://openairdocs.org/ntsb/SEA97LA149.md): Piper PA-28-140 · Madras, OR · Accident · No injuries · Limited investigation · Final report · Jun 21, 1997 · N1357T · Substantial damage
  > The pilot's failure to abort the takeoff. Factors include high vegetation, rough runway, and failure to attain adequate flying speed.
- [NTSB MIA97LA191](https://openairdocs.org/ntsb/MIA97LA191.md): Sherman Powell Kitfox IV · Concord, NC · Accident · No injuries · Limited investigation · Final report · Jun 21, 1997 · N582KF · Substantial damage
  > Failure of the pilot-in-command to maintain directional control and his poor preflight planning preparation for allowing the pilot rated passenger to manipulate the throttle control. Contributing to the accident was the pilots total lack of experience in make…
- [NTSB IAD97LA092](https://openairdocs.org/ntsb/IAD97LA092.md): Piper PA-32R-300 · Defiance, OH · Accident · No injuries · Limited investigation · Final report · Jun 21, 1997 · N5716F · Substantial damage
  > The failure of a wheel rim due to overstress separation with no clear evidence initiating event.
- [NTSB CHI97LA177](https://openairdocs.org/ntsb/CHI97LA177.md): Cessna A188B · Satanta, KS · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1997 · N4954R · Substantial damage
  > the pilot not maintaining aircraft control shortly after it had touched down during its liftoff. A factor in this accident was the premature liftoff during takeoff by the pilot.
- [NTSB CHI97LA176](https://openairdocs.org/ntsb/CHI97LA176.md): Maule M5C · Lino Lakes, MN · Accident · No injuries · Limited investigation · Final report · Jun 21, 1997 · N5643Y · Substantial damage
  > the flight instructor's inadequate preflight planning/preparation, his the improper lowering of flaps for takeoff, his failure to use a longer available area for takeoff, and his failure to abort the takeoff before there was an insufficient amount of area…
- [NTSB FTW97LA231](https://openairdocs.org/ntsb/FTW97LA231.md): Wsk Pzl Mielec M-18A · Waldenburg, AR · Accident · No injuries · Limited investigation · Final report · Jun 20, 1997 · N148RA · Destroyed
  > the pilot's improper planning/decision. The short runway and failure to use up to 10 degrees of flaps were related factors.
- [NTSB CHI97LA178](https://openairdocs.org/ntsb/CHI97LA178.md): Grumman-Schweizer G-164A · Benton, MO · Accident · No injuries · Limited investigation · Final report · Jun 20, 1997 · N48FS · Substantial damage
  > the pilot's inadequate preflight by failing to insure that the secondary flight control lock was stowed properly, and subsequently the secondary flight control lock becoming engaged during the takeoff run. A factor relating to the accident was: inadequate…
- [NTSB NYC97LA122](https://openairdocs.org/ntsb/NYC97LA122.md): Piper PA-28-181 · Manchester, KY · Accident · No injuries · Limited investigation · Final report · Jun 19, 1997 · N2111G · Substantial damage
  > The pilot's delay in aborting the takeoff. A factor in the accident was the high, wet grassy runway.
- [NTSB LAX97LA216](https://openairdocs.org/ntsb/LAX97LA216.md): Cessna 120 · Hollister, CA · Accident · No injuries · Limited investigation · Final report · Jun 17, 1997 · N1819N · Substantial damage
  > the pilot's excessive use of right rudder during the initial stages of the takeoff ground roll, which resulted in his failure to maintain directional control. The unfavorable wind was a related factor.
- [NTSB SEA97LA141](https://openairdocs.org/ntsb/SEA97LA141.md): Wood Murphy Rebel · Marion, MT · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1997 · N224MR · Substantial damage
  > The pilot's failure to maintain clearance from the terrain/water. Factors include gusty winds and downdrafts.
- [NTSB LAX97LA212](https://openairdocs.org/ntsb/LAX97LA212.md): Schweizer G-164B · Rio Linda, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 1997 · N3631G · Substantial damage
  > the pilot's inadequate preflight planning/preparation by failing to ensure that sufficient airspeed would be obtained and/or maintained to remain clear of obstacles at the departure end of the runway. The obstacles (power lines & poles) were a related factor.
- [NTSB NYC97LA120](https://openairdocs.org/ntsb/NYC97LA120.md): Boccher P51 Mustang · North Rose, NY · Accident · No injuries · Limited investigation · Final report · Jun 15, 1997 · N515JB · Destroyed
  > was the failure of the pilot to maintain directional control during takeoff which resulted in the airplane striking trees.
- [NTSB SEA97LA140](https://openairdocs.org/ntsb/SEA97LA140.md): Republic RC-3-1 · Monument Valley, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 1997 · N6290K · Substantial damage
  > the pilot's inadequate preflight planing/preparation, and his failure to maintain sufficient altitude or clearance from the terrain. Factors relating to the accident included: high, gusty, variable winds, and terrain induced downdrafts.
- [NTSB SEA97LA138](https://openairdocs.org/ntsb/SEA97LA138.md): Piper PA-28-140 · Waldport, OR · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 1997 · N1438T · Substantial damage
  > the pilot's inadequate preflight planning/preparation to ensure he could execute a safe departure in the meteorological conditions present at the time. Related factors included: the unfavorable/variable/gusty wind conditions; and a power line near the…
- [NTSB SEA97LA137](https://openairdocs.org/ntsb/SEA97LA137.md): Aero Commander Callair A-9B · Saint Anthony, ID · Accident · No injuries · Limited investigation · Final report · Jun 12, 1997 · N7922V · Substantial damage
  > the pilot's improper planning/decision and failure to dump the load of chemicals. Related factors were: the high density altitude, and a dirt embankment that was encountered during the landing roll.
- [NTSB FTW97LA216](https://openairdocs.org/ntsb/FTW97LA216.md): Wsk Pzl Mielec M-18 · Swifton, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 1997 · N6220C · Destroyed
  > Main landing gear collapse resulting from a failure of the torque link assembly attaching bolt. A factor was the lack of required maintenance (lubrication of the bolt) which resulted in the bolt becoming dry and corroded.
- [NTSB CHI97GA166](https://openairdocs.org/ntsb/CHI97GA166.md): Hughes 269A-1 · Cedar Rapids, IA · Accident · Serious injuries · Final report · Jun 12, 1997 · N1020U · Destroyed
  > loss of engine power due to undetermined reason(s). Related factors included the obstructions (building, utility pole, and transmission wires); and the lack of a functional windsock, due to inadequate facility maintenance by the operator.
- [NTSB IAD97LA085](https://openairdocs.org/ntsb/IAD97LA085.md): Mc Ardle Kolb Mark III · Findlay, OH · Accident · Serious injuries · Limited investigation · Final report · Jun 11, 1997 · N1144T · Substantial damage
  > The loss of power due to one of two carburetors disconnecting in flight for undetermined reasons, and the subsequent collision with the terrain during forced landing.
- [NTSB SEA97LA132](https://openairdocs.org/ntsb/SEA97LA132.md): Piper PA-18-135 · Big Creek, ID · Accident · No injuries · Limited investigation · Final report · Jun 7, 1997 · N27296 · Substantial damage
  > the pilot's improper positioning of the fuel selector to the 'OFF' position, which resulted in fuel starvation and loss of engine power during takeoff. Factors relating to the accident were: down-sloping terrain (airstrip) and trees that were encountered…
- [NTSB FTW97LA211](https://openairdocs.org/ntsb/FTW97LA211.md): Beech 58 · Oklahoma City, OK · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1997 · N22SS · Substantial damage
  > The pilot's impairment of judgment and performance due to alcohol which led to an attempted takeoff in an airplane without an elevator installed.
- [NTSB CHI97LA158](https://openairdocs.org/ntsb/CHI97LA158.md): Kohles Kitfox III · Meadow Grove, NE · Accident · No injuries · Limited investigation · Final report · Jun 4, 1997 · N515JK · Substantial damage
  > failure of the pilot to maintain directional control of the airplane during an aborted takeoff. A factor was the pilot's lack of recent experience in the make and model of airplane.
- [NTSB ANC97LA081](https://openairdocs.org/ntsb/ANC97LA081.md): Piper PA-22 · Healy, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 2, 1997 · N3602A · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane and runway alignment. Factors relating to the accident were: the crosswind, and the proximity of a creek (ravine) to the runway.
- [NTSB SEA97LA121](https://openairdocs.org/ntsb/SEA97LA121.md): Piper PA-28R-201 · Pocatello, ID · Accident · No injuries · Limited investigation · Final report · May 26, 1997 · N30563 · Substantial damage
  > inadequate remedial action of the pilot-in-command (CFI). Related factors include: the dual student's failure to maintain the proper airspeed and descent rate.
- [NTSB NYC97LA097](https://openairdocs.org/ntsb/NYC97LA097.md): Enstrom 280-C · Clarksburg, NJ · Accident · Serious injuries · Limited investigation · Final report · May 21, 1997 · N613LG · No damage
  > The pilot's failure to maintain adequate clearance from the hangar.
- [NTSB MIA97LA169](https://openairdocs.org/ntsb/MIA97LA169.md): Cessna Wren 182G-460 · Spartanburg, SC · Accident · No injuries · Limited investigation · Final report · May 18, 1997 · N3182S · Substantial damage
  > the pilot's inadequate preflight planning/preparation, by failure to survey the takeoff area, and his delay in aborting the takeoff. Upsloping terrain and high vegetation in the takeoff area were related factors.
- [NTSB ANC97TA074](https://openairdocs.org/ntsb/ANC97TA074.md): Schweizer SGS 1-26E · Fort Wainwright, AK · Accident · No injuries · Final report · May 17, 1997 · N2952H · Substantial damage
  > the pilot's inadequate preflight and improper planning/decision. Factors relating to the accident were: an unlatched canopy, and unsuitable terrain for landing.
- [NTSB SEA97LA109](https://openairdocs.org/ntsb/SEA97LA109.md): Learjet 35A · Great Falls, MT · Accident · Minor injuries · Limited investigation · Final report · May 16, 1997 · N1AH · Substantial damage
  > the captain's inadequate preflight planning/preparation, and the subsequent improper response to a simulated loss of engine power, resulting in liftoff at an airspeed below that for which sustained flight was possible.
- [NTSB MIA97LA167](https://openairdocs.org/ntsb/MIA97LA167.md): Cessna 150K · Ball Ground, GA · Accident · Minor injuries · Limited investigation · Final report · May 16, 1997 · N5689G · Substantial damage
  > failure of the pilot to maintain directional control during the takeoff roll and his failure to abort the takeoff before colliding with an embankment.
- [NTSB CHI97LA151](https://openairdocs.org/ntsb/CHI97LA151.md): Beech 35 · Liberty, MO · Accident · No injuries · Limited investigation · Final report · May 13, 1997 · N144GM · Substantial damage
  > retraction of the nose gear for undetermined reason(s).
- [NTSB SEA97LA103](https://openairdocs.org/ntsb/SEA97LA103.md): Cessna 152 · Deer Lodge, MT · Accident · No injuries · Limited investigation · Final report · May 9, 1997 · N714VL · Substantial damage
  > The pilot's improper decision to abort the takeoff, and his improper use of brakes during the abort. A factor contributing to the accident was the pilot's failure to maintain directional control during the takeoff roll.
- [NTSB LAX97LA199](https://openairdocs.org/ntsb/LAX97LA199.md): Cessna 172N · El Monte, CA · Accident · No injuries · Limited investigation · Final report · May 7, 1997 · N6469D · Substantial damage
  > the student pilot's misunderstanding of the controller's clearance during an aborted touch-and-go landing.
- [NTSB SEA97LA098](https://openairdocs.org/ntsb/SEA97LA098.md): Piper PA-46-310P · Tooele, UT · Accident · No injuries · Limited investigation · Final report · May 5, 1997 · N977RA · Substantial damage
  > the pilot's excessive rotation of the aircraft during takeoff, and his failure to obtain/maintain adequate airspeed. Inadequate supervision by the instructor pilot (CFI/check pilot) was a related factor.
- [NTSB ANC97LA073](https://openairdocs.org/ntsb/ANC97LA073.md): Bellanca 8GCBC · Togiak, AK · Accident · No injuries · Limited investigation · Final report · May 3, 1997 · N86801 · Substantial damage
  > failure of the pilot to properly compensate for crosswind conditions. The crosswind was a related factor.
- [NTSB MIA97LA157](https://openairdocs.org/ntsb/MIA97LA157.md): Thacker Starduster TOO SA300 · Lake Wales, FL · Accident · No injuries · Limited investigation · Final report · May 2, 1997 · N14525 · Substantial damage
  > failure of the tail wheel to lock in the centered detent during the beginning of the takeoff roll, which resulted in the pilot being unable to maintain directional control and the aircraft drifting off the runway and nosing over in the soft ground.
- [NTSB ANC97LA066](https://openairdocs.org/ntsb/ANC97LA066.md): Cessna 180 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · May 2, 1997 · N74806 · Substantial damage
  > the pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. A factor associated with the accident was: the variable crosswind condition.

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

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

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