OpenAirDocs.org

NTSB investigations

18,851 cases where the phase of flight was Maneuvering.

Cases, newest first

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.\"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 DEN03LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Newcastle, WYthe pilot's failure to maintain clearance from the terrain. Contributing factors include inadequate in-flight planning and decision making by the pilot, and the ground.Apr 1, 2003 · N6883B · Substantial damageNTSB ANC03LA038Accident · No injuriesLimited investigationFinal reportHughes 369D · Tyonek, AKThe pilot's inadequate visual lookout while lifting into a hover to ensure the helicopter was clear of all objects, which resulted in separation of an external mirror that then struck and damaged a main rotor blade. Factors in the accident were the presence…Mar 31, 2003 · N90431 · Substantial damageNTSB FTW03FA118Accident · 2 fatalField investigationFinal reportBell 407 · Broadus, TXThe partial loss of engine power due to erratic fuel flow metering to the engine resulting from the single point failure of the PLA potentiometer in the hydro-mechanical fuel control unit. A contributing factor was the lack of suitable terrain to execute a…Mar 27, 2003 · N175PA · DestroyedNTSB DEN03FA059Accident · 4 fatalField investigationFinal reportCessna A185F · Grand Junction, COthe pilot's poor judgment and his failure to maintain aircraft control. Contributing factors were the high winds and downdrafts, and the pilot's self-induced pressure to go home.Mar 27, 2003 · N53008 · DestroyedNTSB SEA03LA050Accident · No injuriesLimited investigationFinal reportHiperlight SNS-8 · South Prairie, WAThe failure of the pilot to maintain control of the aircraft during the crosswind turn resulting in an inadvertent spin entry, followed by his intentional stall to a landing resulting in a hard landing and subsequent nose over.Mar 25, 2003 · UNREG · Substantial damageNTSB FTW03LA115Accident · No injuriesLimited investigationFinal reportCessna FA150K · Houston, TXThe in-flight separation of the elevator trim tab.Mar 23, 2003 · N922SZ · Substantial damageNTSB ATL03FA065Accident · 1 fatalField investigationFinal reportSikorsky S-61A · Kimble, TNThe interruption of rotor system drive power due to the input free wheeling unit malfunctioning , and the pilot's operation of the helicopter in the critical area of the height-velocity curve.Mar 23, 2003 · N81664 · DestroyedNTSB MIA03LA079Accident · 1 fatalLimited investigationFinal reportTechno Avia SP-95 · Panama City, FLThe pilot's attempted abrupt maneuver at a low altitude resulting in loss of control and collision with terrain before control could be regained.Mar 22, 2003 · N195SF · Substantial damageNTSB CHI03LA089Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Raymond, MNThe altitude/clearance not maintained by the pilot and his ostentatious display. The power lines and the pilot's maneuvering at low altitude were contributing factors.Mar 22, 2003 · N1814G · Substantial damageNTSB ATL03FA064Accident · 2 fatalField investigationFinal reportCessna 172S · Monroe, GAThe pilot’s exceedence of the design limits of the airplane, which resulted in the overload failure of the horizontal stabilizers, followed by the overload separation of the right wing and subsequent loss of control.Mar 21, 2003 · N219ME · DestroyedNTSB MIA03FA077Accident · 1 fatalField investigationFinal reportChampion Aeronca 7BCM · Pahokee, FLThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall while maneuvering.Mar 18, 2003 · N2517E · Substantial damageNTSB ATL03LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Enterprise, ALThe loss of engine power due to oil starvation resulting from a crack in the propeller governor external oil line. A factor was the soft terrain.Mar 16, 2003 · N7635J · Substantial damageNTSB ATL03FA062Accident · 1 fatalField investigationFinal reportCessna 320D · Perry, GAThe pilot continued visual flight into instrument meteorological conditions, and his failure to maintain altitude/terrain clearance.Mar 16, 2003 · N4137T · Substantial damageNTSB NYC03LA063Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Zelienople, PAThe failure of the tail rotor assembly due to improper maintenance by the owner/pilot.Mar 8, 2003 · N2238U · Substantial damageNTSB MIA03FA068Accident · 1 fatalField investigationFinal reportBeech 36 · Captiva Island, FLThe pilot's VFR flight into instrument meteorological conditions and his ensuing failure to maintain altitude/clearance resulting in an in-flight collision with the ocean. A factor was the fog.Feb 28, 2003 · N41VK · DestroyedNTSB LAX03FA102Accident · 2 fatalField investigationFinal reportMitchell CH-801 · Nicholas, CAan in-flight structural failure due to the pilot exceeding the design limitations of the airplane. Drug impairment was a factor.Feb 28, 2003 · N235RJ · DestroyedNTSB MIA03LA070Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe intentional cutting of the hydraulic line by an unknown person resulting in the loss of hydraulic fluid and the inability of the pilot-in-command to extend and lock the main landing gear, and subsequent collapse of the main landing gear after touchdown.Feb 24, 2003 · N5177R · Substantial damageNTSB LAX03FA100Accident · 2 fatalField investigationFinal reportCessna 172N · Ely, NVthe pilot's failure to maintain adequate terrain clearance while flying in a box canyon.Feb 23, 2003 · N9885J · Substantial damageNTSB LAX03FA093Accident · 2 fatalField investigationFinal reportPiper PA-30 · Nipomo, CAthe flying pilot's failure to maintain an adequate airspeed that resulted in a stall/spin.Feb 22, 2003 · N9YB · Substantial damageNTSB ATL03LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Rome, GAThe maintenance personnel failure to secure the throttle linkage during the installation of the carburetor that resulted in the loss of engine power.Feb 22, 2003 · N8115F · Substantial damageNTSB SEA03LA040Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Garryowen, MTThe pilot in command's allowing the aircraft to inadvertently enter into a stall condition at low altitude while maneuvering. A contributing factor was the pilot's intentional low altitude maneuvering.Feb 20, 2003 · N24MF · Substantial damageNTSB FTW03LA112Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350-B3 · Clyde, TXthe pilot's delayed remedial action and his continued flight into known adverse weather conditions. A contributing factor was the excessive descent rate which resulted in a hard landing.Feb 20, 2003 · N439AE · Substantial damageNTSB CHI03LA074Accident · 1 fatalLimited investigationFinal reportNorth American/Aero Classics P-51D · Urbana, INThe pilot's failure to maintain aircraft control which resulted in a spin.Feb 20, 2003 · N93TF · DestroyedNTSB LAX03FA090Accident · Serious injuriesField investigationFinal reportCessna 172P · Santa Susana, CAThe flight instructor's inadequate in-flight decision to cross mountainous terrain at a inadequate altitude to guarantee terrain clearance.Feb 18, 2003 · N65005 · DestroyedNTSB LAX03LA089Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Stockton, CAfuel starvation due to the pilot's mismanagement of the fuel supply and failure to verify the fuel quantity on board at departure.Feb 16, 2003 · N5089V · Substantial damageNTSB IAD03LA033Accident · Serious injuriesLimited investigationFinal reportRotorway Exec 162F · Westford, MAThe inflight loss of control due to the loss of tail rotor effectiveness.Feb 15, 2003 · N241WC · Substantial damageNTSB MIA03LA057Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Pompano Beach, FLThe student pilot's failure to maintain control during takeoff which resulted in in uncontrolled descent and the helicopter impacting the ground.Feb 12, 2003 · N74842 · Substantial damageNTSB ANC03LA026Accident · No injuriesLimited investigationFinal reportHughes 369E · Paxson, AKThe pilot's failure to maintain altitude/clearance from terrain. A factor contributing to the accident was the pilot's attention being diverted inside the cockpit to look at the global positioning system.Feb 10, 2003 · N500DX · Substantial damageNTSB CHI03LA067Accident · No injuriesLimited investigationFinal reportBeech BE-G35 · Urbana, ILThe partial failure of the left stabilizer in overload.Feb 9, 2003 · N4668D · Substantial damageNTSB MIA03FA050Accident · 2 fatalField investigationFinal reportExtra Flugzeugbau EA300/L · Golden Gate, FLThe airplane's entry into a near vertical descent for undetermined reasons, which resulted in a collision with terrain during the resultant descent.Jan 31, 2003 · N33KL · DestroyedNTSB CHI03FA060Accident · 1 fatalField investigationFinal reportAgusta A109C · West Chicago, ILThe pilot's failure to maintain control of the helicopter while maneuvering, resulting in the excessive descent rate and impact with terrain. Factors to the accident included the dark night, low ceiling and reduced visibility at the time of the accident.Jan 29, 2003 · N109MX · DestroyedNTSB MIA03LA048Accident · No injuriesLimited investigationFinal reportCessna 172F · Jacksonville, FLa total loss of engine power due to the failure the oil filter because of over-pressurization, resulting in damage to the airplane during the subsequent forced landing.Jan 28, 2003 · N5602R · Substantial damageNTSB MIA03FA046Accident · 4 fatalField investigationFinal reportCessna M337B (O-2A) · Fernandina Bch, FLThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent collision with the ocean.Jan 26, 2003 · N52513 · DestroyedNTSB FTW03FA089Accident · Serious injuriesField investigationFinal reportCessna 208B · San Angelo, TXThe flight crew's failure to cycle the deice boots prior to conducting a simulated forced landing and their failure to maintain adequate airspeed during the maneuver, which resulted in an inadvertent stall and subsequent loss of control. A contributing factor…Jan 24, 2003 · N944FE · DestroyedNTSB ATL03LA037Accident · 1 fatalLimited investigationFinal reportLong 2000 · Brewton, ALThe pilot's improper use of flight controls (cyclic and collective) and failure to maintain rotor RPM while maneuvering that resulted in the separation of the tailboom assembly.Jan 24, 2003 · N8YF · Substantial damageNTSB FTW03FA086Accident · 1 fatalField investigationFinal reportCessna 152 · Norman, OKThe pilot's failure to maintain airspeed while maneuvering, resulting in an inadvertent stall . Factors contributing to the accident were the low altitude and the prevailing high winds.Jan 21, 2003 · N47257 · DestroyedNTSB SEA03FA028Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Eastsound, WAThe pilot's failure to maintain clearance from the water and his failure to reset the altimeter to the local barometric pressure. Contributing factors were fog and night conditions.Jan 19, 2003 · N7282C · DestroyedNTSB MIA03FA043Accident · 4 fatalField investigationFinal reportCessna 172P · Edgewater, FLThe pilot's inflight loss of control and the pilot's failure to recover from the resultant dive for unknown reasons which resulted in flight beyond the design stress limits of the airplane and subsequent in flight airframe breakup.Jan 18, 2003 · N65906 · DestroyedNTSB CHI03FA057Accident · 2 fatalField investigationFinal reportCirrus Design SR-22 · Hill City, MNSpatial disorientation experienced by the pilot, due to a lack of visual references, and a failure to maintain altitude. Contributing factors were the pilot's improper decision to attempt flight into marginal VFR conditions, his inadvertent flight into…Jan 18, 2003 · N9523P · DestroyedNTSB ANC03GA023Accident · Serious injuriesFinal reportBell 212 · McMurdo Station, AYThe pilot's continued operation of the helicopter with an unstable external load, which resulted in damage to the cargo hook assembly, adjacent throttle controls, and subsequent loss of engine power, precipitating an emergency descent and impact with terrain.…Jan 17, 2003 · N1079U · Substantial damageNTSB FTW03LA084Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Alamo, TXThe pilot's failure to maintain airspeed which resulted in a stall. Low altitude flight is a contributing factor.Jan 14, 2003 · N1537R · Substantial damageNTSB CHI03LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R22B · Oshkosh, WIThe directional control not maintained by the unrated helicopter pilot, and the remedial action not performed by the pilot-in-command. The pilot-in-command's lack of certification as a certified flight instructor and the dark night conditions were…Jan 14, 2003 · N530DB · Substantial damageNTSB NYC03LA037Accident · Serious injuriesLimited investigationFinal reportSikorsky S-61A · Glady, WVThe improper installation of the left tailrotor control cable by company maintenance personnel.Jan 12, 2003 · N8170V · Substantial damageNTSB IAD03LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · New Middleton, OHA jammed throttle control assembly for undetermined reasons.Jan 11, 2003 · N573PA · Substantial damageNTSB FTW03FA082Accident · 2 fatalField investigationFinal reportAgusta A-109-K2 · Salt Lake City, UTThe pilot's delayed remedial action and continued flight into known adverse weather conditions which resulted in his failure to maintain clearance with the ground. Contributing factors were the prevailing fog, and the pressure to complete the mission induced…Jan 11, 2003 · N601RX · DestroyedNTSB LAX03FA061Accident · 1 fatalField investigationFinal reportMooney M20C · Warner Springs, CAthe pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.Jan 8, 2003 · N5629Q · DestroyedNTSB DEN03FA030Accident · 1 fatalField investigationFinal reportSilvius Rans S-12XL · Laramie, WYthe pilot's failure to maintain aircraft control, resulting in an inadvertent stall/mush. Contributing factors include the pilot's use of an over-the-counter antihistamine, and the pilot's inadequate in-flight decision to fly at low altitude.Jan 6, 2003 · UNREG · DestroyedNTSB CHI03LA048Accident · 1 fatalLimited investigationFinal reportAir Command Commander Elite · Lansing, ILThe inadvertent pilot induced oscillation. Factor to the accident was the wind gusts.Jan 1, 2003 · UNREG · DestroyedNTSB FTW03LA072Accident · No injuriesLimited investigationFinal reportBell 206-L4 · High Island 471The pilot's attempt to takeoff during known adverse weather conditions and failure to maintain control of the helicopter while maneuvering. Contributing factors were the gusty and high wind conditions.Dec 31, 2002 · N177AL · Substantial damageNTSB FTW03LA068Accident · 2 fatalLimited investigationFinal reportBarber Glasair · Conroe, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall and a subsequent loss of control.Dec 28, 2002 · N3885J · Destroyed