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 CHI83LA318Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Utica, MIThe student pilot made a delayed decision to land and landed within a few ft of wires without seeing them. The ground crew tried to hold him but the balloon still had too much lift. The student then saw the wires and tried to go over thembut the collision…NTSB LAX83LA344Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Columbia, CAThe acft contacted a powerline 100 ft above the water at new mellones reservoir. The acft was landed at Columbia. CA without further incident. An inspection of the acft revealed that the top portion of the vertical stabilizer was missingand the rudder was…NTSB LAX83LA343Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Auburn, CAWitnesses observed the acft make two approaches to rwy 25. During the second approach the acft got close to the rwy and drifted to the right. Power was applied and the acft collided with a tree. The wind was gusting to 30 KTS.NTSB LAX83FA341Accident · 3 fatalField investigationFinal reportCessna 177 · Grass Valley, CAThe pilot had flown to the arpt 5 times before and was aware that all landings were to the north and takeoffs to the south on the single rwy 01-19. This was for noise abatement at the north end of the rwy and because of the rwy upslope to the north. At about…NTSB MKC83FA153Accident · 1 fatalField investigationFinal reportCessna 188B · Shelton, NEThe plt had dusted 1 field & had started dusting another that was located on rolling terrain. After making 3 swath runs over the 2nd field, he was maneuvering for a 4th run when the acft's right wing impacted with a power line cable. The wing's leading edge &…NTSB FTW83FA332Accident · Serious injuriesField investigationFinal reportBoeing B75N1 · Webb, TXThe pilot stated that before flying under wires a bird struck and broke a plastic fuel gauge mounted under the center section of the upper wing. Fuel reportedly sprayed onto the windscreen and the pilots face restricting his forward visibility. In an effort…NTSB ATL83FA272Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Ellenwood, GADuring the flt, the acft collided with 2 utility transmission lines, then crashed to the ground. According to witnesses, the accident occurred after the acft had circled the passenger's home & the plt had started a turn. An exam of the wreckage revealed no…NTSB ANC83LA124Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Sleetmute, AKDuring an upstream takeoff toward a fish weir, the acft did not attain enough altitude to clear the fish weir and collided with the top of the weir. The acft contacted the water in a nose low attitude and the acft nosed over onto its back.NTSB FTW83LA327Accident · No injuriesLimited investigationFinal reportBell 212 · Eugene IslandAfter making an apch to an off-shore oil well heliport, the plt believed the tail rotor was too close to a stairwell, so he made a peddle turn to the right. During the turn, the tail rotor blades contacted a crane. The crane was located about 15 ft from the…NTSB LAX83FVG13Accident · Serious injuriesFinal reportChampion 7ECA · Shingle Springs, CAThe acft collided with an oak tree while maneuvering at low alt. The weather was VMC. The pilot stated that he was flying to maintain a battery charge. He said he climbed to about 1600-1700 ft MSL and flew southeast. The average elevation along this route is…NTSB DEN83LA163Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Hooper, UTThe spraying operation was being conducted over a large mosquito abatement district. The district was mapped out into several small areas to be sprayed. Due to the many areas to be sprayed, the plt did not inspect each section for obstacles prior to the flt.…NTSB CHI83LA304Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Middle Bass Isl, OHThe acft collided with wires during a go-around attempt. The pilot reported that as he approached at about 10-15 ft AGL some people walked onto the rwy. He added full power and while gaining control of the acft it collided with the wires and crashed into the…NTSB ATL83LA268Accident · No injuriesLimited investigationFinal reportEames Acro Sport · Huntersville, NCThe acft collided with a tree during inverted flt over an arpt. The pilot had made several aerobatic maneuvers over the airfield. On the last pass the acft was inverted at low alt as it proceeded down the rwy it drifted west about 200 ft and hit a tree near…NTSB FTW83LA328Accident · No injuriesLimited investigationFinal reportBell 206 · Houston, TXThe plt stated he intended to move the helicopter from a dolly platform to a surface parking area when the left skid collided with the dolly and the acft rolled over.NTSB SEA83LA140Accident · No injuriesLimited investigationFinal reportBell 205-A1 · John Day, ORThe plt stated that before starting his takeoff, he hovered for aprx 20 min to get the helicopter's weight to where the acft would hover out of ground effect. The takeoff was begun with a climb speed of 45 KTS; however, the helicopter collided with trees. The…NTSB FTW83FA319Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Newport, ARThe acft remained low after takeoff and after a turn continued north out of sight of witnesses and did not reappear. It collided with the bottom two strands of a powerline which were severed by the propeller. The acft fuselage came to rest 162 ft beyond the…NTSB FTW83FA313Accident · 1 fatalField investigationFinal reportTaylorcraft BCS 12-65 · Odessa, TXThe acft collided with wires and the ground during recovery from an aerobatic maneuver. The plt had done what appeared to be a maneuver similiar to a hammerhead stall shortly after first takeoff. The acft appeared to be recovering as it 'bottomed out' at…NTSB ATL83FMG02Accident · Serious injuriesFinal reportCessna 150 · Monroe, NCThe acft crashed into trees during a night landing attempt. The student pilot was taking a friend to a grass unlighted 2200 ft airstrip for a night landing. A friend in an automobile was shining her car lights on the rwy. The pilot made anunsuccessful attempt…NTSB FTW83LA317Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Jefferson, TXThe acft collided with small trees and two fences during takeoff and nosed down into the ground. A witness noticed the acft wobbling in the air at low alt before the collision with the trees. The density alt was 2800 ft. there were no mechanical malfunctions.NTSB CHI83FA291Accident · 2 fatalField investigationFinal reportPiper PA-22 · Rogers, OHThe acft collided with trees immediately after takeoff. The acft was 20 lbs under max gross weight. Density alt was 2,500 ft.NTSB MKC83LA140Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7 · Ellsworth, KSThe Balloon collided with a radio tower during takeoff. The wind was reported to be from 180 degrees at 12-18 KTS. There is no evidence that this plt received weather briefing. This Balloon was launched closer to the tower than any of the other balloons…NTSB ATL83LA257Accident · No injuriesLimited investigationFinal reportCessna A188B · Prattville, ALThe acft collided with a cow during takeoff for an aerial application flt. The collision broke off the right main landing gear and killed the cow. The pilot stated that the cow got through the fence and wandered onto the strip. The airstrip has a small rise…NTSB ATL83LA250Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Tuscaloosa, ALThe acft collided with a power line spanning a river during a low pass over the water. The pilot said the purpose of thelow pass was to look for his father in a boat. He said he thought he saw the boat and in pulling up the acft hit the power line. Control…NTSB MIA83FA173Accident · 1 fatalField investigationFinal reportTaylorcraft TC-19 · Lorida, FLWitnesses along a highway observed the acft flying at low altitude. One witness saw the acft hit a powerline, climb a little, then crash nose first.NTSB CHI83LA288Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Morris, MNThe plt reported that while he was waiting for the flagman, circling the field to be sprayed, & talking to the flagman, the acft began to sink & struck trees. The load was dumped, but the plane continued to sink to the ground. During the landing, the acft…NTSB DEN83LA170Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Page, NDWhile spraying at dusk, the plt was concerned about injuring a 'non-target crop' across the road to the south from the field that was being sprayed. He stated that an irrigation system was sitting pointed southwest, and that as he was entering a swath to the…NTSB NYC83LA156Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Shelter Island, NYThe acft crashed off the departure end of the rwy in a swamp during an attempted go-around. The pilot said the approach was normal but that the acft floated more than normal. A go-around was initiated. The pilot could not remember if the acft touched down but…NTSB ATL83LA245Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Columbia, SCThe student plt was practicing landings on rwy 7 & completed 1 successful landing. He reported that on the 2nd approach, a gust of wind blew the acft to the left, so he made a go-around. A 3rd approach was made with the acft lined up slightly to the left of…NTSB ANC83FA107Accident · No injuriesField investigationFinal reportRotec Engineering 3A · Fairbanks, AKThe plt & a passenger were on a sales demonstration flt in the two-place, home built, ultralight acft. During takeoff, the acft mushed into power lines after attaining an altitude of aprx 30 ft. according to the plt, there was a loss of power during takeoff.…NTSB MKC83LA135Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Madrid, IAThe acft collided with unmarked wires over a river at about 150 feet AGL. A witness observed the acft low over the river and called an ambulance before the acft collided with the wires.NTSB LAX83FA305Accident · 2 fatalField investigationFinal reportProut LONG-EZE · Geyserville, CAThe acft was first observed rounding the bend in the russian river about 1 mi west of the bridge flying in an easterly direction, apparently following the river bed. The acft's altitude was described from 'just over the water' to 'tree-toplevel.' As the acft…NTSB ANC83LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Kasilof, AKThe acft collided with trees and crashed during takeoff. The plt stated he made several attempts to get airborne in bothdirections from the strip and when he finally got airborne he struck a tree and crashed. The plt statements varied during several…NTSB SEA83FA133Accident · Minor injuriesField investigationFinal reportGarlick UH-1B/204 · Fossil, ORThe helicopter collided with a dead tree and crashed while conducting a spray run on an aerial application mission. The pilot said that the dawn light conditions made the obtacle hard to see. In the attempt to clear the tree the spray boom made contact and…NTSB LAX83FA298Accident · 1 fatalField investigationFinal reportCessna 152 · Pacoima, CAThe acft was observed maneuvering in the area of the arpt traffic pattern for about 45 min before the accident. Initial impact occurred with power lines about 1/2 mi southwest of the arpt while the acft was on a heading of about 320 deg. The acft then struck…NTSB MKC83FA133Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · 3m Se Of Benton, MOAccording to the surviving passenger, a boy, the plt was flying the acft from the right seat. The acft was flown to the vicinity of the plt's property where he made a pass over a farm belonging to a relative. The low pass was made near the operator of a…NTSB ATL83FA237Accident · 2 fatalField investigationFinal reportLockheed L-18 · Millhaven, GAThe acft collided with trees during an attempted off arpt landing at night for marijuana unloading. The acft was being followed by a u.s customs helicopter, the occupants of this helicopter said the acft had made one missed approach and during the go-around…NTSB NYC83LNC07Accident · Minor injuriesFinal reportBölkow B-1 · Groton, VTThe plt was on a x-country flt of aprx 100 miles. She reported that on the last leg of the flt, a lack of 'lift' was encountered & an off arpt landing was initiated. While on final apch to land in a field, the glider struck a telephone wire aprx 30 ft AGL.…NTSB MIA83FU004Accident · 1 fatalFinal reportEipper Quicksilver MX · Williston, FLThe plt of the ultralight vehicle took off from an open field near his residence. Witnesses near the crash site stated that they observed the ultralight approach an open field for a landing. As the plt was in a left descending turn to the field, the…NTSB CHI83LA266Accident · No injuriesLimited investigationFinal reportMaule M4-220C · Green Township, INThe pilot tried to land downwind but his airspeed was too high and the go-around was started too late. During climbout the landing gear caught on a telephone cable which arrested the acft.NTSB MIA83FU003Accident · Serious injuriesFinal reportEipper Quicksilver · Lake Worth, FLThe ultralight collided with a tree while on final approach to land in an open area. This was the pilot's first flt in an ultralight acft. He said that the accident happened when he made an improper weight shift in an effort to avoid a collision with the…NTSB CHI83LA265Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Flint, MIAfter takeoff, the plt leveled the Balloon, and a short time later, he collapsed to the floor of the gondola & had difficulty breathing. The Balloon began descending. Subsequently, it hit the porch of a house & was damaged. The plt died from acute myocardial…NTSB MIA83LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe plt reported that he descended to aprx 50 ft AGL to demonstrate flt at low altitude to his passengers. While flying over a pasture at this altitude, the acft struck a pine tree, damaging the right wing. The plt experienced no control problems & returned…NTSB FTW83LA285Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Clifton, TXOn final apch to land, the plt saw 2 buzzards & added power while maneuvering to avoid theem, then continued the apch. This resulted in landing beyond the intended touchdown point. The middle of the rwy was higher than either end; therefore, the plt was…NTSB LAX83LA289Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Thermal, CAThe acft collided with a truck while attempting to land on the loading pool of the truck being used for refueling purposes. The pilot of the helicopter stated that when about 6 inches from touchdown he felt something funny and since the refueling man was…NTSB DEN83FTM05Accident · Serious injuriesFinal reportBensen B-8M · Wendover, UTThe gyrocopter collided with a powerline at 29 ft AGL. The pilot took off from a road and in proceeding along the road collided with the wires. The pilot was seriously injured. His student pilot certificate had expired in dec. 1979. Due tohis injuries no…NTSB SEA83FA127Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Stehekin, WAThe acft crashed into trees at the departure end of the rwy during a go-around. The pilot had attempted a landing on RWY34 with full flaps. Power was cut on final over the trees at 75 mph. When touchdown had not been accomplished about halfway down the rwy…NTSB MKC83LA129Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Puxico, MOThe plt stated that while trimming a rice field he was watching his drift & when he looked forward he saw the transmission line but was too close to avoid the lines.NTSB LAX83LA288Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Yuma, AZThe plt reported that he landed on a farm road to inspect the alternator & associated wiring before starting aerial application. Following the inspection, during which nothing was found wrong, he commenced taking off. As the acft was accelerating for takeoff,…NTSB CHI83FU004Accident · Serious injuriesFinal reportPara-Sail Glider · Battle Creek, WIThe ultralight vehicle was observed flying low over a golf course. As it approached a tall tree, witnesses heard the addition of power. However, a wing hit the tree & the ultralight spiraled down & impacted the ground. The plt did not possess an FAA plt…NTSB CHI83LA250Accident · Minor injuriesLimited investigationFinal reportBell 47G5A · Detroit, MIThe pilot stated that he was assigned a community affairs project to fly a 'ronald mcdonald' clown to a nearby restaurant for a magic show. During the hover in the landing area the rotor blades struck a light pole. The helicopter pitched forward and landed on…