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 MIA83LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe plt reported that he descended to aprx 50 ft AGL to demonstrate flt at low altitude to his passengers. While flying over a pasture at this altitude, the acft struck a pine tree, damaging the right wing. The plt experienced no control problems & returned…Jun 18, 1983 · N64079 · Substantial damageNTSB LAX83LA291Accident · 1 fatalLimited investigationFinal reportBellanca 17-31A · Ducor, CAThe acft crashed into the side of a hill at 1900 feet MSL while on a photographic mission. The top of the mountain that was struck is 2412 feet MSL. The pilot was fatally injured in the crash and ground fire following impact. According to his secretary he was…Jun 18, 1983 · N8838V · DestroyedNTSB LAX83FVA03Accident · No injuriesFinal reportRockwell S2R · Corcoran, CAThe pilot reported that during his last spraying run he lost left rudder pedal control. He maintained control of the acft in the air but during landing he lost control due to the loss of the left rudder/brake pedal. The acft veered off the right side of the…Jun 18, 1983 · N8435V · Substantial damageNTSB ATL83IA234Incident · No injuriesIncident investigationFinal reportCessna 177RG · Ozark, ALWhile in cruise flight the engine failed to respond to throttle movement due to the throttle linkage being loose. Forced landing was made to a pasture.Jun 18, 1983 · N7515V · Minor damageNTSB CHI83LA268Accident · No injuriesLimited investigationFinal reportHomebuilt Baby Great Lakes · Lebanon, INThe acft landing gear collapsed and the acft nosed over after the engine quit due to fuel starvation. The engine lost power in a steep climb of at least a 45 deg angle and could not be restarted. The fuel flows to the engine by gravity. In a steep climb the…Jun 17, 1983 · N35JR · Substantial damageNTSB FTW83FA288Accident · Serious injuriesField investigationFinal reportRotec Rally III · Seven Points, TXReportedly, the plt had previously flown in a Rotec ralley iii ultralight, but handled the controls for only a few minutes. After assembling this ultralight, N148RE, from a kit, he made the necessary ground checks & preflt inspection, then took off on the 1st…Jun 16, 1983 · N148RE · DestroyedNTSB ATL83LA233Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Toddville, MDThe acft made an emergency landing while skidding after the aileron control jammed. The pilot in the rear seat and the owner in the front seat said that after a couple of steep turns the aileron control could not be moved. The acft was in a left wing down…Jun 16, 1983 · N28019 · Substantial damageNTSB MKC83LA129Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Puxico, MOThe plt stated that while trimming a rice field he was watching his drift & when he looked forward he saw the transmission line but was too close to avoid the lines.Jun 15, 1983 · N4813Y · DestroyedNTSB LAX83FU008Accident · 1 fatalFinal reportEipper Quicksilver MX · Rancho Cordova, CAJust prior to the accident, the ultralight vehicle was observed maneuvering in the area. While maneuvering, it entered a nose high attitude, stalled & crashed in a steep dive. The wind was reported as variable at 5 gusting 12 KTS. A toxicological test of the…Jun 15, 1983 · UNREG · Substantial damageNTSB CHI83FA258Accident · 2 fatalField investigationFinal reportCessna T210L · Porter Township, WIBoth occupants were rated plts. The plt in the right front seat of the acft had applied for membership with the organization that owned the plane. He may have been receiving informal instruction in the operation of the acft. During flt, the acft was observed…Jun 15, 1983 · N732CD · DestroyedNTSB LAX83FUM07Accident · No injuriesFinal reportBell 47G-5 · Valley Center, CAThe acft was damaged during a forced landing following a power loss while engaged in aerial application. The pilot took off with 25 gallons of fuel which he said was usually enough for spraying 40-50 acres. This job was 19 acres but it was 10-12 miles away at…Jun 14, 1983 · N2252W · Substantial damageNTSB LAX83FA287Accident · Minor injuriesField investigationFinal reportBell 206B · Temecula, CAThe plt took off on a demonstration flt to familiarize the passengers with the helicopter. He reported that after takeoff, he proceeded northeast at about 100 to 150 ft AGL & 80 KTS in wind that was from the west at 25 gusting 30 KTS. After traveling about 3…Jun 14, 1983 · N5754M · Substantial damageNTSB FTW83FA276Accident · 1 fatalField investigationFinal reportGrumman AA1A · Lagrange, TXWitnesses in six separate locations around the town reported the acft performing low altitude aerobatic maneuvers & buzzing recreational areas prior to the accident. The acft was subsequently observed doing 'roller-coaster' or figure-8 maneuvers, stall & spin…Jun 14, 1983 · N6338L · DestroyedNTSB NYC83FHM02Accident · 1 fatalFinal reportDial-Thorp T-18 · Morristown, NJThe plt had been active in organizing an air show, but was not considered a participant. However, his home built acft was on static display. On the 2nd day of the show, the chairman of the event gave him permission to do a fly-by. Subsequently, he initiated a…Jun 12, 1983 · N11BD · DestroyedNTSB MKC83FA128Accident · 4 fatalField investigationFinal reportBeech J35 · Knoxville, IAThe acft was observed to lift off the rwy aft abt a 900 ft ground roll. The lndg gear began to retract as it lifted off, and it began an immediate left turn overflying the airport hangars. It was further observed with the wings aligned with the ground in a 90…Jun 12, 1983 · N3054C · DestroyedNTSB CHI83FU004Accident · Serious injuriesFinal reportPara-Sail Glider · Battle Creek, WIThe ultralight vehicle was observed flying low over a golf course. As it approached a tall tree, witnesses heard the addition of power. However, a wing hit the tree & the ultralight spiraled down & impacted the ground. The plt did not possess an FAA plt…Jun 12, 1983 · UNREG · Substantial damageNTSB CHI83LA250Accident · Minor injuriesLimited investigationFinal reportBell 47G5A · Detroit, MIThe pilot stated that he was assigned a community affairs project to fly a 'ronald mcdonald' clown to a nearby restaurant for a magic show. During the hover in the landing area the rotor blades struck a light pole. The helicopter pitched forward and landed on…Jun 11, 1983 · N7995J · Substantial damageNTSB DEN83LA137Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Saco, MTThe acft collided with telephone lines during an aerial application run. The pilot's son reported that the acft was pulling up at the end of a spray run when the wires were hit. Most of the wires in this area are underground however thewires at the end of…Jun 10, 1983 · N4812Q · Substantial damageNTSB ATL83FKG08Accident · Minor injuriesFinal reportCessna A188B · Ashburn, GAThe plt reported that after the 4th pass, he had just completed a turn over a wooded area when the engine power went to idle RPM. He was forced to land in the trees, adjacent to the field that he was spraying. No preimpact, mechanical failure was found. The…Jun 10, 1983 · N21830 · DestroyedNTSB FTW83FA270Accident · 1 fatalField investigationFinal reportAir Tractor AT-400A · Lane City, TXThe plt was leading a flt of 2 acft on an aerial application mission. The plt of the 2nd acft stated that at the end of a swath run, the lead acft pulled up to an almost vertical attitude & to an alt of between 300 & 400 ft AGL. At that time, the plane…Jun 9, 1983 · N31619 · DestroyedNTSB DEN83LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Conrad, MTThe acft landed hard and collapsed the right main landing gear during a forced landing after fuel exhaustion. During a landing to reload the pilot had handled the herbicide on-loading and a ground crewman was loading the acft fuel. The supply of 80/87 octane…Jun 9, 1983 · N23069 · Substantial damageNTSB NYC83FHD01Accident · No injuriesFinal reportHiller UH-12D · Bricktown, NJThe plt reported an erratic RPM drop & a partial loss of power during a swath run. This occurred when the helicopter was aprx 10 ft above trees at aprx 40 KTS. The acft began losing airspeed & altitude. During an emergency landing, the tail rotor & main rotor…Jun 8, 1983 · N67155 · Substantial damageNTSB MIA83FA158Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Fort Lauderdale, FLDuring flt, the acft was observed flying from west to east across the beach & out over the ocean. Witnesses reported that over the ocean, the sky was dark & thunderstorms were approaching with heavy lightning. As the acft crossed the beach, a distinct eng…Jun 8, 1983 · N619MP · DestroyedNTSB LAX83FA276Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · El Cajon, CAThe plt was first wx briefed at 0916 for a flt to catalina island & on to san jose. VFR flt was not recommended. Subsequently the plt called fss four more times, the final call at 1402 during which he requested & received the wx for montgomery & gillespie…Jun 8, 1983 · N8318T · DestroyedNTSB CHI83LA245Accident · No injuriesLimited investigationFinal reportAeronca 7ECA · Wentworth, WIThe CFI stated that he gave the student a simulated emergency landing. When the acft was about 10-20 ft above the ground a gust of wind caught the acft. The acft dropped suddenly and hit the ground. The landing gear folded and the fuselage and wing tips were…Jun 8, 1983 · N2563F · Substantial damageNTSB ATL83LA220Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M74A · Ruleville, MSThe plt reported that the engine lost power during a swath run. A run-on landing was made. Prior to stopping, the right skid & right spray boom hit a rice level, and subsequenily, the main rotor blade chopped the tail boom. No preimpact failures were found.Jun 8, 1983 · N1001G · Substantial damageNTSB LAX83FA267Accident · 1 fatalField investigationFinal reportCessna 152 · Mesa, AZPrior to the flt, the plt reported that he was 'going to do some airwork.' About 1.2 hrs after takeoff, witnesses saw the acft flying eastbound at an estimated altitude of between 2000 & 3500 ft AGL. A witness with about 40 hrs of aeronautical experience…Jun 7, 1983 · N89894 · DestroyedNTSB CHI83LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Roseau, MNDuring an aerial application flt, the acft collided with power lines during a pull-up from a swath run. The plt reported no preimpact malfunctions.Jun 6, 1983 · N7221L · Substantial damageNTSB SEA83FYK04Accident · 1 fatalFinal reportHomebuilt Christen Eagle II · Bend, ORUpon completion of his routine during an airshow, the plt stated to the show announcer that he would do a low pass down the rwy followed by a vertical climb to a hammerhead stall & then into a lomcevak aerobatic maneuver. This maneuver is aclimbing outside…Jun 5, 1983 · N4GT · DestroyedNTSB LAX83FUM06Accident · Serious injuriesFinal reportCessna 172RG · San Clemente, CAThe acft crashed on San Clemente island during a fish spotting flt on a dark night. These flts are usually flown at an alt of 1000-2000 ft AGL. A navy witness on the accident island said the ceiling was zero and the visibility about 200 yards at the accident…Jun 5, 1983 · N4789R · DestroyedNTSB NYC83LA132Accident · No injuriesLimited investigationFinal reportMooney M20B · Lakeville, MAThe acft collided with the smooth water of a reservoir while flying low during an afternoon flight. The acft crashed about 1000 ft offshore when the right wing tip collided with the surface of the water. The acft then sank in 15-20 ft ofwater. The pilot…Jun 4, 1983 · N74788 · Substantial damageNTSB FTW83LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Anson, TXAccording to the plt, while in flt, the eng was running smooth, but seemed to lack power. He checked the instruments & noted that the manifold pressure & eng RPM were normal. Then while at aprx 60 ft AGL, all power was lost. Subsequently, the acft crashed on…Jun 4, 1983 · N57751 · DestroyedNTSB FTW83FA261Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Omega, OKThe plt had just completed spraying a field & was in a right turn when the right wing tip hit gently rising terrain. The owner thought that the plt might have diverted his attention while looking at a farmer's map to locate the next field. (Several similar…Jun 4, 1983 · N6551Z · DestroyedNTSB DEN83FTE09Accident · 1 fatalFinal reportLink-Johnson-Chessman HP-16 · Eldorado Sprgs., COThe glider crashed into a mountain while maneuvering during VMC weather. The pilot was fatally injured. The glider impacted the face of bear peak mountain near the 7900 ft. level. The fuselage was crushed the wings separated and the pilot, who had undone his…Jun 4, 1983 · N9025N · Substantial damageNTSB CHI83LA238Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Park Forrest, ILThe acft was being flown on a routine flight check after having completed an annual inspection. The plt stated that after takeoff he climbed to 800 ft, turned downwind, extended flaps to 30 deg, slowed to 70-80, & intended to make a pass over the field to…Jun 4, 1983 · N5258G · Substantial damageNTSB NYC83FA130Accident · 1 fatalField investigationFinal reportNorth American AT-6C · Westfield, MAThe airline transport rated plt was on a low level, aerobatic waiver, competency check flt. He was scheduled to demonstrate a loop, an aileron roll, a split-s, an immelmann, a barrel roll & a 4-point hesitation roll. The minimum alt for these maneuvers was to…Jun 3, 1983 · N5286N · DestroyedNTSB ATL83LA210Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Alligator, MSThe acft collided with the terrain during an turn to reverse direction on an aerial application flt. The plt said he encountered a wind shear during the turn and was unable to arrest the descent. The acft impacted on the main gear and was substantially…Jun 3, 1983 · N701Y · Substantial damageNTSB NYC83FNC04Accident · Serious injuriesFinal reportMcdonald Steen Skybolt · Milan, NHThe purpose of the flt was preparation of an act for some planned air shows. The pilot maneuvered the acft into an inverted spin at an alt of 2000 AGL. After 3 revolutions of the spin he was unable to recover and the acft impacted the ground inverted.Jun 2, 1983 · N98JP · Substantial damageNTSB DEN83LA132Accident · No injuriesLimited investigationFinal reportBell 47G3-B1 · Devils Tower, WYThe acft crash landed in trees after the engine lost power. The helicopter was being used in aerial application at the time of the accident. The operation was being done in 8 minute segments. Every 8 minutes the helicopter landed for a reload of herbicide. At…Jun 1, 1983 · N80711 · Substantial damageNTSB SEA83FU002Accident · Serious injuriesFinal reportEipper Quicksilver MX · Sumner, WAThe acft collided with a tree and crashed into a parking lot when the engine quit during a low pass maneuver near a memorial day crowd in a park. The ultralight acft was destroyed and the pilot was seriously injured. Witnesses describedthe acft doing…May 29, 1983 · UNREG · Substantial damageNTSB DEN83LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Hilger, MTThe pilot stated that he and another pilot were spraying a field in tandem formation at an alt of about 10 feet AGL. He was about 1/2 mile behind the lead acft and slightly to the left. After making a swath run he pulled up to about 100 ft AGL and started…May 29, 1983 · N3380Z · Substantial damageNTSB DEN83FTM04Accident · Minor injuriesFinal reportPiper PA-25-235 · Delta, UTThe acft collided with two power lines on a clean up swath run. The acft rolled inverted and struck the ground. The field being sprayed was bordered on the north by highly visible wires. The wires that ran along the east side were not so visible. There was…May 29, 1983 · N6651Z · Substantial damageNTSB FTW83LA256Accident · No injuriesLimited investigationFinal reportAeronca 7AC · El Reno, OKThe acft nosed over during a forced landing after the engine quit. The plt stated that when about 4 miles from the arpt at 200 ft the engine began losing power with the dropping from 2000 to 1500 RPM. He also stated that application of carburetor heat did not…May 28, 1983 · N81978 · Substantial damageNTSB FTW83FA251Accident · 1 fatalField investigationFinal reportEnstrom 280C · Opelousas, LAThe helicopter was observed to lift off to a hover and began an erratic hover. The acft pitched up and spun throwing theplt out and fatally injuring him. Witnesses said they did not know the plt was going to fly the helicopter. The opinion was that it was to…May 28, 1983 · N56932 · Substantial damageNTSB FTW83FA250Accident · Serious injuriesField investigationFinal reportEvans VP-1 · Friendswood, TXThe acft collided with the ground during a tight steep turn at low (100 ft) alt. Witnesses reported that the eng was running well and that after flying the length of the rwy at low alt the plt made a steep left turn and crashed. Witnesses said the plt had…May 28, 1983 · N2VC · DestroyedNTSB ANC83LA085Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Glennallen, AKReportedly, the plt & passenger had worked a long day before going to their respective homes to attend household chores. Later, they met, and reportedly, they consumed food & beer. Eventually, they arrived at the location of where the plt's plane was parked.…May 28, 1983 · N3742M · Substantial damageNTSB SEA83LA110Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Turner, WAThe acft nosed over during an emergency landing after an engine failure. The pilot stated that he had almost completed his spraying, when during a turn-around, the engine started to backfire. He dumped the remaining load and reduced power. The engine…May 27, 1983 · N56426 · Substantial damageNTSB MIA83LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Jay, FLThe acft collided with a tree while maneuvering in an aerial application operation. The pilot stated that while completing a run,turbulence was encountered which he believes was related to a 20 acre field being burned nearby. The acft descended about 25 feet…May 26, 1983 · N6770Z · DestroyedNTSB LAX83LA249Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164C · Live Oak, CAThe plt was on a flight to seed a rice field with 2 sets of power lines located near its west edge. The plt had seeded the field many times before, & reportedly, was familiar with the area. During the 1st swath run, which was from east to west, the acft…May 26, 1983 · N6627K · DestroyedNTSB MKC83FA114Accident · Serious injuriesField investigationFinal reportHiller UH-12E · Troy, KSThe acft collided with a powerline while the pilot was locating a field to spray at a later date. The pilot saw telephone lines and flew over them but hit the powerlines which were 20 feet higher. The skids caught the wires and the helicopter nosed down,…May 24, 1983 · N3GK · Destroyed