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

## Cases, newest first

- [NTSB ERA16LA254](https://openairdocs.org/ntsb/ERA16LA254.md): Buckeye Dream Machine · Hartford, KY · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 2016 · N3519T · Substantial damage
  > A partial loss of engine power for reasons that could not be determined and the pilot’s failure to maintain directional control during the aborted takeoff.
- [NTSB GAA16CA369](https://openairdocs.org/ntsb/GAA16CA369.md): Stinson 108 · Red Lodge, MT · Accident · No injuries · Data collection · Final report · Jul 8, 2016 · N955C · Substantial damage
  > A deer running across the runway and impacting the left side of the airplane, resulting in a loss of directional control, a runway excursion, and a ground loop.
- [NTSB CEN16FA261](https://openairdocs.org/ntsb/CEN16FA261.md): Piper PA 32R-300 · Houston, TX · Accident · 4 fatal · Field investigation · Final report · Jul 8, 2016 · N32KK · Destroyed
  > The pilot's failure to maintain adequate airspeed after becoming distracted by the open baggage door while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at…
- [NTSB CEN16LA250](https://openairdocs.org/ntsb/CEN16LA250.md): Bellanca 7ECA · Oak Ridge, LA · Accident · No injuries · Limited investigation · Final report · Jul 4, 2016 · N87083 · Substantial damage
  > The pilot's failure to maintain airplane control during the aborted takeoff, which resulted in it becoming airborne momentarily and then over running the runway.
- [NTSB GAA16CA356](https://openairdocs.org/ntsb/GAA16CA356.md): Cessna 182 · Llano, CA · Accident · Minor injuries · Data collection · Final report · Jul 3, 2016 · N1642T · Destroyed
  > The pilot's failure to attain an adequate airspeed and his intentional aerodynamic stall, which resulted in an impact with terrain and a post-impact fire.
- [NTSB CEN16LA255](https://openairdocs.org/ntsb/CEN16LA255.md): Piper PA 25-235 · Arlington, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 2016 · N6803Z · Substantial damage
  > The pilot’s failure to establish proper airspeed and angle-of-attack during takeoff with the airplane at its maximum gross weight in elevated density altitude and gusting tailwind conditions, which resulted in an aerodynamic stall.
- [NTSB CEN16LA244](https://openairdocs.org/ntsb/CEN16LA244.md): Pollack Quicksilver SPRINT2S · Bullard, TX · Accident · No injuries · Limited investigation · Final report · Jul 3, 2016 · N250AB · Substantial damage
  > A loss of airplane control during landing for reasons that could not be determined, because the airplane sank and was not recovered.
- [NTSB ERA16CA239](https://openairdocs.org/ntsb/ERA16CA239.md): Piper PA 22-160 · Harrisonburg, VA · Accident · Serious injuries · Data collection · Final report · Jul 2, 2016 · N8130D · Substantial damage
  > The pilot's loss of directional control during takeoff in gusting crosswind conditions.
- [NTSB ERA16CA237](https://openairdocs.org/ntsb/ERA16CA237.md): Piper PA 28-161 · Honesdale, PA · Accident · No injuries · Data collection · Final report · Jun 29, 2016 · N8237Z · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in his attempt to take off near the airplane’s maximum gross weight in high-density altitude conditions that degraded the airplane’s takeoff and climb performance and resulted in an aborted takeoff and…
- [NTSB CEN16WA262](https://openairdocs.org/ntsb/CEN16WA262.md): Liberty XL · La Lima, Honduras · Accident · 2 fatal · Foreign investigation · Jun 23, 2016 · HR-HZT · Destroyed
  > On June 23, 2016, about 2259 UTC, a Discovery Aviation, Incorporated, Liberty XL-2, Honduran registration HR-HZT, owned and operated by Horizontes Flight School was destroyed when it impacted the roof of a house in a residential neighborhood near La Lima,…
- [NTSB CEN16WA232](https://openairdocs.org/ntsb/CEN16WA232.md): Beech 65A90 · Hannover, Germany · Incident · No injuries · Foreign investigation · Jun 23, 2016 · OO-SAD · Minor damage
  > The Bundesstelle für Flugunfalluntersuchung (BFU) of Germany has notified the NTSB of an incident involving a Beech 65-A90-1 airplane, OO-SAD, that occurred on June 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the BFU…
- [NTSB ERA16LA224](https://openairdocs.org/ntsb/ERA16LA224.md): Cessna 172P · Honesdale, PA · Accident · No injuries · Limited investigation · Final report · Jun 20, 2016 · N54285 · Substantial damage
  > The pilot's failure to maintain adequate airspeed while departing in a heavily loaded airplane at high density altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, landing hard, and overrunning…
- [NTSB GAA16CA322](https://openairdocs.org/ntsb/GAA16CA322.md): Marks Steven Challenger · Marion, WI · Accident · Serious injuries · Data collection · Final report · Jun 18, 2016 · N7058U · Substantial damage
  > The failure of the airplane engine drive belt during the takeoff, resulting in a forced landing and impact with terrain.
- [NTSB GAA16CA328](https://openairdocs.org/ntsb/GAA16CA328.md): Airbus AS350 · McAllen, TX · Accident · No injuries · Data collection · Final report · Jun 17, 2016 · N4035W · Substantial damage
  > The pilot's inadvertent input of the right tail rotor pedal, which resulted in a loss of directional control and an impact with service equipment.
- [NTSB GAA16CA324](https://openairdocs.org/ntsb/GAA16CA324.md): Cessna 170 · Palmer, AK · Accident · No injuries · Data collection · Final report · Jun 17, 2016 · N1311D · Substantial damage
  > The pilot's failure to maintain a wings-level attitude during takeoff in gusty wind conditions, which resulted in the right wing striking the ground, a loss of lateral bank control, and a nose over during the subsequent landing.
- [NTSB GAA16CA504](https://openairdocs.org/ntsb/GAA16CA504.md): Cessna 152 · Immokalee, FL · Accident · No injuries · Data collection · Final report · Jun 16, 2016 · N4918H · Substantial damage
  > The student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.
- [NTSB GAA16CA385](https://openairdocs.org/ntsb/GAA16CA385.md): Rockwell International 114 · Munday, TX · Accident · No injuries · Data collection · Final report · Jun 13, 2016 · N5814N · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in an aborted takeoff, runway excursion, collision with a fence, and substantial damage.
- [NTSB GAA16CA319](https://openairdocs.org/ntsb/GAA16CA319.md): American AA 1 · Denton, MT · Accident · No injuries · Data collection · Final report · Jun 12, 2016 · N5720L · Substantial damage
  > The pilot's premature rotation and failure to attain sufficient airspeed required for a sustained climb, resulting in a runway overrun and collision with a fence.
- [NTSB GAA16CA313](https://openairdocs.org/ntsb/GAA16CA313.md): Air Tractor AT 802 · Cairo, IL · Accident · No injuries · Data collection · Final report · Jun 12, 2016 · N20361 · Substantial damage
  > The pilot's failure to ensure that the tailwheel pin was in the locked position prior to the takeoff roll, resulting in a runway excursion, ground loop, and substantial damage.
- [NTSB ERA16LA212](https://openairdocs.org/ntsb/ERA16LA212.md): Piper PA28RT · Taylorsville, KY · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 2016 · N42JA · Destroyed
  > The pilot's improper decision to continue a takeoff with a partial loss of engine power that occurred early in the takeoff roll. The reason for the partial loss of engine power could not be determined because postaccident fire damage to the engine precluded…
- [NTSB WPR16FA124](https://openairdocs.org/ntsb/WPR16FA124.md): Grumman American Avn. AA 1B · Hawthorne, CA · Accident · 2 fatal · Field investigation · Final report · Jun 11, 2016 · N4SU · Destroyed
  > The failure of both pilots to land the airplane on the remaining runway when a sufficient rate of climb could not be attained. Contributing to the accident was a reduction of available engine power due to severe camshaft lobe wear.
- [NTSB GAA16CA306](https://openairdocs.org/ntsb/GAA16CA306.md): S.O.C.A.T.A. Rallye 150 · York, SC · Accident · Minor injuries · Data collection · Final report · Jun 11, 2016 · N319RA · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in an impact with a peach tree(s).
- [NTSB CEN16LA228](https://openairdocs.org/ntsb/CEN16LA228.md): Cessna 172S · Deming, NM · Accident · Serious injuries · Limited investigation · Final report · Jun 10, 2016 · N21767 · Substantial damage
  > The pilots’ failure to maintain adequate control of the airplane during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude. Contributing to the accident was the…
- [NTSB GAA16CA293](https://openairdocs.org/ntsb/GAA16CA293.md): Bell 47G · Hastings, MN · Accident · No injuries · Data collection · Final report · Jun 8, 2016 · N25LB · Substantial damage
  > The pilot's failure to attain a positive rate of climb during takeoff from a service truck, which resulted in an impact with terrain and substantial damage to the tail boom and fuselage.
- [NTSB DCA16RA175](https://openairdocs.org/ntsb/DCA16RA175.md): Mcdonnell Douglas MD11 · Incheon, South Korea · Accident · Minor injuries · Foreign investigation · Jun 6, 2016 · N277UP · Substantial damage
  > import
- [NTSB GAA16CA284](https://openairdocs.org/ntsb/GAA16CA284.md): Bellanca 7GCBC · Ferndale, MT · Accident · No injuries · Data collection · Final report · Jun 5, 2016 · N8777 · Substantial damage
  > The pilot's loss of directional control during takeoff resulting in a decision to rotate early, and a collision with a hangar and subsequent fire.
- [NTSB GAA16CA279](https://openairdocs.org/ntsb/GAA16CA279.md): Robinson Helicopter R44 · Las Vegas, NV · Accident · No injuries · Data collection · Final report · Jun 2, 2016 · N441JL · Substantial damage
  > The pilot receiving instruction's incorrect action of interfering with the flight controls and failure to comply with the flight instructor's commands, which resulted in a loss of lateral bank control and a rollover.
- [NTSB GAA16CA271](https://openairdocs.org/ntsb/GAA16CA271.md): Cessna 182 · Elk River, ID · Accident · Minor injuries · Data collection · Final report · Jun 1, 2016 · N21242 · Substantial damage
  > The pilot exceeded the critical angle of attack during takeoff which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ENG16RA023](https://openairdocs.org/ntsb/ENG16RA023.md): Boeing 777 · Tokyo, Japan · Incident · No injuries · Foreign investigation · May 27, 2016 · HL7534 · Minor damage
  > On May 27, 2016 about 1238 Japan standard time, Korean Air flight 2708, a Boeing 777-300, HL7534, rejected the takeoff from Tokyo Haneda International Airport, Tokyo, Japan, after the left engine lost power and caught fire. The investigation is under the…
- [NTSB WPR16FA116](https://openairdocs.org/ntsb/WPR16FA116.md): Cessna 182 · Hanapepe, HI · Accident · 5 fatal · Field investigation · Final report · May 23, 2016 · N2007X · Destroyed
  > The pilot's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic…
- [NTSB WPR16FA115](https://openairdocs.org/ntsb/WPR16FA115.md): Czech Aircraft Works Spol Sro Sportcruiser · Santa Monica, CA · Accident · No injuries · Field investigation · Final report · May 22, 2016 · N1111X · Substantial damage
  > A partial loss of engine power during takeoff due to vapor lock. Contributing to the accident was the student pilot's failure to notice that the engine had exceeded multiple temperature limits and that the fuel flow had become erratic during an extended…
- [NTSB ERA16LA191](https://openairdocs.org/ntsb/ERA16LA191.md): Sikes Zenith CH750 Stol · Lawrenceburg, TN · Accident · Minor injuries · Limited investigation · Final report · May 22, 2016 · N925PS · Substantial damage
  > The pilot's failure to perform an adequate preflight inspection, which resulted in a loss of control due to an improperly-rigged rudder. Contributing to the accident was the pilot's failure to implement and follow proper flight-testing plans.
- [NTSB DCA16WA178](https://openairdocs.org/ntsb/DCA16WA178.md): Airbus A320 · Lisbon, Portugal · Incident · No injuries · Foreign investigation · May 21, 2016 · CS-TNP · Minor damage
  > Gabinete de Prerencao e Investigacao de Acidentes com Aeronaves (GPIAA) Portugal has notified the NTSB of an accident involving a AIRBUS A320 airplane that occurred on May 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB GAA16CA252](https://openairdocs.org/ntsb/GAA16CA252.md): Piper PA 20 · Nikolai Creek, AK · Accident · No injuries · Data collection · Final report · May 19, 2016 · N5589H · Substantial damage
  > The pilot's selection of an unsuitable takeoff area resulting in an airplane nose over during the takeoff roll.
- [NTSB GAA16CA248](https://openairdocs.org/ntsb/GAA16CA248.md): Luscombe 8 · Blue Bell, PA · Accident · No injuries · Data collection · Final report · May 19, 2016 · N62925 · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll and the flight instructor's delayed remedial action, which resulted in runway excursion, and collision with a ditch.
- [NTSB ERA16LA192](https://openairdocs.org/ntsb/ERA16LA192.md): Piper PA 28-180 · Batavia, NY · Accident · No injuries · Limited investigation · Final report · May 19, 2016 · N7781W · Substantial damage
  > The student pilot's failure to maintain directional control during takeoff, which resulted in a collision with runway signs.
- [NTSB ERA16FA185](https://openairdocs.org/ntsb/ERA16FA185.md): Beech A36TC · Tupelo, MS · Accident · 4 fatal · Field investigation · Final report · May 16, 2016 · N60RW · Destroyed
  > A preexisting stress rupture that initiated at a spot weld in the turbocharger v-band exhaust clamp, which resulted in the failure of the clamp and separation of the exhaust tailpipe, an in-flight fire, and subsequent impact with terrain.
- [NTSB GAA16CA240](https://openairdocs.org/ntsb/GAA16CA240.md): Mills Gregory T AIR Commander LRT · Tybee Island, GA · Accident · No injuries · Data collection · Final report · May 14, 2016 · N962GT · Substantial damage
  > The pilot's decision to perform a touch-and-go on unsuitable terrain, which resulted in a loss of directional control and a rollover.
- [NTSB GAA16CA243](https://openairdocs.org/ntsb/GAA16CA243.md): Piper PA-28 · Crystal River, FL · Accident · No injuries · Data collection · Final report · May 13, 2016 · N991A · Substantial damage
  > The student pilot's failure to maintain directional control during the takeoff, which resulted in runway excursion and collision with a ditch. Contributing to the accident was the improper flap retraction procedure employed by the pilot during takeoff.
- [NTSB CEN16LA200](https://openairdocs.org/ntsb/CEN16LA200.md): Mooney M20 · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · May 13, 2016 · N6371Q · Substantial damage
  > A loss of engine power due to water contamination of the fuel.
- [NTSB CEN16LA185](https://openairdocs.org/ntsb/CEN16LA185.md): Jewett Brandon RV 6 · McKinney, TX · Accident · No injuries · Limited investigation · Final report · May 13, 2016 · N700MJ · Substantial damage
  > The pilot’s loss of directional control during takeoff.
- [NTSB CEN16LA182](https://openairdocs.org/ntsb/CEN16LA182.md): Bell 47G 3B 1 · Portia, AR · Accident · 1 fatal · Limited investigation · Final report · May 13, 2016 · N48316 · Substantial damage
  > The pilot's decision to perform a sliding takeoff from the elevated platform, which resulted in a dynamic rollover when the right skid plate caught on a protruding screw. Contributing to the accident was the pilot's failure to adequately inspect the landing…
- [NTSB WPR16LA105](https://openairdocs.org/ntsb/WPR16LA105.md): Beech B24R · Groveland, CA · Accident · Minor injuries · Limited investigation · Final report · May 10, 2016 · N2052L · Substantial damage
  > The pilot's decision to conduct an upslope, downwind takeoff combined with an improper flap setting, which resulted in the airplane's inability to clear trees beyond the runway end. The reason for the improper flap setting could not be determined.
- [NTSB CEN16LA178](https://openairdocs.org/ntsb/CEN16LA178.md): Mooney M20K · Akron, OH · Accident · No injuries · Limited investigation · Final report · May 10, 2016 · N57535 · Substantial damage
  > A missing bolt in the nose landing gear assembly, which resulted in the airplane suddenly turning left and the pilot's inability to maintain directional control during a crosswind takeoff.
- [NTSB GAA16CA227](https://openairdocs.org/ntsb/GAA16CA227.md): American Champion 8GCBC · Plainview, TX · Accident · Minor injuries · Data collection · Final report · May 9, 2016 · N326JH · Substantial damage
  > The pilot's failure to maintain directional control during gusty wind conditions. Contributing to the outcome was the pilot's exceedance of the maximum crosswind component during takeoff.
- [NTSB WPR16LA104](https://openairdocs.org/ntsb/WPR16LA104.md): Bell UH 1B · Maxwell, CA · Accident · No injuries · Limited investigation · Final report · May 7, 2016 · N486SA · Substantial damage
  > A reduction in available engine power during takeoff due to a stuck hot air valve, which resulted in low rotor rpm and a forced landing. Contributing to the accident was the lack of dry film lubricant and the presence of corrosion on the hot air valve…
- [NTSB GAA16CA229](https://openairdocs.org/ntsb/GAA16CA229.md): Waco Classic YMF · Pace, FL · Accident · No injuries · Data collection · Final report · May 7, 2016 · N119SW · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll, and his excessive pitch attitude at low airspeed during initial climb, resulting in an aerodynamic stall and consequent ground impact.
- [NTSB GAA16CA228](https://openairdocs.org/ntsb/GAA16CA228.md): Beech C23 · Yucca Valley, CA · Accident · No injuries · Data collection · Final report · May 7, 2016 · N6566R · Substantial damage
  > The pilot's failure to attain airspeed and a positive rate of climb during takeoff in gusty wind conditions, resulting in a loss of directional control, an uncontrolled descent and collision with terrain.
- [NTSB GAA16CA220](https://openairdocs.org/ntsb/GAA16CA220.md): Cessna 172 · Richmond, KY · Accident · No injuries · Data collection · Final report · May 6, 2016 · N89847 · Substantial damage
  > The student pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with tree(s).
- [NTSB DCA16WA160](https://openairdocs.org/ntsb/DCA16WA160.md): Boeing 737 · Guangzhou, China · Incident · No injuries · Foreign investigation · Apr 27, 2016 · B-2117 · Minor damage
  > The Civil Aviation Administration of China (CAAC) has notified the NTSB of an accident involving a Boeing 737 that occurred on April 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CAAC's investigation under the provisions of…

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

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

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