NTSB investigations, GA
106 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 9 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 1 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 8 |
| 1991 | 7 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 5 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 6 |
| 2005 | 3 |
| 2007 | 7 |
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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' 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 MIA08FA003Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Newton, GAThe failure of the right wing wooden spar due while the airplane was in cruise flight, due to the mechanic's inadequate annual inspection and his failure to comply with an airworthiness directive.NTSB NYC07LA237Accident · No injuriesLimited investigationFinal reportOrtiz G/Saint J RV-10 · Hiram, GASeparation of the passenger cabin door during cruise flight for undetermined reasons.NTSB MIA07IA088Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30 · Atlanta, GAThe improper overhaul of the horizontal stabilizer chain drive unit drive assembly.NTSB ATL07FA077Accident · 5 fatalField investigationFinal reportBeech 58 · Hamilton, GAThe pilot's exceeding the design stress limits of the airplane while performing aerobatics in a nonaerobatic airplane, which resulted in an in-flight overload failure of the airframe. A factor in the accident was the pilot's decision to perform aerobatics.NTSB ATL07LA064Accident · No injuriesLimited investigationFinal reportBeech BE-90 · Augusta, GAA total failure of the electrical system for undetermined reasons, which resulted in the pilot's inability to ensure that the landing gear was down and locked.NTSB ATL07CA058Accident · No injuriesData collectionFinal reportCessna 172K · Cornelia, GAThe failure of the owner/operator to repair or replace a known leaking brake system components resulting in a total loss of brakes while taxing and an on-ground collision with trees.NTSB ATL07LA054Accident · 1 fatalLimited investigationFinal reportJames Walter Hornet · Talbotton, GAThe failure of the right main fuel line, resulting in fuel starvation and a loss of engine power.NTSB ATL05CA083Accident · Minor injuriesData collectionFinal reportRand Robinson Engineering KR-2 · Vienna, GAA loss of engine power due to the owner/pilot mechanic's improper balancing of the modification to engine crankshaft which resulted in an overload failure.NTSB ATL05LA091Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Newnan, GAThe improper repair to the main landing gear assembly resulted in the actuator bracket failure and the right main gear collapse. A factor was the inadequate inspection of the right main landing gear.NTSB ATL05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Thomaston, GAThe unapproved repair of the tailwheel rudder arm assembly, which resulted in an overload failure during touchdown and subsequent loss of control of the airplane and on-ground collision with an object.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 ATL04LA143Accident · No injuriesLimited investigationFinal reportCessna 172S · Winder, GAThe improper maintenance (over-pressurization) of the nose gear strut, which resulted in an overload failure of the nose gear upper torque link bolt. The airplane subsequently nosed over during an uncontrollable landing roll.NTSB ATL04LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-301 · Baxley, GAThe mechanical malfunction of the autopilot pitch servo, and the pilot's inability to maintain adequate control pressure to manually retrim the pitch attitude.NTSB ATL04IA138Incident · No injuriesIncident investigationFinal reportCessna 172RG · Chamblee, GAThe fatigue fracture of the nosewheel bungee assembly, which restricted the movement of the elevator control. A factor was the inadequate equipment from an unknown source/manufacturer.NTSB ATL04LA094Accident · 1 fatalLimited investigationFinal reportFirefly F8B · Eatonton, GAThe overload failure of the windline quick release tiedown eyebolt.NTSB ATL04IA085Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Atlanta, GAThe failure of the tantalum capacitor and the permanent magnet generator input transformer which resulted in total electrical system failure.NTSB ATL04IA048Incident · No injuriesIncident investigationFinal reportCessna 560XL · Savannah, GAThe malfunction of the nose wheel gear for undetermined reasons.NTSB ATL03LA150Accident · Minor injuriesLimited investigationFinal reportSherman Holie Freebird · Newnan, GAThe failure of the aileron control rod, and subsequent loss of control in-flight.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 ATL03FA064Accident · 2 fatalField investigationFinal reportCessna 172S · Monroe, GAThe pilot’s exceedence of the design limits of the airplane, which resulted in the overload failure of the horizontal stabilizers, followed by the overload separation of the right wing and subsequent loss of control.NTSB ATL02LA075Accident · No injuriesLimited investigationFinal reportBoeing 767-332ER · Atlanta, GACompany maintenance personnel inadequate maintenance inspection that resulted in the in-flight separation of the APU inspection doors.NTSB ATL02LA067Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS315B · Hortense, GAFailure of the engine to main transmission drive shaft due to improper installation by company maintenance personnel. A factor were the trees.NTSB ATL01LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Blakely, GAThe pilot's inadequate in-flight decision to go-around after a reported loss of right brake pressure during the landing roll resulted in the in-flight collision with trees.NTSB DCA01MA005Accident · Minor injuriesMajor investigationFinal reportDouglas DC-9 · Atlanta, GAthe leakage of lavatory fluid from the airplane's forward lavatory onto electrical connectors, which caused shorting that led to a fire. Contributing to the accident were the inadequate servicing of the lavatory and the failure of maintenance to ensure…NTSB MIA01LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Jesup, GAA total failure of the wheel braking system due to the pilot's improper use of braking in downwind, downhill conditions, resulting in overheated brakes, and subsequent encounter with a downslope and terrain collision.NTSB ATL00LA055Accident · Minor injuriesLimited investigationFinal reportJackson Velocity RG · Kennesaw, GAA separation of the lower engine cowling and subsequent partial separation of propeller blades during a low high-speed pass. A factor was the recent maintenance work performed by the owner/pilot mechanic.NTSB MIA00LA067Accident · No injuriesLimited investigationFinal reportSwearingen SX300 · Jekyll Island, GAfailure of the left main landing gear attachment during the landing/flare touchdown for undetermined reasons, resulting in the loss of directional control and the airplane exiting the runway and colliding with a runway light.NTSB MIA99FA267Accident · Serious injuriesField investigationFinal reportLearjet 24 · Gainesville, GAThe inadequate inspection of the main landing gear brake assemblies, which lead to operation of the aircraft with worn brakes that failed during the landing roll. Contributing factors were the descending terrain, roadway and ditch.NTSB ATL99FA072Accident · 2 fatalField investigationFinal reportBeech T-34A · Rydal, GAFracture of the wing spar as a result of fatigue cracking that occurred over an unknown number of flights and flight hours with a wing loading spectrum not anticipated during design of the airplane. This report was modified on November 2, 2005.NTSB ATL99IA015Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Atlanta, GAFailure of the Company's maintenance personnel to follow the aircraft's maintenance manual which resulted in a cargo bin fire. Contributing to the severity of the incident was the failure of the mechanic to safety the circuit breaker, and the cut/severed…NTSB DCA99MA007Accident · Minor injuriesMajor investigationFinal reportBoeing 737-200 · Atlanta, GA(1) the capping of the incorrect hydraulic line by mechanics, which led to the failure of hydraulic system A; (2) the mechanics' lack of experience working with the Boeing 737 hydraulic system; and (3) the maintenance controller's failure to ascertain more…NTSB ATL98LA123Accident · Minor injuriesLimited investigationFinal reportVertical Concepts Searey · Hiawassee, GAThe delamination of the hull that resulted in a nose over during landing.NTSB MIA98LA230Accident · No injuriesLimited investigationFinal reportBell 47D1 · Dawson, GAThe pilot's selection of unsuitable terrain for landing resulting in debris being blown up during landing resulting in damage to the tail rotor and loss of control.NTSB MIA98LA165Accident · No injuriesLimited investigationFinal reportCessna 172RG · Roberta, GAThe pilot's inadequate compliance with the emergency procedures for his failure to completely pump the main landing gear into the down and locked position. Contributing to the accident was the reported loss of electrical power for undetermined reasons.NTSB ATL97LA069Accident · No injuriesLimited investigationFinal reportBeech 33 · Carrollton, GAThe inadequate maintenance inspection of the airplane that resulted in the disconnection of the propeller governor linkage and the subsequent reduction in engine power. The pilot also failed to maintain flying speed that resulted in an inadvertent stall…NTSB ATL97LA056Accident · 1 fatalLimited investigationFinal reportCessna A188B · Waynesboro, GAThe failure of the right wing after the pilot exceeded the design stress limit of the airplane, leading to a loss of control in flight.NTSB DCA97IA030Incident · No injuriesIncident investigationFinal reportBoeing 727F · Atlanta, GAA jammed elevator resulting from a backed-off elevator trim tab nut.NTSB ATL97LA027Accident · No injuriesLimited investigationFinal reportBeech 35 · Lafayette, GAfailure of maintenance personnel to balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.NTSB ATL96LA132Accident · No injuriesLimited investigationFinal reportBeech 35 · Griffin, GAfailure of maintenance personnel to properly balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.NTSB ATL95MA106Accident · Serious injuriesClass 1 · MajorFinal reportDouglas DC-9-32 · Atlanta, GAfailure of Turk Hava Yollari maintenance and inspection personnel to perform a proper inspection of a 7th stage high compressor disc, thus allowing the detectable crack to grow to a length at which the disc ruptured, under normal operating conditions,…NTSB ATL95LA004Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Ashburn, GAThe failure of a blade counterweight bearing shaft, allowing one propeller blade to go to high pitch.NTSB ATL94LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Flowery Branch, GAThe maintenance personnel's failure to properly secure the throttle linkage assembly that resulted in a reduction in engine power.NTSB ATL94IA055Incident · No injuriesIncident investigationFinal reportCessna 421B · Lagrange, GAThe pilot's intentional swerve off the taxiway to avoid a ground collision. A factor in the incident was an undetermined malfunction of the airplane's normal brake system.NTSB ATL94FA029Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Covington, GASpatial disorientation experienced by the pilot, resulting in his failure to maintain aircraft control. Factors were the total failure of the engine driven vacuum pump, and the night, cloud conditions prevailing at the time of the accident.NTSB ATL94FA028Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Lagrange, GAWas the pilot's failure to correct a known low battery condition before departing, which resulted in a loss of electrical power during an instrument approach. Factors were the dark night and the low scattered cloud layer.NTSB ATL93LA013Accident · No injuriesLimited investigationFinal reportPatrick F. Bowers Corbin JR. ACE E · Woodstock, GAThe separation of the propeller from the aircraft.NTSB ATL92LA145Accident · No injuriesLimited investigationFinal reportCessna 180B · Monroe, GAFailure of the pilot's seat assembly for an undetermined reason(s) which resulted in a loss of control during the takeoff roll.NTSB ATL92IA113Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-1 · Atlanta, GAThe overheating of the number 2 air cycle machine which resulted in an emergency evacuation via slides; the failure of the flight attendants to secure the slide girt bars.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 ATL92LA017Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Rome, GAThe failure of a tail rotor blade for undetermined reasons.