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 FTW83LA371Accident · No injuriesLimited investigationFinal reportBell 206B · Venice, LAThe acft landed hard during an autorotation landing. The plt said he could not control the engine RPM with RPM switch onthe collective or the manual throttle control. N2 tended to go over 100 percent. The plt notified his company and planned for an…NTSB ATL83LA294Accident · Minor injuriesLimited investigationFinal reportBell 206B · Nr Gatlinburg, TNThe plt reported that he was beginning his apch to a landing site at an elevation of 5200 ft when he felt a bump in the tail rotor pedals. The helicopter begun to spin to the right & the plt found he has no tail rotor control. An autorotative landing was made…NTSB FTW83LA351Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chilton, TXDuring the 1st swath run the prop separated from the eng. A forced landing was made in a plowed field shearing one main landing gear. The acft then went through a barbed wire fence. The #4 cylinder was removed to inspect the vibration damper pins in…NTSB NYC83FA189Accident · 2 fatalField investigationFinal reportRobinson R22 · Canton, PAWhile the helicopter was on a power line patrol flt, one of the main rotor blades separated & the acft crashed & burned. Numerous persons saw the helicopter while the plt was patrolling at low alt. Several reported seeing the acft maneuver abruptly over…NTSB ATL83IA295Incident · No injuriesIncident investigationFinal reportBeech B200 · Winston Salem, NCDuring gear retraction the pct noticed a cracking sound followed by smoke in the cabin which was allwviated by the rear vent blower. The emergency gear handle failed to engage & anemergency landing was made with gear partially extended. Theright gear door…NTSB ATL83FU004Accident · 1 fatalFinal reportCondor II Special · Dahlonega, GAAfter takeoff, the ultralight vehicle was observed to climb about 600 to 700 ft over a pasture east of the rwy, then the plt began to perform aerobatic maneuvers. After completing a loop, the ultralight was observed to rotate nose up. At about that time, a…NTSB FTW83LA341Accident · No injuriesLimited investigationFinal reportCessna 152 · Whitewright, TXThe acft collided with a fence and nosed over after the seat lock pin failed and the seat slid all the way to the rear. The plt was unable to reach the rudder pedals and the acft veered off the road being used as a rwy.NTSB CHI83FA324Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Youngstown, OHDuring an IFR flt, the acft was leveled at 13,000 ft & the power was set at 18 inches manifold pressure & 2300 RPM. Aprx 5 min later, the right eng began to surge to 3000 RPM & almost 'pegged.' The plt attempted to control the right propeller. Finally, the…NTSB ATL83LA283Accident · No injuriesLimited investigationFinal reportCessna 310 · Wheeling, WVDuring the apch, the plt was unable to get a safe down indication for the right main gear. He changed the light bulb & still did not get a safe indication. A tower flyby was made, but the tower operator was unable to confirm if the right gear was locked. To…NTSB CHI83LA317Accident · No injuriesLimited investigationFinal reportCessna 210L · Traverse City, MIThe plt reported that when the landing gear handle was moved to the up position, the hydraulic pump continued to operate. Subsequently, the circuit breaker for the pump was pulled to keep the motor from overheating. Several attempts to lower the gear with the…NTSB CHI83LA313Accident · No injuriesLimited investigationFinal reportCessna 175A · Stanwood, MIThe acft was damaged during landing from a tire failure. During landing the plt heard a report and took off again. He performed a minimum speed landing and during landing the tire rim dug into the surface causing sudden stoppage. The tirefailure had resulted…NTSB MIA83FA183Accident · Serious injuriesField investigationFinal reportKaman H-43B · Near Clermont, FLThe helicopter crashed in an uncontrolled descent from a hover. A witness stated that the helicopter was slowing descending to position a 150 ft line for the ground crew when he observed something separate and the helicopter came down in a vertical descent.…NTSB ATL83LA275Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Brandywine, MDIn level cruise flt the plt experienced a severe vibration followed by uncontrollable rotation to the right. The plt wasunable to regain directional control & crashed into trees. Investigation revealed that the rear t/r drive coupling, PN28-13609, had failed…NTSB CHI83LA310Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Hamel, MNDuring flt, the plt used fuel from 2 of 4 propane tanks, then switched to the 2nd 2 tanks & started a descent. At aprx 300 ft AGL, he tried to start the burner, but could not get a light because the pilot light was out. He attempted to manually relight the…NTSB NYC83FA171Accident · 2 fatalField investigationFinal reportStinson 108 · Farmingdale, NYThe carburetor had been previously removed & reworked, then was reinstalled. After the installation, which included a leak check, the plt got into the left front seat & the passenger/mechanic got into the right front seat. The plt primed the eng, then made a…NTSB NYC83FNE04Accident · 1 fatalFinal reportBede BD-5B · Westfield, MAThe acft crashed short of the rwy during an attempted landing. There were some confusing and garbled transmissions and some mistaken instructions from the tower during the problem experienced by the accident plt. This plt did not make it clear that he had an…NTSB ATL83LA286Accident · No injuriesLimited investigationFinal reportCessna P206B · Suffolk, VAThe parachute of one of the jumpers deployed prematurely. The shroud lines entangled in the right horizontal stabilizer & elevator. As the parachute inflated, the stabilizer was bent downward, & the elevator partially ripped from the trailing edge of the…NTSB ATL83LA264Accident · 1 fatalLimited investigationFinal reportBensen B8M · Somerville, TNThe acft crashed during takeoff while on a pleasure flight. A witness stated that he saw the acft take off and climb outat a gradual climb to about 100 ft and then start a gradual descent to about 30 ft. at which time the acft nosed over and went almost…NTSB FTW83FA323Accident · 1 fatalField investigationFinal reportTexas Helicopter OH-13-EM-7A · Cedarville, ARThe pilot was using an improvised hydraulic vertical saw to trim limbs & brush from powerlines. The saw blades appear to have malfunctioned while the helicopter was maneuvering. The pilot jettisoned the saw, but the quick disconnect hoses failed to release…NTSB SEA83FU007Accident · 1 fatalFinal reportAirmass Sunburst · Tacoma, WAThe ultralight had previously flown to Tacoma with 2 phantom ultralights in preparation for the airshow. During descent the 3 acft had reached speeds of 75-80 mph. After landing, one of phantom plts asked the sunburst plt if he knew how fast he was going and…NTSB CHI83LA297Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Brooten, MNThe helicopter had just lifted off of the flatbed of a truck when it started to spin. The plt lowered the collective, reduced the power & landed beside the truck. During touchdown, the main rotor blades struck the truck. An investigation revealed that the…NTSB NYC83LA166Accident · Minor injuriesLimited investigationFinal reportRotec/Botsford Rally 3 · Kirkville, NYThe 2 place ultralight acft was on final apch to land when the propeller began to freewheel on the propeller shaft. The eng continued to operate & respond to throttle inputs, but the propeller did not produce thrust. The ultralight began to lose altitude…NTSB ATL83LA252Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · Thomasville, GAThe helicopter was on a swath run at about 5 ft AGL & was approaching hi obstructions when the plt noted that the needles split, the eng RPM increased & the main rotor RPM began decreasing. The plt turned to avoid the obstructions, but was unable to level the…NTSB MIA83LA189Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brooksville, FLThe acft collided with a tree during an aborted takeoff when the plt realized that the airspeed was not registering. During the abort, directional control was lost and the acft veer to the left. Inspection revealed the airspeed indicatormalfunctioned due to a…NTSB ATL83FU003Accident · 1 fatalFinal reportAirmass Sunburst Model B · Ernul, NCThe plt was en route from ayden, NC, where he purchased the ultralight, to his home in havelock, NC. While en route, he had landed at Ernul, NC to refuel. After refueling, he took off, circled back over the field, then added power & began to climb. At about…NTSB SEA83FA141Accident · 1 fatalField investigationFinal reportMonnett - Larsen Moni · Albany, ORThe home built, powered glider was being flown on a local test flight. According to witnesses, the acft was in unpowered flt (gliding) when it entered a descent & crashed. At about the same time it began descending, they observed something separate from the…NTSB FTW83LA314Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-2902 · Katy, TXThe glider collided with a ditch during a forced landing after the tow rope disconnected shortly after takeoff. The plt was not able to avoid the ditch during landing due to a strong sink rate. The tow hook assembly was examined after the accident and no…NTSB FTW83LA305Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Port Mansfield, TXAccording to the plt, the nose gear position light flickered & the nose gear unsafe light illuminated, just prior to rotation. He reportedly aborted the takeoff at that time, but was unable to stop before going off the end of the rwy at 65 to 70 KTS. As the…NTSB SEA83FA135Accident · Minor injuriesField investigationFinal reportEnstrom 280C · Kent, WADuring a traffic reporting flt for a radio station, the plt noted the onset of a severe vibration which he felt through the antitorque pedals. He stated that within seconds, the helicopter lost directional control & began a rapid, uncontrolled spin to the…NTSB ANC83LA108Accident · No injuriesLimited investigationFinal reportCessna 180 · King Salmon, AKThe acft groundlooped after landing. The pilot stated that a tire went flat during landing and the wheel dug into the asphalt. This turned the acft and damaged the landing gear. The acft turned about 100 degrees before stopping.NTSB LAX83FU009Accident · 1 fatalFinal reportAmerican Aerolights Eagle XL · Sommerton, AZA witness in another ultralight saw the plt of the eagle xl climb to about 800 to 1000 ft AGL after taking off. The witness was aprx 500 ft AGL when he saw the eagle xl start a steep descent from his 8 to 9 o'clock high position and thought the eagle xl plt…NTSB LAX83LA304Accident · No injuriesLimited investigationFinal reportRutan LONG-EZ-B · Corning, CAThe plt & passenger were participating in the cafe 400 efficiency race. Shortly after passing a check point, a portion of 1 propeller blade separated & the plt shut down the eng. He elected to land on an interstate highway by merging into traffic. However, he…NTSB LAX83IA302Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC9-32 · Las Vegas, NVDuring the ground run for takeoff a fatigue precipitated failure of the third stage turbine blade occurred with secondary damage to several guide vanes and the fourth stage turbine wheel. Imbalance of the turbine wheel caused the failure of the number six…NTSB NYC83LA150Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · Nantucket, MAThe helicopter made a hard landing during an aborted takeoff following a medical evacuation demonstration at Nantucket. After the presentation the acft was changed from a 2 litter configuration. The pilot noted that the cyclic retention cap was on the cyclic…NTSB LAX83LA299Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tracy, CAThe acft made a hard landing while on an instructional flt. On the seventh approach for landing the nose gear green light did not come on. The CFI continued the approach while tapping on the bulb. When he decided to go around the acft had descended so low…NTSB CHI83LA277Accident · No injuriesLimited investigationFinal reportCessna 188B · Campbell Hill, ILAfter taking off from a haul road, which was being used as an airstrip, the acft began climbing. At about 100 ft AGL, the plt noted a loss of power (thrust) as the eng began to overspeed. The plt lowered the nose to gain airspeed & dumped his load, but was…NTSB CHI83LA272Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-30 · Milwaukee, WIA jetway collapsed as passenger loading commenced. The drive gear failed & oil was found to be contiminated with water. Heat had transferred to the worm gear which was misaligned & was not manufactured for acft use specifications.NTSB FTW83LA289Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Pineville, LAPrior to landing, the plt moved the gear switch to the extend position & noted that the gear indicated down. However, the left main gear did not extend. While landing with the left gear retracted, the acft settled on the left wing & prop. The acft spun 180…NTSB LAX83FVA03Accident · No injuriesFinal reportRockwell S2R · Corcoran, CAThe pilot reported that during his last spraying run he lost left rudder pedal control. He maintained control of the acft in the air but during landing he lost control due to the loss of the left rudder/brake pedal. The acft veered off the right side of the…NTSB DEN83LA145Accident · No injuriesLimited investigationFinal reportCessna 195A · St. George, UTThe prop blade separated causing the acft to veer sharply to the left out of control. The acft came to rest about 30 ft from the rwy with the right main landing gear broken off. A metallurgical exam revealed that the blade failed from fatigue. The fatigue…NTSB DEN83LA144Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Brighton, COAfter entering the landing pattern, the plt noted binding of the aileron control system. Reportedly the aileron controls seemed to lock, so he used the rudders for directional control & landed in a plowed field. During the landing, the acft nosed over. An…NTSB ATL83IA234Incident · No injuriesIncident investigationFinal reportCessna 177RG · Ozark, ALWhile in cruise flight the engine failed to respond to throttle movement due to the throttle linkage being loose. Forced landing was made to a pasture.NTSB ANC83LA099Accident · No injuriesLimited investigationFinal reportCessna 185 · (N) Skwentna, AKThe acft was ground looped intentionally to prevent a collision with people or boats. The pilot said he had no braking action during landing. He believes someone loosened the plugs in the bottom of both brake cylinders and these plugs dropped out in flight.…NTSB FTW83LA287Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Frisco, TXThe plt reported that during flt, the low pressure fuel light illuminated & the nose of the helicopter yawed to the left as if the eng had lost power. He made a precautionary landing in a soft, plowed field with a forward speed of about 10 to 15 mph. During…NTSB ATL83LA233Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Toddville, MDThe acft made an emergency landing while skidding after the aileron control jammed. The pilot in the rear seat and the owner in the front seat said that after a couple of steep turns the aileron control could not be moved. The acft was in a left wing down…NTSB CHI83FA258Accident · 2 fatalField investigationFinal reportCessna T210L · Porter Township, WIBoth occupants were rated plts. The plt in the right front seat of the acft had applied for membership with the organization that owned the plane. He may have been receiving informal instruction in the operation of the acft. During flt, the acft was observed…NTSB ATL83LA229Accident · No injuriesLimited investigationFinal reportAyres S-2R · Arlington, GADuring the takeoff roll, the acft had nearly reached its lift-off speed when the eng backfired. The plt shut down the eng, dumped the chemicals & stopped on the rwy. He then exited the acft. As he walked around the acft, he smelled a strong odor of fuel. He…NTSB CHI83LA256Accident · Serious injuriesLimited investigationFinal reportQuickie Q2 · Anderson, INThe homebuilt acft veered and nosed over during a landing. Examination of the acft revealed that the cable to the left front rudder attach point became disconnected. The cable had pulled through the nicropress oval sleeve. When the pilot/ builder was…NTSB CHI83LA282Accident · No injuriesLimited investigationFinal reportLombard Dilley 68 · Camp Douglas, WIThe experimental acft lost a blade of its propeller during cruise flt. The propeller had been modified to obtain more RPM. About 18 inches of one blade separated during cruise at 6000 ft with 2900 RPM at 200 KTS airspeed. The engine remained attached to the…NTSB NYC83FHM02Accident · 1 fatalFinal reportDial-Thorp T-18 · Morristown, NJThe plt had been active in organizing an air show, but was not considered a participant. However, his home built acft was on static display. On the 2nd day of the show, the chairman of the event gave him permission to do a fly-by. Subsequently, he initiated a…