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 NYC88DNA01Accident · No injuriesFinal reportGrosvenor Quickie · Middletown, RIThe worn propeller transmission (reduction gear assembly), which failed to transmit power to the propeller at a critical point in the go-around.NTSB LAX88DVA01Accident · Minor injuriesFinal reportEagle DW-1 · Modesto, CAWhile enroute for the purpose of spraying a field, the engine seemed to overspeed then lose power. The aircraft was landed on a soft field where during the landing roll, the aircraft nosed over. The propeller dome was found to have separated from the aircraft…NTSB FTW88DRA04Accident · Serious injuriesFinal reportBarnett Drifter XP503 · Alvin, TXThe pilot reassembled the flight controls just prior to flight, and installed the aileron pins to connect the cables, but forget the safety locking devices. During flight, the pins fell out causing a total loss of aileron control.NTSB MIA88LA113Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Jupiter, FLThe plt stated that he had completed a ldg away from his home base without the gear down & locked lights being illuminated. He stated that he had assumed the lights were 'burned out'. Upon departure, he retracted the gear & flew to his home airport. Upon…NTSB DEN88DQA02Accident · Minor injuriesFinal reportShiner Pitts S-1S · Los Lunas, NMThe plt reported that the tailwheel steering chain broke during the landing rollout. When the acft slowed to about 30 KTS the rudder was no longer effective and the plt was unable to control direction by use of the brakes. The acft turned to the lt and ran…NTSB SEA88IA051Incident · Minor injuriesIncident investigationFinal reportPiper PA-31T · Las Vegas, NVWhile cruising at FL270, right side cockpit window failed, resulting in decompression. Acft diverted to normal landing. Examination revealed lower bolts overtorqued and plexiglas compromised by excess primer, initiating cracking. Evidence indicated window not…NTSB FTW88FA066Accident · 3 fatalField investigationFinal reportAero Commander 680 · El Paso, TXThe non-instrument rated, non multiengine rated pilot, whose medical had expired, lost control of the aircraft during an IFR flight in instrument meteorological conditions. The aircraft crashed and burned. The pilot was attempting to return and land after he…NTSB LAX88DUJ03Accident · No injuriesFinal reportBeech F33A · Goodyear, AZDuring an instructional flight, after takeoff, at 300 feet, the pilot and student said they heard a loud bang. The engine experienced a loss of power and the pilot noted that the top of the engine cowling was gone. A forced landing was made off the runway.…NTSB DEN88LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Hurricane, UTThe student plt said that when he departed st. george, UT for Hurricane, which is 21 NM northeast, the wind was from the south at about 5 KTS. He landed to the north at Hurricane. He said he did not notice any wind as he prepared to depart to the south. Upon…NTSB NYC88LA083Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Waterfall, PAShortly after takeoff, the pilot heard a loud 'boom' and experienced a loss of tail rotor control accompanied by an increase in N2 and RPM. A radio transmission was made to the aircraft that was trailing and then an approach for landing set up. On landing,…NTSB SEA88LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Twin Falls, IDWhen the pilot attempted to reduce power to descend to land he was unable to obtain a power reduction due to the throttle rod end separating in flight. The pilot made a spiralling descent and then shut down the engine. The pilot misjudged his altitude and…NTSB FTW88DQG03Accident · No injuriesFinal reportBeech G35 · Friona, TXAfter touchdown on the landing strip, the left landing gear collapsed, and the airplane went off the left side of the strip. The airplane went into a water pit, and struck a pump station and associated equipment. Later the pilot stated to his son that he had…NTSB CHI88LA053Accident · No injuriesLimited investigationFinal reportCessna T310R · Urbana, ILAfter the aircraft experienced a complete electrical failure the gear was extended manually and a precautionary landing was made. On roll out the landing gear collapsed. Subsequent investigation revealed that 10 turns remained on the manual gear extension…NTSB MKC88FA043Accident · Minor injuriesField investigationFinal reportAerospatiale AS-350B · Omaha, NEThe pilot picked the aircraft up to a hover and made a hovering turn in preparation for departure. The nose of the aircraft began to rise. The pilot stated later that he could not control the aircraft. The aircraft began to descend and the tail rotor struck a…NTSB ATL88FA081Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Barnardsville, NCNTSB MIA88FA088Accident · Serious injuriesField investigationFinal reportChristen Industries A-1 · Pompano Beach, FLThe plt stated that as he pushed the control stick forward in an attempt to raise the tail, the acft violently pitched up, stalled and broke right, the right wing struck the ground, & the acft rolled over & came to rest inverted. Post crash examination of the…NTSB CHI88IA040Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Minneapolis, MNAircraft experienced a loss of aileron ctl when ice formed around aileron control cables and restricted their movement. Water draining through open plenum drains in the main landing gear wheel well froze when exposed to below freezing temperatures at 35,000…NTSB LAX88LA080Accident · No injuriesLimited investigationFinal reportBell 47D1 · Fontana, CANone submittedNTSB MKC88LA036Accident · No injuriesLimited investigationFinal reportCessna 414 · Fayetteville, ARDuring an instructional flt, the CFI and student plt heard a loud pop while attempting to lower the gear in preparation for landing. Several flybys past the control tower were made to confirm an unsafe nose gear configuration. They flew the aircraft an…NTSB MKC88DCQ01Accident · 1 fatalFinal reportFlagg Star Lite · Ft. Scott, KSThe failure of the main spars at the attachment points inside the fuselage.NTSB LAX88LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Goodyear, AZDuring a cross country flt while cruising at 7500 ft MSL, the acft began to vibrate severely. The plt shut the engine down and landed without further incident. Inspection of the acft revealed that a section of one of the propeller blades had separated. The…NTSB ATL88FA066Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Monroe, NCReptdly, the flt purpose was to administer a bfr to the plt/owner of the acft. The first takeoff was aborted. The acft deptd again without an apparent problem. After about 30 minutes, the apt mgr heard and saw the acft in a vertical descent and rotating about…NTSB FTW88FA036Accident · Serious injuriesField investigationFinal reportBell 412 · Galveston, TXThe acft landed hard in the gulf of Mexico during an autorotation that was entered following the separation of the 90 degree gearbox. The gearbox (with tail rotor blades) separated due to an imbalance. However, the gearbox was not recovered during the…NTSB SEA88IA028Incident · No injuriesIncident investigationFinal reportCanadair CL600-2A12 · Twentynine Plms, CAThe water filter housing lower seal was mis-installed which allowed water to seep out and run down the housing case. Over time the water dropped onto a lavatory drain line, followed the line to a low point & collected on the stab aug computer box. The fluid…NTSB NYC88FA050Accident · No injuriesField investigationFinal reportBoeing 737-2B7 · Deptford, NJDrg tkof, as usair flt 224 was clbg thru 4000', the acft yawed/rolled rgt. Simultaneously, the crew noticed the #2 throttle slam/lock to the idle psn & a continuous airframe buffet began. Soon thereafter, the #2 eng sepd fm the acft & the buffet stopped. The…NTSB DEN88FA033Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · San Jose, CASeveral min after takeoff, the plt noted a loss of oil pressure & elected to return to the arpt. As he was returning, the eng began to overspeed, but he controlled the RPM by retarding the throttle. The wind was from 150 deg at 10 KTS. The plt was clrd to…NTSB ATL88MA053Accident · 2 fatalMajor investigationFinal reportHawker Siddeley HS-125-400A · Lexington, KYWhile en route at FL 370, the plts declared an emerg, rprtd a fire in the rgt eng & reqd vectors to the nearest suitablearpt. They were vectored twd the Lexington bluegrass arpt & clrd to dscnd. Shortly after declaring an emerg, the plts rprtd they secured…NTSB FTW88IA037Incident · No injuriesIncident investigationFinal reportBoeing 727-243 · Houston, TXImproper drilling of the cross hole in the slat track bearing bolt, which led to its failure from fatigue cracking.NTSB LAX88FA060Accident · 1 fatalField investigationFinal reportPiper PA-46 · Long Beach, CAPilot's failure to land the aircraft after experiencing the pilot's faulty decision was his previous experience with a gear up landing a couple of years before.NTSB ATL88MA048Accident · 2 fatalMajor investigationFinal reportBeech C90 · Beaufort, SCAt 0938, while clbg thru 9000', the plt was clrd to clb to FL 210. Aprx 10 min later, the ATC ctlr noted the acft's mode c rtrn wasn't being displayed on his scope. He tried to adz the plt, but couldn't establish radio contact. The acftbroke up in flt & the…NTSB BFO88FA008Accident · 3 fatalField investigationFinal reportPiper PA-32-260B · Willis, VAThe acft was on a night IFR flight at 7000 ft MSL in IMC when the plt reported the directional gyro was inoperative. The acft was outbound from the pulaski VOR on V45 headed southeast. The plt further reported the turn&bank and the mag compass were operative.…NTSB ANC88LA017Accident · No injuriesLimited investigationFinal reportCessna 208 · Atmautluak, AKThe pilot stated that he landed at a distance approximately one-third of the way down the 2,000 foot ice covered gravel runway. After touchdown the pilot lost directional control of the aircraft causing the aircraft to exit the departure end of the runway.…NTSB SEA88IA019Incident · No injuriesIncident investigationFinal reportBeech 99-A · Port Angeles, WABoth generator lights came on along with the left and right fuel pressure lights. The aircraft was being flown back to the airport for a precautionary landing, when the annunciator panel lights began to flicker. When landing flaps were selected they did not…NTSB ATL88IA037Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Cleveland, OHWhile descending into Cleveland from 25,000 feet the pilot, experienced a violent lurch in the airframe. The flight continued and landed without incident. An aircraft examination disclosed that the right upper thrust reverser drive link was broken. Further…NTSB ATL88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Murfreesboro, TNThe rt wheel brake failed while the airplane was taxiing on a parallel taxiway. The failure occurred near the end of the taxiway, just as the plt was about to turn the airplane onto the rwy. The plt subsequently attempted to turn the airplane using…NTSB ATL88DKG02Accident · No injuriesFinal reportCrump 512 · Parrish, ALWhile cruising at 5500 ft, the propeller separated from the aircraft and struck the left wing. During the resulting forced landing, the pilot had difficulty controlling the aircraft and was unable to maneuver to a selected field. He said the aircraft would…NTSB MIA88LA030Accident · No injuriesLimited investigationFinal reportCessna T-210N · Tallahassee, FLDuring ldg gear extension plt did not get safe down indication. Attempts to use emergency extension pump were unsuccessful. Acft was landed nose gear extended main gear retracted. Post accident inspection of the acft revealed the left main gear down lock…NTSB ATL88FA032Accident · No injuriesField investigationFinal reportBeech 95C-55 · Atlanta, GAAcft was being positioned to begin cargo revenue flt. As acft turned final and ldg gear handle was put in down position PIC noted dimming of all lights & communications were lost. PIC unaware gear were still retracted until prop tips contacted rwy. During…NTSB FTW88IA025Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · El Paso, TXThe pilot stated that the nose baggage door was properly closed and locked before takeoff but it came open during the aircraft's initial climb at about 200 feet AGL. He made an immediate descent and landed on the remaining runway. He delayed the leveloff…NTSB ATL88LA030Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Newnan, GAThe tail rotor 90 degree gearbox mounting flange fractured during apch to land, while the helicopter was at about 75 ft AGL. The gearbox subsequently separated from the helicopter. The plt initiated an autorotation. The helicopter rolled over on ldg.…NTSB ATL88LA031Accident · No injuriesLimited investigationFinal reportCessna 401A · Mobile, ALThe plt related that he was climbing through 4,300 ft when he lost the left turbocharger. He then noted sparks and then fire from the engine. He shut off the fuel, waited for the fire to go out and feathered the propeller. The flt was continued to montgomery,…NTSB MIA88LA027Accident · No injuriesLimited investigationFinal reportLearjet 35A · Clearwater, FLDuring taxi up to hangar under direction of lineman after arrival the flt experienced loss of hydraulic pressure and brakes. The plt could not activate the emergency brakes prior to rolling into the hangar and colliding with two acft prior to coming to rest.…NTSB LAX88FA065Accident · 2 fatalField investigationFinal reportBritten-Norman BN2A-26 · Desert Center, CAThe plt was hired to ferry an islander from el paso, TX to santa paula, CA. He represented himself to the ferry company as being an experienced islander plt. No previous islander flt time was found in the pilot's logbook. It was the plt's 40th birthday & he…NTSB CHI88LA014Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Lapeer, MIThe helicopter was in cruise flt when the rgt side horizontal stabilizer attach tube failed & separated from the tail boom, then contacted the tail rotor. This resulted in failure of the tail rotor drive shaft flex coupling at the tail rotor gear box. In…NTSB CHI88LA009Accident · No injuriesLimited investigationFinal reportCessna R182RG II · Indianapolis, INAfter take-off, the pilot attempted to retract the landing gear when the hydraulic line on the right main gear actuator failed. The left main landing gear was stuck in the trailing position while the nose gear and right main gear remained down and locked. The…NTSB CHI88IA011Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILA wing panel separated from the airplane while in cruise flight. Crew declared an emergency and landed without further incident. Examination revealed that maintenance personnel did not fasten 4 of the 5 rod end assembilies used to secure the panel to the top…NTSB NYC88LA019Accident · Minor injuriesLimited investigationFinal reportBeech 19A · Buena, NJa loss of electrical power for undetermined reasons, which necessitated a precautionary landing. Factors were rain, clouds, dark night, and the pole. This report was modified on February 9, 2005.NTSB FTW88LA008Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Lapra, TXUpon entering a bank approx. 80 to 100 ft. off the ground, the aircraft experienced a power loss with vibration. During autorotation the aircraft contacted a tree causing substantial damage. Examination of the wreckage found the transmission clutch assembly…NTSB SEA88LA009Accident · No injuriesLimited investigationFinal reportNapper Vancraft · Pocatello, IDThe experimental gyrocopter was on a test flight when the right rudder pedal pivot bolt broke. The aircraft began a spiral in a counter-clockwise direction with the rudder separating from the aircraft at the hinge points. The aircraft continued to spiral to…NTSB ATL88DKG01Accident · No injuriesFinal reportCessna 188 · Samson, ALThe plt said the prop surged during a swath run. While rtning to land the engine quit. The acft landed in a plowed field, resulting in substantial damage to the rt wing and lndg gear. Inspection of the engine by the plt revealed that the oil filter adapter…