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 DCA21WA173IncidentClass 5 · ForeignBoeing 737 · Caracas, VenezuelaJun 28, 2021 · YV-3158 · No damageNTSB WPR21LA249Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20F · Marion, MTThe pilot’s improper rotation during takeoff from a high-altitude airport and his failure to abort the takeoff, which resulted in an impact with trees and terrain. Contributing to the accident was the pilot’s improper management of the turbocharger, which…Jun 27, 2021 · N9613M · Substantial damageNTSB ENG21WA029IncidentClass 5 · ForeignBoeing 737 · Ciudad de México, MexicoJun 27, 2021 · N875AMNTSB WPR21LA248Accident · No injuriesClass 4 · LimitedFinal reportDewsnup Dave Zenair CH 701 SP · Chester, CAThe pilot’s failure to properly position of the fuel selector valve, which resulted in a loss of engine power during initial climb due to fuel starvation.Jun 26, 2021 · N41XY · Substantial damageNTSB GAA21WA152Accident · No injuriesClass 5 · ForeignCessna 208 · Teuge, NetherlandsJun 25, 2021 · PH-FST · Substantial damageNTSB CEN21LA293Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Porter, TXThe pilot’s decision to continue the takeoff with degraded engine performance, which resulted in an inability to climb and a subsequent forced landing. The reason for the engine’s degraded performance could not be determined based on available information.Jun 25, 2021 · N4216J · Substantial damageNTSB WPR21LA237Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182P · Warren, IDThe pilot's decision to continue the approach for landing with excess airspeed, which resulted in an aborted landing and subsequent collision with trees.Jun 21, 2021 · N2087F · DestroyedNTSB DCA21WA165IncidentClass 5 · ForeignBoeing 787-9 · Sydney, AustraliaJun 21, 2021 · VH-ZNH · No damageNTSB GAA21WA161Accident · 1 fatalClass 4 · ForeignBeech V35 · Padua, ItalyJun 19, 2021 · I-BMBN · DestroyedNTSB GAA21WA151Accident · No injuriesClass 5 · ForeignCessna 188 · Bataypora, BrazilJun 18, 2021 · PR-ACK · Substantial damageNTSB ERA21LA261Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jupiter, FLThe flight instructor’s failure to obtain the proper touchdown point during a forced landing. Contributing to the accident was the improper service and subsequent inadequate inspection of the single-drive, dual magneto, which resulted in a total loss of…Jun 18, 2021 · N2797E · Substantial damageNTSB WPR21FA228Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · Truckee, CAThe student pilot’s exceedance of the airplane’s critical angle of attack during a turn and the flight instructor’s delayed remedial action, resulting in an aerodynamic stall and a subsequent impact with terrain.Jun 15, 2021 · N89423 · Substantial damageNTSB CEN21LA265Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180K · Columbus, OHThe loss of engine power due to fuel starvation resulting from sealant contamination in the wing.Jun 14, 2021 · N13159 · Substantial damageNTSB GAA21WA143Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Auckland, New ZealandJun 12, 2021 · ZK-HVX · Substantial damageNTSB CEN21LA260Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Denton, TXThe flight instructor and student pilot’s failure to properly manage the airplane’s available fuel resulting in fuel starvation.Jun 10, 2021 · N4147J · Substantial damageNTSB ERA21LA241Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Robbinsville, NJThe pilot’s mismanagement of fuel, which resulted in a total loss of engine power.Jun 6, 2021 · N79RG · Substantial damageNTSB ERA21FA239Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 1-35 · Wurtsboro, NYThe pilot’s low-altitude release from tow for reasons that could not be determined, and his subsequent exceedance of the glider’s critical angle of attack while returning to the runway, which resulted in an aerodynamic stall and impact with terrain.Jun 6, 2021 · N2878H · Substantial damageNTSB GAA21WA136Accident · Minor injuriesClass 5 · ForeignAir Tractor AT301 · Cienaga - Magdalena, ColombiaJun 4, 2021 · HK-4953 · Substantial damageNTSB CEN21LA250Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV9 · West Portsmouth, OHThe pilot’s improper use of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation.Jun 4, 2021 · N20YY · Substantial damageNTSB CEN21LA249Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Justin, TXThe loss of engine power for undetermined reasons based upon the available information.Jun 4, 2021 · N8208N · Substantial damageNTSB WPR21LA213Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cashmere, WAA total loss of engine power shortly after takeoff for reasons that could not be determined based on the available information.May 31, 2021 · N7159B · Substantial damageNTSB ERA21FA234Accident · 7 fatalClass 3 · FieldFinal reportCessna 501 · Smyrna, TNThe pilot’s loss of airplane control during climb due to spatial disorientation.May 29, 2021 · N66BK · DestroyedNTSB CEN21LA247Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Flint, MIThe pilot’s failure to adequately monitor his fuel quantity during flight which resulted in a partial loss of engine power due to fuel starvation.May 29, 2021 · N3992W · Substantial damageNTSB DCA21WA143Accident · Serious injuriesClass 5 · ForeignBoeing 767 · Yesan, South KoreaMay 28, 2021 · HL7528 · No damageNTSB WPR21FA210Accident · 1 fatalClass 3 · FieldFinal reportMark Coby Early Bird Jenny · Stoneville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and a loss of control.May 27, 2021 · N831HC · DestroyedNTSB WPR21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Hollister, CAThe improper installation of a relief valve spring that was shorter than the standard spring length, which slowed the response of the propeller governor to change the pitch of the blades during climbout, resulting in a partial loss of power.May 26, 2021 · N75016 · Substantial damageNTSB ERA21LA226Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Lincoln Park, NJThe pilot's loss of directional control during an aborted landing in crosswind conditions.May 23, 2021 · N16528 · Substantial damageNTSB CEN21LA226Accident · Serious injuriesClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Hampshire, ILThe flight instructor’s failure to maintain aircraft control resulting in the exceedance of the glider’s critical angle of attack following the breakage of the weak/safety link during a winch launch, which resulted in an aerodynamic stall and spin, and…May 16, 2021 · N41CR · Substantial damageNTSB WPR21LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Las Vegas, NVThe flight instructor’s failure to compensate for a downdraft during takeoff, which resulted in a loss of control and collision with terrain.May 15, 2021 · N1996T · Substantial damageNTSB ERA21LA223Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 601 XL · McKenzie, TNThe improper installation and inspection of the propeller, which resulted in an in-flight separation of the propeller assembly.May 15, 2021 · N493TG · Substantial damageNTSB CEN21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportBeech B24R · New Lenox, ILThe total loss of engine power due to fuel contamination as a result of the pilot’s improper fueling of the airplane.May 13, 2021 · N9199S · Substantial damageNTSB WPR21LA200Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164C · Glenn, CAThe pilot’s fuel mismanagement, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.May 12, 2021 · N6596K · Substantial damageNTSB DCA21WA136Incident · No injuriesClass 5 · ForeignBoeing 777 · Cayo Coco, CubaMay 11, 2021 · VQ-BJA · Minor damageNTSB CEN21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 23 · Hutchinson, KSThe pilot’s failure to abort the takeoff and his high pitch attitude after takeoff, which resulted in an exceedance of the critical angle of attack and a subsequent aerodynamic stall.May 1, 2021 · N2378Z · Substantial damageNTSB ERA21FA194Accident · 3 fatalClass 3 · FieldFinal reportBeech C23 · Middleburg, FLThe pilot's decision to depart from a soft grass runway with a tailwind, which resulted in an increased takeoff distance and subsequent impact with trees during the initial climb.Apr 28, 2021 · N6009U · DestroyedNTSB CEN21LA200Accident · 1 fatalClass 3 · LimitedFinal reportAeropro CZ S R O A240 · Richmond, INThe noninstrument-rated pilot’s intentional flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of airplane control.Apr 25, 2021 · N417R · DestroyedNTSB DCA21WA139Incident · No injuriesClass 5 · ForeignBoeing 737 · Rotterdam, NetherlandsApr 24, 2021 · PH-XRX · No damageNTSB WPR21LA171Accident · Minor injuriesClass 3 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Twentynine Palms, CAA partial loss of engine power due to inadequate ignition from cracked spark plugs and a failed magneto.Apr 21, 2021 · N2989P · Substantial damageNTSB WPR21FA170Accident · 1 fatalClass 3 · FieldFinal reportConsolidated Vultee BT-13A · Camas, WAThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, resulting in an aerodynamic stall and impact with terrain.Apr 21, 2021 · N53331 · Substantial damageNTSB CEN21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Curtis, NEWater contamination of the airplane’s fuel supply which resulted in a total loss of engine power.Apr 19, 2021 · N2955D · Substantial damageNTSB GAA21WA076Accident · 1 fatalClass 4 · ForeignPiper PA-31-350 · South Bimini, BahamasApr 17, 2021 · N827RD · Substantial damageNTSB CEN21LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · North Vernon, INThe pilot’s improper installation of the fuel selector handle, which resulted in a total loss of engine power due to fuel starvation.Apr 17, 2021 · N19D · Substantial damageNTSB ERA21LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna A188 · Dover, NCA total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft. Contributing to the accident was the hard touchdown during the forced landing.Apr 15, 2021 · N731TB · Substantial damageNTSB CEN21LA188Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Tishomingo, OKThe pilot’s decision to abort the takeoff on encountering a wind gust and his landing beyond the end of the runway that resulted in the airplane impacting a ditch collapsing the nose landing gear.Apr 10, 2021 · N439WT · Substantial damageNTSB CEN21LA185Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot’s failure to maintain directional control during the rejected takeoff with a left quartering crosswind that shifted to a tailwind.Apr 7, 2021 · N21175 · Substantial damageNTSB CEN21LA176Accident · No injuriesClass 3 · LimitedFinal reportBeech B35 · Pearland, TXThe partial loss of engine power due to a crack in the No. 1 cylinder for unknown reasons.Apr 3, 2021 · N5240C · Substantial damageNTSB GAA21WA062Accident · 1 fatalClass 5 · ForeignCessna 182 · Colon and El Marques, Queretaro, MexicoApr 1, 2021 · C-GBQA · Substantial damageNTSB ERA21LA162Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 1730 · Bessemer, ALThe pilot’s failure to maintain control of the airplane, which resulted in an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall.Mar 26, 2021 · N93638 · Substantial damageNTSB ENG21LA023IncidentClass 3 · LimitedFinal reportBombardier CL-600-2C10 · North Canton, OHMoisture ingression thru the window humpseal coming into contact with the terminal block braid wires.Mar 26, 2021 · N709PS · Minor damageNTSB WPR21LA139Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Twin Falls, IDThe pilot’s failure to maintain airplane control during initial climb with a crosswind when the airspeed decreased, the airplane exceeded its critical angle of attack and aerodynamical stalled at too low an altitude for the pilot to recover before the…Mar 18, 2021 · N1956W · Substantial damage