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 DEN84FA042Accident · Serious injuriesField investigationFinal reportMooney M20J · Bismarck, NDThe plt of N1151N reported that the departure arpt had some drifting snow which caused the r brake to freeze after takeoff. When the acft was landed, the r tire slid until it wore thru, then deflated. The plt stopped the acft on the rwy, informed tower psnl…NTSB MIA84IA045Incident · Minor injuriesIncident investigationFinal reportDouglas DC-10-10 · West Palm Beach, FLThe acft experienced a failure of the right main landing gear truck while taxiing for takeoff. Metallurgical examinationrevealed stress corrosion which originated adjacent to the forward outboard longitudinal beam lubrication on hole.NTSB CHI84IA060Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-61 · Chicago, ILA DC-8-61 operated by capitol air inc experienced a partial failure of the left main gear on the landing roll. The rear portion of the left main landing gear bogie & both rear tires were separated. Components of the left landing gear were submitted to…NTSB DEN84IA041Incident · No injuriesIncident investigationFinal reportBoeing 767 · Denver, COOn takeoff roll the no 3 wheel on the right main landing gear fell off the acft. The acft returned and landed without further incident. The wheel bearing was found faileddue to cosmoline contamination.NTSB NYC84IA048Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Newark, NJThe acft experienced a complete truck beam failure after touchdown. Metallurgical examination revealed a crack near the right rear truck pivot pin lubrication hole which showed propagation to the lower end of the grease hole on the mating surface. Grease hole…NTSB CHI84LA055Accident · Minor injuriesLimited investigationFinal reportCessna 310L · West Lafayette, INThe plt was unable to start the eng with the batteries & made a start by using an APU. About 10 min after taking off, he noticed an off flag on the HSI. A further check was made & he discovered the left alternator was not functioning. He then checked the…NTSB LAX84FA095Accident · 3 fatalField investigationFinal reportAerospatiale AS 355F · Black Mountain, NVThe helicopter tookoff on an air ambulance flt at about 1219 PST. According to tower personnel, the departure appeared normal. Radar service was terminated at 1227 & there was no further radio contact with the helicopter. Later, the helicopter was found where…NTSB FTW84FA086Accident · 1 fatalField investigationFinal reportBeech D18S · Brownsville, TXThe plt had just taken off at night on a flt to Mexico when he declared an intent to return & land with some unspecified emergency. While he was using his radio, the sound of both engs, running at hi power, was audible. When asked if he required assistance,…NTSB LAX84LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Oceanside, CAThe acft collided with a fence during landing roll. The private plt receiving instruction in conventional gear acft was making his second landing. After rolling 150 ft the acft made a skidding right turn and veered off the right side of therwy. The CFI was…NTSB LAX84LA078Accident · No injuriesLimited investigationFinal reportHughes 369D · Caliente, CAReportly, the plt had instructed the ground crew to place the external cable\slings in the cargo area of the helicopter. However, they connected the cable to the external hook. The plt was not aware of this & took off. After takeoff, the cable hit the tail…NTSB MIA84FU007Accident · 1 fatalFinal reportWizard J3 · Miami, FLSeveral witnesses observed the ultralight vehicle flying in a southwesterly direction at about 1500 ft AGL. They reported that the plt had executed 5 or 6 stall maneuvers, followed by normal straight ahead recoveries. During the last stall, the acft was…NTSB DCA84AA006Accident · Serious injuriesFinal reportBoeing 727-225A · Miami, FLAfter departing Miami & climbing through 10,900 ft the #3 right main landing gear tire exploded causing massive damage to systems a & b hydraulic lines which resulted in a loss of a & b hydraulic systems. The acft returned to Miami & the crew was unable to…NTSB MKC84IA017Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC9-80 · St. Louis, MODuring landing rollout the aft fiberglass tailcone fell off the acft for undetermined reasons.NTSB LAX84AA054Accident · Serious injuriesFinal reportWestland Helicopters 30-100 · Long Beach, CAAt 4,000 ft MSL directional control was lost. Witnesses observed the helicopter descending through the localized cloud layer in a left high-rotation turn, with the pitch attitude varying & its rate of descent 'very fast.' The helicopter then collided with…NTSB CHI84IA041Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Chicago, ILDuring taxi from landing the left outboard wheel rim failed and bounced onto a highway causing damage to a vehicle the rim failed due to a per-existing fatigue crack.NTSB ATL84LA041Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Columbia, SCWhile en route, the acft's ammeter went to a zero reading, and subsequently, a complete electrical failure occurred. Prior to landing, the plt attempted to lower the landing gear by letting it freefall, in accordance with recommended procedures. The gear…NTSB FTW84LA044Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Tulsa, OKDuring a missed approach from a practice ILS apch, a loud noise was heard during gear retraction. Subsequent attempts toextend the gear, both normally & manually, resulted in the right gear remaining up & locked with the inboard gear door slightly open. The…NTSB CHI84LA038Accident · No injuriesLimited investigationFinal reportBeech A36 · Columbus, OHOn the return flt to Columbus, OH, the alternator warning light was on. After recycling the switch, the plt shut down all electrical equipment. During arrival at the destination, the plt put the gear handle down, but noted a dim unsafe gear light & a…NTSB ATL84FA045Accident · No injuriesField investigationFinal reportRobinson R22 · Gaithersburg, MDDuring his 2nd solo flt in the Robinson R22, the plt performed 2 low 'g' maneuvers. The 1st maneuver was essentially the same as when he practiced it during a check-out flt. However, the 2nd maneuver produced a rapid right roll to aprx 60 deg of bank. The plt…NTSB ATL84LA035Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Greer, SCDuring the flt, hydraulic failure of the landing sys occurred & the aircrew were unable to get the gear locked in the down position. After orbiting for over an hour, a landing was made. During touchdown, the gear collapsed. An exam revealed that an aileron…NTSB ATL84FA031Accident · Minor injuriesField investigationFinal reportEmbraer EMB110-P1 · Blountville, TNThe acft was landed with the landing gear up. Post accident tests of the landing gear extension system showed that all operations were normal except for the main gear down-lock indications. When the crew lowered the gear for landing the nose gear and right…NTSB NYC84FA016Accident · 2 fatalField investigationFinal reportBellanca 17-31 ATC · Littleton, MAGround witnesses observed the right wing separate in flight, the acft bank sharply to the right entered a spiral dive and crashed into a wooded lot in a residential area. Investigation revealed that the right wing separation occurred when the front spar lower…NTSB FTW84LA031Accident · No injuriesLimited investigationFinal reportCessna 172RG · Monticello, ARDuring flt, the plt detected smoke in the cabin. Thinking that an electrical malfunction was the source, he secured the electrical master switch & used the battery. A precautionary landing was made at Monticello, AR. During the landing, the right main gear…NTSB NYC84FU002Accident · 1 fatalFinal reportHighcraft Buccaneer · Mountville, PAThe amphibian ultralight vehicle was being flown on a series of flt tests after being assembled. At aprx 1615 EDT, the plt took off & was followed by another plt in another ultralight vehicle for observation purposes. No undesirable flt characteristic was…NTSB MKC84LA006Accident · No injuriesLimited investigationFinal reportPiper PA31-350 · Chillicothe, MODuring arrival, the plt attempted to lower the gear, but only 2 of the 3 would indicate down & safe. The plt was unable to extend the left gear, so he continued flying for aprx 1 hr to burn down fuel, then intentionally landed with the gear up. The landing…NTSB DEN84FA016Accident · No injuriesField investigationFinal reportCessna TU-206A · Loveland, COThe acft lost part of one blade of the propeller during the climb to cruise phase of operation. The passengers were skydivers so they used their parachutes in an exit of the acft as the airframe started to vibrate. The plt made a successful landing on the…NTSB CHI84LA026Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Indianapolis, INAfter takeoff from dyersburg the gear would not fully retract. The plt attempted to lower the gear manually but it was stuck in the transient position. The plt then diverted to Indianapolis & landed with the gear in the transient position. Investigation…NTSB MIA84IA012Incident · No injuriesIncident investigationFinal reportBoeing 727-21 · Miami, FLThe nose gear failed to extend due to impairment of the retraction/extension mechanism by the complete blockage of a hydraulic passagway with foreign matter similar to rubber.NTSB FTW84LA025Accident · No injuriesLimited investigationFinal reportBeech C24R · Prairie Grove, ARThe plt stated that about 15 min after takeoff, the radio & navigation equpment quit working. He decided to return to the arpt to land. However, when he tried to extend the gear, he could not get a safe gear down indication. There was heavy traffic, so he…NTSB DCA84AA002Accident · 10 fatalFinal reportHawker Siddeley HS-748-2A · Pinckneyville, ILAbout 1.5 min after departing springfield, IL, the fltcrew reported a slight electrical problem, but they continued on course. About 33 min later & a few min before the acft should have reached its destination, the acft crashed. Impact occurred while the acft…NTSB SEA84IA008Incident · No injuriesIncident investigationFinal reportS.N.I.A.S. AS350D · Seattle, WAThe acft sustained a complete failure of the tail rotor drine shaft due to fatigue from stress corrosion precipitated byprevious damage at which time no logbook entry was recorded to indicate that the shaft had been inspected.NTSB FTW84LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Eagle Pass, TXOn a previous flt from Mexico city, the plt was unable to land at monterry, Mexico due to wx & continued the flt to the united states. Before reaching his alternate arpt, the acft ran low on fuel, so the plt made a landing in a field near Eagle Pass, TX. He…NTSB CHI84AA016Accident · 1 fatalFinal reportKemmeyer Sonerai II · Battle Creek, MIThe plt flew the home built acft from Battle Creek to marshall, MI to talk to friends. After about 30 min, he took off without refueling. Shortly after the acft departed, a witness on a golf course heard the sound of the eng. He looked up & saw the acft in…NTSB MIA84LA010Accident · No injuriesLimited investigationFinal reportCessna 210L · St. Augustine, FLThe acft landed gear up after the landing gear could be extended in flight. The plt stated during the app to St. Augustine attempts to lower the gear were unsuccessful. The gear doors would open and the hydraulic pump was working butthe gear would not extend.…NTSB MIA84FA004Accident · Serious injuriesField investigationFinal reportSikorsky S-61N · West Palm Beach, FLWhile descending for a landing there was a separation of an outboard section of the main red rotor blade. An old crack was noted & the fracture was attributed to high stress low cycle fatigue damage initiating from corrosion pitting.NTSB FTW84IA007Incident · Minor injuriesIncident investigationFinal reportBoeing B727-023 · Dfw Airport, TXA brake fire resulting from a dragging brake the cause of which was not determined was the reason for an evacuation during taxi back to the ramp because of a brake discrepancy. The slide lost pressure which was attributed to a high heel shoe.NTSB MKC84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Derby, KSThe plt was pacticing landings & stopped after each touchdown. After aprx the 5th landing, the brakes failed to operate & the acft continued off the end of the rwy. Before stopping, the nose gear went in a ditch & collapsed, and the acft nosed over. The plt…NTSB MIA84FA003Accident · 1 fatalField investigationFinal reportKimbal Dyke Delta JD2 · Punta Gorda, FLThe homebuilt acft was observed flying northeast ovr the east side of charlotte county arpt at abt 1000 ft. witnesses stated that the acft pitched downward and entered a spin into the ground. Wreckage examination revealed that the wing bonding material…NTSB SEA84LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Silverdale, WAThe plt stated he was demonstrating how not to ground loop an airplane. When speed was built up on the taxiway, he applied brakes & the left brake failed. The left main gear & left wing folded.NTSB MIA83LA241Accident · No injuriesLimited investigationFinal reportBeech A35 · Orlando, FLThe pilot heard a loud bang when the gear was retracted. After many attempts to extend the gear, the pilot burned off fuel, had the rwy foamed & a gear up landing was made. During the last annual inspection the landing gear actuator was removed and the worm…NTSB ATL83LA384Accident · No injuriesLimited investigationFinal reportCessna 172K · Brundidge, ALWhile cruising at 2,000 ft the plt smelled fuel fumes & elected to make a precautionary landing. When within gliding distance of the arpt, he secured the eng with the mixture control & made an uneventful deadstick landing. After exiting the acft he noticed…NTSB ATL83LA382Accident · Minor injuriesLimited investigationFinal reportAero Commander A-9 · Andalusia, ALAfter spraying 2 fields, the plt was en route to spray a 3rd field when a severe vibration of the acft was encountered. He elected to land in the 1st available field & dumped his chemical load. During the landing, the acft hit a terrace & nosed over. The plt…NTSB DEN83LU005Accident · 1 fatalFinal reportEipper Quicksiver E (Modified) · Sioux Falls, SDAfter takeoff, the plt of the weight-shift controlled, ultralight vehicle entered a steep climb, then began a series of maneuvers which included past vertical wingovers. Reportedly, on his last maneuver, he performed a whip stall. A ground witness stated that…NTSB CHI83IA442Incident · No injuriesIncident investigationFinal reportCessna 172RG · Shell Lake, WIThe number 4 exhaust pushrod failed in flight for an undetermined reason.NTSB MKC83LA222Accident · No injuriesLimited investigationFinal reportS.N.I.A.S. AS350D · Cape Girardeau, MOThe plt reported that during flt, he heard a grinding noise, then the helicopter pitched up & to the left. He reduced power & noticed that the tail rotor was inoperative. During a run-on landing approach, the helicopter begun to yaw, then before touchdown, it…NTSB FTW83IA438Incident · Minor injuriesIncident investigationFinal reportBoeing 727-223B · Dallas/Ft Worth, TXAfter landing & taxi to the ramp while standing with one engine & the APU running smoke filled the cabine. The captain ordered an emergency evacuation which was accomplished. The origin and cause of the smoke is undetermined.NTSB MIA83IA236Incident · No injuriesIncident investigationFinal reportBeech E18S · Opa-Locka, FLBoth normal and emergency landing gear systems failed duringthe landing apch. The gear motor cutout switch was struck anthe emergency instruction plate in the cockpit was installed backwards. The pilot states that he had tried turning the handle in both…NTSB SEA83FU009Accident · Serious injuriesFinal reportCGS Hawk · Richland, WAAfter being assembled, the ultralight vehicle was taxi tested, and on 9/19/83, it was flown on its 1st flt. The next morning it was taxi tested again. At aprx 0855 PDT, the plt took off on a local flt. At aprx 0945, after making a touch-and-go landing, the…NTSB SEA83LA193Accident · Minor injuriesLimited investigationFinal reportAnderson Starduster TOO SA300 · Lynnwood, WAThe plt reported that during flt, there was a change in the engine sound which was followed by a drop in fuel pressure. The plt started to look for a place to land when a total loss of power occurred. He elected to land on a football field. However, after…NTSB FTW83LA435Accident · Minor injuriesLimited investigationFinal reportPitts S-1T · Haskell, OKWhile performing a snaproll at an airshow, the crankshaft failed & the prop separated from the acft. The plt landed on the arpt, but the acft went thru an open hanger before the plt could stop. The wings struck supporting poles under the roof of the hanger.…