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 FTW01LA109Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Nacogdoches, TXthe pilot's failure to maintain clearance with the wires during takeoff. Contributory factors were the sunglare and the unmarked wires.Apr 27, 2001 · N9508F · Substantial damageNTSB DEN01LA093Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · St. George, UTthe pilot's failure to sump all the fuel drains during preflight and the subsequent loss of power in the right engine during takeoff, the pilot feathering the wrong engine's propeller during the forced landing, the pilot improperly raising the landing gear…Apr 27, 2001 · N27367 · Substantial damageNTSB DEN01FA090Accident · Serious injuriesField investigationFinal reportPiper PA-39 · Fort Collins, COthe loss of right engine power on take-off as a result of the separation of the right engine's alternate air door, which lodged in the fuel servo air inlet. A factor was the lack of suitable terrain for a forced landing.Apr 26, 2001 · N8984Y · Substantial damageNTSB LAX01LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Oxnard, CAThe fracture and separation of the number 3 cylinder exhaust valve head resulting in a loss of engine power and a forced landing. A factor in the accident was the soft field where the forced landing occurred.Apr 22, 2001 · N75343 · Substantial damageNTSB SEA01LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172 N · Sultan, WAThe pilot's failure to maintain adequate clearance from trees and terrain during the airplane's initial climb.Apr 21, 2001 · N8402E · Substantial damageNTSB DEN01FA088Accident · 1 fatalField investigationFinal reportBeech 35 · Glenwood Sprgs, COthe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush to the ground. Contributing factors were the pilot's lack of experience in make/model airplane, the high density altitude weather condition, and the pilot's attempted…Apr 17, 2001 · N2PZ · DestroyedNTSB LAX01FA144Accident · 1 fatalField investigationFinal reportSchleicher ASW-20 · Williams, CAThe failure of the pilot to attach the elevator control rod to the elevator, resulting in a loss of pitch control and subsequent ground impact. Additional factors were the failure to complete a positive control check and the lack of clear guidance in the…Apr 14, 2001 · N47TR · Substantial damageNTSB FTW01FA100Accident · 1 fatalField investigationFinal reportFairchild PT-19A · Midland, TXthe pilot's failure to maintain airspeed which resulted in an inadvertant stall during initial takeoff climb. A contributing factor was wind gusts.Apr 14, 2001 · N58123 · DestroyedNTSB FTW01LA099Accident · No injuriesLimited investigationFinal reportCessna 150L · Iowa Park, TXfuel exhaustion during takeoff due to the pilot's failure to refuel.Apr 12, 2001 · N19045 · Substantial damageNTSB DEN01LA085Accident · Minor injuriesLimited investigationFinal reportBoyd Young Kolb Mark III · Brigham City, UTthe pilot's misjudged landing flare, which resulted in a hard landing. A factor was the propeller tip separation due to foreign object damage.Apr 11, 2001 · N1225Y · Substantial damageNTSB MIA01FA119Accident · 1 fatalField investigationFinal reportBeech A-45/T-34A · Claxton, GAThe pilot in command's failure to maintain airspeed while performing an emergency landing after having just taken off with an unsecured fuel cap, which resulted in an inadvertent stall mush, an uncontrolled descent, and an impact with trees.Apr 10, 2001 · N340JB · DestroyedNTSB MIA01FA117Accident · 2 fatalField investigationFinal reportPiper PA-46-500TP · Vero Beach, FLThe pilot's excessive bank angle and his failure to maintain airspeed while returning to the airport after takeoff due to an unspecified problem resulting in the airplane stalling and colliding with trees during the resultant uncontrolled descent.Apr 9, 2001 · N262MM · DestroyedNTSB DEN01LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Telluride, COthe pilot's failure to maintain control of the airplane during initial climb. Factors include the gusty wind and high density altitude conditions.Apr 8, 2001 · N7736P · Substantial damageNTSB MIA01LA114Accident · Serious injuriesLimited investigationFinal reportArnet Pereyra Aventura II · Rockledge, FLthe pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with the ground. Contributing to the accident was the pilot's distraction with the landing gear system.Apr 7, 2001 · N407EC · Substantial damageNTSB LAX01LA139Accident · Minor injuriesLimited investigationFinal reportBeech F-33A · Mobile, AZThe certified flight instructor's inadequate supervision of the dual student who failed to recognize the extent of the crosswind and lost directional control. A factor in the accident was the variable wind condition.Apr 5, 2001 · N5544P · Substantial damageNTSB LAX01LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucson, AZthe pilot's failure to attain and maintain a sufficient airspeed, which resulted in an inadvertent stall/mush.Apr 3, 2001 · N21394 · Substantial damageNTSB CHI01LA112Accident · No injuriesLimited investigationFinal reportMeyers 200A · Tecumseh, MIThe fuel starvation. Factors were the loose line at the distribution valve, the inadequate annual inspection the owner/pilot mechanic performed, the unsuitable terrain the pilot encountered during the emergency landing after takeoff, and the trees.Apr 2, 2001 · N495C · Substantial damageNTSB CHI01FA111Accident · 1 fatalField investigationFinal reportCessna 501 · Ashwaubenon, WIThe pilot not maintaining aircraft control while maneuvering after takeoff and the pilot's inadequate preflight planning and preparation. Factors relating to the accident were the pilot's diverted attention while maneuvering after takeoff, the pilot's…Apr 2, 2001 · N405PC · DestroyedNTSB ATL01LA046Accident · 1 fatalLimited investigationFinal reportJacques J. Mistrot Skybolt · Smithfield, NCThe pilot's failure to maintain control of the airplane during climb out that resulted in the in-flight collision with the ground. A factor was the physical impairment.Apr 2, 2001 · N58JM · Substantial damageNTSB ATL01LA045Accident · Serious injuriesLimited investigationFinal reportCessna 182 P · Kennesaw, GAThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.Apr 2, 2001 · N21306 · Substantial damageNTSB FTW01LA091Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-3 · Decatur, TXthe pilot's failure to maintain aircraft control during the takeoff/initial climb. Contributing factors were the pilot's exceeding aircraft weight and balance limits and the dust devil.Mar 31, 2001 · N120BA · Substantial damageNTSB DEN01FA075Accident · 1 fatalField investigationFinal reportSocata TBM 700 · Englewood, COthe pilot's spatial disorientation, which led to his failure to maintain aircraft control. A contributing factor was the pilot's decision to intentionally fly into known adverse weather that consisted of low ceilings, obscuration, and ice fog.Mar 26, 2001 · N300WC · DestroyedNTSB LAX01LA120Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Hollister, CAthe pilot's inadequate use of the antitorque controls and subsequent failure to maintain directional control of the helicopter during the takeoff initial climb.Mar 18, 2001 · N637H · DestroyedNTSB FTW01LA078Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKthe loss of engine power during the initial takeoff climb for an undetermined reason, which resulted in a forced landing. A contributory factor to the accident was the lack of suitable terrain for the forced landing.Mar 14, 2001 · N757GP · DestroyedNTSB MIA01LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Poplarville, MSa loss of engine power due to a cracked number 2 cylinder which resulted in a forced landing, subsequent impact with the runway, departure from the runway down an embankment, soft terrain and nose over.Mar 13, 2001 · N5076 · Substantial damageNTSB ATL01LA037Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Durham, NCThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.Mar 10, 2001 · N2968F · Substantial damageNTSB MIA01LA095Accident · No injuriesLimited investigationFinal reportCessna 172R · Cartersville, GAthe pilot's failure to maintain control of the airplane which resulted in the airplane veering off course and subsequent impact with trees.Mar 8, 2001 · N651MA · Substantial damageNTSB ANC01LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Ophir, AKThe pilot's selection of unsuitable terrain for takeoff, and his inadequate preflight planning/preparation resulting in a collision with trees during the initial climb. Factors in the accident were soft, snow-covered terrain, and trees in the area of…Mar 7, 2001 · N9383C · Substantial damageNTSB IAD01IA034Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10 · Boston, MAThe inadequate de-ice and preflight inspection procedure of the #2 engine inlet and bellmouth area by company maintenance personnel that resulted in ice ingestion and foreign object damage of the #2 engine.Mar 6, 2001 · N375FE · Minor damageNTSB SEA01LA058Accident · Serious injuriesLimited investigationFinal reportAvia Stroitel AC-5m · Bozeman, MTthe pilot's improper remedial action upon experiencing the unexpected opening of the aircraft's canopy during the initial part of the takeoff climb. Factors include his attention being diverted to the open canopy, his failure to use a checklist to ensure he…Mar 4, 2001 · N1635M · Substantial damageNTSB CHI01LA098Accident · No injuriesLimited investigationFinal reportCessna 170B · South Haven, MNThe pilot's failure to maintain altitude/clearance from the terrain during the maneuver to avoid the tree line. Factors to the accident were the diminished aircraft handling, the pilot's maneuver to avoid the tree line, the unsuitable terrain for takeoff…Mar 4, 2001 · N2577D · Substantial damageNTSB NYC01LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, RIThe loose fuel line, which resulted in fuel starvation to the engine.Feb 28, 2001 · N2542A · Substantial damageNTSB FTW01LA072Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Brenham, TXthe in-flight separation of the throttle linkage, which resulted in the loss of engine power.Feb 27, 2001 · N1488T · Substantial damageNTSB LAX01FA103Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Paso Robles, CAThe pilot/owner/operator's failure to maintain control of the airplane during the takeoff initial climb resulting in an in-flight collision with terrain. Contributing to the accident was the dark night light condition.Feb 21, 2001 · N9176Z · DestroyedNTSB NYC01LA086Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Keene, NHinadequate visual lookout by the flight instructor on the helicopter's proximity to the snowbank, and subsequent lift off, which resulted in a dynamic rollover.Feb 19, 2001 · N910SM · Substantial damageNTSB LAX01LA099Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Auburn, CAA partial loss of engine power during initial takeoff climb due to the formation of carburetor ice. A contributing factor was the pilot's improper pretakeoff actions. A finding was that the improper rigging of the mixture control cable may have precluded…Feb 15, 2001 · N18152 · Substantial damageNTSB MIA01FA077Accident · 2 fatalField investigationFinal reportCessna 182J · Stuart, FLThe loss of engine power due to undetermined reasons resulting in the forced landing. A factor in the accident was the unsuitable terrain encountered during the forced landing.Feb 13, 2001 · N979ND · DestroyedNTSB LAX01LA098Accident · No injuriesLimited investigationFinal reportBell 47-G3B1 · Winterhaven, CAA failure of the transmission free wheeling unit due to improper maintenance. A factor was the dark night visual condition.Feb 10, 2001 · N3084G · Substantial damageNTSB ATL01LA034Accident · Serious injuriesLimited investigationFinal reportJack McDaniel Rans S-12 · Homestead, FLThe pilots failure to maintain flying speed during a soft field takeoff, that resulted in the loss of control and a stall/ spin.Feb 10, 2001 · N823S · Substantial damageNTSB MIA01FA072Accident · 1 fatalField investigationFinal reportPiper PA-30 · Ponce, PRThe pilot's decision to attempt flight with known deficiencies in the airplanes right engine, his failure to feather the right propeller after the engine failed , his failure to retract the landing gear following the engine failure, and his failure to…Feb 8, 2001 · N181MM · DestroyedNTSB LAX01LA093Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Pixley, CAA loss of control during takeoff due to the helicopter's heavy gross weight condition that exceeded its lifting capability.Feb 7, 2001 · N6260C · Substantial damageNTSB DEN01LA048Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Canon City, COThe loss of engine power during takeoff initial climb resulting from an excessively rich fuel/air mixture, which fouled the spark plugs. A factor was rough, unsuitable terrain for a forced landing.Feb 5, 2001 · N42696 · Substantial damageNTSB LAX01LA086Accident · Minor injuriesLimited investigationFinal reportStorey MK 7 · Marana, AZThe pilot's inadequate preflight preparation with regards to runway choice, terrain, and performance capabilities of the airplane.Feb 4, 2001 · N1296 · Substantial damageNTSB CHI01LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Burlington, WIAircraft control not maintained by the pilot during the landing roll. Factors to the accident were the loss of engine power for undetermined reasons, the end of the runway being snow-covered, and the snowbank.Jan 28, 2001 · N22026 · Substantial damageNTSB DEN01FA044Accident · 2 fatalField investigationFinal reportAero Vodochody Aero. Works L-39CT · Watkins, COThe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush. Factors were the pilot's diverted attention due to the failure of the rear canopy's acrylic transparency and the loss of communication with his back seat passenger,…Jan 24, 2001 · N602MC · DestroyedNTSB ATL01FA027Accident · 4 fatalField investigationFinal reportBeech F90-42 · Nashville, TNThe pilot's failure to follow loss of engine power emergency procedures by not feathering the propeller following the loss of engine power for undetermined reasons, resulting in a descent and collision with trees and the ground.Jan 24, 2001 · N17AE · DestroyedNTSB ATL01LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-A-150 · Sun City, FLThe loss of engine power for undetermined reasons, a factor was weather conditions favorable for carburetor icingJan 15, 2001 · N6971D · Substantial damageNTSB SEA01LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Cottage Grove, ORThe flight instructor's failure to ensure (supervision) the student had an adequate supply of fuel available, and the student's failure to refuel the aircraft sufficently resulting in a fuel starvation/exhaustion condition and total power loss. Contributing…Jan 10, 2001 · N9988L · DestroyedNTSB CHI01TA063Accident · Serious injuriesFinal reportPiper PA-23 · Griffith, INThe unsuitable terrain for landing encountered by the pilot. Factors included the loss of power for undetermined reasons and the rough terrain.Jan 10, 2001 · N200WH · Substantial damageNTSB FTW01LA047Accident · Serious injuriesLimited investigationFinal reportNord 1101 · McKinney, TXthe loss of engine power during takeoff resulting from the inadequate engagement of the throttle torque tube rod end into the support bushing by unknown maintenance personnel.Jan 9, 2001 · N208BF · Substantial damage