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 SEA95LA084Accident · No injuriesLimited investigationFinal reportBaxter-Wilson CW CHAMP-3 · Forks, WALoss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.Apr 23, 1995 · N4232L · Substantial damageNTSB SEA95LA078Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Walla Walla, WATotal failure of the freewheeling sprag unit. A factor to the accident was: suitable terrain was not available for landing.Apr 22, 1995 · N39SD · Substantial damageNTSB LAX95LA169Accident · 1 fatalLimited investigationFinal reportRyan ST-3-KR · Apple Valley, CAthe failure of the pilot to maintain airspeed, and entering into an inadvertent stall while flying close to the ground.Apr 22, 1995 · N214D · DestroyedNTSB FTW95LA173Accident · No injuriesLimited investigationFinal reportCessna 152 · Oakgrove, ARThe student pilot's failure to maintain clearance from power lines while maneuvering at low altitude and the flight instructor's inadequate supervision. Factor's were the instructor's decision to allow the simulation to continue to such a low altitude and…Apr 19, 1995 · N49696 · Substantial damageNTSB CHI95FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his attempt to perform an apparent aerobatic maneuver at an altitude that was insufficient to assure recovery.Apr 16, 1995 · N8397Y · DestroyedNTSB LAX95LA162Accident · 1 fatalLimited investigationFinal reportPitts S-1E · Auburn, CAThe pilot's poor judgment in performing a roll at an altitude insufficient to assure a safe completion.Apr 15, 1995 · N301SH · DestroyedNTSB LAX95FA161Accident · 2 fatalField investigationFinal reportHelio H-250 · Round Mountain, CAthe pilot's poor preflight planning/preparation and in-flight decision by continuing VFR flight into instrument meteorological conditions. The pilot's delay in returning to the departure airport, the low clouds, and low visibility were factors in this…Apr 12, 1995 · N5461E · DestroyedNTSB FTW95LA165Accident · Minor injuriesLimited investigationFinal reportMaule MXT-7-180 · Eunice, LAThe pilot's failure to maintain clearance. A factor was the windshear condition.Apr 11, 1995 · N563AB · Substantial damageNTSB FTW95LA162Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromadier · Pine Bluff, ARThe loss of engine power for undetermined reasons and the pilot's failure to maintain minimum required airspeed for flight, resulting in an inadvertent stall. A factor was the pilot's diverted attention.Apr 9, 1995 · N5277Z · DestroyedNTSB FTW95FA158Accident · 1 fatalField investigationFinal reportCessna 180B · Sanger, TXThe pilot's performance of a low altitude maneuver and his failure to maintain aircraft control. A factor was the gusty wind.Apr 9, 1995 · N5181E · DestroyedNTSB ATL95FA079Accident · 1 fatalField investigationFinal reportCessna 172F · Seneca, SCThe pilot's inadequate visual lookout while maneuvering near utility lines, which resulted in a collision with the wires.Apr 9, 1995 · N8197U · Substantial damageNTSB ATL95FA078Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Covington, TNThe pilot exceeded the design stress limits of the aircraft and subsequent overload failures of the stabilator and wing spars.Apr 8, 1995 · N6390C · DestroyedNTSB FTW95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Waco, TXTotal loss of engine power for reasons undetermined. A factor was the lack of suitable terrain on which to make a forced landing.Apr 7, 1995 · N94534 · Substantial damageNTSB LAX95LA154Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Stanfield, AZthe pilot's failure to maintain an adequate visual lookout for, and clearance from, obstacles while conducting simulated aerial application operations.Apr 6, 1995 · N3105B · DestroyedNTSB NYC95LA084Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cairo, OHFailure of the pilot to maintain adequate airspeed after initiating a climb, which resulted in a stall/spin.Apr 1, 1995 · N9228R · DestroyedNTSB CHI95DCQ01Accident · 1 fatalFinal reportPitts S-2B · Ottawa, KSThe pilot not performing proper stall/spin recovery procedures.Apr 1, 1995 · N876CB · DestroyedNTSB FTW95LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Catoosa, OKThe pilot's failure to maintain terrain and obstacle clearance.Mar 30, 1995 · N4900Y · Substantial damageNTSB MIA95FA094Accident · 2 fatalField investigationFinal reportCessna 172N · Venice, FLIntentional VFR flight into IMC by the pilot-in-command, failure of the pilot to maintain aircraft control, spatial disorientation, and altitude inadequate for recovery following the in flight loss of control.Mar 28, 1995 · N2196E · Substantial damageNTSB ATL95LA071Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Dauphin Island, ALThe pilot's improper use of the rudder control which resulted in a stall, and improper use of the elevator control, in that he maintained back pressure after the stall entry, keeping the airplane in a stalled conditions.Mar 24, 1995 · N83796 · Substantial damageNTSB FTW95LA145Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Gillett, ARThe engine main rod bearing seized to the crankshaft due to worn master rod metal pieces blocking the oil passages. A factor was an engine overhaul was not performed by company maintenance personnel.Mar 23, 1995 · N5561X · Substantial damageNTSB FTW95LA143Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gail, TXThe pilot's failure to maintain flying airspeed resulting in an inadvertent stall at low altitude. Factors were gusty winds and inadequate altitude for maneuvering.Mar 21, 1995 · N99MP · DestroyedNTSB CHI95LA106Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Meade, KSthe pilot's not obtaining/maintaining clearance with the utility pole. A factor was the utility pole.Mar 21, 1995 · N5237S · DestroyedNTSB FTW95LA144Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Edgewood, NMThe flight's encounter with a downdraft. The lack of a suitable landing area was a factor.Mar 20, 1995 · N51947 · Substantial damageNTSB ANC95LA036Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot's continued VFR flight into IMC conditions and a failure to maintain altitude. A factor in the accident was 'whiteout' weather conditions.Mar 20, 1995 · N1719U · Substantial damageNTSB LAX95LA139Accident · No injuriesLimited investigationFinal reportEnstrom F28C-2 · San Gorgonio, CAthe pilot's selection of an inadequate terrain clearance altitude while overflying mountainous terrain.Mar 19, 1995 · N5693W · DestroyedNTSB MIA95FA089Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Staley, NCThe pilot's failure to maintain airspeed (VSO) while maneuvering during a forced landing, resulting in an in-flight loss of control (inadvertent stall), and subsequent in flight collision with terrain. Contributing to the accident was the pilot's inadequate…Mar 18, 1995 · N7545D · DestroyedNTSB ATL95FA065Accident · 1 fatalField investigationFinal reportPiper J-3L-65 · Tallassee, ALThe student pilot's failure to see and avoid the utility line while performing unwarranted low altitude maneuvers.Mar 18, 1995 · N27120 · DestroyedNTSB LAX95LA135Accident · 2 fatalLimited investigationFinal reportCessna 180 · Winslow, AZThe pilot's poor judgement by intentionally deciding to buzz.Mar 15, 1995 · N1520C · DestroyedNTSB FTW95FA134Accident · 1 fatalField investigationFinal reportHinshaw, Keith T. BD5TP · Byers, COFailure by the pilot in command to maintain control of the aircraft. Factors were: lack of experience in type of aircraft and lack of experience in type of operation.Mar 15, 1995 · N777TK · DestroyedNTSB LAX95LA132Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Five Points, CAfuel exhaustion due to the pilot's inattention to the fuel supply.Mar 12, 1995 · N172ET · Substantial damageNTSB ANC95LA034Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Ketchikan, AKThe pilot's continued visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors in the accident were fog and low ceilings, and a failure of the operator to follow their procedures specified in the company operations manual.Mar 10, 1995 · N6478H · DestroyedNTSB SEA95LA063Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Bonners Ferry, IDRotor RPM was not maintained. Factors to the accident were: inadequate in flight planning/decision and suitable terrain was not available.Mar 7, 1995 · N222TE · Substantial damageNTSB SEA95FA064Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Lakecreek, ORThe pilot's failure to maintain adequate clearance from the surrounding terrain. A factor was the transmission lines.Mar 7, 1995 · N59HS · DestroyedNTSB SEA95LA056Accident · No injuriesLimited investigationFinal reportPitts S-2B · Spokane, WAFatigue failure of the crankshaft. Factors were the soft terrain and the pilot/owner's failure to conduct recurring crankshaft inspections recommended by the manufacturer.Feb 25, 1995 · N49335 · Substantial damageNTSB LAX95FA120Accident · 1 fatalField investigationFinal reportCessna 207A · Kotzebue, AKthe pilot's decision to enter a box canyon area at an altitude inadequate to maintain terrain clearance. The pilot's lack of mountain flying experience was a factor in this accident.Feb 25, 1995 · N6479H · DestroyedNTSB SEA95LA055Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34AG · Moses Lake, WAThe pilot-in-command's failure to maintain adequate altitude above the terrain. Factors include his diverted attention and attempted maneuver to avoid obstructions.Feb 23, 1995 · N4021Z · Substantial damageNTSB LAX95LA118Accident · No injuriesLimited investigationFinal reportCessna A-188B · Elmira, CAthe pilot's failure to maintain control of the aircraft after an inadvertent encounter with the wake turbulence from a preceding agricultural aircraft while maneuvering at low altitude.Feb 23, 1995 · N731CZ · Substantial damageNTSB SEA95LA053Accident · 2 fatalLimited investigationFinal reportBruce Tifft Varieze · Tiller, ORThe pilot's failure to maintain clearance from trees.Feb 18, 1995 · N115EZ · Substantial damageNTSB SEA95FA052Accident · 2 fatalField investigationFinal reportCessna 150M · Burley, IDThe failure of the dual student to maintain airspeed while maneuvering, and the flight instructor's inadequate supervision.Feb 18, 1995 · N45325 · Substantial damageNTSB LAX95LA109Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Arvin, CAThe seizure of the transmission due to lack of lubrication from a plugged oil supply line.Feb 15, 1995 · N5335V · Substantial damageNTSB SEA95LA051Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58JT · Marblemount, WAFatigue failure of the main rotor driveshaft.Feb 13, 1995 · N1099T · Substantial damageNTSB MIA95LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Wrightsville, GAThe pilot-in-command's failure to maintain adequate airspeed while maneuvering in a turn. The low altitude at the time of the stall was a factor.Feb 13, 1995 · N79157 · Substantial damageNTSB ATL95LA051Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Tullahoma, TNA lack of lubricant to the starter/roller clutch, seizure of the starter, and failure of the four crankshaft gear capscrews (bolts), which resulted in disengagement of the crankshaft (accessory) gear and subsequent loss of engine power.Feb 13, 1995 · N20001 · Substantial damageNTSB LAX95FA104Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Modesto, CAThe pilot lost control of the airplane for an unknown reason.Feb 12, 1995 · N53972 · DestroyedNTSB LAX95FA103Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Jamestown, CAthe pilot's intentional flight into IMC conditions and subsequent in-flight loss of control due to spatial disorientation.Feb 11, 1995 · CFCNW · DestroyedNTSB ATL95FA050Accident · 1 fatalField investigationFinal reportBeech B60 · Gatlinburg, TNThe pilot's continued visual flight into instrument weather conditions that resulted in a collision with rising terrain.Feb 11, 1995 · N6749S · DestroyedNTSB ATL95FA049Accident · 1 fatalField investigationFinal reportCessna 150J · Piedmont, SCThe pilot's inappropriate 'buzzing' that resulted in exceeding the airplane's design stress limits, the failure of the windshield, and the pilot's subsequent loss of control and impact with the ground.Feb 11, 1995 · N607BB · DestroyedNTSB SEA95FA048Accident · 2 fatalField investigationFinal reportPiper PA-601P · Tremonton, UTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with the mountainous terrain. Factors were the clouds, and the dark night.Feb 10, 1995 · N57NW · DestroyedNTSB LAX95LA101Accident · 1 fatalLimited investigationFinal reportCessna 172G · Pope Valley, CAthe pilot's poor judgment to buzz the lake and his inadequate visual lookout.Feb 9, 1995 · N4345L · DestroyedNTSB LAX95LA100Accident · No injuriesLimited investigationFinal reportBell 47G-3B · China Lake, CAthe pilot's misjudgement of the clearance between the main rotor and a tree while maneuvering at low altitude to herd animals.Feb 7, 1995 · N73240 · Substantial damage