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 ATL88FA155Accident · Serious injuriesField investigationFinal reportCessna 150L · Knoxville, TNApr 25, 1988 · N1491Q · DestroyedNTSB ATL88LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Watkinsville, GAStrong headwinds were encountered during the x-c flt. The plt landed at an arpt to refuel but found the arpt FBO to be closed. He continued on toward his destination. About 10 miles from his destination, he made a precautionary ldg in a field due to a…Apr 24, 1988 · N5921T · Substantial damageNTSB SEA88FA083Accident · 1 fatalField investigationFinal reportCessna 310G · Las Vegas, NVDuring initial climb at 100 ft after takeoff, the pilot announced he had lost an engine. Witnesses observed the aircraft enter a nose high attitude, roll to the right and descend in a vertical nose down attitude until impact with the ground. The aircraft…Apr 23, 1988 · N2924R · DestroyedNTSB FTW88DRA09Accident · 1 fatalFinal reportCurtis Baby Great Lakes · Angleton, TXShortly after liftoff, the acft was observed to enter a rt bank and then a left bank to a course parallel to the t/o rwy. It was subsequently observed to enter a left turn which steepened and the acft nosed over until ground impact. Original turn was executed…Apr 19, 1988 · N6915 · DestroyedNTSB NYC88LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lincoln Park, NJDuring takeoff the aircraft was observed to become briefly airborne; then the wing dipped just before ground contact. The aircraft crashed about 50 feet from the departure end of the runway and about 300 feet to the right. The pilot said he experienced a…Apr 17, 1988 · N9892K · Substantial damageNTSB ANC88FA045Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot-in-command was a certificated airframe and powerplant mechanic who was working on the airplane. The owner stated that the mechanic was not authorized to fly the airplane. The pilot's brother stated he had just disembarked from the airplane after a…Apr 17, 1988 · N4177Z · Substantial damageNTSB MKC88LA077Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Belton, MOWhile practicing touch and go landings, PIC said the engine quit shortly after takeoff. An emergency ldg was made in a nearby field, and during the roll out, the acft struck a terrace and nosed over. Post flight inspection revealed acft fuel tanks were empty.Apr 16, 1988 · N40178 · Substantial damageNTSB ATL88LA145Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Barnwell, SCDuring initial climb after takeoff right side of the engine cowling unfastened and began fluttering violently. The instructor assumed control of acft & made a forced landing straight ahead into a cultivated field. The acft nosed up sustaining substantial…Apr 16, 1988 · N4233E · Substantial damageNTSB MIA88LA148Accident · Serious injuriesLimited investigationFinal reportHenderson RV-4 · Defuniak Sprngs, FLShortly after takeoff at an alt of aprx 100 ft while on a personal flt, the eng quit. The plt banked the acft to the left to land on a rd but lost control during the maneuver. The acft descended uncontrolled and collided with terrain. Examination of the…Apr 15, 1988 · N51HH · Substantial damageNTSB DEN88FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Deer Lodge, MTApr 15, 1988 · N13788 · DestroyedNTSB MIA88LA147Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hastings, FLWhile on an aerial application flt shortly after takeoff, the eng lost power. The plt then dumped the load of fertilizer & landed the acft in a field. After touchdown it nosed over & came to rest. Examination of the eng revealed that the no. four cylinder…Apr 14, 1988 · N8841S · Substantial damageNTSB ATL88LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Painesville, OHThe CFI reported that while performing a simulated short field take-off the acft encountered a downdraft and settled into the trees. The CFI held his certificate for one month and the student plt had logged just over fifty hours. This airport was not approved…Apr 14, 1988 · N91371 · DestroyedNTSB ATL88FA142Accident · Serious injuriesField investigationFinal reportBalloon Works AX-8B · Alpharetta, GAApr 14, 1988 · N74070 · Substantial damageNTSB FTW88IA090Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Wichita Falls, TXThe right engine upper cowling separated during initial climb, went rearward, and shattered a window at the right rearmost passenger seat which was not occupied. The pilot secured the engine and made an uneventful landing. The cowling separated due to…Apr 13, 1988 · N905FB · Minor damageNTSB ATL88LA215Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Lawrenceville, GAThe instructor reported that he initiated a sim engine failure during climb at about 100 ft AGL, as part of the recurrency flight. The pilot initiated an autorotation, at about 50 ft AGL, the rate of descent increased and the throttle was rolled in to arrest…Apr 13, 1988 · N42JW · Substantial damageNTSB SEA88LA072Accident · 1 fatalLimited investigationFinal reportSteen Skybolt GT-2 · Saint John, WAAfter tkof witnesses said the acft did a maneuver at 50-60 ft AGL that involved a steep (90 degree) banked turn to a snap roll. The biwing acft was capable of aerobatic flt and the plt had discussed aerobatic roll maneuvers on tkof with the acft co-owner. The…Apr 12, 1988 · N76JJ · DestroyedNTSB ATL88LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Center Village, OHThe CFI attempted to demonstrate a short-field takeoff to his student, with a tailwind. He reported believing at the time that a light cross-wind/quartering tailwind was blowing. He elected to depart from rwy 27, because rwy 09 had utility wires at the…Apr 12, 1988 · N5089P · Substantial damageNTSB LAX88LA157Accident · Minor injuriesLimited investigationFinal reportAero Commander 560 · Bullhead City, AZApr 11, 1988 · N2705B · Substantial damageNTSB FTW88DRA07Accident · No injuriesFinal reportGrumman G-164B · Lissie, TXAcft experienced an eng failure shortly after t/o from a pvt strip. Acft had been recently refueled at the strip. On touchdown, the acft flipped over and slid to a stop. Investigation revealed water in the acft fuel tank and in the fuel supply tank.Apr 11, 1988 · N6620K · DestroyedNTSB MKC88LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Fort Smith, ARImmediately after takeoff, the student pilot performing his first supervised solo flight, said the aircraft began a left turn. He said the rudder pedals felt inoperative. He reduced power and landed adjacent the runway substantially damaging the acft.…Apr 8, 1988 · N31900 · Substantial damageNTSB ATL88LA134Accident · No injuriesLimited investigationFinal reportCessna 150C · Funston, GAThe plt reported that the engine lost pwr at 200-250 ft AGL after departing rwy 30 at the private 1,750' sod airstrip. He stretched his glide to avoid wires off of the end of the rwy. After clearing the lines. The airplane nose 'fell through', and the…Apr 7, 1988 · N7956Z · Substantial damageNTSB DEN88FA090Accident · 4 fatalField investigationFinal reportBeech A36 · Colorado Spring, COAfter takeoff the acft failed to climb sufficiently to clear a utility pole one-half mile off the end of the runway. The acft collided with the pole and crashed in a residential street. The plt and three pax were fatally injured and the acft was consumed by…Apr 3, 1988 · N5WW · DestroyedNTSB NYC88LA119Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Poland, NYAfter several takeoffs in a southwesterly direction from a farm field, the student pilot attempted a takeoff downwind in an easterly direction and failed to clear the trees at the end of the field. The airplane crashed into the trees and terrain, and was…Apr 2, 1988 · N8316K · DestroyedNTSB NYC88LA118Accident · No injuriesLimited investigationFinal reportCessna 150 · Downingtown, PADuring takeoff from shannon airport, the flight experienced an engine power loss and crashed. Pilot stated that water was found in the carburetor. The plt said after the acc that after the power loss he noticed powerlines and houses in front and made a sharp…Apr 2, 1988 · N60057 · Substantial damageNTSB LAX88LA152Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lone Pine, CAAt the beginning of the flight, just after rotation, at approximately 10 feet AGL, the pilot retracted one notch of flaps. The aircraft settled to the runway and the pilot lost control and collided with the terrain. There were no mechanical failures or…Apr 2, 1988 · N6466P · Substantial damageNTSB LAX88FA149Accident · Serious injuriesField investigationFinal reportCessna 152 · Chandler, AZApr 2, 1988 · N6227H · Substantial damageNTSB NYC88LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Manchester, NHA flight to burlington, Vermont was uneventful. While on the ground at burlington the aircraft was serviced; then the flight was continued. After about one hour of flight, high engine temperature and low oil pressure was experienced and the aircraft landed at…Apr 1, 1988 · CFQQW · DestroyedNTSB FTW88FA085Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Henrietta, TXThe plt was given a pre-flt wx briefing by a fss briefer. He rcvd a full & thorough briefing, except the briefer did not have an opnl wx radar set available. The plt was adzd of a line of thunderstorms (tstms) to the southwest, moving east at 20 KTS. He was…Apr 1, 1988 · N8553P · DestroyedNTSB LAX88FA144Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Torrance, CAJust after takeoff, the plt noticed that the airspeed indicator was inoperative. The plt notified the tower that he was returning for landing and stated the problem. During the turn from base to final approach, the pilot overshot both the right and left rwys.…Mar 31, 1988 · N6574J · DestroyedNTSB NYC88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Erie, PAThe pilot failed to maintain flying speed and the airplane settled back onto the runway and ran off the end.Mar 29, 1988 · N36440 · Substantial damageNTSB LAX88LA142Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Valley Center, CAWitnesses observed the acft rotate to a high pitch attitude during the initial climb after takeoff. They said the acft then entered a left turn & descended to the ground. Impact occurred on rising terrain, beyond a gully, about 200 ft east of the departure…Mar 28, 1988 · N4376F · DestroyedNTSB ATL88FA125Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · Summerville, SCMar 27, 1988 · N410JQ · DestroyedNTSB LAX88FA134Accident · 3 fatalField investigationFinal reportBeech D95A · Santa Maria, CAFailure of the pilot to adequately compensate for the loss of power in the left engine and to maintain control of the aircraft.Mar 26, 1988 · N8855M · DestroyedNTSB MKC88LA071Accident · No injuriesLimited investigationFinal reportRockwell S2-R · Stuttgart, ARDuring a post maintenance test flt, PIC experienced a power loss shortly after lift off. The acft crashed nose low, in a left turn. The engine was thrown clear of the airframe. Post accident inspection of the propeller blades indicated a minimum amount of…Mar 25, 1988 · N5563X · Substantial damageNTSB SEA88LA066Accident · No injuriesLimited investigationFinal reportCessna 150 · Fox, ORWhile departing an airstrip situated on top of a hill the aircraft was not able to clear power lines at the end of the airstrip. The pilot lowered the nose of the aircraft to clear the wires and the aircraft's elevator struck a road sign in flight. The…Mar 20, 1988 · N66727 · Substantial damageNTSB DEN88FA084Accident · 1 fatalField investigationFinal reportPiper PA-22 · Angel Fire, NMAfter takeoff, the acft could not outclimb rapidly rising terrain off the end of the rwy and collided with trees/terrain. Exam of wreckage disclosed fouled plugs from rich mixture and low cyl compression. Exam of airport info did not describe topography…Mar 19, 1988 · N3254Z · DestroyedNTSB CHI88DEX03Accident · Minor injuriesFinal reportPiper PA-28-140 · Evansville, INPilot attempted maximum gross weight take-off from soft soggy field with 10 degree flaps selected. Stall warning activated on lift-off, aircraft climbed to approximately 50 feet then began losing altitude and airspeed, made uncontrolled landing in muddy field…Mar 16, 1988 · N15567 · Substantial damageNTSB MKC88LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Cherokee, IAThe plt stated, that shortly after takeoff, the engine lost substantial pwr. Afterwards there was smoke in the cockpit. The PIC reversed his course with the intent to land on the departure arpt. When he felt he had the ldg field made, he attempted to lower…Mar 15, 1988 · N8136R · Substantial damageNTSB FTW88LA080Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Tomball, TXAs the helicopter lifted off the portable landing platform, it rolled to the right and contacted the terrain. The pilot could not determine if the skid was caught on the platform or if it slid off the side.Mar 15, 1988 · N58332 · Substantial damageNTSB DEN88LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMThe private plt and two pax attempted takeoff at or near max gwt at a density alt of 6,500 ft MSL. Full fuel had been loaded in the right tank and the plt indicated that the left tank was empty. Rwy 24 was in use with a 70 degree x-wind reported from 310…Mar 13, 1988 · N32982 · Substantial damageNTSB CHI88FA075Accident · 3 fatalField investigationFinal reportBeech E18S · Warren, MIThe flt was an air taxi cargo flt carrying truck parts. After takeoff, the twr asked the plt if he was in difficulty and the plt replied 'roger' and requested a change of flt plan. The acft was seen flying erratically just above the tree tops. The acft…Mar 10, 1988 · N900WP · DestroyedNTSB LAX88DUG02Accident · Minor injuriesFinal reportPage Long EZ · Chino, CADuring a flight to test the effectiveness of the propeller, just after takeoff, one propeller blade separated from the hub. The pilot made an emergency off field landing in a soft field, where during the landing roll the aircraft collided with the terrain.…Mar 8, 1988 · N917WP · Substantial damageNTSB LAX88LA121Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Shandon, CADuring the initial climb, at approximately 20 feet AGL, a gust of wind forced the aircraft off course, resulting in a collision with a shed near the private dirt strip. The pilot reported that there were no mechanical failures or malfunctions with the…Mar 7, 1988 · N91286 · Substantial damageNTSB ATL88LA105Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Lincolnton, NCJust after lift off for a LCL flt, the plt-in-cmd, who was in the right seat, noted the front edge of the nose baggage compt to 'pop open'. He assumed control of the acft and attempted to 'tear drop' a return to the opposite runway. During the maneuver, the…Mar 5, 1988 · N4329C · Substantial damageNTSB ATL88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cleveland, OHThe plt rptd that both engines began to surge shortly after t/o during climb. The engines subsequently lost pwr completely, and the plt made a forced ldg in trees. Post-crash exam revealed that the fuel selectors were in the inbd tank positions. The lt inbd…Mar 5, 1988 · N198CD · DestroyedNTSB NYC88LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Southbridge, MADuring takeoff from Southbridge airport, the aircraft encountered a crosswind. The aircraft started drifting to the right even though full left aileron and full power were being applied. The pilot cut the power to abort the takeoff, and the aircraft impacted…Mar 1, 1988 · N75762 · Substantial damageNTSB MKC88FA058Accident · 4 fatalField investigationFinal reportCessna 172N · Oxford, IAWitnesses stated that the aircraft appeared to be in trouble immediatley after takeoff, as the wings were rapidly rocking while it was struggling to stay airborne. The aircraft turned sharply left, where it then barely cleared a row of trees. The airplane…Feb 28, 1988 · N5816E · DestroyedNTSB MIA88FA114Accident · 2 fatalField investigationFinal reportCessna 172N · Kissimmee, FLThe acft was observed at about 2000 ft sw bound & the sound of the eng could be heard. The acft was next observed about a minute later inbound at about 50 ft & eng sound could be heard. The witness heard a 'poof' sound & the acft was observed inverted. The…Feb 24, 1988 · N5211E · DestroyedNTSB CHI88FA067Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Martinsville, INPilot to take into caonsideration the wind direction and velocity before selecting his takeoff direction.Feb 23, 1988 · N9958U · DestroyedNTSB ANC88LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kipnuk, AKThe pilot stated that during the initial climbout from the airport he encountered a complete whiteout condition. The pilot then elected to land on the frozen lake and during the rollout the aircraft struck a snowbank.Feb 23, 1988 · N8429N · Substantial damage