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 MKC88FA007Accident · 2 fatalField investigationFinal reportChampion Aeronca 7GC · Columbia, MOWitnesses reported the pilot had planned to practice 'taildragger' takeoffs and landings. They reported the aircraft operated routinely from engine start through the final approach segment of a VFR traffic pattern. While stabilized at about 400 ft AGL on…NTSB SEA88LA005Accident · No injuriesLimited investigationFinal reportCessna 340A · Tacoma, WAAs the plt was taxiing to the active rwy, the acft's right brake became inop due to a loss of hydraulic fluid. Subsequently, the acft went off the side of the taxiway, contd over an embankment & was damaged. The loss of hydraulic fluid was due to a leak in…NTSB ATL88IA074Incident · No injuriesIncident investigationFinal reportMooney M-20E · Columbia, SCDuring takeoff the propeller studs failed and the propeller departed the acft. FAA incident rpt stated that propeller had been overhauled and replaced 32 hours prior to the separation. Metallurgical exam of the propeller studs revealed fatigue failure of the…NTSB LAX88LA002Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Carefree, AZDuring the first takeoff attempt, a small portion of the balloon envelope caught fire and was quickly extinguished. The second takeoff attempt was successful. One passenger on the balloon said that the flight was very erratic ranging in altitude from 10 feet…NTSB FTW87FA225Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · Houston, TXPlt executed an emergency landing into trees after he experienced an inflight fire and eng failure shortly after t/o. the lndg in the trees was executed after the plt decided that he could not make it to a clear area. Investigation revealed that the fire had…NTSB NYC87LA254Accident · Minor injuriesLimited investigationFinal reportBeech E55 · Block Island, RIJust before lift-off, after the aircraft had accellerated to about 115 mph, the door on the passenger's side came open. The pilot immediately aborted the takeoff, but was unable to stop on the remaining portion of the 2500' runway. After departing the runway,…NTSB MIA87IA256Incident · No injuriesIncident investigationFinal reportGates Learjet 36A · Tyndall Afb, FLThe captain aborted the takeoff at 124 KTS after hearing an explosive sound, feeling the aircraft swerve, and seeing debris from a main wheel rim and brake being thrown forward of the aircraft. The aircraft continued down the runway, barely controllable and…NTSB DEN87DTM01Accident · Serious injuriesFinal reportEvans VP-2 · Cedar Valley, UTThe acft was flown by two different plts who complained of stiff ailerons. The aileron system was examined but no deficiencies were noted. A third plt then took off and began a lt turn at about 75 to 100 ft AGL. When he attempted to return to wings level he…NTSB MIA87IA246Incident · No injuriesIncident investigationFinal reportPiper PA-60 · W.Palm Beach, FLThe plt stated that on landing after rolling about 1000 ft. the scissors on the right main landing gear strut disconnected causing the wheel assembly to rotate & skid. He then applied heavy left brake to keep the acft straight on the runway, but the main gear…NTSB NYC87LA253Accident · No injuriesLimited investigationFinal reportCessna 172D · Scottdale, PADuring a local pleasure flight, the pilot noticed the airspeed indicator was inoperative. On lndg the acft was obsvd to touchdown abt half-way down the rwy and faster than normal. The aircraft continued off the runway and crossed the airport road coming to…NTSB NYC87FA250Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Gaylordsville, CTThe pilot of the Piper PA-28-236 was cruising at 6000 ft at night when he reported a failure of his vacuum pump followed by loss of his attitude indicator and directional gyro. The aircraft was observed to make a 360 degree turn on the radar scope. The air…NTSB ANC87LA139Accident · No injuriesLimited investigationFinal reportCessna 185F · Wasilla, AKThe pilot stated that after rollout on the grass runway, he lost directional control causing the plane to ground loop. Exmination of the tailwheel revealed that the tire was flat prior to the landing.NTSB FTW87FA210Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Graford, TXThe pilot departed possum kingdom airport and entered a crosswind turn. The pilot heard a loud 'pop' and could not move the aileron control to recover from the turn. The aircraft entered an uncontrolled descent and crashed into a lake. The aileron pulley for…NTSB FTW87FA208Accident · Minor injuriesField investigationFinal reportCessna 208 · Bulverde, TXAfter leveling at 5500', the standby power annunciator light illuminated, followed by loss of oil pressure. The plt turned back toward the arpt, but there was a progressive loss of eng power & the prop went to a feathered psn. Drg an emerg landing at night,…NTSB ATL87DEI12Accident · No injuriesFinal reportTomishin W-8 · Painesville, OHThe plt/owner of the homebuilt aircraft was making a local flight to determine the flt characteristics with a larger wing installed on the acft. The plt reported that while in flight an oil leak developed from the area of the propeller. The oil coated the…NTSB LAX87LA323Accident · No injuriesLimited investigationFinal reportCessna 140 · Gorman, CAA Cessna 140 nosed over during the landing roll after a precautionary landing to a paved access road. The plt indicated that the oil pressure and oil temp began to drop for unknown reasons while in cruise flt. The plt stated he was unable to determine the…NTSB CHI87IA201Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-71 · Chicago, ILSmoke detected in the cabin resulted in an evacuation of the aircraft just after being pushed back from the jet-way. Subsequent investigation established that a malfunctioning pack valve had caused the air-conditioning system to overheat causing the smoke.…NTSB MIA87LA238Accident · No injuriesLimited investigationFinal reportAero Commander 680FL · St ThomasAfter a loss of hyd pressure, the rgt main gear would not fully extd when the plt tried to lower the gear for lndg. All atmts to lock it into place were unsuccessful. When the acft touched down drg the lndg, the rgt main gear collapsed. The acft slid to a…NTSB CHI87LA200Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Appleton, WIThe plt rprtd that after the acft was at cruise flt, there was a rapid loss of hydraulic pressure. He returned to the dep arpt, but was unable to get the left main gear to lock down. Subsequently, the left main gear collapsed when the acft was landed. An…NTSB LAX87DUJ11Accident · Minor injuriesFinal reportHiller UH-12E · Scottsdale, AZDuring an aerial application flight, the plt made a turn-around & was starting to make another swath run when he heard a loud 'bang' & then the helicopter collided with terrain. An inspn of the main rotor head & pin revealed the hub had failed from hi cycle…NTSB LAX87LA328Accident · No injuriesLimited investigationFinal reportCessna 310D · Lancaster, CAThe pilot-in-command (PIC) rprtd that he heard a loud bang during gear retraction after takeoff. By using the convex mirrors mounted on the tip tanks, he determined that the nose gear was hanging. He cycled the landing gear switch several times, but the nose…NTSB ATL87LA247Accident · No injuriesLimited investigationFinal reportMooney M20F · Put In Bay, OHThe plt heard a loud 'snap' while taxiing to the rwy, and the ldg gear collapsed immediately thereafter. The plt observed that the gear handle was still in the down-and-locked position and that the green 'gear down' light remained illuminated. FAA exam of the…NTSB MKC87DPG03Accident · Serious injuriesFinal reportAir Tractor AT-301 · Tillar, ARThe pilot stated that the prop RPM became erratic. On approach, the prop ran completely out of control, causing the aircraft to nose down into a plowed field just short of the landing area. The a/c hit on the main landing gear, broke them off, then it nosed…NTSB MIA87IA229Incident · No injuriesIncident investigationFinal reportCessna 402B · W.Palm Beach, FLThe lt main gear would not extend when the plt attempted to lower the gear & and the acft was landed in that condition. An exam of the strut assy revealed that a bearing, p/n 5041108-1/2 had failed permitting the strut to overextend, jamming the gear in the…NTSB LAX87DUM05Accident · 1 fatalFinal reportSawyer DF-9 · Ramona, CADuring the third test flt, the plt was to fly the acft to 6000 ft for slow flt and flutter testing at increasing speeds to 200 mph. The plt was then to complete a shallow descent to touch-down with an on final, over-the-fence speed not to exceed 75 mph.…NTSB CHI87NA194Incident · Minor injuriesFinal reportBoeing 767-231ER · Belleville, ILNTSB DEN87DTK01Accident · 1 fatalFinal reportBushby Mustang II · Aberdeen, SDWitnesses reported that they observed the acft perform two snap rolls. During the second snap roll something came off the aircraft and fell to the ground. The acft then became inverted and descended until impact with the ground. The acft impacted in a near…NTSB FTW87FA203Accident · Serious injuriesField investigationFinal reportAerospatiale AS-355F-1 · Ship Shoal 214cAcft experienced a tail rotor drive shaft failure during t/o from an offshore platform. Acft spun left and completed 6 to 7 revolutions prior to water contact as the single plt could not reach the throttles to reduce pwr to idle. Acft landed hard and the rt…NTSB SEA87LA168Accident · No injuriesLimited investigationFinal reportBeech G35 · Kent, WAShortly after rotation a propeller blade separated from the aircraft with the remaining propeller hub assembly and the other blade also falling from the aircraft. The pilot was able to land the aircraft straight ahead on the remaining runway. The hub was…NTSB NYC87FA272Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · Martha Vineyard, MAThe plt was involved in commerical fishing operations as a spotter and to direct the closing of nets around schools of tuna. While directing the closing of a net, the fish being netted reversed course and started to escape from the open net. The plt dove at a…NTSB LAX87DJA08Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIDuring an aerial application operation, while taking off, the aircraft veered off the runway and came to rest nose down. Inspection of the landing gear revealed that the left main landing gear scissor bolt broke.NTSB FTW87LA195Accident · No injuriesLimited investigationFinal reportBell 206L-1 · New Iberia, LACrew performing practice touchdown autorotations during a trng flt. On 4th autorotation, acft touched down with excess grnd speed and skidded for approx 75' on the wet, soft grass. When crew applied power back to flight RPM they heard a grinding sound and…NTSB FTW87FA198Accident · No injuriesField investigationFinal reportBell 206B · Pledger, TXWhile cruising at 900' AGL, the plt noted a hvy shudder flwd by a grinding noise, loud 'bang' & a low rotor RPM signal. He made an autorotation to a road, but drg touchdown, the main rotor blades flexed dwn & severed the tail boom. An exam revealed the main…NTSB NYC87LA231Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYAfter landing on an instructional flight, Cessna 172, N9425D, experienced brake failure due to a broken hydraulic fluid line. N9425D rolled into another Cessna. Both aircraft received sustantial damage.NTSB LAX87LA302Accident · No injuriesLimited investigationFinal reportBeech C-45H · Auburn, CAThe aircraft collided with a ditch after a loss of control during landing rollout. The pilot indicated that during the landing roll the aircraft veered left. Attempted braking action was ineffective. The aircraft had a history of brake problems. The acft had…NTSB DEN87LA215Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Salt Lake City, UTThe pilot stated the touchdown seemed normal but the aircraft began to porpoise, the propellers struck the runway and the aircraft came to a stop. A post accident inspection revealed the nose gear steering roller had become dislodged and prevented proper…NTSB NYC87LA224Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · York, PAThe Ercoupe model 415 experienced a loss of power in flight. The pilot made a forced landing in a field. He went under some power lines, however, he could not avoid the telephone lines and went through them. The pilot received serious injuries and the…NTSB CHI87FA191Accident · No injuriesField investigationFinal reportBeech B90 · Milwaukee, WIOn departure the crew identified an in flight fire. An immediate shutdown of electrical, environmental and pressurization systems was initiated and a return was made to the airport with a successful landing. The fire was discovered to have occurred in the…NTSB MKC87LA158Accident · No injuriesLimited investigationFinal reportBeech 58 · Arkansas City, KSDuring ldg roll, following a personal flight, the acft had a failure of the left main gear tire. The PIC said the acft began violently shaking and wobbling followed by collapse of the left main lndg gear. The acft swerved off the runway and incurred…NTSB MIA87LA224Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Orlando, FLDuring the apch to land the tail rotor drive assy failed resulting in a momentary loss of control. The plt then autorotated & landed on the company helipad, during which the helicopter sustained substantial damage. Examination of the tail rotor drive assy…NTSB SEA87LA157Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · North Plains, ORThe plt rprtd that drg a x-wind lndg, the acft touched down on the rgt main gear, then after rolling aprx 50 to 100 ft, the left main gear touched down. As the left wheel touched down, the left axle failed, pitching the acft on its nose. The acft then skidded…NTSB LAX87DVD04Accident · No injuriesFinal reportHiller UH-23-D · Brentwood, CADuring an aerial application flight, the tail boom weight separated and contacted the tail rotor. The pilot lost control of the aircraft and collided with a tree and subsequently the terrain. Post acc invest revealed that the 'pip pins' which secure the tail…NTSB DEN87LA208Accident · No injuriesLimited investigationFinal reportCessna 180 · Broomfield, COPlt was conducting test flt following maint on tailwheel due to shimmy. On final landing acft control was lost at apx 20 KTS due to tailwheel jam. Acft departed side of rwy and left main gear collapsed causing substantial damage to airframe. Tailwheel jam was…NTSB DEN87IA207Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-B4-203 · Denver, COAs coplt accelerated acft through 128 KTS for takeoff, electrical malfunction occurred resulting in unreliable instrument indications. Capt rejected takeoff. Acft went off end of 12000-FT rwy. Post-incident examination disclosed no. 1 constant speed drive…NTSB CHI87DEV03Accident · No injuriesFinal reportPiper PA-22 · Roanoke, ILAfter developing an oil leak the pilot elected to make a precautionary landing. The aircraft encountered rough terrain on touchdown and collapsed the nose gear and nosed over. The pilot and one passenger reported no injuries, however the aircraft was…NTSB MIA87FA220Accident · 1 fatalField investigationFinal reportBuccaneer XA-430 · Lk Buena Vista, FLThe accident occurred while the acft was flying at an EST 800 to 1000 ft. persons on the grnd heard a bang, then looked up and saw the acft in a spin to the rt with the rt wing folded back over the fuselage. The acft hit the grnd in a near vertical attitude.…NTSB MKC87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Columbus, NEThe PIC was positioning his ag acft for a spray job when he thought he had a pblm with the eng. A precautionary lndg was decided on, but the lndg resulted in substantial dmge to the acft. A spray pump, posnd beneath the eng cowling which rotates by means of a…NTSB NYC87LA220Accident · No injuriesLimited investigationFinal reportAerospatiale AS350D · Nantucket, MAThe flight was enroute from Nantucket to hyannis when the pilot heard a loud bang followed by a severe vibration, loss of power to the main rotor system, and a loss of hydraulic pressure. The helicopter made an autorotative landing in water about 25 feet in…NTSB FTW87FA177Accident · Minor injuriesField investigationFinal reportAero Commander 520 · Carrollton, TXAcft was destroyed when it struck pwr lines and the grnd during a single eng go-around. Following a left eng shut down due to severe vibrations, the plt overflew one arpt to return to his home base. En route, he elected not to go to full pwr due to a 3 min…NTSB DEN87LA195Accident · No injuriesLimited investigationFinal reportCessna 182L · Aberdeen, SDThe plt was taking off on rwy 13 at Aberdeen, SD, muni arpt. He said when he reached 55 mph he rotated the acft and the stall warning horn sounded. He said he allowed the nosewheel to settle back on the rwy. The acft then veered right and left, then departed…