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 ATL82FA195Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Birmingham, ALDuring takeoff, the aircraft collided with rising terrain about 3/10 mile north of runway 36. The pilot reported that the airspeed decayed and the aircraft mushed into the ground. No preimpact malfunction or failure was found. The temperature and dew point…Jul 14, 1982 · N98316 · Substantial damageNTSB ATL82FA184Accident · 1 fatalField investigationFinal reportCessna 152 · Charleston, SCPlt made steep turn after takeoff & stalled. Acft came to rest on the arpt about 1500 ft from the point where the takeoff run was initiated & about 200 ft north of rwy 9. It was necessary for the plt to be airborne by 0700 in order for him to make his first…Jul 13, 1982 · N6234L · DestroyedNTSB NYC82DA151Accident · No injuriesFinal reportCessna 180J · Ebensburg, PAThe accident flight was the last leg of a series of flights that day, which included other refueling of the aircraft, during this refueling the fuel pump for the ground storage tank slowed and stopped before total refueling was accomplished. The pilot stated…Jul 12, 1982 · N52192 · Substantial damageNTSB NYC82DA150Accident · No injuriesFinal reportCessna 172N · Millinocket, MEAfter takeoff at about 50 ft AGL the plt reached down to recover his watch which had fallen to the floor. At the same time the pax accidently pushed forward on the other wheel causing the acft to hit the water & nose over. The acft sank &was not recovered.Jul 11, 1982 · N1302FNTSB DEN82DA133Accident · No injuriesFinal reportPiper PA-25D-260 · Edgeley, NDThe aircraft lost power on takeoff and a forced landing was made in an open field. The aircraft had been refueled from barrels by the pilot. His fuel contained water from recent rain. During an examination of the aircraft, water was found in the fuel pump;…Jul 11, 1982 · N9792P · Substantial damageNTSB MIA82FA151Accident · 1 fatalField investigationFinal reportPiper PA-18 · Key Largo, FLAircraft climbed steeply after takeoff, stalled and descended vertically to the ground. Pilot had no certificate.Jul 10, 1982 · N3997P · DestroyedNTSB FTW82FPD15Accident · 2 fatalFinal reportCessna 150H · Wichita Falls, TXThe acft was observed to become airborne in a nose high attitude after approximately 1,200 ft of ground run, gain no more than 200 ft of altitude, make a wide left turn to downwind, stall & spin. The high angle of attack was maintained throughout the flt. The…Jul 10, 1982 · N6538S · DestroyedNTSB DCA82AA028Accident · 153 fatalFinal reportBoeing 727-235 · New Orleans, LAThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-83-02. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm The…Jul 9, 1982 · N4737 · DestroyedNTSB CHI82DA243Accident · No injuriesFinal reportCessna 182 · Downers Grove, ILThe aircraft collided with a tree during forced landing on a golf course after the engine lost power at 300 feet AGL during takeoff. Water was found in the sumps and carburetor. The right fuel tank cap was not sealing. The pilot reported that the wing sumps…Jul 9, 1982 · N60PS · Substantial damageNTSB ANC82DAA08Accident · No injuriesFinal reportCessna 170B · 50 Mi Sw Fairba, AKThe plt made a short field takeoff from the 1300 ft gravel strip. He rotated near the end of the strip, but did not recall the airspeed. As the acft reached about 15 ft AGL it started to sink & the right main gear caught in brush tearing off the gear.Jul 9, 1982 · N9717F · Substantial damageNTSB SEA82DA103Accident · No injuriesFinal reportCoot Amphibian · Bellingham, WAThe aircraft was being flown on a local test flight following a new engine installation. This was only the second flight for this home built aircraft. During climb-out, the engine lost power and there was insufficient altitude for a normal runway landing. The…Jul 8, 1982 · N9931X · Substantial damageNTSB FTW82DA273Accident · No injuriesFinal reportGrumman G-164A · Mccrory, ARThe agriculture aircraft lost power during takeoff and an emergency forced landing was made in a soybean field. During the landing roll, the aircraft flipped over.Jul 8, 1982 · N8691H · Substantial damageNTSB FTW82FPM13Accident · Serious injuriesFinal reportBoeing A75 · Tulsa, OKA witness located at the departure end of the runway stated that the aircraft climbed to an altitude of approximately 400 feet when the engine stopped running. In a nose high atitude the left wing was observed to drop and a stall occurred. The pilot had no…Jul 7, 1982 · N69CB · Substantial damageNTSB DEN82DA131Accident · No injuriesFinal reportEnstrom 280C · Steamboat Sprin, COThe pilot stated that during lift-off he was distracted by persons on the ground waving their arms. The aircraft drifted to the left and contacted a tree after which the pilot landed the aircraft and it rolled over.Jul 7, 1982 · N5693R · Substantial damageNTSB NYC82DA141Accident · No injuriesFinal reportGrumman American AA-5A · Marstons Mills, MAThe pilot stated that the aircraft was slow to gain normal lift-off speed due to the surface of the airstrip. He also stated that after prematurely vaulting the aircraft into the air the aircraft never gained sufficient airspeed for a climb. The aircraft…Jul 5, 1982 · N9657U · DestroyedNTSB NYC82DA140Accident · No injuriesFinal reportCessna U206 · Nelson, NHThe pilot of the float equipped aircraft stated that during takeoff, there was a loss of power and lift. He tried to turn and land; however, the plane crashed into the lake and was destroyed. The pilot and passengers evacuated without injury.Jul 5, 1982 · N2147F · DestroyedNTSB MKC82DA117Accident · No injuriesFinal reportStinson HWW-75 · St. Louis, MOAccording to the pilot the fuel tank gauges indicated about one-eight full prior to a takeoff for a flight around the traffic pattern. After takeoff the engine quit and a forced landing was made in a soybean field. The aircraft nosed over during the landing…Jul 5, 1982 · N23710 · Substantial damageNTSB LAX82FA244Accident · Minor injuriesField investigationFinal reportBeech 60 · Santa Monica, CAAt about 700 ft MSL the plt reported to Santa Monica tower that his left eng had failed. He immediately feathered the left prop & continued to climb, planning to attempt a restart before returning to land. At about 1,000 ft MSL the pilot determined that the…Jul 5, 1982 · N726RP · DestroyedNTSB LAX82FUM09Accident · 1 fatalFinal reportPitts S1-S · Fallbrook, CAWitness statements varied widely in the description of the accident. One witness stated the acft appeared to do a fast & tight barrell roll after reaching approximately 50-70 ft AGL. Another witness observed the acft take off at an unusually high angle, then…Jul 4, 1982 · N6HA · DestroyedNTSB FTW82DA264Accident · No injuriesFinal reportGlassflugel 604 · Refugio, TXThe pilot accidently released the tow line at about 50 feet AGL when his parachute caught on the tow release handle. In attempting to turn to the runway, he dragged a wing. The glider fuselage broke aft of the cockpit.Jul 4, 1982 · N604VP · Substantial damageNTSB FTW82DA263Accident · Minor injuriesFinal reportPietenpol Aircamper · Sanger, TXThe flight was limited to pattern work. The aircraft bounced on the second landing and the pilot elected to go around. During the turn to downwind, the engine began to lose power. The pilot was unable to maintain altitude and elected to land in an open field.…Jul 4, 1982 · N4662T · Substantial damageNTSB NYC82DA153Accident · No injuriesFinal reportSchweizer SGS-1-36 · New London, NHWhile being towed during takeoff, the weak link on the tow rope failed when the glider was about 125 ft AGL. The pilot started to land on a golf course ahead, but spotted golfers in his intended landing area. The glider stalled while he was in a steep turn.…Jul 3, 1982 · N3620Y · Substantial damageNTSB LAX82FJA05Accident · No injuriesFinal reportSchweizer SGS 1-34 · Dillingham, HIThe glider was about 5 feet above the rwy during a tow takeoff with the L-19 tow plane about ready to leave the ground when the glider plt switched hands on the control stick & apparently hit the cockpit canopy latch causing the canopy to open violently. The…Jul 3, 1982 · N7657 · Substantial damageNTSB FTW82DA262Accident · No injuriesFinal reportCessna 150 · Fort Worth, TXThe pilot was a local flight practincing landings and had an engine failure during the second climb out. He made an emergency forced landing straight ahead and collided with a ditch. He stated the aircraft had about 3 gallons of fuel before takeoff. Both…Jul 3, 1982 · N6673G · Substantial damageNTSB CHI82FA231Accident · 2 fatalField investigationFinal reportCessna 150J · New York Mills, MNThe acft took off from a 2,500 ft alfalfa field which initially sloped downward then upward near the point of lift-off. A witness stated the acft did not appear to climb. The acft collided with 40 ft high power lines approximately 1000 ft from the point of…Jul 3, 1982 · N61330 · Substantial damageNTSB ATL82DA185Accident · No injuriesFinal reportPiper PA-28-151 · Duncan, MSPilot attempted takeoff from strip with 4 inch deep grass and a 75 degree crosswind. Occupants weighed total of 490 lbs. Temperature was 94 degrees. Aircraft mushed back into ground and pushed gear struts through wing.Jul 3, 1982 · N41661 · Substantial damageNTSB FTW82DA261Accident · Minor injuriesFinal reportCessna T310P · Dallas, TXThe aircraft owner, who had not flown for one year, and a flight instructor were on an instructional flight to prepare the owner for a flight review. After flying about one hour, they returned to the airport and began practicing landings. After the second…Jul 2, 1982 · N303TC · Substantial damageNTSB FTW82DA260Accident · No injuriesFinal reportPiper PA-39 · New Orleans, LAPilot stated he lost power on left engine during takeoff so he elected to abort. The acft landed hard off the end of runway and collapsed all landing gear.Jul 2, 1982 · N125AC · Substantial damageNTSB ANC82FAA07Accident · 2 fatalFinal reportMaule M-5 · Fairbanks, AKEarlier in the day the plt returned from a flt after experiencing a rough running eng & changed the spark plugs. The acft again departed the chena marina arpt. Witnesses observed the acft level off approximately 300 to 350 ft AGL. One witness observed the…Jul 2, 1982 · N6172M · DestroyedNTSB LAX82FA245Accident · No injuriesField investigationFinal reportHiller UH-12L3 · Stockton, CAThe pilot reported that the engine lost power at about 5 ft AGL as he was taking off from a trailer. He turned to avoid a gas and water tank near the poll truck. The helicopter came to rest, right-side-up, but was damaged. A fuel leak was found in a line that…Jul 1, 1982 · N86689 · Substantial damageNTSB DEN82DA124Accident · No injuriesFinal reportLuscombe 8F · Calhan, COThe pilot took off from an airport with a density altitude of about 9500 ft. after lift-off, the aircraft reached an altitude of about 100 ft AGL and then stopped climbing. The pilot initiated emergency procedures which included leaning the mixture and…Jul 1, 1982 · N1370B · Substantial damageNTSB LAX82DA238Accident · Minor injuriesFinal reportCessna 205 · El Centro, CAThe pilot reported that the engine lost power during takeoff. During a forced landing, the aircraft hit a ditch and was substantially damaged. An engine teardown revealed no preimpact malfunction or failure.Jun 30, 1982 · N8100Z · DestroyedNTSB CHI82FA228Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201 · Washington, ILDuring takeoff, the aircraft struck a pile of lumber that was 62 ft from the departure end of the runway. Two witnesses believed that the pilot did not use all off the runway for takeoff. One witness estimated that the pilot began the takeoff about 150 ft…Jun 30, 1982 · N2124U · DestroyedNTSB ATL82FA182Accident · Serious injuriesField investigationFinal reportCessna 150L · Hendersonville, NCReportedly, the engine power was normal during the engine run-up, ground roll and lift-off. However, shortly after takeoff at an altitude of about 250 ft AGL, the engine coughed, sputtered and lost power. At about the same time, two witnesses noticed that the…Jun 30, 1982 · N1750Q · DestroyedNTSB CHI82DA226Accident · No injuriesFinal reportPiper PA-38 · Lowell, MIDuring the administration of a private pilot flight test, the prospective private pilot failed to gain sufficient airspeed on takeoff to enable the aircraft to climb. Approximately 3/4THS of the way down the runway the check pilot elected to abort the takeoff…Jun 28, 1982 · N9595T · Substantial damageNTSB FTW82FRD16Accident · 1 fatalFinal reportPiper PA-32-260 · Belle Chasse, LAThe acft departed southern seaplane's land rwy 20 & climbed to approximately 200-300 ft where it was observed trailing white smoke. It travelled approximately 1.6 mi from its departure point & struck a tree on the bank of the algiers outfall canal. Eng tear…Jun 26, 1982 · N3446W · Substantial damageNTSB CHI82DEG03Accident · Serious injuriesFinal reportBenson B8M · Hamilton, OHThe gyrocopter pilot initiated a takeoff from the grass media between the taxiway and runway 29. After lifting off, he climbed to an altitude of about 40 to 50 ft, then turned toward the runway. At about the same time, a Piper PA-28 was taking off on the…Jun 26, 1982 · NONE · Substantial damageNTSB LAX82DA234Accident · Minor injuriesFinal reportBell 47J-2 · Corcoran, CADuring takeoff from a landing dolly, the pilot lost directional control and the helicopter began to spin to the right. He realized that he had a tail rotor failure, but reported that he was half over the dolly and headed toward a jet ranger and a fuel system.…Jun 25, 1982 · N1141W · DestroyedNTSB FTW82DA249Accident · No injuriesFinal reportSnow 600-S2C · Ozona, TXThe pilot had finished a spray operation on the previous day and was moving the aircraft to a new location. During takeoff, the engine lost power and the plane was landed in a bushy/wooded area. During landing, the right wing was damaged. The pilot…Jun 25, 1982 · N1676S · Substantial damageNTSB ANC82FAA06Accident · Serious injuriesFinal reportPiper PA-18-150 · Fairbanks, AKDuring the takeoff roll, the aircraft became airborne prematurely as it crossed over a dip in the runway. As it bounced, it also veered to the left toward saplings beside the runway. The pilot reported that he was in a nose high stall, but he lowered the nose…Jun 25, 1982 · N90946 · Substantial damageNTSB FTW82DA245Accident · No injuriesFinal reportPiper PA-28-236 · Fort Worth, TXThe aircraft crashed into trees after engine failure during takeoff. A fuel line was leaking. The engine had been written up as malfunctioning and was being tested when the accident occurred.Jun 24, 1982 · N2114D · Substantial damageNTSB ANC82DAG33Accident · 1 fatalFinal reportPiper PA-14 · Talkeetna, AKThe pilot step taxied the float plane to the north end of neil lake in preparation for a south takeoff. Approaching the north shore, a left step turn was initiated to postion the aircraft to the south for a takeoff. During the turn, while still on a northerly…Jun 24, 1982 · N5173H · DestroyedNTSB SEA82FA093Accident · Serious injuriesField investigationFinal reportStinson 108-3 · Lopez Island, WAThe aircraft engine stopped at 400 feet AGL during climbout. The pilot executed a turn at minimum airspeed and landed the aircraft on a golf course. The landing gear and engine mounts failed. Investigation revealed the aircraft's fuel tanks were empty.Jun 23, 1982 · N6954M · DestroyedNTSB FTW82DPG16Accident · Minor injuriesFinal reportCallair A-9 · Hollygrove, ARThe pilot departed the Hollygrove flying service airport, made an immediate left turn, and sank into the trees east of the airport. He managed to dump the full load of chemicals before impact with the trees. The aircraft gave no indicationof any mechanical…Jun 23, 1982 · N7296V · Substantial damageNTSB CHI82FA223Accident · No injuriesField investigationFinal reportCessna 337B · Greenville, ILDuring the initial climb after a touch & go, the rear eng stopped at about 100 to 200 ft AGL. The plt switched the fuel selector to right aux tank but was unable to restart the rear eng. At about 300 to 400 ft AGL the front eng stopped. The plt switched the…Jun 22, 1982 · N2419S · Substantial damageNTSB MIA82FA136Accident · 1 fatalField investigationFinal reportAero Commander S2R · Lakeland, FLThe pilot had planned to fly the foreign registered aircraft to miami, FL to visit the venezuelan consulate's office before continuing on to venezuela. The aircraft was modified with an auxiliary fuel tank in the hopper. Also, authorization was obtained to…Jun 21, 1982 · YV419 · DestroyedNTSB LAX82FVG27Accident · 1 fatalFinal reportRyan PT-22 · Orland, CAAt about 50 ft in the air the acft turned left & straight down.Jun 21, 1982 · N49086 · DestroyedNTSB ANC82DA051Accident · Minor injuriesFinal reportCessna 172 · St. Mary'S, AKPilot found considerable water in fuel during preflight. During takeoff engine quit. Pilot made intersection takeoff allowing less than half of runway available. Tried to land on road during forced landing but used dirt alongside because of truck. Aircraft…Jun 21, 1982 · N9191H · Substantial damageNTSB MIA82DA135Accident · Minor injuriesFinal reportCessna 182P · Chuluota, FLThe pilot reported a normal preflight check was made which included draining fuel from the fuel tank sumps and the strainer. He reported that about one inch of water (in a fuel sampler cup) was drained from the left wing. No water was noted in the right wing…Jun 20, 1982 · N9834E · Substantial damageNTSB LAX82DA228Accident · No injuriesFinal reportCessna 152 · Scottsdale, AZDuring a dual instructional flight, the student pilot and instructor pilot (ip) were practicing touch and go landings. After practicing a soft field approach and landing, the student initiated a short field takeoff with full power and 10 degrees of flaps.…Jun 20, 1982 · N4947H · Destroyed