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 MKC83FCQ01Accident · Serious injuriesFinal reportMooney M20A · Halstead, KSDuring arrival, the pilot noted that the wind was from the northwest. He estimate it was from 330 deg at 20, gusting 35 KTS. On final approach, the aircraft was reportedly unstable due to gusty winds and turbulence. The pilot observed and was aware of the…NTSB ANC83LAA02Accident · 2 fatalFinal reportCessna 150 · Nulato, AKThe acft struck trees 600 ft from the departure end of the rwy at a high rate of speed after taking off from the unlighted rwy at night. The plt's blood alcohol level was 31 mg% & the urine alcohol level 90 mg%.NTSB SEA83FYM01Accident · 1 fatalFinal reportBellanca 7GCBC · 1/4nm S. Of Peo, ORThe pilot and passenger were on a pleasure flight over the willamette river. The passenger stated that after following the river the aircraft began to climb and turn east. There was a sudden jolt and the plane began to spin and impacted the water.NTSB NYC83LA008Accident · No injuriesLimited investigationFinal reportCessna 172P · Grahamsville, NYThe pilot and two passengers departed on a local sightseeing flight with full fuel tanks. About one hour after takeoff, the pilot flew over the passengers' house to take pictures. While a passenger was photographing the house, the pilot's attention was…NTSB LAX83LVD01Accident · Minor injuriesFinal reportBoeing A75 · Ft. Bragg, CAThe pilot reported that he was long and fast on his landing approach, so he decided to go around. Due to a noise sensitivity problem in the area, he elected not to use full throttle. Subsequently, the aircraft hit the tops of trees at the end of the runway.…NTSB FTW83FQA02Accident · Serious injuriesFinal reportRaven Industries S-66A · Albuquerque, NMThe pilot was landing the balloon in strong gusty winds when he saw power lines approaching and told everyone to jump. Those jumping, except the pilot, were injured. One passenger stayed in the basket and was unharmed.NTSB FTW83LA011Accident · Serious injuriesLimited investigationFinal reportRaven AX-7 · Albuquerque, NMThe balloonist attempted to abort a landing due to wind conditions and believes he encountered a downdraft. The balloon descended and landed on a fence and became airborne again. The wind had picked up to about 15 or 20 knots so the balloonwas traveling…NTSB MIA83FA006Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Lake Placid, FLAircraft was transporting marijuana and during an attempted road landing at Lake Placid collided with wires which damagethe landing assembly. Aircraft continued on to north about 4 miles and ditched in a lake. The aircraft sank with both occupants and cargo.NTSB FTW83LA005Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe Balloon collided with trees while landing in a zoo parking lot. The weather was VMC and no flight plan was filed. The pilot stated that in attempting to land next to the Balloon they were chasing in a hound and hare game, he allowed the gondola to drag…NTSB NYC83LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bernville, PAThe pilot reported that the plane crashed after the right wing tip hit the top of a tree during landing. He reported that he had flown only 2 hrs in the last 90 days. He noted that this was only a 13 minute flight. He thought that he would have been more…NTSB FTW83LA004Accident · No injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Albuquerque, NMThe balloon was landed in the backyard of a residence. The envelope dragged across a 7200 volt powerline which burned the envelope fabric. The pilot said he was approaching a large open field when a gust of wind (downdraft) caused the balloon to land…NTSB CHI83LA003Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Seneca, ILWhile landing on a 2300 ft runway, the plane touched down about 1000 to 1200 ft beyond the approach end. The pilot felt that there was insufficient room to stop safely, so she initiated a go-around. The pilot was unable to attain enough altitude to clear…NTSB FTW82DA404Accident · No injuriesFinal reportCessna 182A · New Braunfels, TXThe plt rerouted due to deteriorating wx & when in the vicinity of san antonio elected to land at san antonio. The plt contacted approach control at 2252 & reported 18 mi east for landing. The acft struck trees 5 mi nw of New Braunfels.NTSB LAX82DA363Accident · No injuriesFinal reportBeech 76 · Big Sur, CAReportedly, a small flock of birds were encountered while cruising at 8000 ft MSL. One or more of the birds struck the cowling and windshield which resulted in a hole in the top right side of the windshield. The pilot diverted and landed at monterey, CA…NTSB LAX82DA365Accident · No injuriesFinal reportGrumman G-164B · Delano, CAAircraft collided with wires during spraying of grapes. No air or ground survey made which was a normal procedure. Work pressure created the deviation.NTSB LAX82DA359Accident · 1 fatalFinal reportPiper PA-18 · Casa Grande, AZStudent pilot with no night flying experience flew into wires at night on a personal flight with a passenger. VFR conditions existed and no flight plan was filed.NTSB SEA82DA174Accident · No injuriesFinal reportTanke Goldwing · Harrington, WAAfter a local pleasure flight, the pilot returned to a farm strip for landing. Due to a windshift, the pilot attempted a landing 90 degrees from that of the takeoff. The aircraft struck powerlines while on the approach.NTSB FTW82DA394Accident · Minor injuriesFinal reportBell 206L-1 · Gulf Of MexicoDuring an approach to land on the lower platform of an oil rig, the pilot failed to see and avoid guy wires which obstructed the approach. After contacting the wires, the aircraft crashed upright on the platform.NTSB ATL82FLJ09Accident · No injuriesFinal reportWainscott Scamp B · Holly Springs, NCThe pilot called ahead before landing at the airport and was told that the grass runway was usable. After landing, he initiated a takeoff from the soft, grass runway. According, to the pilot, the grass was uncut and was too high for a departure of his type of…NTSB FTW82DA396Accident · No injuriesFinal reportCessna 152II · Palacios, TXThe aircraft collided with a large black bird (species unknown) while flying at 300 to 500 feet MSL. Impact occurred near the outboard end of the right wing. Immediately after the collision the pilot made a successful precautionary landing.NTSB FTW82DA393Accident · Minor injuriesFinal reportBellanca 7GCBC · Bracketville, TXPilot stated that while flying low over a ranch looking for lost cows, he flew into high powerlines. He also stated thathe was aware that the powerlines were in the area.NTSB MIA82DA187Accident · No injuriesFinal reportPiper PA-36 · N. Chipley, FLAircraft collided with a tree while spraying. Aircraft then landed hard in the bean field.NTSB SEA82FYM24Accident · 2 fatalFinal reportCessna 172P · 3nm Se Scappoos, ORThe acft struck & severed power lines strung between two 90-foot towers located about 1500 feet apart. The power lines were about 50 to 60 feet above the water at the lowest point of the line sag.NTSB FTW82DA380Accident · No injuriesFinal reportCessna 172N · Hobbs, NMPilot collided with power line while on pipeline patrol. A sucessful landing was made at hobb, NM airport after accident.NTSB DEN82FA193Accident · 1 fatalField investigationFinal reportCessna R172K · Vernal, UTThe aircraft collided with trees while low flying on a local flight. Two aircraft piloted by students from a nearby college had been seen flying low and close to each other around the local mountainous terrain. The students were enrolled in the college…NTSB LAX82DA340Accident · Serious injuriesFinal reportBeech C23 · Bear Valley, CAThe pilot landed long and fast on the runway. He was using runway 19 and the wind was from the north at 15-20 KTS. He landed and while still rolling at 65 KTS initiated a go-around. He did not climb high enough to clear small tree and after colliding with…NTSB FTW82DA376Accident · No injuriesFinal reportCessna 150C · Inez, TXPilot aborted downwind landing after overshooting. During go-around he flew under a powerline and collided with trees and a fence.NTSB ANC82DAG57Accident · No injuriesFinal reportPiper PA-18-150 · Wasilla, AKThe pilot landed on anderson lake to obtain fuel. After refueling, he aborted his first attempt to takeoff when the aircraft was slow to accelerate. About 20 gal of fuel was then drained from the aircraft. Another takeoff was started by making a step turn to…NTSB ANC82FAA18Accident · Minor injuriesFinal reportStinson 108 · Fairbanks, AKThe acft collided with power lines during final approach. The plt reported he encountered a downdraft type of windshear.NTSB LAX82DA336Accident · Minor injuriesFinal reportCessna T207A · Riverside, CADuring the second approach the acft struck an approach light. The acft was catipulted downward & to the left striking a moving camper truck on the highway. Visibility was described as zero on the rwy minutes after the accident.NTSB FTW82DA372Accident · No injuriesFinal reportAir Tractor AT-400 · Muleshoe, TXPilot collided with a water spraying machine while making crop spray pass. Landing gear tore off.NTSB CHI82DA345Accident · Serious injuriesFinal reportRaven S55 · Mattawan, MIDuring a landing in an open field the balloon collided with wires and started to burn. The pilot stated that her attention was temporarily distracted as the balloon approached a corral with horses and she was adjusting the maneuvering valve for landing. The…NTSB MKC82FCG19Accident · 2 fatalFinal reportCessna 172N · Lake Of The Oza, MOWitnesses reported that the pilot made a low pass at a cove, then flew out over the water, turned and flew back at low altitude. During a second low pass, it struck electrical cables that crossed the cove. After hitting the cables, the aircraft crashed in a…NTSB FTW82DA370Accident · Minor injuriesFinal reportRobinson R22 · Eden, TXThe pilot reportd that he lifted off to a three foot hover, checked his instrument readings, then took off. He reported climbing to 15 feet to clear some bushes and two fences that were in his flight path. As he approached the first fence, the helicopter was…NTSB ANC82DA090Accident · No injuriesFinal reportMaule M-5 · Nr. Mcgrath, AKThe pilot began a takeoff from an unimproved strip with two passengers on board. The winds were blowing from the northeast at 20 gusting 35 knots. The pilot reported that after the plane had rolled about 300 ft, the airspeed indicated over 40 KTS. After…NTSB LAX82FA329Accident · 2 fatalField investigationFinal reportChampion 7EC · Near Isleton, CAThe pilot and passenger were on a local flight to fly to the san joaquin river delta to observe and photograph a break in the river's level, as well as the passenger's boat. A consensus of the witnesses was that the aircraft was circling the area when it…NTSB FTW82DA362Accident · No injuriesFinal reportPiper PA-28-180 · Weslaco, TXThe plt overshot an approach to rwy 13 & went around. The crosswind leg was extended to give the plt more room. The plt turned on final & lined up on a street paralleling the rwy. Just prior to touchdown the plt saw the "x" painted on the street & executed a…NTSB CHI82DA333Accident · No injuriesFinal reportPiper J-3C65 · Bloomfield Hill, MITakeoff was from se end of a lake about 4,000 ft long (se to nw) with a small island in the center. The plt stated that after lift-off he obtained climb speed but the acft would not climb from about 20-30 ft above the water. Severe turbulence was encountered…NTSB LAX82DA326Accident · No injuriesFinal reportCessna 172M · San Jose, CAThe aircraft was substantially damaged when a landing gear, damaged by a wire strike, collapsed during landing. Witnesses indicated that the aircraft had entered a narrow valley at treetop level. Broken power lines started a grass fire which was eventually…NTSB ATL82DA259Accident · No injuriesFinal reportChampion 7ECA · Middletown, VADuring approach to an uphill & narrow strip, animals crossed the rwy. A go-around was initiated & the acft drifted into trees.NTSB FTW82DA360Accident · No injuriesFinal reportAmerican AA-1A · Georgetown, TXAt 50 feet AGL the instructor pilot closed the throttle to simulate engine failure during takeoff. He expected a low speed, low altitude, steep 120 degree turn to land on runway 29 by the private pilot receiving familiarization on the AA-1A aircraft. The…NTSB FTW82DA359Accident · No injuriesFinal reportCessna U206F · Katy, TXDuring arrival, the pilot initiated his landing with a quartering tail wind at 4 gusting to 8 knots. While landing, he realized his airspeed was too high and he elected to go around. During the maneuver, the tail of the aircraft collided with a power line at…NTSB FTW82DA358Accident · Minor injuriesFinal reportCessna 150 · Farmerville, LAThe pilot made a downwind takeoff from an intersection of the runway. The aircraft failed to clear trees at the departure end of the runway.NTSB ATL82DKQ18Accident · Minor injuriesFinal reportAir Tractor 301A · Marks, MSAircraft collided with guy wire while spraying chemicals, aircraft went out of control and crashed.NTSB ATL82DA257Accident · No injuriesFinal reportBell 206L · Greenville, SCThe pilot reported that he was making an approach to a new helipad that was still under construction when he felt a severe vibration. After landing and shutdown, he discovered that the tail rotor had struck the glass cover of a heliport perimeter light.NTSB CHI82FEG04Accident · 1 fatalFinal reportBently B8M · Williamsburg, OHAfter takeoff the acft climbed to about 250 ft AGL & then made a gradual shallow 180 deg left turn heading back toward the strip. It gradually started loosing altitude without any noticable variations or disruptions in its flt path when it clipped the trees &…NTSB ATL82DA256Accident · No injuriesFinal reportHughes 269B · Angier, NCWhile spaying soy beans, the pilot observed 3 power lines bordering the field, but failed to see a fourth. While on a swath run, the helicopter struck the fourth line with the main and tail rotor blades which resulted in a forced landing.NTSB FTW82FQA26Accident · Serious injuriesFinal reportCessna 150 · La Plata, NMAcft struck a power line which crossed a road at about 40 ft AGL. The acft was observed flying at low altitude in the area prior to the accident.NTSB DEN82FTG06Accident · 2 fatalFinal reportPiper PA-12 · Oakes, NDSeveral witnesses reported that the purpose of the flight was blackbird control of a sunflower field. There was speculation by local residents that the aircraft was being used to spread poisoned corn. This was substantiated when corn and a portion of an…NTSB ANC82DA080Accident · No injuriesFinal reportPiper PA-32 · Near Dillingham, AKThe pilot began taking off down slope in calm wind conditions with six passengers on board. Reportedly, the 1380 ft runway was mostly dry, but was muddy in places, except the last 100 ft contained standing water. The aircraft had barely lifted off prior to…