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 CHI83FA393Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Graceville, MNWhile spraying a field adjacent to a house the acft struck a guy wire which had been strung between a 82 ft tower on the house & a 28 ft pole supported by wires.Aug 26, 1983 · N6253Z · DestroyedNTSB NYC83LA225Accident · No injuriesLimited investigationFinal reportCessna 182C · New Salem, MAThe acft collided with high tension wires while flying at about 100 ft AGL. The plt landed in the water and all 4 occupants evacuated safely. The ditching was controlled but the acft nosed over after impact. The passengers said they had no trouble until they…Aug 25, 1983 · N8596T · Substantial damageNTSB FTW83LA396Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Addis, LAThe acft made a forced landing in a plowed field after colliding with a low hanging transmission wire over a field beingsprayed. The plt applied full power after the collision but a damaged and locked up elevator caused excursions of climbing, stalling and…Aug 25, 1983 · N4348S · Substantial damageNTSB ATL83FKQ03Accident · No injuriesFinal reportAir Tractor AT-301 · Redwood, MSThe acft made a forced landing in a soybean field after severe vibration developed during a spraying operation. The pilot stated that the powerplant and flt controls were functioning normally at the time of the accident. An on-scene investigation revealed…Aug 25, 1983 · N8511S · Substantial damageNTSB ANC83FA152Accident · 3 fatalField investigationFinal reportCessna A-185F · Farewell, AKThe acft collided with mountainous terrain in a narrow canyon, the acft was heading in a general direction to leave the canyon. The propeller damage indicates the engine was at high power at impact. The plt had given a PIREP to farewellfss when he was 40…Aug 25, 1983 · N1725R · DestroyedNTSB MKC83FA199Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Boonville, MOThe acft crashed in a nose low, left wing low attitude during an aerobatic training flt. There were no signs of stretch on the seat belts of both seats. The instructor plt's body was found in the wreckage; however, the private plt's body was found about 900…Aug 24, 1983 · N5270X · DestroyedNTSB ATL83FA339Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Lexington, GAThe plt was on a cable patrol/aerial observation mission. While patrolling, he missed a turn in the cable route & turn to relocate it. After relocating the route, he looked back to observe a portion that he had missed & saw a logging operation. The plt turned…Aug 24, 1983 · N2490P · DestroyedNTSB NYC83FA221Accident · Serious injuriesField investigationFinal reportRobinson R-22 · Nashua, NHAs the instructor watched the third liftoff from in front of the hangar, he observed the helicopter lift off the ground rapidly, its nose swinging quickly to the right as it did. During the yaw, the helicopter lost altitude rapidly until the right skid hit…Aug 23, 1983 · N9078Z · Substantial damageNTSB CHI83LA392Accident · Minor injuriesLimited investigationFinal reportAyres S2R-R1820 · Essexville, MIWhile on a swath run, the acft collided with a power line & crashed in a corn field. The plt received a head injury during the accident & was unable to recall details of the occurrence. According to witnesses, he was on a northerly run & was crossing under…Aug 23, 1983 · N4025R · DestroyedNTSB LAX83FA398Accident · 1 fatalField investigationFinal reportChampion 7GCAA · La Jolla, CAPrior to departure, the acft was observed being run up with the eng sputtering & backfiring quite badly. The acft returned to the hanger & 3 lower plugs were changed. The flt was then resumed. The acft was next observed off shore, with the eng sputtering &…Aug 21, 1983 · N100ES · DestroyedNTSB CHI83LA389Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Canton, MNThe acft collided with a tree about 20-30 ft AGL in IMC weather after calling rochester approach at 1244 CDT to say that he was lost and in a thunderstorm. The plt was not instrument rated. Radio contact was lost at 1247 CDT. The flt originated in alton, IL…Aug 21, 1983 · N84843 · DestroyedNTSB ANC83LA151Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe acft got into a downdraft and collided with hilly terrain. The pilot stated that he was spotting caribou and settled into the side of a hill. According to the passengers the acft was about 300 ft AGL prior to the descent to ground contact.Aug 21, 1983 · N3129S · DestroyedNTSB LAX83FA395Accident · 2 fatalField investigationFinal reportBoeing Vertol BV-107-II · Shaver Lake, CAThe only witness, the hooker, who gets logs ready for transport by the helicopter, stated that he heard noises and the rotor blades began coming apart as the acft started downhill with a log. Examination of the wreckage revealed that #3 sychronizing shaft…Aug 20, 1983 · N190CH · DestroyedNTSB CHI83FA387Accident · 2 fatalField investigationFinal reportAerotek Pitts S-2A · Waukegan, ILWhile on a local flt, the acft crashed in lake Michigan about 1/2 mi from the shoreline. According to witnesses, it was flying over the water at about 100 ft, then pulled almost straight up to about 300 ft above the water, nosed over & went almost straight…Aug 20, 1983 · N80016 · DestroyedNTSB LAX83LA389Accident · Serious injuriesLimited investigationFinal reportPiper PA25-235 · Somerton, AZThe acft collided with the ground during a turn in turbulent air to abort an aerial application mission because of weather. The pilot stated that he had made two passes at the field he was spraying when he noticed the flagman and farmers waving him off due to…Aug 16, 1983 · N7104Z · DestroyedNTSB LAX83FA388Accident · 2 fatalField investigationFinal reportCessna P206B · Kernville, CAThe acft was conducting an aerial search in a box canyon. According to the surviving pax they ran out of room to turn the acft around in the canyon. The acft crashed at the 3,850 ft level. Surrounding mountain peaks are 9,470 ft MSL.Aug 16, 1983 · N4738F · DestroyedNTSB ATL83LA335Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Baxley, GAThe acft collided with trees during an emergency landing after the cockpit filled with smoke. A mechanic who examined the acft after the accident reported that exhaust gases had burned through the muffler shroud & had burned the ignition wires.Aug 16, 1983 · N6953Z · Substantial damageNTSB ATL83LA326Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hatley, GAThe pilot reported that while spraying a cotton field at aprx 60 feet AGL when the engine made a popping sound and then lost power. The pilot landed in a cotton field where the aircraft rolled over on its back and was destroyed by the post impact fire.…Aug 15, 1983 · N7904 · DestroyedNTSB SEA83FYA02Accident · 1 fatalFinal reportPiper PA-22-108 · Nr Jackpot, NVPrior to the accident, the acft was observed maneuvering in the vicinity. Subsequently, the acft collided with the ground while it was being flown under a 40 ft power line. Both of the occupants had student plt certificates that had expired. One of the…Aug 14, 1983 · N5533Z · Substantial damageNTSB SEA83FA178Accident · 1 fatalField investigationFinal reportCessna 150 · Granite Falls, WAThe acft collided with the ground in a vertical nose down attitude. The engine was imbedded 4 ft into the ground. All components of the acft were accounted for in the immediate area of the impact. Witnesses observed the acft in a left turn before falling into…Aug 14, 1983 · N4446U · DestroyedNTSB NYC83FFA02Accident · Serious injuriesFinal reportCessna 150M · So. Fallsburgh, NYThe acft was observed performing low level steep turns, climbs & dives over a hotel. The acft collided with the tops of trees, nosed over & crashed. The student plt resides at, & is employed by, the hotel.Aug 14, 1983 · N704AL · Substantial damageNTSB NYC83AA209Accident · 5 fatalFinal reportAerospatiale AS350D · Dover Township, NJWitnesses observed the helicopter fly along the beach at alt of about 100-150 MSL, enter a bank to the right and descendinto the water at an angle of about 45 deg. Examination of the wreckage failed to reveal any pre-impact discrepancies of the aircraft or…Aug 14, 1983 · N900JA · DestroyedNTSB LAX83LA384Accident · Serious injuriesLimited investigationFinal reportCessna 150K · N. Palm Springs, CAThe plt reported he originally intended to fly aprx 19 mi to the Palm Springs arpt to perform night landings to acquire night currency. However, due to a radio malfunction, he was unable to communicate with the control tower. Therefore, he decided to return…Aug 14, 1983 · N6379G · Substantial damageNTSB LAX83FA386Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-35C · Jamul, CAReportedly, after waiting almost 2 hrs, the plt decided he would fly the sailplane, either for 1 hr or until the owner arrived, when the owner arrived, he observed the sailplane flying back & forth along the north side of ridge area. Subsequently, the acft…Aug 14, 1983 · N2941H · DestroyedNTSB CHI83LER03Accident · Serious injuriesFinal reportBoeing A75N1 · Sabin, MNAcft collided with power lines.Aug 14, 1983 · N51125 · Substantial damageNTSB SEA83LA175Accident · Minor injuriesLimited investigationFinal reportPitts S-1S · Madras, ORThe acft collided with the ground while performing low level aerobatics over the arpt. The pilot stated that was practicing a low level pass over the arpt and that while rolling he felt the acft was not responding correctly. He said his rate of descent was…Aug 13, 1983 · N8067 · DestroyedNTSB MKC83FA189Accident · Serious injuriesField investigationFinal reportPiper PA-25-260 · Whittemore, IAThe plt reported he was making a trim swath in a low area toward rising terrain when he approached an unexpected 'high line' wire. The wire was positioned diagonally across the field. He reported that while avoiding the wire, he was unable to clear nearby…Aug 13, 1983 · N8559L · DestroyedNTSB FTW83LA383Accident · No injuriesLimited investigationFinal reportPierce GS-1 · Sand Springs, OKThe acft collided with the lake after maneuvering around at low alt for some time. A lake patrolman reported the acft alt before the crash at about 20 ft AGL. According to the plts statement he was about 50 ft high when he initiated a 30 to 40 degree angle of…Aug 13, 1983 · N111JP · Substantial damageNTSB DEN83LA190Accident · No injuriesLimited investigationFinal reportCessna T188L · Wahpeton, NDThe acft collided with the ground during aerial application turn around. The pilot stated that he looked inside the cockpit during the maneuver to see how much chemical was left. He saw the ground out of the corner of his eye and tried to avoid the collision…Aug 13, 1983 · N2070J · Substantial damageNTSB ANC83LA145Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Teller, AKAccording to the pilot. He made a pass over the airstrip to determine the wind direction. While maneuvering to land the acft stalled, probably because of the gusty winds. He recovered from the first stall and was preparing to depart the area when the acft…Aug 13, 1983 · N4065Z · Substantial damageNTSB ANC83FA144Accident · No injuriesField investigationFinal reportBell 206L-1 · Bettles, AKAccording to the plt, the low fuel warning light illuminated when the fuel gage was indicating 200 lbs. He reported he could see the arpt lights & elected to continue the flt. After arriving, he terminated his apch to a 30 to 50 ft hover with no forward…Aug 13, 1983 · N1081K · Substantial damageNTSB CHI83FU008Accident · 1 fatalFinal reportEipper Quicksilver MX · Shelby Township, MIThe ultralight was flying low over a gravel pit and suddenly pulled up and went into a dive. The acft engine was runningthroughout the maneuver according to witnesses. The acft did not pull out of the dive and the acft dove into the water. One witness thought…Aug 10, 1983 · UNREG · DestroyedNTSB FTW83LA372Accident · No injuriesLimited investigationFinal reportCessna 172P · Albuquerque, NMDuring a pre-solo flt, the flt instructor (CFI) asked the student to make a simulated forced landing apch to a road. The student made the apch, but while he was making a go-around maneuver, the acft's right wing tip collided with a tree on a rise in the…Aug 9, 1983 · N52456 · Substantial damageNTSB ATL83LA318Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Kenton, TNThe pilot stated that while flying low and slow to observe crops, the aircraft stalled during a turn. The nose was lowered which placed the acft on a heading for a large oak tree. A turn was attempted to avoid the tree; the acft stalled again, struck tree…Aug 9, 1983 · N1094E · Substantial damageNTSB SEA83LA170Accident · No injuriesLimited investigationFinal reportAerospatiale SA-315B · Montpelier, IDThe plt & 3 passengers were on a flt to find drilling supplies that had been dropped off of a truck on the previous day. The plt reported that he was hovering down an abandoned road at about 5 to 10 mph & 15 to 20 ft AGL when the helicopter collided with…Aug 7, 1983 · N49532 · Substantial damageNTSB FTW83FA361Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201T · Seminole, TXPrior to the flt, the plt & passengers were observed drinking beer in a lounge. They told witnesses that they were going to the arpt to eat & were later seen at a restaurant on the arpt. After that, they decided to fly. The takeoff time & purpose of the flt…Aug 7, 1983 · N2122Z · DestroyedNTSB DEN83LU002Accident · Serious injuriesFinal reportMitchell P-38 · Olathe, COThe owner of the ultralight reported that this was the plts 1st flt in this vehicle. Reportedly, he was learning to fly ultralights & had just completed several high speed runs to become familiar with the operation of the vehicle. The owner stated he saw the…Aug 7, 1983 · UNREG · Substantial damageNTSB CHI83FA366Accident · 3 fatalField investigationFinal reportRockwell 114 · Richmond, OHThe acft was borrowed by the pilot to give a friend a familiarization flt in a retractable landing gear acft. The acft was observed by campers as it performed a stall and recovery. A 2nd stall was done but this time the acft entered a spin and after at least…Aug 7, 1983 · N4778W · DestroyedNTSB LAX83LA376Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Flagstaff, AZThe plt reported that during a pleasure flt, when he was flying over rising terrain north of Flagstaff, AZ, he realized a need for more altitude. He turned toward a downhill direction, but the acft crashed into the tree tops when he was unable to maintain…Aug 6, 1983 · N7699Y · Substantial damageNTSB CHI83FA371Accident · 1 fatalField investigationFinal reportSiai-Marchetti F.260C · Oshkosh, WIThe foreign registered plt had a statement of aerobatic competency by an FAA inspector which contained a min alt limitation of 300 ft AGL. While performing at an air show, he had planned to pull up in a half loop, make a half roll on top, enter a 2 turn spin…Aug 6, 1983 · IRAID · Substantial damageNTSB ATL83LA315Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Moultrie, GAAfter completing a swath run, the plt pulled up, made a turn, then started a let down for another pass. As he increased power, the eng RPM went from 3000 to 3100. At the same time, the plt heard a whining noise and noted that the rotor RPM was decreasing. The…Aug 6, 1983 · N68632 · Substantial damageNTSB ANC83FA139Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Mccarthy, AKThe acft was observed by another pilot to fly into a box canyon. The witness stated that the acft then atmptd what looked like a chandelle to reverse direction but stalled and came to rest on the side of the canyon wall.Aug 6, 1983 · N5052E · Substantial damageNTSB SEA83LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Klamath Falls, ORThe acft dragged a wing in a lake and cartwheeled during an aerial application maneuver. The pilot said he had turned away from the field he was spraying to remove the bugs from his windshield. The acfts wing struck a lake surface in the turn, cartwheeled and…Aug 5, 1983 · N6664Q · DestroyedNTSB MKC83LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Ludell, KSThe acft stalled and crashed during an aerial application maneuver. The pilot said the heavily loaded acft stalled during a turn. The accident site elevation is about 3000 ft and the temperature was 90 degrees f. the density alt was about 5500 ft. the pilot…Aug 5, 1983 · N4739Y · DestroyedNTSB MKC83FA177Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Bentley, KSThe acft stalled, crashed, nosed over and burned during an aerial application maneuver. The owner of the acft was spraying the same field in another acft and saw the accident. He stated, the acft pulled up at the completion of a run, was in a turn around when…Aug 5, 1983 · N7620Z · DestroyedNTSB FTW83LA365Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58 · Westwego, LAThe helicopter was being used to string power lines by carrying a 500 lb wt, to which, the respective wire was attached. While hovering at about 120 ft AGL & in close proximity to a power line tower, the eng loss power abruptly. An autorotative landing was…Aug 5, 1983 · N2518M · Substantial damageNTSB CHI83LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Baroda, MIThe acft collided with wires during a spraying operation. During the forced landing following the wire strike the acft nosed over. The pilot said chemical spill from powerline strike obscured his vision through windshield and made the forced landing…Aug 5, 1983 · N4880Y · Substantial damageNTSB LAX83LA378Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Cantua Creek, CAThe plt report that while he was applying sulfur to a tomatoe field, sulfur dust, which had accumulated in the cockpit, ignited. He elected to make an emergency landing in an adjacent cotton field which was muddy from irrigation. After touchdown, the main…Aug 4, 1983 · N8874Q · Substantial damageNTSB ATL83LA310Accident · No injuriesLimited investigationFinal reportCessna T188C · Semmes, ALThe acft collided with a power line during an aerial application maneuver. There were 2 set of wires crossing the area, a low set and a high set. The pilot suddenly came upon the low set and climbed over them but collided with the high set. The vertical…Aug 4, 1983 · N3195J · Substantial damageNTSB NYC83FNA04Accident · No injuriesFinal reportSikorsky H-19D · Halifax, MAAfter arriving at the field to be sprayed, the plt initiated a descent to begin aerial application. At aprx 40 ft AGL & 50 KTS, the eng failed. The plt entered an autorotation, but could not avoid telephone wires. He was able to avoid hitting a dike, but in…Aug 3, 1983 · N37799 · Substantial damage