OpenAirDocs.org

NTSB investigations, 2007

202 cases where the phase of flight was Initial climb.

Cases per year

19622026

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 year(c.\"eventDate\") = 2007
    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 CHI08CA057Accident · No injuriesData collectionFinal reportLerohl RV-8 · Alexandria, MNThe loss of engine power for undetermined reasons.Dec 30, 2007 · N5093F · Substantial damageNTSB MIA08LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Sarasota, FLA loss of engine power due to contamination in the fuel filter.Dec 26, 2007 · N5875Q · Substantial damageNTSB CHI08CA059Accident · Serious injuriesData collectionFinal reportInfinity Commander · Hot Springs Vlg, ARThe pilot not maintaining clearance/altitude from the trees during takeoff initial climb. Factors were the trees and reported turbulent winds.Dec 24, 2007 · N719AR · Substantial damageNTSB CHI08LA052Accident · Serious injuriesLimited investigationFinal reportLevick RAF-2000-GTX-SE · Salem, INThe pilot's failure to maintain control of the gyroplane during climbout after takeoff.Dec 14, 2007 · N24DN · DestroyedNTSB NYC08LA059Accident · 1 fatalLimited investigationFinal reportWootton, John Aero Canard · Statesville, NCAn inadvertent opening of the canopy during takeoff.Dec 12, 2007 · N199JW · Substantial damageNTSB CHI08CA048Accident · No injuriesData collectionFinal reportSmith, Ted Aerostar Aerostar 601 · Elyria, OHThe pilot's momentary loss of control after takeoff, which resulted in an in-flight collision with a tree. A contributing factor was the presence of the tree.Dec 11, 2007 · N2699G · Substantial damageNTSB SEA08FA042Accident · 2 fatalField investigationFinal reportBeech 200 · Salmon, IDAn in-flight loss of control due to the pilot's failure to remove ice and snow from the airplane prior to takeoff. Contributing to the accident were the pilot's improper preflight preparation/actions, falling snow, and a low ambient temperature.Dec 10, 2007 · N925TT · DestroyedNTSB MIA08CA028Accident · No injuriesData collectionFinal reportCessna 172E · Fair Bluff, NCThe pilot's inadequate preflight inspection which failed to detect contaminated fuel, and subsequent loss of engine power.Dec 9, 2007 · N3699S · DestroyedNTSB SEA08CA044Accident · No injuriesData collectionFinal reportCessna 182 · Spokane, WAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the fence.Dec 8, 2007 · N9048T · Substantial damageNTSB CHI08FA045Accident · 2 fatalField investigationFinal reportCessna 208B · Columbus, OHThe pilot's failure to maintain aircraft control and collision avoidance with terrain due to spatial disorientation. Contributing to the accident were the low cloud ceiling and night conditions.Dec 5, 2007 · N28MG · DestroyedNTSB MIA08LA023Accident · Serious injuriesLimited investigationFinal reportPorter Glen Aventura II · Rockledge, FLThe failure of the pilot to maintain airspeed during climbout, resulting in an aerodynamic stall and uncontrolled descent. Contributing to the severity of the pilot's injuries was the inadequate manufacture of the shoulder harness restraint cables.Dec 1, 2007 · N79GP · Substantial damageNTSB ANC08LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power during takeoff initial climb for an undetermined reason.Dec 1, 2007 · N169LC · Substantial damageNTSB NYC08LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Miami, FLA total loss of engine power during initial climb for undetermined reasons.Nov 26, 2007 · N4948P · Substantial damageNTSB DFW08FA036Accident · 1 fatalField investigationFinal reportCessna A150K · Mesquite, TXThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb. Factors contributing to the accident are the instructor's decision to takeoff with excessive flaps, the improper maintenance replacement of the flap…Nov 23, 2007 · N8301M · DestroyedNTSB NYC08FA039Accident · 1 fatalField investigationFinal reportMooney M20K · Maine, NYThe pilot's spatial disorientation, which resulted in a loss of control and subsequent collision with trees.Nov 20, 2007 · N252DD · DestroyedNTSB CHI08LA040Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Waukegan, ILThe pilot's failure to assure that all of his tools were accounted for prior to takeoff which resulted in the foreign object jamming the control stick and the pilot's inability to maintain control of the airplane. A factor associated with the accident was the…Nov 14, 2007 · N947DM · Substantial damageNTSB SEA08LA024Accident · Serious injuriesLimited investigationFinal reportTitan Tornado I · McMinnville, ORThe failure of the pilot to maintain an adequate airspeed during the initial climb after takeoff that resulted in an inadvertent stall. Contributing to the accident was the pilot's unfamiliarity with the accident airplane.Nov 11, 2007 · UNREG · Substantial damageNTSB NYC08LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sacramento, KYA total loss of engine power during initial climb for undetermined reasons.Nov 10, 2007 · N41535 · Substantial damageNTSB LAX08FA026Accident · 2 fatalField investigationFinal reportBeech A100 · Chino, CAThe pilot's failure to maintain a positive climb rate during an instrument takeoff. Contributing to the accident was the low visibility.Nov 6, 2007 · N30GC · DestroyedNTSB NYC08FA026Accident · 3 fatalField investigationFinal reportRobinson Helicopter R44 · Jamestown, TNThe pilot’s failure to maintain clearance from a known wire hazard during takeoff.Nov 5, 2007 · N8356C · DestroyedNTSB DFW08CA024Accident · Minor injuriesData collectionFinal reportPipistrel Sinus 912 · Holt, FLThe pilot's failure to maintain clearance from terrain. A contributing factor was the gusting crosswind.Nov 3, 2007 · N457EZ · Substantial damageNTSB LAX08LA025Accident · Serious injuriesLimited investigationFinal reportInterplane XJ · Independence, ORA partial loss of engine power for undetermined reasons. Also causal was the pilot's failure to maintain adequate airspeed, which resulted in a spin and collision with terrainNov 2, 2007 · N232PM · Substantial damageNTSB LAX08FA023Accident · 1 fatalField investigationFinal reportCessna 172S · Palm Springs, CAThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb, and his impairment from alcohol.Oct 29, 2007 · N21101 · Substantial damageNTSB CHI08CA008Accident · Serious injuriesData collectionFinal reportVeltman, Robert CH701 · Owosso, MIThe pilot inadvertantly turned the fuel selector to the off position and failed to maintain aircraft control during the subsequent loss of engine power. A factor associated with the accident was the pilot's change in his normal habit pattern.Oct 25, 2007 · N702BW · Substantial damageNTSB DEN08LA015Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Santa Fe, NMA leak in the fuel selector valve and gascolator that resulted in fuel starvation during takeoff. Contributing to the accident was a lack of suitable terrain for a forced landing.Oct 20, 2007 · N5104K · Substantial damageNTSB NYC08CA016Accident · No injuriesData collectionFinal reportCessna 182 · Hendersonville, NCThe pilot's failure to calculate weight and balance prior to departure, which resulted in departure above the maximum allowable gross weight, and the airplane's inability to climb. Contributing to the accident was the high density altitude.Oct 19, 2007 · N1437S · Substantial damageNTSB CHI08CA025Accident · No injuriesData collectionFinal reportCessna 152 · O'Neill, NEThe pilot's failure to assure the oil filter was installed on the airplane which resulted in oil starvation. Factors associated with the accident were the mechanic not installing the oil filter, the low altitude at which the loss of engine power occurred, and…Oct 19, 2007 · N48862 · Substantial damageNTSB DFW08FA015Accident · 5 fatalField investigationFinal reportBeech A36 · Glenpool, OKThe pilot's failure to maintain control of the airplane after departure, which resulted in a collision with power lines. A factor was the high winds.Oct 17, 2007 · N978TL · DestroyedNTSB LAX08CA013Accident · No injuriesData collectionFinal reportPoser DM 582 Buckeye · Hurricane, UTThe pilot's inadequate compensation for the existing wind conditions and subsequent failure to maintain aircraft control.Oct 16, 2007 · N785CP · Substantial damageNTSB NYC08FA012Accident · 4 fatalField investigationFinal reportAero Commander 560-F · Wiley Ford, WVA partial power loss in the right engine due to the failure of the number one exhaust valve, and the airplane's inability to maintain a climb on one engine for unknown reasons. Contributing to the accident were fog and rising terrain. [This report was…Oct 14, 2007 · N6370U · DestroyedNTSB DFW08LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Houston, TXThe pilot's failure to properly position the fuel tank selector before takeoff. Contributing to the accident were the non suitable terrain for the forced landing and fuel starvation.Oct 13, 2007 · N9733P · Substantial damageNTSB CHI08LA016Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Muskegon, MILoss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing available to the pilot due to the presence of a residential sub-division and trees.Oct 13, 2007 · N1261X · Substantial damageNTSB DEN08LA010Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Denver, COthe in-flight collision with geese shortly after takeoff.Oct 12, 2007 · N368CA · Substantial damageNTSB DEN08LA009Accident · No injuriesLimited investigationFinal reportJackson Pientenpol · Chanute, KSInternal failure of the engine's starter-generator assembly. Contributing factors in this accident were the trees and unsuitable terrain on which to make a forced landing..Oct 10, 2007 · N4400N · Substantial damageNTSB NYC08LA007Accident · Minor injuriesLimited investigationFinal reportBoeing A75N · Bealeton, VAThe pilot's failure to conduct performance planning before takeoff.Oct 7, 2007 · N66004 · DestroyedNTSB DFW08FA004Accident · 2 fatalField investigationFinal reportCessna 150L · Castroville, TXLoss of engine power for undetermined reasons and the pilot receiving instruction's failure to maintain aircraft control resulting in the stall. A factor contributing to the accident was the instructor pilot's delayed remedial action.Oct 7, 2007 · N11467 · DestroyedNTSB DFW08CA003Accident · Minor injuriesData collectionFinal reportCessna 172N · Oxford, MSThe pilots inadvertent stall during takeoff. A contributing factor was his failure to calculate the aircraft gross weight prior to the flight.Oct 7, 2007 · N5260J · Substantial damageNTSB CHI07CA315Accident · Minor injuriesData collectionFinal reportAerotechnik Sportstar-Evektor · Maple Lake, MNThe student pilot's failure to relinquish the flight controls and the flight instructor's inadequate supervision which resulted in the certified flight instructor not being able to maintain directional control. Contributing factors included the student…Sep 30, 2007 · N806EV · Substantial damageNTSB MIA07LA157Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wimauma, FLThe failure of the pilot to maintain airspeed while maneuvering for a precautionary landing following a reported loss of engine power for undetermined reasons.Sep 25, 2007 · N7961P · Substantial damageNTSB MIA07LA155Accident · 1 fatalLimited investigationFinal reportGrumman AA-5A · Worthington, KYThe separation of the engine's No. 4 piston from the crankshaft for unidentified reasons and the pilot's continued operation with known equipment deficiencies.Sep 22, 2007 · N26442 · Substantial damageNTSB ANC07FA102Accident · 1 fatalField investigationFinal reportCessna 180 · Whittier, AKThe failure of the pilot's seat to engage, or remain engaged, and the pilot's inadvertent stall/mush during takeoff-initial climb. Contributing to the accident was the failure of maintenance personnel to comply with an FAA AD regarding the pilot's seat rails.Sep 22, 2007 · N46209 · Substantial damageNTSB NYC07LA233Accident · 1 fatalLimited investigationFinal reportTemco GC-1B · New Smyrna Bch, FLA loss of engine power due to fuel starvation, which was the result of a blocked fuel tank vent.Sep 21, 2007 · N2455B · Substantial damageNTSB NYC07FA234Accident · Serious injuriesField investigationFinal reportBeech H-18 · Ft. Lauderdale, FLA total loss of engine power due to fuel starvation as a result of the pilot's failure to place the fuel selector for the right engine in the proper position. Contributing to the accident was the improper loading of the cargo.Sep 21, 2007 · N123MD · DestroyedNTSB CHI07LA302Accident · Serious injuriesLimited investigationFinal reportSiebert RV-9A · Barton City, MIThe pilot's failure to maintain adequate airspeed and aircraft control during initial climb after takeoff. Contributing to the accident was the gusting wind condition.Sep 20, 2007 · N3653 · Substantial damageNTSB ANC07FA103Accident · 1 fatalField investigationFinal reportShort Bros. SC-7 · McGrath, AKA collision with trees during takeoff-initial climb for an undetermined reason.Sep 20, 2007 · N2088Z · Substantial damageNTSB CHI07LA307Accident · No injuriesLimited investigationFinal reportBeech V35B · Ravenna, OHThe loss of engine power for an undetermined reason. Contributing to the accident was the tree that the airplane impacted during the forced landing.Sep 19, 2007 · N9271Q · Substantial damageNTSB ANC07CA101Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cooper Landing, AKThe pilot's failure to maintain altitude/clearance from objects, which resulted in an in-flight collision with trees during takeoff/initial climb. A factor contributing to the accident was the pilot's decision to takeoff into known adverse weather.Sep 19, 2007 · N2825Z · Substantial damageNTSB SEA07CA265Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Flagstaff, AZThe pilot's failure to attain an adequate airspeed, which resulted in a forced landing off the end of the runway. A contributing factor to the accident was the gusting wind.Sep 18, 2007 · N4764T · Substantial damageNTSB NYC07LA232Accident · Minor injuriesLimited investigationFinal reportFrancis SE5A Replica · Hendersonville, NCA total loss of engine power for undetermined reasons.Sep 17, 2007 · N7072E · Substantial damageNTSB NYC07CA230Accident · No injuriesData collectionFinal reportGrenier Kitfox IV · Moultonboro, NHThe failure of both spark plugs in the number 3 cylinder which resulted in a partial loss of engine power.Sep 16, 2007 · N20577 · Substantial damage