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 ATL82FLQ07Accident · Serious injuriesFinal reportKR-2 · Mcwhorter, KYThis was a home built aircraft that was equipped with an uncertificated, variable pitch, propeller. During flight, a propeller blade separated and the plane was substantially damaged when a forced landing was made on upward sloping terrain. The aircraft and…NTSB FTW82FPA14Accident · Minor injuriesFinal reportMooney M20E · Paris, TXAbout 20 min after takeoff, the pilot noticed oil on the left side glass and windshield while cruising at 7000 ft. he then checked oil pressure and it was near zero. He shut down the engine, and during a forced landing, the aircraft was substantially damaged.…NTSB FTW82DA254Accident · No injuriesFinal reportDowner Aircraft Industries Republic RC-3 · Llano, TXThe pilot was on a test flight to check the engine in the amphibious aircraft. As the landing gear was being lowered to land at the airport, a "pop" was heard. Reportedly, the noise occurred when the clevis on the rod end of the retract/extend cylinder…NTSB LAX82DA234Accident · Minor injuriesFinal reportBell 47J-2 · Corcoran, CADuring takeoff from a landing dolly, the pilot lost directional control and the helicopter began to spin to the right. He realized that he had a tail rotor failure, but reported that he was half over the dolly and headed toward a jet ranger and a fuel system.…NTSB NYC82FNA17Accident · No injuriesFinal reportS.N.I.A.S. SA-330J · Hyannis, MAThe pilot reported that he took off, and during a climb through about 800 ft, he heard a loud snap and immediately felt severe lateral vibrations. He declared an emergency and landed without further incident. An investigation revealed that the inboard…NTSB DEN82DA110Accident · No injuriesFinal reportPiper PA-32RT-300T · Durango, COThe pilot reported that after taking off, dense white smoke began to fill the cockpit and seemed to come from under the instrument panel. He stated that the instruments were in the normal operating range, but the smoke became so dense that the visibility in…NTSB MIA82DA138Accident · No injuriesFinal reportBrantly B-2B · Ruskin, FLThe plt experienced heavy vibration followed by loss of control of the acft. Witnesses described the acft in abrupt changes in attitude. Exam of the pitch link assemblies revealed failure under static overload conditions. A third pitch link assembly was not…NTSB FTW82FPD13Accident · 1 fatalFinal reportVarieze · Roanoke, TXAbout 5 min after takeoff, the pilot initiated a high speed low pass over the airport. When the aircraft was about 1000 ft from the airport at about 100 ft AGL, the right winglet separated. A witness estimated that the aircraft's speed was about 200 mph.…NTSB ATL82FA163Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Atlanta, GAShortly after takeoff, a loud noise was heard and sparks were observed coming from the right side of the right engine. The aircrew attempted to feather the right engine, but it would not feather. They were unable to maintain altitude and descended into trees.…NTSB SEA82FYM19Accident · Minor injuriesFinal reportChampion 7GCAA · Independence, ORThe pilot reported that during a full stall landing, the aircraft veered to the left at the moment of touchdown. Full power was applied for a go-around, but reportedly, the pilot was unable to turn the aircraft back to the right toward the runway. After…NTSB FTW82DA219Accident · No injuriesFinal reportI.C.A. Brasov - Romania IS-28B2 · El Paso, TXThe sailplane was towed to about 200 ft AGL when the tow rope separated. When the pilot realized he was unable to return to the airport he attempted a landing along a river levee. The left wing struck the levee and the aircraft cartwheeled.NTSB ANC82DA046Accident · Minor injuriesFinal reportCessna 180 · Seldovia, AKDuring flight, the pilot noted that oil began to collect on the windscreen. He continued the flight to the destination and landed on runway 16 with an oil covered windscreen and in what he described as "squirrelly winds." The wind was estimated to be from 150…NTSB FTW82FPD14Accident · No injuriesFinal reportLearjet 23 · Abilene, TXAbout 5 min after takeoff, the pilot initiated a high speed low pass over the airport. When the aircraft was about 1000 ft from the airport at about 100 ft AGL, the richt winglet separated. A witness estimated that the aircraft's speed was about 200 mph.…NTSB NYC82DA121Accident · No injuriesFinal reportScheicher K8B · Shrewsbury, PAThe pilot was on a round robin, cross-country flight from woodbine, MD to Shrewsbury, PA and return. When he arrived over shewsbury, he maneuvered the glider to take a picture of his turn point. While taking the picture, he skidded the glider to include the…NTSB FTW82DA213Accident · No injuriesFinal reportCessna A185E · Lafayette, LAThe pilot stated that during a water landing the right main landing gear dropped down causing the aircraft to swerve to the right. The left wing contacted the water and received substantial damage. The reason for the gear to drop out was never determined.NTSB CHI82FA211Accident · No injuriesField investigationFinal reportPiper PA-30 · Vandalia, OHDuring descent at 215 mph the acft entered violent buffeting. Recovery was initiated by reducing power & the acft landed without any further incident. Examination revealed the horizontal stabilator was permanently bent downward on both sides. The acft was…NTSB FTW82DA208Accident · No injuriesFinal reportPiper PA-25-235 · Jayton, TXWhile taxiing out for takeoff with a full load of fuel and chemicals the left main wheel broke into three pieces. The axle sank into the surface of the runway causing the aircraft to swerve to the left, resulting in an overload condition on the right gear.…NTSB CHI82DA198Accident · Minor injuriesFinal reportBell 47G-5A · New Philadelphi, OHWhile patrolling a powerline, the pilot heard a loud noise, similar to a gunshot, which seemed to come from directly behind the firewall. Immediately after that, the helicopter started to pitch up and roll to the right. He reported that the helicopter reached…NTSB ATL82DA149Accident · No injuriesFinal reportCessna T210N · Clemson, SCThe pilot stated that during landing roll he felt the effectiveness of the brakes diminish appreciably. As the end of the runway became visible he attempted to ground loop the aircraft but was unable to establish any significant rate of turn. The aircraft…NTSB CHI82DA193Accident · No injuriesFinal reportCessna 182 · Tracy, MNThe pilot reported that during a normal landing, the left main gear axle failed and he was unable to control the aircraft. The aircraft went off the runway and the nose gear collapsed when it encountered soft mud.NTSB LAX82FA202Accident · No injuriesField investigationFinal reportKaman K600-3 · Lodi, CAThe helicopter started vibrating in flight, and when the pilot was unable to control the aircraft for a normal approach to the airport, he elected to land in a cornfield. The aircraft rolled to the right at touchdown. The right blade flap assembly had…NTSB CHI82DA192Accident · No injuriesFinal reportErcoupe 415-C · Fort Atkinson, WIThe safety bolt on the propeller hub failed allowing the propeller to separate from the aircraft. The pilot landed in a plowed field.NTSB FTW82IA209Incident · No injuriesIncident investigationFinal reportPiper PA-31P-135 · Lake Charles, LAWhile cruising at FL200 in VMC conditions, the pilot smelled and then observed smoke coming from the windshield defrosters and under the instrument panel. He advised houston center of his situation, then turned off all electrical equipment and made an…NTSB FTW82DA196Accident · No injuriesFinal reportCessna A188B · Mangham, LAWhile turning to begin a swath run at about 200 ft AGL, a propeller blade failed and separated. Subsequently, the engine began a severe vibration and also separated. Oil covered the windshield and prevented forward visibility. The pilot reported that he was…NTSB CHI82DA185Accident · No injuriesFinal reportHughes 369D · Fairbury, ILDuring flight, the N2 and nr suddenly accelerated to 110 percent. The pilot eventually shut down the engine and made an autorotation. An open field was selected for a landing site; however, it was muddy with standing water. The pilot decided on a full stop…NTSB ATL82IA139Incident · No injuriesIncident investigationFinal reportCessna 404 · Charlotte, NCDuring takeoff, the hydraulic pressure was lost after the gear was raised and the flaps were being retracted. The pilot attempted to extend the gear with both the normal and manual systems, but to no avail. Subsequently, a gear up landing was made. An…NTSB NYC82DA102Accident · Minor injuriesFinal reportPiper PA-22-150 · Seneca Falls, NYWhile trying to roll out of a left turn on downwind the pilot experienced a jammed rudder control. Full aileron control was not available because of the aileron-rudder interconnect system and a considerable buffet was induced during an attempt to level the…NTSB FTW82FRG29Accident · 4 fatalFinal reportBeech 95-C55 · Eagle Pass, TXThe wreckage was located approximately 16 mi se of Eagle Pass & with the exception of the elevators, all major components of the acft were identified at the scene. The outboard half of the r elevator was found 2 mi nw & the counterweight on the elev tip was…NTSB DCA82IA021Incident · No injuriesIncident investigationFinal reportGates Learjet 24B · Ft. Myer, FLWhile climbing to a cruise altitude of 41000 feet, the pilot engaged the autopilot at approximately 29500 feet. The aircraft started to pitch nose down several seconds later. The pitch trim switch was turned off and the circuit breakers pulled. The pilots…NTSB ANC82DAG22Accident · Minor injuriesFinal reportCessna 195 · Anchorage, AKThe pilot stated that during the landing roll, at a speed of approximately 30 KTS, the brakes were applied in preparation for turning off the runway. The right brake pedal went to the floor and attempts to pump it up were unsuccessful. The aircraft ran off…NTSB MIA82DA116Accident · No injuriesFinal reportAerospatiale SA-319B · Jacksonville, FLThe pilot and crew were using an air ambulance helicopter while participating with the fire department in a simulated disaster drill. During the drill, the helicopter took off with two other occupants that had volunteered to act as immobilized patients. With…NTSB FTW82FRJ10Accident · 1 fatalFinal reportContinental Tomcat MK6C · Cottonport, LAThe plt was familiarizing himself with the acft & the local area. The plt's log book showed only one hour of flt time logged between 9/23/81 & the date of the accident. Witnesses observed the acft flying for some time over the city at 300-400 ft AGL making…NTSB CHI82DA149Accident · No injuriesFinal reportHughes 269C · Flint, MIThe aircrew were on an instructional flight to prepare the student, a rated pilot, for a flight instructor rating. After practicing several autorotation approaches, the helicopter was landed. The instructor pilot (ip) stated that after touchdown, he and the…NTSB NYC82DA087Accident · No injuriesFinal reportHiller UH-12A · New Paltz, NYWhile cruising at 400 ft AGL, the pilot noticed a decay in the main rotor RPM; however, the engine RPM was reported to have remained constant. The pilot suspected a mechanical failure and elected to make a precautionary landing in an apple orchard. During the…NTSB MKC82IA070Incident · No injuriesIncident investigationFinal reportBeech M35 · Ava, MODuring a night cross-country from pryor, ok to Ava, MO, the aircraft experienced a total electrical failure as a result of a loose alternator belt and a depleted battery. On arrival at his destination, the pilot selected gear down with the normal extension…NTSB LAX82FVG22Accident · Minor injuriesFinal reportOsprey 2 · Lakeport, CAThe pilot reported that after takeoff, he made a few turns and then headed downwind for a landing when he lost the control of an aileron. He reported that he encountered a bad vibration, so he cut the power and brought the plane into a small field by crossing…NTSB MIA82FA115Accident · No injuriesField investigationFinal reportRobinson R-22 · Ft. Pierce, FLThe student pilot was performing autorotations with 180 degree turns terminating with power recoveries. At about 200 feet, after completion of the turn, the instructor heard a rattling noise followed by a medium frequency vibration. The instructor took the…NTSB FTW82DA160Accident · No injuriesFinal reportGrumman G-164A · Oberlin, LAThe pilot reported that during landing, his left brake failed. He elected to go-around. However, while maneuvering to avoid a building, the aircraft struck a rice dike and crashed. The pilot reported that the left brake thrust plate had broken during the…NTSB DEN82DA073Accident · Minor injuriesFinal reportHughes 369D (500D) · Coalville, UTThe helicopter made a hard landing after the pilot experienced a power train failure while flying low and slow. The weather was VMC and a VFR flight plan was filed. The crew was searching for lost mining equipment in a low slow search pattern. The pilot heard…NTSB CHI82FA135Accident · 2 fatalField investigationFinal reportDauntless D52 · Sebring, OHBoth wings separated during an experimental test flight of the motorized glider. The plt had indicated the tests would include climbing to a safe altitude & doing a few power-off shallow glides to see if there was any indication of flutter at perhaps max…NTSB ATL82DA115Accident · No injuriesFinal reportPiper PA-23 · Louisville, KYThe pilot stated that during level flight at 9000 ft, he noticed smoke coming from under the instrument panel, followed by a vibration for 15 to 20 seconds. He diverted and landed at Louisville, KY without further incident. An examination revealed that the…NTSB FTW82FA145Accident · 2 fatalField investigationFinal reportBell 212 · Intracoastal Ci, LAThe helicopter was in cruise flight when a sudden and severe right yaw occurred. Subsequently, it was autorotated to a ditching in rough water. Touchdown was made on top of a wave, then the helicopter rolled over. The survivors did not get the raft out.…NTSB FTW82DA144Accident · No injuriesFinal reportBell 206L-1 · Cameron, LAN2138Y departed Cameron, LA after refueling en route to an offshore rig. Shortly after departure, while over water, the aircraft began to yaw and vibrate severely. The pilot stated that the tail rotor pedals "kicked" hard when additional power was applied.…NTSB MIA82IA102Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · Miami, FLEastern airlines flight 29, a Lockheed L-1011, scheduled flight from new york landed at Miami international airport. During the landing roll, the crew noticed a red warning light on the left main landing gear. The aircraft completed the landing roll at which…NTSB MKC82IA059Incident · No injuriesIncident investigationFinal reportRockwell NA-265-65 · St. Louis, MOWhile enroute from grand island, NE to nashville, TN, the pilot noticed that the aircraft would not trim nose down, but that it would trim nose up normally. The pilot reduced speed and altitude and diverted to St. Louis, MO in order to have the problem…NTSB FTW82FA132Accident · 3 fatalField investigationFinal reportBell 222 · Hinton, OKHelicopter broke up in flight and fell in pieces in an open field. Weather was VMC and it was daylight. All 3 occupants were fatally injured. The breakup occurred while aircraft was in cruise flight.NTSB CHI82FA123Accident · 3 fatalField investigationFinal reportMooney M20J · Bird Island, MNThe aircraft departed thief rivers, MN and proceeded en route to new ulm, MN. One witness near the accident site heard a noise that sounded to him like an explosion. He and other witnesses in the vicinity saw the aircraft descending out of control in a roll…NTSB DEN82DA088Accident · Minor injuriesFinal reportAerospatiale SA315B · Thayne, WYThe helicopter was hovering to pick up a sling load when a loud bang was heard and the aircraft began to spin counter clockwise. Investigation revealed that the tail rotor drive shaft had broken. "Examination of the shaft break disclosed a small fracture…NTSB ATL82DA100Accident · Minor injuriesFinal reportS.N.I.A.S. AS350D Astar · Alcoa, TNWhile preparing to land, the pilot experienced a tail rotor drive failure at a speed of less than 60 knots. At that speed, he was unable to make the necessary right turn from his position to land on the runway. Instead, he climbed about 50 ft in a left turn…NTSB FTW82DA119Accident · Minor injuriesFinal reportCessna 150 · Santa Fe, NMOne blade of the propeller failed in cruise. Power was reduced due to vibration and a forced landing was made. During the hard landing on upslope rangeland the landing gear failed.