OpenAirDocs.org

NTSB investigations, AL

21 cases where the phase of flight was Standing.

Cases per year

19642026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB DCA23LA109Accident · 1 fatalClass 3 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Montgomery, ALThe 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…Dec 31, 2022 · N264NN · Minor damageNTSB ERA15CA107Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Alexander City, ALThe pilot's failure to properly secure the airplane before hand-propping the engine for startup.Jan 19, 2015 · N104SA · Substantial damageNTSB ERA15LA097Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cullman, ALThe student pilot’s failure to maintain airplane control after engine start, which resulted in a ground collision with trees.Jan 10, 2015 · N89921 · Substantial damageNTSB ERA14LA257Accident · Serious injuriesLimited investigationFinal reportP&M Quikr · Gulf Shores, ALThe 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…May 22, 2014 · N428PM · Minor damageNTSB ATL07CA003Accident · No injuriesData collectionFinal reportHadwise Varieze · Enterprise, ALThe pilot's improper starting procedure, which resulted in an uncommanded aircraft movement and collision with a hanger.Oct 8, 2006 · N222DQ · Substantial damageNTSB DEN06CA124Accident · No injuriesData collectionFinal reportBell 47G-2 · Hayden, ALengine fire for reasons undetermined.Sep 9, 2006 · N23947 · DestroyedNTSB MIA98LA031Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6-6 · Elberta, ALa passenger's inadvertent encounter with a rotating propeller.Nov 8, 1997 · N1022S · Minor damageNTSB ATL90LA083Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Gulf Shores, ALFailure of the pilot to obtain proper assistance or properly secure the aircraft when he left it unattended with the engine running.Mar 21, 1990 · N4373L · Substantial damageNTSB ATL87LA252Accident · Serious injuriesLimited investigationFinal reportBell 47G-2A · Mc Intosh, ALThe 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…Sep 8, 1987 · N1200W · DestroyedNTSB ATL87LA143Accident · 1 fatalLimited investigationFinal reportBeech B100 · Birmingham, ALThe 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…May 19, 1987 · N753D · Minor damageNTSB ATL86LA045Accident · No injuriesLimited investigationFinal reportCessna C-172M · Andalusia, ALThe 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.Dec 20, 1985 · N509R · Substantial damageNTSB DCA85AA026Accident · 1 fatalFinal reportBeech E18S · Birmingham, ALAt 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…Jun 21, 1985 · N19T · 2 aircraft · DestroyedNTSB ATL82LA098Accident · No injuriesLimited investigationFinal reportPiper PA-23-170 · Tuscaloosa, ALDuring 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…Apr 9, 1982 · N3016P · Substantial damageNTSB MIA79FKJ47Accident · No injuriesClosedNavion A · Theodore, ALJun 6, 1979 · N4935K · Substantial damageNTSB MIA79FKJ23Accident · No injuriesClosedCessna 310K · Clanton, ALJan 28, 1979 · N734SC · Substantial damageNTSB MIA79FKJ18Accident · No injuriesClosedCessna 182 · Decatur, ALDec 29, 1978 · N1933X · Minor damageNTSB MIA78FKJ66Accident · No injuriesClosedPiper PA-28 · Tuscaloosa, ALJul 26, 1978 · N5239W · Substantial damageNTSB MIA73AM092Accident · 1 fatalClosedCessna 177RG · Huntsville, ALMar 16, 1973 · N1828Q · DestroyedNTSB MIA66D0359Accident · No injuriesClosedCessna 172 · Aliceville, ALOct 17, 1965 · N8385B · Substantial damageNTSB MIA66F0363Accident · No injuriesClosedPiper PA-23 · Mobile, ALOct 8, 1965 · N3486P · Substantial damageNTSB UNK64X0242Accident · No injuriesClosedAeronca 7AC · Troy, ALJan 14, 1964 · N81412 · Substantial damage