# Fatal 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 1 of 2 · 72 cases

## Latest cases

- [NTSB GAA24WA068](https://openairdocs.org/ntsb/GAA24WA068.md): Cessna 210 · Guayaibi, Paraguay · Accident · 4 fatal · Class 5 · Foreign · Dec 2, 2023 · ZP-BDN · Destroyed
- [NTSB CEN23LA413](https://openairdocs.org/ntsb/CEN23LA413.md): Powrachute Airwolf · Erie, CO · Incident · 1 fatal · Class 3 · Limited · Final report · Sep 20, 2023 · N820PP · Substantial damage
  > The pilot’s inadvertent manipulation of the throttle, which resulted in the aircraft traveling on the ground and the unsecured pilot being ejected from the aircraft and sustaining fatal injuries.
- [NTSB ANC23FA001](https://openairdocs.org/ntsb/ANC23FA001.md): Cessna A185F · Fairbanks, AK · Accident · 1 fatal · Class 3 · Field · Final report · Oct 6, 2022 · N217C · No damage
  > The improperly maintained floats, which allowed water to fill the front compartments and resulted in the airplane nosing over during taxi. Contributing to the fatal injury of the pilot was the improperly secured cargo, which prevented the pilot from egressing…
- [NTSB ERA22LA395](https://openairdocs.org/ntsb/ERA22LA395.md): Diamond Aircraft Industries DA 42 · Orlando, FL · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 1, 2022 · N43RG · Substantial damage
  > The flight crew’s insufficient evaluation of the deteriorating weather conditions in the area, which resulted in an encounter with a microburst.
- [NTSB CEN22LA164](https://openairdocs.org/ntsb/CEN22LA164.md): Mooney M20E · Kerrville, TX · Accident · 1 fatal · Class 3 · Limited · Final report · Mar 31, 2022 · N21BS · Substantial damage
  > The pilot’s sudden cardiac event, which resulted in incapacitation, uncontrolled taxi after landing, and collision with a stationary parked airplane.
- [NTSB ERA22FA153](https://openairdocs.org/ntsb/ERA22FA153.md): American AA-1 · Bay Minette, AL · Incident · 1 fatal · Class 2 · Field · Final report · Mar 11, 2022 · N5774L · Substantial damage
  > The pilot’s loss of control during taxi, which resulted in a taxiway overrun and subsequent impact with terrain. Contributing to the incident were the low visibility conditions that existed at the airport around the time of the incident.
- [NTSB CEN20LA413](https://openairdocs.org/ntsb/CEN20LA413.md): Cosmos Phase 3 · Wayne, OK · Accident · Fatal · Class 3 · Limited · Final report · Sep 19, 2020 · N7024L · Substantial damage
  > A loss of control while taxiing for reasons that could not be determined based on available evidence.
- [NTSB ERA14LA084](https://openairdocs.org/ntsb/ERA14LA084.md): Beech A36 · Fryeburg, ME · Accident · 1 fatal · Limited investigation · Final report · Jan 1, 2014 · N1803X · No damage
  > The pilot’s incapacitation due to a cardiac event during taxi.
- [NTSB WPR13FA054](https://openairdocs.org/ntsb/WPR13FA054.md): Robinson Helicopter R44 II · Corona, CA · Accident · 1 fatal · Field investigation · Final report · Nov 26, 2012 · N4204A · Substantial damage
  > The pilot's failure to maintain clearance between the helicopter’s main rotor blades and the metal canopy of a fuel island.
- [NTSB ERA09LA198](https://openairdocs.org/ntsb/ERA09LA198.md): McNear Explorer Coupe · Okeechobee, FL · Accident · 1 fatal · Limited investigation · Final report · Mar 14, 2009 · N5098L · Substantial damage
  > The pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.
- [NTSB MIA08FA070](https://openairdocs.org/ntsb/MIA08FA070.md): Ulrich Christen Velocity XL RG · Titusville, FL · Accident · 3 fatal · Field investigation · Final report · Mar 1, 2008 · N244CU · 2 aircraft · Destroyed
  > The pilot of the Velocity’s failure to see and avoid the flight of four RV-8s that had landed and were in the process of clearing the runway.
- [NTSB NYC08FA051](https://openairdocs.org/ntsb/NYC08FA051.md): Beech 60 · New Castle, DE · Accident · 1 fatal · Field investigation · Final report · Dec 4, 2007 · N105PP · Destroyed
  > The pilot's failure to maintain adequate airspeed during a split flap takeoff, which resulted in an aerodynamic stall. Contributing to the accident were the failure of the right flap drive mechanism and the pilot's failure to verify that both flaps were…
- [NTSB DCA06MA064](https://openairdocs.org/ntsb/DCA06MA064.md): Bombardier CRJ-100 · Lexington, KY · Accident · 49 fatal · Class 1 · Major · Final report · Aug 27, 2006 · N431CA · Destroyed
  > the flight crewmembers's failure to use available cues and aids to identify the airplane's location on the airport surface during taxi and their failure to cross-check and verify that the airplane was on the correct runway before takeoff. Contributing to the…
- [NTSB CHI06FA206](https://openairdocs.org/ntsb/CHI06FA206.md): Grumman TBM-3 · Oshkosh, WI · Accident · 1 fatal · Field investigation · Final report · Jul 30, 2006 · N420GP · 2 aircraft · Minor damage
  > The Avenger pilot's visual lookout was inadequate and he failed to maintain clearance from the RV-6. Contributing factors were the Avenger's restricted visibility and the RV-6.
- [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 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 SEA02LA040](https://openairdocs.org/ntsb/SEA02LA040.md): Piper PA-24-180 · Scappoose, OR · Accident · 1 fatal · Limited investigation · Final report · Feb 12, 2002 · N7004P · Substantial damage
  > The pilot's failure to tie down the aircraft prior to hand propping the engine. Factors were a fence, trees, and the pilot's inadequate preflight planning/preparation.
- [NTSB DCA01MA056](https://openairdocs.org/ntsb/DCA01MA056.md): de Havilland Dash 8-100 · Washington, DC · Accident · 1 fatal · Major investigation · Final report · Aug 5, 2001 · N935HA · Minor damage
  > The ramp agent's impaired performance due to his hyperthyroidism, which was exacerbated by the heat and was inadequately controlled by medication, and possibly also due to the use of an antianxiety medication.
- [NTSB IAD01LA078](https://openairdocs.org/ntsb/IAD01LA078.md): Patalivo Dominator · Laconia, NH · Accident · 1 fatal · Limited investigation · Final report · Jun 16, 2001 · UNREG · Substantial damage
  > The non-certificated pilot's inability to maintain control of the gyrocopter after inadvertently allowing it to become airborne. A factor was the pilot's lack of flight experience.
- [NTSB ANC98LA112](https://openairdocs.org/ntsb/ANC98LA112.md): de Havilland DHC-2 · Nondalton, AK · Accident · 1 fatal · Limited investigation · Final report · Jul 30, 1998 · N123EF · No damage
  > The pilot's inadequate procedures/directives when he allowed a passenger to exit the cabin area while the propeller was still turning, and the passenger's failure to follow the pilot's instructions to stay away from the propeller. A factor associated with the…
- [NTSB FTW98FA283](https://openairdocs.org/ntsb/FTW98FA283.md): Montgomery Quickie TRI-Q/200 · Fort Worth, TX · Accident · 1 fatal · Field investigation · Final report · Jun 26, 1998 · N699WB · Substantial damage
  > The pilot's failure to maintain aircraft control when an excessive taxispeed resulted in an inadvertent lift-off of the airplane. A factor was the pilot's lack of total experience in the make and model of aircraft.
- [NTSB CHI96FA323](https://openairdocs.org/ntsb/CHI96FA323.md): Globe GC-1B · Hampshire, IL · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1996 · N570SR · Minor damage
  > improper use of the mini-bike by the driver. Factors relating to the accident were: darkness, the unlighted mini-bike, and insufficient standards required by the residents of the airstrip concerning use of the taxiways at night.
- [NTSB CHI94FA262](https://openairdocs.org/ntsb/CHI94FA262.md): Grumman HU-16 · St. Ignace, MI · Accident · 1 fatal · Field investigation · Final report · Aug 2, 1994 · N7025N · Minor damage
  > The pilot's failure to follow good seaplane operating practices by taxiing with power at forward thrust, with a tailwind, at a speed that necessitated using reverse thrust to arrest the excessive speed, and the pilot's misjudgment of his distance from the…
- [NTSB SEA94FA199](https://openairdocs.org/ntsb/SEA94FA199.md): Piper PA-12 · Salem, OR · Accident · 2 fatal · Field investigation · Final report · Jul 31, 1994 · N2368M · Minor damage
  > Failure of the pilot to see-and-avoid the occupied canoe. Factors related to the accident were: the pilot's improper planning/decision and excessive taxi speed.
- [NTSB BFO94FA092](https://openairdocs.org/ntsb/BFO94FA092.md): Cessna 172H · Millville, NJ · Accident · 2 fatal · Field investigation · Final report · Jun 9, 1994 · N4964R · 2 aircraft · Destroyed
  > The failure of the Cessna's pilot-in-command to perform an adequate visual lookout.
- [NTSB ATL93FA004](https://openairdocs.org/ntsb/ATL93FA004.md): Aero Commander 680 · Headland, AL · Accident · 1 fatal · Field investigation · Final report · Oct 6, 1992 · N4490 · Substantial damage
  > The pilot's failure to maintain control of the airplane while conducting a high speed taxi maneuver which resulted in inadvertent flight. Factors were the pilot's over confidence in his ability, his lack of familiarity with the airplane and the wind gust.
- [NTSB SEA92IA164](https://openairdocs.org/ntsb/SEA92IA164.md): Smith Vari EZE · Terry, MT · Incident · 1 fatal · Incident investigation · Final report · Jul 27, 1992 · UNREG · Destroyed
  > The pilot in command's exceeding liftoff speed during a taxi test.
- [NTSB SEA92FA045](https://openairdocs.org/ntsb/SEA92FA045.md): Bell 206B · Wellington, UT · Accident · 2 fatal · Field investigation · Final report · Feb 12, 1992 · N5003U · Destroyed
  > The pilot's continued flight into adverse weather conditions and an excessive rate of descent. Factors contributing to the accident were fog, rain, low ceilings, night conditions, snow covered terrain and pilot disorientation.
- [NTSB DCA91MA010](https://openairdocs.org/ntsb/DCA91MA010.md): Mcdonnell Douglas DC-9-14 · Romulus, MI · Accident · 8 fatal · Class 1 · Major · Final report · Dec 3, 1990 · N3313L · 2 aircraft · Destroyed
  > Lack of proper crew coordn, including virtual reversal of roles by the DC-9 plts, which led to their failure to stop taxiing & alert gnd ctlr of their positional uncertainty in a timely manner bfr & after intruding onto the active rwy. Contribuing to cause of…
- [NTSB SEA90FA080](https://openairdocs.org/ntsb/SEA90FA080.md): Swearingen SA226-T(B) · Coeur D'Alene, ID · Accident · 1 fatal · Field investigation · Final report · May 20, 1990 · N161RS · Minor damage
  > Inadequate coordination between the pilot and the ground lineman. A factor related to the accident was: impairment of the ground lineman from consumption of alcohol.
- [NTSB NYC90DFJ02](https://openairdocs.org/ntsb/NYC90DFJ02.md): Robbins Breezy CG-1 · Horseheads, NY · Accident · 1 fatal · Final report · Apr 6, 1990 · N68CG · Destroyed
  > The loss of aircraft control during high speed taxi for an unknown reason.
- [NTSB FTW89DRD10](https://openairdocs.org/ntsb/FTW89DRD10.md): Grumman G-164-B · Mer Rouge, LA · Accident · 1 fatal · Final report · Jun 30, 1989 · N8341K · No damage
  > The failure of the individual struck by the taxiing airplane's propeller to visually perceive and avoid the airplane.
- [NTSB CHI88FA179](https://openairdocs.org/ntsb/CHI88FA179.md): Piper PA-30 · Oshkosh, WI · Accident · 1 fatal · Field investigation · Final report · Jul 29, 1988 · N43GS · No damage
- [NTSB ANC88LA151](https://openairdocs.org/ntsb/ANC88LA151.md): Cessna U206F · Lake Minchumina, AK · Accident · 1 fatal · Limited investigation · Final report · Jul 25, 1988 · N401SU · Substantial damage
  > The plt said he was taxiing the floatplane from a windy/wavy location to a small protected cove for a final preflt. While taxiing, the top cap of the left float was open & the float began filling with water. Subsequently, the float- plane rolled over & sank.
- [NTSB NYC88DNE01](https://openairdocs.org/ntsb/NYC88DNE01.md): Lamb Commander Elite · Meriden, CT · Accident · 1 fatal · Final report · Nov 4, 1987 · N501JL · Substantial damage
  > The pilot's failure to maintain control of the homebuilt gyrocopter while preforming low level 'fast taxi' maneuvers.
- [NTSB MKC86LA178](https://openairdocs.org/ntsb/MKC86LA178.md): Cessna 172 · Emporia, KS · Accident · 1 fatal · Limited investigation · Final report · Aug 26, 1986 · N3791R · Minor damage
  > The acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…
- [NTSB NYC86FHD01](https://openairdocs.org/ntsb/NYC86FHD01.md): Piasecki Acft. Helistat 97-34J · Lakehurst, NJ · Accident · 1 fatal · Final report · Jul 2, 1986 · N1897Z · Destroyed
  > The helistat, a hybrid a/c with 4 H-34 main fuselages attached to a frame along with a ZPG-2 helium filled envelope had just completed it first hover test flt successfully and landed. A pwr loss was noted on the no. 3 helicopter and the test was terminated…
- [NTSB MIA85FA215](https://openairdocs.org/ntsb/MIA85FA215.md): Piper PA-32-260 · San Juan, PR · Accident · 1 fatal · Field investigation · Final report · Jul 18, 1985 · N3714W · Substantial damage
  > The acft was taxiing northbound on the north-south taxiway and collided with the vehicle moving westbound along the east-west access road. The access road is a designated non-movement area under the control of the puerto rico port authority. The plt stated he…
- [NTSB MKC85FCQ03](https://openairdocs.org/ntsb/MKC85FCQ03.md): Cessna 172RG · Wichita, KS · Accident · 1 fatal · Final report · Jun 4, 1985 · N7190C · Minor damage
  > The acft collided with a cushman scooter during taxi. A witness stated that when the scooter driver 'looked up' I saw the acft taxiing, he made a hard rt turn which threw him off. The scooter driver and scooter were struck separately by the acft. The scooter…
- [NTSB NYC85FA097](https://openairdocs.org/ntsb/NYC85FA097.md): Cessna 421B · Johnson City, NY · Accident · 2 fatal · Field investigation · Final report · Apr 2, 1985 · N5407J · Destroyed
  > After a heavy snow shower passed over the airport, the accident acft attempted a departure. Immediately after takeoff the plt transmitted that he was coming back to land. The acft crashed shortly thereafter, 1 mile southwest of the airport. Ground witnesses…
- [NTSB MIA85FA122](https://openairdocs.org/ntsb/MIA85FA122.md): Piper J3C-85 · Winter Haven, FL · Accident · 1 fatal · Field investigation · Final report · Mar 16, 1985 · N6716H · Minor damage
  > While taxiing back to the seaplane ramp after landing the acft struck a small fishing boat causing fatal injuries to the boats sole occupant. The acft was being taxied at high speed on the step and s turns where being made to clear the area due to the plt not…
- [NTSB CHI85FA138](https://openairdocs.org/ntsb/CHI85FA138.md): Beech 58 · Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Mar 13, 1985 · N1889L · Destroyed
  > The Beech 58 plt was returning at ngt when traffic was very light. After lndg, the acft was retained on local control (lc) freq for the plt's convenience. The plt requested clnc to the twa hangar & was cleared on the most expeditious route. This route went…
- [NTSB ANC84LA148](https://openairdocs.org/ntsb/ANC84LA148.md): Cessna 180 · Iliamna Bay, AK · Accident · 2 fatal · Limited investigation · Final report · Aug 28, 1984 · N2641Y · Destroyed
  > The acft struck a gravel bar while taxiing. The acft was not freed from the gravel bar until the next morning due to a receding tide on the previous night. Approx 3 hours later as the pilot taxied around awaiting daylight for takeoff, the acft rolled over in…
- [NTSB ATL84IA137](https://openairdocs.org/ntsb/ATL84IA137.md): Piper PA-34-200T · Parkersburg, WV · Incident · 2 fatal · Incident investigation · Final report · Mar 30, 1984 · N2827U · No damage
  > After an unscheduled landing due to the condition of a patient aboard the acft, the acft turned off a taxiway into the grass and stopped. Rescue personnel found the plt incapacitated from a heart attack and collapsed over the controls and the nurse…
- [NTSB SEA84FA048](https://openairdocs.org/ntsb/SEA84FA048.md): Sikorsky S-61L · Medford, OR · Accident · 1 fatal · Field investigation · Final report · Feb 5, 1984 · N6981R · Destroyed
  > The plt deviated from the painted taxi line to avoid a parked fuel truck and collided with a hangar door. The main rotor hit the door and flying debris damaged 2 hangers,3 acft and 2 cars.
- [NTSB MIA82FKA05](https://openairdocs.org/ntsb/MIA82FKA05.md): Cessna 206 · Saint Croix · Accident · 1 fatal · Final report · Jan 4, 1982 · N5151U · Destroyed
  > Aircraft landed during darkness before control tower had opened. While taxiing to ramp, aircraft was struck by an ambulance as aircraft was crossing parallel taxiway. Aircraft immediately burst into flames, and ambulance continued to travel through the…
- [NTSB FTW80DA039](https://openairdocs.org/ntsb/FTW80DA039.md): Bell 206B · Grand Isle, LA · Accident · 1 fatal · Closed · Feb 8, 1980 · N4019G · Substantial damage
- [NTSB MKC79FA006](https://openairdocs.org/ntsb/MKC79FA006-133094.md): Pazmany PL-2 · Olathe, KS · Accident · 1 fatal · Closed · Nov 16, 1979 · N72KA · Minor damage
- [NTSB ANC78FA075](https://openairdocs.org/ntsb/ANC78FA075.md): Cessna 206 · Twin Lakes, AK · Accident · 1 fatal · Closed · Sep 4, 1978 · N8497Q · Substantial damage
- [NTSB ANC78FA048](https://openairdocs.org/ntsb/ANC78FA048.md): Cessna A185F · Coronation Is, AK · Accident · 1 fatal · Closed · Jul 4, 1978 · N774SB · Destroyed

Next page: https://openairdocs.org/ntsb-phases/250/cases.md?fatal=1&page=2

## 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."highestInjuryLevel" = 'Fatal'
  AND 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?fatal=1

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