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 ANC91FA050Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Tatitlek, AKFailure of both pilots to see-and-avoid each other (inadequate visual lookout). A factor related to the accident was: inadequate communication among all participating aircrews.Apr 9, 1991 · N6966D · 2 aircraft · Substantial damageNTSB LAX91LA163Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Lake Cobb, CAThat the pilot's visual lookout was improper. Contributing to this accident was the unmarked transmission wire.Apr 7, 1991 · N81PT · Substantial damageNTSB NYC91LA107Accident · Serious injuriesLimited investigationFinal reportEnstrom F28A · Leetonia, OHThe helicopter hover performance was exceeded by the pilot and his failure to perform a normal approach to a landing. Factors were the high winds and the tailwind condition.Apr 6, 1991 · N58KC · Substantial damageNTSB LAX91LA160Accident · No injuriesLimited investigationFinal reportBurnett, Jerry D. Challenger II · Bullhead City, AZThe disintegration of the propeller. Contributing to this accident was the deterioration of aircraft control and the nonavilability of suitable landing terrain.Apr 6, 1991 · N4555J · Substantial damageNTSB FTW91LA062Accident · No injuriesLimited investigationFinal reportCessna A188B · Tipton, OKFailure of the pilot to maintain poroper clearance above obstacles. A factor was the sun glare.Apr 6, 1991 · N4165J · Substantial damageNTSB FTW91LA061Accident · Serious injuriesLimited investigationFinal reportCessna 150D · San Ygnacio, TXPower loss due to carburetor ice and a malfunctioning carburetor heat control and the pilot's loss of control of the airplane.Apr 6, 1991 · N4437U · DestroyedNTSB LAX91LA170Accident · Serious injuriesLimited investigationFinal reportSunrise Ultralight Spitfire II · Elk Grove, CAThe failure of the operator to maintain adequate airspeed.Apr 5, 1991 · UNREG · DestroyedNTSB CHI91LA124Accident · Minor injuriesLimited investigationFinal reportCessna C172N · North Liberty, INThe pilot's inadvertent touchdown and inadequate remedial action. Related factors are the low pass maneuver, and the soft terrain.Apr 4, 1991 · N737VP · Substantial damageNTSB FTW91LA058Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Hobart, OKThe pilot's failure to maintain clearance with known objects.Apr 3, 1991 · N53215 · DestroyedNTSB BFO91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-25-235D · Chesapeake, VAThe pilot's failue to maintain adequate airspeed after the loss of engine power for undetermined reasons.Apr 3, 1991 · N54917 · Substantial damageNTSB LAX91LA155Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS1-26-D · Warner Springs, CAThat the pilot used poor planning/decision and failed to maintain flying speed. Contributing to his accident was the loss of thermal lift and lack of experience in this type of aircraft.Apr 2, 1991 · N7562 · DestroyedNTSB CHI91IA120Incident · No injuriesIncident investigationFinal reportCessna 172RG · West Chicago, ILFailure of the splined shaft on the right main landing gear pivot assembly. A factor related to the incident was inadequate design of the landing gear pivot assembly.Apr 2, 1991 · N9592B · Minor damageNTSB FTW91LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Spring, TXPower loss due to carburetor ice, the pilot's failure to use carburetor heat, and his failure to apply adequate cushioning collective pitch during the flare segment of the autorotation. A factor in the accident was the pilot's improper autorotation technique.Mar 28, 1991 · N8050B · Substantial damageNTSB LAX91FA143Accident · 2 fatalField investigationFinal reportBeech 58P · Vail, AZThe failure of both pilots to maintain control of the airplane.Mar 27, 1991 · N27L · DestroyedNTSB ANC91LA038Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Saint Marys, AKThe pilot-in-command's failure to maintain VFR flight in instrument meteorological conditions while maneuvering on a VFR flight plan. Factors related to the accident was the pic's failure to evaluate the weather conditions that existed.Mar 27, 1991 · N9968M · Substantial damageNTSB MIA91FA107Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Chassahowitzka, FLThe pilot in commands continued VFR flight into IFR conditions resulting in an inflight loss of control and an inflight collision with the ground.Mar 24, 1991 · N95BE · DestroyedNTSB CHI91DEE03Accident · Minor injuriesFinal reportAir Command Gyrocopter · Lansing, ILThe pilot's delayed pullup. A factor in the accident was the pilot's exessive rate of descent during the spiral maneuver.Mar 24, 1991 · N447MR · Substantial damageNTSB BFO91LA034Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Buchanan, VAThe pilot's decision to attempt the takeoff with unfavorable winds.Mar 24, 1991 · N2451W · Substantial damageNTSB LAX91LA140Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58J · Chowchilla, CA1) The pilot not following the performance data for the aircraft, and 2) the pilot's inflight decision to turn the aircraft, which was at or near maximum gross weight, in such a direction that required more power than was available for the given flight…Mar 22, 1991 · N27AR · Substantial damageNTSB ANC91LA036Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Moose Creek, AKThe pilot-in-command's failure to maintain aircraft control, proper altitude not maintained, and failure to maintain flying speed. Contributing to the accident was the high altitude terrain.Mar 20, 1991 · N3419M · Substantial damageNTSB MIA91LA103Accident · No injuriesLimited investigationFinal reportCessna 150L · Miami, FLTotal loss of engine power due to inadvertent use of the mixture control by the student, inadequate supervision by the CFI, and delayed remedial action by the CFI resulting in the off airport landing.Mar 19, 1991 · N10629 · Substantial damageNTSB LAX91LA137Accident · No injuriesLimited investigationFinal reportSikorsky H-19/S55 · Richvale, CAThe failure of the engine's number 4 cylinder intake valve keeper. Trees under the helicopter at the time of the loss of engine power were factors in the accident.Mar 19, 1991 · N9894 · Substantial damageNTSB SEA91LA067Accident · No injuriesLimited investigationFinal reportClyde L. King Osprey II · Aurora, ORA loss of engine power due to fuel starvation because of an inadequate component and inadequate fuel system design.Mar 16, 1991 · N69CK · Substantial damageNTSB LAX91FA134Accident · 2 fatalField investigationFinal reportCessna 172RG · Buckeye, AZThe pilot of the airplane exceeding the certificated never exceed velocity. The overloading of the wing attachment fittings while maneuvering was a factor in the accident.Mar 16, 1991 · N6439 · DestroyedNTSB FTW91LA050Accident · No injuriesLimited investigationFinal reportHughes 269A · Addison, TXThe pilot's failure to maintain directional control during landing.Mar 16, 1991 · N62269 · Substantial damageNTSB CHI91LA109Accident · No injuriesLimited investigationFinal reportCessna 172K · Bridgman, MIThe pilot's failure to correct a descent. A factor in the accident was the pilot's maneuvering at an improper altitude.Mar 16, 1991 · N78195 · Substantial damageNTSB MIA91LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Avon, MSLoss of engine power for undetermined reasons during a turn while on an aerial application flight. Contributing to the accident was failure of the left magneto due to failure of a phenolic gear which drives the rotating magnet.Mar 15, 1991 · N73135 · Substantial damageNTSB LAX91LA128Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Farmington, CAThe contamination of the engine induction air filter. Soft terrain during the touchdown was a factor in the accident.Mar 10, 1991 · N59403 · Substantial damageNTSB DEN91FA049Accident · 2 fatalField investigationFinal reportBeech F33A · Sterling, COPoor judgement of the pilot and his misjudgement of altitude while buzzing over glassy water. His lack of visual ques to judge altitude over glassy water was a related factor.Mar 10, 1991 · N4179S · DestroyedNTSB LAX91LA126Accident · No injuriesLimited investigationFinal reportCessna 152 · Tucson, AZEngine failure due to oil starvation caused by a rotation of the main bearing. A factor in the accident was the failure of the operator maintenance personnel to accomplish an engine overhaul within the interval specified by the manufacturer.Mar 8, 1991 · N69116 · Substantial damageNTSB CHI91DCQ04Accident · 1 fatalFinal reportCessna A-188 · Harper, KSThe pilot inadvertently stalling the airplane.Mar 8, 1991 · N8189V · Substantial damageNTSB DEN91FA051Accident · 2 fatalField investigationFinal reportBeech 58 · Whites City, NMThe pilot's inflight decision to fly at low altitude. Factors were: turbulence and downdrafts.Mar 5, 1991 · N2019V · DestroyedNTSB NYC91FA080Accident · Serious injuriesField investigationFinal reportBeech F-33A · West Brookfield, MAThe decision of the pilot to fly the airplane in conditions that prevented him from seeing and avoiding higher terrain. Factors related to the accident were the pilot's decision to not follow the instrument approach into palmer, and the reduced visibility due…Mar 4, 1991 · N77Y · DestroyedNTSB LAX91FA116Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Monterey Park, CASuicide.Mar 3, 1991 · N5290T · DestroyedNTSB LAX91LA120Accident · No injuriesLimited investigationFinal reportBoeing A75 · Marana, AZThe failure of the pilot in the trailing airplane to maintain clearance from the lead airplane.Mar 2, 1991 · N803RB · 2 aircraft · Substantial damageNTSB MIA91FA089Accident · 2 fatalField investigationFinal reportCessna 152 · La Belle, FLThe pilot-in-command/cfi improper supervision of the dual student. This resulted in an in flight loss of control, stall/spin, and collision with terrain for failure to maintain airspeed while maneuvering in a turn.Feb 25, 1991 · N25938 · DestroyedNTSB CHI91DCJ01Accident · 1 fatalFinal reportCessna 172N · Western, NESpatial disorientation which resulted in a loss of aircraft control. A factor related to the accident was VFR flight into IMC.Feb 25, 1991 · N738LL · DestroyedNTSB BFO91LA025Accident · 1 fatalLimited investigationFinal reportCessna 182C · Bonnyman, KYThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.Feb 24, 1991 · N8696T · DestroyedNTSB CHI91LA097Accident · Serious injuriesLimited investigationFinal reportHughes 269C · North Mankato, MNThe fatique failure of the tail boom support strut attachment cluster and the improper inspection of the cluster attachment.Feb 20, 1991 · N8955F · DestroyedNTSB NYC91LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Punxsutawney, PAIntentional flight by the pilot into instrument meteorological conditions which resulted in a inflight collision with rising terrain, which was obscured by fog. A factor related to the accident was the pilots evaluation of the weather.Feb 19, 1991 · N5512Y · DestroyedNTSB ATL91LA059Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Pavo, GAThe failure of the no. 2 exhaust valve and cylinder head, which resulted in a total loss of engine power. A factor in the accident was the collision with a road sign during the forced landing.Feb 18, 1991 · N8770S · Substantial damageNTSB LAX91FA106Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Fredonia, AZThe pilot's inattention to the airspeed and subsequent loss of aircraft control after attempting VFR flight into adverse weather conditions. Contributing to the accident was the pilot's failure to recognize his limitations of his aircraft.Feb 17, 1991 · N4384L · DestroyedNTSB ANC91LA030Accident · Minor injuriesLimited investigationFinal reportBell 206-B · Kodiak, AKA loss of control and collision with terrain after the helicopter entered a whiteout condition.Feb 16, 1991 · N59568 · Substantial damageNTSB DEN91FA042Accident · 4 fatalField investigationFinal reportCessna U206 · Yampa, COInadvertent accelerated stall by the pilot in command while attempting a turn in close proximity to terrain. A factor was the high altitude.Feb 12, 1991 · N8014Z · DestroyedNTSB LAX91LA097Accident · No injuriesLimited investigationFinal reportRobinson R22A · Piru, CAFailure of the CFI to maintain main rotor RPM during a demonstrated autorotation.Feb 10, 1991 · N8491A · Substantial damageNTSB ANC91LA027Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Kivalina, AKThe pilot's failure in not identifying the weather conditions along the route. Contributing to the accident was improper in flight planning and decision by the PIC and the whiteout conditions.Feb 10, 1991 · N9651M · Substantial damageNTSB ANC91LA026Accident · Minor injuriesLimited investigationFinal reportMBB BO-105-CBS-4 · Valdez, AKWas the pilot-in-command's failure to properly use the approval checklist, improper procedures and directives.Feb 10, 1991 · N5413D · Substantial damageNTSB LAX91LA095Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Yuba City, CAThe failure of the no. 5 cylinder due to fatigue. Contributing to this accident was the wet terrain and crops.Feb 9, 1991 · N3633B · Substantial damageNTSB LAX91FA094Accident · 2 fatalField investigationFinal reportBoeing N2S-3 · Sonoma, CAThe pilot-in-command/cfi's performance of a low altitude aerobatic maneuver from which he failed to recover. Factors which contributed to the accident related to the pic's improper inflight decision, poor judgment, and his psychological condition.Feb 9, 1991 · N1065M · DestroyedNTSB LAX91LA092Accident · No injuriesLimited investigationFinal reportCessna 150M · Buckeye, AZThat maintenance personnel failed to properly install the wings by not reconnecting the bolts at the bellcrank and performed an inadequate annual inspection.Feb 6, 1991 · N9433U · Substantial damage