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 SEA82DA134Accident · No injuriesFinal reportMaule M-5-210C · Klamath Falls, ORDrg tkof, the plt ntoed a partial pwr loss & elected to make a prctnry lndg on the remaining rwy (length 10,300'). Whileaborting, he flared late & lndd hard. Water & products of corrosion were fnd in the gascolator. An investigation revealed the acft was…Jul 31, 1982 · N88JS · Substantial damageNTSB NYC82DA183Accident · No injuriesFinal reportSchweizer SGS-2-33A · Eighty Four, PAThe tow line released at 40 feet AGL in a glider tow launch. The glider pilot tried to land on the runway but landed adjacent to it and collided with a tree which ground-looped the glider. The tow hitch mechanism was broken off at the tubing cluster & was…Jul 31, 1982 · N7774S · Substantial damageNTSB NYC82DA177Accident · Minor injuriesFinal reportCessna 150L · Williamson, NYDuring a dual instructional flight the pilot experienced a power loss during takeoff while practicing touch and go landings. The aircraft was forced to land in an orchard and collided with trees.Jul 31, 1982 · N6924G · Substantial damageNTSB MKC82DA135Accident · No injuriesFinal reportBell 47J-2 · Chesterfield, MOThe pilot stated that he took off and was going through translational lift at about 15 to 20 ft AGL when he heard a loud bang. He said the loud bang was accompanied by a power loss. An immediate descent was made and the helicopter was landed hard with a…Jul 31, 1982 · N4070B · Substantial damageNTSB LAX82FYM18Accident · No injuriesFinal reportPiper PA-28RT-201 · San Carlos, CAAfter landing at the airport, the pilot taxied to the transient parking area, parked and got a cup of coffee. He stated that he then made a quick preflight check, but did not visually inspect the fuel tanks. During the takeoff, the engine began to surge at…Jul 31, 1982 · N2090W · Substantial damageNTSB FTW82DA312Accident · No injuriesFinal reportCessna 177 · Springer, NMWhile en route on a flight from gallup, NM to dalhart, TX, the left fuel tank would not feed. The pilot made a precautionary landing on rough, grassy terrain with no damage. An examination revealed that the tab for the left filler cap was broken and the cap…Jul 31, 1982 · N30157 · Substantial damageNTSB CHI82DA287Accident · No injuriesFinal reportBeech A23A · Grantsburg, WIThe pilot could not start the aircraft with the mixture in the normal (rich) position. The mixture was set to lean and the engine started. During takeoff, the engine lost power and the pilot landed off the end of the runway. This was the first flight since an…Jul 31, 1982 · N3683Q · Substantial damageNTSB ATL82FLT05Accident · Serious injuriesFinal reportVarga 2180 · Arlington, TNThe pilot made a precautionary landing during a cross country flight due to low fuel. After deciding he had enough fuel to continue, the pilot elected to takeoff. During the initial climb the engine quit. An emergency landing was made in a cotton field.Jul 31, 1982 · N5600M · Substantial damageNTSB SEA82FAD01Accident · 1 fatalFinal reportLake LA-4-200 · Ketchikan Intl., AKDeparting under a special VFR clearance, the acft entered IMC within a period of approximately 15 secs after takeoff. The acft struck trees & the ground approximately 2 mi south of the airport.Jul 30, 1982 · N2708P · DestroyedNTSB FTW82FPD17Accident · Serious injuriesFinal reportMooney M20 · Abilene, TXAt about 50-75 ft AGL after takeoff the eng quit. Both tanks contained adequate fuel & no eng malfunctions were found.Jul 30, 1982 · N8393E · DestroyedNTSB FTW82DA302Accident · Minor injuriesFinal reportDouglas DC-3C · El Paso, TXShortly after takeoff at about 800 ft AGL, the left engine oil temperate became high and reportedly there was a loss of oil pressure. The pilot reported that he then feathered the left engine and declared an emergency. On final approach, he did not get a safe…Jul 30, 1982 · N102BL · Substantial damageNTSB MKC82DA133Accident · No injuriesFinal reportBeech E-35 · Calamus, IAWhile demonstrating the use of the acft's fuel system during eng runup, the plt mistakingly left the fuel selector on the fuselage aux tank which contained only a small amount of fuel. When the eng quit after lift-off, the plt moved the selector to the left…Jul 29, 1982 · N3476B · Substantial damageNTSB FTW82AA299Accident · 12 fatalFinal reportRobertson C-414 · Lindale, TX7-Seat acft took off with 4 adults & 8 children aboard. Acft rotated at about 2000 ft down rwy & climbed in a flat nose high attitude before settling into 30 ft trees about 4223 ft from point of lift-off. Acft oscillated violently 2 or 3 times in the pitch…Jul 29, 1982 · N110VM · DestroyedNTSB CHI82DA277Accident · Minor injuriesFinal reportCessna 172P · Bruce, WIThe pilot departed an alfalfa field that was eight inches high and heavily saturated with dew. A witness stated that upon takeoff the nose of the aircraft was abruptly raised, the aircraft rose about 50 feet, the left wing dropped, the aircraft descended, and…Jul 28, 1982 · N53056 · Substantial damageNTSB FTW82DA296Accident · No injuriesFinal reportLake LA-4 · Springdale, ARDuring takeoff from a touch-and-go landing, the engine went to about idle power. During a forced landing, the left wing and nose collided with trees. Reportedly, the engine started developing full power just as the aircraft collided with trees. No mechanical…Jul 26, 1982 · N7635L · Substantial damageNTSB FTW82DA295Accident · No injuriesFinal reportCessna 150L · Franklinton, LADuring takeoff, the engine lost power when the aircraft was climbing through about 500 ft AGL. The instructor took the controls, made a shallow turn to a clearing, and landed in a field covered with underbrush and tree stumps. The plane was substantially…Jul 26, 1982 · N5482Q · Substantial damageNTSB SEA82FYP10Accident · Serious injuriesFinal reportPiper PA-22-150 · Tieton, WAAfter takeoff, the pilot turned to the left, but then he was unable to clear trees while climbing over rising terrain. A witness that saw the plane turn after takeoff stated that most airplanes continue climbing over a nearby lake and gain altitude before…Jul 25, 1982 · N8741D · Substantial damageNTSB NYC82DA168Accident · No injuriesFinal reportPiper PA-18S · Moultonboro, NHAccording to the pilot, he taxied to a takeoff point farther out than normal and it took longer to get the plane "on the step" due to very heavy air. When the pilot reached the abort point he used control back pressure to "pop off" the water. However, he was…Jul 25, 1982 · N64BC · Substantial damageNTSB NYC82DA166Accident · No injuriesFinal reportCessna U206G · Batavia, NYThe aircraft had been parked at the genesee county airport since the fall of 1981. The accident flight was the first the aircraft had flown since the fall. As the aircraft cleared the end of the runway, and attained an altitude of approximately 300 feet, a…Jul 25, 1982 · N8198G · Substantial damageNTSB ATL82FA212Accident · 4 fatalField investigationFinal reportCessna 182A · Louisburg, NCWitnesses observed the takeoff roll as being unusually long. The acft never climbed much above 100-200 ft AGL, & struck trees 1/2 mi off the end of the rwy. The flaps were observed up during takeoff. Normal takeoff flap setting used by the club for carrying…Jul 25, 1982 · N5188D · DestroyedNTSB ATL82DA210Accident · Minor injuriesFinal reportCessna 182 · Mobile, ALThe pilot experienced a power loss during takeoff and made an emergency landing in a soft soybean field. The aircraft nosed over after landing. Water was found in the fuel in the left tank and carburetor. The pilot had also found water inthe left tank during…Jul 25, 1982 · N735RF · Substantial damageNTSB SEA82DYK10Accident · 2 fatalFinal reportBeech S35 · Mckenzie Bridge, ORThe aircraft was landed at the Mckenzie Bridge state airport where two passengers deplaned. The airport had a 2600 ft turf runway with an upslope gradient of 3.4% toward the east. The airport/facility directory stated, "unattended. Land to e, takeoff to w.…Jul 24, 1982 · N7932K · DestroyedNTSB SEA82DA127Accident · No injuriesFinal reportGrumman G-164A · Burley, IDAt about 20 ft AGL after takeoff the eng quit. The cause of the eng failure could not be determined.Jul 24, 1982 · N9532 · DestroyedNTSB FTW82DA300Accident · Minor injuriesFinal reportSchleicher ASW-20 · Hempstead, TXThe pilot stated that the glider was assembled at the site. He reported that after becoming airborne, he obviously did not have pitch control. He released the tow rope at about 25 ft AGL and aborted. The glider landed hard on the fuselage, forward of the…Jul 24, 1982 · N13JR · Substantial damageNTSB ATL82FA208Accident · Minor injuriesField investigationFinal reportBeech B-60 · Sylva, NCThe aircraft crashed during takeoff after the pilot reported a loss of power on the left engine. The aircraft slid to a stop about 600 feet southeast of the departure end of runway 32. The pilots statement and physical evidence do not correlate. The prop…Jul 24, 1982 · N6648X · Substantial damageNTSB NYC82DA163Accident · No injuriesFinal reportCessna 150H · Ansonia, CTThe pilot flew to another local airport to practice touch and go landings. During the takeoff from the 1750 foot runway the aircraft stalled into the trees. The pilot stated that the aircraft settled into the tree tops when he maneuvered to avoid power lines.Jul 23, 1982 · N7291S · DestroyedNTSB CHI82DA268Accident · No injuriesFinal reportPiper PA-38 · Antioch, ILThe pilot initiated a soft field takeoff from a 2200 ft, wet, grass runway. After becoming airborne, he lowered the nose of the aircraft to increase his airspeed. The pilot stated that the aircraft failed to climb as expected and would not clear boats that…Jul 23, 1982 · N2365P · DestroyedNTSB NYC82FGT16Accident · No injuriesFinal reportBucker Jungmann BU-131 · Tower City, PAThe engine lost power when the aircraft was about 50 ft AGL during takeoff and landed in a rolling field of crops. The plane contacted the ground in a right bank/nose down attitude and came to rest at the point of impact. The engine separated from the…Jul 22, 1982 · N55JG · Substantial damageNTSB FTW82FPJ17Accident · 1 fatalFinal reportPiper 28-140 · Harrah, OKDuring takeoff, the pilot elected to cross under a power line near the end of the runway when he realized he could not fly over. As the plane crossed under the power line, the right main gear struck a steel perimeter fence post. Across the street form the…Jul 22, 1982 · N655FL · DestroyedNTSB FTW82FPG19Accident · 1 fatalFinal reportCessna 150J · North Little Ro, ARAfter a right turn after takeoff from rwy 17 the plt declared an emergency. A witness heard the eng backfiring. The plt continued the right turn & attempted a landing on rwy 35. He was described as being too high & hot, & touched down, or almost touched down,…Jul 22, 1982 · N60246 · DestroyedNTSB DEN82DA141Accident · Minor injuriesFinal reportAmerican AA5B · Broomfield, COThe pilot was conducting local area pleasure sightseeing flights when the aircraft failed to climb during a normal departure. She landed the aircraft in a plowed field. Investigation revealed the flight was conducted at a density altitude approximately 8,750…Jul 22, 1982 · N28218 · Substantial damageNTSB DEN82DA140Accident · Minor injuriesFinal reportPiper PA-22 · Glenburn, NDThe pilot reported that the engine lost power at about 100 AGL during a night takeoff. The aircraft was examined after the crash and the fuel selector was found positioned on the right tank. The aircraft had remained upright during and after the crash and the…Jul 22, 1982 · N949A · Substantial damageNTSB NYC82DA161Accident · Minor injuriesFinal reportThorp T-18 · Connellsville, PAWhile the student was taking off, the engine began to vibrate violently at an altitude of about 300 to 400 ft AGL. The flight instructor (CFI) took control and initiated a turn back to the airport. He stated that due to the vibration, he had to reduce the…Jul 21, 1982 · N62RB · DestroyedNTSB LAX82DA272Accident · No injuriesFinal reportCessna 140 · Santa Ynez, CADuring practice landing the engine began to run rough and intermittently. The instructor attempted a downwind landing. Pulling up over a fence aircraft stalled and made a hard landing the aircraft then nosed over. The fuel cap vent was blocked which prevented…Jul 21, 1982 · N90088 · Substantial damageNTSB CHI82FA260Accident · 1 fatalField investigationFinal reportRotorway Scorpion TOO · Niles, OHThe plt's wife stated that the helicopter was taken across the street to an open field where the plt conducted his flt in the acft. She had never seen him fly this acft over about 3 ft AGL. The helicopter was observed to jump as if lifted by a gust of wind &…Jul 21, 1982 · N9239Z · DestroyedNTSB DEN82FTM14Accident · Serious injuriesFinal reportOsprey II · Ogden, UTThe pilot reported that during takeoff, he experienced a 400 RPM drop in the engine speed. He began a right turn to land on runway 04, but reportedly, the engine then stopped. The pilot intended to land on the hull with the gear retracted; however, the plane…Jul 20, 1982 · N50733 · DestroyedNTSB ATL82FKM06Accident · 1 fatalFinal reportEvans VP-1 · Greensboro, NCThe eng quit at about 100 ft AGL after takeoff. The acft struck the ground approximately 80 deg nose down. Inspection of the fuel strainer revealed the screen gasket bent double which would allow foreign matter to enter the carburetor. The fiberglass fuel…Jul 20, 1982 · N2260K · Substantial damageNTSB ATL82FA202Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Eastover, NCAt about 60 ft AGL the eng quit. Water & rust sediment were found in the gascolator & carburetor.Jul 19, 1982 · N42098 · Substantial damageNTSB LAX82DA266Accident · No injuriesFinal reportBeech A36 · Grand Canyon, AZThe aircraft dragged a wingtip during an aborted takeoff and swerved off the runway. The density altitude was 8200 feet. The pilot said he could not maintain a climb so he lowered the landing gear to abort the takeoff and lost control of the aircraft. The…Jul 18, 1982 · N4600S · Substantial damageNTSB FTW82FQA22Accident · 4 fatalFinal reportCessna 172N · Santa Fe, NMThe acft struck the ground at a 40-45 deg angle & left wing down 1/2 mi from the departure end of rwy 20. No discrepancies were noted in aircraft systems. An eng disassembly revealed no malfunction. It was known the four occupants had a total weight of 857…Jul 18, 1982 · N6215D · DestroyedNTSB SEA82DA114Accident · No injuriesFinal reportMong Sport 1 · Battleground, WAThe pilot tookoff from a rough turf field adjacent to a school after a parade featuring his plane. The day was hot and the field was short. The pilot was unable to clear 60 foot trees and impacted the ground.Jul 17, 1982 · N610S · Substantial damageNTSB FTW82FPA15Accident · Serious injuriesFinal reportPiper PA-22-150 · Marlin, TXThe pilot stated that after takeoff, at an altitude of approximately 200 feet AGL, the engine quit. While attempting to make a left turn the aircraft lost airspeed and altitude and collided with trees. Examination of the wreckage at the accident site revealed…Jul 17, 1982 · N8760D · Substantial damageNTSB CHI82DA253Accident · No injuriesFinal reportCessna A185F · Lake Delton, WIThe float equipped aircraft was being operated on its first flight of the day. After takeoff, the pilot noted a deterioration of power as he was climbing through about 400 ft AGL. He was unable to restore the power and could not maintain level flight. During…Jul 17, 1982 · N8375Q · Substantial damageNTSB SEA82DA115Accident · Minor injuriesFinal reportGrumman AA-5A · Toketee, ORThe pilot calculated the weight of his aircraft to be 90 pounds below the maximum gross weight. The airport density altitude was calculated to be approximately 5000 feet. The pilot stated that after takeoff the aircraft achieved an altitude of 50 to 100 feet…Jul 16, 1982 · N9692U · DestroyedNTSB MIA82DA156Accident · No injuriesFinal reportSikorsky H-19 · Lake Lady, FLShortly after takeoff, the engine lost power and an autorotative landing was made in a marshy area. During touchdown, the main rotor blades struck the tail boom. The engine became submerged in water and could not be tested due to the high moisture content in…Jul 16, 1982 · N95484 · Substantial damageNTSB DEN82DA136Accident · No injuriesFinal reportCessna T188C · Starkweather, NDThe pilot reported that the aircraft fuel tank had run out of fuel, so he added 2 to 3 gallons of av-gas. He said he thought this would be enough fuel to ferry the the aircraft four miles. He took off, and upon reaching about 400 ft AGL, the engine lost…Jul 16, 1982 · N2087J · Substantial damageNTSB MKC82DA125Accident · No injuriesFinal reportCessna 150G · Bonner Springs, KSThe aircraft was flown from a private airstrip at maximum gross weight and an uphill takeoff run. The pilot stated he could not maintain airspeed. During a turn to make an emergency landing the left wing contacted a utility wire and the aircraft was…Jul 15, 1982 · N3335J · Substantial damageNTSB LAX82FUG14Accident · Serious injuriesFinal reportGrumman AA-5 · Bermuda Dunes, CAImmediately after takeoff the eng lost power & the acft was unable to maintain level flt. The acft landed in sand Dunes and flipped over. During a subsequent eng run it was noted that the eng ran normally at low power settings but at takeoff power settings it…Jul 15, 1982 · N7115L · Substantial damageNTSB ANC82FA059Accident · No injuriesField investigationFinal reportAerospatiale SA-318C · Skwentna, AKThe pilot reported that after takeoff, at an altitude of 200 feet, the aircraft began a moderate vibration. When the aircraft was leveled off and the power reduced, the vibration stopped. The pilot continued the flight and during a climb turn at approximately…Jul 15, 1982 · N4966 · Substantial damageNTSB FTW82DA286Accident · No injuriesFinal reportAir Tractor AT-301 · Rio Hondo, TXImmediately after takeoff, the engine lost power and a forced landing was made in a field of tall cotton. After landing in the cotton field with four-foot-high stalks, the pilot as unable to maintain directional control and the plane was substantially…Jul 14, 1982 · N4448S · Substantial damage