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 ATL87MA041Accident · 6 fatalMajor investigationFinal reportBeech 100 · Windsor, MADrg arr for a LOC rwy 26 apch, the plt was adzd the abyss fan marker was notamed out-of-svc. With abyss inop, min dscnt alt (mda) was 2200'. After N65TD was clrd for the apch, radar svc was terminated & the flt was clrd to adzy freq. The crew contacted UNICOM…NTSB LAX87DUJ02Accident · No injuriesFinal reportGrumman G-164 · Chandler, AZThe acft collided with power lines during an aerial application flight. The pilot had made several passes prior to the accident and noticed the wires each time. Visibility was good, it was daylight conditions, and there were no mechanical problems.NTSB FTW87FA025Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Baytown, TXThe plt took off from a decommissioned, unlighted arpt at night after telling friends in a bar that he was going to new orleans. Later, witnesses observed the acft as the plt made several low passes over an interstate highway near the departure arpt. While…NTSB DEN87LA027Accident · No injuriesLimited investigationFinal reportCessna 152A · Great Falls, MTThe student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.…NTSB CHI87FA040Accident · 4 fatalField investigationFinal reportMooney M20E · Hanna City, ILThe aircraft struck power lines and crashed two miles from the end of the runway on final approach ground track after being cleared for an ILS approach. The accident occurred at the end of a three leg cross-country flight from the Bahamas which began aprx 8…NTSB ATL87FA029Accident · 4 fatalField investigationFinal reportBeech 35-B33 · Winston-Salem, NCThe flt departed rochester, NY, and received and IFR clearance. The flt and ATC handling were normal. The plt was cleared for the ILS rwy 33 apch to Winston-Salem, NC. The flt was established on the final apch but collided with trees about 2 miles southeast…NTSB LAX87DVA02Accident · No injuriesFinal reportSchweizer G-164A · Fresno, CAThe airplane collided with telephone lines while conducting an aerial application operation. The pilot reported that he was familiar with the area. He surveyed the field, in flight, before he commenced the spraying activities. The pilot did not report, nor…NTSB MKC87LA024Accident · No injuriesLimited investigationFinal reportCessna 177XP · Camden, ARThe pilot stated he was on approach during IMC and had the airport in sight when he flew into another cloud and had started a missed approach when he collided with a tree. He completed the missed approach and diverted to monroe, LA.NTSB LAX87LA352Accident · 2 fatalLimited investigationFinal reportCessna 180K · Lakeport, CAThe plt & his daughter were believed to have depd his pvt airstrip on 11/22/86 or 11/23/86. They were rprtd missing on 11/24/86 & a search was begun, but the acft was not fnd until 8/19/88, when the wreckage was discovered by hunters. The crash site was…NTSB FTW87LA020Accident · No injuriesLimited investigationFinal reportBarnes Firefly 7 · Holden, LAA commercially rated pilot on an instructional flight was attempting a touch and go landing in the median of hiway I-12 1 mile east of Holden, LA. The pilot failed to see and avoid some power lines substantially damaging the balloon. The pilot and student…NTSB FTW87FA017Accident · Serious injuriesField investigationFinal reportCessna 152II · Grandview, TXA student plt, while on a solo VFR navigational training flt, became lost. After 3.5 hours of flt, the plt thinking she was almost out of fuel elected to make a downwind landing on a country road near Grandview, TX. The acft contacted trees and subsequently…NTSB CHI87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bethalto, ILThe pilot attempted an ILS approach into an airfield (runway 29) that was reporting a zero foot obscured ceiling with 1/16 mile visibiltiy and fog. He stated that he became confused during the last portion of the approach and was beginning a missed approach…NTSB NYC87LA034Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Jackman, METhe pilot attempted a landing on a runway marked with a x. the runway was closed because it had been extended and was very close to some powerlines. The pilot hit the power lines on final and the aircraft received substantial damage. The pilot was seriously…NTSB CHI87LA032Accident · No injuriesLimited investigationFinal reportBurkhart Grob 109B · Gregory, MIWhile landing, the aircraft bounced twice, so the pilot decided to go around and make a second attempt. On climb out, the landing gear struck 65 ft tall trees at the end of the runway. The aircraft then stalled and collided with the terrain. Reportedly, the…NTSB SEA87LA025Accident · No injuriesLimited investigationFinal reportHughes 369D · Winlock, WAThe plt was loading xmas trees from a farm to a truck. He had just released a load and was en route back to the pickup area when the empty long-line sling contacted treetops. The sling rebounded into the tail rotor & damaged the gear box which resulted in…NTSB LAX87LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Sun City, AZWhile on a solo instructional flight, the pilot was unable to find sufficient lift & decided to turn back toward the airport for landing. Due to his low altitude, he was not able to fly a normal pattern entry. A downwind landing was attempted; however, before…NTSB MIA87DKT01Accident · Minor injuriesFinal reportPitts S-1T · Miami, FLAircraft collided with trees while recovering from a spin which was performed at low altitude as part of an airshow performance. Pilot stated he misjudged height of trees and recovered from the spin too low.NTSB CHI87FA021Accident · 1 fatalField investigationFinal reportCessna 182P · Goreville, ILThe acft crashed and burned following a collision with a guy-wire supporting a micro-wave tower. The plt had initiated the flt in MVFR weather and continued the VFR flt into IMC conditions. The crash site was located adjacent to interstate hwy 57 and…NTSB NYC87LA030Accident · Serious injuriesLimited investigationFinal reportBell 206B · Staten Island, NYThe on-demand cargo flight encountered a bird strike enroute from new jersey to jamaica, new york. The pilot received serious injury to the eye and checkbone but was able to accomplish an emergency landing in a parking lot without further damage or injury.NTSB CHI87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lafayette, INDuring an instructional flight a bird strike was encountered while practicing steep turns at about 2500' MSL. The horizontal stabilator was damaged to the point that it was barely operative. Landing was accomplished by using extreme forward pressure to the…NTSB MIA87FA020Accident · 1 fatalField investigationFinal reportBushby MM-1 · New Smyrna Bch, FLWitnesses, including the victim's son riding as a pax in another acft flying at 800 ft, observed the midget mustang coming up from the right, behind and below them. While still below their alt, the mustang was observed to roll to the right, away from them,…NTSB FTW87DPJ01Accident · No injuriesFinal reportSnow AT-301 · Hennessey, OKThe acft collided with a street sign during takeoff. Unablt to maintain flight, the plt landed the acft in a field collapsing the right landing gear.NTSB BFO87FA006Accident · Minor injuriesField investigationFinal reportPiper PA-28-140 · Bloomington, MDWitnesses observed 2 aircraft flying near treetop level and reported that one appeared to be about 10 feet behind the other. The lead aircraft collided with trees when the pilot delayed his pullup to a point where he was unable to climb over a ridge on his…NTSB MIA87FA015Accident · 1 fatalField investigationFinal reportde Havilland DHC-3 · San Juan, PRWitnesses stated that the acft used most of the rwy to takeoff, reached an aprx altitude of 60 feet, then pulled up to clear an embankment. However, the acft struck a tall palm tree & crashed between 2 roads, near an intersection, where the roads merged. The…NTSB DEN87LA010Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Richardton, NDThe plt attempted a landing on an unlighted dirt strip at dusk. He stated he intentionally flew low because it was getting dark. On final apch acft struck trees and then impacted the terrain, nosing over.NTSB CHI87LA014Accident · No injuriesLimited investigationFinal reportBeech V35A · La Pointe, WIThe acft struck a deer during the landing flare. The plt was able to maintain control of the acft and complete the landing even though the acft sustained substantial damage to the right wing and its associated structure.NTSB DEN87FA007Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Crosby, NDCrosby municipal arpt was notam'd closed due to rwy construction and resurfacing. The plt and paxs were employees of the engineering company participating in the arpt construction. The plt of N8271P had landed on the closed rwy earlier in the day. The rwy was…NTSB MKC87DCA01Accident · 2 fatalFinal reportCessna C-152 · Fredericktown, MOThe aircraft was being used to give relatives local area flights. The witnesses reported that the airplane had been doing low altitude maneuvers, stalls, and engine power cuts for over an hour. The witnesses observed the acft in a low altitude pass when it…NTSB NYC87FA023Accident · 1 fatalField investigationFinal reportCessna R172K · Rockwood, TNThe aircraft was observed departing at approx 2010 hours, reversing course and flying over the airport at 300-400 ft AGL. The aircraft crashed 3/4 miles south of the airport in unpopulated, mountainous/hilly terrain at an elevation of 1560 feet, which is 104…NTSB ATL87DEG01Accident · No injuriesFinal reportCessna T210N · Cleves, OHThe plt reported that he initiated a go-around during an apch T0 a private strip. He stated that he misjudged the height of the acft and stalled it into trees and brush while climbing over rising terrain. He also said he was suffering from a cold and sinus…NTSB LAX87LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Hana, HIDuring a solo instructional flight, the pilot was attempting to fly a course directly over a 10,400 foot mountain. At the 5,200 ft level the pilot encountered turbulence and noticed a cloud build-up over the mountain. The pilot then decided to divert to the…NTSB LAX87DVA01Accident · Minor injuriesFinal reportRockwell S-2R · Dos Palos, CAAfter departing the field on his last spray application, the aircraft's left wing collided with an antenna guy wire located about 100 feet above the ground. The pilot attempted to return to the airstrip aprx five miles away. However, as he entered into a…NTSB ATL87LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172P · East Liverpool, OHRwy repair was in progress. The rwy was closed & battery powered lights were left to mark a 5 inch deep ditch that crossed the runway. Arpt & rwy lights were left off. The FBO continued to rent acft for operations from the arpt. The plt departed on a 28 mi…NTSB FTW86LA172Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Sulphur, OKThe acft struck a large bird at 2,500 ft MSL in cruise flt, which took out the windshield. The plt determined that he could not sustain level flt due to the increased drag and loss of lift and elected to execute an emergency landing in a pasture. During the…NTSB DEN86LA263Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Durango, COWhile flying low level inside a river gorge at 200-300 feet above the water, the balloon impacted a power line and fell into the river.NTSB MIA86LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, FLWhile on approach to runway the pilots vision was restricted by the glare from the rising sun. The pilot failed to see the operating approach light system which is located in the closed first 2000 feet of runway, and collided with the approach light system.…NTSB FTW86LA170Accident · Minor injuriesLimited investigationFinal reportRyan PT-22 · Kerrville, TXWhile arriving for a 'fly-ing' at an uncontrolled arpt, the plt of a PT-22, N48331, turned onto final apch after the plt of a preceding acft had turned off of the rwy. At about the same time, the plt of an unregistered ultralight gyrocopter taxied onto the…NTSB ATL86LA258Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Chardon, OHDuring final landing approach to runway 14, the sutdent pilot deployed spoilers and attempted to maintain altitude. The glider collided with trees and descended out of control to the ground 200 feet short of the runway. The student pilot had a total flight…NTSB BFO86LA046Accident · Serious injuriesLimited investigationFinal reportBalloon Works FF-7 · Roanoke, VAThe hot air Balloon was involved in an air show flight event. While enroute to the airport the plt stated that he encountered winds that forced him to land short of the arpt. During the lndg apch he became distracted by spectators on the ground who were in…NTSB FTW86LA167Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Norias, TXThe commercial plt was engaged in a livestock round-up and attempted to hover over a wire fence. The acft skid caught on the fence causing a loss of acft control and subsequent impact with the terrain.NTSB ATL86LA257Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Covington, KYThe plt landed at the airstrip on his fathers farm as the third stop of the day. He reported that during the attempted takeoff he hit a tree and stalled the acft. His student pilot certificate had been signed off for his first x-country flt the day prior to…NTSB SEA86LA243Accident · 1 fatalLimited investigationFinal reportGrumman G164A-450 · Orovado, NVPower lines were inadvertently struck in flight while maneuvering during aerial application. After striking the power lines the aircraft descended to the ground where a fire erupted and the aircraft was then destroyed by fire.NTSB LAX86LA342Accident · No injuriesLimited investigationFinal reportBeech A-36 · Visalia, CAThe airplane departed monterey airport, monterey, CA on a VFR night flight. The plt entered the downwind leg for runway 30 and observed an airplane depart on the runway at what she thought was about midfield. The airplane had departed from the runway…NTSB ATL86LA249Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Fuguay-Varina, NCPlt said he saw fog around rwy lights as he flew over airport to enter downwind leg for rwy 16. On short final, below level of trees that bordered rwy east side. He lost ground references. Flaps were retracted to reduce drag but acft was not accelerated to…NTSB ATL86LA247Accident · No injuriesLimited investigationFinal reportPiper PA-24 180 · Huntsville, ALThe stated purpose of this flt was a bfr for the plt. Both the CFI and the plt stated that the bfr part of the flt was complete and that the plt was practicing a short field landing when the accident occurred. The approach was too low and the left main…NTSB CHI86LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Dwight, ILThe tail of the aircraft struck the cab of a truck while on final approach. The CFI stated that, as they were passing over the road at the approach end of the runway, the aircraft entered a downdraft and the empennage struck the truck which was approaching…NTSB MIA86LA246Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Palmetto, FLThe CFI was demonstrating a simulated short field takeoff on a grass airstrip to his student. During the takeoff roll, the plt stated the acft was performing normally, but after lift-off, he was unable to climb out of ground effect. The acft collided with a…NTSB ATL86FA240Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Hampton, NHThe acft was flying at low alt in the vicinity of interstate I-95 when the plt made a 360 deg, rgt turn. After the turn, the acft collided with pwr lines, which crossed I-95, then crashed & burned. A witness estimated the acft had dscndd to about 35 to 50 ft…NTSB SEA86LA235Accident · 2 fatalLimited investigationFinal reportCessna 182D · Stibnite, IDAfter taking off in mountainous terrain, the pilot prematurely turned on course to a northerly heading, intending to cross over a ridge line. Shortly after the turn, and while flying up a drainage area towards rising terrain, he encountered a downdraft…NTSB SEA86LA229Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Tygh Valley, ORAn uncertificated plt was flying the acft at a low altitude when the acft struck wires. Due to the damage to the acft a forced landing was made onto a bark dump where additional damage occurred to the acft.