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 ANC86LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Tyonek, AKThe pilot stated that during the initial climb, the aircraft started to settle. The pilot stalled and crashed into a wooded area at the departure end of the runway.Aug 9, 1986 · N1491X · Substantial damageNTSB LAX86DVA13Accident · No injuriesFinal reportBell 47G-4A · Shafter, CAShortly after departing the loading rig, en route to an agricultural aerial application operation, the forward coupling tail rotor drive shaft failed. The helicopter was about 10 ft above ground level and about 100 ft west of the loading rig. The pilot…Aug 8, 1986 · N1185W · Substantial damageNTSB DEN86LA227Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Clark, COAfter the accident the pltstated that he was departing from a landing zone that was surrounded by tall trees. He also stated that after liftoff, as the helicopter climbed above the trees the wind either shifted direction or stopped and the helicopter began to…Aug 8, 1986 · N1110Z · Substantial damageNTSB SEA86FA194Accident · 1 fatalField investigationFinal reportCessna 310C · Vancouver, WAPlt not IFR rated. Attempted departure from own airstrip in fog during early dawn. Positive rate of climb not established. Acft contacted terrain 3/4 mile from runway end. Psgrs reported no sensation of power probs, but complete loss of ground ref at liftoff.…Aug 6, 1986 · N310MT · DestroyedNTSB NYC86LA200Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Grove City, PAThe instructor plt (CFI) rprtd that shortly after takeoff, after climbing out of gnd effect, the acft seemed to lvl off & stop climbing. He took control fm the student & proceeded to check the instruments, but no specific abnormality was determined. He…Aug 5, 1986 · N91356 · Substantial damageNTSB NYC86LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Farmingdale, NYThe Piper PA-38-112 had just taken off and was on crosswind when it experienced a power loss. The pilot landed in a cemetary and both the pilot and passenger received minor injuries. The aircraft received substantial damage. Examination of the acft revealed…Aug 5, 1986 · N9359T · Substantial damageNTSB MIA86LA228Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Indiantown, FLThe aerial application helicopter crashed just after lift-off after sustaining a power failure, the plt stated that he thought the reason for the failure could have been fuel starvation since he had observed some foreign matter in the fuel when he drained the…Aug 5, 1986 · N9086T · Substantial damageNTSB SEA86LA192Accident · Minor injuriesLimited investigationFinal reportCessna 185FII · Reno, NVPlt attempted takeoff with acft 540 pounds over max cert wt and 8500 ft density altitude conditions. Acft became airborne but positive climb and airspeed increase not possible. Plt turned to avoid obstructions, putting acft into semi-controlled collision with…Aug 4, 1986 · N185M · DestroyedNTSB NYC86FA196Accident · 1 fatalField investigationFinal reportGrumman TBM-3E · Brooklyn, CTThe acft was being flown to the owner's residence when the accident occurred. Shortly after takeoff black and white smoke was observed emitting from the eng cowling and the eng was heard sputtering. According to witnesses, the acft leveled off at an alt of…Aug 4, 1986 · N6581D · DestroyedNTSB CHI86FEM13Accident · Minor injuriesFinal reportPiper PA-28-140 · Menominee, MIThe acft lost eng pwr shortly after takeoff. The plt attempted to land back on the rwy but ran off the end into a ditch. The reason for the power loss could not be determined.Aug 4, 1986 · N4394J · Substantial damageNTSB NYC86LA193Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Lancaster, PAThe Piper PA-60 Aerostar was making a takeoff with five passengers on board. The PIC did not establish any procedures with his co-pilot prior to the takeoff. The aircraft continued off the 4100 ft runway to the overrun finally becoming airborne. The co-pilot…Aug 3, 1986 · N9531Q · Substantial damageNTSB MIA86LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Zellwood, FLThe flt sustained eng failure immediately after lift-off & collided with a tree near the end of the rwy. The plt stated that the take-off roll had been 'sluggish'. He said that it was his practice to keep his acft outdoors & to only fuel the tanks to about…Aug 3, 1986 · N9716J · Substantial damageNTSB CHI86LA195Accident · Serious injuriesLimited investigationFinal reportPiper J-3 · Peoria, ILThe plt reported that the acft stalled on takeoff, control was lost and the acft descended to impact with the terrain.Aug 3, 1986 · N40761 · DestroyedNTSB CHI86FEV04Accident · Minor injuriesFinal reportPate Quickie · Danville, ILAfter performing hi speed taxi tests, the plt of a new home built acft took off on the acft's 1st flt. After taking off,he realized something was wrong; however, by then, the acft was past the dep end of the rwy at 50 to 75 ft AGL & would not climb any…Aug 3, 1986 · N24RP · Substantial damageNTSB MKC86LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hugoton, KSThe PIC stated that the eng quit on takeoff abt 100 feet abv the gnd and 200 yds past the departure end of the rwy. The PIC stated that he had no warning prior to the engine quitting. The acft dscnd to the gnd, impacted hard and subsequently flipped over…Aug 2, 1986 · N8677H · Substantial damageNTSB SEA86LA186Accident · No injuriesLimited investigationFinal reportCessna 210 · Hillsboro, ORThe pilot reported that he struck a post on take-off and broke off the main landing gear wheel. The pilot proceeded to Hillsboro, Oregon where an emergency landing was made on a paved runway with the landing gear still extended. The stub caught in the runway…Aug 1, 1986 · N1782X · Substantial damageNTSB SEA86FA211Accident · Serious injuriesField investigationFinal reportSchweizer SGS-2-33 · Toledo, WAThe weak link at the tow vehicle broke during launching. The plt lowered the nose of the acft and turned into the wind. The plt stated that the acft was stalled and that he was unable to stop the descent rate. The acft struck the runway in a slight nose down…Aug 1, 1986 · N5720S · Substantial damageNTSB CHI86FEP08Accident · Minor injuriesFinal reportNorth American T28D-FENNEC · Madison, WIAfter the aircraft was initally taxied for takeoff, the pilot returned to the ramp and stated that he was experiencing engine problems. He inquired at an FBO about chartering an aircraft to take himself and his son to an experimental aircraft association…Aug 1, 1986 · N128RM · Substantial damageNTSB SEA86LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Snohomish, WAThe student was attempting to depart with a quartering tailwind. The aircraft was veering to the left of the centerline and the pilot rotated prematurely. The aircraft settled back to the ground to the left of the runway onto uneven terrain. At the time of…Jul 28, 1986 · N6509L · Substantial damageNTSB MKC86LA162Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Dumas, ARThe pilot stated that after takeoff, during initial climb, he heard grinding metal and smelled hot metal before the engine slowed down and seized. After crash landing in a corn field, the pilot further stated, he noticed smoke coming from the engine…Jul 28, 1986 · N5694X · DestroyedNTSB CHI86FA183Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Plainfield, ILWitnesses who spoke with plt of N6135L prior to accident stated that he was acting out of character. He had a loss of appetite and his complexion was ashen grey. The plt stated that he did not feel well before the flt. Witnesses observed the acft takeoff,…Jul 28, 1986 · N6135L · DestroyedNTSB MKC86LA158Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Audubon, IAThe pilot stated that the engine was developing full power during the brake release and takeoff roll but that the aircraft would not accelerate to lift-off speed as fast as expected. Upon reaching 70 m.p.h.(61 KTS.), and after a takeoff roll of 2,000 feet,…Jul 27, 1986 · N9835U · Substantial damageNTSB DEN86FA211Accident · Serious injuriesField investigationFinal reportSteven Soper Pitts S-1T · Shelby, MTDuring initial climb after takeoff from a private ranch airstrip, the acft engine quit. The plt had inadvertently left the fuel selector switch in the no. 2 position which allowed oil, normally used to produce smoke during aerial demonstrations, to enter the…Jul 27, 1986 · N155NK · DestroyedNTSB BFO86FID10Accident · 1 fatalFinal reportQuickie Q200 · Newport News, VAThe acft went out of control and crashed from aprx 100 AGL after takeoff. The acft was on a test flt and after the crash the plt said that the acft was pulling to the rt during takeoff so he reduced power. The acft continued to pull rt before nosing down to…Jul 27, 1986 · N45CX · DestroyedNTSB ANC86FA114Accident · 2 fatalField investigationFinal reportInterstate S-1B2 · Wasilla, AKWitnesses rprtd that immediately after taking off from the Wasilla lake seaplane base, the acft entered a steep climbing turn. Shortly thereafter, it entered a steep dscnt & crash into the water. There was evidence that the acft entered a stall/spin prior to…Jul 27, 1986 · N51AA · Substantial damageNTSB NYC86LA187Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Boston, MAShortly after takeoff, the aircraft was unable to continue climb out. The pilot lowered the nose to level flight, however the airspeed continued to drop and the aircraft crashed. The continued drop in the airspeed was undetermined.Jul 26, 1986 · N333TE · DestroyedNTSB CHI86LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Middleton, WIThe CFI and student had been practicing touch-and-go's and had just made a full stop landing. The CFI reported that during a subsequent soft field takeoff, accelleration seemed a little slow, and after lift-off, the aircraft seemed to stop accelerating…Jul 26, 1986 · N2444N · Substantial damageNTSB MKC86LA157Accident · No injuriesLimited investigationFinal reportRandolph R.Clark KR-2 · Russell, KSThe pilot had just completed some adjustments to the carburetor and was making a high-speed taxi test when he became airborne. He applied more power to avoid stalling and immediately thereafter, the engine started running rough. He then decided to make a…Jul 25, 1986 · N151RC · Substantial damageNTSB DEN86FA207Accident · Serious injuriesField investigationFinal reportCessna 140 · Taos, NMN76541 took off on rwy 04 on a high density altitude day. The acft was seen climbing with the nose high near the departure end of the rwy. The acft just cleared some electrical lines near the end of the rwy and then was observed to descend down to a height…Jul 25, 1986 · N76541 · Substantial damageNTSB MKC86LA155Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Harrisburg, ARThe aerial application airplane was departing from a short strip on a hot day. The pilot said the airplane would not climb and he was forced to put it down in a flooded rice field where it nosed forward to the inverted position. The pilot stated he should…Jul 23, 1986 · N8494K · Substantial damageNTSB NYC86LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Plymouth, MAShortly after takeoff, the tow was released from the glider when its nose started rising uncontrollably. The glider thencollided with the ground & was substantially damaged. The plt rprted the accident could have been avoided by more info &emphasis on the…Jul 22, 1986 · N33985 · Substantial damageNTSB SEA86FA174Accident · 1 fatalField investigationFinal reportWeiss-Haynes Stits SA6B · Big Creek, IDN3HW, a stits SA6B, was being flown from an airstrip with a density altitude of about 7,800 feet. The plt lost control of the acft during initial climb and the acft descended into the trees, struck the ground, and caught fire. The plt stated that during…Jul 20, 1986 · N3HW · DestroyedNTSB NYC86LA191Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Portland, CTWhile climbing, shortly after takeoff, the eng quit for undetermined reasons. The pilot autorotated into a sand bank where the helicopter received substantial damage.Jul 20, 1986 · N59400 · Substantial damageNTSB MIA86FA216Accident · 3 fatalField investigationFinal reportBeech V35 · Tampa, FLThe private pilot transmitted to the contrl tower shortly after lift off that he had a door ajar, and he was turning back to the runway. Witnesses saw the aircraft execute a teardrop type of turn back to the runway with a nose high attitude, gear down and in…Jul 20, 1986 · N3872N · DestroyedNTSB FTW86LA134Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Plano, TXThe pilot tried twice to rotate the aircraft before it lifted off at approximately 800 feet down the runway. At 100 feet above the ground, the aircraft started veering to the west side of the runway in a nose high attitude, stalled and nosed down impacting…Jul 20, 1986 · N83847 · Substantial damageNTSB DEN86LA203Accident · No injuriesLimited investigationFinal reportRotec Panther II Plus · Sundance, WYThe plt said that on the first flight of N990RE, the vehicle revealed some undesirable flt control characteristics. He said that after landing he installed both doors and then attempted another take off. It was shortly after take off that the plt lost control…Jul 20, 1986 · N990RE · Substantial damageNTSB CHI86FEM11Accident · Serious injuriesFinal reportCessna 150E · Muskegon, MIThe plt rprtd that drg takeoff, the acft lifted off at about the midpoint of the rwy & climbed to just above treetop level. He turned the acft slightly into the wind, then noted that it seem to lose the ability to climb further. The stall warning horn sounded…Jul 20, 1986 · N4072U · Substantial damageNTSB FTW86FA133Accident · 4 fatalField investigationFinal reportCessna 421 · Addison, TXWitnesses reported a normal takeoff and climb was made to an alt of aprx 400 ft AGL at which time eng pwr ceased/ decreased. The rt wing then dropped, the nose and lt wing rose and the acft entered a near vertical descent to ground impact. Post accident exam…Jul 19, 1986 · N6VR · DestroyedNTSB MIA86LA210Accident · No injuriesLimited investigationFinal reportBeech 35 · Plymouth, FLThe plt lost control of the acft when it rotated early due to the elevator trim tab being set at four notches nose up. The acft then stalled & landed hard collapsing the landing gear. The plt failed to use a checklist.Jul 16, 1986 · N417B · Substantial damageNTSB CHI86FEC05Accident · No injuriesFinal reportJerry Berry MONO-FLY · Blissfield, MIThe acft was damaged in a forced lndg after a power loss at 200 ft AGL. The plt/owner had an ignition problem with the eng quitting in flt. After ground checks & repairs the eng was ground run successfully but during test flt it quit again. An attempt was…Jul 15, 1986 · N84JL · Substantial damageNTSB ATL86FEI08Accident · Serious injuriesFinal reportFairchild 24R-46 · Canton, OHThe plt reported that he was taking off after making a touch and go ldg; as he 'pushed (the) throttle forward on lift-off (the) engine began to quit'. The engine subsequently quit altogether at about 200-300 feet AGL over the departure end of the rwy.…Jul 15, 1986 · N77670 · Substantial damageNTSB MKC86LA150Accident · No injuriesLimited investigationFinal reportStainbrook Avid Flyer · Salina, KSThe PIC had been practicing touch and go landings at a private air strip. At 50 feet AGL the PIC stated the engine quit and he descended into the ground off the rwy. Post accident inspection of the eng revealed that the propeller reduction gearing had broken…Jul 14, 1986 · N146AF · Substantial damageNTSB DEN86LA197Accident · No injuriesLimited investigationFinal reportCessna A150N · Akron, COThe plt stated the acft he was piloting encountered a severe downdraft during initial climbout, which forced the acft to the ground. Upon ground contact, the acft nosed over onto its back.Jul 14, 1986 · N757GH · Substantial damageNTSB CHI86FA170Accident · Serious injuriesField investigationFinal reportGrumman AA5B · Benton Harbor, MIThe aircraft departed on runway 09. Passenger remembers the pilot starting to turn back to the airport when the wings went perpendicular to the horizon and the ground came rushing up. Teardown of the engine revealed a bent push rod and a split push rod shroud…Jul 14, 1986 · N81259 · DestroyedNTSB LAX86LA290Accident · No injuriesLimited investigationFinal reportCessna 195B · San Diego, CAThe airplane departed montgomery airport, runway 28L, San Diego, CA. Shortly after departing a fire erupted in the upper cowling area. The pilot executed an emergency landing on runway 05, but landed hard. Examination of the wreckage disclosed the number 2…Jul 13, 1986 · N195JB · Substantial damageNTSB FTW86LA128Accident · No injuriesLimited investigationFinal reportCessna U-206G · Decker'S Island, TXDuring take-off the pilot did not compensate for a strong crosswind and allowed the aircraft to drift sideways where the main gear collided with a fallen tree separating it from the aircraft and causing the aircraft to veer and collide with the ground.Jul 13, 1986 · N9611Z · Substantial damageNTSB SEA86LA166Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAShortly after takeoff at an alt of aprx 110 ft AGL, a loss of pwr occurred due to the #2 cylinder failing. The acft nosed over during the subsequent forced landing in a wheat field. The plt then extinguished a small exhaust fire.Jul 12, 1986 · N5698X · Substantial damageNTSB FTW86LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Broken Arrow, OKThe pilot made his takeoff from the intersection of a cinder packed runway, allowing only 900 feet before the end of the runway. Gross weight of the aircraft at the time of the accident was 1,700 lbs.; maximum gross weight of the aircraft is 1,670. The…Jul 12, 1986 · N65548 · DestroyedNTSB ANC86LA105Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Stoney River, AKAccording to a witness, a certificated pilot, a crowd had gathered to wave, watch the takeoff and take photographs. The airplane began its takeoff roll about mid point on the airstrip and rolled 120 feet before lifting off. The airplane climbed steeply and…Jul 12, 1986 · N1825A · Substantial damageNTSB NYC86LA179Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newburyport, MAPilot made a precautionary landing after experiencing a rudder control failure after a banner pick up. The left aft rudder cable had parted 49.5 inches aft of the rudder pedal attachment point.Jul 11, 1986 · N9574S · Substantial damage