NTSB investigations, 1987, NE
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1964 | 58 |
| 1965 | 67 |
| 1966 | 72 |
| 1967 | 89 |
| 1968 | 80 |
| 1969 | 88 |
| 1970 | 74 |
| 1971 | 93 |
| 1972 | 64 |
| 1973 | 52 |
| 1974 | 71 |
| 1975 | 47 |
| 1976 | 64 |
| 1977 | 52 |
| 1978 | 49 |
| 1979 | 41 |
| 1980 | 36 |
| 1981 | 34 |
| 1982 | 42 |
| 1983 | 39 |
| 1984 | 40 |
| 1985 | 31 |
| 1986 | 27 |
| 1987 | 21 |
| 1988 | 16 |
| 1989 | 22 |
| 1990 | 13 |
| 1991 | 24 |
| 1992 | 20 |
| 1993 | 21 |
| 1994 | 20 |
| 1995 | 16 |
| 1996 | 14 |
| 1997 | 14 |
| 1998 | 28 |
| 1999 | 23 |
| 2000 | 13 |
| 2001 | 19 |
| 2002 | 14 |
| 2003 | 12 |
| 2004 | 11 |
| 2005 | 15 |
| 2006 | 17 |
| 2007 | 11 |
| 2008 | 13 |
| 2009 | 15 |
| 2010 | 13 |
| 2011 | 7 |
| 2012 | 21 |
| 2013 | 11 |
| 2014 | 11 |
| 2015 | 11 |
| 2016 | 10 |
| 2017 | 9 |
| 2018 | 12 |
| 2019 | 13 |
| 2020 | 9 |
| 2021 | 9 |
| 2022 | 14 |
| 2023 | 10 |
| 2024 | 17 |
| 2025 | 11 |
| 2026 | 4 |
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.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'NE' AND c."eventCountry" = 'USA' 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 MKC88FA032Accident · 2 fatalField investigationFinal reportCessna 402C · Chadron, NEThe acft was on a flt to Chadron via Chadron VOR. Abt 30 mi sse of the VOR, the plt reqd & was clrd to fly drct to ackmeiaf for an NDB rwy 2 apch. The acft contd twd the VOR which was in the same general drctn, but 11.9 mi south of ackme. The NDB was at the…NTSB MKC88FA023Accident · 2 fatalField investigationFinal reportCessna 180 · Springfield, NEAccording to witnesses on the ground, the aircraft was flying low, under the overcast, when the left wing struck the guy wires of a tv tower and the plane crashed out of control. It was destroyed by impact forces and a post-crash fire. Weather stations in the…NTSB MKC88FA005Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Lincoln, NEDuring climbout, smoke began filling the cabin and shortly thereafter the eng stopped. Ground witnesses observed smoke coming from the eng compartment just before the acft impacted a large woodpile behind a house located 1/2 mile east of the arpt. Examination…NTSB MKC87LA179Accident · No injuriesLimited investigationFinal reportJenkins Pitts S-1 · Orleans, NEThe pilot stated that the aircraft was cruising at 2,000 ft (AGL) when the engine lost power. He turned toward the nearest suitable emergency airfield but the aircraft's rate of descent precluded this option. The pilot selected a road as alternate, but…NTSB MKC87LA174Accident · No injuriesLimited investigationFinal reportCessna 120 · Creighton, NEThe flt dptd harvard, NE., with a dest of wausa, NE abt 1 hrs flying dist to the northeast. The departure commenced abt 1 hr and 40 min's prior to dark. The PIC stated he encountered strong headwinds along the route which delayed his progress. The acft…NTSB MKC87LA175Accident · No injuriesLimited investigationFinal reportCessna 180B · Atkinson, NEWitnesses stated that the pilot was chasing a wild horse out of an alfalfa field and back into a corral when a wingtip struck a grove of trees and the aircraft cartwheeled onto the ground. The pilot stated to FAA that he did not see the treeline due to…NTSB MKC87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Columbus, NEThe PIC was positioning his ag acft for a spray job when he thought he had a pblm with the eng. A precautionary lndg was decided on, but the lndg resulted in substantial dmge to the acft. A spray pump, posnd beneath the eng cowling which rotates by means of a…NTSB MKC87LA147Accident · No injuriesLimited investigationFinal reportCessna 188B · Fairfield, NEShortly after takeoff for an aerial application flight, the aircraft began to settle. The left wing struck the ground and the aircraft turned 180 degrees. Temperature was 95 degrees f and density altitude 4000 feet. The pilot stated he 'could have dumped some…NTSB MKC87LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Adams, NEAfter a normal approach and landing on a private sod strip, the pilot stated the aircraft swerved to the left of the runway to an adjoining plowed field. The aircraft struck a large hay bale followed by a large mound of dirt. Post accident investigation…NTSB MKC87FA131Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Holdrege, NEWitnesses stated that the aircraft was performing a loop when the left wing failed upward and rearward causing the aircraft to plummet to the ground, out of control. The aircraft appeared to have been in trouble during the loop entry and throughout the…NTSB MKC87LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, NEAfter completing an IFR simulated NDB approach to runway 35L, PIC side-stepped to land VFR on 35R. During base leg acft had a partial power loss followed shortly by total power loss. PIC informed control tower of the emergency and made a forced ldg in a farm…NTSB MKC87LA126Accident · No injuriesLimited investigationFinal reportCessna 150L · Antioch, NEThe rwy was 1900 feet long with 5500 ft density altitude. With pilot and passenger and 30 degrees of flaps and calm wind, airplane lifted off, cleared fence and road. Pilot said he lowered the nose and raised flaps to 20 degrees but may have retracted them…NTSB MKC87LA118Accident · No injuriesLimited investigationFinal reportCessna 188C · Dalton, NEThe PIC attempted to depart a rural farm ldg strip during an aerial application operation. The acft left spray boom struck tall standing wheat prior to lift off speed causing loss of control and subsequent ground loop and nose over.NTSB MKC87FA092Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Valley, NEAt aprx 2020 CDT, witnesses saw the acft as the plt made svrl low passes over the platte river near Valley, NE. On the last pass, the acft struck power lines, then crashed in the river. The wreckage came to rest in the main channel of the river in aprx 25 ft…NTSB MKC87LA090Accident · No injuriesLimited investigationFinal reportCessna A188B · Orleans, NEThe pilot stated that he was spraying a wheat field with a load of chemicals, and was completing his fourth swath run, when he noticed powerlines in his flight path. He performed an evasive maneuver; however, the aircraft struckthe powerlines. The aicraft…NTSB MKC87LA093Accident · No injuriesLimited investigationFinal reportForney Ercoupe · Omaha, NEThe annual inspection on this acft was completed the day prior to this accident. During this flt, the wire holding the fuel filter bowl in place came loose and the bowl came off. The eng quit from fuel starvation and the plt made a forced landing in a plowed…NTSB MKC87IA070Incident · No injuriesIncident investigationFinal reportAgusta A109 · Lincoln, NEThe PIC stated that he was ground taxiing the helo to the ramp area at duncan aviation to shutdown for refueling. During the taxi, the PIC heard a loud 'bang' eminating fm the rear of the helo. The PIC lowered collective pitch and no further noise was heard…NTSB MKC87LA057Accident · No injuriesLimited investigationFinal reportEmbraer EMB-110 · Norfolk, NEThe crew stated they were descending for landing when they flew through a flock of geese that were traveling in the same direction. They received three or four bird stikes. The aircraft landed without further incident.NTSB MKC87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kimball, NEThe PIC rptd landing rwy 10 with a wnd fm 080 at 7 KTS. The acft began veering left and ran through a snow bank which bordered the rwy. The left main landing gear collapsed and the acft spun around 180 deg stopping tail first. Insp of the landing gear noted…NTSB MKC87FA051Accident · 1 fatalField investigationFinal reportPiper PA-18 · Venango, NEA witness saw the airplane fly over his property from the north to the south and he waved to the pilots. The airplane then came back toward the north at a low altitude and when the witness heard the power being applied, the left wing dropped and almost…NTSB MKC87FA044Accident · 2 fatalField investigationFinal reportCessna 150D · Central City, NEAt about 0305 CST, witnesses in vehicles saw the acft lndg lgt as they were driving along a hwy. they rprtd the lgt was moving erratically as the acft was proceeding along the hwy at low alt. Subsequently, the acft struck a utility pole & power lines, then…