NTSB investigations
4,605 cases where the first occurrence was “In flight collision with object”.
Cases, newest first
Query with SQL
duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220) 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.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MKC82DA120Accident · No injuriesFinal reportPiper PA-22-160 · Stockton, MOThe aircraft was one of a flight of four, making demonstration flybys at the airport. The pilot stated that he was slow flying, about 80 to 85 ft AGL, when the aircraft started to sink. At that time, he was about 1000 to 1500 ft behind, to the right, and 20…NTSB FTW82FQG19Accident · 1 fatalFinal reportPiper PA-25 · Edmonson, TXThe pilot had been spraying the field for about 1 hr and was on the last pass. The owner/flagger stated that he had warned the pilot (by using a two way radio) to watch out for a standpipe and radio antenna, and the pilot acknowledged. He reported the plane…NTSB DCA82AA028Accident · 153 fatalFinal reportBoeing 727-235 · New Orleans, LAThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-83-02. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm The…NTSB DEN82DA130Accident · Serious injuriesFinal reportAerospatiale SA316B · Meeteetse, WYPrior to this flight, a long line had been attached to the helicopter for an external load operation. However, there wasa change in the schedule and the pilot was instructed to return to the base camp with six passengers. When the pilot took off, he was…NTSB DEN82DA131Accident · No injuriesFinal reportEnstrom 280C · Steamboat Sprin, COThe pilot stated that during lift-off he was distracted by persons on the ground waving their arms. The aircraft drifted to the left and contacted a tree after which the pilot landed the aircraft and it rolled over.NTSB ATL82DA190Accident · No injuriesFinal reportCessna A188B · Lula, MSDuring a swath run under electrical transmission lines, the vertical stabilizer and rudder contacted the wires and separated from the aircraft. The pilot attempted to return to the airport, but was unable to control the aircraft. He then attempted an…NTSB NYC82DA141Accident · No injuriesFinal reportGrumman American AA-5A · Marstons Mills, MAThe pilot stated that the aircraft was slow to gain normal lift-off speed due to the surface of the airstrip. He also stated that after prematurely vaulting the aircraft into the air the aircraft never gained sufficient airspeed for a climb. The aircraft…NTSB ATL82DA189Accident · No injuriesFinal reportBalloon Works Firefly 7 · Greenville, SCThe ballon with three persons on board dropped too low in a target hitting contest. The pilot then decided he could not climb above wires so he vented the Balloon in an attempt to land short. The bag contacted the wires and burned. The pilot stated he…NTSB CHI82DA238Accident · No injuriesFinal reportPiper PA-28-200R · Black River Fal, WIThe pilot stated that during flight, he encountered an engine problem and started to land on a road, but then the engine began to run better, so he continued to his destination. After landing, he discovered that a portion of the vertical stabilizer (about 18…NTSB CHI82FA231Accident · 2 fatalField investigationFinal reportCessna 150J · New York Mills, MNThe acft took off from a 2,500 ft alfalfa field which initially sloped downward then upward near the point of lift-off. A witness stated the acft did not appear to climb. The acft collided with 40 ft high power lines approximately 1000 ft from the point of…NTSB FTW82DA258Accident · Serious injuriesFinal reportGrumman G-164B · Swifton, ARThe pilot was engaged in an aerial application flight over a rice field with multiple high tension wires. At the beginning of a swath run, the aircraft struck power lines and crashed. The pilot had no recollection of the accident.NTSB ANC82DA054Accident · Minor injuriesFinal reportCessna 172K · Kasilof, AKThe pilot made a landing approach over trees at the approach end of the runway. The runway sloped slightly downhill in the direction of landing. The pilot landed long, then elected to go around, and during the go-around, the left wing struck a tree.NTSB LAX82FVD19Accident · Serious injuriesFinal reportGrumman G-164B · Stockton, CAThe pilot was spraying a field that required flying under a double set of high powerlines. On the third pass after going under one set of wires the pilot pulled up too soon and hit the second set of wires. The pilot stated in his accident report that it was a…NTSB FTW82DRJ13Accident · 1 fatalFinal reportAir Tractor 301 · Clarksville, TXThe pilot stated that he briefed the two flagmen about moving to next row as soon as the aircraft was lined up on the swath run. Both flagmen moved properly until on the fatal pass one flagman did not move and the aircraft struck him. The flagman struck by…NTSB FTW82DA257Accident · No injuriesFinal reportGrumman G-164A · Epps, LAThe pilot stated that while he was spraying crops, he looked into the cockpit during a turn to check the amount of solution that was remaining. He stated that when he looked up, he was too low to complete the turn and miss the trees. He went to full power and…NTSB CHI82FA228Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201 · Washington, ILDuring takeoff, the aircraft struck a pile of lumber that was 62 ft from the departure end of the runway. Two witnesses believed that the pilot did not use all off the runway for takeoff. One witness estimated that the pilot began the takeoff about 150 ft…NTSB DEN82DA119Accident · Minor injuriesFinal reportHughes 269C · Ronan, MTAfter spraying the field, the pilot was making an "end swath" when the helicopter collided with a power line. The helicopter crashed after a wire wrapped around the swash plate and damaged the controls. The pilot stated that he failed to see the wire.NTSB ATL82DA179Accident · Minor injuriesFinal reportBell 47G-3B-1 · Headland, ALThe pilot was positioning the aircraft for refueling when the main rotor contacted the fuel meter. There was substantialdamage to the helicopter and minor injuries to the chemical loader.NTSB FTW82DA255Accident · No injuriesFinal reportCessna 172XP · Kennedale, TXThe aircraft collided with light unmarked aluminum wires during an approach to land at a private airport. These wires were not noticed when an overflight was made prior to landing. The aircraft was landed ok after the collision. The instructor was flying the…NTSB ATL82DA177Accident · Minor injuriesFinal reportPiper PA-22-150 · Hixson, TNThe pilot elected to takeoff on a dark night without runway lights. He stated that the runway lights were not available at the time since the operator was out of town. According to the pilot and other witnesses, at least part of the airport environment was…NTSB NYC82FGT15Accident · 3 fatalFinal reportAeronca 11AC · Peach Bottom, PAThe non-certificated pilot took off with one passenger on board and with both doors removed. Witnesses observed the pilot make a number of passes near boats, under power lines and near people on the surface. A number of witnesses stated the passenger was…NTSB FTW82DRA22Accident · Serious injuriesFinal reportGrumman G-164 · Hardin, TXThe pilot reported that he struck power lines while flying under them during a swath run. Also, he indicated that a thunderstorm was rapidly approaching the field at the time the accident occurred.NTSB ANC82FAA06Accident · Serious injuriesFinal reportPiper PA-18-150 · Fairbanks, AKDuring the takeoff roll, the aircraft became airborne prematurely as it crossed over a dip in the runway. As it bounced, it also veered to the left toward saplings beside the runway. The pilot reported that he was in a nose high stall, but he lowered the nose…NTSB SEA82DA095Accident · No injuriesFinal reportCessna U206 · Juneau, AKThe float equipped aircraft crashed into trees after taking off from samonn creek reservoir while departing with overnight campers. The reservoir was located in a steep walled canyon. The pilot reported that he took off heading north into the canyon, raised…NTSB FTW82DA289Accident · No injuriesFinal reportPiper PA-28-160 · Quinlan, TXWhile the pilot was inspecting a power line, the aircraft struck a feeder line that was located perpendicular to the line being checked. The line snapped, but the plane contacted the ground and sheared off the right gear. The aircraft became airborne again.…NTSB ANC82DAG33Accident · 1 fatalFinal reportPiper PA-14 · Talkeetna, AKThe pilot step taxied the float plane to the north end of neil lake in preparation for a south takeoff. Approaching the north shore, a left step turn was initiated to postion the aircraft to the south for a takeoff. During the turn, while still on a northerly…NTSB LAX82FA232Accident · 3 fatalField investigationFinal reportAerospatiale SA-316B · Dardanelle, CAThe pilot took off from modesto, CA on a medivac flight to pick up a victim that was injured in an automobile accident. A nurse and a medical technician were on board. Spotlights on vehicles were used to illuminate the landing area as well as high surrounding…NTSB FTW82DA241Accident · Serious injuriesFinal reportPiper PA-38-112 · French Settleme, LAThe pilot departed shreveport, LA at 1400 CDT on the return part of a cross-country to jackson, MS. A VFR flight plan had been filed listing 3 1/2 hrs of fuel on board. At about 1706 CDT, the plane crashed near French settlement, LA, about 140 miles south…NTSB DEN82FTI16Accident · Serious injuriesFinal reportPiper PA-28-R-180 · Cameron, MTThe pilot reported that he encountered a downdraft while climbing over rising terrain in an area of foothills near mountains. He reported a loss of airspeed and altitude when the aircraft was about 1000 ft from the crest. At about that time, the gear extended…NTSB FTW82FRJ12Accident · 1 fatalFinal reportPiper PA-36-375 · Wildsville, LAThe pilot took off on a local flight to spray a bean field. About 1000 ft from the end of the field was a 300 ft radio tower. The aircraft was observed to circle the bean field and circle the radio tower twice. During a procedure turn, the aircraft struck the…NTSB NYC82FNA20Accident · No injuriesFinal reportSmith Aerostar 601 · Martha'S Vineyard, MADuring an ILS with the autopilot coupler on, a high sink rate developed toward the end of the approach. The pilot uncoupled the autopilot and began a missed approach, but the aircraft hit the top of a tree. He diverted and landed at providence, RI without…NTSB CHI82FER21Accident · Serious injuriesFinal reportBarrett BG-5 · Maple Plain, MNDuring landing approach the gyrocopter collided with a powerline. The student pilot lost control and crashed beyond the powerlines. The pilot was attempting to land in a farm field adjacent to a relative's house.NTSB ATL82FKQ15Accident · 3 fatalFinal reportCessna R182 · Ocean Springs, MSA pilot-rated witness observed the entire flight and accident. He stated that after takeoff and gear retraction, the aircraft was held at a very low altitude, which he thought was to gain airspeed. The aircraft reached the end of the runway and went into a…NTSB MKC82DA105Accident · No injuriesFinal reportCessna 120 · Gardner, KSDuring takeoff, the aircraft struck a fence near the departure end of the runway. After hitting the fence, it traveled about 37 yards before nosing over in an adjacent wheat field. The field was soft due to recent rains. The pilot said the 1300 ft runway was…NTSB LAX82DA222Accident · Serious injuriesFinal reportRockwell Intl. S-2R · Firebaugh, CAThe pilot was spreading fertilizer over a field and maneuvering over "high tension lines." No problems were encountered during previous flights earlier that day. The pilot had picked up another load which he reported was probably too much. He reported that…NTSB CHI82DA212Accident · No injuriesFinal reportBell 47G-2A · Hudsonville, MIThe pilot was flying a swath run that required him to fly under electric wires near a blacktop county road. As the pilot was coming off the field and passing under the wires, he realized he was on a collision course with a car. He pulled up to avoid the car…NTSB NYC82DA124Accident · No injuriesFinal reportContinental EL Tomcat MK5A · Imlaystown, NJDuring a swath run, a bird flew into the windshield and the pilot rolled the helicopter to the right to avoid further bird strikes. The right spray boom contacted the crops and pulled the aircraft into the ground resulting in substantial damage.NTSB NYC82DA123Accident · Minor injuriesFinal reportCessna 172N · Schellsburg, PADuring a cross-country flight the pilot encountered lowering ceilings and rain. The pilot descended to 2200 feet; however, the weather continued to deteriorate and the pilot elected to climb. The aircraft collided with trees and was destroyed.NTSB LAX82FVD18Accident · No injuriesFinal reportCessna 172 · Mckinleyville, CAThe aircraft struck and severed 3 power lines about 3 miles south of the departure airport. Prior to the accident, it was observed flying at low altitude in the vicinity. The pilot stated that he flew by a mobile home park to verify that a trailer had been…NTSB NYC82FNA15Accident · Minor injuriesFinal reportAeronca 7AC · Danvers, MADuring the previous flight, the aircraft had run out of fuel and was successfully landed in an open field. This occurred while the fuel gauge was indicating 1/4 full. The pilot serviced the plane with 5 gallons of no-lead auto fuel and stripped it of excess…NTSB DEN82FTC05Accident · Minor injuriesFinal reportBell 47G-3B · Douglas, WYThe pilot reported that he made a normal approach to the landing site near his loading dock. When he touched down, the helicopter as on a slope, so he picked the craft back up to a hover. Reportedly, he was moving the helicopter about 4 ft forward to a more…NTSB ATL82FA161Accident · Serious injuriesField investigationFinal reportAerospatiale AS350D · Hazard, KYThe helicopter was on an aerial survey flight with 3 engineers on board. During the flight, the pilot was flying to various areas in response to commands from the observers (engineers). While responding to a command, the helicopter collided with an electrical…NTSB FTW82FRG36Accident · Serious injuriesFinal reportPiper 25-235 · Hondo, TXOn the second pass spraying sodium chloride the aircraft struck the top portion of a line of oak trees when pulling out of a field. The aircraft then collided with a tv antenna and another tree before contacting the ground.NTSB ATL82DA160Accident · No injuriesFinal reportPiper PA-38-112 · Oxford, MSThe pilot had made two stops without refueling before he took off on this leg of his flight. He estimated that 12 gallons of fuel was remaining when he departed decatur, AL. While en route, he exhausted all of the fuel in the right fuel tank and switched to…NTSB MKC82DA098Accident · No injuriesFinal reportWeatherly 201A · Bronson, KSThe pilot reported that he was spraying over rolling terrain that was covered with trees. While on his last pass, he struck the top of a tree with his left wing. The aircraft became difficult to control, and the pilot elected to make a precautionary landing.…NTSB LAX82DVG26Accident · No injuriesFinal reportGrumman G-164 · Williams, CAThe pilot was applying a granular herbicide to a rice field with low voltage wires on the west border and high voltage lines located diagonally across the field. During a pass from west to east, he crossed over the low voltage wires and lowered the nose to…NTSB MKC82FA096Accident · 1 fatalField investigationFinal reportCessna 170B · Tama, IAThe purpose of the flight was to take a family friend on a night airplane ride to see the lights of a neighboring city. The takeoff was made from a soft wet grass runway with an aircraft exceeding the maximum allowable gross weight and the center of gravity…NTSB LAX82DA214Accident · No injuriesFinal reportCessna 152 · San Andreas, CAThe student pilot was a foreign national that was scheduled for a solo cross-country flight. He departed with a passenger that was a private pilot with a ground instructor rating. According to the passenger, the student had not flown for 8 days and was afraid…NTSB FTW82FRD13Accident · 2 fatalFinal reportPiper PA-28-161 · Lake Charles, LAThe plt told the surviving pax he was going to make a short fld takeoff with full (40 deg) flaps. The pax, who is also a plt, disagreed with the plt. The plt said it would be okay & proceeded to take off. During the takeoff roll the pax suggested he change…NTSB DEN82DTI14Accident · No injuriesFinal reportStarke KR-2 · Wolf Creek, MTWhile flying at a low altitude over the Missouri river the aircraft collided with a powerline damaging the propeller and cowling. The pilot used ground transportation to pickup a new propeller. He repaired the aircraft, surveyed the takeoff area and attempted…