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 ANC87LA151Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Salcha, AKThe private pilot was unable to maintain directional control of the acft when he encountered a quartering crosswind gust on final approach. The left wing collided with brush and small trees along side of the unattended airstrip. The pilot rptd the wind…NTSB ANC87FA137Accident · 1 fatalField investigationFinal reportEnstrom F-28F · Anchorage, AKThe pilot of the helicopter was seen flying at approximately 50 feet AGL down the length of a private gravel airstrip near Anchorage, Alaska. A nearby jogger said that the pilot appeared to wave at him as he flew past and then he heard the helicopter crash…NTSB ATL87DLT04Accident · No injuriesFinal reportNord SV4C · Lebanon, TNThe pilot stated while on final approach he allowed the aircraft to get too low and slow. He realized it was too late to recover and the aircraft collided with a tree.NTSB NYC87LA242Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Marlboro, NJDuring the plt's 1st apch to land, he noted a wind shift & made a go-around. He said the wind shifted back in favor of rwy 27, so he attempted another landing with a longer, lower apch to accommodate the winds. Also, he noted there were trees near the apch…NTSB SEA87LA176Accident · No injuriesLimited investigationFinal reportCessna 150 · Oak Harbor, WAThe plt had not slept the night of the flt. He was wearing contact lens and had closed his eyes several times during the flt to alleviate stinging. While on short final approach to land the plt closed his eyes and fell asleep. When he awoke he was left of the…NTSB FTW87DQG03Accident · Serious injuriesFinal reportSchweizer G-164-A · Seminole, TXDuring the flare for landing on a county road the aircraft collided with a pickup truck traveling in same direction as the aircraft. The driver of the pickup sustained serious injuries. The pilot was not injured. The pilot stated he did not see the pickup…NTSB FTW87DRD12Accident · Serious injuriesFinal reportPiper PA-22-150 · Mansfield, LAThe airport was 324 feet above sea level. The OAT was 96 degrees f. the airplane, with the pilot and two passengers, lifted off the rwy but would not climb. A witness stated the engine sounded normal but the nose was very high. The airplane impacted trees and…NTSB MKC87FA165Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Batesville, ARThe airplane was at maximum gross weight at takeoff. The field elevation was 613 feet and the density altitude was 3300 feet. There were two runways available. Runway 25 was 6002 feet long and had a slight headwind from the southwest. Runway 35 was 3320 feet…NTSB BFO87DHD08Accident · Minor injuriesFinal reportBede BD5B · Wilmington, DEThe pilot's failure to attain sufficient altitude to clear obstacles located off the departure end of the runway. His overconfidence in the homebuilt aircraft's performance was a contributing factor.NTSB NYC87MA236Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-8-63 · Newburgh, NYThe wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the…NTSB FTW87DRD11Accident · 1 fatalFinal reportGrumman G-164A · Bastrop, LAThree flagmen were working with one spray plane and three fields. On this pass, two of the flagmen moved to the proper positions but the other one had moved too FAR laterally. The pilot stated to the sheriff that he had observed the flagman stepping off the…NTSB DEN87FA219Accident · 3 fatalField investigationFinal reportCessna 182P · Milner, COThe plt was on a flt fm green bay, WI to steamboat spgs (sbs), CO, with stops at sioux city & cheyenne (cys). At 2245, he contacted denver fss, stated he was on final apch to sbs & said the rwy lgts had gone out. He then asked for the freqfor 'putting them…NTSB DCA87MA046Accident · 156 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-82 · Romulus, MIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/05. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…NTSB BFO87FA056Accident · 2 fatalField investigationFinal reportCessna 190 · Hedgesville, WVThere were no eyewitnesses to the acdnt, but 3 persons heard the eng rev up to a high power setting before the plane crashed. Subsequently, it crashed in a wooded area north of the plt's 2600' pvt strip. There was a wooded hill north of the strip. The plt's…NTSB DEN87FA218Accident · 2 fatalField investigationFinal reportCessna 172C · Switz City, INAfter departing the bloomfield arpt, the plt flew with his family over a coal mine area where he had done reclamation work. Witnesses at the mine stated that they observed the acft fly low over the mine pits & that the plt waved at them. The acft departed,…NTSB ATL87FA230Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Offerman, GADuring a local flt the acft was observed flying at a level attitude approx 10 ft above a corn field at high speed. The right wing of the acft struck tree branches approx 60 ft AGL during a pull up. A 6 ft section of the right wing separated. The acft climbed,…NTSB LAX87DVA11Accident · 1 fatalFinal reportRockwell S-2R · Mendota, CAThe ground flagman reported the pilot had just completed spraying the bean field. The pilot was in the process of doing a touch-up application when he flew under the power lines. The airplane right wing contacted the lowest of the 4 powerlines, rolled…NTSB LAX87DUJ09Accident · No injuriesFinal reportPiper PA-25-235 · San Simon, AZDuring a pull up from an aerial application swath run, the aircraft struck a power line. The accident occurred during daylight in visual meteorological conditions.NTSB FTW87LA194Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Eugene IslandThe acft experienced a main rotor blade strike during takeoff from an offshore platform. The rotor blade struck the underside of a cable raceway on a drilling rig that was situated adjacent to the platform helideck. The raceway was 9 feet laterally and 22…NTSB BFO87LA051Accident · Minor injuriesLimited investigationFinal reportMaule M-4-210C · Burnt Chimney, VAThe plt attempted to land on a 1400 ft grass airstrip. The plt later stated that during the lndg roll the passg alerted him to the fact that they would not stop on the rwy. This caused the plt to start a go-around followed by a 2nd attempt to stop. The plt…NTSB MKC87FA159Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Maquoketa, IAAfter departing the Maquoketa muni arpt, the acft was observed to fly at low altitude over some buildings that included a house & trailer home. As the acft flew over the property in a left banking turn, the left wing struck the top of a tree & then the acft…NTSB ANC87LA114Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Central, AKDuring an interview in the hospital with the passenger who was the pilot's son, he stated to the FAA inspector that his dad was low level flying when the aircraft struck a tree. The pilot lost control of the aircraft and crashed. At the time of the accident…NTSB SEA87LA154Accident · No injuriesLimited investigationFinal reportCessna 150M · Austin, NVThe plt was flying up a canyon when he realized the canyon was closing & he had no way of turning around. He was unable to outclimb rising terrain. Subsequently, the acft crashed into several small pine trees & was extensively damaged. The density alt at the…NTSB BFO87FA050Accident · Minor injuriesField investigationFinal reportCessna 172P · Whitemarsh, MDThe pilot stated that he touched down near the end of the 22OO foot runway. However, witnesses said he landed so FAR down the runway that they did not believe he could stop on the runway. The pilot delayed his go around attempt to the point where it was not…NTSB DEN87FA203Accident · 1 fatalField investigationFinal reportCessna A188B · Kalispell, MTA Cessna ag wagon, N731SH, hit an electrical pwr line during a climbing turn while crop spraying. The acft was observed plummeting to the ground. The acft was substantially damaged and the plt received fatal injuries. The plt was climbing into the sun which…NTSB BFO87DIG08Accident · Minor injuriesFinal reportPiper PA-28 · Mitchellville, MDDuring takeoff, the acft hit the tops of trees near the departure end of the rwy. The plt stated that after clipping the treetops, he knew the acft was 'going in,' so he pulled the yoke back to slow it as much as possible. Also, the plt stated that during…NTSB DEN87LA204Accident · No injuriesLimited investigationFinal reportBell 47J-2 · Canon City, COThe ATP plt was flying sightseeing rides. There were two adults and two children in the four passenger helicopter. Density altitude was 10000 feet. The acft lost pwr and the plt aborted takeoff and landed. After an eng runup the plt took off again and the…NTSB DEN87LA193Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Pisek, NDThe plt was preparing to spray a potato field with a mixture of water and 2 lbs of 'blight-out.' He made one observation pass over the field to check for obstructions and noticed two sets of power lines, one on the east side of a road and the other on the…NTSB FTW87FA174Accident · 1 fatalField investigationFinal reportCessna 421C · Crystal City, TXThe pilot landed downwind on his private strip. The exact amount of the tailwind could not be determined. A thunderstorm was located just to the east of the runway and could have readily given N448 a strong tailwind. The aircraft touched down 390 feet beyond…NTSB BFO87LA049Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Gordonsville, VAThe plt began taking off from a downward sloping, 2300 ft rwy in light winds. The rprtd temp was 92 deg; the density alt was about 2500 ft. the plt rprtd the acft accelerated normally to V1 speed; however, it hit the tops of trees about 350 to 500 ft beyond…NTSB FTW87DRG04Accident · Minor injuriesFinal reportAir Tractor AT301 · Santa Rosa, TXThe pilot was dusting a sugar cane field which bordered a dirt road with parallel electrical transmission lines. The pilot had been terminating his swath runs by flying underneath the electrical wires at the edge of the field. To prevent becoming a hazard to…NTSB DEN87LA190Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Fargo, NDThe plt was spraying a field with orthine, used to exterminate grasshoppers. The plt said he was making his last pass at the field and was flying into a setting sun. He said he did not see the powerline. The acft struck the powerline and the plt made a crash…NTSB MKC87DCA02Accident · Serious injuriesFinal reportRotorway Exec · Highridge, MOThe plt said the helicopter enctrd hi density altitude problems as it was moving out of ground effect drg takeoff. Subsequently, the helicopter settled into trees, then crashed to the ground in an inverted attitude. The temp & dew point were 90 & 77 deg,…NTSB LAX87LA272Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Perris, CAThe tow plt rprtd that drg takeoff, he felt the glider release at about 200' AGL. The purpose of the release was to practice a rope break. After being released, the glider maneuvered back toward the arpt, but it hit a tree & a power line before reaching the…NTSB MIA87LA206Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Hastings, FLThe plt stated that he had just lifted from the 2300 ft wet grass strip, where he estimated the grass to be about 6 in to 1 ft high, when he sustained a partial power loss. The acft struck an embankment at the end of the rwy & sheared the gear. Air temp in…NTSB LAX87LA287Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103A · Maricopa, AZThe plt rprtd that after gliding in a sink for svrl minutes, he began flying about 500' above a north-south mtn ridge in search of lift. While on a northerly heading, the left wing rose & the plt interpreted this as lift. He turned to the left (west) which…NTSB SEA87FA135Accident · 2 fatalField investigationFinal reportMaule M-4-210C · Sitka, AKPlt was on local VFR flight plan. Witnesses observed acft flying at low level along beaches. Later, witness saw smoke rising from wooded terrain about two miles inland from nearest beach. Investigation revealed no evidence of inflight failure of malfunction…NTSB FTW87DRA05Accident · No injuriesFinal reportCessna A188B · El Campo, TXWhile attempting to land, the aircraft's left wing contacted the edge of a corn field. The aircraft veered to the left and impacted the ground causing substantial damage.NTSB ATL87LA207Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Crestwood, KYThe balloon contacted power lines as it was beginning to climb after an aborted ldg attempt. Electrical arcing ignited the propane fuel supply on board. The sole-occupant student plt jumped from the burning balloon and fell approx 40 ft onto a fence. The…NTSB ATL87DEI08Accident · Minor injuriesFinal reportGrumman G-164A · Bucyrus, OHAs the plt was apchg a field to spread fertilizer, the acft collided with a tree & crashed to the ground. The plt received a head injury & said he could not recall the acdnt. According to hospital records, he was suffering from pneumonia & had a 101 deg temp…NTSB MIA87LA201Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Naples, FLThe plt stated that his aprch speed was too fast & he touched down about half way down the 3400 ft rwy. Believing that he would not get stopped during the ldg roll, he attempted to go around, but the gear struck a fence near the end of the rwy & dragged the…NTSB LAX87LA258Accident · No injuriesLimited investigationFinal reportCessna 172 · Hawthorne, CADrg an apch to rwy 25, the acft collided with the omni directional apch lighting system (odals). The plt indcd that she enctrd a downdraft on short final & applied full power; however, the acft contd to dscnd & struck one of the odals light cover lenses with…NTSB LAX87IA260Incident · No injuriesIncident investigationFinal reportMBB BK117A-3 · Cupertino, CAA Mbb BK117A-3 helicopter collided with wires while on final approach to an asphalt road in close proximity to a traffic accident. Night VMC prevailed at the time. The pilot indicated that he did not see the wires and was unaware of the collision until he was…NTSB NYC87LA197Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Scoodic Lake, METhe plt of the float equipped acft was taking off from Scoodic Lake. Drg the initial climb phase after takeoff, he noted the acft began to lose altitude & would not clear trees on a ridge ahead. He initiated a turn back toward the lake; however, the acft…NTSB NYC87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Roseville, PAWitnesses rprtd the acft flew over a pvt strip at low alt, then it began climbing over rising, wooded terrain. Subsequently, the acft would not outclimb the terrain & it crashed into the treetops. No preimpact mechanical problem was found.NTSB NYC87LA195Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Jamestown, NYThe student plt rented the acft & flew to a field aprx 40 mi from the dep arpt. After landing, a passenger boarded the acft. The student started to takeoff again. Drg takeoff, the acft lifted off, but would not climb sufficiently to clear trees at the dep end…NTSB DEN87LA172Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Pagosa Springs, COThe commercial plt and a friend departed aztec, new Mexico, with the intention of flying over wolf creek pass en route to Colorado Springs, Colorado. He said the acft would not climb over the pass and the acft collided with trees in mountainous terrain. The…NTSB ATL87LA200Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Greenville, SCBalloon dtpted launch site about six miles sw of landing airport for a key grab during a Balloon ralley. Wind was about seven KTS according to PIC. Approaching field to land basket was dragged through tree tops to slow Balloon. Power line hidden by the trees…NTSB LAX87LA255Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · Benson, AZA Bell helicopter 206L-3 collided with wires while maneuvering over an underground telephone cable. The plt indicated that he had just completed a 360 deg right turn at the request of the pax and was aprx 185 deg through the second turn when he struck a…NTSB DEN87LA161Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cayuga, NDThe plt was completing a swath run and struck a power line with the right wing, severing the wing. The aircraft did a snap roll to the right and impacted in a field.