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

## Cases, newest first

- [NTSB ANC20CA012](https://openairdocs.org/ntsb/ANC20CA012.md): Cirrus SR22 · Kapolei, HI · Accident · Minor injuries · Class 4 · Data collection · Final report · Jan 7, 2020 · N779LB · Substantial damage
  > The student pilot's loss of airplane control during a short field takeoff in gusting crosswind conditions, and the designated pilot examiner's delayed remedial action.
- [NTSB CEN20FA049](https://openairdocs.org/ntsb/CEN20FA049.md): Mooney M20S · Olathe, KS · Accident · 2 fatal · Class 3 · Field · Final report · Dec 31, 2019 · N602TF · Destroyed
  > The pilot’s failure to set the elevator trim properly for takeoff, which resulted in an exceedance of the airplane’s critical angle of attack during climb out, an aerodynamic stall, and the subsequent impact with terrain.
- [NTSB CEN20CA052](https://openairdocs.org/ntsb/CEN20CA052.md): Piper PA28R · Onaga, KS · Accident · No injuries · Data collection · Final report · Dec 31, 2019 · N3849T · Substantial damage
  > The pilot's improper decision to take off with the airplane at a high gross weight from a short, turf runway, which degraded its climb performance and led to a delayed aborted takeoff, a runway excursion, and impact with terrain.
- [NTSB WPR20CA053](https://openairdocs.org/ntsb/WPR20CA053.md): Cessna 170 · Missoula, MT · Accident · No injuries · Data collection · Final report · Dec 28, 2019 · N4476B · Substantial damage
  > The pilot receiving instruction's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and ground-loop, and the flight instructor’s failure to adequately monitor the pilot.
- [NTSB ERA20CA110](https://openairdocs.org/ntsb/ERA20CA110.md): Piper PA28 · Cortland, NY · Accident · Minor injuries · Data collection · Final report · Dec 24, 2019 · N7450R · Substantial damage
  > The student pilot's failure to maintain the runway heading during takeoff, which resulted in impact with a snowbank and a subsequent nose-over.
- [NTSB CEN20LA042](https://openairdocs.org/ntsb/CEN20LA042.md): Cessna 172 · Rush City, MN · Accident · No injuries · Class 3 · Limited · Final report · Dec 21, 2019 · N9646Q · Substantial damage
  > The total loss of engine power due to fuel starvation because the student pilot failed to reposition the fuel mixture control to full rich before takeoff.
- [NTSB CEN20CA039](https://openairdocs.org/ntsb/CEN20CA039.md): Flight Design Ctsw · Delaware, OH · Accident · Minor injuries · Data collection · Final report · Dec 20, 2019 · N91WW · Substantial damage
  > The student pilot’s failure to maintain yaw control during takeoff, which resulted in an aborted takeoff and subsequent landing on grassy terrain, during which the airplane bounced and then nosed over.
- [NTSB CEN20LA037](https://openairdocs.org/ntsb/CEN20LA037.md): Robinson R22 · Beeville, TX · Accident · No injuries · Class 3 · Limited · Final report · Dec 19, 2019 · N695AP · Substantial damage
  > The solo student pilot's improper cyclic input during takeoff, which resulted in dynamic rollover.
- [NTSB WPR20CA050](https://openairdocs.org/ntsb/WPR20CA050.md): Head AX8 88B · Las Cruces, NM · Accident · Minor injuries · Data collection · Final report · Dec 14, 2019 · N2224H · Substantial damage
  > A burner flameout, which resulted in the pilot's inability to arrest the balloon’s descent and its subsequent impact with power lines as he was trying to relight the burner.
- [NTSB ANC20CA037](https://openairdocs.org/ntsb/ANC20CA037.md): Cessna 207 · Kwigillingok, AK · Accident · No injuries · Data collection · Final report · Dec 10, 2019 · N9728M · Substantial damage
  > The pilot's improper decision to depart from an ice-covered runway with a strong crosswind, which resulted in a loss of directional control, runway excursion, and impact with a ditch.
- [NTSB CEN20TA031](https://openairdocs.org/ntsb/CEN20TA031.md): Beech 36 · Spring Branch, TX · Accident · No injuries · Class 3 · Final report · Dec 6, 2019 · N408P · Substantial damage
  > The pilot's inadequate preflight performance planning and his operation of the airplane outside of the manufacturer's specified weight and balance limitations, which resulted in a failure of the airplane to become airborne, an aborted takeoff, and subsequent…
- [NTSB CEN20LA029](https://openairdocs.org/ntsb/CEN20LA029.md): Luscombe 8A · Baldwin City, KS · Accident · No injuries · Class 3 · Limited · Final report · Dec 4, 2019 · N45606 · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, and the flight instructor's delayed remedial action, which resulted in a runway excursion and nose over.
- [NTSB WPR20WA251](https://openairdocs.org/ntsb/WPR20WA251.md): De Havilland DHC8 · Eaton, Australia · Incident · No injuries · Foreign investigation · Dec 3, 2019 · VH-ZZA · Minor damage
  > The government of Australia has notified the NTSB of an accident involving a De Havilland DHC8 airplane that occurred on December 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…
- [NTSB ERA20FA043](https://openairdocs.org/ntsb/ERA20FA043.md): Bushby Bushby Mustang M II · Milton, FL · Accident · 1 fatal · Class 3 · Field · Final report · Nov 24, 2019 · N24GL · Substantial damage
  > The pilot’s failure to maintain control of the airplane on takeoff, which resulted in an aerodynamic stall.
- [NTSB DCA20WA019](https://openairdocs.org/ntsb/DCA20WA019.md): Dornier 228 · Gomo, Congo - Kinshasa · Accident · 29 fatal · Foreign investigation · Nov 24, 2019 · 9S-GNH · Destroyed
  > The government of Congo has notified the NTSB of an accident involving a DORNIER 228 airplane that occurred on November 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…
- [NTSB WPR20LA033](https://openairdocs.org/ntsb/WPR20LA033.md): Beech 35 · Caldwell, ID · Accident · No injuries · Class 3 · Limited · Final report · Nov 23, 2019 · N7956M · Substantial damage
  > The total loss of engine power due to the separation of the wastegate exhaust elbow.
- [NTSB WPR20LA024](https://openairdocs.org/ntsb/WPR20LA024.md): Piper PA28R · Ogden, UT · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 17, 2019 · N3206R · Substantial damage
  > The flight instructor’s failure to raise the landing gear using the alternate system, which resulted in a reduced climb rate and impact with an obstacle. Contributing to the accident was the flight instructor’s lack of understanding of the backup landing gear…
- [NTSB GAA20CA087](https://openairdocs.org/ntsb/GAA20CA087.md): Fisher FP 202 Koala · Erwin, NC · Accident · No injuries · Data collection · Final report · Nov 14, 2019 · N47CV · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with vegetation.
- [NTSB DCA20WA022](https://openairdocs.org/ntsb/DCA20WA022.md): Boeing 737 · Lyon, France · Incident · No injuries · Foreign investigation · Nov 14, 2019 · 7T-VKR · No damage
  > The government of France has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on November 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…
- [NTSB GAA20CA064](https://openairdocs.org/ntsb/GAA20CA064.md): New Glasair Sportsman GS-2 · Huntsville, AR · Accident · Minor injuries · Data collection · Final report · Nov 9, 2019 · N24EP · Substantial damage
  > The pilot's failure to maintain proper pitch control during takeoff from a muddy, turf runway and his exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.
- [NTSB ERA20LA035](https://openairdocs.org/ntsb/ERA20LA035.md): Beech 55 · Griffin, GA · Accident · No injuries · Class 3 · Limited · Final report · Nov 9, 2019 · N686DR · Substantial damage
  > The pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.
- [NTSB GAA20CA069](https://openairdocs.org/ntsb/GAA20CA069.md): Cessna 180 · Tyler, TX · Accident · No injuries · Data collection · Final report · Nov 8, 2019 · N9925N · Substantial damage
  > The pilot's improper wind correction while taking off with a tailwind, which resulted in a runway excursion and subsequent nose-over.
- [NTSB GAA20CA053](https://openairdocs.org/ntsb/GAA20CA053.md): Zenair CH701 · Salem, OR · Accident · No injuries · Data collection · Final report · Nov 1, 2019 · N102PH · Substantial damage
  > The pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to make his first flight in an airplane he unfamiliar with before waiting for calm winds.
- [NTSB GAA20CA048](https://openairdocs.org/ntsb/GAA20CA048.md): Beech A36 · Le Roy, NY · Accident · Minor injuries · Data collection · Final report · Oct 27, 2019 · N9008V · Substantial damage
  > The pilot's improper pitch control during takeoff in high, gusting wind conditions, which resulted in a runway overrun and the nose landing gear collapsing.
- [NTSB CEN20LA015](https://openairdocs.org/ntsb/CEN20LA015.md): Piper PA22 · White Bear Township, MN · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 27, 2019 · N2621P · Destroyed
  > The pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.
- [NTSB GAA20CA050](https://openairdocs.org/ntsb/GAA20CA050.md): Piper PA 30 · Opa Locka, FL · Accident · No injuries · Data collection · Final report · Oct 25, 2019 · N8816Y · Substantial damage
  > The pilot receiving instruction's failure to relinquish the flight controls to the flight instructor during a simulated engine failure during takeoff, which resulted in the airplane touching down in a left banking attitude and the landing gear collapsing.
- [NTSB GAA20CA044](https://openairdocs.org/ntsb/GAA20CA044.md): Richard B Carpenter AR-1 · Brooksville, FL · Accident · No injuries · Data collection · Final report · Oct 21, 2019 · N147AR · Substantial damage
  > The pilot's failure to attain the proper rotor speed before takeoff, which resulted in the rotor blade striking the rudder. Contributing to the accident was the pilot's failure to abort the takeoff in a timely manner.
- [NTSB WPR20FA008](https://openairdocs.org/ntsb/WPR20FA008.md): Piper PA 24 · Angel Fire, NM · Accident · 2 fatal · Class 3 · Field · Final report · Oct 20, 2019 · N7742P · Substantial damage
  > The airplane’s degraded performance due to high-density altitude and gusting wind conditions, which resulted in its inability to maintain altitude during the initial takeoff climb. Contributing to the accident was the pilot’s lack of experience with high…
- [NTSB ENG20RA002](https://openairdocs.org/ntsb/ENG20RA002.md): Boeing 777 · Bangkok, Thailand · Incident · No injuries · Foreign investigation · Oct 20, 2019 · HS-TKL · Minor damage
  > On October 20, 2019, a Thai Airways International Boeing 777-300ER, powered by two General Electric GE90-115B turbofan engines, aborted takeoff after experiencing a No. 1 engine high pressure turbine uncontainment failure during takeoff roll. The incident is…
- [NTSB GAA20CA036](https://openairdocs.org/ntsb/GAA20CA036.md): Titan Titan Tornado II · Marble Canyon, AZ · Accident · No injuries · Data collection · Final report · Oct 18, 2019 · N49PD · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and impact with sand hummocks.
- [NTSB GAA20CA032](https://openairdocs.org/ntsb/GAA20CA032.md): Flight Design Ctls · Monument Valley, UT · Accident · Minor injuries · Data collection · Final report · Oct 17, 2019 · N771TX · Substantial damage
  > The pilot's failure to maintain lateral control and to attain adequate altitude during takeoff with a quartering tailwind in gusting wind conditions, which resulted in impact with a sandy berm left of the runway.
- [NTSB WPR20WA011](https://openairdocs.org/ntsb/WPR20WA011.md): Diamond DA42 · Singapore, Singapore · Incident · No injuries · Class 5 · Foreign · Oct 15, 2019 · N181CW · Minor damage
- [NTSB GAA20CA014](https://openairdocs.org/ntsb/GAA20CA014.md): Piper PA38 · Colorado Springs, CO · Accident · No injuries · Data collection · Final report · Oct 15, 2019 · N9708T · Substantial damage
  > The pilot's failure to maintain the runway heading while taking off with a gusting tailwind, which resulted in impact with a fence.
- [NTSB GAA20CA015](https://openairdocs.org/ntsb/GAA20CA015.md): Taylorcraft BC12 · Goddard, KS · Accident · No injuries · Data collection · Final report · Oct 13, 2019 · N96709 · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB GAA20CA026](https://openairdocs.org/ntsb/GAA20CA026.md): Llewellyn, Warwinc W Vans RV-4 · Lusby, MD · Accident · Minor injuries · Data collection · Final report · Oct 12, 2019 · N15WL · Substantial damage
  > The pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain and a subsequent cartwheel.
- [NTSB CEN20TA007](https://openairdocs.org/ntsb/CEN20TA007.md): AutoGyro MTO Sport · Montgomery, TX · Accident · Serious injuries · Final report · Oct 12, 2019 · N498AG · Substantial damage
  > The pilot's failure to maintain clearance from trees during departure. Contributing to the accident was the pilot's inadequate preflight assessment of the field for takeoff.
- [NTSB GAA20CA027](https://openairdocs.org/ntsb/GAA20CA027.md): Zenith Zenith 601XLB · Gastonia, NC · Accident · Minor injuries · Data collection · Final report · Oct 11, 2019 · N235JH · Substantial damage
  > The pilot's failure to latch the canopy before departure, which resulted in the canopy opening and the subsequent loss of airplane control.
- [NTSB GAA20CA019](https://openairdocs.org/ntsb/GAA20CA019.md): Antares MA33 · Coeur d'Alene, ID · Accident · Serious injuries · Data collection · Final report · Oct 11, 2019 · N92287 · Substantial damage
  > The student pilot's improper release of the throttle and failure to maintain lateral control during takeoff.
- [NTSB GAA20CA008](https://openairdocs.org/ntsb/GAA20CA008.md): Piper PA18 · Big Flats, NY · Accident · No injuries · Data collection · Final report · Oct 10, 2019 · N4138Z · Substantial damage
  > The pilot's improper flight planning and his subsequent failure to maintain clearance from wires during takeoff.
- [NTSB GAA20CA042](https://openairdocs.org/ntsb/GAA20CA042.md): Beech 19 · Somerville, TN · Accident · No injuries · Data collection · Final report · Oct 9, 2019 · N2177W · Substantial damage
  > The pilot's failure to move the fuel selector position to the "on" position before takeoff, which resulted in a total loss of engine power and necessitated a forced landing to a field shortly after takeoff, and his subsequent improper decision to take off…
- [NTSB CEN20LA006](https://openairdocs.org/ntsb/CEN20LA006.md): Beech 36 · Waukesha, WI · Accident · No injuries · Class 3 · Limited · Final report · Oct 8, 2019 · N396JG · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB GAA19CA575](https://openairdocs.org/ntsb/GAA19CA575.md): Piper J3C · Lander, WY · Accident · Minor injuries · Data collection · Final report · Sep 26, 2019 · N33463 · Substantial damage
  > The pilot's failure to maintain lateral control during takeoff with a quartering tailwind, which resulted in the right wing striking the ground, a runway excursion, impact with a fence, and a subsequent noseover.
- [NTSB GAA19CA587](https://openairdocs.org/ntsb/GAA19CA587.md): Beech 36 · Lubbock, TX · Accident · No injuries · Data collection · Final report · Sep 25, 2019 · N5836B · Substantial damage
  > The pilot's improper pitch trim setting during takeoff in a left quartering tailwind, which resulted in the airplane abruptly pitching up and subsequently experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure to follow a…
- [NTSB ERA19LA282](https://openairdocs.org/ntsb/ERA19LA282.md): Cessna 337 · St. Augustine, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 24, 2019 · N108LS · Substantial damage
  > The failure of the pilot and examiner to recognize that the rear engine was not developing power, which resulted in an attempted partial-power takeoff and the airplane’s subsequent descent and impact with terrain.
- [NTSB GAA19CA580](https://openairdocs.org/ntsb/GAA19CA580.md): Cessna 172 · Plant City, FL · Accident · No injuries · Data collection · Final report · Sep 23, 2019 · N739RT · Substantial damage
  > The student pilot's failure to maintain directional control during the aborted landing, which resulted in a runway excursion and impact with a ditch.
- [NTSB GAA19CA567](https://openairdocs.org/ntsb/GAA19CA567.md): George W. Felix Mosquito · Kershaw, SC · Accident · No injuries · Data collection · Final report · Sep 23, 2019 · N849GF · Substantial damage
  > The pilot's improper cyclic input during takeoff, which resulted in a loss of helicopter control, the skid impacting the ground, and a subsequent dynamic rollover.
- [NTSB GAA19CA564](https://openairdocs.org/ntsb/GAA19CA564.md): Piper PA18 · Skwentna, AK · Accident · No injuries · Data collection · Final report · Sep 23, 2019 · N5408Y · Substantial damage
  > The pilot's improper decision to depart from an off-airport surface covered with standing water, which resulted in a noseover.
- [NTSB GAA19CA560](https://openairdocs.org/ntsb/GAA19CA560.md): Thomas Lee Nieuport 11 · Rose Hill, KS · Accident · No injuries · Data collection · Final report · Sep 23, 2019 · N1398 · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and an impact with runway lights.
- [NTSB GAA19CA563](https://openairdocs.org/ntsb/GAA19CA563.md): De Havilland Beaver DHC 2 · Mountain Village, AK · Accident · No injuries · Data collection · Final report · Sep 22, 2019 · N77KZ · Substantial damage
  > The pilot's improper takeoff configuration due to distraction, which resulted in the airplane’s failure to become airborne and its subsequent collision with rising terrain. Contributing to the accident was the pilot's failure to use the Before Takeoff…
- [NTSB CEN19FA325](https://openairdocs.org/ntsb/CEN19FA325.md): Cessna A185 · Conroe, TX · Accident · 2 fatal · Class 3 · Field · Final report · Sep 21, 2019 · C-GOZJ · Destroyed
  > A partial loss of engine power due to fuel contamination with water, and the pilot’s failure to maintain control of the airplane during an attempted return to the airport shortly after takeoff, which resulted in an aerodynamic stall.

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

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

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