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

## Cases, newest first

- [NTSB GAA15CA075](https://openairdocs.org/ntsb/GAA15CA075.md): Head Balloons AX8 105 - NO Series · Intercourse, PA · Accident · Minor injuries · Data collection · Final report · Apr 12, 2015 · N3099F · Substantial damage
  > The pilot's selection of unsuitable terrain/location for takeoff in gusting wind conditions, resulting in a collision with a building, and substantial damage to the hot air balloon.
- [NTSB WPR15FA143](https://openairdocs.org/ntsb/WPR15FA143.md): Cessna T210M · Challis, ID · Accident · 4 fatal · Field investigation · Final report · Apr 10, 2015 · N732YQ · Substantial damage
  > The pilot's attempt to depart in conditions that resulted in the airplane having insufficient performance capability, which resulted in a collision with a tree.
- [NTSB CEN15CA197](https://openairdocs.org/ntsb/CEN15CA197.md): Rennicke Midget Musta MM1 · Longmont, CO · Accident · No injuries · Data collection · Final report · Apr 10, 2015 · N824C · Substantial damage
  > The pilot's failure attain/maintain pitch control prior to attaining a proper takeoff speed during takeoff roll, which resulted in a premature liftoff of the airplane and loss of control.
- [NTSB ERA15LA177](https://openairdocs.org/ntsb/ERA15LA177.md): Mooney M20J · Allentown, PA · Accident · No injuries · Limited investigation · Final report · Apr 6, 2015 · N4826H · Substantial damage
  > A total loss of engine power during takeoff due to an interruption of fuel flow to the engine. The reason for the interruption of the fuel flow could not be determined during postaccident examination and testing.
- [NTSB WPR15LA139](https://openairdocs.org/ntsb/WPR15LA139.md): Beech H35 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Mar 30, 2015 · N112F · Substantial damage
  > A partial loss of engine power during initial takeoff climb for reasons that could not be determined because postaccident examination revealed no evidence of a mechanical anomaly that would have precluded normal operation.
- [NTSB ERA15FA171](https://openairdocs.org/ntsb/ERA15FA171.md): Piper PA28 · West Chester, PA · Accident · 2 fatal · Field investigation · Final report · Mar 29, 2015 · N6842W · Destroyed
  > The failure of the flight instructor and the pilot to abort the takeoff after the airplane experienced a partial loss of engine power with adequate runway remaining, and their subsequent failure to maintain adequate airspeed, which led to the airplane…
- [NTSB CEN15WA186](https://openairdocs.org/ntsb/CEN15WA186.md): Robinson R44 - II · Modrava, Czechia · Accident · 1 fatal · Foreign investigation · Mar 29, 2015 · OK-RRJ · Substantial damage
  > On March 29, 2015, at 0920 universal coordinated time (UTC), a Robinson model R44 Raven II helicopter, Czech Republic registration OK-RRJ, serial number 12464, sustained substantial damage when it collided with wooded terrain within Šumava National Park, near…
- [NTSB CEN15FA181](https://openairdocs.org/ntsb/CEN15FA181.md): Piper J-4A · Pine River, MN · Accident · 2 fatal · Field investigation · Final report · Mar 28, 2015 · N30341 · Substantial damage
  > The pilot' failure to maintain adequate airspeed after takeoff, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot's decision to conduct the flight…
- [NTSB CEN15CA184](https://openairdocs.org/ntsb/CEN15CA184.md): Cessna T188C · Burdett, KS · Accident · No injuries · Data collection · Final report · Mar 28, 2015 · N2093J · Substantial damage
  > The pilot did not maintain directional control of the airplane in gusting wind conditions.
- [NTSB GAA15LA025](https://openairdocs.org/ntsb/GAA15LA025.md): Spaulding Errol Rans S 7 Courier · Pinedale, WY · Accident · Serious injuries · Limited investigation · Final report · Mar 27, 2015 · N4272M · Substantial damage
  > The pilot’s decision to take off in a crosswind that exceeded the airplane’s maximum demonstrated crosswind capability and his subsequent inability to maintain directional control.
- [NTSB CEN15LA206](https://openairdocs.org/ntsb/CEN15LA206.md): Piper PA 32R-301T · Stephenville, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 27, 2015 · N9284 · Substantial damage
  > The partial loss of engine power after takeoff for undetermined reasons, which necessitated a forced landing, during which the airplane impacted trees and a power line.
- [NTSB GAA15CA014](https://openairdocs.org/ntsb/GAA15CA014.md): Costruzioni Aeronautiche Tecna P92 Eaglet · Cambridge, MD · Accident · No injuries · Data collection · Final report · Mar 19, 2015 · N731HG · Substantial damage
  > The pilot's failure to maintain directional control during takeoff.
- [NTSB WPR15FA125](https://openairdocs.org/ntsb/WPR15FA125.md): BAE Systems MK-67 Hawk · Yuma, AZ · Accident · 1 fatal · Field investigation · Final report · Mar 11, 2015 · N506XX · Substantial damage
  > The pilot’s initiation of an early rotation during takeoff, which led to an aerodynamic stall and loss of airplane control. Contributing to the accident were the pilot's use of nose up pitch trim and the operator's policy to use nose-up pitch trim during…
- [NTSB ERA15CA152](https://openairdocs.org/ntsb/ERA15CA152.md): Cessna 182L · Waycross, GA · Accident · No injuries · Data collection · Final report · Mar 10, 2015 · N42667 · Substantial damage
  > The pilot's failure to use any airport guidance while taxiing, which resulted in geographic disorientation and a takeoff attempt from an inadequate length and unsuitable surface.
- [NTSB ANC15CA014](https://openairdocs.org/ntsb/ANC15CA014.md): Piper PA18 - 150 · Talkeetna, AK · Accident · No injuries · Data collection · Final report · Mar 8, 2015 · N5348T · Substantial damage
  > The pilot's failure to maintain control of the airplane during takeoff from an icy surface in gusty wind conditions.
- [NTSB CEN15CA158](https://openairdocs.org/ntsb/CEN15CA158.md): Piper PA 28-140 · Kansas City, MO · Accident · Minor injuries · Data collection · Final report · Mar 2, 2015 · N1513J · Substantial damage
  > The loss of engine power due to fuel starvation.
- [NTSB CEN15CA165](https://openairdocs.org/ntsb/CEN15CA165.md): Piper PA 28-181 · Lee's Summit, MO · Accident · No injuries · Data collection · Final report · Mar 1, 2015 · N3575X · Substantial damage
  > The pilot-receiving-instruction's excessive pitch control during takeoff, which resulted in an aerodynamic stall shortly after liftoff and the subsequent loss of control. Contributing to the accident was the flight crew's decision to have the flight…
- [NTSB DCA15WA075](https://openairdocs.org/ntsb/DCA15WA075.md): Boeing 747 - 468 · Jeddah, Saudi Arabia · Accident · No injuries · Foreign investigation · Feb 25, 2015 · HZ-AIX
  > The Aviation Investigation Bureau of the Kingdom of Saudi Arabia has notified the NTSB of an accident involving a Boeing 747-400, which occurred on February 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under…
- [NTSB WPR15LA111](https://openairdocs.org/ntsb/WPR15LA111.md): Piper PA46 - 350P · Spokane, WA · Accident · 1 fatal · Limited investigation · Final report · Feb 22, 2015 · CGVZW · Destroyed
  > A total loss of engine power due to the refueler’s incorrect refueling of the airplane. Contributing to the accident was the fixed-base operator’s improper fueling nozzle, which facilitated the use of an incorrect fuel, and the pilot’s inadequate preflight…
- [NTSB CEN15LA149](https://openairdocs.org/ntsb/CEN15LA149.md): Piper PA 32RT-300T · Lubbock, TX · Accident · No injuries · Limited investigation · Final report · Feb 20, 2015 · N22267 · Substantial damage
  > The pilot's delayed decision to abort the takeoff after the airplane did not lift off as expected due to an inaccurate airspeed indication and tailwind condition, which resulted in a subsequent runway overrun.
- [NTSB ERA15LA134](https://openairdocs.org/ntsb/ERA15LA134.md): Cirrus Design SR22 · Lexington, KY · Accident · No injuries · Limited investigation · Final report · Feb 19, 2015 · N358CD · Substantial damage
  > Maintenance personnel's failure to properly inspect and clean the engine ignition harness spark plug terminals, which resulted in a partial loss of engine power during an attempted takeoff.
- [NTSB OPS15IA011](https://openairdocs.org/ntsb/OPS15IA011.md): Embraer EMB 145LR · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Feb 18, 2015 · N698CB · 2 aircraft · No damage
  > The flight crew's failure to manage cockpit tasks during taxi resulting in a loss of situation awareness and subsequently taxiing past a required turn point and onto an active runway without clearance. Contributing to the runway incursion was the ground…
- [NTSB ENG15RA015](https://openairdocs.org/ntsb/ENG15RA015.md): Boeing 767 - 204ER · Islamabad, Pakistan, Pakistan · Incident · No injuries · Foreign investigation · Feb 17, 2015 · JY-JAG · Minor damage
  > On February 15, 2015, a Jordan Air Boeing 767-204ER, leased by Shaheen Air International (SAI), experienced a failure of the No. 1 engine, a General Electric CF6-80A2 turbofan engine, during the takeoff roll from the Islamabad International Airport (ISB),…
- [NTSB CEN15LA144](https://openairdocs.org/ntsb/CEN15LA144.md): Beech 58 · Denver, CO · Accident · No injuries · Limited investigation · Final report · Feb 16, 2015 · N297AT · Substantial damage
  > The pilot’s failure to maintain airplane control during a rejected takeoff from a slush-covered runway at night.
- [NTSB ERA15LA138](https://openairdocs.org/ntsb/ERA15LA138.md): Bell 206 · Sevierville, TN · Accident · No injuries · Limited investigation · Final report · Feb 15, 2015 · N3176L · Substantial damage
  > An uncontained engine failure, which resulted from insufficient lubrication of the No. 4 bearing due to carbon buildup on the filter screen of the bearing's oil supply nozzle.
- [NTSB CEN15WA150](https://openairdocs.org/ntsb/CEN15WA150.md): Piper PA46 500TP · Björnön, Sweden · Accident · Minor injuries · Foreign investigation · Feb 15, 2015 · N164ST · Substantial damage
- [NTSB WPR15LA113](https://openairdocs.org/ntsb/WPR15LA113.md): Mooney M20E - NO Series · Bakersfield, CA · Accident · No injuries · Limited investigation · Final report · Feb 14, 2015 · N11LV · Substantial damage
  > The collapse of all three landing gear during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA15FA129](https://openairdocs.org/ntsb/ERA15FA129.md): Beech 1900 · Miami, FL · Accident · 4 fatal · Field investigation · Final report · Feb 11, 2015 · YV1674 · Destroyed
  > The left engine propeller's uncommanded travel to the feathered position during takeoff for reasons that could not be determined due to impact damage. Contributing to the accident was the flight crew's failure to establish a coordinated climb once the left…
- [NTSB ERA15LA123](https://openairdocs.org/ntsb/ERA15LA123.md): American AA-1 · Fort Meade, MD · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 2015 · N6116L · Substantial damage
  > The mechanic’s failure to detect the incorrect dry valve tappet clearances while troubleshooting ongoing engine issues, which resulted in partial loss of engine power during takeoff. Contributing to the partial loss of engine power was the mechanic's failure…
- [NTSB CEN15IA139](https://openairdocs.org/ntsb/CEN15IA139.md): Gulfstream Aerospace G IV · Eagle, CO · Incident · No injuries · Incident investigation · Final report · Feb 8, 2015 · N701DB · Minor damage
  > The pilot's rejected takeoff due to perceived flight control system anomalies, which led to excessive brake temperatures and resulted in a right main landing gear brake fire.
- [NTSB CEN15LA138](https://openairdocs.org/ntsb/CEN15LA138.md): Air Tractor AT 602 · Slaton, TX · Accident · No injuries · Limited investigation · Final report · Feb 5, 2015 · N602PB · Substantial damage
  > Maintenance personnel’s improper installation of the engine data monitor (EDM), which was not in accordance with the supplemental type certificate instructions and resulted in engine warning indications and the pilot’s subsequent reaction to the warning…
- [NTSB ERA15CA121](https://openairdocs.org/ntsb/ERA15CA121.md): Autogyro Calidus · Crozet, VA · Accident · No injuries · Data collection · Final report · Feb 4, 2015 · N595X · Substantial damage
  > The pilot's improper control inputs which resulted in a loss of control and rollover during the takeoff roll.
- [NTSB DCA15RA059](https://openairdocs.org/ntsb/DCA15RA059.md): ATR 72 · Taipei, Taiwan · Accident · 43 fatal · Foreign investigation · Feb 4, 2015 · B-22816 · Destroyed
  > import
- [NTSB CEN15WA133](https://openairdocs.org/ntsb/CEN15WA133.md): Piper PA 46 350P · Meyrin, Switzerland · Accident · 1 fatal · Foreign investigation · Jan 30, 2015 · N246PR · Destroyed
- [NTSB WPR15CA097](https://openairdocs.org/ntsb/WPR15CA097.md): Schneider Richard J Alaskan Bushmaster · Newburg, OR · Accident · No injuries · Data collection · Final report · Jan 29, 2015 · N36NC · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll into sunlight, which restricted his visibility.
- [NTSB WPR15CA094](https://openairdocs.org/ntsb/WPR15CA094.md): Diamond Aircraft Ind DA 40 · La Verne, CA · Accident · No injuries · Data collection · Final report · Jan 27, 2015 · N805ER · Substantial damage
  > The student pilot's loss of directional control during takeoff from a runway, which resulted in a collision with a sign.
- [NTSB ANC15LA008](https://openairdocs.org/ntsb/ANC15LA008.md): Cessna 170B · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jan 21, 2015 · N2580D · Substantial damage
  > The pilot’s loss of directional control during takeoff, which resulted in a runway excursion.
- [NTSB CEN15LA099](https://openairdocs.org/ntsb/CEN15LA099.md): Cessna 195B · Llano, TX · Accident · No injuries · Limited investigation · Final report · Jan 6, 2015 · N2125C · Substantial damage
  > The pilot’s overrotation of the airplane when lifting the tail during the takeoff roll, which allowed the propeller to come in contact with the runway and resulted in a reduction in engine power and the pilot’s subsequent loss of directional control.
- [NTSB CEN15CA097](https://openairdocs.org/ntsb/CEN15CA097.md): Cessna 172M · Marquette, MI · Accident · No injuries · Data collection · Final report · Jan 5, 2015 · N6591H · Substantial damage
  > The pilot did not maintain directional control during takeoff on the snow and ice covered runway in gusting crosswind conditions.
- [NTSB WPR15CA073](https://openairdocs.org/ntsb/WPR15CA073.md): Cessna 140 · Yuma, AZ · Accident · Minor injuries · Data collection · Final report · Jan 1, 2015 · N2841N · Substantial damage
  > The pilot's failure to compensate for crosswind conditions during takeoff, which resulted in the loss of directional control and collision with terrain.
- [NTSB CEN15FA088](https://openairdocs.org/ntsb/CEN15FA088.md): Piper PA 23-160 · Port Clinton, OH · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2014 · N222CP · Destroyed
  > The pilot's loss of control following a loss of left engine power for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.
- [NTSB WPR15LA067](https://openairdocs.org/ntsb/WPR15LA067.md): Farthing James W II Beaver · Perris, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 2014 · N105JF · Substantial damage
  > The partial loss of engine power during takeoff due to an improperly configured carburetor and fuel supply system. Contributing to the accident was the pilot's loss of airplane control during the off-field landing, which resulted in an aerodynamic stall.
- [NTSB WPR15CA066](https://openairdocs.org/ntsb/WPR15CA066.md): Ferdon Thorp T 18 · San Rafael, CA · Accident · No injuries · Data collection · Final report · Dec 20, 2014 · N25VP · Substantial damage
  > The pilot's delayed decision to abort the takeoff. Contributing to the accident are an inadequate modification to the seat position, and the pilot's failure to check flight controls for freedom and correct movement.
- [NTSB ANC15IA006](https://openairdocs.org/ntsb/ANC15IA006.md): Cessna 180J · Nome, AK · Incident · No injuries · Incident investigation · Final report · Dec 20, 2014 · N393B · Minor damage
  > The disengagement and subsequent binding of the right tailwheel steering cable, which disabled the rudder system.
- [NTSB DCA15RA045](https://openairdocs.org/ntsb/DCA15RA045.md): Boeing 757 - 236 · Warsaw, Poland · Incident · No injuries · Foreign investigation · Dec 17, 2014 · DALED · No damage
  > The State Commission on Aircraft Accident Investigation (SCAAI) of Poland has notified the NTSB of an incident involving a Boeing 757-236 that occurred on December 17, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the SCAAI of…
- [NTSB ERA15LA075](https://openairdocs.org/ntsb/ERA15LA075.md): Johnson David Earl Renegade Spirit · Brunswick, GA · Accident · 1 fatal · Limited investigation · Final report · Dec 13, 2014 · N955R · Substantial damage
  > The pilot's decision to fly the airplane with known engine deficiencies and his subsequent exceedance of the airplane's critical angle of attack following a loss of engine power, which resulted in an aerodynamic stall and loss of control after takeoff.
- [NTSB WPR15LA052](https://openairdocs.org/ntsb/WPR15LA052.md): Nanchang CJ-6 · Mesa, AZ · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 2014 · N4350D · Substantial damage
  > The total loss of engine power during takeoff following a touch-and-go landing for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA15FA066](https://openairdocs.org/ntsb/ERA15FA066.md): Piper PA28 · Sommerville, TN · Accident · 1 fatal · Field investigation · Final report · Dec 2, 2014 · N8607W · Destroyed
  > The noninstrument-rated pilot's improper decision to attempt visual flight in instrument meteorological conditions, which resulted in an in-flight loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s impaired…
- [NTSB CEN15LA063](https://openairdocs.org/ntsb/CEN15LA063.md): Siegel Gerald Long EZ · McGregor, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 30, 2014 · N7015T · Substantial damage
  > A loss of engine power during takeoff due to excessive debris in the fuel system.
- [NTSB CEN15WA080](https://openairdocs.org/ntsb/CEN15WA080.md): Gulfstream Aerospace G 1159A · London, United Kingdom · Accident · No injuries · Foreign investigation · Nov 24, 2014 · N103CD · Substantial damage

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

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

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