OpenAirDocs.org

NTSB investigations

18,851 cases where the phase of flight was Maneuvering.

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 = 450)
  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 SEA82FYK09Accident · Serious injuriesFinal reportAeronca 7AC · Near Creswell, ORThe aircraft crashed while the pilot was making a low pass over a grass field. The pilot reported that the plane struck the ground while he was proceeding westbound toward the setting sun, but he did not remember the details of the crash. An instructor pilot…Jul 1, 1982 · N1838E · Substantial damageNTSB LAX82FVD19Accident · Serious injuriesFinal reportGrumman G-164B · Stockton, CAThe pilot was spraying a field that required flying under a double set of high powerlines. On the third pass after going under one set of wires the pilot pulled up too soon and hit the second set of wires. The pilot stated in his accident report that it was a…Jul 1, 1982 · N4859S · DestroyedNTSB FTW82DRJ13Accident · 1 fatalFinal reportAir Tractor 301 · Clarksville, TXThe pilot stated that he briefed the two flagmen about moving to next row as soon as the aircraft was lined up on the swath run. Both flagmen moved properly until on the fatal pass one flagman did not move and the aircraft struck him. The flagman struck by…Jul 1, 1982 · N4437S · No damageNTSB FTW82DA259Accident · No injuriesFinal reportCessna 310Q · El Dorado, OKWhen the pilot arrived in the vicinity of his destination, he lowered the gear and flaps and dlew over an oil rig. He did this to alert someone on the ground to pick him up at the destination. As he applied power to proceed to the airport, the left engine did…Jul 1, 1982 · N7692Q · Substantial damageNTSB FTW82DA257Accident · No injuriesFinal reportGrumman G-164A · Epps, LAThe pilot stated that while he was spraying crops, he looked into the cockpit during a turn to check the amount of solution that was remaining. He stated that when he looked up, he was too low to complete the turn and miss the trees. He went to full power and…Jul 1, 1982 · N6562 · Substantial damageNTSB ATL82DA188Accident · No injuriesFinal reportGrumman G-164A · Doddsville, MSThe pilot reported that at the end of a swath run, he noticed the smell of burned oil and saw smoke when the engine began a hard miss. He reported that these occurred when the number five cylinder failed. He made a forced landing in a flooded rice field where…Jul 1, 1982 · N7397 · Substantial damageNTSB LAX82FA237Accident · 1 fatalField investigationFinal reportGrumman American AA5A · Phoenix, AZThe acft was observed flying at an altitude of 200 to 300 feet AGL. Witnesses describe a bank to the left which steepened until the wings were perpendicular to the ground. The acft then made a near vertical descent into the ground.Jun 29, 1982 · N26668 · DestroyedNTSB FTW82DA251Accident · No injuriesFinal reportHughes 269C · Canadian, TXThe fixed-wing-rated/helicopter student pilot stated that it had been raining before he went to fly. Reportedly, he began to practice hovering while wearing wet tennis shoes. The student stated that his foot slipped off of the pedal because the soles of his…Jun 28, 1982 · N58407 · Substantial damageNTSB DEN82DA119Accident · Minor injuriesFinal reportHughes 269C · Ronan, MTAfter spraying the field, the pilot was making an "end swath" when the helicopter collided with a power line. The helicopter crashed after a wire wrapped around the swash plate and damaged the controls. The pilot stated that he failed to see the wire.Jun 28, 1982 · N9626F · Substantial damageNTSB ATL82DA179Accident · Minor injuriesFinal reportBell 47G-3B-1 · Headland, ALThe pilot was positioning the aircraft for refueling when the main rotor contacted the fuel meter. There was substantialdamage to the helicopter and minor injuries to the chemical loader.Jun 28, 1982 · N12437 · Substantial damageNTSB SEA82DA096Accident · No injuriesFinal reportBensen B-8M · Kennewick, WAThe pilot stated that he was demonstrating the gyrocopter's vertical decent capability at an eaa fly-in. He flew the aircraft into the wind at approximately 200 feet, reduced power and failed to recover from the sink rate.Jun 27, 1982 · N5919 · Substantial damageNTSB NYC82FHJ06Accident · 3 fatalFinal reportCessna 177 · Larchmont, NYThe aircraft was on a flight to take pictures of a home that was recently constructed on the shore of long island sound. While in flight, pictures were also taken of boats. A witness on a boat stated taht after the pilot made several passes over boats, the…Jun 27, 1982 · N3365T · DestroyedNTSB NYC82FGT15Accident · 3 fatalFinal reportAeronca 11AC · Peach Bottom, PAThe non-certificated pilot took off with one passenger on board and with both doors removed. Witnesses observed the pilot make a number of passes near boats, under power lines and near people on the surface. A number of witnesses stated the passenger was…Jun 26, 1982 · N9451E · DestroyedNTSB MKC82FCQ11Accident · Serious injuriesFinal reportCessna 188B · Scott City, KSThe aircraft crashed during an aerial application operation; however, the pilot could not remember the details of the accident. He believed that the propeller may have started to turn excessively fast, but this was not verified. After contacting the ground,…Jun 26, 1982 · N4965R · Substantial damageNTSB MIA82DA141Accident · Minor injuriesFinal reportPiper PA-38-112 · Fellsmere, FLThe pilot was a foreign national with a private pilot certificate and was on a solo instructional flight. He reported that the engine lost power while he was practicing s-turns at 800 ft. he stated that he accomplished the procedure for an engine failure, but…Jun 26, 1982 · N2437K · Substantial damageNTSB DEN82DA118Accident · Minor injuriesFinal reportAerospatiale SA 315 B · 35 Se Moab, UTHelicopter lifting sling loads lost power in a hover. Pilot jettisoned load and made a forced landing in a ravine, engine had dirt buildup and erosion in the compressor inlet case which led to compressor stall.Jun 26, 1982 · N221RM · Substantial damageNTSB FTW82DRA22Accident · Serious injuriesFinal reportGrumman G-164 · Hardin, TXThe pilot reported that he struck power lines while flying under them during a swath run. Also, he indicated that a thunderstorm was rapidly approaching the field at the time the accident occurred.Jun 25, 1982 · N8354K · Substantial damageNTSB DEN82AA115Accident · 6 fatalFinal reportBeech V35B · Near Ringling, MTAlthough IMC existed over mountainous areas, the plt attempted a visual flt direct to salt lake city. The probable flt path of the acft was one which is usually flown by plts on VFR flts. The course taken by plts desiring to cross over themountain ridges west…Jun 24, 1982 · N4538S · DestroyedNTSB LAX82FA232Accident · 3 fatalField investigationFinal reportAerospatiale SA-316B · Dardanelle, CAThe pilot took off from modesto, CA on a medivac flight to pick up a victim that was injured in an automobile accident. A nurse and a medical technician were on board. Spotlights on vehicles were used to illuminate the landing area as well as high surrounding…Jun 23, 1982 · N6456 · DestroyedNTSB FTW82DA244Accident · No injuriesFinal reportGrumman G-164A · Coy, ARThe pilot reported that the engine lost power as he was pulling up from a swath run. He pumped the throttle several times, the engine regained power momentarily, then quit. The pilot dumped his load and made a forced landing in a muddy field. As the plane was…Jun 22, 1982 · N8729H · Substantial damageNTSB DEN82FTI16Accident · Serious injuriesFinal reportPiper PA-28-R-180 · Cameron, MTThe pilot reported that he encountered a downdraft while climbing over rising terrain in an area of foothills near mountains. He reported a loss of airspeed and altitude when the aircraft was about 1000 ft from the crest. At about that time, the gear extended…Jun 22, 1982 · N3901T · DestroyedNTSB FTW82FRJ12Accident · 1 fatalFinal reportPiper PA-36-375 · Wildsville, LAThe pilot took off on a local flight to spray a bean field. About 1000 ft from the end of the field was a 300 ft radio tower. The aircraft was observed to circle the bean field and circle the radio tower twice. During a procedure turn, the aircraft struck the…Jun 21, 1982 · N90297 · DestroyedNTSB FTW82DA238Accident · No injuriesFinal reportRockwell Intl S-2R · Eudora, ARSince the aircraft had not flown for two months, the pilot was on a flight to check the systems before flying for hire. The pilot flew over an unpopulated area of the Mississippi river with clear water in the spray tanks. He stated that while he as spraying…Jun 21, 1982 · N4905X · Substantial damageNTSB DEN82FA106Accident · Serious injuriesField investigationFinal reportAerospatiale SA-315B · Dillon, MTThe pilot maneuvered the helicopter close to the ground to "spook" an antelope. After a series of turns, the aircraft touched down on both skids and continued forward 246 ft before stopping.Jun 21, 1982 · N47271 · DestroyedNTSB NYC82DA128Accident · No injuriesFinal reportBell 206B · Jamestown, RIThe helicopter was being used to photograph ships. According to the pilot, it began to spin while he was in a low level hover over the water. Subsequently, the helicopter struck the water, rolled over, then sank in about 104 ft of water and was not recovered.Jun 20, 1982 · N20303 · Substantial damageNTSB LAX82FA225Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Westley, CAThe plt made a low pass over a ranch house traveling from nw to se. He then made a second low pass over the swimming pool area traveling in a NE direction, & waved to those standing by the pool. The acft began a 180 reversal turn, entered a steep nose down…Jun 20, 1982 · N2661Z · DestroyedNTSB FTW82FPD13Accident · 1 fatalFinal reportVarieze · Roanoke, TXAbout 5 min after takeoff, the pilot initiated a high speed low pass over the airport. When the aircraft was about 1000 ft from the airport at about 100 ft AGL, the right winglet separated. A witness estimated that the aircraft's speed was about 200 mph.…Jun 20, 1982 · N111CH · DestroyedNTSB DEN82DA108Accident · No injuriesFinal reportCallair A-9B · Rolla, NDThe pilot reported that after loading with chemical, water, and fuel, he went to a field and began spraying. He stated that after he had made his first swath run, he was turning for a second swath when the plane stalled and crashed. The landing gear,…Jun 20, 1982 · N7634V · Substantial damageNTSB CHI82DA217Accident · Minor injuriesFinal reportTaylorcraft BC12-D · La Porte, INThe pilot had flown to the airport to participate in activities of a contest that included spot landings and balloon busting. He stated that on his third pass of a balloon busting contest, he turned too tight, too slow, and the aircraft stalled. The pilot…Jun 19, 1982 · N96054 · Substantial damageNTSB CHI82DA215Accident · Serious injuriesFinal reportBellanca 73CA · Fairfield, ILThe pilot stated that after takeoff he flew 3 or 4 miles, started a right turn and could not recall any further events concerning the flight. Investigation revealed the aircraft crashed on flat terrain. Examination of the flight controls did not reveal any…Jun 19, 1982 · N90977 · DestroyedNTSB ATL82FKQ15Accident · 3 fatalFinal reportCessna R182 · Ocean Springs, MSA pilot-rated witness observed the entire flight and accident. He stated that after takeoff and gear retraction, the aircraft was held at a very low altitude, which he thought was to gain airspeed. The aircraft reached the end of the runway and went into a…Jun 19, 1982 · N757FB · DestroyedNTSB ATL82DA171Accident · Minor injuriesFinal reportPiper PA-25-235 · Ripley, INWhen the pilot arrived to spray the field for the first time, he saw powerlines along a road and saw poles on both sides of a creek. He assumed that all of the lines followed the road. He was unaware that a powerline crossed the narrow field that he was about…Jun 18, 1982 · N8544L · DestroyedNTSB MKC82DA108Accident · No injuriesFinal reportCallair A-9B · Ulysses, KSThe pilot was on a spray flight over an area of sand hills. While dropping flags to help determine the wind on the surface, he encountered unfavorable wind conditions and a sudden loss of lift. He applied full power, but was unable to recover from the mushing…Jun 17, 1982 · N7603V · Substantial damageNTSB FTW82DA230Accident · No injuriesFinal reportRockwell S2R · Bishop, TXReportedly, the pilot realized he was low on fuel, but thought he had enough to finish spraying the field and return to the landing area. As he pulled up from the last pass, he noticed that one fuel gauge was on empty and the other was indicating about 1/8…Jun 17, 1982 · N5028X · Substantial damageNTSB CHI82FA213Accident · 1 fatalField investigationFinal reportCessna 152 · Danville, OHThe pilot made a low, slow pass over a camp so a passenger could drop a package. After the package was dropped, the aircraft entered a left turn, then stalled and spun to the ground.Jun 17, 1982 · N5330M · DestroyedNTSB LAX82DA222Accident · Serious injuriesFinal reportRockwell Intl. S-2R · Firebaugh, CAThe pilot was spreading fertilizer over a field and maneuvering over "high tension lines." No problems were encountered during previous flights earlier that day. The pilot had picked up another load which he reported was probably too much. He reported that…Jun 16, 1982 · N4218X · DestroyedNTSB CHI82DA212Accident · No injuriesFinal reportBell 47G-2A · Hudsonville, MIThe pilot was flying a swath run that required him to fly under electric wires near a blacktop county road. As the pilot was coming off the field and passing under the wires, he realized he was on a collision course with a car. He pulled up to avoid the car…Jun 16, 1982 · N364W · Substantial damageNTSB NYC82FGM11Accident · 1 fatalFinal reportBell 47G-3B-1 · Kittanning, PAThe helicopter was on a powerline patrol flight with three occupants on board. While proceeding along the powerline with a tailwind, the pilot started to climb over a hill. He stated to the passengers that he was unable to out climb the hill, then circled to…Jun 15, 1982 · N9276Z · DestroyedNTSB NYC82DA124Accident · No injuriesFinal reportContinental EL Tomcat MK5A · Imlaystown, NJDuring a swath run, a bird flew into the windshield and the pilot rolled the helicopter to the right to avoid further bird strikes. The right spray boom contacted the crops and pulled the aircraft into the ground resulting in substantial damage.Jun 15, 1982 · N9062T · Substantial damageNTSB FTW82FPA12Accident · Serious injuriesFinal reportCessna 150 · Allen, TXA witness attending a horse show observed the acft fly over the field at low altitude in a slow flt & that something wrapped in plastic was dropped from the acft. The acft was in a nose high attitude approaching a stall. The acft then disappeared from his…Jun 13, 1982 · N3971U · DestroyedNTSB CHI82FA206Accident · 1 fatalField investigationFinal reportMcclary Mong Sport · Cedar, MNWitnesses observed the acft enter a steep nose down attitude & slow spiral from which the acft did not recover.Jun 13, 1982 · N5099 · DestroyedNTSB ATL82FLQ06Accident · 1 fatalFinal reportBellanca 8KCAB · Mayfield, KYThe aircraft crashed while the pilot was performing an aerobatic routine at an airshow. After about 7 minutes in an 8 minute act, the pilot performed an 8-point roll at about 200 ft AGL, then pulled up into a hammerhead stall. After a hammerhead turn to the…Jun 13, 1982 · N50352 · DestroyedNTSB LAX82FVD18Accident · No injuriesFinal reportCessna 172 · Mckinleyville, CAThe aircraft struck and severed 3 power lines about 3 miles south of the departure airport. Prior to the accident, it was observed flying at low altitude in the vicinity. The pilot stated that he flew by a mobile home park to verify that a trailer had been…Jun 12, 1982 · N64187 · Substantial damageNTSB FTW82FPD14Accident · No injuriesFinal reportLearjet 23 · Abilene, TXAbout 5 min after takeoff, the pilot initiated a high speed low pass over the airport. When the aircraft was about 1000 ft from the airport at about 100 ft AGL, the richt winglet separated. A witness estimated that the aircraft's speed was about 200 mph.…Jun 12, 1982 · N5DM · Substantial damageNTSB ANC82DAG31Accident · No injuriesFinal reportPiper PA-18 · Anchorage, AKThe pilot reported that before takeoff, he had trouble getting the engine to develop power. He called a mechanic who advised that conditions were right for carburetor icing. The mechanic suggested running the engine with carburetor heat applied. The pilot did…Jun 12, 1982 · N8653Y · Substantial damageNTSB SEA82DA085Accident · No injuriesFinal reportBell 206B · Swan Valley, IDThe aircraft crashed during an external load operation at an elevation of about 6700 ft MSL in mountainous terrain. The pilot reported that the fuel gauge indicated 8 gallons remaining when he last checked it before the accident. Reportedly, he checked his…Jun 11, 1982 · N1074Z · Substantial damageNTSB MIA82DA133Accident · No injuriesFinal reportBell 47G-4 · N. Greenville, FLThe pilot took off at about 1922 to dispense a non-toxic liquid chemical and fertilizer on a nearby melon field. After one normal swath run on a northerly heading, he pulled up and began a procedure turn to the left (west). He stated the afternoon sun…Jun 11, 1982 · N1151W · Substantial damageNTSB ATL82FA161Accident · Serious injuriesField investigationFinal reportAerospatiale AS350D · Hazard, KYThe helicopter was on an aerial survey flight with 3 engineers on board. During the flight, the pilot was flying to various areas in response to commands from the observers (engineers). While responding to a command, the helicopter collided with an electrical…Jun 11, 1982 · N5781Z · DestroyedNTSB SEA82DA083Accident · Minor injuriesFinal reportGrumman G-164A · Dayton, WAThe pilot had just returned to the area after picking up a load of di-syston. Another ag aircraft had been spraying in an adjacent field. The pilot circled and looked for the other aircraft, but did not see it. He stated that he checked the smoke to determine…Jun 9, 1982 · N7365 · DestroyedNTSB NYC82DA121Accident · No injuriesFinal reportScheicher K8B · Shrewsbury, PAThe pilot was on a round robin, cross-country flight from woodbine, MD to Shrewsbury, PA and return. When he arrived over shewsbury, he maneuvered the glider to take a picture of his turn point. While taking the picture, he skidded the glider to include the…Jun 9, 1982 · N3353G · Substantial damage