OpenAirDocs.org

NTSB investigations

211 cases where the phase of flight was Other.

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 = 800)
  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 CHI05LA186Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Plains, MOA loss of engine power for undetermined reasons during the intentional autorotation. The pilot's misjudgment of the touchdown flare leading to a hard landing was an additional cause. A contributing factor was the intentional autorotation.Jul 13, 2005 · N2756A · Substantial damageNTSB DFW05LA047Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Austin, TXThe failure of an air conditioning pack, which resulted in a haze filling the cabin. A contributing factor was the failure of the passenger to follow evacuation instructions.Dec 29, 2004 · N506MJ · No damageNTSB MIA05CA032Accident · Serious injuriesData collectionFinal reportCessna 172B · Zephyrhills, FLThe pilot's failure to set the parking brake and his improper starting procedure which resulted in an unattended aircraft running away after hand starting the engine and the airplane colliding with parked airplanes, incurring substantial damage.Nov 21, 2004 · N7493X · Substantial damageNTSB NYC04LA217Accident · 1 fatalLimited investigationFinal reportFirefly Galaxy 9 · Lewisburg, WVThe pilot's improper decision to attempt to board the balloon while it was ascending.Sep 25, 2004 · N2200Z · Minor damageNTSB CHI04FA223Accident · 1 fatalField investigationFinal reportCessna 172L · Webster, WIThe high velocity impact with terrain for undetermined reasons.Aug 12, 2004 · N3599F · DestroyedNTSB ATL04IA098Incident · No injuriesIncident investigationFinal reportCessna 208B · Tunica, MSThe pilot's improper use of the emergency power lever which resulted in excessive operating temperatures. A factor was the improper adjustment of the emergency power lever dead band.Apr 27, 2004 · N738FX · Minor damageNTSB SEA03LA180Accident · No injuriesLimited investigationFinal reportLancair LC41 · Bend, ORThe inadequate design of the drogue chute mechanical jettison system, which resulted in its failure to separate from the aircraft during in-flight spin recovery tests, and the incorrectly wired drogue chute cable cutter activation unit, which resulted in the…Aug 27, 2003 · N166PD · DestroyedNTSB MIA03LA055Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR72-212 · San Juan, PRThe aft passenger stair handrail collapsing due to undetermined reasons.Feb 8, 2003 · N448AM · No damageNTSB ATL03IA006Incident · No injuriesIncident investigationFinal reportAmerican Blimp A-60 · Valdosta, GALoss of airship control during tie down, due to gusty wind conditions.Oct 21, 2002 · N660VL · Minor damageNTSB ATL02LA125Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Concord, NCThe pilot's improper use of cyclic while attempting a hover resulting in dynamic rollover.Jun 17, 2002 · N588JR · Substantial damageNTSB CHI02FA093Accident · 1 fatalField investigationFinal reportCessna 208B · Alma, WIThe pilot not removing the ice contamination from the airplane prior to departure and the pilot intentionally flying into known severe icing conditions, resulting in the aircraft not being able to maintain altitude/clearance from the terrain. Factors to the…Mar 15, 2002 · N228PA · Substantial damageNTSB SEA02FA035Accident · Serious injuriesField investigationFinal reportRobinson R-22 Beta · Silver City, MTBoth the pilot/owner and the FAA inspector pilots' failure to maintain adequate rotor RPM during a practice auto rotation landing which resulted in a hard landing. A contributing factor was the pilot/owner's application of excessive anti-torque pedal during…Jan 31, 2002 · N7507G · Substantial damageNTSB ANC01LA109Accident · No injuriesLimited investigationFinal reportSikorsky S61A · Wrangell, AKThe separation of a steel long line cable that failed and rebounded from a load of logs into the helicopter's main and tail rotors.Aug 11, 2001 · N5193Y · Substantial damageNTSB CHI01LA239Accident · Minor injuriesLimited investigationFinal reportAnderson Revelation · Wautoma, WIThe pilot's failure to maintain airspeed, resulting in a stall. An inadequate pitch setting of the propeller is a contributing factor.Jul 21, 2001 · N6116S · Substantial damageNTSB CHI01LA222Accident · Minor injuriesLimited investigationFinal reportDruine Turbulent D-31 · Lebanon, INThe pilot not maintaining aircraft control while maneuvering during initial climb. Factors to the accident were the improperly serviced propeller that resulted in a pitch setting that was insufficient for normal flight.Jul 16, 2001 · N4697T · Substantial damageNTSB CHI01LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Huron, MIThe pilot not maintaing a proper glide path during the simulated forced landing. Factors were flight instructor's inadequate supervision and the wind gusts.Mar 16, 2001 · N6532W · Substantial damageNTSB SEA01LA046Accident · 1 fatalLimited investigationFinal reportWestern International UH-1H · Darby, MTInflight loss of a tail rotor pitch change link-to-blade grip attach bolt, resulting partial loss of tail rotor control, and subsequent entanglement of the helicopter's external load cable with a tree during emergency descent. Factors included the pilot's…Feb 7, 2001 · N205GL · Substantial damageNTSB ANC00LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Slana, AKThe pilot's inadvertent touch down. A factor associated with the accident was deep snow on the airstrip.Sep 29, 2000 · N5489H · Substantial damageNTSB SEA00TA149Accident · No injuriesFinal reportShort SD3-30 200 · Elk City, IDEntanglement of air-dropped cargo parachute with the aircraft's horizontal stabilizer, resulting in damage to the horizontal stabilizer.Jul 31, 2000 · N179Z · Substantial damageNTSB MIA00LA010Accident · No injuriesLimited investigationFinal reportCessna 150M · Bunnell, FLThe erosion and separation of the aft end plate P/N 0450338-18 of the right muffler resulting in exhaust gas contact to electrical wires in the engine compartment. Also, unsuitable terrain encountered by the pilot during the forced landing. A finding in the…Oct 18, 1999 · N3240V · Substantial damageNTSB MIA99LA185Accident · No injuriesLimited investigationFinal reportBeech E-35 · Yankeetown, FLThe failure of maintenance personnel to balance check the ruddervators after painting the airplane and unclear information contained in the compliance section of AD 94-20-04 resulting in the failure of maintenance personnel to balance check the out-of-balance…Jun 5, 1999 · N3508B · Substantial damageNTSB DCA99IA058Incident · No injuriesIncident investigationFinal reportAirbus Industrie 300-600 · Miami, FLUncommanded rudder movement caused by a contaminant in the engagement valve solenoid that prevented disengagement of the autopilot yaw actuator and cross-connected wiring of the autopilot yaw actuator's main valve solenoids by the operator. Factors…May 11, 1999 · N7082A · No damageNTSB IAD98FA086Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Stevensville, MDThe pilot-in-command's failure to maintain aircraft control while buzzing a building.Aug 2, 1998 · N550C · DestroyedNTSB FTW98LA353Accident · No injuriesLimited investigationFinal reportde Havilland DH-8-202 · Telluride, COThe inadequate chocks and inadequate chocking procedures by the operator. Factors were the unavailability of the parking brake and sloping terrain.Jul 27, 1998 · N449YV · Substantial damageNTSB MIA98FA196Accident · 1 fatalField investigationFinal reportCessna 150E · Panama City Bch, FLThe failure of the pilot to maintain airspeed (Vs) and the inadvertent stall by the pilot. Contributing to the accident was the intentional operation of the airplane by the pilot in an over gross weight condition resulting in a higher stall speed, and failure…Jul 15, 1998 · N3549J · Substantial damageNTSB SEA98LA085Accident · 1 fatalLimited investigationFinal reportPiper PA-30 · Everett, WAThe pilot-in-command's exiting the aircraft with both engines running to remove a wheel chock. A factor was the inadequate preflight of the aircraft (not removing the chock) prior to engine start.Jun 4, 1998 · N98NT · Minor damageNTSB MIA98FA039Accident · 1 fatalField investigationFinal reportChristen Industries A-1 · Lansing, NCthe pilot's failure to maintain clearance from a wire.Dec 2, 1997 · N9613P · DestroyedNTSB ATL97LA137Accident · 1 fatalLimited investigationFinal reportJohn W. Culp KR-2 · Greenwood, SCThe collision with the ground for undetermined reasons.Sep 21, 1997 · N9097E · DestroyedNTSB MIA97FA142Accident · 2 fatalField investigationFinal reportBoeing Stearman N2S-4 · Apex, NCThe pilot-in-command's ostentatious display by performing an aerobatic maneuver with inadequate altitude.Apr 20, 1997 · N61S · Substantial damageNTSB LAX97LA061Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600N · Flagstaff, AZThe pilot's inattention to the altitude and inadvertent late entry into an autorotation maneuver below the established minimum test altitude with a helicopter operating at maximum gross weight in a high density altitude environment that led to a subsequent…Nov 21, 1996 · N630N · Substantial damageNTSB CHI96FA211Accident · 1 fatalField investigationFinal reportMcDonnell Douglas F/A-18C · Bethalto, ILthe pilot's failure to follow the preflight crew briefing and attain a proper altitude during an aerobatic maneuver. Factors in the accident were: the pilot's previous experience of flying similar airshow routines in a different airplane with substantially…Jun 19, 1996 · N16518 · DestroyedNTSB MIA96LA175Accident · 1 fatalLimited investigationFinal reportPiper PA-60-601P · Atlantic Ocean (Atlantic Ocean)pilot incapacitation.Feb 17, 1996 · N956AF · DestroyedNTSB ANC96LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKImproper planning/decision by the pilot concerning his method of testing the landing area. His selection of an unsuitable area was a related factor.Oct 7, 1995 · N4463Z · Substantial damageNTSB CHI95LA325Accident · No injuriesLimited investigationFinal reportBede BD12 · Chesterfield, MOThe airplane's inadequate handling characteristics which resulted in the inability to control pitch attitude during landing.Sep 14, 1995 · N112BD · Substantial damageNTSB FTW95LA167Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · San Antonio, TXThe pilot-in-command's failure to set the parking brake.Apr 11, 1995 · N683A · No damageNTSB CHI94LA016Accident · No injuriesLimited investigationFinal reportCessna 150J · Grosse Ile, MIThe pilot misjudged altitude/clearance during the banner pickup, which resulted in the tow rope snagging the landing gear, and failed to maintain adequate airspeed, while landing with the banner attached, which resulted in a failure (or inability) to attain a…Oct 3, 1993 · N5522G · Substantial damageNTSB SEA93LA169Accident · No injuriesLimited investigationFinal reportHadaller Murphy Renegade · Guernsey, WYImproper planning/decision by the pilot. Factors related to the accident were: rising/mountainous terrain, high density altitude, the lack of climb performance information available to the pilot, and rough/uneven terrain in the emergency landing area.Aug 1, 1993 · N95HH · Substantial damageNTSB ATL93MA055Accident · 7 fatalMajor investigationFinal reportLockheed L382E-44K-20 · Marietta, GADisengagement of the rudder fly-by-wire flight control system resulting in a total loss of rudder control capability while conducting ground minimum control speed tests. The disengagement was a result of the inadequate design of the rudder's integrated…Feb 3, 1993 · N130X · DestroyedNTSB CHI93FA029Accident · 2 fatalField investigationFinal reportCessna 150L · Elwood, ILThe pilot-in-command's failure to maintain a proper adequate altitude to avoid obstructions. Factors contributing to the accident was the pilot's impairment of efficiency and judgement due to alcohol, and the dark night condition.Nov 13, 1992 · N11199 · DestroyedNTSB NYC93LA008Accident · No injuriesLimited investigationFinal reportCessna 152 II · Milford, NHThe instructor pilots improper in-flight planning, and his failure to maintain a proper glide path to the forced landing area. A factor in this accident was the instructor's decision to shut down the engine during a 'simulated' engine failure .Oct 5, 1992 · N301DW · Substantial damageNTSB NYC92LA162Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ocean City, NJThe airplane nosing over on landing roll due to inadequate airplane handling characteristics while landing with the banner attached. Factors related to the accident were the use of rope instead of steel cable, the main landing gear mounted tow hitch, and the…Aug 12, 1992 · N9374D · Substantial damageNTSB LAX92GA347Accident · 1 fatalFinal reportHughes 369D · Maxwell, CAThe failure of the pilot to maintain an adequate visual outlook, and failure of the company to provide adequate training. Contributing to the accident was: inadequate company supervision during the operation, and inadequate surveillance by the FAA which…Aug 12, 1992 · N58425 · DestroyedNTSB MIA92LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · St. Augustine, FLThe pilot-in-command's failure to maintain airspeed while buzzing which resulted in the aircraft stalling and entering a spin.Apr 22, 1992 · N13910 · DestroyedNTSB SEA92LA074Accident · 1 fatalLimited investigationFinal reportMoore Sonerai 1 · Harrisburg, ORThe pilot's failure to maintain an altitude sufficient to avoid colliding with terrain while performing acrobatic maneuvers as a result of his alcoholic impairment of efficiency and judgement. Factors contributing to the accident were: the pilots disregard of…Apr 11, 1992 · N27127 · DestroyedNTSB ATL92LA067Accident · 1 fatalLimited investigationFinal reportCessna 182 · Barnwell, SCThe pilot's failure to maintain a safe altitude above the ground while making a low pass at night.Mar 22, 1992 · N5441B · Minor damageNTSB DEN91DTE02Accident · 1 fatalFinal reportCresawn Pitts S1-C · Calhan, COThe pilot's failure to attain adequate aircraft control to avoid terrain collision.Sep 3, 1991 · N939PC · Substantial damageNTSB CHI91DCD02Accident · 1 fatalFinal reportCanadian Car & Foundry Harvard Mark IV · Ida Grove, IAThe pilot's failure to maintain airspeed.Aug 11, 1991 · N15795 · DestroyedNTSB DEN91FA110Accident · 1 fatalField investigationFinal reportCessna 177 · Hygiene, COSuicide. A factor related to the accident was: the pilot's other psychological condition.Aug 6, 1991 · N3185T · DestroyedNTSB BFO91FA060Accident · 1 fatalField investigationFinal reportPiper J5 · Berlin, MDThe pilot's failure to maintain adeqate airspeed which caused the airplane to stall.Jun 29, 1991 · N763WM · DestroyedNTSB FTW91LA119Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-6 · Boerne, TXThe pilot's failure to release at a higher altitude prior to looking for thermal activity and the pilot's poor in-flight planning. Factors were the downdraft and the tall grass encountered during landing.Jun 22, 1991 · N6MN · Substantial damage