NTSB investigations, 1998
135 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 177 |
|---|---|
| 1983 | 260 |
| 1984 | 220 |
| 1985 | 186 |
| 1986 | 184 |
| 1987 | 182 |
| 1988 | 194 |
| 1989 | 141 |
| 1990 | 134 |
| 1991 | 144 |
| 1992 | 149 |
| 1993 | 132 |
| 1994 | 115 |
| 1995 | 141 |
| 1996 | 148 |
| 1997 | 139 |
| 1998 | 135 |
| 1999 | 132 |
| 2000 | 146 |
| 2001 | 120 |
| 2002 | 140 |
| 2003 | 140 |
| 2004 | 122 |
| 2005 | 113 |
| 2006 | 114 |
| 2007 | 121 |
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\") = 1998
AND 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.
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") = 1998 AND 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
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 CHI99LA057Accident · No injuriesLimited investigationFinal reportMooney M20E · Tryon, NEother maintenance personnel's not correcting a loose cylinder assembly. Factors were loose engine cylinder assembly, fractured cylinder mounting hardware, the roadway, and road sign.NTSB LAX99LA061Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · San Ysabel, CAA fatigue fracture of the crankshaft and the resulting separation of the propeller.NTSB LAX99FA051Accident · No injuriesField investigationFinal reportLearjet 55B · Los Angeles, CAthe total loss of electrical power due to the flight crew's failure to complete the engine start checklist, or the electrical power failure checklist, which kept the generators off line and resulted in the complete discharged of both batteries. Also causal to…NTSB MIA99IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Orlando, FLA discharged battery due to a loss of electrolyte, and the latent shorted failures of the No. 1 and 2 generator control unit (GCU) blocking diodes (CR910) for undetermined reasons. These failures resulted in an excessive current drawn from both GCUs, during…NTSB SEA99LA020Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Darrington, WAThe total separation of the vertical fin (stabilizer), as the result of fatigue cracks which initiated in the fourth rivet hole above where the fin extends from the tailboom.NTSB CHI99LA045Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Ankeny, IAthe elevator control system jammed for undetermined reasons.NTSB ATL99LA024Accident · Serious injuriesLimited investigationFinal reportBeech 33-F33A · Fernandina Bch, FLThe Pilot's failure to maintain flying airspeed that resulted in a loss of control and an inadvertent stall. Factors were several electrical system component malfunction.NTSB FTW99LA045Accident · No injuriesLimited investigationFinal reportLockheed L-1329 · Austin, TXThe steering actuator fatigue failure resulting from inadequate procedure documentation for the manufacturing process.NTSB LAX99LA040Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164C · Oroville, CAThe pilot's decision to attempt readjustment of the rudder pedal in-flight.NTSB FTW99LA034Accident · Serious injuriesLimited investigationFinal reportStanton Staros SA 260 · Marion, TXThe fuel leak for an undetermined reason which resulted in an in-flight fire.NTSB NYC99FA026Accident · 1 fatalField investigationFinal reportCessna 414A · Mattapoisett, MAThe pilot's failure to maintain control of the airplane after an undetermined failure of the airplane's attitude indicator. A factor in this accident was fog.NTSB DEN99LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Erie, COThe shorting of the aluminum battery wire and the subsequent failure of the fuel line. Factors were the weak/deteriorated battery, the insufficient information in the airplane's POH about charging an airplane's battery, and the fire in the crew compartment.NTSB SEA99FA013Accident · 1 fatalField investigationFinal reportHiller UH-12E · Marshall, WAThe loss of the bolt that connects the lateral cyclic linkage push rod to the lower end of the upper firewall-mounted lateral cyclic linkage bellcrank, resulting in an uncontrolled descent into the terrain.NTSB ATL99IA015Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Atlanta, GAFailure of the Company's maintenance personnel to follow the aircraft's maintenance manual which resulted in a cargo bin fire. Contributing to the severity of the incident was the failure of the mechanic to safety the circuit breaker, and the cut/severed…NTSB MIA99LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Lauderdale, FLThe failure of the pilot-in-command to note that the flaps did not retract while the pilot-rated student performed a touch-and-go landing on a 6,001 foot-long runway. Factors in the accident were the total failure of the flap system for undetermined reasons…NTSB NYC99IA024Incident · No injuriesIncident investigationFinal reportBoeing 737-3TO · Newark, NJA loss of torque on the apex nut of the shimmy damper for undetermined reason(s), which resulted in a failure of the shimmy damper, and the subsequent failure of the lower torsion link of the right main landing gear.NTSB CHI99LA016Accident · Minor injuriesLimited investigationFinal reportCessna 310I · Janesville, WIThe pilot's inadequate preflight inspection in which he failed to remove the tow bar from the nose gear. Also causal was his misjudgment of distance and altitude from the runway which resulted in both his premature shutdown of the engines and an undershoot of…NTSB DCA99MA007Accident · Minor injuriesMajor investigationFinal reportBoeing 737-200 · Atlanta, GA(1) the capping of the incorrect hydraulic line by mechanics, which led to the failure of hydraulic system A; (2) the mechanics' lack of experience working with the Boeing 737 hydraulic system; and (3) the maintenance controller's failure to ascertain more…NTSB CHI99LA012Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Clinton, IAthe failure of the 90 degree gearbox for reasons undetermined. Factors were the failure of the gearbox, and it not being possible for the pilot to maintain control of the aircraft.NTSB FTW99FA016Accident · 1 fatalField investigationFinal reportKolb Twinstar TA-2 · Bryan, TXThe pilot's loss of control as result of the partial separation of the elevator trim tab resulting in the inability to maintain aircraft control. A factor was the improper design and installation of the elevator trim tab.NTSB LAX99IA013Incident · No injuriesIncident investigationFinal reportBoeing MD-11 · Honolulu, HIA jammed spoiler control pulley system caused by a shop rag left in an area of recent maintenance. Neither the maintenance organization nor the mechanic responsible could be determined.NTSB IAD99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Teteboro, NJthe collapse of the landing gear due to a bent gear locking mechanism for undetermined reasons.NTSB MIA98LA254Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Oxford, MSThe pilot's failure to maintain directional control due to vibration from the main rotor blade for undetermined reasons. A related finding was the improper repair of a crack in the laminant of the blue main rotor blade by other maintenance personnel.NTSB SEA98LA178Accident · No injuriesLimited investigationFinal reportCessna 414 · Burley, IDA brake system failure for undetermined reasons. An intentional ground loop was a factor.NTSB FTW98LA412Accident · No injuriesLimited investigationFinal reportCessna 152 · Durango, COImproper maintenance by an unknown person and the subsequent throttle cable disconnect due to a castellated nut separation. Factors were the none suitable soft terrain for the forced landing, and the failure of the nose wheel landing gear during the landing…NTSB LAX98FA305Accident · 1 fatalField investigationFinal reportO'Neil VAN'S RV-3 · Arbuckle, CAThe pilot's attempt to continue VFR flight in instrument conditions, which led to his spatial disorientation and in-flight loss of aircraft control, and, resulted in a pilot-induced overload failure of the airframe. The pilot's use of quinine may have been a…NTSB ANC98LA164Accident · No injuriesLimited investigationFinal reportGrumman S2F-1 · Wasilla, AKThe failure of the recently overhauled right brake seal resulting in a total loss of brake fluid, failure of the right brake system, and subsequent inability of the pilot to utilize the brake. A contributing factor was the soft terrain.NTSB LAX98LA299Accident · No injuriesLimited investigationFinal reportCessna 185E · Mesa, AZThe failure of the wheel assembly retention nuts and subsequent wheel separation.NTSB ATL98LA123Accident · Minor injuriesLimited investigationFinal reportVertical Concepts Searey · Hiawassee, GAThe delamination of the hull that resulted in a nose over during landing.NTSB MIA98LA230Accident · No injuriesLimited investigationFinal reportBell 47D1 · Dawson, GAThe pilot's selection of unsuitable terrain for landing resulting in debris being blown up during landing resulting in damage to the tail rotor and loss of control.NTSB CHI98LA342Accident · No injuriesLimited investigationFinal reportMBB BK-117 · Topeka, KSthe pilot's failure to assure the engine cowling was secured during the aircraft preflight which resulted in the cowling separating from the helicopter and damaging the main rotor and tail rotor system. Factors associated with the accident were the cowling…NTSB CHI98LA341Accident · No injuriesLimited investigationFinal reportCessna 210D · Sturgis, MIthe cracked left main landing gear saddle, resulting in the pilot's inability to get the gear into the down and locked position.NTSB NYC98LA172Accident · No injuriesLimited investigationFinal reportEkstrom-Farrington Twinstar · Paducah, KYFailure of a through-bolt that attached the lateral control arms to the yoke assembly, due to unanticipated rotor brake forces through the flight control system.NTSB CHI98LA326Accident · No injuriesLimited investigationFinal reportCessna 150B · Lamar, MOinadequate lubrication of the torque plate holes and torque pins by the mechanic who performed the airplane's last annual inspection.NTSB CHI98FA323Accident · 3 fatalField investigationFinal reportBell 222 · Spencer, IAThe below standard (loose) fit of the 'white' swashplate outer ring pin resulting in fatigue and subsequent separation of the pin, and ultimately the in-flight breakup of the rotorcraft. A factor was the manufacturer's dissemination of the pin which did not…NTSB FTW98LA368Accident · No injuriesLimited investigationFinal reportMassey Christen Eagle II · Galveston, TXThe inflight structural failure of the wing spars for the lower wings due to an undetermined reason.NTSB ATL98LA118Accident · No injuriesLimited investigationFinal reportPiper PA-30-39 · Greenville, NCA loose wiring connection at the landing gear motor relay that prevented the electrical extension of the landing gear.NTSB FTW98FA364Accident · Minor injuriesField investigationFinal reportBeech 1900D · Denver, CODebonding of the propeller erosion shield due to an improper overhaul and repair by other maintenance personnel.NTSB FTW98IA361Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Denver, COA hydraulic failure due to a ruptured hydraulic line, preventing the extension of the nose and right main landing gear.NTSB SEA98LA166Accident · No injuriesLimited investigationFinal reportCessna 175 · Missoula, MTA complete loss of crankcase oil due to a missing oil filler tube followed by the failure of a connecting rod. Factors include encountering a small pine tree during the landing roll.NTSB MIA98LA226Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Conway, SCThe total failure of the left wing forward and aft attachment fitting due to corrosion and fatigue during a banner tow pick-up resulting in a subsequent in-flight collision with terrain.NTSB ANC98TA125Accident · No injuriesFinal reportBell 206B II · Chickaloon, AKA fracture of the main rotor drag pin assembly.NTSB SEA98LA162Accident · Minor injuriesLimited investigationFinal reportCessna T337E · Hillsboro, ORThe disengagement of the pilot seat forward and aft movement locking pin, followed by the pilot's seat sliding to the rear of the seat track.NTSB SEA98LA158Accident · No injuriesLimited investigationFinal reportCessna 182 · Yellowpine, IDRight main landing gear spring strut fatigue, improper maintenance, and subsequent separation of the strut end.NTSB ATL98LA102Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Bern, NCThe failure of the inner cable of the carburetor heat cable assembly that prevented the application of carburetor heat. Factors were conditions favorable for the formation of carburetor ice.NTSB MIA98LA218Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Pensacola, FLThe pilot's failure to maintain a proper sink rate during an emergency landing resulting in impact with trees and subsequent stall and impact with the terrain.NTSB LAX98TA251Accident · No injuriesFinal reportAero Commander 690 · Ely, NVThe failure and separation of the left main gear wheel halves due to overload as a result of excessive air pressure. A contributing factor was the inadequate maintenance/service of the main gear tires.NTSB CHI98LA281Accident · No injuriesLimited investigationFinal reportLuckey Dragonfly II · Caro, MIan improper inflight decision when he mistook the road for the runway of the nearby airport to land on. A factor in this accident was the total failure of the engine's crankshaft.NTSB SEA98LA146Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Libby, MTA failure of the external load cable, which became entangled in the tail rotor.NTSB CHI98LA272Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Falls City, NEthe main landing gear leg fracturing and separating from the portion mounted to the fuselage for undetermined reasons.