Major NTSB investigations, 1987
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1968 | 5 |
|---|---|
| 1969 | 13 |
| 1970 | 12 |
| 1971 | 12 |
| 1972 | 11 |
| 1973 | 10 |
| 1974 | 9 |
| 1975 | 11 |
| 1976 | 8 |
| 1977 | 7 |
| 1978 | 10 |
| 1979 | 11 |
| 1980 | 9 |
| 1981 | 11 |
| 1982 | 9 |
| 1983 | 19 |
| 1984 | 25 |
| 1985 | 31 |
| 1986 | 48 |
| 1987 | 30 |
| 1988 | 17 |
| 1989 | 24 |
| 1990 | 12 |
| 1991 | 14 |
| 1992 | 11 |
| 1993 | 14 |
| 1994 | 16 |
| 1995 | 7 |
| 1996 | 12 |
| 1997 | 10 |
| 1998 | 7 |
| 1999 | 8 |
| 2000 | 14 |
| 2001 | 13 |
| 2002 | 6 |
| 2003 | 10 |
| 2004 | 17 |
| 2005 | 18 |
| 2006 | 11 |
| 2007 | 12 |
| 2008 | 15 |
| 2009 | 8 |
| 2010 | 5 |
| 2011 | 9 |
| 2012 | 1 |
| 2013 | 9 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 11 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 9 |
| 2026 | 2 |
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.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') 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 DCA88MA011Accident · 6 fatalMajor investigationFinal reportPiper PA-31-350 · Kenai, AKThe pilot had just departed the runway when he reported to the flight service station that he had engine problems. The aircraft was observed by witnesses to be about 300 ft on a descending downwind. The pilot stated that he was circling for runway one.…NTSB DCA88MA008Accident · 43 fatalMajor investigationFinal reportBritish Aerospace BAE-146-200 · San Luis Obispo, CAA recently discharged usair employee boarded psa flt 1771 after having left a goodbye message with friends. He bypassed security and carried abd a borrowed 44 caliber pistol. A note written by this psgr, found in the wreckage, threatened his former supervisor…NTSB ATL88MA053Accident · 2 fatalMajor investigationFinal reportHawker Siddeley HS-125-400A · Lexington, KYWhile en route at FL 370, the plts declared an emerg, rprtd a fire in the rgt eng & reqd vectors to the nearest suitablearpt. They were vectored twd the Lexington bluegrass arpt & clrd to dscnd. Shortly after declaring an emerg, the plts rprtd they secured…NTSB ATL88MA048Accident · 2 fatalMajor investigationFinal reportBeech C90 · Beaufort, SCAt 0938, while clbg thru 9000', the plt was clrd to clb to FL 210. Aprx 10 min later, the ATC ctlr noted the acft's mode c rtrn wasn't being displayed on his scope. He tried to adz the plt, but couldn't establish radio contact. The acftbroke up in flt & the…NTSB DCA88MA005Accident · 18 fatalMajor investigationFinal reportBeech 1900C · Homer, AKDrg arr, the acft (ryan flt 103) crashed short of rwy 3. The fuselage stayed intact drg impact, but the belly structure was compressed & vertical deceleration forces exceeded the design capability of the seats. Rescue psnl had difficulty shutting off the…NTSB CHI88MA026Accident · 8 fatalMajor investigationFinal reportBeech 200 · Jefferson, WIWhile cruising abv frzg lvl at 12,000', the flt was clrd to dscnd & maint 9000'. Abt 1-1/2 min ltr, the flt declared a mayday (emergency). Radio & radar ctc were lost & the acft crashed in a nr vertical dscnt. Radar data showed that after starting a dscnt,…NTSB DCA88MA004Accident · 28 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-14 · Denver, COThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/09. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…NTSB SEA88MA015Accident · 4 fatalMajor investigationFinal reportCessna 310N · Bellingham, WAThe acft was chartered to take university (wwu) psnl to an alumni dinner. While rtrng at ngt, the plt made a localizer only, ILS rwy 16 apch in marginal VFR conds. Drg the apch, radar svc was terminated & the plt was told to ctc bellinghamradio, but he did…NTSB FTW88MA021Accident · Minor injuriesMajor investigationFinal reportConvair 640 (340D) · Bartlesville, OKThe capt was cross-feeding both engines from the right tank while the first officer (f/o) was flying, without informing the f/o. the capt then left the cockpit while cross-feeding. Both tank valves and the right boost pump were on. The right tank ran dry, the…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 NYC87MA236Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-8-63 · Newburgh, NYThe wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the…NTSB DCA87MA046Accident · 156 fatalMajor investigationFinal reportMcdonnell Douglas DC-9-82 · Romulus, MIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-88/05. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…NTSB DEN87MA168Accident · 10 fatalMajor investigationFinal reportBeech D18S · Lakeside, MTThe plt borrowed the acft to fly a musical group to kalispell for a pvt engagement at Lakeside, MT, which was aprx 15 mi south of the arpt. That evening, the group boarded the acft for the return flt. After takeoff, the acft was seen flying at low alt in the…NTSB FTW87MA135Accident · 2 fatalMajor investigationFinal reportMBB BO-105CBS · Bay City, MIAcft was involved in EMS static demonstration at beaver township fire dept, near Bay City. Following demonstration, shortly after takeoff, the pilot attempted a steep downwind turn at low altitude. Reported winds at the time of the accident were 250 degrees…NTSB FTW87MA133Accident · 1 fatalMajor investigationFinal reportCessna P210R · Arnett, OKThe flt departed baton rouge (btr) for the plts stated dest of alexandria, which was 78 miles on a bearing of 301 deg, at 0836 CDT. After dep the btr local area there was no radio contact with any ATC facility. The transponder continued to transmit a code…NTSB DCA87MA033Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Kenner, LAThe acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was…NTSB DCA87MA031Accident · 2 fatalMajor investigationFinal reportLearjet 35A · West Mifflin, PAThe coplt (dual student) was to get a prof check on the 1st leg of the flt with a simulated single eng pwr loss on tkof. According to witnesses, the tkof was normal until lift-off aprx 3200' down the rwy; but after lift-off, the acft clbd only about 50' &…NTSB DCA87MA030Accident · 2 fatalMajor investigationFinal reportCASA C-212-CC · Mayaguez, PRAfter several maintenance adjustments of the right propeller and flight idle fuel flow, the aircraft was test flown and released for flight. Several pilots continued to note descrepancies concerning the right propeller system. Adjustments were made and the…NTSB DCA87MA029Accident · 4 fatalClass 1 · MajorFinal reportCessna 340A · Orlando, FLThe two acft, a Cessna 340A and a north American SNJ-4, collided in flt at aprx 3000 ft MSL over Orlando FL in VMC with a visibility of 7 miles. Both acft were in contact with and being radar vectored by Orlando approach control. The C-340 was in level flt…NTSB DCA87MA026Accident · 4 fatalMajor investigationFinal reportBoeing 707-351C · Kansas City, MODrg arr, buffalo airways flt 721 was vectored for an ILS rwy 1 apch. Except for deviations to avoid tstms, dscnt to the terminal area was routine. At 2151:01, the flt was adzd it was 5 mi fm the outer marker (om), was given a final vector to intercept the ILS…NTSB DCA87MA024Accident · 5 fatalMajor investigationFinal reportLockheed L-382G · Travis Afb, CACrashed in steep left turn drg go-around after balked landing. Instructor took controls and initiated go-around after student lndd in improper attitude. Engines number 1 & 2 failed to respond when throttles advanced. Both engines decelerated. Airspeed…NTSB ANC87MA057Accident · 2 fatalMajor investigationFinal reportCessna 402 · Anchorage, AKThe acft was on the last leg of a scheduled commuter flight, when it crashed in a heavily wooded area while making a VFR approach to merrill field, Anchorage, AK. The capt and his sole passenger were killed in the crash when the airplane struck the ground…NTSB DCA87MA023Accident · 3 fatalClass 1 · MajorFinal reportCessna 172N · Oakland, CAAt 0954:54, plt of Piper PA-32RT, N39614, rprtd 9 mi north for lndg. Twr controller (north ctlr) told him to pln for a rgt entry to rwy 27R. At 0955:32, a student plt & instructor (CFI) in Cessna 172N, N75584, were clrd for tkof on rwy 33 with a 'right turn…NTSB CHI87MA101Accident · Serious injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILAfter arriving at the gate in Chicago, fumes & smoke were noted in zone c of the cabin, then the cabin lgtg went out & the emerg lgtg came on. Maint psnl fnd the #2 APU had an auto-shutdown due to a malfunction. The APU was placarded as inop & the acft was…NTSB DCA87MA022Accident · 9 fatalMajor investigationFinal reportCASA C-212-CC · Romulus, MIThe capt made a steep, short, fast visual approach to the runway behind a departing DC-9. The evidence indicates the capt placed the power levers into beta mode to slow the aircraft rapidly and make a short field landing. An asymmetric thrust condition…NTSB LAX87MA125Accident · No injuriesMajor investigationFinal reportBoeing 727-224 · Los Angeles, CAAfter a ngt lndg on north side of Los Angeles intl arpt, Cessna 310, N98834, was taxied south (s) to delta cargo area. Bfr rchg s rwys (25L & 25R), the plt stopped short of kilo ramp bhnd another acft (N61C) & contacted s gnd ctlr (GC-1). He was told to hold…NTSB DCA87MA020Accident · 6 fatalClass 1 · MajorFinal reportPiper PA-31-350 · Independence, MOThe two acft, a Beech U-21A and a Piper PA-31-350, collided nearly head on at 7000 ft MSL over Independence, MO. In daylight VMC conditions with a visibility of 20 miles. The U-21 was in level cruise and the PA-31 was climbing eastbound to an undisclosed alt…NTSB DCA87MA018Accident · 10 fatalClass 1 · MajorFinal reportSwearingen SA-226TC · Kearns, UTThe two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the…NTSB ATL87MA057Accident · 4 fatalMajor investigationFinal reportBell 206L-1 · Pollockville, NCThe emerg med svc (ems/med-evac) helicopter (hel) was on a ngt flt with a 3 month old patient aboard. After rprtg lvl AT3000', the plt transmitted he was going to make an emerg lndg. This was flwd by svrl unreadable transmissions which apchctl psnl thought…NTSB MIA87MA064Accident · 6 fatalMajor investigationFinal reportCessna T210N · Jasper, FLDrg flt in an area of IFR conditions & rain showers, the plt reqd & recd clnc to dscnd from 9000' to 7000'. Later, he recd clnc for further dscnt to 5000'. After a freq chg at 2237 EST, the plt inquired about radar indcns of adverse wxahead. The ctlr adzd…