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 ATL88DKG08Accident · No injuriesFinal reportSikorsky S-55B · Valdosta, GAJun 16, 1988 · N6489 · Substantial damageNTSB DEN88DTM02Accident · No injuriesFinal reportEagle DW-1 · Enterprise, UTThe plt reported that he had been going under a powerline that ran across the fld being treated. On the acdt pass he lost sight of the powerline and pulled up into the line. The visibility was unrestricted and the pass was being made north to south at mid…Jun 11, 1988 · N8807E · DestroyedNTSB LAX88DUG04Accident · Serious injuriesFinal reportBushby Mustang II · Upland, CADuring a pleasure flight, while flying s turns and lazy eights, the canopy suddenly separated from the airplane. The airplane was landed without further incident. The canopy was not recovered. The reason for the separation was not determined.Jun 10, 1988 · N1AZ · Minor damageNTSB ATL88DLQ01Accident · No injuriesFinal reportByron/Sorrell SNS-2 · Morehead, KYInflight separation of both propeller blades from the acft for undetermined reasons.Jun 8, 1988 · N112CB · Substantial damageNTSB NYC88FA158Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Enon Valley, PAThe aircraft was observed maneuvering at low altitude. The nose was observed to drop and a left rotation started. One witness said the rotation stopped before the aircraft disappeared behind a tree line. The aircraft caught fire within one minute of impact…Jun 7, 1988 · N2317N · DestroyedNTSB MKC88LA107Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Hazen, ARWhile performing an aerial application operation at dawn, the plt struck a levee. He attributed the acdt to low light intensity, a dirty windscreen and encountering his own wake turbulence. The main gear was sheared off, then the aircraft nosed down, slid for…Jun 7, 1988 · N8027K · Substantial damageNTSB DEN88DTE05Accident · No injuriesFinal reportPiper PA-25-235 · Limon, COThe plt reported that he was making his third swathrun when the eng quit. He attempted a forced landing but the acft nosed over. The plt said he had 15 gal of fuel on board at takeoff and had been airborne about 15 min. The FAA a/w insp who examined the…Jun 7, 1988 · N8678L · Substantial damageNTSB NYC88LA160Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Westerly, RIThe instructor pilot stated that after executing several straight-in and 180 degree autorotations they decided to attempt some hovering autorotations. After executing the first one successfully in a tailwind situation, the student initiated the second one,…Jun 5, 1988 · N580H · Substantial damageNTSB LAX88DVM02Accident · Minor injuriesFinal reportBell 47G5 · Oceano, CAJun 5, 1988 · N1316X · Substantial damageNTSB LAX88DVD04Accident · 1 fatalFinal reportBellanca 8KCAB · Geyserville, CADuring an aerobatic maneuver in front of family and friends the pilot entered an intentional spin starting at approximately 500 ft AGL. The aircraft collided with the ground in a nose low, wings level attitude. Witnesses stated that the aircraft did not…Jun 5, 1988 · N5061W · DestroyedNTSB LAX88LA211Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Lakeport, CADuring a banner tow operation, the plt tried to release the banner. When the banner did not disconnect, the plt turned to see what the problem was. The airplane stalled and before the plt could regain control, it collided with the terrain. Inspection of the…Jun 4, 1988 · N9124C · Substantial damageNTSB DEN88DTK01Accident · Serious injuriesFinal reportEagle DW-1 · Ferney, SDThe ag plt reported that he encountered a 'dust devil' while in a climbing turn during a turnaround at the end of a swath run. He said he attempted to counter the turbulence enduced roll with appropriate flt control inputs but the acft did not recover and…Jun 4, 1988 · N8802Z · DestroyedNTSB DEN88FA119Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Maljamar, NMWhile in slow flt at low level on a oil pipeline patrol demonstration flt, the acft entered a left turn and, according to witnesses, the nose suddenly dropped and the acft crashed in a vertical attitude. The acft was destroyed in the accident and both…Jun 2, 1988 · N1393R · DestroyedNTSB ANC88FA065Accident · 3 fatalField investigationFinal reportCessna 172N · Hatcher Pass, AKThe aircraft crashed at the 3100 foot level of a mountain Pass. The aircraft was destroyed by ground impact and fire, and the pilot and the two passengers were fatally injured. Witnesses near the crash site stated the aircraft was maneuvering very low above…Jun 2, 1988 · N3327E · DestroyedNTSB MIA88LA186Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Callahan, FLWhile maneuvering the helicopter during an aerial application flt the eng quit. During the autorotative landing the helicopter landed hard. Examination of the eng revealed the accessory drive gear, which is attached to the crankshaft by 6 AN-4A bolts with the…Jun 1, 1988 · N9080T · Substantial damageNTSB MIA88LA185Accident · No injuriesLimited investigationFinal reportBost Pitts S-1C · Miami, FLThe plt stated that he was performing a tail-slide maneuver when the eng suddenly quit. He attempted to restart eng. When eng would not restart, he elected to lnd a/c in a fld. During landing roll, the a/c nosed over. FAA stated that the carb was damaged…Jun 1, 1988 · N36GB · Substantial damageNTSB MIA88LA183Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Gretna, FLWhile on an aerial application flt, the plt stated he maneuvered the helicopter to release the remaining chemical. He then heard a loud 'screeching' noise followed by silence as the eng quit. The helicopter landed hard breaking the skids. It came to rest on…Jun 1, 1988 · N4029R · Substantial damageNTSB MKC88LA104Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hickory Ridge, ARWhile executing a standard procedure aerial application turn around maneuver, the acft began to settle. The plt dumped his remaining chemical load, but acft continued to settle, and mushed into the trees. Post accident fire destroyed the acft, but the plt…May 31, 1988 · N9653 · DestroyedNTSB CHI88FA120Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Wautoma, WIPerformance of an aerobatic maneuver with insufficient altitude for recovery.May 31, 1988 · N28156 · DestroyedNTSB SEA88LA101Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lester State, WAThe pilot inadvertently flew into a narrow valley with trees on both sides and steep rising terrain during climb to cruise. The aircraft was not able to outclimb the rising terrain, so the pilot slowed the aircraft to 40 m.p.h. and attempted a shallow…May 30, 1988 · N20580 · DestroyedNTSB MKC88LA100Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Bismark, MOThe accident aircraft was observed making several low passes over lake Bismark near Bismark, Missouri. Witnesses stated that, following the last pass, the aircraft contacted the water and sank. The pilot's blood alcohol content was analyzed as .14 percent…May 29, 1988 · N8122V · Substantial damageNTSB FTW88DQG05Accident · 1 fatalFinal reportPiper PA-25-260 · Stratford, TXWhile maneuvering during an aerial application flt, the pilot allowed the right wing to contact the ground. The aircraft was destroyed in the accident with fatal injuries to the pilot.May 29, 1988 · N8810L · DestroyedNTSB FTW88DQA01Accident · 1 fatalFinal reportAerotek Pitts S2S · El Paso, TXPilot's failure to complete the aerobatic maneuver in a manner which insured adequate terrain clearance at the termination.May 29, 1988 · N5333N · DestroyedNTSB SEA88LA106Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Elgin, ORThe purpose of the flight was for the pilot to practice for his aerial applicators certificate. Water was being used instead of chemical. The pilot reported that as the aircraft began to accelerate during takeoff it began to oscillate. As in prior…May 28, 1988 · N370FH · Substantial damageNTSB FTW88DRD05Accident · No injuriesFinal reportGrumman G-164B · Bastrop, LAThe plt said he was spreading rice when he noticed the oil pressure was decreasing & the prop was beginning to feather. With no other place to go, he landed in a plowed field. Shortly after touchdown, the acft nosed over to an inverted position. An exam…May 28, 1988 · N6676K · Substantial damageNTSB DEN88FA115Accident · 3 fatalField investigationFinal reportMooney M20 · Jamestown, COThe plt told a friend that he was going to conduct a sightseeing flt in the local area. Residents of a small town 2 miles from the acdt site said the acft circled the town at low alt several times at about the time of the accident. There were no witnesses to…May 28, 1988 · N5279B · DestroyedNTSB BFO88DIG03Accident · Serious injuriesFinal reportGrumman G-164A · Sleepy Creek, MDDuring the aerial application flight the airplane struck and severed three power lines. The pilot stated he did not see the lines until it was too late. The airplane caught fire and continued on its flight path crossing a highway and a river. The airplane…May 26, 1988 · N4327 · DestroyedNTSB MIA88FA178Accident · Serious injuriesField investigationFinal reportRockwell A9B · Marianna, FLThe acft sustained a complete & sudden power loss while engaged in ag operations at low alt. The prop, fwd portion of the crankshaft, cyl head & other eng parts separated from the acft. The acft struck a row of 40 ft trees & crashed to the grnd. An exam of…May 25, 1988 · N7787V · Substantial damageNTSB CHI88DEC02Accident · 1 fatalFinal reportChappel Ratsrepus 300 · Pontiac, MIDestructive wing/aileron flutter is suspected, but not sufficiently substantiated through research and calculations to be cited as the probable cause of this accident.May 25, 1988 · N889HC · DestroyedNTSB ATL88MA184Accident · 4 fatalMajor investigationFinal reportLearjet 35A · West Paterson, NJWitnesses rpted a normal takeoff. Radar indicated the acft turned right as cleared and began cruise at 1900 ft, hdg nw at 235 KTS. 65 secs after calling clear of the control zone the acft's radar track ended. The acft was fragmented by theimpact with all flt…May 24, 1988 · N500RW · DestroyedNTSB LAX88LA193Accident · No injuriesLimited investigationFinal reportRobinson R22 · Paso Robles, CADuring a local introductory instructional flight, the student lost control of the helicopter. The flight instructor was unable to take control before the tail rotor contacted the ground. The helicopter collided with the terrain and rolled over.May 21, 1988 · N32Y · Substantial damageNTSB DEN88FA110Accident · 2 fatalField investigationFinal reportCessna 152 · Heber City, UTThe CFI and student plt were on a round-robin cross-country flt. A witness near the accident site said he saw an airplane flying 'up a canyon quite slow and low'. The airplane was reported overdue and found the next day in a 'box canyon' at the 8,500 foot…May 20, 1988 · N25934 · DestroyedNTSB MKC88LA092Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Mc Dougal, ARThe pilot stated that he had just begun the spraying of a rice field when one of the spray nozzles malfunctioned. As he was attempting to set the helicopter down on the ground, to work on the nozzle, the main rotor blades struck a tree. The main rotor blades…May 19, 1988 · N4690 · Substantial damageNTSB LAX88FA190Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Green Valley, AZFailure of the student pilot to accomplish the proper stall recovery procedures allowing the stall to develop into a spin. Contributing to this accident was the lack of training in spin recovery.May 19, 1988 · N2326A · DestroyedNTSB FTW88FA104Accident · 2 fatalField investigationFinal reportCessna 172P · Le Flore, OKThe acft was being used to fly over a wooded area & spot cattle for psnl on the ground. After spotting cattle for about 2 hrs, the plt was flying at low alt when the acft suddenly rolled into a steep bank, then the nose dropped & the acft crashed in a steep…May 18, 1988 · N212FR · DestroyedNTSB ATL88DMG06Accident · No injuriesFinal reportCessna 188 · Messic, NCDuring turnaround procedures, the airplane collided with trees and crashed. The pilot indicated that he had sprayed the field where the accident occurred many times during the past three years.May 18, 1988 · N8250G · DestroyedNTSB FTW88DRD03Accident · 1 fatalFinal reportCessna 188 · Winnsboro, LAThe private pilot was practicing aerial application maneuvers with between 20 to 40 gallons of water in the spray tanks. A witness indicated that 'as the airplane started down for the pass it clearly went into a flat spin in which it made almost 2 full…May 15, 1988 · N78392 · DestroyedNTSB SEA88LA094Accident · 1 fatalLimited investigationFinal reportBellanca 7GCAA · Sutcliffe, NVThe aircraft was observed to execute several low passes over witnesses along the shoreline of a lake. During one of the passes and while tracking northwest, the pilot dropped a package of life preservers from an estimated altitude of 75 feet AGL and while…May 14, 1988 · N57415 · DestroyedNTSB LAX88FA180Accident · 3 fatalField investigationFinal reportCurtiss-Wright Travel AIR 2000 · Fairfield, CAPilot's failure to maintain an airspeed at which the aircraft is controllable and entering a stall.May 14, 1988 · N6130 · DestroyedNTSB FTW88LA101Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Dalhart, TXThe local flight was circling at low altitude and reduced airspeed over farm equipment and level farmland while the passenger in the rear seat took photographs. The passenger in the right front seat said he heard the stall warning horn just prior to the…May 14, 1988 · N6069J · DestroyedNTSB BFO88FA047Accident · Minor injuriesField investigationFinal reportCessna 310L · New Cumberland, WVThe plt was doing low passes down rwy 04 when according to the plt he struck a large bird after the second pass just when he was starting to climb about one-half mile from the rwy end. The plt said that the bird shattered the windscreen causing the plt facial…May 14, 1988 · N2220F · DestroyedNTSB LAX88LA179Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Waialua, HIFailure to follow procedures established by the manufacture for uncommanded trim inputs and his decision to make a hover approach to landing.May 13, 1988 · N4943T · DestroyedNTSB FTW88FA100Accident · Serious injuriesField investigationFinal reportCessna 172F · Golden, TXAcft was operating on an aerial photography flt at 200 to 500' AGL and 70 to 80 mph. The commercial plt stated that as he was in a bank the acft seemed to be 'pushed' into the 60 to 80' trees over which he was flying and that it 'fell out of the air'. He also…May 13, 1988 · N5577R · DestroyedNTSB MKC88DCJ01Accident · Serious injuriesFinal reportCessna A188B · Dalton, NEThe pilot was spraying a large field which had a power line along the north side. On the 1st couple of passes, the spray equipment had intermittent malfunctions. As the aircraft approached the field from north for the 4th pass, it struck the upper cable of…May 11, 1988 · N70135 · DestroyedNTSB FTW88DRD02Accident · No injuriesFinal reportGrumman G-164A · Jennings, LAThe ag airplane was spraying over a rice field and was making a turn-around when the airplane settled into small trees and bushes. No problems were found with the airplane or powerplant.May 11, 1988 · N4708 · Substantial damageNTSB SEA88LA090Accident · No injuriesLimited investigationFinal reportAyres S2R Thrush · Lind, WADuring an aerial application maneuver, a total loss of power occurred due to the number nine cylinder failing. A restart was attempted, but was unsuccessful. The pilot made a forced landing onto a very soft sandy field, where the aircraft nosed over inverted…May 10, 1988 · N5660X · Substantial damageNTSB MKC88FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Mansfield, MOA witness saw the acft flying at low alt as it passed in front of her car at dusk in a northeasterly drctn. She rprtd the acft contd down a valley toward power lines that spanned an open field. She saw the acft pull up rapidly, become entangled in the power…May 9, 1988 · N8605S · Substantial damageNTSB LAX88DVA05Accident · No injuriesFinal reportHiller 12E · Firebaugh, CADuring an aerial application, the helicopter collided with a guy wire and then a field. The pilot knew that the wire was there. He stated that he simply forgot that it was there and did not see it. There were no mechanical problems prior to the accident.May 9, 1988 · N117HA · Substantial damageNTSB MKC88DCQ02Accident · 1 fatalFinal reportPiper PA-25-150 · Chase, KSWitnesses stated they saw the acft spraying a hayfield. They observed the acft strike a powerline as it was making a turn. The pilot stated that his wing clipped the powerline and that the acft went into a flat spin from which he couldn't recover.May 7, 1988 · N6337Z · Substantial damageNTSB LAX88FA176Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Guatay, CAFailure of the pilot to maintian VFR while flying in mountainous terrain.May 7, 1988 · N4367J · Destroyed