# NTSB investigations, AL: Approach

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 7 · 315 cases

## Latest cases

- [NTSB ERA26LA190](https://openairdocs.org/ntsb/ERA26LA190.md): Piper PA-30 · Enterprise, AL · Accident · No injuries · Class 4 · Limited · Final report · Apr 26, 2026 · N8432Y · Substantial damage
  > The pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing into trees.
- [NTSB ERA26LA043](https://openairdocs.org/ntsb/ERA26LA043.md): Beech 95-B55 · Dothan, AL · Accident · No injuries · Class 4 · Limited · Final report · Nov 14, 2025 · N711FA · Substantial damage
  > The failure of the left main landing gear actuator rods, which resulted in a gear up landing.
- [NTSB ERA25LA313](https://openairdocs.org/ntsb/ERA25LA313.md): Raytheon A36 · Gulf Shores, AL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 24, 2025 · N855DC · Substantial damage
  > On August 24, 2025, about 1500 eastern daylight time, a Raytheon Aircraft Company A36, N855DC, was substantially damaged when it was involved in an accident near Gulf Shores, Alabama. The pilot and passenger were seriously injured. The airplane was operated…
- [NTSB DCA25LA241](https://openairdocs.org/ntsb/DCA25LA241.md): Boeing 737-8H4 · Barlow Bend, AL · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 18, 2025 · N8685B · No damage
  > The airplane’s encounter with unanticipated turbulence during descent, resulting in a serious injury to a flight attendant.
- [NTSB ERA24LA349](https://openairdocs.org/ntsb/ERA24LA349.md): Smith T Gunter Quick Silver SP II · Mobile, AL · Accident · No injuries · Class 4 · Limited · Final report · Aug 16, 2024 · N2342D · Substantial damage
  > The pilot’s failure to maintain control of the airplane in gusty wind conditions while flying low over water, which resulted in the floats impacting a wave and the airplane’s subsequent nose over into the water.
- [NTSB ERA24LA047](https://openairdocs.org/ntsb/ERA24LA047.md): Mooney M20F · Meridianville, AL · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 22, 2023 · N9339M · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while on final approach to land, which resulted in an aerodynamic stall, a loss of airplane control, and impact with terrain.
- [NTSB ERA23LA054](https://openairdocs.org/ntsb/ERA23LA054.md): Piper PA-28 · Tanner, AL · Accident · No injuries · Class 4 · Limited · Final report · Nov 2, 2022 · N8667W · Substantial damage
  > The pilot’s inadequate inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA22LA417](https://openairdocs.org/ntsb/ERA22LA417.md): Piper PA-28R-200 · Meridianville, AL · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 8, 2022 · N29RM · Substantial damage
  > A loss of engine power that could not be determined based on the available evidence.
- [NTSB ERA22FA343](https://openairdocs.org/ntsb/ERA22FA343.md): Eurocopter AS350 · Andalusia, AL · Accident · Serious injuries · Class 3 · Field · Final report · Jul 29, 2022 · N124LN · Substantial damage
  > The pilot’s acute incapacitation by a syncopal episode, which resulted in the helicopter departing controlled flight and colliding with terrain.
- [NTSB ERA22LA321](https://openairdocs.org/ntsb/ERA22LA321.md): Cessna 150G · Tuscaloosa, AL · Accident · No injuries · Class 4 · Limited · Final report · Jul 15, 2022 · N3301J · Substantial damage
  > The student pilot’s inadvertent use of the fuel mixture knob instead of the carburetor heat knob, which resulted in fuel starvation and a subsequent loss of engine power.
- [NTSB ERA22LA213](https://openairdocs.org/ntsb/ERA22LA213.md): Vans RV7 · Huntsville, AL · Accident · Serious injuries · Class 3 · Limited · Final report · May 1, 2022 · N1218B · Substantial damage
  > The pilot’s impairment due to the effects of ethanol, which resulted in a loss of airplane control and an impact with terrain on approach to landing.
- [NTSB ERA22LA092](https://openairdocs.org/ntsb/ERA22LA092.md): Beech D55 · Hamilton, AL · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 21, 2021 · N44DC · Substantial damage
  > The pilot’s failure to properly configure the airplane’s fuel system, which resulted in a loss of engine power on the left engine due to fuel starvation.
- [NTSB ERA21LA347](https://openairdocs.org/ntsb/ERA21LA347.md): Quad City Challenger · Geneva, AL · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 1, 2021 · N1225G · Substantial damage
  > A total loss of engine power for reasons that could not be determined.
- [NTSB ERA21LA345](https://openairdocs.org/ntsb/ERA21LA345.md): Maule MXT-7-180 · Troy, AL · Accident · No injuries · Class 4 · Limited · Final report · Aug 28, 2021 · N32566 · Substantial damage
  > The pilot's failure to maintain directional control while landing which resulted in a collision with terrain.
- [NTSB ERA21LA216](https://openairdocs.org/ntsb/ERA21LA216.md): Cessna 172 · Gulf Shores, AL · Accident · No injuries · Class 4 · Limited · Final report · May 13, 2021 · N5170K · Substantial damage
  > The flight instructor’s delayed remedial action, which resulted in a loss of control during an attempted go-around.
- [NTSB ERA21FA133](https://openairdocs.org/ntsb/ERA21FA133.md): Piper PA32RT · Vinemont, AL · Accident · 2 fatal · Class 3 · Field · Final report · Feb 20, 2021 · N10KV · Destroyed
  > A loss of engine power for reasons that could not be determined.
- [NTSB ERA21LA107](https://openairdocs.org/ntsb/ERA21LA107.md): Extra Flugzeugbau EA 300/L · Pell City, AL · Accident · No injuries · Class 3 · Limited · Final report · Jan 13, 2021 · N771JP · Substantial damage
  > The pilot's mismanagement of the fuel supply, which resulted in fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer’s engine restart procedures after a total loss of engine power and his incomplete preflight…
- [NTSB ERA20LA164](https://openairdocs.org/ntsb/ERA20LA164.md): Piper PA32RT · Meridianville, AL · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 27, 2020 · N772SG · Substantial damage
  > The pilot's slip maneuver with a less than full fuel tank selected, which resulted in unporting of the fuel supply, and a total loss of engine power due to fuel starvation.
- [NTSB ERA20CA116](https://openairdocs.org/ntsb/ERA20CA116.md): Let L 23 Super Blanik · Huntsville, AL · Accident · Serious injuries · Data collection · Final report · Mar 1, 2020 · N296BA · Substantial damage
  > The pilot's failure to maintain glider control and his exceedance of the glider's critical angle of attack while maneuvering in gusting wind conditions, which resulted in an aerodynamic stall.
- [NTSB ERA20FA056](https://openairdocs.org/ntsb/ERA20FA056.md): Bell 407 · Headland, AL · Accident · 1 fatal · Class 3 · Field · Final report · Dec 25, 2019 · N663SF · Substantial damage
  > Pilot incapacitation by a sudden cardiac event related to severe coronary artery disease, which resulted in a loss of helicopter control.
- [NTSB ERA19LA260](https://openairdocs.org/ntsb/ERA19LA260.md): DG Flugzeugbau DG-500MB · Robertsdale, AL · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 24, 2019 · N165MB · Substantial damage
  > Impact with trees during the landing approach for reasons that could not be determined based on the available information.
- [NTSB ERA19LA202](https://openairdocs.org/ntsb/ERA19LA202.md): Aeronca S7EC · Jasper, AL · Accident · No injuries · Class 3 · Limited · Final report · Jun 21, 2019 · N4349C · Substantial damage
  > A total loss of engine power due to fuel contamination.
- [NTSB GAA18CA503](https://openairdocs.org/ntsb/GAA18CA503.md): Champion 8GCBC · Elberta, AL · Accident · Minor injuries · Data collection · Final report · Aug 22, 2018 · N88287 · Substantial damage
  > The pilot's failure to use carburetor heat during a low-power setting approach in conditions conducive to carburetor icing, which resulted in a partial loss of engine power.
- [NTSB ERA17LA341](https://openairdocs.org/ntsb/ERA17LA341.md): Cessna 162 · Huntsville, AL · Accident · No injuries · Limited investigation · Final report · Sep 28, 2017 · N552ES · Substantial damage
  > The flight instructor’s failure to use carburetor heat, which resulted in the total loss of engine power due to carburetor icing.
- [NTSB ERA17LA125](https://openairdocs.org/ntsb/ERA17LA125.md): Grob G120TP-A · Abbeville, AL · Accident · Serious injuries · Class 2 · Limited · Final report · Mar 8, 2017 · N196TP · Substantial damage
  > The flame-out of the engine due to a mis-set fuel control unit at the time of manufacture. Contributing to the accident was the pilots’ delayed recognition that the engine had flamed out, partially due to the operator’s requirement to disable the crew…
- [NTSB ERA17LA105](https://openairdocs.org/ntsb/ERA17LA105.md): S C Aerostar S A YAK 52 · St. Elmo, AL · Accident · No injuries · Limited investigation · Final report · Feb 1, 2017 · N624PT · Substantial damage
  > The failure of the right main landing gear uplock actuator due to corrosion.
- [NTSB ERA17CA087](https://openairdocs.org/ntsb/ERA17CA087.md): Cessna 170 · Hayden, AL · Accident · Serious injuries · Data collection · Final report · Jan 12, 2017 · N1387D · Substantial damage
  > The pilot’s failure to maintain clearance from trees during the approach.
- [NTSB ERA16FA100](https://openairdocs.org/ntsb/ERA16FA100.md): Cessna 182 · Mobile, AL · Accident · 2 fatal · Field investigation · Final report · Feb 2, 2016 · N784CP · Destroyed
  > The pilot's loss of airplane control during a missed approach in instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot's inadequate preflight and inflight weather planning which resulted the pilot's…
- [NTSB ERA15FA330](https://openairdocs.org/ntsb/ERA15FA330.md): Cirrus Design SR22 · Alabaster, AL · Accident · 1 fatal · Field investigation · Final report · Aug 28, 2015 · N1116C · Substantial damage
  > An in-flight loss of airplane control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA15LA296](https://openairdocs.org/ntsb/ERA15LA296.md): Bell 47G 3B 1 · Camden, AL · Accident · No injuries · Limited investigation · Final report · Aug 3, 2015 · N4002G · Substantial damage
  > A failure of the helicopter's hydraulic flight control systems for reasons that could not be determined due to the fire damage, and the pilot's inability to turn off the hydraulic system to relieve control pressure.
- [NTSB ERA15CA176](https://openairdocs.org/ntsb/ERA15CA176.md): Beech V35B · Wetumpka, AL · Accident · Serious injuries · Data collection · Final report · Apr 4, 2015 · N9172Q · Substantial damage
  > The pilot's use of an incorrect radio frequency when attempting to turn on the runway lights, resulting is an attempt to land the airplane while aligned with airport hangar lights.
- [NTSB ERA15CA064](https://openairdocs.org/ntsb/ERA15CA064.md): Piper PA 28-180 · Athens, AL · Accident · Serious injuries · Data collection · Final report · Nov 30, 2014 · N7422W · Substantial damage
  > The pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.
- [NTSB ERA14LA325](https://openairdocs.org/ntsb/ERA14LA325.md): Piper PA 24-250 · Monroeville, AL · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 2014 · N5923P · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.
- [NTSB ERA14CA206](https://openairdocs.org/ntsb/ERA14CA206.md): Cessna 172I · Huntsville, AL · Accident · No injuries · Data collection · Final report · Apr 22, 2014 · N35553 · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB ERA14LA147](https://openairdocs.org/ntsb/ERA14LA147.md): Cessna 172D · Fairhope, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 8, 2014 · N2755U · Destroyed
  > The pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.
- [NTSB ERA14FA120](https://openairdocs.org/ntsb/ERA14FA120.md): Cessna 210L · Clay, AL · Accident · 2 fatal · Field investigation · Final report · Feb 15, 2014 · N732EJ · Destroyed
  > The pilot's failure to maintain control of the airplane while being vectored to intercept the localizer during night instrument meteorological conditions (IMC). Contributing to the accident was the operator's inadequate dispatch procedures, which did not…
- [NTSB ERA14LA099](https://openairdocs.org/ntsb/ERA14LA099.md): Bell 47D1 · Pell City, AL · Accident · Minor injuries · Limited investigation · Final report · Jan 21, 2014 · N93067 · Substantial damage
  > The pilot’s use of an improper clutch engagement procedure, which resulted in clutch glazing, slippage, and, ultimately, the in-flight disengagement of the clutch and a loss of rotor rpm. Contributing to the accident were the installation of a light-weight…
- [NTSB ERA14LA052](https://openairdocs.org/ntsb/ERA14LA052.md): Beech V35 · Trussville, AL · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 2013 · N5655D · Substantial damage
  > The failure of the No. 2 connecting rod due to oil starvation, which resulted in a total loss of engine power.
- [NTSB DCA13MA133](https://openairdocs.org/ntsb/DCA13MA133.md): Airbus A300 - F4 622R · Birmingham, AL · Accident · 2 fatal · Class 1 · Major · Final report · Aug 14, 2013 · N155UP · Destroyed
  > the flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…
- [NTSB ERA13CA284](https://openairdocs.org/ntsb/ERA13CA284.md): Piper PA-28-140 · Ozark, AL · Accident · No injuries · Data collection · Final report · Jun 8, 2013 · N6881W · Substantial damage
  > The student pilot’s failure to maintain control of the airplane during the aborted landing.
- [NTSB ERA13LA012](https://openairdocs.org/ntsb/ERA13LA012.md): Cirrus Design SR22 · Birmingham, AL · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 2012 · N80KW · Substantial damage
  > The pilot's failure to maintain airplane control during a missed approach in instrument meteorological conditions. Contributing to the accident was the pilot's overreliance on the autopilot system and his inability to hand-fly the airplane once the autopilot…
- [NTSB ERA12LA562](https://openairdocs.org/ntsb/ERA12LA562.md): Republic RC-3 · Cedar Bluff, AL · Accident · 1 fatal · Limited investigation · Final report · Sep 15, 2012 · N6072K · Substantial damage
  > The pilot's failure to see and avoid power lines during final approach to landing.
- [NTSB ERA12CA396](https://openairdocs.org/ntsb/ERA12CA396.md): Cessna 150M · Gulf Shores, AL · Accident · No injuries · Data collection · Final report · Jun 14, 2012 · N9119U · Substantial damage
  > The student pilot's improper flight control inputs and the flight instructor's delayed remedial action during the attempted go-around, which resulted in an aerodynamic stall.
- [NTSB ERA12LA273](https://openairdocs.org/ntsb/ERA12LA273.md): Cessna T337B · Dothan, AL · Accident · No injuries · Limited investigation · Final report · Mar 24, 2012 · N2334S · Substantial damage
  > The failure of the landing gear to extend and lock, despite troubleshooting attempts using normal and emergency procedures. The reason for the failure could not be determined because the systems were unavailable for testing.
- [NTSB ERA12CA096](https://openairdocs.org/ntsb/ERA12CA096.md): Thompson Tommy W Loehle P5151 · Courtland, AL · Accident · Serious injuries · Data collection · Final report · Dec 4, 2011 · N212WE · Substantial damage
  > The airplane's inadvertent encounter with excessive windshear while on the downwind traffic pattern leg at low altitude, which resulted in the pilot's inability to arrest the airplane’s descent. Contributing to the accident was the pilot's decision to fly the…
- [NTSB ERA11FA391](https://openairdocs.org/ntsb/ERA11FA391.md): Cessna 421C · Demopolis, AL · Accident · 7 fatal · Field investigation · Final report · Jul 9, 2011 · N692TT · Substantial damage
  > The pilot's failure to maintain airplane control during a single-engine approach and his failure to fly an appropriate traffic pattern for a single-engine landing. Contributing to the accident was a total loss of engine power on the right engine due to a…
- [NTSB ERA11FA360](https://openairdocs.org/ntsb/ERA11FA360.md): Clabaugh Robert R Barracuda · Andalusia, AL · Accident · 1 fatal · Field investigation · Final report · Jun 26, 2011 · N289DH · Substantial damage
  > The pilot did not maintain airspeed while maneuvering on approach for landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.
- [NTSB ERA11CA353](https://openairdocs.org/ntsb/ERA11CA353.md): Head Balloons AX8-88 · Summerdale, AL · Accident · No injuries · Data collection · Final report · Jun 18, 2011 · N8190V · Substantial damage
  > The balloon pilot's failure to maintain proper altitude/clearance from a tree line during the landing approach.
- [NTSB ERA11LA175](https://openairdocs.org/ntsb/ERA11LA175.md): Bell 206-L4 · Birmingham, AL · Accident · No injuries · Limited investigation · Final report · Mar 2, 2011 · N154MW · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ERA11FA107](https://openairdocs.org/ntsb/ERA11FA107.md): Beech 58P · Birmingham, AL · Accident · 1 fatal · Field investigation · Final report · Jan 6, 2011 · N48TS · Substantial damage
  > The pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.

Next page: https://openairdocs.org/ntsb-phases/500/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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/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.