NTSB investigations, 2004
122 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\") = 2004
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") = 2004 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 DEN05LA043Accident · No injuriesLimited investigationFinal reportMooney M20E · Telluride, COthe pilot's improper in-flight decision making and inadvertent retraction of the landing gear resulting in a wheels up landing. A contributing factor included the pilot's attention being diverted by the seized engine tachometer.NTSB CHI05LA047Accident · No injuriesLimited investigationFinal reportLearjet 25B · Cedar Rapids, IAThe pilot was not able to maintain directional control of the airplane due to the failure of the nose gear strut seal which prevented the nose wheel from centering. A factor associated with the accident was the berm that the airplane contacted.NTSB LAX05LA083Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH-2000 · Jean, NVan in-flight separation of the left cockpit door due to the failure of the hinges from repeated exposure to wind or propeller slip stream forces while in the open position. The hinge failures were the ultimate result of the failure of persons unknown to…NTSB DFW05LA043Accident · 1 fatalLimited investigationFinal reportAkers Douglas RA40 Defiant · Slaton, TXThe pilot's failure to maintain aircraft control. Contributing factors were the opening of the canopy in-flight and the pilot's diverted attention.NTSB LAX05LA049Accident · No injuriesLimited investigationFinal reportRobinson R22B · Los Angeles, CAThe activation of the low main rotor rpm warning system for undetermined reasons.NTSB LAX05FA046Accident · 1 fatalField investigationFinal reportCessna T207A · Meadview, AZa loss of control due to the in-flight separation of the right elevator and elevator trim tab control surfaces. The precipitating reason for the elevator separation could not be resolved as related to the tab foam core issue with the available evidence.NTSB DEN05FA032Accident · 2 fatalField investigationFinal reportBeech A45 · Montgomery, TXthe in-flight separation of the left wing as a result of extensive fatigue cracking throughout the wing carry-through structure.NTSB SEA05FA022Accident · 1 fatalField investigationFinal reportCessna 185F · Renton, WAThe pilot's failure to maintain aircraft control when the flaps became jammed/stuck in their full-down position during a takeoff from a touch-and-go landing. Factors include a worn/disconnected flap latch mechanism, and the flaps being unable to be retracted.NTSB ANC05IA016Incident · No injuriesIncident investigationFinal reportBoeing 747SR-146B SF · Anchorage, AKThe fatigue and subsequent fracture of a portion of the airplane's pressure bulkhead, which resulted in a rapid decompression during cruise flight.NTSB NYC05IA029Incident · No injuriesIncident investigationFinal reportFairchild-Heliporter Pilatus PC6/B2-H2 · Cross Keys, NJA total failure of the left elevator attachment point for undetermined reasons.NTSB IAD05LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Allentown, PAThe pilot's improper decision to continue the flight with known deficiencies in equipment. Also causal was the failure of the right main landing gear due to overstress cracking.NTSB DEN05LA030Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G-IV · Eagle, COnose wheel steering system failure due to foreign material substance contamination.NTSB ATL05CA024Accident · No injuriesData collectionFinal reportCessna 172N · Wilmington, NCThe student pilot's failure to recognize the proper emergency procedure, which resulted in a precautionary landing in a field and subsequent collision with a ditch. Factors were the undetermined electrical malfunction, smoke in the cockpit, and the student…NTSB LAX05CA030Accident · No injuriesData collectionFinal reportCessna P210N · Rancho Cordova, CAThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power. Contributing factors were the pilot's improper in-flight decision to continue the flight at night after experiencing the total failure of the…NTSB MIA05LA037Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, FLThe improper flare by the pilot in command resulting in a hard landing, Restricted movement of the throttle was a contributing factor.NTSB DFW05LA019Accident · Minor injuriesLimited investigationFinal reportBell 206L1 · Sapulpa, OKThe loss of tail rotor drive as a result of a blanket coming in contact with the tail rotor blades, after the baggage compartment door unlatched during flight. A contributing factor was the "dusk" light condition that prevailed at the time of the accident.NTSB CHI05CA025Accident · No injuriesData collectionFinal reportJabat Avid Flyer · Cleveland, MOThe separation of the wing skin from the wing structure and the pilot's subsequent inablility to maintain aircraft control. A factor associated with the accident was the tree that the airplane contacted.NTSB IAD05LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA jammed control wheel during landing. A contributing factor to the accident was the inadequate maintenance inspection of the airplane's flight control system.NTSB LAX05LA027Accident · No injuriesLimited investigationFinal reportCessna 172RG · Kingman, AZLanding gear extension system component failure resulting in a gear up landing.NTSB DFW05CA024Accident · No injuriesData collectionFinal reportMcCulloch J2 · Camden, ARThe separation of the engine exhaust stack for undetermined reasons.NTSB CHI05MA011Accident · No injuriesMajor investigationFinal reportBoeing 747-132 · Lake MichiganThe number one engine separated from the airplane during climb due to the uncontained separation of a portion of the second stage turbine disk rim after the second stage turbine vanes contacted the disk. The second stage turbine vanes contacted the second…NTSB SEA05LA133Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Hyak, WAThe loss of aircraft control during climb to cruise due to an undetermined flight control malfunction.NTSB CHI05CA003Accident · No injuriesData collectionFinal reportSinclair Zenith 701 · Augusta, KSThe manufacturer's inadequate design/production of the landing gear axle leading to its separation and the airplanes subsequent nose over during the landing roll.. A factor was the axle's separation from its spring.NTSB SEA05LA008Accident · No injuriesLimited investigationFinal reportHiggins Acro-Sport II · Coeur d'Alene, IDThe airplane's wood propeller separated from the airplane during cruise. A factor was the ditch that the airplane impacted during the landing roll subsequent to the forced landing.NTSB IAD05LA001Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Robbinsville, NJThe repair station's improper installation of the stabilator trim tab. A factor was the pilot's inadequate preflight inspection of the airplane.NTSB LAX04LA331Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Burbank, CAthe failure of maintenance personnel to correctly service the forward landing gear strut dampers in accordance with the manufacturer's maintenance instructions.NTSB ATL04CA186Accident · No injuriesData collectionFinal reportCessna 172RG · Montgomery, ALThe separation of a hydraulic line for undetermined reasons, which resulted in a hydraulic fluid leak and malfunction of the landing gear.NTSB ATL04LA181Accident · Minor injuriesLimited investigationFinal reportHughes HU-369-D · Waynesboro, GAThe tail rotor assembly failed due to a fatigue fracture of the input gearshaft in the tail rotor gearbox assembly, which resulted in a loss of tail rotor control and subsequent collision with trees.NTSB LAX04LA333Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 900 · Mesa, AZfracture of a Tension-Torsion strap in the anti-torque fan due to progressive fiber failure of the composite strap material from compression and/or transverse shear stresses that occurred with repeated manipulation of the cockpit anti-torque control pedals…NTSB DEN04LA140Accident · No injuriesLimited investigationFinal reportBeech B-60 · Casper, WYthe missing nose gear assembly bolt, spacer and nut resulting in a gear collapse due to improper maintenance procedures. Contributing to the accident was the collision with the storm drain.NTSB ATL04CA189Accident · No injuriesData collectionFinal reportBeech D18S · Tullahoma, TNRight tire burst during an attempted takeoff that resulted in loss of directional control and the on ground collision with the ground.NTSB DEN04LA138Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Colorado Spring, COright main tire failure for reasons undetermined.NTSB LAX04LA312Accident · No injuriesLimited investigationFinal reportBeech F33A · Fresno, CAthe pilot's loss of pitch control authority during landing flare due to an autopilot system failure that inhibited control yoke movement. A factor was inadequate autopilot system maintenance.NTSB NYC04FA197Accident · 2 fatalField investigationFinal reportRobinson R-22 · Northport, NYAn improper maneuver by the flightcrew while attempting to avoid a kite, which resulted in mast bumping, the separation of the main rotor system, and a subsequent uncontrolled descent into water.NTSB ATL04LA171Accident · Minor injuriesLimited investigationFinal reportHawkins William Searey · Dayton, TNThe delamination of the fiberglass hull of the airplane.NTSB DEN04LA129Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sterling, COthe failure of the landing gear extension system for undetermined reasons.NTSB ATL04CA169Accident · No injuriesData collectionFinal reportAeronca 7AC · Spring Hope, NCThe binding of the right aileron control cable, which resulted in a loss in aileron control, and subsequent collision with trees and terrain.NTSB IAD04LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · London, KYAn undocumented, improper repair attempt, which subsequently resulted in fatigue cracking to the rib cap.NTSB DEN04IA126Incident · No injuriesIncident investigationFinal reportCessna 750 · Jackson, WYthe failure of the right main landing gear trailing link due to fatigue cracking initiated by an undetected manufacturing defect. A contributing factor was the improper plating process by unknown manufacture personnel.NTSB SEA04LA162Accident · No injuriesLimited investigationFinal reportUniversal Moulded Pdts. Monocoach · Pullman, WAThe failure of a landing gear oleo retaining nut safety clip (snap ring) at an unknown point in time, leading to the partial separation of the landing gear strut while in flight, and the full collapse of the strut during the subsequent landing. Factors…NTSB CHI04CA228Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Elkhart, INThe failure of the seat during landing roll and the subsequent pilot's airplane handling not being possible.NTSB ANC04FA092Accident · 2 fatalField investigationFinal reportMaule M-5-235C · Seward, AKThe failure of an aviation mechanic/inspector to adequately inspect the pilot/owner's work during the engine overhaul, which resulted in a loss of engine oil and engine power during cruise flight, and a subsequent ditching. Factors associated with the…NTSB DEN04CA122Accident · No injuriesData collectionFinal reportEurocopter France EC-130 B4 · Englewood, COthe pilot's failure to perform a preflight inspection. Contributing to the accident was the transmission cowling that disconnected during the landing.NTSB LAX04LA287Accident · No injuriesLimited investigationFinal reportCessna TR182 · Torrance, CAA wheels up landing due to the failure of the hydraulic hose leading to the nose gear actuator, which depleted the hydraulic system of pressurized fluid.NTSB MIA04GA117Accident · 1 fatalFinal reportBell 47G-5 · Bunnell, FLThe pilot's continued flights and inadequate inspections after repeated tail rotor guard ground strikes due to improper flaring, which resulted in an in-flight failure of tail rotor drive shaft components, a loss of control, and the helicopter crash.NTSB CHI04LA213Accident · No injuriesLimited investigationFinal reportCessna 208B · Big Rapids, MIThe pilot's failure to verify that the cargo door was latched properly prior to flight and the subsequent in-flight opening of the door. A contributing factor was the box which departed the cargo compartment and struck the horizontal stabilizer.NTSB MIA04FA115Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Miami, FLThe failure of company maintenance personnel to secure the push/pull tube to the left lug of the non-rotating portion of the swashplate assembly following maintenance, and the inability of the pilot to control the helicopter resulting in the in-flight…NTSB SEA04LA153Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Redmond, ORUnknown malfunction of the landing gear system for undetermined reasons that resulted in a gear collapse during landing.NTSB SEA04TA147Accident · No injuriesFinal reportWSK PZL Mielec M-18A · Burns, ORThe improper installation of the throttle linkage clevis to the throttle control arm by unknown maintenance personnel. Contributing factors were the nylon lock nut separating from its' bolt, which permitted the throttle cable to disconnect from the throttle…NTSB LAX04LA276Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Minden, NVthe pilot's failure to lower the landing gear during landing approach, which resulted in his inadvertent gear up landing. A factor was his distraction due to a component malfunction.