NTSB investigations, 2001, AL

6 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 2001, AL per year, 1964–2026: 362 cases
196411
196517
19664
196713
19685
196910
19708
197110
197210
197310
19747
19754
197615
19777
197811
197910
19806
19812
19827
198315
19846
19858
19866
198712
19886
198914
19907
19915
19928
19935
19944
199511
19966
19972
19983
19995
20016
20026
20035
20049
20065
20072
20083
20092
20101
20112
20122
20132
20146
20153
20161
20171
20183
20191
20202
20212
20236
20241
20261

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 year(c.\"eventDate\") = 2001
    AND 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"

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 ATL02FA017Accident · 3 fatalField investigationFinal reportBeech BE-55 · Montgomery, ALThe pilots failure to maintain airspeed while maneuvering in instrument flight conditions resulting in an inadvertence stall/spin (vertical descent) and subsequent in-flight collision with trees and terrain.Dec 12, 2001 · N99DC · DestroyedNTSB MIA02FA001Accident · 1 fatalField investigationFinal reportChampion 7AC/BCM · Woodstock, ALThe failure of the pilot to maintain aircraft control while maneuvering at a low altitude, resulting in an uncontrolled descent and inflight collision with the terrain.Oct 7, 2001 · N82049 · DestroyedNTSB ATL01LA108Accident · No injuriesLimited investigationFinal reportBell 47G · Berry, ALThe failure of the main rotor system stabilizer damper control horn assembly, resulting in an uncontrolled descent and subsequent collision with a tree and terrain.Sep 7, 2001 · N6327D · Substantial damageNTSB ATL01FA093Accident · 2 fatalField investigationFinal reportBoeing Stearman PT-17 · Anniston, ALThe inadvertent activation of the flight control gust locks by the pilot rated passenger that resulted in the loss of control inflight. Contributing was the pilot in commands failure to follow the airplane's pre-flight inspection check list.Jul 24, 2001 · N56920 · DestroyedNTSB MIA01LA153Accident · Minor injuriesLimited investigationFinal reportEnstrom F28A · Double Springs, ALThe failure of the pilot to maintain clearance between the skid and trailer while attempting to lift from a trailer resulting in dynamic roll-over.Jun 5, 2001 · N9565 · Substantial damageNTSB MIA01LA080Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Seminole, ALthe pilot's improper inflight planning/decision and failure to refuel en route and ensure an adequate supply of fuel to safely complete the flight to his destination with adequate reserves, which resulted in fuel exhaustion, subsequent engine failure, and a…Feb 16, 2001 · N210FW · Substantial damage