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 FTW00LA181Accident · Minor injuriesLimited investigationFinal reportBell 206B · Deville, LAthe pilot's failure to maintain clearance with the external load that was setting on the ground while hovering. A contributing factor was the pilot's diverted attention.Jun 19, 2000 · N2277T · Substantial damageNTSB SEA00LA107Accident · 1 fatalLimited investigationFinal reportHaessler Cosmo Phase II · Banks, ORThe pilot's improper installation, i.e., reversed connection, of the rudder control cables resulting in reverse rudder operation and a subsequent stall/spin. A contributing factor was the pilot's intentional design change/addition of a rudder to the aircraft.Jun 17, 2000 · N9022F · DestroyedNTSB LAX00FA230Accident · 2 fatalField investigationFinal reportMaule M4-210C · Willows, CAFailure of the pilot to maintain an adequate airspeed margin while maneuvering in steep turns at low altitude in gusty and strong tailwind conditions, which lead to a wind shear encounter and a stall/spin. A contributing factor in the accident was the pilot's…Jun 16, 2000 · N377BC · DestroyedNTSB LAX00FA231Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · San Jose, CAThe pilot's failure to maintain control of the airplane for undetermined reasons while intentionally performing an aerobatic maneuver.Jun 15, 2000 · N8659V · DestroyedNTSB CHI00GA160Accident · 2 fatalFinal reportSchweizer 269C · Topeka, KSthe pilot's failure to maintain translational lift while maneuvering, and the loss of tail rotor effectiveness. Factors relating to this accident were the tailwind, low airspeed, low rotor rpm, and the pilot's lack of overall experience in helicopters.Jun 13, 2000 · N9488F · DestroyedNTSB IAD00LA050Accident · Serious injuriesLimited investigationFinal reportBakeng Double Deuce · West Alexandria, OHthe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's failure to properly brief/communicate transfer of the flight controls to the pilot-rated passenger.Jun 11, 2000 · N1056G · Substantial damageNTSB LAX00LA220Accident · Serious injuriesLimited investigationFinal reportSikorsky HH-3F · Wellington, NVthe pilot's encounter with a wind shear while maneuvering at low altitude in mountainous terrain, which resulted in a high descent rate and inadvertent entry into a power settling condition.Jun 10, 2000 · N500XL · Substantial damageNTSB SEA00LA103Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Kennewick, WAThe pilot's exceedance of the helicopter's hovering capabilities in a downwind hover. Factors included tailwind conditions, the pilot's lack of experience in the type of operation being conducted, and trees in the area where the helicopter settled.Jun 8, 2000 · N80193 · Substantial damageNTSB CHI00LA151Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Maddock, NDAircraft control not being maintained by the pilot. Factors to the accident were the turbulent weather condition, the inadvertent stall, and the inadequate weather evaluation by the pilot.Jun 7, 2000 · N8515L · DestroyedNTSB SEA00LA099Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilots failure to maintain clearance from power transmission lines.Jun 5, 2000 · N6549K · Substantial damageNTSB LAX00LA216Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Brentwood, CAThe student's improper execution of a quick-stop maneuver in that he misjudged his altitude and failed to terminate at a stationary hover prior to descending to a low hover. This resulted in an excessive engine power requirement and the student improperly…Jun 5, 2000 · N2029H · Substantial damageNTSB DEN00FA102Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Kiowa, COthe flight instructor's failure to maintain aircraft control while practicing stall maneuvers, which resulted in an inadvertent spin.Jun 5, 2000 · N67BJ · DestroyedNTSB MIA00GA184Accident · 1 fatalFinal reportBell UH-1H · Fort Myers, FLthe pilot's failure to maintain control of the helicopter for undetermined reasons. Factors in this accident were self-induced pressure and fatigue due to lack of sleep and rest.Jun 4, 2000 · N127FC · DestroyedNTSB SEA00LA097Accident · No injuriesLimited investigationFinal reportBell 212 · Eugene, ORInadequate quality control by the manufacturer during the manufacturing process, which led to the total failure of a fastener, and the separation of the tail rotor blade balance weight. An adhesive debond between the adhesive and the surface was a factor.Jun 3, 2000 · CFHDY · Substantial damageNTSB LAX00TA212Accident · Minor injuriesFinal reportPiper PA-18-150 · Austin, NVLoss of engine power caused by a fuel soaked float pontoon causing an over rich fuel/air mixture, in a critical phase of flight.Jun 1, 2000 · N4872A · Substantial damageNTSB FTW00LA166Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pioneer, LAThe pilot's failure to maintain clearance with trees while maneuvering during an aerial application flight. A factor was the pilot's lack in experience with aerial application flight operations.Jun 1, 2000 · N70114 · DestroyedNTSB FTW00LA162Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401B · Thibodaux, LAThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A factor was the sunglare on the windscreen.Jun 1, 2000 · N5028Q · Substantial damageNTSB MIA00LA180Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Stockbridge, GAan in-flight collision with trees while maneuvering, which was the result of the pilot not allowing adequate altitude to clear the trees before starting a turn.May 31, 2000 · N2589H · Substantial damageNTSB FTW00LA159Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXThe failure of the supercharger seal resulting in the loss of engine power. A factor was the lack of suitable terrain for the forced landing.May 30, 2000 · N8594S · Substantial damageNTSB FTW00LA157Accident · Minor injuriesLimited investigationFinal reportPzl-Mielec M-18A · Marmaduke, ARThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/mush.May 30, 2000 · N2065S · DestroyedNTSB MIA00FA172Accident · 2 fatalField investigationFinal reportAvions Mudry ET Cie CAP 10B · Bunnell, FLA midair collision due to the failure of the wingman to maintain proper clearance between his aircraft and the lead aircraft while conducting formation aerobatics and the subsequent loss of control of both aircraft resulting in an uncontrolled descent and…May 27, 2000 · N82BW · 2 aircraft · DestroyedNTSB LAX00FA207Accident · 2 fatalField investigationFinal reportCessna 172RG · Prescott, AZThe flight instructor's delayed remedial action, and his failure to correct an inappropriate descent during maneuvering flight, while engaged in commercial flight training maneuvers.May 27, 2000 · N5207U · DestroyedNTSB DEN00FA095Accident · 3 fatalField investigationFinal reportCessna T210K · Buena Vista, COthe pilot's disregard of the weather forecast, and his VFR flight into IMC. Contributing factors were snow showers, fog, and the mountainous terrain.May 26, 2000 · N9457M · DestroyedNTSB NYC00LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Toms River, NJThe failure of the number 9 cylinder connecting rod, due to a primer leak initiation of a partial hydraulic lock. A factor in the accident was the unsuitable terrain, to which the forced landing had to be made.May 25, 2000 · N910X · Substantial damageNTSB FTW00FA154Accident · 2 fatalField investigationFinal reportCessna 152 · Noble, OKthe failure of both pilots to maintain visual lookout.May 25, 2000 · N45973 · 2 aircraft · DestroyedNTSB MIA00LA170Accident · No injuriesLimited investigationFinal reportSouthwest Florida SW204 · Fort Pierce, FLAn in-flight separation of a tail rotor blade tip weight resulting in tail rotor assembly imbalance and separation due to the installation of an unapproved rotor blade by company maintenance personnel, and the subsequent collision with trees during an…May 24, 2000 · N37BA · Substantial damageNTSB NYC00LA142Accident · No injuriesLimited investigationFinal reportHeli-Eagle Ultrasport 496 · Newport News, VAThe pilot's failure to maintain control of the helicopter.May 23, 2000 · N9258H · Substantial damageNTSB FTW00LA149Accident · Serious injuriesLimited investigationFinal reportPZL-Mielec M-18A · Kilbourne, LAThe corrosion and fatigue cracking of the right wing attachment fitting, which resulted in the right wing separating in flight.May 22, 2000 · N2296C · DestroyedNTSB CHI00LA144Accident · No injuriesLimited investigationFinal reportCessna C-T188C · Elgin, NDthe failure of the pilot in command to maintain clearance with the ground during an aerial application.May 22, 2000 · N2075J · Substantial damageNTSB CHI00FA139Accident · 1 fatalField investigationFinal reportWsk Pzl Mielec M-18A · Muskegon, MIthe pilot's failure to maintain clearance from the trees. Factors relating to this accident were the low altitude and the trees.May 20, 2000 · N178RA · DestroyedNTSB LAX00LA199Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Biggs, CAThe broken exhaust valve rocker arm of the number 3 cylinder that resulted in a total loss of engine power during an aerial application flight.May 18, 2000 · N5335 · Substantial damageNTSB NYC00FA136Accident · 1 fatalField investigationFinal reportBell UH-1H · Frenchville, PAForeign object damage to the compressor and turbine sections of the engine, which resulted in a loss of power.May 16, 2000 · N52AG · Substantial damageNTSB DEN00GA089Accident · 2 fatalFinal reportCessna T337C · Alamogordo, NMthe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/spin. Contributing factors were the loss of engine power on both engines for unknown reasons and the terrain induced turbulence.May 15, 2000 · N2522S · DestroyedNTSB MIA00LA153Accident · 2 fatalLimited investigationFinal reportMclarty Vans RV-4 · Apex, NCThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall and subsequent collision with terrain.May 14, 2000 · N45DR · Substantial damageNTSB CHI00LA137Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Ionia, KSthe partial engine failure for undetermined reasons and the unsuitable terrain for landing encountered by the pilot. A factor to the accident was the hilly terrain condition.May 14, 2000 · N9198W · Substantial damageNTSB LAX00LA193Accident · Minor injuriesLimited investigationFinal reportSikorsky S61A · Eureka, CAthe loss of power in all engines due to the pilot's inadequate in-flight decision to continue flight with fuel level below the landing minimums specified in the flight manual, which resulted in the unporting of the fuel supply line and fuel starvation. A…May 11, 2000 · N693CC · Substantial damageNTSB MIA00LA149Accident · 2 fatalLimited investigationFinal reportMorphew Pitts Model 12 · New Smyrna Bch, FLthe pilot's loss of control in flight for undetermined reasons.May 9, 2000 · N69BM · DestroyedNTSB NYC00FA127Accident · Serious injuriesField investigationFinal reportEurocopter BK-117-A4 · Cincinnati, OHthe pilot's misjudgment of his closure rate, while turning to land on the rooftop helipad, which resulted in a collision with the building. Factors in the accident were the tailwind and the stuck windsock.May 7, 2000 · N911NC · Substantial damageNTSB FTW00TA142Accident · 1 fatalFinal reportAir Tractor AT-802A · Fort Stockton, TXThe pilot's failure to maintain clearance with the antenna tower. A factor was the smoke weather condition.May 7, 2000 · N60471 · DestroyedNTSB MIA00LA145Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Metter, GAthe pilot's failure to maintain an adequate lookout resulting in a collision with a transmission wire that resulted in a forced landing and substantial damage to the helicopter.May 6, 2000 · N80584 · Substantial damageNTSB IAD00LA039Accident · Minor injuriesLimited investigationFinal reportRotorway Rotorway 162F Exec · Mcmurray, PAThe pilot's improper in-flight planning and decision to hover out of ground effect which resulted in a loss of tail rotor effectiveness.May 6, 2000 · N162RS · Substantial damageNTSB FTW00LA140Accident · Serious injuriesLimited investigationFinal reportBell 206-L4 · Bailey, COThe pilot's failure to maintain control of the helicopter while maneuvering. A factor was the high density altitude weather conditions.May 6, 2000 · N52192 · Substantial damageNTSB DEN00FA084Accident · 3 fatalField investigationFinal reportAerospatiale AS-350B · Blanding, UTthe pilot's loss of aircraft control due to abrupt flight maneuvering. Contributing factors were the high density altitude weather condition, the total loss of engine power due to the pilot manually introducing excessive fuel into the engine and over temping…May 4, 2000 · CGPTT · DestroyedNTSB DEN00FA082Accident · 2 fatalField investigationFinal reportMcDonnell Douglas 369E · Bloomfield, NMThe pilot's intentional buzzing (low level flying), and his failure to maintain clearance with the static wire. A factor was his physical impairment by a contraindicated drug controlled substance.May 2, 2000 · N1606K · DestroyedNTSB DEN00LA079Accident · 1 fatalLimited investigationFinal reportGreen GTX-SE-FI · Gillette, WYThe pilot's abruptly pulling the nose up at an excessive airspeed, resulting in the rotor blades striking the vertical stabilizer and a subsequent loss of aircraft control.Apr 30, 2000 · N2411V · DestroyedNTSB SEA00FA080Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Fort Smith, MTThe pilot's failure to maintain clearance from the terrain. Factors include low ceilings, snow, rain, and rising, mountainous/hilly terrain.Apr 29, 2000 · N216BC · Substantial damageNTSB LAX00LA172Accident · 1 fatalLimited investigationFinal reportRobinson R22 Beta · San Diego, CAThe failure of the flight instructor to maintain control of the helicopter, resulting in skid contact with an obstacle and dynamic roll over.Apr 27, 2000 · N622EH · DestroyedNTSB LAX00FA171Accident · 2 fatalField investigationFinal reportCessna 152 · Austin, NVThe pilot's decision to attempt flight in an area of high rising mountainous terrain at an inadequate altitude, which resulted in an impact during a turn to reverse direction. A contributing factor was the pilot's lack of total experience in mountain flying…Apr 25, 2000 · N67435 · DestroyedNTSB CHI00LA121Accident · No injuriesLimited investigationFinal reportHughes 500C · Salina, KSthe loss of tail rotor effectiveness and the autorotation performed by the pilot. The unfavorable wind was a contributing factor.Apr 24, 2000 · N9177F · Substantial damageNTSB LAX00FA169Accident · 1 fatalField investigationFinal reportAir Tractor 502A · Queen Creek, AZThe fatigue failure and in-flight separation of the left wing due to the manufacturer's underestimation during the aircraft design process of the time interval from fatigue crack initiation to failure, and, the manufacturer's subsequent specification of an…Apr 22, 2000 · N15466 · Destroyed