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 DEN99LA160Accident · Minor injuriesLimited investigationFinal reportBell UH-1H · Silverton, COThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Sep 6, 1999 · N4085L · Substantial damageNTSB FTW99LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Randalette, OKThe failure of the pilot to maintain clearance with the telephone pole. A factor was the sunglare.Sep 5, 1999 · N731PW · Substantial damageNTSB ANC99LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Kenai, AKThe pilot's inadvertent stall. A factor was the intentional low altitude maneuvering by the pilot.Sep 5, 1999 · N3903Z · Substantial damageNTSB FTW99LA252Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Seminole, TXThe pilot's failure to maintain clearance with powerlines. A factor was the pilot's diverted attention to the light bar for the electronic swath guidance system installed in the airplane.Sep 3, 1999 · N7362 · DestroyedNTSB NYC99LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Greenville, METhe pilot in command's inattentive management of the fuel supply.Sep 2, 1999 · N2584P · Substantial damageNTSB FTW99LA251Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Big Spring, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.Sep 2, 1999 · N4660M · Substantial damageNTSB CHI99FA332Accident · 1 fatalField investigationFinal reportPiper PA-12 · Neguanee, MIthe pilot failed to maintain clearance from the tower.Sep 2, 1999 · N91901 · DestroyedNTSB NYC99LA217Accident · No injuriesLimited investigationFinal reportHughes 269C · Utica, NYThe pilot's failure to maintain control of the helicopter while maneuvering, which resulted in a hard landing. A factor in this accident was the pilot's lack of total experience in helicopters.Sep 1, 1999 · N58397 · Substantial damageNTSB MIA99LA242Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-29 · Fort Lauderdale, FLan in-flight failure of the right aileron due to fatigue cracking in the attachment structure of the right inboard aerodynamic compensator, which resulted in a loss of control, a forced landing, and subsequent impact with the ground.Sep 1, 1999 · N52PB · DestroyedNTSB LAX99LA292Accident · 2 fatalLimited investigationFinal reportHughes 369HS · Pohnpei (Pacific Ocean)An in-flight collision with the water for undetermined reasons.Sep 1, 1999 · N42054 · DestroyedNTSB DEN99FA158Accident · 2 fatalField investigationFinal reportWroblewski RV-4 · Bayfield, COThe pilot's failure to maintain control of the aircraft for undetermined reasons.Sep 1, 1999 · N95PW · DestroyedNTSB DEN99FA157Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Villa Grove, COThe flight instructor's improper inflight decision to enter a narrow blind/box canyon, and his misjudgment of the vertical and lateral clearances. A factor was the downdrafts.Sep 1, 1999 · N4366D · DestroyedNTSB SEA99LA151Accident · 1 fatalLimited investigationFinal reportRotordyne 200 · Kent, WAThe owner/builder's failure to properly torque the rotor blade retaining bolts.Aug 31, 1999 · N85Z · DestroyedNTSB IAD99LA061Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19 · Bedminster, NJthe pilot's medical incapacitation after suffering a massive stroke.Aug 29, 1999 · N19DQ · DestroyedNTSB ANC99FA128Accident · 2 fatalField investigationFinal reportCessna 170B · Cooper Landing, AKThe pilot's inadvertent stall.Aug 29, 1999 · N3402D · DestroyedNTSB CHI99LA317Accident · No injuriesLimited investigationFinal reportAyres S-2R · Brooten, MNthe compressor impeller failure and the unsuitable terrain for landing encountered by the pilot.Aug 28, 1999 · N8417V · Substantial damageNTSB FTW99LA239Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hart, TXThe pilot's failure to maintain clearance with power lines.Aug 25, 1999 · N15119 · Substantial damageNTSB NYC99FA210Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Saddle Island, METhe pilot's failure to maintain altitude/clearance from trees.Aug 24, 1999 · N98PK · Substantial damageNTSB FTW99LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7DC · Helena, ARThe student pilot's failure to maintain clearance from a tree. A factor associated with the accident was the pilot's low altitude.Aug 24, 1999 · N4526E · Substantial damageNTSB LAX99LA280Accident · No injuriesLimited investigationFinal reportPiper PA-18-18 · Eagleville, CAThe pilot's encounter with a thunderstorm induced downdraft, which resulted in a high rate of sink, at an altitude insufficient to provide for recovery prior to ground impact. The high density altitude was a factor in the accident.Aug 22, 1999 · N3356B · Substantial damageNTSB FTW99LA233Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Zachary, LAThe total loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel and his disorientation. Factors were the dusk light conditions and the lack of suitable terrain for the forced landing.Aug 22, 1999 · N6243R · Substantial damageNTSB FTW99LA229Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Houston, TXThe loss of engine power as a result of fuel starvation due to the pilot's improper fuel management.Aug 20, 1999 · N7277E · Substantial damageNTSB LAX99TA274Accident · No injuriesFinal reportAir Tractor AT-802A · Elko, NVThe pilot's failure to maintain an adequate terrain/obstacle clearance altitude margin while engaged in fire fighting operations.Aug 19, 1999 · N9190G · Substantial damageNTSB CHI99LA303Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Seward, NEthe pilot's failure to maintain clearance from the power line. A factor relating to this accident was the power line.Aug 19, 1999 · N136MC · DestroyedNTSB MIA99LA229Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Holly Bluff, MSThe pilot's failure to maintain visual separation between his airplane and a tree while maneuvering during aerial application and the subsequent collision with the tree and the terrain. A factor in the accident was the sunglare on the airplane's windscreen.Aug 18, 1999 · N1510Z · Substantial damageNTSB MIA99LA227Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Perry, SCan in-flight collision with the ground due to inadequate liftoff airspeed, and the pilot's improper use of flaps, which resulted in too low of an altitude to sustain flight.Aug 17, 1999 · N7529 · Substantial damageNTSB FTW99LA226Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Snyder, TXThe loss of engine power due to fuel starvation as result of a leak in the engine fuel control. A factor was the lack of suitable terrain for the forced landing.Aug 17, 1999 · N4523L · Substantial damageNTSB FTW99LA224Accident · No injuriesLimited investigationFinal reportBell 47G2 · Ardmore, OKThe pilot's failure to maintain rotor rpm which resulted in a hard landing. A factor was the high density altitude.Aug 17, 1999 · N1774 · Substantial damageNTSB DEN99FA148Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Newcastle, WYThe pilot's inadequate visual lookout and inadequate altitude/clearance from the transmission wires.Aug 17, 1999 · N1370R · DestroyedNTSB FTW99LA225Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Dermott, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 16, 1999 · N4896X · Substantial damageNTSB ATL99LA118Accident · No injuriesLimited investigationFinal reportBeech G35 · Columbus, MSThe loss of engine power for undetermined reasons and unsuitable terrain to make a forced landing.Aug 15, 1999 · N4473D · Substantial damageNTSB NYC99FA198Accident · 2 fatalField investigationFinal reportCessna 210 · Mount Pocono, PAThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain aircraft control. A related factor was the fog.Aug 13, 1999 · N4827C · DestroyedNTSB FTW99LA218Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Ferriday, LAThe pilot's failure to refuel the airplane which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Aug 12, 1999 · N8253K · Substantial damageNTSB LAX99LA267Accident · 1 fatalLimited investigationFinal reportCessna 152 · Agana, TaiwanThe loss or partial loss of engine power for undetermined reasons.Aug 11, 1999 · N64813 · DestroyedNTSB CHI99LA287Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Garden City, KSThe pilot's misjudging his pull-up maneuver resulting in contact with the wire. A contributing factor was the wire.Aug 11, 1999 · N4923X · Substantial damageNTSB LAX99FA266Accident · 1 fatalField investigationFinal reportCessna 177 · Boulder City, NVThe flight instructor's inadequate supervision of the flight and his failure to maintain an adequate airspeed and altitude margin while conducting low altitude maneuvers in an area of strong gusty winds and terrain-induced turbulence likely to contain wind…Aug 10, 1999 · N29437 · DestroyedNTSB CHI99FA285Accident · 2 fatalField investigationFinal reportBell 206B · Custer, SDThe pilot's failure to maintain adequate altitude/clearance from the trees. Contributing to the accident was the pilot's inadvertent settling with power.Aug 10, 1999 · N67JJ · DestroyedNTSB ANC99FA108Accident · 4 fatalField investigationFinal reportCessna A185F · Juneau, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were mountainous/hilly terrain, low ceilings, the pilot's improper in-flight decision making, and the pilot's impairment from over-the-counter…Aug 9, 1999 · N80229 · DestroyedNTSB SEA99FA168Accident · 1 fatalField investigationFinal reportSchweizer 269C · Westport, ORThe pilot's failure to maintain clearance from terrain. Factors include low clouds and visibility and near-night light conditions.Aug 8, 1999 · N383T · DestroyedNTSB FTW99FA212Accident · 1 fatalField investigationFinal reportStanton Pitts S-1S · Coushatta, LAThe pilot's poor in-flight decision to perform aerobatics at a low altitude and slow airspeed, resulting in the inadvertent stall/spin.Aug 8, 1999 · N90HS · Substantial damageNTSB CHI99LA297Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Oberlin, KSEngine failure due to an undertorqued carburetor fulcrum screw. Contributing factors were the muddy terrain and the low altitude of the aerial operation.Aug 8, 1999 · N197SK · Substantial damageNTSB CHI99FA284Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Titonka, IAThe low altitude maneuver attempted and altitude/clearance not being maintained by the pilot, which resulted in an impact with a pine tree. A factor to the accident was the pine tree.Aug 8, 1999 · N5033G · DestroyedNTSB ANC99FA110Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Anaktuvuk Pass, AKThe inadvertent stall/spin by the pilot. A factor was the box canyon into which he had flown.Aug 7, 1999 · N4996V · DestroyedNTSB IAD99GA056Accident · Minor injuriesFinal reportEurocopter AS-350 · Islip, NYThe pilot's loss of control during hydraulics-off hovering flight and the instructor's inadequate supervision of the maneuver. A factor was the tailwind.Aug 3, 1999 · N211PD · Substantial damageNTSB FTW99LA205Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Bryan, TXThe flight instructor's inadvertent stall while performing an evasive maneuver to avoid colliding with powerlines.Aug 2, 1999 · N444UF · Substantial damageNTSB SEA99LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Middleton, IDThe pilot's failure to maintain clearance from an object. Power lines were a factor.Jul 30, 1999 · N5510B · Substantial damageNTSB MIA99LA204Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Isola, MSFailure of the No. 4 cylinder due to a leaking intake valve resulting in loss of engine power and collision with a ditch while making a forced landing on unsuitable terrain. Contributing to the accident was improper maintenance adjustment of the engine valves…Jul 28, 1999 · N8482V · DestroyedNTSB DEN99LA130Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Centennial, WYThe pilot's failure to consult the airplane performance charts and allowing the airplane to exceed its climb performance. Factors were high density altitude conditions and a downdraft.Jul 27, 1999 · N5989L · Substantial damageNTSB FTW99LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Victoria, TXThe separation of the engine cowling due to a fractured support bracket, which resulted in the cowling striking and bending four engine push rods causing a loss of engine power. A factor was the lack of suitable terrain for the forced landing.Jul 26, 1999 · N4393S · Substantial damageNTSB CHI99LA273Accident · No injuriesLimited investigationFinal reportMooney M20B · Hayward, WIthe pilot's failure to maintain clearance with the surface of the lake. Factors associated with the accident were the low level flight, dusk light conditions, and the glassy water.Jul 26, 1999 · N74523 · Substantial damage