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 FTW86LA161Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Grand IsleThe acft crashed into the gulf of Mexico following a suspected eng failure shortly after lift off from an offshore platform. The plt stated that after takeoff, while at 40 KTS and 200 ft above the water, he heard a loud squeal followed by the low RPM audio…NTSB FTW86LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Afton, OKThe pilot stated he was making a precautionary landing at night due to engine roughness and impacted electrical transmission wires. Investigation failed to disclose any reason for the reported engine roughness.NTSB FTW86FA156Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A-2 · Houston, TXThe ends of the outer string and the inner reinforcing wire of the engine air intake duct were not properly positioned under the duct clamp during installation. As a result, they unwound during engine operation and moved out of their normal position on and in…NTSB FTW86FA154Accident · 2 fatalField investigationFinal reportPiper PA-12 · Big Sandy, MTStudent pilot on unauthorized cross country flight departed unimproved field on VFR flight for the purpose of spotting game. Weather conditions in the area were conducive for light to moderate turbulence. Witnesses reported the acft wings rocked violently…NTSB CHI86MA216Incident · No injuriesMajor investigationFinal reportBoeing 737-222 · Lansing, MIPiedmont flt PI255 (a Boeing 737, N749N) was dscndg in visual conds on an IFR clnc when it & a twin commanche (Piper PA-30, N7399Y) converged & passed within a rprtd 50 to 100 ft of each other. The near collision occurred as the PA-30 was cruising westbound…NTSB CHI86LA217Accident · No injuriesLimited investigationFinal reportCessna 172C · Bement, ILOn touchdown the aircraft was not properly aligned with the rwy. While rolling out the left wing caught the full grown corn on the left edge of the rwy and pulled the aircraft into the corn.NTSB CHI86LA214Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Menominee Falls, WIThe plt stated that the eng had quit 3 times in the past 2 weeks. The purpose of the flt was to insure that the eng was working properly. During takeoff, it lost power at about 100 ft AGL. The plt tried to turn & land on the sw part of the arpt. However, a…NTSB CHI86FER17Accident · Serious injuriesFinal reportEugene Boos VARI-EZE · Rice Lake, WIDuring cruise flight the engine of this homebuilt aircraft began running rough. The pilot turned toward an airfield approximately 15 miles away, but was forced to perform a forced landing about 5 miles short of this field because, following a loud metallic…NTSB ATL86LA234Accident · No injuriesLimited investigationFinal reportBenham Midget Mustang M-1 · Rome, GAThe plt reported he took off too close behind a preceding acft and was caught in the wing tip vorticies. The vortices combined with a 110 deg left crosswind (wind 070/20 gusting higher) resulted in a loss of control and ground impact. The plt said he was in a…NTSB ATL86LA233Accident · No injuriesLimited investigationFinal reportBeech C35 · Akron, OHThe plt stated that one to two minutes after the fuel selector was changed from the right to left tank, the eng quit. The aux pump was turned on and fuel selector changed back to the right tank. Then to aux tank then back to left tank. The engine would not…NTSB ATL86FEK07Accident · No injuriesFinal reportBeech A23A · Marysville, OHThe acft porpoised and nosed down during landing. The plt reported that on the second landing attempt, the acft bounced and she failed to apply power soon enough to effect a recovery.NTSB ATL86FA235Accident · 2 fatalField investigationFinal reportPiper PA-18 · Wilton, MEWitnesses saw the acft go into a nose down attitude prior to crashing into a wooded area near the arpt. Rprtdly, the prop was turning, but no sound was heard from the eng. Subsequently, the acft impacted the gnd in a nose low, inverted attitude. No preimpact…NTSB ATL86FA231Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Mansfield, OHAcft took off from pvt sod strip. Father of plt said eng sounds were normal during run up. Acft appeared to be climbing with a normal attitude when the eng quit. Subsequently, acft was stalled followed by a near vertical nose down impact and post impact fire.…NTSB ANC86LA140Accident · No injuriesLimited investigationFinal reportCessna 182 · Iliamna, AKThe pilot stated that he lost control of the aircraft; the aircraft stalled on takeoff and the aircraft struck the lake and rolled over on the gravel bar.NTSB SEA86LA236Accident · No injuriesLimited investigationFinal reportCessna 172N · Lord Flat, ORThe plt elected to go-around at about four feet AGL. Flaps were reduced from 40 degrees of flaps to 20 degrees of flaps and a gentle right turn was made due to rising terrain. The acft then settled onto the ground and crossed two ditches before coming to…NTSB SEA86LA228Accident · No injuriesLimited investigationFinal reportCessna 152 · Lummi Island, WAThe plt stated he remembers passing arlington, WA, at an alt of aprx 2,000 ft MSL but, remembers nothing else until the acft collided with trees. The plt believes that he fell asleep during the flt.NTSB MKC86LA122Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bayard, NEThe plt stated he encountered downdrafts near trees he was going to overfly while in a turnaround maneuver to spray crops. Instead of flying over the trees, the plt stated that the acft descended into the ground near the trees while in the turn. Wind…NTSB MIA86LA245Accident · No injuriesLimited investigationFinal reportBeech G-35 · Lantana, FLShortly after takeoff the cabin door opened. The pilot continued the short flight to his home airfield. During approach he stated that due to the increased noise in the cabin he forgot to lower the landing gear. The aircraft contacted the runway with the…NTSB FTW86LA158Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Addison, TXDuring the landing roll, the right main landing gear collapsed & separated from the fuselage. An exam revealed the right main gear had failed due to fatigue. The acft had a total airframe time of 1481 hrs.NTSB DEN86MA241Accident · 7 fatalMajor investigationFinal reportCessna 441 · Lander, WYOn 5/1/86, the plt had an acoustic tumor removed fm his rgt ear which included the removal of the 8th nerve (balance nerve). His attending physician suggested aprx a 1 yr period of recuperation due to equilibrium problems associated with this type of surgery.…NTSB CHI86MA212Accident · 1 fatalMajor investigationFinal reportPiper PA-31-T1 · Montgomery, NYAfter canceling his IFR flight plan, the PA-31 pilot entered the traffic pattern for rwy 26 on a crosswind leg. He did not see any traffic on downwind as he entered the pattern. He visually cleared the area below and to his right while on downwind and as he…NTSB CHI86FA215Accident · No injuriesField investigationFinal reportCessna 172P · Grayslake, ILDrg cruise flt, there was a loss of eng power (decreasing to 1900 RPM). The plt initiated a precautionary landing on rwy 27, but overran the intended landing area. The acft contd beyond the end of the rwy & subsequently flipped over in a corn field, west of…NTSB ATL86LA232Accident · No injuriesLimited investigationFinal reportCessna 150H · Rome, GAThe plt said he took off with about 6 gallons of automotive gas in the acft for the 14 NM trip to a local arpt. During descent for landing, the eng quit and a forced landing was made in a corn field. Post accident exam of the acft failed to reveal any fuel in…NTSB ATL86FEK06Accident · No injuriesFinal reportSunburst N/A · Lima, OHAccording to the plt, the ultralight was being taxied when a gust of wind caused it to become airborne. The plt elected to fly around the traffic pattern and return for a landing, however, while airborne it was noted the ailerons were locked in the left bank…NTSB ANC86LA139Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Susitna River, AKThe pilot was demonstrating inverted flight to the student pilot and after one minute of flight in that attitude the engine began to run rough and then finally failed. The pilot performed a forced landing and during the landing roll the airplane nosed over.NTSB SEA86LA227Accident · No injuriesLimited investigationFinal reportBeech A-36 · Elk City, IDDuring landing roll a loss of braking occurred due to excessively worn brake pads and a bent shaft in the left master cylinder. Near the end of the runway the pilot elected to ground loop the aircraft in order to avoid trees at the departure end of the runway.NTSB MKC86FA179Accident · 2 fatalField investigationFinal reportLockheed 18-56 (Howard 250) · Texarkana, ARWhile apchg for a lndg, the acft pitched up, rolled inverted & impacted the terrain to the left of the rwy. No preimpactpart failure/malfunction was fnd; however, an inv revealed the acft had been loaded with the center-of-gravity (CG) wellbehind the aft…NTSB LAX86LA335Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Fremont, CAThe glider tow pilot stated that he noticed the glider's spoilers in the open position shortly after takeoff. He brought the glider to the traffic pattern. The glider pilot released from the tow and made a sharp turn during which the glider pitched up,…NTSB LAX86LA333Accident · No injuriesLimited investigationFinal reportCessna 182R · Kernville, CAThe plt stated he made a hard landing and the acft bounced. After taxiing the acft to parking it was discovered that substantial damage was sustained. The plt also indicated that the winds at the time were calm.NTSB CHI86FEE06Accident · Minor injuriesFinal reportFriling/Cothern Longeze · Plainfield, ILThe pilot made a steep right bank while entering the downwind leg on approach to land when the engine quit and the pilot was forced to make an emergency landing in a field short of the runway. Upon examination of the fuel system there was a lack of fuel in…NTSB SEA86LA226Accident · No injuriesLimited investigationFinal reportHegsted S16B · Kelso, WAThe student pilot was on final when the engine ceased operating. A forced landing was accomplished with touchdown being about 100 yards short of the runway. A hard landing was made with the aircraft coming to rest inverted. The needle valve to the carburetor…NTSB NYC86LA221Accident · No injuriesLimited investigationFinal reportCessna 150H · Leroy, NYThe flt experienced an engine failure shortly after takeoff due to fuel starvation. The plt was flying the aircraft on the left tank which had no appreciable amount of fuel, while the right tank contained 12 to 13 gallons on fuel.NTSB NYC86FHD03Accident · 1 fatalFinal reportPassonno Skybolt · Moorestown, NJThe Passonno skybolt was observed to recover from a loop and then the tail surfaces started to shake. The acft then descended to the ground and was destroyed by impact. Examination of various horizontal stabilizer and elevator components showed that the…NTSB NYC86FA218Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Atlantic City, NJUpon lnding the pilot was unable to maintain directional control. He then aborted the lnding and attempted a go around. During this maneuver the acft struck a marsh area aprpox .5 miles from the arpt. The plt and one passenger received fatal injuries, one pax…NTSB MKC86LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-150C · Junction City, KSThe c.f.I. Stated that this flight was to be an aircraft checkout of another instructor. After some air work they proceeded to a nearby airport to practice takeoffs and landings. While on final approach for a practice short field landing the aircraft…NTSB MIA86LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-R · Cedar Key, FLThe plt stated that he lost fuel pressure and all attempts to restart the acft were to no avail. He tried to make it to Cedar Key but was unable and ditched in the ocean waters 6 miles northwest of Cedar Key. Post crash examination of the fuel system revealed…NTSB ATL86LA254Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Myrtle Beach, SCThe acft was about 1/2 hrs into a planned 2.0 hr banner tow flt. On the last pass along the Beach, at about 500 ft AGL, the eng popped and lost pwr. The plt turned the acft out to sea and landed in the ocean. The plt swam to shore and the acft sank.NTSB ATL86LA230Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Shellman, GAJust after liftoff, the plt noted smoke and attributed it to an overhauled prop which had just been installed. He then heard a loud squeal from the eng and noted a loss of power. A forced landing was made in a rough corn field, where the acft was damaged. An…NTSB ANC86LA138Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Dry Creek, AKThe pilot stated that he had adequate clearance over the trees during the approach, the aircraft just seemed to stall mush into the tree tops. The aircraft's airspeed was below stall speed.NTSB SEA86FA225Accident · 2 fatalField investigationFinal reportCessna 340A · Mesquite, NVWhile en route, the plt was cleared to deviate 20 deg left of course to avoid thunderstorm (tstm) activity that ARTCC radar showed was rgt of course. The plt rprtd turbc, but demurred descending to a lower alt despite a PIREP of clear wx below. He then rprtd…NTSB MKC86LA178Accident · 1 fatalLimited investigationFinal reportCessna 172 · Emporia, KSThe acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…NTSB MKC86LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Wilson, KSThe pilot stated that before the flight the spark plugs were cleaned and inspected and the engine was serviced with eleven quarts of oil. Three hours into the flight instrument meteorological conditions (IMC) with rain was encountered and shortly thereafter…NTSB MIA86LA243Accident · Minor injuriesLimited investigationFinal reportGrumman G-44A · Hawthorne, FLThe plt stated that upon touchdown on the lake the acft felt strange. He added full pwr and took off again but just after takeoff the acft rolled to the right and the nose dove. He removed pwr and with the controls full back, the acft hit the water with no…NTSB LAX86LA332Accident · No injuriesLimited investigationFinal reportCessna TR182RG · San Jose, CAThe plt was unable to fully extend the landing gear and the acft collided with the surface of rwy 30R during landing. Post accident inspection revealed the gear down hose assembly was ruptured thus allowing for a loss of hydraulic fluid.NTSB LAX86LA331Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Salton City, CAA total loss of power was experienced during a descent from 17,500' MSL to 10,000' MSL. Attempts to restart the engine failed and the acft was landed gear-up in a rocky field. Post accident inspection disclosed a track of internal electrical arcing in the…NTSB DEN86LA239Accident · No injuriesLimited investigationFinal reportPiper PA-23E-250 · Grand Forks, NDThe acft was en route from flin flon airport, manitoba, cd, to mason city, IA, and had stopped at Grand Forks, ND, for fuel and to clear customs. During taxi for takeoff, the acft struck a 1-inch concrete lip on the ramp and the right main landing gear…NTSB ATL86LA229Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Benson, NCThe acft was being operated at low level beneath power lines when it collided with the ground. The plt said he could not recall the events of the accident. Exam of the acft revealed no defect in the flt controls nor the engine. Exam of the accident site…NTSB ATL86LA226Accident · No injuriesLimited investigationFinal reportCessna 150L · Campobello, SCWhile on her 2nd solo x-country flt, the student plt became lost/disoriented after the comm/nav radios developed a problem. Subsequently, she made a precautionary landing in an open field. During the landing roll, the acft hit a ditch & nosed over.NTSB ANC86LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Stoney River, AKThe pilot stated that after liftoff he failed to maintain airspeed. The aircraft stalled and crashed into the River.NTSB SEA86LA234Accident · No injuriesLimited investigationFinal reportCessna 182 · Ashwood, ORA loss of power occurred for unknown reason. During landing roll the aircraft's right main gear struck a rock causing part of the gear box to be torn from the aircraft.