OpenAirDocs.org

NTSB investigations

20,559 cases where the phase of flight was Initial climb.

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 = 350)
  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 BFO92LA070Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Morrisville, VTThe pilot's failure to maintain clearance with the terrain. Contributing to the accident was a dark night and the lack of familiarity with the geographic area.May 21, 1992 · N2950K · DestroyedNTSB LAX92FA211Accident · 2 fatalField investigationFinal reportTaylorcraft BL · Chandler, AZAn excessive pull-up during departure and a failure of the pilot to maintain adequate airspeed, resulting in an inadvertent stall/spin. Contributing to the accident was continued flight operations with known airworthiness deficiencies.May 19, 1992 · N26535 · Substantial damageNTSB CHI92DEC01Accident · No injuriesFinal reportCessna 188A · Imlay City, MIThe pilot induced premature liftoff which resulted in inadequate airspeed and the resulting stall.May 19, 1992 · N9946G · DestroyedNTSB ATL92FA102Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Greenville, NCFailure of the pilot to maintain a proper climb rate after takeoff after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, the pilot's self-induced pressure to make the flight, and his lack of total…May 15, 1992 · N2259T · DestroyedNTSB FTW92LA132Accident · No injuriesLimited investigationFinal reportSchweizer G-164D · Welsh, LAThe engine failure at liftoff due to the failure of multiple turbine blades and the pilot's inability to maintain directional control during the aborted takeoff.May 14, 1992 · N8331K · Substantial damageNTSB SEA92LA096Accident · No injuriesLimited investigationFinal reportRobert Griffiths Kitfox MOD II · Burlington, WAThe pilot's overconfidence in his ability, and his overconfidence in the ability of the aircraft. Factors include high/gusty winds, and a fence near the runway.May 12, 1992 · N7183H · Substantial damageNTSB BFO92LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172XP · Milton, DEThe pilot's failure to attain adequate airspeed for climb.May 11, 1992 · N4695K · Substantial damageNTSB CHI92LA143Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Ionia, MIThe pilot-in-command's improper preflight and decision to close the glider's canopy at low altitude.May 10, 1992 · N140BG · Substantial damageNTSB CHI92FA142Accident · 2 fatalField investigationFinal reportTaylorcraft F19 · Harvard, ILThe pilot's failure to maintain control of the aircraft during the initial climb out. A related factor is the pilot's lack of recent experience.May 10, 1992 · N3688T · DestroyedNTSB BFO92FA058Accident · 3 fatalField investigationFinal reportCessna 177 · Lusby, MDA failure of the carburetor resulting in a loss of engine power.May 10, 1992 · N177RD · DestroyedNTSB ATL92LA098Accident · Minor injuriesLimited investigationFinal reportAvid Flyer Heavy Hauler · Wendell, NCThe improper installation of the forward spark plug by the owner/pilot, which resulted in a loss of engine power. A factor was the lack of suitable terrain for a forced landing.May 10, 1992 · N613AB · Substantial damageNTSB LAX92LA208Accident · No injuriesLimited investigationFinal reportCorbus/Winters BD-5B · Fresno, CAThe total loss of engine power during initial climb due to a fracture and failure of the engine starter ring gear. A contributing factor which was related to the mechanical failure was the airplane owner's inadequate maintenance.May 9, 1992 · N811Q · Substantial damageNTSB LAX92LA200Accident · No injuriesLimited investigationFinal reportPiper PA23-150 · Modesto, CAAn engine power loss due to fuel contamination.May 5, 1992 · N2310B · Substantial damageNTSB MIA92FA121Accident · 3 fatalField investigationFinal reportCessna 310Q · Odessa, FLLoss of engine power on initial takeoff climb on all engines for undetermined reasons. This resulted in a forced landing, in flight collision with trees, terrain, and postcrash fire.May 3, 1992 · N300DG · DestroyedNTSB BFO92LA052Accident · Serious injuriesLimited investigationFinal reportBeech 24 · Millis, MAThe pilot's failure to attain adequate flying speed during takeoff climb which resulted in a stall and inflight collision with the terrain. Contributing was a downwind takeoff.May 3, 1992 · N2061L · Substantial damageNTSB ATL92LA092Accident · No injuriesLimited investigationFinal reportCessna 172E · Concord, NCThe loss of engine power because of the formation of carburetor ice.May 1, 1992 · N5529T · Substantial damageNTSB CHI92LA140Accident · No injuriesLimited investigationFinal reportBell BH47G · Bucklin, MOThe helicopter pilot's abrupt touchdown during the forced landing. Related factors were the presence of carburetor ice conditions, and the pilot's improper use of carburetor heat.Apr 28, 1992 · N90642 · Substantial damageNTSB CHI92LA136Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Grain Valley, MOA stall following a downwind takeoff.Apr 28, 1992 · N77205 · Substantial damageNTSB CHI92LA133Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Washington, MOThe pilot in command's improper use of the carburetor heat control.Apr 26, 1992 · N59528 · Substantial damageNTSB MIA92FA115Accident · No injuriesField investigationFinal reportBoeing 707-324C · Miami, FLFailure of the #3 engine pylon inboard midspar support fitting due to fatigue cracking which resulted in the separation of the number three engine and pylon. Contributing to the accident was the inadequate inspection requirements of the manufacturer and the…Apr 25, 1992 · HK360 · Substantial damageNTSB LAX92FA185Accident · 2 fatalField investigationFinal reportBeech S35 · Long Beach, CAThe pilot's failure to maintain an airspeed above the airplane's stall speed (vs) and inadvertent entry into a spin. The engine failure resulting from contaminated fuel and inadequate preflights were factors in the accident.Apr 24, 1992 · N123JH · DestroyedNTSB LAX92MA183Accident · 16 fatalMajor investigationFinal reportde Havilland DHC-6-200 · Perris, CAThe pilot-in-command's inadvertent feathering of the wrong propeller following an engine power loss, and the failure of the operator to assure that the pilot was provided with adequate training in the airplane. Factors related to the accident were: water…Apr 22, 1992 · N141PV · DestroyedNTSB ATL92LA086Accident · 1 fatalLimited investigationFinal reportGlaser-Dirks DG-600/18M · Newnan, GAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall at too low of an altitude to effect recovery.Apr 22, 1992 · N107T · Substantial damageNTSB LAX92LA182Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Oxnard, CAThe pilot's failure to maintain control of the airplane during takeoff as a result of his alcoholic impairment of efficiency and judgement. A factor in the accident was the dark night.Apr 21, 1992 · N6907D · Substantial damageNTSB ATL92LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Monroe, NCThe pilot's failure to maintain flying speed during climbout which resulted in a stall and subsequent collision with the ground. A factor was reported downdrafts.Apr 19, 1992 · N4978P · Substantial damageNTSB CHI92DEM01Accident · No injuriesFinal reportRose Wesley Rotorway WR Exec · Hudsonville, MIThe failure of an intake valve spring. Factors related to the accident were the low altitude at which the autorotation was initiated and the soft terrain on which the helicopter was landed.Apr 18, 1992 · N6617L · Substantial damageNTSB MIA92FA110Accident · 1 fatalField investigationFinal reportCessna 152 · Bushnell, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an inadvertent stall, in flight loss of control, and collision with terrain. Contributing to the accident was the pilot-in-command's failure…Apr 16, 1992 · N47343 · DestroyedNTSB FTW92LA116Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Welsh, LAPartial power loss due to the cracked engine cylinder. A factor was the lack of suitable terrain for the forced landing.Apr 14, 1992 · N9546 · Substantial damageNTSB CHI92LA129Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Iron Mountain, MIThe presence of water in the air induction system.Apr 14, 1992 · N51782 · Substantial damageNTSB SEA92LA219Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Rockford, WAImproper use of rudder trim and poor preflight planning/preparation. Factors to the accident were: directional control was not maintained and lack of familiarity with aircraft.Apr 13, 1992 · N41891 · Substantial damageNTSB CHI92LA128Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Lee'S Summit, MOA delayed aborted takeoff by the pilot in command. A factor in the accident is the presence of carburetor icing conditions.Apr 12, 1992 · N2032L · Substantial damageNTSB CHI92LA126Accident · Serious injuriesLimited investigationFinal reportCessna 170B · St. James, MOThe pilot's failure to maintain clearance from terrain during the attempted takeoff and climb out. A related factor was the rising terrain.Apr 11, 1992 · N1966C · Substantial damageNTSB MIA92LA106Accident · No injuriesLimited investigationFinal reportTomlinson Long EZ · Lakeland, FLThe pilot-in-command's failure to perform pretakeoff procedures and assure the fuel selector was on prior to takeoff. Contributing to the accident was the pilot's complacency.Apr 7, 1992 · N83BT · Substantial damageNTSB NYC92FA073Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paris, OHThe failure of the pilot to maintain directional control which resulted in the airplane flying over higher terrain with a climb rate that was insufficient to clear the obstacles. Factors related to the accident were the pilot's lack of total experience and…Apr 5, 1992 · N9741W · Substantial damageNTSB LAX92LA167Accident · 1 fatalLimited investigationFinal reportBede BD-5 · Compton, CA1) A total loss of engine power for undetermined reasons, 2) the pilot's failure to maintain an adequate airspeed, and 3) the inadvertent entry into a stall spin. Factors in this accident were: 1) the pilot's lack of familiarity with the airplane, and 2) the…Apr 4, 1992 · N3DW · DestroyedNTSB ANC92LA057Accident · No injuriesLimited investigationFinal reportCessna U206G · Kotzebue, AKThe pilot's failure to remove all the frost from the airplane and exceeding the gross weight limit of the airplane.Apr 2, 1992 · N9909Z · Substantial damageNTSB FTW92LA088Accident · No injuriesLimited investigationFinal reportCessna 172B · Scottsville, TXPilots' inadequate compensation for unfavorable windshift. A facator was the unfavorable wind.Apr 1, 1992 · N7492X · Substantial damageNTSB FTW92FA099Accident · 1 fatalField investigationFinal reportRockwell 690A · Taos, NMThe pilot in command's failure to maintain the climb after departing the runway environment. Factors were the weather conditions and the dark night.Mar 30, 1992 · N111FL · DestroyedNTSB ATL92LA071Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Cumberland Is., GAThe loss of the spark plug at a critical point in flight which resulted from the inadequate overhaul of the engine by an unknown person; and the inadvertent stall of the airplane when the pilot failed to maintain airspeed. A factor was the high obstructions…Mar 28, 1992 · N1975Y · Substantial damageNTSB ANC92LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Sleetmute, AKThe airplane stalled when the pilot failed to maintain flying speed.Mar 24, 1992 · N84547 · Substantial damageNTSB DCA92MA025Accident · 27 fatalClass 1 · MajorFinal reportFokker 28-4000 · Flushing, NYThe failure of the airline industry and the federal aviation administration to provide flightcrews with procedures, requirements, and criteria compatible with departure delays in conditions conducive to airframe icing and the decision by the flightcrew to…Mar 23, 1992 · N485US · DestroyedNTSB FTW92LA094Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe loss of engine power due to rocker arm failure. A factor was the unsuitable terrain.Mar 18, 1992 · N5378 · Substantial damageNTSB MIA92FA099Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Aberdeen, MSThe pilot-in-command's decision to initiate a turn back to the airport at a low altitude following loss of engine power.Mar 16, 1992 · N16388 · DestroyedNTSB ATL92LA068Accident · 1 fatalLimited investigationFinal reportMaxair 582 · Willacoochee, GAThe pilot's failure to maintain flying speed which resulted in a loss of flight control, and an inadvertent stall.Mar 16, 1992 · UNREG · Substantial damageNTSB ATL92LA064Accident · No injuriesLimited investigationFinal reportKolb Mark III · Titus, ALThe manufacturer's failure to install the main fuel line properly which resulted in fuel starvation and a loss of engine power.Mar 16, 1992 · N101AB · Substantial damageNTSB LAX92LA142Accident · No injuriesLimited investigationFinal reportCessna A188B · Corcoran, CAThe aircraft's encounter during the takeoff with a crosswind gust beyond the capability of the aircraft.Mar 14, 1992 · N53241 · DestroyedNTSB MIA92LA095Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Deland, FLFailure of the pilot-in-command to maintain the proper airspeed (vs) resulting in an inadvertent stall. Factors in the accident were incorrect fuel selector position resulting in the total loss of engine power due to fuel starvation and fatigue of the pilot.Mar 10, 1992 · N6418A · Substantial damageNTSB CHI92LA102Accident · No injuriesLimited investigationFinal reportStinson 108 · Heyworth, ILImproper use of the carburetor heat control which resulted in carburetor ice and subsequent loss of power. A factor related to the accident was the carburetor icing conditions which existed at the time of the accident.Mar 3, 1992 · N97599 · Substantial damageNTSB ATL92FA053Accident · 2 fatalField investigationFinal reportCessna 172P · N Topsail Beach, NCThe failure of the pilot to obtain and/or maintain adequate airspeed during takeoff, which resulted in an inadvertent stall and collision with the ground. Factors were: the failure of the pilot to follow procedures/directives, his operation of the aircraft…Mar 2, 1992 · N65988 · Substantial damageNTSB MIA92LA180Accident · Serious injuriesLimited investigationFinal reportD.W. Owens Stitts SA3B · Winter Haven, FLFuel contamination and unsuitable terrain encountered while the pilot was attempting an emergency landing on the airport property.Mar 1, 1992 · UNREG · Substantial damage