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

## Cases, newest first

- [NTSB DCA18WA315](https://openairdocs.org/ntsb/DCA18WA315.md): Airbus A320 · Tallinn, Estonia · Accident · No injuries · Foreign investigation · Feb 28, 2018 · ES-SAN · Substantial damage
  > The Estonian Safety Investigation Bureau (AIB) has notified the NTSB of an accident involving a Airbus 320, which occurred on February 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of…
- [NTSB GAA18CA154](https://openairdocs.org/ntsb/GAA18CA154.md): Cessna 207 · Newtok, AK · Accident · No injuries · Data collection · Final report · Feb 25, 2018 · N1658U · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff. Contributing to the accident was the pilot’s failure to properly check that the flight controls were correctly configured before takeoff.
- [NTSB GAA18CA142](https://openairdocs.org/ntsb/GAA18CA142.md): Costruzioni Aeronautiche Tecna Astore · Apopka, FL · Accident · No injuries · Data collection · Final report · Feb 25, 2018 · N194CT · Substantial damage
  > The student pilot’s failure to maintain directional control during takeoff.
- [NTSB ANC18WA035](https://openairdocs.org/ntsb/ANC18WA035.md): Beech B100 · Abbotsford, Canada · Accident · Serious injuries · Foreign investigation · Feb 23, 2018 · C-GIAE · Substantial damage
  > On February 23, 2018, about 1204 Pacific standard time, a twin engine, turbine-powered Beech King Air B100 airplane, Canadian registration C-GIAE, crashed shortly after takeoff from the Abbotsford International Airport, Abbotsford, British Columbia, Canada.…
- [NTSB GAA18CA129](https://openairdocs.org/ntsb/GAA18CA129.md): Robinson Helicopter R22 · Wadsworth, TX · Accident · Minor injuries · Data collection · Final report · Feb 13, 2018 · N843SH · Substantial damage
  > The passenger’s gun becoming lodged in the flight controls during takeoff and his failure to remove it, which resulted in impact with terrain.
- [NTSB CEN18WA096](https://openairdocs.org/ntsb/CEN18WA096.md): Piper PA-28-161 · Helle, Norway · Accident · 2 fatal · Foreign investigation · Feb 11, 2018 · LN-TOS · Destroyed
  > On February 11, 2018, about 2000 UTC, a Piper Aircraft, Inc. PA-28-161 airplane, Norwegian registration LN-TOS, impacted the waters near the Svolvaer Airport (ENSH), Helle, Norway. The pilot and passenger on board were fatally injured and the airplane was…
- [NTSB GAA18CA128](https://openairdocs.org/ntsb/GAA18CA128.md): Cessna 140 · Keller, TX · Accident · No injuries · Data collection · Final report · Feb 9, 2018 · N2829N · Substantial damage
  > The pilot's inability to gain altitude normally in order to avoid a flock of ducks flying overhead during takeoff, which resulted in the airplane striking a fence.
- [NTSB GAA18CA125](https://openairdocs.org/ntsb/GAA18CA125.md): Baker Victor R Kitfox · Carson City, NV · Accident · Serious injuries · Data collection · Final report · Feb 9, 2018 · N377KJ · Substantial damage
  > The pilot-receiving-instruction’s failure to maintain directional control during takeoff.
- [NTSB ENG18WA013](https://openairdocs.org/ntsb/ENG18WA013.md): Boeing 737-800 · Paris, France · Incident · No injuries · Foreign investigation · Feb 8, 2018 · F-GZHO · No damage
  > The Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) of France has notified the NTSB of an accident involving a Boeing 737-800, which occurred on February 8, 2018. The NTSB has appointed a U.S. Accredited Representative to assist…
- [NTSB CEN18LA092](https://openairdocs.org/ntsb/CEN18LA092.md): Cessna 172M · Centralia, IL · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 8, 2018 · N1409U · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall/spin.
- [NTSB DCA18WA134](https://openairdocs.org/ntsb/DCA18WA134.md): Boeing 717 · Melbourne, Australia · Incident · No injuries · Foreign investigation · Feb 5, 2018 · unknown · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 717 airplane that occurred on February 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…
- [NTSB CEN18WA090](https://openairdocs.org/ntsb/CEN18WA090.md): Sikorsky S61 · Marchwood, New Hampshire, United Kingdom · Accident · No injuries · Foreign investigation · Feb 1, 2018 · G-ATBJ · Substantial damage
  > On February 1, 2018, a Sikorsky S-61N helicopter (G-ATBJ, s/n 6126930-439), pitched down and stuck the ground while hovering after takeoff near Marchwood, Hampshire in the United Kingdom. There was two persons on board, who were not injured. This…
- [NTSB GAA18CA114](https://openairdocs.org/ntsb/GAA18CA114.md): Wayne Miller Sport Copter II · Van Nuys, CA · Accident · No injuries · Data collection · Final report · Jan 29, 2018 · N767LW · Substantial damage
  > The pilot’s decision to takeoff in gusting wind conditions with insufficient rotor rpm.
- [NTSB ERA18LA073](https://openairdocs.org/ntsb/ERA18LA073.md): Aero Commander 680 F · Lapine, AL · Accident · No injuries · Limited investigation · Final report · Jan 27, 2018 · N900L · Substantial damage
  > The pilot's failure to maintain directional control during takeoff after a total loss of left engine power due to fuel contamination, which resulted in impact with trees. Contributing to the accident were the mechanic's failure to properly flush the fuel…
- [NTSB ERA18LA070](https://openairdocs.org/ntsb/ERA18LA070.md): Piper PA32R · Marathon, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 25, 2018 · N47863 · Substantial damage
  > The pilot's failure to maintain directional control during takeoff.
- [NTSB ANC18LA021](https://openairdocs.org/ntsb/ANC18LA021.md): Foxfly Foxdominator · Indiantown, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 25, 2018 · N412MF · Substantial damage
  > The pilot’s improper decision to attempt to take off in the gyroplane in strong gusting crosswind conditions, with insufficient distance to safely abort, which resulted in a loss of control and impact with a ditch and road embankment.
- [NTSB ERA18LA082](https://openairdocs.org/ntsb/ERA18LA082.md): Mosquito XEL · Loxahatchee, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 21, 2018 · UNREG · Destroyed
  > The noncertificated pilot's failure to maintain helicopter control during takeoff. Contributing to the accident were the pilot's lack of recent flight experience and his lack of training and experience in the accident helicopter make and model.
- [NTSB GAA18CA104](https://openairdocs.org/ntsb/GAA18CA104.md): Geldermann Bert E Lancair Legacy · Friday Harbor, WA · Accident · Minor injuries · Data collection · Final report · Jan 15, 2018 · N145JG · Substantial damage
  > The pilot’s inability to maintain the landing flare, which resulted in the airplane landing hard short of the runway. Contributing to the accident was the cockpit canopy opening in flight.
- [NTSB GAA18CA106](https://openairdocs.org/ntsb/GAA18CA106.md): Cessna A185 · Lowman, ID · Accident · No injuries · Data collection · Final report · Jan 12, 2018 · N2W · Substantial damage
  > The pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of directional control.
- [NTSB CEN18LA070](https://openairdocs.org/ntsb/CEN18LA070.md): Cessna 170 · Ponca City, OK · Accident · No injuries · Limited investigation · Final report · Jan 6, 2018 · N9972A · Substantial damage
  > The pilot's loss of directional control during takeoff with a quartering tailwind, which resulted in a runway excursion.
- [NTSB ERA18WA061](https://openairdocs.org/ntsb/ERA18WA061.md): Cessna A188 · Dom Pedrito, Brazil · Accident · 1 fatal · Foreign investigation · Dec 30, 2017 · PR-MLY · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB CEN18LA052](https://openairdocs.org/ntsb/CEN18LA052.md): Piper PA 28R-200 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · Dec 25, 2017 · N550D · Substantial damage
  > The pilot's loss of directional control during the rejected takeoff. Contributing to the accident were the pilot's lack of familiarity with the airport runway configuration, which led to his premature attempt to take off, and the airplane’s inoperative…
- [NTSB ERA18WA057](https://openairdocs.org/ntsb/ERA18WA057.md): Cessna 172 · Providenciales, Turks & Caicos Islands · Accident · 2 fatal · Foreign investigation · Dec 24, 2017 · PR-RTS · Destroyed
  > The government of the United Kingdom has notified the NTSB of an accident involving a Cessna 172S airplane that occurred on December 24, 2017, in Turks and Caicos Islands. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accidents…
- [NTSB CEN18FA061](https://openairdocs.org/ntsb/CEN18FA061.md): Cessna 340 · Bartow, FL · Accident · 5 fatal · Field investigation · Final report · Dec 24, 2017 · N247AT · Destroyed
  > The pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.
- [NTSB WPR18FA053](https://openairdocs.org/ntsb/WPR18FA053.md): Browning Gregory S Zodiac 601XL · Thompson's Station, TN · Accident · 1 fatal · Field investigation · Final report · Dec 21, 2017 · N929GB · Substantial damage
  > The sport pilot's decision to depart in and continue flight in instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB ERA18LA054](https://openairdocs.org/ntsb/ERA18LA054.md): Cessna 177 · Ridgeland, SC · Accident · Minor injuries · Limited investigation · Final report · Dec 19, 2017 · N3179T · Substantial damage
  > The student pilot’s improper control inputs, which resulted in a loss of control on takeoff. Contributing to the accident was the flight instructor’s inadequate remedial action.
- [NTSB ENG18WA024](https://openairdocs.org/ntsb/ENG18WA024.md): Antonov TVS-2MS · Naryan-Mar, Russia · Accident · No injuries · Foreign investigation · Dec 19, 2017 · RA-01460 · Destroyed
  > A TVS-2MS airplane powered by a Honeywell TPE331-12UHR-702H and equipped with skids impacted unpaved runway after an aborted takeoff. The airplane was completed destroyed. The Russian Interstate Aviation Committee (MAK) is investigating.
- [NTSB CEN18LA065](https://openairdocs.org/ntsb/CEN18LA065.md): Piper PA-28-201T · Versailles, MO · Accident · No injuries · Limited investigation · Final report · Dec 19, 2017 · N555WM · Substantial damage
  > The total loss of engine power due to fuel starvation when the cap fitting came off the inlet tee fitting on the throttle body/fuel metering unit.
- [NTSB GAA18CA105](https://openairdocs.org/ntsb/GAA18CA105.md): Golden Circle Air T Bird II · Wiscassett, ME · Accident · No injuries · Data collection · Final report · Dec 17, 2017 · N5619Z · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll.
- [NTSB ERA18LA048](https://openairdocs.org/ntsb/ERA18LA048.md): Cessna 150 · Castalia, NC · Accident · 1 fatal · Limited investigation · Final report · Dec 16, 2017 · N7929Z · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while performing a turning takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's decision to attempt the takeoff, which he believed…
- [NTSB ENG18WA016](https://openairdocs.org/ntsb/ENG18WA016.md): Aerospatiale ATR 42-320 · Fond-du-Lac, Canada · Accident · No injuries · Foreign investigation · Dec 14, 2017 · C-GWEA · Destroyed
  > The Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving an Aerospatiale ATR 42-320, which occurred on December 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…
- [NTSB GAA18CA089](https://openairdocs.org/ntsb/GAA18CA089.md): Robinson Helicopter R44 · Newark, OH · Accident · Minor injuries · Data collection · Final report · Dec 13, 2017 · N441ML · Substantial damage
  > The pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in dynamic rollover.
- [NTSB GAA18CA083](https://openairdocs.org/ntsb/GAA18CA083.md): Michael Adamczyk Zenith CH750 · Franklin, PA · Accident · No injuries · Data collection · Final report · Dec 9, 2017 · N750AD · Substantial damage
  > The pilot’s excessive application of aft stick during takeoff, which resulted in an aerodynamic stall. Contributing to this accident was the pilot’s inexperience in the airplane.
- [NTSB GAA18CA077](https://openairdocs.org/ntsb/GAA18CA077.md): Czech Sport Aircraft a.s. Sport Cruiser · Sacramento, CA · Accident · No injuries · Data collection · Final report · Dec 9, 2017 · N227US · Destroyed
  > The pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.
- [NTSB GAA18CA078](https://openairdocs.org/ntsb/GAA18CA078.md): Cessna 172 · Everett, WA · Accident · No injuries · Data collection · Final report · Dec 8, 2017 · N4801D · Substantial damage
  > The pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.
- [NTSB GAA18CA079](https://openairdocs.org/ntsb/GAA18CA079.md): Boeing A75N1(PT17) · Chino, CA · Accident · No injuries · Data collection · Final report · Dec 3, 2017 · N1431C · Substantial damage
  > The pilot’s failure to maintain directional control during a touch-and-go landing.
- [NTSB GAA18CA067](https://openairdocs.org/ntsb/GAA18CA067.md): Todd Foley Zenith 701 · Mount Airy, NC · Accident · No injuries · Data collection · Final report · Dec 1, 2017 · N701TF · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.
- [NTSB GAA18CA076](https://openairdocs.org/ntsb/GAA18CA076.md): Cessna 152 · Fullerton, CA · Accident · No injuries · Data collection · Final report · Nov 30, 2017 · N417CB · Substantial damage
  > The student pilot’s failure to maintain directional control during takeoff.
- [NTSB GAA18CA059](https://openairdocs.org/ntsb/GAA18CA059.md): Mooney M20 · Tucson, AZ · Accident · No injuries · Data collection · Final report · Nov 26, 2017 · N6002Q · Substantial damage
  > The pilot’s inadequate preflight and in-flight fuel management, which resulted in an intermittent loss of engine power due to fuel starvation.
- [NTSB WPR18LA036](https://openairdocs.org/ntsb/WPR18LA036.md): Doshier Wilbert A GT-500 · Willows, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 25, 2017 · N599RA · Substantial damage
  > A loss of engine power during takeoff due a coolant leak and the subsequent overheating of the engine, and the student pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall…
- [NTSB ERA18LA031](https://openairdocs.org/ntsb/ERA18LA031.md): Piper PA46 · Clearwater, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 2017 · N863RB · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN18LA041](https://openairdocs.org/ntsb/CEN18LA041.md): Cessna 182S · Bolingbrook, IL · Accident · No injuries · Limited investigation · Final report · Nov 22, 2017 · N7111W · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff.
- [NTSB CEN18LA039](https://openairdocs.org/ntsb/CEN18LA039.md): Piper PA 12 · Dickinson, ND · Accident · Serious injuries · Limited investigation · Final report · Nov 22, 2017 · N4040M · Substantial damage
  > The pilot’s failure to attain adequate airspeed during the short field takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.
- [NTSB ERA18LA038](https://openairdocs.org/ntsb/ERA18LA038.md): Beech B 55 · Statesville, NC · Accident · No injuries · Class 3 · Limited · Final report · Nov 17, 2017 · N592SS · Substantial damage
  > A total loss of left engine power during initial climb. Contributing to the accident was the pilot's failure to maintain control of the airplane following the loss of engine power.
- [NTSB DCA18WA025](https://openairdocs.org/ntsb/DCA18WA025.md): Boeing 737 · Singapore, Singapore · Incident · No injuries · Foreign investigation · Nov 16, 2017 · VP-CAM · Minor damage
  > The TSIB of Singapore has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSIB's investigation under the provisions of ICAO Annex 13 as…
- [NTSB WPR18LA031](https://openairdocs.org/ntsb/WPR18LA031.md): Robinson Helicopter R44 · Page, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 2017 · N744BS · Substantial damage
  > The pilot's failure to maintain pitch control of the helicopter while transitioning from a hover to forward flight.
- [NTSB DCA18WA030](https://openairdocs.org/ntsb/DCA18WA030.md): Boeing 747 · Maastricht, Netherlands · Incident · No injuries · Foreign investigation · Nov 11, 2017 · TC-ACR · No damage
  > The Dutch Safety Board has notified the NTSB of an incident involving a Boeing 747, which occurred on November 11, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of Manufacture and…
- [NTSB ERA18WA025](https://openairdocs.org/ntsb/ERA18WA025.md): Quest Kodiac 100 · Goias, Brazil · Accident · Serious injuries · Foreign investigation · Nov 10, 2017 · N154KQ · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a QUEST AIRCRAFT COMPANY LLC KODIAC 100 airplane that occurred on November 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's…
- [NTSB GAA18CA047](https://openairdocs.org/ntsb/GAA18CA047.md): Cessna 140 · Macon, GA · Accident · No injuries · Data collection · Final report · Nov 8, 2017 · N76238 · Substantial damage
  > The pilot's incorrect pitch control during takeoff, which resulted in a nose-over.
- [NTSB ERA18LA023](https://openairdocs.org/ntsb/ERA18LA023.md): Great Lakes 2T1A · Montague, MA · Accident · No injuries · Limited investigation · Final report · Nov 2, 2017 · N3512L · Substantial damage
  > The pilot’s failure to maintain directional control during the attempted takeoff, which resulted in a runway excursion.

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

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

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