NTSB investigations, 1995
141 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
Latest 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\") = 1995
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") = 1995 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 FTW96LA082Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Durango, COthe failure of the nose wheel steering mechanism which rendered the aircraft uncontrollable on the ground. A factor was the rough and uneven terrain.NTSB CHI96IA066Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Bemidji, MNinadequate maintenance installation and inspection of the elevator flight control system which led to restricted flight control elevator movement due to a loose bolt.NTSB FTW96IA080Incident · No injuriesIncident investigationFinal reportBeech 1900C · Denver, COfailure by the outside contractor to perform adequate maintenance, and failure by the operator to perform an adequate inspection.NTSB MIA96LA043Accident · 2 fatalLimited investigationFinal reportPro Star PRO Tech · Sebring, FLthe pilot-in-command(CFI) allowed the airplane's design limits to be exceeded which resulted in the overload failure and separation of the right wing.NTSB FTW96LA069Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · West Helena, ARBinding of the power lever linkage, due to corrosion, which resulted in a situation that led to an inadvertent shut-down of the engine at a critical point on the approach to land. A factor relating to the accident was: inadequate maintenance.NTSB LAX96IA065Incident · No injuriesIncident investigationFinal reportBeech 99 · Salt Lake City, UTimproper installation of the rudder control cable by company maintenance personnel, which resulted in chafing and/or fatigue and subsequent failure of the cable.NTSB SEA96LA025Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Scotts Mills, ORThe pilot's failure to maintain adequate clearance from the ground.NTSB FTW96LA052Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Fredericksburg, TXthe pilot's failure to maintain directional control. Factors were the binding tailwheel and the pilot's lack of experience in tailwheel airplanes.NTSB CHI96LA041Accident · No injuriesLimited investigationFinal reportMcclung SEA Hawk · Marengo, ILthe failure of the upper right wing due to the presence of unbonded areas between the spar cap and the bidirectional fiberglass. The unbonded areas were due to the inadequate manufacturing of the airplane by the owner/builder. A factor in the accident was the…NTSB FTW96FA046Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Cypress, TXThe pilot's failure to maintain aircraft control while flying in instrument meteorological conditions. Factors were the weather, and the failure of the airplane's vacuum pump which rendered the attitude indicator and the directional gyro inoperative.NTSB BFO96LA026Accident · No injuriesLimited investigationFinal reportCessna 210E · Newport News, VAthe failure of the engine-driven hydraulic pump drive shaft, the pilot's failure to properly engage the emergency landing gear handle.NTSB SEA96LA013Accident · No injuriesLimited investigationFinal reportCessna TR182 · Salt Lake City, UTmaintenance personnel improperly installed a landing gear system hydraulic line and the throttle cable which resulted in chaffing and subsequent loss of hydraulic fluid disabling the landing gear extention systems.NTSB FTW96IA024Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-212 · Dfw Airport, TX'O' ring failure in the fuel line to the left engine nozzle assemblies, which resulted in a fuel line leak and a left engine compartment fire.NTSB SEA96FA010Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Alta, WYthe corrosion, consequent fatigue cracking and ultimate separation of the right wing forward lift strut.NTSB NYC96LA014Accident · No injuriesLimited investigationFinal reportCessna 210C · Burlington, VTa fractured hydraulic line and loss of hydraulic fluid, which resulted in an inoperative landing gear extension system for both normal and emergency operation of the gear.NTSB CHI96LA010Accident · No injuriesLimited investigationFinal reportCrowley/Zenair Zodiac CH-600 · Columbia, MOA loss of elevator control as a result of the top elevator control cable working its way out of a fitting.NTSB CHI96LA011Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-31 · Cedar Rapids, IAinadequate installation of a thrust reverser, driver linkage arm pivot bolt and nut, which resulted in the nut and bolt becoming disconnected. A factor relating to the accident was: the manufacturer's unclear information regarding the type and number of…NTSB NYC96LA007Accident · No injuriesLimited investigationFinal reportTeague Pitts S-1S · Erwinna, PAthe pilot's misjudged flare and improper bounced landing recovery. Factors were the pilot's lack of recent experience and a false oil pressure gauge indication.NTSB SEA96LA005Accident · 1 fatalLimited investigationFinal reportChard RV-3A · Forest Grove, ORThe pilot exceeded the design stress limit of the aircraft, followed by the failure of the right wing main spar.NTSB FTW96LA011Accident · No injuriesLimited investigationFinal reportCessna 195A · Taos, NMseparation of the left main gear wheel as a result of improper maintenance.NTSB SEA95LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Roberts, IDan improperly performed major rebuild and inadequate inspection of the aircraft by maintenance personnel. Inadequate preflight inspection by the pilot contributed to the accident.NTSB NYC95LA231Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Staten Island, NYFailure of the propeller blade due to fatigue, which resulted in severe vibration, subsequent separation of the engine, and a forced landing.NTSB MIA95LA236Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Union Church, MSinadequate maintenance lubrication and inspection of the main rotor head which resulted in the separation of a rod end bearing.NTSB SEA95LA226Accident · No injuriesLimited investigationFinal reportCessna 340 · Riverton, WYa partial loss of hydraulic fluid in the left brake system rendering the left brake inoperative.NTSB NYC95LA226Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Auburn, NYthe loss of airplane control as a result of a jammed rudder for undetermined reasons.NTSB MIA95TA230Accident · Serious injuriesFinal reportBell 206B · Culebra, PRthe failure of company maintenance personnel to insure the tail rotor gearbox attach bolts were properly torqued.NTSB SEA95LA227Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Yakima, WAFatigue failure of the bolt attaching the scissor arm assembly to the pitch control support assembly. The failure of the bolt led to a loss of collective pitch control and reduced rotor RPM.NTSB FTW95IA397Incident · No injuriesIncident investigationFinal reportMBB BO-105C · Lafayette, LAa short in the 'jam proof system' solenoid valve which prevented activation of the backup hydraulic system and resulting in a cyclic hardover. Factors were the contaminated hydraulic fluid and the resulting jammed actuator (longitudinal control slider).NTSB ANC95LA170Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKFailure of the main landing gear wheel that had been modified for a tundra tire.NTSB FTW95FA394Accident · No injuriesField investigationFinal reportMBB BO-105C · Houston, TXthe failure of the main transmission's #1 (left) input pinion assembly, due to the partially blocked oil passage which reduced oil flow, resulting in the disconnect of the drive shaft.NTSB LAX95LA331Accident · No injuriesLimited investigationFinal reportBell 47G-3B2 · Yuma, AZthe failure of the pilot and company maintenance personnel to detect a crack in the clevis ears during the required daily inspection and the recent annual inspection. A factor in the accident was the improper welding and stress relief procedure used to…NTSB FTW95LA383Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Greeley, COThe pilot's improper in-flight planning/decision by inadvertently selecting a less suitable area for landing (than the runway). Factors relating to the accident were: a malfunction of the nose landing gear micro-switch, which resulted in a false indication…NTSB CHI95IA313Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72 · Chicago, ILimproper installation of the #7 and #8 fuel nozzle manifold transfer tubes by company maintenance personnel, and an inadequate exhaust drain fitting gasket, which resulted in fuel leaks at the respective 'O' ring/gasket fittings; blockage of the fuel/oil…NTSB LAX95LA318Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Dos Palos, CAthe fatigue failure of the tail rotor tension torsion bar plates.NTSB FTW95LA373Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Broomfield, COThe pilot's attempt to taxi with a known inoperative brake. A factor was partial brake failure due to a leaking seal.NTSB SEA95LA200Accident · No injuriesLimited investigationFinal reportCessna 210 · Sunriver, ORThe failure of the landing gear hydraulic drive motor.NTSB BFO95LA094Accident · Minor injuriesLimited investigationFinal reportCessna 310K · Columbiana, OHThe improper maintenance installation and the subsequent separation of the torque links on the left main landing gear during the landing roll.NTSB MIA95LA217Accident · No injuriesLimited investigationFinal reportCessna 337D · Carthage, MSFailure of the normal brake system for undetermined reasons. Contributing to the accident was the failure of the pilot's seatback.NTSB SEA95LA195Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Ogden, UTthe pilot's failure to use brakes to maintain directional control following a tailwheel steering malfunction. Partial failure of the tailwheel steering system contributed to the accident.NTSB MIA95IA214Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Fort Lauderdale, FLLow electrical resistance of the autopilot aileron actuator for unspecified reasons which resulted in an uncommanded roll to the right.NTSB LAX95FA303Accident · No injuriesField investigationFinal reportLockheed L-1011-385-1 · Pacific Ocean (Pacific Ocean)inadequate certification/approval of the airframe structure. Contributing was the lack of required inspections of the failure area.NTSB CHI95LA287Accident · No injuriesLimited investigationFinal reportBeech 65-B80 · Anderson, INseizure of the landing gear wheel bearing and separation of the landing gear outer wheel-half and tire from the aircraft after which directional control of the aircraft by the pilot was not possible.NTSB FTW95LA355Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fayetteville, ARThe pilot's inability to extend the landing gear due to the failure of an emergency gear extension valve.NTSB CHI95LA288Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-1 · Hammond, WIan overload failure of the right horizontal support tube assembly which the pilot/owner had modified to be adjustable. A factor in the accident was the corn.NTSB BFO95FA082Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · East Moriches, NYthe structural failure of the wing for undetermined reasons.NTSB FTW95IA348Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · Lubbock, TXinstallation of an incorrect bearing in the number three main wheel by the wheel assembly supplier, which led to subsequent failure of the wheel bearing and separation of the wheel during takeoff.NTSB NYC95LA197Accident · No injuriesLimited investigationFinal reportSaab-Scania SF-340-A · Philadelphia, PAthe failure of a titanium hydraulic line, which resulted in an uncontained hydraulic fluid wing fire. A factor was the use of a procedure by the operator, approved by the FAA, but not approved by the airplane manufacturer, which resulted in compartment…NTSB NYC95FA195Accident · 2 fatalField investigationFinal reportCessna 310R · Altoona, PApropagation of corrosion cracks in the right engine overboard exhaust stack and fatigue failure of the exhaust stack, which resulted in escape of hot/high velocity gases, in-flight fire, emergency descent, and subsequent collision with trees during an…NTSB FTW95LA346Accident · No injuriesLimited investigationFinal reportCessna 150F · Manila, ARA blown (tripped) fuse, which rendered flap retraction inoperative. Factors relating to the accident were: the hot weather condition, the aircraft's lack of climb performance with the flaps extended, and the lack of suitable terrain in the forced landing area.NTSB ANC95LA140Accident · No injuriesLimited investigationFinal reportCessna 185A · Teller, AKDeflation of the left main tundra tire due to valve stem damage (failure) when the tire rotated independently of the wheel rim, resulting in loss of directional control and a ground swerve.