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 SEA86LA081Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Prescott, WAThe brake locking system engaged in flight causing the right brake to lock. The aircraft nosed over on landing where a small fire erupted from fuel spillage onto the hot engine.NTSB MIA86IA098Incident · No injuriesIncident investigationFinal reportBoeing 727 · Miami, FLDuring arrival at ft lauderdale, the aircrew attempted to extend the gear, but at first, they were unable to get a safe 'down' indication for the rgt main gear. After about one hour, they were able to insure that both main gear had extended& were locked. They…NTSB MIA86FA097Accident · 2 fatalField investigationFinal reportMcfarland Quickie 2 · Mulberry, FLWitnesses reported that the acft was flying at a lower than normal altitude and at full throttle when something broke off the acft. The acft then rolled to the right, went almost straight up and spiraled down striking the ground inverted. Post crash…NTSB ATL86LA094Accident · Serious injuriesLimited investigationFinal reportShaffer KR-2 · Mobile, ALThe pilot lost control of the aircraft during cruise flight while attempting to close the cockpit canopy which inadvertently unlatched. The aircraft entered a spin and the pilot was unable to recover prior to ground impact. The aircraft was an experimental…NTSB NYC86LA083Accident · No injuriesLimited investigationFinal reportCessna T210N · White Plains, NYDuring the flight the plt noted a full discharge on the ammeter and a open alternator circuit breaker after ATC reported loss of transpx signal. The circuit breaker would not reset. The low voltage light did not come on. He diverted the flight to White Plains…NTSB BFO86FA018Accident · Serious injuriesField investigationFinal reportHughes 500D · Mt. Crawford, VAAfter refueling at shenandoah valley airport located near staunton, Virginia, the helicopter climbed to about 1800 feet MSL on a north heading. Approximately 15 minutes after departure a loud rumble was heard coming from the rear of the aircraft and the pilot…NTSB LAX86FVA03Accident · Minor injuriesFinal reportSchweizer G164A · Wasco, CAThe acft went off the left side of rwy during a downwind landing. The ag plts made a practice of landing downwind to speed up turn-around time. They relied on their brakes to maintain control. The acc acfts brake pads were worn and the rt brake was fluid…NTSB NYC86LA081Accident · Minor injuriesLimited investigationFinal reportDassault DA-10 · Coatsville, PAAs the acft was climbing thru 19,000' at ngt, the #2 generator (gen) lgt came on. The flt crew noted there was no outputfm the #2 gen & it would not reset. They then checked the #1 gen voltage & noted it was 14 to 15 volts. The crew reducedthe elec load;…NTSB MIA86LA087Accident · No injuriesLimited investigationFinal reportGulfstream 500S · Opa Locka, FLThe plt stated that upon departure from Opa Locka, FL he had a problem when he retracted the landing gear. Upon returning to the arpt, the gear would not extend so he elected to land with the gear up along side of rwy 36. The acft was placed on jacks after…NTSB ATL86FA082Accident · 2 fatalField investigationFinal reportBeech A23 · Russellville, ALOutboard half of one propeller blade separated during cruise flight. During the subsequent forced landing attempt the acft struck trees, severing the right wing, and crashed inverted. Front occupant seats separated from seat tracks. Examination of propeller…NTSB MKC86LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gardner, KSThe ip and student had been practicing landings at another airport and was landing at this airport for fuel. There was a crosswind at the airport and the ip made the approach and landing. A witness stated that the touchdown was three point in the Cessna 170A…NTSB SEA86LA062Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Odessa, WADuring an external load operation to remove groundwire off crossarms, the cable splice jammed in the pulley frame. The helicopters forward motion stopped and it then struck the ground. The pilot said the cargo hook release didn't work but no failures were…NTSB MKC86LA061Accident · Minor injuriesLimited investigationFinal reportSchweizer G164-B · Colt, ARThis was a new acft which the owner was ferrying from the dealer to his private ag strip. The landing was made to the north on a half mile long grass strip and the wind was calm. The plt reports that the brakes were locked when the acft touched down and the…NTSB MKC86FA059Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Kansas City, MODuring a climb to cruise, the pilot-in-command declared an emergency & requested to dscnd & return to the arpt. The landing was uneventful. An exam of the left prop revealed that 1 of its 3 blades had failed at the butt end & had separated. Subsequently, the…NTSB MIA86IA075Incident · No injuriesIncident investigationFinal reportPiper PA-31-1020 · Panama City, FLThe plt stated that all attempts to extend the landing gear were to no avail & he elected to land with the nose gear not fully locked down. On landing rollout the nose gear completely collapsed. Post crash examination of the nose landing gear revealed that…NTSB CHI86LA089Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Muncie, INThe pilot intentionally landed gear up after an electrical failure and the gear failed to extend normally. The alternator switches were found off after the accident. It was beginning to get dark with ceilings at 2200 ft.NTSB ATL86LA073Accident · No injuriesLimited investigationFinal reportCessna U206B · Columbia, TNSoon after departure the plt experienced a severe vibration throughout the acft. Eng pwr was retarded and the vibration subsided. The plt then noticed aileron control problems and noticed the left wing tip was moving up and down. An emergency landing was made…NTSB LAX86LA110Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · San Francisco, CAOn feb 9, 1986 at 1717 PST a Piper PA-23, N5300Y, ditched approximately 460 NM sw of sfo, CA. The flt originated from hnl, HI. In flt fuel leak was discovered after 7 hrs of flight. Fuel vapors were seen contrailing off both wings. The plt attempted to…NTSB SEA86FA054Accident · Serious injuriesField investigationFinal reportCessna 172N · Renton, WAThe recently certificated private pilot was engaged in practice touch and go landings. Sometime after the second approach the throttle control rod became disconnected from the throttle cable and the pilot was unable to retard the throttle from a full power…NTSB CHI86IA083Incident · Minor injuriesIncident investigationFinal reportBoeing 727-22 · Chicago, ILThe flight crew was unable to lower the nose wheel landing gear through either the normal or backup systems. The airplane subsquently made a nose gear up landing resulting in minor damage to the airplane. An examination of the nose gear drag brace assembly…NTSB MKC86FCQ01Accident · Serious injuriesFinal reportKuhn Sonerai II · Sedgwick, KSThe plt noticed eng oil on the cockpit canopy during the local flt and decided to make a precautionary landing. The landing was made in a wheat field where the acft contacted a fence. The nose gear then collapsed and the acft nosed over. Post accident…NTSB MIA86IA066Incident · Minor injuriesIncident investigationFinal reportBoeing 747-123 · Miami, FLShortly after departure the crew noted smoke in the cabin and the cockpit. The captain declared an emergency and landed back at the departure airport. He then directed an emergency evacuation. During the evacuation several emergency slides failed to deploy…NTSB MKC86LA057Accident · No injuriesLimited investigationFinal reportCessna 310R · Kansas City, MOThe airplane was being taxied toward a parking spot in front of a hangar and the right brake failed and the left wing contacted the front of the hangar.NTSB FTW86LA039Accident · No injuriesLimited investigationFinal reportSocata MS Rallye 235C · Brenham, TXThe right flap push rod experienced a progressive type failure from repeated excessive force being applied by the flap drive motor. The excessive force was caused by the flap rollers being neglected during maintenance to the extent that they became dry and…NTSB SEA86LA044Accident · Serious injuriesLimited investigationFinal reportBoeing 727-214 · Las Vegas, NVAfter activation of no 1 engine fire warning signals a second time, flt crew declared emerg and returned for lndg. Fuel dump was seen by some grnd observers as smoke trail and this was reported to flt crew. Acft waiting takeoff report that no smoke or fire…NTSB CHI86LA070Accident · No injuriesLimited investigationFinal reportCessna 185 · St. Ignace, MIThe pilot stated that after the application of full power for takeoff his seat slid back to its full aft position. He could not reach any of the controls. He then unfastened his seat belt and lunged forward to pull the power off. At this time the right wing…NTSB ATL86LLT06Accident · Serious injuriesFinal reportPiper PA-22 · Jasper, TNThe acft crashed into a house before striking the ground in an uncontrolled descent. The acft was approaching marion arpt for a landing when the plt lost control. The plt said that the stabilizer adjustment 'stripped'. The pilot was using the trim tab when…NTSB DEN86LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cedar City, UTThe plt stated that while in cruise flt, a loud noise was heard followed by air entering the cockpit. The plt said he initially reduced pwr, not knowing what the problem was. According to the plt, when no visual problem with the aircraft was found, he added…NTSB FTW86LA037Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Yukon, OKThe left brake locked after the aircraft rolled a short distance during landing. Aircraft slowed until about 20 mph forward speed and then flipped inverted and stopped. Post accident examination revealed the brake shoe return spring on the left brake was…NTSB DCA86AA014Accident · No injuriesFinal reportBoeing 727-225 · Loudon County, VAThe rt main lndg gear would not extend for lndg at wash natl arpt. The lndg was aborted and the crew attempted to correct the situation but were unsuccessful. An emergency gear-up lndg was made at dulles internatl arpt. The crew and passg evacuated without…NTSB SEA86FA039Accident · 1 fatalField investigationFinal reportHiller-Soloy UH-12E · Horton, ORThe fork connecting the rotorcraft's blue blade to the main rotor hub separated after a long term fatigue crack had spread through more than 60% of the fork circumference. The operator failed to carry out the appropriate inspection of the fork unit as…NTSB CHI86LA067Accident · No injuriesLimited investigationFinal reportSikorsky S-58F · North Adams, MIWhile accomplishing preflight systems checks with the engine running and the rotor system engaged the aircraft experienced a hydraulic hardover. Uncommanded displacement of the flight controls caused the aircraft to pitch up and left simultaneously. The pilot…NTSB NYC86LA060Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJThe student and instructor (CFI) were performing touch-and-go landings. On the third touch-and-go, the student rotated the acft and initiated his climb. The CFI stated 'I realized the acft was not climbing and that the flaps were not retracted even though the…NTSB FTW86LPJ06Accident · No injuriesFinal reportAerospatiale SA319B · Tulsa, OKThe main rotor blades struck the tail boom after liftoff and vibration was violent. When the plt heard metal contact he pulled off the throttle and made an autorotation landing from about 4 ft AGL.NTSB FTW86FA033Accident · Minor injuriesField investigationFinal reportBell 206B · Port O'Connor, TXThe helicopter sustained a loss of tailrotor drive on lift off. A bonding in a shaft coupling failed. Extensive research and analysis discovered no discrepancies in design, production, quality assurance, maintenance or operating environment that could have…NTSB FTW86MA030Incident · No injuriesMajor investigationFinal reportBoeing 737-2H4 · Dallas, TXThis incident occurred when the no. 2 engine experienced an aft engine mount cone bolt failure and the subsequent failure of the secondary support link (stainless steel cable). The failure of both aft engine support assemblies during the takeoff roll allowed…NTSB CHI86LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · Grygla, MNThe aircraft had been fitted with owner installd skis. During landing the left ski separates from its mount allowing the left ski mount to dig into the snow covered runway. The right wingtip struck a snowbank and the aircraft came to rest on its nose. The…NTSB CHI86FEI01Accident · Minor injuriesFinal reportMonnet Moni · Perry, OHAfter initiating a 180 deg turn, the plt heard a 'thump' and noted a low vibration. The acft then pitched down abruptly and entered an inverted spin to ground contact. The plt stated an in flight structural failure of the tail section had occurred which…NTSB FTW86FRG10Accident · Minor injuriesFinal reportMooney M20C · San Antonio, TXThe acft was destroyed during a forced landing. While en route over the San Antonio area the plt noticed a few drops of what he believed to be precipitation on the windshield. Shortly thereafter, it was determined the drops on the windshield were oil. The…NTSB NYC86LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mt. Joy, PAPiper aircraft was in cruise flight from lancaster, PA to mt joy, PA. When an oil line apparently fractured. An emergecny landing was made in a field. During landing, the nose collapsed and the aircraft was substantially damaged.NTSB MIA86LA043Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Homestead, FLThe plt stated that while on a flight from marco island FL, to ocean reef FL, he heard a loud bang and elected to land at Homestead general arpt. Upon landing he found the left muffler had seperated from the acft, struck the propeller and was driven through…NTSB DCA86AA011Accident · No injuriesFinal reportBoeing 747-136 · Boston, MAAprx 16 ft of the left inboard trailing edge flap separated while the acft was on final apch to land. The apch and landing were completed without further incident. Investigation revealed 5 of the 8 bolts which hold the no. 3 flap trackforward attach fitting…NTSB CHI86LA048Accident · No injuriesLimited investigationFinal reportCessna 152 II · Aurora, ILDuring initial climbout the student plt saw his IAS drop 10 KTS. He aborted the takeoff and land hard on the nose gear. Gear collapsed.NTSB MIA86LA041Accident · No injuriesLimited investigationFinal reportCessna 337F · Sarasota, FLThe plt stated that all attempts to extend the landing gear were to no avail. He then intentionally landed gear up on the left side of rwy 4.NTSB CHI86LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Rochester, INUpon takeoff and after reaching an altitude of approx ten feet the right side of the cowl became unlatched and whipped up into the airstream, blocking the pilots forward view and causing some control problems. He elected to abort the takeoff and ran off the…NTSB CHI86IA037Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Detroit, MIThe acft suffered a failure of the left rear axle during taxi to takeoff.NTSB LAX86LA053Accident · No injuriesLimited investigationFinal reportMooney M20J · Taft, CAThe landing gear intransit light illuminated and stayed on when the plt attempted to retract the gear after takeoff. After all efforts to extend or retract the gear failed the plt elected to land at the arpt of departure. The landing gear collapsed on…NTSB NYC86LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bloomsburg, PAThe acft was on an IFR flt en route to allegheny county arpt at 6000 ft when an electrical failure occurred. The plt executed a precautionary landing in a muddy fld. The nose wheel caught in mud and the acft nosed over. Examination of the electrical system…NTSB CHI86IA034Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Glen Ellyn, ILDuring climb a bang was heard and the aircraft shuddered. The crew stated that the number three engine oil pressure and oil quantity indicated low. The fire warning light and bell activvated. The engine was shut down and the aircraft landed without further…NTSB DEN86IA026Incident · No injuriesIncident investigationFinal reportNorth American NA-265-40 · Denver, COAfter to from a snow covered rw, the lg dwn and locked lights in the cockpit remained illuminated on lg retract the crew did not recognize this as a log gear ino sys malfunction nor were they familiar with the correct proc to lower lg when this malfunction…