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 DFW05LA252Accident · Minor injuriesLimited investigationFinal reportBell 206B · Myrtle Grove, LAThe pilot's loss of control in flight for undetermined reasons.Sep 1, 2005 · N59539 · Substantial damageNTSB LAX05LA324Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Mountain City, NVThe pilot's failure to maintain airspeed while maneuvering in mountainous terrain, which led to a stall and impact with trees and terrain.Aug 31, 2005 · N2333J · Substantial damageNTSB LAX05LA283Accident · 1 fatalLimited investigationFinal reportAvions Robin R.2160 · Avalon, CAThe flight instructor's unsuccessful recovery from a spin. The underlying reason was not determined.Aug 31, 2005 · N216RN · DestroyedNTSB SEA05FA181Accident · 2 fatalField investigationFinal reportPiper PA-14 · Challis, IDThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. A contributing factor was the pilot's diverted attention while spotting/locating Rocky Mountain Bighorn sheep.Aug 27, 2005 · N5104H · DestroyedNTSB SEA05CA182Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Boise, IDInadequate communications between the certified flight instructor and student pilot, and the student pilot's delay in relinquishing controls resulting in a hard landing during a practice autorotation.Aug 27, 2005 · N845SH · Substantial damageNTSB NYC05FA138Accident · 1 fatalField investigationFinal reportCessna 172C · Winthrop, METhe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing and impact with terrain.Aug 27, 2005 · N1680Y · Substantial damageNTSB DEN05LA130Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Falcon, COthe pilot's failure to maintain control of the helicopter while conducting a hovering maneuver.Aug 25, 2005 · N777UH · Substantial damageNTSB LAX05TA277Accident · Minor injuriesFinal reportWSK PZL Mielec M-18A · Elko, NVthe pilot's failure to adequately plan for the wind direction and speed during a fire retardant delivery flight, which led to a loss of true airspeed, failure to attain a proper climb rate, and the in-flight collision with mountainous terrain. Contributing…Aug 23, 2005 · N7077N · Substantial damageNTSB ATL05LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Colquitt, GAThe pilot's failure to maintain visual lookout and clearance from obstacles while maneuvering at low altitude, which resulted in an in-flight collision with a tree and subsequent uncontrolled descent into the ground.Aug 21, 2005 · N7399Z · Substantial damageNTSB LAX05LA273Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Palos Verdes, CAa loss of engine power due to the cyclic fatigue failure and separation of the number 4 piston.Aug 20, 2005 · N294T · DestroyedNTSB ATL05FA145Accident · 1 fatalField investigationFinal reportCessna 310R · Apopka, FLThe pilot's failure to maintain adequate visual lookout and object clearance, which resulted in the in-flight collision with trees.Aug 17, 2005 · N2631E · Substantial damageNTSB SEA05LA172Accident · 2 fatalLimited investigationFinal reportMK II Legacy Sport · Madras, ORThe pilot's failure to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall/spin and subsequent collision with the ground.Aug 16, 2005 · N359L · Substantial damageNTSB SEA05CA173Accident · No injuriesData collectionFinal reportHughes 369E · Donnelly, IDThe pilot's failure to maintain clearance of a tree during a landing attempt due to loss of visibility from a self induced brown-out condition. Contributing factors were the pilot's failure to identify a hazardous landing site, and the tree.Aug 16, 2005 · N500FU · Substantial damageNTSB DFW05CA231Accident · No injuriesData collectionFinal reportBell 47 · Monette, ARThe loss of control as result of a loss of hydraulic pressure for undetermined reasons.Aug 16, 2005 · N8494E · DestroyedNTSB SEA05FA169Accident · 3 fatalField investigationFinal reportCessna 177RG · Cascade, IDThe pilot's failure to maintain clearance from a stand of conifer trees during low altitude maneuvering in mountainous terrain. Factors include the mountainous/hilly terrain, gusty winds, a high density altitude, and maneuvering at a low altitude.Aug 13, 2005 · N2082Q · DestroyedNTSB DFW05LA215Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Joiner, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Aug 13, 2005 · N9101R · Substantial damageNTSB LAX05FA264Accident · 1 fatalField investigationFinal reportSan Joaquin Helicopters OH-58A+ · Lancaster, CAThe pinion to turbine shaft coupling failed in fatigue due to a misaligned turbine shaft, which resulted in a loss of engine power.Aug 10, 2005 · N177SJ · Substantial damageNTSB DFW05CA208Accident · Serious injuriesData collectionFinal reportHiller UH-12E · Hampton, ARA loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was unsuitable terrain to complete a successful autorotation.Aug 10, 2005 · N535HA · Substantial damageNTSB DFW05CA209Accident · No injuriesData collectionFinal reportRockwell S-2R · Lyford, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Aug 9, 2005 · N7794V · Substantial damageNTSB DFW05CA207Accident · No injuriesData collectionFinal reportGrumman G-164 · Knobel, ARThe loss of engine power due to the failure of the #1 cylinder head. A contributing factor was the lack of suitable terrain for the forced landing.Aug 9, 2005 · N9041Q · Substantial damageNTSB CHI05LA234Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Georgetown, MNThe reported loss of engine power for undetermined reasons while maneuvering and the low altitude of the operation. Related factors were the unsuitable terrain encountered by the pilot, and trees.Aug 9, 2005 · N553Y · Substantial damageNTSB ANC05LA118Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12D-85 · Wasilla, AKThe total loss of engine power for an unknown reason while maneuvering, which precipitated an emergency descent and landing, and resulted in an in-flight collision with power lines and trees. A factor associated with the accident was the power lines.Aug 9, 2005 · N5616M · Substantial damageNTSB DFW05CA211Accident · No injuriesData collectionFinal reportSchleicher ASW-27b · Encinal, TXThe pilot's misjudgment of distance and altitude during a cross-country soaring flight. A contributing factor was the lack of suitable terrain for the landing.Aug 8, 2005 · N274DW · Substantial damageNTSB DFW05FA204Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Cypress, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.Aug 6, 2005 · N3209K · Substantial damageNTSB DEN05TA119Accident · Serious injuriesFinal reportHughes 369HS · Albuquerque, NMthe bullet(s), which severed the helicopter's left tail rotor pedal. Contributing factors were the severed anti-torque pedal and the unsuitable terrain for landing.Aug 6, 2005 · N500SD · Substantial damageNTSB SEA05FA158Accident · 2 fatalField investigationFinal reportCessna 150M · Renton, WAThe failure of the DHC-2 Beaver pilot to understand air traffic advisory information and the failure of the Cessna pilot to maintain visual separation, resulting in a midair collision. A factor contributing to the accident was the inadequate traffic advisory…Aug 5, 2005 · N66234 · 2 aircraft · DestroyedNTSB SEA05LA164Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Driggs, IDThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern for landing. The pilot's failure to maintain a proper altitude was a factor.Aug 4, 2005 · N153SS · Substantial damageNTSB MIA05CA144Accident · Minor injuriesData collectionFinal reportGrumman American G-164 · Sabana Grande, PRThe pilot's inadvertent encounter with a downdraft in mountainous terrain resulting in an uncontrolled descent and collision with the terrain.Aug 4, 2005 · N460Y · Substantial damageNTSB CHI05LA211Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Buchanan, NDThe pilot failed to maintain obstacle clearance from the power lines. Factors included the glare on the windshield and the power lines.Aug 4, 2005 · N6858Q · DestroyedNTSB NYC05LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Felton, DEThe mechanic's inadequate annual inspection, and failure to comply with an airworthiness directive, which resulted in a total failure of the second stage turbine rotor.Aug 1, 2005 · N5495 · Substantial damageNTSB CHI05CA207Accident · No injuriesData collectionFinal reportAllied Ag Cat Productions G-164A · Trufant, MIThe pilot's inadequate visual lookout and not maintaining clearance from the watering pivot during the aerial application maneuver and the unsuitable terrain he encountered during the emergency landing. A factor was the sunglare encountered.Jul 31, 2005 · N8951H · Substantial damageNTSB DFW05LA193Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540-T · Denison, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the low altitude.Jul 30, 2005 · N95DE · DestroyedNTSB DFW05CA195Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · New Braunfels, TXThe student pilot's failure to maintain control of the helicopter and delayed remedial action by the flight instructor.Jul 30, 2005 · N18VH · Substantial damageNTSB CHI05GA198Accident · Serious injuriesFinal reportBell 206L-3 · Justice, ILThe pilot's improper in-flight decision while maneuvering which resulted in a tailwind during low airspeed helicopter flight and subsequent loss of tail rotor effectiveness. The struck sign and fence were factors in the accident.Jul 26, 2005 · N741LL · DestroyedNTSB CHI05FA197Accident · 1 fatalField investigationFinal reportNorth American F-51D · Malone, WIThe pilot not maintaining aircraft control and clearance from terrain for undetermined reasons during a low level maneuver.Jul 26, 2005 · N6327T · DestroyedNTSB IAD05LA107Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Plymouth, MAFatigue failure of the intermediate tailrotor driveshaft, which resulted in a loss of directional control at a hover.Jul 24, 2005 · N9018Y · Substantial damageNTSB DFW05CA189Accident · No injuriesData collectionFinal reportRockwell International S-2R · Hamlin, TXThe failure of the propeller blade seal resulting in an oil leak. Contributing factors were the limited forward visibility and lack of suitable terrain for the precautionary landing.Jul 23, 2005 · N4946X · Substantial damageNTSB IAD05LA108Accident · No injuriesLimited investigationFinal reportRobinson R22 · Nashua, NHThe flight instructor's failure to maintain aircraft control during a introductory flight and his inadequate remedial actions.Jul 22, 2005 · N8041J · Substantial damageNTSB LAX05LA241Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Beaumont, CAthe pilot's failure to maintain an adequate airspeed while maneuvering that led to an inadvertent stall/mush. The pilot's delayed decision to release the banner was also causal.Jul 21, 2005 · N629AP · Substantial damageNTSB DFW05CA186Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164A · Tallulah, LAThe partial loss of engine power as result of the fracture of the number five-cylinder exhaust valve rocker arm mounting boss. A contributing factor was the lack of suitable terrain for the forced landing.Jul 21, 2005 · N8891H · Substantial damageNTSB DFW05FA185Accident · 3 fatalField investigationFinal reportMooney M20J · Saginaw, TXThe pilot's loss of control for undetermined reasons while maneuvering.Jul 20, 2005 · N5670M · DestroyedNTSB CHI05FA194Accident · 1 fatalField investigationFinal reportCessna 172P · Jackson, WIThe pilot not maintaining aircraft control for undetermined reasons while maneuvering.Jul 20, 2005 · N65875 · DestroyedNTSB DEN05TA113Accident · Minor injuriesFinal reportHughes 369FF · Loveland, COThe pilot's failure to maintain aircraft control due to delayed remedial action during the encounter with the loss of tail rotor effectiveness. Contributing factors were the pilot's inadequate preflight performance planning, and the inadequate supervision by…Jul 19, 2005 · N530TJ · DestroyedNTSB SEA05LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bonners Ferry, IDThe pilot's failure to maintain terrain clearance while maneuvering. Mountainous terrain was a factor.Jul 17, 2005 · N120ER · Substantial damageNTSB LAX05CA232Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Mesa, AZthe improper use of the throttle and antitorque pedal by the pilot undergoing instruction, and the inadequate supervision of the flight by the certified flight instructor.Jul 15, 2005 · N7514P · Substantial damageNTSB DFW05LA190Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Black Oak, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jul 15, 2005 · N4087L · Substantial damageNTSB CHI05LA188Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Langdon, NDThe pilot's failure to maintain clearance from the terrain while attempting an abrupt turning maneuver at a low altitude.Jul 15, 2005 · N3159N · DestroyedNTSB LAX05GA231Accident · 2 fatalFinal reportEurocopter France EC120B · Fair Oaks, CAThe failure of the constant delta P diaphragm in the fuel control unit, which resulted in an increased fuel flow and subsequent catastrophic failure of the engine. The diaphragm's failure was the result of improper installation by the engine manufacturer. A…Jul 14, 2005 · N266SD · DestroyedNTSB DFW05LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Bonita, LAThe failure of the pilot to maintain adequate visual lookout, which resulted in a midair collision.Jul 14, 2005 · N61220 · 2 aircraft · Substantial damageNTSB CHI05FA192Accident · No injuriesField investigationFinal reportAerospatiale AS365N · Valparaiso, INThe loose tail rotor drive shaft coupling due to its improper installation by the operator's maintenance personnel, which resulted in the failure of the tail rotor drive shaft. An additional cause was the inability of the pilot to maintain control of the…Jul 14, 2005 · N365S · Substantial damage