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 DEN87FA216Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A · Bozeman, MT74-Year-OLD plt was performing aerobatics at small arpt for local tv news station to promote weekend airshow. Plt made right & left pass, each pass consisting of shallow descent, pullup from aprx 150 to 200 ft AGL, & slow roll. Plt began third pass from…Aug 13, 1987 · N313Y · DestroyedNTSB LAX87DUJ09Accident · No injuriesFinal reportPiper PA-25-235 · San Simon, AZDuring a pull up from an aerial application swath run, the aircraft struck a power line. The accident occurred during daylight in visual meteorological conditions.Aug 12, 1987 · N7328Z · Substantial damageNTSB FTW87DRD14Accident · No injuriesFinal reportGrumman G-164B · Oak Grove, LAAfter completing the last pass of an agricultural operation the pilot pulled up and started a turn. At this time the engine started shaking and losing power. The pilot attempted a forced landing in a soft field. The wheels bogged four or five inches into the…Aug 12, 1987 · N48614 · Substantial damageNTSB ATL87LA229Accident · Minor injuriesLimited investigationFinal reportBell 47G (TOM CAT) · Dothan, ALThe plt rprtd that while he was making a turn-around over trees after the 1st swath run, the helicopter enctrd a sudden wind change. He stated that the wind cond was from a cumulus buildup which put him in a tailwind situation. As he completed his turn with…Aug 10, 1987 · N10175 · Substantial damageNTSB LAX87FA300Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Springville, CAThe pilot was flying over sharply rising terrain in a canyon in a mountainous area. There was insufficient room in the canyon to manuever the aircraft. The pilot reported that he had maintained an airspeed just above a stall while attempting to fly through…Aug 9, 1987 · N80806 · DestroyedNTSB MKC87FA159Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Maquoketa, IAAfter departing the Maquoketa muni arpt, the acft was observed to fly at low altitude over some buildings that included a house & trailer home. As the acft flew over the property in a left banking turn, the left wing struck the top of a tree & then the acft…Aug 8, 1987 · N32619 · DestroyedNTSB ATL87DEK02Accident · 1 fatalFinal reportAllen Pitts Special S-1 · Lancaster, OHN52LA was being flown in a 2-acft acrobatic demonstration (demo). After takeoff, the plts bgn the demo by passing each other in a low alt knife edge maneuver over the rwy. After passing, they rolled inverted, until near the ends of the rwy, then rolled…Aug 8, 1987 · N52LA · DestroyedNTSB ANC87FA117Accident · 1 fatalField investigationFinal reportCessna 207 · Crooked Creek, AKThe acft overflew the destination due to fog. The station manager stated that after transmitting to the plt that the wx was 'zero zero', the plt stated that he would continue on to red devil and she heard it fly overhead. The first pieces of acft debris were…Aug 8, 1987 · N7371U · DestroyedNTSB LAX87LA295Accident · Serious injuriesLimited investigationFinal reportNorth American T-6G · Butte City, CADuring a local flight, a witness observed the acft making shallow right turns at aprx 100 ft AGL. The acft suddenly nosed down and collided with the terrain. Neither the plt nor the passenger remember what happened. Inspection of the engine revealed…Aug 6, 1987 · N8335H · DestroyedNTSB ANC87FA115Accident · 1 fatalField investigationFinal reportPiper PA-18A · Coldfoot, AKThe pilot had unsuccessfully attempted to fly through atigun pass earlier in the day. Even though the pass was closed due to fog and cloud cover, the pilot attempted to fly through the pass a second time. The aircraft wreckage was locatedin atigun pass. The…Aug 6, 1987 · N7479D · DestroyedNTSB LAX87DVD04Accident · No injuriesFinal reportHiller UH-23-D · Brentwood, CADuring an aerial application flight, the tail boom weight separated and contacted the tail rotor. The pilot lost control of the aircraft and collided with a tree and subsequently the terrain. Post acc invest revealed that the 'pip pins' which secure the tail…Aug 5, 1987 · N61PC · Substantial damageNTSB ANC87LA114Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Central, AKDuring an interview in the hospital with the passenger who was the pilot's son, he stated to the FAA inspector that his dad was low level flying when the aircraft struck a tree. The pilot lost control of the aircraft and crashed. At the time of the accident…Aug 5, 1987 · N2644G · Substantial damageNTSB DEN87DTG01Accident · No injuriesFinal reportCessna 188 · Valley City, NDThe plt rprtd the eng lost pwr drg a swath run & the acft was dmgd drg a forced lndg in a field of mature sunflowers. An exam of the acft revealed that both fuel tanks & the gascolater contained fuel. Subsequently, the eng was started at the acdnt site & it…Aug 4, 1987 · N3530Q · Substantial damageNTSB DEN87DTE03Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Springfield, COThe plt rprtd the eng lost pwr drg an aerial application flt & the acft nosed over drg a forced lndg in a soft, wet, terraced fld. There had been hvy rain on the previous day. An investigation revealed the acft had been refueled from a fuel tank mounted on a…Aug 4, 1987 · N8953H · Substantial damageNTSB MKC87LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-300 · Swea City, IAThe acft was engaged in ag spray operations near Swea City, Iowa. The PIC stated that he was making a procedure turn after a swath run. The PIC further stated that the acft stalled in the turn and the acft descended into the fld he had been spraying. The PIC…Aug 3, 1987 · N2338Y · Substantial damageNTSB SEA87FA152Accident · 4 fatalField investigationFinal reportCessna 172 · Pahrump, NVThe pilot entered a box canyon and attempted to either outclimb the terrain or reverse course. The aircraft's airspeed was allowed to decrease below vs and the aircraft stalled. A density altitude of approximately 9500 feet existed at the time. Insufficient…Aug 2, 1987 · N8696B · DestroyedNTSB NYC87LA216Accident · No injuriesLimited investigationFinal reportPiper PA-18S · Brewster, MAThe instructor (CFI) said that shortly after takeoff, the student was given a simulated power failure. At aprx 75' AGL, the student initiated a steep turn to head into the wind, which terminated in nearly a 90 deg heading change. The CFI stated the wind was…Aug 1, 1987 · N9075H · Substantial damageNTSB MIA87FA220Accident · 1 fatalField investigationFinal reportBuccaneer XA-430 · Lk Buena Vista, FLThe accident occurred while the acft was flying at an EST 800 to 1000 ft. persons on the grnd heard a bang, then looked up and saw the acft in a spin to the rt with the rt wing folded back over the fuselage. The acft hit the grnd in a near vertical attitude.…Aug 1, 1987 · N910DW · DestroyedNTSB LAX87FA286Accident · 2 fatalField investigationFinal reportLuscombe 8A · Oakdale, CAThe plt & his plt-rated wife (flying in their Luscombe) & another couple (in a rented Mooney) had dinner & drank wine. By about 0015 the couples had taken off in their respective acft for a return flt home and they had each other in sight. The couple in the…Aug 1, 1987 · N2098B · DestroyedNTSB FTW87FA184Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Imperial, TXAfter takeoff, the plt elected to fly low over a reservoir. He stated that as he began a pass, not FAR from the water's edge, the acft enctrd a sink. He said he ' . . . Checked power, all ok, plane just seemed to lose all lift . . .' Subsequently, the acft…Aug 1, 1987 · N5998Y · DestroyedNTSB SEA87LA151Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Plymouth, WADrg a swath run, a total loss of power occurred when the eng's #9 cylinder failed. The plt made a forced lndg in a soft potato field, but the acft nosed over after it slowed to about 20 KTS.Jul 31, 1987 · N4229X · Substantial damageNTSB MKC87LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Widener, ARThe ag airplane was making the final swath run over a cottonfield when the engine lost power. After touchdown in a ricefield, the airplane flipped forward to the inverted position. The reason for the power loss could not be determined.Jul 31, 1987 · N6568 · Substantial damageNTSB MKC87LA151Accident · No injuriesLimited investigationFinal reportCessna 150F · Bono, ARThe pilot said he had glided down to 500 feet AGL with the throttle reduced to idle trying to locate a landing strip. He said he applied power and the engine responded too late to avoid hitting a levee in the rice field and he flipped to the inverted position.Jul 31, 1987 · N8591G · Substantial damageNTSB DEN87FA203Accident · 1 fatalField investigationFinal reportCessna A188B · Kalispell, MTA Cessna ag wagon, N731SH, hit an electrical pwr line during a climbing turn while crop spraying. The acft was observed plummeting to the ground. The acft was substantially damaged and the plt received fatal injuries. The plt was climbing into the sun which…Jul 31, 1987 · N231SH · DestroyedNTSB MIA87LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pope, MSThe plt stated that after he made a swath run he was turning back for another run when the eng coughed & quit. He then landed in a field & on rollout he was closing in on some trees so he applied the brakes & the acft nosed over & came to rest inverted. Post…Jul 30, 1987 · N8102K · Substantial damageNTSB DEN87LA199Accident · Serious injuriesLimited investigationFinal reportBell 204B · Dubois, WYThe commercial plt was performing external sling loads in support of seismic operations. The plt reported that the engine failed during a load release and the plt executed an autorotation. This resulted in a hard landing in heavy timber on sloping terrain.…Jul 29, 1987 · N4580Y · Substantial damageNTSB ATL87FA223Accident · 2 fatalField investigationFinal reportCessna 150G · Circleville, OHAprx 35 min after the acft tkof, witnesses observed it in what they described as erratic flt. One witness rprtd the acftflew over a vacant field where it entered a steep climb, then stalled & impacted the gnd in a steep nose down attitude. No preimpact part…Jul 26, 1987 · N2476J · DestroyedNTSB ANC87LA113Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Happy Valley, AKThe aircraft struck the mountain at the 4000 foot level. At the time of the accident several witnesses stated that the weather was IFR, low ceiling, ground fog, and the prevailing visibility was less than one mile.Jul 26, 1987 · N5052C · DestroyedNTSB DEN87LA193Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Pisek, NDThe plt was preparing to spray a potato field with a mixture of water and 2 lbs of 'blight-out.' He made one observation pass over the field to check for obstructions and noticed two sets of power lines, one on the east side of a road and the other on the…Jul 25, 1987 · N2037J · DestroyedNTSB ATL87LA224Accident · No injuriesLimited investigationFinal reportCessna R182 · Calera, ALThe airplane collided with trees during a forced ldg attempt. The plt reported that he observed the fuel gauges indicating near empty shortly after departure. As he executed a 'steep' 180 deg turn back toward the arpt, the engine sputtered and 'quit'. During…Jul 25, 1987 · N737ZZ · Substantial damageNTSB ANC87LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot was reconnoitering for game animals when he overlooked the rising terrain until he could no longer outclimb or turn away from it. The acft collided with a large rock and came to rest in a grass area.Jul 24, 1987 · N2571H · Substantial damageNTSB ATL87LA222Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Huntsville, ALThe helicopter impacted the water during a low-altitude turn over a river. The plt made a low pass to the south over an island at about 30 ft AGL, to show the island to the policewoman/traffic observer onboard. As he was making a climbing right turn at about…Jul 23, 1987 · N972B · Substantial damageNTSB SEA87FA149Accident · 4 fatalField investigationFinal reportAero Commander 560-A · Ashland, ORThe non-instrument rated pilot took off in overcast weather conditions and flew toward a mountain pass that was obscured in clouds. When the flight failed to arrive at the destination, a search was initiated and the wreckage located in a box canyon on the…Jul 22, 1987 · N2794B · DestroyedNTSB FTW87DRG05Accident · No injuriesFinal reportAero Commander S2R · La Joya, TXDuring an aerial application flight at a low altitude the aircraft's engine failed. A forced landing was made to a grassfield resulting in substantial damage to the aircraft. Disassembly of the engine revealed partial failure of the left magneto. The aircraft…Jul 22, 1987 · N5510X · Substantial damageNTSB DEN87LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Romeo, COThe plt reports that the acft encountered a downdraft during the turn around following a swath run. The aircraft began to settle and collided with the ground, bounced, hit a second time and nosed over. The aircraft was loaded with 280 gals of amine and 70…Jul 22, 1987 · N5398 · Substantial damageNTSB MKC87DCQ03Accident · 1 fatalFinal reportPiper PA-36 · Nickerson, KSAfter a swath run to the east, the acft was observed to pull up & begin turning back to the west. The witness then saw a big cloud of smoke. She did not see spray coming from the acft drg the last swath run, although her vision was limitedby foliage & bldgs.…Jul 21, 1987 · N9935P · DestroyedNTSB FTW87DRG04Accident · Minor injuriesFinal reportAir Tractor AT301 · Santa Rosa, TXThe pilot was dusting a sugar cane field which bordered a dirt road with parallel electrical transmission lines. The pilot had been terminating his swath runs by flying underneath the electrical wires at the edge of the field. To prevent becoming a hazard to…Jul 21, 1987 · N4407S · DestroyedNTSB DEN87LA190Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Fargo, NDThe plt was spraying a field with orthine, used to exterminate grasshoppers. The plt said he was making his last pass at the field and was flying into a setting sun. He said he did not see the powerline. The acft struck the powerline and the plt made a crash…Jul 21, 1987 · N9750P · Substantial damageNTSB DEN87LA191Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Portales, NMThe plt was practicing aerial application maneuvers without chemicals onboard. During a turn, the plt reported that the engine lost power. The plt leveled the wings and lowered the nose to gain airspeed. The plt selected a landing site and after touchdown,…Jul 20, 1987 · N6419Z · Substantial damageNTSB CHI87DEM10Accident · Minor injuriesFinal reportPiper PA-25-235 · Marne, MIAt the end of a swath run while about one-third of the way through the procedure turn around, the engine suddenly lost power. The pilot extended his glide to clear powerlines and when he flared to land he did not have enough airspeed to stop the descent. The…Jul 20, 1987 · N8972Y · Substantial damageNTSB ANC87LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Lorraine Lake, AKThe pilot stated that he was flying a few feet above the trees when he flew into the water.Jul 19, 1987 · N5199P · Substantial damageNTSB ANC87FA101Accident · 1 fatalField investigationFinal reportCessna 185 · Hinchinbrook Is, AKAccording to witnesses the aircraft was low flying just above the tree level when the aircraft stalled and spun down into the trees.Jul 19, 1987 · N1744R · DestroyedNTSB MIA87LA209Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Swiftown, MSWhile spraying cotton, severe vibration was felt throughout the acft & the plt elected a forced ldg. During the flare, the throttle was advanced to raise the nose, & the plt discovered the eng had totally failed. The acft flipped inverted on touch down. An…Jul 18, 1987 · N7310N · Substantial damageNTSB LAX87LA272Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Perris, CAThe tow plt rprtd that drg takeoff, he felt the glider release at about 200' AGL. The purpose of the release was to practice a rope break. After being released, the glider maneuvered back toward the arpt, but it hit a tree & a power line before reaching the…Jul 18, 1987 · N125FD · Substantial damageNTSB CHI87DER10Accident · 1 fatalFinal reportAir Tractor AT-301 · Hollandale, MNAfter making a swath run the aircraft pulled up to clear power lines. Witnesses state that the engine cut out and aircraft pitched nose down and began to rotate. They state that the engine regained power just prior to impact. Subsequent investigation failed…Jul 18, 1987 · N3652N · Substantial damageNTSB MIA87LA208Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301 · Rolling Fork, MSDuring the swath run, the plt stated that the eng 'barked' once or twice just prior to impact with the trees. The acft hit the trees, rolled inverted & burst into flames. He stated that the seat belt & shoulder harness saved his life. The plt stated that he…Jul 17, 1987 · N2321V · DestroyedNTSB DEN87FA186Accident · 2 fatalField investigationFinal reportMooney M20E · Vail, COThe pilot proceeded up a box canyon while on a cross-country flight. When unable to out climb terrain, the pilot attempted to reverse direction. During the turn, the aircraft stalled and crashed into trees. The pilot had not received instruction in mountain…Jul 17, 1987 · N71SB · DestroyedNTSB FTW87DRA07Accident · Minor injuriesFinal reportAir Tractor AT-301 · Anahuac, TXThe acft was substantially damaged when it encountered soft terrain and flipped over during a forced landing. The forced landing was executed following a complete loss of eng power during a swath run on an aerial application flight. The cause of the eng…Jul 14, 1987 · N36503 · Substantial damageNTSB ANC87FA097Accident · 1 fatalField investigationFinal reportPiper PA-18 · Kasilof, AKThe student pilot and his non-pilot passenger/father were flying along a salt water beach looking for signs of a recent oil spill, when the pilot saw a fishing net in the water that he wanted a closer look at. He made two 180 degree turns at an altitude of…Jul 14, 1987 · N54106 · Substantial damageNTSB LAX87LA287Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103A · Maricopa, AZThe plt rprtd that after gliding in a sink for svrl minutes, he began flying about 500' above a north-south mtn ridge in search of lift. While on a northerly heading, the left wing rose & the plt interpreted this as lift. He turned to the left (west) which…Jul 13, 1987 · N103BG · Destroyed