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 ATL02LA131Accident · No injuriesLimited investigationFinal reportBeech 18 · Venice, FLThe pilot's improper use of flight controls during takeoff, that resulted in the loss of control during takeoff.Jun 26, 2002 · N1002C · DestroyedNTSB LAX02GA209Accident · Serious injuriesFinal reportMcDonnell Douglas 369E · Ontario, CAThe mechanic's improper maintenance procedures (FOD prevention) during a 100-hour inspection, which resulted in foreign object damage (FOD) to the compressor section and catastrophic engine failure. Factors were the presence of vehicles and power lines…Jun 25, 2002 · N40NT · DestroyedNTSB FTW02LA189Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Farmington, NMThe failure of the nose landing gear plunger assembly due to fatigue.Jun 23, 2002 · N8245H · Substantial damageNTSB IAD02LA062Accident · Minor injuriesLimited investigationFinal reportCastle Glasair II-SRG · Mill Hall, PAThe failure of the crankshaft due to a lack of lubrication.Jun 22, 2002 · N676EC · Substantial damageNTSB NYC02LA124Accident · No injuriesLimited investigationFinal reportHunter A-28 Victor · Shelter Island, NYThe pilot's failure to maintain directional control during the takeoff, which resulted in a collision with trees.Jun 20, 2002 · N61450 · Substantial damageNTSB LAX02LA204Accident · No injuriesLimited investigationFinal reportBeech V35A · Cottonwood, AZThe loss of engine power as a result of the failure of the #1 lower connecting rod bolt due to fatigue.Jun 20, 2002 · N8327N · Substantial damageNTSB MIA02FA113Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Naples, FLThe pilot's failure to maintain airspeed above the stall speed while maneuvering to land after the engine ceased operating for undetermined reasons, which resulted in a stall/spin, an uncontrolled descent, and an impact with the ground.Jun 19, 2002 · N9127L · DestroyedNTSB SEA02LA103Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Heyburn, IDA blocked fuel line due to a gasket that had disintegrated and blocked the fuel line.Jun 16, 2002 · N8849K · Substantial damageNTSB LAX02FA198Accident · Serious injuriesField investigationFinal reportCessna 182Q · Deer Valley, AZa loss of engine power for undetermined reasons during the takeoff initial climb, and, the pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway, which resulted in a stall.Jun 15, 2002 · N33PA · Substantial damageNTSB FTW02LA182Accident · No injuriesLimited investigationFinal reportCessna R172K · Llano, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion and a forced landing.Jun 15, 2002 · N758W · Substantial damageNTSB NYC02LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Gettysburg, PAThe pilot's failure to accurately compute takeoff performance and his failure to establish a positive climb resulting in a collision with trees.Jun 11, 2002 · N9357N · Substantial damageNTSB CHI02LA159Accident · 1 fatalLimited investigationFinal reportGalbraith Piel Emeraude · Hot Springs, SDThe loss of engine power due to the connecting rod fatigue failure during takeoff climb.Jun 11, 2002 · N71PE · Substantial damageNTSB CHI02LA158Accident · No injuriesLimited investigationFinal reportBeech B35 · Lakewood, WIThe pilot's failure to maintain control of the aircraft during takeoff when he encountered a stall after failing to maintain airspeed.Jun 10, 2002 · N352GF · Substantial damageNTSB LAX02LA190Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fallon, NVthe pilot's failure to attain an adequate takeoff airspeed, which resulted in a stall/mush. The high gross weight and density altitude were contributing factors.Jun 9, 2002 · N8249R · Substantial damageNTSB FTW02LA179Accident · No injuriesLimited investigationFinal reportSchweizer 269D · Crawford, TXThe loss of engine power as a result of the pilot's exceedence of the engine's temperature limits, resulting in the melting of blades on the first and second stage turbine wheels. A contributing factor was the lack of suitable terrain for the forced landing.Jun 9, 2002 · N333UC · Substantial damageNTSB CHI02LA160Accident · Minor injuriesLimited investigationFinal reportNavion Navion A · Forest Lake, MNThe pilot not performing an aborted takeoff. The soft turf runway and power lines were contributing factors.Jun 9, 2002 · N8717H · DestroyedNTSB NYC02LA099Accident · No injuriesLimited investigationFinal reportBoucher Revolution Mini 500 · Sterling, MAA misalignment of the rotor system drive belt, which resulted in belt chaffing, its subsequent separation, and a resultant loss of power to the rotor system. Also causal was the relatively low altitude and airspeed at which the separation occurred, which…Jun 8, 2002 · N54VP · DestroyedNTSB LAX02LA192Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Goldfield, NVThe pilot's failure to maintain control of the airplane during a high density altitude takeoff. Contributing factors were the pilot's lack of experience in the type of operation and a wind gust.Jun 8, 2002 · N480DW · Substantial damageNTSB FTW02LA173Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Provo, UTthe total loss of engine power for reasons undetermined.Jun 8, 2002 · N146P · Substantial damageNTSB FTW02LA174Accident · No injuriesLimited investigationFinal reportCessna 150 · Fort Worth, TXthe partial loss of engine power due to the mixture control rod separating from the carburetor. A contributing factor was the lack of suitable terrain for the forced landing.Jun 7, 2002 · N6249R · Substantial damageNTSB MIA02LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe flight instructor's inadequate supervision of the dual student and failure to take prompt remedial action, resulting in a collision with a tree, a subsequent loss of control, and collision with the ground.Jun 4, 2002 · N63591 · Substantial damageNTSB IAD02LA056Accident · No injuriesLimited investigationFinal reportCessna 177RG · Trenton, NJThe separation of the engine induction alternate air door, which resulted in a loss of engine power. A factor was the non-compliance with the manufacturer's service letter.May 31, 2002 · N8200G · Substantial damageNTSB FTW02LA168Accident · No injuriesLimited investigationFinal reportErcoupe ERCO-415-E · Conway, ARThe loss of engine power for undetermined reasons. Factors were the pilots necessity to avoid a power line during the emergency descent and the lack of suitable terrain for the forced landing.May 31, 2002 · N94769 · Substantial damageNTSB SEA02LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Carey, IDThe pilot's failure to maintain clearance from trees during takeoff.May 30, 2002 · N7225A · Substantial damageNTSB DEN02LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Rock Springs, WYthe pilot's failure to maintain aircraft control during initial takeoff climb. A contributing factor was the gusty crosswind.May 30, 2002 · N4559C · Substantial damageNTSB ANC02FA038Accident · 2 fatalField investigationFinal reportPiper PA-18 · Lime Village, AKThe pilot's inadequate evaluation of weather and his inability to maintain aircraft control. A contributing factor was high winds due to thunderstorm outflow activity.May 27, 2002 · N4347Z · DestroyedNTSB MIA02LA099Accident · Minor injuriesLimited investigationFinal reportPiper J-3F-65 · Eton, GAThe pilot's failure to maintain directional control during initial climb after takeoff, resulting in collision with a power pole. A factor in the accident was the flight's encounter with a downdraft condition during initial climb.May 26, 2002 · N33204 · Substantial damageNTSB LAX02LA176Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Aganasabotage to the helicopter's fuel system, which resulted in a loss of engine power and a forced landing.May 26, 2002 · N500LA · Substantial damageNTSB CHI02LA143Accident · Minor injuriesLimited investigationFinal reportRose 75% Scale Fokker D8 · Derby, KSInadequate preflight planning and inadequate compensation for the wind conditions which resulted in a failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the trees which the airplane contacted…May 25, 2002 · N2188X · Substantial damageNTSB ANC02LA039Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate evaluation of weather conditions, which precipitated an in-flight loss of control and subsequent collision with terrain. A factor contributing to the accident was the tailwind.May 25, 2002 · N80994 · Substantial damageNTSB FTW02LA161Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Aubrey, ARThe failure of a compressor turbine blade(s) for an undetermined reason.May 24, 2002 · N4025Y · Substantial damageNTSB ATL02LA105Accident · No injuriesLimited investigationFinal reportStearman A75N1 · Panacea, FLLoss of engine power due to fuel starvation resulting from fuel restriction through the fuel shutoff valve.May 24, 2002 · N5545F · Substantial damageNTSB ATL02LA106Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hernando, MSThe pilot's failure to maintain wing tip clearance during an attempted takeoff that resulted in the collision with the ground.May 23, 2002 · N2925B · Substantial damageNTSB CHI02LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Lake in Hills, ILIt was not possible for the pilot to land the airplane at a proper touchdown point during the aborted takeoff and unsuitable terrain was encountered off the end of the runway. Factors associated with the accident were a proper climb rate was not achieved…May 19, 2002 · N210AB · Substantial damageNTSB SEA02FA083Accident · Serious injuriesField investigationFinal reportGrumman G-44 · Boise, IDA blocked fuel line that resulted in fuel starvation to the engine and the pilot's failure to follow emergency procedures. A contamination of metal flakes on the fuel filter, and an inadequate annual inspection were factors.May 16, 2002 · N700BL · Substantial damageNTSB ATL02LA100Accident · 2 fatalLimited investigationFinal reportTaber Lancair Super ES · Hattiesburg, MSThe pilot's failure to maintain airspeed during takeoff which resulted in an inadvertent stall and subsequent collision with the ground.May 16, 2002 · N600MT · DestroyedNTSB FTW02LA150Accident · Serious injuriesLimited investigationFinal reportAubrey Challenger II · Lubbock, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.May 12, 2002 · N2NX · Substantial damageNTSB LAX02LA152Accident · No injuriesLimited investigationFinal reportCessna 182P · Boulder City, NVthe pilot's failure to lean the mixture properly resulting in a partial loss of power.May 7, 2002 · N425Q · Substantial damageNTSB NYC02LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Middleville, NYThe pilot's failure to maintain proper alignment with the runway after being struck by a gust of wind. Factors were the gusty winds and the berm struck by the airplane.May 4, 2002 · N4151F · Substantial damageNTSB FTW02LA139Accident · Minor injuriesLimited investigationFinal reportBoeing A75SN1 · Georgetown, TXThe pilot's inadequate planning/decision resulting in the wake turbulence encounter during the takeoff/initial climb of the formation flight. A contributing factor was the partial loss of engine power for an undetermined reason.May 4, 2002 · N5805V · Substantial damageNTSB FTW02LA128Accident · No injuriesLimited investigationFinal reportCessna 172RG · Alamogordo, NMthe loss of engine power for an undetermined reason, which resulted in a forced landing after takeoff.Apr 24, 2002 · N6288R · Substantial damageNTSB IAD02LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Louisville, KYThe pilot's inadvertent selection of an empty fuel tank, which resulted in fuel starvation of the engine.Apr 23, 2002 · N166PA · Substantial damageNTSB CHI02FA113Accident · 1 fatalField investigationFinal reportCessna 172RG · Marthasville, MOThe inadequate supervision and the stall encountered by the certified flight instructor.Apr 23, 2002 · N5388R · DestroyedNTSB SEA02LA072Accident · 1 fatalLimited investigationFinal reportGallagher Taylor "Coot" · Creswell, ORA loss of engine power due to oil starvation followed by the pilot's failure to maintain aircraft control during the initial climb shortly after takeoff. An improper engine modification was a factor.Apr 21, 2002 · N41RG · DestroyedNTSB CHI02LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Valparaiso, INThe pilot not maintaining aircraft control while encountering windshear during initial climbout, resulting in a stall at a low altitude.Apr 19, 2002 · N3034A · Substantial damageNTSB FTW02LA120Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Lamesa, TXThe loss of engine power due to contamination of the fuel system. A contributing factor was the lack of suitable terrain for the forced landing.Apr 15, 2002 · N91905 · Substantial damageNTSB ATL02LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pahokee, FLThe loss of engine power and the post-landing fire for undetermined reasons.Apr 11, 2002 · N30660 · DestroyedNTSB ANC02FA028Accident · 1 fatalField investigationFinal reportBeech E18S · Juneau, AKThe pilot's excessive loading of the airplane that precipitated an inadvertent stall/mush during the initial climb.Apr 11, 2002 · N686Q · DestroyedNTSB SEA02LA065Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Rockford, WAThe pilot's inadequate pre-flight planning/decision to continue the takeoff. Contributing to the accident was the wind gusts.Apr 8, 2002 · N81705 · Substantial damageNTSB MIA02LA080Accident · 1 fatalLimited investigationFinal reportGary L. Zeigler Monnett Moni · Sevierville, TNThe failure of the pilot to maintain airspeed while turning to reverse direction resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with trees. A factor in the accident was the failure of the pilot to tighten the spark plugs…Apr 6, 2002 · N10GZ · Substantial damage