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 CHI85LA049Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wild Rose, WIThe plt stated that he was flying at 500 ft AGL over an open marsh that is surrounded by higher terrain covered with pine trees, looking for his father who was hunting in the area. The plt continued to state that he became preoccupied with trying to identify…NTSB CHI85FA050Accident · 2 fatalField investigationFinal reportNorth American P-51D · New Haven, MIThe acft, a North American P51D, crashed into a potato field after striking an electrical wire running at a rt angle to the ground track, struck the ground, a building & disintegrated. The plt & owner of the acft was a 50 yr old ex-naval aviator with…NTSB ATL85LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Luray Caverns, VAThe acft was landed on a inadequate field during a simulated forced landing that became a real emergency because the fltinstructor cut the mixture to off. The CFI took over the landing at the last part of the approach and told the student to restart the…NTSB DEN85FA027Accident · 4 fatalField investigationFinal reportBell 206B-11 · Bingham Canyon, UTPilot was taking passeengers on a sightseeng flight over the kennecott copper mine, largest open pit copper mine in the world. Helicopter collided with unmarked power lines approx 185 ft AGL. Power lines are supported by two unmarked towers on opposing hills…NTSB DEN85LA024Accident · No injuriesLimited investigationFinal reportCessna 185C · Williston, NDThe acft collided with a bridge during an aborted takeoff after failing to get airborne. The plt aborted the takeoff butthe acft failed to stop in time to avoid a collision with a railroad bridge abutment made of concrete. The plt stated that the acft had…NTSB MKC85FA017Accident · 1 fatalField investigationFinal reportPiper PA18-150 · Omaha, ARWitnesses stated that the acft was overflying a portion of tablerock lake near the marina that the plt had intentions of purchasing. The acft struck an unmarked power line that was strung aprx 85 ft above the lake. The acft collided with the water and sank.…NTSB CHI85LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Pillager, MNThe plt took off uphill on a grass rwy that was dew covered. The field was aprx 1600 ft long bordered by 50-75 ft trees. The plt stated that during takeoff roll the acft lights were flickering. He said that the acft was airborne aprx 300 ft before reaching…NTSB SEA85LA014Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Lakeside, ORThe acft collided with power lines during a takeoff from a remote logging camp. The plt reported hearing a loud bang during takeoff. He said that the acft pitched right and nosed down. 'The acft spun to the right without power. The acft came to rest…NTSB NYC85LA023Accident · No injuriesLimited investigationFinal reportBeech BE-55E · Groton, CTAs the acft broke out of the 300 overcast layer the plt saw birds flying off of the rwy threshold. Due to IFR conditions and low altitude the plt elected not to go around. The tower advised the plt of the birds on 2 mile final on the ILS apch.NTSB MIA85FA023Accident · 2 fatalField investigationFinal reportBeech C23 · Crestview, FLDuring arrival, the plt was cleared for an ILS apch. The reported wx at that time was: 600 ft overcast, visibility 7 mi, wind 010 deg at 6 KTS. The plt stated that during the apch, he felt a downdraft that caused the acft to bank to the left & pitch down. The…NTSB FTW85LA035Accident · Serious injuriesLimited investigationFinal reportBeech 95-A55 · Sonora, TXPilot stated that he intended to land at Sonora, TX, but patchy ground fog obscured the arpt. He circled the aprt one time and then departed northward. He turned back to attempt another visual approach to the arpt when the aircraft struck a tree on the…NTSB ANC85LA019Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKThe plt stated during two telephone interviews that he hit trees during takeoff and then continued his two hour flt to to the homer arpt. The left wing was damaged and both left and right sides of the horizontal stabilizer were crushed andbent up about 19…NTSB LAX85FA036Accident · 2 fatalField investigationFinal reportBell 206B · Beaumont, CAApproximately one min before the accident the pilot contacted the tower at norton air force base for clearance through their traffic area. He reported initially that he was at 300 ft AGL. Seconds later he transmitted that he was at 100 ft over the freeway.…NTSB FTW85LA033Accident · No injuriesLimited investigationFinal reportStinson 108 · Sandia, TXThe plt was attempting a night landing at an unlighted airport. Plt stated he elecuted a low angle approach, knowing of elevated and wooded terrain off the end of the runway. On sighting trees to his left, he initiated a go-around but struck other trees…NTSB CHI85FA036Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · North Freedom, WIAt an early morning predeparture wx briefing the pilot was advised of deteriorating afternoon wx pilot flew cross country conducted business and departed late afternoon with no wx brief no flt plan departure area and destination both reporting IMC while…NTSB CHI85FA035Accident · 2 fatalField investigationFinal reportGulfstream 690C · Wooster, OHWhile on final approach to rwy 09 the acft struck a 42 ft power pole with the right wing. The wing was torn from the acft. The acft landed inverted 400 ft east of the pole. The rwy threshold lights are displaced 165 ft from the rwy end for night operations.…NTSB NYC85FA015Accident · 2 fatalField investigationFinal reportEnstrom 280C · Butler, PAThe helicopter struck the static line of a high voltage transmission line while on a flt to photograph an apartment complex. The owner of the complex accompanied the plt on the flt, there after the acft was to be used for passenger sightseeing flts as part of…NTSB FTW85LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hinton, OKDuring takeoff on an instructional flt with a CFI aboard, the acft struck a grain wagon. The CFI stated that on takeoff, the student lifted off prematurely and the acft struck the parked vehicle. The CFI took no corrective action.NTSB BFO85FA003Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Washington, DCAfter a high & fast apch, acft touched down beyond midfield on rwy 36 at dca. Plt delayed initiating a go around until he was sure the acft would not stop in the rwy remaining. On initial climb the acft struck two apch lights at the departure end of the rwy,…NTSB FTW85LA024Accident · 1 fatalLimited investigationFinal reportBeech 58P · Beeville, TXWhen the plt called the fss at 1426 EDT & filed an IFR flt plan, the fss person began providing a wx briefing. The plt interrupted the wx briefing & said he would check back later. He called back at 2016 EDT, but talked to another briefer & only asked for…NTSB BFO85FA002Accident · 4 fatalField investigationFinal reportPiper PA-32R-301 · Salisbury, MDAfter contacting millville fss 4 times for wx info the acft departed lincoln park, NY, at 1858 EDT with destination listed on the IFR flt plan as easton, MD. En route the plt diverted to Salisbury, MD, due to wx. After being cleared forthe rwy 32 ILS the acft…NTSB MIA85FA016Accident · No injuriesField investigationFinal reportBell 47G-5A · Belle Glade, FLAcft wad parked with 3 ft clearance between main rotor and corner of hangar. Plt stated that on lift off a gust of wind blew acft toward hangar. Main rotor blades made contact. Ground crewman injured by flying debris.NTSB CHI85LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Lake Village, INThe plt reported that he was on final apch to land on a wet, sod rwy when he noticed a flock of geese over the apch end. He added power to fly over the geese then proceeded to touchdown further down the rwy than what he had planned. Due to his speed & the wet…NTSB CHI85LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Dodgeville, WIThe plt attempted a landing on rwy 30 which is 85 ft higher in elev at the approach end of the rwy than the departure end. This was the plt's first flt to this arpt. The acft touched down further down the rwy than intended so the plt applied pwr to abort the…NTSB ATL85LA017Accident · Minor injuriesLimited investigationFinal reportBell 222 · Pascagoula, MSThe acft sustained substantial damage while taking off from a barge during a FAR 135 medevac flt. Investigation revealedthat the barge was pitching due to rough seas. As the acft lifted, the rear of the acft was struck by the landing platform as it pitched…NTSB ANC85LA008Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Theodore River, AKThe acft crashed during a go-around attempt at Theodore River located 35 miles southwest of anchorage, AK. According to the plt, after landing on a gravel oil pad he realized that the acft would not stop before going over the edge into a swamp. He applied…NTSB ANC85LA005Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Wasilla, AKDuring final approach the acft struck an unmarked staic wire 40 ft AGL and more than 75 ft from intended touch down. The pilot lost control of the acft. The acft landed on a parked acft during the descent.NTSB NYC85LA009Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Ono, PAAfter a lndg practice flight, solo student plt returned to home field at dusk. First lndg attempt resulted in overshoot and go-around. Since winds were calm, plt elected to land on reciprocal runway due to clear overrun area. This necessitated on obstacle…NTSB CHI85LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · St. Cloud, MNThe plt stated that his ground speed was too fast during a landing due to no wind. During the go-around the acft collided with tree tops & crashed. The plt reported that he delayed his decision to perform a go-around.NTSB ATL85FA008Accident · Serious injuriesField investigationFinal reportCessna 150L · Cumming, GAThe arpt manager observed the acft start a go-around about 2 ft above the rwy with full wing flaps extended. Flaps remained full down as the acft attempted to climb before colliding with trees aprx 1/4 mi from the arpt. According to the plt, the go-around was…NTSB DEN85FA007Accident · No injuriesField investigationFinal reportBell 206B · Cheyenne, WYThe helicopter's tail rotor section contacted a pwr line during an attempted takeoff. A section of tail rotor blade tipwas found beneath the pwr lines. The pilot reported a vibration in the tail rotor control pedals. He attempted a landing into an open field.…NTSB DEN85LA005Accident · Serious injuriesLimited investigationFinal reportPiccard AX6W · Albuquerque, NMPlt stated he observed the wire about 3 secs before collision. Electrical short circuit severed load cables to basket, which fell to the ground, causing personnel injuries. Balloon envelope drifted away, finally coming to rest 150 mi from accident site.NTSB NYC85LA008Accident · Minor injuriesLimited investigationFinal reportGrumman American AA5A · Corinth, NYDuring an aprx 45 min flight the plt became disoriented and flew an apch to a sod area that he mistakenly identified as his desired dest. During the apch the acft contacted wires causing the acft to descend out of control into a river.NTSB NYC85LA004Accident · No injuriesLimited investigationFinal reportCessna 150H · Batavia, NYPlt stated en route time was longer than anticipated. On arrival at destination, deep dusk conditions combined with haze, restricted ground reference cues. In addition, plt stated he misread the altimeter. Acft collided with trees 1 mile short of runway. Plt…NTSB FTW85LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Luling, LAThe plt stated that on final approach a gust of wind carried the acft to the right of the runway. Acft right wing struck a tree. Acft yawed right and contacted ground in uncontrolled flight.NTSB ANC84FA194Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Wasilla, AKAcft contacted pine trees while turning base to final apch to land. Plt stated all he remembers is trying to activate the plt controlled rwy lights but never seeing them illuminate. Another plt who landed just prior to N1260A'S attempt stated the airstrip was…NTSB MIA84LA264Accident · Minor injuriesLimited investigationFinal reportCessna 152 · La Belle, FLThe student plt was making a go-around because of a wind gust and said he added 'some power' and retracted the flaps butthe acft continued to drift left until it collided with the trees to the left of the rwy at about midfield.NTSB LAX84LA501Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Borrego Springs, CAAfter landing, the plt hover taxied to the fuel pumps to refuel. While maneuvering to touch down at the pumps, the main rotor blade struck a 10 to 12 ft high vent pipe. The plt reported that the vent pipes were painted black & were not readily apparent with…NTSB DEN84FTM04Accident · 1 fatalFinal reportRolladen-Schneider LS3 · Brigham City, UTThe acft impacted on a mountain ridge during a 60 deg left bank. The plt had been in radio communication with another glider plt near his flt area. Just prior to the accident he radioed that he was going around a mountain point in search of a thermal. When no…NTSB MKC84FA285Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Wilmot, ARWitnesses stated, acft was seen circling over farmland and during the third circle it descended toward a brick house. The acft was seen to pull-up at which time it contacted the top of a sycamore tree in a left bank. The acft continued an additional 230 ft…NTSB DEN84FA303Accident · 1 fatalField investigationFinal reportPiper PA-31-310 · Paonia, COThe acft was flying at a very low alt over mountanous terrain. As the acft approached a crest of a ridge the acft started to buffet and then encountered a downslope wind condition. The combination of approaching a stall and encountering a downdraft forced the…NTSB LAX84FA498Accident · Minor injuriesField investigationFinal reportCessna 172Q · Prescott, AZDuring a descent to the 5,042 ft elevation arpt the acft impacted the trees and mountainous terrain at the 7,000 ft level. According to the pilot, with the hooded student pilot at the controls, the flight began it's descent from 10,500 ft 30 miles from the…NTSB FTW84FA408Accident · 2 fatalField investigationFinal reportCessna 172P · Webbers Falls, OKAcft struck electrical transmission line 80' above water while flying under the line during a wildlife survey. The acft's mission was to conduct a duck count along a river in a nat'l wildlife refuge which required low, slow maneuvering. The ex-ag pilot was…NTSB ATL84FA297Accident · 2 fatalField investigationFinal reportBell 206B · Kernersville, NCWhile dismantling a water tower, an iron worker was seriously injured & pinned as he was removing a portion of a water tower leg (aprx 92 ft AGL). The helicopter plt responded to the emergency. The acft was equipped with a make-shift sling line to retrieve…NTSB ANC84FA189Accident · No injuriesField investigationFinal reportCessna 188 · Chugiak, AKThe plt stated the acft was covered with ice but he removed the majority of it before taking off. The acft contained a 200 gal load of fuel in the hopper. The plt stated the acft accelerated slower than normal and the takeoff ground run was long. He stated…NTSB LAX84LA488Accident · Serious injuriesLimited investigationFinal reportBell 206B · Paso Robles, CAPlt stated that after receiving a special VFR clearence he took off to spray a nearby field. He continued to state that he 'made a couple of circuits over the field, observed the telephone wires and began spraying. After performing 2 or 3 passes I hit some…NTSB LAX84FUJ04Accident · 1 fatalFinal reportWeatherly 620 · Waddell, AZThe acft collided with a power line during a spray operation. Witnesses said the acft flew under a power line and as it pulled up collided with a line which angled off of the main line. The vertical stabilizer and part of the rudder separated. The acft nosed…NTSB LAX84FA481Accident · Serious injuriesField investigationFinal reportPiper PA-28-236 · Santa Paula, CAAfter departing rwy 22 at Santa Paula arpt, the acft flew sw along the Santa clara river + struck a telephone wire 2.6 sm from the rwy end. Witnesses saw acft fly level at about 8O ft AGL with normal power sounds prior to wire contact. Thewire strike caused…NTSB ANC84FA176Accident · No injuriesField investigationFinal reportCessna 170B · Anchorage, AKPlt stated takeoff was slow and acft could not clear on-coming rising terrain and obstacles. Left wing contacted 100 ft tall tree tops aprx 2500 ft from departure end of rwy yawing acft 180 degrees from direction of flt. Plt failed to perform weight and…NTSB MIA84LA252Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T15 · Climax, GAThe plt said he was familiar with the area and was aware of the power line but misjudged his clearance and inadvertantlycollided with the top wire. The wire broke and wrapped around the landing gear of the acft and dragged it down. The acftwas destroyed when…