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 MIA83LA243Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · St. Augustine, FLOn the previous flt, the plt noted that the left brake was weaker than the right brake. Before taking off again, he added fluid to the left brake sys. After flying about 1 hr, he returned & landed. During the landing roll, the left brake failed to operate.…Sep 16, 1983 · N66524 · Substantial damageNTSB LAX83LA441Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Winkelman, AZThe right wing collided with wires at the end of a swath run and the acft was pulled to the ground about 300 ft from the wires.Sep 16, 1983 · N21613 · DestroyedNTSB FTW83LA432Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Bay City, TXDuring a swath run, the acft came to contact with the crop that was being sprayed. This resulted in a loss of control & the acft impacted in the field & nosed over. A small post-crash fire erupted in the eng compartment, but burned itself out shortly…Sep 16, 1983 · N5049X · Substantial damageNTSB MIA83FA231Accident · 2 fatalField investigationFinal reportPitts S-2A · Green Cove Spr., FLThe acft collided with the ground and was destroyed during a pleasure flt. Examination of the wreckage and the accident site revealed evidence to suggest that the acft collided with the ground while in a steep left bank, nose low attitude and a high rate of…Sep 15, 1983 · N80041 · Substantial damageNTSB LAX83LA467Accident · 1 fatalLimited investigationFinal reportde Havilland B-206 · Davenport, CAThe acft collided or ditched in the water while attempting to evade customs officials. Custom officials had been watching this acft and followed it from Mexico. After a touch and go landing at compton the acft left the los angeles area at 200 ft MSL trying to…Sep 15, 1983 · N206TB · DestroyedNTSB LAX83FVG17Accident · 1 fatalFinal reportHiller UH12L · Tulelake, CAThe helicopter was on an agricultural spraying operation. While performing a turn-around, a spray boom struck a raised dirt bank beside a ditch at the edge of the field. Subsequently, the helicopter was pitched down & to the right, then impacted an upright…Sep 15, 1983 · N871H · DestroyedNTSB SEA83LA201Accident · Serious injuriesLimited investigationFinal reportHughes H-369D · Wrangell, AKThe helicopter landed hard and rolled over out of an autorotation attempt after a power loss. The acft was in the progress of a line-pull through trees when the attitude changed sufficiently to allow the fuel pump to entrain air into the fuel system. There…Sep 13, 1983 · N10915 · DestroyedNTSB LAX83FA439Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · S. Lake Tahoe, CAThe acft crashed during low alt turn following takeoff from the so. Lake Tahoe arpt. The tower controller advised the plt, after takeoff, that he could turn and circle the valley to gain alt before proceeding on course. The acft made one 360 deg turn and…Sep 13, 1983 · N9734T · DestroyedNTSB FTW83LA085Accident · No injuriesLimited investigationFinal reportHiller H-23D · Humble, TXThe helicopter made a hard autorotative landing after a power loss. The pilot stated he was hovering about 75 ft AGL waiting for ground personnel to attach a line to his external sling load when the engine decelerated to flt idle and he could not regain…Sep 12, 1983 · N3201F · Substantial damageNTSB DEN83LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28B-150 · Watford City, NDThe acft nose gear collapsed during a precautionary landing due to weather. The plt had been briefed on the weather the evening before the accident. The pilot stated that when the flight was 20 minutes from home he 'thought we could make it.' However, he…Sep 12, 1983 · N5821W · Substantial damageNTSB DEN83FA215Accident · Minor injuriesField investigationFinal reportHughes 369D · Woodruff, UTThe helicopter was being used to lift seismic materials on a 100 ft long line. After lifting the load to a hover at about 10 to 20 ft, the plt heard a loud 'bang' which was followed by a loss of directional control. The helicopter began uncontrolled spinning…Sep 12, 1983 · N8667F · Substantial damageNTSB FTW83FA424Accident · 1 fatalField investigationFinal reportPartenavia P68C · Plainview, TXThe plt was executing a high speed pass over the rwy at about 250 ft AGL. The plt then began a rapid pull-up & both wings separated just outboard of the eng nacelles. Reconstruction of the sequence from a videotape revealed that the acft's speed at the time…Sep 11, 1983 · N29561 · DestroyedNTSB ATL83FA365Accident · 2 fatalField investigationFinal reportNorth American SNJ · Millington, TNTh plt was giving free rides to spectators at an air show. The acft was observed making what appeared to be a loop which was initiated at a low altitude. As the acft reached the top of the loop, it was estimated to be 1,000 to 1,200 ft AGL. The nose then…Sep 11, 1983 · N9789Z · DestroyedNTSB ANC83LA169Accident · Serious injuriesLimited investigationFinal reportCessna C-152 · Eagle River, AKThe acft collided with rising terrain while maneuvering during a training flt at an alt of 3000 ft MSL. The acft was destroyed and the 2 occupants seriously injured. The CFI stated that there were no mechanical malfunctions which contributed to the accident…Sep 11, 1983 · N94547 · DestroyedNTSB LAX83FA435Accident · 1 fatalField investigationFinal reportCassutt 3-M · Mesa, AZThe acft collided with a street lamp while pulling up from a low pass over a dry river bed. This experimental amateur built acft was operating outside the prescribed boundaries for this acft. Witnesses disagreed on the engine sounds. Somedescribed the engine…Sep 10, 1983 · N2309E · DestroyedNTSB FTW83LA444Accident · No injuriesLimited investigationFinal reportClarks Pitt Special S1S · Manvel, TXThe acft buffetted abnormally during an aerobatic maneuver so the plt relaxed the 'g' loading on the airframe. The plt noted a concave deformity in the bottom of the left upper wing. Level flt was achieved to test the flt characteristics of the acft. Flt…Sep 10, 1983 · N2050 · Substantial damageNTSB ATL83LA363Accident · Minor injuriesLimited investigationFinal reportEipper Quicksilver MX II · Manteo, NCThe plt reported that while he was demonstrating a stall, the eng lost power & would not recover. Subsequently, he landed in a marsh & the ultralight acft nosed over. During an exam, water was found in the carburetor & fuel pump. The fuel tank cap was…Sep 10, 1983 · N242KH · Substantial damageNTSB ATL83FIG07Accident · 1 fatalFinal reportBellanca 8GCBC · Berlin, MDThe acft crashed into trees after the acfts landing gear became entangled in the banners tow bridle during an attempted banner pick-up. According to one witness who was a member of the banner crew on the field, the acft came in too low and caught the left…Sep 10, 1983 · N90916 · DestroyedNTSB LAX83LA430Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Huron, CAThe plt was spraying lettuce fields on a dark night. According to him, the wind was blowing from the north northwest & gusting to 12 KTS. He reported that during a turn-around over a plowed field, the wind was blowing dust which affected his visibility &…Sep 9, 1983 · N56070 · Substantial damageNTSB LAX83FA436Accident · 2 fatalField investigationFinal reportCessna 172N · Newport Beach, CAAbout 30 mins before the accident, the two plts stopped by a hangar to say hello to an individual. This person reported that the plt appeared to be intoxicated; his speech was slurred, he couldn't focus his eyes on things very easily & he giggled a lot. The…Sep 8, 1983 · N734RL · DestroyedNTSB ATL83LA361Accident · No injuriesLimited investigationFinal reportCessna 188 · Slocomb, ALThe plt stated that he pulled up from a swath run and the eng began loosing power. He climbed to 300 ft & started back to the airstrip, then a total power loss occurred. During an emergency landing, he was unable to stop before the acft collided with trees at…Sep 8, 1983 · N9829V · Substantial damageNTSB MKC83LA213Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Odessa, MOThe acft was making an aerial application turn when according to the pilot the engine quit. The landing was made in a stubble terraced field which collapsed the left main landing gear. During the landing the acft struck the rising terrainof a terrace and…Sep 7, 1983 · N459Y · Substantial damageNTSB ATL83LA358Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Estill, SCDuring a swath run, the acft began to lose power, so the plt aborted the mission & started back to the arpt to land. However, before reaching the arpt, the eng quit running & the plt landed in a field. During the landing, the acft was extensively damaged. An…Sep 7, 1983 · N4698 · DestroyedNTSB MIA83FA225Accident · 1 fatalField investigationFinal reportCessna A152 · Homosassa Sprgs, FLThe acft was first observed making low passes, almost striking trees & power lines. It then continued in a steep bank through about 90 deg of turn, rolled inverted & pitched down simultaneously. The acft impacted the ground in the parkinglot of a convenience…Sep 6, 1983 · N7597L · DestroyedNTSB FTW83LA420Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Los Alamos, NMThe acft was unable to climb above local mountainous terrain & attempted to make a 180 deg turn. The acft stalled & crashed on redondo peak.Sep 5, 1983 · N2380E · DestroyedNTSB ATL83LA355Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cameron, SCThe plt stated that he was on a trimming/swath run at about 15 ft AGL & 15 mph when he heard a strange noise which was followed by a 180 deg yaw. Subsequently, the helicopter crash landed, damaging the tail boom & tail rotor blades and spreading the landing…Sep 5, 1983 · N4029R · Substantial damageNTSB NYC83LA234Accident · No injuriesLimited investigationFinal reportCessna 305A · Seaside Heights, NJThe acft collided with a ditch during landing and nosed down. The pilot had made a low approach to pick up a banner but was unable to maintain airspeed and altitude. The banner was dropped but the acft continued to descend. The pilot flaredfor a normal…Sep 4, 1983 · N5179G · Substantial damageNTSB LAX83FA419Accident · 1 fatalField investigationFinal reportEaa Biplane A-1 · Mesa, AZThe acft was observed performing 2 or 3 consecutive loops at an altitude of about 1,000 ft. following the last loop, theacft pulled up to a near vertical attitude, stalled, slid straight down & entered a spin. The eng was heard running in an apparent normal…Sep 3, 1983 · N369Y · DestroyedNTSB CHI83LU012Accident · Serious injuriesFinal reportWeedhopper B · Fall Creek, WIThe ultralight collided with a powerline during maneuvering after takeoff. The pilot had made a normal takeoff and circled a hayfield and decided to return for landing. The pilot stated he had trouble controlling the acft in a left turn. During a turn the…Sep 3, 1983 · UNREG · DestroyedNTSB ANC83LA159Accident · Serious injuriesLimited investigationFinal reportCessna P206C · Kenai, AKAccording to the pilot, after a reduced power descent and cirling a moose at an alt of aprx 300 ft AGL, when throttle was added for climb, the eng failed to respond but continuedto operate at the reduced power level. In attempting a reduced power glide to a…Sep 3, 1983 · N8698Z · Substantial damageNTSB MKC83LA210Accident · No injuriesLimited investigationFinal reportCessna 188A · Klemme, IAThe acft inadvertently descended into the tops of a corn crop while dispensing smoke in preparation for spraying. The induced drag slowed the acft and it landed hard. The plt stated he diverted his his attn to the spray nozzles.Sep 2, 1983 · N9921G · Substantial damageNTSB DEN83LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Grand Junction, COThe CFI stated that while practicing emergency landings, smoke started billowing into the cockpit. She also noticed a lot of heat near her legs. Thinking that there might be a fire on the other side of the firewall, the CFI decided to land in a corn field.…Sep 2, 1983 · N8739T · Substantial damageNTSB CHI83FA407Accident · 2 fatalField investigationFinal reportCessna 152 · Anoka, MNThe plt rented the acft & reported that he & his friend would be going on a local flt. A witness stated that he saw the acft fly over at an estimated 1000 to 1500 ft AGL. Reportedly, the acft was in level flt when the plt 'cut' the power, the acft 'nosed up a…Sep 2, 1983 · N4975A · DestroyedNTSB ATL83LA352Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Tyler, ALThe plt reported that while he was spray a field, he was flying under 2 transmission lines. He reported that as he began spraying the field, there was a thunderstorm aprx 2 to 3 mi away & the air became 'rough.' As the acft was crossing under the 2nd wire on…Sep 2, 1983 · N8438K · DestroyedNTSB ATL83FU006Accident · 1 fatalFinal reportCondor II · Slate Hill, VADuring a local flt, the ultralight vehicle was observed approaching a residence in a shallow descent & with little eng noise. A witness stated that just prior to hitting a tall tree, the eng sound increased, the nose pitched up & the empennage struck tree…Sep 2, 1983 · UNREG · Substantial damageNTSB ANC83LA157Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Soldotna, AKWhile sightseeing the plt stated he saw a moose & made a sharp turn. The acft stalled but the plt recovered from the stall. During recovery the acft hit the top 8 ft of an 80 ft tree. The acft then spun to the ground.Sep 2, 1983 · N7536F · Substantial damageNTSB CHI83LA408Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Little York, INThe plt stated that he circled & looked for wires & obstructions prior to spraying. During a run he flew over a first set of wires but struck a second set of wires which were not marked & the poles were difficult to see because they were in trees. From the…Sep 1, 1983 · N9986G · DestroyedNTSB DEN83LA204Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Manning, NDThe acft collided with the ground after an eng failure while stringing power lines. The acft was in a right side low, nose high attitude pulling a wire attached to the left side of the acft. The wind was from the right rear quarter when the loss of power…Aug 31, 1983 · N400AH · Substantial damageNTSB DEN83FTE12Accident · Serious injuriesFinal reportPiper PA-25-260 · Lamar, COThe acft collided with the ground during an aerial application maneuver. The pilot stated that he finished the second spray run and while in a turn the acft hit the ground on flat terrain. The pilot stated that he did not remember anymoreabout the flt. A fuel…Aug 31, 1983 · N7606Z · Substantial damageNTSB ATL83LA348Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Clinton, KYThe plt reported that he was spraying a field that was bordered by obstacles. When he was about half way thru a procedure turn, the eng began 'backfiring & losing power.' The plt moved the throttle to about the 1/2 power setting, hoping the condition would be…Aug 31, 1983 · N5256 · Substantial damageNTSB ATL83LA347Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Blackshear, GAThe pilot stated that during a spray run, a vibration was felt, the engine backfired and flames erupted from the right underside of the cowling. Power was lost continuously until over the landing strip at 50 feet AGL when all power was lost. The acft landed…Aug 31, 1983 · N1635S · Substantial damageNTSB CHI83FA402Accident · 1 fatalField investigationFinal reportBeech 58P · Cassopolis, MIThe acft entered a flat spin while practicing VMC maneuvers. The right fuel valve was in the off position.Aug 30, 1983 · N88AX · DestroyedNTSB ATL83LA346Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Falkland, NCThe plt reported that during a pull-up from a swath run, the acft began to shake & lose power. He continued to climb with full throttle & was able to maintain altitude for a short time, then the eng had a total power loss. Reportedly, the acft collided with…Aug 29, 1983 · N4633Y · Substantial damageNTSB ATL83FKG11Accident · 1 fatalFinal reportCessna A188A · Jesup, GAThe plt was spraying a field that was bordered by tree lines on the north & south edges. While pulling up from a swath run at the south side of the field, the acft hit the top of a pecan tree. Reportedly, after impacting the tree, the acft pitched up, entered…Aug 29, 1983 · N5633J · Substantial damageNTSB SEA83FA187Accident · 3 fatalField investigationFinal reportCessna 182C · Near Elk River, IDThe acft collided with trees and crashed into heavily wooded area at about 4000 ft MSL. The purpose of flight was to look for game or areas for hunting in a pre-hunting game spotting trip. The acft first impacted a large 200 ft tree about 85 ft below its top.…Aug 28, 1983 · N8807T · DestroyedNTSB LAX83FU014Accident · 1 fatalFinal reportDavis Homebuilt · Byron, CAGround witnesses reported that the ultralight departed the private airstrip to the east. After departure the plt negotiated a 90 deg lt turn, followed by a 270 deg rt turn. After the 90/270 deg turn was completed, the plt negotiated a rt traffic pattern but…Aug 28, 1983 · UNREG · Substantial damageNTSB SEA83FA186Accident · Serious injuriesField investigationFinal reportCessna 150F · Bellingham, WAThe plt & passenger departed on a local sight-seeing flt. While flying low over the narrow part of lake samish, the acftcollided with a power line, then crashed in the water. The power lines were 129 ft above the water at the lowest point.Aug 27, 1983 · N7751F · DestroyedNTSB MKC83LA202Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Wayne, NEThe acft collided with the ground during an aerial application maneuver. The pilots attention was diverted when he was looking for 3 wheel vehicles so he 'wouldn't spray them'. He did not realize that a hill was in his path and could not pull-up soon enough.Aug 27, 1983 · N4777R · Substantial damageNTSB CHI83LU011Accident · Serious injuriesFinal reportPioneer Flightstar · Robinson, ILThe plt reported that after taking off, he stayed low over farm fields. He reported that he traveled about 1 1/4 mi from the arpt & decided to return & land. However, during a left turn, the ultralight vehicle crashed. The plt was seriously injured & did not…Aug 27, 1983 · UNREG · Substantial damageNTSB DEN83LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-25B-235 · Montrose, SDThe pilot stated that he was spraying a field that was divided in half by a 60 foot high powerline. As he made a turn to enter the south side of the field, parallel to the powerlines, flying east into the sun, he struck the unseen guy cables out in the field.…Aug 26, 1983 · N4473Y · Destroyed