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 ERA09LA281Accident · Serious injuriesLimited investigationFinal reportPolaris Motors 582 FIB · Lexington, SCThe non-certificated pilot's failure to maintain airspeed during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the non-certificated pilot’s lack of experience in the make and model airplane.May 4, 2009 · N171MB · Substantial damageNTSB CEN09LA274Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33 · Addison, TXA loss of engine power in flight due to fuel starvation as a result of the pilots' inadequate fuel management.May 4, 2009 · N528BM · Substantial damageNTSB WPR09CA225Accident · No injuriesData collectionFinal reportRans S-7 · Atomic City, IDA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.May 1, 2009 · N4272M · Substantial damageNTSB CEN09FA267Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Mayfield Village, OHThe pilot’s failure to maintain control of the airplane while operating in instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s inattention to basic aircraft control while attempting to program the…Apr 28, 2009 · N504MD · DestroyedNTSB WPR09LA218Accident · No injuriesLimited investigationFinal reportWeinberg RV-6 · Sparks, NVThe pilot's failure to follow the pre-takeoff checklist that resulted in the canopy opening during takeoff, which created a distraction, and his failure to maintain aircraft control during landing.Apr 26, 2009 · N690V · Substantial damageNTSB ERA09CA262Accident · Minor injuriesData collectionFinal reportTecnam P2002 Sierra · Lake Wales, FLThe pilot’s failure to maintain aircraft control and failure to maintain clearance from trees during initial climb.Apr 24, 2009 · N122LS · Substantial damageNTSB CEN09LA263Accident · 1 fatalLimited investigationFinal reportLaseure Sonerai II · Grantsburg, WIThe pilot's failure to maintain airspeed during initial climb which resulted in a stall/spin. Contributing to the accident was the degraded engine performance.Apr 22, 2009 · N232PE · DestroyedNTSB CEN09LA262Accident · 1 fatalLimited investigationFinal reportCapra, Salvatore O Aventura 2 · Des Allemands, LAThe pilot’s failure to achieve adequate altitude and airspeed before beginning a downwind turn after takeoff.Apr 22, 2009 · N912SC · Substantial damageNTSB CEN09CA258Accident · No injuriesData collectionFinal reportMarlin Varieze · Santa Teresa, NMThe pilot's failure to maintain control of the airplane, his failure to latch the canopy prior to takeoff, and his failure to complete the pretakeoff checklist due to his diverted attention.Apr 20, 2009 · N77JM · Substantial damageNTSB ERA09WA241Accident · 4 fatalForeign investigationCessna 210 · Concepcion, BoliviaOn April 11, 2009, at 2305 universal coordinated time (1905 local time), a Cessna 210M, Bolivian registration CP-1373, was destroyed when it impacted terrain shortly after taking off from Concepcion Airport (SLCP), Concepcion, Bolivia. The certificated…Apr 13, 2009 · CP-1373 · DestroyedNTSB ERA09LA239Accident · Serious injuriesLimited investigationFinal reportDiamond DA20 · Shelbyville, TNA partial loss of engine power for an undetermined reason.Apr 11, 2009 · N964CT · Substantial damageNTSB WPR09CA186Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 58 · Anacortes, WAThe partial loss of engine power due to the passenger's inadvertent movement of the engine throttle control.Apr 9, 2009 · N5138J · Substantial damageNTSB CEN09LA239Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Corning, ARA loss of engine power due to the failure of the number one engine cylinder for undetermined reasons.Apr 7, 2009 · N36597 · Substantial damageNTSB CEN09LA236Accident · Serious injuriesLimited investigationFinal reportArgence RV-8 · Angleton, TXThe pilot's failure to maintain clearance from trees during initial climbout.Apr 4, 2009 · N89EA · DestroyedNTSB ERA09LA222Accident · Serious injuriesLimited investigationFinal reportRogers Kenneth J Flaglor Scooter · Griffin, GAA total loss of engine power due to the failure of the engine-driven fuel pump. Contributing to the accident was unsuitable terrain for a forced landing and the pilot’s preexisting medical condition.Mar 30, 2009 · N3248Q · Substantial damageNTSB ERA09CA220Accident · No injuriesData collectionFinal reportSIAI Marchetti SM-1019B · Dade City, FLThe pilot's failure to maintain directional control during initial climb.Mar 29, 2009 · N273LH · Substantial damageNTSB WPR09LA170Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Madera, CAA total loss of engine power during the initial climb due to fuel exhaustion as a result of the pilot's failure to properly monitor the airplane's fuel quantity and to correctly ascertain the fuel on board the airplane prior to takeoff.Mar 28, 2009 · N2445S · Substantial damageNTSB WPR09LA169Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · San Carlos, CAA total loss of engine power during the initial climb for undetermined reasons.Mar 28, 2009 · N9249W · Substantial damageNTSB CEN09FA230Accident · 1 fatalField investigationFinal reportCessna 337C · Stillwater, OKThe total loss of dual engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Mar 27, 2009 · N373E · Substantial damageNTSB ENG09IA004Incident · No injuriesIncident investigationFinal reportMcdonnell-Douglas DC-10-30 · Bogota, ColombiaFailure of the low pressure turbine stage 3 disk due to a design that is vulnerable to high pressure turbine unbalance-induced synchronous vibration that cannot be detected in flight, and the subsequent uncontained engine failure.Mar 26, 2009 · N526MD · Minor damageNTSB ANC09CA026Accident · Minor injuriesData collectionFinal reportCessna 170B · Dillingham, AKThe pilot's selection of unsuitable terrain for takeoff and his failure to attain adequate airspeed to avoid an aerodynamic stall. Contributing to the accident was the pilot's decision to take off with the airplane over its maximum allowable gross weight.Mar 26, 2009 · N2989D · Substantial damageNTSB WPR09FA158Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Corona, CAThe pilot did not maintain airplane control during climb due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the pilot's lack of recent instrument flying experience.Mar 20, 2009 · N55962 · Substantial damageNTSB WPR09CA152Accident · No injuriesData collectionFinal reportKenneth K Knowles Sonex · Cottonwood, AZThe loss of engine power for undetermined reasons.Mar 18, 2009 · N997KK · Substantial damageNTSB CEN09LA224Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F19 · Lake Vermillion, MNThe pilot's failure to maintain proper pitch control resulting in a stall/spin.Mar 14, 2009 · N3937T · Substantial damageNTSB CEN09LA214Accident · Minor injuriesLimited investigationFinal reportMarlman Stol CH 801 · Fort Morgan, COThe complete loss of engine power, as reported by the pilot, for undetermined reasons.Mar 14, 2009 · N130WM · Substantial damageNTSB ANC09LA023Accident · No injuriesLimited investigationFinal reportHelio H-295 · Healy, AKThe pilot's delay in initiating a climb while he was packing snow with the airplane's skis in preparation for landing, resulting in a collision with brush.Mar 14, 2009 · N6478V · Substantial damageNTSB CEN09LA196Accident · 1 fatalLimited investigationFinal reportFritz RV3-A · Greencastle, INA partial loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control during the emergency descent.Mar 7, 2009 · N933WF · Substantial damageNTSB ERA09LA187Accident · Minor injuriesLimited investigationFinal reportDoyle-Michael Sonerai-II · Leonardtown, MDThe pilot's continued operation of the airplane with a known mechanical deficiency. Contributing to the accident was the improper installation of the electronic ignition system.Mar 6, 2009 · N28MD · Substantial damageNTSB CEN09CA192Accident · Minor injuriesData collectionFinal reportChampion 7FC · Thomas, OKA partial loss of engine power for undetermined reasons.Mar 6, 2009 · N7681E · Substantial damageNTSB CEN09CA186Accident · Minor injuriesData collectionFinal reportBeech A36 · Athens, TXThe non-certificated pilot's failure to maintain control during his unauthorized use of the airplane.Mar 4, 2009 · N5470V · Substantial damageNTSB WPR09FA133Accident · 2 fatalField investigationFinal reportMooney M20E · Rio Linda, CAA partial loss of engine power for undetermined reasons and the pilot's failure to maintain an adequate airspeed while maneuvering during the initial climb, which resulted in a stall/spin.Feb 28, 2009 · N3463X · Substantial damageNTSB WPR09LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Turlock, CAThe loss of engine power due to carburetor icing resulting from the pilot's failure to apply carburetor heat. Contributing to the accident was the instructor's inadequate supervision of the flight.Feb 18, 2009 · N48761 · Substantial damageNTSB CEN09LA167Accident · No injuriesLimited investigationFinal reportBeech H35 · Grain Valley, MOThe loss of engine power due to fuel starvation (mechanical). Contributing to the accident was the forced landing on unsuitable terrain.Feb 17, 2009 · N7942D · Substantial damageNTSB WPR09LA115Accident · Minor injuriesLimited investigationFinal reportCessna T337 · Rialto, CAA partial loss of engine power to one engine during initial climb for undetermined reasons.Feb 14, 2009 · N86242 · Substantial damageNTSB CEN09FA164Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Porter, TXThe pilot’s failure to maintain control of the airplane during an aborted landing for undetermined reasons.Feb 12, 2009 · N9648Y · Substantial damageNTSB ERA09LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJA loss of engine power due to the improper tightening of a fuel hose B-nut by maintenance personnel during engine installation.Feb 11, 2009 · N55854 · Substantial damageNTSB ERA09CA162Accident · Minor injuriesData collectionFinal reportDavis Sonex · Crossville, TNA total loss of engine power during initial climb due to the failure of the ignition power supply as a result of the improper installation of the electronic control unit.Feb 6, 2009 · N555SX · Substantial damageNTSB CEN09CA169Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Mineral Wells, TXThe failure of the airframe and power plant mechanic to ensure proper lubrication of wire cables in the landing gear system during the annual inspection which precluded safe operation of the landing gear system.Feb 3, 2009 · N5451P · Substantial damageNTSB ERA09LA150Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL II Sport · Ellenboro, NCThe pilot's failure to maintain control of the airplane during climbout. Contributing to the accident was the pilot’s lack of experience in the make and model of the airplane.Jan 31, 2009 · UNREG · Substantial damageNTSB CEN09LA207Accident · No injuriesLimited investigationFinal reportHall Steven C Lancair LE · Longmont, COThe pilot's failure to maintain aircraft pitch control resulting in the airplane impacting the terrain. Contributing to the accident were the pilot's failure to ensure the canopy was fully locked prior to takeoff and the canopy oscillations in flight.Jan 31, 2009 · N939CB · Substantial damageNTSB CEN09LA149Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Cypress, TXBoth pilot's failure to see and avoid the other aircraft.Jan 31, 2009 · N51KT · 2 aircraft · Minor damageNTSB CEN09LA154Accident · Serious injuriesLimited investigationFinal reportUltra Flight Challenger · Waldron, MOThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident were the pilot's lack of experience in the make and model of airplane, the inoperative flight instruments and the pilot's failure to abort…Jan 21, 2009 · N805FA · Substantial damageNTSB DCA09MA026Accident · Serious injuriesClass 1 · MajorFinal reportAirbus A320 · Weehawken, NJThe ingestion of large birds into each engine, which resulted in an almost total loss of thrust in both engines and the subsequent ditching on the Hudson River. Contributing to the fuselage damage and resulting unavailability of the aft slide/rafts were (1)…Jan 15, 2009 · N106US · Substantial damageNTSB WPR09LA082Accident · Minor injuriesLimited investigationFinal reportStits Flut-R-Bug SA6B · Los Olivos, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's improper decision to depart from a road with a known unresolved engine problem.Jan 14, 2009 · N3129 · Substantial damageNTSB WPR09LA079Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Corona, CAThe pilot's inadequate compensation for the gusting wind conditions and failure to maintain directional control during the takeoff-initial climb.Jan 12, 2009 · N9694Y · Substantial damageNTSB WPR09LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · Fremont, CAThe partial loss of engine power during takeoff due to an oil pump/tachometer drive gear failure for undetermined reasons.Jan 10, 2009 · N758FN · Substantial damageNTSB CEN09LA134Accident · Serious injuriesLimited investigationFinal reportInman J D Kolb Mark III · Ozark, ARThe loss of engine power due to fuel contamination. Contributing to the accident was the pilot maintaining a high angle of attack during takeoff, which resulted in an inadvertent stall when the engine failed.Jan 7, 2009 · N313JD · Substantial damageNTSB WPR09LA075Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Casa Grande, AZThe pilot's failure to ensure that the canopy was latched prior to takeoff. Contributing to the accident was the inadequate guidance in the Pilot Operating Handbook regarding canopy procedures.Jan 6, 2009 · N797BS · Substantial damageNTSB ERA09LA109Accident · No injuriesLimited investigationFinal reportMichel Paul John Murphy Rebel · Live Oak, FLA partial loss of engine power for undetermined reasons.Dec 27, 2008 · N616PM · Substantial damageNTSB ERA09LA108Accident · Serious injuriesLimited investigationFinal reportBeech E18S · Fort Myers, FLThe failure of the right propeller to go to the feathered position for undetermined reasons following a total loss of right engine power during initial climb due to fuel starvation as a result of the pilot's improper fuel planning.Dec 27, 2008 · N7765N · Substantial damage