NTSB investigations, NC
76 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 4 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 5 |
| 1998 | 2 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 3 |
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\" = 'NC' 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" = 'NC' 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 ENG08IA001IncidentIncident investigationFinal reportBoeing 757-225 · Charlotte, NCThe truck beam fracture initiated by fatigue and stress corrosion cracking from pits that were present on the ID surface of the truck beam, under the protective finishes. Crack propagation occurred by alternating modes of stress corrosion cracking and fatigue…NTSB NYC07IA194Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · New Bern, NCA failure of the stabilator control cable turnbuckle terminal fitting due to corrosion. Contributing to the accident were the mechanic's inadequate annual inspection, and the aircraft manufacturer's failure to provide adequate information in its maintenance…NTSB ATL07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Asheville, NCThe failure of the directional gyro and attitude indicator due to a vacuum system leak caused by a loose fitting. Contributing to the accident was the pilot's failure to execute a partial panel, no-gyro approach.NTSB NYC06CA218Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Farmingdale, NCAn inadequate annual inspection of the airplane, which resulted in a total failure of the elevator cable during flight, and subsequent uncontrolled descent into terrain.NTSB ATL06CA125Accident · No injuriesData collectionFinal reportBrown Floyd L Christen Eagle II · Topsail Beach, NCThe in-flight separation of the engine and propeller from the airframe for undetermined reasons, which resulted in the airplane's uncontrolled impact with water.NTSB ATL06CA073Accident · No injuriesData collectionFinal reportRobinson R44 Raven II · Rocky Point, NCThe pilot's inadequate visual lookout during a precautionary landing which resulted in an in-flight collision with a transmission wire.NTSB ATL05LA065Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-135LR · Raleigh, NCAn oily smell in the airplane shortly after takeoff for undetermined reasons that resulted in a return to the airport and a passenger injury during the emergency evacuation.NTSB ATL05CA053Accident · Serious injuriesData collectionFinal reportBennett Ra Oliver Zodiac CH 601 HDS · Mt. Olive, NCRupture of the engine's cooling system radiator, which allowed steam to fill the cockpit.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 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 ATL04TA116Accident · 1 fatalFinal reportHughes 269A · Louisburg, NCFatigue failure of the tailboom saddle fitting which resulted in a loss of aircraft control. Also causal was inadequate maintenance due to non-compliance to an airworthiness directive requiring inspection of the saddle fitting. A contributing factor was the…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 ATL03IA126Incident · No injuriesIncident investigationFinal reportBombardier CL600-2B19 · Raleigh Durham, NCThe failure of a utility bus relay which resulted in an electrical fire and subsequent smoke in the cockpit.NTSB ATL03LA056Accident · No injuriesLimited investigationFinal reportFokker F.27MK 500 · Kinston, NCThe fatigue failure of the main drag stay tube. A factor is no inspection procedure required.NTSB MIA03LA021Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Brevard, NCthe jamming of the elevator control system for undetermined reason, which resulted in the airplane departing the runway, and impacting with a ditch, during the aborted takeoff.NTSB MIA02FA075Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas MD-11 · Charlotte, NCThe failure of the aircraft operator to comply with, in a timely manner, on the No. 2 engine, Boeing Alert Service Bulletin MD11-71A086, resulting in the integrated drive generator feeder cable chaffing through a fire warning loop and failure of the fire…NTSB ATL02FA010Accident · 1 fatalField investigationFinal reportCessna 310Q · Winston Salem, NCImproper installation of the elevator trim tab control rod by maintenance personnel which allowed the control rod to disconnect and jam in the full up position (elevator full down) while in-flight. This resulted in a loss of directional control and subsequent…NTSB MIA01LA219Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wilgrove, NCThe failure of maintenance personal to properly reconnect the throttle-cable-to carburetor attachment, resulting in a throttle cable disconnection while in the landing pattern, and collision with trees. A factor in the accident was the failure of the pilot to…NTSB MIA01LA213Accident · Serious injuriesLimited investigationFinal reportAvid Mk-4 · Salisbury, NC, An aileron control system failure during climb due to an improper welded installation by the aircraft homebuilder, resulting in an inflight loss of lateral control, and an inflight collision with the terrain during an uncontrolled descent and landing.NTSB ATL01LA043Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Cherry Point, NCFatigue cracking of the propeller hub that resulted in the in-flight separation of a propeller blade.NTSB MIA01FA006Accident · 1 fatalField investigationFinal reportAerospatiale AS-355-F2 · Burlington, NCThe mechanics failure to comply with manufacturers instructions for correction of a illuminated main rotor gearbox oil pressure warning light resulting in the helicopter being dispatched on a ferry flight with a failed main rotor gearbox oil pump, failure of…NTSB MIA00LA270Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Charlotte, NCthe right main brake locked after touchdown causing the airplane to yaw and depart the runway, resulting in the landing gear collapsing.NTSB DCA00MA079Accident · Minor injuriesMajor investigationFinal reportDouglas DC-9-32 · Greensboro, NCA phase-to-phase arc in the left heat exchanger cooling fan relay, which ignited the surrounding wire insulation and other combustible materials within the electrical power center panel. Contributing to the left heat exchanger fan relay malfunction was the…NTSB MIA00LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Washington, NCThe inadvertent stall by the pilot-in-command while returning for a precautionary landing. Contributing to the accident was the loose engine cowling.NTSB ATL00LA034Accident · No injuriesLimited investigationFinal reportHughes 369D · Dallas, NCThe pilot's improper use of flight controls during an emergency landing. Factors were an encounter with a loss of tail rotor effectiveness (LTE) during an out-of-ground effect hover, the pilot's inadequate weather evaluation, and his failure to follow proper…NTSB MIA00LA013Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS 125-700A · Fayetteville, NCThe overstress failure of the lugs of the cylinder head of the left main landing gear jack for undetermined reasons. Also, inability of the flight crew to extend the left main landing gear.NTSB MIA99LA191Accident · No injuriesLimited investigationFinal reportMooney M20F · Liberty, NCImproper inspection of the muffler assembly resulting in erosion going undetected and the rupture of the muffler and shroud while in cruise flight. The condition caused melting of portions of the air induction system, loss of engine power, and the pilot's…NTSB ATL99LA092Accident · Minor injuriesLimited investigationFinal reportMurray R. Gardner FLY Baby · Mount Olive, NCA fatigue failure of the flywire bracket that resulted in the inflight separation of the left wing.NTSB ATL99LA082Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Southern Pines, NCA failure of the left main landing gear retraction assembly as a result of the disconnection of the left main landing gear strap bracket assembly from the main gear spring attachment bracket due to the missing nut. A factor was the ditch.NTSB ATL99LA056Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bunn Level, NCThe loss of engine power for undetermined reasons. Factors were an electrical system malfunction for undetermined reasons and the dark night conditions.NTSB ATL98LA118Accident · No injuriesLimited investigationFinal reportPiper PA-30-39 · Greenville, NCA loose wiring connection at the landing gear motor relay that prevented the electrical extension of the landing gear.NTSB ATL98LA102Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Bern, NCThe failure of the inner cable of the carburetor heat cable assembly that prevented the application of carburetor heat. Factors were conditions favorable for the formation of carburetor ice.NTSB MIA98LA027Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Spruce Pine, NCThe unintentional locking-up of the left brake for undetermined reasons resulting in the on ground loss of control. Contributing to the accident was the inability of the pilot to maintain directional control.NTSB MIA98FA025Accident · No injuriesField investigationFinal reportFokker F100 · Charlotte, NCImproper written instructions (job/task card) by company maintenance personnel. The procedures did not reflect the correct manufactures maintenance manual servicing procedure, and did not ensure that the proper tool (replenishing gun) was available for the…NTSB ATL98LA005Accident · No injuriesLimited investigationFinal reportMooney M20C · Hendersonville, NCThe undetermined malfunction of the nose gear steering assembly that resulted in the loss of directional control during a full stop landing. A factor was the rough and uneven runway condition. .NTSB MIA97IA151Incident · No injuriesIncident investigationFinal reportBeech 100 · Kenly, NCInadequate inspection procedures by the airframe manufacturer for failure to require removal of the metal retaining ring to inspect the entire area of the window for cracks.NTSB MIA97LA067Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Salisbury, NCcontinued operation of the aircraft by the flight instructor (CFI) and student after identifying a brake problem, which resulted in a fire that erupted from the brake system and subsequently destroyed the aircraft.NTSB ATL97LA006Accident · No injuriesLimited investigationFinal reportCessna 337G · Fayetteville, NCThe unapproved maintenance modification of the landing gear electrical system by maintenance personnel that prevented the extension of the landing gear.NTSB ATL96LA131Accident · No injuriesLimited investigationFinal reportBeech A23 · Tarboro, NCfatigue failure of the propeller blade. Factors relating to the accident were: corrosion pit(s) on the propeller blade, and inadequate maintenance/inspection of the propeller.NTSB ATL96LA073Accident · No injuriesLimited investigationFinal reportCanadair CL-600S · Raleigh, NCthe flight crew's inadequate emergency procedure in that they did not manually extend the landing gear, as specified in the airplane flight manual. A factor relating to the accident was: the intermittent operation of the extend solenoid in the nose gear…NTSB ATL96LA059Accident · No injuriesLimited investigationFinal reportCessna 172K · Asheville, NCfailure of the brake on the right main landing gear as a result of water (ice) in the brake fluid, which resulted in a loss of braking control.NTSB ATL96IA053Incident · No injuriesIncident investigationFinal reportEmbraer 120 · Raleigh, NCThe operator's inadequate progressive inspection program that did not require periodic analysis of airplane hydraulic system fluid; and the failure of the operator to comply with the airplane manufacturer's maintenance manual resulting in contamination of the…NTSB ATL95LA152Accident · Serious injuriesLimited investigationFinal reportAero Commander 100-180 · Ocracoke, NCA shattered windshield which precluded maintaining level flight due to increased aerodynamic drag.NTSB MIA95IA194Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Charlotte, NCImproper installation of the 'a' system flight control computer by company maintenance personnel, which resulted in pin connector(s) being pushed loose and subsequent malfunction of the autopilot.NTSB ATL95LA042Accident · No injuriesLimited investigationFinal reportMatto KR-2A Modified · Boone, NCThe failure of the propeller retaining bolts for an undetermined reason, which resulted in the separation of the propeller from the engine. The rising, mountainous terrain was a factor.NTSB ATL94FA179Accident · 1 fatalField investigationFinal reportRobinson R-22B · Knightdale, NCDivergence of the main rotor from its normal plane of rotation for an undetermined reason(s) resulting in rotor blade contact with the tailcone.NTSB ATL93LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Goldsboro, NCThe pilot's improper decision in attempting a night landing at an airport without operating runway lights which resulted in a touchdown off the runway. Factors which contributed to the accident were: an airplane lighting malfunction for an undetermined…NTSB ATL92LA140Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Shallotte, NCThe deterioration of the left main fuel bladder which resulted in the premature exhaustion of the fuel supply and the loss of engine power. A factor was soft terrain.NTSB ATL92LA112Accident · No injuriesLimited investigationFinal reportCessna 210F · Manteo, NCThe pilot's inadequate emergency procedures, in that he failed to note the discharge of electrical power on the ammeter, and his loss of directional control during the off airport landing. Factors were the disabled alternator and a low cloud ceiling.NTSB ATL91LA144Accident · No injuriesLimited investigationFinal reportBeech C24R · Morrisville, NCFailure of the left main landing gear uplock cylinder which precluded extension of the landing gear.