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 ERA12WA099Accident · 4 fatalForeign investigationCessna 210 · Cuiaba, BrazilOn November 12, 2011, about 2000 universal coordinated time, a Cessna 210N, Brazilian registration PT-VMG, was substantially damaged when it impacted terrain shortly after takeoff in Cuiaba Municipality, State of Mato Grosso, Brazil. The Brazilian…Nov 12, 2011 · PT-VMG · Substantial damageNTSB DCA12CA043Accident · No injuriesData collectionFinal reportAirbus Industrie A320 211 · Minneapolis, MNIn-flight collision with birds during initial climb, which resulted in substantial damage to the aircraft.Nov 10, 2011 · N331NW · Substantial damageNTSB CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.Nov 10, 2011 · N337LC · DestroyedNTSB WPR12LA032Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Williams, CAA total loss of engine power during takeoff initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Nov 8, 2011 · N325BR · Substantial damageNTSB WPR12LA030Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Cheyenne, WYThe flight crew’s failure to properly latch the cabin door before takeoff.Nov 8, 2011 · N39EH · Substantial damageNTSB ANC12LA002Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Kwigillingok, AKThe pilot's failure to abort the takeoff when he realized the airplane could not attain sufficient takeoff and climb performance and his improper decision to depart from an airport where night operations were prohibited.Nov 7, 2011 · N6314H · Substantial damageNTSB ERA12LA071Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S205-22R · Okeechobee, FLA partial loss of engine power due to a failure of the drive bearings in the alternator drive system. Contributing to the accident was the inadequate maintenance.Nov 5, 2011 · N729WA · Substantial damageNTSB ERA12FA062Accident · 2 fatalField investigationFinal reportBeech D-45 · Williston, FLThe flight instructor's failure to maintain airspeed in changing wind conditions during a steep climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor’s ostentatious display close to the ground.Nov 5, 2011 · N34KT · Substantial damageNTSB CEN12LA049Accident · Serious injuriesLimited investigationFinal reportBrochetti Louis Pietenpol Aircamper · Vienna, OHThe loss of engine power during climb after takeoff due to carburetor icing.Oct 29, 2011 · N486LB · Substantial damageNTSB ERA12LA048Accident · No injuriesLimited investigationFinal reportBeech C23 · Columbia, MSThe partial loss of engine power for undetermined reasons during takeoff.Oct 23, 2011 · N89MH · Substantial damageNTSB ENG12IA003Incident · No injuriesIncident investigationFinal reportBoeing 747-451 · Detroit, MIThe penetration of turbine blade fragments through the rear turbine case, which punctured the No. 4 bearing oil pressure supply tube, allowing misted oil to contact the hot engine case and ignite the undercowl fire. Contributing to the incident was the…Oct 23, 2011 · N661US · Minor damageNTSB ERA12LA034Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Newnan, GAA total loss of engine power for undetermined reasons.Oct 17, 2011 · N828MA · Substantial damageNTSB CEN12CA026Accident · Serious injuriesData collectionFinal reportJantzen Evans VP · Terrell, TXThe pilot’s inadequate preflight planning, in that he did not determine whether the airplane’s climb performance would be sufficient to clear obstacles before initiating take off.Oct 16, 2011 · N331EJ · Substantial damageNTSB WPR12LA013Accident · Minor injuriesLimited investigationFinal reportMiller Avid Flyer · Susanville, CAA total loss of engine power during the takeoff climb for undetermined reasons.Oct 15, 2011 · N4077B · Substantial damageNTSB WPR12LA009Accident · No injuriesLimited investigationFinal reportSpink Robert M Pietenpol Aircamper · San Rafael, CAA total loss of engine power during the takeoff climb due to fuel starvation, which resulted from the incorrect installation location of the fuel tank supply line screen that allowed debris to partially block the fuel supply line.Oct 13, 2011 · N762S · Substantial damageNTSB ERA12FA051Accident · 1 fatalField investigationFinal reportCessna 150F · Moncks Corner, SCThe debilitating effects of ethylene glycol poisoning, which resulted in the pilot’s inability to maintain control of the airplane.Oct 13, 2011 · N3086X · Substantial damageNTSB CEN12LA014Accident · Serious injuriesLimited investigationFinal reportPeck Zodiac 601XL · Traverse City, MIA loss of engine power for undetermined reasons.Oct 11, 2011 · N4595P · Substantial damageNTSB CEN12LA012Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Easton, MODebris in the fuel system, which resulted in a loss of engine power due to fuel starvation. Also causal was the pilot not maintaining sufficient airspeed, which resulted in an aerodynamic stall.Oct 8, 2011 · N27492 · Substantial damageNTSB ERA12CA015Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Elizabethton, TNThe failure of the pilot to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.Oct 7, 2011 · N3491Z · Substantial damageNTSB ERA12LA011Accident · 1 fatalLimited investigationFinal reportRivers William J KR-2 · Wytheville, VAThe pilot's failure to maintain control, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's lack of experience in the airplane make and model.Oct 6, 2011 · N7026G · Substantial damageNTSB ERA12FA006Accident · 1 fatalField investigationFinal reportHarry L. Weber Arion LI · Hedgesville, WVAn aerodynamic stall at low altitude due to the pilot’s acute cardiac event.Oct 5, 2011 · N747HW · Substantial damageNTSB CEN12LA008Accident · Serious injuriesLimited investigationFinal reportJohnston William Alfred JR Kolb Mark III · Versailles, MOA loss of engine power due to adjustments and modifications that the pilot made to the engine and airplane.Oct 5, 2011 · N9144E · Substantial damageNTSB WPR12FA001Accident · 2 fatalField investigationFinal reportVaughn Pulsar · West Jordan, UTThe pilot’s failure to maintain sufficient airspeed and airplane control while initiating a turn during the initial climb after takeoff in a high density altitude environment, above the airplane’s maximum allowable gross weight, and with an overly rich…Oct 4, 2011 · N91BV · Substantial damageNTSB ERA12MA005Accident · 2 fatalMajor investigationFinal reportBell 206B · New York, NYThe pilot's failure to anticipate and correct for conditions (high gross weight, low indicated airspeed, and a right downwind turn) conducive to loss of tail rotor effectiveness (LTE), which resulted in LTE and an uncontrolled spin. Contributing to the…Oct 4, 2011 · N63Q · Substantial damageNTSB ERA12LA001Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Ridgefield, CTThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Oct 1, 2011 · N231EB · Substantial damageNTSB ERA11CA506Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Montgomery, NYA total loss of engine power due to fuel starvation as a result of the pilots’ inadequate fuel management.Sep 27, 2011 · N6800W · Substantial damageNTSB WPR11LA463Accident · No injuriesLimited investigationFinal reportCessna 177 · Rock Springs, WYThe pilot did not lean the fuel mixture prior to takeoff, which resulted in the engine's inability to attain sufficient power due to the rich mixture, and his inadequate preflight planning.Sep 23, 2011 · N3152T · Substantial damageNTSB ERA11LA502Accident · Serious injuriesLimited investigationFinal reportCessna P210N · South Deerfield, MAThe failure of the electrical system due to an alternator failure during flight in instrument meteorological conditions, and the pilot’s inadequate preflight inspection and failure to use the approved checklist for the dual alternator system. Contributing to…Sep 23, 2011 · N210LE · Substantial damageNTSB WPR11LA460Accident · Serious injuriesLimited investigationFinal reportPiper PA23 · Truckee, CAThe pilot's failure to maintain an airspeed at or above the airplane's minimum controllable airspeed, which resulted in a loss of airplane control. Contributing to the accident was the partial loss of power from the left engine as a result of a clogged fuel…Sep 21, 2011 · N62792 · Substantial damageNTSB WPR11FA453Accident · Serious injuriesField investigationFinal reportDacey Venture · Reno, NVA total loss of engine power during the initial climb due to the pilot’s premature activation of the engine's anti-detonant injection system.Sep 15, 2011 · N521XD · Substantial damageNTSB ANC11LA103Accident · No injuriesLimited investigationFinal reportCessna U206G · Beluga, AKThe total loss of engine power for an undetermined reason.Sep 15, 2011 · N1779R · Substantial damageNTSB ANC11CA098Accident · No injuriesData collectionFinal reportCessna 180A · McGrath, AKThe pilot's loss of control when encountering a downdraft during the initial climb after takeoff, resulting in a collision with terrain.Sep 14, 2011 · N7814A · Substantial damageNTSB WPR11CA442Accident · Minor injuriesData collectionFinal reportAir Creation Tanarg · Corvallis, ORThe pilot's failure to maintain clearance from an obstacle while taking off with a gusting crosswind.Sep 9, 2011 · N5628K · Substantial damageNTSB CEN11CA678Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Buena Vista, COThe airplane’s diminished climb performance due to the pilot not leaning the engine mixture enough prior to takeoff in high density altitude conditions and at nearly maximum gross takeoff weight.Sep 6, 2011 · N9430J · Substantial damageNTSB ERA11CA485Accident · Minor injuriesData collectionFinal reportHaines Joseph E SHA-GLASAIR · Beaufort, NCThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.Sep 5, 2011 · N334JH · Substantial damageNTSB WPR11FA428Accident · 2 fatalField investigationFinal reportVeatch Kitfox · Caldwell, IDThe pilot’s failure to prevent a low-altitude stall and spin following a complete loss of engine power during the initial climb after takeoff.Sep 4, 2011 · N624JS · Substantial damageNTSB CEN11FA616Accident · 2 fatalField investigationFinal reportLarson Ken W Christen EAGLE-II · Seward, NEThe pilot’s inadvertent pulling of the mixture control lever on takeoff, which shut down the engine.Sep 4, 2011 · N88CE · Substantial damageNTSB ERA11LA483Accident · Minor injuriesLimited investigationFinal reportDurling James RV-6A · Hollywood, FLParticulate ingestion from the engine, which resulted in the malfunction of the propeller governor during the airplane’s initial climb.Sep 3, 2011 · N241BD · Substantial damageNTSB CEN11LA618Accident · No injuriesLimited investigationFinal reportVicari Waiex · Marion, ILThe partial loss of engine power during initial climb for undetermined reasons.Sep 2, 2011 · N100VY · Substantial damageNTSB ERA11FA480Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot’s failure to maintain adequate clearance from trees and terrain during the initial climb. Contributing was spatial disorientation due to a vestibular illusion and the pilot’s likely impairment due to alcohol consumption.Sep 1, 2011 · N6249C · DestroyedNTSB ANC11CA089Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cape Yakataga, AKThe pilot inadvertently switching off the engine magnetos during the initial climb, resulting in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches.Aug 30, 2011 · N82448 · Substantial damageNTSB WPR11CA409Accident · Serious injuriesData collectionFinal reportCessna 170A · Grangeville, IDThe pilot's loss of directional control for undetermined reasons.Aug 28, 2011 · N1238D · Substantial damageNTSB CEN11LA605Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Freeport, ILThe pilot's decision to operate the airplane with a known defect in the elevator control system that led to his inability to control the airplane during the initial climb.Aug 26, 2011 · N7070L · Substantial damageNTSB WPR11FA403Accident · No injuriesField investigationFinal reportBeech A23-24 · Palo Alto, CAThe student’s and flight instructor’s mismanagement of the fuel supply, resulting in a total loss of engine power due to fuel starvation.Aug 23, 2011 · N5779V · Substantial damageNTSB CEN11LA558Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Alpine, TXThe pilot’s improper flare which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to fly the airplane with a known mechanical deficiency.Aug 22, 2011 · N8076J · Substantial damageNTSB CEN11LA585Accident · 1 fatalLimited investigationFinal reportAero Commander Callair A-9B · Marshall, MIThe towplane pilot's loss of control during an aerotow operation due to the glider pilot's inability to maintain a proper position behind the towplane while encountering turbulence on initial climb.Aug 21, 2011 · N7638V · Substantial damageNTSB CEN11LA556Accident · No injuriesLimited investigationFinal reportGrumman G-164A · El Campo, TXSeparation of the No. 3 cylinder exhaust valve rocker arm, which resulted in a loss of engine power.Aug 18, 2011 · N6567 · Substantial damageNTSB ANC11CA082Accident · No injuriesData collectionFinal reportPiper PA-20 · Tyonek, AKThe student pilot’s decision to take off toward a hill with a gusting tailwind. Contributing was the pilot's premature rotation that prevented the airplane from climbing over the hill.Aug 18, 2011 · N7763K · Substantial damageNTSB ERA11LA459Accident · Serious injuriesLimited investigationFinal reportEvans Robert W SR Pegazair 100 · Maysville, NCThe student pilot's failure to maintain adequate airspeed during initial takeoff climb, which resulted in an aerodynamic stall.Aug 17, 2011 · N523RE · Substantial damageNTSB ERA11FA458Accident · 1 fatalField investigationFinal reportCessna 310Q · Tupelo, MSThe pilot’s delayed reaction in performing the engine failure procedures and his failure to maintain adequate airspeed, which resulted in a loss of airplane control. Contributing to the accident was maintenance personnel’s improper torquing of the B-nut…Aug 17, 2011 · N444YM · Substantial damage