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 NYC93FA166Accident · 1 fatalField investigationFinal reportPiper PA-25-260 · Plymouth, MAwas the failure of the pilot to attain proper alignment for the banner pickup which resulted in picking up the banner tow rope on the wing, and an inflight loss of control and uncontrolled contact with the ground.Aug 22, 1993 · N4844Y · Substantial damageNTSB CHI93LA347Accident · 1 fatalLimited investigationFinal reportWells Pitts S-2-S · Bloomington, ILthe pilot in command continued the aerobatic maneuver too long to effect a safe level off.Aug 22, 1993 · N10T · DestroyedNTSB FTW93LA243Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Lafayette, LAThe engine failure for undetermined reasons. A factor was the lack of suitable terrain onto which a forced landing could be executed.Aug 21, 1993 · N450EC · Substantial damageNTSB CHI93DTG03Accident · No injuriesFinal reportPiper PA-25-235 · Washburn, NDthe loss of engine power due to a magneto failure.Aug 20, 1993 · N4693Y · Substantial damageNTSB MIA93LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Benton, MSThe pilot-in-command's failure to maintain proper visual outlook.Aug 18, 1993 · N6731Q · DestroyedNTSB CHI93LA326Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Marshall, MNThe pilot's improper decision to depart after receiving a weather briefing which forecasted IMC en route and his loss of aircraft control due to spatial disorientation.Aug 17, 1993 · N4477X · DestroyedNTSB MIA93LA176Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering resulting in a stall/mush.Aug 16, 1993 · N8451K · Substantial damageNTSB NYC93LA157Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Beach Haven, NJFailure of the banner release system to function for an undetermined reason, which resulted in an inability of the aircraft to sustain flight once the banner began dragging in the water. A factor related to the accident was: lack of coordination between the…Aug 15, 1993 · N53136 · Substantial damageNTSB LAX93LA324Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-35C · Wickenburg, AZthe pilot's failure to maintain an adequate airspeed margin while maneuvering to land, resulting in an inadvertent stall/spin.Aug 15, 1993 · N2562H · DestroyedNTSB CHI93FA322Accident · 2 fatalField investigationFinal reportPiper J-3C-85 · Salol, MNThe pilot's failure to maintain adequate airspeed resulting in an aerodynamic stall. The pilot's lack of recent flight experience is a related factor.Aug 15, 1993 · N6301H · DestroyedNTSB CHI93DEE05Accident · Serious injuriesFinal reportWeatherly 620 · Mendota, ILThe pilot-in-command's failure to maintain clearance fom powerlines during an aerial application manuever.Aug 14, 1993 · N4605P · DestroyedNTSB NYC93LA150Accident · No injuriesLimited investigationFinal reportErco 415D · Thomaston, METhe improper weather evaluation by the non-instrument-rated pilot, and the subsequent VFR flight into instrument meteorologial conditions, resulting in a collision with the terrain.Aug 11, 1993 · CFJUB · Substantial damageNTSB NYC93LA147Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stonington, CTThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin, and the pilot's improper use of the carburetor heat which resulted in the accretion of carburetor ice. A factor was carburetor icing conditions.Aug 11, 1993 · N98382 · Substantial damageNTSB LAX93LA319Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Dixon, CAthe failure of the pilot to visually detect and avoid the guy wire.Aug 11, 1993 · N100LM · DestroyedNTSB CHI93LA316Accident · No injuriesLimited investigationFinal reportCessna A188B · Lexington, NEobstacle clearance not maintained by the pilot-in-command.Aug 10, 1993 · N4802Q · DestroyedNTSB NYC93LA146Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Leeds, METhe loss of engine power for undetermined reasons.Aug 7, 1993 · N739EP · Substantial damageNTSB MIA93LA172Accident · No injuriesLimited investigationFinal reportLove, Sanford W. Dominator · Okeechobee, FLThe failure of the pilot in command to maintain rotor speed while reversing direction.Aug 7, 1993 · N44162 · Substantial damageNTSB FTW93LA231Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Salida, COThe climb capability of the airplane being exceeded and the pilot's decision to turn into the rising terrain. A factor was the high density altitude.Aug 6, 1993 · N9633B · DestroyedNTSB FTW93FA229Accident · 1 fatalField investigationFinal reportCessna 152 · Houston, TXCompany management's dispatch of an airplane with known deficiencies, their failure to correct the deficiencies, and the student pilot's inadvertent entry into a stall. Factors which contributed to the accident were: chafed wiring, fouled spark plugs, a…Aug 5, 1993 · N24893 · DestroyedNTSB MIA93LA170Accident · No injuriesLimited investigationFinal reportRobinson R22 B · Miami, FLThe commercial rated student pilot's failure to insure the instructor had taken control of the helicopter and the flight instructors failure to properly supervise the student which resulted in the student letting go of the controls while in a hover.Aug 4, 1993 · N24049 · Substantial damageNTSB CHI93DCD03Accident · 1 fatalFinal reportHoward W. Dutton Glas AIR II RG · Mt. Pleasant, IAthe pilot-in-command's not maintaining aircraft control.Aug 2, 1993 · N92T · DestroyedNTSB FTW93LA225Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Osceola, ARInadvertent stall. Factors were the improper latching of the engine cowling by the pilot and his inadequate preflight inspection.Aug 1, 1993 · N4021C · Substantial damageNTSB CHI93DCQ02Accident · No injuriesFinal reportCessna 188 · Buhler, KSthe loss of engine power due to a fractured accessory (camshaft) drive gear.Aug 1, 1993 · N4864Q · Substantial damageNTSB DEN93LA094Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Corpus Christi, TXAn inadvertent stall. A factor was the pilot's intentional buzzing at low altitude over the beach.Jul 31, 1993 · N5115B · Substantial damageNTSB CHI93LA305Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Clarinda, IAThe commercial pilot's failure to maintain adequate clearance from obstacles during aerial application maneuvers.Jul 31, 1993 · N8480E · DestroyedNTSB DEN93LA093Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Brookland, ARThe pilot's failure to maintain adequate object clearance.Jul 30, 1993 · N7319V · Substantial damageNTSB DEN93LA091Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Duson, LAFailure of the transmission mast bearing, resulting in oil contamination and subsequent blockage of the internal oil ports and passages. Factors were: total loss of collective control and partial loss of cyclic control.Jul 30, 1993 · N9014T · Substantial damageNTSB DEN93FA090Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Elk Springs, COThe performance of a stall/spin at an altitude inadequate for recovery and level off.Jul 29, 1993 · N5035K · DestroyedNTSB CHI93LA282Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brule, NEThe unsuitable terrain encountered. Factors relating to this accident include total failure of an engine cylinder, and a hidden obstruction.Jul 29, 1993 · N8368 · Substantial damageNTSB LAX93LA303Accident · No injuriesLimited investigationFinal reportAyres S2R · Stratford, CAThat the pilot misjudged the airplane's altitude. Factors relating to this accident were the pilot's fatigue and the light conditions.Jul 28, 1993 · N4930X · DestroyedNTSB LAX93LA302Accident · No injuriesLimited investigationFinal reportRobinson R22-B · Venice, CAThe failure of the pilot to maintain proper main rotor RPM, altitude, and airspeed during the performance of a steep turn. Inadequate in-flight planning and overconfidence in the pilot's abilities were factors in this accident.Jul 28, 1993 · N23517 · Substantial damageNTSB DEN93LA088Accident · Serious injuriesLimited investigationFinal reportPiper J3C-90 · Meeker, COFailure of the pilot to maintain adequate terrain clearance. A factor was the intentional low pass performed by the pilot in command.Jul 28, 1993 · N33111 · DestroyedNTSB CHI93LA303Accident · No injuriesLimited investigationFinal reportSchweizer G167B · Borup, MNthe loss of engine power due to a cracked cylinder head.Jul 27, 1993 · N6637Q · Substantial damageNTSB SEA93LA161Accident · No injuriesLimited investigationFinal reportBell B206BII · Lake Powell, UTA power loss for undetermined reasons. Factors include landing in water.Jul 26, 1993 · N502AH · Substantial damageNTSB CHI93MA276Accident · 3 fatalMajor investigationFinal reportCanadair CL-600-2B19 · Byers, KSThe captain's failure to adhere to the agreed upon flight test plan for ending the test maneuver at the onset of prestall stick shaker, and the flightcrew's failure to assure that all required switches were properly positioned for anti-spin chute deployment.…Jul 26, 1993 · CFCRJ · DestroyedNTSB CHI93FA274Accident · 2 fatalField investigationFinal reportCessna A150K · Goshen, INFailure of both pilots to see and avoid each other. A factor in the accident was the position of the sun which resulted in sun glare for the pilot of the mong sport.Jul 25, 1993 · N8382M · 2 aircraft · DestroyedNTSB ATL93LA134Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ashford, ALThe failure of the engine supercharger assembly, which resulted in a loss of engine power. A factor was the trees at the forced landing site.Jul 25, 1993 · N8373 · DestroyedNTSB CHI93DEP02Accident · 1 fatalFinal reportStoeckler RV-4 · Lake Delton, WIthe pilot-in-command's failure to maintain proper altitude. A factor was trees.Jul 24, 1993 · N720DS · DestroyedNTSB BFO93FA135Accident · 2 fatalField investigationFinal reportKrowell Christen Eagle II · Lebanon, NHInadequate crew/group coordination.Jul 24, 1993 · N90BC · DestroyedNTSB ANC93LA125Accident · No injuriesLimited investigationFinal reportHughes 369D · Cordova, AKA loss of engine power for undetermined reasons. A factor was the rough/uneven terrain.Jul 24, 1993 · N3115Y · Substantial damageNTSB LAX93FA297Accident · 2 fatalField investigationFinal reportCessna 175B · Blythe, CAThe pilot's failure to see and avoid the cable due to drug impairment. Factors which contributed to the accident were: the pilot's intentional buzzing, his ostentatious display, and his failure to maintain an adequate altitude over the river.Jul 23, 1993 · N8264T · DestroyedNTSB DEN93LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Garner, ARTotal failure of one propeller blade. Factors were the continued operation of the engine during the forced landing, despite the pilot's efforts to shut it down, and the lack of suitable terrain for the forced landing.Jul 22, 1993 · N3650U · Substantial damageNTSB CHI93FA267Accident · 4 fatalField investigationFinal reportCessna 310C · Norton, KSThe pilot's failure to maintain aircraft control due to alcohol impairment. Factors which contributed to the accident were: the pilot's intentional flight into adverse weather, fog, and the dark night.Jul 22, 1993 · N339R · DestroyedNTSB MIA93FA160Accident · 4 fatalField investigationFinal reportPiper PA-28 · Morriston, FLVFR flight by the pilot(s) into instrument meteorological conditions (IMC) and failure to maintain adequate altitude (or clearance) from the tower. The proximity of the tower/guy wires and weather condition were related factors.Jul 21, 1993 · N5096W · DestroyedNTSB BFO93FA132Accident · 2 fatalField investigationFinal reportNorth American T-6G · Berryville, VA1.) The pilot's poor judgment in performing a maneuver in close proximity to the ground, and 2.) the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin and subsequent loss of control in flight, resulting in a collision…Jul 20, 1993 · N44CT · DestroyedNTSB ANC93LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon Flat, AKThe pilot in commands misjudgment of aerodynamic maneuvering parameters (inflight decision making), and his inadvertant stall/spin entry at low altitude.Jul 19, 1993 · N1009A · DestroyedNTSB CHI93LA260Accident · 2 fatalLimited investigationFinal reportChampion 7KCAB · Hill City, KSthe loss of engine power for an undetermined reason and the pilot's decision to continue flying the airplane with known deficiencies. Factors in the accident are the lack of suitable terrain available for a forced landing, the airplane's low altitude, and the…Jul 18, 1993 · N11AT · DestroyedNTSB CHI93DTK02Accident · Minor injuriesFinal reportHiller UH-12E · Milbank, SDUndeterminedJul 18, 1993 · N4028M · DestroyedNTSB CHI93DTG02Accident · No injuriesFinal reportAero Commander S2R · Hoople, NDA loss of engine power due to a cracked engine cylinder.Jul 18, 1993 · N5635X · Substantial damageNTSB SEA93FA153Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Battleground, WAThe pilot in command's failure to maintain adequate altitude during his maneuver.Jul 15, 1993 · N8472C · Destroyed