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 MIA82FKJ04Accident · 1 fatalFinal reportGrumman G-164 · Malone, FLAfter completing a spray run the aircraft was observed to pull up in a tight left turn striking a water tower approximately 5 feet from the top. The aircraft spiraled down and crashed approximately 135 feet from the base of the tower.NTSB SEA82FYM13Accident · Serious injuriesFinal reportWeatherly 201B · Kent, ORThe pilot reported that he was working off of a 1700 ft dirt strip with a rough surface and with a slight cross- wind. The elevation was about 2650 ft MSL and the temperature was approximately 70 degrees fahrenheit. The pilot initiated a takeoff with about…NTSB MKC82IA047Incident · No injuriesIncident investigationFinal reportCessna 152 · Cottonwood Fall, KSAfter executing two landings on runway 36, the pilot noticed a wind shift from 360 degrees to 260 degrees and he taxied back up the runway and started a takeoff on runway 18. The pilot stated that about 1300 from the departure end of the runway, he…NTSB LAX82FUQ13Accident · 1 fatalFinal reportCessna 150 · Santa Barbara, CAThe aircraft crashed in a wooded canyon area beneath the cold spring canyon arch bridge in los padres national forest. The plane impacted about 250 yards north of the bridge while on a northerly heading. Broken tree tops and branches were found over an area…NTSB LAX82DA140Accident · 3 fatalFinal reportHughes 369HS · 8 S. Of Page, AZThe aircraft was number two in a trail of three helicopters flying up the Colorado river at marble canyon to page, AZ when it struck an aerial cableway stretching across the river, 22 ft above the water. Witnesses stated that after the collision the…NTSB LAX82FXQ07Accident · 1 fatalFinal reportCessna 150 · Wadsworth, NVWhile flying over the truckee river on a local flight, the left wing of the aircraft struck a group of five powerlines. The aircraft then impacted the water in a nose down attitude. It was carried downstream about 100 yards by the current before coming to…NTSB ATL82DA107Accident · No injuriesFinal reportCessna 150 · Jacksonville, NCAfter rotation the airspeed would not accelerate past 60 mph during climbout. The instructor took over and after realizing that the aircraft would not climb above 10 feet attempted to land on the remaining 1/3 of the runway. The aircraft floated and ended up…NTSB FTW82FQA16Accident · 3 fatalFinal reportPiper PA-32R-300 · Ruidoso Muni, NMThe aircraft took off from runway 18 with 4 occupants and about 98 gal of fuel on board. The wind was from 210 deg at 8, gusting 20 KTS, the pressure altitude was about 8900 ft and moderate turbulence was reported. According to witnesses, the aircraft made a…NTSB LAX82DVA14Accident · Serious injuriesFinal reportHiller UH-12E · Chowchilla, CAThe pilot was conducting an aerial dusting operation over a grape vineyard. While on a swath run, he gradually converged on a powerline that crossed the field at a slight angle from his flight path. As he proceeded on his swath run, the helicopter got closer…NTSB LAX82DA135Accident · No injuriesFinal reportBell 47G-2 · Stockton, CAThe pilot landed to pick up a flagger and take him to the end of the field. The landing was made facing north on a north-south driveway. An overhead line was located along the east side of the driveway. During takeoff, the pilot moved laterally to the west,…NTSB NYC82FHM05Accident · Minor injuriesFinal reportPiper Aerostar 602P · Tetersboro, NJWhile approaching the teterboro airport, the pilot encountered a bird strike which broke the windscreen. The pilot reported that he was partially blinded with blood and feathers. He regained his sight and landed the aircraft at teterboro.NTSB NYC82FGT13Accident · 1 fatalFinal reportCessna 182 · Catawissa, PAReportedly, the pilot departed the airport to accumulate time on a overhauled engine. The airport manager stated that shortly after takeoff, the pilot called on the UNICOM frequency that the engine and aircraft worked like new and he was completely satisfied…NTSB NYC82DHA08Accident · Serious injuriesFinal reportAeronca 11AC · Beach Lake, PAThe pilot of a ski equipped aircraft began taking off on a 900 ft strip. There was snow on the runway, but grass showed through in places. The pilot reported that the aircraft slowed "very very little" while crossing an area with grass showing. Just beyond…NTSB ATL82DA090Accident · No injuriesFinal reportPiper PA-28-140 · Hazlehurst, GAThe pilot made a successful precautionary landing after becoming disoriented due to problems with his communication and navigation radios. After finding out his location he attempted to depart from a soft field covered with tall grass that was approximately…NTSB ATL82FA087Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Westminster, MDThe aircraft crashed after takeoff from a 2930 ft runway with four occupants on board. The aircraft weight was not known, but was estimated to be 2334 lbs during takeoff. There was a light wind from the west and the temperature was 42 degrees fahrenheit.…NTSB FTW82FRG27Accident · 1 fatalFinal reportBell 206 · Austin, TXDuring a low pass over lake Austin the aircraft collided with power cables about 300 feet above the lake. Witnesses reported two loud cracking sounds and that the helicopter pitched up and gyrated wildly then continued in the original direction of flight and…NTSB FTW82DA114Accident · No injuriesFinal reportRockwell 690A · Conroe, TXThe pilot was too high on an IFR approach and elected to circle and land. During the turn he collided with trees but continued the approach and landed. The left wing and stabilizer were damaged.NTSB MIA82DA080Accident · No injuriesFinal reportPiper PA-38-112 · Near Opalocka, FLThe pilot stated that he was practicing forced landings in a soft field environment. The passenger added that the landing area was a levee bordered by water, trees, and vegetation. He further stated that the aircraft bounced hard and to the left off the…NTSB ATL82FLA01Accident · Serious injuriesFinal reportPiper PA-28-140 · Hoboken, GAThe pilot reported that during takeoff, he accelerated to 68 mph, then realized he would be unable to clear trees. He stated that he closed the throttle and mixture, aimed the aircraft at an opening in the trees, and maintained a level attitude until impact.…NTSB ATL82FLT03Accident · 1 fatalFinal reportCessna 172N · Greenfield, TNWitnesses reported that the aircraft crashed after the pilot had been making low passes for about 15 to 30 minutes. In the vicinity of a 30 ft pole, the pilot made a right turn and the aircraft struck the top of a 45 ft tree. The aircraft continued over a…NTSB MIA82FA078Accident · 3 fatalField investigationFinal reportBeech F35 · Leesburg, FLThe pilot, who was a rock group driver, took an aircraft from the hangar without permission to joy ride members of the group. During the 2nd flight, the aircraft wing hit the bus during one of several low passes over the area. The aircraft then hit a tree and…NTSB ATL82DA074Accident · No injuriesFinal reportCessna A188B · Terry, MSDuring departure from a 2100 ft runway the pilot realized the plane was overloaded for the conditions. He opened the dump gate about 100 ft from the end of the runway. However he reported that lumps of fertilizer in the bottom of the hopper prevented the load…NTSB NYC82DA054Accident · No injuriesFinal reportCessna 172 · Canastota, NYWhile on a local flight, the pilot made a low pass at a grass landing strip. During pull-up, the left wing hit the tops of trees and was damaged. The pilot maintained control and continued on the return flight. However, approaching the runway, he was unable…NTSB DEN82FTC02Accident · Minor injuriesFinal reportCessna 210M · Cheyenne, WYThe pilot initiated his takeoff on runway 12 from an intersection with runway 16. From this intersection, there was 2175 ft or runway remaining. During the takeoff, the aircraft struck the roof of a garage about 360 ft from the departure end of the runway.…NTSB ATL82FKQ11Accident · 1 fatalFinal reportCessna T188C · Mahew, MSDuring return flight to airport the pilot flew into a previously treated field for a cleanup swath run. Approximately 1700 feet from the south end of the field the aircraft collided with a 3-strand steel twisted cable powerline running east-west across the…NTSB NYC82FA053Accident · 1 fatalField investigationFinal reportRobinson R22 · Spangler, PAThe helicopter struck a set of north-south powerlines while the pilot was patrolling a set of east-west powerlines. The powerlines being patrolled passed under the lines that were struck. The accident occurred over hilly, wooded terrain.NTSB LAX82DA101Accident · No injuriesFinal reportBeech V35B · Taft, CAThe aircraft made contact with an antenna during a low pass over a job site. The windshield shattered and the engine stalled forcing the pilot to make an emergency landing.NTSB LAX82DA100Accident · No injuriesFinal reportHiller 12E · Delano, CADuring the spraying operation of a field border the helicopter main rotor blades came in contact with power lines. The loose wire wrapped around the ballast arms and the landing was accomplished with cyclic steering only.NTSB SEA82FYM11Accident · Minor injuriesFinal reportHiller UH-12E · Mount Angle, ORThe aircraft was being used on an external load operation. On his fourth load, the pilot was to transport a 1190 lb electric pump and fan from the back of a pickup truck. While preparing to lift the load, the pilot was not satisfied with its position. He…NTSB FTW82FRG24Accident · Minor injuriesFinal reportBeech E18S · Charlotte, TXThe aircraft crashed during takeoff from a clearing on a ranch and then was abandoned. The aircraft landing gear struck a concrete trough for watering cattle. Drugs were found on board the aircraft.NTSB SEA82DA033Accident · No injuriesFinal reportCessna 172RG · Plush, ORThe pilot departed lakeview, Oregon on a local flight with two passengers on board. After a stopover at a private airstrip, he began a short field takeoff from a grass/gravel/dirt runway that was 2500 ft in length. The density altitude was approximately 4600…NTSB DEN82FA039Accident · 1 fatalField investigationFinal reportMooney M20E · Aspen, COThe aircraft collided with a tree on top of a 12,000 foot mountain after it had departed Aspen, en route to denver. The aircraft should have climbed over the mountain without problems. The pilot only remembers the airspeed decaying and lowering full flaps…NTSB ATL82DA062Accident · 1 fatalFinal reportPiper PA-25-235 · Griffin, GAThe pilot was hired to perform for the filming of an agricultural spraying operation. During one of the low passes the aircraft struck two of the ground crew. The cameraman received fatal injuries. Pieces of the wooden propeller, used to drive the spray pump,…NTSB FTW82DPM10Accident · Serious injuriesFinal reportCessna 140A · Wagoner, OKDuring a low pass over a river, the aircraft struck some power lines approximately 125 ft above the water level.NTSB FTW82DA077Accident · No injuriesFinal reportCessna 152 · Arkadelphia, ARThe pilot elected to practice a forced landing pattern to a large rice field. As he passed over a stand of pine trees on final approach, he heard a loud thump. He increased power and returned to the airport. En route, he noted a dent on the leading edge of…NTSB CHI82DA076Accident · Serious injuriesFinal reportBarnes FIREFLY-7 · Cincinnati, OHPilot stated that after a normal inflation, before the balloon was hot enough to sustain flight, a gust of wind blew it into a school building. After striking the building, the balloon was dragged through a line of trees.NTSB FTW82FPA11Accident · No injuriesFinal reportBeech D18S · Dallas, TXDuring a night, ILS approach, the plane struck a powerline about two miles short of the runway after the pilot was provided a low altitude alert. The left engine lost power and was feathered. The pilot feared possible gear damage and left it extended. Unable…NTSB FTW82FQA15Accident · 1 fatalFinal reportBell 206B · Watrous, NMThe helicopter struck power and communication lines after taking off at night. After hitting the lines, it crashed into a railroad grade and bridge. The crash site was about one mile from the departure point. An inspection of the engine revealed no preimpact…NTSB FTW82FRJ08Accident · 2 fatalFinal reportBellanca 7GCBC · Near Texarkana, ARDuring flight, the aircraft struck a powerline about 70 ft above the red river. The aircraft crashed in the river and drifted about 2 miles before it was recovered. The passenger's body was recovered on 03/21/82 and the pilot's body was recovered on 05/15/83…NTSB FTW82DA063Accident · No injuriesFinal reportCessna 140 · Krotz Springs, LADuring the power recovery from a simulated forced landing to a railroad right-of-way the aircraft struck four strands of telephone wire which ran perpendicular to the tracks. The aircraft was landed at a nearby airport where post-flight inspection revealed…NTSB LAX82FUJ28Accident · No injuriesFinal reportBalloon Works Firefly · Phoenix, AZThe pilot was landing in a vacant lot when the light and variable wind shifted and started blowing the Balloon toward powerlines. Just prior to the wind shift, the Balloon was descending rapidly. Rather than make a hard landing, the pilot tried to "burn" his…NTSB LAX82IA075Incident · No injuriesIncident investigationFinal reportBoeing B737-2H4 · Ontario, CABecause the glide slope had been removed from service, air cal flight 754 was vectored by the Ontario TRACON 'n' controller for a localizer only approach to runway 26L. The first officer stated he descended to 1,200 ft after passing the faf/om. The captain…NTSB FTW82FRG22Accident · 1 fatalFinal reportBeech V35A · Cibolo, TXBefore starting the flight, the pilot was involved in an automobile accident. He called an employee and asked to be picked up. The employee reported that the pilot was drinking when he arrived. The pilot insisted on going to the airport to get keys from his…NTSB ATL82FID06Accident · No injuriesFinal reportCessna 402B · Newport News, VAThe pilot stated that during his first ILS approach, the localizer needle fluctuated to the left. He made corrective turns to the left. When he broke out of the clouds at the decision height (dh), he observed the runway to the right and made a missed…NTSB SEA82FYK07Accident · 1 fatalFinal reportCessna 172 · Lapine, ORWhen the pilot landed at lakeview,OR,he checked the weather but reported to his passenger that although the weather was bad he did not want to stay in lakeview. The aircraft departed lakeview, following a highway, when the weather conditions continued to…NTSB LAX82DA051Accident · No injuriesFinal reportBell 47G-2 · Watsonville, CADuring a preceding spray operation, the pilot noted that some of the spray nozzles were not functioning properly. He flushed the tanks with fresh water and partially refilled them with water to perform an airborne nozzle check. While performing the check at…NTSB ATL82FKJ11Accident · Serious injuriesFinal reportPiper PA-32 · Muscle Shoals, ALDuring the approach the pilot stated that he could not extend the landing gear. At some point during the approach the aircraft broke out into VFR conditions. The pilot stated he had the airport in sight when the aircraft struck a 160,000 volt power line.…NTSB FTW82FPJ12Accident · 2 fatalFinal reportBeech G35 · Stillwater, OKThe aircraft departed on a dark night with no record of a flight plan filed or a weather briefing received. Witnesses observed the aircraft climb out of sight into a fog layer when 2/3 down the runway then reappear and continue to fly at tree top level…NTSB ATL82FKQ10Accident · 1 fatalFinal reportPiper PA-23-250 · Mccomb, MSBefore taking off from jackson, MS, the pilot received a weather briefing by radio and filed an IFR flight plan to Mccomb, MS. During arrival at Mccomb, the weather was IFR with an indefinitely obscured ceiling at zero ft, visibility 1/2 mile in fog, wind 160…NTSB MIA82DA032Accident · Serious injuriesFinal reportPiper PA-23-250 · Okeechobee, FLThe aircraft owner and a friend were taken to a hospital emergency room with serious injuries at about 2115 local time. They stated that they had been attacked and robbed while hitch-hiking. On the next morning, the owner's aircraft was found where it had…