OpenAirDocs.org

NTSB investigations, 2003

263 cases where the phase of flight was Maneuvering.

Cases per year

19622026

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 year(c.\"eventDate\") = 2003
    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 NYC04LA052Accident · Serious injuriesLimited investigationFinal reportMorgan S-17 · Woodstock, CTThe uncertificated pilot's decision to perform a low altitude maneuver at an inadequate altitude, which resulted in an in-flight collision with trees.Dec 28, 2003 · NONE · Substantial damageNTSB ATL04LA060Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · King, NCA loss of engine power for undetermined reasons and the pilot's failure to maintain a visual lookout and obstacle clearance while performing a simulated engine out resulting in an in-flight-collision with a power line and the ground.Dec 27, 2003 · N742CD · Substantial damageNTSB SEA04LA029Accident · Minor injuriesLimited investigationFinal reportBeech 58P · Missoula, MTThe second pilot's failure to maintain terrain clearance while maneuvering after takeoff. Proper climb rate not verified by the flight crew, fog, freezing fog, dark night conditions and inadequate supervision by the pilot-in-command were factors.Dec 23, 2003 · N181AM · DestroyedNTSB IAD04LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-44 · Prospect, PAThe flight instructor's improper in-flight decision, which included an inappropriate altitude selection for intentional single engine operation. Factors were the inability of the flight instructor to restart the right engine for undetermined reasons, and the…Dec 23, 2003 · N432PA · Substantial damageNTSB CHI04FA045Accident · 2 fatalField investigationFinal reportMooney 20E · Webster, WIThe pilot's inadequate decision to conduct a low altitude flight maneuver without sufficient altitude to maintain clearance from the terrain. Low altitude flight and ostentatious display are contributing factors.Dec 20, 2003 · N1275X · DestroyedNTSB ATL04LA057Accident · 1 fatalLimited investigationFinal reportInterplane Skyboy-2 · Covington, TNThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin and collision with the ground. A factor was the unqualified person (pilot).Dec 20, 2003 · UNREG · Substantial damageNTSB ATL04LA055Accident · Minor injuriesLimited investigationFinal reportMBB BK117A3 · Okeechobee, FLThe pilot continued visual flight into instrument meteorological conditions and experienced spatial disorientation, loss of aircraft control, and in-flight collision with trees and terrain. Factors in the accident were the pilot's failure to follow company…Dec 17, 2003 · N911WJ · Substantial damageNTSB ANC04FA015Accident · 2 fatalField investigationFinal reportCessna P210N · Tonopah, NVThe pilot's failure to follow approved instrument flight procedures, and his failure to maintain clearance from obstacles/terrain, which resulted in an in-flight collision with terrain. Factors associated with the accident are snow and low clouds.Dec 14, 2003 · N4674A · DestroyedNTSB SEA04LA026Accident · 1 fatalLimited investigationFinal reportUpright RV-7A · McMinnville, ORThe pilot's failure to maintain aircraft control. Cloudy weather, continued flight into adverse weather, inadequate preflight planning and mountainous terrain were factors.Dec 11, 2003 · N29CV · DestroyedNTSB ATL04FA051Accident · 4 fatalField investigationFinal reportCessna 414 · Greeneville, TNThe pilot's failure to maintain airspeed while maneuvering in icing conditions on a circling approach for landing resulting in an inadvertent stall and collision with trees and terrain. A factor in the accident was a partial loss of engine power due to the…Dec 11, 2003 · N1592T · DestroyedNTSB SEA04LA025Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Moclips, WAA sudden loss of engine power during hover for undetermined reasons.Dec 8, 2003 · N8343F · Substantial damageNTSB LAX04FA057Accident · 2 fatalField investigationFinal reportWing D-1 · Rosamond, CAThe flying pilot's failure to obtain/maintain control of the airplane during practice stalls, which resulted in the inadvertent entry into a spin.Dec 4, 2003 · N8602J · DestroyedNTSB SEA04LA024Accident · 1 fatalLimited investigationFinal reportShear Titan Tornado · Brooks, ORThe failure of the pilot to maintain aircraft control while maneuvering due to a hypoglycemic condition.Dec 2, 2003 · N183T · Substantial damageNTSB LAX04LA054Accident · No injuriesLimited investigationFinal reportCessna 172S · Wikieup, AZThe pilot's selection of an en route altitude that did not provide adequate terrain clearance, and resulted in the in-flight collision with terrain. The rising terrain and the blind/box canyon were contributing factors.Nov 29, 2003 · N518ER · Substantial damageNTSB FTW04LA069Accident · No injuriesLimited investigationFinal reportMBB BK 117 B-2 · Conroe, TXThe pilot's failure to maintain clearance from trees while repositioning in a confined landing zone. Contributing factors were the dark night light conditions and the confined area available to the pilot.Nov 29, 2003 · N440HH · Substantial damageNTSB MIA04FA023Accident · 3 fatalField investigationFinal reportBeech G35 · Okolona, MSThe pilot's intentional low altitude maneuver and buzzing resulting in collision with trees, uncontrolled descent, and in-flight collision with terrain. A factor in the accident was the pilot's ostentatious display.Nov 21, 2003 · N4214D · DestroyedNTSB SEA04LA019Accident · 1 fatalLimited investigationFinal reportKaman K-600 · Nordman, IDThe total failure of the helicopter's right main rotor shaft while in an ascending hover due to the propagation of a fatigue crack that initiated in a corrosion pit on the surface of a slot in the wall of the subject shaft. Factors include accumulation of…Nov 20, 2003 · N286M · Substantial damageNTSB SEA04FA020Accident · 1 fatalField investigationFinal reportCessna T210N · Bellevue, IDThe pilot's failure to maintain adequate altitude above mountainous terrain while maneuvering during descent. Factors included the mountainous terrain, the high wind condition, and dark night light conditions.Nov 20, 2003 · N5244A · DestroyedNTSB FTW04FA025Accident · 2 fatalField investigationFinal reportBeech A45 · Montgomery, TXThe non-compliance with applicable Airworthiness Directives which required wing spar inspections, and the continued operation of the aircraft beyond the compliance time extension granted as per the approved alternate means of compliance (AMOC). Also causal…Nov 19, 2003 · N44KK · DestroyedNTSB SEA04LA018Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Monmouth, ORFatigue failure of a tail rotor blade during hover operations.Nov 18, 2003 · N7825S · Substantial damageNTSB LAX04CA048Accident · No injuriesData collectionFinal reportRobinson R22 · Chandler, AZthe student pilot's failure to maintain control of the helicopter while hovering. A factor to the accident was the student pilot's lack of experience.Nov 18, 2003 · N7193J · Substantial damageNTSB NYC04LA035Accident · 1 fatalLimited investigationFinal reportNortham RAF 2000 · Nelsonia, VAA loss of control for undetermined reason(s).Nov 16, 2003 · N999GC · DestroyedNTSB LAX04LA039Accident · Serious injuriesLimited investigationFinal reportZivko Edge 540-T · King City, CAThe after market manufacturer's improper application of a crankshaft , which exceeded the original manufacturer's intended use. A factor in the accident was the oil covering the windscreen, which restricted the pilot's ability to see.Nov 11, 2003 · N540RC · Substantial damageNTSB CHI04LA030Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Louisville, KYThe pilot's improper in-flight decision to allow the passenger to manipulate the aircraft flight controls, his failure to maintain altitude/clearance from the river, and his inadequate remedial action. A related factor was the low altitude.Nov 10, 2003 · N1093D · Substantial damageNTSB NYC04LA024Accident · 1 fatalLimited investigationFinal reportCessna 150H · Bruceton Mills, WVThe pilot's physical impairment due to alcohol and his improper decision to attempt flight with a low cloud ceiling, low visibility, after consuming alcohol. A related factor in the accident was the low cloud ceiling.Nov 6, 2003 · N23178 · Substantial damageNTSB FTW04LA019Accident · Serious injuriesLimited investigationFinal reportRichard Riley Velocity · Fargo, OKThe pilot's failure to maintain control of the aircraft while practicing slow flight. A contributing factor was the low altitude selected by the pilot.Nov 6, 2003 · N57V · DestroyedNTSB NYC04LA021Accident · 2 fatalLimited investigationFinal reportFleet 16B · Fishers Island, NYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in a collision with water.Nov 2, 2003 · N80656 · DestroyedNTSB LAX04LA034Accident · 1 fatalLimited investigationFinal reportCanadair T33 · Santa Clarita, CAthe pilot's failure to maintain adequate clearance from terrain during low altitude maneuvers.Nov 2, 2003 · N99192 · DestroyedNTSB ATL04LA033Accident · Minor injuriesLimited investigationFinal reportBartholomew Firestar · Waxhaw, NCThe pilot's failure to maintain airspeed while maneuvering on final approach resulting in an inadvertent stall and in-flight collision with trees and the ground.Nov 2, 2003 · N432JR · Substantial damageNTSB MIA04LA015Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Ocala, FLThe failure of the dual student to maintain airspeed (VS) and the CFI's improper supervision while turning to reverse direction resulting in an inadvertent stall/spin and collision with trees and the ground during the resultant uncontrolled descent.Oct 30, 2003 · N5519K · Substantial damageNTSB MIA04CA010Accident · Minor injuriesData collectionFinal reportCessna 152 · Pierson, FLIn flight collision with a bird, resulting in airplane not being able to maintain altitude and nosing over during a forced landing on unsuitable terrain.Oct 22, 2003 · N94445 · Substantial damageNTSB ATL04FA023Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Spencer, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and the subsequent collision with the ground.Oct 22, 2003 · N69190 · DestroyedNTSB MIA04FA008Accident · 2 fatalField investigationFinal reportBell 47G-2A-1 · Balm, FLThe pilot's intentional buzzing and his failure to maintain altitude/clearance which resulted in an in-flight collision with a building.Oct 21, 2003 · N73979 · DestroyedNTSB CHI04LA017Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Evansville, MNThe pilot's misjudgment of clearance from the surface of the lake during the aerial application pass. The low altitude operation, glassy water, and his visual perception were contributing factors.Oct 21, 2003 · N49TJ · Substantial damageNTSB SEA04FA009Accident · 1 fatalField investigationFinal reportBeech A36 · Seaside, ORThe pilot's failure to maintain clearance from objects while maneuvering. High winds, gusts and rain were factors.Oct 20, 2003 · N136SB · DestroyedNTSB FTW04LA014Accident · 1 fatalLimited investigationFinal reportRans S-10 · Ponder, TXThe pilot's decision to conduct low altitude maneuvering flight and his failure to maintain adequate airspeed.Oct 19, 2003 · N190SP · DestroyedNTSB SEA04FA006Accident · 2 fatalField investigationFinal reportCessna 340A · Scappoose, ORThe pilot's failure to maintain airspeed while maneuvering. An inadvertent stall, the pilot's failure to follow engine operation procedures and engine detonation were factors.Oct 18, 2003 · N340P · DestroyedNTSB FTW04LA010Accident · 1 fatalLimited investigationFinal reportGeneral Motors FM-2 · Houston, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin while maneuvering to land.Oct 18, 2003 · N681S · DestroyedNTSB CHI04LA015Accident · 1 fatalLimited investigationFinal reportSchweizer 269C · Fenton, MIThe intentional low altitude flight maneuvering and the ostentatious display by the pilot. The water was a factor to the accident.Oct 18, 2003 · N456JP · Substantial damageNTSB NYC04LA011Accident · 2 fatalLimited investigationFinal reportCessna 150M · Wax, KYThe pilot's failure to maintain obstacle clearance. Low altitude flight is a contributing factor.Oct 16, 2003 · N3807V · Substantial damageNTSB LAX04LA015Accident · No injuriesLimited investigationFinal reportBell UH-1B · Durham, CASeparation of the power turbine shaft retaining bolt resulting in extensive power turbine area damage and a loss of shaft output power.Oct 16, 2003 · N234SJ · Substantial damageNTSB FTW04LA009Accident · Minor injuriesLimited investigationFinal reportAyres · Midland, TXA loss of engine power due to a ruptured oil line. A contributing factor was the lack of suitable terrain available for the forced landing.Oct 15, 2003 · N4013Z · Substantial damageNTSB SEA04LA005Accident · 2 fatalLimited investigationFinal reportBell 206B · Swisshome, ORThe pilot's failure to maintain clearance from power lines while maneuvering. The power line, mountainous terrain with high obstructions (thick trees and underbrush) and the operators failure to maintain a "hazard map" as indicated in their procedures manual…Oct 14, 2003 · N86W · Substantial damageNTSB LAX04LA012Accident · Serious injuriesLimited investigationFinal reportRockwell International S-2R · Lemoore, CAa loss of control for undetermined reasons.Oct 13, 2003 · N7950V · Substantial damageNTSB NYC04LA006Accident · 1 fatalLimited investigationFinal reportExtra Flugzeugbau EA-300L · Queen Anne, MDThe pilot's performance of aerobatic maneuvers with positive and negative Gs, which resulted in a G induced loss of control, and uncontrolled impact with the ground.Oct 12, 2003 · N18NL · DestroyedNTSB DEN04LA008Accident · No injuriesLimited investigationFinal reportCessna 182R · Lysite, WYthe pilot's fuel mismanagement resulting in the loss of engine power and the subsequent forced landing. A contributing factor was the lack of suitable terrain for a forced landing and the nose over.Oct 12, 2003 · N4981E · Substantial damageNTSB ATL04LA014Accident · Minor injuriesLimited investigationFinal reportMcCan Velox Revolution II · Mooresville, NCThe pilot's inadequate in-flight planning/decision to conduct an aerobatic maneuver at an altitude too low to initiate a recovery.Oct 12, 2003 · N296VX · DestroyedNTSB FTW04FA007Accident · 3 fatalField investigationFinal reportBell 206L-3 · W. Cameron 509The pilot's loss of control following an inadvertent encounter with adverse weather conditions. Contributing factors were the prevailing thunderstorms, the low ceilings, and the miscommunication between the pilot and the company's communication center in…Oct 10, 2003 · N81671 · DestroyedNTSB CHI04LA007Accident · 1 fatalLimited investigationFinal reportAviat Pitts S-2B · Cromwell, MNThe altitude/clearance not maintained by the pilot while performing aerobatic maneuvers. Contributing factors were the planning/decision to perform an aerobatic maneuver at a low altitude.Oct 10, 2003 · N68PS · DestroyedNTSB NYC04LA004Accident · 1 fatalLimited investigationFinal reportPfeifler Edge-540 · Warrenton, VAThe pilot's failure to maintain aircraft control while performing aerobatic maneuvers.Oct 7, 2003 · N540SH · Destroyed