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 CEN15FA214Accident · Serious injuriesField investigationFinal reportBeech B35 · Orange, TXThe impact with power lines for reasons that could not be determined based on the available information.May 2, 2015 · N5176C · Substantial damageNTSB DCA15CA117Accident · No injuriesData collectionFinal reportTitan Aerospace Holdings Solara 50 · Otto, NMstructural failure of the left wing due to an overspeed condition.May 1, 2015 · N950TA · DestroyedNTSB ERA15LA200Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Sylacauga, ALA partial loss of engine power due to the failure of the throttle body/fuel metering unit to provide the engine with adequate fuel pressure for full power operation.Apr 27, 2015 · N248ME · Substantial damageNTSB ERA15LA197Accident · Serious injuriesLimited investigationFinal reportJames Kilroy Pitts Model 12 · LaGrange, GAA partial loss of engine power after takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Apr 22, 2015 · N488WT · Substantial damageNTSB ENG15RA023Incident · No injuriesForeign investigationBoeing 400 · Islamabad, Pakistan, PakistanOn April 21, 2015, a Shaheen Air International (SAI) Boeing 737-400, powered by CFMI CFM56-3C1 turbofan engines, experienced a No. 1 (left engine) failure while climbing through 3,200 feet. The flight crew heard a loud band and high exhaust gas temperature…Apr 21, 2015 · AP-BJT · No damageNTSB WPR15LA167Accident · No injuriesLimited investigationFinal reportBeech F33A · Puyallup, WAA total loss of engine power due to fuel starvation as a result of a mechanic’s failure to properly tighten the B-nut to the fuel pump inlet during a recent annual inspection. Contributing to the accident was the pilot's decision to take off despite…Apr 18, 2015 · N84MD · Substantial damageNTSB CEN15LA199Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Diboll, TXThe total loss of engine power due to the use of an improper fuel type. Contributing to the accident were the servicing of the airplane with the improper fuel, noncompliance with an airworthiness directive, and the fuel nozzle installed on the fueling truck.Apr 17, 2015 · N421PK · Substantial damageNTSB ERA15LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lancaster, NYThe loss of engine power during takeoff for reasons that could not be determined during postaccident examination of the engine or testing of the carburetor.Apr 15, 2015 · N7598R · Substantial damageNTSB ERA15LA184Accident · Serious injuriesLimited investigationFinal reportCessna 162 · Shelter Island, NYThe pilot's failure to attain adequate airspeed after takeoff and his exceedance of the airplane’s critical angle-of-attack during the initial climb, which resulted in an aerodynamic stall at too low an altitude to recover.Apr 13, 2015 · N30283 · Substantial damageNTSB ANC15LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Bettles, AKA total loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no mechanical anomalies that would have precluded normal operation.Apr 13, 2015 · N4697C · Substantial damageNTSB WPR15FA144Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Prescott Valley, AZThe pilot’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack during the initial climb after a ground-tow launch, which resulted in an aerodynamic stall/spin.Apr 11, 2015 · N352D · Substantial damageNTSB WPR15LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-200 · Santa Maria, CAThe engine failure due to oil starvation, which resulted from the installation of an unapproved oil quick drain valve that subsequently led to the inadvertent draining of the oil when the nose landing gear was retracted. Contributing to the accident was the…Apr 4, 2015 · N5469T · Substantial damageNTSB DCA15WA211Accident · No injuriesForeign investigationAyres S2R · Penja, CameroonThe Cameroon Civil Aviation Authority (CCAA) has notified the NTSB of an accident involving a Ayres S2R-T34 airplane that occurred on April 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CCAA's investigation under the…Apr 1, 2015 · TJ-AII · Substantial damageNTSB CEN15FA187Accident · 2 fatalField investigationFinal reportAircraft Mfg & Dvlpmt CH601XL · Pleasanton, KSThe pilot's excessively high angle-of-attack on rotation that prevented the airplane from climbing sufficiently to avoid the approaching trees.Mar 31, 2015 · N623HS · DestroyedNTSB GAA15CA028Accident · Minor injuriesData collectionFinal reportLet L23 - NO Series · Los Alamitos, CAThe inadvertent deployment of the air brakes during initial climb, resulting in a loss of lift. Contributing to the accident was the pilot's failure to identify and remediate the cause.Mar 29, 2015 · N381BA · Substantial damageNTSB ERA15FA170Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Orange, VAThe student pilot's failure to maintain adequate airspeed after takeoff, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Mar 29, 2015 · N32396 · Substantial damageNTSB CEN15LA183Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Gordonville, TXThe pilot's decision to depart from an upsloping, soft grass runway at or near the airplane's maximum gross weight and with a high density altitude, which increased the airplane's ground roll and placed the airplane in close proximity to trees during the…Mar 29, 2015 · N80462 · Substantial damageNTSB CEN15LA182Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 400 · Levelland, TXThe in-flight separation of the left aileron's attachment hardware at the connection between the long aileron pushrod and the left aileron bellcrank. Contributing to the accident was maintenance personnel’s improper installation of, or failure to install, the…Mar 26, 2015 · N136DB · Substantial damageNTSB DCA15WA106Incident · No injuriesForeign investigationBoeing Boeing 737-8AS · Lametia, ItalyThe ANSV of Italy has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on March 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV's investigation under the provisions of ICAO Annex 13 as the…Mar 25, 2015 · EI-EGC · Minor damageNTSB GAA15CA020Accident · Minor injuriesData collectionFinal reportCessna 150 · Flushing, MILoss of engine power due to fuel contamination. A factor contributing to the accident was the pilot's inadequate preflight.Mar 24, 2015 · N7987E · Substantial damageNTSB CEN15LA179Accident · Serious injuriesLimited investigationFinal reportPicard Roy J RV 4 · Marathon, TXA total loss of engine power for reasons that could not be determined because postaccident examination of the airplane revealed no evidence of any mechanical anomalies that would have precluded normal operation.Mar 23, 2015 · N945RV · Substantial damageNTSB WPR15LA130Accident · Minor injuriesLimited investigationFinal reportVans RV6A · Green Valley, AZThe total loss of engine power during initial climb due to the disconnection of both fuel pump power wires.Mar 21, 2015 · N811KM · Substantial damageNTSB ERA15RA163Accident · 10 fatalForeign investigationBeech B90 · Punta del Este, UruguayOn March 19, 2015, about 20:38 Local Time, a Beech Model B90 King Air, Argentine Registration LV-CEO, operated by Drogueria Meta, S.A., impacted water in Laguna del Sauce, Punta del Este, Uruguay. Night visual meteorological conditions prevailed, and flight…Mar 19, 2015 · LV-CEO · DestroyedNTSB ERA15LA219Accident · 1 fatalLimited investigationFinal reportRainbow Aerotrike · Chesnee, SCThe pilot’s failure to maintain lateral or bank control during takeoff, which resulted in collision with, and subsequent suspension from, a tree. Contributing to the pilot’s fatal injuries was his attempt to jump out of the trike to a nearby tree limb.Mar 9, 2015 · UNREG · Substantial damageNTSB ERA15LA151Accident · No injuriesLimited investigationFinal reportPiper PA23 · San Juan, PRThe total loss of right engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Mar 9, 2015 · N1153P · Substantial damageNTSB WPR15FA121Accident · Serious injuriesField investigationFinal reportRyan Aeronautical ST3KR · Santa Monica, CAA total loss of engine power during initial climb when the carburetor main metering jet became unseated, which led to an extremely rich fuel-to-air ratio. Contributing to the accident was the lack of adequate carburetor maintenance instructions. Contributing…Mar 5, 2015 · N53178 · Substantial damageNTSB WPR15CA118Accident · No injuriesData collectionFinal reportChristopher Jon Brown Stol CH750 · Palmdale, CAThe pilot's failure to maintain airplane control when he exceeded the airplane's critical angle of attack during climb out which resulted in a loss of airspeed and subsequent aerodynamic stall.Mar 3, 2015 · N756AC · Substantial damageNTSB ERA15FA139Accident · 1 fatalField investigationFinal reportAdams Donald L DA1 · Sebring, FLA partial loss of engine power for reasons that could not be determined based on the available evidence.Mar 2, 2015 · N797A · Substantial damageNTSB WPR15LA104Accident · No injuriesLimited investigationFinal reportScottish Bulldog - 120 121 · Hayward, CAA total loss of engine power during the initial climb due to fuel contamination. Contributing to the accident was the pilot’s inadequate preflight inspection of the fuel system.Feb 15, 2015 · N706BD · Substantial damageNTSB ENG15WA034Incident · No injuriesForeign investigationAirbus A320 · Tehran, IranThe Civil Aviation Organization of the Islamic Republic of Iran (CAO.IRI) has notified the NTSB of an incident involving an Airbus A320-200, which occurred on February 15, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAO…Feb 15, 2015 · EP-TTB · No damageNTSB ERA15LA130Accident · Serious injuriesLimited investigationFinal reportRobertson James F Velocity STD/RG E · Sebastian, FLThe pilot’s loss of airplane control after takeoff, which resulted in collision with terrain. Contributing to the accident was the pilot’s failure to properly secure the cabin door and trim the airplane for takeoff, which resulted in the cabin door opening…Feb 13, 2015 · N112TH · Substantial damageNTSB ERA15FA128Accident · 1 fatalField investigationFinal reportPiper PA28 · Greensboro, NCA total loss of engine power after takeoff due to fuel starvation as a result of excessive wear of the fuel selector valve. Also causal was the owner/operator and maintenance personnel's inadequate maintenance, and inadequate postmaintenance inspection.Feb 11, 2015 · N5985U · Substantial damageNTSB WPR15LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Helena, MTLoss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any evidence of an anomaly that would have precluded normal operation.Jan 20, 2015 · N4666R · Substantial damageNTSB CEN15LA112Accident · No injuriesLimited investigationFinal reportMooney M20C · Lonoke county, ARThe loss of engine power due to fuel starvation.Jan 17, 2015 · N6474U · Substantial damageNTSB CEN15LA109Accident · No injuriesLimited investigationFinal reportCessna 182R · Santa Fe, NMThe pilot’s failure to remove ice from the airplane’s surfaces before departure, which resulted in the airplane’s inability to attain sufficient airspeed shortly after takeoff, the subsequent exceedance of the airplane’s critical angle-of-attack, and an…Jan 15, 2015 · N9611H · Substantial damageNTSB WPR15LA084Accident · 1 fatalLimited investigationFinal reportBruct J Myers RV-9A · Prineville, ORThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during the climb, which resulted in an aerodynamic stall/spin.Jan 11, 2015 · N8080S · DestroyedNTSB ERA15WA112Accident · 2 fatalForeign investigationEmbraer EMB-710C · Luziania, BrazilOn January 10, 2015, about 2105 universal coordinated time, an Embraer EMB-710C, Brazilian registration PT-NAB, was substantially damaged when it impacted a residence, after experiencing a loss of engine power during the initial climb after takeoff from the…Jan 10, 2015 · PT-NAB · Substantial damageNTSB WPR15FA081Accident · 1 fatalField investigationFinal reportGibbs Lancair 320 · Van Nuys, CAThe pilot's improper decision to take off despite low fuel alerts, which resulted in a total loss of engine power due to fuel exhaustion, his subsequent failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack, which…Jan 9, 2015 · N7ZL · Substantial damageNTSB ENG15RA030Accident · No injuriesForeign investigationPac 750XL - NO Series · Taupo, New Zealand, New ZealandOn 7 January 2015, a Pacific Aerospace Limited 750XL airplane, registration No. ZK-SDT, while performing commercial skydiving operations, experienced an engine failure while climbing through approximately 3000 feet, after take-off from Taupo Aerodrome in the…Jan 7, 2015 · ZK-SDT · DestroyedNTSB ERA15LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Norfolk, VAThe engine’s failure to regain full power after a simulated engine failure for reasons that could not be determined during postaccident examinations and testing.Jan 6, 2015 · N2102P · Substantial damageNTSB ERA15LA092Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Long View, NCThe improper installation of the lower rear crankshaft counterweight snap rings by unknown maintenance personnel, which resulted in the separation of the counterweight and a subsequent total loss of engine power during initial climb.Jan 6, 2015 · N246JT · Substantial damageNTSB CEN15FA090Accident · 1 fatalField investigationFinal reportCessna 404 · Englewood, COThe loss of power to the right engine for reasons that could not be determined during postaccident examination and teardown and the pilot’s failure to properly configure the airplane for single-engine flight.Dec 30, 2014 · N404MG · Substantial damageNTSB ERA15WA098Accident · 5 fatalForeign investigationAerospatiale AS350B · Bertioga, BrazilOn December 27, 2014, about 1240 UTC, an Aerospatiale AS350B, Brazil registration PT-HNC, collided with trees near Rio-Santos, Bertioga, Brazil. The pilot and 4 passengers were fatally injured, and the helicopter was destroyed. The helicopter was registered…Dec 27, 2014 · PT-HNC · DestroyedNTSB WPR15CA059Accident · Serious injuriesData collectionFinal reportCessna 182T · Wendover, UTThe pilot's failure to maintain situational awareness during a turn which resulted in a loss of airplane control.Dec 12, 2014 · N961GW · Substantial damageNTSB CEN15IA079Incident · No injuriesIncident investigationFinal reportCessna T182T · Cahokia, ILThe mechanic’s improper installation of the elevator trim actuator, which resulted in reversed elevator trim control, and his subsequent failure to detect the misrigging of the elevator cables during the postmaintenance inspection.Dec 12, 2014 · N93CL · No damageNTSB ERA15LA071Accident · Minor injuriesLimited investigationFinal reportCessna 210 5(205) · Sussex, NJMaintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.Dec 4, 2014 · N8296Z · Substantial damageNTSB WPR15IA046Incident · No injuriesIncident investigationFinal reportEmbraer EMB-505 · Palm Springs, CAThe failure of the gust lock actuator solenoid for reasons that could not be determined because postaccident examination of the rudder gust lock system revealed no mechanical malfunctions or failures that would have precluded normal operation.Nov 23, 2014 · C-GJOL · Minor damageNTSB ANC15LA004Accident · No injuriesLimited investigationFinal reportHelio H 295 · Nenana, AKThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preimpact mechanical anomalies.Nov 15, 2014 · N6465V · Substantial damageNTSB CEN15FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172K · Lake Pontchartrain, LAThe airplane's collision with water for reasons that could not be determined because the wreckage was not located.Nov 13, 2014 · N46707 · DestroyedNTSB ERA15CA056Accident · No injuriesData collectionFinal reportCessna 172S · Sarasota, FLThe student pilot's failure to maintain airplane control during the initial climb, resulting in a runway excursion and substantial damage to the engine firewall. The student pilot's lack of overall flying experience was a factor.Nov 12, 2014 · N60155 · Substantial damage