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 DCA19WA181Incident · No injuriesForeign investigationBoeing 777 · London, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on July 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex…Jul 3, 2019 · GY-MMU · No damageNTSB GAA19CA439Accident · Minor injuriesData collectionFinal reportCessna 172 · Manteo, NCThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jun 30, 2019 · N78658 · Substantial damageNTSB CEN19MA190Accident · 10 fatalClass 2 · MajorFinal reportTextron B-300 · Addison, TXThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined. Contributing to the accident was the pilot’s failure to conduct the airplane…Jun 30, 2019 · N534FF · DestroyedNTSB ENG19WA028Incident · No injuriesForeign investigationAirbus A320 · Delhi, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on June 26, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced issues with the No. 1 (left)…Jun 29, 2019 · VT-ITP · No damageNTSB CEN19LA202Accident · No injuriesClass 3 · LimitedFinal reportAeronca L16A · Zelienople, PAA total loss of engine power due to obstruction of the carburetor air intake by a piece of the air filter gasket that had become detached.Jun 29, 2019 · N9325H · Substantial damageNTSB GAA19CA429Accident · Minor injuriesData collectionFinal reportFlightstar Sportplanes Flightstar II · Coward, SCThe noncertificated pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.Jun 28, 2019 · UNREG · Substantial damageNTSB ERA19LA217Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 77 · Leesburg, FLA partial loss of engine power due to carburetor icing, which resulted from the flight instructor's decision not to use carburetor heat.Jun 28, 2019 · N1802Y · Substantial damageNTSB GAA19CA377Accident · No injuriesData collectionFinal reportCessna 177 · Pleasanton, KSThe pilot's loss of yaw control during takeoff with a right quartering headwind in gusting wind conditions, which resulted in a collision with trees.Jun 27, 2019 · N30257 · Substantial damageNTSB ERA19FA200Accident · 2 fatalClass 2 · FieldFinal reportRans S6 · Fletcher, NCThe exceedance of the airplane's critical angle of attack during climb, which resulted in an aerodynamic stall and spin at low altitude. Contributing was the lack of experience both pilots possessed in the accident airplane.Jun 26, 2019 · N661PF · DestroyedNTSB GAA19CA426Accident · Minor injuriesData collectionFinal reportNorth American T28 · Hollister, CAThe pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.Jun 20, 2019 · N28CU · Substantial damageNTSB CEN19WA201Accident · Serious injuriesForeign investigationPiper PA28R · Pointe-A-Pitre, GuadeloupeJun 19, 2019 · F-ODSM · DestroyedNTSB CEN19LA174Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Key West, FLThe failure of maintenance personnel to properly secure the right-side tail boom mounting bolts which resulted in the failure of the bolts and an inflight separation of the tail rotor.Jun 17, 2019 · N1241W · Substantial damageNTSB GAA19WA356Accident · 1 fatalForeign investigationPitts S2 · Saint-Jean-Port-Joli, CanadaJun 16, 2019 · C-CONV · DestroyedNTSB WPR19LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182M · Upland, CAThe total loss of engine power due to detonation within the No. 2 cylinder as a result of a lean fuel flow setting.Jun 15, 2019 · N777RK · Substantial damageNTSB CEN19LA172Accident · Minor injuriesClass 3 · LimitedFinal reportKarns SKY Ranger · Hedgesville, WVA partial loss of engine power during takeoff due to the formation of carburetor ice while on the ground, which resulted in an impact with terrain.Jun 14, 2019 · N106RK · Substantial damageNTSB CEN19LA173Accident · Minor injuriesClass 3 · LimitedFinal reportJust Highlander · Quinlan, TXThe pilot's decision to depart with minimal runway available and his improper soft-field takeoff procedure, which resulted in impact with trees due to a slow airspeed and settling effect during climb out.Jun 13, 2019 · N324SB · Substantial damageNTSB ERA19FA193Accident · 2 fatalField investigationFinal reportCessna 182 · Maitland, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel starvation.Jun 12, 2019 · N3051Y · Substantial damageNTSB WPR19LA167Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20V · Phoenix, AZThe partial loss of engine power during cruise flight for reasons that could not be determined with the available evidence.Jun 11, 2019 · N576CM · Substantial damageNTSB WPR19TA162Accident · Minor injuriesClass 3Final reportBeech 35 · Medford, ORThe pilot’s mismanagement of fuel onboard, which resulted in a total loss of engine power due to fuel starvation.Jun 8, 2019 · N602BH · Substantial damageNTSB GAA19WA357Accident · 1 fatalForeign investigationS.A.N. Jodel D-11 · La Cote, Switzerland, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a S.A.N. Jodel D-11 airplane that occurred on May 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…May 30, 2019 · HB-SFR · Substantial damageNTSB ANC19WA020Accident · 2 fatalForeign investigationCessna 170 · Whitehorse, CanadaMay 28, 2019 · N4512C · DestroyedNTSB WPR19LA155Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Garberville, CAA total loss of engine power for reasons that could not be determined based on the available information.May 26, 2019 · N8746S · Substantial damageNTSB CEN19FA148Accident · 2 fatalClass 2 · FieldFinal reportCessna S550 · Greenfield, INThe pilot's failure to fully advance the power levers during the takeoff and initial climb, which led to his failure to maintain sufficient airspeed and resulted in the exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.May 22, 2019 · N311G · DestroyedNTSB WPR19FA150Accident · 1 fatalClass 3 · FieldFinal reportBeech 35 · Melba, IDThe pilot's loss of control during a low-level aerobatic maneuver, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment due to the effects of alcohol and antidepressant medication.May 19, 2019 · N1888D · Substantial damageNTSB WPR19LA165Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210 · Medford, ORA total loss of engine power due to fuel starvation.May 15, 2019 · N732DK · Substantial damageNTSB GAA19WA275Accident · 2 fatalForeign investigationBeech F33 · Campo Grande County, BrazilMay 15, 2019 · PR-BHF · DestroyedNTSB GAA19WA291Accident · 2 fatalForeign investigationCessna T210 · Mahahual, Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA T210 airplane that occurred on May 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…May 12, 2019 · XB-OYJ · Substantial damageNTSB CEN19WA254Accident · Minor injuriesForeign investigationCirrus SR22 · Abergavenny, United KingdomOn May 12, 2019, about 0930 coordinated universal time (UTC), a Cirrus Aircraft SR22T airplane, Guernsey registration 2-RORO, serial number 701, was destroyed during a forced landing and postimpact fire following a loss of engine power shortly after takeoff…May 12, 2019 · 2-RORO · DestroyedNTSB GAA19CA258Accident · Serious injuriesData collectionFinal reportCessna 172 · Dexter, MIThe airplane's failure to maintain a climb for reasons that could not be determined based on the available evidence.May 11, 2019 · N21794 · Substantial damageNTSB GAA19CA257Accident · Minor injuriesData collectionFinal reportCessna 182 · Glades Park, COThe pilot's failure to maintain adequate airspeed and climb rate during takeoff in high-density altitude conditions, which resulted in his failure to clear power lines.May 11, 2019 · N6314B · Substantial damageNTSB CEN19FA139Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Moose Lake, MNThe pilot’s failure to maintain control of the airplane after departing into a snowstorm.May 8, 2019 · N111JP · Substantial damageNTSB WPR19FA133Accident · 1 fatalClass 2 · FieldFinal reportJust JA30 Superstol · Chelan, WAThe pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and spin.May 6, 2019 · N825PW · DestroyedNTSB ERA19FA164Accident · 1 fatalField investigationFinal reportPiper PA28 · Foley, ALA partial loss of engine power due to a stuck exhaust valve and the flight instructor's exceedance of the airplane's critical angle of attack following the loss of power, which resulted in an aerodynamic stall at low altitude.May 6, 2019 · N5542U · DestroyedNTSB DCA19WA148Accident · 41 fatalForeign investigationSukhoi RRJ95 · Moscow, RussiaThe MAK of Russia has notified the NTSB of an accident involving a Sukhoi RRJ95 airplane that occurred on May 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the MAK's investigation under the provisions of ICAO Annex 13 as State of…May 5, 2019 · RA89098 · DestroyedNTSB CEN19FA135Accident · Serious injuriesClass 2 · FieldFinal reportPiper PA34 · Anderson, INThe loss of left engine power due to an incorrectly adjusted fuel servo and the airplane's nose up trim which resulted in the airplane steep climb, loss of airspeed, and aerodynamic stall and subsequent impact with terrain.May 5, 2019 · N999CR · Substantial damageNTSB WPR19LA171Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Deer Park, WAAn empennage flutter event for reasons that could not be determined based on the available information.May 3, 2019 · N2839V · Substantial damageNTSB GAA19WA249Accident · Minor injuriesForeign investigationGrumman AA1 · Grena, Denmark, DenmarkThe government of Denmark has notified the NTSB of an accident involving a GRUMMAN AA1 airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the provisions of…May 3, 2019 · OY-CLH · DestroyedNTSB WPR19LA129Accident · Serious injuriesClass 3 · LimitedFinal reportStorch FL-156C · Upland, CAThe pilot’s improper installation of the No. 3 cylinder valve cover, which resulted in an oil leak, oil starvation, and a subsequent total loss of engine power.May 1, 2019 · N156LZ · Substantial damageNTSB WPR19LA128Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Sedona, AZThe partial loss of engine power due to deteriorated O-rings in the throttle metering assembly. Contributing to the accident was non-compliance with the manufacturer's recommended throttle metering assembly overhaul schedule.May 1, 2019 · N6864Q · Substantial damageNTSB ENG19WA024Incident · No injuriesForeign investigationBoeing 767 · London, United KingdomThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 767-322, which occurred on April 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…Apr 29, 2019 · N657UA · Minor damageNTSB ENG19WA023Incident · No injuriesForeign investigationBoeing 767 · Johannesburg, South AfricaThe Government of South Africa has notified the NTSB of an incident involving an Air Zimbabwe Boeing 767-2NOER with Pratt & Whitney PW4056 engines on April 28, 2019. The NTSB has appointed an Accredited Representative in accordance with the provisions of ICAO…Apr 28, 2019 · Z-WPF · No damageNTSB WPR19FA121Accident · 2 fatalClass 3 · FieldFinal reportTL Ultralight Sro Stingsport · Madera, CAThe pilot's exceedance of the airplane's critical angle of attack during the simulated engine failure on initial climb after takeoff, which resulted in an aerodynamic stall and subsequent loss of control at too low of an altitude to recover.Apr 25, 2019 · N797N · DestroyedNTSB CEN19FA122Accident · 2 fatalClass 3 · FieldFinal reportRans S7 · Kingsland, TXThe exceedance of the airplane's critical angle of attack during a steep climb after takeoff, which resulted in an aerodynamic stall and spin into terrain.Apr 21, 2019 · N25TX · DestroyedNTSB WPR19FA115Accident · 1 fatalClass 3 · FieldFinal reportBeech 60 · Fullerton, CAThe pilot’s use of an unapproved elevator control lock device, and his failure to remove that device and correctly position the elevator before flight, which resulted in a loss of control during takeoff. Contributing to the accident was his failure to perform…Apr 19, 2019 · N65MY · DestroyedNTSB GAA19CA268Accident · No injuriesData collectionFinal reportPiper PA32 · SaipanThe airplane’s collision with a bird during the initial climb, which resulted in the engine cowling separating and impacting the empennage.Apr 19, 2019 · N4599X · Substantial damageNTSB CEN19LA121Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Omaha, NEA partial loss of engine power for reasons that could not be determined based on the available evidence.Apr 16, 2019 · N109PD · Substantial damageNTSB ENG19RA019Incident · No injuriesForeign investigationAvro 146 · Tambo International Airport, South AfricaThe South Africa Accident and Incident Investigation Division (AIID) has notified the United States, as the State of Design and Manufacture for the Engines, of an engine in-flight shut down incident involving a BAE Aero 146 RJ85A, ZS-SSJ, that occurred near…Apr 12, 2019 · ZS-SSJ · No damageNTSB WPR19FA106Accident · 2 fatalClass 3 · FieldFinal reportTecnam P2002 · Santa Fe, NMThe flight instructor’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control.Apr 8, 2019 · N118LS · DestroyedNTSB ERA19LA144Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Clover, VAThe pilot's inadequate visual lookout, which resulted in a collision with trees. Contributing to the accident was the pilot’s decision to takeoff at night without adequate runway lighting.Apr 7, 2019 · N4047H · DestroyedNTSB ENG19WA017Incident · No injuriesForeign investigationAirbus A320 · Pune, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 2, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…Apr 2, 2019 · VT-ITG · No damage