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

## Cases, newest first

- [NTSB WPR14LA245](https://openairdocs.org/ntsb/WPR14LA245.md): Air Tractor AT 502B · Princeton, CA · Accident · No injuries · Limited investigation · Final report · Jun 13, 2014 · N502JS · Substantial damage
  > The partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN14LA284](https://openairdocs.org/ntsb/CEN14LA284.md): Air Tractor AT-301 · Winner, SD · Accident · No injuries · Limited investigation · Final report · Jun 11, 2014 · N8564S · Substantial damage
  > The pilot's improper decision to attempt a takeoff with a tailwind and his failure to achieve the proper airspeed for liftoff, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.
- [NTSB ENG14WA030](https://openairdocs.org/ntsb/ENG14WA030.md): Boeing 737 - 6H3 · Budapest, Hungary · Incident · No injuries · Foreign investigation · Jun 10, 2014 · TS-IOK · No damage
  > On June 10, 2014, about 1830 local (1630 UTC), a TunisAir Boeing 737-6H3, TS-IOK, operating as flight TU-4671, experienced a malfunction of the No. 1 (left) engine during the takeoff roll at Budapest, Hungary. The pilots rejected the takeoff. A borescope…
- [NTSB CEN14LA537](https://openairdocs.org/ntsb/CEN14LA537.md): Hughes TH 55A · Hudson, WI · Accident · Minor injuries · Limited investigation · Final report · Jun 10, 2014 · N5335U · Substantial damage
  > The nonhelicopter-rated pilot’s operation of the helicopter and its subsequent collision with trees during takeoff for reasons that could not be determined based on the available evidence.
- [NTSB CEN14CA283](https://openairdocs.org/ntsb/CEN14CA283.md): Ayres S2R T34 · Wilmont, AR · Accident · No injuries · Data collection · Final report · Jun 7, 2014 · N23034 · Substantial damage
  > Pilot's failure to verify the amount of chemical load on the airplane prior to takeoff which resulted in the airplane being heavier than expected. Contributing to the accident was loading crew not following the pilot's instructions.
- [NTSB CEN14CA280](https://openairdocs.org/ntsb/CEN14CA280.md): Schempp-Hirth Nimbus 3/24.5 · Wallis, TX · Accident · Minor injuries · Data collection · Final report · Jun 6, 2014 · N245AB · Substantial damage
  > The pilot's failure to maintain direction control of the glider during takeoff in gusty wind conditions.
- [NTSB CEN14CA291](https://openairdocs.org/ntsb/CEN14CA291.md): Jabiru USA Sport J230-SP · Middleton, WI · Accident · No injuries · Data collection · Final report · Jun 5, 2014 · N752J · Substantial damage
  > The pilot's failure to maintain directional control during takeoff.
- [NTSB WPR14CA228](https://openairdocs.org/ntsb/WPR14CA228.md): Piper PA 18A 150 · Leeds, UT · Accident · No injuries · Data collection · Final report · Jun 4, 2014 · N1672P · Substantial damage
  > The pilot's failure to confirm the flaps had been retracted during takeoff, which resulted in a loss of lift and subsequent collision with terrain.
- [NTSB CEN14LA290](https://openairdocs.org/ntsb/CEN14LA290.md): Teunis Starduster TOO SA300 · Fort Worth, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 4, 2014 · N8DT · Substantial damage
  > The non-certificated pilot’s inadequate preflight planning, which resulted in a loss of engine power during takeoff due to fuel exhaustion.
- [NTSB ANC14CA037](https://openairdocs.org/ntsb/ANC14CA037.md): Cessna 170B · Fairbanks, AK · Accident · No injuries · Data collection · Final report · Jun 4, 2014 · N3442D · Substantial damage
  > The airplane's encounter with a tailwind during takeoff from a short, narrow airstrip, which resulted in a loss of lift and collision with brush and small trees.
- [NTSB ERA14MA271](https://openairdocs.org/ntsb/ERA14MA271.md): Gulfstream Aerospace G IV · Bedford, MA · Accident · 7 fatal · Class 1 · Major · Final report · Jun 1, 2014 · N121JM · Destroyed
  > The flight crewmembers' failure to perform the flight control check before takeoff, their attempt to take off with the gust lock system engaged, and their delayed execution of a rejected takeoff after they became aware that the controls were locked.…
- [NTSB ERA14CA278](https://openairdocs.org/ntsb/ERA14CA278.md): Cessna 172F · Mount Pleasant, PA · Accident · Minor injuries · Data collection · Final report · May 31, 2014 · N8394U · Substantial damage
  > The pilot's incorrect takeoff procedures from the soft grass runway and his delay in aborting the takeoff after recognizing slow acceleration.
- [NTSB CEN14IA270](https://openairdocs.org/ntsb/CEN14IA270.md): Bell 407 · Eugene Island 182A · Incident · No injuries · Incident investigation · Final report · May 30, 2014 · N1197 · No damage
  > The improper repair of the outer combustion case, which led to its ultimate failure due to the continued progression of a fatigue crack and resulted in a partial loss of engine power during takeoff.
- [NTSB CEN14CA271](https://openairdocs.org/ntsb/CEN14CA271.md): BRM Aero Sro Bristell S-LSA · Boerne, TX · Accident · No injuries · Data collection · Final report · May 30, 2014 · N348BL · Substantial damage
  > The instructor pilot's failure to regain control of the airplane following the student pilot's initial loss of control of the airplane.
- [NTSB CEN14CA275](https://openairdocs.org/ntsb/CEN14CA275.md): Unknown Buccaneer SX · Wagoner, OK · Accident · Serious injuries · Data collection · Final report · May 29, 2014 · UNREG · Substantial damage
  > The pilot's failure to maintain aircraft control following a loss of engine power during takeoff. Contributing was the pilot's inadequate fuel management that led to fuel starvation/exhaustion and the loss of engine power.
- [NTSB WPR14CA213](https://openairdocs.org/ntsb/WPR14CA213.md): Schleicher ASW 27 · Cedar Valley, UT · Accident · No injuries · Data collection · Final report · May 26, 2014 · N137ED · Substantial damage
  > The pilot's failure to maintain aircraft control during the takeoff roll, which resulted in inadvertent terrain contact by the wing.
- [NTSB WPR14FA209](https://openairdocs.org/ntsb/WPR14FA209.md): Kenneth A Berger Searey LSX · Electric City, WA · Accident · 1 fatal · Field investigation · Final report · May 24, 2014 · N249PW · Substantial damage
  > The pilot’s failure to maintain pitch control during takeoff after encountering a boat wake, which resulted in the airplane bouncing, impacting the water’s surface, and subsequently becoming submerged.
- [NTSB CEN14LA251](https://openairdocs.org/ntsb/CEN14LA251.md): Smythe Donald F Kitfox Classic IV · Slaughter, LA · Accident · Serious injuries · Limited investigation · Final report · May 24, 2014 · N998DS · Substantial damage
  > The pilot’s inadequate preflight planning, which resulted in his attempt to takeoff in conditions under which the airplane was unable to attain a positive rate of climb and resulted in its failure to clear trees.
- [NTSB CEN14CA258](https://openairdocs.org/ntsb/CEN14CA258.md): Air Tractor AT 802A · Hunter, AR · Accident · No injuries · Data collection · Final report · May 24, 2014 · N802KT · Substantial damage
  > The pilot's downwind takeoff from a grass airstrip, which resulted in inadequate climb performance and the subsequent impact with terrain.
- [NTSB WPR14LA206](https://openairdocs.org/ntsb/WPR14LA206.md): Williams Helicopter UH 1H · Waitsburg, WA · Accident · Minor injuries · Limited investigation · Final report · May 23, 2014 · N260TA · Substantial damage
  > An extreme vibration immediately after entering forward flight for reasons that could not be determined because postaccident examination of the helicopter did not reveal any anomalies that would have precluded normal operation. Contributing to the accident…
- [NTSB WPR14CA401](https://openairdocs.org/ntsb/WPR14CA401.md): Piper PA 22 · Roundup, MT · Accident · No injuries · Data collection · Final report · May 23, 2014 · N3460A · Substantial damage
  > The pilot's delayed action to abort the takeoff. Contributing to the accident was the pilot's inadequate preflight planning and a high density altitude.
- [NTSB CEN14FA249](https://openairdocs.org/ntsb/CEN14FA249.md): Raytheon G36 · Silver City, NM · Accident · 4 fatal · Field investigation · Final report · May 23, 2014 · N536G · Destroyed
  > The airplane’s encounter with a strong tailwind and/or windshear, which resulted in an inadvertent stall. Contributing to the accident was the pilot’s continuation of the unstable approach, long landing, and delayed decision to conduct a go-around.
- [NTSB WPR14CA204](https://openairdocs.org/ntsb/WPR14CA204.md): Cessna 150C · Wellington, NV · Accident · No injuries · Data collection · Final report · May 22, 2014 · N2068Z · Substantial damage
  > The pilot's failure to maintain aircraft control while departing from a wet runway.
- [NTSB ERA14LA253](https://openairdocs.org/ntsb/ERA14LA253.md): Piper J3C - 65 · Hopkinsville, KY · Accident · Serious injuries · Limited investigation · Final report · May 22, 2014 · N46777 · Substantial damage
  > The failure of the pilot to identify poor engine performance during the engine run-up before takeoff. Also causal to the accident was the mistimed right magneto and the poor condition of the spark plugs in the No. 4 cylinder.
- [NTSB ERA14CA258](https://openairdocs.org/ntsb/ERA14CA258.md): Costruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MD · Accident · No injuries · Data collection · Final report · May 20, 2014 · N115TE · Substantial damage
  > The student pilot's failure to maintain directional control of the airplane during the takeoff roll.
- [NTSB CEN14LA245](https://openairdocs.org/ntsb/CEN14LA245.md): Piper PA 28-181 · Yuma, CO · Accident · No injuries · Limited investigation · Final report · May 19, 2014 · N9631C · Substantial damage
  > The pilot's failure to maintain directional control after the airplane encountered a wind gust during takeoff roll. Contributing to the accident was the pilot inadvertently using a runway that resulted in a gusty tailwind condition.
- [NTSB CEN14CA250](https://openairdocs.org/ntsb/CEN14CA250.md): Santschi Chris A Vans RV8 · Bonne Terre, MO · Accident · No injuries · Data collection · Final report · May 16, 2014 · N627CS · Substantial damage
  > The pilot's failure to maintain aircraft control on takeoff.
- [NTSB ERA14WA246](https://openairdocs.org/ntsb/ERA14WA246.md): Cessna T206H · Macas, Ecuador · Accident · Serious injuries · Foreign investigation · May 14, 2014 · HC-CFE · Destroyed
  > On May 14, 2014, about 1600 local time, a Cessna T206H, Ecuadorian registration HC-CFE, was substantially damaged when it impacted power lines while returning to land at Edmundo Carvajal Airport (SEMC), Macas, Ecuador, with smoke in the cockpit. The…
- [NTSB ERA14CA240](https://openairdocs.org/ntsb/ERA14CA240.md): Piper PA-28-151 · Norfolk, VA · Accident · No injuries · Data collection · Final report · May 14, 2014 · N32002 · Substantial damage
  > The student pilot's failure to maintain directional control during takeoff.
- [NTSB WPR14LA201](https://openairdocs.org/ntsb/WPR14LA201.md): Schweizer G 164B · Biggs, CA · Accident · No injuries · Limited investigation · Final report · May 13, 2014 · N3633C · Substantial damage
  > The assembler’s improper fabrication of a fuel line (hose) and the subsequent failure to verify that it was not occluded, which resulted in fuel starvation and a total loss of engine power during takeoff.
- [NTSB ENG14IA013](https://openairdocs.org/ntsb/ENG14IA013.md): Raytheon 400A · Sugar Land, TX · Incident · No injuries · Incident investigation · Final report · May 13, 2014 · N412GJ · Minor damage
  > The probable cause of the uncontained No. 2 engine failure on the Raytheon Beechjet 400A was a yellow-crowned night-heron birdstrike that resulted in fan blade contact with the inlet case and rub induced excitation of a previously unidentified natural…
- [NTSB ERA14CA233](https://openairdocs.org/ntsb/ERA14CA233.md): Piper PA 28-180 · Indian Trail, NC · Accident · Minor injuries · Data collection · Final report · May 11, 2014 · N15230 · Substantial damage
  > The pilot's improper flap retraction during a short field takeoff, which resulted in the aircraft experiencing an aerodynamic stall and impact with trees.
- [NTSB CEN14CA238](https://openairdocs.org/ntsb/CEN14CA238.md): American Legend AL-3 · Osage, AR · Accident · No injuries · Data collection · Final report · May 10, 2014 · N907DC · Substantial damage
  > The pilot's repeated attempts to take off from an unimproved field with tall grass.
- [NTSB DCA14WA114](https://openairdocs.org/ntsb/DCA14WA114.md): Boeing 737-400 · Panama City, Panama · Incident · No injuries · Foreign investigation · May 9, 2014 · YV-2946 · Minor damage
  > The Civil Aeronautical Authority of Panama (AAC) has notified the NTSB of an incident involving a Boeing 737-400 that occurred on May 9, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAC investigation under the provisions of ICAO…
- [NTSB ENG14WA012](https://openairdocs.org/ntsb/ENG14WA012.md): Airbus A330 - 223 · Melbourne, Australia, Australia · Incident · No injuries · Foreign investigation · May 6, 2014 · VN-A371 · Minor damage
  > On May 6, 2014, at 10:52 am local time, an Airbus A330-223 performed a rejected takeoff at the Melbourne Aerodrome, Melbourne, Victoria Australia, due to the failure of the No. 2 engine (right), a Pratt & Whitney PW4168 turbofan. No injuries were reported.…
- [NTSB WPR14CA184](https://openairdocs.org/ntsb/WPR14CA184.md): Cessna 180D · Murieta, CA · Accident · No injuries · Data collection · Final report · May 3, 2014 · N8603X · Substantial damage
  > The pilot's loss of directional control during takeoff. Contributing to the accident was the pilot's failure to abort the takeoff at the initial veer off.
- [NTSB WPR14LA179](https://openairdocs.org/ntsb/WPR14LA179.md): Coulter Hugh Clarke Pulsar XP Series I · Bremerton, WA · Accident · No injuries · Limited investigation · Final report · Apr 30, 2014 · N452PC · Substantial damage
  > Fatigue failure of the nose landing gear retention and pivot shaft, which resulted in the in-flight separation of the nose gear wheel and tire assembly.
- [NTSB WPR14CA178](https://openairdocs.org/ntsb/WPR14CA178.md): Elemdorf 1002 · Rexburg, ID · Accident · Minor injuries · Data collection · Final report · Apr 29, 2014 · C-FOWD · Substantial damage
  > The pilot's loss of directional control and early rotation during takeoff. Contributing to the accident was the failure of the pilots to exercise adequate communication techniques.
- [NTSB WPR14LA173](https://openairdocs.org/ntsb/WPR14LA173.md): Mcdonnell Douglas Helicopter 600N · Adelanto, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 2014 · N606BP · Substantial damage
  > The commercial pilot’s improper control inputs, which resulted in a loss of helicopter control during takeoff.
- [NTSB CEN14LA217](https://openairdocs.org/ntsb/CEN14LA217.md): Cessna 172R · Llano, TX · Accident · No injuries · Limited investigation · Final report · Apr 25, 2014 · N9373F · Substantial damage
  > The total loss of engine power for reasons that could not be determined because examination of the engine did not reveal any evidence of preimpact failures or malfunctions that would have precluded normal operation.
- [NTSB OPS14IA005](https://openairdocs.org/ntsb/OPS14IA005.md): Embraer EMB 145XR · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Apr 24, 2014 · N11176 · 2 aircraft · No damage
  > The local controller’s failure to comply with Federal Aviation Administration separation requirements for aircraft operating on intersecting runways.
- [NTSB ANC14CA023](https://openairdocs.org/ntsb/ANC14CA023.md): Piper PA 18A 150 · Kenai, AK · Accident · No injuries · Data collection · Final report · Apr 22, 2014 · N9299D · Substantial damage
  > The pilot's loss of directional control during takeoff, resulting in a collision with terrain and ground loop.
- [NTSB CEN14LA221](https://openairdocs.org/ntsb/CEN14LA221.md): American AA 1 · Peyton, CO · Accident · No injuries · Limited investigation · Final report · Apr 21, 2014 · N481HY · Destroyed
  > The loss of directional control during takeoff for reasons that could not be determined due to the extent of fire damage.
- [NTSB WPR14CA166](https://openairdocs.org/ntsb/WPR14CA166.md): Piper PA 18-135 · Kent, OR · Accident · Serious injuries · Data collection · Final report · Apr 12, 2014 · N1394Y · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff.
- [NTSB CEN14LA199](https://openairdocs.org/ntsb/CEN14LA199.md): Ercoupe 415 C · Cookson, OK · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 2014 · N2788H · Substantial damage
  > The pilot’s failure to properly secure the primer, which resulted in the loss of engine power during takeoff.
- [NTSB WPR14WA164](https://openairdocs.org/ntsb/WPR14WA164.md): Quest Kodiak · Jayapura, Papua, Indonesia, Indonesia · Accident · 2 fatal · Foreign investigation · Apr 9, 2014 · PK-SDF · Substantial damage
  > On April 9, 2014, at 0025 universal coordinated time, a Quest Aircraft Company, Kodiak-100, PK-SDF, during takeoff from Doyo Baru Airstrip, Jayapura, Papua, Indonesia, the airplane lost altitude and struck the airport fence and subsequently came to rest on a…
- [NTSB CEN14LA192](https://openairdocs.org/ntsb/CEN14LA192.md): Aerotrike Safari · Littlefield, TX · Accident · 1 fatal · Limited investigation · Final report · Apr 9, 2014 · N678TW · Substantial damage
  > The non-certificated pilot's in-flight loss of control for reasons that could not be determined from the available evidence.
- [NTSB CEN14FA193](https://openairdocs.org/ntsb/CEN14FA193.md): Airbus AS350 B3E · Albuquerque, NM · Accident · Minor injuries · Field investigation · Final report · Apr 9, 2014 · N395P · Substantial damage
  > The pilot's loss of yaw control during takeoff due to the absence of hydraulic boost to the tail rotor pedals for reasons that could not be determined based on the available information. A finding in the accident was the lack of a caution indicator to alert…
- [NTSB ERA14CA191](https://openairdocs.org/ntsb/ERA14CA191.md): Terry F King Zenith 701 · La Belle, FL · Accident · Minor injuries · Data collection · Final report · Apr 5, 2014 · N410KT · Substantial damage
  > The pilot's failure to maintain airspeed after a total loss of engine power at takeoff, which resulted in a hard landing. Also causal was the pilot/owner/builder's improper installation of the magnetos which resulted in the engine power loss.
- [NTSB CEN14CA187](https://openairdocs.org/ntsb/CEN14CA187.md): Cessna 172 · Larimore, ND · Accident · No injuries · Data collection · Final report · Apr 5, 2014 · N510ND · Substantial damage
  > Failure of the pilot to attain and maintain sufficient control inputs to compensate for the crosswind. Contributing to the accident was the flight instructor's failure to adequately monitor the pilot and the flight.

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

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

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