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 WPR17LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA 32-260 · Mukilteo, WAThe improper maintenance of the carburetor, which resulted in a stuck float and a partial loss of engine power during takeoff.May 2, 2017 · N3457W · Substantial damageNTSB CEN17FA168Accident · 3 fatalClass 2 · FieldFinal reportPilatus PC 12 · Amarillo, TXThe pilot's loss of airplane control due to spatial disorientation during the initial climb after takeoff in night instrument meteorological conditions and moderate turbulence.Apr 29, 2017 · N933DC · DestroyedNTSB WPR17LA088Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 22-150 · Kernville, CAThe pilot’s exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/mush.Apr 21, 2017 · N9975D · Substantial damageNTSB ERA17FA156Accident · 2 fatalField investigationFinal reportLuscombe 8 · East Windsor, CTThe flying pilot's excessive maneuvering of the airplane at a slow airspeed, which resulted in exceedance of the critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilots' operation of the airplane over its maximum…Apr 18, 2017 · N8554Y · Substantial damageNTSB CEN17RA158Accident · 5 fatalForeign investigationPiper PA31T · Cascais, PortugalOn April 17, 2017, about 1104 hours universal coordinated time, a Piper PA-31T, serial number 31T-8020091, Swiss registration HB-LTI, was destroyed during impact and a postimpact fire following a loss of control during initial climb from runway 17 at the…Apr 17, 2017 · HB-LTI · DestroyedNTSB CEN17LA156Accident · No injuriesLimited investigationFinal reportLoomis Xenon 4 · Knoxville, IAA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.Apr 17, 2017 · N912XV · Substantial damageNTSB ERA17FA155Accident · 4 fatalField investigationFinal reportCessna 170 · Williston, FLThe pilot's failure to maintain adequate airspeed during initial climb in gusty wind conditions, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin.Apr 15, 2017 · N4244V · DestroyedNTSB ERA17CA152Accident · Minor injuriesData collectionFinal reportLazear John T Zenair Stol CH 701 · Windsor Twp, PAThe pilot's improper pretakeoff planning, his failure to maintain adequate airspeed, and his exceedance of the airplane's critical angle of attack during a short-field takeoff with a tailwind, which resulted in an aerodynamic stall.Apr 11, 2017 · N3846T · Substantial damageNTSB ERA17WA142Accident · Serious injuriesForeign investigationQuest Kodiak · Moretecocha, EcuadorOn March 28, 2017, at 1600 Universal Coordinated Time (UTC), a Quest Kodiak 100, Ecuadorian registration HC-CRF, operated by Alas De Socorro, received substantial damage following a collision with trees and terrain during takeoff at Moretecocha Airstrip,…Mar 28, 2017 · HC-CPR · Substantial damageNTSB ERA17FA139Accident · 2 fatalField investigationFinal reportMooney M20J · Aberdeen, MSThe pilot's failure to maintain clearance from terrain after takeoff in dark night conditions for reasons that could not be determined based on the available information.Mar 28, 2017 · N643RJ · Substantial damageNTSB ERA17CA137Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Cleveland, TNThe flight instructor's inadequate supervision, which resulted in a premature rotation for a no-flap takeoff and subsequent loss of airplane control during the initial climb.Mar 26, 2017 · N782JR · Substantial damageNTSB CEN17LA171Accident · Serious injuriesLimited investigationFinal reportJohn Goodman Air Camper · Oronogo, MOA detached throttle cable support block, which resulted in the pilot’s inability to control the throttle and the subsequent stall while maneuvering for an emergency landing.Mar 21, 2017 · N23RT · Substantial damageNTSB WPR17LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA226 · Boise, IDCompany maintenance personnel's failure to remove a screwdriver that was left lodged in the windshield wiper area of the forward fuselage during maintenance and subsequently became dislodged on takeoff/initial climb and collided with a left propeller blade.Mar 20, 2017 · N158WA · Substantial damageNTSB ERA17WA132Accident · Serious injuriesForeign investigationBell 206 · Araucária Municipality, BrazilThe government of Brazil has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on March 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Mar 17, 2017 · PT-YHH · Substantial damageNTSB ERA17LA128Accident · No injuriesLimited investigationFinal reportPiper PA28 · Tampa, FLA collapsed engine induction duct, which resulted in restricted air flow to the engine and a subsequent loss of engine power. Contributing to the accident was the operator's failure to ensure that the correct induction duct was installed.Mar 12, 2017 · N8447R · Substantial damageNTSB CEN17LA117Accident · Serious injuriesLimited investigationFinal reportJude Mike C Side Winder · Paynesville, MNThe pilot’s inadequate preflight inspection, during which he failed to ensure that there was sufficient coolant in the engine reservoir, which resulted in the engine getting too hot and the engine control module shutting down the engine.Mar 4, 2017 · N7524V · Substantial damageNTSB WPR17LA072Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Carson City, NVA total loss of engine power due to internal corrosion of the fuel manifold valve. Also causal was the pilot's decision to return to the runway following the loss of engine power shortly after takeoff, and his exceedance of the airplane's critical angle of…Mar 1, 2017 · N39894 · Substantial damageNTSB ERA17LA122Accident · No injuriesLimited investigationFinal reportXtremeair XA42 · West Palm Beach, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preimpact mechanical failures or malfunctions that would have precluded normal operation.Mar 1, 2017 · N342AW · Substantial damageNTSB ERA17LA113Accident · Serious injuriesLimited investigationFinal reportCirrus SR20 · Daytona Beach, FLThe pilot's inadvertent encounter with instrument meteorological conditions (fog) during initial climb, which resulted in a loss of control due to spatial disorientation.Feb 24, 2017 · N255JB · Substantial damageNTSB ERA17FA112Accident · 1 fatalField investigationFinal reportPiper PA38 · East Haven, CTThe failure of the fuel selector valve in a position that restricted fuel flow to the engine, resulting in a total loss of engine power during initial climb due to fuel starvation. Also causal was the operator's failure to effectively detect and resolve the…Feb 22, 2017 · N2452C · DestroyedNTSB CEN17RA106Accident · 5 fatalForeign investigationRaytheon B200 · Melbourne, AustraliaOn February 20, 2017, at 2159 hours universal coordinated time (0859 hours Australian eastern daylight time on February 21, 2017), a Raytheon model B200 (King Air) airplane, Australian registration VH-ZCR, impacted a building and roadway shortly after takeoff…Feb 20, 2017 · VH-ZCR · DestroyedNTSB CEN17FA108Accident · 1 fatalField investigationFinal reportMacleod Homebuilt · Springfield, OHThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control at an altitude too low for a safe recovery.Feb 19, 2017 · N62888 · DestroyedNTSB ANC17RA055Incident · No injuriesForeign investigationCessna 172 · Giseong-ri, South KoreaOn February 10, 2017, about 0952 local time, a Cessna 172 airplane, Republic of Korea registration number HL1171, operated by a flight school, sustained minor damage following a forced landing in a shallow river near Giseong-ri, Republic of Korea. The pilot…Feb 10, 2017 · HL1171 · Minor damageNTSB ENG17WA012Incident · No injuriesForeign investigationAirbus A320 · Dehli, IndiaOn February 8, 2017, about 1932 local (1402 UTC), a Go Air (Indian air carrier) A320 equipped with Pratt & Whitney PW1127G engines experienced a loss of power in the No. 1 engine. The airplane had to return to Delhi immediately after takeoff because of a low…Feb 8, 2017 · VT-WGB · No damageNTSB ERA17LA102Accident · Serious injuriesClass 3 · LimitedFinal reportShell John Super SIX · Morganton, NCA loss of engine power and impact with trees and terrain for reasons that could not be determined based on the available information.Feb 6, 2017 · N426KS · Substantial damageNTSB ERA17LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · Friendly, MDA total loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage revealed no mechanical malfunctions or failures that would have precluded normal operation.Feb 6, 2017 · N21HD · Substantial damageNTSB CEN17LA098Accident · No injuriesLimited investigationFinal reportRobinson Michael E Cozy Mark IV · Anthony, NMA total loss of engine power during climbout for reasons an examination of the engine and fuel system was not able to determine, which resulted in a forced landing on unsuitable terrain.Feb 1, 2017 · N294MV · Substantial damageNTSB CEN17LA093Accident · No injuriesLimited investigationFinal reportPiper J3C · Brenham, TXThe reciprocating engine's exhaust valve being stuck in the “open” position, which resulted in a partial loss of engine power during initial climb.Jan 30, 2017 · N7039H · Substantial damageNTSB ERA17LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA22 · Georgetown, DEAn in-flight fire for reasons that could not be determined due to extensive thermal damage to the airplane.Jan 28, 2017 · N3659Z · DestroyedNTSB WPR17FA057Accident · 2 fatalField investigationFinal reportBeech 300 · Tucson, AZThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment by the effects of a combination of psychoactive substances.Jan 23, 2017 · N385KA · DestroyedNTSB ERA17LA092Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Beechcraft G36 · West Caldwell, NJThe pilot’s failure to maintain airplane control after takeoff, which resulted in an aerodynamic stall.Jan 21, 2017 · N979BA · DestroyedNTSB WPR17LA056Accident · No injuriesLimited investigationFinal reportBeech 99 · Billings, MTThe fatigue failure of the left main landing gear (MLG) actuator piston rod, which prevented the hydraulic system from producing pressure to control the MLG’s position and led to the right MLG collapsing during landing.Jan 19, 2017 · N326CA · Substantial damageNTSB ERA17CA089Accident · Minor injuriesData collectionFinal reportCessna 182 · Mobile, ALThe pilot’s failure to maintain airplane control during the initial climb.Jan 14, 2017 · N707RB · Substantial damageNTSB CEN17WA087Accident · No injuriesForeign investigationCessna 560 · Gardermoen, NorwayOn January 11, 2017, about 1521 UTC, a Cessna 560, Norwegian registration LN-IDB, experienced a control upset during departure from the Oslo Airport (ENGM), Gardermoan, Norway. The two pilots on board were not injured. The airplane sustained substantial…Jan 11, 2017 · LN-IDB · Substantial damageNTSB ERA17LA078Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Development CH 2000 · Atlanta, GAThe pilot's exceedance of the airplane's critical angle of attack while attempting a short-field takeoff, which resulted in an aerodynamic stall.Jan 5, 2017 · N683AM · Substantial damageNTSB ERA17LA077Accident · No injuriesLimited investigationFinal reportBeech 76 · Dunnellon, FLAn inadequate 100-hour maintenance inspection that failed to detect and correct loose nuts on a single-drive dual magneto, which led to the subsequent separation of the magneto from the engine during initial climb and the total loss of engine power.Dec 30, 2016 · N6627U · Substantial damageNTSB CEN17FA072Accident · 6 fatalField investigationFinal reportCessna 525 · Cleveland, OHControlled flight into terrain due to pilot spatial disorientation. Contributing to the accident was pilot fatigue, mode confusion related to the status of the autopilot, and negative learning transfer due to flight guidance panel and attitude indicator…Dec 30, 2016 · N614SB · DestroyedNTSB WPR17FA041Accident · 2 fatalField investigationFinal reportPetrus David Wayne S90 · Fresno, CAThe pilot's abnormally steep takeoff climb followed by a loss of control and rapid descent to ground impact, for undetermined reasons.Dec 26, 2016 · N176PA · DestroyedNTSB ERA17FA072Accident · 1 fatalField investigationFinal reportPiper PA28 · Middlebury, VTThe pilot's improper decision to return to the airport following a partial or complete loss of engine power during takeoff initial climb and his failure to maintain sufficient airspeed while maneuvering, which resulted in exceedance of the critical angle of…Dec 23, 2016 · N31202 · Substantial damageNTSB ENG17WA007Incident · No injuriesForeign investigationBoeing 767 · Toronto, CanadaOn Dec. 21, 2016, an ElAl Boeing 767-300ER, powered by Pratt & Whitney PW4000 turbofan engines, registration number 4X-EAM, while climbing through 13,000 ft. from Pearson International Airport (YYZ), Toronto, Canada, experienced a loss of power of the right…Dec 21, 2016 · 4X-EAMNTSB WPR17FA035Accident · 1 fatalField investigationFinal reportQuest Kodiak 100 · Moab, UTThe pilot's loss of control shortly after takeoff due to spatial disorientation.Dec 12, 2016 · N772RT · DestroyedNTSB ERA17LA067Accident · Serious injuriesLimited investigationFinal reportMathias Linda B Lightning · Franklin, VAA partial loss of engine power due to pre-ignition damage to the No. 2 cylinder piston and the pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall.Dec 10, 2016 · N59JL · Substantial damageNTSB ERA17LA057Accident · No injuriesLimited investigationFinal reportPiper PA28 · Columbus, GAA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of any anomalies that would have precluded normal operation.Nov 23, 2016 · N41565 · Substantial damageNTSB CEN17LA044Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Bridgeport, TXThe pilot's failure to properly position the fuel selector before takeoff, which resulted a total loss of engine power due to fuel starvation.Nov 23, 2016 · N7392Q · Substantial damageNTSB ANC17LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bethel, AKThe mechanic's failure to install a whistle slot in the engine breather tube, which resulted in a frozen tube, displacement of the crankshaft oil seal, a loss of oil, and smoke in the cockpit, which led to a forced landing.Nov 22, 2016 · N83641 · Substantial damageNTSB WPR17FA024Accident · 4 fatalField investigationFinal reportPiper PA 31T · Elko, NVA loss of engine power to the left engine for reasons that could not be determined due to the extensive fire and impact damage to the airplane.Nov 19, 2016 · N779MF · DestroyedNTSB ERA17FA050Accident · 2 fatalField investigationFinal reportCurtiss JN4 · Williamson, GAThe in-flight failure of the propeller due to excessive engine vibration loads and the use of an incorrectly-sized propeller, which resulted in a fatigue crack of the leading edge strip. Contributing to the accident was the inadequate repair of the propeller…Nov 17, 2016 · N1662 · DestroyedNTSB WPR17WA219Accident · No injuriesForeign investigationCessna 208 · Solomon, AustraliaOn November, 16, 2016, about 7:51, Australian western standard time, a Cessna 208B airplane, VH-LNH, landed on a road near Solomon Aerodrome, Solomon, Western Australia, following an engine failure. The flight crew of 2 and 11 passengers were not injured. The…Nov 16, 2016 · VH-LNH · Substantial damageNTSB CEN17LA041Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Port Allen, LAThe total loss of engine power due to fuel starvation, which resulted from debris in the fuel selector valve restricting the fuel flow to the engine and led to a forced landing on rough terrain.Nov 13, 2016 · N329CT · Substantial damageNTSB ANC17LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA32R · Bethel, AKA total loss of engine power due to oil starvation, which resulted from an oil cooler leak at a fractured brazed seam.Nov 12, 2016 · N9084J · Substantial damage