NTSB investigations, 1987, ID
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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
| 1964 | 70 |
|---|---|
| 1965 | 49 |
| 1966 | 62 |
| 1967 | 64 |
| 1968 | 65 |
| 1969 | 47 |
| 1970 | 54 |
| 1971 | 57 |
| 1972 | 41 |
| 1973 | 48 |
| 1974 | 63 |
| 1975 | 56 |
| 1976 | 63 |
| 1977 | 48 |
| 1978 | 43 |
| 1979 | 56 |
| 1980 | 44 |
| 1981 | 40 |
| 1982 | 47 |
| 1983 | 41 |
| 1984 | 41 |
| 1985 | 46 |
| 1986 | 50 |
| 1987 | 25 |
| 1988 | 29 |
| 1989 | 22 |
| 1990 | 30 |
| 1991 | 30 |
| 1992 | 37 |
| 1993 | 26 |
| 1994 | 39 |
| 1995 | 35 |
| 1996 | 33 |
| 1997 | 31 |
| 1998 | 41 |
| 1999 | 46 |
| 2000 | 34 |
| 2001 | 24 |
| 2002 | 48 |
| 2003 | 52 |
| 2004 | 40 |
| 2005 | 38 |
| 2006 | 30 |
| 2007 | 40 |
| 2008 | 34 |
| 2009 | 37 |
| 2010 | 37 |
| 2011 | 33 |
| 2012 | 40 |
| 2013 | 32 |
| 2014 | 30 |
| 2015 | 27 |
| 2016 | 22 |
| 2017 | 31 |
| 2018 | 28 |
| 2019 | 33 |
| 2020 | 24 |
| 2021 | 39 |
| 2022 | 27 |
| 2023 | 29 |
| 2024 | 35 |
| 2025 | 22 |
| 2026 | 19 |
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\" = 'ID' 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" = 'ID' 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 SEA88FA024Accident · 2 fatalField investigationFinal reportCessna 180G · Cambridge, IDDuring a fuel stop at elko, NV the pilot requested a weather briefing for VFR flight to lander, WY or to couer d'alene, ID. The FAA fss briefed him on adverse weather to both destinations, with flight advisories for mountain obscurations, occasional severe…NTSB SEA88LA009Accident · No injuriesLimited investigationFinal reportNapper Vancraft · Pocatello, IDThe experimental gyrocopter was on a test flight when the right rudder pedal pivot bolt broke. The aircraft began a spiral in a counter-clockwise direction with the rudder separating from the aircraft at the hinge points. The aircraft continued to spiral to…NTSB SEA87MA192Accident · Serious injuriesMajor investigationFinal reportFairchild SA227-AC · Twin Falls, IDChk plt was conducting capt proficiency chk on another company plt (PIC) under dark ngt condtns. Subsequent to full stop ldg on rwy 25, takeoff chklst was recited. PIC commenced t/o on rwy 07. Chk plt simulated VI eng cut after liftoff. PIC was unable to…NTSB SEA87FA190Accident · 3 fatalField investigationFinal reportCessna T210L · Hailey, IDAfter dark night takeoff, acft was observed to execute an immediate left turn up a canyon into rising terrain. During climb, acft lights were seen to perform maneuver characteristic of stall/spin. Investigation showed acft struck terrain slightly nose low. No…NTSB SEA87LA183Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Star, IDThe aircraft was to the left of the centerline during takeoff run on the 60 foot wide airstrip. A cross wind was present from the right. The aircraft's left wing struck a person standing close to the runway edge. The pilot stated that he had his eyes on his…NTSB SEA87LA182Accident · No injuriesLimited investigationFinal reportCessna 180H · Salmon, IDWhile on approach for landing a total loss of power occurred for undetermined reasons.NTSB SEA87LA174Accident · 1 fatalLimited investigationFinal reportLutz Flying Dutchman · Twin Falls, IDThe purpose of the flt was to check the acft after replacing a wooden prop with an all metal prop & to prepare for entry in the reno air races. Bfr entering the air races. The plt needed to demonstrate his ability to make a 'barrel roll' & to make 3 lndgs.…NTSB SEA87LA164Accident · No injuriesLimited investigationFinal reportBeech A36TC · Cascade, IDThe plt elected to divert due to hvy rain at his destn. While lndg at an alternate arpt at ngt, hydroplaning occurred & braking was not effective. Drg a go-around, the acft rolled onto the overrun & lifted off, but the acft's main gear struck a rock pile on…NTSB SEA87LA159Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Hamer, IDThe plt rprtd that he bgn taking off on a downhill strip (aprx 1/2 mi long) with a left quartering tail wind. As the takeoff roll progressed, he realized an overrun was developing, so he bgn dumping his load & attempted to lift- off. He said the acft settled…NTSB SEA87LA155Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Mahoney Creek, IDDrg arrival, the plt inadvertently lndd at the mohoney Creek arpt with a 2050' strip, instead of the intended arpt (indian Creek) which had a 5000' rwy. The arpt elev was 4618'; the density alt was about 7800'. While landing, an overrun occurred & the landing…NTSB SEA87LA146Accident · No injuriesLimited investigationFinal reportDavis Starship Alpha · Burley, IDA loss of power occurred shortly after takeoff at about 100 feet AGL. Due to obstacles in the pilot's flight path landing had to be made in a river where the aircraft was substantially damaged. The reason for the power loss could not be determined.NTSB SEA87LA143Accident · No injuriesLimited investigationFinal reportCessna 170B · Coeur D'Alene, IDOn initial climb a partial loss of power occurred and the pilot made a forced landing in a wheat field. During landing roll the aircraft's left main gear struck an irrigation pipe and the aircraft nosed over inverted. No evidence of a preimpact mechanical…NTSB SEA87FA145Accident · 2 fatalField investigationFinal reportCessna T210N · Avery, IDWhile in cruise at 15000 ft MSL, plt requested ATC deviation around tstm shown on acft stormscope. After passing, ATC gave vector to rejoin airway. Plt requested further deviation around another cell. Radio and radar contact were then lost. Investigation…NTSB SEA87IA139Incident · No injuriesIncident investigationFinal reportBeech 55 · Rigby, IDDuring descent for landing, with both engines being fed from the right main fuel tank, a loss of power occurred due to fuel exhaustion. A forced landing was made on a wheat field and during landing rollout the aircraft struck a ditch. Investigation revealed…NTSB SEA87LA163Accident · No injuriesLimited investigationFinal reportCessna T-207 · Mccall, IDDuring climb out to cruise altitude the pilot noticed a drop in manifold pressure and a loss of oil pressure. The pilot was in the process of attempting to reach an airstrip when the oil pressure dropped to zero followed by a total loss of power. An off…NTSB SEA87LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Sun Valley, IDAfter landing touchdown, plt encountered swirling winds. Acft drifted left and into airport boundary (cyclone-type) fence.NTSB SEA87LA131Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Glenns Ferry, IDDuring takeoff with a quartering tailwind about 3/4 way down the runway the aircraft settled back onto the runway. There was not enough room to stop the aircraft. The aircrafts main gear caught on a fence and tall wheat with the aircraft coming to rest…NTSB SEA87LA121Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Viola, IDDuring an aerial applications maneuver a total loss of power occurred due to the internal failure of the supercharger impeller. During the forced landing the left main gear collapsed causing the aircraft to nose over inverted.NTSB SEA87LA105Accident · No injuriesLimited investigationFinal reportBeech BE18 · Glenns Ferry, IDWhile at crz, plt encountered turbulence. Shortly thereafter, experienced elevator control difficulties and yoke vibrations. Plt declared emerg, requested vector to closest airport. Mtn home afb rapcon gave vector to Glenns Ferry airport. On approach, plt…NTSB SEA87IA093Incident · No injuriesIncident investigationFinal reportStinson 108-1 · Idaho Falls, IDDuring a go around the pilot decided to attempt to reland the aircraft. Gusty crosswind conditions existed at the time and directional control was lost during which the aircraft entered into a ground loop maneuver and the left main landing gear strut…NTSB SEA87LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Twin Falls, IDDuring descent from cruise for landing the engine momentarily ran rough and then quit. The pilot attempted to land onto a road but struck a telephone pole in flight. The aircraft then descended onto the ground nose first. No reason for the engine failure…NTSB SEA87LA067Accident · No injuriesLimited investigationFinal reportGrumman G164B · Reubens, IDDuring takeoff run the aircraft veered to the right of the runway, struck a ditch, and then nosed over inverted. The pilot found that the right dowel pin on the right main gear had broken. The reason for the failure could not be determined.NTSB SEA87LA058Accident · No injuriesLimited investigationFinal reportCessna 188 · Genesee, IDAfter operation in light winds, plt attempted takeoff in calm wind conditions. Gravel runway was soft from overnight rains. Acft became airborne briefly in ground effect near end of runway, settled back into muddy terrain and nosed over inverted.NTSB SEA87LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Mountain Home, IDAcft lost pwr on init climb from takeoff, necessitating a forced landing in an open field. Acft nosed over inverted after touchdown in soft terrain. Investigation revealed #3 cylinder rocker arm bosses had broken. Inspection showed, during previous repair,…NTSB SEA87LA043Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7FC · Athol, IDThe pilot lost control of the aircraft during landing with the aircraft veering to the left of the runway centerline. The plt then elected to go-around and on the go-around the aircrafts main gear caught on a snow berm causing a loss of control in flight. The…