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 FTW82FRG36Accident · Serious injuriesFinal reportPiper 25-235 · Hondo, TXOn the second pass spraying sodium chloride the aircraft struck the top portion of a line of oak trees when pulling out of a field. The aircraft then collided with a tv antenna and another tree before contacting the ground.Jun 8, 1982 · N7344Z · DestroyedNTSB FTW82FPD12Accident · 1 fatalFinal reportCessna 150 · Graham, TXThe aircraft was being used on a pipeline patrol mission. The pilot informed the pipeline ground crew of a pipeline leak and circled the area. The aircraft was observed by the ground crew to making a wide circle at about 100 ft AGL when it abruptly went into…Jun 8, 1982 · N6742G · DestroyedNTSB FTW82DA216Accident · No injuriesFinal reportCessna A188B · Gould, ARThe pilot stated that there were trees on the east end of the field that he was fertilizing and the wind was from the southwest at 15, gusting 20 KTS. The temperature was about 90 degrees. The pilot reported that when he was turning to go into the field, a…Jun 8, 1982 · N731MZ · Substantial damageNTSB DEN82DTG05Accident · No injuriesFinal reportCessna 188 · Devils Lake, NDThe pilot started a swath run at dusk by crossing under a set of wires. As he crossed under the wires, one of his main gear struck the top of a rock pile. The pilot thought that both of the main gear had failed, and he elected to make a belly landing in a…Jun 8, 1982 · N2087J · Substantial damageNTSB MKC82DA098Accident · No injuriesFinal reportWeatherly 201A · Bronson, KSThe pilot reported that he was spraying over rolling terrain that was covered with trees. While on his last pass, he struck the top of a tree with his left wing. The aircraft became difficult to control, and the pilot elected to make a precautionary landing.…Jun 7, 1982 · N2934W · Substantial damageNTSB LAX82DVG26Accident · No injuriesFinal reportGrumman G-164 · Williams, CAThe pilot was applying a granular herbicide to a rice field with low voltage wires on the west border and high voltage lines located diagonally across the field. During a pass from west to east, he crossed over the low voltage wires and lowered the nose to…Jun 7, 1982 · N641U · DestroyedNTSB ATL82FLA03Accident · 2 fatalFinal reportCessna 172M · Thomasville, GAThe aircraft was being operated on a business flight for the purpose of surveying farm crops in the area. At about 1700 EDT, it crashed into a 20 acre farm lake while on a westerly heading. The weather was reported as clear, visibility 6 to 7 miles with haze,…Jun 7, 1982 · N13687 · DestroyedNTSB DEN82DTI14Accident · No injuriesFinal reportStarke KR-2 · Wolf Creek, MTWhile flying at a low altitude over the Missouri river the aircraft collided with a powerline damaging the propeller and cowling. The pilot used ground transportation to pickup a new propeller. He repaired the aircraft, surveyed the takeoff area and attempted…Jun 6, 1982 · N2AL · Substantial damageNTSB LAX82FA213Accident · 2 fatalField investigationFinal reportCessna 172L · Meiners Oaks, CAWitnesses in a remote canyon reported an aircraft making low passes in that area. They last saw the plane going up the canyon. Later, the aircraft was located on a wall of the same canyon. Tests of the pilot's blood showed an alcohol level of .279 percent.…Jun 5, 1982 · N19659 · DestroyedNTSB FTW82FRD14Accident · No injuriesFinal reportGrumman G-164A · Kaplan, LAThe operator reported that the pilot was making a left turn to line up with the flagman when the aircraft stalled and went down into trees. The temperature was reported to be 95 deg. There was no mention of injuries in the operator's accident report…Jun 5, 1982 · N5261 · DestroyedNTSB FTW82FRG35Accident · Minor injuriesFinal reportPiper PA-18A · San Marcos, TXThe pilot was on a flight to spray his own farm. While maneuvering during aerial application, the left wing tip struck a telephone guy wire and then the plane crashed. The pilot had been spraying his own farm over the previous 10 yrs with the same telephone…Jun 4, 1982 · N3590P · DestroyedNTSB ATL82FA153Accident · 1 fatalField investigationFinal reportCessna 172M · Alabaster, ALAt 0755, the plt contacted birmingham approach control & reported 35 mi south at 2,000 ft. he was advised of the bhm wx & that it was IFR at the arpt. The pilot stated he would like to land at another arpt & was given his approximate position to three arpts.…Jun 4, 1982 · N5443H · DestroyedNTSB DEN82FTM13Accident · Serious injuriesFinal reportAerospatiale 315B · Coalville, UTDuring a seismic exploration flight the eng quit. No eng malfunction was found.Jun 3, 1982 · N8237 · Substantial damageNTSB ATL82DKQ14Accident · Serious injuriesFinal reportCessna A188B · Boyle, MSThe pilot reported that he had begun a swath run with a fresh load of fertilizer when the aircraft struck a wire. He stated that this was the top wire of an extremely high set. The wires ran diagonally across the southeast corner of the rice field that he was…Jun 3, 1982 · N731MM · DestroyedNTSB SEA82DA080Accident · No injuriesFinal reportEagle DW-1 · Sprague, WAThe pilot had checked out in this make and model of aircraft on the preceeding day. On the day of the accident, he was spraying fertizer in a crosswind condition. He stated that he was on a downhill swath run in gusty conditions when he deployed the controls…Jun 1, 1982 · N88012 · DestroyedNTSB MKC82DA093Accident · Minor injuriesFinal reportGrumman G-164A · Red Cloud, NEThe aircraft struck the top wire of an electrical transmission line and crashed. The pilot reported that he misjudged the "wire distance" as he let down over a pond to begin a swath run. The pond was at the edge of the field that he was seeding. The pilot…Jun 1, 1982 · N5253 · DestroyedNTSB MKC82DA092Accident · No injuriesFinal reportCessna 188B · Thornton, IAWhile spraying a corn field, the pilot crossed under a powerline at the north end of the field. While passing beneath the lines, his left wing tip struck the bottom wire. The pilot reported that he lost aileron control and landed in a corn field with no…Jun 1, 1982 · N21722 · Substantial damageNTSB FTW82DA205Accident · No injuriesFinal reportGrumman G-164A · Angleton, TXWhile concentrating on his flagger, the pilot misjudged his altitude and allowed the aircraft to collide with a levee. The pilot then dumped his load and made an emergency landing, during which time, the aircraft nosed over.Jun 1, 1982 · N8974H · DestroyedNTSB DEN82FTA10Accident · Serious injuriesFinal reportPiper PA-25-235 · Glendive, MTThe pilot reported that he had just loaded the sprayer and had made one pass downhill. At the end of the field, he started a left turn to make an uphill pass. The pilot stated that he got into bad air or down slope air and started to dump the chemical but it…Jun 1, 1982 · N4589Y · DestroyedNTSB DEN82DTK05Accident · No injuriesFinal reportGrumman G-164 · Murdo, SDDuring a spraying operation the landing gear collided with a dirt bank. The pilot returned to the airport and during landing the right wing contacted the runway because of a missing right landing gear. The aircraft ground looped and nosed over.Jun 1, 1982 · N10247 · Substantial damageNTSB SEA82DYE07Accident · 1 fatalFinal reportStarduster TOO SA300 · Sequim Bay, WAWhile flying over a lake at low altitude, the left wing of the aircraft struck wires on a moored sailboat about 50 ft above the water level. Three witnesses report that just prior to the collision, the pilot dipped or wagged his wings and waved at them. After…May 31, 1982 · N15DK · DestroyedNTSB DEN82FA099Accident · 4 fatalField investigationFinal reportCessna 172N · Orem, UTPrior to the accident, the student pilot was observed performing power-on stalls at low altitude with passengers on board. The stalls were being made toward rapidly rising terrain in a mountainous area. After the last recovery, the aircraft was observed…May 31, 1982 · N5380D · Substantial damageNTSB CHI82DA195Accident · Minor injuriesFinal reportGrumman AA1B · Chesterland, OHThe aircraft collided with trees during low flight maneuvering. The aircraft then collided with terrain and was destroyed. The pilot and passenger received minor injuries.May 31, 1982 · N1631R · DestroyedNTSB ATL82FID09Accident · Minor injuriesFinal reportMignet HM293 · Radford, VADuring flight, the pilot began flying over a river in his homebuilt HM293 "flea." He reported that he had started a right turn and was looking for a bridge when the left wing tip struck wires. The wires were part of a railway signal line that crossed the…May 30, 1982 · N2931 · Substantial damageNTSB ANC82DAG28Accident · 1 fatalFinal reportPiper PA-18 · Kenai, AKPilot was giving passengers rides along bishop creek. He was reported as flying low and erratic. On the last flight with two passengers, the wing dipped & caught the water. The acft then cartwheeled. The plt's blood alcohol level was 196 mg%.May 30, 1982 · N9089D · DestroyedNTSB FTW82DA199Accident · No injuriesFinal reportAir Tractor AT 301 · Eakly, OKThe pilot stated that as he pulled up from a swath run the engine started missing. He then elected to attempt a return to his departure airstrip. While turning toward the field the engine started making a loud noise and lost power. During the forced landing…May 29, 1982 · N3653F · Substantial damageNTSB CHI82DA196Accident · No injuriesFinal reportBell 47D1 · Le Sueur, MNDuring a spraying operation, the aircraft was being refueled from a 200 gal fuel tank, mounted on the rear of a truck. The truck was parked on a slight slope with the outlet for the servicing hose at the lower end. After the helicopter was serviced with 14…May 29, 1982 · N4251A · Substantial damageNTSB DEN82FTK04Accident · No injuriesFinal reportCallair A-9B · Sioux Falls, SDThe eng quit & the plt landed in an adjacent field after first hitting a wooded fence. An inspectin of the bendix fuel servo unit, model PSA-10ED-1, revealed that the fuel diaphragm stem, pn 2539806, had failed.May 27, 1982 · N7769V · Substantial damageNTSB DEN82FTC04Accident · 1 fatalFinal reportCessna 172P · Osage, WYThe aircraft departed gillette, Wyoming on a pipeline patrol mission. This was the pilot's first pipeline patrol over the line that he was patrolling. During the flight, the aircraft struck three powerlines and crashed. The passenger stated that he saw the…May 27, 1982 · N64093 · DestroyedNTSB CHI82FA186Accident · 2 fatalField investigationFinal reportCessna 172N · Milford, MIEarlier in the evening during a return flt from london, ontario to pontiac, MI the plt became disoriented & was radar vectored to detroit city arpt, the only arpt reporting VMC. The plt landed at about 2208. After landing the plt received two wx briefings at…May 27, 1982 · N4967G · DestroyedNTSB LAX82DA194Accident · Minor injuriesFinal reportGrumman G-164A · Woodland, CAThe aircraft collided with wires and crashed during a crop dusting operation. The aircraft hit wires during a turn at the end of a swath run.May 26, 1982 · N8388 · DestroyedNTSB FTW82DA196Accident · No injuriesFinal reportCessna A188B · Mangham, LAWhile turning to begin a swath run at about 200 ft AGL, a propeller blade failed and separated. Subsequently, the engine began a severe vibration and also separated. Oil covered the windshield and prevented forward visibility. The pilot reported that he was…May 26, 1982 · N6303G · DestroyedNTSB LAX82DA193Accident · Serious injuriesFinal reportCessna A188 · Ehrenberg, AZThe pilot stated that as he pulled up at the end of a trim run in order to miss some electric wires the aircraft began to shutter. It then rolled left, right, and back to the left going almost inverted before coming to rest in a cotton field.May 25, 1982 · N70454 · DestroyedNTSB LAX82DVG25Accident · Serious injuriesFinal reportGrumman G-164 · Richvale, CADuring a procedure turn of the swath run the pilot stated he was low and slow and collided with powerlines. The aircraft crashed and burned.May 24, 1982 · N10225 · DestroyedNTSB FTW82FPG12Accident · 1 fatalFinal reportGrumman G-164 · Ethel, ARThe acft collided with power lines during the start of a swath run.May 24, 1982 · N5376 · DestroyedNTSB CHI82FER18Accident · 1 fatalFinal reportAeronca 65-TF · Staples, MNThe pilot was making low passes over a river in search of a drowned man. He made a steep right turn and the aircraft stalled, dove into trees and impacted the ground nose first. The pilot stated the aircraft's door had been removed and that the aircraft had…May 23, 1982 · N31765 · Substantial damageNTSB LAX82FXQ08Accident · 2 fatalFinal reportPiper 18-150 · Tahoe City, CAThe float equipped aircraft departed on a local photography mission. The passenger wanted to take aerial photographs of the city area. After flying around the area for about 25 minutes, the aircraft crashed on a street. A witness observed the aircraft flying…May 22, 1982 · N2881P · DestroyedNTSB LAX82DXQ10Accident · 1 fatalFinal reportBroyill-Cowan-Murray BG12B · Yerington, NVAt about 1315 PDT, the pilot departed on a round robin cross-country flight from minden, Nevada to bridgeport California and return. He was participating in a region ii soaring championship (sport class). On the return leg of the trip, the pilot was oserved…May 22, 1982 · N612BG · DestroyedNTSB DEN82DTG04Accident · No injuriesFinal reportBoeing A75N1 · Northwood, NDThe pilot was on a flight to practice aerial application. This was his first flight in this make and model of aircraft. While making a practice run over an open field with water in the chemical tanks, the left main gear contacted the ground damaging the…May 21, 1982 · N65501 · Substantial damageNTSB MKC82DA085Accident · No injuriesFinal reportGrumman G-164A · Tekamah, NEOn the third spray run the pilot stated that the aircraft engine had a loss of power. He attempted to fly back to the airport but was forced to make an emergency landing in an open field. During the landing roll the aircraft nosed over in the soft mud. Engine…May 20, 1982 · N7689 · Substantial damageNTSB FTW82DA189Accident · No injuriesFinal reportBell 47D-1 · Harrisburg, ARDuring an agricultural spraying operation the pilot turned downwind and the tail rotor struck a rice dike. The pilot lost control and the aircraft landed hard. The main rotor severed the tail boom. Investigation revealed the aircraft had been loaded within…May 20, 1982 · N93067 · Substantial damageNTSB FTW82DA188Accident · No injuriesFinal reportCessna T188C · Knobel, ARThe pilot stated that during his swath run the engine seemed to hesitate. While checking the engine the pilot collided with a levee and the landing gear separated from the aircraft. The pilot made a forced landing in an adjacent field.May 20, 1982 · N4439J · Substantial damageNTSB CHI82FA174Accident · 1 fatalField investigationFinal reportCessna A188 · Blue Earth, MNThe flagman stated that during the swath run the acft was following the contour of the field. The flagman thought the plt was getting close to the end of the field & was about to call him on the radio when the acft pulled up to about a 45 deg nose high…May 19, 1982 · N9819V · DestroyedNTSB SEA82DA072Accident · No injuriesFinal reportBell 47G-2 · Grandview, WAWhile dispensing herbicide (systox) over an apple orchard the pilot sensed that the engine was binding followed by a power loss. The pilot elected to dump the herbicide and performed a power-off autorotation landing in a grape vineyard. Investigation revealed…May 18, 1982 · N11VH · Substantial damageNTSB LAX82DVM16Accident · No injuriesFinal reportHughes 269C · Salinas, CAThe student pilot reported that the purpose of the flight was to practice hovering. He reported that the wind was from 280 degrees at 9 knots. He stated that while hovering, he turned to a downwind heading when a gust of wind spun the helicopter to the right.…May 17, 1982 · N1105B · Substantial damageNTSB ATL82FID08Accident · No injuriesFinal reportCessna 188 · West Point, VAThe pilot took off with a 50 gal load of water to calibrate the spray system. He stated that during a swath run, he heard a loud noise or whirring sound and initially thought there was a spray pump propeller failure. Immediately, he pulled up, started a left…May 17, 1982 · N5522S · DestroyedNTSB LAX82DA178Accident · No injuriesFinal reportPiper PA-36-285 · E. Of Delano, CADuring the procedure turn phase while spraying orange trees the engine stopped. Six orange trees were destroyed during the emergency landing. Examination of the aircraft's engine revealed no preimpact failure or malfunction.May 16, 1982 · N57734 · Substantial damageNTSB ATL82FKJ12Accident · 1 fatalFinal reportPiper J3C-65 · Alabaster, ALDuring an air show, the aircraft was observed flying slowly over the runway on a southerly heading at about 200 to 250 ft AGL. Full left rudder was applied along with full up elevator and the plane entered a spin. After one turn, full opposite rudder was…May 16, 1982 · N42799 · DestroyedNTSB MKC82DA082Accident · Minor injuriesFinal reportBell 47G2 · Thornton, IADuring the downwind turn for the fourth spraying pass the pilot encountered a gust of wind. The pilot stated he applied power, collective and cyclic to level off at spraying altitude but the wind was too strong to prevent the tailboom from striking the ground.May 14, 1982 · N8426E · Substantial damageNTSB ANC82DAG26Accident · 1 fatalFinal reportPiper 18 · Ramsey Bay, AKThe pilot and passenger were on a hunting trip and flew out of the camp to spot fellow hunters climbing a mountain. After locating them the pilot tried to turn in the canyon at low altitude and low airspeed. The aircraft stalled, spun and crashed.May 13, 1982 · N74979 · Substantial damage