# NTSB investigations: Taxi

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 11 of 128 · 6,400 cases

## Cases, newest first

- [NTSB OPS16IA009](https://openairdocs.org/ntsb/OPS16IA009.md): Cessna 172S · Honolulu, HI · Incident · Class 3 · Incident · Final report · Feb 26, 2016 · N269ME · 2 aircraft · No damage
  > The air traffic controller's decision to clear an aircraft to land on a runway occupied by another aircraft that had previously been instructed to line up and wait. Contributing to the runway incursion was the failure of the air traffic controller to visually…
- [NTSB ENG16WA019](https://openairdocs.org/ntsb/ENG16WA019.md): Boeing 767 · Domodedovo, Russia · Incident · No injuries · Foreign investigation · Feb 26, 2016 · VQ-BUO · Substantial damage
  > Initial Notification sent to NTSB by the Ministry of Transport of the Russian Federation. The Ministry of Transport of the Russian Federation has appointed Federal Air Transport Agency (FATA) to investigate the incident of an Azurair Airlines B767-300…
- [NTSB GAA16CA138](https://openairdocs.org/ntsb/GAA16CA138.md): Cessna 170 · Enumclaw, WA · Accident · No injuries · Data collection · Final report · Feb 24, 2016 · N2715C · Substantial damage
  > The pilot's incorrect brake application during taxi, which resulted in a nose over.
- [NTSB DCA16WA097](https://openairdocs.org/ntsb/DCA16WA097.md): Boeing 737 · Chitose, Japan · Accident · Serious injuries · Foreign investigation · Feb 23, 2016 · JA322J · No damage
  > The government of Japan has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of…
- [NTSB DCA16CA094](https://openairdocs.org/ntsb/DCA16CA094.md): Boeing 737 · Detroit, MI · Accident · No injuries · Data collection · Final report · Feb 17, 2016 · N925NN · 2 aircraft · Minor damage
  > N925NN flight crew's incorrect evaluation of the clearance between the two aircraft, leading to the inadvertent collision of the winglet with the horizontal stabilizer and elevator of N784SW.
- [NTSB GAA16CA132](https://openairdocs.org/ntsb/GAA16CA132.md): Consolidated Vultee BT 15 · Chino, CA · Accident · No injuries · Data collection · Final report · Feb 13, 2016 · N67086 · 2 aircraft · Minor damage
  > The taxiing pilot's failure to remain a safe distance from the stopped airplane while taxiing to the run-up area, resulting in a ground collision and substantial damage.
- [NTSB GAA16CA127](https://openairdocs.org/ntsb/GAA16CA127.md): Cessna 150 · Santa Paula, CA · Accident · No injuries · Data collection · Final report · Feb 12, 2016 · N704SL · 2 aircraft · Substantial damage
  > The tailwheel pilot's failure to see and avoid a stationary airplane performing a run-up, which resulted in a ground collision.
- [NTSB GAA16CA119](https://openairdocs.org/ntsb/GAA16CA119.md): Piper PA 28-161 · Everglades, FL · Accident · No injuries · Data collection · Final report · Jan 31, 2016 · N705RA · Substantial damage
  > The pilot's failure to maintain adequate wing clearance while taxiing, which resulted in a collision with two unoccupied airplanes.
- [NTSB ERA16WA099](https://openairdocs.org/ntsb/ERA16WA099.md): Cessna 550 · Istanbul, Türkiye · Incident · No injuries · Foreign investigation · Jan 15, 2016 · TC-AHE · Minor damage
  > On January 15, 2016, at 1103 Universal Coordinated Time (UTC), a Cessna 550 Citation I, Turkish registration TC-AHE, operated by Panjet, received minor damage during taxi after landing at Istanbul Atatürk Airport, Instanbul, Turkey (LTBA). The flight…
- [NTSB GAA16CA096](https://openairdocs.org/ntsb/GAA16CA096.md): Cessna 172 · Punta Gorda, FL · Accident · No injuries · Data collection · Final report · Dec 26, 2015 · N4776E · Substantial damage
  > The student pilot's failure to maintain obstacle clearance while taxiing on the ramp, resulting in a collision with an object.
- [NTSB DCA16LA032](https://openairdocs.org/ntsb/DCA16LA032.md): Boeing 737 3H4 · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Dec 15, 2015 · N649SW · Substantial damage
  > the flight crew's early turn towards the assigned gate because taxiway lighting had been inadvertently turned off by the controller-in-charge which resulted in the airplane leaving the paved surface. Contributing to the accident was the operation of the…
- [NTSB GAA16CA051](https://openairdocs.org/ntsb/GAA16CA051.md): Piper PA 31-350 · Portland, OR · Accident · No injuries · Data collection · Final report · Nov 17, 2015 · N555RG · Substantial damage
  > The failure of the fuel truck driver to see and avoid the taxiing airplane.
- [NTSB GAA16CA058](https://openairdocs.org/ntsb/GAA16CA058.md): Cessna 172 · Greeley, CO · Accident · No injuries · Data collection · Final report · Nov 15, 2015 · N4256Q · 2 aircraft · Substantial damage
  > The pilot of the following airplane failed to maintain adequate spacing during the taxi to the runway, resulting in a collision with the lead airplane.
- [NTSB GAA16CA052](https://openairdocs.org/ntsb/GAA16CA052.md): Cessna 172S · Alcoa, TN · Accident · No injuries · Data collection · Final report · Nov 5, 2015 · N905CP · Substantial damage
  > The pilot's failure to identify the taxiway, which resulted in a runway excursion and impact with terrain while turning off the runway at night.
- [NTSB CEN16LA052](https://openairdocs.org/ntsb/CEN16LA052.md): Cessna 208B · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Nov 3, 2015 · N732MD · Substantial damage
  > The failure of the driver of the service vehicle to yield to the taxiing airplane, which resulted in a near-collision and tail strike.
- [NTSB DCA16FA013](https://openairdocs.org/ntsb/DCA16FA013.md): Boeing 767 · Fort Lauderdale, FL · Accident · Serious injuries · Field investigation · Final report · Oct 29, 2015 · N251MY · Substantial damage
  > the separation of the flexible fuel line coupling and subsequent fuel leak due to the failure of maintenance personnel to install the required safety lockwire. Contributing to the severity of the accident was the initiation of the evacuation before the right…
- [NTSB CEN16LA023](https://openairdocs.org/ntsb/CEN16LA023.md): Piper PA-28-181 · New Century, KS · Accident · No injuries · Limited investigation · Final report · Oct 24, 2015 · N8227L · Substantial damage
  > The pilot’s application of excessive brake pressure to maintain a safe taxi speed during a long, slightly downhill taxi with a strong quartering tailwind, which resulted in a brake fire.
- [NTSB GAA16CA042](https://openairdocs.org/ntsb/GAA16CA042.md): Cessna 421 · Amarillo, TX · Accident · No injuries · Data collection · Final report · Oct 14, 2015 · N19CH · Substantial damage
  > The loss of directional control during taxi to the runway as a result of insufficient brake fluid level in the right brake master cylinder, resulting in a taxiway excursion and collision with a drainage culvert.
- [NTSB GAA16CA034](https://openairdocs.org/ntsb/GAA16CA034.md): Cessna 182R · Abilene, TX · Accident · No injuries · Data collection · Final report · Oct 12, 2015 · N9736H · Substantial damage
  > The pilot's diverted attention while taxiing, which resulted in a collision with a fence post.
- [NTSB CEN16LA008](https://openairdocs.org/ntsb/CEN16LA008.md): Beechcraft A36 · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Oct 12, 2015 · N55674 · Substantial damage
  > The pilot’s improper navigation onto a vehicle service road while taxiing and his subsequent distraction while looking at an airport diagram, which led to the airplane impacting a fence post.
- [NTSB GAA16CA005](https://openairdocs.org/ntsb/GAA16CA005.md): Raytheon A36 · Monterey, CA · Accident · No injuries · Data collection · Final report · Oct 6, 2015 · N53WW · Substantial damage
  > The pilot's failure to see and avoid runway signage during taxi after landing, resulting in a collision and substantial damage to the left wing of the airplane.
- [NTSB ERA16LA004](https://openairdocs.org/ntsb/ERA16LA004.md): Beech 58 · Albany, GA · Accident · No injuries · Limited investigation · Final report · Oct 6, 2015 · N25734 · Substantial damage
  > The mechanic's inadequate inspection of the brake system during the most recent annual inspection, which resulted in the failure of both left and right main landing gear torque plates and a subsequent loss of braking action.
- [NTSB DCA15CA176](https://openairdocs.org/ntsb/DCA15CA176.md): Boeing 737 7H4 · Oakland, CA · Accident · Serious injuries · Data collection · Final report · Aug 23, 2015 · N232WN · No damage
  > inadvertent jet blast, resulting in debris striking ground operations personnel.
- [NTSB GAA15CA303](https://openairdocs.org/ntsb/GAA15CA303.md): Mitsubishi MU 2B-25 · Arvin, CA · Accident · No injuries · Data collection · Final report · Aug 22, 2015 · N553T · Substantial damage
  > The pilot's failure to maintain clearance from trees while taxiing into position for takeoff on a narrow private airstrip, resulting in the left wing striking a tree.
- [NTSB GAA15CA233](https://openairdocs.org/ntsb/GAA15CA233.md): Robinson Helicopter R22 · Prescott, AZ · Accident · No injuries · Data collection · Final report · Aug 18, 2015 · N5VH · Substantial damage
  > The flight instructor's decision to turn the helicopter downwind during a hover taxi which resulted in an uncontrolled descent and impact with terrain.
- [NTSB DCA15WA180](https://openairdocs.org/ntsb/DCA15WA180.md): Boeing 747 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Aug 11, 2015 · D-ABYJ · No damage
  > The German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 747 airplane, which occurred on August 11, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of…
- [NTSB GAA15CA215](https://openairdocs.org/ntsb/GAA15CA215.md): Cessna 560XL · Spanish Fork, UT · Accident · No injuries · Data collection · Final report · Aug 5, 2015 · N560JF · Substantial damage
  > The Captain's decision to taxi on a closed taxiway, which resulted in a collision with a parked construction vehicle. Contributing to the accident was a ground crew employee's decision to move barricades from the closed taxiway.
- [NTSB DCA15WA170](https://openairdocs.org/ntsb/DCA15WA170.md): Airbus A320 - 214 · Padang, Indonesia · Incident · No injuries · Foreign investigation · Aug 2, 2015 · PK-GQG · No damage
  > The National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a AIRBUS A320, which occurred on August 02, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…
- [NTSB CEN15LA334](https://openairdocs.org/ntsb/CEN15LA334.md): Cessna 208B · Chicago, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 2015 · N942AC · Substantial damage
  > An encounter with a wind gust during ground maneuvering and the captain’s improper flight control positioning to account for wind conditions, which resulted in the airplane being blown onto its left wing.
- [NTSB DCA15WA182](https://openairdocs.org/ntsb/DCA15WA182.md): Bombardier CL600 2E25 · Makassar, Indonesia · Incident · No injuries · Foreign investigation · Jul 27, 2015 · PK-GRC · No damage
  > The National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a CRJ-1000, which occurred on August 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…
- [NTSB WPR15LA234](https://openairdocs.org/ntsb/WPR15LA234.md): Cessna 180J · Dixie, ID · Accident · No injuries · Limited investigation · Final report · Jul 26, 2015 · N52095 · Substantial damage
  > The failure of the right brake hydraulic line during taxi due to fatigue, which caused a loss of hydraulic fluid and rendered the brake inoperative.
- [NTSB CEN15RA446](https://openairdocs.org/ntsb/CEN15RA446.md): Cessna 525 · Geneva, Switzerland · Incident · No injuries · Foreign investigation · Jul 24, 2015 · N990FV · 2 aircraft · No damage
- [NTSB ERA15LA288](https://openairdocs.org/ntsb/ERA15LA288.md): Canadair CL-600-2B16 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Jul 22, 2015 · N613PJ · Substantial damage
  > The flight crew's failure to properly use the before start checklist, to monitor the airplane's motion, and to see and avoid objects around the airplane, which resulted in an inadvertent roll into a ground vehicle.
- [NTSB GAA15CA173](https://openairdocs.org/ntsb/GAA15CA173.md): Cessna 182 · Athens, TN · Accident · No injuries · Data collection · Final report · Jul 6, 2015 · N234CF · Substantial damage
  > The failure of the taxiway surface due to a sink hole, which resulted in the right main landing gear sinking into terrain causing substantial damage to the fuselage.
- [NTSB GAA15CA167](https://openairdocs.org/ntsb/GAA15CA167.md): Cessna 170B · Durango, CO · Accident · No injuries · Data collection · Final report · Jun 28, 2015 · N170MW · Substantial damage
  > The pilot's decision to taxi behind a turbojet airplane into jet blast, which resulted in the airplane being blown off an active taxiway and flipped upside down onto terrain.
- [NTSB GAA15CA145](https://openairdocs.org/ntsb/GAA15CA145.md): Beech D17S · Idaho Falls, ID · Accident · No injuries · Data collection · Final report · Jun 28, 2015 · N114H · 2 aircraft · Substantial damage
  > While taxiing as a flight of two, the pilot of the blue Beechcraft became distracted and impacted the red Beechcraft which had stopped.
- [NTSB WPR15LA184](https://openairdocs.org/ntsb/WPR15LA184.md): Eclipse EA500 · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Jun 12, 2015 · N508JA · Substantial damage
  > A manufacturing defect that resulted in fatigue failure of the left main landing gear trunnion.
- [NTSB DCA15CA129](https://openairdocs.org/ntsb/DCA15CA129.md): Mcdonnell Douglas DC 9 83(MD-83) · St Petersburg, FL · Accident · Serious injuries · Data collection · Final report · Jun 8, 2015 · N869GA · No damage
  > evacuation of the aircraft due to reported, but unverified, aircraft condition and poor communication between Aircraft Rescue and Firefighting personnel and the flight crew.
- [NTSB ERA15LA224](https://openairdocs.org/ntsb/ERA15LA224.md): Cessna 337 · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · May 27, 2015 · N1732M · Substantial damage
  > The pilot’s failure to maintain directional control while taxiing as a result of his impairment due to alcohol ingestion.
- [NTSB GAA15CA110](https://openairdocs.org/ntsb/GAA15CA110.md): Piper PA 28-181 · Wickenburg, AZ · Accident · No injuries · Data collection · Final report · May 24, 2015 · N442PA · Substantial damage
  > The pilot's failure to monitor the airplane's wing clearance during taxi, which resulted in a collision with a parked airplane.
- [NTSB GAA15CA078](https://openairdocs.org/ntsb/GAA15CA078.md): Consolidated Aeronautics Lake LA4-200 · Mineral, VA · Accident · No injuries · Data collection · Final report · May 16, 2015 · N1105L · Substantial damage
  > The pilot's failure to maintain directional control during a high-speed water taxi in rough water conditions, resulting in a collision with a dock.
- [NTSB GAA15CA066](https://openairdocs.org/ntsb/GAA15CA066.md): Cessna 177B · Roxboro, NC · Accident · No injuries · Data collection · Final report · May 4, 2015 · N1102C · Substantial damage
  > The pilot's failure to monitor the airplane's movement and maintain control of the airplane.
- [NTSB DCA15CA118](https://openairdocs.org/ntsb/DCA15CA118.md): Bombardier CL600 2D24 · Phoenix, AZ · Accident · No injuries · Data collection · Final report · May 4, 2015 · N932LR · Substantial damage
  > the CRJ900 captain's misjudgment of the clearance between their horizontal stabilizer and the B757 winglet.
- [NTSB CEN15CA223](https://openairdocs.org/ntsb/CEN15CA223.md): Piper J3C-65 · De Kalb, IL · Accident · No injuries · Data collection · Final report · May 3, 2015 · N98656 · Substantial damage
  > The pilot's loss of positional awareness while taxiing, resulting in a collision with a parked and unoccupied airplane. Contributing to the accident was the pilot's difficulty seeing over the nose of the airplane, his preoccupation with trying to control the…
- [NTSB DCA15WA122](https://openairdocs.org/ntsb/DCA15WA122.md): Airbus A321 - 211 · Barcelona, Spain · Incident · No injuries · Foreign investigation · Apr 28, 2015 · F-GTAZ · 2 aircraft · No damage
  > The Comision de Investigacion de Accidentes e Incidentes de Aviacion Civil (CIAIAC) has notified the NTSB of an incident involving an Airbus A321 and a Boeing 737-400 which occurred on April 28, 2015. The NTSB has appointed a U.S. Accredited Representative to…
- [NTSB WPR15LA154](https://openairdocs.org/ntsb/WPR15LA154.md): Diamond Aircraft Ind DA 20 C1 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Apr 24, 2015 · N309EF · 2 aircraft · Minor damage
  > Both pilots’ failure to see and avoid each other, which resulted in an on ground collision while taxiing. Contributing to the accident was the ground controller’s failure to notify either pilot about the presence of the other airplane on the taxiway.
- [NTSB GAA15CA036](https://openairdocs.org/ntsb/GAA15CA036.md): Piper PA 22-135 · Drexel, MO · Accident · No injuries · Data collection · Final report · Apr 5, 2015 · N3768A · Substantial damage
  > The pilot's failure to maintain airplane control while taxiing in unfavorable wind conditions.
- [NTSB DCA15WA102](https://openairdocs.org/ntsb/DCA15WA102.md): Boeing Boeing 737-8AS · Dublin, Ireland · Accident · No injuries · Foreign investigation · Apr 1, 2015 · EI-DWE · 2 aircraft · Substantial damage
  > The Air Accidents Investigation Unit f Ireland (AAIU-IE) has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on April 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU's investigation under…
- [NTSB ENG15WA016](https://openairdocs.org/ntsb/ENG15WA016.md): Fokker F28 - 0070 · Amsterdam, Netherlands · Incident · No injuries · Foreign investigation · Mar 5, 2015 · PH-WXC
  > On March 05, 2015, about 1215 LCL, a Fokker F28, PH-WXC, On March 5, 2015, a Fokker F28 experienced a braking failure while on the ramp and struck a ground power unit (GPU) at Schiphol Airport (EHAM), Amsterdam, the Netherlands.The incident is being…
- [NTSB ERA15LA135](https://openairdocs.org/ntsb/ERA15LA135.md): Cessna 208 · Baltimore, MD · Accident · No injuries · Limited investigation · Final report · Feb 24, 2015 · N989FX · Substantial damage
  > The ground service vehicle operator's failure to yield right of way to the airplane due to distraction, which necessitated the pilot's use of reverse thrust and braking to avoid a collision and resulted in the airplane's empennage striking the ground.

Next page: https://openairdocs.org/ntsb-phases/250/cases.md?page=12

## 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 = 250)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/250/cases?page=11

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.