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 ATL85LA244Accident · No injuriesLimited investigationFinal reportCessna A188B · Benton, MSThe plt attempted to takeoff on the rwy a during takeoff ground run the acft lifted off prematurely and stalled into high vegetation. The plt stated that the grass on the runway should have been cut before it got too tall.NTSB CHI85LA338Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Pickett, WIThe fld where this accident occurred had been sprayed one week prior to the accident by a fixed-wing acft at an alt of 20 ft. no wires were noted to be a hazard at that time. On the day of the accident the plt of the helicopter was talking to a spotter on the…NTSB CHI85LA336Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Red Lake Falls, MNThe acft contacted wires during an aerial application flt. The plt stated he was maintaining extra alt to avoid tall weeds and the clearance below the wires was misjudged. The wires severed the vertical fin and rudder.NTSB MKC85FA177Accident · Serious injuriesField investigationFinal reportCessna A188B · Dodge City, KSThe plt was was making east & west runs over a milo field as he was dispensing parathion. He reported that he had been working under high voltage power lines each time he flew past the west edge of the field. He stated that on the last pass, the acft…NTSB NYC85LA198Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Quakertown, PAThe acft collided with wires during a lndg attempt. The acft was thrown out of control and dragged a wing after which it nosed over. The plt said that he thought the wires had been cleared. He was trying to put the acft right at the edge of the field because…NTSB ANC85LA140Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Anchorage, AKWhile the plt was approaching a field to land, the wind shifted & gusted, blowing the Balloon toward a light standard. The envelope grazed the standard, ripping the material near the top of the Balloon. The Balloon then landed in the field. The wind was…NTSB FTW85FA300Accident · 1 fatalField investigationFinal reportS.N.I.A.S. AS350D Astar · Houma, LAThe plt landed at a microwave antenna tower and did not shut down the eng or deplane. An employee at the tower retrievedcargo from the helicopter (a small box of parts) and went back inside the tower building. Shortly thereafter, the plt apparently initiated…NTSB SEA85LA176Accident · Minor injuriesLimited investigationFinal reportBeech A-24-R · Tuscarora, NVThe plt was attempting to land on a dirt road uphill at about 6,200 ft with gear and flaps down a go-around was attempted at about 50 ft AGL when the plt decided not to land. The acft failed to climb and a barn was struck before it hit the ground. The density…NTSB DEN85LTG04Accident · No injuriesFinal reportPiper PA-25 · Antler, NDThe left wing of the acft received substantial damage when it contacted trees during a pull-up at the end of a swath run. The plt then flew the acft to a fld aprx 1 mile away and a precautionary landing was made.NTSB DEN85FA196Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 7 · Brighton, COA hot air Balloon owned and flown by the plt collided with electrical power lines during an attempted landing. The basket of the Balloon caught fire upon contact with the wires. The occupants leaped from the burning basket sustaining serious injuries. The…NTSB LAX85FA328Accident · 2 fatalField investigationFinal reportCessna 150G · Columbia, CAOn July 21, 1985 at about 2115 hours p.d.t., Cessna 150, N2209J, registered to laurence p. thompson, auburn, California,and operated by sunshine flyers, inc., auburn, California, crashed after colliding with some trees about 1 mile north northwest of Columbia…NTSB CHI85LA312Accident · Minor injuriesLimited investigationFinal reportFrank H Marchetti Avenger Gyro Plane · Shelbyville, ILThe gyroplane was running up on the end of the rwy when the varieze landed on top of him, striking thr rotor system. The varieze flew a non=std flt pattern & did not make a radio call in the traffic pattern.NTSB MKC85LA162Accident · No injuriesLimited investigationFinal reportCessna A188B · Indianola, NEN4848Q was loaded to max gross wt and was taking off on a 2,350 ft, turf rwy. The plt said the wind was light and favored rwy 29 before takeoff. The density alt was about 2,500 ft. the plt said the acft did not seem to be developing quite the power it should…NTSB CHI85LA303Accident · No injuriesLimited investigationFinal reportBell 206BII · Farmington, MNDuring maneuvering to ld in an uncultivated fld the tail rotor struck a fence post,from a dismantled fence,that was concealed by high weeds. One tail rotor blade was separated,the pilot lost control,and on touchdown the helicopter rolled over.NTSB NYC85LA184Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Nantucket, MAThe acft was observed in a medium left bank turning through a south southwest heading as it appeared from the clouds. The acft continued to descend in that attitude until it collided with the trees about 3.5 miles southeast of the arpt. The plt and passenger…NTSB NYC85LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Gardiner, NYDuring the return flt to Gardiner, NY, the plt elected to fly along the walkill river. The acft contacted power lines which crossed over the river and came to rest inverted in aprx 1 1/2 ft of water. The plt stated he was unaware of the power lines and he did…NTSB CHI85LA299Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Falls, MNThe plt diverted into the Big Falls arpt because his original destination was below VFR minimums. After checking the sod runway for a firmness & determining a go/no go point, he subsequently took off using soft field techniques. His rotation was well in…NTSB SEA85FA171Accident · 2 fatalField investigationFinal reportPiper J3-C-65 · Goose Prairie, WAThe acft contacted trees while the plt was performing low level passes over a boy scout camp. Witnesses reported the plt made three passes over the camp and during one of those passes, the plt dropped a bag of candy bars to the scouts. The fourth, during…NTSB FTW85FA287Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Saginaw, TXThe helicopter had landed in the road to pick up an injured auto accident patient. The plt made an aerial check prior to landing to the west in a calm wind condition. The patient was loaded in a secure stretcher and all was ready for liftoff. The plt stated…NTSB DEN85LA190Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Thistle, UTThe plt had just completed an aerial spray mission and was flying through a canyon when the acft collided with pwr lines. Control of the acft was lost and it contacted the terrain.NTSB MKC85LA165Accident · Minor injuriesLimited investigationFinal reportde Havilland DH 82A · Ames, IAThe owner had given the plt permission to fly the acft & the plt elected to take a passenger in the front seat. After the accident, the plt stated that he was making a hi speed taxi run on the grass on the right side of the rwy. He reported that the lower…NTSB DEN85LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Kiowa, COThe acft collided with a telephone wire and crashed. The plt admitted he had been flying over a boy scout ranch at 7500 ft MSL (about 500 ft AGL). He could not recall any other details. One witness said he saw the acft cross in front of his pickup truck at…NTSB LAX85FA315Accident · 2 fatalField investigationFinal reportBell 206-B · Page, AZOn July 12, 1984, a Bell 206B helicopter collided with a steel bridge 10 miles so of Page, AZ. The helicopter was being filmed in flt during the making of a movie. VMC existed at the time. The helicopter was destroyed and the plt and pax, an italian actor,…NTSB DEN85FA186Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Aspen, COCFI and student departed Aspen, Colorado, on a dual x-country flt. The density altitude at the time of departure was calculated to be 9954 feet. The CFI directed student to fly up a canyon in an area of rising terrain. The CFI took control of acft and was…NTSB LAX85LA309Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Durham, CAThe purpose of the LCL flight was for the CFI to demo the newly acquired helicopter to its owner. The CFI reported that during the flt a 'somewhat common' vibration was detected, & he associated the vibration with the acft's wooden main rotor blades. He…NTSB FTW85LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Brownsville, TXWhile practicing touch-and-go landings the plt allowed the acft to descend below the proper glide slope while on final apch. The acft impacted a power line aprx 1000 ft short of the rwy and crashed on the side of a drainage ditch levee. The elevation of the…NTSB ANC85LA120Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe plt aborted his 1st attempt to takeoff due to boat & water ski activity. He back taxied & began a 2nd attempt on rough water. The acft became airborne at about the middle of the lake. It stopped climbing when the plt began to raise the flaps, so he…NTSB ANC85LA119Accident · No injuriesLimited investigationFinal reportHelio 250 · Anchorage, AKThe plt reported that he took off downwind with a heavily loaded acft. He estimated the wind was from the north at 4 gusting to 6 KTS. He stated that after climbing about 100 ft, the acft began to mush as he began retracting the flaps. Subsequently, it…NTSB ATL85LA204Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Owensboro, KYPilot launched Balloon from college campus with two pax. Flew for 35 minutes. During flight he radioed ground crew which was at landing site. During descent pilot saw utility wires previously unnoticed. Parachute was ventd to increase descent rate and avoid…NTSB LAX85FA304Accident · 2 fatalField investigationFinal reportMaule M-6-180 · Corona, CADuring a banner towing mission, the acft was observed flying at low alt near California state freeway 91. According to witnesses, the banner collided with power lines after the acft had crossed over the lines at a relatively slow speed. The banner & tow…NTSB DEN85LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Platte, SDWhile the plt was spraying a field, the landing gear of the acft struck the center pivot of an irrigation structure. Later, when the acft was landed, the gear collapsed.NTSB BFO85LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDAfter not obtaining surface wind info and not observing the wind sock, the student plt entered final apch without observing any significant drift. When the acft was at nose-up attitude. It floated and stopped descending for a few seconds. Suddenly, the plt…NTSB ATL85FA197Accident · 2 fatalField investigationFinal reportPiper PA-42 · Charlotte, NCThe acft collided with a tree and a pole short of the rwy during a night VFR approach to land. The plt changed from rwy 18 to 36 during the approach. He was seen low & fast on dwnwind which ended in a steep descending turn to ground contact. The twr had…NTSB CHI85FA253Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Reedsburg, WINo known witnesses observed the plt preflt the acft or takeoff. He departed in the evening while the arpt was not attended. At aprx 2012 CDT, his son observed & recognized the acft. At that time, the son was at his own home about 1/2 mi from the plt's home.…NTSB SEA85LA150Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Gustavis, AKWhile taxiing the float plane in a gusty x-wind, the wind & water current drifted the acft toward a parked boat. Subsequently, the left wing tip struck the boat & was damaged. But there was no damage to the boat.NTSB SEA85LA145Accident · Serious injuriesLimited investigationFinal reportCessna 310L · Albany, ORThe plt was attempting to bracket the low bar on the 2 bar VASI to avoid landing long on the rwy. On final, the acft landing gear struck unmarked powerlines. The acft then struck the ground in a level attitude. A small fire ensued in the left tip tank. The 4…NTSB ANC85FA107Accident · 1 fatalField investigationFinal reportPiper PA-18 · Lake Beverley, AKThe plt stated that he & his student plt was flying around the lake well below the tree line, & after a steep right bank the acft struck the trees & crashed in the lake, the acft sank into 10 to 12 ft of water.NTSB SEA85LA143Accident · No injuriesLimited investigationFinal reportCessna 172B · Imbler, ORDuring takeoff from a field (off arpt), the acft failed to clear a fence. The pilot then attempted to abort the takeoff, but the acft hit a bale of hay & nosed over. The plt's last medical certificate was dated 9/2/82.NTSB SEA85FA147Accident · 4 fatalField investigationFinal reportCessna C-177RG · Yakima, WAThe pilot, while in slow-flight configuartion, at low altitude, in light chop, failed to see and avoid trees. Resulting tree impact caused acft into stall conditions. Acft contacted other trees, crashed and burned.NTSB FTW85LA264Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Ville Platte, LAThe plt had rented the acft for a local flt and was observed by ground witnesses to have flown very low (50 ft AGL) over miller lake when the left wing struck a tree. The acft continued for aprx 50 ft in a left wing low attitude before striking another tree,…NTSB FTW85LA262Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Ship Shoal BlkThe pilot had landed on the offshore platform and was in the process of repositioning the helicopter to one side of the landing pad to provide additional space for another aircraft when the main rotor blades struck a 3' steel sign post. Theblade separated…NTSB MKC85LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Belgrade, NEFlight instructor giving private pilot a bfr. Bfr was nearly completed when ip gave pilot a simulated forced landing over his own farm strip. Pilot was making an excellent approach until the landing gear hit the barbed wire hidden in the high grass.NTSB MIA85LA192Accident · Minor injuriesLimited investigationFinal reportBell 206B · West Palm Beach, FLTwo helicopters had just completed a mail delivery operation as a flt of two. N159L had landed and the plt left the eng running so as to let the eng operting temp stabilize. N156L approached in a ground hover and collided with N159L. The two plts received…NTSB MIA85FA191Accident · No injuriesField investigationFinal reportAerospatiale SA316B · Silver Springs, FLThe plt of the helicopter on an on demand air taxi medevac flt encountered deteriorating wx conditions and attmepted to maintain VFR flt in IMC conditions. He descended and struck a tree causing substantial damage. He then made a forced landing and the…NTSB LAX85LA273Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Waipahu, HIAprx 1/2 hr into this dual instructional flt the acft struck unmarked high voltage pwr cables, entered an uncontrolled descent and struck the ground. One of the purposes of the flt was to practice emergency apch procedures. Both the instructor and the student…NTSB ANC85FA092Accident · No injuriesField investigationFinal reportBellanca 7GCBC · Anchorage, AKThe pilot in command executed a step turn resulting in his final takeoff path downwind which would have placed the airplane's flight path over the bank with the least obstructions, except for the small scrub tree. The airplane struck the small scrub tree and…NTSB MKC85LA126Accident · No injuriesLimited investigationFinal reportCessna A-188-B · Broadwater, NEAg plt reports that the acft would not climb fast enough after takeoff to clear tree stumps off the end of the runway at his ag strip. The density altitude was about 6,000 and the plt acknowledges that a lighter load would have allowed the acft to climb fast…NTSB DEN85LA159Accident · No injuriesLimited investigationFinal reportPiper PA-25-235-B · Lovington, NMThe plt attempted to take off to the east from a 1000-foot mowed alfalfa field at a field elevation of 3700 ft MSL. The plt estimated the winds to be from the southeast at 8 mph. The density altitude was computed to be between 6578 and 6871 ft MSL. According…NTSB CHI85FA226Accident · 1 fatalField investigationFinal reportSchweizer G-164A · Red Lake Falls, MNThe plt had been spray a field in north & south directions, then elected to make a swath run from east to west toward the sun. This pass was made late in the day. While on the swath run, the acft collided with an unmarked wire, then veered & crashed in a…NTSB DEN85LA146Accident · No injuriesLimited investigationFinal reportPiper PA-25-260-C · Ordway, COThe airplane departed the airport on an aerial application operation. Immediately after takeoff the pilot retarded the propeller control to climb setting and turned east. The pilot said he was aware of and saw power lines ahead. He said he advanced the…