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 BFO87LA032Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Manassas, VAThe student, under the supervision of the instructor, was practicing hovering; about 5 ft AGL. The stu had been overcontrolling the acft and each time the instr would take corrective action to stabilize the acft. The accident occurred when the stu…Apr 26, 1987 · N2486N · Substantial damageNTSB MKC87LA090Accident · No injuriesLimited investigationFinal reportCessna A188B · Orleans, NEThe pilot stated that he was spraying a wheat field with a load of chemicals, and was completing his fourth swath run, when he noticed powerlines in his flight path. He performed an evasive maneuver; however, the aircraft struckthe powerlines. The aicraft…Apr 25, 1987 · N6048G · Substantial damageNTSB DEN87FA111Accident · Serious injuriesField investigationFinal reportTaylorcraft F21 TC · Boulder, COThe flt instructor and student plt were practicing night touch and go landings. Flt instructor reduced engine power to idle after takeoff to simulate an engine failure. He banked the acft 'steeply' to the left at a low altitude. The acft struck the ground in…Apr 25, 1987 · N2005C · Substantial damageNTSB LAX87LA189Accident · 4 fatalLimited investigationFinal reportCessna 172N · Lihue, HIThe pilot filled the aircraft's fuel tanks, loaded three air tour passengers and proceeded up a canyon that climbed up to an elevation of about 3000 feet MSL on a sightseeing flight. A ground tour bus driver observed smoke emanating from the canyon and…Apr 24, 1987 · N739RV · DestroyedNTSB LAX87DUM02Accident · No injuriesFinal reportRockwell S2R · Imperial, CADuring an aerial application applying sulphur, the sulphur ignited inflight. The pilot turned the aircraft back toward the airport; however, the cockpit filled with smoke and the pilot decided to land on a road. Due to the extent of fire damage it could not…Apr 24, 1987 · N4194X · Substantial damageNTSB DEN87LA100Accident · Minor injuriesLimited investigationFinal reportAero Commander A-9B · Wood, SDA commercial ag plt was working a field with 2-4-D and had been spraying for 15 minutes. On a turn to reverse direction at the end of a pass, the plt started a 45 degree bank pull up and added full throttle. The engine then had a partial power loss and began…Apr 24, 1987 · N2755V · DestroyedNTSB LAX87DJA06Accident · Serious injuriesFinal reportSchweizer SGS2-33 · Mokuleia, HIDuring a local sightseeing flt along a ridge line, while maneuvering around a cloud build-up, the acft entered a windshear that suddenly nosed the acft over in an aprx 75 deg vertical dive. Just prior to colliding with trees, the plt was able to regain some…Apr 23, 1987 · N11468 · DestroyedNTSB FTW87LA101Accident · Serious injuriesLimited investigationFinal reportSikorsky S-55B · De Quincy, LAThe pilot experienced an engine surge followed by a complete loss of power during a swath run of a tree spraying ag operation. The helicopter was over a densely wooded area and autorotated into trees. The owner was aware of a carburetor problem and had…Apr 23, 1987 · N414A · Substantial damageNTSB MIA87LA142Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Dundee, MSThe plt stated that when reversing direction after an aerial application maneuver the eng quit. He then landed the acft in a creek due to insufficient altitude to clear trees that were in the flight path. Upon touchdown the acft nosed over and came to rest…Apr 22, 1987 · N3652B · Substantial damageNTSB ATL87DEI02Accident · No injuriesFinal reportBell B-206-1 · Youngstown, OHWhile hovering from the wash rack, the helicopter backed into a utility pole. The main rotor system separated from the airframe following the collision. There were no postimpact mechanical malfunctions/failures.Apr 22, 1987 · N79RR · Substantial damageNTSB ATL87LA121Accident · No injuriesLimited investigationFinal reportBell UH-1B · Bay Minette, ALDuring a logging operation, the helicopter experienced a complete engine failure shortly after attempting a pickup. The pilot entered an autorotative glide. The helicopter impacted the water and sank. The wreckage examination disclosed that the compressor…Apr 21, 1987 · N88987 · DestroyedNTSB NYC87LA129Accident · No injuriesLimited investigationFinal reportBell 47G · Bethel, PAThe student pilot lost directional control of the helicopter and as the instructor pilot attempted to regain control, the main rotor blades struck the ground causing substantial damage to the aircraft.Apr 20, 1987 · N59321 · Substantial damageNTSB MKC87FA083Accident · Serious injuriesField investigationFinal reportAeronca 11AC · Stillwell, KSThe pilot stated that this flight was to be a photographic, pleasure trip involving two aircraft. After several aerial photos were taken of each other's aircraft, both airplanes landed at the accident airport. The PIC and his passenger then took-off while the…Apr 19, 1987 · N85846 · Substantial damageNTSB FTW87DRA02Accident · No injuriesFinal reportHunter Executive · Arcola, TXThe acft was being test flown following the replacement of a tail rotor drive belt. Following a ground run up and ground taxi, several hovering flts were made successfully. As the non-helicopter rated plt was hovering back to the parking area, he heard the…Apr 18, 1987 · N9728N · DestroyedNTSB MKC87LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Kipp, KSThe engine crankshaft broke into two pieces during an ag flight and during the forced landing in a wet, soft field, the airplane nosed forward to the inverted position.Apr 17, 1987 · N8599L · Substantial damageNTSB LAX87LA179Accident · Minor injuriesLimited investigationFinal reportBell 206B-II · Yucaipa, CAA Bell 206B went out of control and crashed while lndg at a 5,720 ft high helipad. The plt indicated that he terminated the aprch at a 8-10 ft hover and began to spin to the right with full left pedal applied. After 1 1/2 to 2 turns the plt atmptd to fly out…Apr 16, 1987 · N76EF · DestroyedNTSB FTW87DRD04Accident · No injuriesFinal reportGrumman G-164 · Rayne, LAThe aircraft's engine lost power and stopped while maneuvering. The aircraft impacted a dirt bank and nosed over in soft dirt/mud during the forced landing. Water was found in the fuel system and water was also found in the fuel tank of another aircraft…Apr 16, 1987 · N10259 · Substantial damageNTSB DEN87LA101Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Argusville, NDThe plt took off with a load of 46-0-0 fertilizer and proceeded to the field to be treated. The plt said when he arrived his flagger was not in position so he initiated a goaround. When the plt had turned 90 deg onto the x-wind leg the acft stalled. The plt…Apr 16, 1987 · N63915 · Substantial damageNTSB LAX87LA178Accident · 1 fatalLimited investigationFinal reportBell 206B · Laupahoehoe, HIThe pilot of the Bell 206B and his three passengers arrived over a beached barge that they were to land on. The pilot hovered over the barge in a left quartering tailwind of about 10 knots and over a moderate sea with waves breaking against the barge. The two…Apr 15, 1987 · N370AH · DestroyedNTSB MIA87LA133Accident · Minor injuriesLimited investigationFinal reportBell 206L · Miami, FLUnlicensed pilot lost control of helicopter while in hover while attempting to steal the helicopter. The aircraft crashed to earth and rolled over. The pilot was on probation for attempting to steal a helicopter on a previous occasion. The plt received minor…Apr 12, 1987 · N16780 · Substantial damageNTSB NYC87FA120Accident · 4 fatalField investigationFinal reportCessna 172P · Berwick, METhe acft was observed doing stalls. A witness said that prior to the crash he saw the nose lower and the right wing drop. The aircraft then entered into a spiral. It was observed descending into trees in a spiral. The plt was found in the right front seat.…Apr 11, 1987 · N55309 · DestroyedNTSB LAX87FA173Accident · Serious injuriesField investigationFinal reportHughes 369E · Palm Desert, CAThe helicopter dscndd uncontrolled & crashed in a residential area. After the acdnt, the plt said he agreed to orbit the residence of his pax. At the aprx 135 deg point of a left orbit, he felt 'a bang & severe vibration in the tail.' The plt lost drctnl ctl…Apr 11, 1987 · N5200W · Substantial damageNTSB FTW87DRG01Accident · 1 fatalFinal reportDavis Pitts S-1S · Coleman, TXThe pilot had completed several aerobatic maneuvers for an air show and was in the process of doing a series of five snap rolls at an altitude of 200-300 feet AGL when the accident occurred. Witnesses observed the nose of the acft to drop during the third…Apr 11, 1987 · N90DW · DestroyedNTSB LAX87FA172Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Malibu, CAThe plt & his 3 passengers met at a bar then decided to go on a local night scenic flt. Subsequently, the acft crashed into the ocean as the plt was demonstrating low flt over the water. The plt & 1 passenger were hospitalized & treated for injuries &…Apr 10, 1987 · N4304F · DestroyedNTSB DEN87LA089Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bountiful, UTThe stud plt was practicing stalls about 10 n of arpt. During recovery from a stall the eng began to run rough. The plt said he advanced throttle, applied carb heat, and tried to adjust mixture. The eng continued to run rough and lose pwr and the plt returned…Apr 8, 1987 · N4970B · Substantial damageNTSB DEN87FA091Accident · 1 fatalField investigationFinal reportGrumman G-164A · Lamar, COThe aircraft had completed a formation aerial application operation and were in the process of single airplane spraying around the perimeters of a field. They collided at 10 feet above the ground on perpendicular flight paths, descended out of control and…Apr 8, 1987 · N8369 · 2 aircraft · DestroyedNTSB DEN87FA090Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Berthold, NDThe plt took off to the east from a farm driveway to return home. Witnesses saw the airplane make an immediate right turn, followed by a left turn at aprx 35-50 ft AGL. The acft approached the farm at aprx 50-100 ft AGL. The acft suddenly pulled up, banked…Apr 7, 1987 · N88177 · DestroyedNTSB DEN87LA087Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · La Salle, COWhile conducting an aerial application flt, the plt misjudged the distance to the end of the field and initiated the pull-up too late to avoid impact with a tree. After striking the tree, the acft descended out of control until impact with the ground.Apr 6, 1987 · N72PB · DestroyedNTSB SEA87LA074Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Forks, WADuring external load operation the aircraft's engine ceased operating. The helicopter was too close to the ground for recovery. The helicopter descended, struck the ground hard and then rolled over onto its right side. Water in the fuel was discovered after…Apr 3, 1987 · N8356F · DestroyedNTSB CHI87DER03Accident · No injuriesFinal reportHiller UH-12ET · Big Lake, MNAircraft was being maneuvered for landing on a ground support trailer when it experienced a power failure. Due to high trees autorotation was made to adjacent field. Aircraft landed on rough/uneven terrain and rolled over. Investigation revealed contaminated…Apr 3, 1987 · N135HA · Substantial damageNTSB MKC87LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Tribune, KSThe pilot stated that he was spotting stray cattle after a snow blizzard moved through the region. Two hours into the flight, the pilot further stated, he reduced engine power for approximately 10 seconds--without carburetor heat. The engine then sputtered…Mar 31, 1987 · N89547 · Substantial damageNTSB MIA87LA132Accident · No injuriesLimited investigationFinal reportCessna 172M · Clarksdale, MSThe pilot stated that while flying at a low altitude over a dried up lake bed the aircraft collided with an unmarked telephone wire. A landing was made in a field where damaged was inspected. The pilot then elected to takeoff and return to the departure…Mar 28, 1987 · N12497 · Substantial damageNTSB CHI87FA104Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Frankfort, ILAircraft control was lost as the pilot attempted to descend to his assigned altitude of 5000 feet from excessive climb. He was in IFR conditions at the time. The airframe broke apart, empennage first, during the uncontrolled descent to the ground due to high…Mar 27, 1987 · N452BH · DestroyedNTSB ATL87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Bainbridge, GAThe acft collided with trees while conducting an ag training flight. The training program was part of the locust control in central and southern africa. There was an instructor on the ground who acted as a radio controller for the flight. The pilot failed to…Mar 26, 1987 · N6699Z · Substantial damageNTSB MIA87FA118Accident · 1 fatalField investigationFinal reportAero Mirage TC-2 · Williston, FLWitnesses stated that the acft made a 'fly by' at 300 ft to check and see if the gear was down. The ground personnel informed the plt that the gear appeared to be down. They stated that the acft then made a sharp left turn paralleling runway 14, they lost…Mar 25, 1987 · N2484V · DestroyedNTSB MIA87FA114Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Miami, FLThe recently rated private pilot took three passengers for an airplane ride in his airplane that was over gross weight upon departure. During the flight he was performing low level dives at trees with rapid pull ups. During the last pull up the aircraft went…Mar 20, 1987 · N726FL · DestroyedNTSB LAX87FA151Accident · Serious injuriesField investigationFinal reportCessna T210K · Prescott, AZAfter overloading the aircraft with 5 pax and baggage, the pilot departed on a personal cross country flight to phoenix, AZ. He climbed the acft to and maintained an altitude of 14,500 feet MSL until reaching salt lake city, UT. The aircraft was then…Mar 20, 1987 · N8105G · DestroyedNTSB ATL87FA088Accident · 3 fatalField investigationFinal reportBeech C23 · Semora, NCWhile conducting a local aircraft checkout, the aircraft was observed flying low prior to pulling up to avoid colliding with a utility line crossing the intended flt path. The aircraft crashed into an open field in a nose low vertical attitude. The post…Mar 20, 1987 · N18879 · DestroyedNTSB LAX87LA157Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Phoenix, AZDuring factory flt training, prior to delivery of the new helicopter to the owner, the CFI said he asked the student to perform a series of emergency procedures which included quick stops from an initial takeoff followed by hovering autorotations. The CFI…Mar 19, 1987 · N1601Y · Substantial damageNTSB LAX87FA147Accident · 2 fatalField investigationFinal reportRobinson R-22-A · Scottsdale, AZA loss of control in flight for undetermined reasons.Mar 16, 1987 · N2256M · DestroyedNTSB LAX87FA146Accident · 2 fatalField investigationFinal reportCessna 182R · Avenal, CAThe plt, with suspended commerical privileges & no current medical cert, borrowed his parents acft. While flying along an interstate highway at night, the acft collided with electrical transmission lines & crashed. Initial impact occurred at about 115' AGL.…Mar 16, 1987 · N3143E · DestroyedNTSB FTW87DPJ04Accident · No injuriesFinal reportAir Tractor 301 · Oluskee, OKDuring aerial application the engine sustained a power loss due to separation of the number 9 cylinder head. During the forced landing in rough terrain the aircraft was substantially damaged.Mar 14, 1987 · N8865S · Substantial damageNTSB ANC87DAG01Accident · No injuriesFinal reportRotorway Scorpion 1670 · Soldotna, AKThe pilot stated that he lost directional control of the aircraft while just a few feet above the ground resulting in substantial damage to the aircraft.Mar 14, 1987 · N48591 · Substantial damageNTSB DEN87FA066Accident · Serious injuriesField investigationFinal reportRockwell 680FL · Basalt, CON4581E was operating under 14 CFR 135 carrying cargo. The plt stated that he departed VFR and had '7 to 10' mi vis at the acdt site. Witnesses at and near the acdt site stated that heavy snow was falling at the time of the acdt and the vis was 1 mi or less.…Mar 13, 1987 · N4581E · DestroyedNTSB LAX87LA140Accident · No injuriesLimited investigationFinal reportHughes 269D · Palmdale, CADuring an external load operation, the engine lost power. The aircraft collided with the terrain and rolled over. Inspection of the engine revealed an overtemperature to the first and second stage turbine wheel airfoils.Mar 10, 1987 · N1103V · Substantial damageNTSB ATL87FA087Accident · 1 fatalField investigationFinal reportCessna 150H · Oneida, TNThe pilot contacted the fss several times during the morning for weather along his proposed route of flight. Shortly after lunch he departed without a flight plan. He reported to one fss that he was VFR only but continued although VFR was not recommended for…Mar 9, 1987 · N50077 · DestroyedNTSB LAX87LA137Accident · No injuriesLimited investigationFinal reportCessna 172C · Kahului, HIThe acft collided with trees while manuevering in mountainous terrain. The plt had planned a local flight from honolulu to maui and return. Once over the island of maui, the plt notified the fss that he was changing his route and would be passing through the…Mar 8, 1987 · N6353F · Substantial damageNTSB FTW87DPJ03Accident · Minor injuriesFinal reportBoeing B75N1 · Fairmont, OKDuring the pull up at end of swath run pilot misjudged power line clearance. Top line caught on aircraft and caused uncontrolled descent to ground.Mar 8, 1987 · N5102N · Substantial damageNTSB ANC87LA045Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kotzebue, AKThe pilot stated that he encountered a complete whiteout condition and during the emergency landing on the frozen lake he lost directional control of the aircraft causing the left wing to strike the ground.Mar 8, 1987 · N67688 · Substantial damageNTSB ANC87FA043Accident · No injuriesField investigationFinal reportBell 47G-2 · Anchorage, AKA flight instructor and his commercial rotorcraft student were practicing quick stops to a hover at low altitude over a snow covered non-maintained airstrip. The student, a commercially rated fixed wing pilot, had successfully completed three quick stops, but…Mar 7, 1987 · N6140C · Substantial damage