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 ATL93FA107Accident · 2 fatalField investigationFinal reportCessna TP206 · Epworth, GAThe pilot's failure to maintain vertical clearance above the trees while maneuvering which resulted in the collision with trees.Jun 10, 1993 · N5719J · DestroyedNTSB FTW93FA183Accident · 1 fatalField investigationFinal reportEagle DW-1 · Goree, TXThe pilot's failure to maintain adequate airspeed. A factor was the pilot's lack of experience in the airplane.Jun 9, 1993 · N8808Z · DestroyedNTSB NYC93FA102Accident · 1 fatalField investigationFinal reportCessna 150E · Selbyville, DEThe pilot's failure to maintain proper airspeed resulting in an inadvertent stall/spin and collision with the terrain. A factor related to the accident was the pilot's lack of experience in the banner towing operation.Jun 7, 1993 · N3981U · DestroyedNTSB LAX93LA243Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Montgomery Pass, NVThe pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the downdraft, low ceiling, rain, obscuration, and the mountainous terrainJun 5, 1993 · N6185E · DestroyedNTSB FTW93LA178Accident · No injuriesLimited investigationFinal reportBell-Transworld 47G-2 · Wynne, ARPartial power loss due to the failure of one magneto. A factor was the lack of suitable terrain for the forced landing.Jun 5, 1993 · N9238Z · Substantial damageNTSB ATL93LA106Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's failure to maintain clearance from trees during agricultural application maneuvering. Factors were the trees in the vicinity of the planned flight path.Jun 5, 1993 · N91676 · DestroyedNTSB FTW93LA173Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Ganado, TXThe pilot's failure to maintain clearance with the power linesJun 2, 1993 · N6752Q · DestroyedNTSB FTW93LA172Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Walnut Ridge, ARThe pilot's failure to maintain adequate clearance.Jun 2, 1993 · N48659 · DestroyedNTSB NYC93LA097Accident · 1 fatalLimited investigationFinal reportCessna A188B · Marengo, OHThe pilot's misjudged clearance from obstacles during aerial application, resulting in a collision with trees. A factor in this accident was the pilot's lack of total experience in aerial application flying.Jun 1, 1993 · N8254G · Substantial damageNTSB MIA93FA137Accident · 2 fatalField investigationFinal reportCessna 152 · Miami, FLThe pilot-in-command's failure to maintain airspeed while maneuvering at low altitude. A factor which contributed to the accident was the pilot's failure to maintain an adequate altitude from which a recovery would have been possible.Jun 1, 1993 · N67571 · DestroyedNTSB CHI93LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-400 · Elbow Lake, MNthe pilot's failure to maintain an adequate visual outlook during aerial application manuevers.May 31, 1993 · N2342Y · Substantial damageNTSB CHI93DCQ01Accident · 1 fatalFinal reportGrumman G-164A · Liberal, KSthe pilot's failure to maintain clearance with the powerlines. A factor related to the accident were the powerlines which were contacted during the aerial application operation.May 30, 1993 · N8385 · DestroyedNTSB LAX93FA231Accident · 4 fatalField investigationFinal reportBeech D-50E · Lee Vining, CAThe pilot's inadequate weather evaluation; inadequate in-flight planning and decision making; and the pilot's continued VFR flight into instrument meteorological conditions.May 28, 1993 · N2R · DestroyedNTSB FTW93LA169Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Weiner, ARPartial power loss due to improper installation of the linkage control bracket. A factor was the lack of suitable terrain for the forced landing.May 27, 1993 · N4593 · Substantial damageNTSB FTW93LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARPilot's failure to maintain clearance from the electrical wires.May 26, 1993 · N8405K · DestroyedNTSB MIA93FA127Accident · 4 fatalField investigationFinal reportCessna 172N · Deerfield Beach, FLFailure of the pilot-in-command to maintain airspeed (vso). The low altitude at the time of the aerodynamic stall was a factor.May 21, 1993 · N4931D · DestroyedNTSB CHI93LA179Accident · Minor injuriesLimited investigationFinal reportBell 47 · Berlin, WIThe pilot-in-command's failure to see the obstruction.May 21, 1993 · N8458E · DestroyedNTSB CHI93LA177Accident · 1 fatalLimited investigationFinal reportCessna 120 · Crawford, NEThe pilot's failure to maintain adequate airspeed.May 21, 1993 · N2976N · DestroyedNTSB CHI93DCD02Accident · 1 fatalFinal reportPiper PA-25 · Essex, IAFatigue failure of the forward spar fuselage attachment assembly for the right wing. A factor related to the accident was: the lack of a directed inspection procedure that could have been provided with the issuance of an airworthiness directive.May 21, 1993 · N6453Z · DestroyedNTSB SEA93LA114Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Moscow, IDThe inadequate visual lookout by the pilot and his failure to maintain clearance from electrical transmission wires. Factors relating to the accident were the sunglare and the presence of the wires.May 19, 1993 · N51458 · Substantial damageNTSB CHI93LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Mexico, MOa loss of engine power for undetermined reasons. A factor in the accident was the soft field landing site.May 19, 1993 · N8787L · Substantial damageNTSB DEN93LA060Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Mead, COA failure by the pilot in command to compensate for wind conditions and maintain control of the helicopter. A factor was: unfavorable wind conditions.May 16, 1993 · N38Q · Substantial damageNTSB FTW93LA159Accident · No injuriesLimited investigationFinal reportCessna A188A · Decatur, TXThe pilot's failure to maintain adequate clearance. A factor was the turbulenceMay 15, 1993 · N9901G · DestroyedNTSB FTW93LA156Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Trumann, ARPilot's failure to maintain terrain clearance. A factor was the diverted attention of the pilot.May 15, 1993 · N6556 · Substantial damageNTSB DEN93LA058Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-29 · Fountain, COFailure of both the pilot in command and the safety pilot to relinquish control of the airplane. A factor was the pilot in command's failure to communicate with the safety pilot.May 14, 1993 · N29RP · DestroyedNTSB CHI93LA170Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Oconto, NEThe pilot's inability to maintain altitude after encountering a downdraft.May 14, 1993 · N4503U · DestroyedNTSB CHI93FA171Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hubbardston, MIThe pilot's failure to maintain airspeed due to alcohol impairment while maneuvering at low altitude.May 14, 1993 · N4563R · DestroyedNTSB SEA93LA107Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Cody, WYThe failure of the pilot to maintain directional control while hovering. Factors relating to the accident were the improper decision by the pilot, improper touchdown point selection, high density altitude, and wind gusts.May 13, 1993 · N14NH · Substantial damageNTSB SEA93LA105Accident · 1 fatalLimited investigationFinal reportKaman HH-43F · Anatone, WAFatigue failure of the rotor transmission drive system, resulting from the improper certification/approval of the aircraft modification by the federal aviation administration.May 12, 1993 · N846D · DestroyedNTSB CHI93DER01Accident · 1 fatalFinal reportPitts S1 · Madison, MNThe pilot's failure to maintain adequate terrain clearance during aerobatic maneuvers.May 12, 1993 · N17FS · DestroyedNTSB FTW93LA151Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ville Platte, LAThe pilot's failure to maintain ground clearanceMay 11, 1993 · N91AY · Substantial damageNTSB CHI93FA165Accident · 3 fatalField investigationFinal reportCessna 182N · Genoa, NEThe private pilot's failure to maintain clearance from terrain while attempting aerobatic maneuvers. The pilot's disregard for procedures/directives, and attempted aerobatics, are factors.May 10, 1993 · N9222G · DestroyedNTSB FTW93FA150Accident · 2 fatalField investigationFinal reportCessna 150M · Liberty Hill, TXThe inadvertent stall with insufficient altitude to recover before terrain contact.May 9, 1993 · N63574 · DestroyedNTSB CHI93LA169Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Garden City, KSThe pilot-in-command's not maintaining proper altitude.May 9, 1993 · N731DD · Substantial damageNTSB ATL93LA090Accident · No injuriesLimited investigationFinal reportRapp VAN'S RV-4 · Greenwood, SCThe loss of engine power which resulted from the formation of carburetor ice. The lack of a carburetor heat source and the carburetor icing conditions were factorsMay 9, 1993 · N743DR · DestroyedNTSB ANC93FA061Accident · Minor injuriesField investigationFinal reportBell 214B1 · Thorne Bay, AKForeign object damage to the compressor assembly, probably due to loose nuts from the compressor case after improper maintenance (installation) by maintenance personnel.May 8, 1993 · N314CR · Substantial damageNTSB FTW93LA148Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lookeba, OKThe loss of engine power for undetermined reasons. Factors were the smoke in the cockpit and loss of outside visual reference.May 4, 1993 · N424OX · Substantial damageNTSB LAX93FA202Accident · 1 fatalField investigationFinal reportCessna 175 · Jackson, CAA failure of the pilot to adequately calculate the required fuel for the flight and the pilot's continued visual flight into instrument meteorological conditions. The failure of the non-instrument rated pilot to obtain a weather briefing, and adequately…May 3, 1993 · N9494B · DestroyedNTSB FTW93LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Waco, TXThe students pilot's failure to maintain clearance from an object and inadequate supervision by the instructor pilotMay 3, 1993 · N46285 · Substantial damageNTSB LAX93LA199Accident · 1 fatalLimited investigationFinal reportCanadair F-86E MK.6 · Santa Ana, CAThe pilot's inadequate planning/decision concerning performance of an aerobatic maneuver, and his failure to maintain adequate altitude/clearance above the runway during recovery from the maneuver. A factor related to the accident was: the pilot's lower…May 2, 1993 · N3842J · DestroyedNTSB ANC93FA056Accident · 1 fatalField investigationFinal reportBell 204B · Copper Harbor, AKFatigue failure of the tail rotor gearbox, and improper helicopter operations being conducted by the operator resulting in repetitive at and over maximum loads. Factors in the accident were: material defect of the tail rotor gear box (inadequate quality…May 2, 1993 · N204AQ · DestroyedNTSB CHI93MA143Accident · 2 fatalMajor investigationFinal reportBeech C99 · Shelton, NEThe deliberate disregard for the federal aviation regulations, gp express procedures, and prudent concern for safety by the two pilots in their decision to execute an aerobatic maneuver during a scheduled check ride flight, and the failure of gp express…Apr 29, 1993 · N115GP · DestroyedNTSB ANC93LA055Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Delta Junction, AKA loss of control for undetermined reasons.Apr 29, 1993 · N2578P · DestroyedNTSB FTW93LA139Accident · No injuriesLimited investigationFinal reportBell-K Copter 47G-2 · Walnut Ridge, ARWas the pilot's failure to maintain clearance of wires. A factor was the unsuitable terrainApr 28, 1993 · N7766 · Substantial damageNTSB DEN93LA051Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Truman, ARA power loss for undetermined reasons. A factor was: the lack of suitable terrain for the forced landing.Apr 28, 1993 · N31182 · DestroyedNTSB MIA93LA130Accident · 2 fatalLimited investigationFinal reportSmith FW2C80TD · Lucedale, MSThe pilot in command's operation of the aircraft in a manner which exceeded design limitations which resulted in inflight failure and separation of the wings.Apr 27, 1993 · N912WB · DestroyedNTSB LAX93LA189Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Sacramento, CAfailure of the pilot in command to maintain adequate airspeed during a low altitude maneuvering turn which resulted in an inadvertent stall.Apr 27, 1993 · N8307K · Substantial damageNTSB DEN93LA048Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Newark, TXAn inadvertent stall. A factor was: the pilot's diverted attention.Apr 25, 1993 · N2510F · Substantial damageNTSB CHI93LA148Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Yankton, SDThe pilot in command's failure to maintain proper clearance. Gusty wind conditions were a factor.Apr 24, 1993 · N5548W · DestroyedNTSB ANC93FA054Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Kashwitna, AKThe pilot in command not maintaining control of the airplane and his inadequate preflight preparation for high mountain terrain big game operations. Factors contributing to the accident were: the high terrain condition and the lack of total experience in the…Apr 24, 1993 · N3741Z · Destroyed