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 MIA00LA227Accident · Minor injuriesLimited investigationFinal reportBell 206A-1 · Bennettsville, SCThe pilot's failure to use proper remedial action to counteract a loss of tail rotor effectiveness resulting in collision with terrain during the subsequent uncontrolled descent.Jul 22, 2000 · N136C · Substantial damageNTSB SEA00LA140Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Lone Pine, ORThe complete loss of engine power for undetermined reasons. Factors include an irrigation system in the field where the forced landing took place, and the pilot's intentional initiation of a ground loop in order to miss the pipes of the irrigation system.Jul 21, 2000 · N731GR · Substantial damageNTSB ANC00LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Anchorage, AKThe failure of the pilot-in-command (CFI) to adequately supervise the instructional flight. Factors in the accident were an inadvertent spin entry by the student, and the pilot-in-command's failure to utilize adequate altitude for a stall demonstration.Jul 20, 2000 · N6296R · Substantial damageNTSB LAX00LA276Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Cave Creek, AZThe pilot's inadequate in-flight planning/decision to attempt a hover in atmospheric conditions and over terrain that would require maximum helicopter performance, and which would leave no viable alternate actions in the event of difficulties.Jul 19, 2000 · N577TA · Substantial damageNTSB FTW00LA214Accident · 1 fatalLimited investigationFinal reportBurton/Boyton Celerity · Horseshoe Bend, ARThe loss of control while maneuvering for an undetermined reason.Jul 19, 2000 · N5104X · DestroyedNTSB FTW00LA212Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401 · Panhandle, TXThe pilot's failure to maintain airspeed, which resulted in a stall.Jul 18, 2000 · N6055W · DestroyedNTSB DEN00FA136Accident · 2 fatalField investigationFinal reportGrumman American AA-5 · Moab, UTThe pilot in command exercising poor judgment and exceeding the aircraft's turning capability. Contributing factors were the pilots' attention being diverted, flying into a known blind canyon, high temperature, and high density altitude.Jul 18, 2000 · N7161L · DestroyedNTSB CHI00LA212Accident · 1 fatalLimited investigationFinal reportHess RH-1 Falcon · New Castle, INaircraft control not attained by the pilot.Jul 18, 2000 · N7242H · DestroyedNTSB MIA00LA222Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Covington, TNthe pilot allowed the helicopter to get too low while hovering, which resulted in the tail rotor striking the ground, the separation of the blade, and subsequent force landing.Jul 17, 2000 · N818HJ · Substantial damageNTSB FTW00LA206Accident · No injuriesLimited investigationFinal reportMbb BK-117-A3 · Allen, TXthe pilot's failure to maintain obstacle clearance while hovering the helicopter. A contributing factor was the dark night light conditions.Jul 16, 2000 · N312LS · Substantial damageNTSB CHI00LA204Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Holstein, NEthe settling with power encountered by the pilot. A factor was the sudden windshift.Jul 16, 2000 · N83701 · Substantial damageNTSB CHI00FA200Accident · 1 fatalField investigationFinal reportBeech 35 · Columbus, NEthe failure of the pilot to maintain clearance from the power line. Factors were the sunglare and the wire.Jul 15, 2000 · N947V · DestroyedNTSB MIA00FA217Accident · 2 fatalField investigationFinal reportCessna 150M · Holly Springs, MSThe failure of the pilot to maintain control while maneuvering the aircraft due to impairment as a result of use of illegal drugs, and the subsequent collision with the terrain during an uncontrolled descent.Jul 14, 2000 · N9249U · DestroyedNTSB FTW00FA208Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Houston, TXthe loss of engine power for an undetermined reason during maneuvering. Contributing factors were the dark night light conditions and the lack of suitable terrain for the forced landing.Jul 14, 2000 · N8263R · DestroyedNTSB SEA00FA133Accident · 3 fatalField investigationFinal reportCessna 150E · Ashton, IDThe pilot's failure to maintain clearance from a tree while making a low pass over an outdoor gathering of individuals. Factors include the intentional low pass, a tree located in a shadow generated by the sun's low position at dusk, hilly terrain, and the…Jul 13, 2000 · N6196T · DestroyedNTSB LAX00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ripley, CAA loss of engine power due to the separation of a connecting rod from the crankshaft.Jul 13, 2000 · N4508Y · Substantial damageNTSB SEA00LA129Accident · Serious injuriesLimited investigationFinal reportKaman K-1200 · Cusick, WAThe termination of power to the main rotor system as a result of the malfunction of the free-wheeling sprag clutch assembly, followed by the torsional overload separation of the engine adapter shaft. Factors include trees in the area where the emergency…Jul 11, 2000 · N311KA · Substantial damageNTSB NYC00LA191Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Harpswell, METhe pilot-in-command's improper in-flight decision to maneuver at a low airspeed with a left-quartering tailwind which resulted in a loss of tailrotor effectiveness.Jul 11, 2000 · N2365S · Substantial damageNTSB LAX00LA261Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gridley, CAA partial loss of engine power due to the failure of an exhaust valve during an aerial application flight.Jul 11, 2000 · N897X · Substantial damageNTSB CHI00LA210Accident · No injuriesLimited investigationFinal reportGrumman G164 · Mcville, NDthe pilot's failure to maintain clearance with the power lines. A factor associated with the accident was the power line.Jul 10, 2000 · N10244 · Substantial damageNTSB CHI00LA191Accident · No injuriesLimited investigationFinal reportCessna A188B · Washington, KSthe failure of the number-two connecting rod bearing and the unsuitable terrain for landing encountered by the pilot during the forced landing. A factor to the accident was the rough/uneven field.Jul 10, 2000 · N9557G · Substantial damageNTSB LAX00LA257Accident · Minor injuriesLimited investigationFinal reportInteravia E-3 · Watsonville, CAthe total loss of engine power due to the pilot's inaccurate fuel consumption calculations, which resulted in fuel exhaustion.Jul 9, 2000 · N4426X · Substantial damageNTSB FTW00LA199Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Chase, LAThe failure of the pilot to maintain clearance with the deer stand. Factors were the chemical covering the windshield and the glare from the setting sun.Jul 9, 2000 · N731DW · Substantial damageNTSB FTW00LA200Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Moscow, TXthe failure of the power output reduction gear to the propeller. A contributing factor was the lack of suitable terrain for the forced landing.Jul 8, 2000 · N3629T · Substantial damageNTSB DEN00FA127Accident · 4 fatalField investigationFinal reportCessna 195 · Aspen, COthe pilot's poor in-flight decision to fly up a valley with rapidly rising terrain, which resulted in the airplane colliding with the terrain due to its climb performance being exceeded. A contributing factors was the high, rapidly rising, mountainous terrain.Jul 8, 2000 · N4377V · DestroyedNTSB CHI00FA186Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Capron, ILThe pilot attempting an aerobatic maneuver at a low altitude and the pilot not maintaining clearance from the terrain. A factor to the accident was the pilot disregarding the federal aviation regulations concerning the minimum altitudes required for aerobatic…Jul 8, 2000 · N8739V · Substantial damageNTSB CHI00LA189Accident · No injuriesLimited investigationFinal reportStaudacher S-300D2 · Kenosha, WIThe fatigue failure of the rod end bearing and the separation of the aileron. A factor was the inadequate design change by the aircraft designer.Jul 7, 2000 · N112KG · Substantial damageNTSB CHI00LA181Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Champion, NEthe undetermined uncontrolled descent.Jul 7, 2000 · N7015K · Substantial damageNTSB FTW00LA195Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Anahuac, TXThe pilot's failure to maintain clearance with the power line. A factor was the lack of suitable terrain for the forced landing.Jul 5, 2000 · N2252N · DestroyedNTSB SEA00LA124Accident · Minor injuriesLimited investigationFinal reportBell 47G · Haines, ORThe pilot's failure to correctly judge his rate of descent and his failure to initiate his level off soon enough to keep the helicopter from impacting the terrain. Factors include hilly terrain near the edge of the field he was spraying.Jul 4, 2000 · N30DP · Substantial damageNTSB MIA00LA202Accident · 1 fatalLimited investigationFinal reportCessna A188B · Inverness, MSThe failure of the pilot to maintain airspeed while reversing course during an aerial application flight resulting in the aircraft stalling, descending, impacting a tree, and crashing to the ground.Jul 4, 2000 · N731SP · DestroyedNTSB MIA00FA201Accident · 1 fatalField investigationFinal reportCessna 152 · Murfreesboro, TNthe flight instructor's failure to maintain an airspeed above the aircraft's stall speed, which resulted in a stall/mush, and an inflight loss of control while maneuvering to return to a landing area during an emergency, resulting in an uncontrolled descent…Jul 4, 2000 · N89043 · DestroyedNTSB NYC00FA183Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Lakewood, NJThe pilot's failure to maintain airspeed, resulting in an inadvertent stall. Factors were the entanglement of the tow rope with the rudder horn, restricted rudder movement, the pilot's lack of total experience in the type of operation, and no stall warning…Jul 3, 2000 · N8384V · Substantial damageNTSB LAX00LA246Accident · No injuriesLimited investigationFinal reportGrumman G-164B · King City, CAThe loss of engine power for undetermined reasons.Jul 3, 2000 · N48456 · DestroyedNTSB FTW00LA192Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Brownfield, TXThe loss of engine power due to the blocked engine intake, which resulted from ingesting birds. Factors were the lack of suitable terrain for the forced landing and the pilot's intentional ground loop in an attempt to avoid a ditch.Jul 3, 2000 · N4061H · Substantial damageNTSB DEN00LA122Accident · 1 fatalLimited investigationFinal reportRowley P-40F · Peyton, COthe pilot's inadequate decision to turn back (low altitude) towards the runway for a forced landing. A contributing factor was the total loss of engine power due to a reduction gear failure.Jul 3, 2000 · N42915 · DestroyedNTSB NYC00LA179Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Woodbine, NJThe pilot-in-command's failure to initiate a timely go-around.Jul 1, 2000 · N5661P · Substantial damageNTSB MIA00LA197Accident · No injuriesLimited investigationFinal reportCessna A188B · Belzoni, MSThe pilot's failure to refuel prior to departure resulting in loss of engine power due to fuel exhaustion.Jul 1, 2000 · N53208 · Substantial damageNTSB IAD00LA054Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · East North Port, NYThe pilot's failure to maintain adequate rotor RPM and failure to follow published recovery procedures after the low rotor RPM warning horn and caution light activated.Jul 1, 2000 · N94RP · Substantial damageNTSB FTW00LA197Accident · No injuriesLimited investigationFinal reportBushby Midget Mustang · Tulsa, OKThe in-flight separation of the propeller spinner. A factor was the lack of suitable terrain for the precautionary landing.Jul 1, 2000 · N6402G · Substantial damageNTSB CHI00LA178Accident · 1 fatalLimited investigationFinal reportWeatherly 201C · Tolna, NDthe wing spar fatigue and wing separation while maneuvering. A factor was that the fatigue was not detected by the mechanic during the last annual inspection.Jun 30, 2000 · N9228W · DestroyedNTSB FTW00LA188Accident · No injuriesLimited investigationFinal reportCessna 172N · San Antonio, TXThe flight instructor's failure to refuel the airplane, which resulted in fuel exhaustion. Contributing factors were the flight instructor's fatigued condition and diverted attention.Jun 29, 2000 · N4918G · Substantial damageNTSB SEA00LA117Accident · No injuriesLimited investigationFinal reportHughes 369D · Heyburn, IDFuel exhaustion and inaccurate fuel management. A false indication on the fuel quantity gage, and an erratic low level fuel warning system were factors.Jun 28, 2000 · N8653F · Substantial damageNTSB FTW00LA186Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hondo, TXThe fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.Jun 27, 2000 · N4917X · Substantial damageNTSB DEN00FA118Accident · 1 fatalField investigationFinal reportCessna 152 · Karval, COthe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's inadvertent flight into the clouds, and his becoming spatially disorientated.Jun 27, 2000 · N46935 · DestroyedNTSB LAX00LA239Accident · 1 fatalLimited investigationFinal reportBell UH-1B · Arbuckle, CAthe partial failure of the tail rotor pitch change control rod that resulted in an attempted run-on landing in dark night conditions.Jun 23, 2000 · N807SB · DestroyedNTSB SEA00LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Wallace, IDThe pilot's failure to maintain airspeed and his failure to maintain clearance from the trees. Related factors were trees and mountainous terrain.Jun 22, 2000 · N9895V · Substantial damageNTSB SEA00LA110Accident · 2 fatalLimited investigationFinal reportHoye Kolb Twinstar MK III · Bigfork, MTThe pilot's failure to maintain aircraft control. Inadequate altitude for recovery was a factor.Jun 21, 2000 · N618HP · Substantial damageNTSB NYC00LA171Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CM · Warren, VTThe pilot's inadequate compensation for crosswind conditions. A factor in the accident was the cross wind.Jun 19, 2000 · N800PF · Substantial damageNTSB LAX00LA234Accident · 1 fatalLimited investigationFinal reportBeech G35 · Byron, CAin-flight loss of control and inadvertent stall.Jun 19, 2000 · N5801 · Destroyed