# 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 22 of 128 · 6,398 cases

## Cases, newest first

- [NTSB NYC04LA099](https://openairdocs.org/ntsb/NYC04LA099.md): Beech 1900D · Windsor Locks, CT · Accident · No injuries · Limited investigation · Final report · Apr 1, 2004 · N149CJ · Substantial damage
  > The fuel truck driver's failure to maintain clearance with a taxiing airplane, resulting in the collision between the fuel truck and the airplane. A factor in the accident was the night condition.
- [NTSB CHI04CA092](https://openairdocs.org/ntsb/CHI04CA092.md): Cessna 150J · Gardner, KS · Accident · No injuries · Data collection · Final report · Mar 22, 2004 · N51365 · Substantial damage
  > The pilot's inadequate visual lookout and failure to maintain clearance from the post. A factor was the post.
- [NTSB ANC04LA044](https://openairdocs.org/ntsb/ANC04LA044.md): Beech V35B · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Mar 20, 2004 · N412V · Substantial damage
  > The pilot's inadvertent retraction of the landing gear during the taxi from landing, which resulted in structural damage to the airplane.
- [NTSB MIA04LA058](https://openairdocs.org/ntsb/MIA04LA058.md): Ortmayer/Parson none · Bunnell, FL · Accident · 1 fatal · Limited investigation · Final report · Mar 12, 2004 · N69EP · Substantial damage
  > The owner/pilot mechanic's failure to comply with a manufacture notice to replace the rotor blades and hub bar assembly, resulting in a failure of the hub bar to hub bar wing attaching bolt and separation of a main rotor blade.
- [NTSB LAX04LA159](https://openairdocs.org/ntsb/LAX04LA159.md): Beech 65 · Sedona, AZ · Accident · No injuries · Limited investigation · Final report · Mar 9, 2004 · N751T · Substantial damage
  > an explosion of the left outboard wing, resulting from a leaking fuel line and the ignition of the flammable fuel/air mixture in the outboard wing bays; the source of ignition energy for the explosion could not be determined. A factor in the accident was an…
- [NTSB DEN04IA050](https://openairdocs.org/ntsb/DEN04IA050.md): Airbus Industrie A320-232 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Mar 6, 2004 · N467UA · 2 aircraft · Minor damage
  > the failure of the other flight crew to maintain clearance from the airplane and the ground crews failure to follow proper pushback procedures.
- [NTSB CHI04LA083](https://openairdocs.org/ntsb/CHI04LA083.md): Cessna 195 · Manitowoc, WI · Accident · No injuries · Limited investigation · Final report · Feb 19, 2004 · N4351V · Minor damage
  > The Cessna 195 pilot's failure to maintain clearance from the Cessna 177RG while taxiing to the ramp after landing. A contributing factor was the restricted forward visibility (blind spot) of the Cessna 195 due to the engine cowling. An additional factor was…
- [NTSB ANC04LA024](https://openairdocs.org/ntsb/ANC04LA024.md): Robinson R44 · Daytona Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 2004 · N323TC · Substantial damage
  > The pilot's inadequate compensation for wind conditions while hover taxiing, which resulted in a loss of control and subsequent in-flight collision with terrain and a rollover of the helicopter. A factor associated with the accident was a gusty wind condition.
- [NTSB LAX04CA130](https://openairdocs.org/ntsb/LAX04CA130.md): Cessna 172S · Riverside, CA · Accident · No injuries · Data collection · Final report · Feb 15, 2004 · N262TA · Substantial damage
  > the pilot's inadequate visual lookout, which resulted in his failure to maintain proper alignment with the taxiway. Factors in the accident were the dusk lighting conditions and pilot not understanding the ground control taxi clearance.
- [NTSB NYC04LA062](https://openairdocs.org/ntsb/NYC04LA062.md): Gates Learjet 35A · Akron, OH · Accident · No injuries · Limited investigation · Final report · Jan 30, 2004 · N39WA · Substantial damage
  > An improperly maintained ramp area, which resulted in a loss of airplane control while taxiing on ice. Factors in this accident were, high winds, and the down-sloping ramp.
- [NTSB LAX04CA099](https://openairdocs.org/ntsb/LAX04CA099.md): Cessna 152 · San Diego, CA · Accident · No injuries · Data collection · Final report · Jan 11, 2004 · N67844 · Substantial damage
  > the pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.
- [NTSB LAX04LA090](https://openairdocs.org/ntsb/LAX04LA090.md): Piper PA-28R-180 · California City, CA · Accident · No injuries · Limited investigation · Final report · Jan 7, 2004 · N3820T · Substantial damage
  > the pilot's decision to continue taxiing during dark night conditions without an operable taxi/landing light or taxiway lights and his failure to maintain taxiway alignment. Contributing factors to the accident were the dark night light conditions, the failed…
- [NTSB LAX04CA088](https://openairdocs.org/ntsb/LAX04CA088.md): Piper PA 28-181 · Groveland, CA · Accident · No injuries · Data collection · Final report · Jan 3, 2004 · N9272Q · Substantial damage
  > the pilot's inadequate visual lookout, and his failure to maintain obstacle clearance. Factors to the accident were the parked vehicle, and the pilot's diverted attention.
- [NTSB DEN04LA033](https://openairdocs.org/ntsb/DEN04LA033.md): Aerospatiale AS 365 N-2 · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Dec 27, 2003 · N291LL · Destroyed
  > the pilot's failure to maintain lateral clearance from the hangar. A contributing factor was the gusty crosswind.
- [NTSB DEN04LA030](https://openairdocs.org/ntsb/DEN04LA030.md): Robinson R22 · Broomfield, CO · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 2003 · N341MK · Destroyed
  > the flight instructor's failure to maintain aircraft control. Contributing to the accident was the wind gust.
- [NTSB NYC04LA047](https://openairdocs.org/ntsb/NYC04LA047.md): Piper PA-23-250 · Buffalo, NY · Accident · No injuries · Limited investigation · Final report · Dec 12, 2003 · N40259 · Substantial damage
  > The pilot's improper procedure with regard to the cabin heater, which resulted in the over temperature of the heater and subsequent fire.
- [NTSB LAX04CA065](https://openairdocs.org/ntsb/LAX04CA065.md): Beech 58P · San Diego, CA · Accident · No injuries · Data collection · Final report · Dec 9, 2003 · N58JG · Substantial damage
  > the pilot's inadequate lookout, which resulted in his failure to maintain clearance from the vehicle while taxiing.
- [NTSB DEN04FA027](https://openairdocs.org/ntsb/DEN04FA027.md): Swearingen SA226-TC · Denver, CO · Accident · No injuries · Field investigation · Final report · Dec 3, 2003 · N60U · 2 aircraft · Substantial damage
  > the failure of the pilot of the taxiing aircraft to maintain clearance and adequate visual lookout for the stopped aircraft.
- [NTSB IAD04LA003](https://openairdocs.org/ntsb/IAD04LA003.md): Cessna C172R · Lexington, KY · Accident · No injuries · Limited investigation · Final report · Nov 30, 2003 · N9968F · Substantial damage
  > The ground controller's failure to advise the relieving controller information regarding an engine run-up, which subsequently resulted in the flight instructor's inadvertent encounter with jet blast during ground taxi.
- [NTSB NYC04LA046](https://openairdocs.org/ntsb/NYC04LA046.md): Cessna 172E · Islip, NY · Accident · No injuries · Limited investigation · Final report · Nov 13, 2003 · N5329T · Substantial damage
  > The pilot's failure to maintain aircraft control, which resulted in a nose over. A factor in this accident was the gusty wind conditions.
- [NTSB LAX04LA043](https://openairdocs.org/ntsb/LAX04LA043.md): Cessna 208B · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Nov 13, 2003 · N717BT · Substantial damage
  > the pilot's improper decision to taxi behind another airplane conducting an engine run-up, which resulted in a jet blast encounter.
- [NTSB CHI04FA031](https://openairdocs.org/ntsb/CHI04FA031.md): Cessna 560XL · Wheeling, IL · Accident · No injuries · Field investigation · Final report · Nov 11, 2003 · N789CN · Substantial damage
  > The flight crew's intentional operation with know deficiencies in the aircraft and their delay in aborting the takeoff when a no-takeoff warning was presented. An additional cause was the crew's failure to comply with flight manual procedures concerning…
- [NTSB DEN04IA024](https://openairdocs.org/ntsb/DEN04IA024.md): Beech 1900D · Denver, CO · Incident · No injuries · Incident investigation · Final report · Nov 10, 2003 · N254GL · Minor damage
  > the ground personnel’s failure to maintain aircraft clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel, the flight crew's inadequate visual outlook and the parked airplane.
- [NTSB LAX04LA027](https://openairdocs.org/ntsb/LAX04LA027.md): Piper PA 28-161 · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Oct 25, 2003 · N39494 · 2 aircraft · Substantial damage
  > the pilot of the other airplane's inadvertent application of the rudder pedals rather than the brakes, which resulted in the collision with the Cessna 172R.
- [NTSB MIA04LA004](https://openairdocs.org/ntsb/MIA04LA004.md): Airbus Industrie A-319-112 · Tampa, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 2003 · N764US · No damage
  > An intermittent fault with the airplane's Brake Steering Control Unit (BSCU) for undetermined reasons, which resulted in a momentary loss of brakes and steering, and a serious injury to a flight attendant during the resultant sudden stop during taxi for…
- [NTSB LAX04CA013](https://openairdocs.org/ntsb/LAX04CA013.md): Cleveland Orson Starduster II SA-300 · Stockton, CA · Accident · No injuries · Data collection · Final report · Oct 14, 2003 · N379C · Substantial damage
  > the pilot's inadequate visual lookout resulted in his failure to maintain clearance from the parked airplane.
- [NTSB DCA03IA058](https://openairdocs.org/ntsb/DCA03IA058.md): McDonnell Douglas MD-80 · Dfw, TX · Incident · Minor injuries · Incident investigation · Final report · Sep 25, 2003 · N462AA · No damage
  > The improper maintenance of the tailcone evacuation system, which prevented the evacuation slide from inflating during an evacuation due to smoke/fumes in the cabin.
- [NTSB SEA03LA192](https://openairdocs.org/ntsb/SEA03LA192.md): Cessna 421B · Driggs, ID · Accident · No injuries · Limited investigation · Final report · Sep 20, 2003 · N41053 · Substantial damage
  > The collapse of the nose landing gear while taxiing due to the failure of the nose wheel bearing. A factor was the lack of lubrication.
- [NTSB SEA03LA201](https://openairdocs.org/ntsb/SEA03LA201.md): Cessna 172S · Anacortes, WA · Accident · No injuries · Limited investigation · Final report · Sep 18, 2003 · N3555L · Substantial damage
  > The pilot attempting to taxi the airplane with a known system deficiency. Factors include worn wheel brakes and a drainage ditch.
- [NTSB ANC03LA128](https://openairdocs.org/ntsb/ANC03LA128.md): Cessna 206 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 18, 2003 · N275F · Substantial damage
  > A failure of an attaching bolt that allowed the nose wheel fork to separate from the nose gear strut, which resulted in the collapse of the nose gear during the landing roll. A factor contributing to the accident was rough/uneven terrain.
- [NTSB MIA03IA168](https://openairdocs.org/ntsb/MIA03IA168.md): Boeing 757-223 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Aug 24, 2003 · N609AA · Minor damage
  > The failure of maintenance personnel from the aircraft operator to identify a missing left main landing gear truck beam shield and damage to the left main landing gear truck beam which resulted in the fracture of the truck beam as a result of stress corrosion…
- [NTSB CHI03LA280](https://openairdocs.org/ntsb/CHI03LA280.md): Cessna 172P · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Aug 23, 2003 · N55326 · Substantial damage
  > Failure of the maintenance crew to provide adequate clearance to an active taxiway during the engine run-up. Contributing factors were the failure of the control tower to provide a wake turbulence advisory to the accident aircraft when assigning a taxi route…
- [NTSB CHI03LA178](https://openairdocs.org/ntsb/CHI03LA178.md): Champion 7GCBC · Buffalo, SD · Accident · No injuries · Limited investigation · Final report · Jul 28, 2003 · N9032L · Substantial damage
  > The instructor pilot's inadequate remedial action to the dual student's loss of aircraft control during high speed taxiing which lead to the inadvertent ground loop/swerve. A factor was the student not maintaining aircraft control.
- [NTSB SEA03LA156](https://openairdocs.org/ntsb/SEA03LA156.md): Hughes 269C · Marblemount, WA · Accident · No injuries · Limited investigation · Final report · Jul 25, 2003 · N500HS · Substantial damage
  > The partial failure of a magneto during hover taxi over water, leading to a forced landing in shallow water near the shoreline. Factors include the aircraft being over a lake at the time that the partial loss of power made it impossible to keep it airborne.
- [NTSB SEA03LA150](https://openairdocs.org/ntsb/SEA03LA150.md): Cessna 185 · Sinclair Is., WA · Accident · No injuries · Limited investigation · Final report · Jul 19, 2003 · C-FHMY · Substantial damage
  > The pilot's failure to maintain directional control while taxiing for takeoff. Factors contributing to the accident were the ditch and the fence.
- [NTSB MIA03LA144](https://openairdocs.org/ntsb/MIA03LA144.md): Cessna 172R · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Jul 18, 2003 · N864CP · 2 aircraft · Substantial damage
  > Failure of the student pilot of N864CP to judge the clearance between his airplane and the stationary N431ER while taxiing for takeoff which resulted in a ground collision.
- [NTSB SEA03CA162](https://openairdocs.org/ntsb/SEA03CA162.md): Cessna R172K · Idaho Falls, ID · Accident · No injuries · Data collection · Final report · Jul 17, 2003 · N758LW · Substantial damage
  > The pilot's failure to see and avoid a parked aircraft while taxiing.
- [NTSB SEA03LA133](https://openairdocs.org/ntsb/SEA03LA133.md): Cessna 402 B · Lakeview, OR · Accident · No injuries · Limited investigation · Final report · Jul 8, 2003 · N98635 · Substantial damage
  > Failure of the landing gear shaft roll pin resulting in a main gear collapse during the taxi phase of operation.
- [NTSB DEN03LA115](https://openairdocs.org/ntsb/DEN03LA115.md): Schweizer 269C · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Jun 28, 2003 · N3623U · Substantial damage
  > the pilot not maintaining aircraft control during the aerial taxi. Factors contributing to the accident were the oscillating cyclic, the pilot's diverted attention, and the gusting crosswind.
- [NTSB SEA03LA104](https://openairdocs.org/ntsb/SEA03LA104.md): Mooney M20C · Boise, ID · Accident · No injuries · Limited investigation · Final report · Jun 14, 2003 · N6806U · Substantial damage
  > Failure of the welds on the nose landing gear retraction truss during taxi for takeoff..
- [NTSB DEN03TA103](https://openairdocs.org/ntsb/DEN03TA103.md): Cessna R172E · Albuquerque, NM · Accident · No injuries · Final report · Jun 12, 2003 · N7867N · Substantial damage
  > the student pilot's inadvertent encounter with the jet blast and the subsequent inability to maintain aircraft control.
- [NTSB DEN03LA096](https://openairdocs.org/ntsb/DEN03LA096.md): Embraer EMB-120ER · Denver, CO · Accident · No injuries · Limited investigation · Final report · Jun 2, 2003 · N299UX · Substantial damage
  > the ground personnel's failure to maintain aircraft/ground vehicle clearance, resulting in the collision. Contributing factors include ground communications not coordinated by the ground personnel and the airport vehicle.
- [NTSB NYC03LA114](https://openairdocs.org/ntsb/NYC03LA114.md): Saab-Scania 340B · Flushing, NY · Accident · Minor injuries · Limited investigation · Final report · May 22, 2003 · N277MJ · 2 aircraft · Substantial damage
  > The inadequate visual lookout and inadequate crew coordination of the Dassault DA-50 flightcrew while taxiing, which resulted in an on ground collision with a taxing Saab 340B. A factor in the accident was the dark night.
- [NTSB LAX03LA167](https://openairdocs.org/ntsb/LAX03LA167.md): Boeing 757-223 · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · May 20, 2003 · N692AA · Substantial damage
  > the vehicle driver's failure to deploy the parking brake or use wheel chocks to secure the vehicle prior to leaving it unattended.
- [NTSB LAX03LA157](https://openairdocs.org/ntsb/LAX03LA157.md): Sabre Trike 330 · Jean, NV · Accident · 1 fatal · Limited investigation · Final report · May 20, 2003 · UNREG · Substantial damage
  > The pilot's excessive taxi speed, which resulted in an inadvertent liftoff at an inadequate airspeed and a subsequent stall. A factor was the pilot's lack of experience in the airplane.
- [NTSB CHI03LA122](https://openairdocs.org/ntsb/CHI03LA122.md): Cessna 182S · Hatton, ND · Accident · No injuries · Limited investigation · Final report · May 6, 2003 · N182ND · Substantial damage
  > Failure by the flight instructor to maintain clearance to the tree. Contributing factors were the delayed remedial action by the flight instructor and the tree.
- [NTSB LAX03LA196](https://openairdocs.org/ntsb/LAX03LA196.md): Piper PA-46-310P · Grand Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Apr 26, 2003 · N189ET · Substantial damage
  > The out of rig condition of the landing gear control linkages, which prevented the on-ground antiretraction safety device from working. Also causal was the pilot's inadvertent movement of the gear selector to the up position while taxiing.
- [NTSB LAX03LA144](https://openairdocs.org/ntsb/LAX03LA144.md): Piper PA-28-181 · Bullhead City, AZ · Accident · No injuries · Limited investigation · Final report · Apr 25, 2003 · N38137 · Substantial damage
  > The pilot's misjudgment of distance resulting in the inadequate clearance between the wing tip and the fuel truck.
- [NTSB NYC03LA089](https://openairdocs.org/ntsb/NYC03LA089.md): Cessna P206 · Newport, RI · Accident · No injuries · Limited investigation · Final report · Apr 24, 2003 · N4624F · Substantial damage
  > The pilot's inadvertent encounter with propeller blast.
- [NTSB LAX03LA149](https://openairdocs.org/ntsb/LAX03LA149.md): Cessna 340A · Boulder City, NV · Accident · No injuries · Limited investigation · Final report · Apr 23, 2003 · N100UW · Substantial damage
  > the airport committee members failure to repair or mark the faulty telephone junction box cover as a hazard. A factor in the accident was the inadequate notification process of the airport and city personnel.

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

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

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