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 MKC89FA017Accident · Serious injuriesField investigationFinal reportCessna T210M · Clarksville, ARThe pilot took off on a 4500 ft runway, raised the landing gear, and turned south at approximately the 2500 ft point. Aircraft lost engine power. Pilot attempted to return to departure runway. Aircraft impacted prior to reaching the runway. Examination of the…Oct 31, 1988 · N1357M · Substantial damageNTSB LAX89LA029Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Saint Johns, AZJust after takeoff, the pilot noted cylinder head temp and manifold pressure above red line and a loss of engine power. Mixture had been leaned for tkof. The engine quit when the plt closed the turbocharger wastegate. A forced landing was made upslope on…Oct 31, 1988 · N8580M · Substantial damageNTSB ATL89LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Hilton Head Is., SCThe plt reported that the airplane lost power shortly after takeoff. A forced ldg was subsequently made in a swamp near the arpt. The airplane nosed over during rollout. Post-crash exam of the airplane revealed that the throttle cable outer casing had become…Oct 30, 1988 · N1275U · Substantial damageNTSB BFO89LA006Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cambridge, MDThe stu plt did three takeoffs & lndgs with the instr aboard and then three more during solo flight. On his fourth takeoff try he used aileron and rudder to maintain directional control on the rwy. There was an 8 to 10 kt crosswind. The stu said when the acft…Oct 29, 1988 · N63019 · Substantial damageNTSB ATL89LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazel Green, ALThe flight instructor and the pre-solo student crashed after takeoff about 1/2 mile from the Hazel Green airport. The acft had been operated about one hour since the original takeoff from huntsville, Alabama. The instructor pilot reported that about 12…Oct 29, 1988 · N555DU · Substantial damageNTSB MIA89LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Homestead, FLThe plt rprtd that while climbing at night after takeoff, the eng sputtered. He suspected possible water in the fuel & landed across rows in a field. Drg the landing, the gear failed & the acft came to rest on its belly with a bent prop, torn fabric & dmgd…Oct 25, 1988 · N26820 · Substantial damageNTSB MIA89IA016Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-600R · San Juan, PRThe acft departed runway 8 at 1810 ast. The plt reported a rt eng fire and declared an emergency. The acft was landed at 1815 ast, turned off the runway, and all the passengers were evacuated via the slides. According to maintenance personnel in San Juan, the…Oct 24, 1988 · N70054 · No damageNTSB ATL89LA017Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Advance, NCDuring takeoff climb eng quit then re-started. PIC turned to the north & engine quit again. PIC stalled acft & crashed into wheat field. Acft had STC for auto gas. Fuel in acft had water & rust contaminants. Fuel lines had dried. Carb had composite float. The…Oct 24, 1988 · N5361Z · Substantial damageNTSB NYC89LA017Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Trumbauersville, PAAn off airport landing in which the aircraft struck trees and a swing set, following a power loss caused by the failure of the pilot to determine that the fuel selector was in the off position and to turn it on prior to the power loss.Oct 23, 1988 · N185SH · Substantial damageNTSB LAX89FA022Accident · 2 fatalField investigationFinal reportCessna 172N · Petaluma, CAPilot used poor judgement when he attempted v.f.r. flight during instrument meteorological conditions and that he encountered spatial disorientation when he entered into the clouds.Oct 22, 1988 · N9372E · DestroyedNTSB DEN89LA022Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Peyton, COA practice touch and go landing was being made on rwy 15, with winds reported as gusting to 20 knots. During the takeoff, the wing flaps would not retract and the aircraft climbed to 15 ft AGL. The pilot said he attempted to land after flying 500 yards and…Oct 22, 1988 · N9062H · Substantial damageNTSB MKC89LA008Accident · No injuriesLimited investigationFinal reportDavis TRI-Q-200 · Carthage, MODrg the 2nd flt of the newly constructed home built acft, the eng began to lose power shortly after takeoff. The plt reentered the pattern for a precautionary landing, but misjudged the apch & had to go around. Drg the next apch, the eng lost power…Oct 21, 1988 · N800Q · Substantial damageNTSB MIA89FA015Accident · Serious injuriesField investigationFinal reportLake LA-4-250 · Key West, FLThe plt reduced engine power during initial climb from a touch and go landing on the gulf of Mexico. The acft stalled and descended uncontrolled back to the water, striking the water hard. The acft then bounced and again hit the water in a nose low right wing…Oct 21, 1988 · N250MW · Substantial damageNTSB FTW89DPA02Accident · Minor injuriesFinal reportPilatus B4PC11 · Bridgeport, TXThe glider was being tow-launched by an automobile from the pilot's private ranch airstrip. When the glider was approximately 250 feet AGL, the tow rope separated and the pilot attempted to return to the airstrip. A downdraft made this impossible and the…Oct 17, 1988 · N8349 · Substantial damageNTSB MKC89LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Marion, NEShortly after takeoff from a farm field, the acft's left wing dropped & the acft descended striking the terrain. Witnesses said that immediately after takeoff, the plt attempted to make a steep climbing, left turn. A post acdnt inspn revealed no preimpact…Oct 16, 1988 · N288T · Substantial damageNTSB DEN89DTE01Accident · 1 fatalFinal reportHicks/Mervin RH-3 · Erie, COOct 16, 1988 · N69272 · DestroyedNTSB MIA89LA011Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Tampa, FLThe plt stated the acft was topped with 30 gals of auto fuel prior to departing for the open house at mcdill afb. The flt to mcdill was normal. Before departure, about 1/2 inch of water was drained from the fuel system during preflt inspection. At about 300…Oct 15, 1988 · N4553V · Substantial damageNTSB LAX89DUQ01Accident · 1 fatalFinal reportLewis Moni · Lancaster, CADuring a local flight, shortly after takeoff, the pilot reported engine trouble. The pilot was cleared to land at his discretion. The glider was observed to make a steep left descending turn subsequently colliding with the terrain. This was an experimental…Oct 15, 1988 · N8123 · DestroyedNTSB DEN89LA015Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Edgewood, NMThe acft had just been overhauled & a new prop (hartzell model 7636D-4) had been installed in place of the old prop. The plt rprtd that after takeoff, the acft failed to climb, although he was using full power. He said he headed for lower terrain & circled…Oct 14, 1988 · N7258D · Substantial damageNTSB MIA89IA008Incident · No injuriesIncident investigationFinal reportCessna 210M · Orlando, FLAfter takeoff when the ldg gear was raised, the plt noted that the gear motor circuit breaker popped and that he could not lower the landing gear using the emergency gear extension procedures. He landed gear up in the grass. Post accident investigation…Oct 11, 1988 · N9064M · Minor damageNTSB FTW89DPJ01Accident · 1 fatalFinal reportAutra Scorpion/133 · Mcalester, OKThe homebuilt helicopter was departing on a local flight, when, on initial climbout, the low time, inexperienced student pilot made an abrupt maneuver which sent the helicopter into an uncontrolled descent. It impacted trees and a post crash fire occurred.Oct 10, 1988 · N137A · DestroyedNTSB NYC89LA018Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-35C · Methuen, MAPilot uncontrolled contact with a tree during a landing after the pilot failed to connect his aileron controls and accepted a tow to get airborne.Oct 9, 1988 · N2737H · Substantial damageNTSB NYC89FA007Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Akron, NYThe Piper PA-18-135 stalled on takeoff and crashed. Witnesses said they observed the aircraft nose high, not climbing, and at a slow airspeed. They reported that the aircraft banked left and struck trees. The aircraft descended through the trees to the ground…Oct 9, 1988 · N8179C · DestroyedNTSB CHI89LA003Accident · No injuriesLimited investigationFinal reportChampion 7EC · Bainbridge, OHOct 9, 1988 · N9836Y · Substantial damageNTSB DEN89FA009Accident · 1 fatalField investigationFinal reportCessna T210M · Clovis, NMBefore dawn, witnesses (who were preflighting an acft) saw N732QP taxiing to rwy 4. They heard an eng run-up; however, they were unable to see the acft takeoff due to heavy fog that had just moved over the arpt. (The witnesses decided to cancel their flt due…Oct 7, 1988 · N732QP · DestroyedNTSB LAX89DVG01Accident · Serious injuriesFinal reportGlasair FT · Redding, CAOn takeoff, plt's canopy came open. When plt diverted attention to close canopy, acft collided with a tree, then terrain. Investigation revealed no canopy latch malfunction. Post acc exam showed that the plts canopy latches were undamaged.Oct 6, 1988 · N197RL · DestroyedNTSB ANC89LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Healy Lake, AKAfter waiting for more favorable wind conditions, the student pilot and his passenger attempted a departure from a dirt strip surrounded by trees. The non-rated passenger stated that 'after becoming airborne and climbing slightly above the treetops, it felt…Oct 3, 1988 · N3421A · Substantial damageNTSB SEA89FA002Accident · 2 fatalField investigationFinal reportCessna T210M · Prosser, WAThe flight was on initial climb after takeoff at 400 AGL when the engine quit. During the ensuing forced landing, the aircraft impacted on an interstate highway perpendicular to the roadway, bounced into open pasture land, impacted a rock berm and burst into…Oct 2, 1988 · N1817M · DestroyedNTSB SEA89FA001Accident · 3 fatalField investigationFinal reportCessna Robertson 337A · Eliza Island, WAThis Cessna/robertson 337 was departing from a 1600 foot grass strip in VFR conditions. There were gusting head winds estimated at 15 knots. At the midpoint of the runway the aircraft made a steep climbing left turn, stalling after about 180 degrees of turn.…Oct 2, 1988 · N6314F · DestroyedNTSB NYC89LA002Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Derry, NHThe acft collided with trees after takeoff from a private airstrip with a rwy which has 1,200 feet useable length. The field elev is 425 ft and the plt EST the temp to be 60 deg f. the plt said the takeoff was made to the NE. The wind was reported to be out…Oct 2, 1988 · N2715A · DestroyedNTSB MKC89LA001Accident · No injuriesLimited investigationFinal reportSchweizer TG3A · Yoder, KSAn abrupt maneuver resulting in a stall/spin and subsequent aircraft control not being maintained by the pilot in command.Oct 2, 1988 · N73483 · Substantial damageNTSB LAX89LA005Accident · No injuriesLimited investigationFinal reportCessna 150M · Tucson, AZThe acft collided with the terrain shortly after an intersection tkof from the Tucson international airport. The plt reported that during the initial climb the a/c was not producing sufficient lift in order to maintain alt to clear obstacles. The plt aborted…Oct 2, 1988 · N8998U · Substantial damageNTSB BFO89LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cumberland, MDThe pilot stated that shortly after takeoff at an altitude of aprx 150 ft AGL, the engine sputtered and lost power. According to the police report, the pilot attempted to return to the airport. During the turn the wingtip contacted the ground and the airplane…Oct 2, 1988 · N7653D · Substantial damageNTSB SEA89LA004Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Bellingham, WADrg the initial climb after takeoff, the eng lost power. Subsequently, the acft was damaged drg an emergency landing in a rough field northwest of the arpt. A post-acdnt eng run-up was made with a club prop installed. The eng operated normally to 1500 RPM…Oct 1, 1988 · N2068Q · Substantial damageNTSB LAX88DVA17Accident · No injuriesFinal reportHiller UH12E · Mcfarland, CAOct 1, 1988 · N46991 · Substantial damageNTSB CHI88FA249Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Columbus, OHAerodynamically stalled lifting surface causing an uncommanded pitch over at an altitude too low to affect a recovery.Oct 1, 1988 · N14HR · DestroyedNTSB ANC88LA149Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Homer, AKJust after liftoff the airplane experienced a complete engine failure, the airplane crashed on the mud flats approximately 500 feet off the departure end of runway 21. The chief pilot stated that the pilot did not check the fuel supply prior to this flight…Sep 30, 1988 · N4634Z · Substantial damageNTSB DEN88LA209Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Questa, NMThe private plt and 1 pax were taking off using 2,500 ft of a 4,000 x 50 ft dirt strip with a d/a of 9,200 ft. during intial climb the plt noticed a sink rate. The plt said he varied the angle of flaps from 5 to 25 deg 'in search of lift.' The right wing and…Sep 29, 1988 · N8517B · Substantial damageNTSB MIA88LA274Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Groveland, FLThe acft crashed into the trees at the end of the rwy while on initial climb after sustaining complete eng failure. FAA personnel attempted to test run the engine after the accident, but were unable to due so due to an air leak on the gascolator. When upward…Sep 26, 1988 · N4365D · Substantial damageNTSB MKC88LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cameron, MOThe student pilot said he was practicing short field takeoffs from his pasture, when he stalled shortly after takeoff. The aircraft fell uncontrolled to the terrain causing substantial damage to the wings, fuselage and nose gear.Sep 25, 1988 · N2866Q · Substantial damageNTSB FTW88DRG13Accident · Serious injuriesFinal reportBingelis T-40 · Georgetown, TXThe pilot's inability to maintain control of an aircraft that he had never flown before, as well as, his inability to apply remedial action as required for the flight regime.Sep 24, 1988 · N187T · DestroyedNTSB FTW88DPJ13Accident · Serious injuriesFinal reportNord 1101 · Ardmore, OKImmediately after liftoff, the airplane abruptly turned left, nosed down, and struck the ground. Examination of the electrical pitch control of the propeller revealed the propeller blades to be in the high pitch, low RPM position. Due to extreme damage of the…Sep 24, 1988 · N5337M · Substantial damageNTSB SEA88LA186Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Seattle, WAPlt received ATIS info which advised of gusty crosswind conditions and low level wind shear and recommended contacting Seattle radio(fss) for further info. Plt did not contact fss and initiated takeoff. At 100-200 ft AGL, acft encountered turbulence, pitched…Sep 23, 1988 · N96248 · Substantial damageNTSB LAX88FA327Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Fullerton, CAFailure of the pilot to properly preflight the acft followed by loss of power during takeoff. The plt also failed to about the takeoff.Sep 23, 1988 · N3451W · DestroyedNTSB CHI88DET06Accident · 1 fatalFinal reportJones None · Elkhart, INInadequate aircraft design which resulted unacceptable aircraft takeoff and climb capability.Sep 21, 1988 · UNREG · DestroyedNTSB LAX88FA321Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Big Bear, CAThe pilot failed to maintain airspeed during takeoff. Contributing factors related to the high density altitude condition, the aircraft's excessive weight and the pilot's failure to lean the mixture. Also contributing to the accident was the pilot's improper…Sep 18, 1988 · N55478 · DestroyedNTSB MIA88FA269Accident · 1 fatalField investigationFinal reportCessna 305A · Tampa, FLPlt experienced complete loss of engine power while climbing through 200 ft. the aircraft stalled and mushed, descending out of control and crashing to the ground. The engine was operated to full power after the accident. The cause of the loss of engine power…Sep 17, 1988 · N5223G · Substantial damageNTSB CHI88DER12Accident · No injuriesFinal reportCessna A188B · Clearbrook, MNOn initial climb the right cowling door came open. The pilot was unable to maintain a climb and elected to make an emergency landing in a hay field. The aircraft encountered unsuitable terrain and received substantial damage. Post accident inspection of the…Sep 14, 1988 · N4915Q · Substantial damageNTSB SEA88LA179Accident · No injuriesLimited investigationFinal reportCessna 152 · Cottage Grove, ORA loss of power occurred after takeoff from runway 33, during turn from upwind to crosswind, while doing touch and go landings. After checking the fuel selector and applying carburetor heat, the instructor pilot made a right turn back to the runway. The wind…Sep 12, 1988 · N68142 · Substantial damageNTSB LAX88FA332Accident · Serious injuriesField investigationFinal reportFairchild Hiller FH-1100 · Picacho, AZOwner/pic used poor judgement in allowing an unqualified pilot to fly the helicopter when it was not equipped with dual controls.Sep 11, 1988 · N1345Q · Destroyed