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 CHI82DA220Accident · Minor injuriesFinal reportPiper PA-18 · Hobart, INDuring takeoff, the engine lost power at an altitude of about 150 to 200 ft AGL. Subsequently, during a forced landing, the aircraft flew through a row of trees when the pilot tried to reach an open area that turned out to be a grave yard. The pilot believed…Jun 20, 1982 · N897SP · Substantial damageNTSB LAX82FA224Accident · No injuriesField investigationFinal reportBeech H-18 · Fresno, CAJust after lift-off from rwy 29R, the acft began to pitch up. As the pitch-up progressed, the plt applied right aileron & full right rudder. The acft responded by rolling to the right with the nose falling thru. Subsequently, the plt was able to pull out…Jun 19, 1982 · N74JT · DestroyedNTSB FTW82DA237Accident · Minor injuriesFinal reportGrumman G164B · Beedeville, ARThe agricultural aircraft lost power during takeoff. The pilot jettisoned the load and made a forced landing in a rice field. During the landing, the aircraft nosed over in soft muddy terrain.Jun 18, 1982 · N8187K · Substantial damageNTSB MKC82DA105Accident · No injuriesFinal reportCessna 120 · Gardner, KSDuring takeoff, the aircraft struck a fence near the departure end of the runway. After hitting the fence, it traveled about 37 yards before nosing over in an adjacent wheat field. The field was soft due to recent rains. The pilot said the 1300 ft runway was…Jun 17, 1982 · N1993V · Substantial damageNTSB CHI82FA214Accident · 2 fatalField investigationFinal reportPiper PA-32 · Charlevoix, MIThe acft departed the Charlevoix arpt & crashed 1 mile south of the arpt. Two persons tried to discourage the plt from leaving because of the poor weather. Witnesses described the weather as raining hard & visibility poor with an estimated visibility at 200…Jun 17, 1982 · N30575 · DestroyedNTSB FTW82DA236Accident · No injuriesFinal reportAyres S-2R · Edgerly, LAAfter takeoff with a load of fertilizer, the aircraft lost power and a forced landing was made which resulted in damage to the aircraft. The cause of the engine malfunction was not determined.Jun 16, 1982 · N8989Q · Substantial damageNTSB DEN82DTI15Accident · Serious injuriesFinal reportAerospatiale SA 315B · White Sulphur S, MTThe pilot landed beside a small building (called a dog house) which contained seismic instruments and recording equipment. He was scheduled to move the building and hooked a long line from it to the helicopter. After waiting about 45 minutes for final…Jun 16, 1982 · N5785V · DestroyedNTSB CHI82DA208Accident · No injuriesFinal reportCessna A188B · Greenbush, MNThe aircraft crashed during takeoff from a grass runway that had not been mowed for several weeks. The field elevation was 1070 ft, the wind was calm, and the temperature and dew point were 62 and 50 degrees. A full flap (20 degree) configuration was used for…Jun 14, 1982 · N4870R · Substantial damageNTSB ATL82FA163Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Atlanta, GAShortly after takeoff, a loud noise was heard and sparks were observed coming from the right side of the right engine. The aircrew attempted to feather the right engine, but it would not feather. They were unable to maintain altitude and descended into trees.…Jun 14, 1982 · N4072P · DestroyedNTSB FTW82DA219Accident · No injuriesFinal reportI.C.A. Brasov - Romania IS-28B2 · El Paso, TXThe sailplane was towed to about 200 ft AGL when the tow rope separated. When the pilot realized he was unable to return to the airport he attempted a landing along a river levee. The left wing struck the levee and the aircraft cartwheeled.Jun 13, 1982 · N51842 · DestroyedNTSB ATL82FIG08Accident · Serious injuriesFinal reportAeronca C-3 · Ocean City, MDThe aircraft was observed taking off on runway 14 under a 700 ft ceiling. It climbed to about 100 ft AGL, and while still over the runway, it began a left turn and started losing altitude. The pilot reported that during the takeoff, he had throttled back and…Jun 13, 1982 · N16270 · Substantial damageNTSB SEA82DA086Accident · Minor injuriesFinal reportCessna 210-5(205) · Jerome, IDDuring takeoff, the engine lost power at about 100 ft AGL. The pilot elected to land in a newly planted bean field. After touchdown, the wheels sank into soft terrain and the plane nosed over. An examination of the aircraft and engine revealed no precrash…Jun 12, 1982 · N8228Z · DestroyedNTSB NYC82FFJ13Accident · Serious injuriesFinal reportLake LA-4-200 · Canandaiqua, NYWhile taking off, an intermittent power loss was encountered. According to the pilot, the aircraft settled and bounced on a paved road at the end of the runway, then engine power returned and the plane began climbing again. At about 60 to 70 ft AGL, power was…Jun 12, 1982 · N6056V · Substantial damageNTSB NYC82FNA15Accident · Minor injuriesFinal reportAeronca 7AC · Danvers, MADuring the previous flight, the aircraft had run out of fuel and was successfully landed in an open field. This occurred while the fuel gauge was indicating 1/4 full. The pilot serviced the plane with 5 gallons of no-lead auto fuel and stripped it of excess…Jun 11, 1982 · N2983E · Substantial damageNTSB FTW82FRD15Accident · Serious injuriesFinal reportGrumman G-164A · Egan, LAAs the plt was adjusting the powerplant & prop controls the eng accelerated, & at the same time oil covered the windshield. The acft went down into a bean field & flipped over. Disassembly of the eng revealed the rear counterweight trailing pin worn &…Jun 11, 1982 · N6787Q · DestroyedNTSB LAX82DA215Accident · No injuriesFinal reportAerospatiale 341G · Flagstaff, AZThe pilot reported that he lifted off to a 5 ft hover with 4 passengers and 70 gallons of fuel on board. He reported that during the hover check, all instruments were in the green with the turbine outlet temperature at 550 degrees. The pilot stated that he…Jun 10, 1982 · N341BB · Substantial damageNTSB SEA82DA082Accident · No injuriesFinal reportHughes 269A · 2nm Nnm Redmond, WAThe engine lost power during the climb and the pilot executed an autorotation. Upon landing the aircraft rocked back and the main rotor severed the tail boom.Jun 9, 1982 · N8730F · Substantial damageNTSB NYC82DA120Accident · No injuriesFinal reportCessna 185E · Round Lake, NYThe pilot stated that during his preflight, he drained the main sediment bowl for 5 seconds, then repeated draining it for another 5 seconds. He reported that he performed an engine run-up, switched all tanks on, and initiated a takeoff. Reportedly, the…Jun 9, 1982 · N70232 · Substantial damageNTSB CHI82FA203Accident · 2 fatalField investigationFinal reportBellanca 7KCAB · Centerpoint, INThe non-rated owner/pilot crashed after taking off from a private sod strip. The impact point was about 400 ft from the departure end of the runway and 200 ft left of the centerline. According to a witness, the takeoff roll was started from a crown on the…Jun 9, 1982 · N7543F · DestroyedNTSB FTW82DA217Accident · No injuriesFinal reportGrumman G164B · Bono, ARThe aircraft was loaded with 1700 pounds of fertilizer and 70 gallons of fuel. The aircraft would not climb out of ground effect. During the forced landing the aircraft nosed over. The aircraft burned after impact.Jun 8, 1982 · N8105K · DestroyedNTSB CHI82DA202Accident · Minor injuriesFinal reportCessna 150 · Cambridge, MNOn his first solo flight the student pilot stated he panicked at about 400 feet AGL and decided to land in a plowed field. During the landed sequence the aircraft nosed over.Jun 8, 1982 · N714HY · DestroyedNTSB FTW82DA215Accident · No injuriesFinal reportBeech C23 · Brinkley, ARDuring a short field takeoff the pilot abruptly raised the nose of the aircraft. The aircraft drifted to the right and stalled. The aircraft crashed in an adjacent wheat field.Jun 7, 1982 · N38413 · DestroyedNTSB MKC82FA096Accident · 1 fatalField investigationFinal reportCessna 170B · Tama, IAThe purpose of the flight was to take a family friend on a night airplane ride to see the lights of a neighboring city. The takeoff was made from a soft wet grass runway with an aircraft exceeding the maximum allowable gross weight and the center of gravity…Jun 6, 1982 · N8187A · DestroyedNTSB MIA82FA128Accident · Serious injuriesField investigationFinal reportDouglas DC-3C · St. Petersburg, FLAfter a local maintenance flight the crew returned to St. Petersburg to practice full stop landings. Shortly after becoming airborne during the 2nd takeoff, the right eng experienced a power loss. The acft was observed to climb to about 50 ft AGL, then veer…Jun 6, 1982 · N95C · DestroyedNTSB FTW82FRD13Accident · 2 fatalFinal reportPiper PA-28-161 · Lake Charles, LAThe plt told the surviving pax he was going to make a short fld takeoff with full (40 deg) flaps. The pax, who is also a plt, disagreed with the plt. The plt said it would be okay & proceeded to take off. During the takeoff roll the pax suggested he change…Jun 6, 1982 · N83006 · DestroyedNTSB MKC82DA097Accident · Minor injuriesFinal reportPiper PA-25-235 · Kimball, NEThe aircraft was loaded with 100 gallons of 2-4-D and 40 gallons of fuel. During the preflight run-up check, the pilot noted a mag drop of 225 RPM. He stated that leaning the fuel mixture cleared the excessive decrease in RPM, and he observed 2500 RPM on the…Jun 5, 1982 · N6997Z · Substantial damageNTSB NYC82FA115Accident · 5 fatalField investigationFinal reportBeechcraft B-55 · Ithaca, NYThe takeoff was observed to appear normal for 2500 ft. at about 150 ft in the air the acft rolled sharply left. The roll continued to an inverted position, after which the acft descended in a near vertical attitude. The aileron- elevator control locking pin…Jun 3, 1982 · N677F · DestroyedNTSB DEN82DTI13Accident · No injuriesFinal reportAir Tractor AT-301 · Ruyard, MTThe aircraft was refueled prior to takeoff. The pilot reported that the takeoff was normal until about 75 ft off the runway when the engine quit. During a forced landing, the plane touched down in a 3-point attitude, bounced, and then hit the ground in a nose…Jun 2, 1982 · N4403S · Substantial damageNTSB ATL82FKG15Accident · 1 fatalFinal reportAeronca 7AC · Cedartown, GAThe acft stalled & crashed into trees from an altitude of approximately 60 feet AGL. The elevator trim tab control was found in the full nose up position.Jun 2, 1982 · N2475E · DestroyedNTSB NYC82DA112Accident · No injuriesFinal reportCessna 172P · Greenville, METhe pilot reported that during takeoff, there was a partial loss of engine power after the float plane had climbed about 200 to 300 ft. carburetor heat was applied, but there was no immediate effect. The pilot reported that after the plane started to settle,…Jun 1, 1982 · N52178 · Substantial damageNTSB FTW82DA206Accident · No injuriesFinal reportLake LA-4-200 · Rockport, TXA partial loss of power was experienced during takeoff and a forced landing was made on a road. As the pilot was landing, a car pulled out on the road ahead of the aircraft. While manuevering to the right to avoid the car, the right wing struck a road sign…Jun 1, 1982 · N1233L · Substantial damageNTSB DEN82DA100Accident · Minor injuriesFinal reportCessna T337C · Gunnison, CODuring takeoff, the rear engine lost power at about 600 ft AGL, and about 20 seconds later, the front engine lost power. The pilot had turned to a downwind, but had lost all power during the turn to final approach. The aircraft impacted about 1/2 mile from…Jun 1, 1982 · N12AC · Substantial damageNTSB FTW82DA203Accident · No injuriesFinal reportAero Commander S2R · Lake City, ARThe aircraft departed from a soft private ag strip with a heavy load and would not climb high enough to get above wheat in a field off the end of the runway. The aircraft collided with the wheat and was subsequently destroyed by ground fire.May 30, 1982 · N5522X · DestroyedNTSB CHI82DA194Accident · Serious injuriesFinal reportAeronca AR-58 · Grand Haven, MIAfter liftoff the pilot lost directional control and crashed in a swamp. The aircraft was substantially damaged.May 30, 1982 · N2563E · Substantial damageNTSB FTW82DA202Accident · No injuriesFinal reportAir Tractor AT 301 · New Deal, TXThe pilot departed an ag strip with a heavily loaded aircraft. Reportedly, the elevation and temperature were 3338 ft and 87 deg. After climbing to about 45 ft AGL, he entered a right turn. At this time, he noticed engine roughness and a loss of manifold…May 29, 1982 · N4359S · DestroyedNTSB DEN82FTM12Accident · No injuriesFinal reportQuickie Rise · Ogden, UTDuring takeoff, the engine lost power as the aircraft was climbing near the departure end of the runway. The aircraft was substantially damaged during a forced landing on rolling terrain with brush. An investigation revealed there was a loose screw holding a…May 29, 1982 · N23SR · Substantial damageNTSB CHI82DA192Accident · No injuriesFinal reportErcoupe 415-C · Fort Atkinson, WIThe safety bolt on the propeller hub failed allowing the propeller to separate from the aircraft. The pilot landed in a plowed field.May 29, 1982 · N93616 · Substantial damageNTSB FTW82DA197Accident · No injuriesFinal reportConsolidated Aeronautics LA-4-200 · Canyon Lake, TXAfter taxiing around the shoreline, taking-off, and landing again, the pilot was unable to takeoff a second time because his left pontoon was submerging. He proceeded to drain the water out at a public boat dock and attempted to make a downwind takeoff due to…May 28, 1982 · N80022 · DestroyedNTSB LAX82FA196Accident · 8 fatalField investigationFinal reportCessna 320D · Chandler, AZShortly after the aircraft took off from stellar airpark, several witnesses saw it flying northbound with smoke trailing from the left engine. One witness, a student pilot, stated that the gear was down and the plane was lower than normal, about 500 ft AGL.…May 27, 1982 · N4167T · DestroyedNTSB NYC82DA106Accident · No injuriesFinal reportSchleicher ASW-15 · Plymouth, CTThe pilot stated that he thought he heard the rudder pedals click into their detented/locked position when they were adjusted before takeoff. However, while being towed for takeoff, the rudder pedals slipped forward about 1 to 2 inches. The pilot reached down…May 26, 1982 · N77BZ · Substantial damageNTSB MIA82DA124Accident · No injuriesFinal reportCessna 188 · Alpha, FLThe pilot reported that during takeoff, the engine began running rough at about 1000 ft. he noted that the fuel pressure had increased abnormally and black puffs of smoke were coming out of the exhaust. He dumped his load and gained a small amount of…May 24, 1982 · N53277 · DestroyedNTSB MIA82DA123Accident · No injuriesFinal reportLake LA-4 · Winter Garden, FLThe pilot reported that during takeoff from a 2500 ft Lake, the aircraft would not gain sufficient altitude. The plane collided with trees at the FAR end of the Lake and fell to the ground. The wind was calm and the temperature was about 85 degrees.May 24, 1982 · N8005J · DestroyedNTSB FTW82FPG13Accident · 1 fatalFinal reportLuscombe 8A · Parkin, ARThe pilot departed presidents isle, TN with about 1/4 tank of fuel (3.5 gal) and proceeded en route with a planned stop at wynne, AR for fuel. Prior to reaching wynne, heavy rain was encountered and a landing was made at a private airport near Parkin, AR. The…May 24, 1982 · N71153 · DestroyedNTSB ANC82DA041Accident · Minor injuriesFinal reportPiper PA-28-140 · Portage Creek, AKThe pilot reported that he encounted a downdraft and the plane stalled and hit the ground during takeoff. The aircraft came to rest with a broken nose gear, bent propeller, broken engine mount, and a broken strobe light. An investigation revealed the wind was…May 24, 1982 · N55038 · Substantial damageNTSB SEA82DA074Accident · No injuriesFinal reportCessna 172G · Lester, WAThe pilot elected to takeoff from an airport that was officially closed to aircraft operations by the FAA because of winter flood damage to the runway. The aircraft cleared two large fir trees about 500 ft from the end of the runway but struck trees about 400…May 23, 1982 · N1320F · Substantial damageNTSB ANC82DAA03Accident · No injuriesFinal reportBrantly B-2B · Fairbanks, AKShortly after takeoff, a partial power loss occurred over a wooded area and the pilot initiated an autorotative landing. During the landing, the main rotor and tail rotor blades hit trees, then the right skid set down on a small tree and the helicopter rolled…May 23, 1982 · N2195U · Substantial damageNTSB SEA82DA076Accident · Serious injuriesFinal reportCessna 182F · Medford, ORAfter takeoff, engine oil began to accumulate on the windshield and restrict forward visibility. The pilot returned to land, bounced during landing, and elected to go-around. During climbout the aircraft struck trees on rising terrain and crashed. The owner…May 22, 1982 · N3461U · Substantial damageNTSB DEN82DA093Accident · No injuriesFinal reportBeech V35A · Colorado Spring, COThe pilot stated, the engine run-up was normal and the mixture was leaned at 1700 RPM to obtain initial EGT movement off the bottom of the guage. He reported taking off uphill on runway 03. He noted that the acceleration was slow, but attributed it to the…May 22, 1982 · N6242V · Substantial damageNTSB CHI82DA184Accident · No injuriesFinal reportBoeing B75N1 · Alliance, OHThe pilot started a turn at low altitude after takeoff and the aircraft started to sink. Since he was headed for trees, the pilot allowed the aircraft to settle to the ground in a residential backyard. There was no malfunction of the aircraft to contribute to…May 22, 1982 · N65544 · Substantial damageNTSB MKC82DA087Accident · No injuriesFinal reportPiper PA-31P · Salina, KSAccording to the pilot, the left engine began running rough at about 300 ft AGL after takeoff and the roughness was accompanied by a slight left yaw. The pilot said the left engine was producing some power so he elected not to feather the propeller. The…May 21, 1982 · N40NC · Substantial damage