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 ANC82DA078Accident · No injuriesFinal reportPiper PA-32-300 · Egegik, AKAfter lift-off from a soft muddy strip the plt encountered a 30 knot crosswind eddying behind a building he was passing & settled into alder trees beyond the departure end of the strip.Aug 30, 1982 · N1084X · DestroyedNTSB DEN82DA177Accident · No injuriesFinal reportSchweizer 84 · Aspen, COAt low altitude after takeoff, the aircraft hit turbulence and the tow rope broke. The pilot reversed course and attempted to return to the airport. Having insufficient altitude, he landed on a railroad track and collided with bushes. The left wing canopy and…Aug 29, 1982 · N5742S · Substantial damageNTSB CHI82DA327Accident · No injuriesFinal reportHughes 269B · Medina, OHThe pilot stated that shortly after takeoff, at about 800 feet AGL he felt a violent vibration lasting for 2 or 3 seconds. He reentered the downwind leg to the airport and experienced the vibration again. The aircraft then entered an uncontrollable spiral to…Aug 28, 1982 · N9307F · DestroyedNTSB SEA82FA149Accident · Minor injuriesField investigationFinal reportCessna T207A · Boise, IDBefore takeoff, the pilot filed a company flight plan for a VFR flight from Boise to salmon, ID. He reported that during initial climb, the engine surged, then seemed to return to normal operation. He reduced the power to 33 inches of manifold pressure and…Aug 27, 1982 · N7306U · DestroyedNTSB FTW82FQG20Accident · Serious injuriesFinal reportPiper PA-22-150 · Clovis, NMThe eng quit immediately after takeoff & the acft flipped over during a forced landing in a plowed field. A 4 inch piece of gasket that was installed between the carburetor air filter & carburetor air box had come loose & was found lodged in the carburetor…Aug 27, 1982 · N4827A · Substantial damageNTSB ANC82DA080Accident · No injuriesFinal reportPiper PA-32 · Near Dillingham, AKThe pilot began taking off down slope in calm wind conditions with six passengers on board. Reportedly, the 1380 ft runway was mostly dry, but was muddy in places, except the last 100 ft contained standing water. The aircraft had barely lifted off prior to…Aug 26, 1982 · N7989C · Substantial damageNTSB ANC82DAG46Accident · No injuriesFinal reportCessna 172 · Quinhagak, AKThe pilot reported that he landed on a gravel bar about 900 ft long with a passenger to go fishing. Later, he took off to the west with a slight head wind. Near the end of the gravel bar was a tree with branches sticking out of the water. As the pilot took…Aug 25, 1982 · N53145 · Substantial damageNTSB ANC82DAG43Accident · No injuriesFinal reportPiper PA-20 · Eagle River, AKThe eng lost power about 750 ft after a water takeoff. There was insufficient landing room on the lake & the acft hit a dike. The pilot stated he fuels the acft from 5 gallon cans due to nonavaiability of aviation fuel at fire lake. Approximately 2 cups of…Aug 24, 1982 · N7773K · Substantial damageNTSB LAX82FA313Accident · 4 fatalField investigationFinal reportMaule M-6-235 · 5nm Sw Of Mcnea, AZImmediately after takeoff the acft was observed in a right turn with an abnormally nose high attitude. The acft appearedto stall & slide toward the left wing. Before a recovery could be completed the left wing & nose hit simultaneously at a 45 deg angle in…Aug 23, 1982 · N56493 · DestroyedNTSB ANC82DAG50Accident · No injuriesFinal reportCessna 150 · Kodiak, AKThe pilot took off from a gravel bar that was surrounded by higher terrain. Reportedly, the wind was calm until after lift-off, then a strong crosswind was encountered as the plane cleared higher terrain. The pilot reported that the plane was hit by the…Aug 23, 1982 · N60460 · Substantial damageNTSB MKC82FA153Accident · Serious injuriesField investigationFinal reportLawson Special DG-1 · Ozark, MOThe accident occurred during a fly-in. Several hundred spectators were at the arpt. The acft lifted off rwy 18 in a nose-high attitude, the left wing dipped down & the acft settled back to the ground in a nose-high attitude. The acft impacted about 50 ft east…Aug 22, 1982 · N922 · Substantial damageNTSB LAX82DA315Accident · No injuriesFinal reportPiper PA-30 · Santa Catalina, CAThe aircraft lost right engine power following departure from Santa Catalina. Unable to climb the aircraft to airport altitude the pilot decided to proceed over the open sea to san clemente. About 19 miles from the island the pilot stated he switched fuel…Aug 22, 1982 · N7956Y · DestroyedNTSB SEA82DA147Accident · Minor injuriesFinal reportMaule BEE DEE M-4 · Yakima, WAThe pilot reported that just as he became airborne, an uncontrollable left roll developed. The left wing contacted the ground and the aircraft cartwheeled. An investigation revealed that the aileron balance and control cables were reversed to the aileron…Aug 21, 1982 · N4170C · Substantial damageNTSB LAX82DA317Accident · No injuriesFinal reportPiper PA-12 · Phoenix, AZThe aircraft collided with trees during takeoff from a 900 foot, dirt strip. The weather was VFR. The temperature was 102 degrees. No accident report was filed. The pilot had an expired medical certificate.Aug 21, 1982 · N98931 · DestroyedNTSB CHI82DA347Accident · No injuriesFinal reportBell 47G-4A · Near Brooten, MNThe pilot had been engaged in a spraying operation for 2.5 hrs when he returned and landed on a flat bed type trailer to service the helicopter. After the hopper was serviced with 60 gal of herbicide, the pilot began his take off. He stated that just after…Aug 20, 1982 · N4090G · Substantial damageNTSB CHI82DA314Accident · Serious injuriesFinal reportCessna 177 · Minford, OHThe aircraft had just recently received an annual inspection. Before taking off on a local flight, the fuel tanks were topped off. The pilot reported that the preflight run-up was satisfactory, and during the takeoff roll, the engine developed full power.…Aug 20, 1982 · N30845 · Substantial damageNTSB NYC82DA204Accident · No injuriesFinal reportCessna 195A · Wallingford, CTThe pilot reported that when he preflighted the aircraft, the fuel tanks were full. Fuel was drained from each wing and the fuselage low point with no indication of water. During takeoff, engine power was lost at an altitude of about 150 ft as the manifold…Aug 19, 1982 · N4433C · Substantial damageNTSB SEA82DA151Accident · No injuriesFinal reportAeronca 7AC · 7nm So. Of Sale, ORImmediately after a soft field takeoff the pilot executed a right turn into a quartering tailwind condition in an effort to avoid trees beyond the upwind end of the field. The pilot reported that during this turn the aircraft stalled and struck the ground in…Aug 18, 1982 · N82219 · Substantial damageNTSB LAX82FA305Accident · No injuriesField investigationFinal reportCessna T210L · Buena Park, CAReportedly, the eng began losing power after takeoff at aprx 300 ft AGL, after the plt retracted the landing gear & flaps. The eng then stopped & the plt was forced to land. While descending, the acft struck power lines. During touchdown, it collided with 2…Aug 17, 1982 · N732JP · Substantial damageNTSB FTW82DA334Accident · No injuriesFinal reportGrumman G164A · Marianna, ARThe pilot stated that shortly after lift off the engine backfired and lost power. He reported that the engine did not completely quit and there was no visible smoke, flame or oil coming from the engine. Due to his low altitude and heavy load the pilot elected…Aug 17, 1982 · N5364 · Substantial damageNTSB ATL82DA241Accident · No injuriesFinal reportCessna A188A · Florala, ALThe pilot reported that as he was climbing through about 30 to 40 ft AGL, the aircraft suddenly went to the right as the flaps were being retracted. In an effort to counteract the lateral movement, the pilot applied left aileron and rudder which started the…Aug 17, 1982 · N9916G · Substantial damageNTSB ANC82DA075Accident · Minor injuriesFinal reportEnstrom F-28F · Near Sutton, AKThe pilot had approached and landed on a bluff to discharge his two passengers. However, before discharging the passengers, he decided to takeoff and find a better landing area. When the helicopter was about 10 to 20 ft from the takeoff point, but…Aug 17, 1982 · N5698E · Substantial damageNTSB ANC82DA073Accident · No injuriesFinal reportCessna 185 · Near Skwentna, AKThe pilot of the float plane began his takeoff from a narrow river with a left turn at the lift-off point. After becoming airborne and while turning, the right wing struck a branch. The pilot stated that the aircraft came to rest in the trees, upside down.…Aug 16, 1982 · N79SC · Substantial damageNTSB CHI83DA308Accident · Minor injuriesFinal reportVon Berg VEE BEE 4 · Saginaw, MIThe pilot of the home built aircraft was making a high speed taxi run when the aircraft inadvertently became airborne. The plane climbed to about 100 ft AGL and then the engine lost power. During landing, the aircraft was substantially damaged. The pilot…Aug 14, 1982 · N4VB · Substantial damageNTSB ATL82FLQ09Accident · Serious injuriesFinal reportCessna 150 · Prestonburg, KYImmediately after takeoff from rwy 13 the CFI saw another acft on final to rwy 31 & entered a steep left climbing turn up a small valley east of the arpt. The CFI was unable to out-climb the rising terrain. The CFI stated he took this evasive action to avoid…Aug 14, 1982 · N1410Q · DestroyedNTSB FTW82FQA25Accident · Minor injuriesFinal reportBeech P35 · Albuquerque, NMAfter takeoff engine reportedly lost power. The pilot flew it between trees but one wing was separated in the collision with a tree during the forced landing. No reason for the power loss was found.Aug 13, 1982 · N1555Z · Substantial damageNTSB ANC82DA071Accident · No injuriesFinal reportPiper PA-12 · Polly Creek, AKThe pilot landed on the beach near the mouth of Polly Creek to go fishing. After fishing for several hours. He noticed fuel leaking from the filler cap on the left main tank. This occurred when fuel cross-flowed from the right auxiliary tank. The pilot turned…Aug 13, 1982 · N2701M · Substantial damageNTSB FTW82FPM15Accident · 2 fatalFinal reportBeech H35 · Tulsa, OKAircraft lost power during takeoff. Pilot tried to turn back to airport in a left bank described as 60 to 90 degrees. Aircraft stalled and crashed about 1300 feet east of takeoff point. During the investigation the fuel pump was placed on a flow bench & on…Aug 12, 1982 · N4800Y · DestroyedNTSB CHI82FA304Accident · Serious injuriesField investigationFinal reportHiller UH12L4 · Wisconsin Dells, WIDuring climb, at about 200 ft AGL, the m/r lost RPM. During autorotation the eng RPM increased beyond the red line when the plt added power. The helicopter made a hard landing in a residential area. Inspection of the mercury clutch revealed that the exterior…Aug 12, 1982 · N3748Z · Substantial damageNTSB NYC82FA193Accident · 2 fatalField investigationFinal reportCessna 180H · Porter, METhe acft was taking off from a pond which is about 4,200 ft at its longest length. A power line extends across the pond about 2,000 ft from the south end. The acft was observed to takeoff to the north remaining on the water while passing under the wires. The…Aug 11, 1982 · N2800T · Substantial damageNTSB MKC82DA141Accident · Minor injuriesFinal reportCessna 140 · West Plains, MOThe pilot was practicing short field takeoffs and maneuvered to clear a 50 foot barrier. He stalled the aircraft and was unable to recover before impacting the ground, nose and right wing first.Aug 10, 1982 · N2319V · Substantial damageNTSB LAX82FVG30Accident · Serious injuriesFinal reportPiper PA-36-285 · Malin, OKPower loss during takeoff resulted in forced landing. Aircraft collided with canal bank. Cylinder had broken rings. Both plugs were badly oil fouled. One plug would not fire & the other fired intermittently.Aug 10, 1982 · N9925P · Substantial damageNTSB CHI82DA299Accident · No injuriesFinal reportQuickie Quickie · Youngstown, OHDuring takeoff, the home built aircraft struck the tops of trees near the departure end of the 3300 ft runway. The pilot stated that the aircraft climbed very slowly and was barely able to climb at a greater rate than the upslope of the runway. The elevation…Aug 10, 1982 · N336RM · Substantial damageNTSB CHI82DA298Accident · No injuriesFinal reportQuickie · Greenville, MIDuring the preflight inspection. The laminar-flow wing and canard were carefully wiped free of a heavy deposit of dew. All items of inspection were satisfactory. The engine was warmed up while taxiing to the runway. It was noted that beads of moisture were…Aug 9, 1982 · N39QB · Substantial damageNTSB NYC82DA186Accident · No injuriesFinal reportPiper PA-22-160 · Barnstead, NHThe pilot stated he lost power during takeoff and landed in trees off the end of the runway.Aug 8, 1982 · N3627Z · Substantial damageNTSB FTW82FPJ19Accident · Serious injuriesFinal reportCessna 172M · Overbrook, OKThe pilot stated that he began his takeoff from the very beginning of the runway, and that on rotation, the engine seemed to lose power. He stated that he observed the tachometer and saw that the engine was dropping below 1500 RPM. Subsequently, the aircraft…Aug 8, 1982 · N46172 · DestroyedNTSB DEN82DA156Accident · No injuriesFinal reportCessna 172M · Fairburn, SDThe aircraft tookoff with 4 occupants, baggage and 50 gallons of fuel. The density altitude was 4,963 feet. After takeoff, the pilot could not maintain altitude and stalled the aircraft into a field of high grass. The flaps were not used.Aug 8, 1982 · N19889 · Substantial damageNTSB ATL82DA232Accident · No injuriesFinal reportCessna 150 · Horrell Hill, SCPilot making touch and go landings at private airstrip. After takeoff aircraft would not maintain altitude. Pilot made an emergency landing in a bean field. Aircraft flipped over. Pilot forgot to retract full flaps and carb heat was on during takeoff.Aug 8, 1982 · N18019 · Substantial damageNTSB ATL82DA231Accident · No injuriesFinal reportHughes 369HS · Wrightsville Bc, NCThe pilot reported that he initiated a downwind takeoff in a 10 kt wind and started a climb over water. Reportedly, the helicopter began to spin to the right as it reached an altitude of about 50 ft AGL and 20 KTS. The pilot allowed the helicopter to rotate…Aug 8, 1982 · N4265P · Substantial damageNTSB SEA82DA136Accident · No injuriesFinal reportCessna T207 · Dixie, IDThe pilot took off with 4 passengers after waiting 4 hours for the air temperature to cool. The takeoff seemed normal, but over the river at about 50 feet AGL, the aircraft began to sink. It impacted rough terrain on the FAR side of the river. The airport…Aug 6, 1982 · N1627U · DestroyedNTSB NYC82DA187Accident · Serious injuriesFinal reportSchleicher ASW-20 · Unionville, PAWhile being towed during takeoff, the pilot moved the flaps from the neutral #3 to the positive #4 setting and the nose of the glider pitched up. The pilot realized there was no elevator control, the flaps were moved to the #1 (negative) setting and the two…Aug 6, 1982 · N20KG · DestroyedNTSB LAX82FA290Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Palo Verde, AZThe acft took off from a road near the plt's home. It was observed to go around a pickup truck parked alongside the road & then lift off. The acft climbed, turned right briefly & then went wings level. It then started a right descending turn into the ground.…Aug 5, 1982 · N1UR · DestroyedNTSB ATL82FA229Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Raleigh, NCShortly after takeoff the acft caught fire. The plt attempted to turn back to the arpt but the eng lost power & the acftcould not maintain altitude. The acft crashed into a heavily wooded state park. The #5 cylinder exhaust pipe was found separated & was not…Aug 5, 1982 · N4076W · DestroyedNTSB ATL82FID12Accident · Minor injuriesFinal reportBenson B8M · Suffolk, VAThe pilot stated that he was practicing high speed taxi with occasional lift off and landing. He stated that on this lift off the aircraft was approximately 25 feet off the ground when he lost control.Aug 4, 1982 · NONE · Substantial damageNTSB ANC82DAG39Accident · Minor injuriesFinal reportCessna 180 · Rush Lake, AKThe float-equipped acft failed to clear rising terrain after taking off from Rush Lake. The pilot stated that the enginewas developing full power.Aug 4, 1982 · N3125C · DestroyedNTSB ANC82DA065Accident · No injuriesFinal reportMaule M-4-210C · Eagle River, AKThe pilot reported that he preflighted the float plane, pumped the floats, and checked for water. After the engine start, taxi, and pretakeoff checks, he set the flaps at the first notch. He aborted his first takeoff run and taxied back for a longer run. The…Aug 4, 1982 · N9872M · Substantial damageNTSB ANC82DAG38Accident · Minor injuriesFinal reportCessna 172K · 44mi Nw Mccarth, AKShortly after liftoff from a short gravel strip the aircraft settled back onto the rough terrain and crashed.Aug 2, 1982 · N84345 · Substantial damageNTSB MIA82DA162Accident · No injuriesFinal reportMooney M20F · Orlando, FLThe pilot reported that rain had occurred on the previous night and there was water on the 2430 ft grass runway. He reported that during rotation, the aircraft hit the water and lost airspeed. Subsequently, the aircraft failed to gain sufficient altitude to…Aug 1, 1982 · N9109V · Substantial damageNTSB CHI82DA288Accident · No injuriesFinal reportPiper PA-28-180 · Rockford, ILThe aircraft began to settle or mush after takeoff so the pilot made a landing in a school yard. Post accident examination failure to reveal any evidence of engine malfunction although pilot claimed he lost power. The aircraft was about 80 lbs. Below maximum…Aug 1, 1982 · N5286L · Substantial damageNTSB ATL82DA222Accident · Serious injuriesFinal reportBeech C23 · Greer, SCThe student pilot had received about three hours in this make and model of aircraft. After about 45 minutes of dual instruction, he was indorsed for solo flight, the instructor deplaned, and the student took off to fly locally. About 25 minutes later, the…Aug 1, 1982 · N1831F · Substantial damage