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 LAX85FA262Accident · 2 fatalField investigationFinal reportCessna TU-206E · San Manuel, AZThis plt was attempting to air drop illegal drugs to someone on the ground. While executing an intentional low pass, at dusk, theacft inadvertently collided with a cactus tree & crashed.NTSB MIA85FA180Accident · 3 fatalField investigationFinal reportPiper PA-34 · Loxahatchee, FLThe plt & passengers were seen drinking beer in a bar prior to the flt. After the acft took off, witnesses observed it flying very low near a shoreline; one of them was a police officer that identified the acft by its registration number. At aprx 1930, the…NTSB SEA85FA124Accident · 3 fatalField investigationFinal reportCessna 177 · Selma, ORThe acft was on a cap search mission with a plt & 2 observers on board. While searching, the plt was flying relatively low & slow over wooded, mountainous terrain. A witness observed the acft enter a bowl or box canyon type area at or below his eye level. The…NTSB BFO85FA048Accident · 5 fatalField investigationFinal reportRockwell 112B · Woodbridge, VAOn may 26,1985,at approximately 1240 hrs EDT,a Rockwell international commander 1120,N1417J,collided with trees aft tkof fm Woodbridge arpt in Woodbridge,VA. The acft was destroyed drng the post impact fire and the put plt and 4 pax all suffered fatal…NTSB ATL85LKG06Accident · Serious injuriesFinal reportPiper PA-28-140 · Brooklet, GAThe plt stated that 2 approaches were made to rwy 09 and he could not locate a wind indicator. He was also unable to contact anyone over the UNICOM to obtain wind information. The plt attempted a landing on rwy 09 during which the acft bounced and a go-around…NTSB CHI85LA206Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · New Hudson, MIThe pilot inadvertently attempted to take off with at least 21 deg. Of flaps. The acft climbed to approximately 30-50 8T. AGL and passed over a hangar on the left side of the runway. Once past the hangar the acft began a rapid descent. Post impact fire…NTSB NYC85FGM04Accident · Serious injuriesFinal reportBell 206B · New Baltimore, PAThe acft collided with a power line during aerial application operations. There was no malfunction of equipment prior to the accident. The helicopter descended into trees & was damaged. The plt said that he was looking for a cut off marker in the form of a…NTSB CHI85LA204Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Mantua, OHDuring an aerial application flt, the plt banked the helicoper to fly around a utility pole; however, the main rotor blades contacted the pole. The helicopter then descended, landed on its skids & sustained substantial damage. The plt stated that the gusty…NTSB DEN85LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Claire City, SDThe acft collided with power lines during an aerial application flt. The power lines were located in the middle of the field being sprayed and during the last spray run, while flying into the sun, the acft contacted the lines.NTSB ATL85FA170Accident · 2 fatalField investigationFinal reportBell 206L · Duluth, GAAfter loading a seriously burned patient in the helicopter, the plt started the eng & lifted off from the hospital parking lot. Immediately after lift-off, he started forward translational flt. About 65 ft from the lift-off point, an advancing main rotor…NTSB BFO85LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warrenton, VAThe plt was obtaining transition tng fm pwrd acft to gliders and had flown 3 dual flts n N2885H on the morning of the accident with an instruction on board. The CFI then authorized him to fly his list solo flt and acft tkof obsvd the glider make what he…NTSB NYC85FA125Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Latrobe, PADrg an IFR arrival, the acft was vectored for an NDB rwy 23 apch to the westmoreland county arpt. At the NDB final apch fix (8.1 mi from the rwy), the crew turned inbound & contd to the arpt. They contacted the tower & reported over the ILS outer marker (an…NTSB DEN85LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Loma, MTThe acft contacted power lines which cross over the Missouri river. The lines are aprx 150-200 ft above the river on one side and aprx 45 ft above the river on the opposite side. The plt stated he was flying along the river at an alt of aprx 75 ft when…NTSB ATL85FA169Accident · No injuriesField investigationFinal reportLuscombe 8-A · Columbiana, ALThe airstrip is used primarily as a gliderport and at the time of the accident, traffic was being controlled by a person on the ground using handsignals. N28428 proceeded on to the rwy to takeoff as the ultralight was on final apch. Both plts observed the…NTSB MIA85LA172Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Orlando, FLThe plt reported that after he arrived & was on an apch to land, he noted 'tape' across the rwy. He remained airborne until the acft passed over 'the taped off area.' He then landed the acft on the rwy which was rough & bumpy. The plt stated that the acft was…NTSB FTW85LA223Accident · No injuriesLimited investigationFinal reportCessna 210D · Austin, TXThe plt touched down long on rwy 17 with 30 degs of flaps, apparently goind downwind. He attempted a go-around, drifted to the right and the left main gear hit a large boulder separating the gear from the acft. The plt then flew to another nearby arpt and…NTSB FTW85FA220Accident · 2 fatalField investigationFinal reportCessna 182RG · Odessa, TXWhile flying at approx 100' AGL, the acft struck a 5/8' static line on a newly constructed powerline. The cable was not yet anchored, except with pulley's on each tower and had about two miles of slack. The wire engaged the left front eng cowl and 1 prop…NTSB ATL85LA162Accident · No injuriesLimited investigationFinal reportCessna 172N · Broxton, GAThe acft collided with power lines on final apch to a private airstrip. The acft was landed in a field next to the rwy. The wires were not marked. The plt reported he was aware of the large power lines near the apch end of rwy 36 but was unaware of the small…NTSB NYC85LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Hancock, MAThe acft was under contract to the Massachusetts state environmental department. It was being used for aerial observation of forest fires & for the disposition of ground fire fighting personel & equipment. The plt reported that while he was attempting to find…NTSB FTW85FPJ02Accident · No injuriesFinal reportRobinson R-22A · Mcalester, OKThe plt was using the helicopter to round up cattle. One cow charged the helicopter and struck the tail rotor. The helicopter pitched nose down, the main rotor blade struck the ground. The helicopter came to rest in an upright position.NTSB CHI85LA191Accident · No injuriesLimited investigationFinal reportCessna A188B · Virden, ILDuring aerial application, the pilot attempted to pass over a set of low wires and under high tension lines. The wires are 300 ft. apart horizontally. The prop contacted the high tension lines and the acft was destroyed on contact with the ground.NTSB MKC85LA096Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Grady, ARAg airplane was being flown on a spray run when the left wing hit a tree. Impact with tree and ground demolished the airplane. Pilot was wearing helmet and seat belt and shoulder harness was fastened. The pilot was not injured.NTSB SEA85FA104Accident · 2 fatalField investigationFinal reportHughes 369D · Spokane, WAThe helicopter was on a flt to a tv station to transport a tv camera man & his gear. The regular plt for this trip was unable to fly, so another was retained for the flt. This was his 1st flt to the station. Helicopter operations at the tv station were…NTSB LAX85LA242Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Springville, CAAfter overflying the uncharted, private airstrip & evaluating its size, the PIC attempted to land on the narrow rwy. Only about 900 ft of the rwy was usable. After touching down, the plt realized the acft could not be stopped on the remaining available strip,…NTSB DEN85LA127Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Fort Collins, COThe balloon basket containing 8 pass'g & 2 crewmembers brushed alongside a fence during lndg. One pass'g who had been jostled by the landing became a victim of 1ACERATIONS & a broken arm from contact with barbed wire fence. The plt stated that the wind was…NTSB NYC85FHA03Accident · 1 fatalFinal reportCessna 172M · Auburn Center, PADuring attempted landing on a non-certificated strip, plt attempted a go around. The acft struck a grounding cable which was stretched between two telephone poles near the end of the airstrip. The acft then traveled aprx 120 ft before contacting trees. When…NTSB FTW85LA210Accident · Serious injuriesLimited investigationFinal reportPiper J-3C · Fredericksburg, TXThe acft contacted trees after encountering a downdraft during final apch. The plt stated the apch into the 10-12 kt gusty wind resulted in a low, flat apch. A downdraft was encountered, the acft contacted trees and descended uncontrolled into the terrain.NTSB LAX85FA230Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Garberville, CAWitnesses reported that the acft departed shelter cove, elevation 69 ft, and headed east toward a 2000 ft high mountain located 1 3/4 miles away. They continued to report the acft was climbing at a slow rate in a nose high attitude. The acft contacted trees…NTSB ATL85LA151Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Tullahoma, TNThe plt was giving a 15 yr old passenger a local area flt. While in level flt at about 200 ft AGL, the acft hit an unmarked/guyed antenna tower & crashed. The plt reported that he did not see the tower. Although the tower had been there for many years, it was…NTSB CHI85LA180Accident · No injuriesLimited investigationFinal reportMitchell Monnett Moni · Athens, MIThe plt of the home-built/powered glider initiated a touch-&-go landing. However, he did not retract the spoilers when he began the takeoff portion of the touch-&-go. The acft lifted off into ground effect, but the left wing contacted a rwy light at the…NTSB ATL85LA150Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Bayou La Batre, ALInadvertant opening of parachute in aircraft during climb to jump altitude pulled jumper from aircraft. Jumper struck right horizontal tail. Control of aircraft was lost and the pilot and the other three jumpers exited the aircraft, deployed their chutes and…NTSB CHI85LA175Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Richfield, OHThe plt made a short field takeoff using aprx 1700 ft of the 2200 ft airstrip. Unable to clear trees along the flt path, he turned to the right. However, the acft's wheel pants contacted a tree while the plane was still banked to the right & a slight amount…NTSB MKC85FA087Accident · 1 fatalField investigationFinal reportGrumman G-164A · Coy, ARWhile approaching a field to dispense rice, the acft struck a set of power lines. The plt had flown over the same set of power lines for nearly 2 hours. The flagmen stated they heard the acft strike the wires and one of the wires made a 'pop' as if being…NTSB CHI85MA169Accident · 7 fatalMajor investigationFinal reportCessna 310R · St James, MIDuring a night arrival, the plt reported that he had the arpt in sight & canceled his IFR flt plan. A witness saw the lights of the acft as it circled the destination arpt. He reported the acft had turned left to a southerly heading, & shortly thereafter, he…NTSB ATL85LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Columbia, SCThe plt stated that during takeoff the right main gear struck a large dog which ran onto the rwy. The takeoff was continued & the plt circled the arpt for 2 hrs to burn off excess fuel before performing a ldg with the nose gear & the left main ldg gear…NTSB ATL85FA140Accident · 2 fatalField investigationFinal reportCessna 140 · Hawesville, KYThe acft collided with and sunk into the Ohio river following a wing separation after contacting the lowest wire in a set of 3 power lines which spanned the river. Two other wires were located above the set of 3 power lines. Witnesses on and near the river…NTSB MKC85FCA02Accident · Serious injuriesFinal reportPiper PA-25-235 · Dexter, MOThe plt was making a swath run while on an aerial application training flt. During a pull-up at the end of the swath run, the rgt wing struck the tops of 3 willow trees. The acft then entered a rgt roll, struck an eletrical power line, rolled inverted &…NTSB MKC85LA083Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mechanicsville, IAThe plt attempted a takeoff from a short, wet, soft, alfalfa field in an acft loaded with two occurants and aprx a full load of fuel. The acft collided with a fence and a tree after using the available distance in the flt attempt. Plt recommended a more…NTSB CHI85LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Phillipsburg, OHDuring a night VFR approach to a strange airport the acft struck power lines located one-half mile from the end of the rwy. The plt stated that she was unaware of the wires & was not aware that her acft had collided with them until her forward progress was…NTSB SEA85LA090Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Okanogan, WADuring an aerial application flt, the acft collided with a power line at about 30 ft AGL. The acft then rolled to the right & struck the ground. The accident occurred about 5 min after the acft had departed the spray area.NTSB LAX85LA200Accident · Minor injuriesLimited investigationFinal reportBell 206B · Lake Berryessa, CAThe acft was on a low level, eagle survey mission. While cruising between 20 & 30 mph, the plt flew up a canyon & was crossing a ridge at about 150 ft AGL when he saw wires ahead. He took evasive action, but the helicopter struck the wires. The tail rotor &…NTSB LAX85FA197Accident · Serious injuriesField investigationFinal reportCessna 177 · Fallbrook, CAAlthough aware of existing IMC conditions and reduced lighting with the setting of the sun, the plt attempted a visual apch to his home arpt which did not have an approved apch. His remarks to mcclellen-palomar twr, regarding the use of the on-board loran…NTSB MKC85LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Herington, KSAcft tookoff from a 1900 ft long, sod, farm strip. Plt said acft became airborne at mid-field but felt mushy and would not climb. Acft collided with fence and bush at end of strip and sustained substantial damage. Acft remained airborne and continued to…NTSB LAX85FVG02Accident · Serious injuriesFinal reportCessna 172 · Auburn, CAThe acft crashed into trees during an approach to land after sunset. The plt stated that he was descending from 10,500 ft thru 5000 ft with the arpt in sight as well as the lights of sacramento, CA. He does not remember the accident but remembers his wife was…NTSB MIA85LA142Accident · No injuriesLimited investigationFinal reportCanard Long EZ · Crystal River, FLThe plt stated that while flying at low level he collided with some power lines, severing his main landing gear & one half of his left winglet. He then continued about 4 miles further landing in a clear area on the Crystal River power plant property & slid…NTSB BFO85LA033Accident · No injuriesLimited investigationFinal reportMooney M20E · Mitchellville, MDAfter experiencing a gusty crosswind on final approach to runway 18, the pilot employed standard crosswind landing technique. Once over the threshold, power was reduced to idle and the pilot commenced the flare. During the flare, a gust of wind blew the alft…NTSB MKC85FA080Accident · 1 fatalField investigationFinal reportGulfstream-Schweizer G-164B · Garland, ARThe plt was beginning a spray run over a wheat field when the acft impacted the top 3 strands of a 4 strand, high voltage power line. The acft then descended uncontrolled until impact with the terrain.NTSB FTW85FPJ01Accident · Serious injuriesFinal reportGrumman AG CAT G-164 · Norman, OKThe acft collided with a high static wire on an electric transmission line before colliding out of control with the ground. The plt stated after the accident that he forgot about the static line and flew into it during a maneuver for aerial spraying.NTSB LAX85LVM03Accident · No injuriesFinal reportBell 47G-2 · Watsonville, CAThe plt stated he intended to climb over a pwr line at the end of a swath run, however, a tailwind gust was encountered and the acft could not obtain sufficient altitude to clear the line. The plt elected to fly under the line unaware of a lower line which…NTSB FTW85IA168Incident · No injuriesIncident investigationFinal reportBoeing 727-200B · Mexico City, MexicoDuring the initial climb after takeoff a 27 foot tall light pole was struck by the right main landing gear 1,677 feet from the end of the rwy. Acft gross weight dictated a 5 deg flap takeoff and company performance data authorized departure on either rwy 5R…