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 FTW84LA391Accident · Serious injuriesLimited investigationFinal reportBell 206B III · Ship Shoal 241The pilot had landed on a offshore helideck, which had one aircraft parked on it. After the passengers were clear of the aircraft, the pilot picked the aircraft up to a hover. During the hover, the pilot allowed the aircraft to drift slightly and one skid…NTSB CHI84LA390Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Westfield, INThe acft collided with a powerline during landing. The plt said he 'found himself too low and gunned the engine to stay over the corn field but did not see the wires. Had never known they were there.'NTSB CHI84LA389Accident · Minor injuriesLimited investigationFinal reportDenil Sonera II · De Pere, WIPlt stated that on initial climb, he became distracted by an insect in the cockpit and the acft drifted off the right side of the rwy, colliding with telephone lines near the end of the rwy.NTSB NYC84FA307Accident · 4 fatalField investigationFinal reportBell 206B · Wallingford, CTThe acft collided with wires after the plt announced by radio that he was going to make a low pass over the site of an outdoor event that he had just attended. Some witnesses saw the helicopter flying extremely low. It appeared that one of the landing skid…NTSB LAX84FU033Accident · 1 fatalFinal reportPioneer Flightstar · Lowerlake, CAAfter takeoff the ultralight flew at about 50 ft AGL toward a row of oak trees bordering a pasture. It then struck a 60 ft tree & crashed. Two witnesses who knew the plt well stated he had 'been drinking quite a bit' on the day of the accident. They also…NTSB CHI84LA378Accident · No injuriesLimited investigationFinal reportCessna 320B · Clear Lake, MNFollowing maint on an air vent the mechanic failed to secure the map compartment. The ass'y interfered with the rearward movement of the control yoke on rotation for takeoff limiting the climb rate and resulting in a collision with the trees. The flt…NTSB SEA84LA219Accident · No injuriesLimited investigationFinal reportBell 206 · Boulder City, NVThe plt was landing at a helipad that was surrounded by a wire fence. He reported that as he was about to land, he misjudged his apch & the tail rotor struck the fence. Subsequently, the helicopter hit the ground while turning right & the gear collapsed.NTSB ANC84FA157Accident · No injuriesField investigationFinal reportArtic S-1B2 · Clam Gulch, AKPlt stated that on takeoff from a 600 ft long gravel bar, the acft hit a clump of brush with the rt main landing gear. He stated that the acft turn into the path of taller brush, so he reduced the pwr and landed, turn 180 degrees after impact. The plt aslo…NTSB CHI84FA376Accident · 3 fatalField investigationFinal reportPiper PA-18-150 · Oak Grove, WIThe plt stated to the host of the picnic that he would 'buzz the party a couple of times.' The two seat acft had three occupants aboard at the time of the accident. Witnesses stated that the acft passed over the picnic twice at a very low altitude. The acft…NTSB ATL84LA278Accident · Minor injuriesLimited investigationFinal reportHead Balloons AX7-77 · Austell, GAWhile flying at a low alt looking for a suitable landing area the plt noticed power lines at a higher alt. Plt initiallyapplied heat to the envelope to try and climb above the wires, but did not immediately realize the height of the wires. Plt then advised…NTSB ANC84LA159Accident · No injuriesLimited investigationFinal reportCessna 172E · Palmer, AKThe acft was taking off from an airport which was an unimproved field site. According to the plt the acft would not accelerate and climb out so he stalled into the brush along a creek bed. The plt said the acft had departed this field before but both times…NTSB DEN84FA274Accident · 1 fatalField investigationFinal reportBoeing Stearman E75 · Kalispell, MTThe pilot was completing a turn to final on a normal aerial application maneuver. He was aprx 15 ft AGL at 65 mph when the a/c struck a bird (presumed to be a red tailed hawk). The force of the impact broke the plexiglass canopy and temporarily distracted the…NTSB LAX84LA464Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Watsonville, CAThe plt maneuvered during an aerial application flt to avoid high tension wires and collided with lower telephone lines. The plt said the winds were gusty at the time of the accident.NTSB CHI84LA366Accident · No injuriesLimited investigationFinal reportCessna A188B · Delavan, MNThe plt stated the acft would not climb rapidly enough on takeoff to clear powerlines. Plt elected to fly under the wires instead of climbing over them and risking stalling the acft. The prop, windshield, and vert stabilizer contacted the lowest wire. Plt…NTSB CHI84LA363Accident · No injuriesLimited investigationFinal reportCessna 150 · Brookville, OHThe CFI made a successful forced landing on a highway median strip while on a dual night x-country flt after a pwr loss occurred. CFI drained the fuel sumps and was able to restart the engine. He then decided to takeoff from the median and fly the acft back…NTSB NYC84FNC09Accident · 1 fatalFinal reportCessna 172 · Pownal, MEPrior to the accident, witnesses observed the acft making several low passes & maneuvering. During the last maneuver, the acft entered a dive & collided with trees before the plt recovered. Trees were broken or damaged over an area of about 200 ft. no…NTSB CHI84LA360Accident · No injuriesLimited investigationFinal reportBeech B-24-R · Independence, WIThe acft collided with trees near the departure end of the field during an attempted go-around. A passenger reported that the go-around was initiated at about 100 ft AGL, 1/2 way down the fld. The plt said the fld was in a valley, it wasa hot (reported temp…NTSB ATL84LA271Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Biloxi, MSPrior to departure the pilot determined that his destination, a grass runway, was dry. His first approach to this field resulted in a go-around because he would have landed long. The second approach resulted in a landing, but because his wheels began to slide…NTSB FTW84LA362Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Pecan Island, LADue to the wet condition of the sod strip the plt used only the last 1,000 ft of the strip for the takeoff. During the roll he felt that insufficient rwy remained and initiated an aborted takeoff. Unable to stop however the plt resumed the attempted takeoff.…NTSB ANC84LA144Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Viekoda Bay, AKBefore taking off, the plt had become preoccupied with pumping water from the floats & allowed the acft to drift downwind from a fishing vessel. He then elected to takeoff into the wind which was also directly toward the sun. After making a normal rough water…NTSB LAX84FA451Accident · 1 fatalField investigationFinal reportCessna T337G · Paradise, CAWitnesses observed the acft touchdown then heard a power application and watched the acft depart in a nose high attitude. The left wing of the acft struck an aprx 70 ft tall tree about 600 ft from the end of the rwy and 200 ft left of the rwy extended…NTSB LAX84LA446Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Coalinga, CAThe acft struck power lines about 50 ft AGL while on a x-country. The plt made a successful landing after the collision at an arpt about 30 miles away. The plt said the accident could have been prevented by not flying so low.NTSB LAX84LA440Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Watsonville, CAThe acft collided with a utility pole and was forced to land. The plt reported that on his last spray run in trying to do a better job than anyone else, he came to close to the pole. His rotor made contact with the pole. During the forced landing the landing…NTSB FTW84LU008Accident · Serious injuriesFinal reportMattison MAC MU-200 · Orange, TXAccording to law enforcement officers, who responded to the scene, the plt of the ultralight vehicle was attempting to land in a field when he encountered a x-wind & initiated a go-around. During the go-around, the vehicle struck a 30 ft tree while in a left…NTSB MKC84FA254Accident · 1 fatalField investigationFinal reportCessna A188B · Algona, IAN9387G was flying at an altitude of aprx 75 feet AGL when it struck power lines while maneuvering to spray a corn field. The reported weather near the accident site was: visibility 7 miles, temperature 73 degrees, light precipitation in the way of rain was…NTSB NYC84FA275Accident · 2 fatalField investigationFinal reportCessna 172I · Brockport, NYThe acft crashed into trees about 2500 ft from the takeoff point. Witnesses observed the acft in a running takeoff aftera normal landing. The acft failed to gain alt and stayed at about 50 ft AGL. The acft had taken off on rwy 28 & after takeoff was seen…NTSB MIA84LA227Accident · No injuriesLimited investigationFinal reportAero Commander 520 · Stuart, FLThe acft collided with a fence at the departure end of the rwy during takeoff. The acft tires were grossly under inflated and the turf rwy was wet and soft. One witness said the acft made an intersection takeoff without using the entire rwy length. After the…NTSB ATL84LA256Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Adams, TNAfter completing a spray run the plt climbed to 75 ft AGL to fly aprx 2 miles to the next field. The elevation of the destination field was higher than the last one sprayed; no estimate of elevation change was provided. While attempting to climb over a hill…NTSB CHI84LA345Accident · Minor injuriesLimited investigationFinal reportHughes 300/269C · Freeport, ILThe helicopter was being used to give sight seeing rides at albertus airport. The two pax onboard asked the plt to provide an exciting ride. The plt stated that he intended to demonstrate an autorotation to a corn field and make a pwr recovery. After flaring…NTSB SEA84FA198Accident · Serious injuriesField investigationFinal reportLuscombe 8F · Levenworth, WAAccording to the plt, downdrafts encountered after takeoff prevented a normal climb and resulted in a collision with trees at 60 to 80 ft AGL aprx 1 mile from the arpt.NTSB NYC84FA274Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Sydney, NYDuring a night arrival, the plt was cleared for a vor/circling apch to the sidney muni arpt. The published apch was from the hancock VOR with a northerly heading to the arpt of 354 deg. Subsequently, the acft crashed & burned on wooded terrain about 1 mi…NTSB LAX84LA438Accident · No injuriesLimited investigationFinal reportCessna 152 · Cressey, CAWitnesses observed two acft making multiple low passes down the river. Each acft was seen flying under 3 electrical power lines at least 3 times. On the last pass, according to local law enforcement officers, one acft struck and severed all 3 power lines.…NTSB SEA84FYK01Accident · Serious injuriesFinal reportCessna 172N · Creswell, ORThe acft collided with wires during an attempted go-around. The plt stated that he had made one go-around and on the 2NDLANDING attempt he landed hard in gusty wind & bounced. During the 2nd go-around he collided with wires & crashed.NTSB NYC84LA268Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seven Springs, PAAfter refueling, the plt took off from a 3000 ft rwy located in a mountainous region. He reported that after a normal rotation & lift-off, he established a positive rate of climb. However, shortly after takeoff, during gear retraction, the acft began to…NTSB MIA84LA226Accident · No injuriesLimited investigationFinal reportAyres Thrush S2R-T15 · Quitman, GAAt the end of swath run the acft struck a piece of farm equipment during the pull-up. After the collision the plt noticed liquid trailing behind the acft as he returned to his departure airport. Upon ldg when the left wing settledclose to the rwy, the plt…NTSB MKC84FA245Accident · Serious injuriesField investigationFinal reportCessna 188 · Bloom, KSThe acft struck two guy wires during a spraying operation when the plt failed to clear the wires. Operators heard the impact which occurred about 160 AGL & toppled the 310 ft tower. The acft wings were separated from the fuselage which continued to the west…NTSB FTW84LA349Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tallulah, LAAfter applying seven (7) loads of chemicals the pilot landed and loaded both fuel and chemicals. After takeoff he completed one swath run and was just starting the second run when he allowed the wheels to contact the crop. The load was not jettisoned and the…NTSB FTW84LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Del Rio, TXJust after liftoff from the fourth touch-and-go landing, the plt heard and felt an impact. Continuing climbout, he observed a deer carcass on the runway. A subsequent uneventful full stop lndg was made but substantial damage had been incurred in the left main…NTSB BFO84FA003Accident · 2 fatalField investigationFinal reportPiper L-21-A · Selbyville, DEAt the conclusion of towing banners with no pax on board, the acft was landed and topped off with fuel. The plt then reentered the acft and an additional employee got in the rear seat with the intension of flying to a nearby airport for a plt exchange. During…NTSB ATL84FA247Accident · Serious injuriesField investigationFinal reportCessna 172H · Ellijay, GAThe student pilot and passenger were on unauthorized flight in the local area at 0145 when the accident occured. According to the student pilot he had returned from a local flt, picked up a pax, departed again and had flown for 30 to 45 mins before returning…NTSB NYC84LA263Accident · No injuriesLimited investigationFinal reportCessna 150 · Hanover, NJApch was high but plt continued apch with power at idle and full flaps. Plt misjudged rwy length and touched down 1/2 way down the rwy. To avoid hitting trees at end of rwy, plt aborted the landing. Plt stated that with the slow airspeed and full flaps the…NTSB DEN84FA251Accident · 2 fatalField investigationFinal reportCessna R172E · Farmington, NMAfter being airborne 1 hour and 10 minutes the traffic surviellance flt was cancelled. The plt transmitted to the policeunits on the ground that he would 'buzz' them as he left the area. During this pass the acft struck a high voltage transmission line 88.9…NTSB CHI84LA335Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lebanon, OHPlt attempted takeoff on 1100 ft of remaining rwy with a 5 kt tailwind. Acft became airborne but was unable to clear power lines located 1000 ft beyond the departure end of the rwy. Density alt at time of accident was calculated to be 3600 ft. with these…NTSB FTW84LA338Accident · Serious injuriesLimited investigationFinal reportCessna 150B · Weatherford, TXThe plt had been performing successful solo touch & go landings toward rising terrain with a high ambient temp, but after boarding a passenger the acft failed to clear the rising terrain and stalled into the trees. The density alt was about 3600 ft while the…NTSB LAX84LU030Accident · Serious injuriesFinal reportEipper Quicksilver MX · Thousand Oaks, CADuring a takeoff climb, the ultralight collided with a power line & crashed. The plt stated that he did not see the wires until impact; nor was he aware of their presence.NTSB FTW84LA337Accident · 1 fatalLimited investigationFinal reportCessna A188B · Batesville, TXThere were no known acft or eng problems involved in the accident. A witness stated the acft started its pullup from the first swath run of the day on an agricultural operation, collided with an electrical transmission line & fell to the ground, fatally…NTSB NYC84FFA04Accident · Serious injuriesFinal reportPiper PA-25-150 · Lennox, NYDuring the pullup after a swath run the acft collided with a tree causing it to crash out of control into the ground. The wreckage was burned in a post crash fire.NTSB LAX84LA423Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Maricopa, AZThe plt added fuel and chemicals for a total of about 230 gallons of cargo. The temperature was 87 degrees and the arpt elevation is 1100 ft. the density alt was not computed and performance not assessed. After takeoff in a crosswind turn the acft 'quit…NTSB LAX84FA421Accident · 3 fatalField investigationFinal reportFairchild Hiller FH-1100 · Meadview, AZPurpose of the flt was s sightseeing tour of lake mead, hoover dam and the western rim of the grand canyon. Before reaching the canyon the flt was to travel over a 5500 ft MSL ridge. The helicopter contacted a juniper tree at the bottom of a 3-sided canyon at…NTSB CHI84FA321Accident · No injuriesField investigationFinal reportS.I. Briggs Varieze · Pickett, WIThe acft contacted a 25 ft AGL 2 strand 14000 v power line. After contacting the lines, the acft touched down in a corn field and traveled for aprx 210 ft. the acft then crossed a 2 lane road, struck a ditch separating the canard/gear and traveled an…