NTSB investigations, 1987
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 | 72 |
|---|---|
| 1963 | 78 |
| 1964 | 5,253 |
| 1965 | 5,377 |
| 1966 | 5,912 |
| 1967 | 6,339 |
| 1968 | 5,199 |
| 1969 | 5,027 |
| 1970 | 4,915 |
| 1971 | 4,825 |
| 1972 | 4,430 |
| 1973 | 4,398 |
| 1974 | 4,565 |
| 1975 | 4,403 |
| 1976 | 4,314 |
| 1977 | 4,412 |
| 1978 | 4,624 |
| 1979 | 4,165 |
| 1980 | 3,921 |
| 1981 | 3,836 |
| 1982 | 3,545 |
| 1983 | 3,514 |
| 1984 | 3,405 |
| 1985 | 3,055 |
| 1986 | 2,831 |
| 1987 | 2,774 |
| 1988 | 2,685 |
| 1989 | 2,502 |
| 1990 | 2,479 |
| 1991 | 2,419 |
| 1992 | 2,328 |
| 1993 | 2,283 |
| 1994 | 2,229 |
| 1995 | 2,281 |
| 1996 | 2,150 |
| 1997 | 2,121 |
| 1998 | 2,195 |
| 1999 | 2,175 |
| 2000 | 2,183 |
| 2001 | 2,031 |
| 2002 | 2,000 |
| 2003 | 2,062 |
| 2004 | 1,930 |
| 2005 | 2,001 |
| 2006 | 1,826 |
| 2007 | 1,984 |
| 2008 | 1,882 |
| 2009 | 1,783 |
| 2010 | 1,786 |
| 2011 | 1,848 |
| 2012 | 1,834 |
| 2013 | 1,561 |
| 2014 | 1,534 |
| 2015 | 1,581 |
| 2016 | 1,662 |
| 2017 | 1,635 |
| 2018 | 1,687 |
| 2019 | 1,626 |
| 2020 | 1,396 |
| 2021 | 1,645 |
| 2022 | 1,700 |
| 2023 | 1,678 |
| 2024 | 1,693 |
| 2025 | 1,655 |
| 2026 | 1,342 |
Where
Latest 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 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 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 NYC88LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Concord, NHThe aircraft was landing at Concord municipal airport, and during landing roll, the aircraft veered to the left leaving the runway surface and nosed over in the field between the taxiway and runway 35.NTSB NYC88FA062Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Burlington, VTDrg flt fm wilmington, de to rutland, VT, the plt diverted to binghamton after recg the albany wx & learning rutland wx was not available. After lndg, he told fss psnl he phoned rutland & was told the wx was good. He got 2 wx briefings bfr contg the flt & was…NTSB MKC88LA035Accident · No injuriesLimited investigationFinal reportCessna 182Q · Davenport, IAThe PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty…NTSB LAX88LA078Accident · No injuriesLimited investigationFinal reportCessna 150K · San Andreas, CANTSB CHI88LA038Accident · No injuriesLimited investigationFinal reportCessna 210-5 · East Lansing, MIThe aircraft was landed at night on runway 9 which is 2530' in length with a 600' displaced threshold. This runway was ice covered and winds were recorded 25 minutes before the accident at a reporting facility 5 nautical miles west of the accident site as 160…NTSB SEA88FA034Accident · 3 fatalField investigationFinal reportCessna 182J · Molalla, ORThe recently certificated, non-instrument rated, pvt plt flew into the an area of low ceilings, low vis, rain & snw w/o filing a flt plan. No record of a wx briefing was fnd. A surviving pax rprtd that drg flt, the plt flew into clds that were initially…NTSB DEN88LA045Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Dona Ana, NMThe commerical plt was conducting a sightseeing flight in his balloon. After a one and one half hour flight, he landed beside a paved road. The envelope collapsed over a power line. The ground crewman somehow contacted the balloon and was electrically…NTSB DEN88FA044Accident · Serious injuriesField investigationFinal reportSwearingen SA-26AT · Telluride, CODuring a visual apch, the plt said he encountered 2000 fpm downdrafts. The plt stated he added power and executed a normal apch at 120 KTS, compensating for downdrafts/crosswinds. After touchdown, the plt said he did not get a beta light on the right eng. He…NTSB SEA88LA033Accident · 1 fatalLimited investigationFinal reportCessna 182C · Las Vegas, NVThe aircraft bounced on landing touchdown, swerved off the side of the runway and impacted a concrete culvert in a drainage ditch. Witnesses observed the acft bounce and stated that no application of power for recovery was heard nor any apparent attempt to…NTSB MIA88IA079Incident · No injuriesIncident investigationFinal reportCessna U206G · Key West, FLWhile water taxiing nw from the ramp to takeoff with the wind from the north at 22 KTS, the rt wing lifted resulting in the lt float digging into the water. The plt attempted to correct this by turning into the wind and applying full-up right aileron but was…NTSB LAX88LA081Accident · No injuriesLimited investigationFinal reportCessna 172M · Banning, CADuring a pleasure flight while on final approach, aprx 10 ft above the rwy, the acft suddenly dropped and bounced on the rwy. After a nearby rain storm passed over the area, the acft was flown to the home base. Several days later, the operator discovered…NTSB FTW88LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Woodworth, LAThe plt stated that during landing roll the aircraft veered left due to a strong wind gust. The aircraft fell into a ravine, coming to rest 180 degrees from the runway heading, damaging both wing spars at the fuselage attach points and collapsing the nose…NTSB FTW88LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Fargo, OKDuring takeoff roll, the engine RPM dropped to 2600 and started running rough. Shortly after takeoff, the pilot elected to make a precautionary landing. During landing roll the aircraft's left wing hit a tree causing substantial damage to the aircraft. Prior…NTSB MIA88NA070Accident · Minor injuriesFinal reportMcDonnell Douglas DC-9-31 · Pensacola, FLNTSB MIA88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLEn route to the destination during a cross country flt, the acft was diverted to an alternate arpt due to weather conditions below minimums. Unable to land at the alternate due to poor visibility the non-instrument rated plt requested vectors to the…NTSB LAX88LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Goodyear, AZDuring a cross country flt while cruising at 7500 ft MSL, the acft began to vibrate severely. The plt shut the engine down and landed without further incident. Inspection of the acft revealed that a section of one of the propeller blades had separated. The…NTSB MIA88IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Miami, FLPlt was instructed to turn the tail to the right as viewed by the signal man during power back. As power back started the tail was turned to the left as viewed by the signal man. The signal man corrected this turn but the acft was now making a much larger arc…NTSB LAX88DUQ03Accident · Serious injuriesFinal reportRolladen-Schneider LS-3 · Santa Ynez, CADuring a pleasure flight, the left wing of the glider struck a tree and collided with the terrain during a left turn in sinking air. The plt stated that he was looking over his right shoulder at nearby traffic then turned to look forward into the hazy setting…NTSB FTW88DPA02Accident · No injuriesFinal reportCessna 150M · Gainesville, TXThe pilot lost engine power due to a throttle cable which failed during flight. He then made a 360 degree turn to lose altitude before initiating an emergency landing on an airport. He lost excessive altitude during the turn which resulted in an off-airport…NTSB DEN88IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Denver, CODuring landing roll the acft struck a taxiway marker. Visibility was reported by RVR to be 2200. Actual visibility was near zero due to blowing snow. Plt stated he did not lose cntrl but finite cntrl not possible due to lack of visibility and cross winds of…NTSB DCA88RA019Accident · 1 fatalForeign investigationCessna 402 · St. Barthelemy, WNNTSB MKC88LA034Accident · No injuriesLimited investigationFinal reportLuscombe 8-A · Chillicothe, MODuring a ldg attempt, acft touched down and swerved abruptly. Loss of control was experienced by PIC, and acft made a 180 degree turn on the runway. PIC stated the brakes may have been frozen, as he had taxied thru standing water during departure.NTSB MKC88LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hays, KSDuring a personal cross country IFR flt, PIC encountered forecast icing conditions. He then made a 180 degree turn to an alternate airfield. He said the acft accumulated substantial icing on propeller, wings and windshield. He said full pwr was necessary to…NTSB MIA88LA076Accident · Minor injuriesLimited investigationFinal reportCrusenberry Windwagon · Lantana, FLWhile on a high speed taxi test the acft inadvertently became airborne. While looking out the rt side of the acft the plt rolled it into a rt bank. He then leveled the wings after which the acft stalled, touched down and separated the main landing gear wheels…NTSB MIA88LA075Accident · No injuriesLimited investigationFinal reportBoeing 727-200 · San Juan, PRN705AA was number two in position for takeoff behind N893AA. N705AA received takeoff clearance first and as it began to taxi to the runway it's left wing tip struck and passed under the right wing tip of N893AA.NTSB DEN88LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Riverton, WYThe instructor plt and student were practicing forced landings to an open field. The instructor stated that he descended to approx 50 to 75 ft AGL over the intended landing area. He initiated a go around, pulled up and banked left to go over powerlines. At an…NTSB CHI88LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Redwood Falls, MNWind was 210 degrees at 13 knots when the student pilot attempted a landing on snow compacted runway 12. The student stated that a gust of wind pushed the aircraft sideways and it struck a snowbank when it exited the runway to the left.NTSB ATL88FA069Accident · Serious injuriesField investigationFinal reportCessna 172M · Warner-Robins, GAThe non-ifr rated plt dptd in VFR wx. He subsequently encountered IFR wx several hrs after departure and attempted to continue on to his destination arpt in IFR conditions. He made several VOR approaches to the destination arpt. But was unable to visually…NTSB NYC88LA060Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Flushing, NYAs the plts were taxiing at dusk to takeoff, the acft was struck by a food svc van at a vehicle svc road. The acdnt occurred as rain was falling & the ramp area was wet with standing water. The van driver said he had just maneuvered his vehicle to the left to…NTSB CHI88LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Mt. Pleasant, WIThe stu plt climbed to 1600 ft MSL aft tkof. Shortly aft level off, the engine stopped. He attempted an air start without success. During the forced lndg the nose wheel dug in and the acft nosed over in the soft soil. During a post crash interview, the stu…NTSB BFO88FA011Accident · 1 fatalField investigationFinal reportChampion 7ECA · Keymar, MDWitnesses heard and observed the aircraft takeoff, bank to the left, and nose down into the adjoining dirt field with no change in engine sound. Exam of the wreckage revealed that an elevator cable had separated at a point where grounding strap was found to…NTSB ATL88FA068Accident · 4 fatalField investigationFinal reportPiper PA-28RT-201 · Rutherfordton, NCThe pilot was cleared for the adf approach. The aircraft was last observed on radar about one mile inside the rbn. The aircraft was located on December 27 about 4 NM NE of the airport. The aircraft impacted the trees at about the 2270-foot level of carson Mt.…NTSB NYC88LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe aircraft was taxiing from a shop on the airport to runway 24 for a south end departure. The pilot stated that the left wing of the aircraft made contact with the parked truck causing substantial damage.NTSB MIA88FA071Accident · 1 fatalField investigationFinal reportCessna 150H · Destin, FLWitnesses stated that they observed the acft flying in the fog in a southeasterly direction and turn hard right just before it struck the 19th floor of a condominium. The fog according to residents of the bldg was so thick that the ground could not be seen…NTSB LAX88LA077Accident · No injuriesLimited investigationFinal reportCessna 150E · Hilo, HIDuring a local pleasure flt, while climbing to 5500 feet, the engine sputtered and quit. During the landing roll, the acft nosed over. The engine was examined with no mechanical failures or malfunctions noted. The acft was operating in the range of serious…NTSB LAX88LA076Accident · No injuriesLimited investigationFinal reportCessna 210K · Chowchilla, CADuring a cross country flt, the plt had diverted to another arpt for fuel. The plt was unable to activate the rwy lights and a forced landing was made that was perpendicular to the rwy. Upon inspection of the acft, an incorrect frequency was noted on the…NTSB LAX88FA075Accident · 8 fatalField investigationFinal reportPiper PA-31-350 · Maunaloa, HIThe flight was to be flown across a 22 mile channel between islands on an overcast night with no moon and no ground reference lights. The aircraft disappeared from radar and, after extensive searches, could not be found. A three dimensional flight track was…NTSB LAX88DUM02Accident · 1 fatalFinal reportBede BD-5 · Chula Vista, CANTSB ATL88FA067Accident · 1 fatalField investigationFinal reportBeech B23 · Crossville, TNN6571R crashed into trees near the VOR on top on hinch mtn at about 3000 feet MSL. Trees at the crash site indicated wings level with a descent angle of about 10 degrees. Weather in the area was IMC, characterized by low ceilings (lower than the mtn top…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 MIA88WA074Accident · No injuriesForeign investigationMitsubishi MU-2B-30 · San Salvador, El SalvadorNTSB MIA88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLU.S. Coast guard personnel stated that the pilot reported that they were out of fuel and were ditching approximately 110 miles southeast of Marathon FL. The pilots were picked up by the coast guard and were transported back to miami.NTSB FTW88LA041Accident · No injuriesLimited investigationFinal reportCessna 172XP · Godley, TXDuring a cross country flight, the weather worsened. Visibility decreased and the ceiling lowered, forcing the pilot to descend in order to remain VFR. The pilot elected to perform a precautionary landing in a field. During landing roll the pilot noticed a…NTSB DEN88LA040Accident · No injuriesLimited investigationFinal reportBeech A36 · Angel Fire, NMThe private plt and five pax were returning home from a skiing trip. During takeoff the acft encountered a left crosswind from 270 degrees, at an estimated 40 knots. The plt lifted off early, then the wind pulled. The acft stalled and impacted right of the…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 NYC88LA059Accident · 1 fatalLimited investigationFinal reportCessna 170A · Sandwich, MAThe Cessna 170A was on an aerial photography flt. Witnesses rprtd the acft was flying slow at about 200 ft AGL when it began to settle. The witnesses then heard an increase in eng power & saw the acft pitch up. Subsequently, it 'fell off on a wing,' crashed…NTSB LAX88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Los Angeles, CAWhile taxiing after landing, N911E was instructed to taxi to a position and hold, en route to that position, the acft collided with N75397 that was also holding in the same position. The plt of N911E stated that he did not see the acft due to moisture that…NTSB CHI88LA034Accident · No injuriesLimited investigationFinal reportCessna 172K · Staunton, ILDuring the flare for landing the aircraft drifted to the right and the right wingtip contacted the rudders of two aircraft parked with their tails 21' and 23' from the centerline of the runway. The wingspan of the accident aircraft is 35'9'. Had the pilot…NTSB MKC88LA031Accident · No injuriesLimited investigationFinal reportSonerai 2L · St. Louis, MOWhile practicing take offs and ldgs, PIC lost directional control during rollout. He added power and struck a snowbank just after becoming airborne during running takeoff.NTSB MIA88LA073Accident · 1 fatalLimited investigationFinal reportCessna 152 · MissingAccording to the operator the acft departed san juan, PR on a cross country flight to la romana. The acft arrived there & dropped the student off & the plt departed at about 1400 ast on his return trip to san juan. The acft did not arrive at it's destination…