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 FTW98LA342Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Bryce Canyon, UTA partial loss of engine power due to an oil leak in the turbocharger system. Factors were high vegetation and high density altitude.Aug 4, 1998 · N8619M · Substantial damageNTSB CHI98LA301Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · La Moure, NDa loss of engine power due to undetermined reasons.Aug 4, 1998 · N8693H · Substantial damageNTSB MIA98LA216Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Tuskegee, ALThe pilot's failure to attain adequate airspeed, and his failure to abort the takeoff.Aug 2, 1998 · N7884U · Substantial damageNTSB CHI98LA294Accident · Minor injuriesLimited investigationFinal reportPiper 20 · Andover, KSa loss of engine power for undetermined reasons. A factor associated with the accident were the trees which the airplane contacted and the low altitude at which the loss of power occurred.Aug 2, 1998 · N127X · Substantial damageNTSB MIA98LA218Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Pensacola, FLThe pilot's failure to maintain a proper sink rate during an emergency landing resulting in impact with trees and subsequent stall and impact with the terrain.Aug 1, 1998 · N7631 · Substantial damageNTSB IAD98LA087Accident · No injuriesLimited investigationFinal reportCessna 172N · Lebanon, OHThe pilot's delay in aborting the landing, which resulted in inadequate obstacle (car) clearance during initial takeoff climb. A contributing factor is the pilot's decision to perform a tailwind landing.Aug 1, 1998 · N733LK · Substantial damageNTSB CHI98FA286Accident · Minor injuriesField investigationFinal reportMonocoupe 70 · New Holstein, WIThe pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.Jul 31, 1998 · NC6740 · Substantial damageNTSB LAX98LA250Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Corona, CAThe loss of engine power due to a partially closed fuel shutoff valve as a result of improper maintenance installation.Jul 29, 1998 · N177JH · Substantial damageNTSB MIA98LA210Accident · Serious injuriesLimited investigationFinal reportProgressive Aerodyne Searey · Clermont, FLThe pilot's failure to maintain directional control and his failure to maintain obstacle (hangar)clearance.Jul 26, 1998 · N80JH · Substantial damageNTSB MIA98LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLTotal loss of engine power due to a hydraulic valve lifter failure.Jul 24, 1998 · N8258E · Substantial damageNTSB CHI98LA277Accident · Serious injuriesLimited investigationFinal reportMarchetti Avenger Gryo Plane · Mentone, INthe pilot's lack of familiarity with the gyroplane's performance, and his improper in-flight decision to reduce engine power to idle which aggravated the gyroplane's nose down pitch and exceeded the gyroplane's back stick authority.Jul 24, 1998 · N2223A · Substantial damageNTSB CHI98LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · New Lenox, ILLoss of engine power for undetermined reasons.Jul 24, 1998 · N4813D · Substantial damageNTSB MIA98FA205Accident · 2 fatalField investigationFinal reportCessna 310Q · Port Orange, FLThe pilot's inadequate weather evaluation and his continued visual flight into instrument meteorological conditions which resulted in in-flight collision with trees. A related factor was the fog.Jul 23, 1998 · N8135Q · DestroyedNTSB IAD98LA083Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Newburg, METhe pilot's failure to maintain directional control. Related factors were the long, wet, unmowed grass runway.Jul 23, 1998 · N5643V · Substantial damageNTSB CHI98LA270Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Sheboygan, WIThe pilot's inadequate fuel management which led to fuel exhaustion.Jul 23, 1998 · N7199M · Substantial damageNTSB ANC98LA108Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot's delay in aborting the takeoff prior to reaching the end of the lake. A factor associated with the accident was a downdraft.Jul 23, 1998 · N206F · Substantial damageNTSB IAD98LA082Accident · Minor injuriesLimited investigationFinal reportMiehl Team HI-MAX-1700R · Jamestown, NYthe pilot's failure to obtain proper airspeed and his subsequent loss of directional control.Jul 20, 1998 · N3546V · Substantial damageNTSB CHI98LA266Accident · No injuriesLimited investigationFinal reportCessna R182 · Bismarck, NDThe fatigue failure of the fuel system line fitting.Jul 20, 1998 · N9142C · Substantial damageNTSB NYC98LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Rockland, METhe pilot's failure to attain adequate airspeed during the takeoff, which resulted in a stall.Jul 19, 1998 · N5755F · DestroyedNTSB LAX98LA239Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of the pilot to maintain directional control of the aircraft during takeoff.Jul 19, 1998 · N2148Y · Substantial damageNTSB IAD98LA080Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Somesville, METhe pilot's inadequate planning and decision, which fail to consider the effect of takeoff in the direction of the sunlight, which resulted in the pilot encountering sunglare and the loss of aircraft control.Jul 19, 1998 · N7694E · Substantial damageNTSB FTW98FA325Accident · 1 fatalField investigationFinal reportCommander 114TC · West Jordan, UTA brittle fracture of the clamp that joins the exhaust pipe to the turbocharger. The pipe separated and hot exhaust gases escaped into the engine compartment. The engine lost power due to the high heat vaporizing fuel in the fuel line. Factors were inadequate…Jul 18, 1998 · N61174 · DestroyedNTSB CHI98LA257Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Napoleon, MIthe pilot inadequate pre-flight planning. Factors in this accident were the airplane's weight and balance limitations had been exceeded by the pilot and an improper top overhaul of the engine's cylinder by the mechanic.Jul 18, 1998 · N54R · DestroyedNTSB ANC98LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKThe loss of engine power due to carburetor icing and the pilot's improper use of the carburetor heat control. A factor associated with the accident is the rough and uneven terrain at the forced landing area.Jul 18, 1998 · N8162C · Substantial damageNTSB ANC98LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bethel, AKThe fracture of the flap handle position locking pin, which resulted in an uncommanded raising of the flaps during takeoff. A factor was the pilot's decision to takeoff with a suspected problem in the flap system.Jul 18, 1998 · N1793J · DestroyedNTSB ANC98LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Big Lake, AKThe pilot's inadequate preflight procedure of failing to ensure his seat was engaged, which resulted in the seat slipping aft during takeoff.Jul 18, 1998 · N5133H · Substantial damageNTSB MIA98LA202Accident · No injuriesLimited investigationFinal reportAir Tractor 502 · Clewiston, FLThe pilot's failure to attain adequate airspeed. A tailwind was a contributing factor.Jul 17, 1998 · N9184R · Substantial damageNTSB IAD98LA079Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · West Milford, NJLoss of engine power for undetermined reasons.Jul 15, 1998 · N60019 · Substantial damageNTSB NYC98LA143Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Bedford, PAThe pilot's inadequate preflight inspection in which he failed to secure the oil filler cap, and his misjudgment of distance and altitude from the runway.Jul 14, 1998 · N27616 · Substantial damageNTSB CHI98LA250Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Dyersville, IAthe pilot in command's not maintaining control of the airplane and his inadvertently allowing the airplane to enter a stall. A factor was the undetermined loss of engine power.Jul 14, 1998 · N5101W · Substantial damageNTSB SEA98LA121Accident · No injuriesLimited investigationFinal reportCessna 172L · Lapwai, IDThe pilot's inadequate preflight planning or preparation from unsuitable terrain. Factors include an embedded railroad tie in the takeoff path, and high vegetation..Jul 13, 1998 · N2885Q · Substantial damageNTSB SEA98LA132Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chico Hot Sprgs, MTThe pilot-in-command's selection of the wrong runway for takeoff. Factors contributing to the accident were high density altitude, rising terrain and a fence post.Jul 12, 1998 · N28299 · Substantial damageNTSB SEA98LA131Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Hailey, IDThe pilot-in-command's failure to maintain directional control during takeoff. Contributing factors were the pilot-in-command's failure to follow procedures by the improper use of the flaps, high density altitude conditions, crosswind conditions and the tree.Jul 12, 1998 · N3018A · DestroyedNTSB ANC98LA094Accident · Minor injuriesLimited investigationFinal reportMeeuwsen Wagabond · Wasilla, AKLoss of engine power for undetermined reasons.Jul 11, 1998 · N36GM · Substantial damageNTSB SEA98LA128Accident · 1 fatalLimited investigationFinal reportHughes 369D · Raymond, WAThe use of the improper long-line cable by the ground crew, and its subsequent separation from the helicopter.Jul 9, 1998 · N5063G · No damageNTSB SEA98LA125Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pasco, WASeparation of the throttle linkage which resulted in the loss of power. Factors include worn throttle linkage parts and the furrows in the plowed field which was the available field for the forced landing.Jul 9, 1998 · N4996X · Substantial damageNTSB SEA98LA124Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Eltopia, WAFatigue of the control rotor blade spar and failure of the maintenance inspector to follow the procedures set forth in the airworthiness directive.Jul 7, 1998 · N5360V · DestroyedNTSB FTW98LA303Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Beaumont, TXThe pilot's failure to maintain control of the airplane while attempting to return to the airport. Factors were the open baggage compartment door and the pilot's diverted attention to the open door.Jul 7, 1998 · N6898Y · Substantial damageNTSB FTW98LA300Accident · No injuriesLimited investigationFinal reportBeech H35 · Marshall, TXThe loss of engine power due to fuel starvation as a result of the improper position of the fuel selector. A factor was the pilot's lack of experience in this make and model of airplane.Jul 6, 1998 · N5554D · Substantial damageNTSB LAX98LA222Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Chico, CALoss of engine power for undetermined reasons.Jul 5, 1998 · N592SP · Substantial damageNTSB LAX98LA221Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS-6 · Llano, CAThe failure of the pilot to attach the aileron quick disconnect fitting during assembly of the glider and his inadequate preflight inspection.Jul 5, 1998 · N6686 · DestroyedNTSB FTW98LA301Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin II · Refugio, TXThe pilot's inadvertent ground loop. A factor was the pilot's failure to follow procedures in securing the rear canopy, which resulted in the canopy opening in flight.Jul 5, 1998 · N103GG · Substantial damageNTSB NYC98LA141Accident · Minor injuriesLimited investigationFinal reportChampion 7GCG · Neavitt, MDThe pilot's failure to maintain control of the airplane.Jul 4, 1998 · N9985Y · Substantial damageNTSB ATL98LA091Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Zellwood, FLThe loss of engine power for undetermined reasons which led to a forced landing and nose over. A factor affecting the severity of the damage was the soft terrain.Jul 4, 1998 · N42760 · Substantial damageNTSB LAX98LA220Accident · Serious injuriesLimited investigationFinal reportBushby Mustang II · Livermore, CAAn inadequate inspection of the flight control system during the condition inspection by the check pilot/mechanic.Jul 3, 1998 · N7LP · Substantial damageNTSB FTW98LA295Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Watkins, COThe pilot's inadequate evaluation of the weather which resulted in an encounter with a microburst. Contributing was the airplane's climb capability exceeded by the microburst, and rising terrain.Jul 3, 1998 · N7780U · DestroyedNTSB FTW98LA294Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe airplane's impeded climb performance for undetermined reasons. A factor was the rising terrain.Jul 3, 1998 · N1656J · Substantial damageNTSB ATL98LA090Accident · Minor injuriesLimited investigationFinal reportMbb Phoebus C · Perry, SCThe pilot's loss of control during takeoff, leading to an in-flight collision with the ground. A factor was the pilot's lack of recent experience in a high performance glider.Jul 3, 1998 · N2157 · Substantial damageNTSB SEA98LA116Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Langley, WAClearance from an object was not maintained. The pilot's lack of recent experience in the type of aircraft, improper use of carburetor heat and exceeding the gross weight of the airplane were factors.Jul 2, 1998 · N8153V · Substantial damageNTSB SEA98LA115Accident · No injuriesLimited investigationFinal reportTracy Avid Mark IV · Coeur D'Alene, IDThe pilot's failure to maintain adequate airspeed.Jul 2, 1998 · N4353D · Substantial damage