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 CHI88LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WIAug 7, 1988 · N65711 · Substantial damageNTSB DEN88LA178Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Clinton, MTThe plt rprtd that drg takeoff from rwy 25, the winds were from 270 deg at 10 gusting 15 KTS. He stated that drg the initial climb, the airplane enctrd a severe windshear. Subsequently, he lost control & the acft struck the ground in a 40 deg nose down, 70…Aug 6, 1988 · N95855 · Substantial damageNTSB DEN88LA171Accident · No injuriesLimited investigationFinal reportCessna 150 · Albuquerque, NMThe instructor (CFI) & student plt were on an instructional flt. The CFI rprtd that while climbing thru aprx 150' AGL, the acft enctrd a downdraft. He took the controls, but the acft descended to about 10 ft AGL. The CFI elected to land immediately to avoid a…Aug 4, 1988 · N704UN · Substantial damageNTSB CHI88LA191Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · St. Charles, MIThe pilot failed to attain sufficient altitude to clear obstacles during the initial climb-out and the aircraft collided with trees located off the departure end of the private grass strip. The aircraft fell to the ground, where it caught fire and was…Aug 4, 1988 · N97797 · DestroyedNTSB NYC88FA202Accident · 2 fatalField investigationFinal reportCessna 172P · Post Mills, VTThe plt flew the acft to an arpt with two turf rwys. Rwy 5/23 was 2300' long & rwy 4/22 was 2600' long. After attending a meeting which ended at 1600 EDT, the plt elected to wait until later in the day to takeoff after the air had cooled. Subsequently, he…Aug 3, 1988 · N62541 · DestroyedNTSB NYC88DHJ01Accident · Serious injuriesFinal reportStolp Starduster SA-300 · Shirley, NYThe plt rprtd that the acft's eng lost power as he was departing from rwy 24. He said he turned left to land on rwy 15, then the eng restarted again, so he decided to land on rwy 24. Also, he rprtd that as he was banking to the left in the traffic pattern,…Aug 3, 1988 · N7613 · DestroyedNTSB CHI88FA188Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Flushing, MIPilot's physical incapacitation due to a coronary seizure, which resulted in a loss of aircraft control, and a stall/spin into the ground.Aug 3, 1988 · N2956Z · DestroyedNTSB DEN88FA170Accident · 1 fatalField investigationFinal reportBeech B23 · Cimarron, NMThe pilot to properly preflight his aircraft in accordance with the procedures provided in the operators handbook thus causing the engine to lose power following takeoff due to fuel contamination caused by water.Aug 2, 1988 · N4006T · DestroyedNTSB CHI88LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Cheboygan, MIShortly after departure, when the aircraft was approximately 30' in the air, the aircraft's right wing 'dropped hard'. The pilot attempted remedial action, but was unable to regain control of the aircraft before the right wing tip struck the ground. The…Aug 1, 1988 · N4982Z · Substantial damageNTSB CHI88DEP08Accident · No injuriesFinal reportMonnett Sonerai II · Wisc Rapids, WIThe plt rprtd that drg takeoff, the eng lost power as the acft was climbing thru about 200' AGL. An emerg lndg was made in the best available area, which was a golf course on rolling terrain. Drg the lndg roll, the plt applied brakes, but was unable to stop…Aug 1, 1988 · N79TG · Substantial damageNTSB CHI88LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · St. Jacob, ILDuring the initial climbout the student pilot failed to attain sufficient altitude to clear the power lines located off of the departure end of the runway. When the pilot realized that he would not be able to clear the power lines, he elected to attempt to…Jul 31, 1988 · N9291T · Substantial damageNTSB CHI88FA183Accident · No injuriesField investigationFinal reportBoeing B75N1 · Wonder Lake, ILJul 31, 1988 · N4408N · Substantial damageNTSB MKC88LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Cherry Valley, ARThe plt said that shortly after takeoff, he had a partial power loss. He dumped his chemical load and attempted to return for landing. While turning the engine suffered a complete loss of power. He attempted to land, but on the roll out, acft nosed over in…Jul 30, 1988 · N6823K · Substantial damageNTSB NYC88LA197Accident · Serious injuriesLimited investigationFinal reportErco 415C · W. Bloomfield, NYShorlty after takeoff at about 150 feet a.g.l., the pilot lost control of the airplane and crashed in a corn field about 0.5 mile from airport. A passenger reported that they encountered a wind gust and the pilot was unable to control the airplane.Jul 29, 1988 · N94011 · DestroyedNTSB MKC88LA140Accident · No injuriesLimited investigationFinal reportMooney M20C · Olathe, KSShortly after takeoff, the pilot said the engine failed. He said he pumped the throttle and the engine restarted about the same time the acft returned to the runway. The engine restart propelled the aft back into the air. The plt felt he had sufficient power…Jul 28, 1988 · N6722U · Substantial damageNTSB NYC88LA195Accident · No injuriesLimited investigationFinal reportCessna 177RG · Canton, MADuring initial climb from takeoff, the engine lost total power and an emergency landing was made on a highway. The left wing and horizontal stabilizer struck a guardrail when the pilot was maneuvering to avoid a truck. A post-crash inspection of the engine…Jul 27, 1988 · N52865 · Substantial damageNTSB ANC88LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Sand Point, AKThe pilot reported that the aircraft had high oil temp and moderate vibrations. The aircraft was landed at Sand Point and a company mechanic arrived to inspect the aircraft. The oil quantity was checked and a run-up performed. The mechanic reported that no…Jul 27, 1988 · N493CA · Substantial damageNTSB NYC88FA193Accident · 1 fatalField investigationFinal reportCessna 150J · Palmyra, NYCessna N51413 departed Palmyra airpark with full flaps and crashed into a barn about 75 feet past the departure end of runway 35. Afterward, the flap actuator was found in the flap up position. The pilot said that the engine lost 200 to 300 RPM about 300 feet…Jul 25, 1988 · N51413 · DestroyedNTSB NYC88LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Smoketown, PAThe plt reported that the eng lost power at about 300 ft AGL after takeoff. A forced landing was made in a corn field. During the landing roll the aircraft nosed over. The wreckage was examined after the accident and water was discovered in the fuel system.…Jul 24, 1988 · N33743 · Substantial damageNTSB MIA88IA231Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Miami, FLFlt experienced failure of the number two engine shortly after takeoff when the combustion outer case ruptured. Metallurgical examination revealed the ruptured case had a 1/2 inch crack in it when it went through overhaul 16 cycles before the failure. It was…Jul 24, 1988 · N69AF · Minor damageNTSB FTW88DRA15Accident · 1 fatalFinal reportAir Command Elite 532 · Baytown, TXAcft was observed to takeoff and turn right crosswind. Drng the crosswind, the RPM increased suddenly. The acft pitched nose downwards, impacted the ground in a vertical descent and burned. The plt/builder had a total of 5 hrs in the new acft. No evidence of…Jul 23, 1988 · N91359 · DestroyedNTSB ATL88FA219Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Winston-Salem, NCN7942N crashed into a building shortly after liftoff from runway 21. The pilot was cleared for a left turnout over runway 33. A witness estimated that the airplane had reached 300 feet when the pilot lost control and crashed. The investigation failed to…Jul 23, 1988 · N7942N · DestroyedNTSB FTW88LA138Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Sayre, OKThe pilot said that shortly after takeoff, at 200 feet AGL, the engine quit. He tried to land on the remaining runway but the airplane went off left side, then through a ditch. No problems could be found to cause the loss of engine power. The engine was later…Jul 22, 1988 · N771RB · Substantial damageNTSB ANC88LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Dillingham, AKThe pilot reported that he lost control of the aircraft. The plane crashed approximately 500 feet off the departure end of the airstrip. The flight was a part 135 on-demand air taxi flight. At the time of the accident, the aircraft was above maximum certified…Jul 22, 1988 · N29148 · Substantial damageNTSB SEA88LA135Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Colfax, WAOn departure with a load of chemical, ag plt attempted to outclimb rising terrain ahead. The aircraft collided with terrain in a stall/mush.Jul 21, 1988 · N8974H · Substantial damageNTSB NYC88LA190Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Greenland, NHThe intention of the flight was to give people at an annual company picnic a ride in the aircraft. After takeoff and while starting a left turn the pilot stated that he encountered a 'sudden windshear/downdraft.' The aircraft never got above 200 feet and…Jul 21, 1988 · N20973 · Substantial damageNTSB ATL88LA217Accident · No injuriesLimited investigationFinal reportMooney M20E · Lawrenceville, GAThe plt reported that the engine failed shortly after takeoff. The pilot made a 180 degree turn and landed downwind on the runway. He elected to land gear up to avoid a drop-off past the runway end. The acft slid off the runway end, but came to a stop before…Jul 21, 1988 · N6810V · Substantial damageNTSB BFO88FA067Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-200 · Chantilly, VAThe pilot inadvertently misused the flaps, by failing to set the flaps to the proper setting. The flaps were set full down. This caused the aircraft to pitch up steeply after liftoff. Additionally, the flight control lock was probably installed during some…Jul 20, 1988 · N7267 · DestroyedNTSB MIA88LA229Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Moorhead, MSWhile on an aerial application flt during the ground roll the wind changed from a headwind to a tailwind. The plt dumped the load of chemical in an attempt to climb but the acft crashed into a fish pond.Jul 18, 1988 · N23640 · Substantial damageNTSB CHI88DEI02Accident · Serious injuriesFinal reportGeddes Commander 503 · North Lima, OHPilots continued operation of the aircraft with a known deficiency and attempting to stretch his partial power descent to reach a runway rather than land off airport.Jul 18, 1988 · N9173W · Substantial damageNTSB NYC88LA184Accident · No injuriesLimited investigationFinal reportMooney M20F · Princeton, NJThe Mooney M20F made a takeoff and as the pilot turned crosswind, he experienced a partial power loss. He returned for a landing and the engine smoothed out. He made extensive ground runs and could not duplicate the problem. However he did not have…Jul 17, 1988 · N6310Q · Substantial damageNTSB NYC88LA183Accident · No injuriesLimited investigationFinal reportAeronca S11BC · Livingston Mnr, NYThe pilot had just departed from the surface of a lake, when at an altitude of 50 ft AGL and in a left turn, the engine quit. There was not enough altitude to make it back to the lake. The aircraft impacted trees and was destroyed. The pilot had experienced…Jul 16, 1988 · N3988E · DestroyedNTSB LAX88LA259Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Corona, CADuring takeoff the engine failed to develop full power & the acft collided with trees located approx 500 ft beyond the runway. Exam of the engine revealed the mixture control arm at its fuel pump housing attachment point had restricted movement & was…Jul 16, 1988 · N736HQ · Substantial damageNTSB LAX88FA258Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Compton, CAThe student plt was taking his 2 grandchildren & 1 of their friends on a local flt. Ground witnesses observed the airplane lift off and continue in an excessively high angle of attack climb attitude. When the airplane reached abt 150 ft a.g.l. it stalled,…Jul 16, 1988 · N40808 · DestroyedNTSB FTW88DRG11Accident · No injuriesFinal reportEnstrom F28A · Port Isabel, TXThe pilot reported that he had accomplished a max-performance takeoff, cleared an obstacle, and when he attempted forward flight, the main rotor RPM decreased. He stated he was unable to recover the RPM and maintain altitude so he selected a landing area. Due…Jul 16, 1988 · N9087 · Substantial damageNTSB SEA88LA130Accident · No injuriesLimited investigationFinal reportCessna 150G · Athol, IDThe student pilot was practicing full stop landings. He failed to raise the flaps from full down after the previous landing. On the subsequent takeoff, the aircraft became airborne prematurely. The pilot reduced the power and the aircraft stall/mushed onto…Jul 14, 1988 · N2886S · Substantial damageNTSB ATL88LA216Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Michie, TNWitness reported that the airplane engine was running rough during takeoff; the airplane subsequently disappeared from sight in a nose-down attitude. The plt later reported that he could not remember the events that led up to the power loss. Post-crash exam…Jul 14, 1988 · N19632 · Substantial damageNTSB LAX88FA252Accident · 1 fatalField investigationFinal reportBeech A35 · Lompoc, CAPilot's improper use of the fuel system and his failure to maintain control of his aircraft. Contributing factors were the pilot's intentional operation of an aircraft with known deficiencies in equipment, his improper emergency procedure and his lack of…Jul 12, 1988 · N27EB · DestroyedNTSB FTW88LA130Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot landed on the private strip to pick up a passenger. The pilot reported that after takeoff he smelled smoke and almost immediately, the engine started cutting out. The airplane impacted the tops of tall trees, thena fence, and then impacted…Jul 12, 1988 · N25999 · Substantial damageNTSB FTW88DRD15Accident · No injuriesFinal reportCessna A188B · Patterson, LAShortly after takeoff, the engine lost power & the plt dumped his load. Subsequently, the acft crash landed in a cane field. No preimpact mechanical problems could be found with the engine or fuel system. Water was found in the fuel tank outlet screen,…Jul 12, 1988 · N4825Q · Substantial damageNTSB DEN88LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Fort Peck, MTThe pilot made a takeoff from a muddy, dirt, road. He said that after he become airborne he put his aircraft into a sharp turn in order to avoid some power lines. Although he was successful in avoiding the power lines, he inadvertently stalled the aircraft…Jul 12, 1988 · N7940Z · Substantial damageNTSB CHI88DEP06Accident · No injuriesFinal reportHuntley Challenger II · Platteville, WIAfter climbing about 100' after takeoff, a partial power loss occurred & the plt initiated a left turn to rtrn to the arpt. Unable to reach the arpt, an emerg lndg was made in a corn field & the acft was damaged. No airframe failure was found & the eng ran…Jul 12, 1988 · N51012 · Substantial damageNTSB NYC88LA180Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Lakewood, NJLoss of directional control during landing, due to a banner towing rope being wrapped around the left rudder horn.Jul 11, 1988 · N11088 · Substantial damageNTSB NYC88LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Fryeburg, MEAccording to witnesses, the pilot had been drinking and two friends drove him to the airport and watched as he departed. They noted that the aircraft was climbing steeply after liftoff and then observed the aircraft's rotating beacon as the aircraft spiraled…Jul 11, 1988 · N84493 · DestroyedNTSB DEN88LA153Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Spearfish, SDThe accident involved a tri-pacer with four persons and about 150 pounds of baggage on board who were from Canada and vacationing in the U.S. The pilot said the acft became airborne and climbed to about 100 ft above the rwy, but would not maintain altitude…Jul 11, 1988 · CGCCF · Substantial damageNTSB NYC88LA179Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Plymouth, NHThe plt reported that the eng lost power during takeoff as the acft was climbing thru about 200 to 250 ft AGL. Unable to restore power, he turned to land in a corn field, but was unable to reach it. He then selected a smaller field, but during the landing,…Jul 9, 1988 · N32126 · Substantial damageNTSB MKC88DCG01Accident · Serious injuriesFinal reportBoeing 75A · Neosho, MOWitnesses stated that just after liftoff, they observed a map blow out of the a/c. the pilot stated he saw something go past and turned to see what it was. He inadvertently pushed the stick forward and hit the runway nose-first. The pilot stated that he was…Jul 9, 1988 · N450LR · Substantial damageNTSB DEN88LA149Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Cheyenne, WYThe flight originated in omaha, NE. Three passengers and the commercial plt embarked on a fishing trip into Wyoming. The pilot departed Cheyenne after having several problems with the engine and correcting the problem by proper leaning. He said he took off…Jul 8, 1988 · N4329F · Substantial damageNTSB CHI88DEX07Accident · Minor injuriesFinal reportCessna 175A · Bloomington, INAircraft experienced partial loss of engine power at 150 feet AGL after takeoff. Pilot made 180 degree turn in attempt to return to airport, but experienced further power loss and elected to make emergency landing in field. Right wingtip hit tree, and…Jul 8, 1988 · N8059T · Substantial damageNTSB ATL88FA210Accident · Serious injuriesField investigationFinal reportCessna 210L · St. Marys, GAJul 7, 1988 · N732JV · Substantial damage