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 ANC06LA087Accident · Minor injuriesLimited investigationFinal reportKennedy Chinook Plus 2 · Willow, AKThe pilot's failure to maintain sufficient airspeed to avoid an aerodynamic stall during takeoff/initial climb, which resulted in an uncontrolled descent and collision with trees. A factor associated with the accident was an inadvertent stall.Jul 2, 2006 · N9077M · Substantial damageNTSB ATL06LA099Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Ringgold, GAThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation resulting in a forced landing, and collision with trees and the ground.Jul 1, 2006 · N8084L · Substantial damageNTSB NYC06FA162Accident · 2 fatalField investigationFinal reportCessna 310D · Sutton, WVThe pilot's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/mush. A factor associated with the accident was the inadvertent stall/mush.Jun 30, 2006 · N6867T · DestroyedNTSB NYC06CA164Accident · Serious injuriesData collectionFinal reportBaker, Timithy Falco F8L · Montgomery, NYThe pilot's inadequate pre-flight inspection, which resulted in a loss of engine power due to fuel contamination.Jun 30, 2006 · N4TB · Substantial damageNTSB DEN06LA094Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Sheridan, WYthe partial loss of engine power for undetermined reasons. Contributing factors were the dirt embankment and fence.Jun 30, 2006 · N153M · Substantial damageNTSB DFW06IA171Incident · No injuriesIncident investigationFinal reportMooney M20J · Beaumont, TXThe improper installation of the propeller governor by maintenance personnel, which resulted in a partial loss of engine power and subsequent forced landing. A contributing factor was the lack of suitable terrain for the forced landing.Jun 29, 2006 · N5662M · Minor damageNTSB SEA06LA130Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Snohomish, WAThe loss of engine power for undertermined reasons. Conditions for carburetor icing were present at the time of the accident. Factors included the fence and the berm.Jun 28, 2006 · N243K · Substantial damageNTSB MIA06FA120Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Fort Pierce, FLthe pilot’s loss of aircraft control during the initial climb which was precipitated by the sudden loss of thrust and increase in drag from the right engine, and the pilot’s failure to adhere to the published emergency procedures regarding the position of the…Jun 25, 2006 · N316PR · DestroyedNTSB LAX06LA214Accident · No injuriesLimited investigationFinal reportCessna T210M · Hayward, CAA loss of power for undetermined reasons.Jun 25, 2006 · N761GW · Substantial damageNTSB CHI06LA165Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Bowling Green, MOThe loss of engine power due to fatigue fracture of the number two cylinder exhaust valve during initial climb after takeoff. A contributing factor was the unsuitable terrain (cornfield) encountered during the forced landing.Jun 24, 2006 · N2890K · Substantial damageNTSB SEA06CA128Accident · No injuriesData collectionFinal reportUnknown Challenger II · Emmett, IDThe pilot's failure to maintain aircraft control, which resulted in an off-airport landing. Contributing factors were the pilot's lack of familiarity with the airplane and the soft terrain.Jun 23, 2006 · UNREG · Substantial damageNTSB MIA06CA119Accident · Serious injuriesData collectionFinal reportPiper PA-25-235 · Opa-Locka, FLThe failure of the pilot-in-command to maintain airspeed resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with terrain.Jun 23, 2006 · N7788Z · Substantial damageNTSB DEN06LA090Accident · Serious injuriesLimited investigationFinal reportExcel Jet Sport Jet · Colorado Sprngs, COA loss of control for an undetermined reason during takeoff-initial climb that resulted in an in-flight collision with terrain.Jun 22, 2006 · N350SJ · Substantial damageNTSB ANC06LA074Accident · Serious injuriesLimited investigationFinal reportCessna 185F · Bettles, AKThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall and collision with terrain. Factors contributing to the accident were the inadvertent stall, and an unfavorable wind.Jun 22, 2006 · N94204 · Substantial damageNTSB DFW06CA164Accident · Serious injuriesData collectionFinal reportCessna 172F · Marietta, OKThe pilot's improper weather evaluation. Contributing factors were the strong tailwind and the high density altitude.Jun 21, 2006 · N8649U · Substantial damageNTSB NYC06CA148Accident · Serious injuriesData collectionFinal reportTaylorcraft DC-65 · Parma, NYAn uncontrolled descent into trees and terrain after takeoff for undetermined reasons.Jun 17, 2006 · N50VS · Substantial damageNTSB LAX06CA203Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2000 · Chandler, AZThe student pilot's failure to maintain directional control and the instructor's delayed remedial actions, which resulted in a collision with terrain during the initial takeoff climb. The instructor's inadequate supervision of the flight was also causal.Jun 10, 2006 · N280AM · Substantial damageNTSB DFW06CA157Accident · Serious injuriesData collectionFinal reportCaproni Vizzola Cos. Aero. Calif A-21 · San Antonio, TXThe pilot/owner's failure to properly secure the right wing, which resulted in the in-flight separation of the right wing.Jun 10, 2006 · N9FM · Substantial damageNTSB DEN06CA085Accident · No injuriesData collectionFinal reportBrent W. Brown Murphy Moose · St. Francis, KSthe pilot's failure to open the fuel selector valve, resulting in fuel starvation. Contributing factors were the pilot's failure to use a checklist, his attention being diverted, and the fence.Jun 10, 2006 · N142SR · Substantial damageNTSB LAX06FA197Accident · 2 fatalField investigationFinal reportBeech H35 · Reno, NVLoss of engine power during takeoff initial climb for undetermined reasons, which resulted in a loss of control and impact with a house. A contributing factor was the lack of suitable terrain for a forced landing.Jun 7, 2006 · N5455D · DestroyedNTSB ANC06LA069Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Jacksonville, FLAn undetermined event during takeoff/initial climb, which resulted in an emergency landing after takeoff and substantial damage to the airplane.Jun 4, 2006 · N80MJ · Substantial damageNTSB LAX06CA194Accident · No injuriesData collectionFinal reportCessna T207A · Jean, NVthe pilot's failure to obtain and maintain an adequate airspeed, which resulted in a stall/mush. A factor in the accident was the high density altitude.Jun 2, 2006 · N9962M · Substantial damageNTSB DEN06CA081Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Dighton, KSThe broken rocker arm boss causing the number 1 cylinder exhaust valve to stay closed and subsequently the engine failed. A factor contributing to the accident was the soft field the airplane set down in.Jun 1, 2006 · N14RY · Substantial damageNTSB NYC06FA128Accident · Serious injuriesField investigationFinal reportEmbraer EMB-170 · Dulles, VAImproper servicing of the nose landing gear strut and the operator's inadequate maintenance procedure. A factor was the inadequate checklist provided to the flight crew by the operator.May 31, 2006 · N651RW · Substantial damageNTSB NYC06CA135Accident · Minor injuriesData collectionFinal reportFlight Design Gmbh · Leesburg, VAThe pilot's improper remedial action to regain directional control after takeoff. A factor was the pilot's failure to maintain directional control after takeoff.May 30, 2006 · N460CT · Substantial damageNTSB LAX06LA187Accident · Serious injuriesLimited investigationFinal reportHunter Comp Air 6 · Minden, NVa loss of engine power due to an excessively rich mixture. The underlying reasons for the overly rich mixture were not determined. Also causal was the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which led to a…May 30, 2006 · N6008N · Substantial damageNTSB NYC06CA126Accident · No injuriesData collectionFinal reportPiper J3C · Old Town, METhe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with water.May 29, 2006 · N1401V · Substantial damageNTSB LAX06LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Oxnard, CAThe loss of engine power for undetermined reasons.May 26, 2006 · N4596X · Substantial damageNTSB LAX06LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Eagar, AZthe flight instructor's failure to attain and maintain the proper climb airspeed, which resulted in a stall/mush.May 26, 2006 · N6309W · Substantial damageNTSB MIA06LA116Accident · No injuriesLimited investigationFinal reportTecnam P92 Super Echo · Sebring, FLThe loss of engine power for undetermined reasons resulting in a forced landing and collision with a fence.May 25, 2006 · N929HA · Substantial damageNTSB MIA06IA110Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Augustine, FLThe loss of engine power due to separation of the crankshaft as a result of lack of adequate oil lubrication to the #2 main bearing. The lack of oil lubrication was most likely the result of improper assembly (fitting) of the bearing shells to the crankshaft.May 23, 2006 · N1130T · Minor damageNTSB ANC06LA059Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's inadequate evaluation of the weather conditions, and his selection of unsuitable terrain (rough water) for takeoff, which resulted in a collision with ocean swells during takeoff initial climb, and a hard emergency landing and a roll over. Factors…May 22, 2006 · N1543 · Substantial damageNTSB DFW06LA135Accident · No injuriesLimited investigationFinal reportBoeing A75 · Jennings, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.May 20, 2006 · N58072 · Substantial damageNTSB ANC06LA072Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKThe pilot's improper use of the carburetor heat control during takeoff, which resulted in a partial loss of engine power, a hard landing, and an on ground encounter with terrain. A factor contributing to the accident was an inadvertent ground loop.May 20, 2006 · N6324V · Substantial damageNTSB DFW06CA133Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · La Porte, TXThe student pilot's inadequate weather evaluation and his failure to maintain airspeed which resulted in a stall. A contributing factor was the prevailing tailwind.May 19, 2006 · N2378K · Substantial damageNTSB MIA06LA109Accident · Serious injuriesLimited investigationFinal reportMooney M20G · Lantana, FLThe pilot's inadequate preflight inspection, which resulted in a loss of engine power during initial climb due to water contamination in the fuel. Contributing factors were the deteriorated fuel cap o-ring and the pilot's failure to maintain adequate airspeed.May 18, 2006 · N12RH · Substantial damageNTSB LAX06LA178Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Chico, CAThe loss of engine power due to the pilot's inadequate preflight inspection and failure to verify the amount of fuel onboard.May 18, 2006 · N212DW · Substantial damageNTSB DFW06CA129Accident · Minor injuriesData collectionFinal reportMahoney Evans VP-1 · Corpus Christi, TXThe pilot's failure to maintain control of the airplane. A contributing factor was the dust devil/whirlwind.May 18, 2006 · N72260 · Substantial damageNTSB MIA06CA111Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Ormond Beach, FLA loss of engine power due to the student pilot's improper positioning of the fuel selector during takeoff. A contributing factor was the pilot's failure to abort the takeoff.May 16, 2006 · N8149Q · Substantial damageNTSB LAX06LA169Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tracy, CAloss of power for undetermined reasons.May 15, 2006 · N8981H · Substantial damageNTSB ATL06FA078Accident · 2 fatalField investigationFinal reportCessna 150L · Cumming, GAThe pilot's failure to consider the appropriate aircraft performance data prior to takeoff, and his improper use of the wing flaps during takeoff, which resulted in reduced climb performance and an in-flight collision with a residence. A factor associated…May 12, 2006 · N1715Q · DestroyedNTSB LAX06CA168Accident · No injuriesData collectionFinal reportGrumman G-164A · Yuba City, CAthe pilot's failure to attain and maintain an adequate airspeed during the takeoff initial climb.May 11, 2006 · N4892 · Substantial damageNTSB DFW06LA122Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Bishop, TXThe delayed landing flare by the pilot which resulted in a hard landing. A contributing factor was the loss of engine power for undetermined reasons.May 9, 2006 · N5021M · Substantial damageNTSB DEN06CA075Accident · Minor injuriesData collectionFinal reportAviat A-1 · Alamosa, COthe pilot's failure to maintain aircraft control during the departure, resulting in an inadvertent stall.May 9, 2006 · N105KY · Substantial damageNTSB NYC06CA111Accident · Serious injuriesData collectionFinal reportQuicksilver GT-400 · West Middlesex, PAThe pilot's failure to maintain adequate clearance from trees during the initial climb.May 7, 2006 · UNREG · Substantial damageNTSB LAX06LA164Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Show Low, AZthe collapse of the air intake duct resulted in a loss of engine power. A factor was the uneven terrain in the landing area.May 7, 2006 · N5263N · Substantial damageNTSB LAX06LA158Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26D · Aguila, AZThe pilot's failure to maintain control of the glider during takeoff-initial climb, which resulted in a broken tow rope, a spiral, and an in-flight collision with terrain. A factor associated with the accident is the pilot's failure to correct the spiral.May 3, 2006 · N7729S · Substantial damageNTSB DFW06CA117Accident · Minor injuriesData collectionFinal reportCessna 182L · Covington, LAThe total loss of engine power due to water contamination in the fuel system for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.May 2, 2006 · N42336 · Substantial damageNTSB LAX06LA155Accident · Serious injuriesLimited investigationFinal reportPartenavia P68 · Kaunakakai, HIthe pilot's failure to attain a proper climb rate and to maintain adequate clearance from the terrain during the initial climb in dark night conditions, which resulted in an in-flight collision with terrain.May 1, 2006 · N4574C · Substantial damageNTSB LAX06LA153Accident · 1 fatalLimited investigationFinal reportRonald R Russell RV-6 · Death Valley, CAa fuel starvation induced loss of engine power due to a likely vapor lock condition in the fuel lines.Apr 30, 2006 · N655VT · Destroyed