# NTSB investigations, AL: Standing

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.

## Latest cases

- [NTSB DCA23LA109](https://openairdocs.org/ntsb/DCA23LA109.md): Embraer S A ERJ 170-200 LR · Montgomery, AL · Accident · 1 fatal · Class 3 · Limited · Final report · Dec 31, 2022 · N264NN · Minor damage
  > The ramp agent’s cognitive impairment, which resulted in her (1) inconsistent behavior with trained procedures and pre landing briefings, (2) presence on the left side of the airplane while the left engine was still operating, and (3) subsequent ingestion…
- [NTSB ERA15CA107](https://openairdocs.org/ntsb/ERA15CA107.md): Piper PA-28-161 · Alexander City, AL · Accident · Minor injuries · Data collection · Final report · Jan 19, 2015 · N104SA · Substantial damage
  > The pilot's failure to properly secure the airplane before hand-propping the engine for startup.
- [NTSB ERA15LA097](https://openairdocs.org/ntsb/ERA15LA097.md): Cessna 152 · Cullman, AL · Accident · Minor injuries · Limited investigation · Final report · Jan 10, 2015 · N89921 · Substantial damage
  > The student pilot’s failure to maintain airplane control after engine start, which resulted in a ground collision with trees.
- [NTSB ERA14LA257](https://openairdocs.org/ntsb/ERA14LA257.md): P&M Quikr · Gulf Shores, AL · Accident · Serious injuries · Limited investigation · Final report · May 22, 2014 · N428PM · Minor damage
  > The pilot’s failure to maintain aircraft control during engine startup, which resulted in a collision with a parked airplane. Contributing to the accident was the pilot’s failure to follow engine startup procedures and a sudden surge of engine power for…
- [NTSB ATL07CA003](https://openairdocs.org/ntsb/ATL07CA003.md): Hadwise Varieze · Enterprise, AL · Accident · No injuries · Data collection · Final report · Oct 8, 2006 · N222DQ · Substantial damage
  > The pilot's improper starting procedure, which resulted in an uncommanded aircraft movement and collision with a hanger.
- [NTSB DEN06CA124](https://openairdocs.org/ntsb/DEN06CA124.md): Bell 47G-2 · Hayden, AL · Accident · No injuries · Data collection · Final report · Sep 9, 2006 · N23947 · Destroyed
  > engine fire for reasons undetermined.
- [NTSB MIA98LA031](https://openairdocs.org/ntsb/MIA98LA031.md): de Havilland DHC-6-6 · Elberta, AL · Accident · 1 fatal · Limited investigation · Final report · Nov 8, 1997 · N1022S · Minor damage
  > a passenger's inadvertent encounter with a rotating propeller.
- [NTSB ATL90LA083](https://openairdocs.org/ntsb/ATL90LA083.md): Cessna 172G · Gulf Shores, AL · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 1990 · N4373L · Substantial damage
  > Failure of the pilot to obtain proper assistance or properly secure the aircraft when he left it unattended with the engine running.
- [NTSB ATL87LA252](https://openairdocs.org/ntsb/ATL87LA252.md): Bell 47G-2A · Mc Intosh, AL · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 1987 · N1200W · Destroyed
  > The helicopter was being used to set fires to burn off underbrush in a commercial forest prior to cutting of trees. The plt landed the helicopter on a mobile transport trailer at the completion of the day's work. The helicopter engine had been shut off and…
- [NTSB ATL87LA143](https://openairdocs.org/ntsb/ATL87LA143.md): Beech B100 · Birmingham, AL · Accident · 1 fatal · Limited investigation · Final report · May 19, 1987 · N753D · Minor damage
  > The lineman walked into the prop arc of the operating rt engine and was fatally injured after disconnecting a ground power unit (gpu) cable from the rt engine nacelle. The lineman initially approached the nacelle from the rear, but walked forward into the…
- [NTSB ATL86LA045](https://openairdocs.org/ntsb/ATL86LA045.md): Cessna C-172M · Andalusia, AL · Accident · No injuries · Limited investigation · Final report · Dec 20, 1985 · N509R · Substantial damage
  > The acft battery power was depleted. The plt hand propped the engine with his wife at the controls. The engine started with the throttle advanced and acft taxied into trees and over an embankment. The wife was not a rated pilot.
- [NTSB DCA85AA026](https://openairdocs.org/ntsb/DCA85AA026.md): Beech E18S · Birmingham, AL · Accident · 1 fatal · Final report · Jun 21, 1985 · N19T · 2 aircraft · Destroyed
  > At 2045 the military flt, dixie 06, contacted Birmingham apch & obtained clearance for a low apch followed by a full-stop lndg on rwy 05. At 2053, dixie 06 reported a 4 mile final for a low apch to the local controller. At 2054:19, the local controller…
- [NTSB ATL82LA098](https://openairdocs.org/ntsb/ATL82LA098.md): Piper PA-23-170 · Tuscaloosa, AL · Accident · No injuries · Limited investigation · Final report · Apr 9, 1982 · N3016P · Substantial damage
  > During an instructional flight the right engine was shut down and the prop feathered after a vibration was felt. The flight continued to its intended destination. Witnesses stated that they observed the right prop rotating while on final approach, even though…
- [NTSB MIA79FKJ47](https://openairdocs.org/ntsb/MIA79FKJ47.md): Navion A · Theodore, AL · Accident · No injuries · Closed · Jun 6, 1979 · N4935K · Substantial damage
- [NTSB MIA79FKJ23](https://openairdocs.org/ntsb/MIA79FKJ23.md): Cessna 310K · Clanton, AL · Accident · No injuries · Closed · Jan 28, 1979 · N734SC · Substantial damage
- [NTSB MIA79FKJ18](https://openairdocs.org/ntsb/MIA79FKJ18.md): Cessna 182 · Decatur, AL · Accident · No injuries · Closed · Dec 29, 1978 · N1933X · Minor damage
- [NTSB MIA78FKJ66](https://openairdocs.org/ntsb/MIA78FKJ66.md): Piper PA-28 · Tuscaloosa, AL · Accident · No injuries · Closed · Jul 26, 1978 · N5239W · Substantial damage
- [NTSB MIA73AM092](https://openairdocs.org/ntsb/MIA73AM092.md): Cessna 177RG · Huntsville, AL · Accident · 1 fatal · Closed · Mar 16, 1973 · N1828Q · Destroyed
- [NTSB MIA66D0359](https://openairdocs.org/ntsb/MIA66D0359.md): Cessna 172 · Aliceville, AL · Accident · No injuries · Closed · Oct 17, 1965 · N8385B · Substantial damage
- [NTSB MIA66F0363](https://openairdocs.org/ntsb/MIA66F0363.md): Piper PA-23 · Mobile, AL · Accident · No injuries · Closed · Oct 8, 1965 · N3486P · Substantial damage
- [NTSB UNK64X0242](https://openairdocs.org/ntsb/UNK64X0242.md): Aeronca 7AC · Troy, AL · Accident · No injuries · Closed · Jan 14, 1964 · N81412 · Substantial damage

## 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 = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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