NTSB investigations, 1987
123 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 290 |
|---|---|
| 1983 | 222 |
| 1984 | 210 |
| 1985 | 187 |
| 1986 | 159 |
| 1987 | 123 |
| 1988 | 135 |
| 1989 | 122 |
| 1990 | 141 |
| 1991 | 146 |
| 1992 | 143 |
| 1993 | 163 |
| 1994 | 124 |
| 1995 | 139 |
| 1996 | 110 |
| 1997 | 111 |
| 1998 | 105 |
| 1999 | 116 |
| 2000 | 109 |
| 2001 | 130 |
| 2002 | 105 |
| 2003 | 87 |
| 2004 | 72 |
| 2005 | 80 |
| 2006 | 79 |
| 2007 | 77 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1987
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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 year(c."eventDate") = 1987 AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 ATL88FA056Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Anniston, ALThe VFR pilot continued the flight into deteriorating weather conditions and attempted to descend below the lowering clouds until the aircraft was too low to turn around safely and return to VFR flight conditions. The aircraft collided with trees and struck…NTSB DEN88FA036Accident · 1 fatalField investigationFinal reportCessna A152 · Benson, AZAbt 20 min after tkof, the acft crashed in VMC conds, aprx 26 mi along the route fm tucson to las cruces. Initial impactoccurred with the l wing hitting the top of a yucca plant as the acft was in a slgt nose down, l wing low attitude. Justbyd this point, the…NTSB DEN88LA035Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newell, SDThe plt reported that he was surveying a field of winter wheat at approximately 100 feet AGL in slow flight. The wind was strong and gusty and the acft began to settle toward the ground. The plt added full power, however, the left main landing gear struck the…NTSB LAX88FA061Accident · 2 fatalField investigationFinal reportPiper PA-11 · San Marcos, CAThe 2 plts took off on an instructional flt which was to be a biennial flt review for the acft owner. During the flt, the plts flew to a dirt strip on a saddleback between 2 mtn peaks near San Marcos. Subsequently, the acft struck a boulder & crashed near the…NTSB SEA88LA022Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Las Vegas, NVDuring practice autorotation the pilot flared excessively high and the tail boom struck the ground. The pilot then lost control of the aircraft. The density alt was 2616 feet. A rt quartering tailwind was present.NTSB SEA88LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sequim, WADuring dark night visual meteorological conditions, the aircraft struck trees while in cruise flt at about 2,000 feet MSL. Although the pilot had requested VFR traffic advisories, he did not solicit the use of the low altitude alert system. This system was…NTSB MKC88FA018Accident · 1 fatalField investigationFinal reportCessna 310Q · Augusta, KSThe airplane departed to the south and made a left turn. Approximately 1/4 of a mile east of the airport, the airplane impacted straight down with gear down and flaps at 15 degrees. No preimpact problems were found with airframe or powerplants. No indication…NTSB CHI88LA028Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Belle Plaine, MNAfter the acft was in the traffic pattern, the instructor (CFI) initiated a simulated forced landing. Just before touchdown on final apch, the student (a rated pvt plt) allowed the acft to drift to the right. The CFI attempted a go-around, but was delayed in…NTSB LAX88FA045Accident · 2 fatalField investigationFinal reportCessna 441 · Mexicali, MexicoA Cessna 441 operated by the uscs collided with terrain while on a authorized night tactical flight. The copilot did not meet the currency standards as required by uscs and was not qualified in the acft. The flight originated during the daylight hours and…NTSB LAX88LA026Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Willcox, AZThe plt reported that the takeoff ground roll was unusually long. After liftoff the acft stayed in ground effect until just before the end of the rwy then climbed to aprx 100 ft. the plt landed in a soft field. During the landing roll the acft nosed over.…NTSB NYC88FA032Accident · 2 fatalField investigationFinal reportBeech F-33A · Forked River, NJThe pilot and passenger departed white plains, new york on a VFR flight to kill devil hills, north carolina. Search efforts were initiated when the aircraft failed to arrive at its destination. A witness in a hunting camp near the crashsite saw the aircraft…NTSB LAX88LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · San Jose, CAWhile flying 500-600 feet above the terrain on a local pleasure flight, the pilot turned into what he believed to be an open ended canyon. After becoming aware that he had inadvertently turned into a box canyon, the pilot attempted a 'chandelle turn' to exit…NTSB DEN88LA017Accident · No injuriesLimited investigationFinal reportPiper J5A · Devils Lake, NDA commercial plt was giving instruction to another commercial plt with a CFI rating. Witnesses observed the aircraft at approximately 100 feet over a water fowl production lake. The plt stated that during a turn and pull up, the engine lostpower and the…NTSB DEN88FA016Accident · 3 fatalField investigationFinal reportBeech A-36 · Mitchell, SDThe acft had been cleared for the VOR approach at Mitchell municipal arpt at approx 1915 CST. The acft collided with the ground in a slight nose down attitude about 12 miles northwest of the arpt at the point where the procedure turn intersected the inbound…NTSB LAX88FA023Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Red Bluff, CAThe pilot was asked to move his aircraft from a private airstrip on which he had landed without prior approval. As the aircraft climbed after takeoff the pilot made a left wingover, reversed course and buzzed the runway at an elevation of about 30 - 40 feet.…NTSB FTW88LA013Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Brownsville, TXWhile circling an unlighted private airstrip, the pilot allowed the aircraft to descend into 2 feet of water causing substantial damage.NTSB DEN88LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260C · Timberon, NMOn takeoff with a 10 to 15 knot tailwind and 10 degrees of flaps, a 20 degree turn was attempted at 60 feet AGL. The pilot stated a downdraft forced the aircraft back to the ground. The aircraft struck a woodpile and several small trees. Post-crash fire…NTSB SEA88FA012Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Colville, WAAlthough the recently certificated private pilot was not checked out by the fixed base operator for night flight and had been warned to return before sunset, he departed the airport during dark night conditions. Witnesses reported observing the aircraft climb…NTSB ANC88LA010Accident · No injuriesLimited investigationFinal reportCessna A185 · Karluk, AKThe pilot arrived late and the tide had come in at the beach in kanatak bay. By the time he commenced his takeoff attempt, the usable area had diminished considerably. The right main gear caught in the surf and the airplane inverted in the water.NTSB MIA88FA008Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau 230 · Arcadia, FLThe accident occurred while the aircraft was performing exhibition aerobatics at an airshow. The acft had just completed a portion of the planned low alt aerobatic sequence which included a tail slide & 3 rolls with the nose of the acft pointed toward the…NTSB ATL88DMG01Accident · 1 fatalFinal reportRogers-Gibson 1 · Bennettsville, SCThe homebuilt aerobatic airplane impacted flat terrain adjacent to the rwy shortly after takeoff. A pilot/witness who was in the arpt terminal lobby at the time rptd that he briefly observed the airplane pass by the terminal at a low level in a near…NTSB BFO88FA002Accident · 1 fatalField investigationFinal reportCessna 172N · Lowmoor, VAThe acft was involved in powerline patrol over mountainous terrain at low altitude. The plt made a climbing right turn to avoid a ridge and went into a valley where he was boxed in by two ridges. He unsuccessfully tried to outclimb one of the ridges before he…NTSB NYC88LA003Accident · No injuriesLimited investigationFinal reportCessna 172H · Oneonta, NYThe plt rprtd he started to depart from rwy 13 with the wind from the south at 15 gusting 25 KTS. He stated the acft was not climbing as expected so he elected to land on the remaining rwy. He stated the wind gusts were strong from the right rear. He said he…NTSB LAX88FA006Accident · No injuriesField investigationFinal reportBoeing 767-201 · Los Angeles, CAThe captain sensed the aircraft ballooning during the flare. He increased the pitch angle to 11.8 degrees to arrest the descent during touchdown. Flight attendants sitting in the aft cabin crew seats heard a scraping sound just prior to main landing gear…NTSB LAX87FA350Accident · 6 fatalField investigationFinal reportCessna 340A · San Diego, CAAt aprx 0600, the acft depd guerrero negro, Mexico on an air taxi flt to tijuana, Mexico. At 0715, the tijuana wx was rprtd as partially obscured, vis 1 mi with fog, haze & smoke, wind calm. Drg arrival, the plt was clrd for an ILS rwy 9 apch & rprtd over the…NTSB DEN87LA247Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Grand Junction, COThe plt was practicing some helicopter maneuvers in preparation for taking an FAA flt examination. During one of his maneuvers the helicopter's main rotor blades struck the ground causing the acft to crash. A post accident fire errupted and destroyed the…NTSB ATL87FA268Accident · 5 fatalField investigationFinal reportBeech 95-B55 · Manteo, NCWitness observed acft settle into ocean during low level cruise flt adjacent to beach. Wx was ovrcst, indistinct horizon & calm sea. IFR flt plan had been filed but no contact was made with ATC. Engines and propeller examination did not reveal a mechanical…NTSB LAX87DVD05Accident · No injuriesFinal reportRotorway Scorpion 133 · Boonville, CAThe plt said that when he was practicing quick stops & flares, the tail rotor struck the ground. The helicopter then yawed, touched down (right skid 1st) & rolled over. No preimpact mechanical failure or malfunction was rprtd.NTSB NYC87FA262Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Montoursville, PAThe plt initiated the ILS approach and acknowledged a frequency change. The acft was found on a steep hill one mile south of the airport. No evidence of an engine or control system malfunction was found. It appeared that the pilot made a missed approach and…NTSB ANC87FA165Accident · 5 fatalField investigationFinal reportPiper PA-31-310 · Eldred Rock, AKThe flt was clrd on an IFR flt fm whitehorse to juneau, via V-428 to chill intxn, then drct to juneau. Chill intxn was located on V-428, 36 mi south of haines NDB on a bearing of 146 deg. On reaching haines NDB, the plt cancelled his IFR clnc & contd under…NTSB NYC87LA261Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Fitchburg, MADrg arrival, the plt was clrd for an ndb-a apch to Fitchburg muni arpt. The NDB was located on the arpt & the arpt elev was 350'. The min dscnt alt (mda) was 1140' MSL. The apch procedure was to go outbnd fm the NDB on a 137 deg bearing, make a procedure…NTSB LAX87LA340Accident · Serious injuriesLimited investigationFinal reportPiper JC3-65 · Sacramento, CAThe pilot was observed to be flying at a very low altitude by two separate witnesses. They stated that he was flying and maneuvering at approximately 15-20 feet AGL and buzzing powerlines. The pilot stated that he can not remember what happened and that the…NTSB LAX87LA336Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Byron, CAWith the wind out of the southwest at 8 to 10 knots, the plt was taxiing the acft in a northerly direction at a high enough speed to keep 'on the step'. When he attempted to turn the acft to a southwesterly heading for tkof, the acft failed to respond. Rather…NTSB SEA87LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · John Day, ORPlt departed hay field in hi density alt conds. The pilot was unable to clear trees and stalled/mushed into terrain, collapsing gear and colliding with trees.NTSB FTW87LA215Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Batesvile, TXA witness to the accident reported the pilot was 'buzzing' personnel in a cotton field and on the third pass did not pull up in time. The belly struck the ground while the aircraft was in a 'fairly steep angle of descent.' The witness stated the engine…NTSB DEN87FA237Accident · Serious injuriesField investigationFinal reportFairchild Hiller FH-1100 · Pinedale, WYThe plt and two passengers had flown to Pinedale to fish. The plt stated that he was cruising at an alt of 400 ft AGL and was executing a rt turn at the request of a pax. He stated that he slowed the acft, decreased the collective, and added rt pedal as he…NTSB LAX87IA326Incident · No injuriesIncident investigationFinal reportMooney M20C · Los Angeles, CAThe plt rprtd that before landing, he went thru the landing checklist, but the green gear light did not illuminate. He contd the landing, & subsequently, the acft touched down & came to rest with the gear retracted. There was evidence the gear was retracted…NTSB LAX87LA325Accident · 1 fatalLimited investigationFinal reportBeech A45 · Mammoth Lakes, CADuring an airshow performance, the acft collided with the terrain in a near vertical attitude. The maneuver the plt was to perform was a cuban eight. The first half of the maneuver was flown correctly, however, during the second half of it the acft remained…NTSB ANC87FA146Accident · 2 fatalField investigationFinal reportCessna U206E · Harding Glacier, AKThe private pilot and his non-pilot adult male passenger were flying from modesto, CA, to soldotna, AK, for a hunting trip. The pilot, who had approximately 164 hours total flight time at the time of the accident, and who had no prior flying experience in…NTSB ANC87LA142Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Mcgrath, AKA local hunting guide crashed his airplane in a remote mountain pass in central Alaska. Another guide who overflew the crash site shortly after the accident saw the airplane burning, but was unable to land due to strong winds, severe turbulence and strong…NTSB ATL87FA248Accident · 1 fatalField investigationFinal reportCessna 182 · Lima, OHDuring a night flt from toledo to cincinnati, OH, the acft crashed along the route at Lima, OH, after svrl local residents heard an acft circling. Initial impact was with the top of a dike after the acft crossed over a reservoir. Wreckage was scattered over a…NTSB ATL87DKG06Accident · 1 fatalFinal reportPitts S-1 · Brooks, GAThe acft was observed in aerobatic maneuvers near the departure airfield. The last of the series was a lomcevak maneuver, which was started at an estimated alt of 2500 to 2700 ft. a witness rprtd the acft went into an inverted flat spin, which was corrected…NTSB MKC87FA169Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Kanorado, KSThe fss stated they had personally briefed the student pilot on the wx en route for this night flight and told him VFR was not recommended. At the first stop, he called the co-owner of the airplane and told her he had been flying around storms. At the next…NTSB LAX87LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Temple Bar, AZThe stall warning horn sounded during climbout following a touch-and-go landing. Rising terrain was reported beyond the end of the runway and the pilot was unable to continue to climb while maintaining a safe airspeed. The density altitude was approximately…NTSB NYC87FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-28-161 · Nantucket, MAThe Piper PA-28-161 with a pilot and passenger onboard disappeared from the radar scope while being vectored to an ILS approach to rwy 24 at Nantucket, MA. The controller observed the aircraft in a southeasterly heading and asked the tower controller to…NTSB LAX87LA310Accident · Minor injuriesLimited investigationFinal reportBell 206B · Kailua-Kona, HIAs the helicopter was climbing over rising terrain at 300' to 400' AGL, the plt noted altimeter & airspeed indcns of 8700' & 60 mph. After climbing an adnl 2 min to aprx 10,000' (12,000' density alt), he noticed the rotor RPM was bleeding off. He made a 180…NTSB SEA87FA166Accident · 1 fatalField investigationFinal reportCessna 172RG · Kettle Falls, WAWhile on a local personal flight, plt entered a canyon into rising terrain, colliding first with a tree and then ground near crest. Investigation revealed that acft probably had performance to clear crest had tree not been struck. Circumstances indicate plt…NTSB MKC87LA164Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Mediapolis, IAThe pilot stated that the field to be sprayed appeared safe enough when he flew a recon flight over the area the day prior to the accident. He stated that he didn't expect the power transmission lines to be so low, and that he did not see a rise in the…NTSB LAX87FA300Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Springville, CAThe pilot was flying over sharply rising terrain in a canyon in a mountainous area. There was insufficient room in the canyon to manuever the aircraft. The pilot reported that he had maintained an airspeed just above a stall while attempting to fly through…NTSB LAX87FA298Accident · 1 fatalField investigationFinal reportCessna 150M · Newport Beach, CAOn a dark night beneath a scattered to broken marine layer of stratus clouds the plt made a low altitude pleasure flight 1/4 mi off shore. The acft entered a gradual descent, collided with the ocean and the plt drowned.