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 ATL86LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Middle Bass Is., OHHeavy rains had flooded the causeway that connected Middle Bass island to the main island. A family was in need of transportation off the island and the pilot was attempting to fly them to the mainland using the 2,100 foot grass airstrip. The airstrip was wet…NTSB MIA86FA181Accident · 1 fatalField investigationFinal reportRobinson R22 HP · Lk Buena Vista, FLMotorists obsd the helicopter flying low ovr & along an interstate hiway. In the vicinity of a hiway rest area, the helicopter maneuvered to the side of the hiway, then flew back ovr the median. Two witnesses said it came to a hover, then started to continue…NTSB CHI86FEM07Accident · No injuriesFinal reportCessna 188B · Bay City, MIDuring an ag spray operation, the plt flew over the area before starting his swath runs. On his first run, he flew over wires at the end of the field. On the return swath run, he attempted to fly under the wires. While doing so, the acft struck a newly…NTSB CHI86LA153Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Breckenridge, MNAircraft collided with a truck while engaged in aerial application work. Pilot was unable to maintain control and the aircraft collided with terrain after an uncontrolled descent. Investigation revealed that the aileron had separated due to the collision.NTSB CHI86LA149Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Brodhead, WIThe plt was making a low pass over a friend's house. He was waving to the people on the ground and when he looked up he was too close to a tree to avoid hitting it. The plane then descended to the ground.NTSB LAX86FVA08Accident · Serious injuriesFinal reportNelson/Nelson Varieze · Merced, CAWhile on final approach witnesses observed the aircraft to be low and slow when the wing collided with a light stanchion (5' high). The left wing banked sharply to the left, hit the ground and the acft cartwheeled. The pilot reported no mechanical problems…NTSB CHI86FA151Accident · No injuriesField investigationFinal reportBeech 55 · Kenosha, WIThe acft was on a positioning flt returning from traverse city, MI, to Kenosha, WI. The reported milwaukee weather was ceiling 300 ft and visibility 2 miles. The pilot was cleared for a VOR 14 approach and given vectors to the final approach course. The pilot…NTSB ATL86LA166Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Magnolia Spring, ALDuring a spray run the plt attempted to climb over a tall tree, the acft failed to clear the tree which was contacted with the right wing. The acft then crash landed in a field. The acft was observed to stagger during several turns earlier in the operation.…NTSB LAX86LA241Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Sonoma, CAThe acft collided with a pole and crashed in a flooded field while on final approach. The pilot indicated that he flew a 20 minute local VFR flight prior to the accident. He stated he had suffered head injuries and was unable to recall any details of the…NTSB FTW86FRG25Accident · 1 fatalFinal reportAero Commander S2R · La Feria, TXThe acft contacted guy wires which supported a 1000 ft high television tower. Impact with the wires occurred at an alt of aprx 300 ft.NTSB FTW86FRG24Accident · No injuriesFinal reportGrumman G-164 · La Feria, TXAs the plt was making a swath run, he started to cross under power lines, but saw the profile view of a road marker. When he pulled up to avoid the road marker, the acft struck the wires, rolled to the left & collided with the ground.NTSB DEN86LA151Accident · Minor injuriesLimited investigationFinal reportBell 206B · Portal, NDThe plt reported that the acft hit wires at the end of a swath run. The pitch change link broke when the main rotor contacted the wires and the plt attempted to land. After touchdown, the helicopter rolled onto its side.NTSB ATL86FA156Accident · 3 fatalField investigationFinal reportMBB BO-105C · Peterson, ALThe EMS helicopter was heard and observed as it flew at low altitude down the river. A witness saw it dip down then attempt to climb just prior to the collision with power lines across the river. The helicopter broke the wires but was stopped and came apart…NTSB ATL86FA155Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Elizabethtown, KYAcft observed in level flt in IMC just below EST 500 foot ovc. EST viz about 3/4 mi. Lt wing struck 15/16 inch dia steel guy cable 534 feet AGL shearing outer 118 in. Acft impacted earth fill dam 1169 ft from 650 feet tall tv antenna. Tower. Top of tower…NTSB ATL86LA153Accident · No injuriesLimited investigationFinal reportCessna 150M · Franklin, NCFifty two hr pvt plt flying over lake in mountainous terrain started climb out toward destination. Elevation of lake about 3000 ft. ambient temp about 90 f. plt could not climb a/c at an angle to clear rising terrain. Flew a/c into trees.NTSB CHI86FET01Accident · Serious injuriesFinal reportPiper PA-20 · Rolling Prairie, INDuring a go-around from an aborted landing the acft struck unmarked power lines at the departure end of the landing rwy. The acft collided with terrain during the resulting uncontrolled descent. The rwy being used was a 2400 ft long and 50 ft wide sod private…NTSB BFO86FID05Accident · No injuriesFinal reportMaule M-4-210C · Saluda, VAWhile on final apch, the acft struck the top side of a van which was on a road off the apch end of the rwy. Both main landing gear were sheared off and the plt landed the acft in a grass area along the side of the rwy. The plt reported that a high sink rate…NTSB DEN86LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Decker, MTThe plt attempted to make a downwind landing in a grass covered pasture, landed long and attempted to make a go-around. During the go-around with the flaps retracted the aircraft struck a wire fence and impacted a horse trailer. The aircraft was destroyed.…NTSB ATL86LA138Accident · No injuriesLimited investigationFinal reportBell 47G-3B · Red Bay, ALThe pilot had completed a dispensing operation and was returning to the ag staging area to refuel. As the helicopter hovered towards the parked refueling vehicle, the main rotor blades struck a metal structure attached to the truck. The pilot stated that the…NTSB NYC86LA130Accident · No injuriesLimited investigationFinal reportCessna 206 · Greenville, METhe pilot experienced problems on takeoff from moosehead lake, but eventually was able to get airborne and fly to the Greenville airport. The aircraft remained on the ground for a few hours, then was preflighted for deparapure. Runway 21 was the favorable…NTSB NYC86LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150K · North Hampton, NHThe acft settled into trees during a landing apch. The plt reported that he added full power with the carburetor heat off and was still unable to stop the descent. When flt checked by the FAA, the plts slow flt and stall recovery procedures were found to be…NTSB LAX86FJA06Accident · 2 fatalFinal reportBell 206B · Maui, HIThe acft collided with powerlines while carrying pass'g on a sightseeing flt through a canyon. The wires across the canyon were EST to be 1700 long with height AGL unknown. The wires were unmarked and were 1/2 in dia aluminum. One of the passengers was…NTSB FTW86LA082Accident · Minor injuriesLimited investigationFinal reportCessna 150F · San Antonio, TXPilot failed to obtain sufficient airspeed to clear the trees at the end of the runway. The runway was soft and there was a left crosswind.NTSB BFO86LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Selbyville, DEThe acft impacted trees while attempting to release a banner at the drop zone. The acft was reportedly equipped with separate towing and release mechanisms, so that up to four banners could be towed in succession without the acft having to land. The plt…NTSB ATL86LA130Accident · No injuriesLimited investigationFinal reportCessna 150M · Littleton, NCPIC made low pass to let friend know he would land at airport for prearranged meeting. PIC reported he was low and slow. When go-around was attempted acft controls were mushy and acft would not climb. Later pilot commented he thought he was on the backside of…NTSB ATL86FA133Accident · 1 fatalField investigationFinal reportCessna 172 · Douglasville, GAThe acft was observed flying at low alt & circling several houses. The plt landed on a grass strip, then after a short time, he & his passenger took off again. The acft was again observed circling several houses at low alt in an area near the strip. A witness…NTSB LAX86LA218Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Julian, CAThe acft collided with wires on final apch to a private airstrip while on a personal VFR x-country flt. The plt stated that he was concerned about his fuel quanity and decided to make a precautionary landing at an arpt other than his dest. The plt realized he…NTSB DEN86FTK01Accident · Serious injuriesFinal reportBellanca 7GCBC · Huron, SDThe acft contacted powerlines and descended uncontrolled to ground impact. The plt reported that he was checking fields when the accident occurred. The acft was traveling to the west into the setting sun when accident occurred.NTSB ATL86LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Toccoa, GAThe pilot made three unsuccessful attempts to land the aircraft on the runway. During the third attempt the aircraft bounced on the runway and the pilot applied power to go-around. During the attempted go-around the aircraft collided with trees on the left…NTSB ATL86FA129Accident · 1 fatalField investigationFinal reportCessna 182P · Bay Minette, ALThe acft collided with trees during a descent. The plt was attempting to fly below the overcast to determine his location. The plt radioed just prior to his descent to announce his intentions to his destination UNICOM. There were no further communications…NTSB MKC86LA109Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Stuttgart, ARDuring an agricultural spray maneuver back to a field the PIC was fertilizing, the PIC stated he allowed the acft to become too slow and the aircraft descended into trees which bordered the field. The PIC stated he should have been flying with a lighter load…NTSB MIA86LA157Accident · No injuriesLimited investigationFinal reportCessna 182F · Sanford, FLThe plt stated that as he attempted to land he did not notice the apch lights at the end of the rwy. The left wing and windshield struck the lights, after which, the acft landed without further incident.NTSB NYC86LA125Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Spring Valley, NYThe plt was making an apch to rwy 08 which is 2185 ft long and 50 ft wide. The last 1/3 of the rwy slopes down noticeably. The acft struck parked cars in a parking lot located off the departure end of the rwy. There were no witnesses to the accident. The arpt…NTSB ANC86FA055Accident · 1 fatalField investigationFinal reportEnstrom F28C · Turnagain, AKThe helicopter was observed flying along the highway at a low altitude and it then struck some high power transmission lines, fell to the ground and burned upon impact. The transmission lines were 283 feet above the road surface and spanned a distance of 1127…NTSB MKC86LA104Accident · No injuriesLimited investigationFinal reportCessna 175 · Louisburg, KSDuring a fly-by over a pvt airstrip owned by the plt, the acft contacted power lines bordering the south end of the airstrip which the plt stated he forgot about. The plt reported he failed to pull up during the over fly and flew under the power lines. The…NTSB SEA86LA122Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Smiths Ferry, IDThe plt was returning to home base from a business flight on which he delivered parts to company personnel. The acft was observed flying down the north fork of the river at low altitude with its wings dipping. Aprx one mile after entering the canyon, the acft…NTSB NYC86LA123Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hallstead, PAThe airport is located in a valley between two rows of mountains on the ny/pa border. The plt had completed two takeoff and landings to a full stop at night for night currency. After takeoff and leveling off at 2,000 feet MSL and downwind for a left base to…NTSB NYC86FGM02Accident · Minor injuriesFinal reportContinental Copters OH13H Tomcat Mark 5A · Indiana, PAThe acft collided with wires during a spray run and crashed out of control. The plt tried to fly under the wires that were sighted too late to clear. During his survey of the field the plt had failed to see the wires that were struck. The collision broke off…NTSB LAX86LA215Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Angels Camp, CANumerous ground witnesses observed the aircraft fly low along the river which fed into the new melonies reservoir lake and then collide with unmarked high tension power lines which spanned a narrow portion of the lake. The pilot thought the aircraft was at…NTSB DEN86FA131Accident · 1 fatalField investigationFinal reportPiper PA-28B-140 · Salt Lake City, UTPlt and pax departed slc at 0930 for sightseeing cross country trip to heber city and return. Plt said plan was to fly through lambs canyon and parley's canyon. Acft hit tree and crashed at 8040 ft MSL level in lambs canyon at approximately 0955. Terrain…NTSB CHI86LA139Accident · No injuriesLimited investigationFinal reportTaylorcraft DC-65 · Plainwell, MIWhile departing to the north in light wind conditions, the pilot made a decision to abort the takeoff, then realized he would not be able to stop on the remaining runway. He attempted to continue the takeoff. He zoomed the aircraft to clear wires in his path,…NTSB ATL86FA126Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Ludlow, PAAn acft fitting the description of the acdt acft was observed entering the lake arm about 7 1/2 mi n of the acdt site. The acft was observed to pull up to clear pwr lines across the lake arm about 2 1/2 mi n of the acdt site. The acft was observed to fly into…NTSB LAX86LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Crescent City, CAThe pilot reported due to severe turbulence he decided to land long. Upon realizing that the airplane was too high he added full flaps. Shortly after touchdown the plt began to lose control of the airplane and elected to takeoff. During the initial climb the…NTSB ATL86FA125Accident · 1 fatalField investigationFinal reportBellanca 17-31ATC · Winchester, TNThe plt made a VFR pattern at an uncontrolled arpt and noted a truck alongside the north end of the rwy. The plt did notsee any persons on the rwy. During the landing flare the plt noticed a man on the rwy near the right wingtip. A jolt was felt as the acft…NTSB MIA86FA142Accident · Serious injuriesField investigationFinal reportCessna 172N · Starkville, MSWitnesses rprtd that the plt had purchased wine cooler beverages before going to the arpt. He stated that he drank from one of the bottles before the flt. The plt took off at about 2230 CDT. After takeoff, he flew back over the arpt & made a low pass over a…NTSB MIA86LA141Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · New Smyrna Bch, FLDuring a pickup of an aerial advertising banner the acft struck the pickup bridle with the left main landing gear. He stated that he was unable to climb. The acft then stalled and crashed along the arpt boundary in a swamp.NTSB CHI86FEX07Accident · Minor injuriesFinal reportAir Tractor AT301 · Bruceville, INThe acft collided with trees during a pull-up at the end of a swath run. During the collision the rt wing tip separated from the acft and the acft rolled hitting the ground with the rt wing first which started a cartwheel. Investigation revealed that the acft…NTSB MKC86LA097Accident · No injuriesLimited investigationFinal reportCessna 172F · Van Buren, MOThe pilot states that he had been advised of utility lines on both ends of the airstrip, and that several aircraft had previously experienced landing problems there. He further states that as he initiated a go-around he was caught in a downdraft he could not…NTSB LAX86LA195Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kearny, AZThe plt stated that he was on a sightseeing flt and was flying westbound at about 100 ft AGL along the gila river, when the acft struck powerlines. The acft then descended into the river bed. He futher stated that he observed the powerlines at the last minute…NTSB CHI86LA130Accident · No injuriesLimited investigationFinal reportCessna 150 · Gregory, MIThe CFI stated that the purpose of the flight was to look at property and give a bfr to his dual student. The aircraft struck wires while on approach to runway 23 at the smith farm airport. The CFI stated this accident could have been prevented had he used a…