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 NYC88DFJ04Accident · Serious injuriesFinal reportCallair A-9 · Churchville, NYThe pilot was engaged in aerial application activities. When he started a turn at low altitude to align himself for another spray run the aircraft stalled and struck the terrain.Sep 29, 1988 · N8402V · Substantial damageNTSB ATL88FA256Accident · 2 fatalField investigationFinal reportBellanca 14-19-3 · Oak Grove, ALSep 28, 1988 · N7637E · DestroyedNTSB LAX88DVM04Accident · No injuriesFinal reportWeatherly 201B · Soledad, CAThe pilot stated that after detecting smoke in the cockpit he turned off all electrical switches and made one more spray pass. After the pass, smoke became visible from the engine and part of the cowl separated. The engine lost power and the pilot executed a…Sep 27, 1988 · N1265W · DestroyedNTSB BFO88LA084Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Princess Anne, MDThe pilot reported that he had sprayed aprx 1/2 of the soybean field when smoke started to fill the cockpit. He shut off the spray, turned off the electrical system and opened the fresh air vents. He then looked back at the tail section of the airplane and…Sep 23, 1988 · N7781Z · Substantial damageNTSB LAX88DVA15Accident · No injuriesFinal reportSchweizer G-164A · Laton, CASep 22, 1988 · N9946 · Substantial damageNTSB CHI88FA240Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Oswego, ILInadequate design inthe manufacture of the pilot's seat which failed during intentional aerobatic maneuvers for which the aircraft including the seat were intended.Sep 20, 1988 · N50702 · DestroyedNTSB FTW88DRD21Accident · No injuriesFinal reportAir Tractor AT301 · Ferriday, LAThe agricultural airplane was on a swath run when the engine malfunctioned. The pilot released the load of chemicals and made a forced landing in a bean field. There was very little damage to the beans but there was substantial damage to the airplane.…Sep 19, 1988 · N31646 · Substantial damageNTSB NYC88LA237Accident · No injuriesLimited investigationFinal reportRobinson R-22 · W.Kingston, RIThe plt said it was a clear, calm night. When he got to his helicopter he found the windshield covered with a heavy dew. He cleaned the windshield but during takeoff the dew reformed on the windshield and he lost all visual references outside the helicopter.…Sep 17, 1988 · N47CS · Substantial damageNTSB LAX88FA319Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Springville, CAPilot used poor judgement in executing the second low pass and failed to follow normal v.f.r. go-around procedures. Contributing to this accident was the pilot's failure to maintain flying speed during the rapid pitch-up maneuver.Sep 17, 1988 · N604MM · DestroyedNTSB FTW88DPJ12Accident · 1 fatalFinal reportSnyder Stolp SA-300 · Oklahoma City, OKTotal failure of the rudder control due to failure of the metal welds on the cable attachment to the rudder pedal, due to improper welding by the manufacturer.Sep 17, 1988 · N57DH · DestroyedNTSB SEA88LA180Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Wenatchee, WAAfter takeoff, plt noted wind increasing. Plt then made downwind 300 ft AGL survey run of field to be sprayed abutting columbia river. In procedure turn over river at completion of run, acft encountered 'sinkhole' wihch plt could not counter with full power…Sep 16, 1988 · N8815C · Substantial damageNTSB DEN88LA205Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lund, UTThe private plt was spraying crops during an aerial application flight. During a right turn at the end of a spray run, he said he diverted his attention into the cockpit to check the metering rate, and may have inadvertently pushed the control stick forward.…Sep 15, 1988 · N9764 · Substantial damageNTSB ATL88LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gray, GAInstructor said that after completing a stall series the engine began to backfire continously & power was lost so that he could not maintain altitude. An off airport landing was made and a fence was hit during the landing roll. Eng had been overhauled &…Sep 15, 1988 · N32105 · Substantial damageNTSB LAX88LA310Accident · No injuriesLimited investigationFinal reportCessna 172F · Fairfield, CAThe pilot performed a soft field takeoff on a grass strip in winds gusting to 34 KTS. The airplane would not accelerate in ground effect, nor would it climb. Feeling that he could not out-climb objects in his path, the pilot turned to the right. As he turned…Sep 11, 1988 · N5149F · Substantial damageNTSB FTW88DPA07Accident · No injuriesFinal reportBölkow BO-105C · Dallas, TXThe helicopter made its approach to an open area on the westside of the airport to go to a refueling area on the south side of the airport. The pilot changed his mind and decided to go to the northeast side of the airport. He received tower approval but was…Sep 7, 1988 · N210BB · Substantial damageNTSB SEA88LA172Accident · No injuriesLimited investigationFinal reportYoung-Owens Cassutt 3M · Caldwell, IDOn test flt in preparation for reno air races, plt entered power dive at 10000 ft to 230 KTS and experienced vibrations. He reduced power and entered a steep nose high climb allowing the aircraft to decelerate to near stall speed. The vibration continued. At…Sep 6, 1988 · N67Y · DestroyedNTSB SEA88FA169Accident · 4 fatalField investigationFinal reportCessna 172E · Petersburg, AKPlt was briefed for marginal VFR conditions. Witnesses on departure noted fog bank offshore from airport. Witnesses near accident site, 10 mi from departure point, heard acft and sounds of impact. They reported fog on the water and glassy water conditions.Sep 5, 1988 · N3841S · DestroyedNTSB SEA88FA167Accident · 1 fatalField investigationFinal reportBritten-Norman BN-2A · Sitka, AKThe pilot encountered low ceilings, rain and fog while attempting to fly through a narrow mountain pass and successfully reversed course. He then flew into a small canyon off the main pass that terminated in a small glacier-covered bowl surrounded by steep…Sep 5, 1988 · N111VA · DestroyedNTSB CHI88FA203Accident · 2 fatalField investigationFinal reportPiper PA-20 · Claypool, INPilot-in-command's failure to maintain a sufficient visual lookout and perform a pull up in time to avoid collision with a tree.Sep 5, 1988 · N7791K · DestroyedNTSB CHI88DER14Accident · 1 fatalFinal reportHomebuilt Woodstock · Mankato, MNAircraft structural failure due to overload induced by pilot in the performance of unauthorized maneuvers.Sep 5, 1988 · N369DK · DestroyedNTSB CHI88FA231Accident · 1 fatalField investigationFinal reportCessna 172P · Boyne City, MIThe pilot and his passenger were flying low over a sailboat regatta to photograph sailboats. As the pilot maneuvered for a photograph, he throttled back and banked the aircraft in a steep bank. Subsequently, the aircraft stalled and there was insufficient…Sep 4, 1988 · N52601 · DestroyedNTSB FTW88FA160Accident · 4 fatalField investigationFinal reportCessna 170A · El Paso, TXPilot's impairment due to the influence of alcohol.Sep 3, 1988 · N9101A · DestroyedNTSB LAX88DVA14Accident · Minor injuriesFinal reportAyres S2R-T34 · Five Points, CAPlt was engaged in aerial application and had been overflying power lines. On last pass, plt elected to fly beneath power lines, struck bracing wire between poles with vertical fin, disabling elevator. The acft crashed nose down in a field in an uncontrolled…Sep 2, 1988 · N4009M · Substantial damageNTSB BFO88LA081Accident · No injuriesLimited investigationFinal reportArthur Acrosport 1 · Danville, VAThe acft was on a performance test flight when a power loss occurred at 1100 ft MSL. The plt unsuccessfully tried to restart the engine and made a forced landing in an open field. Examination of the acft revealed the rubber hose vent line was obstructed with…Aug 31, 1988 · N47TA · Substantial damageNTSB MIA88FA262Accident · 1 fatalField investigationFinal reportCommens Midget Mustang I · Davie, FLThe private pilot flying the homebuilt aircraft crashed into a swamp, and there were no witnesses. The aircraft was located 4 days later. Friends of the pilot recalled that in the 3 weeks prior to the accident the pilot had bragged to them about the high 'g'…Aug 30, 1988 · N35LC · DestroyedNTSB LAX88DVA13Accident · No injuriesFinal reportAyres 600-S2D · Los Banos, CAPlt was engaged in aerial application when no 9 cyl head cracked. Plt returned for precautionary lndg. On approach, oil obscured windshield. Plt missed landing area; landed in cultivated field beside landing area. Acft nosed over.Aug 30, 1988 · N1779S · Substantial damageNTSB ATL88DKG15Accident · Minor injuriesFinal reportRockwell S2R · Pelham, GAThe crop duster had completed the third swath run of the morning when the engine began to lose power. The plt released the contents of the hopper and made a forced landing in a soybean field. During the landing roll, the airplane nosed over and a ground fire…Aug 30, 1988 · N4887X · DestroyedNTSB MKC88FA166Accident · Serious injuriesField investigationFinal reportCessna 150 · Reed Springs, MOThe accident aircraft was observed performing high speed passes at extremely low altitude over the lake. Witnesses estimated the altitude of the aircraft from 30 to 75 feet above the water. The aircraft struck 72,000 volt power lines at a point approximately…Aug 29, 1988 · N3475V · Substantial damageNTSB DEN88LA195Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rawlins, WYPlt and pax were on a flight from milwaukee, WI, to las vegas, NV. The plt made an unscheduled stop at Rawlins due to poor vis and low fuel. The airplane was loaded with suit cases, camping gear, coolers and full fuel. The pilot and pax combined weight was…Aug 29, 1988 · N5873U · Substantial damageNTSB CHI88LA221Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Burnsville, MNDuring a local pleasure/aerial photography flight, the pilot failed to handle the aircraft properly. Subsequently the pilot was unable to maintain sufficient airspeed and/or altitude to remain clear of obstacles. The aircraft was configured for slow flight as…Aug 27, 1988 · N5561G · Substantial damageNTSB BFO88LA076Accident · No injuriesLimited investigationFinal reportRobinson R22A · Gaithersburg, MDThe flt was initiated with the student plt bringing the helicopter up to a hover with some forward speed. The student rapidly and forcefully applied aft cyclic. The CFI was unable to compensate in time, even though he was on the controls with the student. The…Aug 27, 1988 · N8559A · Substantial damageNTSB BFO88DID04Accident · 1 fatalFinal reportPiper PA-25-250 · Waverly, VAThe acft contacted pwr lines, crashed and burned during an aerial appliation flt. Witnesses reported that it looked as if the plt descended to fly under the lines when it suddenly pulled up and contacted them.Aug 25, 1988 · N8668L · DestroyedNTSB SEA88FA160Accident · 3 fatalField investigationFinal reportAero Commander 100-180 · John Day, ORWhile elk spotting in mountainous terrain, the aircraft collided with trees in a nose low turn similar to the intermediate stages of a stall. A severe post impact fire erupted. The density altitude at the accident site elevation was approximately 10,100 feet.…Aug 24, 1988 · N4175X · DestroyedNTSB ATL88LA235Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rock Hill, SCThe plt reported that the engine began to run rough & lose pwr while he was circling some property he owned. He subsequently attempted to land at a nearby ultralight airstrip. He stated that he didn't remember anything after that. The airstrip owner reported…Aug 23, 1988 · N3105J · Substantial damageNTSB LAX88DVA11Accident · 1 fatalFinal reportTedford VARI-EZE · Mariposa, CAAcft observed to dive into grnd. Investigation revealed inflt breakup and separation of canards. Exam of canards revealed modification to increase chord improperly done, adding excess weight aft of CG and making components subject to flutter. One mounting…Aug 22, 1988 · N707LT · DestroyedNTSB ATL88DMG08Accident · No injuriesFinal reportPiper PA-25-235 · La Grange, NCThe pilot reported that the spray boom collided with a tree, resulting in the left aileron being jammed in an uncontrollable position. The acft impacted in a field.Aug 22, 1988 · N8819L · Substantial damageNTSB ATL88DLT02Accident · No injuriesFinal reportGrumman G-164B · Dancyville, TNAug 22, 1988 · N6783K · DestroyedNTSB LAX88DVA12Accident · No injuriesFinal reportAyres S2R · Kerman, CADrg an aerial application flt, the eng lost power & a fire started in the eng compartment when a fuel line failed, just forward of the fire wall. The plt made a successful landing in an open field, but the acft was substantially damaged due to the fire.Aug 20, 1988 · N8930Q · Substantial damageNTSB FTW88DRD19Accident · No injuriesFinal reportSchweizer G-164B · Catahoula, LAThe ag airplane was being utilized to scare birds away from the rice fields. It was 15 feet AGL when the engine backfired and quit. The airplane collided with the terrain and burned. The engine and engine accessories were so destroyed by fire that nothing…Aug 20, 1988 · N6685Q · DestroyedNTSB MKC88LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hebron, NEWhile making a aerial application swath run, the pilot was checking his spray booms because of some malfunctioning nozzles. Exiting the field between two groups of trees on the border he failed to see power line poles. He struck the wires, then the terrain,…Aug 19, 1988 · N5329 · DestroyedNTSB LAX88LA290Accident · No injuriesLimited investigationFinal reportCessna T210N · Santa Paula, CADuring a cross country flight, the pilot diverted to a closer airport due to a low fuel state. The pilot was unable to land the airplane on the first attempt. During the second attempt, the engine quit. The pilot made an emergency landing where during the…Aug 19, 1988 · N1199U · Substantial damageNTSB SEA88LA155Accident · 1 fatalLimited investigationFinal reportMace R-2 · Reno, NVAcft had been fitted with new outer wing panels of elliptical design and was on sixth test flight for racing certification, exploring g envelope. Investigation revealed right outer panel separated in flight during maneuvering. Failure occurred in center…Aug 18, 1988 · N711HM · DestroyedNTSB SEA88FA156Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 Mark 1 · Sitka, AKWhile on a flight from Sitka to rowan bay, Alaska, the pilot flew up a valley intending to cross a pass whose elevation was 2745 feet MSL. Upon approaching the pass the pilot encountered clouds which prevented his transit. The pilot then executed a 180 degree…Aug 18, 1988 · N64398 · DestroyedNTSB ANC88LA115Accident · No injuriesLimited investigationFinal reportPiper PA-12 · King Mountain, AKThe pilot-in-command was maneuvering through a valley for the second time. During the second pass the engine lost power. Mixture was full rich, and the pilot applied carburetor heat and when nothing happened he turned the carburetor heat off. He attempted a…Aug 18, 1988 · N5461Y · Substantial damageNTSB LAX88DUG06Accident · Minor injuriesFinal reportHiller UH-12E · Thermal, CAShortly after refueling the helicopter & reloading the hopper, the plt took off & was starting to spray a field when the eng suddenly lost power. The plt said the helicopter was dscndg from about 30 ft when the power loss occurred; thus, he barely had time to…Aug 17, 1988 · N65120 · Substantial damageNTSB CHI88DEP11Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Plover, WIThe aircraft collided with a farm machinery shed during an aerial application maneuver. The pilot stated that there was no powerplant or control malfunction. The temperature at the accident site was 87 degrees (f), with a calculated density altitude of 2944…Aug 17, 1988 · N8495 · Substantial damageNTSB ATL88DMG07Accident · No injuriesFinal reportCessna A188B · Oak City, NCAug 16, 1988 · N8284G · Substantial damageNTSB SEA88LA153Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Oreana, IDPlt was circling a friend's ranch at low alt when acft began an uncommanded left roll. Plt was able to level wings before ground contact in rough terrain. Investigation revealed aileron attach bolt missing. Aileron had just undergone repair.Aug 15, 1988 · N9806Y · Substantial damageNTSB NYC88FA218Accident · 1 fatalField investigationFinal reportCessna 172K · Island Falls, MEPilot's poor in-inflight decisions and planning and failed to follow ATC directives to maintain VFR. The pilot continued VFR into IFR conditions and collided with hilly terrain.Aug 15, 1988 · N1183M · DestroyedNTSB LAX88DVA10Accident · No injuriesFinal reportAyres S2R-T34 · Huron, CADuring an aerial application flight at night, the airplane's vertical stabilizer collided with a transmission wire. Subsequently, the vertical stabilizer & rudder were dislocated & directional control was lost. Realizing he had lost directional control, the…Aug 14, 1988 · N40071 · Substantial damage