NTSB investigations, 1987
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, newest first
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 MIA88IA068Incident · No injuriesIncident investigationFinal reportBeech 99 · Tampa, FLThe commuter air carrier crew received an unsafe nose gear indication on final approach. The approach was abandoned and all efforts to use the emergency extension procedures were to no avail. The crew secured both engines on final and landed nose gear up.…NTSB LAX88LA073Accident · No injuriesLimited investigationFinal reportCessna 195A · Burbank, CAWhile holding short of the active rwy, the number one acft,N4309Y, was having radio problems. The tower began to clear other acft for takeoff. Two acft were able to get around the number one acft and takeoff. The third acft cleared to taxi into position did…NTSB FTW88FA039Accident · 15 fatalField investigationFinal reportAerospatiale SA-330J · Eugene IslandThe helicopter, with 2 plts & 13 passengers, was on an IFR flt to a psn in the gulf of Mexico. From that psn, they proceeded under VFR to an off-shore oil drilling rig (EI-190). As the helicopter was arriving from the se, there was a strong wind from the NE.…NTSB SEA88FA032Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Eastsound, WAThe plt depd south from an unattended island arpt at sea level & flew into marginal VFR conds with moderate snowfall. Acquaintances at the arpt rprtd the plt expressed an urgent need to return to snohomish, WA, despite the wx conds. When the acft did not…NTSB LAX88LA072Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Fallbrook, CAThe plt stated that while on short final to rwy 36, approx 5 to 6 ft AGL ovr the rwy, he noticed another acft approaching fm the opposite direction. He initiated a climbing right turn and collided with a tree located abt 150 ft to the right of the rwy…NTSB NYC88LA058Accident · No injuriesLimited investigationFinal reportCessna 182 · Hammonton, NJThe aircraft had taxied to the runup area and during this process of engine runup, the pilot stated that the engine was running rough on one magneto but smooth on the other. The carburetor mixture was leaned but the engine quit. When an attempt to restart was…NTSB MIA88LA065Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Guvate, PRThe private pilot became separated from the formation of 4 aircraft and entered an area of deteriorating weather. He descended and attempted to maintain visual contact with the ground and struck trees and crashed. The pilot was not instrument rated and did…NTSB LAX88FA071Accident · 2 fatalField investigationFinal reportBeech A35 · Chino Hills, CAFailure of both pilots to see and avoid each other and thus avert the collision.NTSB FTW88FA038Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Burnet, TXThe pilot arrived in the area of his planned destination and completed the outbound and inbound procedure turns for the NDB runway 17 approach without reported incident. Almost immediately thereafter, the aircraft impacted a large oak tree about 15 feet AGL…NTSB FTW88DRG04Accident · 1 fatalFinal reportMBB 109 · Harlingen, TXThe set of floats which allows a high fuel flow in this carburetor for high power settings used for takeoff, climb, etc., had cracked and swollen to such an extent that they were rubbing against the float chamber walls and float chamber shroud tubes. This…NTSB DEN88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Las Cruces, NMWhile practicing crosswind landings the instructor stated that the student touched down normally with aprx 5 knot crosswind. Upon touch down, the right main landing gear separated from the acft causing substantial damage. There were no injuries and no fire.…NTSB DEN88LA038Accident · No injuriesLimited investigationFinal reportCessna T210R · Bismarck, NDThe plt was attempting to takeoff at dusk on a gravel road. The acft veered off of road and hit a ditch.NTSB ANC88FA022Accident · Minor injuriesField investigationFinal reportCessna 208 · Bethel, AKThe plt had planned to back taxi for takeoff on rwy 36. The tower controller asked if a rwy 18 departure would be acceptable to accommodate an arriving acft & the plt accepted a clnc. He started his takeoff with 3900' remaining on the 6399' rwy. After initial…NTSB MKC88LA030Accident · No injuriesLimited investigationFinal reportCessna 150H · Siloam Springs, ARWhen the airplane was on downwind, the pilot thought he was pulling on the carburetor heat. The pilot attempted to apply power on final and found the engine was windmilling. The pilot found he had pulled the mixture instead of the carburetor heat. During the…NTSB MIA88LA067Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA5A · Marathon, FLWhile on a personal flt shortly after takeoff at an alt of aprx 400 ft, the plt reported that the eng quit shortly after she turned off the electric fuel pump. Attempts to restart were unsuccessful. A forced landing followed during which the acft collided…NTSB MIA88LA066Accident · No injuriesLimited investigationFinal reportCessna A188B · South Bay, FLThe plt attempted a landing on a narrow runway, on an embankment. The airplane swerved to the left, into a crosswind, and left the rwy. The right main ldg gear collided with a boulder; the airplane nosed over and came to rest in the water.NTSB CHI88FA035Accident · 1 fatalField investigationFinal reportBeech 58 · Wedron, ILThe airplane struck trees and descended uncontrolled into a river while attempting a night forced landing after running out of fuel during a cargo flight. The airplane was found under water on the fifth day of a search conducted by the cap after two boys…NTSB BFO88FA010Accident · Serious injuriesField investigationFinal reportSwearingen SA-226 · Chantilly, VAThe acft had descended through a cloud layer enroute for the scheduled lndg at iad and according to the crew had picked up some trace rime ice on its wing surfaces. Although pitot and sas (stall avoidance system) heat were used the captain elected not to use…NTSB MIA88WA086Accident · No injuriesForeign investigationBoeing 747-124F · Bogota, ColombiaNTSB FTW88LA040Accident · No injuriesLimited investigationFinal reportHughes 269A-1 · Eldorado, TXWhile the pilot was attempting to land in a clearing, the main rotor blades contacted a tree causing the aircraft to descend uncontrolled for about 40 feet. The helicopter struck the ground in a nose low attitude causing damage to the skids, bubble, rotor…NTSB ATL88FA066Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Monroe, NCReptdly, the flt purpose was to administer a bfr to the plt/owner of the acft. The first takeoff was aborted. The acft deptd again without an apparent problem. After about 30 minutes, the apt mgr heard and saw the acft in a vertical descent and rotating about…NTSB MKC88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osceola, ARThe airplane was being jump-started from an automobile. The flight instructor left for some equipment when the student called him back and said there was smoke in the cabin. The airplane started to burn and was demolished. The student stated there was a…NTSB MKC88FA028Accident · No injuriesField investigationFinal reportAero Commander 680FL · Kansas City, MOAt 2108:57 ea flt 275(EA275) a Boeing 727, was cleared to takeoff on runway 19 and at 2110:24 N6509V, an Aero Commander,was cleared to taxi into position and hold. N6509V entered runway 19 near mid-field at taxiway A-3 without advising the tower of his intent…NTSB ATL88LA065Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Elizabethtown, KYAfter a short stop btn flts, the battery was too weak to crank the eng. The plt elected to hand-prop the eng while his non-rated pax held the brakes. He briefed the pax on the proper procedure. He had previously allowed the pax to operate the brakes while…NTSB SEA88FA031Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Lakeport, CAAlthough weather conditions were marginally VFR at his departure point, and the pilot had access to a vehicle which could have been used to drive to his dest, he departed novato, CA, enroute to Lakeport, CA, without obtaining a wx briefing nor filing a flt…NTSB NYC88LA057Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Rome, NYThe flight was enroute from watertown to glens falls, new york when snow squalls of varying intensity and gusty wind conditions were encountered. The pilot stated that forward visibility was marginal. The engine failed shortly after changing heading towards…NTSB MIA88LA064Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Marathon, FLWhile on a personal flt after the plt lowered the landing gear for landing, the left main landing gear did not extend. The plt continued the apch, & after touchdown, the acft veered off the rwy, collided with trees, then came to rest. According to FAA…NTSB DEN88FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Draper, UTDrg a ngt flt to reposition the acft to its home base, the eng lost pwr as the plt was cruising at about 1000' AGL. He transmitted a 'mayday' call & maneuvered the acft to make a forced lndg on an interstate hiway. While apchg to lnd, the acft struck the top…NTSB MKC88FA027Accident · Serious injuriesField investigationFinal reportBritish Aerospace BAE-3101 · Joplin, MOThe capt stated that he had planned the approach at a higher-than-normal airspeed and altitude due to a reported low level windshear. At 400 feet AGL the acft entered a light downdraft but the crew corrected the descent profile with power. At 200 feet AGL the…NTSB MIA88FA063Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Geneva, ALPrior to the acdnt, a witness saw the acft flying across an open field at a very low alt. Subsequently, it collided with the tops of several pine trees at about 90 to 95 ft AGL, then it crashed to the ground. No preimpact part failure or malfunction was…NTSB ATL88LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Grantham, NCThe airplane touched down initially on the nose wheel, and the nose landing gear collapsed. The airplane subsequently nosed over. The student plt reportedly had about 2 hrs total PIC (solo) flt time.NTSB SEA88LA030Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Aurora, ORA single engine aircraft was taxiing from the south end of the ramp area to the runway. A twin engine aircraft entered the taxiway in front of the single engine aircraft from the right of the taxiway. The single engine aircraft struck the twin engine aircraft…NTSB MIA88LA062Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Ocoee, FLThe plt rprtd that before takeoff, he made a thorough preflt, which included a check of the fuel sys for contaminates & water, but no discrepancies were noted. Shortly after takeoff, at an alt of aprx 100 ft, the eng sputtered & lost pwr. The plt stated he…NTSB MIA88LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fellsmere, FLWhile on a business flt over the company's property the plt elected to land the acft on a 40 foot wide dirt road. After touchdown the acft drifted off the left side of the road, due in part, to a crosswind. The left wing collided with a tree.NTSB LAX88LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Tracy, CAThe surface wind was strong when the pilot began taxiing for takeoff. He did not obtain a preflight weather briefing for the flight. As the aircraft taxied from behind a hangar the strong wind lifted one of the wings and the aircraft rolled over on its back.NTSB ATL88LA063Accident · No injuriesLimited investigationFinal reportCessna 150K · Portland, TNThe student plt rptd that the airplane veered off the rt side of the rwy into a ditch while ldg in x-wind conditions. The student plt estimated that the wind velocity was 10 KTS with gusts to 20 KTS. The student rptdly had about 32 hrs total flt experience,…NTSB ATL88FA060Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Moultrie, GAThe plt was on a personal VFR flt with his wife and son. During the course of the flt, he entered deteriorating weather conditions. He was advised that there were scattered rain showers ahead. He continued on his track and advised apch control that he had…NTSB MKC88LA024Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Coffeyville, KSWhile trying to start the acft with a low battery, PIC exited the acft and pulled the propeller one quarter of a turn to get it past the compression cycle. Engine started with pax aboard and proceeded to taxi. PIC was unable to stop the acft, and pax, after…NTSB MIA88LA060Accident · No injuriesLimited investigationFinal reportMooney M20J · St Theresa, FLWhile in cruise flt at 3000 ft south-southeast of st. Theresa, FL over the gulf of Mexico, the plt reported a total loss of power. Attempts to restart were unsuccessful. The acft was then ditched aprx 11 nautical miles & 146 degrees from st. Theresa, FL, near…NTSB LAX88LA050Accident · No injuriesLimited investigationFinal reportCessna 150H · Fullerton, CAAs the aircraft began its initial climb after takeoff, the engine began to run rough and the pilot elected to land on a street. The aircraft impacted street signs during the ground roll and collided with the street curbing. Post acc investigation revealed the…NTSB LAX88DVD01Accident · No injuriesFinal reportTexas Helicopter Wasp/M74L · Petaluma, CADuring an aerial application flight, while on the last pass, the aircraft struck a power line that became entangled in the rotor blades. The pilot was unable to maintain control of the aircraft and collided with the terrain. There were no reported mechanical…NTSB ATL88LA062Accident · No injuriesLimited investigationFinal reportCessna 172P · Columbus, OHAt 1343 EST, the student plt contacted apch ctl & asked for lndg info. He was adzd to continue VFR for rwy 31. When he contacted the tower at 1347, the wind was fm 200 deg at 13 KTS. Tower psnl gave him the choice of rwy 31 or 28L; he elected to lnd on rwy…NTSB ATL88LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Richmond Hts, OHThe plt began taking off on rwy 23 with a wind from 160 deg at 13 KTS. The tower ctlr saw the acft turn sharply to the left after lift-off & subsequently impact about 250' left of the rwy. The ctlr said the plt appeared to have 'jerked' the acft off of the…NTSB ATL88FA059Accident · 2 fatalField investigationFinal reportCessna 421A · Hilton Head Isl, SCAcft depted coastal arpt at night with 400 ft partial obscuration in patchy fog. Ground witnesses who heard acft depicted a circling flt path to the right after takeoff. Eng, prop & turbo teardowns demonstrated both engs were operating at high power & no…NTSB ANC88FA020Accident · 1 fatalField investigationFinal reportCessna 207A · Ambler, AKThe plt of the air taxi cargo flt was operg at night in marginal VFR conds when the acft struck rising terrain. The acft was fnd the next day at aprx 1000 ast, some 15 mi off the intended route. The plt was unconscious & suffering fm hypothermia & other…NTSB SEA88LA082Accident · No injuriesLimited investigationFinal reportCessna TU206G · Silverdale, WAWhile on the lndg roll with a qtrg hdwnd, the acft enctrd a gust which pushed it to the left. The plt said he applied full rgt aileron, but it had no effect. As the acft was 'being blown' toward trees, the plt applied full rgt brake. He said the left wing tip…NTSB MKC88IA025Incident · Minor injuriesIncident investigationFinal reportBell 206L-3 · Little Rock, ARAn EMS helo was consumed in a fire while parked at a hospital heliport. The helo had recently returned fm a medevac flt and the on-board patient oxygen pressure was low. Two respiratory therapists participated in refilling the system after the flt. The system…NTSB MKC88FA026Accident · Serious injuriesField investigationFinal reportVarga 2150A · Conroe, TXThe pilot took off for a short flight without being sure of his fuel quantity. He was not able to locate his destination which was 32 NM from his departure airport. The engine stopped and the pilot attempted a forced landing. During the forced landing, the…NTSB MIA88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Daytona Beach, FLAlthough the plt stated that he performed a preflt & eng runup prior to departure with no problem noted, shortly after takeoff, while climbing through 350 ft, the engine RPM dropped to & stayed between 1500 & 1600. The plt was unable to maintain altitude…NTSB MIA88FA058Accident · No injuriesField investigationFinal reportEmbraer EMB 120 · Columbus, MSThe acft landed gear up while on a training flight, the crew stated that they had completed 2 hours of training when the first officer requested a single engine no flap approach demonstration. Both pilots stated that during this demonstration they neglected…