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 CHI89MA046Accident · No injuriesMajor investigationFinal reportBoeing 737-201 · Chicago, ILPrevious damage to the aft cone (engine mounting) bolt, which resulted in mismatched surfaces between the bolt and isolation mount, loss of torque during cyclic loading of the mounting bolt, and subsequent fatigue failure of the bolt.Jan 20, 1989 · N242US · Substantial damageNTSB FTW89LA041Accident · Serious injuriesLimited investigationFinal reportDouglas DC-3 · Laredo, TXThe pic's disregard for the security of the cargo that permitted its shift during the takoeff roll. This resulted in an aft CG situation and a subsequent stall and loss of aircraft control. A contributing factor in the accident was the mismanagement of the…Jan 19, 1989 · XBDYP · DestroyedNTSB ATL89LA079Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Williamsburg, OHA defective gasket in the fuel strainer which caused a restriction in fuel flow during climbout.Jan 19, 1989 · N8774B · Substantial damageNTSB NYC89LA068Accident · Serious injuriesLimited investigationFinal reportRobinson R-22HP · Ronkonkoma, NYThe pilot's improper operation of the rotorcraft flight controls and a resulting low rotor RPM condition.Jan 18, 1989 · N9021M · Substantial damageNTSB NYC89LA069Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Bridgeport, CTThe improper fuel selector position and loss of power to the engine due to fuel exhaustion.Jan 17, 1989 · N6829Q · Substantial damageNTSB CHI89LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Osceola, WIInadequate preflight by the student pilot, inadequate supervision (to assure a proper preflight) by the instructor pilot (CFI), and water contamination of the fuel. The terrain was considered to be a contributing factor.Jan 15, 1989 · N61306 · Substantial damageNTSB DEN89FA061Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Albuquerque, NMEngine stoppage from fuel starvation which resulted from the pilot's failure to select the fullest tank for takeoff. In addition the pilot attempted to return to the airport during the forced landing and inadvertently stalled the aircraft during the…Jan 14, 1989 · N5983P · DestroyedNTSB ATL89LA073Accident · No injuriesLimited investigationFinal reportCessna 182P · Hamilton, OHThe pilot's improper use of the carburetor heat control which resulted in a loss of engine power. Contributing to the accident were conditions conducive to carburetor ice.Jan 14, 1989 · N21531 · Substantial damageNTSB MKC89LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Chadron, NEThe plt failed to devote full time & attention to flying the acft, with a resulting loss of control and collision with the ground. Contributing to the accident was the dark night conditions.Jan 9, 1989 · N3799R · Substantial damageNTSB NYC89LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Stratford, CTThe loss of engine power for undetermined reasons.Jan 7, 1989 · N757KR · Substantial damageNTSB CHI89DEX03Accident · No injuriesFinal reportGrumman American AA-1C · Richmond, INThe pilot's attempt to continue the takeoff with a partial loss of power. Contributing to the accident were the carburetor icing conditions.Jan 5, 1989 · N39000 · Substantial damageNTSB DEN89LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Erie, COThe pilot said that he made a normal preflight and engine runup prior to takeoff on runway 33 at the tri-county airport, Erie, Colorado. A normal takeoff was made but he said that as the aircraft reached 200 feet, the engine lost about 400 RPM. When he…Dec 31, 1988 · N80650 · Substantial damageNTSB DEN89LA051Accident · No injuriesLimited investigationFinal reportBeech B24R · Ogden, UTThe non-instrument rated plt rcvd a wx briefing & filed an IFR flt pln. He tkof on rwy 34 at 1517 MST with low ceiling &restricted vis due to fog & lgt snow. The twr ctlr saw the acft lift-off at the rwy's end, then lost sight of it. Soon thereafter, the plt…Dec 31, 1988 · N65PW · Substantial damageNTSB NYC89LA061Accident · No injuriesLimited investigationFinal reportNavion NA-1 · Allentown, PAThe pilot stated that he experienced a loss of power shortly after takeoff and landed back on the runway. The landing was hard and the right wing was damaged. The FAA investigator checked the engine and fuel system for possible contaminants and water. No…Dec 29, 1988 · N2518T · Substantial damageNTSB MKC89LA047Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Derby, KSDrg an eng run-up before a simulated instrument flt, the crew noticed the carb heat control would only move about 1/2 of its normal travel. The plts discussed the malfunction & ran the eng for another 1 to 2 min until the oil temp gauge indcd a temp rise. Drg…Dec 28, 1988 · N2213T · Substantial damageNTSB LAX89LA071Accident · Serious injuriesLimited investigationFinal reportUnivair Globe GC-1B · Chino, CA**This report was modified on 2/24/2016. Please refer to the public docket for this accident for additional information.** The pilot's failure to maintain airspeed during an emergency landing following an inflight loss of engine power, resulting in an…Dec 27, 1988 · N3388K · Substantial damageNTSB CHI89FA036Accident · 4 fatalField investigationFinal reportBeech B23 · Jeffersonville, INPilot-in-command's poor inflight decision in attempting to return to the airport after a partial engine failure, and his encountering a stall/spin at low altitude from which he was unable to recover.Dec 26, 1988 · N6100N · DestroyedNTSB NYC89FA056Accident · 3 fatalField investigationFinal reportBeech A36 · Harrison, NYThe plt was clrd for an IFR departure from rwy 16 in instrument meteorological conditions (IMC). His departure clnc was to climb on rwy heading to 800 ft, then turn right to a heading of 320 deg. When the acft took off, tower psnl did not have visual contact…Dec 24, 1988 · N555ST · DestroyedNTSB MKC89LA046Accident · No injuriesLimited investigationFinal reportBeech A23A · California, MOThe pvt pilot said while attempting a downwind takeoff on a dark night from an unlighted sod strip, he received an intermittent stall warning horn shortly after lift-off. He lowered the nose and the acft struck the runway and rebounded into the air. He said…Dec 24, 1988 · N2364W · Substantial damageNTSB DEN89LA049Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Winnett, MTThe pilot was taking off from a farm strip with a 10 kt head wind. The plt said the sun was shining at the time of the acdt but there had been snow showers in the area. He said the liftoff was normal but at about 15 to 18 ft AGL the acft stalled and crashed.…Dec 23, 1988 · N5570H · Substantial damageNTSB MIA89LA053Accident · Minor injuriesLimited investigationFinal reportPilatus P-2/05 · St. Augustine, FLAfter an en route stop, the pilot took off in the newly acquired acft. Shortly after gear and flap retraction, the eng sustained a partial loss of power. The plt stated that all eng gages appeared normal and a turn was begun in an attempt to return to the…Dec 19, 1988 · N109PL · DestroyedNTSB DEN89LA044Accident · No injuriesLimited investigationFinal reportCessna 150E · Basin, WYThe private plt attempted a takeoff from his short farm field strip. During the takeoff ground run, the plt realized the acft would not have flying speed and clear the fence at the end of the field. He elected to try to jump the acft over the fence and land…Dec 17, 1988 · N6122T · Substantial damageNTSB NYC89LA048Accident · Serious injuriesLimited investigationFinal reportEnstrom F28F · Bradford, NHAn inflight contact with trees during takeoff after the student pilot experienced a loss of control due to his failure to adequately compensate for the winds.Dec 12, 1988 · N5699M · Substantial damageNTSB MIA89LA049Accident · No injuriesLimited investigationFinal reportCessna 182E · Ocala, FLShortly after rotation at an alt of aprx 20 ft AGL, the plt stated the control column would not move. He closed the throttle & the acft landed hard, bounced, then came to rest off the rwy. Examination of the acft revealed 3 of the 4 lower instrument panel…Dec 10, 1988 · N9261X · Substantial damageNTSB MKC89LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Crete, NEThe pvt pilot said shortly after takeoff, the engine coughed, sputtered, then quit. An emergency ldg was attempted on a farm field which resulted in substantial damage to the acft, serious injury to the pax and minor injuries to the pilot. Post accident…Dec 8, 1988 · N5875W · Substantial damageNTSB LAX89LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Carlsbad, CADuring the initial climb after takeoff, the engine lost power. Subsequently, the airplane collided with terrain as the plt was completing an emergency landing. An examination of the fuel tanks disclosed no evidence of fuel in the left tank. However, aprx 9…Dec 5, 1988 · N706FL · Substantial damageNTSB FTW89LA027Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Plano, TXFuel exhaustion which resulted from the pilot's inadequate fuel consumption calculations and his failure to utilize numerous suitable sources of fuel along his route of flight.Dec 3, 1988 · N7917X · Substantial damageNTSB ATL89DMG01Accident · 1 fatalFinal reportFlagg Teenie TWO · Albemarle, NCReportedly, the 150-hour pilot owner was performing a high speed taxi run to get acquainted with the airplane and its controls. The airplane taxiied down runway 22, using 3000 feet of the 4700 foot runway and suddenly became airborne. The flight continued to…Dec 3, 1988 · N4831Y · Substantial damageNTSB LAX89DVD01Accident · 1 fatalFinal reportHitchcock JH-1 · Petaluma, CAPlt was on initial flt in newly-built gyrocopter. After takeoff, witnesses observed the acft to climb to about 100 feet then to nose over until ground impact. No evidence of mechanical failure was found.Dec 2, 1988 · N58EE · DestroyedNTSB MKC89DCJ01Accident · 1 fatalFinal reportPiper PA-17 · Omaha, NEWitnesses observed the airplane takeoff and climb steeply to about 100 feet above ground. The airplane then turned sharply to the right and crashed into the ground in a nose low attitude. Investigation revealed no problems with either engine or airframe.Nov 28, 1988 · N4691H · Substantial damageNTSB MIA89IA043Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · San Juan, PRCompany maintenance crews replaced the high pressure bleed valve prior to the flight and installed the mounting clamp improperly. After takeoff the valve disconnected and the bleed air discharge activated the fire warning system. The crew discharged both fire…Nov 28, 1988 · N80057 · Minor damageNTSB NYC89LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Danielson, CTFailure of the pilot to recognize a stall and take corrective action prior to experiencing a loss of control.Nov 26, 1988 · N8172P · DestroyedNTSB MKC89LA026Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Salisbury, MOThe pilot said shortly after takeoff the engine lost power. He attempted to land on a plowed field, and after rolling about fifty yards on the rough, soft terrain, the aircraft nosed over. Post accident investigation revealed the engine lost power due to fuel…Nov 22, 1988 · N8927C · Substantial damageNTSB MKC89LA028Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lino Lakes, MNShortly after takeoff and climbing to about 150 AGL, the pilot said the engine began sputtering and losing power. Attempts to correct the situation by pumping the throttle and working the engine primer failed to correct the situation, and shortly thereafter…Nov 20, 1988 · N12MZ · Substantial damageNTSB NYC89FA033Accident · 3 fatalField investigationFinal reportBeech A35 · Shirley, NYLoss of control during takeoff, due to the failure (separation) of the right rudder control cable. Contributing to the accident was improper inspection and maintenance of the cable.Nov 18, 1988 · N8697A · DestroyedNTSB CHI89FA026Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Chicago, ILThe first takeoff was aborted due to a perceived engine problem. Six minutes later on second takeoff, the aircraft climbed to 50 feet, drifted to the right, rolled right and impacted in the infield. This was a single pilot operation in a complex aircraft.…Nov 17, 1988 · N271MA · DestroyedNTSB LAX89LA044Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Inyokern, CAThe pilot stated that, 'I landed in an open unpopulated area for the mechanic ... To make adjustments on the main blade (we were tracking and balancing the blades). I never shut the engine down. I disengaged the clutch. After the adjustment was made, I…Nov 16, 1988 · N552CS · DestroyedNTSB ATL89LA037Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Lawrenceville, GAImproper repair and/or modification of the carburetor airbox by unknown person(s), and the subsequent failure of maintenance personnel to detect the improper repair/modification during annual inspection(s), which led to a loss of power due to carburetor…Nov 15, 1988 · N96164 · Substantial damageNTSB CHI89LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Indianapolis, INThe plt rprtd that immediately after rotation & drg the initial climb, the rgt eng began to backfire & run rough. When the eng contd to run rough in spite of attempts to smooth it out, the plt elected to abort the takeoff. At that time, the acft was at about…Nov 14, 1988 · N6292 · Substantial damageNTSB CHI89DEV03Accident · No injuriesFinal reportRyan Navion · Lane, ILAirplane landed in a plowed field after losing power during initial climb. The flight purpose was to accomplish a biennial flight review. The landing gear failed after digging into the soft dirt of the plowed field. During the investigation the acft owner…Nov 14, 1988 · N91411 · Substantial damageNTSB LAX89LA047Accident · No injuriesLimited investigationFinal reportBeech H35 · Corning, CAThe flt originated at hayward, CA, with a stop at san carlos, CA and Corning, CA. The plt's destination was the red bluff arpt (rbl). The plt reported that when he departed hayward both main fuel tanks were full. He flew to san carlos where he picked up three…Nov 12, 1988 · N5594D · DestroyedNTSB BFO89LA008Accident · No injuriesLimited investigationFinal reportCessna 207 · Topping, VAThe pilot of N76470 departed on rwy 18 and followed the noise abatement procedure before turning downwind for rwy 18. The pilot of N73114 departed the grass rwy 18 and flew the noise abatement procedure prior to turning to a heading of 070 deg to depart the…Nov 12, 1988 · N73114 · 2 aircraft · Minor damageNTSB MKC89LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mena, AROn left crosswind leg, during initial climb, the aircraft experienced a total loss of power. The acft had reached about 800 feet AGL and was about 1 1/2 miles from the departure end of the runway. An emergency ldg was attempted which resulted in substantial…Nov 11, 1988 · N9109J · Substantial damageNTSB ANC89LA016Accident · No injuriesLimited investigationFinal reportCessna 180 · Meshik Lake, AKThe pilot was attempting to takeoff from an unimproved landing area with two hunter-friends. He stated that the aircraft bounced three times, reached an altitude of about four feet, then hit the ten-foot high trees at the departure end of the area and nosed…Nov 11, 1988 · N420SB · Substantial damageNTSB MIA89LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe plt taxied to rwy 6 & made an eng run-up. As he called the twr for tkof, a navy P-3 was making a low apch to rwy 10.the plt was told to taxi to rwy 10. Abt 30 sec later, as he arrived at rwy 10, he was clrd for tkof & was cautioned abt wake turbc fm the…Nov 9, 1988 · N6578B · Substantial damageNTSB LAX89LA039Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Yucca Valley, CAThe student plt and the CFI agreed that the acft developed a high sink rate as it passed over the departure end of the dirt rwy. The acft collided with the ground about 3/4 mile from the rwys end. The winds were variable but basically from the south at 15-20…Nov 5, 1988 · N94TB · Substantial damageNTSB LAX89LA040Accident · No injuriesLimited investigationFinal reportMooney M20J · San Diego, CADuring the initial climb after takeoff, the engine lost partial power. A turn was made to land on rwy 10R, but the pilot was unable to reach the landing area. Subsequently, he made a wheels-up landing short of the runway. An inspectionof the engine revealed…Nov 4, 1988 · N3875H · Substantial damageNTSB FTW89FA013Accident · 4 fatalField investigationFinal reportAerospatiale AS-355F-1 · W. Cameron 617The loss of control of the aircraft which occurred when the tail rotor drive shaft experienced a fatigue induced material failure and tail rotor thrust was lost. Evidence indicated that the shaft was under designed for the loads that were encountered during…Nov 4, 1988 · N355EH · DestroyedNTSB LAX89LA033Accident · Serious injuriesLimited investigationFinal reportChampion 7FC · Hesperia, CAWitnesses rprtd that the winds at the arpt were out of the west at about 20 KTS with peak gusts of about 37 KTS. They stated the wind sock was indicating a direct x-wind with rwy 3/21 & that the plt initiated his takeoff on rwy 21. Witnesses rprtd that during…Nov 3, 1988 · N9874Y · DestroyedNTSB LAX89FA034Accident · 1 fatalField investigationFinal reportBell 47G2 · Phoenix, AZLoss of aircraft control by a unqualified person.Nov 3, 1988 · N5163B · Destroyed