NTSB investigations, 2003
140 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\") = 2003
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") = 2003 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 LAX04LA079Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Oxnard, CAthe failure of the pin that secured the right rudder pedal to the brake cylinder arm due to improper installation of the pin. Also causal was the manufacturer's confusing maintenance instructions regarding the installation of the right rudder pedal pin and…NTSB ATL04IA067Incident · No injuriesIncident investigationFinal reportSabreliner NA-265-60 · Birminghham, ALThe lack of lubrication of the right main wheel bearing which resulted in the overheating.NTSB CHI04LA046Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · St. Paul, MNThe failure of the worm drive bearing that resulted in the failure of the landing gear extension/retraction gearbox, which ultimately resulted in the extension of the landing gear not being possible. A factor to the accident was the airport sign that the…NTSB DEN04IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-3M8 · Denver, COThe restricted movement of the flight control yoke and tiller wheel steering for reasons undetermined.NTSB SEA04FA022Accident · 4 fatalField investigationFinal reportBeech S35 · Warren, ORThe vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.NTSB LAX04TA052Accident · No injuriesFinal reportEurocopter France AS 350 B3 · Yuma, AZThe malfunction of the rotor drive system due to improper maintenance, which resulted in the uncoupling of the drive shaft during takeoff-initial climb. A factor associated with the accident is the undertorqued drive system bolts.NTSB ATL04IA048Incident · No injuriesIncident investigationFinal reportCessna 560XL · Savannah, GAThe malfunction of the nose wheel gear for undetermined reasons.NTSB NYC04LA040Accident · No injuriesLimited investigationFinal reportBeech H-18 · Westminster, MDThe pilot's failure to maintain control of the airplane after a failure of one propeller system. Factors in the accident were the failure to perform maintenance inspection and the failure of a bolt in the left propeller blade system.NTSB SEA04LA019Accident · 1 fatalLimited investigationFinal reportKaman K-600 · Nordman, IDThe total failure of the helicopter's right main rotor shaft while in an ascending hover due to the propagation of a fatigue crack that initiated in a corrosion pit on the surface of a slot in the wall of the subject shaft. Factors include accumulation of…NTSB FTW04FA025Accident · 2 fatalField investigationFinal reportBeech A45 · Montgomery, TXThe non-compliance with applicable Airworthiness Directives which required wing spar inspections, and the continued operation of the aircraft beyond the compliance time extension granted as per the approved alternate means of compliance (AMOC). Also causal…NTSB CHI04LA032Accident · Serious injuriesLimited investigationFinal reportHughes TH-55A · West Lafayette, INThe fractured cluster fitting resulting in a loss of directional control during initial climb and the improper repair of cluster fitting by unknown personnel. The night conditions were a contributing factor.NTSB FTW04IA023Incident · No injuriesIncident investigationFinal reportBell 407 · Eugene Is. 27The loss of engine power due to the failure of the 3rd stage turbine wheel and subsequent catastrophic failure of the turbine assembly.NTSB ANC04LA011Accident · No injuriesLimited investigationFinal reportCessna 402 · Galena, AKWater contamination and freezing of the landing gear actuator that prevented the extension of the right main landing gear, resulting in a gear-up landing. Factors contributing to the accident were freezing temperatures at the accident location, and inadequate…NTSB CHI04FA031Accident · No injuriesField investigationFinal reportCessna 560XL · Wheeling, ILThe flight crew's intentional operation with know deficiencies in the aircraft and their delay in aborting the takeoff when a no-takeoff warning was presented. An additional cause was the crew's failure to comply with flight manual procedures concerning…NTSB ATL04LA035Accident · No injuriesLimited investigationFinal reportCessna 210D · Millington, TNThe malfunction of the main hydraulic landing gear system actuator resulting in an emergency gear up landing.NTSB LAX04LA035Accident · No injuriesLimited investigationFinal reportEurocopter AS350 B3 · Mesa, AZThe pilot's inadvertent activation of the hydraulic test switch, which resulted in a loss of the hydraulic system pressure, and his failure to maintain directional control.NTSB ATL04IA028Incident · No injuriesIncident investigationFinal reportPiper PA-32RT-300T · Fayetteville, NCFlight control elevator attachment turnbuckle corrosion and fracture resulting in the loss of aircraft control in flight.NTSB DEN04IA014Incident · No injuriesIncident investigationFinal reportLearjet 45 · Denver, COthe failure of the airplane's spoiler system when used as speed brakes due to high resistances in the spoilers' actuator coils.NTSB CHI04IA018Incident · No injuriesIncident investigationFinal reportEnstrom F-28C · Lapeer, MIComplete failure of the right anti-torque cable while on final approach for landing. A factor was the diminished tail rotor control resulting from the broken cable.NTSB LAX04LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mesa, AZthe pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall. Also causal, was the pilot's inadequate preflight and failure to secure the right side of the engine cowling prior to departure.NTSB LAX04LA020Accident · No injuriesLimited investigationFinal reportCessna 170 · San Diego, CAthe pilot's inadequate preflight inspection which failed to determine the security of his seat, and his failure to maintain directional control.NTSB ANC04LA004Accident · No injuriesLimited investigationFinal reportCessna 195B · North Pole, AKA fracture of the left brake master cylinder actuator rod, which resulted in failure of the left brake, a loss of directional control and an inadvertent ground loop during landing, and the separation of the left main landing gear strut due to fatigue. Factors…NTSB MIA04LA004Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-319-112 · Tampa, FLAn intermittent fault with the airplane's Brake Steering Control Unit (BSCU) for undetermined reasons, which resulted in a momentary loss of brakes and steering, and a serious injury to a flight attendant during the resultant sudden stop during taxi for…NTSB LAX04TA017Accident · No injuriesFinal reportMD Helicopter 900 · Fredonia, AZthe pilot's in-flight loss of control due to the fatigue fracture and separation of the force limiting control rod (an integral part of the anti-torque system), which resulted in the helicopter's uncommanded yaw/spin and subsequent collision with terrain.NTSB CHI04LA009Accident · No injuriesLimited investigationFinal reportBeech A33 · Grandview, MOSeparation of the fuel selector handle which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was the hay bale that the airplane contacted during the forced landing.NTSB LAX04LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Camarillo, CAThe fracture and failure of the left landing gear actuator. Contributing to the accident was the operator's failure to comply with the manufacturer's service bulletin.NTSB DEN04IA012Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Denver, COthe manufacturer's improper installation of the inboard slat drive mechanism's lower left hand anti-torque strut, which resulted in the axial migration of the rod-end bearing, the binding of the anti-torque strut, and the subsequent activation of the slat…NTSB SEA04IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Lyon, FranceAn undetermined malfunction in an aircraft system while in cruise flight leading to a fire in the engine number four B Loop portion (Card A16) of the fire detection controls cardfile.NTSB FTW04LA001Accident · Serious injuriesLimited investigationFinal reportBratton Experimental Homebuilt Swearingen SX300 · Floresville, TXThe separation of one propeller blade while in cruise flight. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX03LA290Accident · No injuriesLimited investigationFinal reportCessna 172RG · Santa Ana, CAthe failure of the right main landing gear pivot assembly.NTSB ATL03LA151Accident · Serious injuriesLimited investigationFinal reportSheppard S-2 · Obion, TNThe failure of the elevator control pushrod, that resulted in an uncontrolled descent and subsequent in-flight collision with ground.NTSB ATL03LA150Accident · Minor injuriesLimited investigationFinal reportSherman Holie Freebird · Newnan, GAThe failure of the aileron control rod, and subsequent loss of control in-flight.NTSB DCA03IA058Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Dfw, TXThe improper maintenance of the tailcone evacuation system, which prevented the evacuation slide from inflating during an evacuation due to smoke/fumes in the cabin.NTSB DEN03LA156Accident · No injuriesLimited investigationFinal reportCessna R182 · Cedar City, UTthe nose wheel separating from the airplane during the precautionary landing. Factors contributing to the accident were the missing nose gear axle through-bolt and the missing cotter pin.NTSB CHI03LA314Accident · No injuriesLimited investigationFinal reportCessna 182S · Joliet, ILThe pilot not performing a go-around when the other airplane taxied onto the landing runway, which resulted in the pilot not attaining the proper touchdown point. Factors to the accident include the failure of the alternator, the complete loss of electrical…NTSB LAX03LA291Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Lone Pine, CAthe pilot's inadequate assembly of the glider and improper preflight inspection, which resulted in an inadvertent deployment of the spoilers. Also causal was the pilot's failure to maintain obstacle clearance. His diverted attention to the control problems…NTSB SEA03LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Anacortes, WAThe pilot attempting to taxi the airplane with a known system deficiency. Factors include worn wheel brakes and a drainage ditch.NTSB ANC03LA128Accident · No injuriesLimited investigationFinal reportCessna 206 · Fairbanks, AKA failure of an attaching bolt that allowed the nose wheel fork to separate from the nose gear strut, which resulted in the collapse of the nose gear during the landing roll. A factor contributing to the accident was rough/uneven terrain.NTSB SEA03LA187Accident · No injuriesLimited investigationFinal reportCessna 172RG · Blanchard, IDThe loss of engine oil as a result of the inadequate installation of the idler gear shaft set screw and the lack of a safety wire on the hex head (oil) plug. A contributing factor was the rough and uneven terrain.NTSB CHI03LA318Accident · Minor injuriesLimited investigationFinal reportDixon Glasair II · Columbia, ILThe pilot's failure to maintain directional control during an aborted takeoff. Contributing factors were the open cabin door, the grass runway and the soft terrain adjacent to the runway.NTSB CHI03IA300Incident · No injuriesIncident investigationFinal reportCessna 650 · Rapid City, SDThe in-flight failure of the right wing aileron cable during cruise.NTSB LAX03LA267Accident · 1 fatalLimited investigationFinal reportPetz Flying Boat · Tracy, CAThe inadequate design of the engine exhaust system and inappropriate selection of propeller materials by the designer/builder, which resulted in separation of the propeller blades during takeoff/initial climb, and a subsequent in-flight collision with terrain…NTSB SEA03LA180Accident · No injuriesLimited investigationFinal reportLancair LC41 · Bend, ORThe inadequate design of the drogue chute mechanical jettison system, which resulted in its failure to separate from the aircraft during in-flight spin recovery tests, and the incorrectly wired drogue chute cable cutter activation unit, which resulted in the…NTSB MIA03IA168Incident · No injuriesIncident investigationFinal reportBoeing 757-223 · Miami, FLThe failure of maintenance personnel from the aircraft operator to identify a missing left main landing gear truck beam shield and damage to the left main landing gear truck beam which resulted in the fracture of the truck beam as a result of stress corrosion…NTSB CHI03LA265Accident · No injuriesLimited investigationFinal reportCessna 188B · Monette, ARFailure of the right brake and the pilot's inability to maintain directional control. A factor associated with the accident was the ditch.NTSB ATL03LA132Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Camilla, GAThe malfunction (locking) of the left brake piston during the landing roll, which resulted in a loss of control and subsequent nose over.NTSB CHI03FA277Accident · Serious injuriesField investigationFinal reportBell TH-13T · Light, ARThe total failure and seizure of the main rotor transmission while in cruise flight leading to the helicopter’s impact with terrain.NTSB CHI03IA293Incident · No injuriesIncident investigationFinal reportBell 230 · Wilmington, ILThe material defect during the manufacture of the tail rotor counterweight bellcrank and the bellcrank's subsequent failure due to a fatigue fracture.NTSB LAX03IA259Incident · No injuriesIncident investigationFinal reportAirbus A340-300 · Honolulu, HIthe failure of the center landing gear tires as a result of low tire pressure.NTSB DEN03LA144Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Longmont, COSeparation of the landing gear tire valve stem resulting in the left main tire deflating, and the pilot's inability to maintain aircraft control.