# 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 30 of 281 · 14,035 cases

## Cases, newest first

- [NTSB CEN19LA229](https://openairdocs.org/ntsb/CEN19LA229.md): Cessna 305A · Houston, MO · Accident · No injuries · Class 3 · Limited · Final report · Jul 21, 2019 · N1831 · Substantial damage
  > A total loss of engine power during initial climb due to carburetor icing, which resulted in a forced landing and impact with trees and terrain.
- [NTSB CEN19FA235](https://openairdocs.org/ntsb/CEN19FA235.md): Cessna 175 · Kilgore, TX · Accident · Fatal · Class 3 · Field · Final report · Jul 20, 2019 · N7013M · Substantial damage
  > The noncertificated pilot’s exceedance of the airplane’s critical angle of attack when the airplane became airborne during a high-speed taxi test, resulting in an aerodynamic stall and impact with terrain.
- [NTSB WPR19LA196](https://openairdocs.org/ntsb/WPR19LA196.md): Cessna 210 5(205) · Dallesport, OR · Accident · No injuries · Class 3 · Limited · Final report · Jul 19, 2019 · N8260Z · Destroyed
  > The pilot’s improper pitch control during the aborted takeoff, which resulted in a bounced landing and landing gear collapse.
- [NTSB GAA19CA450](https://openairdocs.org/ntsb/GAA19CA450.md): Rockwell 112A · Cove, OR · Accident · No injuries · Data collection · Final report · Jul 19, 2019 · N1330J · Substantial damage
  > The pilot's delayed decision to abort the takeoff from a grass runway, which resulted in a runway overrun and subsequent impact with a pole.
- [NTSB GAA19CA440](https://openairdocs.org/ntsb/GAA19CA440.md): Cessna 172 · Denver, CO · Accident · No injuries · Data collection · Final report · Jul 19, 2019 · N403FR · Substantial damage
  > The student pilot's failure to maintain lateral control during a soft-field takeoff, which resulted in the left wing striking the runway and a runway excursion.
- [NTSB ANC19FA035](https://openairdocs.org/ntsb/ANC19FA035.md): De Havilland Beaver DHC 2 · Seldovia, AK · Accident · 1 fatal · Class 2 · Field · Final report · Jul 19, 2019 · N68083 · Substantial damage
  > The airplane's floats impact with an ocean wave or swell, which exceeded the design load specifications of the flying wire assemblies and resulted in a partial separation of the float assemblies.
- [NTSB WPR19LA191](https://openairdocs.org/ntsb/WPR19LA191.md): Bolkow Phoebus · Alvord Desert, OR · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 17, 2019 · N112AJ · Destroyed
  > Pilot’s failure to properly respond to a slack towline during takeoff, which resulted in a loss of control of the glider.
- [NTSB GAA19CA428](https://openairdocs.org/ntsb/GAA19CA428.md): Robinson R44 · Council Bluff, IA · Accident · Minor injuries · Data collection · Final report · Jul 16, 2019 · N124LA · Substantial damage
  > The pilot's improper cyclic input during liftoff from a landing deck, which resulted in the right skid hooking onto an opening on the landing deck and a subsequent dynamic rollover.
- [NTSB WPR19LA195](https://openairdocs.org/ntsb/WPR19LA195.md): Cessna T210 · Hurricane, UT · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 15, 2019 · N6330N · Substantial damage
  > Maintenance personnel's improper installation of a throttle cable to the throttle body arm, which resulted in a throttle detachment during takeoff and subsequent loss of power. Contributing to the accident was the inadequate inspection of the throttle…
- [NTSB GAA19CA416](https://openairdocs.org/ntsb/GAA19CA416.md): Thomas Wild Avid · York, SC · Accident · No injuries · Data collection · Final report · Jul 15, 2019 · N987TW · Substantial damage
  > The pilot's inadvertent reduction of power during the initial climb, which resulted in an aerodynamic stall. Contributing to the pilot’s inadvertent reduction of power was his lack of experience with his left hand on the control stick and right hand on the…
- [NTSB WPR19LA190](https://openairdocs.org/ntsb/WPR19LA190.md): Cessna P206 · Cascade, ID · Accident · No injuries · Class 3 · Limited · Final report · Jul 14, 2019 · N131DV · Substantial damage
  > A loss of engine power due to the pilot’s improper leaning of the engine.
- [NTSB GAA19WA420](https://openairdocs.org/ntsb/GAA19WA420.md): AIRvan GA8 · Umea, Sweden · Accident · 9 fatal · Foreign investigation · Jul 14, 2019 · SE-MES · Destroyed
  > The government of Sweden has notified the NTSB of an accident involving a AIRvan GA8 airplane that occurred on July 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…
- [NTSB GAA19CA447](https://openairdocs.org/ntsb/GAA19CA447.md): Biuro Projektowe B Bogumil Ber SZD-56-2 · Sparks, NV · Accident · No injuries · Data collection · Final report · Jul 14, 2019 · N821W · Substantial damage
  > The pilot’s failure to abort the takeoff in a timely manner, which resulted in glider settling into sage brush.
- [NTSB ERA19LA227](https://openairdocs.org/ntsb/ERA19LA227.md): Piper PA22 · Hastings, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 14, 2019 · N7833D · Substantial damage
  > The pilot’s failure to secure the engine primer control, which resulted in an overly rich fuel/air mixture and degraded engine performance. Contributing to the accident was the pilot’s failure to abort the takeoff in a timely manner.
- [NTSB CEN19LA224](https://openairdocs.org/ntsb/CEN19LA224.md): Piper PA18 · Osceola, WI · Accident · No injuries · Class 3 · Limited · Final report · Jul 14, 2019 · N6983B · Substantial damage
  > The failure of the right horizontal stabilizer during takeoff, resulting in a loss of control and forced landing. Contributing to the accident was the installation of an unapproved stabilizer frame and failure of maintenance personnel to identify…
- [NTSB ANC19WA041](https://openairdocs.org/ntsb/ANC19WA041.md): Robinson R22 · Moscow, Russia · Accident · 2 fatal · Foreign investigation · Jul 14, 2019 · RA-1789G · Destroyed
  > On July 14, 2019, at 1551 Moscow time, a Russian registered Robinson R-22M helicopter was destroyed after impacting terrain after takeoff from the Shevlino landing site, Moscow region, Russian Federation. The helicopter was privately owned and operated. The…
- [NTSB CEN19LA222](https://openairdocs.org/ntsb/CEN19LA222.md): Stinson 108 · Clinton, AR · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 13, 2019 · N9651K · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB DCA19WA184](https://openairdocs.org/ntsb/DCA19WA184.md): Boeing 737 · San Jose, Costa Rica · Incident · No injuries · Foreign investigation · Jul 11, 2019 · N86534 · Minor damage
  > The CETAC of Costa Rica has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CETAC's investigation under the provisions of ICAO Annex 13 as…
- [NTSB CEN19LA217](https://openairdocs.org/ntsb/CEN19LA217.md): Piper PA34 · Ypsilanti, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 2019 · N2930Y · Substantial damage
  > The pilot's premature movement of the landing gear selector to the "up" position during takeoff, which allowed the landing gear to retract before a positive climb rate was established, and the lack of a positive climb rate, which led to the airplane settling…
- [NTSB WPR19LA207](https://openairdocs.org/ntsb/WPR19LA207.md): Stinson 108 · Klamath Falls, OR · Accident · No injuries · Class 3 · Limited · Final report · Jul 9, 2019 · N6642M · Substantial damage
  > The mechanic’s failure to identify an engine performance issue, which led to a partial loss of engine power. Contributing to the accident was the pilot’s decision to operate the airplane with a known mechanical deficiency.
- [NTSB GAA19CA438](https://openairdocs.org/ntsb/GAA19CA438.md): Beech 19 · Columbia Station, OH · Accident · No injuries · Data collection · Final report · Jul 9, 2019 · N9161S · Substantial damage
  > The pilot's failure to see and avoid tall grass along the side of the runway during the takeoff roll, which resulted in his loss of directional control, a runway excursion, and nose-over.
- [NTSB CEN19LA215](https://openairdocs.org/ntsb/CEN19LA215.md): Beech 65 · Sidney, NE · Accident · No injuries · Class 3 · Limited · Final report · Jul 9, 2019 · N62069 · Substantial damage
  > The improper maintenance of the outboard left wing, which allowed electrical arcing and leaking of the fuel sending unit and subsequently resulted in ignition of fuel vapors and an explosion of the outboard left wing.
- [NTSB GAA19CA387](https://openairdocs.org/ntsb/GAA19CA387.md): Piper PA32 · Seldovia, AK · Accident · No injuries · Data collection · Final report · Jul 7, 2019 · N3556W · Substantial damage
  > The pilot's failure to attain a sufficient climb following a short-field takeoff, which resulted in collision with trees.
- [NTSB GAA19CA389](https://openairdocs.org/ntsb/GAA19CA389.md): Cessna 152 · Paris, TX · Accident · No injuries · Data collection · Final report · Jul 6, 2019 · N757YK · Substantial damage
  > The student pilot's failure to maintain the runway heading during takeoff with a crosswind, which resulted in impact with a hay bale left of the runway, and his improper decision to perform a soft-field takeoff without adequate practice.
- [NTSB CEN19LA219](https://openairdocs.org/ntsb/CEN19LA219.md): Fisher Flying Products Super Koala · Hazen, ND · Accident · No injuries · Class 3 · Limited · Final report · Jul 6, 2019 · N220FF · Substantial damage
  > The airplane owner's and mechanic's improper rigging and cable tension of the aileron control system, which resulted in a loss of control during takeoff.
- [NTSB GAA19CA393](https://openairdocs.org/ntsb/GAA19CA393.md): Cessna A185 · Stanley, ID · Accident · No injuries · Data collection · Final report · Jul 2, 2019 · N612TW · Substantial damage
  > The pilot's failure to maintain directional control and his overapplication of brakes during an aborted takeoff, which resulted in a runway excursion and subsequent nose-over.
- [NTSB CEN19FA191](https://openairdocs.org/ntsb/CEN19FA191.md): Piper J3C · Elyria, OH · Accident · 1 fatal · Class 3 · Field · Final report · Jun 30, 2019 · N98527 · Substantial damage
  > A loss of engine power due to carburetor icing, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB GAA19CA378](https://openairdocs.org/ntsb/GAA19CA378.md): Cessna 180 · Wasilla, AK · Accident · No injuries · Data collection · Final report · Jun 28, 2019 · N9939V · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll, which resulted in the left wing striking bushes. Contributing to the accident was the pilot’s distorted visual perception due to his flying with one seat cushion rather than the two…
- [NTSB GAA19WA386](https://openairdocs.org/ntsb/GAA19WA386.md): Cessna 182 · Chimaltenango, Guatemala · Accident · 2 fatal · Foreign investigation · Jun 27, 2019 · N5388N · Destroyed
- [NTSB GAA19CA385](https://openairdocs.org/ntsb/GAA19CA385.md): Piper PA 12 · Skwentna, AK · Accident · No injuries · Data collection · Final report · Jun 27, 2019 · N3914M · Substantial damage
  > The pilot's use of excessive brakes during an aborted takeoff, which resulted in a nose-over.
- [NTSB ERA19LA219](https://openairdocs.org/ntsb/ERA19LA219.md): Vans RV 4 · Williamson, GA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 27, 2019 · N102GL · Substantial damage
  > The pilot's inadvertent misplacement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB GAA19CA413](https://openairdocs.org/ntsb/GAA19CA413.md): Cessna 152 · Clewiston, FL · Accident · No injuries · Data collection · Final report · Jun 23, 2019 · N5096L · Substantial damage
  > The student pilot's maneuver to the left to avoid striking birds during takeoff and his subsequent loss of directional control after aborting the takeoff and landing on soft, muddy grass adjacent to the runway during, which resulted in a nose-over.
- [NTSB WPR19MA177](https://openairdocs.org/ntsb/WPR19MA177.md): Beech 65-A90 · Mokuleia, HI · Accident · 11 fatal · Class 2 · Major · Final report · Jun 22, 2019 · N256TA · Destroyed
  > The pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…
- [NTSB CEN19LA181](https://openairdocs.org/ntsb/CEN19LA181.md): Quicksilver Sport · Barnesville, OH · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 22, 2019 · UNREG · Substantial damage
  > The pilot's loss of control for undetermined reasons.
- [NTSB WPR19LA176](https://openairdocs.org/ntsb/WPR19LA176.md): Cessna 172 · Fullerton, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 21, 2019 · N64460 · Substantial damage
  > Partial loss of engine power during takeoff due to an age-degraded carburetor heat valve seal, which detached and partially blocked the carburetor air inlet. Contributing to the accident was an inadequate maintenance inspection.
- [NTSB GAA19CA369](https://openairdocs.org/ntsb/GAA19CA369.md): Piper L21 · Imnaha, OR · Accident · No injuries · Data collection · Final report · Jun 21, 2019 · N753AT · Substantial damage
  > The pilot's failure to maintain directional control while taking off from a soft, rough field, which resulted in a ground-loop.
- [NTSB ANC19FA026](https://openairdocs.org/ntsb/ANC19FA026.md): Helio H 250 · Seward, AK · Accident · 3 fatal · Field investigation · Final report · Jun 21, 2019 · N6314V · Destroyed
  > The pilot's failure to maintain clearance from trees during takeoff, which resulted in an in-flight collision, a loss of control, and impact with terrain.
- [NTSB DCA19WA173](https://openairdocs.org/ntsb/DCA19WA173.md): Boeing 737 · Bandung, Indonesia · Incident · No injuries · Foreign investigation · Jun 20, 2019 · 9M-LCK · Minor damage
  > The government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions…
- [NTSB GAA19CA359](https://openairdocs.org/ntsb/GAA19CA359.md): Autogyro Cavalon · Nephi, UT · Accident · Minor injuries · Data collection · Final report · Jun 19, 2019 · N882M · Substantial damage
  > The pilot's insufficient rudder input during takeoff, which resulted in a loss of yaw control and a hard landing.
- [NTSB DCA19WA174](https://openairdocs.org/ntsb/DCA19WA174.md): Boeing 737 · Birmingham, United Kingdom · Incident · No injuries · Foreign investigation · Jun 18, 2019 · YR-BMJ · No damage
  > The government of United Kingdom has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…
- [NTSB GAA19CA405](https://openairdocs.org/ntsb/GAA19CA405.md): Eurocopter EC135 · Cobleskill, NY · Accident · No injuries · Data collection · Final report · Jun 17, 2019 · N135WJ · Substantial damage
  > The pilot's failure to maintain situational awareness during takeoff from a confined area, which resulted in the helicopter rotors striking tree branches.
- [NTSB GAA19CA364](https://openairdocs.org/ntsb/GAA19CA364.md): Cessna 170 · Hewitt Lake, AK · Accident · No injuries · Data collection · Final report · Jun 17, 2019 · N4427B · Substantial damage
  > The pilot's failure to maintain directional control during takeoff from a soft, grass airstrip, which resulted in impact with brush.
- [NTSB GAA19CA361](https://openairdocs.org/ntsb/GAA19CA361.md): Quicksilver Aircraft Northeast Sport · Ledgedale, PA · Accident · Minor injuries · Data collection · Final report · Jun 17, 2019 · N418RB · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, which resulted a nose-over. Contributing to the accident was the pilot's improper in-flight fuel management, which resulted in the precautionary landing on unsuitable terrain.
- [NTSB GAA19CA348](https://openairdocs.org/ntsb/GAA19CA348.md): Piper PA18 · Fairbanks, AK · Accident · No injuries · Data collection · Final report · Jun 16, 2019 · N2765A · Substantial damage
  > The pilot receiving instruction's premature pitch control input during takeoff, which resulted in an aborted takeoff and subsequent impact with terrain. Contributing to the accident was the flight instructor's delayed remedial action.
- [NTSB ENG19WA039](https://openairdocs.org/ntsb/ENG19WA039.md): Atr ATR42 · Manaus, Brazil · Accident · Minor injuries · Foreign investigation · Jun 15, 2019 · PR-MPN · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a ATR 42-300 airplane that occurred on June 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…
- [NTSB GAA19CA351](https://openairdocs.org/ntsb/GAA19CA351.md): Vans Vans Acft RV 6 · Culpepper, VA · Accident · No injuries · Data collection · Final report · Jun 14, 2019 · N696SH · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in gusting crosswind conditions, which resulted in a ground loop.
- [NTSB GAA19CA339](https://openairdocs.org/ntsb/GAA19CA339.md): Air Tractor AT502 · San Benito, TX · Accident · No injuries · Data collection · Final report · Jun 13, 2019 · N103CK · Substantial damage
  > The pilot's improper decision to take off with the airplane near its maximum allowable gross takeoff weight and his subsequent exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.
- [NTSB CEN19LA166](https://openairdocs.org/ntsb/CEN19LA166.md): Beech E90 · Greenville, TX · Accident · No injuries · Class 3 · Limited · Final report · Jun 12, 2019 · N176TW · Substantial damage
  > The fatigue failure of the right main landing gear upper torque knee.
- [NTSB DCA19WA163](https://openairdocs.org/ntsb/DCA19WA163.md): Casa C212 · Kuinga, Kenya · Accident · No injuries · Foreign investigation · Jun 11, 2019 · N603AR · Substantial damage
  > The Ministry of Transport of the Republic of Kenya has notified the NTSB of an accident involving a CASA 212, which occurred on June 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under the provisions of ICAO…
- [NTSB WPR19FA161](https://openairdocs.org/ntsb/WPR19FA161.md): Lockwood Aircam · Hemet, CA · Accident · 1 fatal · Class 2 · Field · Final report · Jun 8, 2019 · N123GN · Substantial damage
  > The pilot/builder's improper installation of the left wing during the build process, which resulted in the wing failing during takeoff.

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

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

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