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 NYC86FA030Accident · 2 fatalField investigationFinal reportCessna C-182N · Winterport, METhe acft departed bangor under special VFR dur to low ceilings. A witness saw the acft fly under powerlines that crossed a river and disappear behind trees. There was no indication of an accident. 22 day later, the acft was located 150 ft south from the…NTSB CHI86FA007Accident · 2 fatalField investigationFinal reportGulfstream 690A · Cadillac, MIThe acft was cleared for an NDB approach to Cadillac. The wkwas 300 ft ovcst, 1 mile vis. Shortly after cancelling IFR the acft crashed on the opposite side of the arpt from the approach end of the rwy. The pilot activated rwy lights were never turned on…NTSB SEA86FA007Accident · 3 fatalField investigationFinal reportCessna 172 M · Callville Bay, NVNew pvt plt with two pax on board was observed making several low level passes over road in a canyon in dark. On last pass acft wing tip hit power pole below cross-bar, rolled inverted, crashed and burned.NTSB ATL86FA003Accident · 2 fatalField investigationFinal reportCessna C-172M · Luxora, ARAfter a day of work,the plt and two friends made a LCL flt around he area. Near the end of the flt,a fire was spotted on the west bank of a miss. River channel. The plt decided to go down and take a look at the fire. After passing over the fire, flt down the…NTSB LAX86FA004Accident · 4 fatalField investigationFinal reportCessna T210L · Lebec, CAThe acft contacted trees and the terrain in an uncontrolled descent and was destroyed by impact and an ensuing fire. The acft's left elevator was not located during the post accident inspection. Witnesses reported seeing the acft flying low (50 ft AGL) and…NTSB LAX86FA002Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Paradise, CAAfter takeoff, for an aflight orentation, the high time (over 2 4000 flt hours) pilot descended to an altitude of approx. 300 over a lake. The pilot was then flying up a twisting arm of the lake, in mountainous terrain into unmarked electrical transmission…NTSB SEA86LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fall City, WADuring an attempted go around the acft struck trees and bushes. The plt stated he could not remember if carb heat was removed during the go around. He continued to state, sufficient alt and airspeed could not be gained. An eng examination revealed several…NTSB BFO86FA002Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Gaithersburg, MDThe plt was clrd for a VOR rwy 14 apch. On apch, he rprtd at the sleet intxn (a fix on the NDB apch). The acft was then seen flying ovr the arpt on an easterly hdg. UNICOM operator said he then heard the plt call "turning final." However, bfr lndg, the acft…NTSB DEN86FA002Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Chamberlain, SDThe plt and his passenger friend were looking for stray cattle when aprx at 142 ft above the ground their acft struck an antennae mounted on a microwave tower. The acft descended and was destroyed on ground impact.NTSB NYC85LA254Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Preble, NYA Schweizer N33920, collided with a utility pole while executing a go around at Preble airport, NY. The acft was destroyed. The plt and passenger received minor injuries. The plt stated that the first two flights were uneventful, but noticed the stall speed…NTSB CHI85LA389Accident · No injuriesLimited investigationFinal reportDouglas Maselink XTC · Caledonia, MIThe acft struck power lines while on apch for landing. The plt stated that he did not see the power lines; however, witnesses reported they warned the plt of the electrical lines prior to the accident.NTSB ATL85LA284Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Holly Springs, MSThe stu plt on his fourth solo flt elected to make a touch-and-go lng prior to going to the practice area. After turning base on the closed VFR traffic pattern, he states that he could not find the runway and allosed the airspeed to decrease too low. When he…NTSB SEA85LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fernly, NVThe acft's windscreen was struck by a bird and was blown out injuring the plt. The plt had difficulty keeping the acft airborne and a forced landing was made. The acft nosed over during the landing rollout on soft terrain.NTSB MIA85LA259Accident · No injuriesLimited investigationFinal reportCessna C-152 · Lantana, FLThe plt stated that he was hovering at an altitude of about three feet. Approximately 100 feet north of the rwy. When an out-of-control Cessna 152 tore off their right landind skid. The helicopter landed safely using a wooden dolly for support of the right…NTSB NYC85LA242Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Ware, MAThe student plt and CFI were practicing full stop night landings when the accident occurred. While on final apch for thefourth landing, the acft collided with trees 1.7 NM short of the rwy.NTSB MIA85LA256Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Indiantown, FLThe acft attempted a take-off from an intermediate point of a damp, soft, turf rwy. A 70 deg. Left x-wind of approx 25 KTS existed at the time. The acft became airborne but was unable to clear trees at the end of the rwy. Thee acft was destroyed in the crash…NTSB FTW85LA347Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Angleton, TXThe plt had descended to very low alt (10-15 feet above ground level) during VFR weather conditions while still several miles from his destination arpt and impacted an electrical power line. He made a precautionary landing and rendered first aid to his…NTSB MIA85LKG06Accident · Serious injuriesFinal reportCessna A188B · Bascom, FLThe acft collided with a pecan tree during a spray operation the plt said he should have been more attentive to the operation of the acft and the environment.NTSB ATL85FA272Accident · Serious injuriesField investigationFinal reportMBB BK-117A-1 · Aiken, SCPlt was maneuvering helicopter at low alt and into rising terrain. On 3rd right turn racetrack pattern, witnesses observed acft descend slightly, roll into a 45 deg or greater bank and contact trees. The acft started a yawing rotation to the right and…NTSB FTW85LA354Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26C · Rockdale, TXThe pilot observed and cleared serveral obstructions in the approach path of his intended landing area. However, he did not see one small and unmarked electrical power line until too late to take evasive action. This line was about 30 feet above ground level…NTSB CHI85FEV03Accident · 1 fatalFinal reportCessna 172 · Sweetwater, ILThe acft was observed flying at low alt parallel to a hiway before colliding with a tree before impacting the ground. The plts wife said that the plt had been under extreme stress for a few months and had not been to bed for 2 days preceding the accident. She…NTSB DEN85FTE08Accident · Minor injuriesFinal reportCessna 182N · Alamosa, COThe acft contacted trees, a fence and a ditch during a precautionary landing on a dirt road. The plt stated that when approaching his destination, the eng began running rough and he was unable to correct the problem. He then decided to land on the road and…NTSB CHI85LA367Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Blaine, MNThe one hour balloon sightseeing flight was uneventful. During his approach to land in a clear area he decided that his forward velocity was too high to land without hitting houses or powerlines below the balloon. According to him he burned fuel to attempt a…NTSB FTW85LA339Accident · Minor injuriesLimited investigationFinal reportCessna 150B · Drumright, OKThe pilot's landing approach was long and fast. The aircraft touched down but the pilot decided he would be unable to stop on the remaining runway and intiated a go-around. He then realized he would not be able to clear trees beyond the end of the runway. He…NTSB FTW85LA340Accident · 1 fatalLimited investigationFinal reportCessna L-19E · Palo Pinto, TXThe acft was reported by witnesses to have been flying very low over a lake just prior to accident. The acft collided with pwr lines after passing over a dam and was destroyed on ground impact. The plt reported a loss pwr was experienced. The eng was test run…NTSB ATL85FA278Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Proctor, WVThe acft was artd msg and was the object of a search from 9-1-85 to 9-12-85. Acft found in remote area of mtns and dense woods by man on foot hunting ginseng on 9-16-85.ND witnesses found. Residents in area reported rain all day on 8-30-85 and it was heavy at…NTSB MKC85LA196Accident · No injuriesLimited investigationFinal reportCessna 172 M · Gravois Mills, MOThe plt reports that he began his takeoff on rwy 07 which is 2550 ft long, has an asphalt surface and a downhill slope. Plt said the rwy is rough. He said the acft did not achieve the speed desired and he reduced power to abort. He then decided to attempt the…NTSB NYC85LA224Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Central Square, NYThe plt stated the acft would not climb out of ground effect during takeoff. He flew the acft between trees at the end of the rwy and severed the wings from the fuselage. The acft was found to be 317 lbs over gross weight.NTSB LAX85LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Williams Afb, AZAfter making his first swath run,during the hours of darkness,the pilot became disorented and flew into an area with tall electrical transmission lines. He descended into trees beneath the lines in his attempt to miss them.NTSB DCA85AA035Accident · 8 fatalFinal reportBeech 99 · Auburn, MEDrg arr, aprx 12 mi south of the final apch fix (faf), flt 1808 was clrd for an ILS rwy 4 apch. Aprx 3 min later, ATC controller (ctlr) noted acft was tracking east of the localizer (LOC) course. He asked if the flt was rcvg the ILS LOC. Capt replied 'not yet…NTSB DEN85LTK02Accident · Minor injuriesFinal reportPiper PA-25-235 · Yankton, SDThe acft descended uncontrolled into the terrain after it contacted a power line during an aerial application flt. Witnesses reported the acft appeared to pull up at the west end of the 40 acre fld, however, it did not clear the lines and it nosed over into…NTSB ATL85LA257Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Portland, TNThe plt made a visual aprch to the wrong airport & attempted to go-around. During the go-around the acft coll ided with trees on the departure end of the rwy.NTSB ATL85LA255Accident · No injuriesLimited investigationFinal reportCessna 172E · Villa Rica, GAThe plt took off from the stockmar arpt on a local flt. After flying in the local area, he returned at dusk to land, but inadvertently made an approach to another arpt that was located about 1/2 mi from the stockmar arpt. He did not realized that he was…NTSB ANC85LA159Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Gulkana, AKThe acft crashed shortly after the plt had departed an airstrip to proceed on a hunting trip. Impact occurred in a wooded area about 1 mi from the strip. According to witnesses, the plt had made 2 low approaches over the trees before the acdnt. The acft was…NTSB CHI85FA354Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Wilmington, OHThe pilot was flying on a south casterly heading of approximately 150' at a low altitude when he struck a set of static lines at approximately 170' AGL. The aircraft flipped over and hit the terrain at approximately 60, nose down in a stand of corn. The pilot…NTSB ANC85MA157Accident · 3 fatalMajor investigationFinal reportGates Learjet 24D · Gulkana, AKDuring a night arrival, the flt was on an instrument apch to the Gulkana arpt when radio contact with the acft was lost. A search was initiated & the wreckage was found 7.4 mi north of the terminal VOR on the 330 deg radial. The inbound course for the VOR rwy…NTSB CHI85FA356Accident · 1 fatalField investigationFinal reportCessna 172 · Rose Township, MIJust prior to the accident, several witnesses observed the acft flying at a very low alt in the vicinity of the crash site. The crash site was located across the road from the home of the plt's brother. According to witnesses, the acfts eng was operating…NTSB SEA85LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, ORThe plt descended to a low alt over a river to look for birds. While over the river the plt spotted pwr lines at an alt of aprx 75 ft AGL. An attempt was made to fly under the lines, but the tail contacted the wires severing aprx 6 inches off the top portion…NTSB NYC85LA215Accident · Minor injuriesLimited investigationFinal reportBell BH206L-1 · Hawley, PAThe helicopter arrived at a private residence to transport race car drivers to the pocono raceway. During departure the pilot failed to see powerlines in the flight path that contacted the main rotor system. The main rotor system failed and the helicopter…NTSB LAX85FA355Accident · Serious injuriesField investigationFinal reportCessna 150L · Rialto, CAThe christian eagle biplane was returning from a local instructional flight and entered the pattern on a normal 45 degree entry, announcing position and intentions on the UNICOM frequency. The Cessna 150 was departing the airport on a local instructional…NTSB NYC85LA214Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Montgomery, NYThe plt reported that the flt was uneventful until he was in a descent about 12 mi from the destination arpt. He said that a large bird suddenly appeared in front of the acft & collided with the right wing. The bird strike put a large hole in the right wing…NTSB FTW85LA323Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Floydada, TXThe plt stated he failed to see a metal stand pipe in the cotton field. The acft collided with the stand pipe and flipped inverted. Residue of the spraying chemical was observed on the windscreen after the accident. This residue restricted forward visibility…NTSB DEN85LA219Accident · No injuriesLimited investigationFinal reportCessna C-172 · Killdeer, NDThe plt said he measured the length of the r/w prior to t/o. the t/o was normal on a downsloping r/w with trees at the FAR end. The plt said that as the a/c lifted off the r/w the a/c struck the trees. He said a gust of wind caused the a/c to settle into the…NTSB ATL85LA260Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Prestonburg, KYThe pilot stated that while on short final the aircraft encountered a down draft which caused a sudden loss of altitude resulting in a hard landing. The aircraft tire blew on landing and the aircraft veered off of the side of the runway and was substantially…NTSB MIA85FA234Accident · Serious injuriesField investigationFinal reportCessna C-172M · Immokalee, FLThe acft had departed from the north-south oriented grass strip for a local flt and was returning to land toward the north. On short final the acft collided with an umarked power transmission line aprx 100 ft AGL and 0.25 mile south of the apch end of the…NTSB MKC85LA187Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Ottumwa, IAN27492 collided with utility wires which cross the des moines river and crashed into the river.NTSB LAX85LA344Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Big Bear City, CAOn August 12, 1985, a Bell 47G2 helicopter collided with a yucca tree and rolled over during a landing near Big Bear City, CA. The acft sustained substantial damage and the plt and his two passengers were not injured. The purpose of the flight was a aerial…NTSB FTW85LA312Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Morton, TXAfter completing several passes, the acft was crossing a road under power lines when the propeller struck a road sign. The acft subsequently became uncontrollable and impacted in an adjacent field, flipped over and slid to a stop. The pilot stated that he was…NTSB ATL85FA243Accident · 1 fatalField investigationFinal reportCessna 150G · Selma, ALAcft took off from sod strip on hot humid day near max weight. PIC said he used 10 degrees flaps and was airborne. At about runway mid point. When over first tree line after passing threshold acft descended. When over brown terrain acft climbed. When over…NTSB MKC85FA179Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Palisade, NEWhile on a swath run over a cornfield, the plt attempted to maneuver under power lines that were spanning a large ditch. The right wing struck one of the three lower cables which cut into the wing structure. The cable finally separated releasing the acft. The…