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 CEN13FA509Accident · 1 fatalField investigationFinal reportCessna 421C · Paris, ILThe pilot's failure to abort the takeoff during the ground roll after detecting the airplane's degraded performance. Contributing to the accident was the pilot's decision to attempt a flight with a known problem with the left engine and the likely partial…Aug 27, 2013 · N229H · DestroyedNTSB ERA13LA380Accident · Minor injuriesLimited investigationFinal reportPiper PA46R-350T · Cat Cay, BahamasThe pilot’s attempt to rotate the airplane before obtaining sufficient airspeed and his improper pitch control during takeoff, which resulted in the airplane exceeding its critical angle-of-attack and subsequently experiencing an aerodynamic stall at a low…Aug 25, 2013 · N720JF · Substantial damageNTSB ERA13FA372Accident · 2 fatalField investigationFinal reportAeronca 7AC · Taunton, MAThe pilot/owner’s inadequate preflight inspection and inadequate pretakeoff check of the flight controls, which resulted in a takeoff with the rudder gust lock installed. Contributing to the accident was the pilot-rated passenger’s failure to detect that the…Aug 25, 2013 · N83863 · DestroyedNTSB DCA13WA144Incident · No injuriesForeign investigationAirbus Industrie A300B4-622R · Luton, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A300 operated by Federal Express Corp, which occurred on August 25, 2013. The NTSB has appointed a U.S. Accredited Representative to…Aug 25, 2013 · N721FD · No damageNTSB WPR13LA384Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Sacramento, CAA partial loss of engine power during initial climb for reasons that could not be determined because postaccident examination revealed no evidence of preimpact mechanical malfunction or failure that would have precluded normal operation.Aug 24, 2013 · N8223W · Substantial damageNTSB WPR13FA386Accident · Serious injuriesField investigationFinal reportPiper PA 28 · Tehachapi, CAThe pilot's failure to conduct predeparture airplane performance planning for a departure from a high density altitude location, which resulted in his selection of a flightpath toward rising terrain that the airplane was not capable of outclimbing.Aug 24, 2013 · N32582 · Substantial damageNTSB CEN13LA502Accident · Minor injuriesLimited investigationFinal reportAnderas Tiger Moth R80 · New Franken, WIThe 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.Aug 24, 2013 · N927TM · Substantial damageNTSB ERA13LA370Accident · No injuriesLimited investigationFinal reportBeech C23 · Bingham, METhe pilot's inadequate preflight planning, which resulted in his attempt to take off from a short, turf runway in high-density altitude conditions under which the airplane was unable to attain a positive climb rate to clear trees.Aug 20, 2013 · N243RG · Substantial damageNTSB CEN13FA496Accident · 2 fatalField investigationFinal reportMooney M20J · Kansas City, MOThe pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…Aug 18, 2013 · N9201R · Substantial damageNTSB ERA13LA366Accident · No injuriesLimited investigationFinal reportInterstate S-1B1 · Lititz, PAThe pilot’s failure to control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the initial takeoff climb. Contributing to the accident was the pilot’s failure to set the trim in accordance with the pretakeoff checklist and the…Aug 17, 2013 · N46336 · Substantial damageNTSB ERA13CA354Accident · No injuriesData collectionFinal reportStetson Norman B Challenger II · Orange, MAThe pilot’s failure to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of total flight experience in the accident airplane make and model.Aug 6, 2013 · N94454 · Substantial damageNTSB ERA13CA350Accident · No injuriesData collectionFinal reportCessna 172S · Portsmouth, NHThe pilot’s inadequate preflight inspection resulting in his failure to remove the pin he used to lock the flight controls in place of the approved control lock.Aug 3, 2013 · N645PD · Substantial damageNTSB CEN13LA460Accident · Serious injuriesLimited investigationFinal reportSnyder Todd W Titan Tornado 1 · Wild Rose, WIThe improperly secured spark plug, which resulted in a total loss of engine power.Aug 3, 2013 · N70786 · Substantial damageNTSB CEN13FA456Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Chesterfield, MOThe pilot’s failure to establish and maintain a positive climb rate during the initial climb in night instrument meteorological conditions.Aug 3, 2013 · N225CD · DestroyedNTSB ERA13LA346Accident · Serious injuriesLimited investigationFinal reportFpna A-22 Valor · Wurtsboro, NYThe pilot’s failure to comply with the manufacturer’s limitations and guidance regarding flaperons usage at low altitude and in adverse wind conditions, which resulted in an in-flight loss of airplane control.Jul 30, 2013 · N912FP · Substantial damageNTSB WPR13LA347Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge XT-912-L · Red Bluff, CAThe pilot's failure to properly secure himself in the cockpit with the seat belt, which resulted in his inability to control the airplane after takeoff.Jul 29, 2013 · N123FJ · DestroyedNTSB WPR13LA346Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Lone Pine, CAA partial loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot's decision to not…Jul 28, 2013 · N82182 · Substantial damageNTSB CEN13LA455Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lafayette, INThe pilot’s failure to maintain adequate airspeed in gusting wind conditions during the initial climb after takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Jul 28, 2013 · N286P · Substantial damageNTSB ERA13LA339Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Farmingdale, NJThe airplane’s loss of lift shortly after picking up a banner for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation.Jul 26, 2013 · N61929 · Substantial damageNTSB CEN13FA432Accident · 1 fatalField investigationFinal reportPiper PA-30 · Amarillo, TXThe pilot’s failure to maintain airplane control after a loss of left engine power due to water-contaminated fuel. Contributing to the accident was the lack of a proper preflight that could have detected water accumulation in the fuel system before takeoff.Jul 25, 2013 · N8306Y · Substantial damageNTSB WPR13FA335Accident · 1 fatalField investigationFinal reportMooney M20C · South Lake Tahoe, CAThe pilot’s decision to turn into rising terrain that would have required performance in excess of the airplane’s maximum climb rate to clear after taking off at a high density altitude.Jul 22, 2013 · N6709U · Substantial damageNTSB ERA13LA347Accident · Serious injuriesLimited investigationFinal reportDurfee Fred Quicksilver MXL · Lexington, TNThe student pilot/builder’s failure to maintain airspeed following a loss of engine power, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the student pilot/builder’s…Jul 22, 2013 · N2590B · Substantial damageNTSB ERA13FA325Accident · Serious injuriesField investigationFinal reportBeech 23 · Laurel, MDThe pilot's inadequate preflight preparation of the airplane, which resulted in a total loss of engine power during takeoff and his decision to operate the unairworthy airplane.Jul 18, 2013 · N2333Z · Substantial damageNTSB ERA13LA323Accident · Minor injuriesLimited investigationFinal reportJohnson Garret W Merlin GT · Collierville, TNThe total loss of engine power during takeoff for reasons that could not be determined during postaccident examination due to postcrash fire damage.Jul 17, 2013 · N618V · DestroyedNTSB CEN13LA418Accident · No injuriesLimited investigationFinal reportMarino Benoist Type XIV · Duluth, MNThe pilot's failure to maintain control of the seaplane during its initial flight test. Contributing to the accident was the pilot's overall lack of flight experience in the seaplane.Jul 16, 2013 · N613LD · Substantial damageNTSB WPR13CA330Accident · Serious injuriesData collectionFinal reportKincaid Wade Dakota Hawk · San Simon, AZThe pilot's failure to maintain clearance from power lines during takeoff from an open field.Jul 14, 2013 · N544WK · Substantial damageNTSB WPR13CA325Accident · No injuriesData collectionFinal reportBoeing E75 · Bozeman, MTThe pilot’s failure to maintain adequate airspeed during a turn, which resulted in a loss of lift and collision with terrain.Jul 14, 2013 · N5176N · Substantial damageNTSB WPR13LA321Accident · Minor injuriesLimited investigationFinal reportRaytheon A36 · Fallon, NVA fatigue failure of the No. 5 connecting rod, which resulted in a catastrophic engine failure during the initial climb and a subsequent forced landing.Jul 10, 2013 · N517DJ · Substantial damageNTSB WPR13CA323Accident · Minor injuriesData collectionFinal reportCessna 152 · Kamiah, IDThe student pilot’s failure to maintain aircraft control during the initial climb, which resulted in a collision with a powerline.Jul 10, 2013 · N46566 · Substantial damageNTSB DCA13MA121Accident · 10 fatalMajor investigationFinal reportDehavilland DHC-3 · Soldotna, AKThe operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…Jul 7, 2013 · N93PC · DestroyedNTSB WPR13CA311Accident · Minor injuriesData collectionFinal reportBellanca 8GCBC · Long Beach, CAThe pilot did not maintain adequate airspeed which resulted in an inadvertent stall and loss of aircraft control. Contributing to the accident was the pilot's improper use of flaps.Jul 6, 2013 · N613AP · Substantial damageNTSB WPR13FA300Accident · 2 fatalField investigationFinal reportAllstar PZL Glider SZD-54-2 Perkoz · Jacumba, CAThe premature release of the towline from the glider and the glider’s subsequent right banking turn at low altitude for reasons that could not be determined because postaccident airframe examination did not reveal any evidence of a mechanical malfunction or…Jun 29, 2013 · N684SD · Substantial damageNTSB WPR13FA298Accident · 2 fatalField investigationFinal reportAyers Less Drag Special · Oxnard, CAA loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and the pilot’s failure to maintain adequate airspeed, which resulted in an…Jun 29, 2013 · N130LD · Substantial damageNTSB ANC13LA059Accident · No injuriesLimited investigationFinal reportCessna 175 · Skwentna, AKThe partial loss of engine power for reasons that could not be determined because the postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation. .Jun 29, 2013 · N7698M · Substantial damageNTSB WPR13CA297Accident · Minor injuriesData collectionFinal reportCharles Peet Zenith CH 701 · Jackson, WYThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during takeoff/initial climb.Jun 28, 2013 · N44CP · Substantial damageNTSB WPR13FA281Accident · 2 fatalField investigationFinal reportPiper PA-30 · Idaho Falls, IDA loss of power to the right engine during the initial climb due to fuel contamination and the pilot's failure to maintain adequate airspeed and airplane control. Contributing to the accident was the pilot's inadequate preflight check of the airplane.Jun 22, 2013 · N830SS · Substantial damageNTSB ERA13LA297Accident · Minor injuriesLimited investigationFinal reportBeech G-36 · Pompano Beach, FLThe pilot’s premature rotation during takeoff with a tailwind and his delayed retraction of the landing gear, which reduced the airplane’s climb performance and subsequently led to the collision with power lines.Jun 21, 2013 · N7513 · Substantial damageNTSB CEN13FA364Accident · 4 fatalField investigationFinal reportCessna 172M · Waterford, MIThe pilot's failure to retract the wing flaps before attempting to take off, due to his lack of familiarity with the airplane make and model, which prevented the airplane from maintaining adequate altitude for takeoff.Jun 21, 2013 · N9926Q · DestroyedNTSB CEN13LA363Accident · No injuriesLimited investigationFinal reportThomsen Avid Flyer MK IV · Hibbing, MNA total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Jun 20, 2013 · N6240T · Substantial damageNTSB CEN13LA358Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Durango, COThe pilot's improper decision to take off with a tailwind at a high-density altitude, which resulted in the airplane’s failure to maintain the initial climb rate.Jun 18, 2013 · N7444J · Substantial damageNTSB CEN13LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Carrizo Springs, TXThe pilot’s failure to identify the water contamination of the fuel system during his preflight inspection, which resulted in a total loss of engine power during the airplane’s initial climb.Jun 17, 2013 · N49108 · Substantial damageNTSB WPR13LA274Accident · No injuriesLimited investigationFinal reportCessna T210L · Fresno, CAA hydraulic fluid leak in the nose landing gear actuator rod seal, which prevented the hydraulic system from building up sufficient pressure to fully retract or extend the main landing gear.Jun 16, 2013 · N94086 · Substantial damageNTSB CEN13FA352Accident · Serious injuriesField investigationFinal reportAero Commander 685 · Victoria, TXMaintenance personnel's failure to secure the left engine idler pin during overhaul, which resulted in a catastrophic engine failure and subsequent forced landing.Jun 15, 2013 · N74CP · Substantial damageNTSB ERA13WA287Accident · 4 fatalForeign investigationPiper PA22 · Taisha, EcuadorOn June 13, 2013, at 2028 coordinated universal time (1528 local time), a Piper PA-22-135, Ecuadorian registration HC-CMX, was destroyed when it impacted terrain shortly after taking off from Taisha Airport (SETH), Taisha, Morona-Santiago, Ecuador, en route…Jun 13, 2013 · HC-CMX · Substantial damageNTSB ERA13CA283Accident · No injuriesData collectionFinal reportHughes TH-55A · Morgantown, WVThe pilot’s inadequate planning which resulted in an encounter with settling with power and descent into terrain during takeoff.Jun 12, 2013 · N7057H · Substantial damageNTSB WPR13CA263Accident · Minor injuriesData collectionFinal reportGarland Avipro Bearhawk · Sheridan, WYThe pilot's failure to maintain airspeed, which resulted in a stall and a loss of aircraft control during the initial takeoff.Jun 7, 2013 · N540TH · Substantial damageNTSB ERA13WA306Accident · 1 fatalForeign investigationPiper PA34 · Envira, BrazilOn June 7, 2013, at 1400 coordinated universal time (UTC), a Piper PA-34-200T, Brazilian registration PT-MMX, was substantially damaged during a ditching into the Tarauacá River following an unspecified malfunction of the airplane’s right engine after…Jun 7, 2013 · PT-MMX · Substantial damageNTSB ERA13LA270Accident · 1 fatalLimited investigationFinal reportMaule BEE DEE M-4-210 · Cuttyhunk, MAThe pilot’s failure to maintain adequate airspeed after takeoff, which resulted in an aerodynamic stall and loss of airplane control.Jun 5, 2013 · N9807M · Substantial damageNTSB ERA13LA269Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Elkton, KYThe pilot's failure to use carburetor heat during the approach to landing, which resulted in carburetor icing and a partial loss of engine power during a subsequent initial climb.Jun 4, 2013 · N97592 · Substantial damageNTSB ERA13IA267Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tallahassee, FLThe failure of the elevator trim cable due to fatigue cracking, which resulted from maintenance personnel’s repeated inadequate inspection of the cable.Jun 3, 2013 · N633TC · No damage