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 ATL86LA246Accident · No injuriesLimited investigationFinal reportBeech 95 · Springfield, TNThe instructional flt had been in the air for about 45 min when the instructor told the plt to return to the arpt and land. Upon entering the traffic pattern the plt was told to make a touch and go landing. He completed two of these maneuvers and was…Sep 6, 1986 · N2030C · DestroyedNTSB ANC86LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Farewell, AKAircraft lost control and crashed while attempting takeoff from gravel bar. Pilot estimated left crosswind to be 10 gusting to 30 knots.Sep 5, 1986 · N5907Y · Substantial damageNTSB MIA86LA246Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Palmetto, FLThe CFI was demonstrating a simulated short field takeoff on a grass airstrip to his student. During the takeoff roll, the plt stated the acft was performing normally, but after lift-off, he was unable to climb out of ground effect. The acft collided with a…Sep 4, 1986 · N938SC · Substantial damageNTSB DEN86LA247Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1A · Chinook, MTThe acft took off on a 3900-foot dry asphalt rwy. An uncommanded left yaw developed which the plt was unable to counter. The acft struck a fence off the left side of the rwy and nosed over.Sep 4, 1986 · N6401L · Substantial damageNTSB ATL86FMG10Accident · Serious injuriesFinal reportQuickie Q2 · Clinton, NCThe acft was destroyed during a forced lndg after a power loss during takeoff climb. The plts son witnessed the takeoff & saw the acft descend below trees north of the arpt. He said that the eng sounded out of time. During a post acc eng inspection the…Sep 4, 1986 · N206JB · DestroyedNTSB SEA86LA238Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Kent, WAA forced landing was made due to a loss of power for undetermined reasons. The power loss occurred at about 600 feet AGL. A slight left turn was made to land onto a road. The aircraft's left wing struck a tree separating it from the aircraft. The aircraft's…Sep 1, 1986 · N66BW · DestroyedNTSB NYC86LA229Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Haven, CTDuring a simulated engine out on takeoff, the student plt leveled the acft instead of lowering the nose to maintain airspeed. The CFI took over control of the acft, however, the airspeed was too slow to arrest the rate of descent. The acft contacted the…Sep 1, 1986 · N2447B · Substantial damageNTSB NYC86LA226Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · So. Berwick, METhe acft experienced a loss of eng power while leveling off at 2,500 ft MSL shortly after takeoff. Remedial action was attempted, however, power was not regained. The plt initiated a 180 deg turn back toward the arpt but altitude was insufficient to reach the…Sep 1, 1986 · N26784 · Substantial damageNTSB ATL86LA236Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Coshocton, OHThe plt initiated a maximum power takeoff from a confined parking lot with 2 passengers on board. The area was boardered by obstructions & people. The plt rprtd that during lift-off, she increased power to 2900 RPM, lifted off to a 4' hover with 33' of…Sep 1, 1986 · N549H · Substantial damageNTSB NYC86LA224Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Butler, PAA loss of eng power was experienced shortly after takeoff at an alt of aprx 400 ft AGL. The acft contacted wires and descended uncontrolled to terrain impact during the forced landing descent. Post accident inspection of the acft revealed aprx 4 ounces of…Aug 31, 1986 · N3649J · DestroyedNTSB MKC86FA181Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Elkhart, KSThe student plt intended to fly from his home arpt to a nearby arpt where he was receiving flt instruction. No record of a wx briefing was found. Local authorities said there were low clouds and fog in the area at the time of the accident. No one saw the acft…Aug 31, 1986 · N4233J · DestroyedNTSB DEN86LA243Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Dexter, NMPlt and pax were taking off from 1900 ft x 50 ft turf rwy 30. Plt said she lifted off at 45 mph and initiated climb of 55 mph. At 250 ft AGL acft suddenly lost 100 ft. acft then went into steep right bank. Acft cleared power lines. Right wing contacted ground…Aug 31, 1986 · N8856S · DestroyedNTSB LAX86FUM03Accident · No injuriesFinal reportEipper Quicksilver MX 2 · Pine Valley, CAJust after lift-off at an altitude of aprx 10 ft AGL, the ultralight acft began to settle back to the dirt runway. The plt turned the acft to the right to avoid colliding with trees, however, the nose gear caught in the brush and the acft nosed over. There…Aug 30, 1986 · N57999 · Substantial damageNTSB FTW86LA161Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Grand IsleThe acft crashed into the gulf of Mexico following a suspected eng failure shortly after lift off from an offshore platform. The plt stated that after takeoff, while at 40 KTS and 200 ft above the water, he heard a loud squeal followed by the low RPM audio…Aug 30, 1986 · N3905G · DestroyedNTSB FTW86FA156Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A-2 · Houston, TXThe ends of the outer string and the inner reinforcing wire of the engine air intake duct were not properly positioned under the duct clamp during installation. As a result, they unwound during engine operation and moved out of their normal position on and in…Aug 30, 1986 · N6198L · DestroyedNTSB FTW86FA154Accident · 2 fatalField investigationFinal reportPiper PA-12 · Big Sandy, MTStudent pilot on unauthorized cross country flight departed unimproved field on VFR flight for the purpose of spotting game. Weather conditions in the area were conducive for light to moderate turbulence. Witnesses reported the acft wings rocked violently…Aug 30, 1986 · N2532M · DestroyedNTSB ATL86LA234Accident · No injuriesLimited investigationFinal reportBenham Midget Mustang M-1 · Rome, GAThe plt reported he took off too close behind a preceding acft and was caught in the wing tip vorticies. The vortices combined with a 110 deg left crosswind (wind 070/20 gusting higher) resulted in a loss of control and ground impact. The plt said he was in a…Aug 30, 1986 · N545JS · Substantial damageNTSB ATL86FA231Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Mansfield, OHAcft took off from pvt sod strip. Father of plt said eng sounds were normal during run up. Acft appeared to be climbing with a normal attitude when the eng quit. Subsequently, acft was stalled followed by a near vertical nose down impact and post impact fire.…Aug 30, 1986 · N9698P · DestroyedNTSB ANC86LA140Accident · No injuriesLimited investigationFinal reportCessna 182 · Iliamna, AKThe pilot stated that he lost control of the aircraft; the aircraft stalled on takeoff and the aircraft struck the lake and rolled over on the gravel bar.Aug 30, 1986 · N5227R · Substantial damageNTSB MIA86LA245Accident · No injuriesLimited investigationFinal reportBeech G-35 · Lantana, FLShortly after takeoff the cabin door opened. The pilot continued the short flight to his home airfield. During approach he stated that due to the increased noise in the cabin he forgot to lower the landing gear. The aircraft contacted the runway with the…Aug 29, 1986 · N1883D · Substantial damageNTSB NYC86LA221Accident · No injuriesLimited investigationFinal reportCessna 150H · Leroy, NYThe flt experienced an engine failure shortly after takeoff due to fuel starvation. The plt was flying the aircraft on the left tank which had no appreciable amount of fuel, while the right tank contained 12 to 13 gallons on fuel.Aug 27, 1986 · N6659S · Substantial damageNTSB ATL86LA230Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Shellman, GAJust after liftoff, the plt noted smoke and attributed it to an overhauled prop which had just been installed. He then heard a loud squeal from the eng and noted a loss of power. A forced landing was made in a rough corn field, where the acft was damaged. An…Aug 27, 1986 · N5042X · Substantial damageNTSB MIA86LA243Accident · Minor injuriesLimited investigationFinal reportGrumman G-44A · Hawthorne, FLThe plt stated that upon touchdown on the lake the acft felt strange. He added full pwr and took off again but just after takeoff the acft rolled to the right and the nose dove. He removed pwr and with the controls full back, the acft hit the water with no…Aug 26, 1986 · N1629H · Substantial damageNTSB ANC86LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Stoney River, AKThe pilot stated that after liftoff he failed to maintain airspeed. The aircraft stalled and crashed into the River.Aug 26, 1986 · N400TH · Substantial damageNTSB NYC86FHM03Accident · 1 fatalFinal reportSchempp-Hirth Ventus A · Middletown, NYThe sailplane was being towed into the air. It was observed to come off the ground in a tail low attitude and then start porposing. The aircraft was released from the tow plane and impacted. The pilot was fatally injured and the aircraft destroyed. No…Aug 24, 1986 · N7XT · DestroyedNTSB MKC86LA174Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau Bergfalke II-55 · Hutchinson, KSThe pilot stated that he performed what he thought was a thorough pre-flight inspection, including the installation of the horizontal tail, before he pushed the aircraft onto the runway and hooked the tow line. Immediately after liftoff, the pilot further…Aug 24, 1986 · N5924 · Substantial damageNTSB LAX86FVA15Accident · Minor injuriesFinal reportI.C.A. Brasov IS-28M2 · Porterville, CADuring initial climb, shortly after takeoff, the pilot heard a loud whir then a boom sound. The aircraft started vibrating so the pilot shut down the engine. Having gained 200 to 300 feet of alt the pilot initiated a left 180 deg turn to attempt a forced…Aug 24, 1986 · N9023B · Substantial damageNTSB LAX86FA328Accident · 2 fatalField investigationFinal reportCessna 172L · Grand Canyon, AZThe acft crashed in a wooded area shortly after departing rwy 21 at Grand Canyon national park arpt (gcn). The plt had made a precautionary landing at gcn during the x-country flt to page, AZ, so he call a fss having been unable to establish contact in-flt.…Aug 24, 1986 · N7382Q · DestroyedNTSB CHI86LA209Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Milford, MIThe pilot used full power and 10 degrees of flaps to perform a short field takeoff from a sod strip. He rotated for takeoff less than halfway down the 1100 ft runway, then kept the acft low to accelerate to 80 KTS. He then pulled up to clear a row of 40 ft…Aug 24, 1986 · N8765S · Substantial damageNTSB SEA86FA216Accident · 3 fatalField investigationFinal reportGlasair SH2 · Roche Harbor, WAThe acft was one of a group of glasairs that were departing the airport after a fly in breakfast at the resort. Witnesses reported the acft departed on runway 06 (uphill) in a 3 point attitude. As the acft continued down the runway, in a steep nose up climb,…Aug 23, 1986 · N394SK · DestroyedNTSB LAX86LA330Accident · No injuriesLimited investigationFinal reportCessna 182U · Tuba City, AZThe acft collided with a dirt bank after losing alt during the initial climb after takeoff from a dirt road. The plt indicated the acft became airborne after an aprx 800 ft ground run and climbed to an alt of 10 ft AGL. The acft then encountered a gust of…Aug 23, 1986 · N5299N · Substantial damageNTSB CHI86LA211Accident · No injuriesLimited investigationFinal reportCessna 175 · Muskegon, MIJust prior to applying takeoff power the pilot switched to the left fuel tank. Fuel from this tank had never been used by this pilot since he purchased the aircraft two weeks earlier. Shortly after breaking ground the engine quit. Although the pilot switched…Aug 23, 1986 · N9275B · Substantial damageNTSB ANC86LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nabesna, AKDuring the initial climbout the pilot stalled the aircraft, lost control and crashed off the departed end of the airstrip. At the time of the accident, the pilot departed with a tailwind.Aug 23, 1986 · N2994Z · Substantial damageNTSB ANC86LA132Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Two Lakes, AKThe pilot lost control of the aircraft on the initial climb. The pilot stated that after takeoff the wind shifted 180 degrees.Aug 20, 1986 · N7481K · Substantial damageNTSB CHI86FEM14Accident · No injuriesFinal reportPiper PA-25-235 · White Pigeon, MIThe pilot took off with a full load of seed on a 1300 ft runway during shifting wind conditions. He struck a fence before he had enough airspeed to establish a climb.Aug 18, 1986 · N6862Z · Substantial damageNTSB SEA86LA208Accident · Minor injuriesLimited investigationFinal reportCurtiss JN4-D · Vancouver, WAThe plt reported a normal takeoff was made with 1300 RPM. At liftoff a small amount of black smoke emitted from both exhaust stacks and the RPM dropped to 1250. After clearing the rwy, more black smoke emitted and the RPM dropped to 1200. The plt cleared two…Aug 17, 1986 · N511JN · Substantial damageNTSB NYC86LA211Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Moultonboro, NHThe plt rprtd that he departed the Moultonboro arpt at about 2200 EDT. During departure, the acft stalled & crashed into trees about 1/2 mi northwest of the arpt.Aug 16, 1986 · N9909L · Substantial damageNTSB CHI86LA205Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Linden, MIThe newly certificated pvt plt with three passengers was attempting to practice a short field takeoff on the 2500 ft long asphalt runway. The owner's manual recommends 25 degrees of flaps to perform the takeoff. The plt did not extend any flaps. After…Aug 16, 1986 · N40754 · Substantial damageNTSB NYC86LA210Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Nantucket, MAThe pilot made a precautionary landing on a beach shortly after takeoff when the engine stopped running. However during engine examination, nothing was found to determine malfunction or failure.Aug 15, 1986 · N1515B · Substantial damageNTSB MIA86LA236Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Jacksonville, FLThe plt stated that just after takeoff, the eng sputtered and lost power. He landed the acft in the grass on the right side of runway 31, rolled aprx 100 yards, struck a sign, and veered left into soft dirt collapsing the nose gear. Post crash examination and…Aug 15, 1986 · N4539X · Substantial damageNTSB LAX86LA323Accident · Serious injuriesLimited investigationFinal reportBeech 35R · Sun City West, AZA Beechcraft BE-35R lost alt during initial climb and collided with the ground after takeoff from a private airstrip. The plt described the takeoff as normal until he reached an alt of 100 to 125 ft AGL and started to turn left. The plt stated, 'the aircraft…Aug 15, 1986 · N3371V · Substantial damageNTSB SEA86LA199Accident · No injuriesLimited investigationFinal reportSchweizer 2-22EK · Easton, WAThe instructor pilot was flying the glider with a student in the front seat on a local instructional flight. About 2200 ft down the 2640 foot grass strip, the tow aircraft, at about 50 to 100 feet AGL, lost power and started to descend back to the runway. The…Aug 14, 1986 · N2723Z · Substantial damageNTSB SEA86LA198Accident · No injuriesLimited investigationFinal reportCessna 188 · Easton, WAThe tow plane with glider attached began losing pwr at aprx 50 ft AGL during takeoff. The tow plt signaled the glider plt for tow release. The two plts landed on the remaining rwy. The tow plane skidded into the trees off the end of the rwy. Investigation…Aug 14, 1986 · N5506S · Substantial damageNTSB ANC86LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Rochez Moutonee, AKAfter departing the gravel bar, the aircraft banked to the left; the aircraft stalled and crashed.Aug 13, 1986 · N4293Z · Substantial damageNTSB MKC86LA170Accident · No injuriesLimited investigationFinal reportTeratorn Tierra 2 · Dixon, IAThe experimental acft was loaded near max gross wt on takeoff from the pvt sod airatrip. The plt stated the acft performed sluggishly during the climbout from the field. The plt stated that on the climbout that he was overflying a corn field bordering the…Aug 12, 1986 · N5575Y · Substantial damageNTSB NYC86LA206Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Sussex, NJThe Piper PA-28-140 had just taken off when the main cabin door unlocked at the top. The pilot returned for a landing, had to go-around due to traffic, and was on final for his second approach, with the top of the main cabin door still unlocked. When, passing…Aug 11, 1986 · N5803U · Substantial damageNTSB SEA86LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Preston, IDThe jackson county sheriff reported that the pilot was attempting to take off from a farmer's field and failed to clear a dike. Subsequently, the acft cartwheeled into a county landfill and was damaged.Aug 10, 1986 · N5576F · Substantial damageNTSB ATL86FA217Accident · Minor injuriesField investigationFinal reportPiper PA-28-161 · Douglasville, GAThe plt loaded three adults plus herself into the warrior ii and attempted to take off from a grass strip which had a dip and a hill of about 6 feet near the departure end. The acft traveled about 150 ft past the end of the runway before impacting on the side…Aug 10, 1986 · N8340F · DestroyedNTSB SEA86LA200Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Elko, NVPlt executed forced lndg following pwr loss on initial climb. Acft tanks (16 gal cap ea) had been topped two hours prior, fuel receipt shows 16.6 added, refueler recalled abt 8 gals added per tank. Plt checked visually and on gages during preflight.…Aug 9, 1986 · N9148A · Substantial damageNTSB ATL86FMG09Accident · 1 fatalFinal reportGray Drifter XP · Orangeburg, SCThe homebuilt acft crashed shortly after takeoff. Witnesses reported hearing a loss of power during initial climb. The acft then entered an abrupt right turn and descended to ground impact. Post accident bench test of the engine failed to disclose any…Aug 9, 1986 · N4817N · Destroyed