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 WPR09LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taylor, AZThe loss of engine power for undetermined reasons.Jul 6, 2009 · N5957U · Substantial damageNTSB WPR09LA336Accident · Minor injuriesLimited investigationFinal reportThomas C. Piper Murphy Rebel · Idaho Falls, IDA total loss of engine power during initial climb due to fuel starvation. The underlying reason for the fuel starvation condition could not be determined.Jul 5, 2009 · N5PQ · Substantial damageNTSB WPR09FA326Accident · 1 fatalField investigationFinal reportCessna 150 · South Lake Tahoe, CAA partial loss of engine power due to a malfunctioning carburetor and the pilot’s failure to maintain adequate airspeed while maneuvering to return to the runway. Contributing to the accident was the high density altitude.Jul 5, 2009 · N51172 · Substantial damageNTSB WPR09CA329Accident · No injuriesData collectionFinal reportNalis Glastar · Arlington, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank prior to takeoff.Jul 5, 2009 · N432P · Substantial damageNTSB CEN09CA408Accident · Serious injuriesData collectionFinal reportCessna 150B · Conway, ARThe total loss of engine power for undetermined reasons.Jul 5, 2009 · N1124Y · Substantial damageNTSB CEN09CA510Accident · No injuriesData collectionFinal reportWohnoutka Steven M Team Z MAX · Iowa, LAA total loss of engine thrust during initial climb due to the failure of the airplane's propeller as a result of preexisting damage.Jul 4, 2009 · N301SS · Substantial damageNTSB CEN09CA406Accident · Serious injuriesData collectionFinal reportNorth American T-28B · Waxahachie, TXThe total loss of engine power for undetermined reasons.Jul 4, 2009 · N28NB · Substantial damageNTSB WPR09LA330Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Tracy, CAThe loss of engine power for undetermined reasons.Jul 3, 2009 · N51459 · Substantial damageNTSB WPR09LA324Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Tucson, AZThe pilot’s failure to maintain directional and lateral aircraft control during takeoff. Contributing to the accident was the partial loss of left engine power for undetermined reasons.Jul 3, 2009 · N7657Y · Substantial damageNTSB ERA09WA406Accident · Serious injuriesForeign investigationPiper PA-34-200T · Imperatrize, Maranhao, BrazilOn July 3, 2009, at 2146 UTC, a Piper PA-34-200T, PT-RFU, registered to and operated by Heringer Taxi Aereo LTD, as a cargo flight,lost engine power on one engine after takeoff from Imperatriz, Maranhao Airport, Brazil. The pilot attempted to return to the…Jul 3, 2009 · PT-RFU · Substantial damageNTSB ERA09CA382Accident · No injuriesData collectionFinal reportCessna 172H · Clifton, METhe pilot's mismanagement of his fuel supply which resulted in fuel starvation and a loss of engine power.Jul 3, 2009 · N1782F · Substantial damageNTSB WPR09LA323Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Burley, IDThe flight instructor's failure to maintain clearance from power lines during takeoff.Jul 1, 2009 · N87487 · Substantial damageNTSB WPR09CA479Accident · Minor injuriesData collectionFinal reportSchleicher ASK-21 · Jean, NVThe pilot's failure to maintain control of the glider during the initial climb due to an inadvertent encounter with wind.Jun 30, 2009 · N63JJ · Substantial damageNTSB ERA09LA371Accident · 1 fatalLimited investigationFinal reportLayson Stanley B Steen SKY Bolt · High Point, NCThe pilot’s failure to maintain clearance from power lines during takeoff.Jun 27, 2009 · N233VW · Substantial damageNTSB CEN09FA393Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Lakeview, ARThe pilot's poor judgment/decision making in attempting the no-flap takeoff, his failure to comply with weight and balance limitations, and his failure to calculate the airplane's performance under exiting conditions.Jun 26, 2009 · N38171 · Substantial damageNTSB WPR09FA309Accident · 4 fatalField investigationFinal reportBeech B95 · Holbrook, AZThe pilot’s decision to depart when ill and his failure to maintain control of the airplane during a return to the airport, likely because of his physical illness and drug impairment.Jun 25, 2009 · N912T · Substantial damageNTSB CEN09LA385Accident · 1 fatalLimited investigationFinal reportSchendl Mustang II · West Union, OHThe pilot's failure to maintain adequate airspeed after a loss of engine power for undetermined reasons, which resulted in an aerodynamic stall/spin at a low altitude.Jun 25, 2009 · N152AS · Substantial damageNTSB WPR09LA308Accident · 2 fatalLimited investigationFinal reportMayo RV-6A · Cottonwood, AZThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.Jun 23, 2009 · N413RV · Substantial damageNTSB CEN09CA371Accident · Serious injuriesData collectionFinal reportBuckeye Dream Mach · Marian, INThe pilot's failure to maintain clearance with the utility pole and power lines.Jun 23, 2009 · N2526J · Substantial damageNTSB WPR09CA303Accident · No injuriesData collectionFinal reportCessna A188B · Ogden, UTA partial loss of engine power due to the number one cylinder air induction tube becoming disconnected for undetermined reasons.Jun 20, 2009 · N731GE · Substantial damageNTSB ERA09CA359Accident · No injuriesData collectionFinal reportAircraft Mfg & Development CH 601XL S · Vaughn, MSThe pilot's inadequate preflight planning.Jun 20, 2009 · N2601 · Substantial damageNTSB ERA09FA355Accident · Serious injuriesField investigationFinal reportSchweizer 269C-1 · Naples, FLA loss of engine power due to the improper installation of the right magneto by maintenance personnel resulting in subsequent loss of engine power. Contributing to the accident was the inadequate 100-Hour inspection by the mechanic when he failed to note that…Jun 18, 2009 · N9421K · Substantial damageNTSB ERA09WA353Accident · 2 fatalForeign investigationCessna 150 · Urmantany, RussiaOn June 15, 2009, at approximately 0605 universal time coordinated, a Cessna 150L, Russian registration RA-0848G, impacted terrain during a force landing shortly after takeoff. The accident location was approximately 1 kilometer east of Urmantany, in the…Jun 15, 2009 · RA-0848G · Substantial damageNTSB ERA09LA352Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Islesboro, MEA loss of engine power due to fuel contamination.Jun 15, 2009 · N33243 · Substantial damageNTSB ERA09LA346Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Magee, MSA total loss of engine power after takeoff for undetermined reasons.Jun 14, 2009 · N5202U · Substantial damageNTSB ERA09FA345Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Scotia, NYThe flight instructor's failure to ensure that the airplane was properly configured for a short field takeoff, and his decision to not abort the takeoff.Jun 14, 2009 · N3226R · Substantial damageNTSB WPR09LA286Accident · Serious injuriesLimited investigationFinal reportWermling KR-2 Rand Robinson · Anaconda, MTThe non-certificated pilot’s failure to maintain airspeed and aircraft control during initial climb resulting in a stall/spin.Jun 13, 2009 · N40908 · Substantial damageNTSB ERA09LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Lawrenceville, VAA loss of engine power due to carburetor icing.Jun 13, 2009 · N22075 · Substantial damageNTSB ERA09FA343Accident · 1 fatalField investigationFinal reportCessna 177 RG · Gilford, NHA loss of engine power due to oil exhaustion from the fracture of the nipple for the engine oil cooler return line. Contributing to the accident was the mechanic's signoff and release of the airplane without performing the required engine run-up following an…Jun 13, 2009 · N52670 · Substantial damageNTSB ANC09CA056Accident · No injuriesData collectionFinal reportMaule M-5-235C · Wasilla, AKThe pilot's selection of an unsuitable takeoff area with an unfavorable wind.Jun 12, 2009 · N407X · Substantial damageNTSB ERA09CA332Accident · No injuriesData collectionFinal reportTeratorn Tierra · Cutchogue, NYThe pilot's decision to attempt takeoff from unsuitable terrain.Jun 7, 2009 · Unregister · Substantial damageNTSB CEN09CA418Accident · No injuriesData collectionFinal reportCessna 550 · Sellersburg, INAn in-flight collision with a large bird during the airplane's initial climb.Jun 5, 2009 · N73HH · Substantial damageNTSB ERA09CA313Accident · Minor injuriesData collectionFinal reportPensinger Zodiac 601 · Greeneville, TNAn encounter with wind shear on initial climb after takeoff.May 31, 2009 · N250JP · Substantial damageNTSB WPR09LA268Accident · Serious injuriesLimited investigationFinal reportMaule M-5-210C · Ogden, UTA loss of engine power during takeoff for undetermined reasons.May 28, 2009 · N315X · Substantial damageNTSB ERA09LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Jasper, ALA total loss of engine power due to fuel starvation as a result of the flight instructor's improper fuel management.May 26, 2009 · N1669H · Substantial damageNTSB ERA09FA303Accident · 1 fatalField investigationFinal reportAero Commander 500 S · Daytona Beach, FLA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight inspection.May 25, 2009 · N73U · Substantial damageNTSB ERA09CA306Accident · Minor injuriesData collectionFinal reportCessna 152 · Lumberton, NJThe pilot's failure to maintain aircraft control during initial climb, which resulted in a loss of adequate airspeed and a subsequent aerodynamic stall.May 25, 2009 · N49396 · Substantial damageNTSB CEN09LA325Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Skiatook, OKLoss of engine power for undetermined reasons.May 23, 2009 · N4892D · Substantial damageNTSB CEN09CA334Accident · Minor injuriesData collectionFinal reportAerotrike Safari · Lake City, MIThe pilot's failure to maintain adequate airspeed during the initial climb.May 23, 2009 · N8035W · Substantial damageNTSB WPR09CA256Accident · No injuriesData collectionFinal reportWesterhout/Gagnier Escapade · Healdsburg, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional/lateral control during the initial climb.May 21, 2009 · N29DY · Substantial damageNTSB CEN09LA311Accident · 2 fatalLimited investigationFinal reportThornton RV-6A · Plainwell, MIThe pilot's failure to maintain aircraft control for undetermined reasons.May 21, 2009 · N39JT · DestroyedNTSB CEN09CA302Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Gallup, NMThe pilot's inadequate preflight planning. Contributing to the accident was the high density altitude.May 16, 2009 · N94300 · Substantial damageNTSB ANC09GA040Accident · No injuriesFinal reportRobinson Helicopter R44 · Iliamna, AKThe main rotor transmission mount design, which resulted in an in-flight vibration/oscillation, and damage to the helicopter during an emergency descent and hard landing. Contributing to the accident was the lack of information from the manufacturer regarding…May 12, 2009 · N7196H · Substantial damageNTSB WPR09CA232Accident · Minor injuriesData collectionFinal reportAtkins John RAF 2000 G · South Prairie, WAThe pilot's abrupt maneuver to avoid a collision that resulted in an airspeed reduction and subsequent loss of lift provided by the rotor system. Contributing to the accident was the failure of both pilots to maintain an adequate visual lookout for other…May 9, 2009 · N1435X · Substantial damageNTSB WPR09CA231Accident · Serious injuriesData collectionFinal reportFuhrmann-Super Emeraude Stretched · Peach Springs, AZThe airplane's encounter with turbulence after takeoff, which resulted in an uncontrolled descent and collision with terrain.May 8, 2009 · N11LF · Substantial damageNTSB CEN09LA284Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Alpine, TXThe loss of engine power due to disengagement of the magneto idler gear support pin.May 8, 2009 · N60HG · Substantial damageNTSB CEN09CA253Accident · No injuriesData collectionFinal reportCessna 172N · Roanoke, TXThe partial loss of engine power due to a failure of the throttle control rod-end to carburetor arm hardware. A contributing factor was the pilot's decision to fly the airplane without a current annual inspection.May 8, 2009 · N172SV · Substantial damageNTSB CEN09CA283Accident · No injuriesData collectionFinal reportGulfstream-Schweizer A/C Gulfstream · Iowa, LAA partial loss of engine power due to the Number 8 cylinder head cracking and separating from the barrel.May 7, 2009 · N8080K · DestroyedNTSB ERA09FA283Accident · 2 fatalField investigationFinal reportBeech K35 · Lantana, FLA total loss of engine power due to disengagement of the idler gear support pin as a result of improper maintenance.May 6, 2009 · N111YR · Substantial damageNTSB ANC09LA038Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Bethel, AKThe pilot’s failure to remove visible frost from the wings during the preflight inspection, and his failure to maintain adequate airspeed to avoid a stall. Contributing to the accident were conditions conducive to structural icing/frost.May 6, 2009 · N629SP · Substantial damage