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 MKC84LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Arapahoe, NEWhile on a swath run to apply insecticide, the acft collided with electrical transmission lines that were crossing the field. After the initial impact, the acft angled to the left & hit another transmission line, then impacted the ground.NTSB LAX84LA417Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Delhi, CAThe plt took off so early it was described by a witness as still being dark. The elevation of the accident was higher than the takeoff point. The operator said the plt tended to be easy on the equipment and throttled back shortly after takeoff. He stated that…NTSB CHI84FA315Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Sandwich, ILPilot attempted to takeoff with 7 passengers in a six place acft. The acft was 187 lbs over gross wt and 1.54 inches out of aft c.g. the pilot tookoff downwind and collided with trees at the end of the rwy. There was a post crash fire.NTSB MIA84LA212Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Panama City, FLThe plt had experienced an eng failure due to fuel exhaustion & had safely executed a forced landing on a 1,100 ft road in front of condominiums. After having fuel brought from a local arpt, he attempted a takeoff. After lift-off, at an altitude of about 6…NTSB MKC84LA230Accident · No injuriesLimited investigationFinal reportMooney M20C · Hannibal, MON7702M experienced an electrical failure en route & diverted to Hannibal. Plt stated he circled the arpt, saw no traffic& decided to land to the south. N38455 had just landed to the north and was on the rwy when the plt saw N7702M attempting to land in the…NTSB FTW84FA321Accident · 2 fatalField investigationFinal reportBell 206B · Dallas, TXWitnesses observed the helicopter circling a 523 ft, free standing, communications tower. After circling several times, helicopter passed close to the tower & a main rotor blade struck it at the 451 ft level. The outboard portion of the rotor blade separated…NTSB LAX84LA411Accident · No injuriesLimited investigationFinal reportAeronca 60-TF · Gorman, CAAccording to the plt a 90 degree crosswind caused a loss of directional control shortly after takeoff. The empennage contacted a fence and trees off the left side of the rwy.NTSB NYC84LA253Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Seboomook Lake, METhe acft was on final for a water landing when a bird hit the windscreen according to the plts statement. A witness who observed a dark object (thought to be a cormorant, since several were seen in the area before & after the accident) saidthe object floated…NTSB MKC84LA227Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Troy, KSShortly after takeoff the acft collided with wires and crashed. The plt had tried to fly under the wires because the acft would not climb over them. Investigation revealed that the acft was overloaded and out of balance by having 2 minorpassengers in the…NTSB FTW84LA316Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · High Isl Blk298The helicopter skid contacted a net fence around the landing platform on an oil rig. The safety net broke and the acft rocked over the side of the platform. The plt attempted to autorotate into the water. The landing was hard and one floatseparated. The…NTSB ATL84LA234Accident · No injuriesLimited investigationFinal reportBeech V35B · Marion, NCThe acft collided with light gauge power lines which broke but acft control was not lost. The plt and a passenger were flying low over a lake looking for another friend who was skiing there. The flt was proceeding at about 25 ft AGL when the wires were…NTSB ATL84LA231Accident · No injuriesLimited investigationFinal reportBeech C23 · Gainesboro, TNThe acft collided with a static wire while flying along a river. The collision occurred at 350 ft AGL about 5 miles NE of the arpt. The left wing hit the wire which cut into the wing and penetrated a fuel cell. Fuel escaped from this cell and when the acft…NTSB MKC84LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Pollard, ARThe plt stated that he was spot spraying a bean field and was aware of the location of the electrical transmission line. As he attempted to maneuver the acft under the line, a wing made contact with the line and the acft inpacted the ground.NTSB MKC84FCD01Accident · Serious injuriesFinal reportCessna A188B · Hesper, IAThe acft crashed after colliding with a power line. During the first spray pass the plt attempted to fly under the power line. The veritcal fin hit the wire and the acft crashed. There were no mechanical problems with the acft during this aerial application…NTSB LAX84LA399Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Folsom, CAThe acft was observed flying down a river at a low altitude toward the main body of a lake. The acft impacted a 12 kv power line. The plt stated that he did not see the wires until an instant before impact.NTSB MKC84FA218Accident · 1 fatalField investigationFinal reportEagle DW1 · Kimball, NEThe acft collided with a microwave tower 158 ft AGL while the plt was making a smoke trail to test the wind. As the plt was seen to look back along his smoke path, the acft collided with the tower. The cables supporting the twr & the twr destroyed the acft…NTSB CHI84LA299Accident · No injuriesLimited investigationFinal reportCessna 172 · Alpena, MIThe plt stated that while flaring for their 5th stop-&-go at night, a deer ran out onto the rwy. The acft collided with the deer & the left main landing gear was sheared off. The acft then veered off the rwy.NTSB NYC84FFJ03Accident · Serious injuriesFinal reportRaven S55A · Lakeville, NYWitnesses stated that as the balloon approached a field for landing, in dim light, it became apparent that the gondola was going to hit power lines. The wooden gondola hit the top wire and the plt jumped approximately 33 ft to the ground sustaining serious…NTSB MKC84LA215Accident · No injuriesLimited investigationFinal reportCessna 172H · Marvell, ARThe acft collided with telephone lines as the plt was making a low pass over the passengers place of business. The plt said he did not know the lines were there when his passenger asked for the low pass. The acft stalled and contacted the ground on the…NTSB CHI84LA297Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · North Liberty, INThe plt had changed departure runway due to shifting winds of 10-15 KTS, electing rwy 18 when wind seemed favorable. On initial climb, aircraft performance was insufficient to clear trees at end of runway. Acft came to rest in trees. Acft manual specifies…NTSB CHI84LA300Accident · No injuriesLimited investigationFinal reportCessna 177 · Columbia, ILPilot stated that she landed the aircraft approximately one third of the way down the runway. She continued to stated the acft ballooned so she decided to go-around, during which she retracted the flaps to 1/4. The pilot operating handbook states that the…NTSB ATL84LU007Accident · Serious injuriesFinal reportTeraton TA · Snellville, GAAfter making a touch & go landing, the plt was unable to climb over trees at the departure end of the rwy. Subsequently, the ultralight vehicle lodged in a tree about 40 to 50 ft AGL. The plt said that he was not injured during the impact with the tree.…NTSB DEN84LU008Accident · Serious injuriesFinal reportWeedhopper Unknown · Spanish Fork, UTThe ultralight was taking off from a street with obstructions on either side. The plt said that during the climbout, he encountered a x-wind from the north which blew him into a lamp post. The vehicle and pole were damaged and the vehicle crashed to the…NTSB DEN84FA219Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Peetz, COPlt had completed spraying around farm buildings for insect control. On first pass in crop area, the acft was observed to pull up over pwr lines at end of swath run but collided with overhead ground wire at top of multi- wire array. Acft then collided with…NTSB MKC84LA212Accident · No injuriesLimited investigationFinal reportCessna 172 · Beuamont, KSThe plt was taking off to the north on a sod rwy with a light, northeast wind. The rwy was outlined with old automobile tires. The plt elected to use the left side of the rwy, since it appeared to be smoother. After lift-off, the acft drifted left & the left…NTSB NYC84LA237Accident · No injuriesLimited investigationFinal reportSchleicher ASW-15 · Fairfield, PAThe glider was landed off arpt during a return from a round robin flt after experiencing a high sink rate. During the landing approach power lines hidden in a tree line were not cleared and the collision caused the acft to yaw about 45 degrees. The acft…NTSB DEN84LU007Accident · 1 fatalFinal reportEipper Quicksilver MXL · Granby, COReportedly, the plt was flying at low altitude over a lake & had to pull up to cross over a dam. After crossing the dam, he began to descend, but the ultralight vehicle collided with power lines on the down river side of the dam. The power lines were about…NTSB DEN84LA212Accident · No injuriesLimited investigationFinal reportCessna 172 · Minnewaukan, NDThe pilot of this aircraft overflew his intended landing site, a gravel road, in an attempt to observe any power lines or other obstructions that might be in his way. He did not see anything that would prevent a safe landing. While turning to make the actual…NTSB ATL84LA217Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Glen Allen, MSThe plt stated that while doing aerial applications and flying into the sun he failed to see a tree and collided with it. The pilot was not wearing sunglasses nor was the aircraft equipped with sun shading devices.NTSB NYC84LA232Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ellington, CTAfter being directed to do so by the arpt mgr the pilot was air taxiing to parking when the main rotor blades contacted one main rotor blade of a parked bell 206. The pilot related that he assumed he would clear the 206 since he was watching the airport mgr…NTSB MKC84FA197Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Wright, ARDuring aerial application, the plt was making a left turn over high voltage power lines when the acft hit the cables, crashed & burned in a rice field. An exam revealed 2 wire marks & 2 electrical arc marks on the left wing along with wire marks on one of the…NTSB MIA84LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Port St. Joe, FLWhile on final apch to land at a private arpt, the acft collided with power lines near the apch end of the rwy. The plt stated that he did not see the power lines until just prior to impact. He attempted to fly under the lines, but the vertical stabilizer of…NTSB LAX84LA380Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · El Mirage, AZThe plt was practicing takeoffs & landings with about 800 lbs of water on board. After turning downwind for his second landing, he experienced a loss of airspeed & the acft started to sink into power lines. He released the emergency dump gate, at which time,…NTSB LAX84LA379Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Stanfield, AZThe plt was maneuvering to start another field when the acft's left wing hit the roof of the ground flagging vehicle. The acft then collided with the ground.NTSB LAX84LA377Accident · No injuriesLimited investigationFinal reportCessna 177 · Lancaster, CAThe acft struck trees during a go-around from a simulated forced landing to a dirt road. The instructor plt stated that the acft would not climb as rapidly as it should, perhaps due to the density alt. The density alt was aprx 6000 ft.NTSB CHI84LA276Accident · No injuriesLimited investigationFinal reportCessna 150G · Williamston, MISome cows ran into the path of the acft during takeoff. The plt turned as soon as airborne to avoid the animals and had to turn again to avoid powerlines. In this maneuvering the acfts left wing hit a tree and the acft cartwheeled.NTSB FTW84LA313Accident · No injuriesLimited investigationFinal reportCessna 182M · Georgetown, TXWhile on a x-country flight the acft experienced a bird strike. The plt elected to return to the departure airfield for a precautionary landing. She made two hard landings on the first approach and then recovered and made a go-around. On the next approach she…NTSB CHI84LA266Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Lake Benton, MNWhile on an aerial application flt, the plt was crossing under a power line when a wire caught the rudder & separated itfrom the acft. During a landing, the left wing contacted the ground 1st.NTSB ANC84LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Ekuk, AKThe acft collided with a water pipe about 6 ft AGL during takeoff. Witnesses said that the plt did not use all availablerwy. Witnesses also said that he drifted off the rwy centerline after a premature takeoff. The plts employer said that he had warned him at…NTSB LAX84FA367Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Weaverville, CAWhen the plt filed a VFR flt plan, he stated that he was aware that the arpt at Weaverville, CA, was a one way strip & that he had a guide book which showed this info. Published procedures called for acft to 'land on rwy 36, take-off rwy 18.' A caution note…NTSB CHI84LA263Accident · Minor injuriesLimited investigationFinal reportHiller UH 12 D · Deerfield, WIPlt was aware of pwr lines which crossed the field over which he was performing a calibration test. Plt stated that because of sun glare visual contact with the wires was lost. The acft contacted the wires.NTSB FTW84LA285Accident · No injuriesLimited investigationFinal reportCessna T210N · Monahans, TXThe plt made several unsuccessfull downwind landing attempts. The last attempt was long & fast & upon go around, the acft struck the arpt boundry fence & came to rest 700 ft past the departure end of the rwy.NTSB ATL84LA209Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Williamsport, TNPilot stated that while departing from a small 2000 foot long private strip the engine appeared to loose power. The aircraft would not climb and collided with a tree at the departure ens of the rwy. The acft then collided with several other trees prior to…NTSB MKC84LA181Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Campbell, MOPIC was making a clean up swath run after spraying a field and failed to avoid a high voltage power line. After strikingthe line the acft impacted the ground, caught fire and burned.NTSB ANC84LA104Accident · No injuriesLimited investigationFinal reportRaven S-55A · Anchorage, AKWhile apchg to land on a school ground, the balloon plt lowered a drop line for the ground crew, then looked forward & saw a power line. He told the ground crew not to touch the drop line. The drop line contacted & pulled one power line into another, causing…NTSB SEA84FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Burley, WAThe non-rated plt was employed as an acft cleaner & had access to the ignition keys of several acft, including N6950J. Earlier during the evening, he was seen consuming beer. At about 0024 PDT, he took off from rwy 18. About 1 min later, the acft collided…NTSB ANC84LA096Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Rainbow Lake, AKThe plt stated that the acft 'was sluggish getting on the step. After lift-off it still performed under par. We cleared the hills and trees. On the downside of the hill we hit a downdraft. We hit the trees nose high; climb power.' The reported wind was calm.…NTSB MKC84LA176Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-375 · Storm Lake, IAWhile on the 2nd swath run, the plt maneuvered the acft to cross under power lines bordering the edge of the corn field. He said he misjudged the distance to clear the power lines. The vertical stabilizer & rudder struck the lines & were torn from the acft.…NTSB DEN84LA186Accident · 1 fatalLimited investigationFinal reportCessna 188 · Groton, SDDuring aerial application flight, the aircraft passed beneath two power lines. The top of the vertical fin and collision avoidance beacon light apparently made contact with the first wire, as they were found separated near that location. After contact, the…NTSB CHI84LA243Accident · Minor injuriesLimited investigationFinal reportCessna 152 · South Webster, OHThe plt selected a farm field with obstructions at each end to practice short field takeoffs and landings. He had previously walked the field to check for obstacles and to get the owners permission. He said that during his approach toland everything seemed…