NTSB investigations, 1991
144 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\") = 1991
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") = 1991 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 NYC92DEG01Accident · Minor injuriesFinal reportDevenport EAA Biplane · Wilksville, OHThe restricted visibility of the pilot due to oil on the windshield and his goggles, which resulted in a tree strike and uncontrolled touchdown, during the execution of a precautionary landing. Factors related to the accident were a clogged crankcase breather…NTSB SEA92LA027Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Klamath Falls, ORPilot factor in that he failed to follow IFR procedures. Factors to the accident were generator failure, operation with known deficiencies with equipment, and poor inflight planning.NTSB NYC92IA042Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-310-324 · Covington, KYThe installation of an improper restrictor in the bleed air line by the manufacturer, which caused the rvdt to fail due to heat, and brought about the uncommanded power loss.NTSB DEN92IA014Incident · No injuriesIncident investigationFinal reportCessna 172RG · Broomfield, COFailure of the left main landing gear pivot assembly due to ductile torsional overstress.NTSB LAX92FA054Accident · 4 fatalField investigationFinal reportAerospatiale SA 316B · Bridgeport, CAFailure of the helicopter's tail rotor drive shaft and drive shaft bearing due to undetermined reason(s).NTSB NYC92LA036Accident · No injuriesLimited investigationFinal reportPiper PA-31-T1040 · Portland, METhe excessive fuel pressure during inflight fuel transferring, which resulted in the rupture of the wing tank and subsequent damage to the wing. Also causal to the accident was the inadequate fuel tank vent system and the inaccurate fuel quantity system.NTSB LAX92LA050Accident · 1 fatalLimited investigationFinal reportSpeyer Avid Amphibian · San Ysidro, CAFailure of the pilot/builder to follow the manufacturer's recommended airframe modification procedure to prevent the inflight loss of a flaperon due to flutter. Contributing to the accident was in inflight separation of the wing when the design limits of the…NTSB CHI92LA031Accident · No injuriesLimited investigationFinal reportCessna 310R · South St Paul, MNThe inadequate design of the propeller hub assembly which resulted in metal fatigue and propeller blade separation during initial climbout.NTSB NYC92IA035Incident · No injuriesIncident investigationFinal reportSaab-Fairchild SF-340A · Buffalo, NYA fatigue fracture on the propeller shaft, that originated at a subsurface slag inclusion, which remained in the material used to manufacture the shaft.NTSB ATL92IA025Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAA short in an electrical connector which resulted in its failure. The reason for the short was not determined. A factor was the improper installation of the connector by an unknown maintenance person.NTSB NYC92DNE01Accident · Serious injuriesFinal reportAdvanced Buccaneer SX B1B-503 · Palmer, MAA failed lower rudder attach pivot bolt which resulted in jammed flight controls and an uncontrolled descent into trees.NTSB FTW92LA020Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Epps, LAThe loss of 1/2 of a propeller blade. Factors were powerplant vibration and resultant powerplant separation.NTSB LAX92LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Sacramento, CAThe partial failure of the brake system due to contamination.NTSB LAX92LA038Accident · No injuriesLimited investigationFinal reportQuestaire Venture · San Luis Obispo, CAThe pilot's inability to control the aircraft during the landing roll due to a failure of the left brake and nose wheel steering systems. The failure of the brake and steering systems was due to a deterioration of the 'o' ring seals caused by the use of…NTSB LAX92LA034Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Riverside, CAThe failure of the engine to transmission drive belt and the pilots failure to correctly judge of the landing flare during the subsequent autorotation.NTSB CHI92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNInadequate preflight planning and preparation by the pilot in command, the non performance o fan emergency procedure and not maintaining a positive rate of climb on behalf of the pilot in command. Factors contributing to the accident were the pilot in…NTSB SEA92LA029Accident · No injuriesLimited investigationFinal reportAerospatiale AS355F1 · Billings, MTThe unlatching and subsequent opening inflight of the left-rear engine cowl door. A factor contributing to the accident was the failure of company maintenance personnel to execute the manufacturer's service bulletin.NTSB LAX92IA027Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Las Vegas, NVRupture of a forward pressure bulkhead because of cyclically induced metal fatigue. Factors which contributed to the incident were: the operator's decision not to structurally modify its airplane in accordance with the manufacturer's but rather to rely on the…NTSB FTW92FA015Accident · Serious injuriesField investigationFinal reportBellanca 17-30A · Cotulla, TXThe pilot's failure to maintain aircraft control. Factors related to the accident were: darkness, and a short in the electrical system which resulted in partial failure of the instrument lights and a malfunction of the autopilot.NTSB ATL92LA017Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Rome, GAThe failure of a tail rotor blade for undetermined reasons.NTSB LAX92FA025Accident · Minor injuriesField investigationFinal reportAerospatiale AS350B · Scottsdale, AZAn undetermined malfunction of the hydraulic system in which the system was locked, preventing the movement of the flight controls, and loss of directional control.NTSB LAX92FA017Accident · 2 fatalField investigationFinal reportCessna 414 · Long Beach, CAThe pilot's improper emergency procedures by not retracting the landing gear when he shut the engine down and his failure to maintain airspeed. The scavenge pump failure, shutting down the engine and the inadvertent stall were factors in the accident.NTSB NYC92LA018Accident · Serious injuriesLimited investigationFinal reportBoeing 737-4B7 · Boston, MAA latch failure on a door in the aft galley which allowed a liquor kit to roll forward.NTSB CHI92LA017Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas MD369D · Beech Grove, INImproper installation of the flight control linkage during maintenance. Complacency and inadequate inspection of the helicopter by maintenance personnel and the pilot are factors in the accident.NTSB LAX92LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Compton, CAThe improper maintenance of the alternator's drive belt by the aircraft owner which resulted in its total failure. A factor which contributed to the accident was the inadequate distance available for the pilot to stop the airplane.NTSB NYC92LA011Accident · No injuriesLimited investigationFinal reportAerospatiale ND-26 · Albany, NYInadequate quality control during maintenance or manufacturing by failing to use corrosion inhibiter, which resulted in corrosion, fatigue, and subsequent failure.NTSB CHI92DEP01Accident · No injuriesFinal reportLassiter Swearingen SX300 · Eagle River, WIThe partial loss of engine power, for reasons undetermined which resulted in an aborted takeoff and eventual overrun and landing gear collapse.NTSB CHI92LA012Accident · No injuriesLimited investigationFinal reportRockwell 112YC · Detroit, MIThe pilot's failure to perform a major repair and continued operation of the airplane with known deficiencies.NTSB MIA92LA014Accident · No injuriesLimited investigationFinal reportBell 47G-5 · La Belle, FLThe pilot in command's improper aft application of cyclic control during an autorotative landing to an open field, resulting in the main rotor blades colliding with the tail boom. Contributing to the accident was the in flight failure of the outer bearing of…NTSB SEA92LA011Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Hyder, AKThe failure of the tail rotor hub assembly. Factors include unsuitable terrain, and high vegetation.NTSB CHI92LA006Accident · No injuriesLimited investigationFinal reportCessna 421B · Battle Creek, MIThe total failure of the right main landing gear's downlock link assembly.NTSB MIA92LA005Accident · No injuriesLimited investigationFinal reportBell 206-L-1 · Hollywood, FLThe failure of the pilot to maintain rotor RPM and the failure of the CFI to monitor the controls.NTSB MIA92LA010Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Vieques, PRInadequate aircraft maintenance inspection resulting in the defective muffler which failed and caused an inflight fire.NTSB CHI91DEV05Accident · No injuriesFinal reportUllman Vari Viggen · Greenville, ILImproper maintenance installation of the propeller.NTSB NYC91LA250Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Utica, NYFatigue cracking of the propeller hub.NTSB CHI91FA305Accident · 1 fatalField investigationFinal reportErcoupe Ercoupe 415-D · Emmett, MIThe pilot's exceeding the design limits of the aircraft, which resulted in an inflight breakup.NTSB ATL91LA180Accident · No injuriesLimited investigationFinal reportContinental Copters MK5A · Franklin, GAAn undetermined failure of the tail rotor control cable, which resulted in an uncontrolled collision with the ground.NTSB FTW91DPG20Accident · No injuriesFinal reportAyres S2R · Dumas, ARThe failure of a worn rudder adjustment bar. A factor was the pilot's inability to maintain directional control.NTSB CHI91LA303Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Newark, ILA sheared oleo piston retaining pin which allowed the wheel to fall out.NTSB CHI91DTK04Accident · 1 fatalFinal reportBoland/Poe Tsunami · Pierre, SDA bending overload failure of the wing flap control rods and remedial action by the pilot was not possible. Factors in the accident are the inadequate design of the wing flap system by the pilot/operator manufacturer and his lack of total experience in type…NTSB ATL91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Brewton, ALThe inflight separation of the left wing resulting from corrosion of the wing front spar fitting assembly. A factor was inadequate maintenance procedures.NTSB LAX91LA398Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-602P · Pago Pago, AntarcticaThe mechanical failure of the airplane's nose wheel/gear steering system. A contributing factor was the pilot's inability to maintain directional control following the loss of steering effectiveness.NTSB CHI91LA278Accident · No injuriesLimited investigationFinal reportCessna 310J · Sugar Grove, ILThe buckled nose landing gear retraction/extension gear drive tube. A factor in the accident was the pilot in command not having the landing gear inspected at the interval recommended by the manufacturer.NTSB CHI91IA297Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Detroit, MIInadequate maintenance inspection of the main landing gear actuator assembly by company maintenance personnel. A factor in the incident is inadequate design of the landing gear actuator by the manufacturer.NTSB NYC91LA240Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Slippery Rock, PAThe on ground collision with a farm vehicle during landing roll out.NTSB CHI91LA300Accident · Serious injuriesLimited investigationFinal reportATR ATR 42-300 · Muskegon, MIThe failure, for reasons unknown, of the number four bearing in the high pressure spool of the engine.NTSB DCA91MA052Accident · 14 fatalClass 1 · MajorFinal reportEmbraer 120 · Eagle Lake, TXThe failure of Continental express maintenance and inspection personnel to adhere to proper maintenance and quality assurance procedures for the airplane's horizontal stabilizer deice boots that led to the sudden in-flight loss of the partially secured left…NTSB NYC91LA232Accident · No injuriesLimited investigationFinal reportPiper PA46-350P · Dayton, OHA malfunction of the elevator trim indicator and incorrect position of the trim tab which resulted in the pilot aborting the takeoff and a loss of directional control on the ground.NTSB NYC91LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJAn off airport landing in unsuitable terrain following a power loss due to oil exhaustion. A factor related to the accident was the operators decision not to follow the recommendations of the Piper cherokee service manual.NTSB FTW91FA155Accident · 1 fatalField investigationFinal reportBell 412 · Garden BanksOverheating and subsequent failure of the number one tail rotor hanger bearing for an undeterined reason, and failure of the tail rotor drive shaft.