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 LAX83FUJ15Accident · 1 fatalFinal reportGrau VARI-EZE · Tucson, AZWitnesses observed the acft make 4 low passes, 200-300 ft AGL. On the last pass the acft pulled up ino about a 30 deg nose high attitude & start a right roll. The nose began to drop, & as the roll was completed the acft was in about a 80 deg nose low, wings…Aug 2, 1983 · N79AA · DestroyedNTSB CHI83FA351Accident · No injuriesField investigationFinal reportSwain Rutan Longeze · Oshkosh, WIThe acft nosed over during a forced landing after a power loss. The acft collided with tall corn during the landing rolland swerved into the corn. Examination of the carburetor revealed pieces of a soft brownish-white somewhat elastic substance in the float…Aug 2, 1983 · N4ZZ · Substantial damageNTSB CHI83FA347Accident · 1 fatalField investigationFinal reportNorth American AT-6D · Muskegon, MIThe acft collided with trees after performing an aerobatic maneuver at low altitude. Witnesses near the scene said the acft was flying low; most heard the engine running. Some said that at the top of a loop the engine sounded like it stopped. On the descent…Aug 2, 1983 · N29938 · DestroyedNTSB MIA83LA194Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City, FLThe plt reported that as he was recovering from the 1st banner tow mission, he noted a line of cumulus buildups moving northerly from over the gulf toward the arpt. He elected not to pick up another banner. He planned just to drop the banner he was towing,…Aug 1, 1983 · N88477 · DestroyedNTSB FTW83LA358Accident · No injuriesLimited investigationFinal reportRockwell S2R · Eudora, ARWhile dispensing fertilizer, oil suddenly covered the windshield & the eng began running at reduced power. The plt made an emergency landing in a water covered rice field where the wheels hit a levee & the acft nosed over. An exam revealed that the #1 exhaust…Aug 1, 1983 · N4903X · Substantial damageNTSB CHI83LA342Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Camp Point, ILThe plt had just completed a swath run. As he approached a road he pulled up to avoid a car, then attempted to descend below power lines & in so doing collided with a stop sign. The acft cartwheeled & landed inverted in a bean field.Jul 31, 1983 · N4332Y · Substantial damageNTSB CHI83FA243Accident · 1 fatalField investigationFinal reportPestes RV-3 · Oshkosh, WIThe accident occurred during a 'showcase' flyby at the annual eaa convention. The acft was flying #4 position in a formation of 4 acft. The flt was executing a very steep, near 90 deg bank left turn at 300-500 ft when the acft's came up & over putting the…Jul 31, 1983 · N45AP · DestroyedNTSB ANC83FA137Accident · 1 fatalField investigationFinal reportGrumman G-44A · Big Lake, AKThe acft crashed in a level, wooded area. The initial impact with trees occurred aprx 40 ft AGL. Both wing tips & a portion of the left stabilizer & elevator were found at the bases of the trees that were first impacted. From the first impact point, the…Jul 31, 1983 · N1423 · DestroyedNTSB LAX83FVG15Accident · 2 fatalFinal reportGreat Lakes 2T-1A-Z · Davis, CAThe acft collided with the ground while performing aerobatic maneuvers. The plt had scheduled a number of aerobatic fltsfor various people. During the last flt of the day the aircraft crashed in a alt open, plowed field. Weather was not a factor. The aircraft…Jul 30, 1983 · N5761N · DestroyedNTSB FTW83FU002Accident · 1 fatalFinal reportPterodactyl Ascenger II+ · Round Rock, TXThe ultralight vehicle had been recently built & had been flown once by an experienced ultralight plt. He reported there were no discrepancies in the vehicle's assembly or flt characteristics. The owner & 2 other personnel met at the flying area & assembled…Jul 30, 1983 · UNREG · Substantial damageNTSB DEN83LA178Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Fowler, COThe plt & the owner thought there was enough fuel remaining for about 1 hr of aerial application. During a procedure turn, aprx 45 min after takeoff, the eng lost power. The plt reported he tried to start the eng, but the acft was so low that he didn't have…Jul 30, 1983 · N6217Z · Substantial damageNTSB ATL83FA299Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-23G · Warrenton, VAAt an altitude of about 4,500 ft the glider was ovserved to pull up into a stall & enter a spin which continued for three turns. The glider came out of the spin into a left spiral & appeared to be traveling at a very high speed. The nose then 'tucked under'…Jul 30, 1983 · N3843A · DestroyedNTSB FTW83FA357Accident · No injuriesField investigationFinal reportAyres S2R · Waldenburg, ARThis acft made a hard forced landing in a field during aerial application after the engine failed. The landing gear failed during the landing. The post accident examination of the engine showed a failure and separation of the reduction gearing. The failure…Jul 29, 1983 · N5054X · Substantial damageNTSB ATL83LA297Accident · No injuriesLimited investigationFinal reportHughes 269B · Summerville, SCThe helicopter was being used in controlled burning of timberland. While being operated at an alt of aprx 20 ft over wind rows of organic material, there was a partial loss of eng power. The plt stated that he was unable to maintain a hover, so he landed on…Jul 29, 1983 · N9419F · Substantial damageNTSB LAX83FA362Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Porterville, CAOn 7/27/83, mild mast bumping occurred during a pushover maneuver while a hiller FH-1180 was on a flt to certify new rotor blades. Prior to the incident, the helicopter was accelerated to 90 mph. This was followed by a pull-up & deceleration to 80 mph, then…Jul 28, 1983 · N450FH · DestroyedNTSB MKC83FA165Accident · Serious injuriesField investigationFinal reportCessna 140 · Pratt, KSThe acft stalled and crashed in a plowed field during an aerial application flt while dispensing wasp eggs on a corn field. The eggs were carried in plastic tubes in a styrofoam ice chest behind the seat and were transferred by the plt as needed to the…Jul 27, 1983 · N76242 · DestroyedNTSB DEN83FA180Accident · 4 fatalField investigationFinal reportPiper PA-28-235C · Pitkin, COThe acft was on a x-country flt from camarillo, CA to oshkosh, WI. The plt landed at about noon at montrose, CO, where the acft was refueled & the occupants went to a restaurant to eat. After departing montrose, the acft was seen flying low over rising,…Jul 27, 1983 · N9378W · DestroyedNTSB FTW83LA350Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kemah, TXThe plt had landed in a restaurant parking lot. When he was informed that a local ordinance had been passed prohibiting helicopter operations from restaurant parking lots & that the police had been called, he prepared to takeoff. As the plt was preparing to…Jul 26, 1983 · N1109 · No damageNTSB FTW83LA351Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chilton, TXDuring the 1st swath run the prop separated from the eng. A forced landing was made in a plowed field shearing one main landing gear. The acft then went through a barbed wire fence. The #4 cylinder was removed to inspect the vibration damper pins in…Jul 25, 1983 · N4866 · Substantial damageNTSB NYC83LA190Accident · No injuriesLimited investigationFinal reportLet L-13 · Fredericksburg, PAAfter lift-off from a tow takeoff, the towplane was unable to attain the normal tow airspeed of 65 to 75 mph & continuedat about 55 mph. The glider plt thought the towplane was having engine problems, & as the two acft circled the arpt, theglider plt released…Jul 24, 1983 · N32360 · Substantial damageNTSB DEN83LA176Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Elbert, COThe acft engine quit while the plt was performing aerobatics, an airstart was unsuccessful and a forced landing was madein an open field surrounded by trees. During the landing one wing hit a tree causing the acft to veer into a creek. The plt said he had…Jul 24, 1983 · N8626V · Substantial damageNTSB LAX83LA355Accident · 1 fatalLimited investigationFinal reportCessna A150K · Stonyford, CAThe acft collided with the ground while negotiating a low level aerobatic maneuver. The acft had departed a private ranch airstrip and according to a witness the acft was 'rolled'. After a few circles of the strip. The witness was surprised because the plt…Jul 23, 1983 · N8353M · DestroyedNTSB LAX83LA353Accident · Minor injuriesLimited investigationFinal reportAyres Turbo Thrush S2R-34 · Avenal, CAThe acft collided with wires during aerial application. The acft hopper was inadvertently set on full open for the 3rd operation of the day. There is no indicator in the cockpit to show the pilot the position of the gate stop. When the pilot opened the hopper…Jul 23, 1983 · N57SK · Substantial damageNTSB LAX83FUA06Accident · 1 fatalFinal reportRand Robinson KR-1 · Seal Beach, CAAccording to a witness, the acft apchd at about 1000 ft, made 3 circles & headed in an easterly direction. The acft was then observed to make a steep banked turn toward the witness at an estimated altitude of 200 to 300 ft above the water. It then nosed down,…Jul 23, 1983 · N98BB · DestroyedNTSB DEN83LA174Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Salida, COThe acft crashed into a mountain in a controlled crash situation with full flaps and full power at the 11,312 ft level the density alt was computed to be 12,370 ft MSL. The plt was aware that the weather was questionable in some areas of his route and the…Jul 23, 1983 · N12370 · DestroyedNTSB ANC83LA130Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria 7GCBC · Seward, AKThe pilot stated that he was flying at 200 feet AGL, at about 65 mph in a left turn, spotting fish for a fishing vessel when a map that was on his lap fell to the floor. When he reached for it his left hand hit the throttle, reducing power. Before he could…Jul 23, 1983 · N50509 · Substantial damageNTSB LAX83LA352Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Mammoth Lakes, CAThe acft collided with trees while trying to maneuver through a mountain pass at 13000 ft MSL with the temperature at 82DEGREES. The plt stated that the acft started a high sink rate. He checked the throttle, mags and mixture but was forcedto settle into the…Jul 22, 1983 · N5737Z · DestroyedNTSB DEN83LA172Accident · No injuriesLimited investigationFinal reportCessna T188C · Bozeman, MTThe acft settled into trees after the engine lost power during a swath run. The flt had been in progress for about 15 minutes. The plt started the 4th run and the acft started to settle. The plt dumped the load but did not touch the throttle or mixture. He…Jul 22, 1983 · N2834J · Substantial damageNTSB SEA83LA154Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Tensed, IDThe acft had made 3 passes since reloading, so the acft was fairly heavy and was on an uphill pass as it began a turn- around. In an attempt to maneuver and clear 100 ft trees the acft stalled and the rt wing tip hit a tree.Jul 21, 1983 · N9089W · Substantial damageNTSB CHI83LA329Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Springfield, OHThe plt reported he had taken on a 30 lb chemical load & 45 lbs of fuel in the left tank after landing on a nurse truck. He took off again. About 10 min later, after spraying the load, the boost pump failure light illuminated. The plt turned into the wind &…Jul 21, 1983 · N81HF · Substantial damageNTSB ATL83FU004Accident · 1 fatalFinal reportCondor II Special · Dahlonega, GAAfter takeoff, the ultralight vehicle was observed to climb about 600 to 700 ft over a pasture east of the rwy, then the plt began to perform aerobatic maneuvers. After completing a loop, the ultralight was observed to rotate nose up. At about that time, a…Jul 21, 1983 · UNREG · DestroyedNTSB MKC83FA161Accident · 2 fatalField investigationFinal reportAmerican Eagle 2-PLACE · Chesterfield, MOThe acft was first observed in a left 30 deg bank turn with the nose slightly down. After the first 360 deg turn, the angle of bank increased to 60 deg. During the 3rd 360 deg turn, the diameter of the turn decreased to about 100 ft & theforward speed…Jul 20, 1983 · N911AA · DestroyedNTSB FTW83FA343Accident · 1 fatalField investigationFinal reportHughes 269C · Houston, TXThe helicopter crashed in a relatively high speed descent while in a slight nose-low and left bank attitude. The acft had been circling at an alt of about 600 ft MSL awaiting clearance to land. The PIC in the left seat, who was not flying the acft, said he…Jul 20, 1983 · N8995F · DestroyedNTSB LAX83LA334Accident · No injuriesLimited investigationFinal reportCessna A188B · Calipatria, CAThe acft made a hard landing in a cotton field during a crop dusting operation after buffeting was felt in a turn. The pilot thought he was stalling in vortex turbulence from another acft in front of him. A toxic load of suprecide was dumped before the pilot…Jul 19, 1983 · N4463Q · Substantial damageNTSB CHI83LA321Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Brooklyn Park, MNThe plt reported that he was spraying the end rows of a field when the helicopter approached some wires. He stated that he saw the wires at the last second & tried to get under them. Reportedly, the helicopter crossed below a set of power lines, but struck a…Jul 18, 1983 · N120NR · Substantial damageNTSB FTW83LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rutheron, NMThe acft collided with the ground inadvertantly after dropping emergency drilling equipment at a drilling site. The plt was making another pass to check on the drop when the acft started to descend. In spite of power application the acft descended into an…Jul 17, 1983 · N8198B · Substantial damageNTSB LAX83LA344Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Columbia, CAThe acft contacted a powerline 100 ft above the water at new mellones reservoir. The acft was landed at Columbia. CA without further incident. An inspection of the acft revealed that the top portion of the vertical stabilizer was missingand the rudder was…Jul 16, 1983 · N5492W · Substantial damageNTSB LAX83LA340Accident · No injuriesLimited investigationFinal reportHughes 269 · Mesa, AZThe instructor was demonstrating a power recovery autorotation to a dry river bed, which he initiated at 500 feet AGL by rolling off the throttle and lowering the collective. Aprx 5 seconds later he observed a change in sound and noticed the engine RPM at 0.…Jul 16, 1983 · N8773F · Substantial damageNTSB DEN83LA167Accident · No injuriesLimited investigationFinal reportCessna 188A · Burlington, COThe acft stalled into the ground after a dive and accelerated pull-up during aerial application. The pilot stated that he was doing the steep pull-ups and dives because of proximity to the city of Burlington co. he said the acft was just about empty of gas…Jul 16, 1983 · N1584M · Substantial damageNTSB ATL83LA281Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Sledge, MSThe acft collided with the ground and nosed over during an aerial application maneuver. The plt stated, the acft startedto settle while in a turn and he dumped the load after leveling the wings but was unable to stop the descent prior to ground contact. The…Jul 16, 1983 · N8526H · DestroyedNTSB DEN83LA166Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Thompson, NDThe acft crashed during descent for the first swath run. Investigation revealed that the pilot applied back pressure to the control stick to flare from the descent. The acft did not respond and continued to descend. The impact was hard enough to tear the left…Jul 15, 1983 · N1279W · Substantial damageNTSB MIA83FA183Accident · Serious injuriesField investigationFinal reportKaman H-43B · Near Clermont, FLThe helicopter crashed in an uncontrolled descent from a hover. A witness stated that the helicopter was slowing descending to position a 150 ft line for the ground crew when he observed something separate and the helicopter came down in a vertical descent.…Jul 14, 1983 · N57996 · DestroyedNTSB LAX83FA335Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Fontana, CAThe acft impacted the terrain at 4600 ft MSL at a steep angle in brush and dirt near a fire road. According to the plts family the acft had recently been purchased by the plt and he frequently practiced aerobatics in the late afternoon. Hisaerobatic…Jul 14, 1983 · N7692S · DestroyedNTSB MKC83LA155Accident · No injuriesLimited investigationFinal reportCessna A188B · Edgar, NEThe plt reported that he was completing a turnaround when the acft encountered turbulence from another plane that was spraying the same field. The acft began to settle. When he pulled up to avoid a power line, the acft stalled & crashed.Jul 13, 1983 · N9114G · DestroyedNTSB MKC83FA153Accident · 1 fatalField investigationFinal reportCessna 188B · Shelton, NEThe plt had dusted 1 field & had started dusting another that was located on rolling terrain. After making 3 swath runs over the 2nd field, he was maneuvering for a 4th run when the acft's right wing impacted with a power line cable. The wing's leading edge &…Jul 12, 1983 · N731AC · DestroyedNTSB FTW83FA332Accident · Serious injuriesField investigationFinal reportBoeing B75N1 · Webb, TXThe pilot stated that before flying under wires a bird struck and broke a plastic fuel gauge mounted under the center section of the upper wing. Fuel reportedly sprayed onto the windscreen and the pilots face restricting his forward visibility. In an effort…Jul 12, 1983 · N59085 · DestroyedNTSB ATL83LA273Accident · Minor injuriesLimited investigationFinal reportCessna 305A · N. Myrtle Beach, SCThe acft stalled into an inland waterway shortly after takeoff for a banner towing flt. The pilot reported he had just refueled and made a takeoff. He was on the crosswind leg of the traffic pattern when the accident happened. He stated that he encountered…Jul 12, 1983 · N5172G · Substantial damageNTSB ATL83FA272Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Ellenwood, GADuring the flt, the acft collided with 2 utility transmission lines, then crashed to the ground. According to witnesses, the accident occurred after the acft had circled the passenger's home & the plt had started a turn. An exam of the wreckage revealed no…Jul 12, 1983 · N92367 · Substantial damageNTSB LAX83LA330Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Princeton, CAThe acft made a forced landing and was destroyed by fire after an engine failure during a spraying operation. The plt stated that his flagger saw black smoke during the pull-up. The smoke turned white and was observed coming from the stacks. Inspection of the…Jul 11, 1983 · N9707 · DestroyedNTSB FTW83LA327Accident · No injuriesLimited investigationFinal reportBell 212 · Eugene IslandAfter making an apch to an off-shore oil well heliport, the plt believed the tail rotor was too close to a stairwell, so he made a peddle turn to the right. During the turn, the tail rotor blades contacted a crane. The crane was located about 15 ft from the…Jul 11, 1983 · N16989 · Substantial damage