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 FTW88DRG06Accident · Minor injuriesFinal reportHodges Condor III +2 · Canyon Lake, TXThe homebuilt airplane was being flown by the new owner and his son. After two takeoffs and landings, the airplane was 5O feet in the air when the engine quit. The pilot stated in his report, 'we suspect a kill switch was inadvertently touched and this was…Feb 21, 1988 · N5539Z · Substantial damageNTSB BFO88LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Annapolis, MDThe plt said he did a preflight inspection of the acft which included a check for water in the fuel. Tanks were partially full- 17 gals in each one. A pre-takeoff eng runup was normal. During the initial takeoff climb the eng had a partial power loss. After…Feb 21, 1988 · N32019 · Substantial damageNTSB DCA88MA032Accident · 12 fatalMajor investigationFinal reportFairchild SA227-AC · Cary, NCThe aircraft departed during low ceiling, low visibility, and night conditions. Shortly after takeoff the aircraft impacted a reservoir. Analysis of radar data indicated the acft was in a 45 degree descending turn. Exam of the acft trim system showed that the…Feb 20, 1988 · N622AV · DestroyedNTSB CHI88IA073Incident · No injuriesIncident investigationFinal reportBoeing 747-227B · Chicago, ILFailure of the tower cab supervisor to assure that coordination between the south local controller and north local controller had been completed. A factor is the failure of FAA tower management to insure there were personnel manning the cab coordinator…Feb 19, 1988 · N635US · 2 aircraft · No damageNTSB LAX88DUJ03Accident · No injuriesFinal reportBeech F33A · Goodyear, AZDuring an instructional flight, after takeoff, at 300 feet, the pilot and student said they heard a loud bang. The engine experienced a loss of power and the pilot noted that the top of the engine cowling was gone. A forced landing was made off the runway.…Feb 18, 1988 · N6785Y · Substantial damageNTSB BFO88FA022Accident · 1 fatalField investigationFinal reportCessna 150M · So. Charleston, WVThe stu plt said the engine began to alternate between partial and full power during the initial tkf climb. The acft was about 100 ft AGL and about 300 ft past the rwy end. According to the stu the inst took control of the acft, turned left, reversed course…Feb 17, 1988 · N9399U · DestroyedNTSB MKC88LA053Accident · No injuriesLimited investigationFinal reportBeech 23 · Grain Valley, MOWhile practicing soft field takeoffs, the student pilot stated that he overrotated, establishing too high a nose up attitude. The aircraft entered a departure stall, followed by uncontrolled descent to the terrain.Feb 16, 1988 · N18868 · Substantial damageNTSB SEA88LA046Accident · 2 fatalLimited investigationFinal reportCessna 305A (L-19) · Jean, NVWitnesses observed acft enter 45 deg climb attitude on liftoff, climb to about 200 ft AGL, then enter left turn. Acft appeared to stall, wing dropped and nose fell through to impact 100 yds left of runway. Flaps found set at 60 deg vs. max 30 deg setting…Feb 14, 1988 · N5173G · DestroyedNTSB FTW88LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Maud, TXThe acft took off from a 1800 ft private, turf, strip. The takeoff was to the sw and the wind was strong and gusty from the nw. There are trees along the right or upwind side of the rwy. Shortly after takeoff, the acft encountered turbulence and collided with…Feb 14, 1988 · N9319T · DestroyedNTSB ATL88FA088Accident · 1 fatalField investigationFinal reportCessna 150H · Youngstown, OHFeb 9, 1988 · N618DP · Substantial damageNTSB NYC88LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Westerly, RIThe plt reported that he experienced a power loss at 350 ft AGL after takeoff. He turned back toward the airport but had insufficient altitude. He elected to land off-airport at an industrial site with the stall warning horn sounding. During landing roll, the…Feb 6, 1988 · N3210J · Substantial damageNTSB NYC88LA076Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Williamstown, NJThe flight departed runway 27 at cross keys airport and upon reaching 250 feet altitude, the engine lost power and began vibrating. The pilot maneuvered to return to the airport but was unable to reach it. The aircraft crashed in a yard about 1/2 mile from…Feb 5, 1988 · N2352N · DestroyedNTSB NYC88LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hammonton, NJThe plt reported that he experienced a power loss after takeoff at about 100 feet AGL near the end of rwy 30. He said the acft stalled at treetop level, collided with trees, and came to rest in a nosedown attitude. The plt reported that he initiated the flt…Feb 5, 1988 · N2126J · DestroyedNTSB LAX88DVD02Accident · No injuriesFinal reportCessna A188B · Lodi, CAFeb 5, 1988 · N2832J · Substantial damageNTSB NYC88LA071Accident · No injuriesLimited investigationFinal reportCessna 402B · Bangor, METhe crew rprtd that drg takeoff, a power surge occurred after the acft had climbed about 400 to 500 ft. the coplt saw what he later said was a right fuel flow fluctuation & told the plt (PIC) that the right eng was losing power. The PIC told the coplt to…Feb 1, 1988 · N4175G · Substantial damageNTSB MKC88LA045Accident · No injuriesLimited investigationFinal reportCessna 195 · Rolla, MOShortly after takeoff, during a personal flight, the engine progressively lost power. The PIC attempted an emergency ldg in a pasture. During the ldg roll, the acft collided with a tree, causing substantial damage to the right wing. Post accident aircraft…Jan 28, 1988 · N1071D · Substantial damageNTSB MIA88FA094Accident · 1 fatalField investigationFinal reportCessna 411 · Venice, FLWitnesses stated that the acft was climbing & just after takeoff, the left wing dropped, the acft then leveled off, climbed aprx 75 more feet. The acft then abruptly turned hard left & went straight in, striking a wall surrounding a swimming pool, burst into…Jan 27, 1988 · N235UV · DestroyedNTSB SEA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kennewick, WAAt about 75 feet AGL a total loss of power occurred. The plt landed on the remaining runway but overran the rwy, coming to rest 200 ft beyond the end. During the overrun, the nose gear struck a rock and the acft nosed over. The aircraft's fuel tanks contained…Jan 24, 1988 · N3316Z · Substantial damageNTSB NYC88FA069Accident · 2 fatalField investigationFinal reportCessna 182L · Waynesburg, PAShortly after departure from runway 26, the aircraft engine failed. The aircraft banked to about 90 degrees, descended and impacted the ground. A flight instructor described the wind as very gusty and varying out of the south at approximately 10-20 knots. The…Jan 24, 1988 · N3467R · DestroyedNTSB NYC88LA066Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Stowe, VTThe Cessna 210 took off and shortly thereafter experienced a loss of power. The pilot was unable to get the engine restarted and made an off-airport landing in a grove of trees. On-scene examination by the FAA showed that the fuel selector was on the left…Jan 17, 1988 · N94064 · Substantial damageNTSB MIA88FA088Accident · Serious injuriesField investigationFinal reportChristen Industries A-1 · Pompano Beach, FLThe plt stated that as he pushed the control stick forward in an attempt to raise the tail, the acft violently pitched up, stalled and broke right, the right wing struck the ground, & the acft rolled over & came to rest inverted. Post crash examination of the…Jan 17, 1988 · N29076 · DestroyedNTSB LAX88FA087Accident · 1 fatalField investigationFinal reportCessna T210N · Lost Hills, CAOn a dark night with light drizzle falling the pvt plt, who was not instrument rated, departed from an uncontrolled arpt for a x-c flt. The plt made a downwind departure, & his altitude on the x-wind leg was estimated by a passing truck driver at 200 ft AGL.…Jan 16, 1988 · N7573N · DestroyedNTSB ANC88LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKThe pilot had selected the left auxiliary fuel tank for takeoff. During the climbout the engine quit; the aircraft crashed short of a private airstrip. The pilot stated that he ran the left auxiliary fuel tank dry and did not select another fuel tank with the…Jan 16, 1988 · N9103W · Substantial damageNTSB NYC88LA054Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Honesdale, PAShortly after takeoff from runway 35 at cherry ridge airport, Honesdale, Pennsylvania, the aircraft experienced an engine power loss and crashed about 200 feet off the end of the runway. Examination of the aircraft after the accident revealed no fuel in the…Jan 10, 1988 · N26869 · Substantial damageNTSB CHI88FA041Accident · 3 fatalField investigationFinal reportFairchild SA226T · Pontiac, MIAcft was scheduled for an instructional flt. During the wx briefing, the CFI told the fss specialist that the flt would include eng-out practice. Witness statements indicate that the acft rolled sharply to the rt and nosed down after attaining about 100 ft of…Jan 10, 1988 · N800AW · DestroyedNTSB MIA88LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tampa, FLAfter preflighting the acft, 30.8 gal of fuel were added. No further insp was performed. The flt took off after an eng runup was accomplished. No problems were noted. During the initial climb of the first touch-and-go landing, at an alt of aprx 75 ft, the eng…Jan 3, 1988 · N40AZ · Substantial damageNTSB MIA88LA080Accident · Minor injuriesLimited investigationFinal reportBellanca 14-13 · Merritt Island, FLThe private pilot experienced a power loss after takeoff. He then collided with water after hitting a mast of a boat and a dock. The plt stated that he experienced carburetor ice prior to the eng quitting. The plt stated that on an earlier flt he had problems…Jan 2, 1988 · N8429H · Substantial damageNTSB FTW88LA045Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Mineola Quitman, TXDuring a practice touch and go landing, the engine back fired and then surged. At about 150' AGL the engine RPM dropped about 80% and the pilot attempted to make an emergency landing in an open field. The aircraft flew over a trash dump and between two trees.…Jan 2, 1988 · N3709X · Substantial damageNTSB ATL88LA071Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Springfield, KYOne witness stated that the eng misfired during the takeoff roll, others stated that the acft was about 75 ft high when it lost power. There were several interruptions of power before it quit totally. The pilot attempted to return to the departure airfield.…Jan 2, 1988 · N2906X · Substantial damageNTSB LAX88LA078Accident · No injuriesLimited investigationFinal reportCessna 150K · San Andreas, CADec 31, 1987 · N6422G · Substantial damageNTSB FTW88LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Fargo, OKDuring takeoff roll, the engine RPM dropped to 2600 and started running rough. Shortly after takeoff, the pilot elected to make a precautionary landing. During landing roll the aircraft's left wing hit a tree causing substantial damage to the aircraft. Prior…Dec 29, 1987 · N94546 · Substantial damageNTSB BFO88FA011Accident · 1 fatalField investigationFinal reportChampion 7ECA · Keymar, MDWitnesses heard and observed the aircraft takeoff, bank to the left, and nose down into the adjoining dirt field with no change in engine sound. Exam of the wreckage revealed that an elevator cable had separated at a point where grounding strap was found to…Dec 25, 1987 · N11089 · DestroyedNTSB DCA88MA011Accident · 6 fatalMajor investigationFinal reportPiper PA-31-350 · Kenai, AKThe pilot had just departed the runway when he reported to the flight service station that he had engine problems. The aircraft was observed by witnesses to be about 300 ft on a descending downwind. The pilot stated that he was circling for runway one.…Dec 23, 1987 · N496SC · DestroyedNTSB FTW88DRG04Accident · 1 fatalFinal reportMBB 109 · Harlingen, TXThe set of floats which allows a high fuel flow in this carburetor for high power settings used for takeoff, climb, etc., had cracked and swollen to such an extent that they were rubbing against the float chamber walls and float chamber shroud tubes. This…Dec 19, 1987 · N8575 · DestroyedNTSB MIA88LA067Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA5A · Marathon, FLWhile on a personal flt shortly after takeoff at an alt of aprx 400 ft, the plt reported that the eng quit shortly after she turned off the electric fuel pump. Attempts to restart were unsuccessful. A forced landing followed during which the acft collided…Dec 18, 1987 · CGRRP · Substantial damageNTSB MIA88LA062Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Ocoee, FLThe plt rprtd that before takeoff, he made a thorough preflt, which included a check of the fuel sys for contaminates & water, but no discrepancies were noted. Shortly after takeoff, at an alt of aprx 100 ft, the eng sputtered & lost pwr. The plt stated he…Dec 12, 1987 · N4387C · Substantial damageNTSB LAX88LA050Accident · No injuriesLimited investigationFinal reportCessna 150H · Fullerton, CAAs the aircraft began its initial climb after takeoff, the engine began to run rough and the pilot elected to land on a street. The aircraft impacted street signs during the ground roll and collided with the street curbing. Post acc investigation revealed the…Dec 11, 1987 · N50320 · Substantial damageNTSB ATL88LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Richmond Hts, OHThe plt began taking off on rwy 23 with a wind from 160 deg at 13 KTS. The tower ctlr saw the acft turn sharply to the left after lift-off & subsequently impact about 250' left of the rwy. The ctlr said the plt appeared to have 'jerked' the acft off of the…Dec 11, 1987 · N9494J · Substantial damageNTSB ATL88FA059Accident · 2 fatalField investigationFinal reportCessna 421A · Hilton Head Isl, SCAcft depted coastal arpt at night with 400 ft partial obscuration in patchy fog. Ground witnesses who heard acft depicted a circling flt path to the right after takeoff. Eng, prop & turbo teardowns demonstrated both engs were operating at high power & no…Dec 11, 1987 · N777RC · DestroyedNTSB MIA88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Daytona Beach, FLAlthough the plt stated that he performed a preflt & eng runup prior to departure with no problem noted, shortly after takeoff, while climbing through 350 ft, the engine RPM dropped to & stayed between 1500 & 1600. The plt was unable to maintain altitude…Dec 10, 1987 · N8767C · Substantial damageNTSB NYC88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pottstown, PADuring soft field takeoff, the instructor pilot who was watching from the ramp, said the the student plt seemed to have excessive angle of attack and stalled the aircraft. The aircraft crashed on airport property about 1,000 feet from the start of the takeoff…Dec 3, 1987 · N16491 · Substantial damageNTSB MIA88FA049Accident · 1 fatalField investigationFinal reportBeech K-35 · Crescent City, FLThe pilot experienced a partial engine failure at lift off with 1/2 of the runway remaining in front of him. The pilot then attempted to do a 180 degree teardrop back to the runway, stalled and crashed. Investigation revealed water contamination of the fuel…Dec 1, 1987 · N125LE · DestroyedNTSB SEA88LA026Accident · No injuriesLimited investigationFinal reportCessna 206 · Funter Bay, AKShortly after takeoff, with a right quartering tailwind of 20 knots gusting to 25 knots, a downdraft was encountered. The pilot flew the aircraft away from rising terrain but the aircraft settled into small trees at full power in the takeoff configuration.Nov 30, 1987 · N9303R · Substantial damageNTSB CHI88DEP02Accident · Serious injuriesFinal reportBeech V35B · Waukesha, WIShortly after liftoff in IMC, the acft descended to the ground. The plt had been cleared for a rt turn but the controller noticed the acft turning left at about 50 ft AGL. The plt later could not stop the drifting to the left. The lndg gear was raised and the…Nov 30, 1987 · N6679J · DestroyedNTSB MIA88LA046Accident · Serious injuriesLimited investigationFinal reportCessna 172P · New Port Richey, FLThe pilot experienced an engine failure due to a heavily coked #4 cylinder exhaust valve while on climb out at 500 ft AGL. He attempted a turn back to the airport and stalled in the turn and crashed.Nov 29, 1987 · N62083 · Substantial damageNTSB DEN88LA031Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Conner, MTOn takeoff from a private, grass strip the pilot stated the engine began to lose power at approximately 20 to 30 feet AGL. A ravine was ahead and he attempted to stretch his glide to the FAR side of the ravine; however, the aircraft stalled and crashed into…Nov 27, 1987 · N2926D · Substantial damageNTSB SEA88FA023Accident · Serious injuriesField investigationFinal reportCessna 172M · Hillsboro, ORThe daily radio traffic reporting flight was cleared for an IFR departure from Hillsboro airport in IMC. The owner/ operator of the aircraft stated the company had a 'no ifr' policy. On takeoff witnesses observed the aircraft to be lower and slower than…Nov 25, 1987 · N21460 · DestroyedNTSB ATL88FA043Accident · 1 fatalField investigationFinal reportCessna 172N · Blanchester, OHThe aircraft departed before dawn from a private sod airstrip owned by the pilot, and collided with trees shortly thereafter. The pilot's wife said that the airstrip was not foggy when her husband took off, but the witness reported that the fog at the…Nov 24, 1987 · N5548J · DestroyedNTSB NYC88FA041Accident · 4 fatalField investigationFinal reportMooney M20C · St. Marys, PAWhile getting fuel, the pilot of the Mooney M20C and his 3 pals were attempting to remove frost with paper towels and plastic credit cards after being told by the fuel truck driver that the arpt had no ice removal solution. A witness stated that as the…Nov 15, 1987 · N3644H · DestroyedNTSB DCA88MA004Accident · 28 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-14 · Denver, COThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/09. 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…Nov 15, 1987 · N626TX · Destroyed