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 CEN12LA244Accident · Serious injuriesLimited investigationFinal reportT Bird Golden Circle Air II · Clara City, MNThe airplane's loss of engine power for reasons that could not be determined because postaccident examination did not reveal any malfunctions or anomalies that would have precluded normal operation.Apr 14, 2012 · N5654N · Substantial damageNTSB ERA12CA281Accident · No injuriesData collectionFinal reportPiper J3C-65 · Plantation Key, FLThe pilot’s failure to maintain adequate control of the airplane and ensure clearance from trees.Apr 13, 2012 · N75487 · Substantial damageNTSB ERA12FA271Accident · 1 fatalField investigationFinal reportWejebe Jose CA8 -SF · Everglades City, FLThe pilot’s failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of airplane control.Apr 6, 2012 · N548SF · Substantial damageNTSB WPR12LA152Accident · 2 fatalLimited investigationFinal reportNelson Rans S-12 · Mesa, AZThe pilot’s failure to maintain airplane control while maneuvering at low altitude shortly after takeoff.Apr 3, 2012 · N586BN · Substantial damageNTSB ERA12FA265Accident · Serious injuriesField investigationFinal reportSapp Larry E Seawind 3000 · Deland, FLA total loss of engine power for reasons that could not be determined because the damage and postimpact fire precluded thorough examination of the engine and its systems.Apr 2, 2012 · N514KT · Substantial damageNTSB ERA12LA264Accident · Serious injuriesLimited investigationFinal reportPowrachute Airwolf 912ULS · Plant City, FLThe flight instructor’s failure to ensure an obstruction-free takeoff path prior to initiating the takeoff and his inadequate preflight inspection of the powered parachute’s flight controls, which resulted in a collision with trees during the takeoff.Apr 1, 2012 · N415BA · Minor damageNTSB ERA12FA262Accident · 1 fatalField investigationFinal reportBeech 58 · Calhoun, KYThe failure of the pilot to maintain airplane control after experiencing a loss of power from the left engine due to water contamination of the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane and…Apr 1, 2012 · N9448Q · Substantial damageNTSB WPR12LA149Accident · Serious injuriesLimited investigationFinal reportPowrachute Sky Rascal · Indio, CAThe operation of an airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot's failure to maintain clearance from powerlines during initial climb in gusty wind conditions.Mar 30, 2012 · UNREG · Substantial damageNTSB ERA12LA260Accident · Minor injuriesLimited investigationFinal reportHughes 369D · McCormick, SCThe pilot's decision to use automotive fuel instead of the approved alternate fuel, which resulted in a total loss of engine power.Mar 30, 2012 · N868W · Substantial damageNTSB ERA12WA255Accident · 4 fatalForeign investigationPiper PA-32R-300 · Treasure Cay, BahamasOn March 25, 2012, at 1830 UTC, a Piper PA-32R-300, N8415C, was substantially damaged when it crashed shortly after takeoff from Treasure Cay International Airport (MYAT), Abaco, Bahamas. The two certificated private pilots and two passengers were fatally…Mar 25, 2012 · N8415C · Substantial damageNTSB CEN12LA203Accident · 1 fatalLimited investigationFinal reportEnbody Frank GY 201 Minicab · Granite Shoals, TXA loss of engine power due to fuel starvation as a result of a contaminated carburetor fuel screen. Contributing to the accident was the pilot's impairment from medications that degraded his decision-making and the pilot's improper maintenance of the airplane.Mar 24, 2012 · N416FC · Substantial damageNTSB WPR12LA143Accident · No injuriesLimited investigationFinal reportReich Glastar · Caldwell, IDThe failure of a propeller blade at the hub due to fatigue cracking.Mar 22, 2012 · N617G · Substantial damageNTSB CEN12LA239Accident · Minor injuriesLimited investigationFinal reportGerner Evans WE-1 · Kimball, NEThe loss of engine power for reasons that could not be determined because a postaccident examination of the airplane and engine was not performed.Mar 22, 2012 · N5936 · Substantial damageNTSB ERA12LA230Accident · Serious injuriesLimited investigationFinal reportSadler Terry A Merlin · Otisfield, METhe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was his lack of experience in the airplane make and model.Mar 17, 2012 · N6113Y · Substantial damageNTSB ERA12LA229Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Venice, FLA total loss of engine power due to a loss of fuel pressure. The cause for the loss of fuel pressure could not be determined during postaccident testing.Mar 16, 2012 · N379CT · Substantial damageNTSB ERA12WA202Accident · 1 fatalForeign investigationCessna 208 · Manaus, BrazilOn February 28, 2012, about 1020 universal coordinated time, a Cessna 208B, Brazilian registration PT-PTB, operated by Cleiton Taxi Aereo Ltda., was substantially damaged when it impacted a lamppost and terrain, during the initial climb after takeoff from…Feb 28, 2012 · PT-PTB · Substantial damageNTSB CEN12FA170Accident · 2 fatalField investigationFinal reportMooney M20E · San Antonio, TXThe pilot's inadvertent overboost of the turbocharged engine during initial climb, which resulted in detonation and a partial loss of engine power followed by the pilot's failure to maintain airspeed and the instructor's delayed remedial action, which…Feb 26, 2012 · N9224M · Substantial damageNTSB ERA12FA193Accident · 2 fatalField investigationFinal reportCessna 172S · Key West, FLThe non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.Feb 24, 2012 · N53589 · Substantial damageNTSB WPR12LA110Accident · No injuriesLimited investigationFinal reportBeech C23 · Rawlins, WYThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in an uncontrolled descent and collision with terrain.Feb 18, 2012 · N5205M · Substantial damageNTSB WPR12LA108Accident · No injuriesLimited investigationFinal reportMooney M20J · Lewiston, CAA loss of engine power due to oil starvation as a result of improper maintenance.Feb 17, 2012 · N367MR · Substantial damageNTSB ERA12WA238Accident · 4 fatalForeign investigationBeech 95B55 · Cameta, BrazilOn February 16, 2012, about 1230 universal coordinated time, a Beech 95-B55, Brazilian registration PT-LOU, was destroyed when it impacted trees and terrain shortly after takeoff in Cameta Municipality, State of Mato Para, Brazil. The foreign certificated…Feb 16, 2012 · PT-LOU · DestroyedNTSB ENG12IA010Incident · No injuriesIncident investigationFinal reportBoeing 767 · Jamaica, NYThe failure of the American Airlines aviation maintenance technicians to properly reassemble the two-piece bracket and spray shield on the integrated drive generator fuel-oil heat exchanger that caused a fuel leak that sprayed out and ignited on hot engine…Feb 8, 2012 · N360AA · No damageNTSB WPR12LA092Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Kalispell, MTThe partial loss of engine power due to magneto malfunction. Contributing to the accident was the lack of adherence to the manufacturer’s recommended magneto overhaul schedule.Feb 4, 2012 · N38906 · Substantial damageNTSB WPR12FA091Accident · 2 fatalField investigationFinal reportCessna T206H · Show Low, AZThe pilot’s encounter with low clouds/low visibility conditions during the initial climb, which resulted in spatial disorientation and loss of airplane control.Feb 4, 2012 · N445GH · Substantial damageNTSB CEN12LA149Accident · 1 fatalLimited investigationFinal reportPipistrel Virus 912 · Ray, MIA loss of engine power due to fuel starvation for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Feb 4, 2012 · N325MZ · Substantial damageNTSB WPR12FA089Accident · 1 fatalField investigationFinal reportGarza Lancair IV-TP · Boise, IDA loss or commanded reduction of engine power during the initial climb for reasons that could not be determined because of postaccident impact damage and fire destruction to engine systems and components. Also causal were the pilot's failure to maintain…Feb 3, 2012 · N321LC · DestroyedNTSB CEN12LA146Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Sheridan, ARThe passenger’s interference with the flight controls during the initial climb, which resulted in a loss of control and impact with terrain.Jan 31, 2012 · N2677A · Substantial damageNTSB ERA12LA164Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Clearwater, FLThe total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident testing of the engine did not reveal any malfunctions or failures that would preclude normal operation. Contributing to the accident was the…Jan 28, 2012 · N761HW · Substantial damageNTSB CEN12LA192Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Seguin, TXA loss of engine power for undetermined reasons.Jan 28, 2012 · N5551M · Substantial damageNTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…Jan 23, 2012 · N73JK · Substantial damageNTSB ERA12FA149Accident · 1 fatalField investigationFinal reportAero Vodochody L39C · Rainbow City, ALAn in-flight loss of control in instrument meteorological conditions.Jan 21, 2012 · N16RZ · Substantial damageNTSB ERA12LA150Accident · No injuriesLimited investigationFinal reportM-Squared Breese 2 · Bayou La Batre, ALThe pilot's inability to maintain control of the airplane for reasons that could not be determined because postaccident examination of the rudder control system did not reveal any anomalies that would have precluded control of the airplane.Jan 19, 2012 · N582MS · Substantial damageNTSB ERA12FA146Accident · 1 fatalField investigationFinal reportAerostar PA-60-601P · Philadelphia, MSThe pilot’s failure to maintain directional control during takeoff following loss of power to the left engine due to fuel starvation. Contributing to the loss of control was the pilot’s failure to feather the left propeller following the loss of left engine…Jan 16, 2012 · N700PS · Substantial damageNTSB ERA12FA143Accident · Serious injuriesField investigationFinal reportCessna 150G · Fitchburg, MAA partial loss of engine power due to the formation of carburetor ice and the flight instructor's improper application of carburetor heat.Jan 11, 2012 · N4041J · Substantial damageNTSB ERA12LA141Accident · 1 fatalLimited investigationFinal reportBowers Fly Baby 1-A · Jefferson, GAThe pilot’s failure to maintain airplane control which resulted in an aerodynamic stall and spin. Also causal was the partial loss of engine power during the initial climb due to the improper installation of a magneto. Contributing to the accident was the…Jan 8, 2012 · N4626 · DestroyedNTSB ERA12LA131Accident · No injuriesLimited investigationFinal reportHaney John F B Seastar XP · Willimantic, CTA partial loss of engine power due to carburetor icing. Contributing to the accident was the lack of an installed manufacturer-recommended carburetor heat system.Jan 1, 2012 · N667JH · Substantial damageNTSB ERA12FA130Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Jacksonville, FLThe pilot's in-flight loss of control during climb after a banner pickup. Contributing to the accident was the pilot's impairment due to marijuana.Dec 31, 2011 · N7408Z · Substantial damageNTSB ERA12FA127Accident · No injuriesField investigationFinal reportCessna 650 · Ft. Lauderdale, FLThe crew's failure to use proper emergency procedures during an uncommanded right roll after takeoff, which led to a forced landing with a quartering tailwind. Contributing to the accident was a faulty right roll spoiler actuator, which allowed the right roll…Dec 28, 2011 · N877G · Substantial damageNTSB ERA12CA125Accident · Serious injuriesData collectionFinal reportCessna 150H · Knoxville, TNThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Dec 26, 2011 · N22565 · Substantial damageNTSB ERA12CA124Accident · No injuriesData collectionFinal reportChapel Robert B Aerial · Simsbury, CTThe pilot's decision to operate the gyroplane outside his endorsement limitations and to depart with a tailwind, which resulted in a forced landing to unsuitable terrain.Dec 26, 2011 · N435AB · Substantial damageNTSB ANC12FA014Accident · Minor injuriesField investigationFinal reportCessna U206G · Nanwalek, AKThe pilot’s decision to takeoff from a contaminated runway with unfavorable wind conditions, and his failure to maintain airspeed during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the operator’s inadequate…Dec 15, 2011 · N252AL · Substantial damageNTSB ERA12LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLA loss of engine power during takeoff for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.Dec 9, 2011 · N471TC · Substantial damageNTSB CEN12LA103Accident · No injuriesLimited investigationFinal reportBeech C23 · Watertown, SDA total loss of engine power during initial climb for undetermined reasons.Dec 9, 2011 · N6717K · Substantial damageNTSB WPR12LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180 · Seattle, WAThe flight instructor’s failure to maintain airplane control during a go-around.Dec 1, 2011 · N2163N · Substantial damageNTSB WPR12LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Hailey, IDThe pilot's failure to maintain course heading and terrain clearance because he was distracted by efforts to engage the autopilot shortly after takeoff on a dark night in mountainous terrain.Nov 30, 2011 · N36824 · Substantial damageNTSB ERA12WA086Accident · Serious injuriesForeign investigationBell 212 · Quito, EcuadorOn November 25, 2011, about 1640 coordinated universal time (1140 local time), a Bell 212, Ecuadorian registration HC-CLH, operated by Aeromaster Airways, S.A., was substantially damaged when it impacted steep terrain next to the company's helipad in Quito,…Nov 25, 2011 · HC-CLH · Substantial damageNTSB ERA12CA088Accident · No injuriesData collectionFinal reportAnatra Bart T Vans RV-7A · Quinton, VAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation, and the subsequent nose-over during the forced landing.Nov 25, 2011 · N816BA · Substantial damageNTSB CEN12LA076Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · New Orleans, LAA loss of engine power due to detonation of the No.2 cylinder from a clogged fuel injector nozzle.Nov 20, 2011 · N211CD · Substantial damageNTSB CEN12CA075Accident · No injuriesData collectionFinal reportGlobe GC-1B · Denver, COA loss of engine power due to fuel starvation as a result of a loose fuel line fitting.Nov 19, 2011 · N80775 · Substantial damageNTSB ERA12WA073Accident · 2 fatalForeign investigationCessna 150 · Santa Rosa, EcuadorOn November 14, 2011, about 2020 coordinated universal time (1520 local time), a Cessna 150M, Ecuadorian registration HC-BJA, was substantially damaged when it impacted rising terrain in the Girón Alto mountains near Santa Rosa, Ecuador. The Ecuadorian pilot…Nov 14, 2011 · HC-BJA · Substantial damage