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 CHI85LA043Accident · No injuriesLimited investigationFinal reportRockwell AC-112A · Columbus, OHThe acft experienced a main gear collapse during a landing roll. The plt claimed that the acft suffered a failure of theelectrical system shortly after initial takeoff. The plt lowered the lndg gear but was unable to achieve a gear down & locked indication…NTSB MIA85IA021Incident · No injuriesIncident investigationFinal reportPiper PA-60 · Jacksonville, FLThe acft swerved left off the rwy during the landing roll. An exam of the left main landing gear strut revealed that the collar had failed permitting the lower portion of the landing gear strut to shift. The shift was transmitted tothe tire causing it to…NTSB FTW85FA032Accident · Serious injuriesField investigationFinal reportBell 206B · Lane City, TXDuring cruise at 600 ft AGL a bang was heard & acft experienced a vibration. When turning toward a fld to land a second bang was heard & vibration ceased. However, an uncommanded rt yaw was experienced & the nose began to tuck under. Acft contacted terrain…NTSB MIA85LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA-315-B · West Bay, FLThe acft crashed following a loss of tail rotor control while on an external load agricultural flt. Witnesses stated that during a landing attempt at a loading area the acft started spinning, the ext load was jettisoned, and the acft hit the ground and rolled…NTSB FTW85LA030Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Terrell, TXAcft was substantially damaged during an autorotative landing after the plt heard a 'loud pop' from the rear of the helicopter. Investigation revealed the spines on the lower pulley shaft coupling were severly stripped.NTSB LAX85LUQ01Accident · No injuriesFinal reportJack L. Bigham Bede 5B · Camarillo, CAThe plt was performing a go around when the prop drive failed. A forced landing was made on a soft fld adjacent to a taxiway during which the landing gear collapsed. Examination of the acft disclosed the prop drive belt laying in the fuselage.NTSB LAX85LA029Accident · No injuriesLimited investigationFinal reportBeech C24R · Montague, CAThe acft made a forced landing in a pasture and collided with a cow after the engine quit. The plt said he has noticed the landing gear in transit light come on at about 10 minute intervals during the flt. He said he had noticed a red fluid dripping from the…NTSB FTW85IA028Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Tulsa, OKDuring cruise, the crew experienced a loss of hydraulic pressure & smoke in the cockpit, then donned their oxygen masks. They used the emerg gear extension system & made a safe emerg landing. An exam revealed a cracked 2000 PSI aluminum hydraulic line had…NTSB CHI85LA029Accident · No injuriesLimited investigationFinal reportLight Aero Avid Flyer 1 · Allegan, MIPlt stated he noted a momentary flutter in the right flaperon while in cruise at 80 KTS. He then heard a bang and looking at right wing, observed at least two of the outboard flaperon hinge attachments had broken. The acft then entered a 30-degree right bank…NTSB LAX85IA023Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Las Vegas, NVAn uncommanded deployment of the #8 leading edge slat occurred during a climb. Control of the acft was not affected & the flt continued to the destination. The crew attempt to recycle the slats, but to no avail. An exam of the #8 slat actuator did not…NTSB FTW85FA014Accident · 4 fatalField investigationFinal reportPiper PA-23-170 · Seguin, TXShortly after takeoff, acft returned with an unknown engine problem. Left engine was feathered and gear partially extended. Acft too high on final to land, acft continued down rwy, descending and slowing down. Witness said acft entered a VMC roll and dove…NTSB ANC85LA004Accident · No injuriesLimited investigationFinal reportCessna U206 · Hinchinbrook, AKInvestigation revealed that the nose gear torque link bolt sheared during the landing roll on an abandoned sand airstrip causing the gear collapse and noseover. Metallurgical testing disclosed evidence of long term progression of severe corrosion between the…NTSB MIA85LA004Accident · No injuriesLimited investigationFinal reportBeech 58 · Orlando, FLPlt noted decreasing oil press on right engine & diverted to suitable arpt for precautionary lndg. Plt received night vector to runway, arrived high for final approach and received tower clrnc for descending 360 degree turn to lose alt. During turn, right eng…NTSB ATL85IA005Incident · No injuriesIncident investigationFinal reportBell 206B · Chamblee, GAThe plt attemped a descent and noticed the collective had locked up. Even with considerable pressure, he was unable to move the collective in either direction. He checked the system & made several remedial action attempts to no avail. An uneventful emerg…NTSB LAX85FA006Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Newport Beach, CAShortly after takeoff, the propeller separated from the aircraft's left engine. The aircraft continued to climb straight ahead and was then observed in s steep left turn during which it descended and crashed into the roof of a building approximately one…NTSB DEN85FA008Accident · 3 fatalField investigationFinal reportCessna 195A · Santa Fe, NMWhile en route, the transponder was inop & the plt lost radio contact with ARTCC 2 times. As he apchd the destn (Santa Fe), instructions were relayed via another acft. When asked what type apch he wanted, the plt responded, 'well if they can get me lower,…NTSB NYC85FA001Accident · No injuriesField investigationFinal reportBell 206L-1 · Reinholds, PAPlt felt vibration in anti-torque pedals followed by a series of loud bangs coming from the tail section. Plt initiated precautionary landing during which tail rotor effectiveness. During the 'power off' run on landing main rotor blades contacted the tail…NTSB ANC85LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Ohio Creek, AKThe pilot reported that during the landing roll, the right main landing gear wheel adaptor broke. The failure caused the pilot to lose directional control and the airplane subsequently overturned. Examination of the wheel adaptor disclosed evidence of…NTSB NYC84LA327Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Churchton, MDDuring glider tow climbout, encounter with thermal resulted in momentary tow rope slack. Tow rope separated in overload when slack was taken up. Glider plt selected nearest open fld & set up landing pattern. On downwind leg, plt noted obstructions in fld,…NTSB NYC84FA326Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · Turbotville, PAWhile the acft was en route, ATC advised the plt of VFR traffic at his one o'clock position at 12 mi on a nw heading. The plt acknowledged, but reported that he had no contact & said the wx was a little hazy. A short time later, ATC advised the traffic was…NTSB CHI84LA408Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Defiance, OHDuring initial takeoff climb at alt of 300 ft AGL, 9 1/4 inches of rt engine prop blade separated. Forced landing was make in field during which time the rt wing contacted a tree. Metallurgical examination revealed progressive fatigue over 75% of the…NTSB MIA84LA263Accident · No injuriesLimited investigationFinal reportCessna 421 · Naples, FLDuring climbout on this FAA check ride the acft experienced a nose gear extension-retraction malfunction of unknown origin. The plt was unable to extend the nose gear for landing. According to the FAA examiner on the flt, the PIC shut down both engines on…NTSB ATL84FA298Accident · 1 fatalField investigationFinal reportBeech V35B · Mc Cormick, SCN6740Z, a Beech V35B acft,separated in flt over mccormick, SC while operating in VFR conditions. The investigation failed to locate witnesses who observed the flt prior to & during the inflight separation. Witnesses on the ground heard the acft & observed…NTSB LAX84LA495Accident · No injuriesLimited investigationFinal reportSchweizer G164 · Tulare, CAThe aircraft had a full load of fuel and chemicals on board for this takeoff. The pilot stated that the brakes locked on the takeoff ground run and reduced the aircrafts acceleration. A railroad cross tie barrier at the end of the runway made an on ground…NTSB LAX84LA494Accident · Serious injuriesLimited investigationFinal reportHiller UH12ET · Yuma, AZThe pilot stated that he was carrying a load of pesticide for application on a broccoli field. The aircraft was in level flight, approximately 4 to 8 feet AGL when it became uncontrollable and impacted the ground. The aircraft was consumed by a post crash…NTSB LAX84LA493Accident · No injuriesLimited investigationFinal reportCessna 180 · Camarillo, CAThe pilot reported that he was unfamiliar with the acft. He discovered that the right main tire was deflated during his landing roll and he over controlled the acft while compensating. The acft ground looped to the left and nosed over.NTSB NYC84FA319Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Unionville, PAOn approach, acft yawed right. Plt reduced power and executed emerg lndg. Before shutdown, it was noted the t/r was stationary while the main rotor continued to turn. Investigation revealed t/r drive shaft had separted due to thermal/mechanical damage…NTSB LAX84FA487Accident · No injuriesField investigationFinal reportCessna 550 · Santa Ana, CAAfter completing a dual instructional flt in 91 to 103 deg wx, the acft landed uneventfully. The PIC failed to follow the required procedure in the flight manual of turning off the anti-skid switch after clearing the rwy. Rather, he used the outdated…NTSB CHI84LA394Accident · No injuriesLimited investigationFinal reportBeech A-24R · Evansville, INShortly after take off, plt experienced complete electrical failure, later traced to a broken field wire on the acft alternator terminal. Plt returned for landing & placed gear handle in down position. Gear failed to extend (electrically operated). Plt made…NTSB LAX84LA482Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Calistoga, CAThe starboard entrance hatch opened during takeoff roll. The pilot aborted the takeoff. The acft could not be stopped on the remaining rwy & collided with a ditch. The takeoff was attempted with a light tailwind on a unidirectional rwy.NTSB FTW84IA400Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Dfw Airport, TXThe acft experienced sepn of the rgt wing #3 leading edge slat while descending for an apch. An investigation revealed that on 7/5/84, the company performed a 'c' check inspection of the acft. At this time a rgt wing #3 leading edge slat retract aluminum…NTSB NYC84LA278Accident · No injuriesLimited investigationFinal reportCessna C182 · Norridgewock, MEA parachte became entangled in the horizontal stabilizer while the acft was maneuvering to drop the parachutists. The acft made a hard landing after the parachustist disengaged from the acft. The acft stabilizer spar was damaged in the encounter and the lack…NTSB DEN84LA282Accident · No injuriesLimited investigationFinal reportAerospatiale 316B Alouette III · Cokeville, WYThe plt stated that he lost tailrotor control while maneuvering for a landing. He elected to return to Cokeville airport and make the landing. The plt executed an aitorotation to the runway and during the landing flare, the tail skid struck the runway,…NTSB MKC84LA268Accident · No injuriesLimited investigationFinal reportCessna 172 M · Heber Springs, ARThe acft ran off the side of the rwy into some brush and a ditch. The plt said the landing seemed normal until she applied the brakes and the acft veered to the right. The lift wheel brake was found to be worn after the accident.NTSB ANC84LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Chistochina, AKThe acft collided with a car during an aborted takeoff. The plt said that the acft would not attain flying speed so halfway down the rwy she aborted the takeoff. She also said that she and her passengers removed frost off the acft for about 25 minutes before…NTSB FTW84FA374Accident · 1 fatalField investigationFinal reportMiller Air Sports GEM 260 · Martindale, TXNotes left by plt indicate he had been testing the flight envelope of this experimental racing acft, including operation of the engine beyond prop limit of 4000 RPM. Witnesses heard engine sound suddenly speed up to high RPM then cease altogether. Some…NTSB ANC84LA158Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe acft was damaged in an off arpt precautionary landing atter the engine began vibrating with the oil temperature in the red. The plt said he turned off the ELT to conserve the battery.NTSB NYC84FFJ04Accident · 1 fatalFinal reportSchweizer SGS 1-36 · Elmira, NYVery shortly after takeoff at 150 to 200 ft the tow rope failed. The glider initiated a steep left turn back to the arpt. During the turn witnesses observed the acft to stall and enter an uncontrolled near vertical descent to ground impact.NTSB MKC84FA262Accident · Serious injuriesField investigationFinal reportShindler-Smiley THE Blue MAX · Lawrence, KSWhile in cruise flt, plt noted rising oil temp and decreasing oil press, and elected to make a precuationary landing in open alfalfa field. During landing flare, acft stalled, right wing dropped then left wing dropped to ground contact. Engine exam disclosed…NTSB MIA84IA242Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Orlando, FLJust prior to V1 and rotation both left main landing gear tires failed. Takeoff was aborted and acft was stopped on rwy. Pax & crew deplaned without injury. Cause of tire failure could not be determined.NTSB MKC84LA261Accident · No injuriesLimited investigationFinal reportCessna U206F · Satanta, KSThe pilot selected 10 degrees of flap for takeoff with the aircraft loaded to near limits for existing conditions. The aircraft became airborne in ground effect and would not accelerate to flying speed, necessitating a forced landing in a soybean field.…NTSB LAX84LA454Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355E · Strawberry, CAThe helicopter was approaching the landing pad when the plt heard a loud noise & experienced a loss of tail rotor control. He lost directional control & the helicopter began spinning to the left, struck the helipad, rolled over & burned. The acft was…NTSB FTW84LA366Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Oak Grove, LAAircraft landed with a flat left main tire, veered left and nosed over inverted.NTSB MKC84LA259Accident · No injuriesLimited investigationFinal reportBeech A36 · Carlisle, ARThe acft landing gear collapsed during landing. After electrical failure the plt had cranked the gear down in flt. Inspection revealed that a nut on the alternator ground wire had come off. The landing gear manual extension system had no deficiencies.NTSB FTW84LA360Accident · No injuriesLimited investigationFinal reportCessna 310Q · Amarillo, TXDuring gear retraction on post-maintenance check flight initial climb, gear unlocked light remained on and gear extend/retract motor circuit breaker popped. Plt reset cb and heard a 'loud pop' from the nose section of the acft. Plt then extended gear but nose…NTSB ATL84LA261Accident · No injuriesLimited investigationFinal reportCessna A188B · Kingstree, SCThe acft ran into high vegatation during a precautionary landing after the plt heard a vibration which began aprx 2 hrs after the initial takeoff. The vibration was caused by a loose wing fairing. Examination of the acft revealed that a screw stripped out of…NTSB ATL84LA258Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Virginia Beach, VAAfter a banner tow pick-up, rudder jammed full right. Plt applied both feet to left rudder pedal in attempt to control direction of flt. Left rudder cable then failed in overload as banner engaged power line and broke free. Directional control requirements on…NTSB ATL84IA255Incident · Minor injuriesIncident investigationFinal reportSwearingen SA226TC · Memphis, TNDuring level off at 16,000 ft with a sea level cabin pressure (6 PSI differential pressure), the crew heard a 'pop', then the coplt's window blew out. Debris, including the glareshield, exited the cockpit & injured the copilot. The window was a single…NTSB CHI84LA336Accident · No injuriesLimited investigationFinal reportCessna 180 · Springfield, OHAfter what the pilot described as a normal landing his seat dislodged from the track and tilted back against the rear seat. He held on to the yore but was unable to reach the pedals. The a/c slowed to about 20-25 mph then the right main landing gear failed at…NTSB CHI84LA338Accident · 1 fatalLimited investigationFinal reportPiper PA-28-160 · Palmyra, WIWhile on a personal flt the eng and airframe began to vibrate severely. The plt closed the throttle and turned eastward to land in a mint field. As he approached the field he applied power to clear a row of small houses, but during this maneuver struck a…