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 FTW82DA172Accident · No injuriesFinal reportGrumman G164B · Marvell, ARDuring an aerial application process the pilot allowed the aircraft to collide with a rice levy. The aircraft was destroyed and there were no injuries to the pilot.May 11, 1982 · N6625K · DestroyedNTSB ATL82FLT04Accident · 3 fatalFinal reportPiper PA-32R-300 · Iuka, MSThe aircraft crashed during a pass across the airport. A witness was parked, facing east, in the runup area for runway 18. According to him, the the aircraft took off about 6 minutes earlier, made a traffic pattern, and crashed behind and to his right. The…May 11, 1982 · N444ME · DestroyedNTSB ANC82DAG21Accident · No injuriesFinal reportPiper J3C-75 · Soldotna, AKWhile executing departure stalls the elevator locked in the full up position. After several attempts to regain control, it was found that partial control was possible in a power off descending turn. This attitude was maintained until just prior to ground…May 11, 1982 · N27006 · Substantial damageNTSB NYC82DA089Accident · No injuriesFinal reportBell 47g-3b (Soloy Conversion) · New Hope, PAWhile making a cleanup swath around the bottom of a hill, the helicopter collided with wires. The pilot reported that he did not see the wires while holding his head in such a manner as to reduce the effect of sun-glare. After hitting the wires, the pilot…May 10, 1982 · N5449C · Substantial damageNTSB LAX82FVD16Accident · No injuriesFinal reportScorpion 133 · Fremont, CAThe student pilot, builder of the helicopter was on a dual instructional flight with an instructor pilot (ip). The student had about 71 hours in this make and model while the ip had 18 hours. After making two landings, a descending turn was made to a downwind…May 8, 1982 · N19NS · Substantial damageNTSB SEA82FYA07Accident · Serious injuriesFinal reportHughes 369HS · Gooding, IDWhile making a turn at the end of a swath run, the pilot heard a bang and then noticed a loss of engine power. He entered an autorotative landing from a low altitude at low airspeed. Subsequently, the helicopter landed hard and rolled over on its right side.…May 6, 1982 · N9184F · DestroyedNTSB FTW82FRJ10Accident · 1 fatalFinal reportContinental Tomcat MK6C · Cottonport, LAThe plt was familiarizing himself with the acft & the local area. The plt's log book showed only one hour of flt time logged between 9/23/81 & the date of the accident. Witnesses observed the acft flying for some time over the city at 300-400 ft AGL making…May 5, 1982 · N9098T · DestroyedNTSB FTW82FRD10Accident · 1 fatalFinal reportCessna 207 · Franklinton, LAThe passenger stated that after sharp turns at low altitude over a farm house they did a roll & were too low to recover prior to striking trees. The acft came to rest inverted in a 4-5 ft deep farm pond. The autopsy report shows the plt's death by asphyxia…May 5, 1982 · N73013 · Substantial damageNTSB CHI82DA150Accident · No injuriesFinal reportSikorsky S-55B · Otsego, OHThe pilot was spreading fertilizer by using external buckets. As he was unhooking a bucket, the engine lost power. He did a hovering autorotation, but the helicopter settled on a bucket, tipped over and allowed the main rotor blades to hit the ground. An…May 4, 1982 · N16861 · Substantial damageNTSB FTW82FRA20Accident · Serious injuriesFinal reportRockwell Intl S-2R · Alvin, TXThe pilot's father reported that he and his son were en route in separate aircraft to apply fertilizer to a rice field. He noticed his son dive from 500 ft to about 100 ft where the aircraft struck the top ground wires of a transmission line. The plane…May 3, 1982 · N8456V · DestroyedNTSB ATL82DA122Accident · No injuriesFinal reportPiper PA-25-235 · Greenwood, MSThe pilot smelled an odor similar to burning rubber followed by a loss of oil pressure. During the attempted forced landing the right wing contacted a fence causing substantial damage. Examination of the engine logbook reflected installation of new pistons,…May 3, 1982 · N8617L · Substantial damageNTSB FTW82FRJ11Accident · Serious injuriesFinal reportCessna 170B · Plain Dealing, LAThe aircraft was observed over a river at low altitude when it struck a powerline. The pilot was unable to recall anything about the flight after the takeoff. The passenger reported that they had flown to springhill to obtain 80 octane fuel, and while…May 2, 1982 · N1960C · DestroyedNTSB FTW82FQD11Accident · 2 fatalFinal reportPiper PA-28-140 · Mescalero, NMTwo witnesses observed the aircraft flying eastbound at low altitude along a highway, then begin a climbing turn over sharply rising terrain. After completing about 90 degrees of turn, the aircraft struck the tops of trees about 30 ft AGL. About 12 paces…May 2, 1982 · N1884J · DestroyedNTSB ATL82FKM03Accident · 1 fatalFinal reportHudson 2-2-2E · Statesville, NCWitnesses observed the pilot make a low pass parallel to runway 26, then pull-up sharply in a left climbing turn. The witnesses reported that after the pull-up, the left wing dropped and the aircraft entered a spin. The aircraft crashed about 1000 ft south of…May 2, 1982 · N1035G · Substantial damageNTSB ATL82FKG13Accident · 2 fatalFinal reportGreat Lakes 2T-1A-2 · Thomson, GAPrior to the accident, witnesses observed the aircraft while aerobatics were being performed. One witness estimated that the maneuvers were being flown between 100 and 300 yards AGL. Reportedly, the aircraft had been performing rolls, loops and spins for…May 2, 1982 · N3559L · DestroyedNTSB NYC82DHD11Accident · Minor injuriesFinal reportBell 47G · New Egypt, NJThe pilot stated that he was about to finish spraying the field and had only two passes remaining when the accident occurred. Passes were made to the north and south with the wind from the west at 5 to 10 knots. After completing a pass to the south, he pulled…May 1, 1982 · N1002P · DestroyedNTSB FTW82DA174Accident · No injuriesFinal reportBoeing E75 · Erick, OKThe pilot was pulling up from the swath run and collided with wires. The aircraft nosed over during the forced landing.May 1, 1982 · N5186N · DestroyedNTSB FTW82DA157Accident · No injuriesFinal reportCessna 150M · Harrison, ARThe pilot was performing a low, slow pass to make a bean bag drop on a taxiway target when he lost control, collided with a ditch and nosed over. The aircraft flipped inverted. The stall warning horn was sounding during the maneuver.May 1, 1982 · N704EY · Substantial damageNTSB CHI82FA141Accident · 2 fatalField investigationFinal reportCessna 152 · Kenosha, WIThe aircraft crashed in a steep nosed down attitude while the pilot and one passenger were on a local flight. Prior to the accident, witnesses observed the pilot practicing stalls below 1000 ft. no precrash failures were found. The last entry in the pilot's…Apr 29, 1982 · N48732 · DestroyedNTSB FTW82FRA19Accident · 1 fatalFinal reportBoeing A75 · Chapell Hill, TXDuring a pull-up from a swath run, the right wing of the aircraft struck the top of a 45 ft pecan tree. The lower right wing tip separated, and the aircraft rolled inverted and crashed.Apr 27, 1982 · N1774B · DestroyedNTSB DEN82DA073Accident · Minor injuriesFinal reportHughes 369D (500D) · Coalville, UTThe helicopter made a hard landing after the pilot experienced a power train failure while flying low and slow. The weather was VMC and a VFR flight plan was filed. The crew was searching for lost mining equipment in a low slow search pattern. The pilot heard…Apr 27, 1982 · N8684F · Substantial damageNTSB ATL82FKQ12Accident · 1 fatalFinal reportBell/Soloy 47G-3B · Magee, MSThe Bell 47G-3B with a Soloy conversion was being used to demonstrate an aerial application spraying technique for use along powerline right-of-ways. For about 15 to 20 minutes after takeoff, routine spray runs were made over several different powerlines…Apr 27, 1982 · N8469E · DestroyedNTSB MKC82FCD07Accident · 1 fatalFinal reportBellanca 8KCAB · Fairfield, IAThe pilot stated that he intended to fly down the runway to have a photographer take pictures to be used in publicity for airshows. After several passes (one inverted), the pilot landed to talk with the photographer. The photographer stated they agreed that a…Apr 26, 1982 · N5035N · Substantial damageNTSB SEA82DA058Accident · No injuriesFinal reportGrumman G-164A · S. Of Echo, ORDuring a spray run the pilot experienced a power loss. After pulling up to 100 feet AGL and turning 90 degrees the engine ceased to operate. The pilot completed a forced landing in a nearby soft wheat field and after rolling approximately 300 feet the…Apr 25, 1982 · N4897 · Substantial damageNTSB NYC82FHM06Accident · 1 fatalFinal reportSpezio Sport DAL-1 · Lagrange, NYThe owner/pilot of the aircraft was a photographer with an amputation above his left wrist. His class iii medical certificate stated that he must wear an artifical limb while flying. The pilot had been asked to photograph a building in an industrial park.…Apr 25, 1982 · N1796 · DestroyedNTSB CHI82FA135Accident · 2 fatalField investigationFinal reportDauntless D52 · Sebring, OHBoth wings separated during an experimental test flight of the motorized glider. The plt had indicated the tests would include climbing to a safe altitude & doing a few power-off shallow glides to see if there was any indication of flutter at perhaps max…Apr 25, 1982 · N1422D · DestroyedNTSB MIA82FKJ04Accident · 1 fatalFinal reportGrumman G-164 · Malone, FLAfter completing a spray run the aircraft was observed to pull up in a tight left turn striking a water tower approximately 5 feet from the top. The aircraft spiraled down and crashed approximately 135 feet from the base of the tower.Apr 23, 1982 · N6521K · DestroyedNTSB DEN82DA065Accident · No injuriesFinal reportPiper PA-18-180 · Savage, MTThe pilot reported that after takeoff, he remained at about 100 ft AGL and proceeded toward Savage, MT. He said he intended to fly over his partner's farm near Savage. Nearly 20 minutes after takeoff, a loss of engine RPM was noted as the pilot approached his…Apr 22, 1982 · N55WP · Substantial damageNTSB MKC82FA058Accident · 1 fatalField investigationFinal reportBeech B95 · Climax Springs, MOApproximately 8 min after takeoff the acft was observed at a very low altitude. It started a right turn that gradually steepened until the wings were almost vertical. After almost two turns the wings leveled for an instant, then the right wing & nose dropped…Apr 21, 1982 · N9639R · DestroyedNTSB MIA82FLD18Accident · Minor injuriesFinal reportSikorsky H-19A · Croom, FLThe pilot reported that he was spraying about 15 ft over a lake when the engine lost power. He entered an autorotation and ditched the helicopter in the lake. After recovery from the lake, a check of the engine revealed no precrash failures.Apr 21, 1982 · N15185 · Substantial damageNTSB MIA82DA105Accident · Minor injuriesFinal reportRobinson R-22 · Vero Beach, FLThe helicopter was air taxied to the fuel pump for refueling. The aircrew remained in the helicopter while the lineman serviced the fuel tank. After refueling and starting the engine, the instructor was at the controls while in close proximity of the pumps.…Apr 21, 1982 · N9033B · Substantial damageNTSB CHI82DA128Accident · Serious injuriesFinal reportPiper PA-32 · Brookfield, OHWitnesses observed the aircraft performing turns and rolls at an altitude of approximately 300 feet AGL. A decrease and subsequently an increase in engine power was heard. The aircraft was observed crashing into trees. Investigation revealed that the pilot…Apr 21, 1982 · N2477U · DestroyedNTSB DEN82FTC03Accident · Serious injuriesFinal reportAerospatiale SA315B · Big Piney, WYThe acft was engaged in seismic activity supplying explosives by long line. The eng failed at about 400-500 ft AGL. The load was released & an open field was selected. At about 150 ft AGL the plt was unable to maintain rotor RPM & the acft impacted the ground…Apr 20, 1982 · N9007N · DestroyedNTSB LAX82FVG20Accident · 1 fatalFinal reportSmith Miniplane DSA-1 · Chicago Park, CAThe aircraft crashed while the pilot was performing aerobatic maneuvers at low altitude. The impact occurred just below the top of a ridge at the edge of a valley as the pilot was completing a loop. He was performing the loop perpendicular to the ridge, and…Apr 18, 1982 · N103L · DestroyedNTSB LAX82FUQ13Accident · 1 fatalFinal reportCessna 150 · Santa Barbara, CAThe aircraft crashed in a wooded canyon area beneath the cold spring canyon arch bridge in los padres national forest. The plane impacted about 250 yards north of the bridge while on a northerly heading. Broken tree tops and branches were found over an area…Apr 18, 1982 · N66631 · DestroyedNTSB LAX82FXQ07Accident · 1 fatalFinal reportCessna 150 · Wadsworth, NVWhile flying over the truckee river on a local flight, the left wing of the aircraft struck a group of five powerlines. The aircraft then impacted the water in a nose down attitude. It was carried downstream about 100 yards by the current before coming to…Apr 17, 1982 · N7820F · DestroyedNTSB LAX82DA137Accident · No injuriesFinal reportAvres S-2R · Kettleman City, CAThe pilot stated that the fuel gauge was faulty so he flew by time. On the day of the accident the battery on the pilot's electric watch ran down. The pilot reported that the aircraft ran out of fuel and crashed in an open field with his watch still showing…Apr 16, 1982 · N5672X · Substantial damageNTSB LAX82DVA14Accident · Serious injuriesFinal reportHiller UH-12E · Chowchilla, CAThe pilot was conducting an aerial dusting operation over a grape vineyard. While on a swath run, he gradually converged on a powerline that crossed the field at a slight angle from his flight path. As he proceeded on his swath run, the helicopter got closer…Apr 15, 1982 · N67156 · DestroyedNTSB DEN82DA088Accident · Minor injuriesFinal reportAerospatiale SA315B · Thayne, WYThe helicopter was hovering to pick up a sling load when a loud bang was heard and the aircraft began to spin counter clockwise. Investigation revealed that the tail rotor drive shaft had broken. "Examination of the shaft break disclosed a small fracture…Apr 15, 1982 · N48089 · Substantial damageNTSB FTW82DA128Accident · No injuriesFinal reportGrumman G-164A · Victoria, ARThe pilot reported taking off with full tanks and about 1600 lbs of fertilizer. After takeoff, he flew a short distance to the field that was being worked and made one swath run. During a procedure turn close to trees, the aircraft stalled and crashed.Apr 13, 1982 · N9963 · DestroyedNTSB NYC82FGT13Accident · 1 fatalFinal reportCessna 182 · Catawissa, PAReportedly, the pilot departed the airport to accumulate time on a overhauled engine. The airport manager stated that shortly after takeoff, the pilot called on the UNICOM frequency that the engine and aircraft worked like new and he was completely satisfied…Apr 11, 1982 · N9227X · DestroyedNTSB LAX82DA133Accident · No injuriesFinal reportRobinson R-22 · Mesa, AZAfter landing in a practice area the instructor told the student to pick the helicopter up to a hover. The aircraft lifted off the ground to approximately 5 feet and yawed to the right 45 degrees. As the instructor applied left pedal and lowered collective…Apr 10, 1982 · N90736 · Substantial damageNTSB FTW82FA111Accident · No injuriesField investigationFinal reportPiper PA-23-150 · Newark, TXThe plt reported a loud bang was heard and he observed the left eng cowl raised to a vertical position & the eng drooped downward. The excessive amount of drag caused the acft to be uncontrollable. The plt was able to gain control of the acft by feathering…Apr 7, 1982 · N1196P · DestroyedNTSB SEA82DA045Accident · No injuriesFinal reportRockwell Intl. S-2R · Eureka, WAAfter spraying most of his load, the pilot made a dry pass and dropped a smoke flare. The flare was dropped to check the drift of the air relative to a susceptible crop east of the field being sprayed. After dropping the flare, the pilot made a 180 degree…Apr 5, 1982 · N8471V · Substantial damageNTSB NYC82FNC06Accident · 1 fatalFinal reportCessna 172 · Hampstead, NHSeveral witnesses observed the plane circling at low altitude before it crashed. A friend of the pilot reported that thepilot waved, gunned his engine a couple of times and waggled his tail. Witnesses stated that after making several circles at an altitude of…Apr 2, 1982 · N21869 · DestroyedNTSB FTW82FA110Accident · 3 fatalField investigationFinal reportMbb-Bolkow BO-105CBS · Mckinney, TXThe acft accelerated over the runway after a 10 sec hover. After acceleration, the acft went into a nose high, steep, right climbing turn. The angle of bank was described as 45 to 90 deg. The pitch varied from 15 deg up to 30 deg down just prior to impact.…Apr 2, 1982 · N112CF · DestroyedNTSB LAX82DA121Accident · No injuriesFinal reportCessna 150G · Tucson, AZDuring flight, the student pilot heard a loud noise from the engine and landed at a nearby airport. He reported that during the landing, a gust of wind was encountered, the left wing came up and the nose veered left. At that time, the right spindle attachment…Mar 28, 1982 · N4816X · Substantial damageNTSB DEN82DA050Accident · Serious injuriesFinal reportPiper PA-11 · Devils Lake, NDThe pilot and passenger/pilot were making low, slow passes over fisherman on the ice. The pilot reversed directions and the aircraft stalled. The pilot stated he was looking at the ground and became distracted.Mar 28, 1982 · N4709H · Substantial damageNTSB LAX82FVM13Accident · 4 fatalFinal reportStinson 108-2 · Morgan Hill, CAThe pilot was observed making repeated low passes in the vicinity of the crash site. This was also close to the home of one of the passengers. The final pass was made in a westerly direction over a dam at about 50 ft AGL. Just beyond the dam, the pilot made a…Mar 27, 1982 · N9455K · DestroyedNTSB LAX82FUG09Accident · Serious injuriesFinal reportFournier RF4D · Rialto, CAThe pilot reported that when the accident occurred, he was soaring his "motor-glider" in updrafts of "thermal, slope-wind, and wave" origin. He reported that thermals and a weak southwest wind were producing lift along ridges with walls that were facing west,…Mar 27, 1982 · N7719 · Substantial damage