NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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 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 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 NYC84LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Ocean City, NJDuring landing in a x-wind the plt said the acft was pushed to the right side of the rwy by the shifting wind. The nose wheel was broken off and the right wing damaged. The plt reported that the wind shifted from the southwest to the southeast and was gusting…NTSB LAX84LA388Accident · No injuriesLimited investigationFinal reportBeech C-23 · Chandler, AZThe student plt was on his 1st solo flt. He reported that the acft bounced during a landing, then 'started to head off to the left.' He reported that he 'came in with power & rudder' but the acft went off the rwy & hit a mound of dirt & a fence.NTSB DEN84LA217Accident · No injuriesLimited investigationFinal reportWeatherly 201 · Watertown, SDThe spray boom of the acft caught in the green wheat along the right side of the dirt rwy during takeoff. The acft then ran off the prepared surface into the wheat. It then nosed over onto its back and caught fire. The dirt rwy is 30 ft wide. The wingspan of…NTSB DEN84LA216Accident · No injuriesLimited investigationFinal reportBell 206B · Salina, UTThe acft crashed during takeoff. The plt said he was hovering after takeoff at about 20 ft AGL when he noticed a long line draped over the rt skid. He said he thought he could dislodge it. While maneuvring to attempt this, the helicopter rolled to the rt and…NTSB CHI84LA285Accident · No injuriesLimited investigationFinal reportCessna 170B · Edgerton, WIThe plt stated he made a faster than normal approach & upon touchdown, the acft bounced back into the air. He added a little power to smooth out the landing, but when the acft touched down, the second time, it veered off the rwy, encountered a muddy corn…NTSB CHI84LA283Accident · No injuriesLimited investigationFinal reportPitts S-1C · Port Sanilac, MIThe acft was on a VFR x-country when the weather began to deteriorate. The plt overflew sandusky arpt with wx 0F 1000 ftovercast and visibility 3 miles in fog. He said he 'inspected' the arpt as a possible landing site but continued the flt. Following a road…NTSB ATL84FA218Accident · Serious injuriesField investigationFinal reportHughes 369D · Franklin, TNThe acft landed hard & rolled over during an emergency autorotation lndg after the acft eng experienced a flame-out. Theacft had experienced a low fuel warning light earlier in the flt and the plt had made a precautionary lndg after which he and the passenger…NTSB SEA84LA169Accident · No injuriesLimited investigationFinal reportCessna 172NII · Hillsboro, ORWhile taxing on a ramp area the plts attention was diverted to adjusting the transponder code. The left wing of the acft contacted a moving fuel truck.NTSB SEA84IA168Incident · No injuriesIncident investigationFinal reportBoeing B-737-222 · Portland, ORAfter takeoff, the acft was climbing thru about 4000 ft when the APU fire warning light illuminated. The flt crew discharged the fire extinguishing units & requested an emergency landing. A teardown of the APU revealed evidence that a hard object was injested…NTSB MKC84LA210Accident · No injuriesLimited investigationFinal reportGrumman G164B · Mc Gehee, ARThe acft was engaged in an aerial application flt when the eng lost power. The plt made a forced landing in a bean field. During the landing roll, the acft struck a levee that was obscured by high vegetation & nosed over. A post-accident investigation…NTSB MKC84LA208Accident · No injuriesLimited investigationFinal reportCessna 337G · Hickory Ridge, ARThe plt was on a business trip to Hickory Ridge, AR. He stated that he landed at wynne, AR, but could not rent an auto to proceed to Hickory Ridge. The FBO stated that there was a 3200 ft crop dusting strip at Hickory Ridge, so the plt elected to fly there.…NTSB MKC84LA207Accident · No injuriesLimited investigationFinal reportCessna 182P · East Lynne, MODuring landing, plt stated, a gust of wind caught the acft resulting in a hard landing before a recovery could be initiated. The plt reported winds were variable at 20 KTS with gusts to 30 KTS.NTSB MKC84LA205Accident · No injuriesLimited investigationFinal reportHiller H-23D · Neelyville, MOThe acft rolled over during an emergency landing. The plt claimed that the rotor disengaged at about 30 ft AGL during takeoff. After the accident the upper half of the yoke control was found fractured. A lab report stated that no materialdefects were related…NTSB LAX84LA387Accident · No injuriesLimited investigationFinal reportHelio H-295 · Santa Ana, CAAs the tailwheel settled to the rwy the acft veered right and ground looped collapsing the left main ldg gear. The left main gear oleo strut failed due to tensile overload.NTSB LAX84LA386Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Llano, CAAccording to the plt, the glider did not sink as fast as expected on the downwind leg, so he extended flaps to 30 to 40 deg, used spoilers & extended the downwind. On base leg he entered an area of high sink; therefore, he closed the spoilers & angled toward…NTSB DEN84LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Los Alamos, NMThe attempted downwind takeoff was aborted but resulted in an overrun off the end of the rwy. According to the PIC the airspeed indicator was inoperative and the brakes were well worn prior to departure. With about 1000 ft of rwy remaining the abort was…NTSB DEN84LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Empire, COPlt stated, 'departed arapahoe, planning on selecting best mountain pass versus altitude achieved. At 10,500, decided pass I was entering would be too difficult & began maneuvering for 180 turn. Severe downdraft occurred & altitude & airspeed lost precluded a…NTSB ATL84FKG11Accident · No injuriesFinal reportCessna 421C · Kennesaw, GAThe plt reported that during the takeoff roll, at about 80 KTS, the right baggage door came open. He aborted the takeoff & the acft ran off the end of the rwy.NTSB SEA84LA188Accident · No injuriesLimited investigationFinal reportCessna 182 · Craigmont, IDAccording to the plt, during landing the brakes failed and the acft came to a stop about 10 ft beyond the end of the rwy after rolling into a shallow ditch. Maint personnel examined the right wheel brake system and found no mechanical malfunction or leakage…NTSB NYC84LA238Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau SF-27M · Grove City, PAThe motorglider lost power after takeoff. According to the plt the takeoff seemed long but he did not abort because thiswas his first self-launch and he was unsure of the operation. About 200 ft AGL a turn was made to the east to return to the arpt and the…NTSB NYC84LA237Accident · No injuriesLimited investigationFinal reportSchleicher ASW-15 · Fairfield, PAThe glider was landed off arpt during a return from a round robin flt after experiencing a high sink rate. During the landing approach power lines hidden in a tree line were not cleared and the collision caused the acft to yaw about 45 degrees. The acft…NTSB NYC84LA236Accident · No injuriesLimited investigationFinal reportBeech 58 · Oneonta, NYPlt stated he was making multiple communications on base leg, talking on company freq as well as UNICOM, while adjusting his pattern to accomodate slow traffic on the runway and maintaing acft handling in gusty wind conditions. Gear handle was selected to…NTSB NYC84LA235Accident · No injuriesLimited investigationFinal reportPiper PA-23 · No. Andover, MAThe acft lost power at about 200 ft AGL during takeoff. The plt feathered the right engine and then elected to land on the remaining rwy when the left engine lost power. The acft went off the rwys end with brakes locked. When the acft was examined by FAA…NTSB NYC84FGM06Accident · Serious injuriesFinal reportTeratorn II · Brownsville, PAThe owner/plt had previous flown the home built acft which was constructed similar to an ultralight. An optional pilot enclosure (canvas covering over the plt compartment) had just been installed. On 7/7/84, the owner/plt taxi checked the acft for about 30…NTSB NYC84FA234Accident · 2 fatalField investigationFinal reportBeech 95 · Shelter Island, NYAcft level abt 3000 ft. engines sputtered. Acft descended in uncontrolled attitude. Tach 6.9 hrs since last fueling. Acft did not have shoulder harness or metal to metal seat belt buckle for pilot and copilot seats. Pilot biennial and medical not currentNTSB MKC84LA206Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Bennington, KSThe student plt stated that after lifting to a hover on her first solo flt, she made two 180 degree hovering turns. She said that the helicopter entered a violent lateral vibration and descended to the ground. Examination of the wreckage did not disclose any…NTSB MKC84LA203Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Topeka, KSDuring flt, the plt decided to divert to Topeka, KS. While landing on rwy 13, the acft veered to the right. Subsequently, it went off the side of the rwy, encountered soft, muddy terrain & nosed over. The wind was from 210 degs at 14 gusting 22 KTS.NTSB MKC84FA202Accident · 1 fatalField investigationFinal reportCulver LFA · Plattsburg, MOWitnesses viewed the acft in a nose high attitude at a low alt near the south end of rwy 18. The acft climbed a short distance, rolled to the left and descended nearly vertically to the ground.NTSB LAX84LA385Accident · No injuriesLimited investigationFinal reportCessna 500 · Gualala, CAOn an air taxi flt to a privately owned, public use arpt, the transport category acft touched down hard, 7 ft beyond the beginning of the 2500-FT-long rwy. The hard surfaced rwy's strength was inadequate to support the acft's 9500 lb ldg weight & the acft's…NTSB CHI84LA284Accident · No injuriesLimited investigationFinal reportCessna 172M · Lake Geneva, WIAccording to the plt, he was on a short final apch to land when the acft encountered sudden turbulence. At that time, the passenger in the right front seat lurched against the control wheel, causing the nose to pitch down & the acft to bank left.…NTSB CHI84LA277Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lansing, ILThe acft ran off the end of the rwy into a ditch during landing. The plt said that his landing speed was 'well above normal touchdown speed.' He had made one approach before the accident and went around because he was 'landing long.' There were no reported…NTSB CHI84LA271Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Flint, MIThe plt stated that during preflight, he noticed that after straining the fuel sump, the strainer handle did not go backin as FAR as it should have. He checked to make sure no fuel was leaking & decided to take off. En route, he smelled fuel vapors. The eng…NTSB CHI84FA282Accident · Serious injuriesField investigationFinal reportCessna 205 · Oak Brook, ILPilot and passengers here circling over a golf tournanent taking photographs when the engine quit. The pilot made an emergency landing on an adjacent golf course and the aircraft struck a tree during the rollout. Post accident exam of the eng revealed no…NTSB ATL84FA216Accident · 1 fatalField investigationFinal reportCessna 150J · Terry Town, GAWitnesses observed the aircraft manuvering in the vicinity of the accident site at about 100 ft AGL. A second low pass was executed, terminating with a sharp pull up to a near vertical attitude. The acft climbed to about 300 ft AGL, the nose tucked under and…NTSB SEA84LA167Accident · No injuriesLimited investigationFinal reportCessna 172N · Roache Harbor, WAThe acft bounced and drifted during a landing in a gusty x-wind. The plt tried applying power and reducing flaps but ended up off the rwy in a ditch and fence. His total time in this model acft was 3 hours.NTSB SEA84LA166Accident · Serious injuriesLimited investigationFinal reportMooney M-20C · Chiloquin, ORThe acft stalled and crashed during a forced landing after the engine quit. The acft had only been airborne for about 5 minutes. The plt told FAA inspectors he was going to get fuel. He stated that the left tank had less than 1/4 tank and 'a small ammount' in…NTSB SEA84LA165Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Juneau, AKThe cowling of the acft came loose and the plt reduced power because of the vibration. An emergency was declared and theplt attempted a 180 degree turn at an alt of 400 ft AGL. A stall was entered and the acft hit a channel where the water was about 10 ft…NTSB MKC84LU005Accident · Serious injuriesFinal reportUFM Easy Riser · Des Moines, IAThe ultralight was making turns at low alt when it stalled and spun into the ground. The plt was unable to recover before ground impact.NTSB MKC84LA204Accident · No injuriesLimited investigationFinal reportCessna 172M · Colt, ARThe pilot stated that he made his final approach to the rwy at 70 mph and the aircraft floated when he flared for touchdown. He continued to state that after acft touched down, insufficient runway remained to stop before overrunning the runway and impacted a…NTSB FTW84LA305Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Welch, TXThe plt was participating in a national x-country contest. After aprx 6 hrs of flt, he elected to land in a circular irrigated cotton field. During a 2nd 360 deg turn over the intended landing area, at aprx 100 ft AGL, the glider's left wing dropped about 60…NTSB FTW84LA304Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Lubbock, TXAccording to the plt, the right eng lost power & during the approach to the arpt, the left eng also lost power. Subsequently, he made a wheels up landing in a cotton field & the acft was damaged. The plt indicated that he was distracted in his attempts to…NTSB FTW84FA302Accident · 1 fatalField investigationFinal reportMooney M-18LA · New Iberia, LAA plt witness observed the acft in a 20 to 30 deg dive at high speed just prior to the accident. He reported that at an alt of about 1200 to 1300 ft, the acft began a pull-up. As the pull-up was started, the outboard portion of the acft's left wing folded…NTSB DEN84LU007Accident · 1 fatalFinal reportEipper Quicksilver MXL · Granby, COReportedly, the plt was flying at low altitude over a lake & had to pull up to cross over a dam. After crossing the dam, he began to descend, but the ultralight vehicle collided with power lines on the down river side of the dam. The power lines were about…NTSB DEN84LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Bryce, UTThe plt said that the wind was calm. The arpt mgr said that the wind was 5-10 KTS from about 180 degrees. The acft according to him went off the left side of the rwy into dirt at full pwr. The acft went back to the rwy heading still atfull power. The plt…NTSB DEN84LA212Accident · No injuriesLimited investigationFinal reportCessna 172 · Minnewaukan, NDThe pilot of this aircraft overflew his intended landing site, a gravel road, in an attempt to observe any power lines or other obstructions that might be in his way. He did not see anything that would prevent a safe landing. While turning to make the actual…NTSB CHI84LU006Accident · Serious injuriesFinal reportPterodactyl Fledgling · Hartford, WIThe ultralight was in the takeoff climb at about 75 ft AGL when the engine failed. During the emergency forced landing, the acft landed hard on upsloping terrain & the nose gear failed in overload. Investigation revealed that an ignition wire was worn and had…NTSB CHI84LA287Accident · No injuriesLimited investigationFinal reportCessna 172P · Columbus, OHNose gear collapsed during hard, flat landing.NTSB CHI84LA286Accident · No injuriesLimited investigationFinal reportGillmore Moni · Joliet, ILThe prop separated from the acft at aprx 500 ft AGL during the initial takeoff climb. A forced landing was made in a corn field. The prop was attached by means of 4 5/16 inch bolts and retaining nuts. Two of the four bolt portions remaining after the accident…NTSB ATL84LA217Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Glen Allen, MSThe plt stated that while doing aerial applications and flying into the sun he failed to see a tree and collided with it. The pilot was not wearing sunglasses nor was the aircraft equipped with sun shading devices.NTSB ANC84LA113Accident · No injuriesLimited investigationFinal reportMaule M-4 · Wasilla, AKThe acft landed short of the rwy during a forced landing. The plt said he switched fuel tanks 3 minutes piror to landingand the engine quit on downwind leg. Restart attempts were unsuccessful. Attempts to further question the plt have been unsuccessful.