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 FTW83LA274Accident · Minor injuriesLimited investigationFinal reportHughes 369D · S. Padre Island, TXThe helicopter made a hard touchdown during a precautionary landing after the plt felt a tail rotor vibration. The landing was made on a beach and the touchdown collapsed the left side of the landing gear cross tube. This separated thetail boom. Examination…NTSB FTW83IA279Incident · No injuriesIncident investigationFinal reportAerospatiale AS 355 F · High Island 582Acft developed a severe vertical vibration and made a precautionary landing. Fatigue cracks were found which originated in a corrosion pit located in an area of chipped paint which had been covered with a coat of primer contrary to Aerospatiale service…NTSB LAX83LA278Accident · No injuriesLimited investigationFinal reportPiper PA-25 · New River, AZThe pilot stated that he refueled his aircraft and secured the gas cap after which he made four fifteen minutes aero tow flights. During the fifth aero tow, as the aircraft was climbing, the pilot heard an object strike the wind shield and he saw that the gas…NTSB LAX83FA277Accident · 2 fatalField investigationFinal reportBell 212 · Goleta, CAThe plt stated that as he approached the oil rig & reduced power to start his descent from 500 ft, the tail rotor (t/r) pedals began to vibrate. The vibrations became worse with a further reduction of power to reduce airspeed. The plt then planned a descent…NTSB SEA83FA121Accident · No injuriesField investigationFinal reportLearjet 35 · Seattle, WAThe acft dragged the right wing tip tank and ruptured it after the passenger door opened during takeoff. During the aborted takeoff the acft oscillated right, left and right before making ground contact on the right wing. The highest alt attained was about…NTSB CHI83FU003Accident · Serious injuriesFinal reportSunburst 1 · Fraser, MIA witness reported that this ultralight was 1 of 3 that took off on rwy 18, then turned 180 deg to a northerly heading. He reported that the ultralight was in level flt at aprx 200 ft when it suddenly pitched nose down, then it nosed up. At about that time,…NTSB MKC83FU003Accident · 1 fatalFinal reportAirmass Sunburst · Pittsburg, KSThe plt had completed a private plt ground school course & had flown aprx 4.6 hrs in a Cessna 172 before flying his home built ultralight vehicle. During a test flt, he was making a go-around from a touch-and-go landing when the vehicle crashed. A witness…NTSB DCA83AA029Accident · No injuriesFinal reportLockheed 188C · Cold Bay, AKDuring a cruise climb, the aircrew noted an unusual vibration; however, attempts to isolate the vibration were unsuccessful. While climbing from FL190 to FL250, the flt engineer went aft to observe the engs & props, but noted nothing unusual. A flt attendant…NTSB ANC83FA092Accident · No injuriesField investigationFinal reportBell B47G-2 · Anchorage, AKThe helicopter experienced a tail rotor strike during a hard landing with a door open. According to the student pilot who is a commercial pilot working on an add-on helicopter rating, the left cockpit door unlatched and partially opened on the downwind leg…NTSB SEA83LA119Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Near Randle, WAThe acft was engaged in log slinging operations and had just released a load and initiated a climb away from the site when according to the pilot the engine started to spool down, although the pilot was able return to the log-landingarea there was…NTSB MKC83FA122Accident · Serious injuriesField investigationFinal reportCessna 320E · Minden, NEThe acft stalled and crashed on the final approach to land. The acft had called for landing information and entered the pattern and was seen established in a low final approach when it suddenly turned right and descended to the ground. The acft impacted about…NTSB FTW83LA263Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Texarkana, ARThe acft landed short of the rwy and the landing gear collapsed during a night landing. Electrical failure occurred on the acft shortly after takeoff. When elect recal power could not be restored the plt elected to return to Texarkana and land using VASI. The…NTSB CHI83LU002Accident · Serious injuriesFinal reportBarnstormer 1 · Newton, ILDuring takeoff, the right wing collapsed when the ultralight vehicle was climbing thru aprx 100 ft AGL. An investigation disclosed that the right wing spar failed allowing the section, outboard of the strut attach point, to fold upward.NTSB LAX83LA269Accident · No injuriesLimited investigationFinal reportCessna T337H · Redding, CADuring the landing sequence at a private airstrip the plt attempted to lower the landing gear but found it would not lock. The acft was returned to the departure arpt and after circling for two and one half hours with darkness approaching was landed with the…NTSB MKC83LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Chesterfield, MOThe acft swerved off the runway into soft terrain and collapsed the main gear during landing. The pilot stated that a normal landing was made after which the left tire blew out and the acft swerved off the runway. Examination of the tire after the accident…NTSB DEN83LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Ennis, MTDuring a night flight, oil began spreading over the windshield & heavy smoke came in the cockpit through the cabin heater. The plt opened the cabin windows, reduced power & turned back toward the arpt. The oil pressure dropped to 5 PSI & the plt descended to…NTSB CHI83IA228Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Clarion, PADuring descent in turbulence the crew noted all 3 engines were overtempting and experiencing compressor stalls. Attemptsto reduce throttles did not reduce the temperatures. No 183 engines were shut down. During diversion to a close airport the engines were…NTSB LAX83LA248Accident · Minor injuriesLimited investigationFinal reportEnstrom 280C · Goshen, CAAbout 5 min after taking off, the plt noticed a sudden loss of power to the tail rotor. He made an emergency landing in an alfalfa field. He reported that during an autorotative landing, he had insufficient collective to flare properly. Subsequently, the main…NTSB LAX83LA244Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · Redding, CAThe acft veered off the rwy collided with a ditch and nosed over during landing. The pilot stated that the engine died when he retarded it to idle at touchdown. When he applied the brakes the pedals had no pressure and no effect. Due to a slight crosswind and…NTSB ATL83IA197Incident · No injuriesIncident investigationFinal reportBoeing B-737-222 · Memphis, TNA malfunctioning relay resulted in overheating of an air conditioning pack causing the evacuation of the acft prior to takeoff.NTSB FTW83FA245Accident · 1 fatalField investigationFinal reportBreezy DRAKE-EDGAR · Broken Arrow, OKThe acft collided with the ground in a flat spin that lasted for about 14 turns with no change in attitude. The plt had just completed an air show and was preparing to join a formation flt to return to the arpt. Just before joining the formation the plt was…NTSB DEN83LU001Accident · 1 fatalFinal reportIntl Ultralight Banshee · St. George, UTReportedly, the ultralight vehicle was assembled at an abandoned arpt, then was test flown by an international ultralight company salesman. The non-rated plt, who was planning to buy the ultralight, then flew the vehicle to familiarize himself with its flt…NTSB CHI83LA223Accident · Serious injuriesLimited investigationFinal reportSchreder HP12A · Stanton, MNThe pilot performed his preflight checks including a flight control check. After lift off the pilot could not control the pitch of the glider. As the pitch increased to about 30 degrees he elected to release the tow cable from the tow aircraft. The glider…NTSB NYC83FA122Accident · Serious injuriesField investigationFinal reportCessna 172N · N. Stonington, CTThe acft collided with a tree during a go-around at night following a downwind precautionary landing. During the flt the plt had noted the fuel gauges at low readings and said he suspected a 'fuel leak'. He made radio calls to try to go to an arpt before fuel…NTSB NYC83FA121Accident · 1 fatalField investigationFinal reportMooney M-20K · Old Lyme, CTThe acft collided with the ground in IMC after the plt reported he lost his vacuum instruments. The flt originated at mattituck, NY with a destination of lebanon, NH. After departure the plt was cleared to climb to 7000 ft. the instrumentrated pilot was on an…NTSB FTW83FA238Accident · 1 fatalField investigationFinal reportAerospatiale AS-350D · Venice, LAThe acft crashed into a swamp with low rotor RPM after a failure of the accessory gearbox power output gear. The pilot radioed an emergency call saying he was experiencing severe vibrations and was landing. A few seconds later, he radioed that he was…NTSB FTW83LA239Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hayes, LAThe acft ran off the rt side of the rwy and collided with a dirt embankment drng lndg roll. Brake fluid was found on the l main gear following the accd. Investigation revealed the source of the leak to be a popped o-ring in the brake actuating cylinder.NTSB NYC83FHM01Accident · Minor injuriesFinal reportBell 47G · Plainsboro, NJThe acft collided with the ground after a tail rotor drive shaft failed. The plt lost tail rotor control during an aerial application maneuver. The metallurgist report of examination and discovery of fatigue fracture after the accident is a part of the…NTSB FTW83FA232Accident · Serious injuriesField investigationFinal reportBell 47G · Zachary, LAThe tail rotor gear box separated from the acft during practice autorotation. The acft began to spin rapidly and nose down. Increasing the power brought the nose up but increased the speed of rotation. The acft hit on one skid still in a rapid spin. The…NTSB DEN83FA111Accident · No injuriesField investigationFinal reportPiper PA28R-201T · Aurora, COThe plt received a jump start because the battery failed to start the eng. After departure & leveling of at 10,000 ft, he was concerned with the 1 inch of rime ice he had picked up & got an updated wx briefing from flt watch. He asked for & received a…NTSB NYC83FU004Accident · 1 fatalFinal reportVector 610 · Turners Falls, MAOn 4/18/83, the ultralight vehicle was damaged by high winds. This necessitated the replacement of the front & rear spars as well as the battens which provided curvature to the upper wing surface. Prior to a test flt, a weighted tail wheel was also installed.…NTSB MKC83LA105Accident · No injuriesLimited investigationFinal reportCessna 182Q · Springfield, MOThe acft went off the runway, collapsed the nose gear and nosed over during landing. The pilot was unable to extend the flaps and tried to land on a 3800 foot runway. There was a 7003 foot runway 8 NM west of the landing site. The pilot also had a tailwind of…NTSB FTW83FU001Accident · 1 fatalFinal reportRotec Rally 2B · Manvel, TXThe plt had flown the ultralight vehicle to his employer's house & landed in the back yard. During the landing, the vehicle sustained damage which included a bent main landing gear axle, a sheared kingpin bolt & a cracked tail boom to tailmount sleeve. A…NTSB ATL83LA181Accident · No injuriesLimited investigationFinal reportPitts S1-SP · Wetumpka, ALThe acft experienced an inflt structural failure of its upper wing during aerobatics in an air show. The acft was landedsafely and the pilot was not injured. The upper wing leading edge ribs reportedly collapsed as the pilot began to pull up at the beginning…NTSB ATL83FA178Accident · 1 fatalField investigationFinal reportCessna 150 · Kennesaw, GAThe acft crashed in a wooded area after a touch and go landing. The wing flaps lever had been placed to the up position but the flaps did not retract. When the CFI finally noticed that the flaps were not up he took over at about 200 ft AGL and started a…NTSB MIA83LA139Accident · No injuriesLimited investigationFinal reportCessna 421C · Gainesville, FLDuring takeoff, the aircrew heard an unusual 'thud' sound as the gear was retracting, but all gear indications were normal. Prior to landing at the destination, 3 green lights were observed when the landing gear switch was moved to extend the gear. A normal…NTSB CHI83IA209Incident · No injuriesIncident investigationFinal reportAero Commander 500B · Youngstown, OHWhile cruising at 5000 ft MSL, the plt heard a 'very loud bang' & noted 'very much vibration from the left eng.' He shut down & feathered the left eng & prop. When the eng stopped turning, he noted 1 prop blade was missing. The acft was landed without further…NTSB SEA83FYM05Accident · 1 fatalFinal reportBrantly Helicopter B-2 · Milton Freewtr., ORThe helicopter was observed to climb to about 50-75 ft AGL & then something flew off the acft. One m/r blade was found intact 240 ft from the wreckage. The outer blade was heavily damaged at the tip area. The inboard blade section had the pylon tube attached…NTSB LAX83FVG11Accident · 1 fatalFinal reportRietman Widget · Yreke, CAAfter takeoff the acft was observed to climb to about 7,000-8,000 ft MSL & enter a slow flat spin. 8 turns were counted & the acft did not recover. The plt bailed out of the acft at about 500-600 ft but the parachute did not have time to fully deploy. The…NTSB MIA83LA130Accident · No injuriesLimited investigationFinal reportGlobe GC1B · Miami, FLThe acft groundlooped and collapsed the landing gear after the rt brake failed during taxi from landing. The pilot said he had installed new brake pads and had spent time taxiing to wear them in. After completing one takeoff and landing theacft was being…NTSB FTW83LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Spicewood, TXWhile on the landing roll, the brakes failed & the plt was unable to stop on the remaining rwy. Subsequently, the acft hit a metal light pole, the nose gear was damaged when it hit a hole & the left wing struck trees. An exam of the brakes revealed that the…NTSB LAX83LA197Accident · No injuriesLimited investigationFinal reportMaule M-5-220C · Young, AZThe plt reported that the landing was normal, & as he applied brakes the right brake failed. He intentionally applied hard left brake to negotiate a ground-loop to avoid trees at the end of the rwy. Disassembly of the right master brake cylinder revealed that…NTSB LAX83FU002Accident · Serious injuriesFinal reportRotec Rally 2B · Le Grand, CAReportedly, the plt took off & landed in a dairy pasture with no apparent difficulties. He then took off again on an easterly heading. After takeoff, he turned to a modified crosswind/downwind pattern & was proceeding in a northwesterly direction. Reportedly,…NTSB MIA83LA124Accident · No injuriesLimited investigationFinal reportBeech 76 · Pensacola, FLThe acft was landed with the gear retracted after a door opened during takeoff. The pilot stated that at about 100 feet AGL after the gear had been retracted the pilots door came open. According to the pilot the acft became erratic with thedoor banging…NTSB CHI83LA172Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Alexandria, MNThe pilot decided to make a precautionary landing after he heard a noise or bang which he thought was the muffler. The pilot made a decision to land on a runway which had an unfavorable wind. Control was lost when a gust of wind raised the left wing. The…NTSB MKC83FA090Accident · 1 fatalField investigationFinal reportBreezy 01 · Kechi, KSThe home built acft had been in storage with the wings removed. The wings had been recently re-installed by the owner and this was the first flight after the re-installation. During a takeoff from an open field, witnesses observed the aircraft lift-off, climb…NTSB MIA83FU002Accident · 1 fatalFinal reportRotec Rally 2B Ultralight · Palm Bay, FLThe Rotec rally 2B was an unregistered ultralight vehicle that had been assembled from a kit. The plts of two other ultralight vehicles stated that they were in a very loose formation with the one that had crashed. According to them, they were flying at about…NTSB MIA83LA122Accident · No injuriesLimited investigationFinal reportCessna 402B · Ft. Pierce, FLThe acft was landed wheels up. The pilot stated that he never heard the landing gear warning horn operate. Post accidentinvestigation showed that the landing gear operated properly but that the warning horn was inoperative. The pilot of theaccident acft held…NTSB ATL83LA159Accident · No injuriesLimited investigationFinal reportCessna 210F · Brunswick, GAThe acft was intentionally landed wheels up after the landing gear extension systems failed to operate. The rt aileron control cable had chaffed a hole in the main landing gear hydraulic line causing a hydraulic leak that depleted the gearextension system of…NTSB NYC83FA086Accident · No injuriesField investigationFinal reportCessna 210L · Avon, CTThe acft collided with a tree and broke the nose landing gear during an emergency landing after electrical failure. After the failure, using matches and a flashlight, the plt tried to land but could not find the arpt. The weather was deteriorating so when a…