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 CHI88LA235Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Detroit Lakes, MNDuring the initial climbout, as the aircraft climbed through approximately 200' AGL, the powerplant failed completely. The pilot executed a forced landing in an plowed field, substantially damaging the aircraft. Post-accident examination of the engine…Sep 11, 1988 · N2616R · Substantial damageNTSB BFO88FA082Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Orange, VAPilot initiated lift off before flying speed was gained and as a result the aircraft had a loss of aerodynamic lift and stalled on the initial takeoff climb. The pilot's inadequate inflight decision and failure to abort the takeoff are contributing factors.Sep 11, 1988 · N98121 · DestroyedNTSB SEA88LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Battle Mountain, NVAt about 1 mile from the departure airport and 200 feet AGL, the pilot elected to make a right turn back to the airport, as the aircraft was not climbing and power lines were in the flight path. During the turn, the pilot lost control of the aircraft. The…Sep 10, 1988 · N8895V · DestroyedNTSB NYC88LA234Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Griswold, CTThe takeoff was made with the temp at about 90 deg f. the acft was about 60 lbs over the authorized max gross wt. Witnesses said the nose of the acft was high as it passed over trees just beyond the end of the rwy. The acft then descended with the wings…Sep 10, 1988 · N1840T · DestroyedNTSB LAX88DVA16Accident · Minor injuriesFinal reportHiller UH-12E · Helm, CADuring an aerial application flight, the pilot lost control of the helicopter just after liftoff and collided with the terrain. Inspection of the wreckage revealed that the chemical trucks filler hose was still attached to the helicopter when it lifted off.Sep 10, 1988 · N4029Y · Substantial damageNTSB CHI88LA234Accident · No injuriesLimited investigationFinal reportFairchild PT-19 · Converse, INDuring initial climbout after takeoff, the aircraft experienced a loss of engine power. After an unsuccessful attempt to restart the engine, the pilot executed a forced landing in a corn field. Post accident exam revealed a broken universal joint in the fuel…Sep 10, 1988 · N46876 · Substantial damageNTSB ATL88DKG18Accident · No injuriesFinal reportGrumman G-164B · Smithville, GASoon after takeoff from a private sod airstrip for aerial application maneuvering, the engine lost power. The plt was forced to land in soft muddy terrain where the acft nosed over. Post acc invest revealed that the float assy in the carburetor jammed which…Sep 9, 1988 · N8132K · DestroyedNTSB LAX88FA312Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Camarillo, CAThe pilot decided to operate the aircraft with a known electrical deficiency during night instrument meteorlogical conditions and the decision of the pilot to conduct a flight operation in which he was not certified. Contributing to this accident was the…Sep 8, 1988 · N8743W · DestroyedNTSB CHI88LA232Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Watertown, WIThe pilot in command's improper selection of the fuel tank, and his subsequent failure to maintain control of the aircraft.Sep 8, 1988 · N9346C · DestroyedNTSB SEA88LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Leavenworth, WAOn initial climb over trees bordering 2500-FT mountain strip, plt experienced sudden and severe wind gusts beyond his capability to counter. Acft collided with trees and terrain.Sep 5, 1988 · N2811Q · Substantial damageNTSB FTW88LA163Accident · No injuriesLimited investigationFinal reportAmerican AA1B · Houston, TXShortly after liftoff, the engine lost power and the pilot turned toward a field. The nose wheel struck a levee and the airplane flipped inverted. During a post-crash inspection, a large mud dauber nest was found inside the air induction system, just behind…Sep 5, 1988 · N6208L · Substantial damageNTSB LAX88FA308Accident · 1 fatalField investigationFinal reportCessna 150F · Chino, CAPilot's in flight loss of control of the aircraft during a banner pickup sequence.Sep 4, 1988 · N7093F · DestroyedNTSB CHI88LA236Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Hinckley, ILDuring the initial climbout on the dual instructional flight, as the glider was towed through approximately 50-100' AGL, the tow rope failed. The instructor pilot executed a hard forced landing at the edge of a cornfield located to the right side of the…Sep 4, 1988 · N3613F · Substantial damageNTSB ANC88LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot stated that during the takeoff roll and initial climb from the gravel bar, he lost directional control of the airplane causing the airplane to stall, then the airplane ground looped.Sep 4, 1988 · N7697D · Substantial damageNTSB ANC88LA123Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Fairbanks, AKThe airplane was on a climbout at approximately 1000 to 1200 feet m.s.l. when the engine quit and the pilot encountered an engine fire. The pilot elected to go back to the airport. The airplane crashed on the taxiway, and the airplane was substantially…Sep 4, 1988 · N906JS · Substantial damageNTSB DEN88LA198Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Peyton, COSep 3, 1988 · N6737F · Substantial damageNTSB MIA88LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Lakeland, FLWhile on a ferry flt shortly after takeoff the plt reported that the eng slowly began to lose power. He then attempted to land on another rwy but lost control of the acft & crashed short. An eng run was accomplished which revealed no evidence of pre-impact…Sep 1, 1988 · HBPLH · Substantial damageNTSB DCA88MA072Accident · 14 fatalClass 1 · MajorFinal reportBoeing 727-232 · Dallas/Ft Worth, TX(1) The captain and first officer's inadequate cockpit discipline which resulted in the flightcrew's attempt to takeoff without the wing flaps and slats properly configured; and (2) the failure of the takeoff configuration warning system to alert the crew…Aug 31, 1988 · N473DA · DestroyedNTSB ANC88LA120Accident · No injuriesLimited investigationFinal reportCessna 170B · Willow, AKAfter the student did a touch and go, during the initial climb out, the airplane stalled and crashed into a row of trees at the end of the runway. The student pilot reportedly startled by turbulence, pulled rapidly back on the control yoke, and the aircraft…Aug 31, 1988 · N2905D · Substantial damageNTSB SEA88FA166Accident · 1 fatalField investigationFinal reportCessna 150H · Caldwell, IDThe plt flew to hubler field (a pvt 2800' strip) & landed. After landing on rwy 10, he taxied back to the apch end & took off again. As the acft was climbing, about 60' over trees at the departure end, it rolled abruptly to the left, entered a steep descent &…Aug 30, 1988 · N23204 · Substantial damageNTSB LAX88LA302Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Dunsmuir, CAJust after takeoff, the airplane gained just enough altitude to clear trees at the end of the runway. The pilot turned up a valley to gain altitude. The airplane was gaining altitude at 150 fpm, however, the valley turned into a box canyon and the airplane…Aug 29, 1988 · N5058K · Substantial damageNTSB MKC88FA164Accident · Serious injuriesField investigationFinal reportPiper J3 · York, NEVisual outlook not maintained by pilot in command.Aug 28, 1988 · N3J · Substantial damageNTSB CHI88DEC07Accident · No injuriesFinal reportCessna 305A · Gregory, MIFailure (at first partial, then total) of the aircraft's powerplant at an altitude of about 100 feet above the ground during the initial climbout with a glider in tow; a forced landing ensued, during which the aircraft struck a fence, a small tree, and…Aug 28, 1988 · N5166G · Substantial damageNTSB NYC88DFJ03Accident · Serious injuriesFinal reportGarlick/Guppy SNS-2 · Honeoye Falls, NYThe homebuilt airplane was being operated on the first test flight after its completion. During takeoff, the airplane climbed about 100 ft AGL, then crashed in an open field adjacent to the airport. No preimpact part failure/malfunction of the airplane was…Aug 27, 1988 · N222AG · Substantial damageNTSB LAX88LA298Accident · No injuriesLimited investigationFinal reportStinson L-5 · Chino, CADuring the initial climb, the pilot reported that the engine lost power. The pilot initiated a forced landing and during the descent, the airplane collided with a fence coming to rest inverted. Fuel was observed to be leaking from the left wing. When the fuel…Aug 27, 1988 · N723E · Substantial damageNTSB ATL88DKG14Accident · Minor injuriesFinal reportAyres Thrush S2R · Ochlocknee, GAShortly after takeoff the pilot allowed the nose to drop resulting in a collision with the ground. The airplane hit the ground, right wing first, and traveled about 500 feet before stopping. The pilot had been spraying methyl parathion all day and stated he…Aug 26, 1988 · N4006P · Substantial damageNTSB MIA88FA261Accident · 3 fatalField investigationFinal reportPiper PA-60 · Pembroke Pines, FLWitnesses stated that the acft used almost the entire length of the runway during the ground run. After rotation & gear retraction, it continued to climb in a nose high attitude to aprx 100-150 feet, then it started an aprx 20 degree bank to the right until…Aug 25, 1988 · N6069W · DestroyedNTSB NYC88LA228Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Doylestown, PAThe CFI and student plt took off from a 2330 ft turf rwy. Witnesses said the wind was calm and it was hot. The pilots both said that everything seemed normal until the acft reached about 200 ft AGL at which time they lost lift due to either a power loss or…Aug 24, 1988 · N1203K · DestroyedNTSB DEN88LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lordsburg, NMFollowing takeoff the acft lost power at 150-200 ft AGL. Plt landed in rough terrain. During landing the left wing and landing gear separated. Examination revealed a failed exhaust valve guide and soft valve springs due to blow-by heat. At the time of the…Aug 24, 1988 · N6189H · Substantial damageNTSB CHI88FA218Accident · 2 fatalField investigationFinal reportCessna 150F · Bellbrook, OHFailure of the PIC to maintain sufficient airspeed to sustain flight during initial climb to clear a barrier after taking off from an off airport area.Aug 23, 1988 · N8660G · DestroyedNTSB MKC88LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Elaine, ARDuring an aerial application operation, the pilot said that immediately after breaking ground on takeoff, the engine quit. He attempted to re-land on the remaining available runway, but ran off the end, hitting a ditch and nosing over. Cause of the engine…Aug 22, 1988 · N6661Q · Substantial damageNTSB NYC88DHA03Accident · No injuriesFinal reportDebarry/Starduster SA100 · Slatington, PAAs the homebuilt acft was climbing thru about 300 ft AGL during initial climb after takeoff, the eng lost power. The plt was able to restart the eng (once), but as he turned the acft back toward the arpt, the eng lost power again. During an emerg landing, the…Aug 21, 1988 · N22GT · Substantial damageNTSB CHI88LA215Accident · No injuriesLimited investigationFinal reportCessna 170 · Boyceville, WIShortly after lift-off, the aircraft encountered a gust of wind and the pilot failed to compensate adequately for the wind conditions. The pilot experienced a loss of aircraft control and decided to reject the takeoff and execute a landing. The aircraft…Aug 21, 1988 · N3804V · Substantial damageNTSB LAX88DUQ04Accident · No injuriesFinal reportTexas Helicopter M74A · Lancaster, CADuring an aerial application flight, just after takeoff, the nose of the helicopter suddenly pitched up. The pilot reduced power to keep from climbing. The fore/aft cyclic control had no effect. The helicopter settled to the ground resulting in substantial…Aug 19, 1988 · N51862 · Substantial damageNTSB DEN88FA186Accident · 2 fatalField investigationFinal reportLuscombe 8A · Dimock, SDThe plt was giving airplane rides to some neighbors from his private airstrip. He had just taken off with a new pax. A witness reported observing the acft skimming close to the ground after liftoff, and then the acft climbed quickly. The acft then banked…Aug 18, 1988 · N71572 · DestroyedNTSB CHI88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140E · Glidden, WIWhile attempting to takeoff from a 2,175' grass strip, with the aircraft loaded near maximum gross weight, the pilot approached the end of the runway without having attained liftoff airspeed. The pilot lifted the aircraft off the ground prematurely and was…Aug 18, 1988 · N4476T · Substantial damageNTSB NYC88LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Georges Mills, NHWitnesses reported the wind was gusty and there were whitecaps on the lake when the acft attempted to takeoff. The plt said that when the acft had climbed to a sufficient altitude he began a left turn to climb over the lake. After the turn was started the…Aug 16, 1988 · N2906M · Substantial damageNTSB LAX88LA289Accident · No injuriesLimited investigationFinal reportCessna 177 · Jackson, CAJust after takeoff, the engine quit at aprx 50 ft AGL. The pilot made an emergency forced landing off the runway, where during the landing roll the airplane collided into a fence. There were no mechanical failures or malfunctions found during an engine…Aug 16, 1988 · N3270T · Substantial damageNTSB MKC88LA159Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Swifton, ARShortly after takeoff during an aerial application operation, the pilot said he was unable to establish a positive climb. After traveling about 1 mile, he elected to dump his dry fertilizer load. When he dumped the load, the increased aerodynamic drag caused…Aug 15, 1988 · N8856Q · Substantial damageNTSB CHI88FA206Accident · 1 fatalField investigationFinal reportAeronca 7CCM · Barker, NYThe pilot in command failed to maintain control of the airplane.Aug 15, 1988 · N83255 · DestroyedNTSB LAX88LA285Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Lake Arrowhead, CADuring a local parachute jump flight, the airplane was unable to gain enough altitude to clear rising terrain. The airplane collided with a tree and eventually the terrain. There were no reported mechanical failures or malfunctions. The acft handbook lists…Aug 14, 1988 · N4788F · Substantial damageNTSB DEN88LA182Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Pueblo, COAug 13, 1988 · N2341Z · Substantial damageNTSB NYC88FA216Accident · 2 fatalField investigationFinal reportCessna TU206G · White Lake, NYThe float equipped aircraft made multiple takeoff attempts on a lake, getting airborne at least once prior to the accident. On the takeoff run that terminated in the accident, the pilot turned into an inlet after getting airborne with insufficent room to turn…Aug 12, 1988 · N4613Z · Substantial damageNTSB CHI88LA202Accident · No injuriesLimited investigationFinal reportWaco ATO · Middletown, OHThe plt stated that during initial climb the engine sputtered and he discovered that the fuel pressure gauge read zero. He made an immediate right turn back toward the airport. While attempting to glide to the airport he noticed that the fuel selector was set…Aug 12, 1988 · N763E · Substantial damageNTSB NYC88LA215Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Montgomeryville, PAThe plt reported that the flt took off with light & variable winds. He said he used the short fld, obstacle clearance procedure to avoid powerlines which are located 1000 ft from the end of the rwy. After the acft became airborne it would not climb. A turn…Aug 11, 1988 · N8233N · DestroyedNTSB MIA88LA250Accident · Minor injuriesLimited investigationFinal reportContinental Copters MK-5A · Valley Park, MSThe pilot stated that he thought he had 8 gallons of fuel prior to takeoff. The engine failed about 100 ft AGL and he attempted to stretch the glide of the helicopter by using collective pitch. The aircraft hit hard and rolled over. Only 1 quart of fuel was…Aug 10, 1988 · N9086T · Substantial damageNTSB FTW88IA147Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Oklahoma City, OKThe flight was an instructional flight with three pilots onboard. The airplane departed on runway 17R and was 300 to 400 feet AGL when one blade of the right propeller separated from the hub, followed by the remainder of the propeller. The PIC made an…Aug 10, 1988 · N3589B · Minor damageNTSB CHI88FA198Accident · 2 fatalField investigationFinal reportPiper PA-28 · Auburn, INFlight known adverse weather conditions.Aug 10, 1988 · N3828K · DestroyedNTSB MKC88LA151Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lees Summit, MOShortly after takeoff, on a touch and go, after a full flap landing, the CFI and student said they heard a loud bang about 150 AGL on climbout. The CFI took over the controls and said they were nonresponsive in pitch. Full throttle was maintained and they…Aug 8, 1988 · N51390 · Substantial damageNTSB NYC88LA206Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Kutztown, PALoss of control during takeoff after the canopy came open. Contributing was the failure of the pilot to properly close the canopy prior to takeoff.Aug 7, 1988 · N65920 · Substantial damage