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 MIA83FA140Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A-2 · Pembroke Pines, FLWitnesses reported that during takeoff, the eng began sputtering when the acft was climbing thru about 50 ft AGL, then the eng noise stopped completely as the acft reached about 150 ft AGL. A puff of smoke was observed coming from the eng as the acft veered…May 12, 1983 · N3667L · DestroyedNTSB FTW83FA226Accident · 4 fatalField investigationFinal reportCessna 182R · New Braunfels, TXAt 2006 CDT, before departing san antonio, TX, the plt obtained a wx breifing. At that time, he was advised to expect VFR conditions on his flt to san marcos, TX, but IFR conditions were expected when he planned to return at about midnight. The plt flew to…May 10, 1983 · N5134E · DestroyedNTSB LAX83LA219Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Marysville, CADuring the previous 7 mos, the acft had been flown only about 2.5 hrs & had been parked outdoors when not in use. Anticipating the flt, the student plt & her husband had started the engine to make sure the battery was operational. The instructor plt reported…May 9, 1983 · N21579 · Substantial damageNTSB DEN83LA110Accident · No injuriesLimited investigationFinal reportCessna 172F · Escalante, UTThe acft collided with the terrain and nosed over off the departure end of the runway during takeoff. The runway in use was 12 and the wind was from 180 degrees at 5 KTS gusting to 15 KTS. The runway is 5000 feet long and 60 feet wide. The field elevation is…May 8, 1983 · N5501R · Substantial damageNTSB MIA83LA138Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Brooksville, FLThe acft rolled over and crashed during an attempted downwind running takeoff. The acft was destroyed by impact forces and fire. The pilot and 2 passengers were not injured. A witness on the ground and one of the passengers who is an A&P mechanic stated that…May 7, 1983 · N9086 · DestroyedNTSB MIA83LA139Accident · No injuriesLimited investigationFinal reportCessna 421C · Gainesville, FLDuring takeoff, the aircrew heard an unusual 'thud' sound as the gear was retracting, but all gear indications were normal. Prior to landing at the destination, 3 green lights were observed when the landing gear switch was moved to extend the gear. A normal…May 6, 1983 · N3237U · Substantial damageNTSB FTW83LA225Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Socorro, NMShortly after liftoff, at about 10 ft AGL & 95 mph in level flt, the plt found the controls 'ineffective.' The acft impacted at full power in a crab & bounced back into the air. The acft still would not climb & the plt lowered the nose to gain airspeed. The…May 6, 1983 · N4796 · Substantial damageNTSB CHI83LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Mount Vernon, ILAfter takeoff, the acft was climbing thru about 500 ft AGL when there was a considerable power loss. Subsequently, the acft struck trees while the plt was attempting to return to the rwy. An exam of the eng was made, but the reason for the power loss was not…May 6, 1983 · N8210V · Substantial damageNTSB SEA83FYM05Accident · 1 fatalFinal reportBrantly Helicopter B-2 · Milton Freewtr., ORThe helicopter was observed to climb to about 50-75 ft AGL & then something flew off the acft. One m/r blade was found intact 240 ft from the wreckage. The outer blade was heavily damaged at the tip area. The inboard blade section had the pylon tube attached…May 4, 1983 · N5912X · Substantial damageNTSB CHI83LA197Accident · Serious injuriesLimited investigationFinal reportHolmes XTC2 · River Falls, MNThe acft pulled up steeply after takeoff and stalled. The acft crashed back on the rwy. The pilot said he reduced power after takeoff and the acft stalled. He also said if he had not reduced power the accident would not have happened.May 4, 1983 · N3885D · Substantial damageNTSB LAX83FA208Accident · 1 fatalField investigationFinal reportSchempp-Hirth Nimbus II · California City, CAWitnesses reported that during takeoff, the glider was being towed when it released at aprx 300 ft AGL & entered a left turn. The turn continued, the bank angle increased & the glider subsequently hit the ground aprx 1 mile southwest of the arpt. Impact…May 1, 1983 · N21RB · DestroyedNTSB MKC83LA101Accident · No injuriesLimited investigationFinal reportCessna C-140 · Mt. Pleasant, IAThe pilot stated he did not make a visual check of his fuel supply prior to flight. After a 45 minute solo flight he landed at a private strip and picked up a passenger. The right fuel tank was selected and the guage was indicating in the lower red 1/4 red,…Apr 30, 1983 · N77090 · Substantial damageNTSB LAX83FA205Accident · Serious injuriesField investigationFinal reportBeech A36 · Hawthorne, CAAs the acft was climbing thru about 400 to 500 ft AGL, after takeoff, the eng began losing power. The plt turned on the fuel boost pump & started a turn back toward the arpt. When he realized that he could not reach the rwy, he elected to land on a street.…Apr 30, 1983 · N7036G · Substantial damageNTSB SEA83FA093Accident · 2 fatalField investigationFinal reportBeech 77 · Renton, WAThe acft was taking off for a 1 hour engine run-in following a top overhaul. After liftoff the engine began a gradual power loss and rough running. The pilot was trying turning back to the runway to land when total power loss occurred. The acft had turned 45…Apr 29, 1983 · N67140 · DestroyedNTSB LAX83LA206Accident · Minor injuriesLimited investigationFinal reportCessna 150C · Madera, CAThe plt was flying in & out of several crop duster strips. During takeoff from the 4th strip the engine quit. The acft nosed over in a plowed field. The plt attributed the engine failure to water in fuel.Apr 29, 1983 · N2062Z · Substantial damageNTSB NYC83LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Thomasville, PAThe acft nosed over during a forced landing after a power loss. Several weeks prior to this accident the acft made a precautionary landing due to a rough running engine. The acft was examined and 1 gallon of water was found in the fuel lines. The water was…Apr 28, 1983 · N21243 · Substantial damageNTSB NYC83FU003Accident · Serious injuriesFinal reportUltralight Flight Phantom · Jaffrey, NHSeveral days prior to the accident, the plt was advised by others that the eng on his newly assembled Ultralight did not'sound right.' After checking he noted that full power could not be obtained from the eng. However, enough power was available to fly a…Apr 28, 1983 · UNREG · Substantial damageNTSB MIA83FA133Accident · Serious injuriesField investigationFinal reportBeech D18S · Dania, FLThe acft crashed in a wooded area during a forced landing following a power loss on both of its engines. The acft had been flown to bimini from opa-locka, FL. About 75 gallons of fuel was drained from the acft. Upon the return to ft lauderdale, FL, the…Apr 28, 1983 · N213S · DestroyedNTSB MKC83FA094Accident · Minor injuriesField investigationFinal reportCessna CE-500 · Witchita, KSThe acft collided with the ground during takeoff. The fuel tank in the right wing ruptured and the acft burned while sliding to a stop. The day before the accident the acft was washed and the thrust reverser doors were polished. After the service, the…Apr 26, 1983 · N22FM · Substantial damageNTSB CHI83LA189Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Greencastle, INThe acft experienced power loss at about 300 feet AGL after takeoff. The pilot landed in a cornfield after attempting a restart of the engine. The pilot had put 5 gallons of fuel in the right tank on the day of the accident in preparation for a test flight.…Apr 25, 1983 · N9703K · DestroyedNTSB LAX83LA204Accident · No injuriesLimited investigationFinal reportVarga 2150A · Chandler, AZAccording to the plt, after gaining about 50-75 ft of altitude a strong vertical gust was encountered which increased the acft's pitch attitude to a critical angle whereupon the acft stalled. Recovery was incomplete & the acft impacted the taxiway north of…Apr 24, 1983 · N8269J · Substantial damageNTSB CHI83FA180Accident · 2 fatalField investigationFinal reportCessna 185F · Pillager, MNThe acft collided with the ground after dragging the right wing in the water 3 times. The acft disappeared from view of witnesses around a point of land in the lake. The acft was heard producing power up to a 'few second' before a 'thud' was heard followed by…Apr 24, 1983 · N29968 · DestroyedNTSB NYC83LA100Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Ashley Falls, MAThe pilot stated that he was about a half mile from the airport when the engine quit. He restarted it but it quit a 2nd time and would not restart. By this time the acft was down to about 200 ft. a right turn was made to land on an island. The acft landed…Apr 23, 1983 · N86948 · Substantial damageNTSB NYC83FGM02Accident · Serious injuriesFinal reportBeech A-23 · West Mifflin, PAThe acft lost power during takeoff and a forced landing was made from 400 ft AGL to a slag dump about 1 mile south of the airport. The right wing was substantially damaged by the initial impact as the acft was turning right at touchdown. The nose gear…Apr 22, 1983 · N1411L · Substantial damageNTSB FTW83LA202Accident · No injuriesLimited investigationFinal reportCessna 150M · Altus, OKThe acft collided with a barbed wire fence and a ditch during an aborted takeoff. The acft was pulled off the ground prematurely and when it failed to accelerate the CFI aborted the takeoff. During the rollout the acft went through a fence and into a ditch.…Apr 22, 1983 · N63385 · Substantial damageNTSB CHI83LA175Accident · No injuriesLimited investigationFinal reportHughes 300C · Hollandale, MNThe pilot said 'that upon takeoff from truck, pulled too much power so he lost too much RPM, hit somewhat solid ground, slid 10 feet and stuck in the mud, the helicopter stopped immediately and flew apart.'Apr 21, 1983 · N7418F · DestroyedNTSB CHI83LA174Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Middleton, WIAccording to the instructor pilot the student did not release enough back pressure or use enough right rudder after the acft became airborne. The acft drifted left and was going to stall. The instructor took over and landed the acft. The left main gear came…Apr 21, 1983 · N2444N · Substantial damageNTSB ANC83LA073Accident · No injuriesLimited investigationFinal reportCessna C-185F · Nome, AKThe aircraft stalled at low altitude and crashed during takeoff. The pilot stated that 'during the takeoff roll the leftski stuck in the snow and turned the aircraft 45 degrees to the left. Instead of stopping, I continued on'. The pilot said that the ski had…Apr 21, 1983 · N4757E · Substantial damageNTSB ATL83LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Clinton, MDWitnesses observed that the acft took off from rwy 31, began a left turn, then descend into the trees. One witness, a lineboy, stated that he heard the engine running until the acft contacted the trees. The plt received a head injury and was unable to recall…Apr 20, 1983 · N7617T · Substantial damageNTSB DEN83LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Martinsdale, MTReportedly, the instructor plt was on a personal/business flt with a student plt as a passenger. A landing was made on a road that had been used by crop duster plts. The plt had been informed about the presence of power lines. He saw some power lines & had…Apr 19, 1983 · N6322D · DestroyedNTSB ANC83IA072Incident · No injuriesIncident investigationFinal reportPiper PA-28R-201 · Mcgrath, AKAfter 3 attempts to takeoff from a muddy airstrip and failing, the pilot off-loaded one passenger and some baggage. On the fourth takeoff attempt the aircraft got airborne but settled back to a snow covered frozen river. The snow slowed the aircraft and the…Apr 19, 1983 · N38565 · Minor damageNTSB MIA83LA126Accident · No injuriesLimited investigationFinal reportBeech H35 · Cedar Key, FLThe plt stated that he switched fuel tanks just before the takeoff roll, & shortly after takeoff, the eng lost power. He retracted the gear before making a forced landing in water, beyond the end of the rwy. An exam of the eng revealed no evidence to suggest…Apr 17, 1983 · N8225D · Substantial damageNTSB ANC83FA070Accident · No injuriesField investigationFinal reportPiper PA-18 · Chugiak, AKThe acft collided with a tree during a forced landing and nosed over. The pilot reported that he made the takeoff with the fuel selector in the left tank position. Visual inspection of the left tank revealed no fuel in the tank except for residual fuel. Test…Apr 17, 1983 · N1827A · Substantial damageNTSB SEA83LA153Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B2 · Rogue River, ORThe helicopter rolled over during lift off with pilot and one passenger and a full load of fuel. On a previous flt with one passenger and 8 gallons of fuel the pilot had noticed the left skid was about 8 inches lower than the right during lift off. On the day…Apr 16, 1983 · N5955X · Substantial damageNTSB MIA83LA124Accident · No injuriesLimited investigationFinal reportBeech 76 · Pensacola, FLThe acft was landed with the gear retracted after a door opened during takeoff. The pilot stated that at about 100 feet AGL after the gear had been retracted the pilots door came open. According to the pilot the acft became erratic with thedoor banging…Apr 16, 1983 · N3711N · Substantial damageNTSB NYC83FFJ01Accident · No injuriesFinal reportCessna A188B · Williamson, NYThe acft collided with a tree during a forced landing after a power loss on takeoff. The pilot had a load of 125 gallonsof a fungicide for spraying trees when the engine quit at about 100 ft AGL. The load was dumped and the acft was turned to the right for a…Apr 15, 1983 · N731VY · Substantial damageNTSB MKC83FA090Accident · 1 fatalField investigationFinal reportBreezy 01 · Kechi, KSThe home built acft had been in storage with the wings removed. The wings had been recently re-installed by the owner and this was the first flight after the re-installation. During a takeoff from an open field, witnesses observed the aircraft lift-off, climb…Apr 15, 1983 · N1019W · DestroyedNTSB LAX83LA466Accident · No injuriesLimited investigationFinal reportCessna 188B · Modesto, CAThe acft collided with a fence during takeoff and pulled the tailwheel out of the empennage. The plt said the dump valvefailed to work or 'struck' so he could not jettison the load. He felt the need to 'dump' when the acft hit a 'softspot' in the gravel and…Apr 15, 1983 · N9961J · Substantial damageNTSB NYC83LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Norfolk, MAThe acft crash landed shortly after takeoff and was destroyed. The student pilot stated that after clearing the runway on his last takeoff of the day the engine hesitated and stopped. He lowered the nose to a glide speed of 70 mph picked aspot to land and…Apr 14, 1983 · N19435 · Substantial damageNTSB MIA83FA121Accident · Minor injuriesField investigationFinal reportBeech G18S · Hollywood, FLThe plt stated that start, taxi & takeoff were normal until after he raised the gear handle & the acft was climbing thru aprx 150 to 200 ft AGL. At that time, he noticed that the left eng RPM was decaying. There was insufficient rwy remaining to abort, so he…Apr 14, 1983 · N444PV · DestroyedNTSB LAX83FA192Accident · 1 fatalField investigationFinal reportCessna 182P · Auburn, CAPrior to this flt, the acft had not been flown for two months or refueled in five months. During that period, it had been exposed to unusually heavy amounts of rainfall. An annual inspection had been completed on 1/12/82 & 77 hrs had been flown since that…Apr 14, 1983 · N333LK · DestroyedNTSB DEN83LA096Accident · No injuriesLimited investigationFinal reportCessna 182P · Ashland, MTThe acft lifted off early, stalled, dropped a wing and cartwheeled to a stop. The left main gear was sheared off in the impact. The pilot stated that during the takeoff from his own ranch airstrip a horse ran out on the rwy in front of the acft. He said there…Apr 14, 1983 · N9891E · Substantial damageNTSB NYC83LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · West Chester, PAThe plt reported that during the takeoff roll, some oscillation in the controls for the nosewheel steering was noted. At about 45 KTS, he applied back pressure to lighten the load on the nosewheel as he had done in the past. He reported that since he was only…Apr 13, 1983 · N2943F · Substantial damageNTSB NYC83LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Waynesburg, PAThe pilot stated that following a normal takeoff, upon reaching an altitude of about 200 to 250 MSL, all eng power was lost. During an attempt to avoid trees at the end of the runway, for a clear area near a highway, the acft hit the top of a t-hangar. The…Apr 12, 1983 · N99ML · Substantial damageNTSB DEN83FA092Accident · 1 fatalField investigationFinal reportBell 206L-1 · Salt Lake City, UTThe helicopter collided with the side of a mountain during a turn after departing from a hospital helipad while on an emergency medical flt to pick up a medical team to care for a critically ill child. The plt was notified at 0510 by his dispatcher. After…Apr 11, 1983 · N1759D · DestroyedNTSB LAX83LA190Accident · 1 fatalLimited investigationFinal reportRolladen-Schneider LS-4 · La Jolla, CAThe plt was qualified for solo winch launches in an SGS-1-26 glider. On his 1st winch launch using a c.g. hook in this glider, he allowed the acft to enter an abnormally high angle of attack, which was observed thru-out the takeoff process. The glide then…Apr 10, 1983 · N3025R · DestroyedNTSB CHI83LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-140E · Lake, MIThe pilot stated the wind shifted at about 50 ft AGL and the acft stopped climbing and mushed down and collided with a fence.Apr 10, 1983 · N4395T · Substantial damageNTSB NYC83LA089Accident · No injuriesLimited investigationFinal reportPiper J3C-85 · Spencer, MAThe pilot was warming the eng for a compression check and oil change in preparation for an annual inspection. He stated that he decided to fly the aircraft rather than run the engine on the ground. On tkof a high rate of climb was obtained and at 150 MSL the…Apr 9, 1983 · N26182 · Substantial damageNTSB ATL83LA156Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Liberty, NCThe acft collided with trees during takeoff climb and crashed to the ground in a nose low attitude. The 4 occupants received only minor injuries. This was the beginning of a 10 minute night flight in dark overcast conditions. The pilot lowered the acft nose…Apr 9, 1983 · N3918P · DestroyedNTSB SEA83LA077Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · American Falls, IDThe acft was damaged in an off airport forced landing due to water in the fuel. The acft took off and at 3OO feet the left engine quit. The pilot was attempting a left turn back to the airport when the right engine started to sputter. Thepilot landed straight…Apr 7, 1983 · N3172P · Substantial damage