OpenAirDocs.org

NTSB investigations

3,929 cases where the first occurrence was “Airframe/component/system failure/malfunction”.

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 c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
  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.

NTSB FTW88NA106Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-30 · Dfw Airport, TXMay 21, 1988 · N136AA · Substantial damageNTSB CHI88LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Terre Haute, INMay 20, 1988 · N55786 · Substantial damageNTSB MKC88LA091Accident · No injuriesLimited investigationFinal reportCessna 170B · Bayard, NEThe pilot stated that he started the trip, from new Mexico to north dakota, the evening prior to the accident. Because of poor weather, the pilot re-routed the flight through several alternate fuel and oil stops. The flight was en route to a planned fuel stop…May 17, 1988 · N4510C · Substantial damageNTSB NYC88IA141Incident · No injuriesIncident investigationFinal reportCessna S550 · Allentown, PAWhile cruising at FL350 in light turbulence, the trailing half of the left hand outboard trailing edge flap separated from the acft. The pilot declared and emergency and landed at poughkeepsie, new york, without further incident. The portion of the damaged…May 16, 1988 · N81SH · Minor damageNTSB NYC88LA140Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Rochester, NYThe Luscombe 8E experienced a failure of the right main landing gear axle during a bounced landing. The failure occurred at the weld where the axle attaches to the landing gear strut. Examination of the fracture revealed a pre-existing crack that was not…May 15, 1988 · N2047K · Substantial damageNTSB MIA88LA169Accident · Serious injuriesLimited investigationFinal reportBoeing HP-B-377 · Miami, FLAccording to company personnel, as the acft rotated for takeoff, one generator tripped off the line. Then as the landing gear was selected up, the other three generators simultaineously tripped off. The acft was flown on an extended pattern while the crew…May 13, 1988 · HI468 · No damageNTSB ATL88IA171Incident · No injuriesIncident investigationFinal reportAerospatiale AS-355-F · Reidsville, NCMay 13, 1988 · N101UC · Minor damageNTSB SEA88LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Kennewick, WADuring landing roll the aircraft's nose gear began to shudder, with the nose gear turning 90 degrees to the left. The aircraft then nosed down onto the nose and right wing. Visual examination of the aircraft's shimmy dampener arm assembly revealed a previous…May 9, 1988 · N7090A · Substantial damageNTSB CHI88FA110Accident · No injuriesField investigationFinal reportBoeing 747-136 · Chicago, ILFailure of the number three flap track due to stress corrosion cracking. Factors contributing to this failure are insufficient design of the member and inadequate inspection and maintenance procedures to detect cracks before they propagate to a critical…May 9, 1988 · GAWND · Substantial damageNTSB DEN88FA106Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Cortez, COThe plt said that he had just taken off and reached an alt of about 300 ft when his collective control went 'limp'. The helicopter entered a descent, partially controlled by the plt using throttle and cyclic control inputs. The helicopter touched down in soft…May 7, 1988 · N8455E · DestroyedNTSB DCA88IA056Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Nr Tokyo, JapanUnited flt 97 experienced indications of uneven fuel flow from main tanks 2 and 3 at FL360 beginning about 4- hours after departure on an 11-hour transpacific flight. The fuel system had been set up for all engine feed from the nos 2 and 3 tanks. Although it…May 2, 1988 · N157UA · Minor damageNTSB CHI88LA104Accident · No injuriesLimited investigationFinal reportBeech K35 · Milaca, MNApr 29, 1988 · N6042E · Substantial damageNTSB DCA88MA054Accident · 1 fatalMajor investigationFinal reportBoeing 737-297 · Maui, HIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-89/03. 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 Flt…Apr 28, 1988 · N73711 · Substantial damageNTSB LAX88LA174Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Chico, CAApr 27, 1988 · N6601P · Substantial damageNTSB NYC88LA130Accident · No injuriesLimited investigationFinal reportBeech 35 · New Haven, CTDuring engine start the throttle jammed in the full forward position and could not be pulled back to the idle position to retard the power. The aircraft started rolling and collided with an unoccupied parked aircraft. Examination of the throttle control…Apr 25, 1988 · N4528V · Substantial damageNTSB FTW88LA093Accident · No injuriesLimited investigationFinal reportPezetel PZL-M-18 · Cheneyville, LAThe pilot said that after takeoff the aircrft seemed extremely tail-heavy and that he used 'both feet and one arm' to hold forward stick. He said the aircraft was almost uncontrollable in pitch and displayed a right turning tendendcy. The pilot returned to…Apr 25, 1988 · N4226V · Substantial damageNTSB MIA88LA204Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Myers, FLWhile en route, on a personal cross country flt, the alternator belt broke resulting in the loss of electrical power which the plt did not recognize before the battery had been drained. During the precautionary landing the acft landed hard resulting in…Apr 17, 1988 · N2032M · Substantial damageNTSB ATL88LA145Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Barnwell, SCDuring initial climb after takeoff right side of the engine cowling unfastened and began fluttering violently. The instructor assumed control of acft & made a forced landing straight ahead into a cultivated field. The acft nosed up sustaining substantial…Apr 16, 1988 · N4233E · Substantial damageNTSB MIA88LA146Accident · Minor injuriesLimited investigationFinal reportFischer STAR-LITE · Lakeland, FLThe owner/manufacturer of the homebuilt acft repaired the horizontal stabilizers, then asked the designer to test fly the aircraft. After takeoff, at an alt of aprx 7,000 feet MSL, in a nose low attitude, at 158 mph ( 28 mph greater than vne) both horizontal…Apr 13, 1988 · N20RF · DestroyedNTSB FTW88IA090Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Wichita Falls, TXThe right engine upper cowling separated during initial climb, went rearward, and shattered a window at the right rearmost passenger seat which was not occupied. The pilot secured the engine and made an uneventful landing. The cowling separated due to…Apr 13, 1988 · N905FB · Minor damageNTSB SEA88LA073Accident · No injuriesLimited investigationFinal reportHughes 269C · Sitka, AKDuring sling operations, the long line became separated and entangled in the tail rotor at about 300 feet AGL. The pilot landed the helicopter onto a beach area where it rolled over onto its left side striking the main rotor. No accident report has been filed…Apr 12, 1988 · N92PC · Substantial damageNTSB ATL88IA139Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Atlanta, GAThe left MLG outer cylinder main trunnion fractured and separated while the airplane was sitting at the gate, shortly before the planned departure. Subsequent metallurgical exam of the part revealed that it was improperly overhauled, which significantly…Apr 12, 1988 · N889Z · Minor damageNTSB LAX88LA157Accident · Minor injuriesLimited investigationFinal reportAero Commander 560 · Bullhead City, AZApr 11, 1988 · N2705B · Substantial damageNTSB SEA88FA069Accident · 2 fatalField investigationFinal reportAero Commander 680FL · Soda Springs, IDWhile en route on a night IFR cargo flt, the plt reqd & was clrd for a dscnt from an IFR cruise alt of 16,000 ft to proceed vfr-on-top. The last transmission from the acft was at 2106 when the plt acknowledged that he was familiar with the terrain along the…Apr 9, 1988 · N291NC · DestroyedNTSB DEN88LA094Accident · No injuriesLimited investigationFinal reportAgusta A109A · Sioux Falls, SDApr 9, 1988 · N33SV · Substantial damageNTSB DEN88FA091Accident · No injuriesField investigationFinal reportAerospatiale SA316B · Silver Plume, COApr 2, 1988 · N72590 · Substantial damageNTSB ATL88LA129Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Stockbridge, GAThe airplane landed with the left wheel locked, and subsequently nosed over during the ldg roll. Post-crash exam revealed that the left wheel could not be rotated in the fwd direction by hand, and that it could be rotated aft by hand only with considerable…Apr 2, 1988 · N9871C · Substantial damageNTSB MIA88LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wayside, MSWhile on an aerial application flt on short final, the plt pulled the throttle lever to reduce airspeed but it broke at the power control quadrant. The apch was continued & after acft traveled aprx 1/2 the length of the rwy, he turned the magneto switch off.…Apr 1, 1988 · N7961 · Substantial damageNTSB LAX88FA144Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Torrance, CAJust after takeoff, the plt noticed that the airspeed indicator was inoperative. The plt notified the tower that he was returning for landing and stated the problem. During the turn from base to final approach, the pilot overshot both the right and left rwys.…Mar 31, 1988 · N6574J · DestroyedNTSB MIA88LA133Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · St Petersburg, FLThe acft was climbing thru 1600 ft when the upper half of the main entry door opened & separated from the acft. The physician plt stated that he was reasonably sure that he had secured the door prior to departure. He stated that although the cabin had not yet…Mar 30, 1988 · N3645E · Substantial damageNTSB CHI88IA088Incident · Minor injuriesIncident investigationFinal reportBoeing 727-251 · Detroit, MIMar 28, 1988 · N277US · No damageNTSB LAX88FA140Accident · No injuriesField investigationFinal reportEnstrom 280C · Fremont, CAFailure of the engine to main rotor drive system due to a drive belt slippage caused by a drive pulley worn beyond its service limit. Contributing to the accident was the inadequate factory maintenance manuals which did not provide the serviceable limits for…Mar 27, 1988 · N5692P · Substantial damageNTSB CHI88LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Muncie, INWhen the pilot found that the battery would not start the aircraft, he elected to hand start it. His wife, a non-pilot passenger, was in the aircraft when it started. She attempted to close the throttle, however opened it and the aircraft began to move…Mar 27, 1988 · N7725D · Substantial damageNTSB ATL88LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Muscle Shoals, ALThe airplane experienced a loss of electrical power during the local, solo flt. The student elected to make a precautionary ldg at Muscle Shoals arpt (MSL) which was the nearest arpt. He made two attempts to land on rwy 36, with a 12-20 kt tailwind: on the…Mar 24, 1988 · N2738S · Substantial damageNTSB SEA88IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Portland, ORCrew was unable to lower the left main lndg gear. Crew then executed an emergency landing on the right main and nose gear with minor damage to the acft. The investigation revealed that the left main gear door attach fitting had a fatigue fracture.Mar 21, 1988 · N515DA · Minor damageNTSB DEN88GA088Accident · No injuriesFinal reportBell 47G-3B1 · Gobernador, NMThe commerical plt was hovering out of ground effect at 40 feet AGL. During a maneuver he reported hearing a loud bang and the rotor RPM began to decay. The plt made a hovering autorotation resulting in a hard landing. The main rotor struck the tail boom and…Mar 21, 1988 · N7863S · Substantial damageNTSB ATL88LA122Accident · No injuriesLimited investigationFinal reportCessna 310Q · Donalsonville, GAThe pilot stated that he had experienced prior brake problems and had repeated maintenance performed. He further stated that not all of the brake problems had been corrected. After landing the pilot noticed that the right brake seemed 'spongy'. He continued…Mar 20, 1988 · N7765Q · DestroyedNTSB SEA88LA059Accident · No injuriesLimited investigationFinal reportBeech A24R · Las Vegas, NVDuring climb to cruise the aircraft's door opened. The pilot then diverted to a nearby airport for a precautionary landing. During landing the pilot had difficulty maintaining directional control. The aircraft struck a runway edge light during landing roll…Mar 18, 1988 · N8307R · Substantial damageNTSB LAX88FA129Accident · 1 fatalField investigationFinal reportBeech V35B · Oildale, CAImproper maintenance given by the fixed based operator.Mar 17, 1988 · N4103A · DestroyedNTSB LAX88DVD03Accident · Serious injuriesFinal reportPaxton RV-3A · Antioch, CAWhile performing aerobatic maneuvers, the aircraft was seen to have entered a spin. At approximately 300 feet the aircraft recovered, however, the left wing was seen to be bent upward and the fiberglass tip was dangling from the wing. The aircraft impacted…Mar 15, 1988 · N87JP · DestroyedNTSB ATL88LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Butler, ALThe plt rptd that he observed the engine oil pressure indication drop to zero during a low-level pipeline patrol flight. He attempted to increase engine pwr and initiate a climb, but the engine began to run rough. He subsequently landed on the pipeline…Mar 15, 1988 · N78840 · Substantial damageNTSB LAX88DVA02Accident · Minor injuriesFinal reportBell UH-1B · Arvin, CAMar 14, 1988 · N59368 · DestroyedNTSB SEA88LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Elma, WADuring landing roll the pilot applied toe brakes. The right brake pedal went to the floor. The aircraft then veered to the left of the centerline despite the pilots attempt to groundloop the aircraft. The aircraft then rolled over an embankment, collapsing…Mar 12, 1988 · N8374C · Substantial damageNTSB DEN88DQA03Accident · 2 fatalFinal reportSurline Sidewinder · Moriarty, NMWitnesses heard the acft eng sound increase dramatically as the acft passed over a gen aviation airport. The acft was seen by another witness at low atl, estimated to be about 200 ft, as the nose pitched up. The acft then entered a spin and impacted the…Mar 12, 1988 · N185SA · DestroyedNTSB CHI88LA076Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dixon, ILMar 10, 1988 · N4072D · Substantial damageNTSB ANC88FA037Accident · 1 fatalField investigationFinal reportBeech B35 · Nome, AKThe aircraft sustained an in-flight breakup during the enroute phase of the flight. The left fitting that secures the front spars of the stabilizers to the fuselage revealed the presence of pre-existing fatigue cracking. The initial separation of the left…Mar 10, 1988 · N5115C · DestroyedNTSB LAX88DUG02Accident · Minor injuriesFinal reportPage Long EZ · Chino, CADuring a flight to test the effectiveness of the propeller, just after takeoff, one propeller blade separated from the hub. The pilot made an emergency off field landing in a soft field, where during the landing roll the aircraft collided with the terrain.…Mar 8, 1988 · N917WP · Substantial damageNTSB MIA88LA121Accident · No injuriesLimited investigationFinal reportSchleicher K-8B · Miami, FLThe plt stated that he had placed the glider into a mild dive & was indicating 90 to 95 mph, well below redline speed when the whole section of the trailing edge of the wing from the aft spar & wing root out to a dist of about 6 ft, separated from the acft.…Mar 7, 1988 · N4663S · Substantial damageNTSB ATL88LA105Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Lincolnton, NCJust after lift off for a LCL flt, the plt-in-cmd, who was in the right seat, noted the front edge of the nose baggage compt to 'pop open'. He assumed control of the acft and attempted to 'tear drop' a return to the opposite runway. During the maneuver, the…Mar 5, 1988 · N4329C · Substantial damageNTSB MKC88FA059Accident · 2 fatalField investigationFinal reportBeech E18S · Vienna, MOThe plt rcvd a wx briefing bfr starting a ngt cargo opn in known icing conds. Bfr the flt, a line serviceman noticed ice on the acft's wings & suggested its removal, but the plt declined. Aprx 45 min after tkof, the plt rprtd to ARTCC that a de-ice boot had…Mar 4, 1988 · N45A · Destroyed