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 ANC84LA130Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Aleknagik, AKThe acft crashed into trees short of a clearing during a forced landing following a prop failure. Post accident attemptsto identify the reasons for the failure were clouded by the impact damage. The acft was placarded warning against continuous high RPM…NTSB FTW84LA353Accident · No injuriesLimited investigationFinal reportCessna A188B · Driscoll, TXAcft experienced a propeller blade failure in flight followed by an engine failure due to the unbalanced forces. While making a forced landing the acft was landed hard. The acft was being flown to a field where aerial application was to be performed and had a…NTSB DEN84IA241Incident · No injuriesIncident investigationFinal reportde Havilland DHC-7-100 · Denver, COThe left main landing gear was disassembled & reassembled by company maintenance personnel & the acft was being ferried to another base for permanent landing gear repairs. During takeoff, the left main landing gear and shock strut seperated from the acft. The…NTSB CHI84FU007Accident · 1 fatalFinal reportCollins Fisher FP-202 · Ludington, MIThe ultra-light was constructed by the pilot and two other persons. This group had no previous experience in aircraft construction. This was the third known flight for this aircraft. It had been flown two days prior to the accident and an adjustment to the…NTSB FTW84LA325Accident · Minor injuriesLimited investigationFinal reportBell 47J · Grove, OKThe plt stated that yaw control was lost during climb out for a local flt with two passengers onboard. The acft began torotate to the right and the antitorque pedals were ineffective. They were over buildings at the time so the plt held a minimum descent…NTSB NYC84IA271Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Buffalo, NYDuring the departure from newark, NJ, the aircrew noted a vibration which ceased after the gear was retracted. The crew suspected that a tire was out-of-round or a gear door was vibrating & continued the flt. During the apch to Buffalo, NY, the vibration…NTSB FTW84LA323Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Wichita Falls, TXThe acft lost thrust and started a descent at full power during climbout. A forced landing was made in a residential area. Examination of the acft indicated that the prop blades had twisted to low pitch. One blade was twisted 180 degreesat the scene. Torques…NTSB MIA84LA211Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Bainbridge, GAShortly after takeoff at about 150 ft AGL the propeller hub failed allowing one propeller blade to separate from the acft. The pilot flew the forced landing straight ahead into trees. Metallurgical examination of the hub revealed evidence of a fatigue…NTSB CHI84IA314Incident · No injuriesIncident investigationFinal reportBoeing 727-2M7 · Minneapolis, MNThe crew reported that they noticed a decrease in climb rate while over rapid city, SD, en route from msp to sfo at flt level 310. The plt noted fuel burn was aprx 1400 lbs ahead of schedule. In-flt inspection revealed that the inboard trailing edge flaps had…NTSB LAX84FA415Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-300 · Tau, AntarcticaThe acft crash landed after the plt used flaps and power to semi-control pitch after the elevator down control cable failed at about 300 ft AGL on final approach. The left wing of the acft hit the terminal roof during the stall mush FROM50 ft AGL. The company…NTSB MKC84LA228Accident · No injuriesLimited investigationFinal reportAero Commander Thrush S2R · Waldenberg, ARWhile on takeoff roll one propeller blade separated and the engine came loose from the engine mounts. The acft was then stopped on the rwy.NTSB MKC84IA220Incident · No injuriesIncident investigationFinal reportBeech C-45H · Columbia, MOThe plt reported that he was unable to get a down & locked indication on the main landing gear when arriving at Columbia. He stated that he went thru the emergency procedures & made two landing attempts but felt the gear was about to collapse & made…NTSB LAX84FA405Accident · 2 fatalField investigationFinal reportHughes 369D · Mesa, AZThe helicopter experienced a main rotor drive system disconnect, an uncontrolled descent & subsequent inflight collision with terrain in a hilly desert area. This was the third & last in a planned series of marketing demo flts conducted for three USMC…NTSB SEA84LA174Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Redmond, ORThe acft collided with the ground after a in-flt main rotor blade separation during an aerial application flt. Inspection of the fracture surface of the failed blade revealed characteristics consistant with the high stress, low cycle fatigue. Lab findings…NTSB CHI84IA301Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Chicago, ILThe #2 wheel assembly separated from the acft during takeoff roll. Flt was diverted to atlanta, GA, where an uneventful landing was made. Inspection revealed the axle failure occurred as a result of fatigue crack propagation of numerous prior cracks in the…NTSB LAX84LA394Accident · Serious injuriesLimited investigationFinal reportExperimental Amateur Built OWL Racer · Oroville, CAThe Experimental/amateur built aircraft had just turned inbound for an exhibition race run when it experienced severe vibrations as the pilot applied full power. He headed for the runway and found that he could not control the engine with the throttle. He was…NTSB DEN84LA224Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Richey, MTThe plt had finished spraying & was proceeding to the glendive arpt. He said that eng or prop began a sudden severe vibration which required the eng to be shut down. An emegency landing was made. The plt stated that the left wing impacted a hill which spun…NTSB CHI84FA290Accident · 1 fatalField investigationFinal reportJerry D. Fish Drifter · Columbus, INDuring flt, the plt was performing aerobatics & did a series of loops. While maneuvering, the left wing folded upward & the acft, an experimental ultralight, entered a descent & crashed. An exam revealed that the left wing had folded over the eng. Evidence…NTSB CHI84LA291Accident · Serious injuriesLimited investigationFinal reportSIAI-Marchetti FN-333 · Lansing, MIThe acft was not flown for 6 yrs. During last annual inspection, 67 hrs of labor, the batteries (2), spark plug gaskets,magneto gaskets, battery cable lugs and impulse coupling were replaced. The fuel quantity transmitter, battery, magnetos and spark plugs…NTSB LAX84FU029Accident · 1 fatalFinal reportUltralight Soaring Wizard J-3B · Lake Elsinore, CAThe Ultralight was observed by witnesses to be circling, then performed what was described as a 'barrel-type' maneuver. During the maneuver, the right wing collapsed and the acft spiraled to the ground in an uncontrolled descent. During theinvestigation of…NTSB ANC84LA114Accident · No injuriesLimited investigationFinal reportCessna 185 · Bethel, AKThe acft ran off the right side of the rwy after touchdown. The plt indicated that the right main tire blew out. He saidthat he was unable to keep the acft on the rwy and it nosed down into soft dirt.NTSB SEA84IA168Incident · No injuriesIncident investigationFinal reportBoeing B-737-222 · Portland, ORAfter takeoff, the acft was climbing thru about 4000 ft when the APU fire warning light illuminated. The flt crew discharged the fire extinguishing units & requested an emergency landing. A teardown of the APU revealed evidence that a hard object was injested…NTSB MKC84LA205Accident · No injuriesLimited investigationFinal reportHiller H-23D · Neelyville, MOThe acft rolled over during an emergency landing. The plt claimed that the rotor disengaged at about 30 ft AGL during takeoff. After the accident the upper half of the yoke control was found fractured. A lab report stated that no materialdefects were related…NTSB NYC84LA236Accident · No injuriesLimited investigationFinal reportBeech 58 · Oneonta, NYPlt stated he was making multiple communications on base leg, talking on company freq as well as UNICOM, while adjusting his pattern to accomodate slow traffic on the runway and maintaing acft handling in gusty wind conditions. Gear handle was selected to…NTSB SEA84LA165Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Juneau, AKThe cowling of the acft came loose and the plt reduced power because of the vibration. An emergency was declared and theplt attempted a 180 degree turn at an alt of 400 ft AGL. A stall was entered and the acft hit a channel where the water was about 10 ft…NTSB FTW84FA302Accident · 1 fatalField investigationFinal reportMooney M-18LA · New Iberia, LAA plt witness observed the acft in a 20 to 30 deg dive at high speed just prior to the accident. He reported that at an alt of about 1200 to 1300 ft, the acft began a pull-up. As the pull-up was started, the outboard portion of the acft's left wing folded…NTSB CHI84LA286Accident · No injuriesLimited investigationFinal reportGillmore Moni · Joliet, ILThe prop separated from the acft at aprx 500 ft AGL during the initial takeoff climb. A forced landing was made in a corn field. The prop was attached by means of 4 5/16 inch bolts and retaining nuts. Two of the four bolt portions remaining after the accident…NTSB BFO84FU001Accident · 1 fatalFinal reportEipper Quicksilver MX · Elkton, MDThe ultralight pilot had been practicing maneuvers that weredescribed as whip stalls which were not taught or authorizedbecause of the excessive 'g' forces imposed. An instructor checked his machine and warned him of the dangers on the day of the accident.…NTSB CHI84IA294Incident · No injuriesIncident investigationFinal reportEnstrom F-28A · Muncie, INAccording to the plt, he was in a 20 deg left bank with an airspeed of about 40 KTS when the helicopter began rotation to the right. He entered an autorotation & landed with a forward speed of about 5 KTS. An exam revealed that the tail rotor drive shaft had…NTSB DEN84FA207Accident · 2 fatalField investigationFinal reportBell 206B · Englewood, COWitnesses stated the helicopter entered a 'hard left turn' into a near inverted position before 'it went down hard and fast.' Inspection disclosed the metal connection for the left cyclic stick was broken in half. (Plt was flying from left seat.) Exam of the…NTSB ATL84LA215Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hickory, NCAcft landed with the nose gear retracted. Examination revealed that the nose gear was hung up in the wheel well because an AN4-12 bolt, which secured the nose gear centering spring ass'y, was hung up in the gear door linkage. An annual inspection was…NTSB ATL84FU006Accident · 1 fatalFinal reportRitz A · Tullahoma, TNThe ultralight had been flown for 4 ftls and the plt upon landing mentioned a possible control problem with the owner and builder. The builder then took the vehicle up to show how fast it would go. After about 30 minutes of flt he dove atthe rwy in a full…NTSB FTW84LA293Accident · No injuriesLimited investigationFinal reportMooney M20C · Marshall, TXThe plt reported initial landing extension indicated an unsafe condition. The landing gear was recycled & a safe down & locked position was indicated. On landing roll the acft veered left off of the rwy & collided with trees. Tire marks on the rwy indicated…NTSB MKC84LA189Accident · No injuriesLimited investigationFinal reportCessna T210M · Kirksville, MOAfter taking off, the plt noted a malfunction of the landing gear sys. He then tried to lower the gear, but the nose gear would not extend. All attempts to extend the nose gear were unsuccessful, so the plt elected to make a wheels-up landing. After the…NTSB NYC84IA225Incident · Minor injuriesIncident investigationFinal reportBoeing 737-130 · Portland, MECaptain heard loud 'pop' and observed an electrical panel interruption along with illumination of rt 'bus off' & 'gen off bus' lights. No generator amps or freqs were observed. Faint odor of smoke. Capt started APU and put APU generator on rt side. 'Bus off'…NTSB LAX84FA371Accident · 2 fatalField investigationFinal reportHughes 269B · Palos Verde Est, CAGnd witnesses obsvd helicopter into normal turn at 500 ft AGL followed by a violent rt turn. During the violent turn the tail rotor assy separated & the main rotor blades coned upwards. The helicopter went into a near vertical descent & crashed. Wreckage exam…NTSB MKC84IA185Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Joplin, MOWhile taxiing to takeoff & on the takeoff roll, the left brake overheated. Ten to fifteen mins after departure both tires on the left main landing gear exploded. The bearings and brakes also seized due to the high temperatures. Upon arrival at the dest, the…NTSB LAX84LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gila Bend, AZA forced landing was made on a road after the plt shut down the eng due to a 'run-away' prop. During the landing roll, the left wing tip struck a reflector post followed by the right wing striking a sign post. An eng overhaul & an annual inspection had been…NTSB CHI84IA264Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-54 · Chicago, ILDuring the landing roll, the left main gear swivel link pin failed allowing the rear set of tires to become detached from the main strut and drag along the rwy. The left main gear bogie was last overhauled in 1981. At the time of failure, it had 4459 hours…NTSB ANC84IA103Incident · No injuriesIncident investigationFinal reportFairchild C-82A · Anchorage, AKDuring arrival at the destination arpt, the aircrew was unable to extend the landing gear by using either the normal or emergency systems. They elected to return to Anchorage where emergency equipment was available. Fuel was reduced & subsequently a wheels up…NTSB DEN84LA215Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Marion, SDIn cruise flt, oil covered the windscreen and plt elected a precautionary landing on a dirt road. Acft collided with a mailbox on roll out and nosed over. Oil filler cap found loose.NTSB MIA84FU006Accident · 1 fatalFinal reportStorey SKY PUP · Indiantown, FLThe ultralight experienced an in-flight separation of the left wing. The wing separated at the wing attachment fitting. The plt & ultralight had a parachute attached but it did not deploy.NTSB MIA84LA186Accident · No injuriesLimited investigationFinal reportCessna A188B · Marianna, FLDuring a crop dusting operation, there was an apparent loss of power & oil sprayed on the windshield of the acft. The plt stated that when he applied power, there was no response. He made a forced landing on a road, but the right wing of the acft hit a tree.…NTSB LAX84LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fair Oaks, CAAcft touched down beyond the threshold at a normal airspeed. Plt raised the flaps and applied brakes but the left brake bottomed out with no resistance. An intentional ground loop was performed to stop the acft. Inspection revealed that allthe brake pads were…NTSB CHI84IA246Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-73 · Chicago, ILDuring descent, flt engineer noticed the hydraulic fluid level was low. Acft landed with locked brakes on all 4 wheels of the rt main gear and all 4 tires were blown out. Two hydraulic line fittings on the rudder hydraulic booster package were found to be the…NTSB MKC84FA174Accident · 4 fatalField investigationFinal reportBeech C35 · Broken Bow, NEWhile on an IFR flt at 6000 ft, the plt requested, and was granted a deviation around wx. Later, N335W informed denver ARTCC that they were going to get into some moderate turbulence for a little bit but that it looked like the light at the end of the tunnel.…NTSB ANC84FA094Accident · No injuriesField investigationFinal reportCessna A185F · Talkeetna, AKThe acft was being used to transport mountain climbers from a glacier. During takeoff from the glacier, the right landing gear strut failed at the axle point & the wheel/ski dangled free. When he landed on a gravel rwy, the plt held off the right side as long…NTSB MKC84LA180Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pocahontas, ARAbout 18 inches of one propeller blade separated in flight. The acft began to shake violently and the plt shutdown the engine. The aircraft crashed during the forced lndg. Metallurgical examination revealed features typical of fatique cracking over aprox 2/3…NTSB LAX84LA354Accident · No injuriesLimited investigationFinal reportCessna T210N · Camp Verde, AZThe plt reported that during the landing, the acft rolled about 200 to 250 ft after touchdown, then began veering to the left. He attempted to maintain directional control by applying right rudder & brake, but was unusccessful. The left main gear hit a berm,…NTSB CHI84IA252Incident · No injuriesIncident investigationFinal reportFairchild SA-227-TT · Pontiac, MIThe aircrew noticed a 'nose up' pitch change during descent at about the time they were leveling to slow for the arpt pattern & traffic. The plt reported that full forward yoke pressure was required to stop the nose up condition. The acft was landed without…