# NTSB investigations, AL: Maneuvering

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 8 · 362 cases

## Latest cases

- [NTSB ERA26FA338](https://openairdocs.org/ntsb/ERA26FA338.md): Reed Julian Estill RV-4 · Albertville, AL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 15, 2026 · N469TW · Substantial damage
  > On September 15, 2026, about 0620 central daylight time, an experimental amateur-built RV-4, N469TW, was substantially damaged when it was involved in an accident near Albertville, Alabama. The pilot was fatally injured. The airplane was operated as a Title…
- [NTSB ERA24LA114](https://openairdocs.org/ntsb/ERA24LA114.md): Cessna 172M · Brookwood, AL · Accident · 1 fatal · Class 3 · Limited · Final report · Feb 16, 2024 · N9160H · Substantial damage
  > The pilot’s failure to see and avoid powerlines while maneuvering at low altitude.
- [NTSB ERA24LA083](https://openairdocs.org/ntsb/ERA24LA083.md): Rabe Richard Exec 162F · Tuscumbia, AL · Accident · No injuries · Class 4 · Limited · Final report · Dec 16, 2023 · N60932 · Substantial damage
  > The pilot’s failure to maintain control of the helicopter, which resulted in the right skid contacting the ground and a subsequent rollover.
- [NTSB ERA24LA060](https://openairdocs.org/ntsb/ERA24LA060.md): Cessna 150 · Mount Vernon, AL · Accident · No injuries · Class 4 · Limited · Final report · Dec 8, 2023 · N5952T · Substantial damage
  > The pilot’s decision to operate the airplane at a low altitude over a river, and his failure to maintain clearance from the river while maneuvering.
- [NTSB ERA24FA055](https://openairdocs.org/ntsb/ERA24FA055.md): Beech E95 · Elkmont, AL · Accident · 2 fatal · Class 3 · Field · Final report · Dec 4, 2023 · N369BB · Substantial damage
  > The flight instructor’s failure to maintain control of the airplane during slow flight, which resulted in an aerodynamic stall and spin from which he was unable to recover.
- [NTSB ERA23FA382](https://openairdocs.org/ntsb/ERA23FA382.md): Smith William S Smith Cozy Mark IV · Cullman, AL · Accident · 1 fatal · Class 3 · Field · Final report · Sep 29, 2023 · N95SF · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot/owner’s improper installation of engine…
- [NTSB ERA23FA254](https://openairdocs.org/ntsb/ERA23FA254.md): Zenith 601XL · Albertville, AL · Accident · 1 fatal · Class 3 · Field · Final report · Jun 3, 2023 · N601YP · Substantial damage
  > A descent and impact with terrain for reasons that could not be determined.
- [NTSB ERA23FA175](https://openairdocs.org/ntsb/ERA23FA175.md): Airbus Helicopters EC 130 T2 · Chelsea, AL · Accident · 2 fatal · Class 3 · Field · Final report · Apr 2, 2023 · N231SH · Substantial damage
  > The pilot’s delayed corrective inputs while maneuvering, which resulted in a loss of control. Contributing to the accident was the pilot’s use of multiple sedating medications.
- [NTSB ERA21LA269](https://openairdocs.org/ntsb/ERA21LA269.md): Garlick Helicopters OH-58A+ · Alpine, AL · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 25, 2021 · N372NS · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines during a low-level aerial application flight, resulting in main rotor blade impact with a fiber-optic cable, a loss of control, and the helicopter’s subsequent impact with terrain.
- [NTSB ERA21LA217](https://openairdocs.org/ntsb/ERA21LA217.md): Cessna 150 · Brewton, AL · Accident · No injuries · Class 4 · Limited · Final report · May 15, 2021 · N3396J · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with the ground.
- [NTSB ERA21LA068](https://openairdocs.org/ntsb/ERA21LA068.md): Beech V35A · Attalla, AL · Accident · 1 fatal · Class 3 · Limited · Final report · Dec 12, 2020 · N5470U · Destroyed
  > A loss of control inflight and the failure of a component of the up elevator flight control system due to fatigue, which rendered recovery from a right descending turn improbable.
- [NTSB ERA20LA217](https://openairdocs.org/ntsb/ERA20LA217.md): Air Tractor AT502 · Atmore, AL · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 16, 2020 · N879JA · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, spin, and loss of control.
- [NTSB ERA19LA263](https://openairdocs.org/ntsb/ERA19LA263.md): Weatherly 620 · Russellville, AL · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 2, 2019 · N90104 · Destroyed
  > The pilot's failure to see and avoid powerlines during low-altitude agricultural spraying flight operations.
- [NTSB ERA19FA047](https://openairdocs.org/ntsb/ERA19FA047.md): Bell OH 58C · Verbena, AL · Accident · 2 fatal · Class 2 · Field · Final report · Nov 16, 2018 · N510CP · Substantial damage
  > The pilot's improper decision to conduct a low-level flight over a river, and his failure to see and avoid power lines, which resulted in the helicopter's impact with power lines and the water.
- [NTSB ERA18LA195](https://openairdocs.org/ntsb/ERA18LA195.md): Eagle DW1 · Ider, AL · Accident · No injuries · Limited investigation · Final report · Jul 18, 2018 · N8805X · Substantial damage
  > Fatigue failure of the No. 2 cylinder studs/through bolts and the fracture of the crankcase, which resulted in a total loss of engine power.
- [NTSB WPR18LA144](https://openairdocs.org/ntsb/WPR18LA144.md): Ryan Navion · Jasper, AL · Accident · No injuries · Limited investigation · Final report · May 21, 2018 · N4356K · 2 aircraft · Substantial damage
  > The other pilot's failure to maintain clearance from another airplane in the formation flight due to sun glare.
- [NTSB ERA17FA136](https://openairdocs.org/ntsb/ERA17FA136.md): Cessna T210 · Hayden, AL · Accident · 4 fatal · Field investigation · Final report · Mar 25, 2017 · N6563D · Destroyed
  > The pilot's decision to continue the flight into known adverse weather conditions, which resulted in spatial disorientation and a subsequent loss of airplane control and in-flight breakup.
- [NTSB ERA17LA075](https://openairdocs.org/ntsb/ERA17LA075.md): Cessna 172 · Bridgeport, AL · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2016 · N3772F · Substantial damage
  > The pilot's decision to make steep turns to the right while operating on the right fuel tank with low fuel quantity, which led to a loss of engine power due to unporting of the right fuel tank and fuel starvation.
- [NTSB ERA16LA015](https://openairdocs.org/ntsb/ERA16LA015.md): Bell 206L 3 · Dickinson, AL · Accident · No injuries · Limited investigation · Final report · Oct 15, 2015 · N206CJ · Substantial damage
  > The improper installation by company maintenance personnel of the securing hardware of a tail rotor driveshaft section, which resulted in that section of tail rotor driveshaft disconnecting and a complete loss of tail rotor thrust.
- [NTSB GAA15LA296](https://openairdocs.org/ntsb/GAA15LA296.md): Bell 206 · Ozark, AL · Accident · No injuries · Limited investigation · Final report · Sep 24, 2015 · N49660 · Substantial damage
  > The pilot's failure to maintain clearance from terrain while hovering, which resulted in the helicopter's skid impacting terrain, subsequent abnormal airframe vibrations, and a hard landing during the subsequent hovering autorotation.
- [NTSB ERA15LA172](https://openairdocs.org/ntsb/ERA15LA172.md): Merian Richard F RV 8 · Tuscaloosa, AL · Accident · No injuries · Class 3 · Limited · Final report · Mar 29, 2015 · N8JL · 2 aircraft · Substantial damage
  > The RV-8 pilot's failure to maintain adequate clearance from the RV-6 while maneuvering during an air show, which resulted in a midair collision.
- [NTSB ERA15CA055](https://openairdocs.org/ntsb/ERA15CA055.md): Mcdonnell Douglas Helicopter MD500 · Decatur, AL · Accident · No injuries · Data collection · Final report · Nov 18, 2014 · N8371F · Substantial damage
  > An undetermined pilot's failure to maintain clearance from an electrical transmission tower resulting in substantial damage to a main rotor blade. Postaccident investigation could not determine which of two pilots was flying the helicopter at the time the…
- [NTSB ERA15CA018](https://openairdocs.org/ntsb/ERA15CA018.md): Bell 206B · Prattville, AL · Accident · No injuries · Data collection · Final report · Oct 16, 2014 · N59541 · Substantial damage
  > The pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA14FA396](https://openairdocs.org/ntsb/ERA14FA396.md): Mcdonnell Douglas Helicopter 369E · Northport, AL · Accident · 2 fatal · Field investigation · Final report · Aug 19, 2014 · N444RS · Substantial damage
  > An inadvertent collision with a utility wire for reasons that could not be determined from recorded data and examination of the helicopter and accident site.
- [NTSB ERA14LA391](https://openairdocs.org/ntsb/ERA14LA391.md): Let L 23 Super Blanik · Sylacauga, AL · Accident · Serious injuries · Limited investigation · Final report · Aug 17, 2014 · N266SE · Substantial damage
  > The student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and spin. Contributing to the accident was the student pilot's failure to properly assess her physical condition prior to conducting the flight.
- [NTSB ERA14FA350](https://openairdocs.org/ntsb/ERA14FA350.md): Wilderoder Great Lakes 2TIA · Lillian, AL · Accident · 2 fatal · Field investigation · Final report · Jul 23, 2014 · N47149 · Substantial damage
  > A loss of engine power due to an inoperative magneto and possible carburetor ice, which resulted in a forced landing into unsuitable terrain. Contributing to the accident was an inadequate magneto overhaul by unknown personnel and the modification to the…
- [NTSB ERA14TA326](https://openairdocs.org/ntsb/ERA14TA326.md): Cessna 336 · Mobile, AL · Accident · Serious injuries · Final report · Jul 3, 2014 · N3804U · Substantial damage
  > The pilot’s inadequate preflight fuel planning during which he did not ensure that there was adequate fuel in the main tanks for the flight, which resulted in a loss of engine power.
- [NTSB ERA14LA057](https://openairdocs.org/ntsb/ERA14LA057.md): Piper PA-28-161 · Elkmont, AL · Accident · 1 fatal · Limited investigation · Final report · Nov 30, 2013 · N8878E · Destroyed
  > A stuck exhaust valve, which resulted in a total loss of engine power at low altitude. Contributing to the accident were the pilot’s decision to fly at a low altitude, which reduced his forced landing options when the loss of engine power occurred; and poor…
- [NTSB ERA13CA163](https://openairdocs.org/ntsb/ERA13CA163.md): Air Tractor AT-301 · Greenbrier, AL · Accident · No injuries · Data collection · Final report · Feb 24, 2013 · N7310N · Substantial damage
  > The pilot’s failure to maintain adequate clearance from trees.
- [NTSB ERA12FA565](https://openairdocs.org/ntsb/ERA12FA565.md): Yakovlev YAK 52 · Brownsboro, AL · Accident · 2 fatal · Field investigation · Final report · Sep 16, 2012 · N2207X · Substantial damage
  > The pilot's loss of control while performing a low-level aerobatic maneuver, which resulted in collision with terrain.
- [NTSB ERA12FA194](https://openairdocs.org/ntsb/ERA12FA194.md): Strout Frank Aventura II · Laceys Spring, AL · Accident · 2 fatal · Field investigation · Final report · Feb 26, 2012 · N1193S · Substantial damage
  > The pilot's failure to maintain control of the airplane during a low-altitude maneuver. Contributing to the accident was the pilot's lack of the required rating to operate the airplane.
- [NTSB ERA11LA167](https://openairdocs.org/ntsb/ERA11LA167.md): Cessna 182F · Auburn, AL · Accident · Minor injuries · Limited investigation · Final report · Feb 27, 2011 · N3420U · Substantial damage
  > A loss of engine power due to an internal failure of the muffler that was not detected by maintenance personnel.
- [NTSB ERA11LA135](https://openairdocs.org/ntsb/ERA11LA135.md): Belcher William B II Firestar · West Blocton, AL · Accident · Serious injuries · Limited investigation · Final report · Feb 6, 2011 · N43341 · Substantial damage
  > The student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.
- [NTSB ERA11FA074](https://openairdocs.org/ntsb/ERA11FA074.md): Beech A36 · Theodore, AL · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2010 · N1860P · Substantial damage
  > The pilot's failure to maintain aircraft control while maneuvering at night in deteriorating weather conditions due to spatial disorientation. Contributing to the accident was the pilot's failure to obtain a weather briefing.
- [NTSB ERA09LA455](https://openairdocs.org/ntsb/ERA09LA455.md): Schempp-Hirth Ventus 2CM · St. Elmo, AL · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 2009 · N70ZZ · Substantial damage
  > A partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain adequate airspeed during the forced landing.
- [NTSB ERA09LA302](https://openairdocs.org/ntsb/ERA09LA302.md): Hazelwood Michael S RV-8 · Decatur, AL · Accident · 1 fatal · Limited investigation · Final report · May 23, 2009 · N875MH · 2 aircraft · Substantial damage
  > The RV-8 pilot's failure to maintain adequate clearance from the CJ-6A while maneuvering. This report was modified on September 10, 2010.
- [NTSB NYC08CA309](https://openairdocs.org/ntsb/NYC08CA309.md): Bell 206B · Eutaw, AL · Accident · No injuries · Data collection · Final report · Sep 9, 2008 · N206WA · Substantial damage
  > The pilot's inadequate preflight inspection.
- [NTSB MIA08CA137](https://openairdocs.org/ntsb/MIA08CA137.md): Air Tractor AT-402B · Muscle Shoals, AL · Accident · No injuries · Data collection · Final report · Jun 12, 2008 · N402BT · Substantial damage
  > The pilot's failure to maintain clearance from utility wires during low altitude maneuvers.
- [NTSB NYC08LA087](https://openairdocs.org/ntsb/NYC08LA087.md): Unknown Free Bird Sportlite · McCullough, AL · Accident · 1 fatal · Limited investigation · Final report · Jan 27, 2008 · N75474 · Destroyed
  > The non-certificated pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the non-certificated pilot's improper decision to conduct a flight prior to the airplane being properly inspected and certified.
- [NTSB NYC08FA071](https://openairdocs.org/ntsb/NYC08FA071.md): Bell 206L-3 · Cherokee, AL · Accident · 3 fatal · Field investigation · Final report · Dec 30, 2007 · N109AE · Substantial damage
  > The pilot's failure to maintain control of the helicopter during an out-of-ground-effect hover. Contributing to the accident was a loss of tail rotor effectiveness.
- [NTSB MIA07CA100](https://openairdocs.org/ntsb/MIA07CA100.md): Hillery W. Grice Alley Cat 1 · Fairhope, AL · Accident · Serious injuries · Data collection · Final report · May 19, 2007 · N985GC · Substantial damage
  > The failure of the pilot-in-command to maintain terrain clearance while completing a loop at an airshow, resulting in impact with the runway.
- [NTSB ATL06LA110](https://openairdocs.org/ntsb/ATL06LA110.md): Arter RV6 · Hartselle, AL · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 2006 · N112WA · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and collision with trees and the ground. Factor in the accident were the pilot's ostentatious display and impairment due to alcohol.
- [NTSB ATL06CA088](https://openairdocs.org/ntsb/ATL06CA088.md): Bellanca 7ECA · Gadsden, AL · Accident · No injuries · Data collection · Final report · May 29, 2006 · N99NR · Substantial damage
  > The pilot's failure to maintain a visual lookout,while maneuvering at a low altitude resulting in an in-flight collision with a powerline.
- [NTSB ATL06FA076](https://openairdocs.org/ntsb/ATL06FA076.md): Piper PA60-602P · Camp Hill, AL · Accident · 2 fatal · Field investigation · Final report · May 10, 2006 · N68999 · Destroyed
  > The pilot's continued flight into known thunderstorms resulting in an in-flight break up. A factor in the accident was air traffic controller's failure to issue extreme weather radar echo intensity information displayed on the controller's radar to the pilot.
- [NTSB ATL06LA059](https://openairdocs.org/ntsb/ATL06LA059.md): Brantly Helicopter B2B · Cullman, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 2006 · N2183U · Destroyed
  > The pilot's failure to maintain a visual look out while maneuvering resulting in an in-flight collision with wires and the ground. A factor in the accident was the pilot's lack of recent experience in rotorcraft operations.
- [NTSB ATL06LA058](https://openairdocs.org/ntsb/ATL06LA058.md): Cessna 182T · Double Springs, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 2006 · N2157V · Substantial damage
  > The pilot's failure to maintain airspeed resulting in a stall. A factor in the accident was the pilot's physical impairment due to dementia and his failure to report the medical condition to the aviation medical examiner..
- [NTSB ATL05LA035](https://openairdocs.org/ntsb/ATL05LA035.md): Bell UH-1H · Rockford, AL · Accident · No injuries · Limited investigation · Final report · Dec 16, 2004 · N51AG · Substantial damage
  > The pilot's failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tree.
- [NTSB ATL05CA003](https://openairdocs.org/ntsb/ATL05CA003.md): Bell 206 B · Eutaw, AL · Accident · Minor injuries · Data collection · Final report · Oct 14, 2004 · N300HT · Substantial damage
  > The pilots inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.
- [NTSB ATL04LA195](https://openairdocs.org/ntsb/ATL04LA195.md): Cessna 172L · Gadsden, AL · Accident · 2 fatal · Limited investigation · Final report · Sep 29, 2004 · N4336Q · Destroyed
  > The flight instructors failure to maintain clearance and his inadequate visual lookout while flying low over a river resulting in an in-flight collision with a wire.
- [NTSB ATL04LA164](https://openairdocs.org/ntsb/ATL04LA164.md): Cessna 172S · Waterloo, AL · Accident · 1 fatal · Limited investigation · Final report · Aug 1, 2004 · N970SP · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in a stall and subsequent uncontrolled descent and collision into water.

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

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