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 LAX83LA184Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Delano, CAThe acft collided with a power line and trees while applying pesticide to an orchard. The pilot was flying into the rising sun and failed to see the power line which serviced an agricultural deep well.NTSB FTW83LA180Accident · No injuriesLimited investigationFinal reportCessna 150 · Donna, TXAccording to the student plt, he was practicing a simulated emergency landing & had aborted the approach when the acft banked to the left, went out of control & crashed. An investigation revealed that the acft hit a palm tree, aprx 60 ft tall, then came to…NTSB CHI83FA160Accident · No injuriesField investigationFinal reportGates Learjet 35A · Indianapolis, INThe aircraft struck trees one mile from the runway during an ILS approach to Indianapolis intl airport after a flight from chicago. The pilot successfully executed a missed approach and diverted to hulman regional airport, terre haute, IN, for an emergency…NTSB SEA83LA076Accident · No injuriesLimited investigationFinal reportCessna 150F · Anacortes, WAThe uncertificated plt had made several attempts to land when he struck a tree in the approach path with the right wing. The acft then left the area for a short period of time, returned & made what was described as a bumpy landing. The acft use was…NTSB SEA83LA074Accident · No injuriesLimited investigationFinal reportCessna 172G · Near Homedale, IDThe flt originated before sunset, but the student plt practiced in the local area until the onset of darkness. While attempting to land on his private strip, he made 2 go-arounds. On the second go-around, the acft collided with an electrical wire, then flew…NTSB ATL83LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Verbena, ALThe acft collided with a wire cable during a simulated emergency landing to an open field off the arpt. The pilot said he was flying locally and saw a field that looked large enough to land in so he reduced power to idle and was making a simulated emergency…NTSB MIA83FLA01Accident · Serious injuriesFinal reportCessna T188C · St. Augustine, FLThe plt reported that he had just completed east to west swath runs & turned toward the sun to trim the east side of the field. Also, he reported that his windshield was covered with spray mist which restricted his visibility. Subsequently, he did not see how…NTSB DEN83LA095Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA 315B · Craig, COThe helicopter was being used in a long line demonstration when the cable contacted a man on the ground and injured him. According to the pilot, after the acft was landed at the staging area, the field was briefed on helicopter operations for aprx 45 min.…NTSB LAX83LA165Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gorman, CAEncountering clouds enroute the plt descended to fly through the teton pass. After confirming a VFR check point, he commenced a climb. Shortly thereafter the acft struck a powerline.NTSB LAX83FJA05Accident · 1 fatalFinal reportMurrayair MA1B · Nr Lihue Arpt, HIThe acft collided with a tree during a turn-around while engaged in aerial application operations. The pilot had made a few runs over the same field until he exhausted his load. After landing and reloading he returned to the area to finish the job and on the…NTSB MIA83LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLA student pilot on a supervised solo flight in a Cessna 152 collided with a remote controlled model airplane during climb out through 400 feet. The acft was damaged but the pilot was not injured. The model airplane was being operated from an adjacent park, by…NTSB LAX83FA150Accident · 1 fatalField investigationFinal reportCessna 150M · Dos Palos, CAThe non-rated plt & a friend (also non-rated) took the acft without permission of the owner. They took off at night & made repeated passes over the city of Dos Palos, CA. After about 15 to 20 min, the acft was flown to the vicinity of a home belonging to the…NTSB CHI83LA143Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Irwin, OHThe plt circled the arpt to set up his landing pattern for rwy 14 with a left crosswind. On final at 60 KTS & full flapsthe stall warning horn came on with the acft drifting. The plt added power & removed carb heat. He also started to 'work' the flaps up 'a…NTSB MKC83LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenfield, MOThe plt reported that before landing he applied carburetor heat & extended full flaps. Reportedly, he made a steep approach to the 3000 ft, sod rwy. He said he overshot the 1st half of the rwy & touched down at about midfield. At this point, the plt initiated…NTSB LAX83FA138Accident · 2 fatalField investigationFinal reportMooney M20J · Chatsworth, CAThe acft collided with powerlines 177 AGL during flt in adverse weather. About 2 miles from the site of the powerline collision the acft had collided with hilly terrain about 500 ft higher than the powerline. The pilot had received a weather briefing and…NTSB SEA83FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Glenns Ferry, IDThe acft collided with wires and crashed during a low pass while it was being delivered to a repair station. The pilot was flying low to keep pace with his wife who was following in a car to transport the pilot after landing. Witnesses observed the acft…NTSB NYC83LA076Accident · No injuriesLimited investigationFinal reportBurkhart Grob G10Z Astir CS · Buena Vista, PAThinking that he might be lost in a wave above the clouds, the plt descended through an opening & decided to make an off-field landing. Severe wind gusts altered his glide path & he headed toward an apple orchard. The left wing contacted a branch about 10 ft…NTSB CHI83LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Garden City, MNThe pilot elected to land to the west on a blacktop road. After touchdown, he initiated a go-around. During the go-around, the aircraft collided with the top wire of a power line on the right side of the road and crashed. The pilot estimated that the wind was…NTSB ATL83LA134Accident · No injuriesLimited investigationFinal reportCessna A188B · Wadley, GAThe pilot had been using a paved road for a landing strip until someone complained. He then changed to a north- south dirt road with trees on the west side and utility wires and poles on the right side. While landing with a left crosswind at about 16 gusting…NTSB ANC83LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Pedro Bay, AKThe acft collided with trees during an attempted go-around after an aborted landing on a frozen lake. The pilot landed toward the village and found the braking action on the snow covered ice was non existent. A go-around was attempted but not enough altitude…NTSB FTW83FA144Accident · 1 fatalField investigationFinal reportCessna 172N · Mayflower, ARThe acft collided with trees while flying in a westerly direction near Mayflower, AR. The acft was returning from a cross-country at night and was observed by a group of youths who said it was flying fast at low alt. As they watched, it descended to about…NTSB ATL83FA129Accident · 2 fatalField investigationFinal reportBeech K35 · Birmingham, ALThe acft collided with trees and terrain during a practice localizer approach at night to rwy 23 at Birmingham municipalarpt. The weather was VMC and the pilot was not instrument rated. On approaching Birmingham from tri-cities, NC the pilot asked for a…NTSB SEA83FA060Accident · 1 fatalField investigationFinal reportGlasair SH-2 · 5 Nm E. Of Kent, WAThe homebuilt acft collided with powerlines on final approach and crashed. The pilot was on a flight from one airport toanother to demonstrate his acrt to other builders of the acft. He was observed to enter the pattern and fly a low base leg and final…NTSB ATL83LA125Accident · No injuriesLimited investigationFinal reportRockwell 112A · Chestertown, MDThe aircraft settled back to the right of the runway during takeoff and struck an old stanchion used for runway lights. The pilot was unsure of the extent of damage and elected to re-land the aircraft. The landing gear had already been raised, so the landing…NTSB FTW83FA134Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · La Grange, TXThe plt elected to takeoff to the north on a downsloping paved road. He reported that the wind was variable from the southwest at 2 to 4 KTS, gusting 4 to 6 KTS. At austin, TX, the wind was from 190 deg at 13 gusting 20 KTS & at college station, TX, it was…NTSB FTW83LA135Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Muskogee, OKThe passenger was in the back seat with a 35 mm camera, a pocket camera, a pair of binoculars in a case and a windbreaker. While flying at dusk, they flew by a herd of deer, but the passenger did not get a photograph. Reportedly, the plt made a 180 deg turn &…NTSB LAX83FA120Accident · 1 fatalField investigationFinal reportAyres S2R-R3S · Kerman, CAThe acft returning from a spray mission collided with a tree and crashed near the pilots home. The pilot made a low passover his house to let his wife know he had returned. He made a spray run over his own vineyard and collided with a largetree while pulling…NTSB CHI83FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Beloit, WIReportedly, the plt had not flown for 2 or 3 months before his flts on 2/27/83. On that day, he took off & made 5 touch-and-go landings, then stopped for a cup of coffee. The plt then departed again on a 2nd flt. Aprx 1/2 hr later, smoke was observed from the…NTSB ANC83LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe plt reported that while he was flying in a canyon, up cub creek, he encountered unanticipated turbulence. He decided to make a 180 deg turn & leave the canyon. However, while making a left turn, the right wing of the acft struck a tree. Subsequently, the…NTSB FTW83LA145Accident · No injuriesLimited investigationFinal reportCessna 152 · Manor, TXDuring a biennial flight review, the private pilot began a crosswind landing on a 30 ft wide runway. As the pilot started to flare, the aircraft began drifting to the left. The instructor (CFI) reported that he waited too long to take control or initiate a…NTSB FTW83LA130Accident · No injuriesLimited investigationFinal reportCessna 182R · Flatonia, TXThe acft collided with a power line while the plt was making a low apch over a private strip. The top 3 inches of the vertical stabilizer was cut off. The plt did not realize the acft was damaged & landed without further incident.NTSB ATL83LA120Accident · No injuriesLimited investigationFinal reportCessna 421 · Dayton, TNThe Cessna 421 collided with trees during the landing approach while on a corporate flight. The weather was IMC at the accident site and the acft was on an IFR flight plan. The acft was substantially damaged but the pilot was not injured. The acft contacted…NTSB LAX83LA115Accident · No injuriesLimited investigationFinal reportGrumman G164A · Mendota, CAThe acft collided with wires and crashed during and aerial application flight. The acft stalled after hitting the wires with the left wing and was out of control when it hit the ground and nosed over. The pilot said he had 3 miles visibility. He was also…NTSB DEN83FTK03Accident · Serious injuriesFinal reportBeech V35A · Sioux Falls, SDDuring an ILS approach to rwy 3 the acft collided with 50 ft powerlines 3 mi sw of the arpt. The acft then collided witha mobile home & pickup truck. Half of the 60 ft mobile home & the truck were destroyed. Minimum altitude at the lim, located 5.2 mi from…NTSB ATL83LA104Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Pickens, SCThe acft collided with two birds while cruising at 6000 ft MSL. The weather was VFR but the acft was on IFR flt plan. The acfts left wing was damaged but there were no injuries. The plt stated that although he heard a thud on the left side of the acft he was…NTSB CHI83FA114Accident · Serious injuriesField investigationFinal reportPiper PA-44-180T · Indianapolis, INDuring an ILS apch to rwy 22R, apch control asked the plt to keep his speed up as much as practical. At a later inter- view, the plt could not remember details of the apch. He recalled putting the gear down at the outer marker (om) & using the autopilot to…NTSB FTW83LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Hennessey, OKWhile on a short final to land at a private ag strip, the acft struck power lines, then flipped over & impacted on the apch end of the rwy. Although the plt was unfaamilar with the arpt, she had been briefed on the existance of the wires before her departure.…NTSB CHI83LA112Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Three Oaks, MIThe acft collided with a wire during the landing approach and landed hard enough to collapse the nose gear. According to the owner the flt was not authorized and the person at the controls held no pilot certificate. The pilot made the following statement, 'I…NTSB CHI83FA108Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Reedsburg, WIThe acft impacted a quonset-type bldg while apparently on an unusual type approach for landing. One witness observed theacft make a low south to north pass over the rwy & then pull up into a loop that culminated in the quonset impact. Another witness observed…NTSB FTW83LA113Accident · No injuriesLimited investigationFinal reportCessna R182 · George West, TXThe plt reported that after he touched down on a wet grass runway, he was unable to stop, so he elected to go around. During the go-around, the gear collided with a fence, and subsequently, the acft crashed into trees and a building.NTSB FTW83LA106Accident · No injuriesLimited investigationFinal reportRobinson R22 · Stillwater, OKA simulated autorotational landing was initiated at about 450 ft AGL. During the approach, a 90 deg arc was flown toward an open field. A flare was begun with a power recovery at about 40 ft AGL when a wire was observed in the flight path. By this time, the…NTSB FTW83AA104Accident · No injuriesFinal reportCessna 550 · Houston, TXAfter landing on rwy 31L, the aircrew of N100VV requested clearance to turn off to the right at midfield onto rwy 22. The request was approved & the aircrew was instructed to use caution for a cherokee proceeding from the opposite direction. The plt of N100VV…NTSB LAX83FA087Accident · Minor injuriesField investigationFinal reportBell 47G4 · Five Points, CAThe pilot was on his final pass of the operation. He flew under 2 sets of wires but failed to see a third set. The spray boom caught on the the wire pitching the helicopter nose down. The main rotor hit the tail boom and the helicoptercrashed into a canal.NTSB SEA83LA049Accident · No injuriesLimited investigationFinal reportCessna A188B · Medford, ORThe aircraft collided with a tree during aerial application operations. The pilot stated that there was a powerline at one end of the orchard he was spraying and a row of leafless trees at the other. One of the taller boundary trees was overlooked by the…NTSB NYC83FA054Accident · 4 fatalField investigationFinal reportCessna 310R · Atlantic City, NJThe flt proceeded routinely from chicago to Atlantic City. Communications and procedures all seemed routine and normal and at 1901 local control at Atlantic City informed the pilot that he was one mile out and should be picking up the 'rabbit' momentarily. At…NTSB MIA83LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Riverview, FLAccording to the pilot he lost control of the acft after a bird hit him on the right temple while flying at about 15 feet above the water. The acft was traveling at about 50 mph when the bird flew in through left door opening. The pilot lost control of the…NTSB FTW83LA098Accident · No injuriesLimited investigationFinal reportCessna 172N · Carlsbad, NMThe plt landed in a short, level area near a drilling rig site at an elevation of aprx 3300 ft. he stated that he previously stepped off the 960 ft takeoff area. He stated that he lifted off at about 58 KTS, but the plane seemed to hit turbulence and the…NTSB NYC83FHA03Accident · Serious injuriesFinal reportPiper PA-22-135 · New Hope, PAThe acft collided with a power line while the pilot and a friend in another plane were flying along the deleware river. The plt reported that as he approached a bridge, he climbed to clear over the bridge and some power lines, then started to descend. He…NTSB FTW83FA079Accident · 2 fatalField investigationFinal reportMooney M20E · Cushing, OKThe acft collided with a powerline during a low flt down a river. The acft impacted 3 high tension cables spanning the river. Witnesses said the acft was flying low and fast. The collision produced a sound 'like a gunshot' and the acft fell to the ground and…NTSB MKC83LA053Accident · No injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-B · Greenwood, MOThe student plt/owner was being instructed by a free Balloon plt with a commercial certificate. According to the commercial plt, the Balloon had been inflated, but the air was still not hot enough for flt, and the wind blowing over the envelope created a…