OpenAirDocs.org

NTSB investigations, IA

208 cases where the phase of flight was Initial climb.

Cases per year

19642026

Where

Open the map

Latest cases

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.\"eventStateOrRegion\" = 'IA' AND c.\"eventCountry\" = 'USA'
    AND 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 CEN23LA205Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 8KCAB · Larchwood, IAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during initial climb after takeoff, which resulted in an aerodynamic stall and impact with the ground.May 29, 2023 · N5038E · Substantial damageNTSB CEN21LA329Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Amana, IAThe loss of engine power for reasons that could not be determined.Jul 19, 2021 · N8422K · Substantial damageNTSB CEN20CA244Accident · Serious injuriesClass 4 · Data collectionFinal reportCoyote S-6ES · Pisgah, IAThe uncertificated pilot's failure to attain/maintain a proper angle-of-attack during an initial climb that resulted in an aerodynamic stall and subsequent impact with terrain.Jun 23, 2020 · N7764W · Substantial damageNTSB CEN18LA051Accident · No injuriesLimited investigationFinal reportCessna 172C · Algona, IAThe No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.Dec 9, 2017 · N8856B · Substantial damageNTSB CEN17LA263Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Corydon, IAA total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.Jul 9, 2017 · N929DE · Substantial damageNTSB 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 CEN16LA320Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Des Moines, IAThe two separations in the induction system due to improper installation and/or maintenance, which resulted in a partial loss of engine power during initial climb.Aug 13, 2016 · N314BF · DestroyedNTSB CEN14LA305Accident · 1 fatalLimited investigationFinal reportBollinger Robert L BD 4 · Fairfield, IAThe pilot’s loss of airplane control due to the in-flight separation of the propeller blades for reasons that could not be determined based on the available evidence.Jun 22, 2014 · N108BC · 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 damageNTSB CHI08CA213Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Ida Grove, IAA failure of the turbocharger blower which resulted in the partial loss of power. Factors associated with the accident were the low altitude of the airplane and the embankment.Aug 12, 2008 · N45029 · Substantial damageNTSB CHI08CA205Accident · Minor injuriesData collectionFinal reportHowell FW2C80TR · Washington, IAThe low airspeed and proper climb rate not attained by the pilot during takeoff and the inadvertent stall by the pilot.Jul 23, 2008 · N92FW · Substantial damageNTSB CHI08LA189Accident · Serious injuriesLimited investigationFinal reportRoof Curtis Hawk P6E · Iowa City, IAThe loss of engine power for an undetermined reason and the pilot's subsequent failure to maintain airspeed, which resulted in an aerodynamic stall.Jul 3, 2008 · N386PE · Substantial damageNTSB CHI08FA150Accident · 1 fatalField investigationFinal reportSocata TBM 700 (850) · Iowa City, IAThe pilot's improper decision to depart with a preexisting tailwind and failure to abort takeoff. Contributing to the severity of the injuries was the failure to properly restrain (FAA-required) the child passenger.Jun 3, 2008 · N849MA · Substantial damageNTSB CHI07CA212Accident · No injuriesData collectionFinal reportBell 47G-5 · Jesup, IAThe pilot's inability to maintain control of the helicopter when it unexpectedly encountered a whirlwind shortly after takeoff.Jul 10, 2007 · N8140J · Substantial damageNTSB CHI05LA229Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Marshalltown, IAThe loss of engine power for undetermined reasons during initial climb and the unsuitable landing area encountered by the pilot during a forced landing.Aug 12, 2005 · N9632 · Substantial damageNTSB CHI05CA044Accident · Serious injuriesData collectionFinal reportGoiden Circle T-Bird · Ft. Dodge, IAThe loss of engine power during initial climb for undetermined reasons.Dec 4, 2004 · UNREG · DestroyedNTSB CHI03LA309Accident · Minor injuriesLimited investigationFinal reportStrother KR2 · Clarinda, IAFailure of the pilot to maintain clearance from the roadway sign. The loose gravel and the sign were contributing factors.Sep 11, 2003 · N60MS · Substantial damageNTSB CHI03FA088Accident · 1 fatalField investigationFinal reportCessna 182R · North English, IAThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident was the CFI's improper decision to attempt to takeoff from a short, grass taxiway instead of departing from a runway aligned with the prevailing winds,…Mar 22, 2003 · N6211E · DestroyedNTSB CHI02FA292Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Ankeny, IAThe pilot applied an excessive angle of bank and failed to maintain terrain clearance. An additonal factor was the pilot's attention being diverted.Sep 24, 2002 · N8782P · DestroyedNTSB CHI01LA300Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Atlantic, IAThe loss of engine power for undetermined reasons during the takeoff and initial climb, and the unsuitable terrain encountered during the forced landing. Factors relating to this accident were the corn crop and the low altitude.Sep 3, 2001 · N6598K · DestroyedNTSB CHI01LA178Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28A · Eldridge, IAThe inadequate autorotation and disregarded wind information by the pilot. Factors were the gusting tailwind and the loss of engine power for undetermined reasons.Jun 19, 2001 · N612B · Substantial damageNTSB CHI00LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Sully, IAThe pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…Jun 11, 2000 · N9315W · Substantial damageNTSB CHI00LA086Accident · Minor injuriesLimited investigationFinal reportAlon Ercoupe · Osceola, IAfuel starvation due to an undetermined blockage in the fuel line from the header tank to the gascolator. Factors relating to this accident were the blocked fuel line and the rough terrain.Mar 5, 2000 · N6560Q · Substantial damageNTSB CHI99LA045Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Ankeny, IAthe elevator control system jammed for undetermined reasons.Dec 3, 1998 · N7278R · Substantial damageNTSB CHI98LA328Accident · No injuriesLimited investigationFinal reportBeech B35 · Iowa City, IAThe fuel starvation due to improper fuel management by the pilot-in-command. Also, the aircraft procedures and directives which were not followed by the pilot-in-command is an additional cause. The rough and uneven terrain in addition to the low altitude of…Aug 23, 1998 · N5210C · Substantial damageNTSB CHI98LA250Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Dyersville, IAthe pilot in command's not maintaining control of the airplane and his inadvertently allowing the airplane to enter a stall. A factor was the undetermined loss of engine power.Jul 14, 1998 · N5101W · Substantial damageNTSB CHI98LA186Accident · Minor injuriesLimited investigationFinal reportSheets Kitfox II · Greenfield, IAthe initial climb airspeed not obtained/maintained after liftoff by the pilot in command. A factor was the improper compensation for wind conditions by the pilot in command.Jun 2, 1998 · N487JS · DestroyedNTSB CHI98LA015Accident · No injuriesLimited investigationFinal reportReed-Madsen Taylor Bird · Humboldt, IAthe failure of the pilot-in-command to attain airspeed and maintain control of the aircraft, resulting in a stall/mush.Oct 5, 1997 · N12121 · Substantial damageNTSB CHI97LA155Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodbine, IAThe pilot's inadequate preflight planning and preparation. Factors were the high temperature and high vegetation.May 31, 1997 · N60971 · Substantial damageNTSB CHI97FA067Accident · 1 fatalField investigationFinal reportCessna 150 · Larchwood, IAthe noninstrument-rated pilot's takeoff into instrument meteorological conditions. The weather was a factor.Feb 7, 1997 · N714EE · DestroyedNTSB CHI96FA330Accident · 1 fatalField investigationFinal reportGreen Castle Avid Flyer Aerobat · Oxford, IAfailure of the private pilot to maintain sufficient airspeed after takeoff, during the initial climb and turn to the crosswind leg; and a delay by the flight instructor (CFI) in taking remedial action to avoid a stall.Sep 4, 1996 · N95GC · DestroyedNTSB CHI96LA232Accident · No injuriesLimited investigationFinal reportCessna 188 · Independence, IAthe delayed jettison of the dry chemicals by the pilot. The inability of the airplane to climb was a related factor.Jul 10, 1996 · N9542J · Substantial damageNTSB CHI96LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Nora Springs, IAthe pilot's inadequate preflight planning/preparation, which resulted in loss of airspeed and a stall/mush as he was maneuvering to avoid obstructions off the end of the runway. Factors relating to the accident were: the unfavorable wind condition, high…Nov 25, 1995 · N6094R · Substantial damageNTSB CHI95IA189Incident · No injuriesIncident investigationFinal reportBell 222UT · Des Moines, IAdelamination of the left engine air inlet duct.Jun 21, 1995 · N274SM · Minor damageNTSB CHI94LA295Accident · No injuriesLimited investigationFinal reportSchreiber-Stitts SA-3B · Muscatine, IAA loose intake manifold pipe on the airplane's engine which resulted from improper maintenance. Factors associated with this accident were the builder/pilot improperly installing the intake manifold pipe and the alternate landing area's high vegetation.Aug 21, 1994 · N79GJ · Substantial damageNTSB CHI94LA255Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marshalltown, IAA partial loss of engine power for undetermined reasons.Jul 29, 1994 · N8144Y · Substantial damageNTSB CHI94LA044Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Denison, IAThe pilot-in-command's inadequate remedial action. A factor associated with the accident is the student pilot's inadequate aircraft handling.Dec 6, 1993 · N6959Q · Substantial damageNTSB CHI93LA325Accident · No injuriesLimited investigationFinal reportCessna 152-II · Keokuk, IAthe loss of engine power due to an exhaust valve failure. A factor related to the accident is the power line.Aug 17, 1993 · N47716 · Substantial damageNTSB CHI93LA264Accident · No injuriesLimited investigationFinal reportBellanca DW-1 · Grinnell, IAthe loss of engine power due to undetermined reason(s). A factor in the accident is the soft field landing site.Jul 19, 1993 · N8815W · Substantial damageNTSB CHI93GA204Accident · 2 fatalFinal reportBeech 95-C55 · Fort Madison, IAthe pilot-in command's failure to maintain control of the aircraft. Factors were door not secured, checklist not followed, diverted attention of the pilot-in-command, and emergency procedure not followed.Jun 11, 1993 · N301U · Substantial damageNTSB CHI93LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ames, IAThe pilot exceeded the aircraft's maximum gross weight limitation which resulted in the failure to obtain a proper climb rate after takeoff.Nov 5, 1992 · N16231 · Substantial damageNTSB CHI92DCD07Accident · Serious injuriesFinal reportBernard W. Resnik ACRO-SPECIAL · Earlham, IAA loss of total engine power when a failed flapper valve in the air box blocked the flow of air through the carburetor throat.Jul 2, 1992 · N79WA · Substantial damageNTSB CHI92DCD05Accident · 1 fatalFinal reportRutter 532 Commander · Washburn, IAFailure of the pilot to maintain control of the gryocopter during initial climb.May 31, 1992 · N211CL · DestroyedNTSB CHI91LA193Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Spirit Lake, IAImproper use of carburetor heat by the pilot and unsuitable terrain.Jun 16, 1991 · N9008X · Substantial damageNTSB MKC90FA017Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Elkader, IAThe pilot's failure to maintain clearance from the runway marker at the departure end of the runway.Oct 24, 1989 · N36163 · DestroyedNTSB MKC89LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Leon, IABlockage of the engine air induction system by a field mouse nest. The nest was positioned so that it could not be seen during the pre-flight inspection. It became dislodged during the takeoff roll on the rough runway.Aug 22, 1989 · N8AG · Substantial damageNTSB MKC89LA066Accident · No injuriesLimited investigationFinal reportCessna 182RG · Ft. Madison, IAAn electrical wiring short that caused an in flight fire.Feb 25, 1989 · N4314R · Substantial damageNTSB MKC88DCD01Accident · No injuriesFinal reportBohnker Tierra II · Audubon, IAThe pilot stated that the takeoff run and liftoff appeared normal, but after liftoff the aircraft veered to the right (into the crosswind). The pilot attempted to correct with left rudder and aileron. When he was unsuccessful, he retarded throttle. The plane…Jun 5, 1988 · N116LB · Substantial damageNTSB MKC88LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Cherokee, IAThe plt stated, that shortly after takeoff, the engine lost substantial pwr. Afterwards there was smoke in the cockpit. The PIC reversed his course with the intent to land on the departure arpt. When he felt he had the ldg field made, he attempted to lower…Mar 15, 1988 · N8136R · Substantial damageNTSB MKC88FA058Accident · 4 fatalField investigationFinal reportCessna 172N · Oxford, IAWitnesses stated that the aircraft appeared to be in trouble immediatley after takeoff, as the wings were rapidly rocking while it was struggling to stay airborne. The aircraft turned sharply left, where it then barely cleared a row of trees. The airplane…Feb 28, 1988 · N5816E · Destroyed