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 LAX04FA330Accident · Serious injuriesField investigationFinal reportBushmaster 2000 · Fullerton, CAthe inadequate preflight inspection by the pilot-in-command, where the pilot failed to remove the makeshift gust lock attached to the rudder and left elevator of the airplane. As a result, the airplane veered off the runway surface during the takeoff roll,…Sep 25, 2004 · N750RW · DestroyedNTSB ANC04LA120Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nenana, AKThe loss of engine power during takeoff-initial climb for an undetermined reason, which resulted in an emergency descent and hard landing.Sep 25, 2004 · N4409M · Substantial damageNTSB NYC04LA219Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-22A · Richmond, VAThe pilot's inadequate preflight inspection which resulted in fuel contamination and a subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while attempting a forced landing which resulted in an inadvertent…Sep 24, 2004 · N665WB · Substantial damageNTSB ANC04LA113Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A · Kodiak, AKThe pilot's inadequate compensation for wind conditions, and his intentional flight into adverse weather conditions, which resulted in a loss of control and collision with terrain during takeoff-initial climb. Factors contributing to the accident were high…Sep 23, 2004 · N6522T · Substantial damageNTSB IAD04LA048Accident · Minor injuriesLimited investigationFinal reportBoeing A75N (PT17) · Bayport, NYThe failure of a magneto, which resulted in a loss of engine power. Factors in the accident were the pilot's decision to take off downwind, which resulted in reduced airplane performance, and the tail wind.Sep 22, 2004 · N57003 · Substantial damageNTSB DEN04LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Provo, UTthe pilot's premature liftoff which resulted in failure to attain airspeed which resulted in a stall.Sep 22, 2004 · N5338H · Substantial damageNTSB CHI04LA265Accident · Serious injuriesLimited investigationFinal reportKenny Mariner-MF Boat · Eagle River, WIThe pilot's inability to maintain control of the aircraft during flight for undetermined reasons.Sep 21, 2004 · N744PK · Substantial damageNTSB LAX04LA322Accident · 2 fatalLimited investigationFinal reportWolf Glassair IIS · Mesa, AZa partial loss of power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering for a forced landing that resulted in a stall and a collision with terrain.Sep 18, 2004 · N110UX · DestroyedNTSB LAX04LA320Accident · Serious injuriesLimited investigationFinal reportHebb Avid Magnum · Bridgeport, CAthe pilot's failure to adequately compensate for the crosswind condition and his failure to maintain an adequate airspeed while using crossed controls, which led to a stall.Sep 17, 2004 · N970JH · DestroyedNTSB ATL04LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Inverness, FLThe improper installation of the carburetor which resulted in a loss of engine power and subsequent collision with trees during an emergency landing.Sep 16, 2004 · N4647Z · Substantial damageNTSB ANC04LA109Accident · No injuriesLimited investigationFinal reportCessna 140 · North Pole, AKThe pilot's failure to use carburetor heat during takeoff/initial climb, which resulted in a total loss of engine power, and an in-flight collision with trees.Sep 15, 2004 · N1629V · Substantial damageNTSB SEA04LA187Accident · Minor injuriesLimited investigationFinal reportWSK PZL Warzawa-Okecie PZL-104 Wilga 80 · The Dalles, ORAircraft control was not maintained by the tow plane pilot and the glider pilot did not maintain a proper climb rate during the initial climb. A direct crosswind and wind gusts were factors.Sep 11, 2004 · N10RN · Substantial damageNTSB FTW04LA236Accident · 1 fatalLimited investigationFinal reportLancair 360 · Orange, TXThe pilot's failure to maintain adequate airspeed during takeoff resulting in an inadvertent stall and loss of aircraft control.Sep 10, 2004 · N163DS · DestroyedNTSB CHI04LA253Accident · Serious injuriesLimited investigationFinal reportWilliams Glastar GS-1 · Hayward, WIThe pilot's failure to adequately compensate for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusty wind condition.Sep 10, 2004 · N501YR · Substantial damageNTSB ATL04LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Kennesaw, GAThe loss of engine power for undetermined reasons.Sep 9, 2004 · N45100 · Substantial damageNTSB LAX04LA333Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 900 · Mesa, AZfracture of a Tension-Torsion strap in the anti-torque fan due to progressive fiber failure of the composite strap material from compression and/or transverse shear stresses that occurred with repeated manipulation of the cockpit anti-torque control pedals…Sep 8, 2004 · N9016W · Substantial damageNTSB ANC04LA112Accident · No injuriesLimited investigationFinal reportCessna 170 · Teller, AKThe pilot's selection of unsuitable terrain for takeoff, and his inadequate evaluation of the wind conditions, which resulted in a collision with an embankment during takeoff-initial climb. Factors contributing to the accident was the presence of a sand…Sep 8, 2004 · N3492C · Substantial damageNTSB MIA04LA131Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · St. ThomasThe failure of the pilot-in-command to comply with performance data related to the recommended takeoff profile and his failure to perform remedial action following reduced tailrotor effectiveness, resulting in subsequent initiation of an autorotation and…Sep 4, 2004 · N176FM · Substantial damageNTSB FTW04FA232Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Corsicana, TXThe loss of engine power due to a faulty carburetor and the pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during the forced landing after takeoff.Sep 4, 2004 · N79307 · Substantial damageNTSB FTW04LA231Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Mountain Home, TXThe pilot's failure to maintain adequate airspeed which resulted in a stall.Sep 3, 2004 · N2972P · Substantial damageNTSB FTW04LA229Accident · No injuriesLimited investigationFinal reportCessna 175 · De Ridder, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Sep 2, 2004 · N6517E · Substantial damageNTSB LAX04LA308Accident · Minor injuriesLimited investigationFinal reportRockwell 112TCA · San Rafael, CAA total loss of engine power during initial climb due to fuel starvation, which was caused by the pilot's failure to turn on the electric boost pump and an undetermined failure of the engine driven pump to supply sufficient fuel to the carburetor.Aug 31, 2004 · N44MH · Substantial damageNTSB SEA04IA175Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Richmond, BC, CanadaThe slat was impacted by birds after takeoff and subsequently the slat delaminated due to flight loads.Aug 27, 2004 · N526UA · Minor damageNTSB FTW04LA220Accident · Minor injuriesLimited investigationFinal reportBell 212 · Umpire, ARThe pilot's encounter with settling with power resulting in a loss of control. A contributing factor was the high density altitude.Aug 24, 2004 · N181W · Substantial damageNTSB ANC04LA093Accident · 1 fatalLimited investigationFinal reportHudson Hiperbipe SNS-7 · Palmer, AKThe pilot's failure to maintain control of the airplane, which resulted in an uncontrolled descent and subsequent in-flight collision with trees. A factor associated with the accident was a low altitude maneuver preformed by the pilot just after takeoff.Aug 18, 2004 · N898DH · DestroyedNTSB SEA04FA165Accident · 3 fatalField investigationFinal reportCessna T210L · Tulsa, OKThe pilot's inadequate preflight inspection by his failure to secure the oil cap, which resulted in oil leakage on the windscreen, obstructing his vision, and his failure to maintain adequate airspeed.Aug 17, 2004 · N2452S · DestroyedNTSB MIA04LA120Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · Pensacola, FLThe pilot's inadequate planning/decision and his failure to maintain airspeed which resulted in fuel exhaustion and an inadvertent stall.Aug 17, 2004 · N45TT · DestroyedNTSB IAD04LA039Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Pemberton, NJA total loss of engine power for undetermined reasons.Aug 17, 2004 · N3771H · Substantial damageNTSB CHI04LA231Accident · Serious injuriesLimited investigationFinal reportStephen T-Bird TBT06 · Gobles, MIThe pilot's inadvertent flight into adverse weather conditions which resulted in an encounter with a downdraft that exceeded the climb capabilities of the airplane. The downdraft and the trees were factors.Aug 17, 2004 · N655DM · Substantial damageNTSB LAX04FA291Accident · 1 fatalField investigationFinal reportCessna 172M · Yuba City, CAthe pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall.Aug 15, 2004 · C-GTKX · DestroyedNTSB NYC04LA192Accident · No injuriesLimited investigationFinal reportWaco QCF · Rhinebeck, NYA partial loss of engine power due to a magneto failure.Aug 14, 2004 · N11478 · Substantial damageNTSB IAD04LA037Accident · Minor injuriesLimited investigationFinal reportAero Commander 112 · Jackson, OHthe loss of engine power for undetermined reasons over unsuitable terrain.Aug 14, 2004 · N1222J · Substantial damageNTSB CHI04CA229Accident · No injuriesData collectionFinal reportBell 47G2 · Muncie, INThe engine failure for an undetermined reason, and the pilot's inability to properly level-off for landing due to the low rotor speed, which resulted in the hard landing. The low altitude where the engine failure occurred was a factor.Aug 14, 2004 · N96MB · DestroyedNTSB CHI04CA224Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Cambridge, KSThe pilot not jettisoning his chemical load during initial climb with the reported loss of airplane performance. Factors were the reported loss of aircraft performance and the tree.Aug 12, 2004 · N2353W · Substantial damageNTSB SEA04LA156Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DC-65 · Wamic, ORThe pilot's inadequate compensation for wind conditions and his failure to maintain airspeed, resulting in a stall. The pilot's failure to use all of the available runway, and the high-gusty winds were factors.Aug 7, 2004 · N61021 · Substantial damageNTSB NYC04LA186Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Marlboro, MAThe loss of engine power due to a stuck cylinder exhaust valve. Factors were the tailwind and a jammed engine cylinder exhaust valve.Aug 7, 2004 · N6159T · Substantial damageNTSB ANC04CA089Accident · No injuriesData collectionFinal reportAeronca 15AC · Big lake, AKThe pilot's inadequate evaluation of the weather conditions and subsequent collision with high vegetation during the initial climb after takeoff, which resulted in a collision with the ground. Factors contributing to the accident were the presence of a…Aug 7, 2004 · N4433N · Substantial damageNTSB NYC04LA187Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Phillipsburg, PAA loss of partial engine power for undetermined reasons.Aug 3, 2004 · N6311P · Substantial damageNTSB FTW04FA204Accident · 6 fatalField investigationFinal reportPiper PA-60-601P · Lakeway, TXThe pilot's failure to successfully perform a short-field takeoff and his subsequent failure to maintain adequate airspeed during climbout, which resulted in an aerodynamic stall.Aug 3, 2004 · N601BV · DestroyedNTSB SEA04LA152Accident · 1 fatalLimited investigationFinal reportPaulick Wittman W-10 · Langley, WAThe pilot's inadequate preflight preparation to assure adequate takeoff performance to clear obstacles, and his failure to maintain obstacle clearance.Aug 1, 2004 · N70P · DestroyedNTSB SEA04LA134Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Mazama, WAThe pilot's inadequate compensation for the weather conditions and his failure to maintain the initial takeoff climb, which resulted in a collision with trees during an emergency landing. Contributing factors were the unfavorable wind and high density…Aug 1, 2004 · N7815Z · Substantial damageNTSB DEN04LA118Accident · No injuriesLimited investigationFinal reportBeech V35A · Grand Junction, COthe pilot's improper planning and decision making resulting in the loss of engine power due to fuel starvation. Contributing factors include the insufficient time to completely extend the landing gear, and the lack of suitable terrain for a forced landing.Aug 1, 2004 · N222S · Substantial damageNTSB CHI04CA210Accident · Minor injuriesData collectionFinal reportPiper PA-28RT-201T · Plymouth, MIThe loss of engine power at a low altitude due to a fuel flow restriction caused by vapor lock. Factors to the accident included the high atmospheric temperature and the road sign that the airplane impacted during the forced landing.Jul 31, 2004 · N77782 · DestroyedNTSB DEN04LA110Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Guernsey, WYthe pilot's inadequate use of carburetor heat which resulted in the formation of carburetor ice and loss of engine power. Factors contributing to the accident were weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced…Jul 25, 2004 · N5667L · DestroyedNTSB NYC04LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJThe flight instructor's inadequate preflight inspection, which resulted in an attempted takeoff with contaminated fuel, and a subsequent forced landing.Jul 24, 2004 · N6139J · Substantial damageNTSB LAX04CA278Accident · No injuriesData collectionFinal reportCessna A185F · Gridley, CAThe pilot's improper use of the rudder to correct for torque and P-factor effects and failure to maintain obstacle clearance.Jul 24, 2004 · N93DM · DestroyedNTSB LAX04LA275Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Mendota, CAThe pilot's inadequate preflight/pretakeoff procedure by not lowering the wing flaps, which resulted in an inadvertent stall as the pilot attempted to climb out of ground effect to clear a corn crop at the end of the runway. A factor in the accident was the…Jul 23, 2004 · N5010E · Substantial damageNTSB FTW04LA196Accident · Minor injuriesLimited investigationFinal reportEverett Vidrine Dragonfly · Covington, LAthe pilot's inadequate preflight planning which failed to assure adequate takeoff performance for the airplane to clear obstacles. A contributing factor was the pilot's failure to abort the takeoff.Jul 23, 2004 · N89VE · Substantial damageNTSB ANC04CA082Accident · Minor injuriesData collectionFinal reportPiper J3C · Palmer, AKThe pilot's inadequate evaluation of the wind conditions which resulted in an encounter with a downdraft during the takeoff/initial climb, and subsequent collision with trees and terrain. Factors contributing to the accident were the presence of a downdraft,…Jul 22, 2004 · N3458N · Substantial damageNTSB SEA04LA137Accident · Serious injuriesLimited investigationFinal reportRoot RV-4 · Buckley, WAThe pilot's inadequate preflight planning/preparation which resulted in a loss of engine power due to fuel starvation during the initial climb after takeoff. The pilot's failure to select the proper fuel tank before takeoff and to maintain airspeed during the…Jul 19, 2004 · N901ER · Substantial damage