# NTSB investigations, AL: Initial climb

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 5 · 235 cases

## Latest cases

- [NTSB ERA26FA067](https://openairdocs.org/ntsb/ERA26FA067.md): American Champion 8KCAB · Irvington, AL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 13, 2025 · N157WB · Substantial damage
  > On December 13, 2025, about 1145 central standard time, an American Champion Decathlon, N157WB, was destroyed when it was involved in an accident near Roy E. Ray Airfield (5R7), Bayou La Batre, Alabama. The commercial pilot was fatally injured. The airplane…
- [NTSB ERA25LA225](https://openairdocs.org/ntsb/ERA25LA225.md): Cessna 150J · Elberta, AL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 1, 2025 · N150FJ · Substantial damage
  > On June 1, 2025, at about 1200 central daylight time, a Cessna 150J, N150FJ, was substantially damaged when it was involved in an accident near Elberta, Alabama. The pilot and the pilot- rated passenger were not injured. The airplane was operated under as a…
- [NTSB ERA25FA071](https://openairdocs.org/ntsb/ERA25FA071.md): Magni Builder M-16 · Foley, AL · Accident · 1 fatal · Class 3 · Field · Final report · Dec 9, 2024 · N271BP · Substantial damage
  > The sport pilot’s failure to maintain control of the gyroplane during initial climb, which resulted in an uncontrolled descent and collision with terrain.
- [NTSB ERA24LA344](https://openairdocs.org/ntsb/ERA24LA344.md): Beech A36 · Cullman, AL · Accident · No injuries · Class 4 · Limited · Final report · Aug 2, 2024 · N718FG · Substantial damage
  > The pilot’s decision to depart in an area of developing convective weather, which resulted in an unanticipated wind shift during the initial climb after takeoff, a loss of climb performance, and the subsequent forced landing.
- [NTSB ERA24LA152](https://openairdocs.org/ntsb/ERA24LA152.md): Cessna 172 · Opelika, AL · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 24, 2024 · N863AU · Substantial damage
  > A partial loss of engine power due to a combination of fuel/oil contamination in the fuel injector assembly.
- [NTSB ERA24LA027](https://openairdocs.org/ntsb/ERA24LA027.md): Mustang II · Asheville, AL · Accident · No injuries · Class 4 · Limited · Final report · Oct 28, 2023 · N71CB · Substantial damage
  > The pilot’s failure to maintain control of the airplane during initial climb after an aborted landing, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB ERA23LA288](https://openairdocs.org/ntsb/ERA23LA288.md): Steen Skybolt · Aliceville, AL · Accident · No injuries · Class 4 · Limited · Final report · Jul 4, 2023 · N32WM · Substantial damage
  > A partial loss of engine power for reasons that could not be determined as the wreckage was not recovered and could not be examined.
- [NTSB ERA23LA251](https://openairdocs.org/ntsb/ERA23LA251.md): Magniflight M24 Orion Plus · Dauphin Island, AL · Accident · No injuries · Class 3 · Limited · Final report · May 30, 2023 · N1777W · Substantial damage
  > A partial loss of engine power due to a loss of combustion in the No. 4 cylinder for undetermined reasons.
- [NTSB ERA23LA183](https://openairdocs.org/ntsb/ERA23LA183.md): Peterson Mark G Peterson A600 · Foley, AL · Accident · No injuries · Class 4 · Limited · Final report · Apr 6, 2023 · N272AM · Destroyed
  > The loss of engine power during the initial climb due to the disconnection of the turbocharger air intake hose and clamp, and the pilot’s inadequate servicing and preflight inspection of the turbocharger air intake clamp.
- [NTSB ERA22LA389](https://openairdocs.org/ntsb/ERA22LA389.md): Cessna 140 · Slocomb, AL · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 27, 2022 · N76527 · Substantial damage
  > The partial loss of engine power during takeoff for reasons that could not be determined.
- [NTSB ERA22LA198](https://openairdocs.org/ntsb/ERA22LA198.md): Cessna 310 · Selma, AL · Accident · No injuries · Class 3 · Limited · Final report · Apr 13, 2022 · N7733Q · Substantial damage
  > The failure of maintenance personnel to properly rig the rudder trim system after reinstallation and pilot’s inadequate preflight inspection after recent maintenance, which resulted in an inability to adequately maintain directional control during the flight.
- [NTSB ERA21LA284](https://openairdocs.org/ntsb/ERA21LA284.md): Cessna 150 · Elba, AL · Accident · No injuries · Class 3 · Limited · Final report · Jul 11, 2021 · N8172S · Substantial damage
  > The partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with trees during takeoff.
- [NTSB ERA21LA162](https://openairdocs.org/ntsb/ERA21LA162.md): Bellanca 1730 · Bessemer, AL · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 26, 2021 · N93638 · Substantial damage
  > The pilot’s failure to maintain control of the airplane, which resulted in an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall.
- [NTSB ERA20LA197](https://openairdocs.org/ntsb/ERA20LA197.md): Schweizer 269C-1 · Ozark, AL · Accident · 1 fatal · Class 3 · Limited · Final report · May 30, 2020 · N9421P · Destroyed
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the flight school’s inadequate maintenance of the helicopter’s fuel quantity and caution systems.
- [NTSB ERA20FA063](https://openairdocs.org/ntsb/ERA20FA063.md): Vans Vans RV-6 · Cullman, AL · Accident · 2 fatal · Class 3 · Field · Final report · Jan 5, 2020 · N420PW · Destroyed
  > The pilot’s inadequate planning, which resulted in fuel exhaustion and a total loss of engine power during the initial climb. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the runway after…
- [NTSB ERA20LA023](https://openairdocs.org/ntsb/ERA20LA023.md): Piper J3C · Grand Bay, AL · Accident · No injuries · Class 3 · Limited · Final report · Oct 27, 2019 · N7009H · Substantial damage
  > A loss of engine power during initial climb due to carburetor ice that formed during an extended ground delay, and the pilot's failure to use carburetor heat before initiating the takeoff.
- [NTSB ERA19FA164](https://openairdocs.org/ntsb/ERA19FA164.md): Piper PA28 · Foley, AL · Accident · 1 fatal · Field investigation · Final report · May 6, 2019 · N5542U · Destroyed
  > A partial loss of engine power due to a stuck exhaust valve and the flight instructor's exceedance of the airplane's critical angle of attack following the loss of power, which resulted in an aerodynamic stall at low altitude.
- [NTSB ERA19LA017](https://openairdocs.org/ntsb/ERA19LA017.md): Cessna 182 · Opelika, AL · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 16, 2018 · N9398G · Substantial damage
  > The improper torque application and ongoing inspection of an oil filter adaptor by maintenance personnel, which resulted in a loss of lubrication and a catastrophic engine failure.
- [NTSB ERA18FA208](https://openairdocs.org/ntsb/ERA18FA208.md): Champion 8GCBC · Foley, AL · Accident · 2 fatal · Field investigation · Final report · Aug 4, 2018 · N424A · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall and spin at an altitude that was too low for recovery.
- [NTSB ANC18LA004](https://openairdocs.org/ntsb/ANC18LA004.md): Cirrus Design SR22T · Tuskegee, AL · Accident · No injuries · Limited investigation · Final report · Oct 15, 2017 · N289CM · Substantial damage
  > An improperly adjusted slope controller and fuel pump that resulted in an excessively high fuel flow, an extremely rich mixture, a rough-running engine, and a subsequent partial loss of engine power.
- [NTSB ERA17CA089](https://openairdocs.org/ntsb/ERA17CA089.md): Cessna 182 · Mobile, AL · Accident · Minor injuries · Data collection · Final report · Jan 14, 2017 · N707RB · Substantial damage
  > The pilot’s failure to maintain airplane control during the initial climb.
- [NTSB ERA16LA199](https://openairdocs.org/ntsb/ERA16LA199.md): American Legend AL3 · Elberta, AL · Accident · No injuries · Limited investigation · Final report · May 31, 2016 · N156WB · Substantial damage
  > A total loss of engine power for reasons that could not be determined because the engine ran normally during a postaccident engine test run with no anomalies noted.
- [NTSB ERA16LA014](https://openairdocs.org/ntsb/ERA16LA014.md): Gross Michael E Stol CH 701 · Eufala, AL · Accident · No injuries · Limited investigation · Final report · Oct 14, 2015 · N4931M · Substantial damage
  > A partial loss of engine power during takeoff for reasons that could not be determined, because postaccident examination revealed no evidence of any preimpact mechanical malfunctions or failures. Also causal was the pilot's decision to continue the takeoff…
- [NTSB ERA15LA200](https://openairdocs.org/ntsb/ERA15LA200.md): Diamond Aircraft Ind DA 20 C1 · Sylacauga, AL · Accident · No injuries · Limited investigation · Final report · Apr 27, 2015 · N248ME · Substantial damage
  > A partial loss of engine power due to the failure of the throttle body/fuel metering unit to provide the engine with adequate fuel pressure for full power operation.
- [NTSB ERA12LA305](https://openairdocs.org/ntsb/ERA12LA305.md): Aviat A-1B · Sylacauga, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 2012 · N388AS · Substantial damage
  > The pilot's attempt to take off with the carburetor heat in the hot position, which limited the airplane’s performance, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.
- [NTSB ERA12FA149](https://openairdocs.org/ntsb/ERA12FA149.md): Aero Vodochody L39C · Rainbow City, AL · Accident · 1 fatal · Field investigation · Final report · Jan 21, 2012 · N16RZ · Substantial damage
  > An in-flight loss of control in instrument meteorological conditions.
- [NTSB ERA12LA150](https://openairdocs.org/ntsb/ERA12LA150.md): M-Squared Breese 2 · Bayou La Batre, AL · Accident · No injuries · Limited investigation · Final report · Jan 19, 2012 · N582MS · Substantial damage
  > The pilot's inability to maintain control of the airplane for reasons that could not be determined because postaccident examination of the rudder control system did not reveal any anomalies that would have precluded control of the airplane.
- [NTSB ERA11CA441](https://openairdocs.org/ntsb/ERA11CA441.md): Cessna 172K · Sylacauga, AL · Accident · No injuries · Data collection · Final report · Aug 5, 2011 · N7214G · Substantial damage
  > A stuck exhaust-valve on the number one cylinder which resulted in a loss of engine power.
- [NTSB ERA11FA348](https://openairdocs.org/ntsb/ERA11FA348.md): Piper PA-28-140 · Guntersville, AL · Accident · 3 fatal · Field investigation · Final report · Jun 18, 2011 · N1803T · Substantial damage
  > The pilot's excessive pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to comply with weight and balance limitations.
- [NTSB ERA10CA185](https://openairdocs.org/ntsb/ERA10CA185.md): Shaw Fisher FP 404 · Lillian, AL · Accident · Serious injuries · Data collection · Final report · Mar 22, 2010 · N6587V · Substantial damage
  > The pilot’s inadequate weather evaluation and failure to maintain directional control during takeoff in gusty wind conditions.
- [NTSB ERA10LA166](https://openairdocs.org/ntsb/ERA10LA166.md): Belcher William B II Firestar · Wetumpka, AL · Accident · Minor injuries · Limited investigation · Final report · Mar 6, 2010 · N43341 · Substantial damage
  > The student pilot’s in-flight loss of control as a result of previous damage to the airplane from an undetermined event.
- [NTSB ERA09LA308](https://openairdocs.org/ntsb/ERA09LA308.md): Piper PA-28-161 · Jasper, AL · Accident · Minor injuries · Limited investigation · Final report · May 26, 2009 · N1669H · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the flight instructor's improper fuel management.
- [NTSB MIA08CA183](https://openairdocs.org/ntsb/MIA08CA183.md): Smith Wylie Jay Kit Fox II · Deatville, AL · Accident · No injuries · Data collection · Final report · Sep 5, 2008 · N8188F · Substantial damage
  > The pilot's inadequate fuel system maintenance.
- [NTSB NYC08LA270](https://openairdocs.org/ntsb/NYC08LA270.md): Piper PA-12 · Brownsboro, AL · Accident · 2 fatal · Limited investigation · Final report · Aug 5, 2008 · N7820H · Substantial damage
  > The pilot’s failure to ensure the fuel valve was on prior taxi and takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following loss of engine power due to fuel starvation.
- [NTSB NYC08CA321](https://openairdocs.org/ntsb/NYC08CA321.md): Grimes Barry R Chinook Plus TWO · Magnolia Springs, AL · Accident · No injuries · Data collection · Final report · Jul 26, 2008 · N92095 · Substantial damage
  > The total loss of engine power during initial climb due to the failure of the fuel pump.
- [NTSB NYC08FA231](https://openairdocs.org/ntsb/NYC08FA231.md): Beech 95-B55 · Jasper, AL · Accident · 4 fatal · Field investigation · Final report · Jun 29, 2008 · N727BC · Destroyed
  > The pilot's intentional visual flight into known instrument meteorological conditions, resulting in spatial disorientation and a subsequent loss of control in flight. Contributing to the accident was the overweight and aft-center-of-gravity condition of the…
- [NTSB NYC08CA154](https://openairdocs.org/ntsb/NYC08CA154.md): American AA-1A · Alabaster, AL · Accident · Minor injuries · Data collection · Final report · Apr 6, 2008 · N7UX · Substantial damage
  > The pilot's failure to utilize carburetor heat during a power off approach.
- [NTSB MIA07CA126](https://openairdocs.org/ntsb/MIA07CA126.md): Phantom Sport XI · Anderson, AL · Accident · Minor injuries · Data collection · Final report · Jul 18, 2007 · UNREG · Substantial damage
  > The failure of the unqualified person (pilot) to maintain airspeed during the initial climb, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with a residence.
- [NTSB ATL07LA063](https://openairdocs.org/ntsb/ATL07LA063.md): Randy Stanley Rotoway Exc 162F · Foley, AL · Accident · No injuries · Limited investigation · Final report · Mar 29, 2007 · N494D · Substantial damage
  > Loss of engine power due to failure of the No. 4 engine exhaust valve.
- [NTSB ATL07CA011](https://openairdocs.org/ntsb/ATL07CA011.md): Air Tractor AT-802A · Linden, AL · Accident · No injuries · Data collection · Final report · Oct 13, 2006 · N8504T · Substantial damage
  > The pilot's attempt to takeoff downwind resulting in the airplane not clearing trees at the end of the runway.
- [NTSB ATL06FA129](https://openairdocs.org/ntsb/ATL06FA129.md): Beech F-33A · Alabaster, AL · Accident · 3 fatal · Field investigation · Final report · Sep 23, 2006 · N8148R · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering toward an emergency landing area following the total loss of engine power shortly after takeoff resulting in an inadvertent stall, uncontrolled descent, and collision with the ground, and a fence. A…
- [NTSB ATL05FA139](https://openairdocs.org/ntsb/ATL05FA139.md): Beech BE-D35 · Decatur, AL · Accident · 1 fatal · Field investigation · Final report · Aug 6, 2005 · N3468B · Substantial damage
  > The pilot's mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation, and subsequent inadvertent stall/spin during the forced landing.
- [NTSB ATL05LA081](https://openairdocs.org/ntsb/ATL05LA081.md): Paul E. Conner Rotor-EZ · St Elmo, AL · Accident · 1 fatal · Limited investigation · Final report · May 16, 2005 · N2992 · Substantial damage
  > The pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. The pilot failed to maintain airspeed resulting in an inadvertent stall.
- [NTSB ATL05FA044](https://openairdocs.org/ntsb/ATL05FA044.md): Cessna T206H · Huntsville, AL · Accident · 2 fatal · Field investigation · Final report · Jan 12, 2005 · N2467X · Substantial damage
  > The pilot's decision to attempt flight into known adverse weather, which resulted in an in-flight encounter with a thunderstorm.
- [NTSB ATL03LA148](https://openairdocs.org/ntsb/ATL03LA148.md): Piper PA-28-180 · Talladega, AL · Accident · No injuries · Limited investigation · Final report · Sep 29, 2003 · N2342T · Substantial damage
  > The pilot's failure to use carburetor heat when weather conditions were favorable for carburetor icing.
- [NTSB ATL03LA113](https://openairdocs.org/ntsb/ATL03LA113.md): Aero Vodochody Aero Works L39C · Gadsden, AL · Accident · 1 fatal · Limited investigation · Final report · Jun 30, 2003 · N8125R · Destroyed
  > The loss of engine power during takeoff due to foreign object damage, which resulted in an in-flight collision with terrain during forced landing. Factors were the pilot's inadequate preflight inspection of the airplane, his failure to secure the…
- [NTSB ATL03LA043](https://openairdocs.org/ntsb/ATL03LA043.md): Penska Rans S-9 · Dothan, AL · Accident · Serious injuries · Limited investigation · Final report · Feb 9, 2003 · N34AP · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent inflight collision with the ground
- [NTSB MIA02LA175](https://openairdocs.org/ntsb/MIA02LA175.md): Piper PA-28R-200 · Irvington, AL · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 2002 · N2963R · Substantial damage
  > The loss of engine power due to internal contamination (rust and water) of the servo fuel injector resulting in it flowing approximately half of the required fuel flow at full throttle. A contributing factor was the unsuitable terrain encountered by the pilot…
- [NTSB MIA02LA169](https://openairdocs.org/ntsb/MIA02LA169.md): Charles Maxted RV6 · Bay Minette, AL · Accident · No injuries · Limited investigation · Final report · Sep 16, 2002 · N440CM · Substantial damage
  > The intentional operation of the airplane with known deficiencies with the right magneto resulting in the partial loss of engine power during the initial climb.
- [NTSB ATL02LA037](https://openairdocs.org/ntsb/ATL02LA037.md): Consolidated-Vultee 108-M · Bayou La Batre, AL · Accident · Serious injuries · Limited investigation · Final report · Jan 13, 2002 · N9315K · Substantial damage
  > The loss of engine power for undetermined reasons.

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

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