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 NYC90DHM26Accident · No injuriesFinal reportPalen Sopwith Dolphin · Reinbeck, NYUndetermined engine failure during low altitude operations.Sep 30, 1990 · N47166 · Substantial damageNTSB LAX90DUQ02Accident · 1 fatalFinal reportFolland Gnat T-1 · Mojave, CAThe pilots failure to correct a descent during a low level aerobactics.Sep 30, 1990 · N1CW · DestroyedNTSB FTW90DQG05Accident · No injuriesFinal reportCessna T188C · Nazareth, TXThe pilot's failure to maintain obstacle clearance.Sep 30, 1990 · N2925J · Substantial damageNTSB ANC90LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Anchorage, AKThe pilot's poor judgement due to consumption of alcohol, and his improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.Sep 30, 1990 · N6523H · Substantial damageNTSB SEA90LA199Accident · 2 fatalLimited investigationFinal reportCessna 172N · Neilton, WAThe failure of the crew to maintain adequate clearance from the terrain. Factors to the accident were mountainous and box canyon terrain.Sep 29, 1990 · N738AQ · DestroyedNTSB NYC90DNA05Accident · 2 fatalFinal reportNorth American P-51D · Chatham, MAThe pilot's failure to maintain flying speed which resulted in an accelerated stall and loss of airplane control.Sep 29, 1990 · N51U · DestroyedNTSB FTW90LA188Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Albany, TXFuel starvation power loss due to the inadvertent movement of the fuel selector valve by the passenger.Sep 29, 1990 · N2550B · Substantial damageNTSB SEA90LA172Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Brothers, ORThe pilot's improper flight planning and decisions that led to him flying into rising terraain while engaged in low level flight activities.Sep 28, 1990 · N6522V · DestroyedNTSB NYC90DGM03Accident · Minor injuriesFinal reportContinental Copters MK5A · Cranesville, PAThe pilot's inability to maintain control of the helicopter after the loss of a portion of the cyclic control assembly; this resulted in ground impact and post-impact fire.Sep 28, 1990 · N9024T · DestroyedNTSB LAX90LA339Accident · No injuriesLimited investigationFinal reportWaco YMS · Kailua, HIImproper use of carburetor heat resulting in engine failure due to carburetor icing.Sep 28, 1990 · N40115 · Substantial damageNTSB MIA90FA190Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Thornton, MSThe improper drilling of a hole in the spar cap by a mechanic resulting in the initiation of fatigue cracking in the spar cap and subsequent failure of the spar cap and inflight separation of the wing.Sep 26, 1990 · N4017B · DestroyedNTSB BFO90FA077Accident · 1 fatalField investigationFinal reportChristen Industries A-1 · Middle River, MDThe pilot delayed his recovery from an intentional spin manuever until there was insufficient altitude to recover.Sep 23, 1990 · N6082P · DestroyedNTSB NYC90FA226Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Smithfield, PAThe failure of both pilots to maintain aircraft control while conducting training maneuvers at an altitude that precluded a safe recovery.Sep 22, 1990 · N9UP · DestroyedNTSB DEN90FA192Accident · 1 fatalField investigationFinal reportCessna 182P · Marble, COFailure of the private pilot (student pilot) to maintain sufficient altitude and airspeed above mountainous terrain, and inadequate supervision by the instructor pilot (CFI) and her delay in taking remedial action. Factors related to the accident were: the…Sep 22, 1990 · N9643G · DestroyedNTSB FTW90GA185Accident · No injuriesFinal reportHughes 369HS · New Orleans, LAThe pilot's failure to maintain rotor RPM. A factor in the accident was the lose of engine power due to fuel starvation.Sep 21, 1990 · N71552 · Substantial damageNTSB DEN90LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Mason, TXThe failure of the pilot to maintain an adequate visual lookout.Sep 20, 1990 · N746JG · Substantial damageNTSB ATL90LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Hertsboro, ALFatigue failure of the propeller blade which resulted from improper overhaul procedures, and the absence of oil in the propeller hub which would allow the detection of blade cracks.Sep 20, 1990 · N8677G · Substantial damageNTSB LAX90DUM03Accident · 1 fatalFinal reportParrigin RV-4 · Poway, CAThe pilot's performing low level acrobatic maneuvers and failure to maintain aircraft control.Sep 18, 1990 · N810WP · DestroyedNTSB SEA90LA186Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Kamas, UTPoor inflight planning by the pilot. The airplane encountered a possible downdraft condition while maneuvering in mountainous terrain which resulted in an inflight collision with trees.Sep 17, 1990 · N67853 · DestroyedNTSB FTW90FA183Accident · 1 fatalField investigationFinal reportHughes 269A · Kingsville, TXThe fatigue failure of the left flange on the tail boom saddle fitting.Sep 17, 1990 · N403SD · Substantial damageNTSB FTW90DPJ12Accident · No injuriesFinal reportMassegee Rebel 300 · El Reno, OKFailure of the elevator control rod at the bell crank.Sep 17, 1990 · N469RR · DestroyedNTSB SEA90LA187Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Park City, UTThe pilot's lack of understanding of aircraft performance and meteorological conditions when flying at high density altitude in close proximity to mountainous terrain.Sep 16, 1990 · N4183U · Substantial damageNTSB ANC90LA175Accident · No injuriesLimited investigationFinal reportCessna 206 · Puntilla Lake, AKAn inadequate preflight.Sep 16, 1990 · N756JC · Substantial damageNTSB CHI90FA265Accident · 2 fatalField investigationFinal reportCessna 172M · Aberdeen, SDFailure to maintain a safe airspeed resulting in an inadvertent stall/spin.Sep 15, 1990 · N73059 · DestroyedNTSB FTW90FA181Accident · 1 fatalField investigationFinal reportCessna 152 · Blue Ridge, TXThe pilot's decision to perform buzzing type maneuvers, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall.Sep 14, 1990 · N69137 · DestroyedNTSB CHI90LA279Accident · No injuriesLimited investigationFinal reportCessna 177B · Kokomo, INExceeding the design stress limits of the aircraft while recovering from a loss of control in flight due to spatial disorientation. Factors related to the accident were delayed remedial action and inadequate supervision of an inexperienced pilot by the…Sep 12, 1990 · N35014 · Substantial damageNTSB ATL90DLG02Accident · 1 fatalFinal reportCessna A188B · Aiken, SCThe pilot's delayed pull-up during an aerial application swath which resulted in the collision with a static wire associated with electrical transmission lines.Sep 11, 1990 · N9422R · DestroyedNTSB SEA90LA178Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Elk Mountain, WYThe pilot's failure to maintain flying speed while at an altitude that did not provide adequate terrain clearance for a safe stall recovery.Sep 10, 1990 · N9157A · Substantial damageNTSB LAX90FA320Accident · 2 fatalField investigationFinal reportCessna A152 · Tucson, AZFailure of the pilot to recover from a spin. Factors related to the accident were: the pilot's failure to assure there was adequate altitude to recover from an inadvertent or intentional spin, and his lack of recent expereince in the type of operation.Sep 10, 1990 · N4649A · DestroyedNTSB CHI90DCJ02Accident · 1 fatalFinal reportAero Commander Calair A9B · Ord, NEThe pilot's failure to maintain aircraft control during low altitude maneuvering.Sep 8, 1990 · N7691V · DestroyedNTSB ANC90FA167Accident · 2 fatalField investigationFinal reportTaylorcraft DCO-75 · Mckinley Park, AKFailure of both pilots to maintain adequate visual lookout to see-and-avoid other aircraft.Sep 8, 1990 · N49032 · 2 aircraft · DestroyedNTSB SEA90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Lewistown, MTThe pilot did not maintain an adequate lookout while maneuvering which resulted in a collision with a transmission wire.Sep 6, 1990 · N2107F · Substantial damageNTSB FTW90DPG14Accident · Minor injuriesFinal reportGrumman G-164B · Dumas, ARThe inadvertent stall encountered during the turn to reverse direction.Sep 4, 1990 · N48602 · Substantial damageNTSB LAX90FA310Accident · 1 fatalField investigationFinal reportSchempp-Hirth NIMBUS-2C · California City, CAThe pilot's improper decision to execute the rapid climbing turn maneuver at an insufficient airspeed. Contributing to this accident was the premature dumping of the glider's water ballast.Sep 3, 1990 · N39285 · DestroyedNTSB LAX90DVA11Accident · Minor injuriesFinal reportBob Sandlin BOB'S Executive · Sanger, CAFailure to maintain directional control during a hover.Sep 3, 1990 · N8153R · Substantial damageNTSB ANC90LA163Accident · No injuriesLimited investigationFinal reportCessna 150-L · Anchorage, AKThe pilot-inn-command's failure to maintain flying speed. Contributing to the accident was improper altitude.Sep 2, 1990 · N17008 · Substantial damageNTSB CHI90DCQ01Accident · Minor injuriesFinal reportPiper PA 36-300 · Mingo, KSInadequate airspeed resulting in a stall/mush being encountered by the PIC. Contributing factors were a tailwind and a load jettison not performed.Aug 31, 1990 · N2329Y · Substantial damageNTSB NYC90DFJ04Accident · No injuriesFinal reportSchweizer Grumman G-164A · Wayland, NYA cracked engine cylinder assembly, which resulted in loss of engine power.Aug 30, 1990 · N48395 · Substantial damageNTSB FTW90LA172Accident · Minor injuriesLimited investigationFinal reportBell B206BIII · Cameron, LAThe pilot's failure to jettison the external load.Aug 30, 1990 · N59558 · Substantial damageNTSB FTW90DPG13Accident · No injuriesFinal reportGrumman G-164A · Luxora, ARA partial power loss due to failure of the number five connecting rod. A factor was the soft terrain in which the forced landing was made.Aug 30, 1990 · N5213 · Substantial damageNTSB NYC90LA203Accident · 2 fatalLimited investigationFinal reportCessna 152 · Provincetown, MAThe failure of the pilot to maintain adequate airspeed, which resulted an inadvertent stall/spin. Probable factors related to the accident were: failure of the pilot to follow procedures/directives, and his lack of proper certification (qualification) for…Aug 28, 1990 · N24894 · DestroyedNTSB FTW90FA168Accident · 2 fatalField investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain flying speed which resulted in an inadvertent stall during the steep turn. A factor was the door opening in flight.Aug 26, 1990 · N66369 · DestroyedNTSB CHI90FA240Accident · 2 fatalField investigationFinal reportCessna 182 · Marine City, MIPilot-in-command's ostentation display resulted in his failure to maintain flying sped, and a subsequent stall.Aug 26, 1990 · N5373B · DestroyedNTSB FTW90DQG04Accident · 1 fatalFinal reportPiper PA-25-235 · Lubbock, TXFailure of the pilot to maintain adequate airspeed and altitude during a turn-around maneuver, which resulted in the aircraft stalling into the ground.Aug 25, 1990 · N9852P · DestroyedNTSB CHI90FA239Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Clark Lake, MIPoor judgement of the pilot due to consumption of alcohol, and his failure to maintain proper altitude and clearance above water, while performing aerobatic maneuvers.Aug 25, 1990 · N2521F · DestroyedNTSB MIA90LA176Accident · No injuriesLimited investigationFinal reportGrumman 164-A · Dundee, MSImproper maintenance repair by an unknown person that initiated the engine failure and the forced landing.Aug 24, 1990 · N9650 · Substantial damageNTSB FTW90DPG10Accident · No injuriesFinal reportCessna 188A · Hunter, ARThe pilot's failure to maintain proper clearance above the crops.Aug 23, 1990 · N3566Q · DestroyedNTSB LAX90DUJ06Accident · 2 fatalFinal reportChristen/Walter Christen Eagle II · Marana, AZThe loss of control by the pilot.Aug 20, 1990 · N3272U · DestroyedNTSB DEN90DTE05Accident · No injuriesFinal reportCessna 188B · Eckley, COA failure on the part of the pilot in command to maintain adequate terrain clearance.Aug 20, 1990 · N4933Q · Substantial damageNTSB LAX90LA295Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Tucson, AZThe pilot to maintain proper pitch attitude and airspeed to avoid an aerodynamic stall.Aug 19, 1990 · N71330 · Substantial damage