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 BFO85IA024Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011 · Patuxent River, MDWhile enroute fm ft lauderdale, FL to montreal, Canada, air Canada flt 087 requested to make an unscheduled lndg due to smoke in the rear of the acft. C-ftne was vectored to Patuxent RVR nas, Patuxent, MD and descended out of FL 370. The smoke was determined…NTSB FTW85FA131Accident · 4 fatalField investigationFinal reportPiper PA-34-220T · Stigler, OKThe plt filed a VFR flt plan after the wx improved from IFR to VFR with a chance of thunderstorms en route. Ocnl mod turbulence below 5000 ft was forcast due to strong/gusty low lvl wnds. While the acft was en route, a gnd witness heard the engs rev up more…NTSB LAX85FA150Accident · 1 fatalField investigationFinal reportJim Mckinstry Arestia Ganador · Marana, AZThe aircraft was observed to land fast from a low approach with its canopy open. The aircraft then veered right, and went over on its back at the edge of the runway where it burned. One counterweight had separated from the propeller hub assembly and was not…NTSB SEA85LA060Accident · Minor injuriesLimited investigationFinal reportBell 214B1 · Lowell, ORThe acft collided with hilly terrain during an emergency autorotation landing attempt following a reported eng overspeed. The crew reported there was an indication of eng overspeed which they could not control. Post acc examinationrevealed no evidence of…NTSB CHI85LA113Accident · No injuriesLimited investigationFinal reportRutan Varieze · Mt. Vernon, ILThe acft lndg gear collapsed after several lndgs. The plt was practicing touch & go lndgs and completed 5 circuits. During the 6th lndg the main gear collapsed at touchdown. The nose gear then collapsed this model varieze was equipped with a lndg gear that…NTSB ATL85LA091Accident · No injuriesLimited investigationFinal reportBeech 58 · Holly Springs, MSAbout 40 to 45 min after takeoff pilot noted electrical load meters at 0. Alternator warning lights were on. Reset was attempted but unsuccessful due to low battery voltage. Plt decided to make a precautionary ldg at Holly Springs, MS,but could not lower the…NTSB NYC85IA062Incident · No injuriesIncident investigationFinal reportBeech BE-99 · Putnam, CTPlt stated that during tkf the acft started to yaw & roll in a manner consistent with wake turbulence encounter. He applied full opposite rudder & aileron. Normal directional was regained between 50-75 ft above the gnd. The acft was leveled for cruise at 5000…NTSB LAX85FA136Accident · 1 fatalField investigationFinal reportHughes 369D · Hilo, HIA search was initiated when the helicopter did not arrive. It was fnd 2 days later where it crashed drg an autorotation in a rain forest. Drg the flare/touchdown, vegetation had caught on a tundra pad on the l skid & the acft rolled over. An exam revealed the…NTSB FTW85FA112Accident · 2 fatalField investigationFinal reportCessna 402B · Altus, OKDuring an eng start, prior to the flt, the l eng backfired 2 or 3 times. A witness described the 1st backfired as 'the loudest I have ever heard.' When the acft took off, two persons living near the departure end of the rwy noted that the acft (believed to be…NTSB SEA85LA053Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Taholah, WAThe acft had lifted off during an external load operation when the plt felt a 'vibration/shudder'. The right skid contacted the ground and the helicopter rolled over during an attempt to maneuver the helicopter away from ground personnel. Inspection revealed…NTSB BFO85LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Chantilly, VAWhile retracting the landing gear after takeoff, the gear hesitated briefly at about midpoint before retracting fully. Attempts to extend the gear through normal and emergency procedures failed. The acft landed at dulles international airport with the gear in…NTSB FTW85LA107Accident · No injuriesLimited investigationFinal reportCessna A185F · Belle Chase, LAThe plt had diverted back to the departure aprt due to wx. After landing, he was 'step taxiing' on the water with no reported difficulties when a landing gear shock strut, p/n 51961, separated. This allowed a float to dig into the water & caused the acft to…NTSB LAX85FA126Accident · Serious injuriesField investigationFinal reportAerospatiale SA316B · Galt, CAWhile in cruise the plt lost tail rotor control and elected to execute an emergency landing in an open field. The tail rotor gearbox was found 45 ft from the main wreckage. The tail rotor guard was found 60 ft from the main wreckage. It did not exhibit any…NTSB ATL85MA083Accident · No injuriesMajor investigationFinal reportLockheed 188C · Dobbins Afb, GADuring gear retraction after takeoff, the right main gear became jammed in a partially retracted psn & the respective in-transit gear light would not extinguish. Attempts to recycle the gear were unsuccessful. The flt crew diverted to atlanta, GA; then…NTSB CHI85LA098Accident · No injuriesLimited investigationFinal reportCessna 140A · Three Rivers, MIThe ski equipped aircraft was taxiing on the frozen surface of the lake when the two bottom bolts that attached the right ski to the gear leg failed the overload failed the two top bolts and the ski failed out and up at a forty five degree angle this…NTSB FTW85LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Coushatta, LAThe acft was on its 1st flt following maintenance for a previous nose gear shimmy problem. When the student made his 1st attempt to land, he noticed that the nose gear seemed to be cocked, so he aborted the landing. On the 2nd attempt, the acft swerved to the…NTSB ATL85LA082Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Vicksburg, MSDuring the landing attempt, the pilot failed to ensure that the landing gear was extended. He was preoccupied with trying to locate a runway sweeper reported by the airport manager. When the gear failed to extend the pilot continued the approach knowing that…NTSB MIA85LA080Accident · No injuriesLimited investigationFinal reportCessna 182E · Ft Myers, FLThe plt reported that after he had started the eng, the acft began moving out of the tie-down position. When he applied brakes, the right brake failed. He attempted to stop by using the parking brake, but the parking brake handle broke off. Subsequently, the…NTSB NYC85LA051Accident · No injuriesLimited investigationFinal reportBeech B58 · New Bedford, MAThe acft experienced a gear collapse during landing. During the first landing and takeoff the plt noticed the left main gear began to collapse. The takeoff was continued and two passes were performed in front of the ATC twr. Twr personnel advised that the…NTSB LAX85LA108Accident · No injuriesLimited investigationFinal reportCessna T210L · San Jose, CADuring first leg of the flight, plt discovered that landing gear would not extend. Pressurizing 'down side' with emergency hand pump allowed normal operation of the landing gear. On return flt to San Jose, plt tried to extend the gear but system would not…NTSB MIA85IA074Incident · No injuriesIncident investigationFinal reportCessna C-402 · Miami, FLOn 1/7/85 at about 0750 EST, N60SA, a Cessna 402 landed leftmain gear collapsed, on a commuter air taxi, positioning flight at maimi, FL. VMC prevailed at the time an IFR flight plan was filed. The aircraft received minor damage and the pilot, the sole…NTSB MKC85IA045Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · St. Louis, MOAfter departing st Louis and reaching cruise flt the crew experienced a continual trim pitch-up which had to be relieved by a reduced airspeed. No aural indication was noted by the crew. The return to the airport was uneventful. Follow-up inspection of the…NTSB MIA85IA069Incident · No injuriesIncident investigationFinal reportCessna 402B · Sanford, FLDuring cruise flt, the acft suddenly nosed down & began vibrating. Remedial action was taken & an uneventful emerg landing was made. An exam revealed that the bolt, nut & cotter pin (used to attach the elevator trim control rod to the elevator trim tab) were…NTSB CHI85LA079Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · New Philadelphi, OHPlt felt vibration and reduced power on both engines to idle. Plt heard a 'thud' and discovered the left propeller had separated cutting through the nose of the acft as it departed. The propeller was not located. Two of the six propeller bolts remained with…NTSB ATL85FA068Accident · 1 fatalField investigationFinal reportGyrocopter B-8M · Madisonville, TNStudent pilot attempting flight in Gyrocopter loss control cusing main rotor system to contact the rudder system. Pilot was not qualified to conduct this flight. A/c was not assigned an identification number.NTSB ATL85LA065Accident · No injuriesLimited investigationFinal reportMooney M20E · Monroeville, ALPlt unable to electrically or manually fully extend landing gear in traffic pattern so he decided to make a gear up landing. Unknowingly plt had lowered gear to a transit position and gear collapsed on landing. Plt had previous problems with gear and had to…NTSB LAX85LA083Accident · Minor injuriesLimited investigationFinal reportBeech 77 · San Martin, CAOn a night pleasure flt the afct's alternator went off line. The plt elected to make an immediate landing at the arpt he was overflying rather than flying to a fld which had operating rwy lights. The fld he was over had a plt-controlled lighting system, but…NTSB LAX85LA081Accident · No injuriesLimited investigationFinal reportWeedhopper Super Nova II · Lakeside, CAThe ultralight acft lost power on takeoff & stalled into the ground. According to the builder/plt the capillary type fuel pump had failed to function properly on the takeoff climb causing fuel starvation. He failed to recover from a nose high attitude in time…NTSB SEA85FA034Accident · Serious injuriesField investigationFinal reportde Havilland DHC-3 Turbo · West Seattle, WAAcft was performing test flt maneuvers when problems with the modified fuel system occurred. Ice blocking a fuel vent line caused a partial collapse of the main (engine feed) fuel cell which produced an errouneous fuel quantity reading. In addition, the main…NTSB FTW85FA078Accident · 1 fatalField investigationFinal reportBeech V35A · Midlothian, TXN7460N, operating as mid-america flt 401, crashed while on an IFR flt plan enroute to corpus christi, TX. After having been vectored around a heavy thunderstorm & cleared direct to waco, TX. The plt contacted fort worth center & stated that he had 'lost my…NTSB MIA85LA060Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Jacksonville, FLElectrical malfunctions caused the loss of air to ground communications and acft navigational equipment. The plt became lost about 70 mi east of Jacksonville, FL. With the help of another acft the plt located the arpt and radio communications were temporarily…NTSB MIA85FA059Accident · No injuriesField investigationFinal reportBritten-Norman BN-2 · San Juan, PRAfter landing the flt was directed by ground control to taxi to the cargo ramp making room for a taxiing Boeing 747. Ground control then asked the acft to make a 180 deg turn and taxi further east on the ramp. As the left turn was completed the right brake…NTSB NYC85LA042Accident · Minor injuriesLimited investigationFinal reportCessna T337G · Lawrence, MAN8CF made an emergency landing in a wooded are after experiencing a dual engine failure aprx 50 minutes after takeoff./ the fuel pressure gage for the front engine displayed erratic elevated readings. The pilot then decided to return to the departure airport…NTSB NYC85IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Jamaica, NYDuring taxi for departure, acft experienced several jolts to the right. Capt stopped acft and requested grnd personnel to inspect landing gear. Inspection revealed rt main gear truck beam failed. Metallurgical inspection of truck beam ass'y concluded the…NTSB CHI85FA070Accident · 2 fatalField investigationFinal reportPiper PA-31 · Pontiac, MIThe aircraft departed the airport with one dry air pump inoperative and the other pump reading low. Aircraft control was lost during an instrument approach in IMC approximately 2.5 hours later. Both pump driveshafts were found sheared in the wreckage and both…NTSB MKC85LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Norfolk, NEThe plt confirmed an alternator failure a short time after departing fairmont, cancelled his IFR clearance and continued to Norfolk for landing. Upon reaching his destination the plt was unable to extend the landing gear due to the electrical failure and no…NTSB LAX85FA066Accident · 1 fatalField investigationFinal reportBarry Zielinski SNS 8 Hiperlt · Corona, CAN5303U, owned & operated by the amateur acft builder sustained an inflt structual failure of the lt bottom wing & crashed 6 mi east of Corona, CA. The ultralight type acft was destroyed and the plt fatally injured. Investigation revealed that wing spar…NTSB DCA85AA004Accident · 13 fatalFinal reportEmbraer EMB-110P1 · Jacksonville, FLProvincetown-boston airlines flt 1039, an Embraer EMB-110P1, was cleared to takeoff on rwy 31 at 1812 EST. Drg the initial climb nr the departure end of the rwy, the capt routinely acknowledged an instrn to contact dep control (ctl). Shortly thereafter, the…NTSB MIA85LA042Accident · No injuriesLimited investigationFinal reportRockwell 690A · Jacksonville, FLClimbing through 10,000 ft the plt noticed a red gear light and dropping hyd pressure. Prior to the precautionary landing, according to the plt, the gear were extended and indicated down and locked. When reverse thrust was applied the left main gear…NTSB ATL85FA043Accident · Serious injuriesField investigationFinal reportBeech M35 · Gainesville, GAThe acft crashed during an emergency landing while operating in VFR conditions on a dark night over isolated terrain. The plt stated he thought the eng exploded & lost visual contact due to oil spraying on the windshield. The rt front passenger held a…NTSB DCA85AA003Accident · Serious injuriesFinal reportBoeing 747-122 · Honolulu, HIAfter accelerating to about 153 KTS drg the takeoff roll, the #7 tire failed & the flt crew aborted the takeoff. The acft was stopped with aprx 3000 ft of rwy remaining. Due to a fuel leak from the right wing, the capt ordered an evacu- ation from the left…NTSB MIA85IA031Incident · No injuriesIncident investigationFinal reportSwearingen SA-226AT · Tallahassee, FLN31264 crashed intentionally gear up on rwy 18 at Tallahassee, FL, while on a night, all cargo 14 CFR 135 flt. The crew attempted emergency gear extension procedures & a fly-by. Investigation revealed a broken wire, TS-70, where it connects with terminal 6.…NTSB SEA85LA017Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Humptulips, WAWhen the hoisting cable on the helicopter failed, the hook end rebounded into the rotor system. The rotor system failed from the structural damage imposed and the acft went into an uncontroled descent impacting the ground on the left skid.NTSB FTW85FA050Accident · 2 fatalField investigationFinal reportHughes 269B · Clint, TXN9336F, crashed while on a training flt. The certified flt instructor & his student were killed. Investigation revealed that the main drive shaft thrust bearing had failed. A service bulletin dated 1968 mandated replacement of the bearing at 300 hr time in…NTSB ATL85LA036Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Eads, TNThe plt stated that he was taking off with full pwr. The acft accelerated to about 60 when it went over a small rise in the rwy, the left wheel assembly seperated from the acft at the pt where it attaches to the landing gear strut. The strut dug into the gnd…NTSB CHI85LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Bloomington, INPlt stated that while in cruise flt, the acft nose pitched down abruptly. Plt disengaged the autopilot and noted vacuum system was inoperative. Flt continued on manual control without further incident until late final approach at destination. When flaps were…NTSB FTW85LA039Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Mission, TXAfter a loss of oil pressure the acft was landed downwind. During the precautionary landing across plowed furrows, the rt wing caught in the sugar cane crop and the acft turned to the rt, collapsing the left landing gear and damaging the left wing. The plts…NTSB LAX85IA040Incident · No injuriesIncident investigationFinal reportWestland Helicopters WG30 · Santa Ana, CADuring a climb to cruise, the crew experienced control difficulties when the for-&-aft trim actuator began to motor forward and would not stop. An emerg descent was made with both plts exerting aft cyclic pressure to prevent the speed from increasing over 120…NTSB ATL85FLT03Accident · Serious injuriesFinal reportCessna T210N · Soddy Daisey, TNThe acft descended into trees during IFR weather after having a ttl electrical failure. The plt continued navigating by dead reckoning and not finding a break in the clouds decided to descend through the clouds. The tops of trees were struck on a ridge at the…NTSB CHI85IA042Incident · No injuriesIncident investigationFinal reportCessna T210L · Wheeling, ILDuring a preflt, just prior to takeoff, the plt checked the flt controls & full travel of the controls was achieved. He initiated the takeoff, but when he applied back pressure on the elevator control, it would only move about 1 inch. He aborted the takeoff…