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 NYC84FGM03Accident · Minor injuriesFinal reportBliss Corbin Baby ACE CM-1 · Emporium, PAOn final approach the acft struck several trees, the pilot lost control of the acft. The acft then struck telephone wires & a pole and crashed.NTSB MIA84LA134Accident · No injuriesLimited investigationFinal reportBell 47D1 · Berlin, GAThe plt collided with power lines as he turned to fly back to reload the acft. The plt made a statement that he did not see the wires in the trees. The plt did not file an accident report.NTSB MIA84FU004Accident · Serious injuriesFinal reportUnknown Easy Riser · Snead, FLThe ultralight collided with a high tension wire and crashed. The plt said he made a low pass to look at an auto and didnot see the wire in time to avoid the collision.NTSB FTW84LA195Accident · No injuriesLimited investigationFinal reportCessna 150 · Papalote, TXThe acft collided with a powerline while making a low pass over a local residence during a solo training flt. The plts recommendation for prevention is to 'use common sense.'NTSB NYC84FA137Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Marlboro, NJPilot and pax departing 2170 ft rwy at near max gross weight pax stated it didnt appear as if they were going to clear high tension power lines located about 2400 ft from rwy end. Pilot made left turn and impacted unmarked wires about 600 ft left of extended…NTSB LAX84LA252Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7 · Moorpark, CAThe plt reported that after completing the 2nd flt of the morning, he changed the fuel tank & acquired new passengers. He stated that during the 1st 2 flts, the Balloon had not drifted more than 100 yds from its point of lift-off. As the Balloon ascended on…NTSB NYC84LA133Accident · No injuriesLimited investigationFinal reportCessna T303 · Binghamton, NYPrior to the approach, the plt was advised of a thunderstorm sse of the arpt. The plt stated that the weather was deteriorating rapidly with turbulence, heavy rain, near-blinding lighting & windshear. During the approach, due to the adverse wx conditions &…NTSB FTW84FA189Accident · 4 fatalField investigationFinal reportAerospatiale AS 355F · W Cameron 540While the plt was taking off from an unmanned rig, the tail section of the helicopter contacted a rotating beacon support bracket on top of a crane structure. The crane structure was located below the elevation of the landing pad. The helicopter then crashed…NTSB CHI84FA148Accident · No injuriesField investigationFinal reportPiper Aerostar 600 · Pontiac, MIDuring an ILS apch, the acft collided with treetops while it was slightly left of the apch course near the middle marker. The plt continued to fly the acft to the rwy & the plane touched down about 1000 ft beyond the threshold. At touchdown, the acft veered…NTSB ATL84LA140Accident · No injuriesLimited investigationFinal reportCessna 172N · Winnsboro, SCThe acft was making a precautionary landing because the fuel guages were indicating 'empty'. Following touchdown the pltsaw a barbed wire fence and attempted a go-around & struck the fence. After making ground contact a second time the acftcontinued through…NTSB NYC84FA117Accident · 4 fatalField investigationFinal reportBeech C23 · Champion, PAN23968, crashed into trees shortly after takeoff from rwy 27 at seven springs airport. Plt told the resort manager of seven springs that he could not seem to get airborne & after he did get airborne he could not clear the trees. Investigation revealed the…NTSB CHI84LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · St. Ignace, MIThe pilot took off into adverse wx conditions & failed to attain sufficient altitude to clear trees. The purpose of the flight was to search for a missing acft.NTSB SEA84LA070Accident · No injuriesLimited investigationFinal reportCessna 150-K · Fallon, NVThe student plt said he was departing his privately owned strip & had a 7 ft fence to clear at the departure end. He reported that just as he became airborne, the acft encounter a gust of wind which caused the right wing to hit a fence post, then the acft…NTSB FTW84LA173Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Blanco, TXAccording to the plt, the acft was standing unattended with the eng running at 1000 RPM when an inexperienced person attempted to shut down the eng. He reportedly pushed the throttle in, instead of pulling it out & the acft jumped the chocks. According to 2…NTSB ATL84MA114Accident · 6 fatalMajor investigationFinal reportCessna 421B · Cullman, ALPlt cleared for night NDB rwy 19 apch to folwom field. Erratic radar track drg procedure turn and inbd intercept. Witnesses described 200 ft ceiling and reduced vis in fog at airport. Other witnesses observed acft on northbound course,followed by turn to west…NTSB ATL84FA115Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Spartanburg, SCThe acft collided with trees during a landing at a company helipad. The weather was IMC with low ceilings and fog. The acft had been cleared for a VOR approach monitored by radar. The co-plt spotted the pad and called it out to the plt who started a steep…NTSB NYC84FA096Accident · Serious injuriesField investigationFinal reportCessna A185F · Waitsfield, VTThe acft collided with trees during takeoff. The rwy was snow covered 4 to 6 inches deep and was only 1800 ft long. The takeoff was on a bearing of 130 degrees. The wind was from 280 degrees at 14 KTS. The skis on the acft had wheels protruding through at the…NTSB MKC84FA084Accident · 1 fatalField investigationFinal reportPiper PA-31P · El Dorado, ARThe acft crashed into trees 2 miles short of the rwy during an instrument approach in IMC weather. A plt in the right front seat said that just prior to impact, the acft was descending at 2500 fpm, & when he looked ahead, he saw trees. Hesaid he yelled at the…NTSB LAX84FA193Accident · 2 fatalField investigationFinal reportRobinson R22 · Thousand Oaks, CAThe helicopter collided with 2 cables supported by 150 ft tall twin towers. It then went out of control & crashed into a 15 ft deep drainage ditch & burned. The plt had been cited on 2/20/84 for 'careless & reckless operation of an acft.' Another person who…NTSB NYC84FU003Accident · 1 fatalFinal reportPanaplane Pappillon · Pepperell, MAThe airman took off on his first solo flt after one and one half hours of ground instruction and no flt instruction. Theflt proceeded after a normal takeoff to turn left at about 50 ft AGL to avoid a hanger. After a precise 90 degree turn, the acft continued…NTSB FTW84LA140Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Ada, OKThe acft collided with powerlines during a low level flt along the canadian river and fell into the shallow water. The plt who is a fireman said he had descended to observe a grass fire burning along side the river.NTSB DEN84LA092Accident · No injuriesLimited investigationFinal reportCessna T-210 · Duchesne, UTThe acft departed the side of the rwy during the landing roll. The plt stated that he could no determine where the center of the rwy was due to about 2 inches of fresh snow. The rt landing gear collapsed & the nose gear failed.NTSB MKC84FA077Accident · 2 fatalField investigationFinal reportCessna 414A · Mena, ARAcft cleared for Mena NDB apch and to maintain 5000 ft MSL until established on the apch. Acft descended to 4800 ft MSL on aprx grnd track of 040 to 030 deg after NDB passage. Acft then turned to a ground track of 116 deg. After 12 seconds the acft turned to…NTSB LAX84FUG01Accident · Minor injuriesFinal reportBellanca 8KCAB · Riverside, CAThe plt tried to takeoff from a grassy area adjacent to the paved rwy. The takeoff was hindered by high grass. Just after takeoff the acft collided with a fence and cartwheeled.NTSB LAX84LA166Accident · No injuriesLimited investigationFinal reportCessna 150M · Fremont, CAThe plt said he was doing a precautionary landing because he heard a 'pop' during a practice spin. During the landing the wing of the acft struck a tree. The acft was successfully flown back to the arpt and landed without further incident.NTSB CHI84LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · New Paris, OHThe acft collided with a power line while practicing an emergency approach to a field. The plt stated he struck the top wire of two wires strung about 30 ft AGL.NTSB NYC84FA078Accident · No injuriesField investigationFinal reportDassault Falcon 10 · Trenton, NJDistracted by an interruption in taxi and departure routines, the pilot reset his altitude alert controller to two hundred feet instead of two thousand feet, his ammended clearance altitude. Taking off on instruments in the dense morning fog, the alert system…NTSB LAX84LA160Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Santa Nella, CADuring a low level ag turn, the acft's left wing impacted an 8-FT high stand pipe. The acft then cartwheeled & crashed. A few weeks before the accident, the plt had personally inspected the field. However, just days before the accident, the standpipe had been…NTSB NYC84FA085Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Templeton, MAThe acft collided with trees on unlgtd terrain at ngt after making a low pass at aprx 60 ft AGL with the gear extended. Witnesses reported that the acft's clearance lights were not operating until the rwy lights were turned on, then they observed the acft's…NTSB CHI84LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Greenville, ILThe plt received a weather briefing the night before the accident and did not have it updated on the day of the accident. The acft was descended below the mda during the approach in fog and collided with high tension lines.NTSB ATL84FLT02Accident · Serious injuriesFinal reportPiper PA-22-150 · Memphis, TNThe acft struck a powerline and crashed 1.5 mi south of Memphis airport while on a ILS localizer app to rwy 36R. The wx at the time of acc was ceiling 200 ft, visibility 3/4 mile with fog. The acft was equipped with a VOR localizer, but no glide sloop…NTSB CHI84LA092Accident · No injuriesLimited investigationFinal reportBeech B-19 · Crystal Lake, ILThe acft hit a snow bank during an approach for landing. The plt added power and made a go-around. The CFI took control of the acft and made the final landing when the main landing gear collapsed.NTSB LAX84FA151Accident · 2 fatalField investigationFinal reportWells/Rand KR-2 · Santa Paula, CAWhile flying in an easterly direction, the acft collided with a 1/2 inch power line/ground cable, aprx 300 ft above the terrain. The impact occurred at mid-span. After colliding with the cable, the acft crashed & came to rest in an orchard. The sun was at an…NTSB LAX84LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Mendota, CAThe acft collided with a tractor while the plt was making a low pass over some workers in a tomato field. The plt said he was returning the rented acft when he decided to make a final check on the field workers before departing for the day. No evidence of any…NTSB LAX84LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · Oakland, CAThe acft collided with wires during a descent through the clouds. The student plt had found himself on top of an overcast and managed to descend through it but in doing so a power line was hit. The plt climbed back on top and continued to destination without…NTSB ATL84FA084Accident · 4 fatalField investigationFinal reportRockwell 690B · Greenville, SCAs the plt was making an ILS approach in IMC weather, the acft descended into trees & crashed about 1-1/2 mi from the rwy threshold. The descision height for this approach was 1316 ft MSL & was located less than a mile from the threshold.a controller said…NTSB ATL84FA083Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Attalla, ALDuring a VOR approach to land in IMC wx, the acft collided with a tree. The non-instrument rated plt had filed an IFR flt plan on this and other occasions even though he was not qualified. During this approach, the descent was continued past the mda of 960…NTSB SEA84LA043Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Aibirm, WAThe plt stated that the wind shifted during landing and the balloon touched down hard and lifted off again. With power lines ahead a decision was made to cross over but the balloon struck the lines. Several cables were burned through and the balloon was torn…NTSB FTW84FA115Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Davidson, OKThe acft struck high voltage powerlines while conducting aerobatic maneuvers. A witness stated that the acft pulled-up into a nose high maneuver, climbed to about 3000 ft AGL, appeared to slide backwards and enter a nose-down turning maneuver. Full power was…NTSB ATL84FA080Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300 · Basye, VAAfter the acft landed, slush was observed to have accumulated under the wings & lower aft fuselage & was freezing. The acft was parked with the tail facing the sun, but none of the arpt personnel noticed whether the sun had melted the ice. The plt indicated…NTSB FTW84LA416Accident · 1 fatalLimited investigationFinal reportCessna 210N · Plaquemine, LAThe acft was found by a hunter crashed in a heavily wooded swamp area aprx 10 months after the acdnt. The sole body fnd was beyond a condition of testing for toxicology or autopsy. The body was identified as a plt who was supposed to meet the owner of the…NTSB SEA84FU001Accident · Serious injuriesFinal reportEipper Quicksilver MX · Junction City, ORAccording to the plt, he was operating the ultralight between 50 & 200 ft AGL, when he experienced throttle control difficulties. He reported that while correcting the problem, his attention to the surrounding environment was reduced. When he returned his…NTSB LAX84LA131Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Watsonville, CAThe plt reported that he was making a swath run at the edge of the field when he apchd a standpipe. He applied control pressure to avoid the obstruction, but the outer 3 inches of the rotor blades struck the standpipe. The helicopter contacted the ground…NTSB FTW84LA106Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Corsicana, TXThe acft collided with wires shortly after takeoff as the plt maneuvered at low altitude. After the collision the acft flew for about 1/4 mile and crashed in an unimproved field on a farm. There was no passenger seat in the acft and the passenger was…NTSB LAX84LA123Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Melville Lake, CAThe acft landed hard during an aborted takeoff from a dry lake bed after the landing gear had snagged a tent. In preparing to leave the plt noticed a small tent on the lake bed. He believed he could overfly it on takeoff but the landing gear did not clear the…NTSB LAX84FA113Accident · 1 fatalField investigationFinal reportPiper PA 24-260 · Fontana, CAThe acft collided with a electrical power line tower at night during IMC weather. The tower was struck at 40 ft AGL. Theplt received a weather briefing for this flt and VFR flt was not recommended. No flt plan was filed. Witesses heard the acft fly over at an…NTSB NYC84FA059Accident · Serious injuriesField investigationFinal reportBeech A36 · Montoursville, PADuring takeoff roll the overhead courtsey light flickered. As the acft lifted off the right front cabin door opened & the light remained on. The plt advised the tower he would be returning to land & entered a right downwind leg for rwy 27AT 500 ft AGL. The…NTSB ATL84LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Indian Head, MDThe plt stated that shortly after departing dca, he encountered a small amount of rain that froze on the aircraft's windshield. He continued on to his destination and again encounter freezing rain when turning from base to final. He elected to make a…NTSB ANC84FA026Accident · Serious injuriesField investigationFinal reportBoeing 747-200F · Anchorage, AKAt 2359 the local controller cleared the flt to land on rwy 6R. At 0001 the ground controller cleared a state-operated pick-up truck onto rwy 6R for a tapley run. The ground controller stated that he requested clearance from the local controller to allow the…NTSB NYC84FA058Accident · 2 fatalField investigationFinal reportBeech T-34A · Stockton, NJPrior to the accident, the acft was observed in aerobatic type maneuvers. According to one witness, he saw the acft enter a descent after it had completed a roll maneuver. It was still in a steep descent when he lost sight of the acft due to trees. The acft…