NTSB investigations, 1990
134 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\") = 1990
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") = 1990 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 CHI91LA046Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Mundelein, ILLanding gear tire failure and directional control not maintained by the pic/cfi.NTSB FTW91LA023Accident · No injuriesLimited investigationFinal reportBell 206L-1 · W.Cameron 266Failure of the helicopter's aft landing gear crosstube assembly due to fatigue.NTSB SEA91LA028Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Vernal, UTA malfunction/failure of the helicopter's main rotor lead-lag damper.NTSB NYC91LA040Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Easton, PAAn inflight failure of the left side cabin mount bracket which resulted in a loss of lateral cyclic control. Factors related to the accident were: an incomplete inspection of the helicopter following a hard landing with a blade strike.NTSB MIA91GA034Accident · No injuriesFinal reportAsta N22S · Homestead Afb, FLThe bending overstress failure of the left main landing screwjack at an undetermined time during flight for undetermined reasons.NTSB LAX91LA038Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Phoenix, AZStrength degradation of the kevlar suspension cables, due to previous heat damage. Factors related to the accident were: failure of the quick release line to release, and susceptibility of kevlar suspension cables to heat.NTSB LAX91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Prescott, AZThe failure of the main landing gear trunion attach fitting for undetermined reasons.NTSB BFO91LA012Accident · Minor injuriesLimited investigationFinal reportTaylor Rotorway Executive · Keysville, VAA jammed engine throttle cable. Factors related to the accident are inadequate maintenance inspection and low rotor RPM.NTSB ATL91IA017Incident · No injuriesIncident investigationFinal reportFokker F28 MK0100 · Atlanta, GAFrozen moisture in the stabilizer actuator hydraulic servo valve which resulted in reduced movement of the servo valve and limited its ability to respond to flight control inputs. The lack of response from the servo valve resulted in the jammed stabilizer…NTSB MIA91FA023Accident · 3 fatalField investigationFinal reportCessna 421B · Flamingo, FLAn undetermined airframe/component/system failure/malfunction, which resulted in a fuel fed fire in the left wing.NTSB ATL91FA013Accident · Serious injuriesField investigationFinal reportBell 47J-2 · Gatlinburg, TNThe accident was inadequate maintenance of the helicopter, allowing a tail rotor drive shaft bearing to exceed wear limits. This resulted in high loads on the tail rotor drive shaft, and the resulting fatigue failure of the drive shaft.NTSB CHI91LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Portage, WIThe PIC became lost and disorientated and performed a premature precautionary landing.NTSB ATL91FA006Accident · 1 fatalField investigationFinal reportOlsen-Gordon Veri EZE · Hohenwald, TNThe failure of the left rudder control cable which rendered the airplane uncontrollable.NTSB NYC91DNC01Accident · 2 fatalFinal reportSkytek Skyseeker MK II · Chapman, MEIn-flight failure of the outboard section of the wing, and the loss of aircraft control. Due to the unauthorized structural modification by the pilot/owner.NTSB BFO91LA003Accident · Serious injuriesLimited investigationFinal reportMooney M20M · Culpeper, VAIntergranular cracking (fatigue) failure of the exhaust clamp, which resulted in a disconnected exhaust manifold (tailpipe), and subsequent fire in the engine compartment.NTSB CHI91DER01Accident · Minor injuriesFinal reportCessna 206 · South St. Paul, MNThe inadvertent deployment of the drag parachute. Related factors are the pilot's improper remedial action, habit interference, and the reduced aircraft controllability.NTSB CHI90LA276Accident · No injuriesLimited investigationFinal reportMooney M20E · Morrison, ILImproper maintenance of the propeller blade by unknown persons and the subsequent failure of the blade in fatigue during cruise flight. A factor was: unsuitable terrain.NTSB MIA90FA190Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Thornton, MSThe improper drilling of a hole in the spar cap by a mechanic resulting in the initiation of fatigue cracking in the spar cap and subsequent failure of the spar cap and inflight separation of the wing.NTSB BFO90FA079Accident · 1 fatalField investigationFinal reportHughes 269C · Jefferson, MDThe failure of the tail rotor drive transmission system due to a worn tail rotor splined drive sleeve, and inadequate maintenance and/or inspection by the operator. Contributing to the loss of control was the student pilot's failure to maintain adequate rotor…NTSB LAX90DXQ05Accident · Minor injuriesFinal reportGlaser-Dirks DG 400/17 · Truckee, CAThe uncommanded deployment of the right spoiler system due to the absence of a spring pin not fitted to the quick disconnect as recommended which resulted in the pilot losing control of the glider during a critical phase of flight.NTSB ATL90IA177Incident · No injuriesIncident investigationFinal reportFairchild SA 227 · Morrisville, NCThe fatigue failure of the rudder trim control rod end.NTSB LAX90LA328Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hayward, CAThe failure of the airplane's main landing gear bolt/nut plate attachment assembly. Contributing factors related to the improper installation (threading) of the gear bolt/nut assembly.NTSB ATL90LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Hertsboro, ALFatigue failure of the propeller blade which resulted from improper overhaul procedures, and the absence of oil in the propeller hub which would allow the detection of blade cracks.NTSB DEN90IA189Incident · Minor injuriesIncident investigationFinal reportBoeing 737-222 · Denver, COThe failure of the flight crew to follow emergency procedures/directives. Factors were the failure of the aircraft electrical system (relays) and the failure of the company to provide a jetway operator.NTSB FTW90FA183Accident · 1 fatalField investigationFinal reportHughes 269A · Kingsville, TXThe fatigue failure of the left flange on the tail boom saddle fitting.NTSB FTW90DPJ12Accident · No injuriesFinal reportMassegee Rebel 300 · El Reno, OKFailure of the elevator control rod at the bell crank.NTSB FTW90DRA10Accident · No injuriesFinal reportLockheed PV-2 · Conroe, TXThe engine starter remained engaged after engine start and the electrical system overheat.NTSB FTW90DPJ11Accident · No injuriesFinal reportDooley Mustang MII · Cashion, OKThe separation of a 14 inch section of one propeller blade due to previous damage.NTSB DEN90LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Springdale, ARPilot's loss of control of the aircraft, during landing, due to mechanical malfunction of the tailwheel assembly.NTSB ATL90LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Americus, GAA low cycle fatigue failure of the left main landing gear spring.NTSB CHI90LA261Accident · No injuriesLimited investigationFinal reportPiper PA-601P · Monroe, MIA fatigue fracture of the torque link on the right landing gear strut scissor assembly.NTSB CHI90LA260Accident · No injuriesLimited investigationFinal reportCessna 152 · Garrison, MNInadequate inspection of the aircraft.NTSB BFO90DID02Accident · 2 fatalFinal reportCessna 182R · Evington, VAThe pilot's failure to maintain control of the aircraft because of spatial disorientation. A contributing cause is failure of the vacuum system.NTSB LAX90LA314Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Barbara, CAA disconnect of the throttle control.NTSB ANC90LA173Accident · 2 fatalLimited investigationFinal reportPiper PA-32RT-300T · Glacier Island, AKUndetermined mechanical failure(s) that resulted in loss of engine power, smoke in the cockpit, and a subsequent emergency descent for a forced landing (ditching) at sea. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW90LA162Accident · No injuriesLimited investigationFinal reportPiper PA28-201T · Heber Springs, ARThe pilot's failure to conduct a thorough preflight and his attempt to execute a turn at high speed.NTSB CHI90DEX02Accident · No injuriesFinal reportJohnson Quickie 299 · Delphi, INPilot/mechanic's improper installation of the rudder cable turnbuckles.NTSB FTW90IA169Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 · College Station, TXPropeller and engine (powerplant) overspeed.NTSB LAX90LA296Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Temecula, CAThe pilot's inadequate preflight that resulted in his continuing flight with an inoperative alternator.NTSB ANC90LA145Accident · No injuriesLimited investigationFinal reportCessna 185B · Mcgrath, AKFailure of the left inside wheel bearing, for undetermined reasons.NTSB NYC90LA193Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-35 · Erwinna, PAInadvertent release of the tow line at low altitude. A contributing factor was the landing in unsuitable terrain.NTSB NYC90LA191Accident · No injuriesLimited investigationFinal reportCessna 150 · Salem, OHThe airplane overran the end of the runway into a corn field after an aborted takeoff, due to the engine cowling door opening. Contributing to the accident was pilot's delay in aborting the takeoff.NTSB SEA90IA161Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Belgrade, MTThe malfunction of the starter control valve.NTSB LAX90LA288Accident · No injuriesLimited investigationFinal reportCessna 421 · Concord, CAThe pilot's failure to follow the electrical system failure checklist. Contributing to this accident was the total electrical failure for undetermined reasons and the landing gear being unlocked.NTSB LAX90DVM03Accident · 1 fatalFinal reportIlli Thunder Gull · Calif Valley, CAPoor judgement of the pilot from use of a drug (cocaine), and the pilot allowing the design stress limits of the aircraft to be exceeded, while maneuvering, which resulted in overload failure of the wing spar & wing separation.NTSB ANC90LA136Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKFailure of the right main landing gear spring upon landing.NTSB CHI90DTG02Accident · No injuriesFinal reportHiller UH-12-E · Garrison, NDThe failure of the helicopter tail rotor control cable. A factor related to the accident was the chafing of the tail rotor control cable.NTSB LAX90LA272Accident · Minor injuriesLimited investigationFinal reportStinson L-5B · Victorville, CAThe oil gauge line 'b' nut backed off, and the pilot failed to maintain airspeed.NTSB NYC90DNA04Accident · No injuriesFinal reportBell 47G-3B-1 · Hanson, MAThe pilot's loss of control of the helicopter due to the failure of the tail rotor drive shaft.NTSB BFO90LA065Accident · No injuriesLimited investigationFinal reportRobinson R22 · Paducah, KYThe loss of tail rotor thrust due to improper part installation.