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 CHI91DCD01Accident · 1 fatalFinal reportHeal SONERAI-I · Davenport, IAFailure of the wing spar straps, as the aircraft was being maneuvered around a pylon in an air race.Jun 23, 1991 · N4227N · DestroyedNTSB LAX91FA270Accident · 1 fatalField investigationFinal reportBeech T-34A · Redding, CAThe pilot's failure to attain an altitude to permit the aircraft to complete the aerobatic maneuver.Jun 22, 1991 · N45GD · DestroyedNTSB FTW91DPG13Accident · Serious injuriesFinal reportGrumman G-164B · Mc Crory, ARLoss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Jun 22, 1991 · N8089K · DestroyedNTSB FTW91LA103Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Brighton, AR(1) The pilot's failure to maintain adequate clearance from the wires and (2) the wire's subsequent interference with the flight controls.Jun 19, 1991 · N48370 · DestroyedNTSB FTW91FA104Accident · 1 fatalField investigationFinal reportCessna C182R · Big Spring, TXThe pilot's failure to recover from an aerobatic maneuver due to insufficient altitude.Jun 19, 1991 · N5459E · Substantial damageNTSB ANC91LA077Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Woods River, AKFailure of the pilot to maintain adequate airspeed, while turning after a low pass, which resulted in an inadvertent stall. The wind gusts and turbulence were related factors.Jun 19, 1991 · N10PC · Substantial damageNTSB NYC91FA154Accident · 2 fatalField investigationFinal reportAeronca 7BCM · Millinocket, MEFailure of the pilot to maintain adequate airspeed, while maneuvering for a precautionary landing on a road, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's improper replacement of an oil temperature gage, and a…Jun 18, 1991 · N2155E · DestroyedNTSB CHI91DTG02Accident · No injuriesFinal reportSikorsky H-19-UH19D · Mcclusky, NDFailure of the engine blower/supercharger assembly. A factor related to the accident was: no suitable terrain in which to make an immediate emergency landing.Jun 18, 1991 · N6735 · Substantial damageNTSB CHI91DER06Accident · No injuriesFinal reportPiper PA-36-285 · Fergus Falls, MNThe pilot's failure to maintain adequate clearance from obstacles during aerial apllication operations.Jun 17, 1991 · N57824 · Substantial damageNTSB CHI91DEP09Accident · 1 fatalFinal reportBowers Flybaby 1A · Stoughton, WIThe inadequate design by the manufacturer to provide for adequate protection from moisture accumulation in the form of drain holes. Contributing factors were the deterioration (wood rot) of the wing spar attach and the lack of inspection access.Jun 17, 1991 · N8084D · DestroyedNTSB CHI91LA192Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Marquette, MIThe pilot-in-command's failure to maintain proper altitude.Jun 16, 1991 · N5055F · Substantial damageNTSB CHI91DEP08Accident · 1 fatalFinal reportJack Thomas Pitts S-IT · Kenosha, WIImproper maintenance, by person or persons unknown, to the elevator control system which allowed a bolt attaching the elevator control rod to the pitch bellcrank to become disconnected during flight.Jun 16, 1991 · N83AM · DestroyedNTSB SEA91FA131Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nephi, UTPoor inflight planning and decisions. Factors to the accident were: an uncontrolled stall/spin, and inadequate airspeed.Jun 15, 1991 · N4090Z · DestroyedNTSB MIA91LA163Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Greenville, MSLoss of engine power due to a cracked cylinder and the pilot's inadvertent stall.Jun 14, 1991 · N2361C · Substantial damageNTSB SEA91LA130Accident · Minor injuriesLimited investigationFinal reportHughes 269A-1 · Canby, ORA hard landing after an undetermined loss of power. Factors include an excessive emergency descent rate.Jun 13, 1991 · N8944F · Substantial damageNTSB CHI91DER05Accident · No injuriesFinal reportBell 47G3B1 · Lasalle, MNThe pilot's failure to maintain adequate clearance from the terrain. A related factor is the pilot's misjudged altitude above the crop.Jun 11, 1991 · N73284 · Substantial damageNTSB SEA91LA145Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Corvallis, ORThe pilot displayed poor in-flight planning. A factor to the accident was: the pilot did not maintain a proper altitude over mountainous terrain.Jun 10, 1991 · N3474Z · DestroyedNTSB FTW91LA094Accident · No injuriesLimited investigationFinal reportPitts S1C · Houston, TXThe failure of the propeller due to improper installation.Jun 9, 1991 · N48JP · Substantial damageNTSB LAX91LA254Accident · Serious injuriesLimited investigationFinal reportCullen/Roth Falcon XP · Sebastopal, CAThe structural failure of the airplane's canard wing. Contributing factors which related to the accident were the pilot's performance of an adjustment to the rigging of his airplane which deteriorated its flight characteristics.Jun 8, 1991 · N9939M · DestroyedNTSB FTW91LA095Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Newport, ARThe pilot's improper planning which resulted in his flying into his own chemicals.Jun 8, 1991 · N36335 · Substantial damageNTSB FTW91DRG03Accident · Serious injuriesFinal reportGrumman G-164A · Weslaco, TXFailure of the pilot to maintain clearance.Jun 8, 1991 · N7445 · DestroyedNTSB FTW91DRA03Accident · No injuriesFinal reportBronner Skybolt · Alvin, TXThe pilot's failure to maintain terrain clearance. A factor was the pilot's decision to perform a low pass.Jun 8, 1991 · N773HD · Substantial damageNTSB BFO91DIA01Accident · Serious injuriesFinal reportHagaman Pitts Pitts S · Warrenton, VAThe pilot misjuded altitude and clearance above the terrain. Contributing to the accident was aerobatic maneuver performed at low altitude.Jun 8, 1991 · N711B · DestroyedNTSB SEA91LA128Accident · No injuriesLimited investigationFinal reportEnstrom F280C · Baggs, WYExhaust valve failure, resulting in a partial power loss. Contributing factors were low altitude and rough/uneven terrain.Jun 7, 1991 · N5695Y · Substantial damageNTSB LAX91FA251Accident · 1 fatalField investigationFinal reportVarga 2150A · Livermore, CAAn inflight collision with terrain for undetermined reasons.Jun 7, 1991 · N8272J · DestroyedNTSB ATL91FA108Accident · 2 fatalField investigationFinal reportCessna T37B · Chickamauga, GAThe T-37 pilot misjudged the clearance between his aircraft and the A-26.Jun 7, 1991 · N120DB · 2 aircraft · DestroyedNTSB LAX91LA250Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Stockton, CAFailure of the pilot to maintain an adequate visual outlook to detect power transmission wires in his flight path resulting in an abrupt maneuver and subsequent inadvertent stall.Jun 6, 1991 · N8806Y · DestroyedNTSB LAX91FA247Accident · 1 fatalField investigationFinal reportCessna C-172 · Lakeside, CAThe failure of the pilot to request radar assistance to avoid low ceilings in high terrain and the pilot's inadequate visual outlook which ultimately resulted in an inflight collision with high terrain. Contributing to the accident were the weather conditions…Jun 6, 1991 · N5814A · DestroyedNTSB CHI91DER04Accident · No injuriesFinal reportBellanca Eagle DW-1 · Hector, MNThe loss of engine power due to the total failure of a connecting rod. Related factors are the low maneuvering altitude and the unsuitable (muddy) terrain encountered during the forced landing.Jun 6, 1991 · N8800W · Substantial damageNTSB FTW91LA091Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Peach Orchard, ARThe pilot's failure to maintain adequate main rotor RPM resulting in deteriorated helicopter performance. A factor was the tailwind condition.Jun 5, 1991 · N8117 · Substantial damageNTSB CHI91DEE06Accident · No injuriesFinal reportRobinson R22B · Mineral, ILFailure of the pilot to maintain clearance from the power line.Jun 5, 1991 · N91MG · Substantial damageNTSB LAX91FA242Accident · 1 fatalField investigationFinal reportCessna C-A150L · Cottonwood, CAThe pilot's intentional low pass during which he performed an aerobatic maneuver with inadequate airspeed. Contributing factors were the pilot's low altitude and the tailwind condition which created the visual perception to the pilot of having an airspeed…Jun 4, 1991 · N6019J · DestroyedNTSB FTW91LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lawtell, LAThe pilot's exceeding the performance capability of the airplane. A factor was turbulence.Jun 4, 1991 · N67210 · DestroyedNTSB SEA91LA125Accident · No injuriesLimited investigationFinal reportCessna C-182A · Buhl, IDThe intentional high speed buzzing by the pilot, and his failure to maintain clearance from obstacles on the ground.Jun 2, 1991 · N3767D · Substantial damageNTSB SEA91LA123Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · St. Xavier, MTThe pilot's improper use of the fuel system, and the overfilling of the fuel tank. Contributing to the accident was: aerobatics performed, the pilot's inattention and the design of the fuel system.Jun 2, 1991 · N10527 · DestroyedNTSB MIA91LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · High Springs, FLLoss of engine power due to disintegration of the impeller caused by a worn impeller bearing.Jun 2, 1991 · N8841S · Substantial damageNTSB FTW91DPG12Accident · Minor injuriesFinal reportBell 47-G3B1 · Colt, ARLoss of engine power for an undetermined reason. A factor was the unsuitable terrain.Jun 1, 1991 · N31052 · DestroyedNTSB ATL91LA104Accident · Serious injuriesLimited investigationFinal reportPeecher EAA Biplane P-2 · Dalton, GAThe pilot's failure to maintain airspeed when he diverted his attention outside the airplane which resulted in an inadvertent stall and subsequent collision with trees.Jun 1, 1991 · N202P · DestroyedNTSB NYC91FA145Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Wallingford, CTThe pilot attempting a VFR flight in adverse weather conditions, at an altitude that was insufficient to clear trees along his route of flight. Factors related to the accident were the pilot's lack of instrument rating, and his overconfidence to fly in…May 31, 1991 · N36069 · DestroyedNTSB ATL91LA105Accident · No injuriesLimited investigationFinal reportCessna 188 · Sycamore, SCThe pilot's failure to secure the gust lock during prelflight; the string jammed the flight controls and created an uncontrollable condition.May 31, 1991 · N731EP · Substantial damageNTSB ATL91LA102Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Lake Seminole, GAThe failure of the pilot to maintain clearance from the surface.May 29, 1991 · N9650N · DestroyedNTSB SEA91LA136Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wilson Creek, WAThe loss of engine power in flight due to improper overhaul of the carburetor float assembly fulcrum screw, shutting off fuel flow to the engine.May 27, 1991 · N8407K · Substantial damageNTSB SEA91LA127Accident · Serious injuriesLimited investigationFinal reportMaxair Ultralight · Toledo, WAThe pilot's inattentiveness. Factors were his performance of a low pass, and a transmission wire in his flight path.May 27, 1991 · UNREG · Substantial damageNTSB SEA91LA116Accident · Serious injuriesLimited investigationFinal reportGreg Smith KR-2 · Twisp, WAThe loss of engine power in flight due to shorted magneto wires, resulting from inadequate maintenance inspection by the pilot.May 27, 1991 · N47KR · Substantial damageNTSB DEN91LA077Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAPremature pull up from an aerial application swath run resulting in a collision with an electrical transmission line.May 27, 1991 · N48383 · Substantial damageNTSB SEA91LA115Accident · Serious injuriesLimited investigationFinal reportDave Ronneberg LONG-EZE · Kanab, UTLoss of aircraft control in flight which resulted from the pilot's diverted attention and his failure to maintain proper airspeed.May 26, 1991 · N515DR · Substantial damageNTSB LAX91LA224Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Palm Springs, CALack of total experience by the unqualified person at the controls; improper use of rotorcraft flight controls by an unqualified person. A factor in the accident was the fence.May 26, 1991 · N7033H · DestroyedNTSB FTW91FA084Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Folsom, LAThe inadvertent stall. Factors were the pilot's poor judgement in performing the buzzing maneuver and his lack of experience.May 26, 1991 · N6181W · DestroyedNTSB CHI91DTK01Accident · 2 fatalFinal reportPiper PA-18-125 · Newell, SDAn inadvertent stall/spin during maneuvering flight and inadequate remedial action by the pilot. Factors associated with the accident are the pilot's disregard for procedures and directives and inadequate initial training.May 26, 1991 · N1799A · DestroyedNTSB NYC91LA141Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Ossipee, NHAn inadequate annual inspection by the mechanic which resulted in the inflight failure of the elevator control cable.May 25, 1991 · N6342N · Substantial damage