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 ERA09CA545Accident · No injuriesData collectionFinal reportKermit Weeks Quicksilver · Polk City, FLThe pilot’s failure to adequately inspect the landing gear floats for water prior to takeoff.Sep 25, 2009 · N69MX · Substantial damageNTSB CEN09LA605Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Troy, MIA loss of engine power during initial climb due to fuel starvation as a result of the pilot's selection of an empty or nearly empty main tank for takeoff.Sep 25, 2009 · N4864S · Substantial damageNTSB WPR09LA463Accident · 1 fatalLimited investigationFinal reportFrazier Tangent · Nampa, IDThe pilot's failure to maintain pitch control of the airplane.Sep 24, 2009 · N72TZ · Substantial damageNTSB CEN09FA603Accident · 1 fatalField investigationFinal reportCessna 182Q · Houma, LAThe pilot’s decision to take off into instrument meteorological conditions.Sep 24, 2009 · N96894 · DestroyedNTSB WPR09LA451Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Hayward, CAThe pilot's failure to maintain directional control after takeoff. Contributing to the accident was the pilot's inadequate preflight and failure to follow the airplane manufacturer's checklist to ensure that the rudder trim control and right propeller control…Sep 16, 2009 · N726CB · Substantial damageNTSB CEN09CA588Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf · New London, OHThe pilot's failure to maintain clearance from an obstacle during takeoff and the flight instructor's inadequate supervision.Sep 15, 2009 · N6126B · Substantial damageNTSB WPR09LA449Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-34 · Lake Elsinore, CAThe pilot's failure to maintain control of the glider after the tow line released during the initial climb.Sep 12, 2009 · N7656 · Substantial damageNTSB WPR09LA432Accident · Serious injuriesLimited investigationFinal reportCessna P206B · Truckee, CAThe pilot’s failure to maintain adequate airspeed for flight, which resulted in an aerodynamic stall and subsequent impact with the ground. Contributing to the accident was the intermittent failure of the stall warning system due to a contaminated switch.Sep 8, 2009 · N206ST · Substantial damageNTSB ERA09LA509Accident · Serious injuriesLimited investigationFinal reportHebert Kitfox Speedster · Morrisville, VTA total loss of engine power during the initial climb after takeoff for undetermined reasons.Sep 7, 2009 · N43KA · Substantial damageNTSB ERA09LA503Accident · 1 fatalLimited investigationFinal reportPiper PA-11 · Quincy, FLThe pilot’s improper use of flight controls following a partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s impairment from the use of an over-the-counter sedating antihistamine.Sep 7, 2009 · N4778M · Substantial damageNTSB CEN09LA573Accident · No injuriesLimited investigationFinal reportBeech B36TC · Sullivan, MOA loss of aircraft control for undetermined reasons.Sep 7, 2009 · N65873 · Substantial damageNTSB CEN09CA563Accident · Minor injuriesData collectionFinal reportHalbert James H Rans S-7 · Short, OKA partial loss of engine power for undetermined reasons.Sep 6, 2009 · N615JH · DestroyedNTSB WPR09LA431Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oroville, CAA total loss of engine power for undetermined reasons.Sep 4, 2009 · N2482R · DestroyedNTSB ERA09LA516Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti F.260 · Atlanta, GAA total loss of engine power due to a fuel system air leak as a result of a deteriorated O-ring seal in the fuel shut-off cock. Contributing to the accident was the exceedance of the suggested overhaul schedule for the fuel shut-off cock.Sep 4, 2009 · N517P · Substantial damageNTSB CEN09LA572Accident · Minor injuriesLimited investigationFinal reportWright Bruce M Avid Flyer · Hitchcock, TXA total loss of engine power for undetermined reasons.Sep 3, 2009 · N583AF · Substantial damageNTSB ERA09LA498Accident · Serious injuriesLimited investigationFinal reportHahn R-W22 Tiger Moth Rep · Symrna, TNA loss of engine power for undetermined reasons.Sep 1, 2009 · N318JT · DestroyedNTSB WPR09LA427Accident · Serious injuriesLimited investigationFinal reportStone Kitfox Series 6 · May, IDThe pilot's failure to maintain clearance from obstacles during the takeoff initial climb.Aug 30, 2009 · N2070A · Substantial damageNTSB WPR09LA417Accident · No injuriesLimited investigationFinal reportPiper PA28R · Wendover, UTThe failure of the pilot to attain and maintain an airspeed sufficient for normal landing gear retraction during initial climb. Contributing to the accident was the pilot's failure to use the airplane's manual override landing gear system, misidentifying that…Aug 27, 2009 · N4837T · Substantial damageNTSB ERA09LA494Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Luray, VAA total loss of engine power during initial climb for undetermined reasons.Aug 26, 2009 · N186CF · Substantial damageNTSB CEN09LA551Accident · No injuriesLimited investigationFinal reportWeber Pelican · Searcy, ARA total loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.Aug 26, 2009 · N713DW · Substantial damageNTSB ANC09LA088Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s decision to make an abrupt and steep low altitude turn just after takeoff, while attempting to return to his departure airport, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident was the pilot’s failure to…Aug 25, 2009 · N6073V · Substantial damageNTSB CEN09CA537Accident · No injuriesData collectionFinal reportRewey William M CH 801 · Cottage Grove, WIA total loss of engine power during initial climb due to fuel starvation from a blocked fuel screen that resulted from the pilot/owner's inadequate inspection and maintenance of the fuel system.Aug 23, 2009 · N171WR · Substantial damageNTSB CEN09LA546Accident · No injuriesLimited investigationFinal reportTaylorcraft BCS-65 · Boulder, COA partial loss of engine power during initial climb due to carburetor icing.Aug 21, 2009 · N8023Q · Substantial damageNTSB WPR09FA400Accident · 2 fatalField investigationFinal reportPiper PA-24 · Prescott, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering to return to the runway at a high density altitude, which resulted in an aerodynamic stall.Aug 17, 2009 · N6304P · Substantial damageNTSB WPR09LA395Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glendale, AZA loss of engine power for undetermined reasons.Aug 12, 2009 · N86GW · Substantial damageNTSB ERA09LA459Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Sussex, NJThe pilot’s improper pre-flight planning and take off over gross weight limits.Aug 12, 2009 · N6676S · Substantial damageNTSB ERA09LA454Accident · 1 fatalLimited investigationFinal reportPongracz John M Nieuport 1 · Brasstown, NCThe pilot’s failure to maintain adequate airspeed during climb after takeoff, resulting in an inadvertent stall.Aug 10, 2009 · N112PM · Substantial damageNTSB ERA09LA452Accident · 1 fatalLimited investigationFinal reportMaxair Drifter · Bumpass, VAThe accelerated stall induced by the pilot in a steep turn to avoid obstacles during takeoff. Contributing to the accident were the pilot’s chosen takeoff path and the density altitude.Aug 9, 2009 · N160HA · Substantial damageNTSB ERA09LA448Accident · 2 fatalLimited investigationFinal reportKociemba Robert H T-Bird II · Keymar, MDThe pilot's failure to maintain adequate airspeed following a total loss of engine power due to fuel contamination.Aug 8, 2009 · N90458 · Substantial damageNTSB CEN09CA505Accident · Serious injuriesData collectionFinal reportFairchild PT-19A · Colorado Springs, COThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during a high-density altitude takeoff.Aug 8, 2009 · N54804 · Substantial damageNTSB WPR09FA385Accident · 1 fatalField investigationFinal reportCessna 182S · Napa, CAThe instrument-rated pilot’s loss of situational awareness and failure to follow the prescribed instrument departure clearance/procedure, which resulted in an in-flight collision with the terrain.Aug 5, 2009 · N23750 · Substantial damageNTSB ERA09CA445Accident · Serious injuriesData collectionFinal reportDestiny XLT · Athens, GAThe pilot’s failure to maintain obstacle clearance during climbout.Aug 4, 2009 · UNREG · Substantial damageNTSB WPR09LA381Accident · Serious injuriesLimited investigationFinal reportSchempp Hirth Discus CS · Williams, CAThe pilot's failure to maintain clearance with terrain after intentionally releasing from the tow plane at a low altitude during the initial climb.Aug 2, 2009 · N7HV · Substantial damageNTSB WPR09LA380Accident · Serious injuriesLimited investigationFinal reportDavenport DAVE-EZ · Santa Monica, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control during the forced landing.Aug 2, 2009 · N7CE · Substantial damageNTSB CEN09CA498Accident · Minor injuriesData collectionFinal reportRans Employee Flying Club Rans S-6S · Montezuma, INThe pilot's failure to maintain aircraft control after takeoff resulting in an impact with a power line and the ground.Jul 31, 2009 · N91226 · Substantial damageNTSB ERA09CA505Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Geneva, FLOil starvation due to air in the engine oil supply line, which resulted in engine seizure during initial climb.Jul 29, 2009 · N781PJ · Substantial damageNTSB CEN09LA467Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BF12 · Sawyer, MIThe pilot's failure to maintain adequate airspeed while taking off from a short, grass runway.Jul 25, 2009 · N36299 · Substantial damageNTSB WPR09LA364Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Washougal, WAA loss of engine power during initial climb due to a stuck exhaust valve.Jul 24, 2009 · N22278 · Substantial damageNTSB CEN09CA470Accident · No injuriesData collectionFinal reportRaytheon C90A · Bismarck, NDThe cabin entry door inadvertently opening during initial climb.Jul 23, 2009 · N405DD · Substantial damageNTSB CEN09CA473Accident · Minor injuriesData collectionFinal reportStinson 108 · Gardner, KSThe pilot's failure to ensure that the fuel selector valve was set properly in its detent prior to takeoff, resulting in fuel starvation.Jul 21, 2009 · N192C · Substantial damageNTSB ERA09LA412Accident · 1 fatalLimited investigationFinal reportJames O'Bert Vari-Eze · Columbus, GAThe pilots improper fuel management, which resulted in a loss of engine power due to fuel starvation.Jul 19, 2009 · N39DX · Substantial damageNTSB WPR09LA355Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Truckee, CAA loss of engine power during initial climb for undetermined reasons.Jul 18, 2009 · N9772Y · Substantial damageNTSB CEN09LA445Accident · Serious injuriesLimited investigationFinal reportMarvin Faulk Tinker Bell · La Porte, TXThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in a collision with terrain.Jul 18, 2009 · N62431 · Substantial damageNTSB CEN09CA449Accident · No injuriesData collectionFinal reportFoglio Tiger CUB · Toronto, OHThe pilot not turning off the carburetor heat prior to takeoff resulting in the engine's reduced performance, and his failure to remain clear of the tree during takeoff.Jul 18, 2009 · N312TC · Substantial damageNTSB ERA09LA407Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Morristown, TNThe partial loss of engine power for undetermined reasons.Jul 16, 2009 · N7227E · Substantial damageNTSB WPR09CA349Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Snohomish, WAA complete loss of engine power due to the failure of the airplane's engine-driven fuel pump.Jul 15, 2009 · N827EV · Substantial damageNTSB CEN09LA440Accident · 1 fatalLimited investigationFinal reportAntares MA-33 · Centerburg, OHThe pilot's failure to maintain adequate airspeed resulting in an aerodynamic stall.Jul 15, 2009 · N6405 · Substantial damageNTSB WPR09LA343Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Yellow Pine, IDThe pilot's failure to maintain clearance from the trees while taking off in a high-density altitude. Contributing to the accident were the pilot's failure to perform pre-takeoff performance calculations, his positioning of the elevator trim in a nose-down…Jul 14, 2009 · N71BS · Substantial damageNTSB ANC09FA062Accident · 2 fatalField investigationFinal reportZenair Stol CH 701 · Wasilla, AKThe pilot's failure to maintain sufficient airspeed to avoid an aerodynamic stall during takeoff and his decision to fly the airplane over its allowable gross weight. Contributing to the accident was the airplane's excessive gross weight.Jul 14, 2009 · N701BX · DestroyedNTSB CEN09LA451Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Beaman, IAThe loss of engine power during initial climb for undetermined reasons.Jul 10, 2009 · N6683K · Substantial damage