Fatal NTSB investigations, AL

144 cases where the phase of flight was Enroute.

Cases per year

19642026
Fatal NTSB investigations, AL per year, 1964–2026: 144 cases
19642
19651
19665
19673
19682
19692
19702
19714
19726
19737
19745
19759
19763
19773
19791
19801
19813
19821
19832
19844
19853
19866
19871
19883
19894
19902
19914
19923
19932
19947
19952
19964
19971
19982
19991
20001
20012
20022
20034
20041
20062
20074
20092
20101
20121
20151
20161
20171
20182
20191
20204
20221
20231
20261

Latest cases

Query with SQL
duckdb -csv -c "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.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB ERA26LA140Accident · 2 fatalClass 3 · LimitedPreliminary reportBeech A36 · Gulf Shores, ALOn March 7, 2026, about 1900 central standard time, a Beechcraft A36, N66519 was destroyed when it was involved in an accident near Gulf Shores, Alabama. The pilot and one passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…Mar 8, 2026 · N66519 · DestroyedNTSB ERA24FA050Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Attalla, ALThe undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…Nov 27, 2023 · N4187Q · DestroyedNTSB ERA23FA087Accident · 1 fatalClass 3 · FieldFinal reportMooney M20B · Kellyton, ALA total loss of engine power due to fuel starvation.Dec 13, 2022 · N74586 · Substantial damageNTSB ERA21FA010Accident · 1 fatalClass 3 · FieldFinal reportCzech Sport Cruiser · Waterloo, ALThe improper configuration of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation following the failure of the electric fuel pump.Oct 7, 2020 · N251SC · Substantial damageNTSB ERA20LA314Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH750 Cruzer · Boaz, ALThe pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing was the pilot’s continued visual flight rules flight into an area of low clouds.Sep 10, 2020 · N656BN · Substantial damageNTSB ERA20LA262Accident · 2 fatalClass 3 · LimitedFinal reportBeech F33 · Malbis, ALThe noninstrument-rated pilot’s decision to depart in deteriorating weather conditions, which led to restricted visibility and the pilot’s loss of airplane control due to spatial disorientation. Contributing to the pilot’s poor decision-making was…Jul 29, 2020 · N3156W · Substantial damageNTSB ERA20LA212Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA32RT · Selma, ALThe mechanic’s failure to clean the oil suction screen during the most recent maintenance, which resulted in oil starvation and subsequent total loss of engine power.Jun 10, 2020 · N543GS · DestroyedNTSB CEN20FA009Accident · 1 fatalClass 3 · FieldFinal reportVans RV-8 · White Plains, ALImpact with terrain for reasons that could not be determined based on the available information.Oct 20, 2019 · N249BW · DestroyedNTSB ERA18FA146Accident · 1 fatalField investigationFinal reportBeech 35A33 · Jacksonville, ALThe pilot/mechanic's inadequate inspection of the exhaust system, including the left muffler and heat exchanger, which precluded his detection of preexisting cracks and led to a missed opportunity to replace the components. The inadequate inspection allowed…May 13, 2018 · N486T · DestroyedNTSB ERA18FA118Accident · 1 fatalField investigationFinal reportCessna R182 · Ashville, ALDescent and impact with terrain for reasons that could not be determined.Mar 28, 2018 · N3167C · DestroyedNTSB ERA17FA140Accident · 2 fatalField investigationFinal reportBeech A36 · Dadeville, ALA loss of engine power for reasons that could not be determined due to postcrash thermal damage to the engine accessories and the airframe. Contributing to the accident was the pilot's failure to navigate to any of the available forced landing sites within…Mar 28, 2017 · N8169Y · DestroyedNTSB ERA16FA289Accident · 6 fatalField investigationFinal reportPiper PA 31 · Northport, ALA total loss of power in both engines due to fuel starvation as a result of the pilot's fuel mismanagement, and his subsequent failure to follow the emergency checklist. Contributing to the pilot's failure to follow the emergency checklist was his lack of…Aug 14, 2016 · N447SA · Substantial damageNTSB ERA15FA178Accident · 1 fatalField investigationFinal reportHughes 369D · Cherokee, ALThe pilot's spatial disorientation during a low-level river crossing in rainy, gray, reduced visibility meteorological conditions, which resulted in the helicopter's subsequent descent and impact with the water. Contributing to the accident was the pilot's…Apr 6, 2015 · N555JC · Substantial damageNTSB ERA12FA566Accident · 2 fatalField investigationFinal reportMooney M20M · Crane Hill, ALThe pilot’s loss of control in moderate-to-heavy rain. Contributing to the accident was the pilot’s reliance on ADS-B for tactical weather avoidance.Sep 17, 2012 · N1085A · Substantial damageNTSB ERA10FA115Accident · 2 fatalField investigationFinal reportBeech B-60 · Madison, ALThe pilot's failure to divert to the nearest suitable airport following a total loss of power in the right engine during cruise flight. Contributing to the accident was the total loss of power in the right engine due to separation of its No. 2 cylinder as a…Jan 18, 2010 · N810JA · Substantial damageNTSB ERA10FA099Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Heflin, ALThe student pilot's failure to maintain adequate airspeed during night, adverse weather conditions, which resulted in an aerodynamic stall/spin. Contributing to the accident was the student pilot's decision to attempt a flight that he was not qualified for…Dec 25, 2009 · N1277T · Substantial damageNTSB ERA09FA289Accident · 2 fatalField investigationFinal reportBeech A36 · Beauregard, ALThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.May 15, 2009 · N191MK · Substantial damageNTSB NYC07FA226Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Whitfield, ALThe pilot’s intentional flight into known thunderstorms.Sep 13, 2007 · N109PA · DestroyedNTSB MIA07FA098Accident · 1 fatalField investigationFinal reportHughes 369A · Moulton, ALThe separation of a main rotor blade from its tension torsion bar for an undetermined reason.May 13, 2007 · N468WE · DestroyedNTSB ATL07LA066Accident · 1 fatalLimited investigationFinal reportSzybowcowy Zaklad Do SZD-36A · Sylacauga, ALThe pilot's improper installation of the left wing attachment pin, which allowed it to disengage during cruise flight, resulting in wing separation.Mar 31, 2007 · N6SZ · Substantial damageNTSB ATL07FA038Accident · 2 fatalField investigationFinal reportCessna 172K · Bessemer, ALThe non-instrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions.Feb 2, 2007 · N7109G · Substantial damageNTSB ATL07FA005Accident · 1 fatalField investigationFinal reportBeech BE-19A · Gunthertown, ALThe pilot's continued flight from VMC into IMC conditions which resulted in an in-flight collision with rising terrain.Oct 9, 2006 · N6974Q · DestroyedNTSB ATL06FA038Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Camden, ALThe pilots failure to maintain altitude and clearance during a visual descent which resulting in an in-flight collision with trees and the ground for undetermined reasons.Jan 28, 2006 · N38510 · DestroyedNTSB ATL04FA077Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Arlington, ALThe pilots inadequate in-flight planning/decision and his failure to maintain aircraft control, resulting in an in-flight encounter with a thunderstorm and exceeding the design limits of the aircraft.Feb 23, 2004 · N9103Z · DestroyedNTSB ATL04FA049Accident · 2 fatalField investigationFinal reportCessna 441 · Vestavia Hills, ALThe pilot's failure to maintain adequate airspeed during climb in icing conditions, which resulted in an inadvertent stall / spin of the airplane and subsequent uncontrolled descent and collision with terrain. A factor was the accumulation of airframe ice.Dec 10, 2003 · N441W · DestroyedNTSB ATL03FA114Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Scottsboro, ALThe pilot's improper fuel management which resulted in a loss of engine power due to fuel starvation and subsequent impact with trees.Jun 19, 2003 · N270LM · Substantial damageNTSB ATL03LA152Accident · 2 fatalLimited investigationFinal reportChinook Plus 2 A13-SWB · Elsanor, ALThe loss of engine power for undetermined reasons.Jun 12, 2003 · UNREG · Substantial damageNTSB ATL03FA075Accident · 2 fatalField investigationFinal reportCessna 180 · Oxford, ALThe pilot's continued VFR flight into IMC conditions and his failure to maintain obstacle clearance. A factor was low ceilings.Apr 10, 2003 · N3166D · DestroyedNTSB ATL03FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Spanish Fort, ALthe pilot's spatial disorientation, which resulted in loss of airplane control. Contributing to the accident was the night instrument meteorological conditions with variable cloud layers.Oct 24, 2002 · N76U · DestroyedNTSB ATL02FA143Accident · 2 fatalField investigationFinal reportCessna 150G · Duncanville, ALThe pilot's failure to maintain airspeed , which resulted in an inadvertent stall, and subsequent collision with the ground. A contributing factor was low level flight.Jul 17, 2002 · N3400J · DestroyedNTSB MIA01LA113Accident · 1 fatalLimited investigationFinal reportLarry R. Kinsey Variez O-235 · Pinson, ALThe pilot's continued visual flight rules flight into instrument meteorological conditions resulting in the airplane colliding with mountainous terrain.Mar 31, 2001 · N49LK · DestroyedNTSB ATL01FA019Accident · 1 fatalField investigationFinal reportCessna 206H · Vandiver, ALThe pilot's inflight decision to continued visual flight into instrument meteorological conditions resulted in the inflight collision with trees. Low ceilings and trees were factorsJan 12, 2001 · N2468G · DestroyedNTSB MIA00FA166Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Aliceville, ALThe in-flight collision with trees then terrain while descending for undetermined reasons.May 23, 2000 · N711MS · DestroyedNTSB MIA00FA029Accident · 2 fatalField investigationFinal reportHughes 369HS · Helena, ALThe pilots continued visual flight rules flight into instrument meteorological conditions resulting in his becoming spatially disoriented and loosing control of the helicopter, which resulted in an uncontrolled descent and impact with the ground.Nov 25, 1999 · N395WM · DestroyedNTSB MIA99FA027Accident · 2 fatalField investigationFinal reportCessna C-182Q · Piedmont, ALThe pilot's decision to continue the flight under visual flight rules into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.Nov 2, 1998 · N735JZ · DestroyedNTSB MIA98FA060Accident · 1 fatalField investigationFinal reportFairchild 24G · Andalusia, ALA loss of engine power while in cruise flight caused by a contaminated fuel supply and the subsequent inflight collision with trees and unsuitable terrain during the emergency descent and landing.Jan 28, 1998 · N16866 · DestroyedNTSB ATL98LA018Accident · 1 fatalLimited investigationFinal reportJohn T. Simpson Challenger II · Rainbow City, ALThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with the ground. A related factor was the pilot's lack of flying experience.Dec 6, 1997 · N11644 · DestroyedNTSB MIA97FA031Accident · 1 fatalField investigationFinal reportPiper PA32-300D · Reform, ALa complete loss of engine power due to a total failure of both magnetos, and the failure of the pilot-in-command to insure that the airplane was airworthy. The dark night and unsuitable terrain were factors.Dec 6, 1996 · N8603N · DestroyedNTSB MIA96LA200Accident · 1 fatalLimited investigationFinal reportBell 206B III · Barton, ALfailure of the pilot to see-and/or-avoid the obstruction (unmarked power line), while en route between the area that was being treated and the refueling location. The power line and lack of visual cues at dusk were related factors.Aug 4, 1996 · N5015T · DestroyedNTSB ATL96FA096Accident · 2 fatalField investigationFinal reportCessna 152 · Talladega, ALfailure of the pilot to see-and-avoid an antenna that was mounted on a Forest Service watch tower. The pilot's excessively low altitude flight was a related factor.Jun 27, 1996 · N95396 · DestroyedNTSB ATL96FA095Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Clanton, ALcorrosion pitting of the number six cylinder on the left engine, and subsequent fatigue fracture and separation of the cylinder, which led to an engine compartment fire, wing fire, and an in-flight separation of the left wing.Jun 24, 1996 · N6937Y · DestroyedNTSB ATL96FA021Accident · 2 fatalField investigationFinal reportMooney M20J · Bay Minette, ALfailure of the alternate air door, which resulted in blockage of air through the induction system. A factor relating to the accident was: failure to comply with Safety Bulletin SB-M20-253.Dec 14, 1995 · N3874H · DestroyedNTSB ATL95FA092Accident · 2 fatalField investigationFinal reportWittman O&O · Stevenson, ALAileron-wing flutter induced by separation at the trailing edge of an unbonded portion of wing fabric at an aileron wing station. The debonding of the wing fabric was a result of improper installation.Apr 27, 1995 · N41SW · DestroyedNTSB MIA95FA037Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Sylvan Springs, ALPoor in-flight planning/decision by the pilot-in-command for failure to deviate to an alternate airport after encountering icing conditions in an airplane not certificated for flight in icing conditions. Also, failure of the pilot to maintain altitude…Dec 11, 1994 · N6517C · DestroyedNTSB ATL95FA007Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Newville, ALFailure of maintenance personnel to properly install the marmon clamp on the discharge side of the turbocharger.Oct 23, 1994 · N999BW · DestroyedNTSB ATL95LA059Accident · 1 fatalLimited investigationFinal reportHayes LONG-EZ · Collinsville, ALThe pilot continued visual flight into instrument weather conditions, and collided with the ground.Oct 9, 1994 · N33EZ · Substantial damageNTSB ATL95FA003Accident · 2 fatalField investigationFinal reportCessna 182L · Ft. Mcclellan, ALThe pilot's continued VFR flight into IMC conditions, and his failure to maintain a proper altitude over mountainous terrain. Factors were the low ceiling, fog, and drizzle weather conditions, and the mountainous terrain at the accident site.Oct 3, 1994 · N3499R · DestroyedNTSB ATL94FA131Accident · 2 fatalField investigationFinal reportBeech H-35 · Jackson, ALThe pilot's failure to avoid an area of thunderstorm activity, which resulted in a loss of control and the designed structural limits of the airframe being exceeded. The thunderstorms were a factor in the accident.Jul 5, 1994 · N7917D · DestroyedNTSB ATL94FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Opelika, ALLoss of aircraft control for an unknown reason. Factors related to the accident were: the weather conditions (clouds with low ceiling), continued VFR flight by the pilot into instrument meteorological conditions (IMC), the pilot's lack of instrument…Apr 15, 1994 · N39770 · DestroyedNTSB ATL94FA056Accident · 4 fatalField investigationFinal reportCessna P210R · Bay Minette, ALThe pilot's failure to maintain control of the aircraft due to spatial disorientation, and exceeding the design stress limits of the aircraft. Factors related to the accident were: the pilot's flight into known adverse weather conditions, overconfidence in…Mar 1, 1994 · N55MM · Destroyed