NTSB investigations, 2002, FL

15 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 2002, FL per year, 1964–2026: 949 cases
196415
196520
196620
196715
196811
196913
197015
19719
197219
197319
197422
197519
197620
197719
197821
197918
198016
198115
198214
198337
198429
198521
198617
198711
198824
198924
199012
199122
199213
199320
199422
19959
199619
199723
199817
199920
200020
20019
200215
200319
200412
20058
20069
200712
200815
200913
201015
201115
20124
20138
20146
20156
20167
201711
20187
201913
202012
20219
202214
20238
20248
20257
20267

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\") = 2002
    AND c.\"eventStateOrRegion\" = 'FL' 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 MIA02LA153Accident · 2 fatalLimited investigationFinal reportReviere Vans RV6A · Tampa, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, while maneuvering, and subsequent impact with a concrete wall. A factor in this accident was the impairment of the pilot in command due to the use of prescription…Aug 18, 2002 · N747ES · DestroyedNTSB MIA02LA133Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Lorida, FLThe pilot's continued operation with known engine anomalies resulting in loss of engine power due to failure of the engine fuel control pump drive clutch assembly due to wear and collision with the terrain during the resultant descent.Jul 16, 2002 · N91281 · Substantial damageNTSB ATL02LA128Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A · La Belle, FLThe pilot's failure to maintain visual lookout while maneuvering during an aerial application, which resulted in an in-flight collision with power lines and uncontrolled descent into terrain.Jun 24, 2002 · N8486E · Substantial damageNTSB ATL02FA121Accident · 1 fatalField investigationFinal reportCessna 172H · Palmetto, FLThe pilot's failure to maintain airspeed which resulted in a stall while maneuvering after a banner release.Jun 6, 2002 · N260WB · DestroyedNTSB MIA02LA090Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Myakka City, FLthe pilot's failure to maintain altitude while maneuvering during an aerial application, subsequently resulting in impact with the terrain.Apr 30, 2002 · N70213 · DestroyedNTSB ATL02LA092Accident · 1 fatalLimited investigationFinal reportHartman Buccaneer 2 · Estero Bay, FLThe pilot's failure to maintain aircraft control for undetermined reasons.Apr 27, 2002 · N8127W · DestroyedNTSB ATL02LA094Accident · No injuriesLimited investigationFinal reportBell 47G-5A · La Belle, FLThe pilot's failure to maintain clearance of a tree while maneuvering, which resulted in an in-flight collision with the tree and subsequent uncontrolled descent and collision with terrain.Apr 26, 2002 · N14838 · Substantial damageNTSB ATL02TA083Accident · Serious injuriesFinal reportHughes OH-6A · Tampa, FLThe pilot's improper planning/decision to conduct an out of ground effect hover in a tailwind environment, which resulted in the loss of tail rotor effectiveness and the subsequent in-flight collision with water.Apr 14, 2002 · N56TP · Substantial damageNTSB ATL02LA066Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400A · Hastings, FLFatigue cracking in the most outboard splice bolt hole in the lower spar cap of the right wing. .Mar 26, 2002 · N3159G · Substantial damageNTSB MIA02LA061Accident · Serious injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Belle Glade, FLthe pilot continued flight into known adverse weather resulting in a loss of control and subsequent impact with the ground.Feb 16, 2002 · N715RM · Substantial damageNTSB ATL02LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Panama City Bch, FLThe pilot's failure to use carburetor heat that resulted in the loss of engine power. A factor was weather conditions favorable for the formation of carburetor ice.Feb 12, 2002 · N10949 · DestroyedNTSB ATL02LA044Accident · Minor injuriesLimited investigationFinal reportHiller UH12E · Miami, FLFatigue cracking in the main rotor hub that resulted in the separation of the main rotor system. A factor was corrosive deposits on the exposed portion of the plate set pin.Feb 11, 2002 · N103HA · Substantial damageNTSB MIA02FA049Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Micanopy, FLThe pilot's experiencing spatial disorientation while maneuvering at a low altitude at night under visual meteorological conditions which resulted in an uncontrolled descent and an in-flight collision with a tree.Jan 13, 2002 · N8263P · DestroyedNTSB ATL02LA035Accident · 1 fatalLimited investigationFinal reportSpringer Longbow 150 · Oak Hill, FLThe improper modification of the exhaust muffler which resulted in fractures that enabled the contamination of the cabin heating and ventilation system. The pilot subsequently became incapacitated by carbon monoxide poisoning, and the airplane descended…Jan 10, 2002 · N150LB · Substantial damageNTSB ATL02TA030Accident · Minor injuriesFinal reportHughes OH-6A · Tampa, FLThe pilot's improper flare during practice autorotation.Jan 4, 2002 · N46TP · Substantial damage