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 LAX86DVA09Accident · No injuriesFinal reportHiller UH-12E · Delano, CAThe helicopter rotor blade delaminated shortly after departing the operator's north base at Delano, CA. The investigation determined the blade contained extensive voids on the bond line. The blade was rejected by the manufacturer as being unairworthy. The…NTSB CHI86FER11Accident · Serious injuriesFinal reportBell 47G-5 · Brooten, MNAccording to the pilot, the helicopter collective control failed to respond to a climb input to level off after a descent for an agricultural swath run. Fire and impact damage to the helicopter was extensive, however one broken rod end in the collective…NTSB MIA86MA182Accident · 2 fatalMajor investigationFinal reportHughes 369HE · Jacksonville, FLA LCL tv stn had hired the oper to provide a helicopter for use in broadcasting an airborne traffic show. The plt took off with a rprtr & a camera man aboard. Drg a live traffic rprt, the acft was hdg eastbound at slow speed ovr a downtownarea at aprx 400 ft…NTSB LAX86LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Glendale, AZThe pilot said that during the takeoff roll on the 2,400 foot long runway he noticed the aircraft aceleration was slow and the airspeed was still below 55 KTS at 3/5 of the way down the runway and he elected to abort the takeoff. The aircraft overran the end…NTSB DEN86FA160Accident · Serious injuriesField investigationFinal reportBeech C23 · Lamar, CODuring the takeoff climb, the plt's door came open. The pvt plt with 2 hours flying experience in C-23 acft made a close in traffic pattern to return for landing. During the turn from base leg to final the nose of the acft suddenly dropped and the acft…NTSB FTW86FA116Accident · 1 fatalField investigationFinal reportMBB 105 · Houma, LAA fatigue failure in a main rotor blade pitch change link resulted in the loss of control of one blade, leading to an in flight separation of the tail boom. The helicopter was uncontrollable and pitched forward, impacting the ground inverted.NTSB SEA86LA141Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BCM-12D-85 · Ketchikan, AKThe plt felt a sudden hard jolt while in cruise flt. The acft assumed a nose low, left wing down attitude which the plt was unable to correct by use of power and control inputs. The acft was at a low altitude due to weather. The acft impacted the water in a…NTSB LAX86LA245Accident · Minor injuriesLimited investigationFinal reportFairchild 24R-40 · Marysville, CAThe acft's left wing spar failed while the acft was in level flt. The plt was able to regain partial control of the acft and landed it in a plowed field. The acft owner reported he had previously replaced the right wing due to deterioration of the wood…NTSB DEN86LA152Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Sisseton, SDThe front seat plt, on his first flt in the acft, was flying the acft. After takeoff the acft entered a nose high attitude because the elevator trim was improperly set. The nose high attitude was corrected but the right door on the engine cowling came open…NTSB SEA86FA137Accident · 1 fatalField investigationFinal reportBell UH-1L · Wenatchee, WAN4964N, a Bell UH-1L, was being operated in logging ops by an experienced, military trained plt who possessed 6000 hrs of flt experience in model. While lifting a sling load gnd crew rptd smoke from the tail rotor area. Plt released sling load & acknowledged…NTSB ATL86LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GADuring a normal landing, the plt lost directional control of the acft which subsequently collided with a parked C-172. The plt reported that the right tire was inflated during the preflt inspection. Following the accident the tire was found deflated. The plt…NTSB MKC86LA120Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Corning, ARThe plt was making his second flt in this acft when the accident occurred. He failed to lock the cockpit canopy before start of takeoff roll. During the takeoff roll the canopy opened and separated from the acft. The plt diverted his attention from flying the…NTSB DEN86LA145Accident · No injuriesLimited investigationFinal reportMooney M20 · Fargo, NDThe plt reports that he experienced difficulty in retracting the landing gear after departure but it did retract after several attempts. He said the gear system seemed to be hanging up. Upon reaching destination the gear again seemed to hang up when extension…NTSB ATL86LA143Accident · Serious injuriesLimited investigationFinal reportAero Commander 100 · Eufaula, ALDuring a descent of 400-500 fpm at 120-125 mph the windshield blew into the aircraft. A portion of the windshield remained attached to the acft, folded up so as to jut above the cabin roof and acted as a spoiler. Level flight could not be maintained due to…NTSB FTW86IA093Incident · Minor injuriesIncident investigationFinal reportBoeing 727-224 · Corpus Christi, TXThe pilot made an intentional gear-up landing (left main only) after numerous attempts to lower it were unsuccessful. The small steel nut which had jammed the left main gear door unlatching mechanism fell into that position sometime after the gear was…NTSB FTW86FA091Accident · 2 fatalField investigationFinal reportAerotek Pitts S2A · Santa Fe, TXA short occurred in the aircraft's electrical system distracting the owner/pilot occupying the back seat of the aircraft. This seat was not equipped with a second lap restraint. The aircraft was observed, by witnesses, to enter a spin which went inverted. The…NTSB CHI86FEV02Accident · Serious injuriesFinal reportJerry Cox Goldwing · Mattoon, ILThe acft was circling a racetrack at a relatively low alt, described as between 800-1500 ft AGL, with the eng throttled back. During a subsequent steep bank to the left while accelerating the left wing failed and the acft crashed into the trees.NTSB SEA86LA129Accident · No injuriesLimited investigationFinal reportCessna 310 · Skinner Ranch, ORThe pilot elected to make a precautionary landing due to a stated electrical problem. The runway was only 30 feet wide and the aircraft struck a dirt mound to the right of the center line. The aircraft's main landing gear then collasped.NTSB CHI86FEM05Accident · No injuriesFinal reportEagle DW-1 · Baroda, MIThe plt shut down the acft engine after noticing oil on the canopy and a loss of oil pressure. A forced landing was performed in a corn field and the acft nosed over. Post accident inspection disclosed the oil pressure hose had ruptured.NTSB ATL86IA144Incident · No injuriesIncident investigationFinal reportBoeing 727-295 · Nashville, TNThe flight experienced a fire warning light descending through 10500 feet for landing at Nashville. The aircraft landed without incident. The passengers evacuated the aircraft using evacuation slides. Examination of the aircraft disclosed that the detection…NTSB FTW86FRG20Accident · No injuriesFinal reportAir Tractor AT301 · Taylor, TXCommercial pilot of an Air Tractor AT301 enroute to base of operations at Taylor, TX executed a forced landing after experiencing severe vibration in the aircraft. Landing was made to a soft field. The aircraft nosed over during landing roll and was…NTSB MKC86LA115Accident · No injuriesLimited investigationFinal reportCessna A185F · Bernie, MOThe pilot stated that they were on the takeoff roll when his seat failed and he fell backward away from the flight controls and the throttle. The airplane veered left, off the runway, crossed a small ditch, a road and then impacted in a very large drainage…NTSB CHI86LA143Accident · No injuriesLimited investigationFinal reportBeech BE-F90 · Eaton, INThe acft had made a stop at muncie to pick up a fourth passenger. After boarding, the passenger closed the cabin door. After departure and climbing thru 6,000 ft the airstair separated from the aircraft and struck the vertical stabilizer.NTSB CHI86FA141Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Angola, INThe pilot diverted into Angola, an airfield he had never landed at before, due to an unidentified electrical problem at night. He was given vectors to the airport and reported the field in sight. He then said he was going to circle to lose altitude prior to…NTSB MIA86LA162Accident · No injuriesLimited investigationFinal reportCessna 182E · Crystal River, FLThe plt stated that just before descent he pushed the propeller control full forward, experienced a runaway prop and lost oil pressure. Moments later a connecting rod failure was experienced and an emergency landing was executed in amarshy area northwest of…NTSB MIA86LA159Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Tallahassee, FLWhile in the traffic pattern the acft's electrical system failed due to internal failure of the alternator. The plt failed to extend the landing gear by the emergency gear extension handle and a gear up landing resulted.NTSB FTW86FA085Accident · 2 fatalField investigationFinal reportBell 206B · Pine Spring, TXThe helicopter was on a flt to a site nr guadalupe pass, an area known for erratic & gusty wnds. As the plt was on an apch to a hi meadow (elev aprx 5460'), the helicopter entered a dscnt & crashed well short of the intended lndg area. A witness rprtd the…NTSB MIA86LA151Accident · No injuriesLimited investigationFinal reportCessna T188C · Shaw, MSThe plt stated that shortly after takeoff he noticed the fuel cap was loose. He then turned downwind to land, at which time the aircraft stalled, resulting in the right wing colliding with trees.NTSB MIA86LA149Accident · Minor injuriesLimited investigationFinal reportLearjet 24 · Hollywood, FLThe plt stated he made a normal apch and landing but on rollout discovered he had no brakes. The acft traveled off the left side of the rwy and collided with a fence surrounding a ballpark. Post crash examination of the hydraulic system revealed that the…NTSB LAX86DVA07Accident · 1 fatalFinal reportWright BD5B · Merced, CAGround witnesses and the pilot reported the canopy opened shortly after departing runway 30 at Merced airport, Merced, CA. The pilot executed a steep left banking turn. When the airplane turned abt 140 deg it pitched up, rolled inverted and nosed down into…NTSB DEN86LA127Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · Longmont, COThis experimental glider has a stowable 2 cycle eng mounted behind the cockpit. When the eng is stowed the glide ratio is about 40:1. When the eng is deployed but not running, the glide ratio is about 10:1. While returning after a 4 hr and 50 min flt the plt…NTSB DEN86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Riverton, WYThe plt reports that the eng cowling came loose and he decided to land on a highway to secure the cowling. The approach was made to the west on the east/west road. The plt said the wind was from the south at 25 mph with gusts to 35 and the landing attempt…NTSB CHI86FA137Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Warren, MIThe acft developed a small oil leak during a x-country flt. The plt reduced power to idle to conserve oil even though the oil pressure was still in the normal range. During the descent the acfts airspeed was not maintained and the acft contacted the ground in…NTSB MIA86LA139Accident · Serious injuriesLimited investigationFinal reportWing D-1 · Bunnell, FLThe plt stated that his canopy had come open and he was trying to hold it closed and make an emergency landing on runway 29 at flagler co. airport, but being too low and fast the acft struck the ground about 100 ft short of the runway and slid to a stop.NTSB LAX86FVM05Accident · Minor injuriesFinal reportHiller UH12E · Castroville, CAThe acft landed hard and rolled over after the lndg skid failed in a forced lndg. The plt said he was crusing at 500 ft AGL over an open field when he heard a loud bang. The helicopter began to vibrate severely and spiral to the right. The plt lost ground…NTSB CHI86LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Griffith, INAfter takeoff and while climbing through 60 ft AGL the plt could not move the aileron to recover from a 15 deg left bank. The plt reduced power and landed the acft in a left wing low attitude. The acft slid and struck a creek bank with the right wing. Post…NTSB CHI86LA127Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Ft. Wayne, INApprox 10-15 minutes after takeoff the student pilot lost control of the helicopter and crash landed into trees. Following the accident, the only unusual thing FAA personnel could locate was a failed horizontal stabilizer spar. Post-crash examination of the…NTSB LAX86LA126Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · El Monte, CAThe eng cowling opened as the acft took off. The plt slowed the acft to lower the open cowl. The acft descended into unmarked elec wires and received substantial damage. The pilot returned to arpt and landed without further incident.NTSB CHI86IA121Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Detroit, MIWhile taxiing for takeoff a male pax panicked and shouted 'open the door!' During a smoke-in-the-cabin occurrence (overheated a/c pack). The lead fa mistook this 'instruction' as coming from the cockpit and opened an exit door. Passengers interpreted her…NTSB LAX86DVA06Accident · Minor injuriesFinal reportBell UH-1B · Chowchilla, CAWhile returning from a spraying operation the plt observed that the main transmission oil pressure gage indicated zero. The plt reported that the engine master caution did not illuminate and that the oil temperature gage was normal. The plt stated that he…NTSB MIA86LA120Accident · No injuriesLimited investigationFinal reportCessna T303 · Bunnell, FLWhile on a dual instructional flight both instructor and the student pilot noted a left brake failure on taxi to takeoff. The instructor attempted to utilize asymmetric power to steer the aircraft but could not control the turn. The aircraft ran off the edge…NTSB BFO86FA023Accident · Minor injuriesField investigationFinal reportPiper PA-28R-200 · Camp Springs, MDDuring a flt to prepare the student for a CFI check ride, both the student and the CFI could not obtain a green light confirming the nose gear was down and locked. After numerous attempts to assure it was down and locked the acft was landed at andrews afb.…NTSB CHI86LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172-RG II · St Paul, MNDuring climbout after t.o. and passing thru 4000 ft smoke began to enter the cabin. Plt declared an emergency and turned toward arpt. Eng then began to shake violently. Acft was cleared to ld but plt continued to a point four mi past base leg, attempted to…NTSB FTW86FA060Accident · No injuriesField investigationFinal reportDouglas DC-3C · El Paso, TXThe pilot reported that he was leveling off from climb when he experienced a prop runaway. He observed oil streaming from the left engine, but could not feather. Unable to maintain altitude with a windmilling prop, he performed a gear up emergency landing in…NTSB FTW86MA058Accident · 7 fatalMajor investigationFinal reportIsrael Aircraft Industries 1124A · Redwater, TXAirplane crashed during a uncontrolled descent, following a turbulence upset at FL370. The upset occurred as a result of clr air turb associated with a vip lvl 6 thunderstorm located within 7 miles of the last pos of the airplane. After the upset, the…NTSB SEA86LA089Accident · No injuriesLimited investigationFinal reportHiller 12E · Walla Walla, WAA catastrophic failure of the planetary gear of the transmission occurred about 51 flight hours after overhaul. During forced landing a hard landing occurred severing the tail boom. A fire then erupted.NTSB DEN86LA105Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Aztec, NMPlt and one pax departed eston, saskatchewan at 0600, en route to guaymas, Mexico for a vacation. Acft was refueled in billings, mt at 0900 and at grand junction, CO. Plt checked wx, filed VFR flight plan and departed grand junction at 1430, en route to…NTSB NYC86IA093Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · Boston, MATwo of 3 reqd flt attendants (f/a's) were distributing passenger (pax) coats as the acft was being taxied after lndg. Smoke fm an overheated air cond (a/c) pack bgn entering the cabin & the f/a's returned to their duty stations. The flt crew stopped the acft…NTSB FTW86LA047Accident · No injuriesLimited investigationFinal reportBell 206BIII · Gulf Of MexicoThe pilot failed to assure the cabin door was properly closed before flight, or the cabin door just popped open during flight, allowing an unsecured life vest to blow out the door and into the tail rotor blades. This resulted in the entire tail rotor assembly…NTSB MIA86LA104Accident · No injuriesLimited investigationFinal reportCessna 210E · Jacksonville, FLAfter departure plt selected landing gear up and did not receive a gear up indication. Another aircraft flew under the aircraft and reported the nose gear and left main gear were up and that the right main gear was partially extended. When attempts to correct…