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 BFO93LA140Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Woodbine, NJThe pilot maintaining too steep of an angle of climb and an inadequate airspeed which resulted in an inadvertent stall/mush and subsequent loss of control in flight resulting in a collision with the runway. The pilot's lack of experience in the type of…Jul 28, 1993 · N2971D · Substantial damageNTSB SEA93LA166Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Dayton, WAThe loss of engine power, undetermined. A factor relating to the accident was a fence in the flt path.Jul 27, 1993 · N5646J · Substantial damageNTSB CHI93LA289Accident · No injuriesLimited investigationFinal reportChampion 402 · Valparaiso, INFailure of the exhaust stack assembly.Jul 27, 1993 · N9981Y · Substantial damageNTSB CHI93LA286Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Birmingham, MIAn improper grade of fuel was loaded into the airplane by the owner/operator of the rental airplane, improper planning and/or decision by the pilot, and subsequent vapor lock in the fuel system of the airplane (fuel system - other), which resulted in fuel…Jul 26, 1993 · N1976W · Substantial damageNTSB CHI93LA278Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · West Plains, MOThe loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.Jul 26, 1993 · N6723B · DestroyedNTSB LAX93LA299Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oceano, CAThe student pilot's misjudging the landing flare altitude and his improper recovery from a bounced landing. Factors relating to this accident are the student pilot's lack of total experience and failure to raise the flaps.Jul 25, 1993 · N6331M · Substantial damageNTSB ANC93LA127Accident · Minor injuriesLimited investigationFinal reportBeech D18S · Kodiak, AKThe pilot's improper in flight planning/decision. A factor was the partial loss of power on one engine.Jul 25, 1993 · N2053D · Substantial damageNTSB ANC93LA126Accident · No injuriesLimited investigationFinal reportCessna 207 · Egegik, AKThe pilot-in-command's failure to see and avoid the truck.Jul 25, 1993 · N9993M · Substantial damageNTSB NYC93FA138Accident · 2 fatalField investigationFinal reportRobinson R22 · Warsaw, KYThe pilot's inadequate visual lookout and his failure to maintain adequate clearance with ground obstacles, which resulted in an inflight collision with a power line.Jul 24, 1993 · N9021Z · DestroyedNTSB DEN93LA085Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Durango, COThe failure of the tow plane pilot to warn the glider pilot that he was releasing the tow line. A factor was: an inadvertent stall by the pilot in command.Jul 24, 1993 · N48069 · DestroyedNTSB CHI93LA279Accident · No injuriesLimited investigationFinal reportCessna 150M · Bridgman, MIthe pilot's premature lift-off.Jul 24, 1993 · N66155 · Substantial damageNTSB CHI93LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sparta, MIthe separation of the rear landing light gasket into the air induction path.Jul 24, 1993 · N95478 · Substantial damageNTSB CHI93IA312Incident · No injuriesIncident investigationFinal reportBritish Aerospace 146-300A · Chicago, ILwas a crack in the fuel system fuel flow distribution manifold which resulted from an inadequate design by the manufacturer.Jul 21, 1993 · N611AW · Minor damageNTSB BFO93LA133Accident · Serious injuriesLimited investigationFinal reportBeatty Glasair SH-2 · Cape May, NJInadequate preflight by the pilot by not assuring the fuel selector was in the proper position for takeoff, which resulted in fuel starvation and subsequent loss of engine power; and failure of the pilot to maintain sufficient airspeed, which resulted in a…Jul 21, 1993 · N522EB · DestroyedNTSB ANC93LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKFuel contamination and the pilot in command's improper preflight planning/decision. A factor was the pilot's inadequate airspeed with which to make a normal landing following the engine power loss.Jul 21, 1993 · N472GF · 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 ANC93LA121Accident · No injuriesLimited investigationFinal reportCessna 206G · Kelly River Bar, AKThe pilot's failure to assure that adequate takeoff distance was available. The rough/uneven terrain was a factor.Jul 19, 1993 · N756AH · Substantial damageNTSB SEA93LA156Accident · 1 fatalLimited investigationFinal reportStark Rand KR-2 · Townsend, MTThe loss of engine power due to the failure of the improperly modified magneto and loss of control in flight by the PIC while maneuvering to return to the airport.Jul 18, 1993 · N2AL · DestroyedNTSB DEN93LA080Accident · Minor injuriesLimited investigationFinal reportGlasflugel Standard Libell · Boulder, COImproper rigging of the spoiler system by maintenance personnel, which caused an uncommanded spoiler deployment and prevented spoiler retraction by the pilot. A factor was unsuitable terrain for a forced landingJul 16, 1993 · N4362 · Substantial damageNTSB MIA93FA155Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Jacksonville, FLAn explosion and fire from undetermined fuel and ignition sources in the left wing.Jul 15, 1993 · N2200Q · DestroyedNTSB BFO93LA123Accident · 1 fatalLimited investigationFinal reportRolando Rans S-10 · Numidia, PAThe excessive maneuver attempted by the pilot which resulted in a loss of control in flight and an inadvertent spin at an altitude insufficient for recovery.Jul 15, 1993 · N217ER · DestroyedNTSB LAX93LA289Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · La Jolla, CAthe failure of the injured ground crewman to release his hold on the basket in a timely manner when instructed by the pilot.Jul 13, 1993 · N2809D · No damageNTSB LAX93FA287Accident · 3 fatalField investigationFinal reportCessna 402C · Las Vegas, NVThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern. A factor which contributed to the accident was the pilot's failure to assure that the nose baggage compartment door was secured.Jul 12, 1993 · N818AN · DestroyedNTSB LAX93LA286Accident · No injuriesLimited investigationFinal reportStephens VP2 · Lodi, CAthe grounding of the magneto coil to the magneto case due to a crack in the coil sheath.Jul 11, 1993 · N31349 · Substantial damageNTSB CHI93LA261Accident · No injuriesLimited investigationFinal reportBeech F33A · Kahoka, MOThe pilot's premature liftoff. The soft runway condition was a factor.Jul 10, 1993 · N18RB · Substantial damageNTSB FTW93LA214Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bono, ARThe airplane's takeoff performance being exceeded by the PIC. A factor was the pilot's inability to safely reject the takeoff.Jul 9, 1993 · N8522V · Substantial damageNTSB ANC93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot-in-command's improper positioning of the fuel selector. Factor was the soft condition of the forced landing area.Jul 9, 1993 · N1ZA · Substantial damageNTSB LAX93FA282Accident · Minor injuriesField investigationFinal reportPiper PA-34-200 · La Verne, CAThe flight instructor's failure to obtain/maintain best the single-engine rate-of-climb airspeed, and his failure to ensure that the landing gear was retracted. A factor related to the accident was contamination in the fuel system, which blocked fuel flow…Jul 8, 1993 · N1392T · DestroyedNTSB FTW93FA207Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Little Rock, ARThe pilot's loss of control of the airplane as a result of physical impairment.Jul 7, 1993 · N95851 · Substantial damageNTSB CHI93LA244Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · California, MOThe pilot in command's failure to maintain adequate airspeed.Jul 7, 1993 · N5638W · Substantial damageNTSB LAX93LA280Accident · No injuriesLimited investigationFinal reportCessna 172N · Truckee, CAThe partial loss of engine power during the takeoff initial climb for undetermined reasons. A factor in the accident was the unsuitable nature of the terrain for a forced landing.Jul 6, 1993 · N3090E · Substantial damageNTSB CHI93DTK01Accident · 1 fatalFinal reportCrowser Avid MK 3.75 · Philip, SDThe pilot's selection of unsuitable terrain for takeoff, and the pilot inadvertently stalling the airplane.Jul 5, 1993 · N42CJ · DestroyedNTSB BFO93LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Mayville, NYThe pilot's failure to select the proper runway for takeoff, and his failure to maintain clearance with terrain. A factor related to the accident was a prevailing tailwind.Jul 5, 1993 · N1990P · DestroyedNTSB MIA93LA149Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Ocala, FLPremature lift off by the pilot during takeoff.Jul 4, 1993 · N8962L · Substantial damageNTSB BFO93LA105Accident · 1 fatalLimited investigationFinal reportAdolfson Starduster SA300 · Windsor, NYLoss of engine power during initial climbout due to undetermined reasons. A factor related to the accident was the pilot's failure to maintain adequate airspeed following the loss of engine power, leading to an aerodynamic stall.Jul 4, 1993 · N10JA · DestroyedNTSB ANC93LA111Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Dillingham, AKThe pilot in command's attempt to takeoff with insufficient airspeed. A factor in the accident was the pilot in command's selection of unsuitable terrain on which to land and takeoff.Jul 3, 1993 · N9597S · Substantial damageNTSB CHI93LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Felton, MNThe pilot-in-command's failure to maintain airspeed. Factors contributing to the accident were a cracked carburetor float, fuel starvation, and the failure to perform an annual inspection.Jul 2, 1993 · N1841A · DestroyedNTSB BFO93FA103Accident · 2 fatalField investigationFinal reportCessna 180K · Webster, NHThe pilot's inadequate preflight planning/preparation, his failure to assure proper weight and balance of the aircraft for takeoff, and his failure to obtain and/or maintain adequate airspeed, which resulted in a stall. A possible factor related to the…Jul 1, 1993 · N2880K · DestroyedNTSB ANC93FA107Accident · Minor injuriesField investigationFinal reportCessna 185 · Wasilla, AKThe pilot in command's failure to use all of the available runway (waterway). A factor in the accident was the pilot in command's lack of recent experience in the type of operation.Jul 1, 1993 · N93018 · Substantial damageNTSB NYC93LA135Accident · No injuriesLimited investigationFinal reportBeech C23 · Montgomery, NYA power loss due to a collapsed air duct and a consequent blockage of induction air, which resulted in a forced landing and an on ground collision with a ditch.Jun 30, 1993 · N66347 · Substantial damageNTSB CHI93LA239Accident · Serious injuriesLimited investigationFinal reportAeronca AC7B · Kearney, MOThe pilot in command's failure to maintain adequate airspeed and the aircraft exceeding maximum allowable gross weight.Jun 29, 1993 · N1032E · Substantial damageNTSB NYC93LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-236 · West Milford, NJA manufacturer's defect which resulted in fatigue failure of the magneto impluse coupling spring and the loss of engine power. A factor was unsuitable terrain.Jun 27, 1993 · N8220J · Substantial damageNTSB CHI93LA237Accident · Serious injuriesLimited investigationFinal reportDaniel Squire HI-MAX · Omro, WIthe pilot's inadequate preflight planning and preparation. A factor in the accident is the downdraft.Jun 27, 1993 · N200D · Substantial damageNTSB CHI93DEE02Accident · Minor injuriesFinal reportDouglas B-26B · Kankakee, ILthe failure of the piston assembly in the number ten cylinder of the right engine. A factor associated with the accident was the inoperative propeller feathering system for the right engine.Jun 27, 1993 · N8036E · Substantial damageNTSB MIA93LA147Accident · Serious injuriesLimited investigationFinal reportPiper PA-38 · St. Petersburg, FLThe loss of engine power for undetermined reasons, which resulted in the aircraft being ditched.Jun 26, 1993 · N25459 · Substantial damageNTSB CHI93FA225Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Elwell, MIImproper use of the fuel selector by the pilot, which resulted in fuel starvation.Jun 26, 1993 · N7779P · Substantial damageNTSB ATL93LA117Accident · Serious injuriesLimited investigationFinal reportTemco GC-1B · Cleveland, GAThe pilot's improper use of carburetor heat, resulting in a partial loss of engine power during the initial climb. Factors were the carburetor icing conditions, and the trees located at the departure end of the airstrip.Jun 26, 1993 · N3255K · Substantial damageNTSB FTW93LA196Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Edgard, LAThe pilot's attempt to takeoff under conditions that exceeded the performance capability of the aircraft. A factor was the high density altitude.Jun 25, 1993 · N9772G · Substantial damageNTSB FTW93LA195Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A Dromader · Wheatley, ARThe pilot's operation of the airplane beyond its takeoff performance limitations and inadvertent stall. A factor was high density altitude.Jun 23, 1993 · N116RA · Substantial damageNTSB SEA93LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Ephrata, WAUndetermined loss of power and the lack of suitable terrain. A factor contributing to the accident was dark night conditions.Jun 22, 1993 · N7591J · Destroyed