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 ATL87LA195Accident · No injuriesLimited investigationFinal reportCessna 172E · Denmark, GAThe acft struck power lines and severed the nose gear during landing. When the nose was lowered to ground on landing roll acft nosed over inverted. Acft was being delivered to mechanics new airstrip for annual inspection. The plt was unaware of power lines…NTSB LAX87LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auberry, CADuring an approach into a private airstrip, the student pilot touched-down, then decided that there was not enough stopping distance and elected to go-around. On the initial climb-out the aircraft struck an object that made the aircraft yaw right then left.…NTSB LAX87DUJ08Accident · Serious injuriesFinal reportTeague Phantom · Casa Grande, AZThe plt was flying the ultralight type acft at low level. As he flew thru a pass between two foothills, the acft struck telephone lines, then collided with terrain. There were no reported mechanical failures or malfunctions.NTSB FTW87LA153Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Marietta, OKThe plt rprtd that drg takeoff fm a grass rwy, the acft stalled after climbing about 10 ft AGL. He said that torque pulled the nose of the acft to the left & he tried to recover. However, there was insufficient alt & the acft hit the tops of trees, then fell…NTSB ATL87FA189Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Jesup, GAWitnesses rprtd the acft 'buzzed' (flew low) over a factory, where the plt used to work, then it went over the altamaha river, flew under a bridge & continued up the river at low alt. About 2 to 3 mi upstream, the acft was maneuvering when it struck trees &…NTSB CHI87FA153Accident · 2 fatalField investigationFinal reportPiper PA-28R · Milwaukee, WIDrg arr at the Milwaukee/lawrence j timmerman arpt, the plt made 2 atmts to use the localizer 15L apch. After the 2nd missed apch, he elected to divert to Milwaukee/general mitchell fld (mke). At that time, he was adzd the mke wx was 300' ovc, 1/4 mi vis with…NTSB CHI87DEP07Accident · Serious injuriesFinal reportPiper PA-36 · Plover, WIAfter spraying most of a bean crop, the plt was making clean-up swaths over an area at the north side of the field. This area had bldgs to the west & trees to the east. To avoid flying toward the bldgs, the plt elected to make the passes to the east (toward…NTSB FTW87LA150Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Chelsea, OKThe non-rated plt attempted a downwind takeoff from a 1450' pvt grass strip. The strip was soft from recent rain & contained grass & weeds which were 6 to 7 inches hi. After taking off, the acft would not climb fast enough to clear obstacles. Subsequently, it…NTSB DEN87LA155Accident · No injuriesLimited investigationFinal reportCessna 172 · Paradise, UTThe plt departed bear lake arpt, montpelier, ID, and flew to logan, UT. He departed logan and flew to his father's ranch at avon, UT, near Paradise. A 1400-FT dirt/gravel driveway leading to the ranch house was used as a rwy. The plt said he helped his father…NTSB DEN87LA157Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Ray, NDThe plt reports that he was departing from an aerial app operating area. He said there was a tree line along a road with an opening and the takeoff was made toward the opening. There were wires across the opening and the poles were obscured by the trees on…NTSB NYC87LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt.Union Boro, PAThe aircraft collided with transmission wires while flying low during a pleasure flight. An uneventful precautionary landing was made on a highway with reduced power and full flaps.NTSB FTW87FA151Accident · Serious injuriesField investigationFinal reportCessna A188B · New Taiton, TXAcft was observed departing on rwy 35 of a 4,250' pvt ag strip after having been loaded to near capacity with 46% nitrogen fertilizer. Acft lifted off, crossed a fence parallel to the rwy and struck a fence that was perpendicular to the north end of the rwy.…NTSB FTW87LA144Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · Lago Vista, TXWhile maneuvering at approximately 50 feet AGL, the aircraft's landing gear contacted a 7200 volt powerline. Control of the aircraft was lost, and it descended out of control into about 2 feet of water, causing substantial damage.NTSB FTW87LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Cameron, TXDuring takeoff climb the aircraft struck a powerline then trees and impacted the ground. The aircraft was being flown bya student pilot with no medical certificate or solo endorsement.NTSB SEA87LA114Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Yerington, NVWhile on an aerial application swath run the pilot allowed the aircraft landing gear to contact the grain crop, resulting in loss of airspeed, uncontrolled descent, impact with the ground and nose over.NTSB MKC87FA121Accident · Serious injuriesField investigationFinal reportTaylorcraft BL-65 · Hope, ARThe PIC had last student certificate and medical in 1978. On this flight with passenger, takeoff was made from rough hay meadow, 1372 feet long. When airplane could not climb over powerline at end of meadow, pilot decided to fly under powerline. Right wing…NTSB MIA87LA173Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Vaiden, MSThe plt stated that during the takeoff ground run the acft travelled over a small rise on the rwy & became airborne prematurely. The acft then collided with trees while the plt was trying to maneuver it to avoid a populated area. The acft then collided with…NTSB BFO87LA041Accident · 1 fatalLimited investigationFinal reportPiccard AX-6 · Gaithersburg, MDAfter two aborted landings the pilot saw a field in the distance and attempted to land. Although two other balloons had landed nearby, the field he was blown towards had numerous powerlines surrounding it, some of them at treetop height. During the approach…NTSB ATL87LA158Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Kannapolis, NCThe Balloon pilot was executing a landing approach to a clear area. He failed to see and avoid electrical power lines on the near side of the field as he made his approach. The Balloon collided with the power lines and the basket landed hard. The Balloon…NTSB FTW87DRD05Accident · No injuriesFinal reportGrumman G-164 · Kaplan, LAThe plt was dispensing fertilizer on a rice field when the acft collided with six strands of a power line at about 20' AGL. The airplane then crashed to the ground & was substantially damaged. The power line poles were located outside the field boundry.…NTSB BFO87FIG04Accident · No injuriesFinal reportAyres S2R-T15 · Grantsville, MDThe acft was second in a flt of three spraying forest area with dimilin when it contacted a power line suspended between two hilltops. The prop severed the single strand of cable and shortly after the engine lost power. The plt maneuvered for an emgcy lndg,…NTSB ATL87LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Dahlonega, GAThe acft impacted trees and a hillside shortly after a night takeoff from rwy 33 while the CFI was flying the acft from the rt seat. The CFI reported that he intended to fly the pattern to demonstrate a ldg to his student. During initial climb, he lost sight…NTSB LAX87DVA09Accident · No injuriesFinal reportAyres S2R-T34 · Mendota, CADuring an agricultural application flight, the aircraft struck a pole that was located 30 feet within the field boundary. The pilot stated that due to the dawn light and the way the pole blended in with the field along with a light amount of chemical on the…NTSB ATL87DEI03Accident · No injuriesFinal reportBell 47G-2A · Monroeville, OHThe plt was on a normal spray run next to the edge of a field when he misjudged his clearance & the main rotor blades contacted a tree. The helicopter then crashed to the ground in a wheat field.NTSB SEA87LA096Accident · No injuriesLimited investigationFinal reportMooney M20F · Wagontire, ORDuring takeoff with full flaps and a density altitude of about 6,200 feet the aircraft failed to gain flying speed. Shortly after becoming airborne the aircrafts gear caught on a barbed wire fence at the departure end of the runway. The aircraft then struck…NTSB CHI87LA130Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Lansing, ILDuring an attempted go-around, the right wing struck a tree, the left wing then contacted a building and the aircraft impacted in a freshly plowed field. Witnesses report the aircraft was high and fast and drifting to the right of runway centerline. Also…NTSB BFO87LA038Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEDuring takeoff the pilot stated that at about 150 to 200 feet he experienced a slow sinking of the aircraft. The engine was at full throttle, the flaps set at 10 degrees and the airspeed at 70 knots. The aircraft continued to sink and collided with trees.…NTSB LAX87LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe student and CFI landed at ford island and the CFI deplaned to observe the student perform solo landings. The studentexecuted one takeoff and landing without incident. On the second approach the student elected to make a go-around. He used full flaps for…NTSB DEN87LA124Accident · No injuriesLimited investigationFinal reportBrantly Helicopter 305 · Golden, COThe commercial plt was performing hover tests in his experimental helicopter at his private helipad, located 60 feet from his residence. The plt reported winds as variable gusting to 40 knots. The plt's attention was diverted and a wind gust pushed the…NTSB LAX87DUM04Accident · Minor injuriesFinal reportTexas Helicopter M74L-WASP · Holtville, CADuring an aerial application flight, the pilot reported that the electrical system failed. Shortly after, the aircraft collided with power lines. Inspection of the aircraft revealed that the generator was inoperative. There were no other reported mechanical…NTSB BFO87LA036Accident · No injuriesLimited investigationFinal reportBeech C-24R · Chestertown, MDThe pilot, unfamiliar with the airport, intended to perform a trial takeoff run to determine how the aircraft accelerated on the grass runway. During the trial run when the aircraft was about half way down the runway, the pilot felt the aircraft was ready to…NTSB BFO87LA034Accident · Minor injuriesLimited investigationFinal reportAyres Turbo Thrush 52R34 · Lavale, MDWhile spraying for gypsy moths during the early morning, the turbo-thrush collided with static wires located on top of high tension lines. The pilot stated that he did not see the wires because they were located on the shady side of an adjacent mountain.NTSB MKC87DCQ02Accident · Serious injuriesFinal reportCessna 188 · Harper, KSThe pilot was preparing to spray a wheatfield. During the second 1/3 of procedural turnaround, the aircraft struck powerlines, then the ground. The aircraft was destroyed by post-impact fire.NTSB CHI87LA123Accident · Minor injuriesLimited investigationFinal reportCessna A152 · Gobles, MIDuring the third leg of a cross-country flight, the pilot reported that the sun was directly in his eyes while on final approach to rwy 27. He stated he first saw the set of power lines when they were about 25 feet ahead of the aircraft. While attempting to…NTSB CHI87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Footville, WIPilot landed in a field to practice an emergency landing. After two unsuccessful attempts to takeoff from the soft, plowed field, the pilot taxiied onto a two-lane road. On lift off the left wing struck a road sign.NTSB NYC87LA139Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Valatie, NYThe Robinson R-22B took off from a open field, traveled 600 feet and struck suspended utility lines at approximately 25-30 ft. afterward, the helicopter was landed successfully. Other lines were approximately 1000 ft from the departure point. The pilot was…NTSB NYC87LA137Accident · No injuriesLimited investigationFinal reportStearman PT-17 · Hampton, NHWhile on final approach, the plt stated that the acft encountered a moderate crosswind. At abt mid-field, the plt elected to make a go-around, however, due to windshear and/or downdrafts, the acft was unable to climb. The Stearman collided with several tall…NTSB MKC87FA094Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Neelyville, MOWitnesses stated that the p.I.c. had aborted several takeoff attempts while trying to depart to the north--the winds were originating from the southwest at approximately 5 mph. The aircraft eventually departed from, and almost used the full length of, runway…NTSB DEN87LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Harvey, NDAn ag plt was working a field on an aerial application flt. At the end of a spray pass, the acft struck a shelterbelt and went out of control. The acft climbed to 300 ft and rolled inverted. The acft impacted the ground in a nose low, wing down attitude. The…NTSB MKC87FA092Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Valley, NEAt aprx 2020 CDT, witnesses saw the acft as the plt made svrl low passes over the platte river near Valley, NE. On the last pass, the acft struck power lines, then crashed in the river. The wreckage came to rest in the main channel of the river in aprx 25 ft…NTSB MKC87LA090Accident · No injuriesLimited investigationFinal reportCessna A188B · Orleans, NEThe pilot stated that he was spraying a wheat field with a load of chemicals, and was completing his fourth swath run, when he noticed powerlines in his flight path. He performed an evasive maneuver; however, the aircraft struckthe powerlines. The aicraft…NTSB MKC87LA088Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Lincoln, KSThe plt was spraying 2/4/D when one spray nozzle stuck open. Rather than kill alfalfa and trees during the turnarounds, the plt elected to land on a dirt road and repair the nozzle. He misjudged the width of the road and on touchdown, the right wing touched…NTSB ATL87DKG01Accident · Serious injuriesFinal reportAir Tractor AT301 · Atmore, ALDuring landing the aircraft collided with a tractor mowing grass on the runway. The pilot stated that the sunglare on final prevented him from seeing the vehicle on the runway. The tractor's operator apparently did not hear the aircraft because he made no…NTSB ATL87DEI02Accident · No injuriesFinal reportBell B-206-1 · Youngstown, OHWhile hovering from the wash rack, the helicopter backed into a utility pole. The main rotor system separated from the airframe following the collision. There were no postimpact mechanical malfunctions/failures.NTSB DEN87LA105Accident · No injuriesLimited investigationFinal reportCessna TR182 · Santa Rosa, NMAn a & p acft mechanic who additionally was a commercial plt was operating a borrowed acft on a local flt. He landed on an island in a lake and shut down. Later, when airborne on takeoff, the right elevator struck a small tree and the acft yawed right. The…NTSB DEN87LA102Accident · Minor injuriesLimited investigationFinal reportAero Commander S-2D · Columbus, NMThe plt departed deming, NM and flew to a ranch 15 mi n of Columbus, NM, to position the acft for aerial spraying that day. It was still dark when the plt made his apch to a road paralleled by power lines on the left and telephone cable marker posts on the…NTSB ATL87LA115Accident · No injuriesLimited investigationFinal reportCessna 182Q · Meridianville, ALThe plt completed the vor/dme-b appch to the arpt and cancelled his IFR flt plan. The plt reported observing that the acft was to the right of the rwy while on final appch to rwy 36. He then initiated a go-around, and began a right turn after 'passing' a tree…NTSB ATL87DLT01Accident · No injuriesFinal reportSchleicher ASK-21 · Eagleville, TNDuring a landing attempt, N174KS collided with a treeline on final approach to the airport. The instructor reported that the flight was normal until the student encountered a downdraft on final approach. The instructor took control of the controls, but was…NTSB FTW87LA095Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Midland, TXOn April 15, 1987, at approximatly 1910 CDT, the private pilot of a Cessna 182Q attempted to land on a 2650 ft dirt runway near Midland, TX. Witness stated she landed long and fast. The brakes failed due to a pre-existing crack in the left brake line. The…NTSB ATL87LA110Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Branchville, ALThe plt was ldg at the private airstrip to the north with a tailwind, because trees located on the north end of the rwy precluded ldg to the south into the wind. He made three attempts to land on the 1,754 ft runway; witnesses reported that a 7-12 kt tailwind…