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 CEN21LA400Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Fort Wayne, INThe total loss of engine power after takeoff due to the formation of carburetor ice while on the ground and the pilot’s failure to apply carburetor heat immediately before takeoff.Sep 4, 2021 · N2071K · Substantial damageNTSB GAA21WA228Accident · Serious injuriesClass 3 · ForeignBritten Norman BN2A · Kuserua, EcuadorAug 28, 2021 · HC-CMQNTSB CEN21LA390Accident · Minor injuriesClass 3 · LimitedFinal reportMantooth Thorp T-18 · San Antonio, TXThe loss of engine power after takeoff for undetermined reasons.Aug 28, 2021 · N78DW · Substantial damageNTSB WPR21LA326Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Del Mar, CAThe partial loss of engine power for reasons that could not be determined, which resulted in a forced landing on an interstate highway and subsequent collision with vehicles.Aug 24, 2021 · N2843T · Substantial damageNTSB GAA21WA265AccidentClass 5 · ForeignPiper PA-19 · Lille Marcq en Baro, FranceAug 23, 2021 · F-HLOG · DestroyedNTSB GAA21WA221Accident · Minor injuriesClass 5 · ForeignPilatus PC6 · Maturin, VenezuelaAug 21, 2021 · YV-1912 · DestroyedNTSB CEN21FA377Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Fort Worth, TXThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s inadequate preflight planning, which resulted in an exceedance of the airplane’s…Aug 21, 2021 · N1472E · Substantial damageNTSB ERA21FA334Accident · 1 fatalClass 3 · FieldFinal reportNorth American SNJ-2 · Wilkes-Barre, PAA partial loss of engine power for undetermined reasons. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for a forced landing following the loss of engine power, which resulted in an aerodynamic stall and…Aug 20, 2021 · N52900 · DestroyedNTSB ERA21FA333Accident · 2 fatalClass 3 · FieldFinal reportPiper PA24 · Wadesboro, NCA partial loss of engine power during takeoff for reasons that could not be determined. Contributing was the pilot’s loss of airplane control, resulting in an aerodynamic stall and impact with trees and terrain.Aug 20, 2021 · N8262P · DestroyedNTSB ERA21LA335Accident · No injuriesClass 3 · LimitedFinal reportHummer 260L · Livingston, TNA total loss of engine power for reasons that could not be determined. Contributing to the accident was the pilot’s operation of the helicopter in a flight regime that would not allow for a successful autorotative landing.Aug 18, 2021 · N777TC · Substantial damageNTSB ERA21LA330Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · North Springfield, VTThe check pilot's failure to account for the extended departure distance from the airport during a simulated tow rope break and recovery.Aug 15, 2021 · N2805H · Substantial damageNTSB CEN21LA372Accident · Serious injuriesClass 3 · LimitedFinal reportFlying K Enterprises Sky Raider · Augusta, KSA partial loss of engine power for reasons that could not determined based on available information.Aug 15, 2021 · N56179 · Substantial damageNTSB ANC21LA071Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-14 · Tyonek, AKThe pilot’s failure to maintain directional control and adequate airspeed during takeoff which resulted in a collision with a river. Contributing to the accident was the pilot’s improper decision to load the airplane above its maximum allowable gross weight.Aug 15, 2021 · N4226H · Substantial damageNTSB WPR21LA319Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Panguitch, UTThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance due to high-density altitude conditions. Contributing to the accident was the pilot’s failure to conduct preflight performance planning…Aug 13, 2021 · N1651J · Substantial damageNTSB WPR21LA316Accident · No injuriesClass 3 · LimitedFinal reportBeech 77 · Stanley, NMA loss of engine performance due to lead fouling of the lower spark plugs, which resulted in an off airport forced landing.Aug 12, 2021 · N3873Y · Substantial damageNTSB CEN21LA381Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Wadsworth, OHA partial loss of engine power due to carburetor icing and the pilot’s failure to apply carburetor heat when the power loss occurred.Aug 11, 2021 · N66748 · Substantial damageNTSB CEN21LA369Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Wheeling, ILA partial loss of engine power for reasons that could not be determined based on available information.Aug 11, 2021 · N4043B · Substantial damageNTSB ANC21LA075Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-18 · Talkeetna, AKThe malfunction of the control stick during initial climb for reasons that could not be determined based on available evidence.Aug 10, 2021 · N1264A · Substantial damageNTSB CEN21FA364Accident · 1 fatalClass 3 · FieldFinal reportCessna 210H · Melbourne, ARThe pilot’s failure to maintain control of the airplane with full flaps during the takeoff.Aug 9, 2021 · N5940F · DestroyedNTSB CEN21LA363Accident · No injuriesClass 3 · LimitedFinal reportRotary RAF2000 · Anahuac, TXThe pilot’s incorrect trim system installation, which resulted in a loss of gyroplane control and impact with terrain.Aug 7, 2021 · UNREG · Substantial damageNTSB WPR21LA307Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170A · Metaline Falls, WAThe pilot’s failure to attain sufficient altitude during the initial climb to clear trees due to an encounter with windshear.Aug 6, 2021 · N5459C · Substantial damageNTSB ERA21LA321Accident · No injuriesClass 3 · LimitedFinal reportCubcrafters CC11-160 · Springfield, TNA loss of engine power for undetermined reasons.Aug 6, 2021 · N825ME · Substantial damageNTSB DCA21WA214IncidentClass 5 · ForeignAirbus A319 · Edinburgh, United KingdomAug 6, 2021 · G-DBCF · No damageNTSB ANC21LA070Accident · No injuriesClass 4 · LimitedFinal reportAlaskan Air Adventures SQ2 · Talkeetna, AKThe pilot’s inadvertent movement of the fuel selector valve to a position between the tanks, which resulted in fuel starvation and a subsequent loss of engine power.Aug 5, 2021 · N148CM · Substantial damageNTSB CEN21LA351Accident · Serious injuriesClass 3 · LimitedFinal reportCozy Mark IV · Rushville, NEA total loss of engine power due to an obstruction of airflow to the engine as a result of the landing brake being deployed in flight.Aug 2, 2021 · N1361S · Substantial damageNTSB ANC21LA068Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-1 · Sterling, AKInsufficient available power as a result of low compression in three engine cylinders. Contributing to the accident was the pilot’s decision to takeoff with a slight quartering tailwind.Aug 2, 2021 · N8656K · Substantial damageNTSB ERA21LA310Accident · Serious injuriesClass 3 · LimitedFinal reportLiteflite PTY Dragonfly Model C · Middletown, NYThe improper installation of the carburetor, which resulted in a momentary total loss of engine power during initial climb. Contributing was the pilot’s failure to maintain control of the airplane following the initial power loss.Jul 31, 2021 · N799HG · Substantial damageNTSB DCA21WA205IncidentClass 5 · ForeignBoeing 737 · Perth, AustraliaJul 31, 2021 · UNK · No damageNTSB CEN21FA345Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Hartford, WIThe flight crew’s exceedance of the airplane’s critical angle of attack during a simulated engine failure during initial climb after takeoff, which led to an aerodynamic stall/spin and loss of control. Contributing to the severity of the occupants’ injuries…Jul 31, 2021 · N42522 · Substantial damageNTSB ERA21FA308Accident · Serious injuriesClass 3 · FieldFinal reportRyan Navion · Pensacola, FLA partial loss of engine power during the initial climb, which resulted in a forced, off-airport landing and impact with trees and a fence.Jul 29, 2021 · N114ST · Substantial damageNTSB CEN21LA341Accident · No injuriesClass 4 · LimitedFinal reportCessna T210F · Peyton, COThe pilot’s fuel mismanagement that resulted in a complete loss of engine power during climb and subsequent impact with terrain during a forced landing.Jul 27, 2021 · N6162R · Substantial damageNTSB ERA21LA300Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 140 · Murfreesboro, TNA total loss of engine power as a result of carburetor icing.Jul 26, 2021 · N72129 · Substantial damageNTSB WPR21FA283Accident · 1 fatalClass 3 · FieldFinal reportSiai-Marchetti SM-1019B · Lewiston, IDThe pilot’s failure to remove the flight control lock before departure, which resulted in a loss of airplane control and impact with terrain. Contributing to the accident was his failure to perform an adequate preflight inspection and flight control check…Jul 24, 2021 · N28U · Substantial damageNTSB GAA21WA238Incident · No injuriesClass 5 · ForeignPiper PA31 · Doncaster, United KingdomJul 23, 2021 · G-UKCS · Minor damageNTSB CEN21LA338Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Harrah, OKThe pilot’s decision to fly the airplane without a carburetor heat control in atmospheric conditions conducive to the development of serious carburetor icing, which resulted in a partial loss of engine power.Jul 23, 2021 · N83365 · Substantial damageNTSB ENG21WA033IncidentClass 5 · ForeignBoeing 747-8F · Hone Kong, Hong Kong SAR ChinaJul 20, 2021 · N624UP · Minor damageNTSB CEN21LA329Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Amana, IAThe loss of engine power for reasons that could not be determined.Jul 19, 2021 · N8422K · Substantial damageNTSB CEN21LA325Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35-C33 · Longmont, COThe airplane’s lack of climb performance after takeoff in high density altitude conditions for reasons that could not be determined based on the available evidence.Jul 18, 2021 · N18AR · Substantial damageNTSB CEN21LA326Accident · Serious injuriesClass 3 · LimitedFinal reportGary James Lail Zenith CH 750 Cruzer · Blossom, TXThe improper swaging of the rudder control cable, which disconnected during flight and resulted in the loss of control.Jul 17, 2021 · N9667Z · Substantial damageNTSB ERA21LA288Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland Canada DHC-1 Chipmunk X · Lebanon, TNA total loss of engine power during the initial climb for reasons that could not be determined based on the available evidence.Jul 15, 2021 · N47YC · Substantial damageNTSB WPR21FA270Accident · 2 fatalClass 3 · FieldFinal reportCessna 421C · Monterey, CAThe pilot’s failure to maintain airplane control due to spatial disorientation during an instrument departure procedure in instrument meteorological conditions which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of…Jul 13, 2021 · N678SW · DestroyedNTSB ERA21LA284Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Elba, ALThe partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with trees during takeoff.Jul 11, 2021 · N8172S · Substantial damageNTSB GAA21WA166Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Mikolajki, PolandJul 6, 2021 · SP-CCCNTSB ERA21LA287Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46-500TP · Manteo, NCThe improperly secured pneumatic compressor discharge air (P3) line coupling nut on the engine, which ultimately allowed the nut to back off resulting in a partial loss of engine power.Jul 6, 2021 · N31062 · Substantial damageNTSB CEN21LA309Accident · No injuriesClass 3 · LimitedFinal reportTitan T-51D · Ashtabula, OHThe tripped engine control computer circuit breaker caused by an excessive electrical load on the system, which resulted in a complete loss of engine power during the initial climb.Jul 6, 2021 · N15180 · Substantial damageNTSB WPR21LA260Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5B · Wells, NVThe pilot’s decision to takeoff with a tailwind, which resulted in an impact with terrain.Jul 5, 2021 · N28643 · Substantial damageNTSB ERA21LA277Accident · No injuriesClass 3 · LimitedFinal reportVans RV7 · Pottstown, PAA total loss of power for reasons that could not be determined based on the available information.Jul 4, 2021 · N654C · DestroyedNTSB DCA21FA174Accident · Serious injuriesClass 2 · FieldFinal reportBoeing 737-275C · Honolulu, HIThe flight crewmembers’ misidentification of the damaged engine (after leveling off the airplane and reducing thrust) and their use of only the damaged engine for thrust during the remainder of the flight, resulting in an unintentional descent and forced…Jul 2, 2021 · N810TA · DestroyedNTSB WPR21LA250Accident · No injuriesClass 3 · LimitedFinal reportL-Bird CCX-2000 · Hood River, ORThe total loss of engine power due to improper construction of the muffler, which resulted in separation of the internal components.Jun 28, 2021 · N10TA · Substantial damageNTSB ERA21LA271Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Bentleyville, PAThe flight instructor and student pilot’s inadequate preflight performance planning which resulted in a takeoff attempt with insufficient available runway, a loss of control, and impact with terrain.Jun 28, 2021 · N22307 · Substantial damage