NTSB investigations
3,929 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases, newest first
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.\"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."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 LAX99LA219Accident · No injuriesLimited investigationFinal reportBeech A-36 · Van Nuys, CAThe failure of the pilot to verify that the alternator was activated after engine start, subsequently resulting in a total electrical failure; and his inadequate emergency procedures for manual extension of the landing gear following the electrical failure.NTSB NYC99LA134Accident · 1 fatalLimited investigationFinal reportSaliba Long EZ · Friendly, MDThe separation of the airplane canopy for undetermined reasons, the diminished controllability of the airplane, and the pilot's failure to maintain airspeed resulting in a stall/mush into trees short of the runway.NTSB FTW99LA156Accident · No injuriesLimited investigationFinal reportCessna 195 · Conroe, TXThe fatigue fracture of the left main landing gear spring at the clamping mechanism, as a result of fretting.NTSB SEA99LA073Accident · No injuriesLimited investigationFinal reportCessna 180K · Bremerton, WAFailure of the landing gear attach bolt due to fatigue failure resulting in the left main landing gear collapsing.NTSB SEA99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Hillsboro, ORA loose alternator drive belt, and the flight crew's decision to continue flight with a known electrical system deficiency, resulting in disabling of the aircraft electrical system and landing with the gear not down-and-locked.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 FTW99LA145Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Lufkin, TXThe loss of control due to the separation of the left main landing gear as a result of the fatigue failure of the U-bolt which attaches the landing gear to the airframe.NTSB MIA99FA159Accident · 1 fatalField investigationFinal reportClassic S-51D · Tamarac, FLA complete loss of engine power caused by the malfunctioning landing gear, which blocked the radiator scoop, leading to increased fuel temperature and the subsequent vapor lock condition and fuel blockage. A secondary cause was the pilot's failure to maintain…NTSB NYC99LA113Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Grafton, OHInadequate maintenance which resulted in the failure of the mercury clutch assembly.NTSB SEA99LA063Accident · No injuriesLimited investigationFinal reportLake LA-4 · Coeur D'Alene, IDThe fatigue failure of a repair weld on one of the engine pylon mount straps and the resultant reduction in directional control. Factors include an inadequate repair of the strap, variable wind speeds and sudden wind shifts.NTSB LAX99LA175Accident · Minor injuriesLimited investigationFinal reportMatter GLASAIR-SH-2R · St. Johns, AZThe pilot misjudging the distance/altitude while on final approach to the runway, which resulted in a landing overrun. Factors were the pilot's failure to position the flap switch to the neutral position after takeoff, resulting in the continuous running and…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 NYC99LA102Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · New Milford, CTThe manufacturer's use of inadequate adhesive material which resulted in the de-bonding and subsequent failure of the wing spar pin-lock assembly.NTSB FTW99FA123Accident · 1 fatalField investigationFinal reportCessna 402C · Goldsby, OKThe fatigue failure of the right wing spar as a result of inadequate quality control during manufacture of the spar. A factor was the inadequate inspection of the right wing by maintenance personnel, which failed to detect the crack.NTSB CHI99IA144Incident · No injuriesIncident investigationFinal reportCessna 206H · Wheeling, ILimproper installation of the aileron control bellcrank stop bolts and lock nuts during the manufacturing process which resulted in a binding aileron control surface.NTSB MIA99LA138Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Fernandina Bch, FLThe failure of the pilot to use the printed checklist which resulted in the gear-up landing. A factor associated with the accident was the intermittent failure of the gear warning horn.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 MIA99LA130Accident · Minor injuriesLimited investigationFinal reportZemp Avid Catalina · Sebring, FLThe in-flight separation of one of the propeller blade's and one of the engine's exhaust pipes causing the engine to vibrate until it stopped running. A related factor was the unsuitable terrain for the forced landing.NTSB MIA99LA128Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Vero Beach, FLThe improper return to service of a propeller hub by a propeller overhaul company which according to manufacturer's procedures should have been retired due to damage to propeller blades from sudden stoppage. This resulted in undetected fatigue propagation…NTSB MIA99LA127Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Pensacola, FLThe pilot's inability to maintain directional control due to failure of the main landing gear, and partial electrical system failure for undetermined reasons.NTSB MIA99LA124Accident · Minor injuriesLimited investigationFinal reportBean Whitman W-10 · Wimauma, FLThe pilot's failure to maintain a visual lookout during a forced landing resulting in an in-flight collision with a ditch and subsequent nose over.NTSB CHI99IA136Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Dubuque, IAthe frozen elevator control. Factors to the incident were the rain and the low temperature.NTSB SEA99IA045Incident · No injuriesIncident investigationFinal reportFokker F.28 MK 4000 · Spokane, WAA chafed hydraulic line.NTSB FTW99LA107Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXThe pilot's inability to maintain directional control of the airplane as result of the failure of the right brake system due to the stripped threads on the eye bolt connecting the brake pedal to the brake master cylinder.NTSB CHI99FA120Accident · No injuriesField investigationFinal reportExtra Flugzeugbau 300S · Dow, ILa fatigue failure of the upper left longeron and adjacent diagonal cross member near the horizontal stabilizer attach point. A factor related to the accident was that the manufacturer informed the operator that they were already in compliance with the latest…NTSB CHI99IA115Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-14 · Grand Rapids, MIthe frozen elevator control. Factors were the rain and the low temperatures.NTSB ATL99LA057Accident · No injuriesLimited investigationFinal reportBeech 23 · Jacksonville, FLThe overload failure of the landing gear attach points during takeoff from a turf airstrip. Factors are rough and uneven terrain.NTSB LAX99FA128Accident · 2 fatalField investigationFinal reportErcoupe 415E · Kingman, AZThe in-flight loss of airplane control due to rear wing spar attachment fitting failure. The failure resulted from severe corrosion that was undetected during performance of an inspection specified by an airworthiness directive. The airworthiness directive…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 DEN99IA053Incident · No injuriesIncident investigationFinal reportGulfstream G-IV · Durango, COThe failure of the number four fuel line. Factors were the chaffing of the alternator's electrical wires on the number four fuel line, and the subsequent fire in the number one engine nacelle.NTSB CHI99FA105Accident · 1 fatalField investigationFinal reportBeech C-45G · Romulus, MIthe aircraft control not maintained and the inadvertent stall by the pilot while maneuvering to the landing area. The open door was a contributing factor.NTSB SEA99LA038Accident · 1 fatalLimited investigationFinal reportSikorsky S-64E · Shelton, WAThe failure of the victim to follow the procedure that required him to make sure that all choker lines had separated from the helicopter's release mechanism prior to entering the landing (collection area).NTSB CHI99LA099Accident · No injuriesLimited investigationFinal reportCalkins Kitfox 5 · Waunakee, WIthe fracture of the trim actuator.NTSB FTW99LA086Accident · 1 fatalLimited investigationFinal reportKeil Jaeger D-IX · Santa Fe, TXThe separation of the right upper aileron for an undetermined reason.NTSB MIA99LA091Accident · No injuriesLimited investigationFinal reportMooney M20J · St. Cloud, FLThe improper installation of the propeller by maintenance personnel resulting in fretting of the face of the propeller hub and fatigue failure of the No. 1 propeller blade. Also, the unsuitable terrain encountered during the descent for the forced landing.NTSB NYC99IA062Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Columbus, OHa failure of the external o-rings in the nose landing gear steering module.NTSB CHI99LA092Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lawrenceville, ILthe fatigue fracture of the landing gear actuator.NTSB FTW99LA079Accident · No injuriesLimited investigationFinal reportMiller/Bell TR-1 · Hiwasse, ARThe pilot's inadequate compensation for prevailing wind conditions. Factors were the crosswind, the lack of suitable terrain, and the separation of the adell clamp for the oil cooler inlet line.NTSB ANC99IA027Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Fairbanks, AKThe restricted/delayed movement of the elevator flight control due to extremely cold weather conditions.NTSB FTW99LA078Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D1 · Daingerfield, TXAn undetermined airframe malfunction which rendered the aircraft uncontrollable.NTSB LAX99IA085Incident · No injuriesIncident investigationFinal reportAerospatiale AS350B · Grand Canyon Pk, AZThe in-flight separation of a side window for undetermined reasons.NTSB CHI99FA079Accident · 1 fatalField investigationFinal reportCessna U-206G · Salem, MOthe spatial disorientation and loss of control by the pilot after a reported vacuum failure. Factors were instrument flight conditions and icing conditions.NTSB DEN99FA034Accident · 3 fatalField investigationFinal reportCessna P210N · Albuquerque, NMTotal failure of the vacuum system, and failure of the pilot to maintain aircraft control, resulting in wing spar failure. Factors were the pilot's spatial disorientation, and his exceeding the design stress limits of the airplane.NTSB ANC99IA025Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Fairbanks, AKThe improper overhaul of the thrust reverser pneumatic drive unit, and the subsequent failure of the thrust reverser actuator. Factors associated with the incident were the inadequate quality assurance procedures by the overhaul company.NTSB FTW99LA093Accident · No injuriesLimited investigationFinal reportBeech G35 · Ennis, TXFlutter of the empennage for an undetermined reason, which resulted in damage to the aft fuselage.NTSB DEN99IA033Incident · No injuriesIncident investigationFinal reportBeech E90 · Clovis, NMTotal failure of the elevator control cable due to a short circuit from chafing against an adjoining electrical cable, and failure of maintenance personnel to detect the problem during an AAIP phase inspection.NTSB LAX99LA074Accident · No injuriesLimited investigationFinal reportAbraham J G II/Erickson K ONE Design · No Las Vegas, NVThe separation of the left rudder control cable from the rudder horn due to the improper installation of a nicopress fitting that secured the cable to the control horn.NTSB FTW99LA059Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Shelbyville, TXThe total failure of the aircraft's electrical system. Factors were the thunderstorms, the dusk light condition, and the lack of suitable terrain for the precautionary landing.NTSB CHI99LA057Accident · No injuriesLimited investigationFinal reportMooney M20E · Tryon, NEother maintenance personnel's not correcting a loose cylinder assembly. Factors were loose engine cylinder assembly, fractured cylinder mounting hardware, the roadway, and road sign.NTSB LAX99LA061Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · San Ysabel, CAA fatigue fracture of the crankshaft and the resulting separation of the propeller.