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 MIA88FA214Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Clearwater, FLThe private pilot experienced a rough running engine on takeoff roll and continued the takeoff. After liftoff the engine failed and he crashed into a residence. The engine fuel control and fuel divider block were found to have water, rust and sand in them.…Jul 5, 1988 · N399AC · DestroyedNTSB DEN88LA145Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58J · Sioux Falls, SDN62243 was being used to lift air conditioning units to the top of a shopping mall. The plt stated that he was on the 16th lift of the day and had just taken off when he heard two loud pops and the engine lost power. After jettisoning the load he executed an…Jul 5, 1988 · N62243 · Substantial damageNTSB SEA88FA122Accident · 5 fatalField investigationFinal reportCessna TU-206-G · Root Ranch, IDShortly after takeoff, prior to reaching 500 feet AGL, the pilot lost control of the aircraft and struck trees. After striking trees the aircraft then impacted the ground and exploded into flames. Witnesses stated that from the time of rotation to the time…Jul 3, 1988 · N732HH · DestroyedNTSB NYC88LA194Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Bally, PAThe plt was taking off with a left tailwind/crosswind. At liftoff, the left wing dropped and the pilot attempted to correct with rudder. The acft collided with the terrain.Jul 3, 1988 · N11061 · Substantial damageNTSB BFO88FA063Accident · No injuriesField investigationFinal reportPiper PA-23 · Friendly, MDShortly after takeoff at an altitude of 200 ft AGL, a power loss was experienced on the left engine. According to the plt, when the throttle was retarded to verify the engine failure, the engine seemed to 'come back to life'. The throttle was advanced and…Jul 2, 1988 · N1021P · Substantial damageNTSB DEN88DTE06Accident · No injuriesFinal reportHelfrich-Leonard BD-5B · Englewood, COThis experimental acft is powered by a modified honda 1250 cc, watercooled eng. The plt reported that after takeoff the eng temp reached the redline and the eng lost power. During the forced landing the main landing gear collapsed. Examination of the eng…Jul 1, 1988 · N250TH · Substantial damageNTSB NYC88DHD02Accident · Minor injuriesFinal reportDarlington Monnett Moni · Vincentown, NJThe plt was on his 1st flt in the home built acft. During the initial climb after takeoff, he diverted his attention from the airspeed indicator to other instruments. He believed that he may have inadvertently pulled up the nose at that time. Subsequently,…Jun 29, 1988 · N2276R · Substantial damageNTSB LAX88LA239Accident · Minor injuriesLimited investigationFinal reportCessna 206F · Healdsburg, CAJust after takeoff the engine lost power. A forced landing was made in a field where the airplane collided with rough terrain. Inspection of the engine revealed evidence of corrosion in the main fuel sump bowl and on the fuel injection throttle body fuel…Jun 29, 1988 · N33284 · Substantial damageNTSB FTW88DPJ07Accident · Minor injuriesFinal reportNorthrop C-125A · Tulsa, OKThe pilot did not hold a type rating or written authorization to act as pilot in command. The co-pilot did not hold a type rating or written authorization to act as second in command and his medical had expired. The aircraft did not have an airworthiness…Jun 29, 1988 · N3756Q · Substantial damageNTSB BFO88DIA01Accident · Serious injuriesFinal reportTerry Osprey II · Manassas, VAThe pilot reported that on initial climb at an alt of 300 ft AGL, engine power began to decay. A right turn was initiated to return to the runway but a further loss of power was experienced and a forced landing was attempted in a field. The acft contacted…Jun 29, 1988 · N70J · DestroyedNTSB CHI88FA144Accident · 1 fatalField investigationFinal reportCessna 150G · Ft Wayne, INInadvertent stall/spin due to the failure to maintain adequate airspeed, and failure to avoid the adverse wind conditions associated with a thunderstorm.Jun 28, 1988 · N4744X · DestroyedNTSB ATL88LA202Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Whitsett, NCThe plt reported that the engine lost power during initial climb at 150 ft AGL. He attempted to make a 180 deg turn back to the arpt; the airplane crashed at about the 180 deg point. Post-crash exam of the engine revealed no evidence of mechanical failure or…Jun 28, 1988 · N2875Y · Substantial damageNTSB MIA88LA208Accident · No injuriesLimited investigationFinal reportCessna 150M · Davisville, FLAcft's engine had over 200 RPM drop on one magneto during runup. Plt attempted to takeoff with the engine running rough. After liftoff the engine began to backfire and lose power. The plt stated he then applied carburetor heat and pumped the engine primer.…Jun 27, 1988 · N704MN · Substantial damageNTSB LAX88LA236Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Lake Tahoe, CADuring the initial climb the pilot was unable to sustain a positive climb rate. The acft collided with a tree at the end of the runway and, subsequently, the ground. There were no reported mechanical failures or malfunctions. The density altitude was about…Jun 27, 1988 · N23TW · Substantial damageNTSB LAX88LA232Accident · No injuriesLimited investigationFinal reportBeech B35 · Weaverville, CAJun 24, 1988 · N5354E · Substantial damageNTSB FTW88LA124Accident · No injuriesLimited investigationFinal reportMooney M20J · Portland, TXThe pilot dragged the lower empennage on the runway during the takeoff rotation. A premature liftoff resulted and the aircraft recontacted the runway twice before the aircraft passed the runway end. Thereafter, the aircraft collided with a powerline before…Jun 24, 1988 · N201ZP · Substantial damageNTSB BFO88LA058Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A · Moundsville, WVThe helicopter contacted power lines shortly after takeoff from a mine site. The nose gear of the helicopter contacted an uninsulated static wire. This wire was strung with one other static wire and two black insulated power lines. Both crew members stated…Jun 23, 1988 · N54C · DestroyedNTSB CHI88LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Noblesville, INDuring initial climbout the pilot stated that he experienced a partial loss of power and was unable to maintain sufficient rate of climb to continue flight. The pilot executed a forced landing in a field, striking trees. Post-accident investigation failed to…Jun 22, 1988 · N36472 · Substantial damageNTSB ATL88LA197Accident · Serious injuriesLimited investigationFinal reportAeronca 0-58B · Newberry, SCThe pilot related that he had been flying around the local area making landings at various airports for about 1 1/2 hours. He returned to the departure airport and made a full stop landing. His 12 year old son requested that he make another takeoff and…Jun 21, 1988 · N47190 · DestroyedNTSB NYC88DFA02Accident · 1 fatalFinal reportTerry Tierra II · Plattsburgh, NYAccording to witnesses, the plt was on his 2nd flt of the day in a recently purchased ultralight type of acft. They rprtd that after the acft took off from rwy 32, it climbed to about 300' AGL & rolled into a steep right bank. Its nose then dropped & the acft…Jun 20, 1988 · N4462T · Substantial damageNTSB MIA88FA201Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Catano, PRAs the acft was taxiing for takeoff, witnesses noted the l rear baggage door was unlocked & hanging down. A warning was relayed to the plt via the twr, but by then the acft was airborne & the plt had rprtd a control prblm. Drg lift-off, theacft pitched up…Jun 20, 1988 · N90360 · DestroyedNTSB LAX88DVG05Accident · No injuriesFinal reportSchweizer G-164B · Gridley, CAJun 20, 1988 · N8487K · DestroyedNTSB CHI88DER10Accident · No injuriesFinal reportAnderson-Tucker Evans VP-1 · Duquette, MNOn the initial flight of this amateur built aircraft the pilot lowered the nose after liftoff to allow the aircraft to accelerate. However, the aircraft settled and the pilot was unable to keep the aircraft from colliding with trees.Jun 20, 1988 · N17BL · Substantial damageNTSB LAX88DVA08Accident · Serious injuriesFinal reportSmith Model B Avid Flyer · Atwater, CADuring a local test flight, just after takeoff, the engine suddenly lost power and went to idle. The pilot made an off airport landing without incident. The pilot inspected the engine finding nothing unusual. The pilot attempted another takeoff to return to…Jun 18, 1988 · N249SJ · DestroyedNTSB MKC88LA111Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Scranton, ARShortly after takeoff from a 2400 foot sod strip, the PIC said the acft began to settle, although both engines were delivering takeoff power and RPM, and liftoff speeds were proper. The acft settled back to the runway and careened off on to the overrun…Jun 16, 1988 · N165SE · Substantial damageNTSB MIA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lake Wales, FLDuring takeoff from the grass strip, the left main landing gear and wingtip collided with runway lights & a fencepost. The acft was slow to climb. After clearing trees at the departure end of the rwy, the acft descended below treetop level, then continued to…Jun 16, 1988 · N4379A · Substantial damageNTSB MIA88FA192Accident · Serious injuriesField investigationFinal reportBell 47G3B-1 · Benoit, MSThe plt said the engine misfired three times during takeoff and lost partial power. The helicopter settled into a rice field and the damaged spray booms became entangled. The helicopter nosed over in the high vegetation. The plt stated the engine accelerated…Jun 15, 1988 · N73947 · Substantial damageNTSB LAX88LA224Accident · No injuriesLimited investigationFinal reportCessna 180K · Show Low, AZThe plt attempted to takeoff in his conventional gear acft using rwy 21. The local wind was estimated at 180 degrees, 15 knots with gusts to 35 knots. The plt stated that immediately after rotating for takeoff 'a gust of wind caught us & threw us…Jun 15, 1988 · N2509K · Substantial damageNTSB MKC88LA110Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Dighton, KSDuring an aerial application operation, the plt said that as he initiated liftoff, the acft turned to the left and he felt he had no rudder control. He hit a fence on the apt boundary, continued, dumped his chemical load, hit a tree, and landed in a field…Jun 14, 1988 · N731CD · Substantial damageNTSB MIA88LA190Accident · No injuriesLimited investigationFinal reportCessna 150J · Carthage, MSWhile on a personal flt, during the upwind leg after completion of the second touch-and-go landing, the plt reported that the eng sputtered. He then turned crosswind & attempted to land on a section of road under construction. Shortly before touchdown a…Jun 13, 1988 · N50945 · Substantial damageNTSB FTW88LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Mounds, OKThe instructor was demonstrating an engine out emergency to the student. The engine balked on the attempted go-around and he completed the landing. Thereafter, his first two takeoff attempts were aborted because of insufficient distance to complete the…Jun 13, 1988 · N94370 · Substantial damageNTSB LAX88DVD05Accident · No injuriesFinal reportKerlin Avid Flyer · Tracy, CADuring a local high speed taxi test, the airplane became airborne. Shortly after takeoff the engine quit. The airplane was landed straight ahead in an open field. During the landing roll, the airplane nosed over. The pilot did not report any mechanical…Jun 12, 1988 · N4642S · Substantial damageNTSB ANC88FA067Accident · 1 fatalField investigationFinal reportDe Havilland DHC-2 · Chugiak, AKThe pilot-in-command, a certified mechanic, performed his own maintenance on the acft. This maintenance required the removal, reinstallation & rigging of the ailerons. As the plt was taking off on the 1st flt after maintenance, the acft entered a roll after…Jun 10, 1988 · N48108 · Substantial damageNTSB FTW88FA115Accident · 2 fatalField investigationFinal reportCessna 340 · Georgetown, TXThe pilot in the right seat had hired the pilot in the left seat to ferry the airplane to germany, then to turkey. A four tank ferry fuel system was installed but a weight and balance check was not made. During the tkof, the acft would not climb. Afterward…Jun 7, 1988 · N7828Q · DestroyedNTSB FTW88DRD07Accident · Minor injuriesFinal reportPezetel M-18 · Mer Rouge, LAThe ag airplane departed the strip with 3000 lbs of fertilizer. 200 yds later it settled in a rice field and flipped forward to the inverted. No mechanical problems were found. Elevation at takeoff was 150 ft MSL. Density altitude was 2272 ft. max allowable…Jun 7, 1988 · N4685R · Substantial damageNTSB MKC88LA108Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Wynne, ARFollowing the takeoff from a private strip near Wynne, Arkansas, the pilot reported that he failed to establish and maintain an adequate angle of climb with the heavily loaded condition of the aircraft. The aircraft impacted trees in the flight path, then…Jun 6, 1988 · N9695 · Substantial damageNTSB FTW88DPJ05Accident · 1 fatalFinal reportStinson 108-3 · Collinsville, OKThe pilot experienced a loss of engine power during the takeoff leg. Post accident investigation revealed that the fuel selector was in the near closed position. This position only allowed a small percentage of the fuel to flow but would allow operation in…Jun 6, 1988 · N4108C · DestroyedNTSB NYC88LA161Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Franconia, NHDuring takeoff, turbulence was encountered and the student pilot had a hard time controlling the glider. As the instructor took control, the student released the tow rope. The instructor pushed the nose down and turned in an attempt to level the wings, but…Jun 5, 1988 · N49443 · Substantial damageNTSB MKC88DCD01Accident · No injuriesFinal reportBohnker Tierra II · Audubon, IAThe pilot stated that the takeoff run and liftoff appeared normal, but after liftoff the aircraft veered to the right (into the crosswind). The pilot attempted to correct with left rudder and aileron. When he was unsuccessful, he retarded throttle. The plane…Jun 5, 1988 · N116LB · Substantial damageNTSB DEN88LA123Accident · Serious injuriesLimited investigationFinal reportHelio H-295 · Encampment, WYThe plt stated he calculated the density altitude to have been 11,300 ft at takeoff. He said the acft was near max gross wt and that the grass strip he departed from was approx 1,500 ft long. The plt stated 'I was on the on the back side of the pwr curve as…Jun 5, 1988 · N6454V · DestroyedNTSB DEN88LA122Accident · No injuriesLimited investigationFinal reportBeech C23 · Gallup, NMThe private plt was taking off with three passengers for a personal transportation flight. The airplane left the runway and only gained about 50 feet AGL according to a witness. The plt reported that the aircraft reached 200 feet AGL. The airplane stalled and…Jun 5, 1988 · N9311S · Substantial damageNTSB CHI88LA127Accident · Minor injuriesLimited investigationFinal reportTaylorcraft L-2 · Three Rivers, MIThe owner of the acft stated that he released the acft to the PIC so that he could 'checkout' another plt and help her with her tailwheel landings. During their fourth tkof, the plt being checked out attempted to climb out of ground effect with insufficient…Jun 5, 1988 · N57502 · Substantial damageNTSB CHI88LA126Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Aledo, ILDuring takeoff roll the pilot reported he experienced a loss of directional control and elected to lift the aircraft off the ground prematurely in an effort to avoid running into a cornfield. Unable to establish the proper rate of climb, and unable to clear…Jun 4, 1988 · N95061 · DestroyedNTSB MIA88FA187Accident · Serious injuriesField investigationFinal reportCessna 172N · Jacksonville, FLThe private pilot had been hired to ferry a recently purchased aircraft. He stated that the aircraft had not been flown for about 2 weeks. He had it refueled and checked the fuel tanks for water. After takeoff the engine failed at about 200 ft. he crashed…Jun 3, 1988 · N5245E · Substantial damageNTSB DEN88FA120Accident · 1 fatalField investigationFinal reportLuscombe 8E · Grantsville, UTThe acft was 1 of 3 that were lndd on a gravel road near a truck stop where the occupants had breakfast. Drg departure, the 1st 2 acft took off without incident. Witnesses rprtd that when the 3rd acft (N71646) took off, the plt began a left turn at about 75'…Jun 3, 1988 · N71646 · DestroyedNTSB CHI88LA133Accident · No injuriesLimited investigationFinal reportAlon A2 · Flushing, MIDuring initial takeoff climb the acft experienced a loss of engine power at approximately 30' to 40' above the ground. The pilot elected to execute a forced landing on the grassy infield of the airport because insufficient runway remained. The acft struck the…Jun 2, 1988 · N6589Q · Substantial damageNTSB MIA88FA184Accident · 2 fatalField investigationFinal reportPiper J3C · N Fort Myers, FLThe plt tkof on rwy 27 with the wind fm 060 deg at 12 gusting 23 KTS. Density alt was 2100'. Witnesses said the acft was in a slow speed, nose hi climb, when eng pwr was interrupted momentarily. Pwr was restored, but soon thereafter, the acft rolled rgt,…Jun 1, 1988 · N98178 · DestroyedNTSB FTW88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hinton, OKThe pilot departed bethany, Oklahoma on a local pleasure flight with the fuel tanks slightly less than 1/2 full. After about a 1.5 hour flight, he landed at the red rock airport in Hinton, Oklahoma. No service was performed on the aircraft while in Hinton and…Jun 1, 1988 · N25352 · Substantial damageNTSB NYC88LA148Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Dover, PALoss of engine power for an unknown reason. Contributing factors were: failure of the pilot to maintain runway alignment obstructions near the end of the runway (sign, stone fence & tree).May 30, 1988 · N9981L · Substantial damageNTSB MKC88LA102Accident · No injuriesLimited investigationFinal reportPitts S-2 · Siloam Springs, ARThe pilot said that after takeoff and reaching a safe altitude, he made an immediate hard left turn resulting in a loss of control. Pilot did not recover from the resultant stall.May 30, 1988 · N246PC · Substantial damage