# NTSB investigations, AL: Enroute

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 11 · 538 cases

## Latest cases

- [NTSB ERA26LA348](https://openairdocs.org/ntsb/ERA26LA348.md): Hopwood Joseph R Zodiac · Stockton, AL · Accident · No injuries · Class 4 · Limited · Final report · Sep 20, 2026 · N601LL · Substantial damage
  > A partial loss of engine power due to a missing exhaust clamp bolt and subsequent oil loss due to a damaged engine oil return line, which resulted in the pilot’s decision to perform an off-airport landing.
- [NTSB ANC26LA075](https://openairdocs.org/ntsb/ANC26LA075.md): Cessna 152 · Pell City, AL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 20, 2026 · N103UC · Substantial damage
  > On July 20, 2026, at 1030 eastern daylight time, a Cessna 152 airplane was substantially damaged when it was involved in an accident near Pell City, Alabama. The flight instructor and student pilot were not injured. The airplane was operated as a Title 14…
- [NTSB ERA26LA193](https://openairdocs.org/ntsb/ERA26LA193.md): Bell UH1 · Enterprise, AL · Accident · No injuries · Class 4 · Limited · Final report · Apr 4, 2026 · N75140 · Substantial damage
  > The in-flight separation of a turn lock fastener stud, which resulted in substantial damage to one tail rotor blade.
- [NTSB ERA26LA140](https://openairdocs.org/ntsb/ERA26LA140.md): Beech A36 · Gulf Shores, AL · Accident · 2 fatal · Class 3 · Limited · Preliminary report · Mar 8, 2026 · N66519 · Destroyed
  > On 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…
- [NTSB ERA26LA098](https://openairdocs.org/ntsb/ERA26LA098.md): Diamond Aircraft Ind DA 40 NG · Bay Minette, AL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jan 27, 2026 · N708BL · Substantial damage
  > On January 27, 2026 at 1439 central standard time, a Diamond Aircraft Ind. Inc. DA-40 NG, N708BL, was substantially damaged when it was involved in an accident near Bay Minette, Alabama. The flight instructor and student pilot sustained minor injuries. The…
- [NTSB ERA26LA061](https://openairdocs.org/ntsb/ERA26LA061.md): Mooney M20K · Foley, AL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Dec 3, 2025 · N57229 · Substantial damage
  > On December 3, 2025, about 1600 central standard time, a Mooney Aircraft Corp. M20K, N57229, was substantially damaged when it was involved in an accident near Foley, Alabama. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB ERA26LA001](https://openairdocs.org/ntsb/ERA26LA001.md): Cirrus Design SR22 · Talladega, AL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 2, 2025 · N812SE · Substantial damage
  > On October 2, 2025, at 1126 central daylight time, a Cirrus SR22, N812SE, was substantially damaged when it was involved in an accident near Talladega, Alabama. The commercial pilot sustained minor injuries, and the two passengers were not injured. The…
- [NTSB ERA25LA269](https://openairdocs.org/ntsb/ERA25LA269.md): Beech K35 · Sylacauga, AL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 16, 2025 · N5353E · Substantial damage
  > On July 16, 2025, at 1402 central standard time, a Beech K35, N5353E, was substantially damaged when it was involved in an accident near Sylacauga, Alabama. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA24LA232](https://openairdocs.org/ntsb/ERA24LA232.md): Cessna 172P · Citronelle, AL · Accident · Serious injuries · Class 3 · Limited · Final report · May 27, 2024 · N658NV · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a fuel vent line that was clogged by an insect nest.
- [NTSB ERA24LA222](https://openairdocs.org/ntsb/ERA24LA222.md): Cessna 177 · Selma, AL · Accident · Serious injuries · Class 3 · Limited · Final report · May 19, 2024 · N3268T · Substantial damage
  > Insufficient lubrication of the engine’s internal components, which resulted in a total loss of engine power.
- [NTSB ERA24FA050](https://openairdocs.org/ntsb/ERA24FA050.md): Piper PA32R · Attalla, AL · Accident · 1 fatal · Class 3 · Field · Final report · Nov 27, 2023 · N4187Q · Destroyed
  > The 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…
- [NTSB ERA23LA331](https://openairdocs.org/ntsb/ERA23LA331.md): Cessna 175 · Wetumpka, AL · Accident · No injuries · Class 3 · Limited · Final report · Aug 11, 2023 · N7117M · Substantial damage
  > A total loss of engine power due to the separation of the No. 3 connecting rod from the crankshaft.
- [NTSB ERA23LA325](https://openairdocs.org/ntsb/ERA23LA325.md): Long Charles Jackson Avid Flyer · Wetumpka, AL · Accident · No injuries · Class 3 · Limited · Final report · Aug 3, 2023 · N3HH · Substantial damage
  > A loss of engine power due to fuel exhaustion because of a leaking fuel drain valve.
- [NTSB ERA23LA286](https://openairdocs.org/ntsb/ERA23LA286.md): Grumman American Avn. AA5A · Redstone Arsenal, AL · Accident · No injuries · Class 3 · Limited · Final report · Jul 4, 2023 · N26387 · Substantial damage
  > The separation of the clamp assembly securing the throttle control cable outer housing, which resulted in the pilot’s inability to control the throttle.
- [NTSB ERA23LA232](https://openairdocs.org/ntsb/ERA23LA232.md): Piper PA28 · Selma, AL · Accident · No injuries · Class 3 · Limited · Final report · May 12, 2023 · N1347T · Substantial damage
  > The pilot’s improper preflight inspection, during which the left wing fuel sump drain was moved to and left in the open and locked position, allowing for fuel to drain during the flight and resulting in a total loss of engine power due to fuel starvation.…
- [NTSB ERA23LA122](https://openairdocs.org/ntsb/ERA23LA122.md): Aero Commander 500 · Sylacauga, AL · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 28, 2023 · N107DF · Substantial damage
  > The pilot’s failure to assure there was an adequate amount of fuel onboard to complete the flight, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA23FA087](https://openairdocs.org/ntsb/ERA23FA087.md): Mooney M20B · Kellyton, AL · Accident · 1 fatal · Class 3 · Field · Final report · Dec 13, 2022 · N74586 · Substantial damage
  > A total loss of engine power due to fuel starvation.
- [NTSB ERA23LA028](https://openairdocs.org/ntsb/ERA23LA028.md): Mcglaughlin Richard Sportsman GS2 · Pell City, AL · Accident · No injuries · Class 4 · Limited · Final report · Oct 14, 2022 · N302BM · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.
- [NTSB ERA22LA380](https://openairdocs.org/ntsb/ERA22LA380.md): Cessna 150 · Berry, AL · Accident · No injuries · Class 3 · Limited · Final report · Aug 20, 2022 · N8797G · Substantial damage
  > A partial loss of engine power due to the No. 3 cylinder’s stuck exhaust valve.
- [NTSB ERA22LA071](https://openairdocs.org/ntsb/ERA22LA071.md): Cessna 210 · Brent, AL · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 21, 2021 · N5779J · Substantial damage
  > The inadequate maintenance of the oil filter adapter, which resulted in in an engine oil leak and subsequent loss engine oil pressure, and the subsequent off-airport landing.
- [NTSB ERA21LA307](https://openairdocs.org/ntsb/ERA21LA307.md): Cessna 150 · Carrollton, AL · Accident · No injuries · Class 4 · Limited · Final report · Jul 1, 2021 · N561QL · Substantial damage
  > The pilot’s incorrect preflight planning and poor in-flight planning, resulting in fuel exhaustion. Contributing to the damage was the inadvertent encounter with a hole during the forced landing.
- [NTSB ERA21LA190](https://openairdocs.org/ntsb/ERA21LA190.md): Cessna 182M · Eufaula, AL · Accident · No injuries · Class 3 · Limited · Final report · Apr 20, 2021 · N91606 · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA21FA010](https://openairdocs.org/ntsb/ERA21FA010.md): Czech Sport Cruiser · Waterloo, AL · Accident · 1 fatal · Class 3 · Field · Final report · Oct 7, 2020 · N251SC · Substantial damage
  > The 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.
- [NTSB ERA20LA314](https://openairdocs.org/ntsb/ERA20LA314.md): Zenair CH750 Cruzer · Boaz, AL · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 10, 2020 · N656BN · Substantial damage
  > The 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.
- [NTSB ERA20LA262](https://openairdocs.org/ntsb/ERA20LA262.md): Beech F33 · Malbis, AL · Accident · 2 fatal · Class 3 · Limited · Final report · Jul 29, 2020 · N3156W · Substantial damage
  > The 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…
- [NTSB ERA20LA212](https://openairdocs.org/ntsb/ERA20LA212.md): Piper PA32RT · Selma, AL · Accident · 2 fatal · Class 3 · Limited · Final report · Jun 10, 2020 · N543GS · Destroyed
  > The 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.
- [NTSB ERA20LA194](https://openairdocs.org/ntsb/ERA20LA194.md): Bellanca 8KCAB · Rainbow City, AL · Accident · No injuries · Class 3 · Limited · Final report · May 22, 2020 · N68555 · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB ERA20LA161](https://openairdocs.org/ntsb/ERA20LA161.md): Keuthan Buccaneer II · Coden, AL · Accident · No injuries · Class 3 · Limited · Final report · Apr 24, 2020 · N43310 · Substantial damage
  > A total loss of engine power due to carburetor icing. Contributing to the accident was the lack of a carburetor heat system installed on the engine.
- [NTSB CEN20FA009](https://openairdocs.org/ntsb/CEN20FA009.md): Vans RV-8 · White Plains, AL · Accident · 1 fatal · Class 3 · Field · Final report · Oct 20, 2019 · N249BW · Destroyed
  > Impact with terrain for reasons that could not be determined based on the available information.
- [NTSB ERA19LA264](https://openairdocs.org/ntsb/ERA19LA264.md): Cirrus SR22 · Foley, AL · Accident · No injuries · Class 3 · Limited · Final report · Sep 1, 2019 · N878SR · Substantial damage
  > Total loss of engine power due to a fatigue failure of the camshaft gear.
- [NTSB ERA19TA254](https://openairdocs.org/ntsb/ERA19TA254.md): GIger Frank R Nieuport II · Talladega, AL · Accident · Minor injuries · Class 3 · Final report · Aug 17, 2019 · N112GV · Substantial damage
  > A total loss of engine power due to fuel exhaustion after the pilot inadvertently kicked a fuel line during turbulence, which resulted in a forced landing into trees.
- [NTSB CEN19LA265](https://openairdocs.org/ntsb/CEN19LA265.md): Piper PA28 · Fairhope, AL · Accident · No injuries · Class 3 · Limited · Final report · Jul 30, 2019 · N6754J · Substantial damage
  > Failure of the No. 3 exhaust valve and the subsequent loss of engine power due to engine operation with an excessively lean fuel mixture over a period of time.
- [NTSB ERA18LA177](https://openairdocs.org/ntsb/ERA18LA177.md): Crawford RV-7 · Alexander City, AL · Accident · No injuries · Limited investigation · Final report · Jun 24, 2018 · N19MM · Destroyed
  > A total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA18LA161](https://openairdocs.org/ntsb/ERA18LA161.md): Robinson Helicopter R44 II · Fort Morgan, AL · Accident · No injuries · Limited investigation · Final report · Jun 7, 2018 · N755KT · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident engine examinations did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA18FA146](https://openairdocs.org/ntsb/ERA18FA146.md): Beech 35A33 · Jacksonville, AL · Accident · 1 fatal · Field investigation · Final report · May 13, 2018 · N486T · Destroyed
  > The 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…
- [NTSB WPR18LA142](https://openairdocs.org/ntsb/WPR18LA142.md): Kolb Firestar · Atmore, AL · Accident · Serious injuries · Limited investigation · Final report · May 11, 2018 · N9216E · Substantial damage
  > The noncertificated pilot's failure to maintain airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of flight experience and qualification.
- [NTSB CEN18LA151](https://openairdocs.org/ntsb/CEN18LA151.md): Cessna 152 · Cullman, AL · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 2018 · N89904 · Substantial damage
  > The pilot’s inadvertent engine shutdown due to excessive leaning of the engine and his subsequent inability to restart the engine.
- [NTSB ERA18FA118](https://openairdocs.org/ntsb/ERA18FA118.md): Cessna R182 · Ashville, AL · Accident · 1 fatal · Field investigation · Final report · Mar 28, 2018 · N3167C · Destroyed
  > Descent and impact with terrain for reasons that could not be determined.
- [NTSB ERA18LA041](https://openairdocs.org/ntsb/ERA18LA041.md): Piper PA28 · Brewton, AL · Accident · No injuries · Limited investigation · Final report · Dec 5, 2017 · N747KM · Substantial damage
  > The pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ANC18LA008](https://openairdocs.org/ntsb/ANC18LA008.md): Cloud Jeffrey Ferrell Long EZ · Eufaula, AL · Accident · No injuries · Limited investigation · Final report · Nov 11, 2017 · N754T · Substantial damage
  > The in-flight separation of a portion of the propeller, which subsequently penetrated the right rudder, as a result of the failure of the bond line between two of the propeller’s wood layers. Contributing to the failure of the propeller was the manufacturer’s…
- [NTSB ERA17LA302](https://openairdocs.org/ntsb/ERA17LA302.md): Pacific Aerospace 750XL · Harvest, AL · Accident · No injuries · Limited investigation · Final report · Aug 28, 2017 · N750UP · Substantial damage
  > The pilot's improper decision to not stop and refuel the airplane as planned and his improper in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB GAA17CA427](https://openairdocs.org/ntsb/GAA17CA427.md): Let L23 · Deatsville, AL · Accident · Minor injuries · Data collection · Final report · Jul 21, 2017 · N342BA · Substantial damage
  > The student pilot’s failure to maintain clearance from trees and power lines while landing.
- [NTSB ERA17FA140](https://openairdocs.org/ntsb/ERA17FA140.md): Beech A36 · Dadeville, AL · Accident · 2 fatal · Field investigation · Final report · Mar 28, 2017 · N8169Y · Destroyed
  > A 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…
- [NTSB ERA17LA006](https://openairdocs.org/ntsb/ERA17LA006.md): Piper PA24 · Hollywood, AL · Accident · No injuries · Limited investigation · Final report · Oct 6, 2016 · N8560P · Substantial damage
  > A failure of the fuel tank selector valve in a partially closed position, which resulted in fuel starvation to the engine and a total loss of engine power.
- [NTSB ERA16FA289](https://openairdocs.org/ntsb/ERA16FA289.md): Piper PA 31 · Northport, AL · Accident · 6 fatal · Field investigation · Final report · Aug 14, 2016 · N447SA · Substantial damage
  > A 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…
- [NTSB GAA16CA078](https://openairdocs.org/ntsb/GAA16CA078.md): Cessna 525 · Monroeville, AL · Accident · No injuries · Data collection · Final report · Nov 6, 2015 · N525DY · Substantial damage
  > An inadvertent collision with a bird during takeoff enroute climb, which resulted in substantial damage to the right wing.
- [NTSB ERA15LA345](https://openairdocs.org/ntsb/ERA15LA345.md): Piper PA 28R-201T · Atmore, AL · Accident · No injuries · Limited investigation · Final report · Sep 7, 2015 · N44903 · Substantial damage
  > A total loss of engine power due to oil starvation caused by insufficiently torqued cylinder through bolt nuts, which caused bearings to shift and led to the subsequent failure of the No. 3 connecting rod.
- [NTSB ERA15LA232](https://openairdocs.org/ntsb/ERA15LA232.md): Beech A23 24 · Grove Hill, AL · Accident · No injuries · Limited investigation · Final report · Jun 1, 2015 · N29JR · Substantial damage
  > A total loss of engine power for reasons that could not be determined because engine examination and testing did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA15FA178](https://openairdocs.org/ntsb/ERA15FA178.md): Hughes 369D · Cherokee, AL · Accident · 1 fatal · Field investigation · Final report · Apr 6, 2015 · N555JC · Substantial damage
  > The 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…
- [NTSB ERA14LA369](https://openairdocs.org/ntsb/ERA14LA369.md): Piper PA-32-300 · Helena, AL · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 2014 · N9103K · Destroyed
  > A total loss of engine power for reasons that could not be determined due to postcrash fire damage.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?state=AL&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."eventStateOrRegion" = 'AL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?state=AL

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