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 LAX82DUJ30Accident · No injuriesFinal reportPiper 25 · Sacaton, AZDuring an aerial application procedure turn the aircraft's engine quit. The aircraft was crash landed in a field and was substantially damaged. Examination of the wreckage revealed there was no fuel in the fuel tanks and approximately one tablespoon of fuel…Mar 27, 1982 · N4929Y · Substantial damageNTSB MIA82DA087Accident · No injuriesFinal reportChampion 7GCBC · New Smyrna Beac, FLThe pilot reported that during a banner pick up, he missed the banner, and on climb out, he encounter windshear and stalled. The plane crashed before recovering from the stall. He reported that the wind was gusting to 20 knots.Mar 26, 1982 · N7552F · Substantial damageNTSB FTW82FRG27Accident · 1 fatalFinal reportBell 206 · Austin, TXDuring a low pass over lake Austin the aircraft collided with power cables about 300 feet above the lake. Witnesses reported two loud cracking sounds and that the helicopter pitched up and gyrated wildly then continued in the original direction of flight and…Mar 26, 1982 · N5739Y · DestroyedNTSB MKC82DA049Accident · No injuriesFinal reportCessna 172 · Jetmore, KSThe aircraft was flown out to an oil well site to air drop a valve. The pilot stated that after dropping the valve he turned around in his seat to see where the valve hit and he ran the aircraft into the ground.Mar 22, 1982 · N4915F · Substantial damageNTSB SEA82DA077Accident · No injuriesFinal reportRobinson R-22 · Hillsboro, ORThe instructor pilot was demonstrating a hovering autorotation to the student from approximately an 18 inch altitude. Shortly after touchdown, which was level and without movement in any direction, the aircraft started to roll to the left. The pilot reported…Mar 21, 1982 · N1KH · Substantial damageNTSB ATL82FLT03Accident · 1 fatalFinal reportCessna 172N · Greenfield, TNWitnesses reported that the aircraft crashed after the pilot had been making low passes for about 15 to 30 minutes. In the vicinity of a 30 ft pole, the pilot made a right turn and the aircraft struck the top of a 45 ft tree. The aircraft continued over a…Mar 20, 1982 · N737QS · DestroyedNTSB MIA82FA078Accident · 3 fatalField investigationFinal reportBeech F35 · Leesburg, FLThe pilot, who was a rock group driver, took an aircraft from the hangar without permission to joy ride members of the group. During the 2nd flight, the aircraft wing hit the bus during one of several low passes over the area. The aircraft then hit a tree and…Mar 19, 1982 · N567LT · DestroyedNTSB NYC82DA056Accident · Serious injuriesFinal reportBell 47J-2A · Emmaus, PAWhile maneuvering at approximately 200 feet AGL for an aerial photography mission a sudden and complete power failure occurred. The pilot initiated autorotation procedures and set a course for the only open area, a small field with a 15 degree upslope. A…Mar 18, 1982 · N8565F · Substantial damageNTSB FTW82FQG16Accident · 1 fatalFinal reportPiper PA-18-150 · Near Sterling C, TXThe student pilot departed his ranch strip reportedly to check on cattle. The plane crashed on rolling terrain in a nose down, left bank attitude and burned. There was no indication that the aircraft moved after impact. Both propeller blades were twisted and…Mar 17, 1982 · N82622 · DestroyedNTSB ATL82DA073Accident · No injuriesFinal reportHiller UH12E · Lydia, SCThe pilot was applying liquid fertilizer on his last swath run prior to reloading when the engine stopped. A run-on landing was attempted during which the skids sank into the soft ground causing the helicopter to roll over. The field was level and covered…Mar 17, 1982 · N4029R · Substantial damageNTSB NYC82DA054Accident · No injuriesFinal reportCessna 172 · Canastota, NYWhile on a local flight, the pilot made a low pass at a grass landing strip. During pull-up, the left wing hit the tops of trees and was damaged. The pilot maintained control and continued on the return flight. However, approaching the runway, he was unable…Mar 15, 1982 · N9243H · Substantial damageNTSB FTW82DA094Accident · No injuriesFinal reportGulfstream American G-164B · Holly Grove, ARThe agricultural pilot was aligning the aircraft to begin a swath run when the engine began to lose power. He noted a loss of manifold and oil pressure as well as black smoke from the exhaust. He turned away from the field and collided with trees rather than…Mar 15, 1982 · N8059K · Substantial damageNTSB ATL82FKQ11Accident · 1 fatalFinal reportCessna T188C · Mahew, MSDuring return flight to airport the pilot flew into a previously treated field for a cleanup swath run. Approximately 1700 feet from the south end of the field the aircraft collided with a 3-strand steel twisted cable powerline running east-west across the…Mar 14, 1982 · N2965J · DestroyedNTSB NYC82FA053Accident · 1 fatalField investigationFinal reportRobinson R22 · Spangler, PAThe helicopter struck a set of north-south powerlines while the pilot was patrolling a set of east-west powerlines. The powerlines being patrolled passed under the lines that were struck. The accident occurred over hilly, wooded terrain.Mar 12, 1982 · N9079M · DestroyedNTSB FTW82DA089Accident · No injuriesFinal reportRockwell S-2R · Oberlin, LAAs the pilot was completing a spray run, he started to close the hopper, but it felt to him that the handle had broken. He looked inside the cockpit momentarily. When he looked back outside, the aircraft had begun a descent. It was too close to the ground to…Mar 10, 1982 · N8466V · DestroyedNTSB CHI82IA082Incident · No injuriesIncident investigationFinal reportSwearingen SA-266TC · South Bend, INThe captain reported that at lift-off above VI speed, he heard a loud pop that sounded like a tire had failed. A "bright yellowish" illumination was then seen in front of the right engine. There was insufficient runway to abort, so the takeoff was continued.…Mar 10, 1982 · N323BA · Minor damageNTSB LAX82DA101Accident · No injuriesFinal reportBeech V35B · Taft, CAThe aircraft made contact with an antenna during a low pass over a job site. The windshield shattered and the engine stalled forcing the pilot to make an emergency landing.Mar 9, 1982 · N7266R · Substantial damageNTSB LAX82DA100Accident · No injuriesFinal reportHiller 12E · Delano, CADuring the spraying operation of a field border the helicopter main rotor blades came in contact with power lines. The loose wire wrapped around the ballast arms and the landing was accomplished with cyclic steering only.Mar 9, 1982 · N99242 · Substantial damageNTSB DEN82DA040Accident · Serious injuriesFinal reportBell 206B III · Trenton, NDThe aircraft was hovering during a sling load operation when the engine lost power. The pilot released the load but due to low rotor RPM the aircraft landed hard, substantially damaging the aircraft. Investigaton revealed a failure of the forward male splines…Mar 7, 1982 · N16867 · Substantial damageNTSB LAX82DA091Accident · No injuriesFinal reportBeech B35 · La Jolla, CADuring flight over the water, the engine lost power and the pilot was unable to glide to a safe landing area on shore. The plane was ditched in the pacific ocean about 1/4 mile from the shore.Mar 4, 1982 · N180L · DestroyedNTSB FTW82FQG15Accident · 1 fatalFinal reportPiper PA-36 · Floydada, TXThe aircraft crashed about 500 ft north of the field that was being sprayed. After impact, it traveled about 90 ft on a heading of 060 degrees. Green glass fragments were found at the initial impact point as well as propeller slash marks that were nearby. No…Mar 4, 1982 · N2394Y · DestroyedNTSB NYC82FGT08Accident · 2 fatalFinal reportCessna A152 · Scotland, PAThe aircraft crashed after the pilot made a low pass over runway 13. At the departure end of the runway, the aircraft was observed to pull up into a 40 to 45 degree climb, then stall and enter a spin. It crashed in a near vertical descent.Mar 2, 1982 · N7378L · DestroyedNTSB FTW82DA082Accident · No injuriesFinal reportStarduster II · Taylor, TXDuring a slow roll to the left, the aircraft developed a high rate of descent. The roll was completed just before ground impact which demolished the aircraft.Mar 1, 1982 · N2361 · Substantial damageNTSB ATL82DA062Accident · 1 fatalFinal reportPiper PA-25-235 · Griffin, GAThe pilot was hired to perform for the filming of an agricultural spraying operation. During one of the low passes the aircraft struck two of the ground crew. The cameraman received fatal injuries. Pieces of the wooden propeller, used to drive the spray pump,…Mar 1, 1982 · N4732Y · Minor damageNTSB FTW82DPM10Accident · Serious injuriesFinal reportCessna 140A · Wagoner, OKDuring a low pass over a river, the aircraft struck some power lines approximately 125 ft above the water level.Feb 28, 1982 · N9688A · Substantial damageNTSB FTW82DA077Accident · No injuriesFinal reportCessna 152 · Arkadelphia, ARThe pilot elected to practice a forced landing pattern to a large rice field. As he passed over a stand of pine trees on final approach, he heard a loud thump. He increased power and returned to the airport. En route, he noted a dent on the leading edge of…Feb 28, 1982 · N4912H · Substantial damageNTSB SEA82FYK08Accident · Minor injuriesFinal reportKaman HH-43F · Sutherlin, ORThe helicopter was being used on a logging operation. After releasing a load from a hover out of ground effect, the pilot began to turn and accelerate. About two-thirds to three-fourths of the way through a 180 degree turn, the aircraft began a sudden, very…Feb 22, 1982 · N4524 · DestroyedNTSB LAX82FVM12Accident · Minor injuriesFinal reportPitts 51 · Morgan Hill, CAWhile performing acrobatic maneuvers the pilot noticed smokeand oil streaming back from the engine and a loss of oil pressure. He throttled back immediately and started a descent towards a vacant field. In an attempt to clear some telephone lines in his path…Feb 21, 1982 · N8WA · DestroyedNTSB FTW82FRJ08Accident · 2 fatalFinal reportBellanca 7GCBC · Near Texarkana, ARDuring flight, the aircraft struck a powerline about 70 ft above the red river. The aircraft crashed in the river and drifted about 2 miles before it was recovered. The passenger's body was recovered on 03/21/82 and the pilot's body was recovered on 05/15/83…Feb 21, 1982 · N53731 · Substantial damageNTSB FTW82FQA14Accident · 2 fatalFinal reportCessna 182Q · Fort Sumner, NMThe plane crashed and burned on a dark moonless night after impacting in a nose low attitude. The crash site was located near the home of the pilot's friend where the pilot had visited earlier in the evening. After impacting in soft, level, sandy soil, the…Feb 20, 1982 · N759QR · DestroyedNTSB FTW82FPD09Accident · 1 fatalFinal reportPiper PA-36-375 · Saint Jo, TXAfter taking off to the south, the plane was observed to climb to about 300 ft AGL, then turn to the southwest. P0WER was reduced, and within three to five miles, the aircraft was turned back toward the airstrip. While approaching the airstrip at about 500 ft…Feb 20, 1982 · N3802E · DestroyedNTSB FTW82DA063Accident · No injuriesFinal reportCessna 140 · Krotz Springs, LADuring the power recovery from a simulated forced landing to a railroad right-of-way the aircraft struck four strands of telephone wire which ran perpendicular to the tracks. The aircraft was landed at a nearby airport where post-flight inspection revealed…Feb 20, 1982 · N77029 · Substantial damageNTSB NYC82FNC04Accident · 1 fatalFinal reportAeronca 7EC · New Gloucester, METhe pilot flew the ski equipped aircraft to a frozen lake where he met two friends who were ice fishing. Later, after he visited with his friends and had given each of them a ride in the aircraft, the pilot took off again. After takeoff, the pilot turned back…Feb 14, 1982 · N4393C · DestroyedNTSB FTW82FRG22Accident · 1 fatalFinal reportBeech V35A · Cibolo, TXBefore starting the flight, the pilot was involved in an automobile accident. He called an employee and asked to be picked up. The employee reported that the pilot was drinking when he arrived. The pilot insisted on going to the airport to get keys from his…Feb 10, 1982 · N7148N · DestroyedNTSB SEA82DA025Accident · No injuriesFinal reportCessna 150J · Nr. Colbert, WADuring flight, the instructor asked the student to perfrom a power-off approach-to-landing stall. The student began the maneuver at about 4600 ft with the carburetor heat on. During recovery, he abruptly advanced the throttle and the engine began to lose…Feb 3, 1982 · N5527G · Substantial damageNTSB FTW82FQG14Accident · 2 fatalFinal reportCessna 182 · Pampa, TXN58947 was purchased by the pilot the day of the accident. According to a flight instructor who sold the aircraft, the pilot received dual instruction for a checkout in the aircraft and currency for night flight. According to witnesses, the pilot did not…Feb 1, 1982 · N58947 · DestroyedNTSB DEN82DA025Accident · No injuriesFinal reportCessna 172 · Near Gillete, WYThe purpose of the flight was to make an aerial survey for livestock. During flight, the observer noted some cattle in a cove. The pilot then turned and descended to about 100 feet AGL. After leveling, he noted that he would have to climb or turn to avoid…Jan 29, 1982 · N758RD · Substantial damageNTSB ATL82FLG10Accident · 1 fatalFinal reportCessna 150 · Darlington, SCWitnesses observed the aircraft performing aerobatic type of manuevers before entering a spin and crashing into a field. Although the pilot was known never to drink alcoholic beverages before flying, the pilot's blood alcohol level was 266MG/DL.Jan 29, 1982 · N1434Q · DestroyedNTSB LAX82FA061Accident · 1 fatalField investigationFinal reportBell UH1B · Lagunitas, CAHelicopter crashed into a reservoir and sank in 60 feet of water after tail boom separated during a log slinging operation. The pilot had lifted and began to back up when a loud noise was heard and the tail separated. The log was released and an auto-rotation…Jan 27, 1982 · N96142 · DestroyedNTSB FTW82FPM09Accident · Serious injuriesFinal reportCessna A188B · Muskogee, OKThe pilot made two passes to survey the field to be sprayed. He stated that on his third pass, he pulled up, made a shallow left turn, leveled off, and started looking to the right for obstructions. Reportedly, the aircraft started into a 10 degree dive at…Jan 26, 1982 · N9413G · DestroyedNTSB LAX82DA051Accident · No injuriesFinal reportBell 47G-2 · Watsonville, CADuring a preceding spray operation, the pilot noted that some of the spray nozzles were not functioning properly. He flushed the tanks with fresh water and partially refilled them with water to perform an airborne nozzle check. While performing the check at…Jan 23, 1982 · N10194 · Substantial damageNTSB SEA82DA020Accident · No injuriesFinal reportSikorsky S-58J · Near Kingston, IDThe aircraft was engaged in logging operations. While in a hover to pick up a second load of logs, the engine lost power. An autorotation was made into a creek bed. An inspection revealed that snow and water from the cabin interior had penetrated the cabin…Jan 22, 1982 · N97AR · Substantial damageNTSB LAX82FUJ25Accident · Serious injuriesFinal reportPiper PA-23-250 · Bagdad, AZThe pilot attempted to fly from phoenix to Bagdad, AZ under a low overcast. When it became obvious that weather conditions were too poor for a landing the pilot attempted to reverse direction and the aircraft struck high terrain.Jan 21, 1982 · N40291 · DestroyedNTSB FTW82FPJ12Accident · 2 fatalFinal reportBeech G35 · Stillwater, OKThe aircraft departed on a dark night with no record of a flight plan filed or a weather briefing received. Witnesses observed the aircraft climb out of sight into a fog layer when 2/3 down the runway then reappear and continue to fly at tree top level…Jan 20, 1982 · N4438D · DestroyedNTSB LAX82FUQ08Accident · 1 fatalFinal reportBede BD-5B · Mojave, CAAfter takeoff the amateur built Bede-5 entered left traffic and circled the airport once at 700 to 1000 feet AGL. During the second 180 degree turn from the downwind leg to the runway heading a witness reported that the bank angle suddenly increased and the…Jan 17, 1982 · N381JH · DestroyedNTSB DEN82FA020Accident · Minor injuriesField investigationFinal reportPiper PA-31T · Delta, UTApproximately 1/2 mi from the arpt after takeoff, the plt noticed the left front baggage door partly open & made a left turn back toward the airstrip. After the turn, the baggage door came completely open, the left wing dropped immediately & the acft stalled.…Jan 17, 1982 · N91TW · DestroyedNTSB DEN82DA019Accident · No injuriesFinal reportCessna 180E · Cedar City, UTThe pilot stated that he intended to fly close to the field surface dragging the tailwheel of the aircraft to determine snow/field conditions. During the low pass he used three notches of flap and added full power with the propeller at full pitch. When the…Jan 17, 1982 · N2600Y · Substantial damageNTSB ATL82DA036Accident · No injuriesFinal reportBell 206B · Centerville, ALThe mishap occurred during a practice hover with a 100 ft cable in preparation for an external load operation. While hovering about 100 ft AGL, the fuel boost pump light illuminated and the boost pump pressure dropped to zero. A descent was started; however,…Jan 17, 1982 · N203AL · Substantial damageNTSB LAX82DA035Accident · Minor injuriesFinal reportBellanca 7GCBC · San Clementine, CADuring flight, the pilot observed an area of sloping terrain that appealed to him as a prospective piece of land to purchase. He stated that he got too low and slow with the sun in his eyes as he circled the area. The right wing struck the ground and the…Jan 4, 1982 · N8630V · Substantial damageNTSB FTW82FPG06Accident · 1 fatalClosedPiper J3C-65 · Star City, ARDec 26, 1981 · N20886 · Substantial damage