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 FTW95FA406Accident · 5 fatalField investigationFinal reportMartin B-26C · Odessa, TXthe failure of the pilot to maintain minimum airspeed for flight resulting in an inadvertent stall/spin. Factors were the loss of power for undetermined reasons, and the pilot's lack of recent flight experience in the aircraft.Sep 28, 1995 · N5546N · DestroyedNTSB CHI95LA339Accident · 1 fatalLimited investigationFinal reportMcclintic-Piercie KR-1 · Scotts, MIthe pilot's failure to maintain airspeed.Sep 28, 1995 · N9975A · DestroyedNTSB CHI95LA335Accident · Minor injuriesLimited investigationFinal reportBell 206B · Indianapolis, INThe pilot not maintaining adequate terrain clearance during his maneuvering exercise and his abrupt lowering of the collective. A factor associated with the accident was the pilot's lack of experience.Sep 28, 1995 · N28SJ · Substantial damageNTSB ATL95LA175Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Hoover, ALThe pilot's failure to maintain directional control when he positioned the helicopter in a hover so as to induce a loss of tail rotor effectiveness.Sep 27, 1995 · N267RW · Substantial damageNTSB SEA95LA224Accident · 1 fatalLimited investigationFinal reportMacphee Vans RV-6 · Jacksonville, ORthe pilot-in-command's failure to maintain altitude and/or clearance from surrounding terrain after a low pass. The mountainous terrain was a factor.Sep 23, 1995 · N726WM · DestroyedNTSB SEA95LA223Accident · 2 fatalLimited investigationFinal reportEurocopter AS350BA · Crater Lake, ORFailure of the pilot to maintain sufficient altitude/clearance above water, while performing low altitude flight. Factors relating to the accident were: the glassy water condition, and lack of visual cues concerning perception of altitude.Sep 23, 1995 · N6099Z · DestroyedNTSB NYC95LA226Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Auburn, NYthe loss of airplane control as a result of a jammed rudder for undetermined reasons.Sep 23, 1995 · N6304N · DestroyedNTSB MIA95LA233Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Dyer, TNThe pilot-in-command's failure to properly manage the fuel required for the flight, resulting in a total loss of engine power due to fuel exhaustion and subsequent in flight collision with trees and terrain.Sep 23, 1995 · N5095S · Substantial damageNTSB MIA95LA227Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · Vero Beach, FLFailure of company maintenance personnel to comply with a required airworthiness directive, resulting in an in-flight fire and emergency landing. Contributing to the accident was the lack of suitable terrain for the forced landing.Sep 21, 1995 · N7304C · DestroyedNTSB LAX95LA348Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Marana, AZthe pilot misjudged clearance from the power lines.Sep 21, 1995 · N8551L · Substantial damageNTSB FTW95FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-502A · Coleman, TXthe pilot's continued flight into adverse weather resulting in spatial disorientation and loss of control. A factor was the pilot's improper weather evaluation and the weather.Sep 21, 1995 · N91969 · DestroyedNTSB SEA95LA227Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Yakima, WAFatigue failure of the bolt attaching the scissor arm assembly to the pitch control support assembly. The failure of the bolt led to a loss of collective pitch control and reduced rotor RPM.Sep 20, 1995 · N38115 · Substantial damageNTSB SEA95LA221Accident · Serious injuriesLimited investigationFinal reportBell UH-1L · Grace, IDthe fatigue failure of the centrifugal impeller and the lack of suitable terrain for a forced landing. Factors contributing to the accident were: the lack of required compliance with the FAA Airworthiness Directive by the operator, the insufficiently defined…Sep 18, 1995 · N70410 · DestroyedNTSB CHI95LA323Accident · 1 fatalLimited investigationFinal reportHaugen Kolb Firestar II · Souris, NDthe pilot's failure to maintain control of the ultralight vehicle.Sep 17, 1995 · N42996 · DestroyedNTSB CHI95FA326Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Danville, INthe pilot-in-command's inadequate recovery while maneuvering.Sep 16, 1995 · N118AT · DestroyedNTSB ATL95LA169Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Plains, GAFailure of the number four cylinder rocker arm housing and pin, which resulted in a closed exhaust valve and loss of engine power.Sep 16, 1995 · N2362D · Substantial damageNTSB ANC95FA167Accident · 2 fatalField investigationFinal reportCessna 185 · Petersburg, AKThe pilot's failure to maintain sufficient airspeed above the airplane's stall speed. The high terrain and low ceiling (clouds) were related factors.Sep 14, 1995 · N90033 · DestroyedNTSB ANC95TA166Accident · Serious injuriesFinal reportBell 206B · Glennallen, AKThe pilot's improper in-flight planing/decision and inadequate supervision of the passenger, which allowed the helicopter's lateral center-of-gravity to be exceeded. Factors relating to the accident were: pressure (compelling influence) on the pilot and…Sep 10, 1995 · N84TA · DestroyedNTSB ANC95LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKFailure of the pilot to maintain adequate altitude/clearance from terrain, during a low pass over a prospective (off-airport) landing area. Factors relating to the accident were: rain and rising/uneven terrain.Sep 10, 1995 · N6996D · Substantial damageNTSB FTW95LA385Accident · No injuriesLimited investigationFinal reportCessna 210F · Montrose, COThe pilot's inattentiveness to the low fuel supply and his failure to switch fuel tanks in a timely manner. A factor was the lack of suitable terrain for the forced landing.Sep 9, 1995 · N1851F · Substantial damageNTSB ANC95LA162Accident · No injuriesLimited investigationFinal reportCessna 140 · Anchorage, AKfailure of the pilot to maintain sufficient altitude/clearance from terrain during a low pass over a prospective (off-airport) landing area. Factors relating to the accident were: the 'flat' lighting condition, and uneven terrain.Sep 9, 1995 · N89138 · Substantial damageNTSB SEA95LA211Accident · 2 fatalLimited investigationFinal reportGift Challenger II · Scappoose, ORFailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall/spin. Although the aircraft recovery parachute had been activated, there was not enough time (or altitude) for it to fully deploy.Sep 8, 1995 · N838TG · DestroyedNTSB SEA95FA212Accident · 2 fatalField investigationFinal reportAero Commander 560 · Ketchum, IDThe pilot-in-command's failure to maintain adequate airspeed during a turn resulting in a stall/spin. Factors contributing to the accident were the pilot-in-command's becoming geographically disoriented as well as his improper in-flight decision, and…Sep 8, 1995 · N731R · DestroyedNTSB SEA95FA209Accident · 1 fatalField investigationFinal reportCessna 180J · Browning, MTClearance from the ground was not maintained while attempting a VFR flight into IMC weather conditions. A factor to the accident was fog.Sep 7, 1995 · N7820K · DestroyedNTSB LAX95LA326Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Porterville, CAthe flight instructor's inadequate supervision of the flight; the dual student's improper use of the flight controls; and improper remedial action.Sep 6, 1995 · N1348Z · Substantial damageNTSB FTW95LA379Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Loop, TXThe pilot's failure to maintain clearance with the power line. A factor was the sun glare light conditions.Sep 5, 1995 · N4998X · Substantial damageNTSB CHI95LA306Accident · Serious injuriesLimited investigationFinal reportPiper PA-11 · Badger, SDthe pilot's failure to maintain adequate airspeed while making a steep right turn. A contributing factor was the insufficient altitude needed to make a recovery.Sep 5, 1995 · N70613 · DestroyedNTSB SEA95LA208Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Salem, ORA loss of power for undetermined reasons and the pilot's failure to maintain airspeed while maneuvering for a forced landing.Sep 4, 1995 · N9222H · Substantial damageNTSB NYC95LA214Accident · 1 fatalLimited investigationFinal reportGillet C.P. 328 · Fire Island, NYthe failure of the pilots to maintain control of the airplane while performing aerobatics.Sep 4, 1995 · N4171G · DestroyedNTSB SEA95FA198Accident · 1 fatalField investigationFinal reportBeech A24R · Yakima, WAThe pilot's failure to maintain clearance from a tree. Factors related to the accident were: the pilot's poor judgment and ostentatious display to buzz.Sep 3, 1995 · N9726Q · DestroyedNTSB NYC95FA212Accident · 1 fatalField investigationFinal reportPiper PA-18A-150 · Egg Harbor, NJFailure of the pilot to maintain adequate airspeed during pull-up from a banner pickup, which resulted in a stall and collision with trees before recovering from the stall.Sep 3, 1995 · N9374D · DestroyedNTSB CHI95LA302Accident · 1 fatalLimited investigationFinal reportMorrow Starduster I · Ottawa, KSthe pilot's delayed remedial action during the inverted spin maneuver. A factor associated with the accident was the pilot's lack of recent experience in the type operation.Sep 3, 1995 · N46565 · DestroyedNTSB LAX95LA318Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Dos Palos, CAthe fatigue failure of the tail rotor tension torsion bar plates.Sep 1, 1995 · N4027D · Substantial damageNTSB ANC95LA158Accident · 1 fatalLimited investigationFinal reportShort Brothers SC-7 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions. The weather was a factor.Sep 1, 1995 · N30GA · DestroyedNTSB LAX95FA313Accident · 2 fatalField investigationFinal reportBell 206-L1 · Johnsondale, CAthe pilot's failure to maintain an adequate obstacle clearance altitude while operating at a very low level. The aircraft's lack of wire cutters was a factor in this accident.Aug 30, 1995 · N3886J · DestroyedNTSB LAX95LA310Accident · No injuriesLimited investigationFinal reportBell 206BIII · Carmel Valley, CAthe pilot's failure to maintain an adequate clearance from obstructions while hovering.Aug 28, 1995 · N206MT · Substantial damageNTSB FTW95LA361Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Holyoke, COthe pilot's failure to maintain terrain clearance.Aug 28, 1995 · N9650 · Substantial damageNTSB LAX95LA305Accident · No injuriesLimited investigationFinal reportSikorsky CH-54A · Emigrant Gap, CAa compressor stall in the right engine for an unknown reason, which resulted in a loss of power in that engine; and inadequate crew coordination between the pilot and copilot, which resulted in their failure to ensure that the external load was promptly…Aug 26, 1995 · N64AR · DestroyedNTSB FTW95LA371Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Trumann, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain available to the pilot to execute the forced landing.Aug 26, 1995 · N8783H · Substantial damageNTSB ANC95FA150Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's improper in-flight planning and decision by flying into a box canyon.Aug 26, 1995 · N1590R · Substantial damageNTSB ANC95LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe pilot's improper in-flight planning/decision, and his failure to maintain sufficient altitude to assure clearance from obstructions. The downdraft was a related factor.Aug 24, 1995 · N96911 · Substantial damageNTSB SEA95LA191Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Nyssa, ORthe pilot's inadequate ground reconnaissance.Aug 23, 1995 · N146KY · Substantial damageNTSB LAX95TA304Accident · No injuriesFinal reportDouglas C-54G · Aubeery, CAfailure of the pilot to see and avoid known obstacles along his route of flight. Contributing was the insufficient information given by the pilot in the lead aircraft.Aug 23, 1995 · N2742G · Substantial damageNTSB FTW95FA359Accident · 2 fatalField investigationFinal reportMooney M20F · Red Cliff, COImproper in-flight planning/decision by the flight crew, and their failure to maintain sufficient airspeed over mountainous terrain, which resulted in an inadvertent stall and collision with terrain. Factors relating to the accident were: high density…Aug 23, 1995 · N3768N · DestroyedNTSB FTW95LA358Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot's diverted attention, which resulted in his failure to assure that clearance was maintained from the transmission line.Aug 22, 1995 · N9190Q · DestroyedNTSB ANC95FA147Accident · 2 fatalField investigationFinal reportChampion 7ECA · Palmer, AKfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall/spin and collision with the terrain.Aug 22, 1995 · N57393 · DestroyedNTSB FTW95LA356Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Houston, TXThe flight instructor's poor judgement, and his disregard of the owner's objection to air taxi into the hangar.Aug 21, 1995 · N911BT · Substantial damageNTSB CHI95LA291Accident · 1 fatalLimited investigationFinal reportCessna 140 · Mio, MIthe pilot's impairment of judgement and performance which led to performing a low altitude maneuver with insufficient altitude for recovery. A factor was the tailwind.Aug 21, 1995 · N76429 · DestroyedNTSB ANC95FA169Accident · 1 fatalField investigationFinal reportPiper PA-18A · Anchorage, AKThe pilot's improper in-flight planning/decision and failure to maintain adequate clearance or altitude from the mountainous terrain, while maneuvering near an airstrip.Aug 21, 1995 · N7262D · DestroyedNTSB SEA95LA185Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Thompson, UTthe pilot's continued flight into instrument meteorological conditions, and his failure to maintain altitude and clearance from the mountainous terrain. Factors contributing to the accident were the fog, low ceilings, and downdraft.Aug 20, 1995 · N1930Q · Destroyed