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 NYC84LA212Accident · No injuriesLimited investigationFinal reportHiller 12E · Meadville, PAThe acft flew into wires during a crop spraying mission. The acft was flying at about 5-10 ft when a flash was seen overhead. The acft vibrated and slowed before impacting the ground and rolling over.NTSB FTW84LA274Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · San Benito, TXAt the beginning of the initial swath run the acft collided with power lines. The power lines remained attached to the acft throughout the uncontrolled descent into a cotton field.NTSB DEN84LA180Accident · No injuriesLimited investigationFinal reportRockwell Callair A-9B · Circleville, UTAfter spraying several fields, the plt looked down to check a map during which time a loss of altitude occurred. The acft collided with a barbed wire fence. One of the main gear was damaged & the barbed wire became entangled in the propeller. During a forced…NTSB CHI84LA238Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Leroy, WIThe acft collided with trees while turning during an aerial application mission. The plt said that the acft started losing altitude in the turn and despite application of full power it continued to settle until trees were hit. The plt reported that during…NTSB SEA84LA132Accident · No injuriesLimited investigationFinal reportBell 47G2A · Buena, WAMain rotor blades contacted a wind machine during an aerial application flt. Helicopter settled into trees and rolled over. Plt said he knew the machine was there but had forgotten.NTSB CHI84LA237Accident · No injuriesLimited investigationFinal reportHughes 269C · Boyd, MNWhile beginning a gradual pull-up at the end of a spray run, the plt was distracted by a person in a ditch & did not see the wire at the end of the field. The wire contacted the tail rotor & the helicopter began to spin. The plt reduced power & was able to…NTSB CHI84LA232Accident · Minor injuriesLimited investigationFinal reportBell 47G · Fairfax, MNThe helicopter plt turned at the end of a spray run & the acft collided with a power line. He said that because of a quartering tailwind, the helicopter was in a nose high attitude & the tail rotor hit a wire. The plt was able to make an autorotation after…NTSB ATL84LA199Accident · 1 fatalLimited investigationFinal reportCessna A188B · Hollandale, MSTwo acft were spraying same field. A farm hand was used as flagger to mark last crop row sprayed. Flagger used for last two seasons and briefed previously on flagging operations by the pilot/farm owner. Flagger was not briefed where to begin counting crop…NTSB CHI84LA230Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Center Village, OHThe plt stated that during the takeoff, the acft prematurely became airborne, then settled back onto the rwy & lifted off again. During the second lift-off, he raised the left w ing. Subsequently, the left x-wind blew the acft into a tree line beside the rwy.NTSB ATL84LA198Accident · No injuriesLimited investigationFinal reportBell 222 · Salem, VAThe helicopter was flown to the site of an auto accident to transport an injured person. After landing, the patient was loaded without shutting down the eng. Due to the position of power lines, the aircrew had to depart in the opposite direction. While…NTSB CHI84LU005Accident · Serious injuriesFinal reportLycan Nomad II · Harrisburg, OHAccording to witnesses, the plt was on an apch to land in a field near his home when the ultralight vehicle's tailwheel caught onto a power line. The ultralight then crashed nose 1st into the terrain.NTSB MKC84LA166Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Pocahontas, ARThe plt said he was making a cleanup swath & encountered spray from the previous swath run. The spray contains a dye which covered the windshield & obscured the plt's vision. The plt said he pulled up at the end of the field but failed to clear the trees.…NTSB FTW84LA269Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · San Antonio, TXAcft struck a marked transmission line on final apch. Plt could not maintain full control of acft on landing. Acft touched down rt wing low and a go-around was initiated. Upon application of pwr, acft went into trees off rt side of airstrip. Both plts stated…NTSB DEN84FA172Accident · 2 fatalField investigationFinal reportCessna 182K · Cascade, COThe purpose of the flt was to qualify one of the plts to fly search missions over mountainous terrain. Such flts included maneuvering at low alt, but not below 500 ft AGL. During the flt, the acft crashed on the nortwest side of pikes peak at an elevation of…NTSB ANC84LA086Accident · No injuriesLimited investigationFinal reportDouglas C-118A · Deadhorse, AKThe acft struck a non-directional radio beacon tower while on an ILS DME rwy 05 instrument approach to the kuparak oil field airport. Investigation revealed that wx issued to the acft included an indefinate 200 ft sky obscured condition & visibility of 1 1/4…NTSB LAX84FA337Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Barstow, CAThe flt had originated somewhere in Mexico & was being tracked by dea investigators until radar contact was lost. In the vicinity of amboy, CA an anonymous caller had contacted the highway patrol & reported a low flying acft near amboy with no visible…NTSB NYC84FNC03Accident · Serious injuriesFinal reportPiper PA-28-140 · Hampton, NHPurpose of flt was to obtain actual experience in short/soft field operations. Takeoff was initiated on a runway that was not only short and soft, but uphill and with a 70 degree left crosswind. Under these conditions, acft performance was inadequate to clear…NTSB SEA84FA123Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · North Bend, ORThe acft was cleared for an ILS rwy 4 apch while 9 miles north of oth (North Bend) VOR. Instructions were given to cross oth VOR at or above 3700 ft MSL. 14 min later, the plt reported to North Bend fss 'my needle doesn't seem to be moving on my localizer…NTSB MKC84LA158Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Ellinwood, KSWhile the plt was spraying a field of soybeans, the right main gear of the acft hit an irrigation sys that he had been crossing. The right main gear was torn off, but the acft continued to fly. During the landing on a sod arpt, the prop dug in & the acft…NTSB FTW84FA264Accident · 2 fatalField investigationFinal reportCessna A185F · Houma, LAPlt was returning to home base of operations, executing standard visual approach along intercoastal waterway on westerly base heading prior to turn on final. Acft collided with overhead ground wires of power transmission array spanning the waterway at an…NTSB LAX84LA329Accident · Minor injuriesLimited investigationFinal reportBell 206 · Allegheny, CAThe plt was delivering supplies from a mountain site to a river work site. He stated that on his 10th & last flt, the wind caused the helicopter & external load combination to shift laterally. At that time, the load/line became entangled in a tree. The…NTSB FTW84LA263Accident · 1 fatalLimited investigationFinal reportRockwell A-9B · Maringouin, LAThe plt was completing the first swath pass attempting to fly under a power line and between a tree and parked farm equipment. In a slight left turn under the power line, the right wing contacted tree tops aprx 30 ft AGL. The acft continued aprx 150 yards…NTSB FTW84LA257Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Ripley, OKAcft contacted three unmarked transmission power lines which crossed the cimarron river. The plt was flying over the river trying to locate a field which was to be sprayed. The acft then crashed on nearby river bed.NTSB FTW84LA256Accident · 1 fatalLimited investigationFinal reportPiper PA-36-375 · Hominy, OKThe acft collided with a radio tower guy wire while the plt was en route to reload. During the collision, the right wing was sheared off & the acft crashed to the ground & burned. The radio tower was located about 1 mi from the arpt.NTSB DEN84FA161Accident · 1 fatalField investigationFinal reportLet L-13 · Edgewood, NMWitnesses reported that the acft appeared to be too high, too fast, and in a crab as it approached the rwy. Over the rwy the glider was observed to roll into a right turn as the nose came up. Shortly thereafter the right wing struck 3 parked acft and collided…NTSB DEN84LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bountiful, UTThe aircraft was on short final during instructional landing practice. A truck loaded with a backhoe was crossing the end of the runway from left to right on a public access road which displayed no caution or warning signs regarding aircraft operations.…NTSB ATL84FA183Accident · Serious injuriesField investigationFinal reportCessna 152 · Piedmont, ALThe plt reported that prior to flying, he had 2 mixed drinks which contained alcoholic beverage. The flt originated at talledega, AL. The plt then flew to anniston, AL, where he landed. From there he flew to jacksonville & centre, where he made touch-&-go…NTSB ANC84LA076Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Nunavachak, AKThe plt of a Piper PA-32, N4143W, was taking off toward the west-northwest on a tidal beach at the same time that another plt was taxiing west onto the beach. The other plt was taxiing a high wing, Bellanca 7GCBC, N2677Z. The Bellanca was angling down onto…NTSB NYC84LA181Accident · No injuriesLimited investigationFinal reportCessna 177B · Spring Valley, NYSufficient alt was not obtained to clear trees located aprx 100 ft off the departure end of the rwy during an aborted landing to avoid an overrun.NTSB LAX84LA303Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Avalon, CAThe plt flew to catalina island, then flew northwest along the north side of the island. He stated that he then made a climbing left turn over the island from about 500 ft MSL, but encountered a downdraft at 1000 ft MSL, which slowed the acft below the…NTSB DEN84FU005Accident · 1 fatalFinal reportEipper Quicksilver MX · Peyton, COThe ultralight was flying in formation with 2 other craft. The accident plt was seen by one of the other two plts to descend to a low alt over a creek bed and then pull up abrultly to climb over a power line. The landing gear collided with the wires and the…NTSB NYC84LA177Accident · Minor injuriesLimited investigationFinal reportCessna 152 · West Milford, NJThe plt stated that during the initial climb of a max performance takeoff the best angle rate of climb could not be maintained. The acft contacted trees and subsequently crashed in an abandoned parking lot.NTSB FTW84LA240Accident · No injuriesLimited investigationFinal reportRockwell S2R · Alexandria, LAThe acft collided with a static wire between two electrical poles while maneuvering during aerial application. Control was maintained and the acft returned to the airport and landed without futher incident.NTSB FTW84LA233Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Colcord, OKThe flight departed downwind from an unimproved field to avoid power lines at the upwind end of the field. During the takeoff roll sufficient speed could not be attained to lift off and clear a fence at the departure end of the runway. The pilot attempted to…NTSB ANC84FA067Accident · No injuriesField investigationFinal reportBell 206B · Palmer, AKThe helicopter was being used to re-supply fire fighters by the division of forestry. En route back to the staging area the acft struck unmarked lines 85 ft above the valley floor. Poles supporting the lines were obscured by vegetation and were 224 ft apart.…NTSB NYC84LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Montrose, PAPilot attempted to land on a 2200 foot grass runway. The plt overshot the runway and attempted to go-around. The aircraft collided with trees at the end of the runway.NTSB FTW84LA228Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bay City, TXWhile spraying a field with propanel & modown grass killers, the plt was crossing below a high tension power line. The vertical stabilizer contacted the lowest wire which tore loose the vertical stabilizer. The acft pitched nose up, then it dove down, crashed…NTSB NYC84FA163Accident · 2 fatalField investigationFinal reportCessna 310K · New Cumberland, PAThe plt departed VFR without a formal wx briefing or filing a flt plan. The wx at dest was VFR when the plt departed. The forecast indicated that ceilings would lower. The wx did, in fact, deteriorate while the flt was enroute and the plt obtained an IFR…NTSB FTW84LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Allen, OKThe pilot stated that he could not climb enough to clear the trees at the end of the airport. The left wing hit a tree then the right wing hit a pwr line and utility pole. The acft then crashed into the ground. The plt had about 400 hours in this make and…NTSB FTW84LA221Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Putnam, OKThe acft bounced during landing and the plt attempted to abort the landing. A truck was parked near the end of the field. The acft collided with the truck which it failed to clear in an attempt to fly over it. There were no reported malfunctions of equipment.NTSB ATL84FA158Accident · Serious injuriesField investigationFinal reportBell 206B · Trammel, VAThe acft collided with static wires attached to an electrical transmission line while cruising at low alt, crashed and burned near hwy 63. The plt was thrown from the acft before it burned. The plt said he never saw the wire he hit. He had been employed as a…NTSB NYC84LA153Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Clinton, MDThe main rwy at the arpt was closed due to resurfacing. The plt was attempting a landing on rwy 31 knowing it would be a deliberate downwind landing. According to the operator of the arpt, plts were discouraged from using rwy 13 because the traffic directly…NTSB ATL84FA150Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Suffolk, VADuring the initial takeoff climb the acft contacted power lines located 584 ft from the end of the rwy. This was an initial test flt of the acft after having the engine overhauled. The plt stated at an alt of aprx 50 ft AGL the engine began to lose power and…NTSB DEN84LA134Accident · No injuriesLimited investigationFinal reportHelio H-295 · Dulce, NMThe plt was crossing a mountain ridge at 250 feet when a downdraft was encountered on the downwind side of the ridge. The plt then banked and returned to the upwind slope but still was unable to maintain altitude. The acft collided with trees and stabilizer…NTSB ATL84MA148Accident · 6 fatalMajor investigationFinal reportPiper PA-34-220T · Mt Airy, GADrg arrival, the plt reqd & rcvd clnc to fly drct to the unctld arpt, altho the arpt had no terminal nav fac & the acft had no RNAV type equip. Nrby at athens, the 0745 spl wx OBS was in part: indef cig, sky obscd, vsby 1/4 mi with fog. At 0801, atl ctr clrd…NTSB NYC84LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Westerly, RIOn final approach to runway 32, the aircraft contacted trees located approximately 600 yard short of the approach end of the runway. The passenger stated after the accident that as the aircraft approached the runway, he noticed the acft was 'a bit too close…NTSB FTW84LA208Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Mullin, TXThe acft was observed by witnesses to have been flying very low, paralleling highway 84. A set of railroad tracks parallel the highway. Between the rr tracks and hwy is a power line. The witnesses saw the left wing contact the pwr line and the acft roll to…NTSB SEA84LA087Accident · Minor injuriesLimited investigationFinal reportPZL-Mielec PZL-M-18 · Rockford, WAThe plt said the acft was a 'little heavier' than it should have been. The acft bounced settled after takeoff and the right wing hit a fence post. The collision jammed the right aileron down and the acft became uncontrollable and crashed.NTSB FTW84LA198Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Monterey, LAThe plt landed at an improved private strip. Later, he took off in winds that he reported were down the rwy at 12 KTS gusting to 14 KTS. After lift-off the acft 'climbed normally' & cleared a power line as well as low trees at the end of the strip. However,…NTSB DEN84FU003Accident · Serious injuriesFinal reportAmerican Falcon · Salt Lake City, UTReportedly, the plt made an apch to rwy 18, then initiated a go-around due to traffic on the rwy. He reported that traffic to the left necessitated a right pattern. There were power lines located aprx 500 ft west of the grass strip, about 40 to 50 ft AGL.…