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 LAX85LA187Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Banning, CAThe acft collided with a power line 50 ft AGL while maneuvering over a freeway at low alt. A palm springs ATC employee who was driving his car in the eastbound lane of I-10 aprx 10 NM east of the Banning arpt, observed the accident acft on a westbound heading…NTSB MKC85FPG03Accident · Serious injuriesFinal reportHelio Courier H-295 · Winslow, ARThe left wing of the acft contacted a tree during an attempted takeoff from a 1200 ft long grass fld. The acft then rotated 180 degs and impacted the ground. The plt had landed the acft in the fld on 3/21/85 when deteriorating wx was encountered in-flight.…NTSB FTW85FA152Accident · 1 fatalField investigationFinal reportUniversal Stinson 108 · Emhouse, TXWitnesses observed the student plt making repeated low passes near his friend's house. While maneuvering, the acft collided with a power line, then crashed to the ground inverted. The student held a student plt certificate that was dated 10/17/62. No record…NTSB ATL85LA119Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Tarboro, NCThe plt was attempting a simulated emergency landing on an ag airstrip & collided with several unmarked power lines while on final approach. The student plt was not authorized to land at the ag strip according to his flight instructor.NTSB MKC85LA072Accident · No injuriesLimited investigationFinal reportHughes 369HS · Princeton, MOThe helicopters tail rotor collided with power lines during an apch to an open field. According to the plt, upon descending onto the fld, the acft began to vibrate severely. Consequently, the plt lost control and the helicopter made two 360 degree revolutions…NTSB ANC85LA059Accident · No injuriesLimited investigationFinal reportBell 206B · Mcknley Park, AKDuring takeoff the helicopter contacted a .081 inch copper wire which was strung across the river at an alt of aprx 15 ft. the wire became entangled in the tail rotor resulting in control difficulties, however, the plt was able to land the helicopter aprx 1/2…NTSB MIA85LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe acft collided with trees while the plt was practicing slow flt on a solo training flt. The plt stated after the accident that he diverted his attention from outside to the acft instrument panel and felt a jolt. A full pwr recovery to level flt was made…NTSB CHI85LA140Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Marshall, MNThe acft contacted 10 ft high trees during takeoff from a gravel taxiway. The plt then performed a forced landing in a cultivated fld during which the landing gear separated from the acft.NTSB MIA85LA114Accident · Minor injuriesLimited investigationFinal reportMitchell Harvey Condor III +2 · Lake Placid, FLThe plt stated that on takeoff from lake persommon he was unable to climb more than 50 fpm due to downdrafts along the tree line on his right side & he collided with a 35 ft tree & crashed into a creek.NTSB FTW85LA143Accident · Minor injuriesLimited investigationFinal reportCessna 172-N-II · Markham, TXThe accident occurred on go-around from an inadvertant down-wind approach to a crop duster strip. The pilot failed to retract the flaps, and the heavily-laden aircraft could not accelerate to climb. The pilot elected to fly under powerlines at the end of the…NTSB CHI85LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140B · Barlow, OHAcft owner-student plt was flying the acft accompanied by a pvt plt. During a simulated forced landing apch the acft struck static lines on a high tension installation and descended to ground impacted.NTSB MKC85FA069Accident · 1 fatalField investigationFinal reportCessna 150F · Waldron, MOWhile maneuvering northbound on the Missouri river levee the passenger noticed the plt flying just above the levee road. The passenger stated the plt told him they were forty feet off the ground but sometimes lower. The passenger stated he saw the pickup…NTSB ANC85FA052Accident · 1 fatalField investigationFinal reportBell 206B · Whittier, AKThe helicopter impacted terrain in a 150 ft gorge after contacting telephone lines along a railroad right-of-way aprx 2 miles north of a tunnel station. Purpose of the flt was to survey the area around the tunnel station.NTSB FTW85FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Gilmer, TXAn associate of the plt/owner stated that he had departed at about 2030 CST to get some night practice prior to getting a day VFR restriction removed from his pvt license. Reportedly, the owner/plt & an instructor (CFI) were intending to fly together &…NTSB MIA85LA109Accident · No injuriesLimited investigationFinal reportCessna 170 · Newberry, FLThe plt stated that he was having eng problems so he landed on a road, repaired the problem, & upon attempting to takeoff the acft first struck power lines then collided with trees. Investigation revealed that the plts initial eng problem was a clogged fuel…NTSB ATL85FMG03Accident · Minor injuriesFinal reportPitts S1C · Durham, NCThe plt reported he put the acft in a steep bank shortly after takeoff to view his son who was on the ground. He stated he failed to apply back pressure and the acft contacted trees off the end of the rwy. The acft then impacted the gorund.NTSB DEN85FA088Accident · 2 fatalField investigationFinal reportBellanca 7GCAA · Cornville, AZThe acft was on a local flt with the owner/private plt & a student plt on board. While in aerobatic flt over a narrow canyon/gully area, the acft collided with & severed 3 power lines & a static line, located aprx 100 ft above the ground. The acft then…NTSB ATL85LA104Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Suches, GAAfter takeoff in mountainous terrain pilot used shallow climb on course. Pilot stated he failed to climb to a suitable altitude. When first ridge was cleared a downdraft was encountered. Pilot made 180 degree turn but was unable to climb above terrain.NTSB CHI85FA120Accident · 2 fatalField investigationFinal reportPiper PA-31T · Utica, MIThe pilot attempted a VOR approach and missed. He advised ATC he was going to attempt the NDB & if he could not see the rwy he would go to metro at detroit or pontiac. On the NDB approach the aircraft struck trees 960 ft below the moa. The aircraft flipped…NTSB MKC85FCQ01Accident · Serious injuriesFinal reportBeech 95-B55 · Hutchinson, KSDuring arrival, the plt began an ILS apch to rwy 13 at the Hutchinson muni arpt. He reported that he had turned off the 16 mi arc, had intercepted the localizer & had begun his descent to the min published alt to cross over the outermarker (final apch fix).…NTSB SEA85LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Spanaway, WAThe plt was attempting to better align the acft for final apch when a tree was struck with the right wing. The plt stated she was distracted while making preparations to land. The landing was continued without incident.NTSB LAX85LA144Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Healdsburg, CAWhile on a local flt, the acft collided with trees in a canyon. The plt reported the acft's alt was lower than anticipated & the terrain in the canyon rose rapidly. Full eng power was not sufficient to negotiate the rising terrain. The plt reported the acft's…NTSB MIA85LA093Accident · Minor injuriesLimited investigationFinal reportMonerai S-P · Immokalee, FLThe plt was making an apch to a grass portion of the arpt not usually used for acft. The glider contacted pwr lines during the apch and subsequently collided wtih the terrain. The plt stated he never saw the pwr lines before contacting them.NTSB ATL85FA090Accident · Serious injuriesField investigationFinal reportCessna 152 · Acworth, GAThe acft contacted power lines and descended uncontrolled to the terrain during the recovery phase of a simulated forced landing. The simulated forced landing was initiated by the CFI at an alt of aprx 800 ft AGL over the median strip of hwy 75. The student…NTSB NYC85FA059Accident · 2 fatalField investigationFinal reportBeech A100 · Cedarville, NJThe two ATP rated plts were en route back to their home base arpt flying on an IFR flt plan in actual instrument wx conditions. Communications with ATC controllers was normal. During a night localizer apch into millville municipal arpt, an ATC specialist…NTSB ATL85FA081Accident · 2 fatalField investigationFinal reportCessna 182H · Letohatchee, ALAcft was observed at low alt descending on a northerly hdg. About 1.5 mi. 5 of the crash site. Engine sounds were characterized as smooth and normal. Acft struck a 44000 volt x-mission line parting a 5/16IN. Diameter hi-strength steel ground cable and a 1/0…NTSB MIA85LA084Accident · No injuriesLimited investigationFinal reportCessna 340A · Orlando, FLThe acft collided with power lines while operating at low alt over an unpopulated area. The plt indicated that he descended to a 'low alt' & pulled up to aviod some trees. After the pull-up, he said that he noticed some damage & continued his flt to ft.…NTSB LAX85LA117Accident · No injuriesLimited investigationFinal reportHughes 369E · Honolulu, HIWhile in flt over water at about 400 ft AGL & 1/2 mi from shore, the plt saw a large flock of white birds. He reported that he flared to a stop, but was unable to avoid the birds. After the helicopter struck bird(s), an extreme vibration developed. The plt…NTSB DEN85IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Flushing, NYAcft struck a seawall dike immediately after takeoff from runway 13 at la guadia airport, Flushing, NY. Acft continued on to denver, co where uneventful landing was made. Post-flight inspection revealed minor damage to tailskid and number 2 engine thrust…NTSB ANC85LA034Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Mt Village, AKTakeoff was performed downhill on the ice covered 2200 ft gravel airstrip. Plt stated liftoff was late but given the surrounding terrain, the takeoff was continued rather then aborted. During climb the acft contacted the roof of an abandoned building. Acft…NTSB MIA85LA072Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Pompano Beach, FLThe balloon envelope struck a palm tree and a building while landing. The basket turned over when it contacted the ground. A passenger was injured when another passenger fell on her as the basket turned over.NTSB NYC85FNC02Accident · Serious injuriesFinal reportPiper PA-34-200T · Hopkinton, NHThe acft collided with a tree during an ILS approach in IMC wx. The acft was on a x-cty flt and the plt declared a missed approach at this pt but did not acknowledge hitting the tree. When the rt eng quit and directional control could not be maintained the…NTSB ATL85FA072Accident · 1 fatalField investigationFinal reportCessna 182A · Dublin, VAAfter dropping the parachutist, the acft was observed to fly eastward over the dz, make a left 180 turn, line up on the parked van on an easterly heading and descend to a low altiude. Witnesses estimated the altitude at from 10 T0 30 ft AGL. The van was…NTSB MKC85FA040Accident · 3 fatalField investigationFinal reportBeech S35 · Hot Springs, ARThe acft collided with trees & crashed on the east side of west mountain after the plt had made an ILS rwy 5 apch & overflew the arpt. The last wx observation before the accident was: partial obscuration, ceiling 300 ft, visibility 1 mi. The decision height…NTSB MIA85FA066Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Homestead, FLWhile cruising northerly at a low altitude during a dark night, the acft struck a row of trees appx 50 ft tall about 8 ft from the tops, it then hit a large tree at about 6 ft AGL, 670 ft from the initial impact point, & came to rest in a dirt road. An exam…NTSB LAX85LA085Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Cottonwood, AZWitnesses reported that the acft was in level flight at treetop altitude along a river and that the engine was operatingnormally until the acft struck & severed three power lines before impacting the riverbank about 200 ft west of the wiresNTSB FTW85FA084Accident · 4 fatalField investigationFinal reportBeech A36 · Lake Charles, LAThe acft crashed 3 miles short of the Lake Charles airport while on an ILS approach. Instrument meteorological conditions prevailed at the time of the accident, and an IFR flight plan was filed by the non-instrument rated pilot. A review of the radio…NTSB ATL85FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glasgow, KYThe acft crashed one mi short of rwy 07 at Glasgow municipal airport while on sdf rwy 07 inst app. There were no witnesses to the actual accident other then the surviving passenger who stated that the plt had asked her to look for the rwy lights. She stated…NTSB MKC85FA039Accident · 1 fatalField investigationFinal reportCessna 180K · Ft.Smith, ARWitnesses along the Arkansas river observed the acft flying low over the river, in a northeasterly direction. As the acft approached a set of high voltage power lines that crossed the river aprx 85 ft above the water, it banked left and the rt wing struck the…NTSB ATL85LA053Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Albermarle, NCPlt saw unfamiliar mountain range and decided to land in a residential construction site to find out his exact location. Plt failed to see electrical wires during the descent until too late. Plt lost control of acft in last minute attempt to avoid wires. Acft…NTSB SEA85FA028Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Gig Harbor, WAThe plt departed in the early morning hours from salem, OR, destined for Gig Harbor. Upon arrival in the destination area the plt was in radio contact with seattle apcon. The plt reported he was unable to aquire visual contact with the arpt. Vectors were…NTSB NYC85FA039Accident · 1 fatalField investigationFinal reportMooney M20J · Montague, NJThe pilot of this aircraft was discharged from the hospital following a bladder biopsy about six hours prior to the accident. Although he was advised not to fly that day he elected to do so. He was engaged in buzzing a friends house when he collided with…NTSB FTW85LA074Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKThe acft collided with power lines during a recovery from a practice autorotational landing. The instructor plt took control of the acft for recovery and did not see the wires.NTSB ATL85MA049Accident · 1 fatalMajor investigationFinal reportBeech 58 · Charleston, SCPlt descended below mda during a night VOR (non-precision) apch to an uncontrolled arpt and collided with trees & groundwhich were obscured by fog. The plt had 'pushed' himself to make the trip according to friends and associates in an attempt to win an…NTSB SEA85LA026Accident · No injuriesLimited investigationFinal reportCessna 402C · Boise, IDDescent was made to aprx 50 ft AGL to observe a herd of cattle. Acft contacted power lines cutting off the left wing tip. Flt continued and landing was made at Boise air terminal without incident. Plt stated he did not see wires.NTSB CHI85FA059Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Wixom, MIThe acft collided with power lines while on final approach for a landing. The passenger related that the sun was very low on the horizon, and while looking toward the sun & haze, the visibility was limited. As the acft turned on final approach, a large flock…NTSB MKC85LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Van Buren, MOPlt stated that while on approach into setting sun, he failed to see a tree and the windsock tower due to sunglare, colliding with both before impact with the ground. The windsock was located 200 ft north of the rwy. Winds were calm and reciprocal rwy was…NTSB CHI85LA055Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Lagrange, INPlt was landing in gusty, crosswind conditions. On late final, a gust of wind caused the left wing to drop and strike the top of an 80 ft tree. Acft touched down nose low, collapsing the landing gear.NTSB MKC85FA024Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Cozad, NEThe acft collided with a electrical transmission line while on a business flt. Investigation revaled IMC existed at the time of the accident, the plt did not file a flt plan, there was no evidence of a wx briefing and there were no known communications with…NTSB MKC85LA021Accident · No injuriesLimited investigationFinal reportMooney M20J · Kirksville, MOAccording to the plt, during a localizer apch impact with an object was heard and the acft yawed left. The plt did not see what the acft hit but stated that he believed the acft struck a bird. Using a flashlight he attempted to inspect theacft in order to…