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 WPR11LA289Accident · Serious injuriesLimited investigationFinal reportLemond FLY Fisher · West Glacier, MTA total loss of engine power during takeoff due to water contamination in the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.Jun 26, 2011 · N397JL · Substantial damageNTSB WPR11LA287Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · St Johns, AZThe pilot did not attain and maintain an adequate airspeed during the takeoff initial climb, which resulted in an aerodynamic stall.Jun 26, 2011 · N2725V · Substantial damageNTSB WPR11CA286Accident · No injuriesData collectionFinal reportAir Tractor AT301 · Circle, MTThe pilot's failure to attain and maintain an adequate airspeed during initial climb.Jun 24, 2011 · N2362D · Substantial damageNTSB ERA11LA359Accident · Serious injuriesLimited investigationFinal reportNavion Navion B · Red Oak, NCThe pilot's inadvertent movement of the fuel tank selector handle to the off position, resulting in a total loss of engine power due to fuel starvation.Jun 23, 2011 · N75394 · Substantial damageNTSB WPR11LA292Accident · No injuriesLimited investigationFinal reportCessna 320F · Phoenix, AZThe mechanic's failure to properly secure the nose landing gear actuator push-pull tube to the landing gear door hinge clevis, which resulted in the gear jamming and not fully retracting after takeoff.Jun 21, 2011 · N6160Q · Substantial damageNTSB WPR11LA278Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Blackfoot, IDA partial loss of engine power during takeoff for undetermined reasons.Jun 21, 2011 · N1515P · Substantial damageNTSB ERA11FA349Accident · 4 fatalField investigationFinal reportCessna T210N · Armonk, NYThe pilot's decision to depart on the flight with a suspected mechanical deficiency and his subsequent decision to fly the final approach at a reduced power setting. Contributing to the accident was the improper timing of the magneto(s) that resulted in a…Jun 18, 2011 · N210KW · Substantial damageNTSB ERA11FA348Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Guntersville, ALThe pilot's excessive pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to comply with weight and balance limitations.Jun 18, 2011 · N1803T · Substantial damageNTSB CEN11CA406Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Shepard, TXthe pilot's loss of aircraft control after encountering windshear and turbulence on takeoff.Jun 17, 2011 · N3504K · Substantial damageNTSB ERA11LA342Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Linden, NCA partial loss of engine power during initial climb for undetermined reasons.Jun 14, 2011 · N8476B · Substantial damageNTSB CEN11FA383Accident · Minor injuriesField investigationFinal reportBoeing B-17G · Oswego, ILAn inadequate repair of the fuel tank that allowed the fuel leak to continue, ultimately resulting in an in-flight fire.Jun 13, 2011 · N390TH · Substantial damageNTSB CEN11LA484Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Cash, ARA loss of engine power for undetermined reasons.Jun 11, 2011 · N3629C · Substantial damageNTSB ERA11LA336Accident · Serious injuriesLimited investigationFinal reportMarks Ca III Kitfox II · Scarborough, METhe pilot’s failure to maintain control of the airplane while taking off with a gusting wind.Jun 10, 2011 · N915PK · Substantial damageNTSB CEN11CA391Accident · No injuriesData collectionFinal reportBeech F33A · Houston, TXAn in-flight collision with a bird during initial climb.Jun 10, 2011 · N70TP · Substantial damageNTSB CEN11LA375Accident · No injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Junction City, KSThe degraded engine performance due to low compression on the cylinder and delayed ignition timing.Jun 4, 2011 · N50052 · Substantial damageNTSB CEN11LA374Accident · Serious injuriesLimited investigationFinal reportMalkin Roy K Searey · Minneapolis, MNThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall. Contributing to the accident was the degraded engine performance due to the improper servicing and maintenance of the fuel system.Jun 4, 2011 · N242RM · Substantial damageNTSB ERA11LA325Accident · Minor injuriesLimited investigationFinal reportClamar Floats CA-4 · Merritt Island, FLThe loss of engine power during takeoff for reasons that could not be determined because a postaccident examination could not be performed before the airplane was disassembled.Jun 3, 2011 · N434JC · Substantial damageNTSB WPR11LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Pine Bluffs, WYA partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation.Jun 2, 2011 · N9496G · Substantial damageNTSB ANC11CA040Accident · No injuriesData collectionFinal reportCessna 140 · Chickaloon, AKThe pilot's improper decision to take off downwind from unsuitable terrain.May 29, 2011 · N89424 · Substantial damageNTSB CEN11FA346Accident · 1 fatalField investigationFinal reportHansen IB C Cassutt III M · Erie, COThe pilot's incapacitation due to a cardiac event.May 22, 2011 · N420FH · Substantial damageNTSB CEN11LA348Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Cypress, TXThe loss of engine power due to carburetor ice.May 21, 2011 · N55754 · Substantial damageNTSB CEN11CA360Accident · Serious injuriesData collectionFinal reportLammers Sjef J Apache · Colorado Springs, COThe pilot's failure to maintain control of the aircraft during take-off in a cross wind, which resulted in an inadvertent stall.May 20, 2011 · N566RL · Substantial damageNTSB ANC11CA033Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate preflight inspection, resulting in a departure with the fuel selector in the "off" position, a subsequent loss of engine power, and an off-airport emergency landing.May 17, 2011 · N7690H · Substantial damageNTSB CEN11LA339Accident · No injuriesLimited investigationFinal reportMD Helicopter 369E · Victoria, TXThe pilot’s failure to ensure that the governor limit switch was properly set, which resulted in reduced engine power.May 16, 2011 · N4278T · Substantial damageNTSB WPR11LA223Accident · 1 fatalLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Arlington, WAThe pilot’s failure to maintain control during the takeoff climb, which resulted in a stall at low altitude and collision with terrain. Contributing to the accident was the pilot’s impaired performance from over-the-counter medications.May 14, 2011 · N282SC · Substantial damageNTSB ERA11LA297Accident · Serious injuriesLimited investigationFinal reportBell 206-L4 · Mobile Block 114CCThe pilot’s operation of the helicopter with a left, quartering headwind, resulting in conditions conducive to a loss of tail rotor effectiveness.May 13, 2011 · N266P · Substantial damageNTSB ERA11LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocilla, GAThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.May 7, 2011 · N7317W · Substantial damageNTSB CEN11FA324Accident · 2 fatalField investigationFinal reportWoodward Harold L Ravin 500 · Conroe, TXAn in-flight smoke event on takeoff and the pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall.May 7, 2011 · N913RA · DestroyedNTSB CEN11LA316Accident · 1 fatalLimited investigationFinal reportNorris Dominator · Blue Springs, NEThe pilot's failure to maintain clearance from power lines.May 3, 2011 · N103EB · Substantial damageNTSB ERA11FA274Accident · 1 fatalField investigationFinal reportBeech E18S · Miami Gardens, FLThe pilot’s improper response to a loss of power in the No. 2 engine and his failure to ensure that the airplane was airworthy. Contributing to the accident was the inadequate engine maintenance by the operator's maintenance personnel.May 2, 2011 · N18R · Substantial damageNTSB ERA11CA279Accident · No injuriesData collectionFinal reportFranke Harry C Avid Flyer B · Somerset, PAThe pilot’s failure to hold full power for takeoff.Apr 30, 2011 · N145HF · Substantial damageNTSB CEN11FA310Accident · 1 fatalField investigationFinal reportJurmu Stol CH701 · Pulaski, WIThe pilot did not maintain control of the airplane during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of recent flight experience.Apr 29, 2011 · N701MJ · Substantial damageNTSB WPR11LA209Accident · No injuriesLimited investigationFinal reportCessna 182B · Colville, WAThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.Apr 23, 2011 · N8435T · Substantial damageNTSB WPR11LA207Accident · No injuriesLimited investigationFinal reportDavison RV-7A · Marsing, IDA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Apr 23, 2011 · N59TD · Substantial damageNTSB CEN11FA304Accident · 2 fatalField investigationFinal reportCubcrafters CC11-160 · Parker, COThe pilot’s excessive and unsafe maneuvering during gusty wind conditions, which resulted in an inadvertent stall-spin.Apr 23, 2011 · N143FJ · Substantial damageNTSB ERA11WA265Accident · 7 fatalForeign investigationEmbraer EMB-810C · Manaus, BrazilOn April 21, 2011, about 1850 coordinated universal time, an Embraer EMB-810C, Brazilian registration PT-EFS, was destroyed when it impacted terrain shortly after takeoff from Eduardo Gomes Airport (SBEG), Manaus, Brazil. The two flight crewmembers and five…Apr 21, 2011 · PT-EFS · DestroyedNTSB WPR11LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Payson, AZThe pilot's decision to conduct a touch-and-go arrival during his first flight to a high elevation airport, which resulted in an improper mixture adjustment and a partial loss of engine power for the takeoff and attempted climbout.Apr 16, 2011 · N1835U · Substantial damageNTSB WPR11CA196Accident · No injuriesData collectionFinal reportCessna T188C · Palouse, WAThe pilot's inadequate evaluation of the wind conditions at takeoff and failure to maintain an adequate airspeed, which resulted in a stall and collision with terrain during the initial climb.Apr 13, 2011 · N4562J · Substantial damageNTSB ERA11LA240Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Richmond, VAThe pilot’s failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall and subsequent impact with the ground.Apr 12, 2011 · N3547C · Substantial damageNTSB WPR11LA205Accident · Minor injuriesLimited investigationFinal reportBennett Midjet Mustang I · Ramona, CAThe pilot's inability to maintain directional control during the landing roll due to the overload separation of the left brake master cylinder from the left rudder pedal assembly.Apr 10, 2011 · N611JB · Substantial damageNTSB ERA11LA234Accident · 1 fatalLimited investigationFinal reportLet L 33 Solo · New Castle, VAPilot incapacitation shortly after takeoff for unknown reasons.Apr 10, 2011 · N286BA · Substantial damageNTSB DCA11IA040Incident · No injuriesIncident investigationFinal reportAirbus A320 · New Orleans, LAthe captain's failure to properly recognize and manage the abnormal condition, resulting in it escalating to an in-flight emergency.Apr 4, 2011 · N409UA · Minor damageNTSB WPR11FA184Accident · 1 fatalField investigationFinal reportNorth American Navion A · Alameda, CAThe pilot’s failure to maintain airspeed while maneuvering for an emergency landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power for undetermined reasons during initial climb.Apr 3, 2011 · N91472 · Substantial damageNTSB ERA11FA222Accident · 2 fatalField investigationFinal reportReplogle Lancair 360 · Chesapeake, VAThe pilot did not maintain airspeed following a loss of engine power, which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot's selection of the wrong fuel tank at takeoff, which resulted in fuel starvation and the total…Apr 3, 2011 · N164T · Substantial damageNTSB CEN11LA262Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Ruidoso, NMThe left engine's intermittent loss of power during initial climb for undetermined reasons. Contributing to the accident was the high density altitude at the time of the accident.Apr 3, 2011 · N7849Y · Substantial damageNTSB WPR11LA180Accident · Minor injuriesLimited investigationFinal reportWilliam Wright Avid Flyer · Cedar City, UTA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal a specific anomaly that would have precluded normal operation.Apr 1, 2011 · N613HH · Substantial damageNTSB ANC11LA022Accident · No injuriesLimited investigationFinal reportBoeing 737-301 · Dayton, OHThe flightcrew's inadequate preflight inspection, resulting in in-flight structural damage to the airplane's fuselage from an unsecured pallet jack that was located in the airplane's empty cargo hold.Mar 30, 2011 · N360WA · Substantial damageNTSB ERA11LA228Accident · Minor injuriesLimited investigationFinal reportHrosik Gene Aventura II · Crescent City, FLThe pilot's failure to maintain adequate airspeed during climb after takeoff, resulting in an aerodynamic stall.Mar 29, 2011 · N5842 · Substantial damageNTSB ERA11LA213Accident · Minor injuriesLimited investigationFinal reportHolst Lawrence E VP-1 · Calhoun, GAA partial loss of engine power during initial climb due to an over-lean carburetor setting. Contributing to the accident was the pilot's improper adjustment of the engine's carburetor during construction.Mar 25, 2011 · N770VP · Substantial damageNTSB ERA11LA196Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean Springs, MSThe airplane's overweight condition due to the pilot's improper weight and balance calculation that resulted in the airplane's inability to maintain altitude.Mar 19, 2011 · N7330J · Substantial damage