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 SEA03LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Zurich, MTThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.Jul 15, 2003 · N6792B · Substantial damageNTSB CHI03LA210Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Cleveland, MNThe pilot's inadequate visual lookout and low altitude flight when he failed to maintain altitude/clearance from the transmission wire. A factor contributing to the accident was the transmission wire.Jul 15, 2003 · N7925J · DestroyedNTSB DEN03LA128Accident · 1 fatalLimited investigationFinal reportGrob G103 Twin Astir · Morgan, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's inadequate in-flight planning/decision to fly low over a mountain ridge. Contributing factors included the wind shear, altitude/clearance, and the…Jul 14, 2003 · N27TA · DestroyedNTSB SEA03LA137Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-20 · Fish Haven, IDThe pilot's failure to maintain terrain clearance while maneuvering. Rising terrain, an inadvertent raising of the flaps for unknown reasons, and low altitude were factors.Jul 12, 2003 · N27SJ · Substantial damageNTSB LAX03FA232Accident · Serious injuriesField investigationFinal reportSikorsky S-58ET · Rancho P.Verdes, CAA total loss of antitorque control, due to the fatigue-induced failure of a gear within the drive shaft's intermediate gear box (IGB). Contributing factors were the pilot's improper on-ground decision to continue flight operations following discovery of…Jul 12, 2003 · N15AH · DestroyedNTSB CHI03LA204Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Ft. Yates, NDThe inadvertent settling with power and unsuccessful remedial action by the pilot. A factor to the accident was the potato crop.Jul 9, 2003 · N9080T · Substantial damageNTSB LAX03TA229Accident · No injuriesFinal reportSikorsky S-64E · Tucson, AZthe pilot's failure to maintain tail rotor clearance while hovering resulting in a tail rotor blade strike.Jul 8, 2003 · N6979R · Substantial damageNTSB FTW03LA186Accident · No injuriesLimited investigationFinal reportEurocopter EC120B · Ship Shoal 80The pilot's failure to maintain clearance with a parked/stationary aircraft.Jul 8, 2003 · N162TA · Substantial damageNTSB FTW03FA182Accident · 2 fatalField investigationFinal reportCessna 172S · McKinney, TXThe CFI's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during the forced landing. A contributing factor was the impact with a bird, which affected the performance of the airplane.Jul 8, 2003 · N166ME · DestroyedNTSB LAX03LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Phoenix, AZThe disengagement of the left control wheel from the control column, which was due to the attaching screw backing out of the nut plate. Also causal was the manufacturer's inadequate design of the installation and the improper length of the screw.Jul 7, 2003 · N288PA · Substantial damageNTSB LAX03LA226Accident · No injuriesLimited investigationFinal reportBell 47 G5 · Salinas, CAThe failure of a piston connecting rod during an aerial application, which resulted in a total loss of engine power and subsequent forced landing.Jul 6, 2003 · N7938J · Substantial damageNTSB DEN03LA121Accident · Serious injuriesLimited investigationFinal reportPringle Rans S-7 Courer · Manti, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Low altitude flight and high density altitude are contributing factors.Jul 5, 2003 · N6687 · DestroyedNTSB SEA03LA125Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · La Grande, ORThe cross threading and separation of the clutch assembly while maneuvering which resulted in a loss of engine power followed by a hard landing. An inadequate maintenance overhaul was a factor.Jul 4, 2003 · N37799 · DestroyedNTSB SEA03FA123Accident · 3 fatalField investigationFinal reportBeech A24-R · Yellow Pine, IDThe pilot's failure to maintain clearance. Factors include trees and mountainous terrain.Jul 4, 2003 · N254M · DestroyedNTSB LAX03FA224Accident · 1 fatalField investigationFinal reportCessna 182Q · Saugus, CAin-flight collision with terrain for undetermined reasons.Jul 4, 2003 · N129JB · DestroyedNTSB ATL03LA116Accident · 1 fatalLimited investigationFinal reportButler Bowers Fly Baby 1A · Lincoln, ALThe pilot's failure to maintain airspeed while maneuvering resulting in a stall.Jul 3, 2003 · N197DE · DestroyedNTSB NYC03LA147Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · West Liberty, OHThe student pilots failure to maintain directional control while hovering, and the CFI's delayed remedial action.Jul 2, 2003 · N7001Z · Substantial damageNTSB FTW03LA200Accident · Serious injuriesLimited investigationFinal reportChampion 7AC · San Antonio, TXThe pilot's failure to maintain minimum required airspeed while maneuvering, resulting in an inadvertent stall of the airplane.Jul 1, 2003 · N84426 · Substantial damageNTSB ANC03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Ketchikan, AKThe pilot's abrupt, excessive pull-up during an intentional low level maneuver, and his failure to maintain adequate airspeed which resulted in an inadvertent stall and subsequent collision with the water.Jun 29, 2003 · N48061 · Substantial damageNTSB LAX03LA214Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mt. Charleston, NVthe pilot's inadequate in-flight planning and selection of the wrong route of flight, which led the airplane toward rising terrain in excess of the performance capability of the airplane. Also causal was the pilot's delayed decision to divert her route of…Jun 28, 2003 · N6182U · Substantial damageNTSB DEN03FA113Accident · 1 fatalField investigationFinal reportMattison Starduster Too · Ellicott, COthe pilot's improper in-flight planning/decision to perform aerobatics at low altitude and the failed welds at the elevator horn and torque tube. Factors contributing to the accident were the pilot performing aerobatics at low altitude, his inability to…Jun 28, 2003 · N80T · DestroyedNTSB DEN03LA112Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Glendo, WYthe pilot's failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the high density altitude, and the trees.Jun 27, 2003 · N4406S · Substantial damageNTSB CHI03LA185Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Elk Mound, WIThe pilot's failure to maintain clearance from the terrain. Factors contributing to the accident were the whirlwind, the turbulence, and the helicopter's low altitude.Jun 27, 2003 · N62417 · DestroyedNTSB NYC03TA138Accident · No injuriesFinal reportAir Tractor 402A · Pearisburg, VAA compressor turbine blade fracture which resulted in a power loss, and forced landing. Factor were the rocks in the landing area, and the operator's decision to operate the engine beyond the engine manufacturer's recommendations for overhaul.Jun 26, 2003 · N4506L · Substantial damageNTSB LAX03LA212Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kualapuu, HIthe total loss of engine power resulting from a fatigue failure of the 3rd stage turbine wheel airfoils. The reason for the airfoil's fatigue failure could not be determined.Jun 26, 2003 · N633WA · Substantial damageNTSB CHI03LA182Accident · 1 fatalLimited investigationFinal reportRobinson R-22 Beta · Dexter, MOThe pilot's inadequate visual lookout and failure to maintain clearance from the wires during the aerial application flight. Factors contributing to the accident were the helicopter's low altitude and the transmission wires.Jun 25, 2003 · N933CB · DestroyedNTSB DEN03LA109Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Las Vegas, NMthe pilot's failure to maintain obstacle clearance and visual lookout. Contributing factors were his attention being diverted and the trees.Jun 22, 2003 · N8505E · Substantial damageNTSB SEA03LA111Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Alzada, MTThe student pilot's failure to maintain adequate flying airspeed in a turn while maneuvering close to the ground resulting in a stall condition. A contributing factor was the turbulent wind conditions.Jun 21, 2003 · N4565M · DestroyedNTSB FTW03FA174Accident · 1 fatalField investigationFinal reportCessna 182H · Cushing, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.Jun 21, 2003 · N8548S · DestroyedNTSB CHI03LA172Accident · Minor injuriesLimited investigationFinal reportBell 206B · Baxter, MNThe pilot's failure to maintain control of the helicopter due to a loss of tail rotor effectiveness. Factors contributing to this accident were the helicopter's low airspeed, low altitude, the crosswind, and the trees.Jun 20, 2003 · N79BH · Substantial damageNTSB LAX03LA210Accident · No injuriesLimited investigationFinal reportBeech S35 · Weed, CAthe pilot's failure to maintain an adequate terrain/object clearance altitude.Jun 19, 2003 · N5828S · Substantial damageNTSB LAX03FA206Accident · 1 fatalField investigationFinal reportSchleicher ASW-27B · Valyermo, CAThe pilot's failure to maintain adequate terrain clearance altitude and his delayed remedial action by not turning away from the ridge when a lack of lift became apparent..Jun 19, 2003 · N271EC · DestroyedNTSB CHI03LA176Accident · No injuriesLimited investigationFinal reportAllied Ag Cat Productions G-164B · Dyess, ARThe loose fittings on the bleed air system which resulted in a loss of engine power, and the unsuitable terrain encountered during the forced landing. Factors to the accident were the watery and the muddy conditions and the inadequate fastening of the bleed…Jun 19, 2003 · N8375K · Substantial damageNTSB CHI03LA171Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Marked Tree, ARThe pilot's failure to maintain clearance with the wire. Contributing factors were the low altitude flight/maneuver and the static wire.Jun 19, 2003 · N4004U · Substantial damageNTSB IAD03FA058Accident · 2 fatalField investigationFinal reportPiper PA-30 · NewPhiladelphia, OHThe pilot's mismanagement of the fuel, and his failure to maintain minimum controllable airspeed with one engine inoperative.Jun 16, 2003 · N8162Y · DestroyedNTSB LAX03LA198Accident · No injuriesLimited investigationFinal reportKowtun Mini 500 · Phoenix, AZThe pilot's failure to maintain directional control of the helicopter.Jun 14, 2003 · N919WK · DestroyedNTSB FTW03LA173Accident · 1 fatalLimited investigationFinal reportApex CAP 10B · Gladewater, TXThe failure of the left wing, which resulted from progressive compressive fractures in the upper wooden spar cap. Contributing the accident was the difficulty in performing adequate inspections of the spar caps in an attempt to detect the compressive…Jun 14, 2003 · N80DD · DestroyedNTSB LAX03LA197Accident · 1 fatalLimited investigationFinal reportBell 47-G4 · Porterville, CAloss of control for undetermined reasons.Jun 13, 2003 · N9017N · DestroyedNTSB DEN03LA104Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Eureka, UTthe pilot's improper in-flight planning and failure to maintain aircraft control. Contributing factors include high density altitude, hilly terrain, low airspeed and the subsequent inadvertent stall/mush.Jun 13, 2003 · N630DA · DestroyedNTSB SEA03LA101Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Royal City, WAThe pilot's failure to maintain clearance from a 20 foot high post while applying chemicals to an agricultural field, which resulted in impact damage to the right main landing gear, and ultimately to a collapse of the subject gear during the subsequent…Jun 12, 2003 · N8468V · Substantial damageNTSB LAX03LA189Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta II · Phoenix, AZThe instructor's inadequate supervision and his failure to maintain aircraft control. The wind gusts were a factor.Jun 9, 2003 · N727DD · Substantial damageNTSB LAX03LA188Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Maricopa, AZThe pilot's failure to maintain clearance/altitude from terrain during an aerial application, which resulted in an in-flight collision with terrain. A factor associated with the accident is the pilot's diverted attention while resetting a circuit breaker.Jun 9, 2003 · N6117X · Substantial damageNTSB SEA03FA096Accident · 1 fatalField investigationFinal reportAviat A-1A · Sandpoint, IDThe pilot's failure to maintain adequate airspeed during a low pass maneuver which resulted in a stall. A related factor was the trees.Jun 8, 2003 · N141F · Substantial damageNTSB FTW03LA168Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Encinal, TXThe pilot's failure to maintain clearance from a tree. A contributing factor was the pilot's diverted attention.Jun 8, 2003 · N854WT · Substantial damageNTSB FTW03LA167Accident · No injuriesLimited investigationFinal reportManweiler Acro Sport II · Bartlesville, OKThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion. A related factor was the lack of suitable terrain.Jun 7, 2003 · N94SM · Substantial damageNTSB DEN03LA098Accident · Minor injuriesLimited investigationFinal reportHelio H800 · Cody, WYthe pilot's improper preflight planning and his failure to maintain aircraft control when returning to the airport. Factors contributing to the accident were the oil leak, the attempted precautionary landing, and the downdraft.Jun 7, 2003 · N4035K · Substantial damageNTSB SEA03LA095Accident · 1 fatalLimited investigationFinal reportRans S-14 · Pasco, WAThe pilot's failure to maintain aircraft control while maneuvering. A physical impairment due to alcohol was a factor.Jun 6, 2003 · None · Substantial damageNTSB NYC03LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Londonderry, VTThe pilots inadvertent flight into instrument meteorological conditions and his failure to maintain a safe altitude above the rising terrain. Factors related to the accident were the low ceilings and rising terrain.Jun 5, 2003 · N704TG · Substantial damageNTSB IAD03FA056Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Montpelier, VAThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude.Jun 3, 2003 · N23428 · Substantial damageNTSB LAX03LA177Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe pilot's failure to maintain an adequate visual lookout.Jun 1, 2003 · N991RW · Substantial damage