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 FTW87FA222Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Jackson, LAJust prior to the acdnt, witnesses observed the acft flying at low alt over a creek. They rprtd the acft went into a steep climbing left turn from about 40 to 75 ft AGL, then it entered a steep descent & crashed in the creek. No eng problems or changes in the…Sep 20, 1987 · N3815H · DestroyedNTSB MKC87LA175Accident · No injuriesLimited investigationFinal reportCessna 180B · Atkinson, NEWitnesses stated that the pilot was chasing a wild horse out of an alfalfa field and back into a corral when a wingtip struck a grove of trees and the aircraft cartwheeled onto the ground. The pilot stated to FAA that he did not see the treeline due to…Sep 19, 1987 · N5133E · Substantial damageNTSB MKC87FA172Accident · 1 fatalField investigationFinal reportSchweizer G-164B · Weiner, ARThe plt rprtd he was on a flt to chase birds from a rice field. Drg a low pass over the field, the main wheels dscndd into the rice crop, & after about 1000', the acft contacted the terrain & nosed over. The single place acft was equippedwith only one seat…Sep 18, 1987 · N36328 · Substantial damageNTSB FTW87LA221Accident · 1 fatalLimited investigationFinal reportCessna 340A · Lubbock, TXThe pilot did not declare an emergency or mention to the tower controller that his fuel was low. He was first told to enter right traffic for runway 17R but was subsequently told to enter right traffic for runway 26. (This was to allow a dea aircraft, at its…Sep 17, 1987 · N5449G · DestroyedNTSB FTW87FA219Accident · 4 fatalField investigationFinal reportGrumman American AA-5A · Corpus Christi, TXThe aircraft exceeded maximum allowable takeoff weight and aft center of gravity limits. The aircraft had two passengers in the rear seats. The operator's manual states that no passengers are permitted in the rear seats during aerobatic maneuvers. The pilot…Sep 16, 1987 · N6035L · DestroyedNTSB CHI87DEE10Accident · Minor injuriesFinal reportHughes 269A · Plainfield, ILWhile maneuvering at about 4 feet above ground level the pilot experienced a loss of engine power and entered an uncontrolled right turn and descent, colliding with the ground. The engine power loss was due to the failure of a stud and bolt holding the…Sep 15, 1987 · N8927F · Substantial damageNTSB ATL87DKG07Accident · Serious injuriesFinal reportGrumman G-164A · Alamo, GAThe acft was rprtd to be on an agricultural spraying assignment. The plt took off in the single seat acft with a passenger aboard. About 5 min after depg the arpt, the acft collided with trees & crashed after making an unscheduled low pass over an open field.…Sep 15, 1987 · N6590 · DestroyedNTSB ANC87LA149Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F-19 · Kuskatan River, AKThe pilot stated that he was maneuvering the aircraft at approximately 400 feet MSL when he stalled the aircraft and spun down until striking the trees. At the time of the accident the pilot did not hold a valid FAA pilot or medical certificate. He also did…Sep 14, 1987 · N3686T · Substantial damageNTSB FTW87LA215Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Batesvile, TXA witness to the accident reported the pilot was 'buzzing' personnel in a cotton field and on the third pass did not pull up in time. The belly struck the ground while the aircraft was in a 'fairly steep angle of descent.' The witness stated the engine…Sep 13, 1987 · N84191 · Substantial damageNTSB FTW87DPJ08Accident · 1 fatalFinal reportAir Tractor 301A · Hollis, OKDuring an aerial application cleanup run, the aircraft's wing collided with a pole and sheared off the outboard five feet. The aircraft then collided with the ground out of control. Exam of the engine and airframe did not disclose any pre-existing failures or…Sep 13, 1987 · N3651D · DestroyedNTSB DEN87FA237Accident · Serious injuriesField investigationFinal reportFairchild Hiller FH-1100 · Pinedale, WYThe plt and two passengers had flown to Pinedale to fish. The plt stated that he was cruising at an alt of 400 ft AGL and was executing a rt turn at the request of a pax. He stated that he slowed the acft, decreased the collective, and added rt pedal as he…Sep 13, 1987 · N5059F · DestroyedNTSB SEA87LA186Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Quincy, WADuring an aerial application maneuver the pilot flew into two 23,000 volt powerlines. The helicopter's rotor blades struck the powerlines, the aircraft turned to the right and descended to the ground.Sep 12, 1987 · N8QA · DestroyedNTSB NYC87FA252Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Granby, CTThe pilot departed simsbury airport on a x-country flight and crashed 4.5 miles to the north in bradley intl airport traffic area. Witnesses in the crash site area saw an aircraft flying in and out of clouds prior to hearing the crash.Sep 12, 1987 · N670FL · DestroyedNTSB LAX87FA332Accident · 3 fatalField investigationFinal reportBell 206B · Vallejo, CAWhile performing a routine aerial observation flight to inspect the integrity of the pacific gas & electric company's transmission lines, the helicopter crashed after colliding with an unmarked static wire. The line installation was on sloping terrain &…Sep 9, 1987 · N1082S · DestroyedNTSB DEN87DTG02Accident · No injuriesFinal reportBell 47G-4A · Minot, NDThe plt rprtd that when he took off fm a nrby nurse truck, the wind was fm the NE at 5 to 7 mph. He made an observation pass across the area to be treated, then bgn a dscndg rgt turn to make a swath run in the opposite drctn. He stated he was unaware of a…Sep 8, 1987 · N2238W · Substantial damageNTSB LAX87LA325Accident · 1 fatalLimited investigationFinal reportBeech A45 · Mammoth Lakes, CADuring an airshow performance, the acft collided with the terrain in a near vertical attitude. The maneuver the plt was to perform was a cuban eight. The first half of the maneuver was flown correctly, however, during the second half of it the acft remained…Sep 6, 1987 · N34GL · Substantial damageNTSB SEA87LA181Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Burbank, WAWhile on a local pleasure flight the pilot made a 30 degree, banked turn at reduced power. The aircraft entered a stall and descended to the ground. The aircraft has no stall warning system.Sep 5, 1987 · N71513 · DestroyedNTSB FTW87FA209Accident · 1 fatalField investigationFinal reportMooney M-20C · Waller, TXIt was reported that a private pilot was receiving instrument flight instructions from a CFI when the accident occurred. However, the CFI stated that he was invited by the pvt plt to go with him on a short flight and that he was only a passenger. During the…Sep 5, 1987 · N5590Q · DestroyedNTSB ANC87LA142Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Mcgrath, AKA local hunting guide crashed his airplane in a remote mountain pass in central Alaska. Another guide who overflew the crash site shortly after the accident saw the airplane burning, but was unable to land due to strong winds, severe turbulence and strong…Sep 5, 1987 · N4191Z · DestroyedNTSB ANC87FA137Accident · 1 fatalField investigationFinal reportEnstrom F-28F · Anchorage, AKThe pilot of the helicopter was seen flying at approximately 50 feet AGL down the length of a private gravel airstrip near Anchorage, Alaska. A nearby jogger said that the pilot appeared to wave at him as he flew past and then he heard the helicopter crash…Sep 5, 1987 · N8622A · Substantial damageNTSB ATL87FA248Accident · 1 fatalField investigationFinal reportCessna 182 · Lima, OHDuring a night flt from toledo to cincinnati, OH, the acft crashed along the route at Lima, OH, after svrl local residents heard an acft circling. Initial impact was with the top of a dike after the acft crossed over a reservoir. Wreckage was scattered over a…Sep 4, 1987 · N71536 · DestroyedNTSB ATL87DKG06Accident · 1 fatalFinal reportPitts S-1 · Brooks, GAThe acft was observed in aerobatic maneuvers near the departure airfield. The last of the series was a lomcevak maneuver, which was started at an estimated alt of 2500 to 2700 ft. a witness rprtd the acft went into an inverted flat spin, which was corrected…Sep 3, 1987 · N11HJ · DestroyedNTSB SEA87FA180Accident · 1 fatalField investigationFinal reportCessna U206G II · Yakutat, AKAcft was observed to depart from controlled flight while in a steep left turn at slow speed and low altitude, impacting on a river sand bar. Fire ensued, demolishing acft. Following heavy rains, river rose and acft not recovered.Sep 2, 1987 · N756PS · DestroyedNTSB LAX87DUJ11Accident · Minor injuriesFinal reportHiller UH-12E · Scottsdale, AZDuring an aerial application flight, the plt made a turn-around & was starting to make another swath run when he heard a loud 'bang' & then the helicopter collided with terrain. An inspn of the main rotor head & pin revealed the hub had failed from hi cycle…Sep 1, 1987 · N236HA · DestroyedNTSB ATL87LA246Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Greenville, KYThe flt was being conducted as part of a 'clown act' at an air show. The eng lost pwr shortly after takeoff as the plt was performing pitching maneuvers. He unsuccessfully attempted to regain pwr by 'pumping' the throttle. The airplane subsequently impacted…Aug 30, 1987 · N92191 · Substantial damageNTSB ATL87FA244Accident · 1 fatalField investigationFinal reportCessna 150L · Murray, KYPIC stated to friends he intended to execute a hammerhead stall after take off from a private grass strip. Airstrip owner observed acft make a low pass, pitch up vertically, and execute a hammerhead stall at about 450-500 feet AGL. There was insufficient…Aug 29, 1987 · N6795G · Substantial damageNTSB SEA87FA178Accident · 1 fatalField investigationFinal reportPiper PA-20 · Chelan, WAThe pilot was observed making a engine out landing at his private grass/dirt strip. The dirt strip is located on a plateau with the runway starting at the edge of the plateau. The aircraft impacted in a steep nose down attitude below the runway level on a…Aug 28, 1987 · N6901K · DestroyedNTSB ATL87FA243Accident · 1 fatalField investigationFinal reportAero Commander 112 · Middlefield, OHOn the previous flt, the plt made two unsuccessful IFR approaches before landing on the third attempt. The pax- configured acft was loaded with cargo. The plt filed an IFR flight plan and departed the arpt. Radio contact was established with ATC and the plt…Aug 28, 1987 · N1050J · DestroyedNTSB ATL87DMG02Accident · No injuriesFinal reportPiper PA-25-235 · Macclesfield, NCPlt ind that he was in procedure turn-around for spraying soybeans. Acft stalled and recovery initiated. Acft entered secondary stall and collided with trees. Examination of eng and acft did not disclose any pre-impact malfunction.Aug 27, 1987 · N89201 · DestroyedNTSB MKC87FA169Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Kanorado, KSThe fss stated they had personally briefed the student pilot on the wx en route for this night flight and told him VFR was not recommended. At the first stop, he called the co-owner of the airplane and told her he had been flying around storms. At the next…Aug 26, 1987 · N8975P · DestroyedNTSB DEN87FA224Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Devils Lake, NDThe acft was observed flying at low altitude and circling a farm that belonged to the plt's sister. After making two passes by the farm, the acft crashed in a corn field. The plt said he was looking for a field in which to land, and on the 2nd pass, the acft…Aug 26, 1987 · N11024 · DestroyedNTSB LAX87LA310Accident · Minor injuriesLimited investigationFinal reportBell 206B · Kailua-Kona, HIAs the helicopter was climbing over rising terrain at 300' to 400' AGL, the plt noted altimeter & airspeed indcns of 8700' & 60 mph. After climbing an adnl 2 min to aprx 10,000' (12,000' density alt), he noticed the rotor RPM was bleeding off. He made a 180…Aug 23, 1987 · N2777R · Substantial damageNTSB LAX87FA309Accident · 2 fatalField investigationFinal reportBeech C-55 · Salton City, CAInstructor pilot's inability to recover control of the aircraft after it entered a spin.Aug 23, 1987 · N3784Q · DestroyedNTSB LAX87DUM05Accident · 1 fatalFinal reportSawyer DF-9 · Ramona, CADuring the third test flt, the plt was to fly the acft to 6000 ft for slow flt and flutter testing at increasing speeds to 200 mph. The plt was then to complete a shallow descent to touch-down with an on final, over-the-fence speed not to exceed 75 mph.…Aug 23, 1987 · N6524J · DestroyedNTSB CHI87FA195Accident · 3 fatalField investigationFinal reportCessna 172 · Baileyville, ILWhile performing a low level (300-400' above the ground) flight search for a remote controlled aircraft that had been lost during flight, the pilot lost control of the acft. A witness reported that the aircraft entered a 'tight left turn', and then the nose…Aug 23, 1987 · N8207B · DestroyedNTSB NYC87DHJ02Accident · 2 fatalFinal reportReder KR-2 · Mattituck, NYWitnesses observed the experimental homebuilt acft in a steep nose down attitude descent with its prop rotating. No witnesses were located who saw the acft prior to the descent, however, pilots in the area reported that winds were turbulent and gusty. The…Aug 22, 1987 · N2262N · DestroyedNTSB SEA87LA172Accident · Serious injuriesLimited investigationFinal reportBell 47G2 · Grandview, WAAfter the completion of spray operations the pilot was attempting to place the helicopter onto a trailer. The pilot misjudged his position, over-corrected, and then lost control of the helicopter, striking the ground.Aug 21, 1987 · N74161 · Substantial damageNTSB DEN87DTK01Accident · 1 fatalFinal reportBushby Mustang II · Aberdeen, SDWitnesses reported that they observed the acft perform two snap rolls. During the second snap roll something came off the aircraft and fell to the ground. The acft then became inverted and descended until impact with the ground. The acft impacted in a near…Aug 21, 1987 · N44TA · DestroyedNTSB BFO87FA057Accident · 3 fatalField investigationFinal reportBell 206B · Washington, DCThe helicopter was on a LCL photography (sight-seeing) flt. While hovering at aprx 200' abv the potomac river, the eng lost pwr. The plt initiated an autorotation & deployed the emerg floats. Subsequently, the helicopter impacted in the river & rolled ovr,…Aug 21, 1987 · N83080 · DestroyedNTSB FTW87DRD13Accident · No injuriesFinal reportAir Tractor AT-400A · Monroe, LAThe ag pilot pulled up from a swath run while spraying chemicals on cotton and the pt 6A-20A engine in his aircraft exploded. A post accident teardown of the engine revealed the blades of a compressor disk had failed causing a total loss of power. Reason for…Aug 19, 1987 · N3159C · Substantial damageNTSB ATL87FA235Accident · 1 fatalField investigationFinal reportCessna 172A · Camilia, GAThis flt had been delayed several days due to poor weather in the area. On the day of the flt the plt waited until the local area fog had dissipated before departing the private air strip. The acft was heard above the clouds about five miles from the crash…Aug 19, 1987 · N7559T · DestroyedNTSB NYC87FA272Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · Martha Vineyard, MAThe plt was involved in commerical fishing operations as a spotter and to direct the closing of nets around schools of tuna. While directing the closing of a net, the fish being netted reversed course and started to escape from the open net. The plt dove at a…Aug 18, 1987 · N5060K · DestroyedNTSB FTW87DRD11Accident · 1 fatalFinal reportGrumman G-164A · Bastrop, LAThree flagmen were working with one spray plane and three fields. On this pass, two of the flagmen moved to the proper positions but the other one had moved too FAR laterally. The pilot stated to the sheriff that he had observed the flagman stepping off the…Aug 18, 1987 · N9685 · Minor damageNTSB SEA87FA166Accident · 1 fatalField investigationFinal reportCessna 172RG · Kettle Falls, WAWhile on a local personal flight, plt entered a canyon into rising terrain, colliding first with a tree and then ground near crest. Investigation revealed that acft probably had performance to clear crest had tree not been struck. Circumstances indicate plt…Aug 17, 1987 · N9747B · DestroyedNTSB FTW87LA199Accident · No injuriesLimited investigationFinal reportLet L-13 · Littlefield, TXThe pilot activated the flaps while on final approach instead of the spoilers. When the glider did not descend as he expected, a left 360 degree turn was initiated to lose altitude. The pilot stated that he then unintentionally stalled the aircraft while in…Aug 16, 1987 · N9997Q · Substantial damageNTSB DEN87FA218Accident · 2 fatalField investigationFinal reportCessna 172C · Switz City, INAfter departing the bloomfield arpt, the plt flew with his family over a coal mine area where he had done reclamation work. Witnesses at the mine stated that they observed the acft fly low over the mine pits & that the plt waved at them. The acft departed,…Aug 16, 1987 · N1418Y · DestroyedNTSB MKC87LA164Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mediapolis, IAThe pilot stated that the field to be sprayed appeared safe enough when he flew a recon flight over the area the day prior to the accident. He stated that he didn't expect the power transmission lines to be so low, and that he did not see a rise in the…Aug 15, 1987 · N4949X · Substantial damageNTSB NYC87DNC12Accident · Serious injuriesFinal reportCessna 150L · Heartwellville, VTThe pilot of the Cessna 150 was on a solo flight to practice several maneuvers including stalls. At about 4000 ft MSL, then aircraft was climbing with power on when it stalled and went into a spin. The pilot managed to get the nose up just prior to impact…Aug 14, 1987 · N19363 · DestroyedNTSB ATL87FA230Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Offerman, GADuring a local flt the acft was observed flying at a level attitude approx 10 ft above a corn field at high speed. The right wing of the acft struck tree branches approx 60 ft AGL during a pull up. A 6 ft section of the right wing separated. The acft climbed,…Aug 14, 1987 · N55649 · DestroyedNTSB LAX87DVA11Accident · 1 fatalFinal reportRockwell S-2R · Mendota, CAThe ground flagman reported the pilot had just completed spraying the bean field. The pilot was in the process of doing a touch-up application when he flew under the power lines. The airplane right wing contacted the lowest of the 4 powerlines, rolled…Aug 13, 1987 · N4219X · Substantial damage