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 MKC82FCG20Accident · Serious injuriesFinal reportVilline'S Breezy RLV-1 · Independence, MOPilot made a precautionary landing when aircraft developed a vibration. What pilot thought was a bean field was 5 feet high milo, and aircraft flipped inverted. Vibration was caused by piece of separated exhaust system hitting and breaking off part of the…NTSB LAX83FVM03Accident · Serious injuriesFinal reportFalkenthal Varieze · Palo Alto, CADuring final approach the acft suddenly pitched down about 45 deg & crashed into a duck pond containing approximately 4-5 ft of water. During examination of the wreckage it was noted a bolt was missing that secures the elevator control stick, at the…NTSB CHI82IA331Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Appleton, WIThe right main gear "in transit" light remained on after gear retraction on a training flight. Various methods of remedial action did not cure the problem. A landing on runway 21 was executed with the nose and left main gear in the down position. The right…NTSB DEN82DA177Accident · No injuriesFinal reportSchweizer 84 · Aspen, COAt low altitude after takeoff, the aircraft hit turbulence and the tow rope broke. The pilot reversed course and attempted to return to the airport. Having insufficient altitude, he landed on a railroad track and collided with bushes. The left wing canopy and…NTSB CHI82DA327Accident · No injuriesFinal reportHughes 269B · Medina, OHThe pilot stated that shortly after takeoff, at about 800 feet AGL he felt a violent vibration lasting for 2 or 3 seconds. He reentered the downwind leg to the airport and experienced the vibration again. The aircraft then entered an uncontrollable spiral to…NTSB FTW82FRJ17Accident · Serious injuriesFinal reportBell 206B · Jamestown, LAThe pilot was conducting aerial burning operations over a wooded area when he heard a loud bang from the engine area of the helicopter. At that time, the helicopter was approximately 20 ft above the tallest tree in the area with the aerial torch burning. The…NTSB FTW82FRG37Accident · 2 fatalFinal reportChampion 7GCAA · Killeen, TXThe majority of the wreckage was contained within a small area except for the left wing tip which was found about 125 yds from the wreckage & some pieces of fabric from the left wing that were found about 525 yds from the wreckage. Both wings had separated…NTSB ATL82IA245Incident · No injuriesIncident investigationFinal reportBeech C23 · Duluth, GADuring preflight, the pilot found the right aileron front push-pull rod end broken. This defect would have precluded aileron control. Metallurgical examination of the fracture revealed that the part had failed due to reverse bending fatigue as a result of…NTSB MIA82DA178Accident · No injuriesFinal reportDouglas C-47 · Charlotte AmaliThe pilot reported normal braking pressure failed while taxiing on the ramp. He attempted to steer clear of other aircraft, but collided with two parked DC-3 aircraft. No determination of the nature of the braking problem was made.NTSB NYC82DA207Accident · No injuriesFinal reportPiper PA-11 · Utica, NYThe throttle would not close during landing. The pilot tried brakes and then elevator as the aircraft nosed over. There was no indication of trying to stop the engine by other means (switch, mixture, etc).NTSB MKC82DA151Accident · No injuriesFinal reportBell 47G-2A · Washington, IAThe helicopter was being air taxied to the refueling location when it crashed. The pilot said he had lifted off and was about 6 ft AGL with about 20 KTS forward speed when he suddenly felt a snap and the cyclic went full left. The helicopter became…NTSB DEN82DA171Accident · No injuriesFinal reportCessna 190 · Bismarck, NDLeft brake failed. Examination revealed the hydraulic brake line to the left brake had pulled loose from a union fitting. The line also sheared by the shifting of the gear box assembly. There were signs of inadequate flare to the tubing in that it pulled out…NTSB FTW82DA342Accident · No injuriesFinal reportBell 206B · Port Mansfield, TXThe helicopter was being ferried to shore from an oil rig when the tailrotor gear box failed and separated from the aircraft. The pilot autorotated to the water. Upon water contact the helicopter rolled over. The pilot had called his skipper on the radio as…NTSB MKC82FA149Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Kansas City, MODuring the approach to topeka the crew was unable to extend the left gear. The crew diverted to Kansas City, and after many unsuccessful attempts to lower the left gear elected to land wheels-up. The left main gear was jammed into the geardoors. The aft hinge…NTSB CHI82DA321Accident · No injuriesFinal reportCassutt Cassutt · West Chicago, ILThe purpose of the flight was to check the aircraft after repitching the propeller blade angle. Reportedly, the tail wheel swivel cotter pin failed and the pilot lost directional control during the landing. The aircraft then veered off the right side of the…NTSB SEA82DA146Accident · No injuriesFinal reportAuster A.O.P.6 · Toledo, WAAircraft lost wooden propeller during cruise. Aircraft was forced to land on a highway. During approach aircraft wing hit a light pole and yawed. During touchdown it bounced hard on left main landing gear which collapsed.NTSB ATL82DA241Accident · No injuriesFinal reportCessna A188A · Florala, ALThe pilot reported that as he was climbing through about 30 to 40 ft AGL, the aircraft suddenly went to the right as the flaps were being retracted. In an effort to counteract the lateral movement, the pilot applied left aileron and rudder which started the…NTSB NYC82DA198Accident · No injuriesFinal reportCessna R182 · Endicott, NYAfter making an approach and go-around, the pilot turned to a downwind and moved the gear selector to the down position. However, the gear would not extend by using either the normal system or emergency hand pump. Subsequently, the aircraft was landed on a…NTSB LAX82DA299Accident · No injuriesFinal reportLake LA-4 · Lake Tahoe, CAThis was to have been the fourth sight-seeing flight of the day. As the amphibian was taxied for takeoff, the pilot noticed water flowing into the aircraft. The bilge pump was unable to quell the flow. The pilot and passengers, four children, abandoned the…NTSB CHI82FA304Accident · Serious injuriesField investigationFinal reportHiller UH12L4 · Wisconsin Dells, WIDuring climb, at about 200 ft AGL, the m/r lost RPM. During autorotation the eng RPM increased beyond the red line when the plt added power. The helicopter made a hard landing in a residential area. Inspection of the mercury clutch revealed that the exterior…NTSB DEN82DA160Accident · No injuriesFinal reportCessna 421C · Bountiful, UTThe pilot reported that the approach and landing to touchdown were normal. At touchdown, the aircraft shuttered and pulled to the right, but was kept on the runway through the use of left brake and nosewheel steering. After continuing down the runway for…NTSB FTW82DA323Accident · Serious injuriesFinal reportBell 206B · Grand Isle, LAThe pilot was approaching an offshore platform for landing at about 100 ft AGL when he felt the helicopter shudder. He also heard an engine-out horn and a low-rotor-rpm warning. He turned away from the platform, popped the emergency floats and initiated an…NTSB DEN82IA154Incident · No injuriesIncident investigationFinal reportBoeing 737-291 · Denver, COThe captain said he felt a "thump" and the aircraft slumped to the left as it was rotated for takeoff. At this point, the aircrew were committed to continue the takeoff which accomplished successfully. A low pass was made for tower personnel to check the…NTSB DEN82DA152Accident · No injuriesFinal reportCessna 172N · Lander, WYThe pilot reported that the aircraft suddenly veered to the right after he had slowed to about 30 to 35 KTS. An examination revealed that the nose gear fork had failed in two places. The breaks were just below the strut attachment point and directly accross…NTSB NYC82DA183Accident · No injuriesFinal reportSchweizer SGS-2-33A · Eighty Four, PAThe tow line released at 40 feet AGL in a glider tow launch. The glider pilot tried to land on the runway but landed adjacent to it and collided with a tree which ground-looped the glider. The tow hitch mechanism was broken off at the tubing cluster & was…NTSB LAX82DA283Accident · No injuriesFinal reportEnstrom F28C · Phoenix, AZThe helicopter made a forced landing in a cotton field after tail rotor driveshaft failure. Examination showed a ductileshear overload failure. No evidence of fatigue was reported.NTSB DEN82FA148Accident · 1 fatalField investigationFinal reportEnstrom F-280 · Medora, NDDuring flt the plt noticed that eng RPM was about 500 over rotor RPM. The acft crashed during an unsuccessful autorotation. The overrunning clutch linkage & clutch was found in the disengaed position. A successful autorotation requires that the collective…NTSB LAX82DA280Accident · Minor injuriesFinal reportCessna 180J · Ramona, CAThe plt was practicing landings on a 15 ft wide remote dirt strip. The right brake failed & the acft veered off the rwy.NTSB FTW82DA297Accident · No injuriesFinal reportPiper PA-25-235 · Santa Rosa, NMWhile landing, the aircraft swerved off the runway and received substantial damage. An investigation revealed that the right main wheel had come off the axle. A closer examination revealed that the retaining nut and the cotter pin, which holds the nut in…NTSB DEN82DA142Accident · No injuriesFinal reportBeechcraft C-45H · Aurora, COThe pilot reported that he was unable to extend the landing gear by using either the normal or emergency systems. After repeated attempts to extend the gear, he elected to land with it configured in a free-fall position. He shut down and feathered both…NTSB LAX82AA274Accident · 3 fatalFinal reportBell UH-1B · Valencia, CAAcft being used to film movie scene depicting attack of village typical of villges in viet nam. Acft was about 25 ft AGL & above location where special effects explosives were detonated. As the plt turned acft for camera coverage, acft'stail section was…NTSB NYC82DA161Accident · Minor injuriesFinal reportThorp T-18 · Connellsville, PAWhile the student was taking off, the engine began to vibrate violently at an altitude of about 300 to 400 ft AGL. The flight instructor (CFI) took control and initiated a turn back to the airport. He stated that due to the vibration, he had to reduce the…NTSB CHI82DA265Accident · No injuriesFinal reportEagle DW-1 · Murdock, MNThe pilot was en route to a bean field when the ground adjustable propeller came out of adjustment. The pilot dumped the load and made a forced landing in a beanfield. During the landing, the aircraft nosed over and was substantially damaged. An investigation…NTSB LAX82FA261Accident · No injuriesField investigationFinal reportCessna 150M · Lake Isabella, CAAfter takeoff, the acft was flown aprx 5 mi south of the arpt & was at about 1000 ft above a lake when the eng began vibrating violently & losing power. The plt turned toward the shore & tried various mixture settings in an attempt to correct the problem.…NTSB ATL82DA203Accident · No injuriesFinal reportAmerican AA-1 · Covington, TNPrior to landing, the pilot checked his brakes to insure their integrity and noted that the left brake did not hold pressure. He elected to land on runway 01 since the hangar and ramp areas were located at the north end of the field and he didn't want to taxi…NTSB ATL82FA196Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Roswell, GAAbout 12 minutes after takeoff the plt reported "...alternator or generator trouble" & requested to return to the arpt. He later reported that he was having radio problems. The plt was vectored to intercept the ILS rwy 20L apch course. The accident occurred…NTSB ANC82FA059Accident · No injuriesField investigationFinal reportAerospatiale SA-318C · Skwentna, AKThe pilot reported that after takeoff, at an altitude of 200 feet, the aircraft began a moderate vibration. When the aircraft was leveled off and the power reduced, the vibration stopped. The pilot continued the flight and during a climb turn at approximately…NTSB ANC82FA056Accident · Minor injuriesField investigationFinal reportBell 212 · 38 Se Barrow, AKWhile executing a precautionary landing after hearing a screeching sound the plt lost directional control & the helicopter landed while spinning. Examination revealed that the primary tail rotor driveshaft quill coupling had failed. The 204-040-604-5 female…NTSB SEA82DA113Accident · No injuriesFinal reportCessna 340 · Sunriver, ORThe pilot reported that he landed 10 KTS fast to compensate for a 15 kt crosswind. He reported that during the landing roll, the right brake felt like it was not working. Rather than going off the end of the runway, he applied heavy left brake and steered the…NTSB NYC82FNA19Accident · No injuriesFinal reportBreezy RL4-1 · Andover, MADuring flt the plt felt something snap or break on the acft. The control wheel movement for the aileron became exceedingly harder to move & the acft started to flutter in an up & down motion. He reduced power to slow the flutteringaction, but was not able to…NTSB ANC82DAG34Accident · Minor injuriesFinal reportJunior Ace D · Ninilchik, AKThe pilot reported that while he was maneuvering to land, the right rudder pedal became locked in the"full up position." This caused the aircraft to move through the air in uncoordinated flight. The pilot applied full power and banked the aircraft to the…NTSB FTW82DA291Accident · No injuriesFinal reportCessna A188B · Boise City, OKThe pilot stated that during the landing roll after a normal touchdown, the right tire blew out. Subsequently, the aircraft veered into a ditch and was substantially damaged. This was a 2200 x 8 goodyear tire.NTSB ATL82DA191Accident · No injuriesFinal reportBeech V35 · Huntington, WVBefore departing st louis, MO, attempts to restart the engine were unsuccessful until an auxiliary power unit was used. The aircraft took off at 1746, and about one hour later, the pilot noticed that the ammeter indicated a discharge. The flight was…NTSB SEA82IA101Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Boise, IDAfter a gate delay to load late passengers, the flight was cleared for takeoff on runway 28L. About 4 seconds after rotation speed was called, the stickshaker activated and the takeoff was aborted. A readout of the CVR indicated that the thrust reversers were…NTSB NYC82IA137Incident · No injuriesIncident investigationFinal reportBoeing 727-233 · Flushing, NYDuring initial climb, the amber leading edge flat light remained lit after flap retraction from 5 degrees to 2 degrees. Moderate aileron and rudder inputs were required to maintain wings level flight. After cycling the flaps from 5 back to 2 degrees, the same…NTSB LAX82FA242Accident · No injuriesField investigationFinal reportBell 206B · Grand Canyon, AZPilot lost power during sight-seeing flight and decided to make a precautionary landing. He aborted one landing due to wind and was at 50 AGL for 2nd attempt when power decreased. Due to wind and lack of power the aircraft made contact with a tree and the…NTSB LAX82DA243Accident · No injuriesFinal reportCessna 182J · Deer Valley, AZWhile climbing through about 6500 ft, a loud bang was heard and the pilot saw the engine cowling buckle. About 10 seconds later, the engine ceased to operate. The pilot declared an emergency and landed on an uncontrolled airport. After landing, an examination…NTSB NYC82DA153Accident · No injuriesFinal reportSchweizer SGS-1-36 · New London, NHWhile being towed during takeoff, the weak link on the tow rope failed when the glider was about 125 ft AGL. The pilot started to land on a golf course ahead, but spotted golfers in his intended landing area. The glider stalled while he was in a steep turn.…NTSB LAX82FUQ15Accident · 1 fatalFinal reportQuickie QAC-1 · Mojave, CAThe acft was built as a one-time only acft for record breaking distance flying, presumably for an around-the-world flight without refueling. Immediately after takeoff, the plt radioed the chase plane that he had some minor problem & was going to land. After…NTSB ANC82DA057Accident · No injuriesFinal reportBritten-Norman BN-2A · Nome, AKDuring the takeoff roll, a propeller blade tip failure occurred on the left engine. About 9 inches of the blade tip separated and entered the top side of the fuselage about 1 ft behind the pilot's head. The blade tip severed the throttle, fuel mixture,…