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 NYC87FA101Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Locke, NYThe student pilot of the PA-140 was performing a solo x-country flight. He had made a fuel stop approx 20 mins prior to the crash. Witness observed an aircraft flying low and remarked that the engine sounded very loud just before crashing into an occupied…Mar 5, 1987 · N6489R · DestroyedNTSB MKC87LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Malden, MOThe acft was being used on training flt when the eng failed. During the forced landing in a muddy field, the acft flipped forward to an inverted position. Post accident inspection revealed the eng failed due to a connecting rod bolt failure on the number two…Mar 2, 1987 · N20362 · Substantial damageNTSB FTW87LA071Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Porter, TXAccording to the pilot, he was flying low over the san jacinto river, approximately 50 ft AGL. During a descending right turn the aircraft contacted a power line. The aircraft crashed into the river causing substantial damage to both wing spars and the…Mar 2, 1987 · N714KG · Substantial damageNTSB NYC87FA095Accident · 2 fatalField investigationFinal reportCessna 152C · Port Matilda, PAThe university student departed the university air park airport in state college, PA on a local flight in VFR weather conditions. The aircraft nosed into the ground in an approximate 70 degree dive about 10 minutes after takeoff. The pilot was engaged in low…Feb 22, 1987 · N757BQ · DestroyedNTSB MKC87FA051Accident · 1 fatalField investigationFinal reportPiper PA-18 · Venango, NEA witness saw the airplane fly over his property from the north to the south and he waved to the pilots. The airplane then came back toward the north at a low altitude and when the witness heard the power being applied, the left wing dropped and almost…Feb 22, 1987 · N9498D · DestroyedNTSB SEA87LA059Accident · No injuriesLimited investigationFinal reportBell 206B-III · Dayton, WAPlt lifted off with fertilizer bucket on 3-FT external hook. As fwd motion commenced, acft settled slightly, dragging bucket on ground and tipping it over. Plt attempted to recover by backing up, but skid caught on bucket, causing loss of control.Feb 20, 1987 · N90327 · DestroyedNTSB LAX87DVG02Accident · No injuriesFinal reportPiper PA-25-235 · Williams, CADuring an aerial application flt, the plt was paralleling a canal when the right wing became entangled in weeds and contacted the canal. The acft began a right turn when the acft slowed and the left main landing gear contacted the terrain. The acft nosed…Feb 15, 1987 · N7162Z · Substantial damageNTSB ANC87FA036Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Hay Stack Mt., AKThe pilot-in-command was maneuvering at the 2200 foot level of haystack mountain. He stated he was turning into the mountain at a steep angel of bank. While he was turning the airplane struck the trees. No mechanical irregularities were found during the on…Feb 15, 1987 · N1883G · Substantial damageNTSB ATL87FA071Accident · 1 fatalField investigationFinal reportHughes 269A · Buford, GAThe helicopter was observed to slow down over the parking lot then continued out over the lake. A puff of smoke was observed around the rear of the engine area and the helicopter fishtailed as it almost came to a stop then dropped into the water nose first.…Feb 13, 1987 · N3782B · DestroyedNTSB FTW87DPJ02Accident · Serious injuriesFinal reportAir Tractor AT-302 · Colony, OKDuring a downwind swath run the number one compressor bearing failed in the ltp 101-600-1A engine which resulted in the engine failing completely. During an attempt to turn into the wind for an emergency landing the left wing tip struck the ground and the…Feb 11, 1987 · N8864S · Substantial damageNTSB CHI87FA070Accident · 3 fatalField investigationFinal reportMooney M20J · Waskish, MNDuring the preflight wx briefing the non-instrument rated pilot was advised that VFR flight was not recommended. Shortly before the accident, the acft was observed flying over a state highway under a low overcast in poor visibility. The acft was witnessed to…Feb 8, 1987 · N11665 · DestroyedNTSB MKC87FA048Accident · 1 fatalField investigationFinal reportCessna A150K · West Memphis, ARThe airplane was making low passes over the edge of a trailer park and at the end of each pass, it would climb almost straight up and then make a steep banked turn and dive for another pass. At the end of the last pullup, the airplane made an abrupt steep…Feb 7, 1987 · N8459M · DestroyedNTSB ANC87LA034Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Paxson, AKThe pvt plt took off at night and flew into instrument conditions. He had failed to unlock the direction gyro until the acft entered the clouds. The acft crashed 32 miles from the departure point due to fuel exhaustion. Automotive fuel was being used in the…Feb 5, 1987 · N5312B · Substantial damageNTSB ANC87IA032Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Barter Island, AKThe pilot flew into rising terrain during a night VFR flight. After shutting down the right engine and achieving only partial propeller feather he elected to make a gear up landing. The plt was flying at 500 ft AGL when he wandered from over water to on-shore…Feb 4, 1987 · N35232 · Minor damageNTSB LAX87LA106Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Plaster City, CADuring a local business flight the pilot was flying low, approximately 50 ft AGL, and slow with 30 degrees of flaps extended to take aerial photographs of a motorcyclist on the ground. Upon completing a 360 degree turn to the left, the aircraft flew through…Feb 2, 1987 · N3441C · Substantial damageNTSB LAX87DJA04Accident · 1 fatalFinal reportGlaser-Dirks DG-400 · Dillingham, HIThe aircraft was observed flying over a ridge at a 'good rate of airspeed'. It turned back towards the ridge and collided with the terrain. There was a SIGMET in effect for moderate to severe turbulence. Investigation revealed no preimpact mechanical…Feb 2, 1987 · N104MN · DestroyedNTSB MKC87FA044Accident · 2 fatalField investigationFinal reportCessna 150D · Central City, NEAt about 0305 CST, witnesses in vehicles saw the acft lndg lgt as they were driving along a hwy. they rprtd the lgt was moving erratically as the acft was proceeding along the hwy at low alt. Subsequently, the acft struck a utility pole & power lines, then…Feb 1, 1987 · N4372U · DestroyedNTSB LAX87FA103Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Gualala, CAThe student plt, flying his own acft, took off under VFR conditions for an intended 45 min solo cross country flt. The plt encountered deteriorating wx & attempted to return to the departure airport. A witness observed the aircraft enter clouds, turn left &…Feb 1, 1987 · N75178 · DestroyedNTSB LAX87LA105Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58B · Los Angeles, CAA Sikorsky S-58B collided with a marked 253 ft AGL antenna tower (twr) while maneuvering over external load lift site. The plt indicated that he was sitting in the right seat of the acft in a right descending orbit conducting a site recon and that he was…Jan 31, 1987 · N5594C · Substantial damageNTSB ANC87FA033Accident · No injuriesField investigationFinal reportChampion 7EC · Kenai, AKThe pilot allowed the wing tip to descend into brush and willows while turning to avoid obscured sky conditions. The turn was downwind and the airplane stalled and struck the snow while skidding sideways.Jan 31, 1987 · N7539B · Substantial damageNTSB NYC87LA069Accident · No injuriesLimited investigationFinal reportHughes 269D · Antrim, NHDuring a practice hover, the pilot lost directional control and the helicopter pitched up at an angle of about 20-25 degrees causing the tail rotor to contact the snow. The aircraft was substantially damaged, but there were no injuries. The CFI stated that…Jan 28, 1987 · N3624J · Substantial damageNTSB LAX87FA101Accident · 2 fatalField investigationFinal reportMooney M20E · Dunsmuir, CADuring a pleasure flight, the airplane was seen flying low and disappeared into instrument meteorological conditions, consisting of low clouds, gusty winds and snow which lasted throughout the day. The airplane was found on the side of a hill in a descending…Jan 27, 1987 · N79366 · DestroyedNTSB SEA87LA048Accident · 2 fatalLimited investigationFinal reportMichael D. Mansfield KR-2 · Fallon, NVThe owner and an acquaintance, both commerically rated pilots, departed Fallon, Nevada, on a personal flight to a nearby town. Witnesses reported observing the aircraft engaged in maneuvers described as steep turns and sharp dives a short distance from the…Jan 25, 1987 · N66996 · DestroyedNTSB LAX87DJA03Accident · Serious injuriesFinal reportEmroth Emair MA-1B · Naalehu, HIDuring an aerial application flight, the aircraft was observed to make a downwind run when the pilot dumped the load collided with the terrain, become airborne and eventually collided with trees. Witnesses stated that they heard the engine running and that it…Jan 20, 1987 · N88896 · DestroyedNTSB DEN87FA043Accident · 1 fatalField investigationFinal reportAmerican Aerolights Falcon C · Albuquerque, NMAfter takeoff the plt initiated a steep nose up left climbing turn to approximately 300 ft AGL where the acft stalled. It entered a spin and descended in a nose down attitude until impact with the ground. The acft was destroyed and the student plt was fatally…Jan 18, 1987 · N918AA · DestroyedNTSB NYC87DHD04Accident · 1 fatalFinal reportMarrone VM-1 · Jobstown, NJThe plt was observed to make a low pass over the arpt, then cont beyond the departure end where the acft flew into a row of trees. Witnesses rprtd the sun was low & that the plt was flying toward the sun. Impact with the trees occurred about 1200 ft from the…Jan 17, 1987 · N4047A · DestroyedNTSB MIA87FA074Accident · 2 fatalField investigationFinal reportCessna 150L · Naranjito, PRThe pilot and passenger were reported to be on a personal flight during their lunch hour. They departed from isla grande airport and proceeded to a dirt airstrip at Naranjito, PR. At Naranjito, witnesses saw the airplane go into a low pass over the dirt…Jan 16, 1987 · N10103 · DestroyedNTSB LAX87FA096Accident · 2 fatalField investigationFinal reportMorrisey 2150A · Mt. Baldy, CADuring a local flt, the airplane was seen circling over a ridge four times. On the fifth pass, the airplane disappeared northbound into the clouds. A witness reported that at the time the mt tops were covered with fog and that blizzard conditions existed.…Jan 16, 1987 · N5138V · DestroyedNTSB DCA87MA018Accident · 10 fatalClass 1 · MajorFinal reportSwearingen SA-226TC · Kearns, UTThe two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the…Jan 15, 1987 · N163SW · 2 aircraft · DestroyedNTSB CHI87IA061Incident · No injuriesIncident investigationFinal reportNihon YS-11A-500 · Remmington, INThe flight crew failed to adhere to appropriate procedures and directives when they failed to select the HP cock levers to the hswl (lock out) position while performing an approach to landing stall during a training/test flight. When stall recovery was…Jan 13, 1987 · N906TC · Minor damageNTSB NYC87DHD02Accident · Serious injuriesFinal reportCessna 170 · Pittman, NJThe pilot stated that approx 15 mins after takeoff, while in a left turn, both he and his pax heard a loud snap. This was followed by collapse of the left rudder pedal and a right rolling motion. The aircraft began to spiral; just prior to impact the spiral…Jan 7, 1987 · N2528V · DestroyedNTSB LAX87FA077Accident · 1 fatalField investigationFinal reportCessna 182Q · Essex, CAUpon reaching his destination the pilot descended to make a message drop. He selected a flight path that was perpendicular to a 55 foot tall, unmarked, electrical power line. During the low pass for the drop the aircraft collided with the electrical wires.…Jan 7, 1987 · N28MB · DestroyedNTSB LAX87LA076Accident · 1 fatalLimited investigationFinal reportVarga 2150A · Hayward, CAAfter rtrng fm a flt, the plt took off again (using rwy 28L) & turned to the se. A witness (se of the arpt), said he sawthe acft at low alt (estd 100 to 200 ft) flying in his drctn. He noted no otr indcn of a problem until after the acft made a 'very sharp…Jan 5, 1987 · N5076V · Substantial damageNTSB FTW87FA043Accident · 1 fatalField investigationFinal reportMooney M20J · Gladewater, TXThe pilot departed into low overcast clouds (about 200 foot ceiling) with one to two miles visibility in light rain and fog. He did not file a flight plan although he was instrument rated. His currency for flight in instrument conditions are unknown.…Jan 3, 1987 · N201AV · DestroyedNTSB LAX87LA073Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Dimas, CAWitnesses rprtd the acft had circled the area 2 times at aprx 200' before it hit trees & crashed. Subsequently, it came to rest against a residence where the plt's sister lived. According to the plt, the eng started 'sputtering,' so he applied carb heat, but…Jan 1, 1987 · N5540H · Substantial damageNTSB ATL87FA052Accident · 2 fatalField investigationFinal reportCessna 150F · Newville, ALThe aircraft was observed flying at low levels during an orientation/pleasure flight for a friend's out-of-town relative visiting over the holidays. The professional military pilot had been checked out in the civilian Cessna 150 six weeks prior to the…Jan 1, 1987 · N8780S · DestroyedNTSB NYC87LA054Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fairfax, VTThe CFI reported that he had initiated a simulated eng failure for the student. The student responded properly to the simulated emergency and lined the acft up on an apch to a field. At 200 ft AGL, the student was instructed to go-around at which time full…Dec 30, 1986 · N94336 · DestroyedNTSB FTW87FA041Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Robertson, TXWitnesses stated that the aircraft was circling the top of a 94 ft tall oil well makeover rig when it descended below their line of sight. Another witness a mile away stated that the aircraft began spinning before ground impact. No evidence of any malfunction…Dec 30, 1986 · N9493L · DestroyedNTSB CHI87FA060Accident · 2 fatalField investigationFinal reportCessna 150L · Lakeview, MIWitnesses observed the aircraft buzzing a farm where a friend of the pilot resided. Following a low pass, the aircraft pulled up into a steep, left climbing turn. At the top of the climb, the nose dropped and the aircraft spiraled into the ground.Dec 30, 1986 · N6965G · DestroyedNTSB NYC87DNE01Accident · Serious injuriesFinal reportKosch Whitehead #21 · Stratford, CTThe experimental aircraft was making taxi tests on an abandoned taxiway when it became airborne. A photographer rushed out from a marked safety area directly in the flight path of the aircraft and was struck by the aircraft receiving a broken arm. The…Dec 29, 1986 · N1901G · Minor damageNTSB DEN87FA035Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Gilcrest, COThe plt made a low pass at aprx 200 ft AGL & waved at TW0 friends who were duck hunting. He then made a 2nd pass at aprx 150 ft & left the area. About 10 min later, the acft returned & was seen flying down a river at tree top level. The acft struck 3 of 4…Dec 27, 1986 · N78475 · DestroyedNTSB LAX87MA068Accident · No injuriesMajor investigationFinal reportPiper PA-28-181 · Long Beach, CAA Piper PA-28-161, N7646F, and a Mooney M-20K, N231LY, collided near pader intersection abt 16 miles southwest of lgb airport. Both airplanes were conducting instrument flight training and none of the occupants were injured. N231LY had conducted an ILS…Dec 26, 1986 · N7646F · 2 aircraft · Substantial damageNTSB FTW87FA037Accident · 1 fatalField investigationFinal reportCessna 150L · Altus, OKThe pilot was circling about 40-50 feet above the ground at a slow rate of airspeed while searching for a lost dog. He was using 10 degrees of flaps and most probably operating at a reduced power setting. Carburetor icing conditions were present and…Dec 26, 1986 · N18227 · DestroyedNTSB DEN87FA037Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Lewistown, MTOn the morning of the day of the accident the private plt/owner and his friend took off on an all day coyote hunting flt. When the acft failed to return that evening an air and ground search was begun. The burned wreckage of the acft was found 3 days later…Dec 26, 1986 · N6712L · Substantial damageNTSB FTW87LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Marble Falls, TXA pilot on a cross country flight in the local area at randolf afb, TX. Was flying low over the llano river about 50 ft. AGL and contacted a power line, substantially damaging the right wing. The pilot continued on to randolf afb and landed without incident.Dec 24, 1986 · N53384 · Substantial damageNTSB MKC87FA033Accident · 2 fatalField investigationFinal reportChampion 7ECA · Cambridge, NEThe low time PIC had been flying his acft over the farm land in search of coyotes. Several of the grd crew had flown as psngrs with him during the time period of this search. Witnesses stated that they saw the acft turn left and right as it was spotting the…Dec 21, 1986 · N2674G · Substantial damageNTSB FTW87DQA01Accident · 1 fatalFinal reportBeggs Pitts S-1 · El Paso, TXCommercial pilot practicing aerobatics in pitts S1 experimental homebuilt aircraft entered spin. Pilot failed to recover control of aircraft during descent. Aircraft impacted terrain approximately 1/2 mile south of west Texas airport near El Paso, TX.Dec 20, 1986 · N16GB · Substantial damageNTSB MKC87LA032Accident · No injuriesLimited investigationFinal reportCessna 172P · Pine Bluff, ARThe pilot stated he had flown over trees from the southeast and descended to 50 ft. upon seeing trees in front of the acft he turned left, away from the trees. The left wing touched the ground followed by the nose gear. The acft then flipped forward to the…Dec 14, 1986 · N75579 · Substantial damageNTSB ATL87LA044Accident · No injuriesLimited investigationFinal reportHughes 269C · Bowling Green, KYWhile hovering in a grassy area near the hangar facility, the pilot experienced a complete loss of flight control. The helicopter struck the ground and sustained substantial damage. The helicopter component examination failed to disclose any system…Dec 14, 1986 · N7416F · DestroyedNTSB ANC87LA020Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Willow, AKThe pilot stated that he had good ground visibility but suddenly flew into whiteout conditions losing ground reference. He stated that before realizing what had happened the acft struck the top of the mountian rigde.Dec 14, 1986 · N30814 · Substantial damage