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 ATL83LA269Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Hopeful, GAThe acft collided with the ground during a turn around while conducting an aerial application operation. The pilot was spraying soy beans and was performing a turn when he stalled the acft without sufficient alt to recover. The pilot said there was no problem…Jul 11, 1983 · N7019Z · DestroyedNTSB MIA83FU005Accident · Serious injuriesFinal reportPterodactyl Ascender · Jacksonville, FLThe plts of 2 high wing, pterodactle ascender, ultralight vehicles took off & were operating in a designated area for ultralights. One plt (plt-a) was making touch & go landings while the other plt (plt-b) was maneuvering in the vicinity. After plt-a made a…Jul 10, 1983 · UNREG · 2 aircraft · DestroyedNTSB LAX83FVG13Accident · Serious injuriesFinal reportChampion 7ECA · Shingle Springs, CAThe acft collided with an oak tree while maneuvering at low alt. The weather was VMC. The pilot stated that he was flying to maintain a battery charge. He said he climbed to about 1600-1700 ft MSL and flew southeast. The average elevation along this route is…Jul 10, 1983 · N1882G · DestroyedNTSB DEN83LA163Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Hooper, UTThe spraying operation was being conducted over a large mosquito abatement district. The district was mapped out into several small areas to be sprayed. Due to the many areas to be sprayed, the plt did not inspect each section for obstacles prior to the flt.…Jul 10, 1983 · N4886R · Substantial damageNTSB ATL83LA268Accident · No injuriesLimited investigationFinal reportEames Acro Sport · Huntersville, NCThe acft collided with a tree during inverted flt over an arpt. The pilot had made several aerobatic maneuvers over the airfield. On the last pass the acft was inverted at low alt as it proceeded down the rwy it drifted west about 200 ft and hit a tree near…Jul 9, 1983 · N16SE · Substantial damageNTSB ATL83FKJ05Accident · 2 fatalFinal reportAeronca 7BCM L-16A · Gadsden, ALThe acft collided with the ground in a 70 degree dive while taking part in an air show as a spotter plane. The acft had dropped one smoke grendade and was orbiting to drop another when it turned left and pitched down. According to an inspection guide for this…Jul 9, 1983 · N2557B · DestroyedNTSB FTW83FA323Accident · 1 fatalField investigationFinal reportTexas Helicopter OH-13-EM-7A · Cedarville, ARThe pilot was using an improvised hydraulic vertical saw to trim limbs & brush from powerlines. The saw blades appear to have malfunctioned while the helicopter was maneuvering. The pilot jettisoned the saw, but the quick disconnect hoses failed to release…Jul 8, 1983 · N68040 · DestroyedNTSB ATL83LA260Accident · Minor injuriesLimited investigationFinal reportGrumman G164A · Hazlehurst, MSThe acft collided with a tree and the ground shortly after takeoff with a heavy load on a hot day. The acft had 1600 lbsof dry fertilizer, 42 gallons of fuel for takeoff. The plt stated he got into 'downdrafts' in the rolling hills and he jettisoned the load…Jul 8, 1983 · N951X · DestroyedNTSB FTW83LA328Accident · No injuriesLimited investigationFinal reportBell 206 · Houston, TXThe plt stated he intended to move the helicopter from a dolly platform to a surface parking area when the left skid collided with the dolly and the acft rolled over.Jul 7, 1983 · N352QT · Substantial damageNTSB SEA83FA142Accident · 1 fatalField investigationFinal reportVans-Rupert RV-4 · Marshall, WAThe flt was to test a newly installed airspeed indicator. A passenger who went on the flt survived the accident and saidthe pilot had done an aileron roll from 4000 ft MSL (about 1700 ft AGL) and had buffeted and lost alt during recovery. After a high speed…Jul 6, 1983 · N444RV · DestroyedNTSB MKC83FU004Accident · Serious injuriesFinal reportMattison MAC 300 · Brewster, KSThe ultralight went out of control and dove in a cockscrew spiral to the ground. The vehicle did not move after impact. The acft was at about 200 ft AGL when witnesses saw it dip the right wing and start a spin which was described as a corkscrew. It made 4 or…Jul 6, 1983 · UNREG · Substantial damageNTSB MIA83FA177Accident · No injuriesField investigationFinal reportBell 206B · Miami, FLThe plt stated that as he slowed the helicopter to at or near 'effective translational lift' to let paxs obsv some construction he heard the engine make a loud noise and fail. The acft was at abt 300 ft AGL at 30-40 KTS. During lndg flare the t/r and t/boom…Jul 6, 1983 · N63RC · Substantial damageNTSB SEA83FU007Accident · 1 fatalFinal reportAirmass Sunburst · Tacoma, WAThe ultralight had previously flown to Tacoma with 2 phantom ultralights in preparation for the airshow. During descent the 3 acft had reached speeds of 75-80 mph. After landing, one of phantom plts asked the sunburst plt if he knew how fast he was going and…Jul 5, 1983 · UNREG · DestroyedNTSB FTW83FA313Accident · 1 fatalField investigationFinal reportTaylorcraft BCS 12-65 · Odessa, TXThe acft collided with wires and the ground during recovery from an aerobatic maneuver. The plt had done what appeared to be a maneuver similiar to a hammerhead stall shortly after first takeoff. The acft appeared to be recovering as it 'bottomed out' at…Jul 5, 1983 · N1776B · DestroyedNTSB SEA83FU006Accident · Serious injuriesFinal reportAmerican Aerolights Eagle XL · Happy Valley, ORThe ultralight collided with the terrain while maneuvering during an airshow. According to witnesses, the pilot had just executed a touch-and-go landing and commenced a climbing 180 degree left turn to downwind in what was described as a wingover type…Jul 4, 1983 · UNREG · DestroyedNTSB ATL83LA255Accident · No injuriesLimited investigationFinal reportCessna 172P · Charleston, SCThe acft nosed over during a forced landing after a stall during a low pass. The plt said he was flying around an islandat 500 ft AGL taking pictures when the acft began to settle. He added power and applied elevator back pressure. Then carburetor heat was…Jul 4, 1983 · N52471 · Substantial damageNTSB ATL83LA252Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · Thomasville, GAThe helicopter was on a swath run at about 5 ft AGL & was approaching hi obstructions when the plt noted that the needles split, the eng RPM increased & the main rotor RPM began decreasing. The plt turned to avoid the obstructions, but was unable to level the…Jul 4, 1983 · N37785 · Substantial damageNTSB DEN83LA159Accident · No injuriesLimited investigationFinal reportCessna 188B · Pierre, SDThe plt was making practice swath runs with a load of water. During the third turn, at about 100 ft AGL, the eng stopped, according to the plt. The acft then landed hard & cartwheeled. No eng malfunctions were found.Jul 2, 1983 · N8965G · Substantial damageNTSB DEN83FA156Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Wheatland, WYDuring an aerial application maneuver, the acft collided with the ground. An exam of the wreckage indicated that it impacted in a steep nose down attitude while rotating to the left. The flaps were found extended 25 deg & the airspeed gage was found…Jul 2, 1983 · N6850Z · DestroyedNTSB ATL83LA250Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Tuscaloosa, ALThe acft collided with a power line spanning a river during a low pass over the water. The pilot said the purpose of thelow pass was to look for his father in a boat. He said he thought he saw the boat and in pulling up the acft hit the power line. Control…Jul 2, 1983 · N8876U · Substantial damageNTSB MIA83LA179Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Altha, FLThe plt stated that the eng began losing power during an aerial application mission. Subsequently, he landed in a muddy field & the acft nosed over. He stated that the indupartial loss of power.Jul 1, 1983 · N6531K · Substantial damageNTSB MIA83FA173Accident · 1 fatalField investigationFinal reportTaylorcraft TC-19 · Lorida, FLWitnesses along a highway observed the acft flying at low altitude. One witness saw the acft hit a powerline, climb a little, then crash nose first.Jul 1, 1983 · N20021 · DestroyedNTSB DEN83LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Brandt, SDThe acft was damaged in a forced landing after its eng lost power during pull-up from the last (cleanup) swath run. APRX25 min before the acdnt flt, the plt landed to reload with chemicals. The owner stated that when the plt was asked if hewanted fuel, he…Jul 1, 1983 · N7121Z · Substantial damageNTSB CHI83LA288Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Morris, MNThe plt reported that while he was waiting for the flagman, circling the field to be sprayed, & talking to the flagman, the acft began to sink & struck trees. The load was dumped, but the plane continued to sink to the ground. During the landing, the acft…Jul 1, 1983 · N8379 · Substantial damageNTSB CHI83LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Morgan, MNThe acft collided with trees while turning during aerial application. The pilot reported that the acft controls felt soft. Thinking he was stalling he reduced bank, lowered the nose and at 85 mph indicated with full power continued levelflt until a wing hit a…Jul 1, 1983 · N6002Z · Substantial damageNTSB SEA83FA141Accident · 1 fatalField investigationFinal reportMonnett - Larsen Moni · Albany, ORThe home built, powered glider was being flown on a local test flight. According to witnesses, the acft was in unpowered flt (gliding) when it entered a descent & crashed. At about the same time it began descending, they observed something separate from the…Jun 30, 1983 · N83GL · DestroyedNTSB LAX83LA312Accident · No injuriesLimited investigationFinal reportBell 204B · Ocotillo, CAThe acft was on an external load operation to airlift loads of cement. The cement was being poured for base pilings for power line towers on rough terrain. While carrying a 3100 lb load of cement on a 40 ft line, the helicopter had just moved to a position to…Jun 30, 1983 · N1WA · DestroyedNTSB SEA83FA139Accident · Serious injuriesField investigationFinal reportCessna 182Q II · Near Peak, ORThe acft collided with rising terrain as the pilot tried unsuccessfully to avoid the trees and ridges. The two rear seatpassengers reported that they flew up a canyon at about 6500 ft MSL. The ridges on either side were as high as the acft. The pilot was seen…Jun 29, 1983 · N759XP · DestroyedNTSB FTW83FRG05Accident · 1 fatalFinal reportAero Commander Callair A-9 · Lytton Springs, TXThe acft crashed during a turn-around maneuver while conducting an aerial application mission. The acft had completed about 3 spraying patterns after reloading and was turning steeply to line up for another pass when the nose dropped and the acft descended in…Jun 29, 1983 · N7717V · No damageNTSB DEN83LA170Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Page, NDWhile spraying at dusk, the plt was concerned about injuring a 'non-target crop' across the road to the south from the field that was being sprayed. He stated that an irrigation system was sitting pointed southwest, and that as he was entering a swath to the…Jun 29, 1983 · N6652Q · Substantial damageNTSB MKC83LA138Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Poplar Bluff, MOAfter making 2 swath runs, the acft was in a procedure turn-around over a wooded area when the eng lost power. The plt tried to glide to a suitable area, but the acft hit the tops of trees & crashed. The owner stated the eng had a history of maintenance…Jun 28, 1983 · N7246 · DestroyedNTSB ATL83LA292Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Fairfax, SCThe acft mushed into the ground after the engine quit from negative g forces imposed by the pilot after clearing a fenceduring a swath run. After the engine lost power due to the temporary fuel starvation the pilot managed to clear some trees and mush into…Jun 28, 1983 · N4411S · Substantial damageNTSB SEA83LA134Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Lebanon, ORThe helicopter was damaged in a roll-over during a forced landing on a soft plowed field. The pilot stated that he was checking another company pilot and in doing so he abruptly reduced power to simulate engine failure. A total loss of power occurred. The…Jun 27, 1983 · N9240 · Substantial damageNTSB LAX83LA311Accident · No injuriesLimited investigationFinal reportRobinson R22 · Buckman Springs, CAThe helicopter experienced a loss of lift and descended into a lake after takeoff. The acft was about 29 lbs below max gross weight and the field elevation for takeoff was 4200 ft; also the calculated hover ceiling out of ground effect. The plt had climbed to…Jun 27, 1983 · N9065L · Substantial damageNTSB MKC83LA135Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Madrid, IAThe acft collided with unmarked wires over a river at about 150 feet AGL. A witness observed the acft low over the river and called an ambulance before the acft collided with the wires.Jun 26, 1983 · N69026 · DestroyedNTSB LAX83LA306Accident · Serious injuriesLimited investigationFinal reportCessna C170A · Cajon Pass, CAThe plt was flying about 40 ft AGL in marginal weather when the acft contacted a power line and crashed. No flt plan wasfiled and there is no record of a weather briefing for the plt. The plt stated he was following a highway up a Pass whenhe encountered…Jun 26, 1983 · N1239D · Substantial damageNTSB LAX83FU009Accident · 1 fatalFinal reportAmerican Aerolights Eagle XL · Sommerton, AZA witness in another ultralight saw the plt of the eagle xl climb to about 800 to 1000 ft AGL after taking off. The witness was aprx 500 ft AGL when he saw the eagle xl start a steep descent from his 8 to 9 o'clock high position and thought the eagle xl plt…Jun 26, 1983 · UNREG · DestroyedNTSB NYC83FNE03Accident · 1 fatalFinal reportBellanca 8KCAB · Madison, CTThe acft collided with the ground while performing aerobatic maneuvers during an airshow. Witnesses said it appeared that the pilot was having trouble staying in the assigned area for the maneuvers because of high winds. The winds were estimated at 20 KTS…Jun 25, 1983 · N2979T · DestroyedNTSB LAX83LA307Accident · Serious injuriesLimited investigationFinal reportCessna A150K · San Diego, CAWitnesses observed the acft circling over the housing development at low altitude. The acft banked steeply, pitched up & the nose fell through the horizon. The student plt flying the acft resided four houses away from where the acft crashed.Jun 25, 1983 · N8496M · DestroyedNTSB LAX83FA305Accident · 2 fatalField investigationFinal reportProut LONG-EZE · Geyserville, CAThe acft was first observed rounding the bend in the russian river about 1 mi west of the bridge flying in an easterly direction, apparently following the river bed. The acft's altitude was described from 'just over the water' to 'tree-toplevel.' As the acft…Jun 25, 1983 · N81KP · DestroyedNTSB FTW83LA295Accident · Minor injuriesLimited investigationFinal reportKate 301 · Nas Kingsville, TXThe home built acft was built from parts of a north American SNJ-4 & BT-13. It was made to resemble a ww-ii japanese Kate bomber & was being used in a confederate air force show to smiulate low level bombing runs. Between passes, the plt made 90-270 deg…Jun 25, 1983 · N3239G · DestroyedNTSB DEN83LA153Accident · Minor injuriesLimited investigationFinal reportAero Commander Callair A-9B · Rolla, NDDuring a procedure turn-around after the second pass, the acft entered a stall, the left wing dropped & the plane impacted, left wing first, while in a nose down attitude. No preimpact, mechanical malfunction or failure was reported.Jun 25, 1983 · N7642V · DestroyedNTSB SEA83FA133Accident · Minor injuriesField investigationFinal reportGarlick UH-1B/204 · Fossil, ORThe helicopter collided with a dead tree and crashed while conducting a spray run on an aerial application mission. The pilot said that the dawn light conditions made the obtacle hard to see. In the attempt to clear the tree the spray boom made contact and…Jun 24, 1983 · N5598G · DestroyedNTSB LAX83LA301Accident · No injuriesLimited investigationFinal reportCessna 172N · Marina, CAThe acft collided with the water while circling at low alt at night. During the maneuvering the engine also was reportedas running rough which further distracted the plt. He was already distracted trying to identify an object in the water while circling.…Jun 24, 1983 · N733PP · DestroyedNTSB LAX83FA298Accident · 1 fatalField investigationFinal reportCessna 152 · Pacoima, CAThe acft was observed maneuvering in the area of the arpt traffic pattern for about 45 min before the accident. Initial impact occurred with power lines about 1/2 mi southwest of the arpt while the acft was on a heading of about 320 deg. The acft then struck…Jun 24, 1983 · N5454B · DestroyedNTSB MKC83FA133Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · 3m Se Of Benton, MOAccording to the surviving passenger, a boy, the plt was flying the acft from the right seat. The acft was flown to the vicinity of the plt's property where he made a pass over a farm belonging to a relative. The low pass was made near the operator of a…Jun 23, 1983 · N99SP · DestroyedNTSB DEN83FTG01Accident · 2 fatalFinal reportStolp SA750 · Harwood, NDThe acft impacted the ground in an inverted position in about a 30 degree nose down attitude. The acft was observed doing aerobatics with the last maneuver a spin. The acft spun to an out of sight position behind the trees and a crash was heard. The CFI on…Jun 23, 1983 · N25873 · DestroyedNTSB ATL83FA238Accident · 1 fatalField investigationFinal reportCessna 172K · Millhaven, GAThe plt & his son took off at night to participate in the search for a downed acft. Subsequently, they found the burning wreckage of the downed plane. They saw people moving around the accident scene & made a pass over it by diving with the landing light on.…Jun 23, 1983 · N78160 · Substantial damageNTSB CHI83FA267Accident · 2 fatalField investigationFinal reportPiper PA28-161 · Cambridge, OHThe acft collided with the ground during a night flt after the plt encountered weather according to the radio transmissions to cleveland center. His statements were 'what have you got me into' and 'what are we into here' when asked by cleveland if he was into…Jun 20, 1983 · N2405U · DestroyedNTSB LAX83LUQ03Accident · 1 fatalFinal reportMareik-Bensen B-8M · Santa Maria, CAThe gryoplane was observed to depart from controlled flt at or below 800 ft AGL & the plt became separated from the acft. Both impacted the ground in a near vertical descent about 40 ft apart. The plt's blood alcohol content was 0.13%. The clasp ends of the…Jun 19, 1983 · N7045 · Destroyed