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 BFO86FID03Accident · 2 fatalFinal reportTaylor Lonsdale KR-2 · Waynesboro, VAThe airport operator, caleb glick, was driving on a road adjacent to the airport when he observed the aircraft turning base for runway 23 at Waynesboro airport. Shortly therafter he lost sight of N99PT and next observed it as it collided with the ground in…NTSB ATL86LA117Accident · No injuriesLimited investigationFinal reportBellanca 7-GCAA · Chester, SCAircraft was being repositioned on airport for glider tow. Tow rope was attached and pilot concentrated his attention on avoiding entangling tow rope on runway lights. When pilot noticed the aircraft was too low he attempted a go-around with insufficient…NTSB ATL86FA116Accident · Minor injuriesField investigationFinal reportCessna 150M · Gaston, SCTwo aircraft collided and were substantially damaged during landing flare/touchdown at the uncontrolled airport. Both aircraft flew a left hand traffic pattern at a pattern altitude of 1000 ft MSL. A witness to the accident related that one aircraft flew…NTSB SEA86LA106Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Lapwai, IDThe helicopter rotor mast struck powerlines at an alt of 12 ft AGL during an aerial application flt. The plt reported she inadvertently missed seeing the powerlines when she made her survey of the terrain prior to this flt. The helicopterdescended and…NTSB NYC86LA107Accident · No injuriesLimited investigationFinal reportEnstrom F-280C · Ridgefield, NJSeconds after an over-water takeoff from a shoreline helipad the acft impacted the water and sank. The pilot and pax escaped from the submerged acft and were not injured. The pilot claimed that he had a split needle in which the rotor RPM deteriorated. The…NTSB MIA86LA124Accident · No injuriesLimited investigationFinal reportCessna 172N · St. Augustine, FLThe private pilot with a total of 36.2 hours of logged flight time, stated that she landed hard on the nose wheel and the nose strut failed during a full stop landing.NTSB LAX86LA126Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · El Monte, CAThe eng cowling opened as the acft took off. The plt slowed the acft to lower the open cowl. The acft descended into unmarked elec wires and received substantial damage. The pilot returned to arpt and landed without further incident.NTSB FTW86LA070Accident · Serious injuriesLimited investigationFinal reportBellanca 17-300 · El Paso, TXThe eng quit due to fuel starvation. The acft had been flown 2.6 hours on the main tanks. Normal operating time on the main tanks is 2.5 hours according to the owner's manual of the Bellanca viking 300 series. At the crash site the main tanks were found empty…NTSB CHI86FA122Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Westville, INThe plt was taking a friend and two of her acquaintances on a sightseeing ride when the acft crashed into a plowed farm field. The acft's weight was estimated to be 60 lbs under max allowable gross weight at the time of the crash. A witness near the crash…NTSB ATL86LA115Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lake City, TNWhile filming for king kong productions, a Cessna 150, flown by the production pilot collided with bowel mountain near Lake City, TN the pilot was flying low over the terrain when the aircraft failed to climb as fast as the pilot anticipated. The aircraft…NTSB MKC86LA091Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Salem, IAThe pilot states that the engine quit without warning as he was spraying a wheatfield. Pilot further states that he had very little time to pick a suitable landing area. He landed in hilly terrain and slid sideways into a crest, tearing out the right main…NTSB MKC86LA090Accident · No injuriesLimited investigationFinal reportCessna 172D · Garden Grove, IAThe plt stated that he was attempting a no-flap takeoff from his pvt strip when the wheels hit a wet spot. He said that the acft slowed down but he extended flaps and continued the takeoff. When he saw that he was running out of rwy, he aborted the takeoff…NTSB FTW86LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mt. Vernon, TXThe pilot reported landing at above normal speed, when he lost control of the aircraft at touchdown. The aircraft then veered off the runway onto wet grass. Do to the slippery conditions, the aircraft began sliding until it collided with a fence 100 feet from…NTSB CHI86IA121Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Detroit, MIWhile taxiing for takeoff a male pax panicked and shouted 'open the door!' During a smoke-in-the-cabin occurrence (overheated a/c pack). The lead fa mistook this 'instruction' as coming from the cockpit and opened an exit door. Passengers interpreted her…NTSB MIA86LA123Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Ocala, FLPurpose of the flight was to calibrate the spray equipment. The plt loaded the hopper with about 70 gallons of water and initiated a takeoff. At about 100 ft AGL on initial climb the cockpit filled with smoke and the eng failed. The acft struck a tree on…NTSB MIA86LA122Accident · No injuriesLimited investigationFinal reportCessna 172M · Borinquen, PRThe plt stated that after completing a local flt he landed on the rwy and noticed that the taxiway lights were inoperative where he wished to taxi. When he taxied off the rwy the propeller and landing gear struck a concrete culvert that was resting next to an…NTSB LAX86LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Colusa, CAThe pilot reported that while on a pipeline aerial observation flight he encountered moderate to severe turbulence, snow showers and freezing rain. When he attempted to depart the area the aircraft began to shudder and vibrate to the extent that any further…NTSB LAX86LA180Accident · No injuriesLimited investigationFinal reportCessna 150K · Joshua Tree, CAThe plt landed at the yucca valley arpt to refuel, but no fuel was available. The acft fuel gages registered 1/8 & 1/4 full, so the plt took off on a planned 7 min flt to another arpt. About 4 min after departing, fuel exhaustion occurred. During an emergency…NTSB LAX86FA178Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Beaumont, CAWhen the non-instrument rated plt departed for the flt at about 2110 hrs, the wx conditions were marginal and deteriorating in the area. No record of a wx briefing was found. For unkn reasons, the plt was returning to the arpt after about 1 hr and 20 mns,…NTSB LAX86DVA06Accident · Minor injuriesFinal reportBell UH-1B · Chowchilla, CAWhile returning from a spraying operation the plt observed that the main transmission oil pressure gage indicated zero. The plt reported that the engine master caution did not illuminate and that the oil temperature gage was normal. The plt stated that he…NTSB SEA86LA105Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORThe plt reported that after aprx 15 minutes of flt, the eng sputtered 2 or 3 times. An autorotation was performed onto rough terrain during which the tail rotor drive shaft was damaged by the main rotor blades. Post accident inspection revealed a hole in the…NTSB NYC86LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Westhampton Bch, NYThe instrument instructional flight returned to the airport late at night and successfully completed two instrument approaches with missed approaches. The pilots had been advised of a low layer of fog on the airport. On the third and final approach, after…NTSB NYC86LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hampden, MEAfter taking off, the plt initiated a climb & leveled off at 2500'. As he reduced power to cruise, the eng stopped running. All attempts to restart the eng were unsuccessful. Subsequently, the acft was damaged when the plt landed on rocky pasture land. Fuel…NTSB LAX86LA179Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Hesperia, CAThe acft collided with wires after an attempted go-around on apch to rwy 21. On short final to rwy 21 at aprx 20 ft AGL, a gust of wind blew the acft off the centerline of the rwy. The plt initiated a go-around by applying full power and rising the flaps from…NTSB FTW86FA066Accident · 2 fatalField investigationFinal reportGrumman G164A · Hankamer, TXTwo Grumman ag cats operated by the same air service collided in mid air. The accident occurred as one was departing and the other was returning to a temporary air strip adjacent to the fields they were fertilizing. Witnesses indicated that both pilot…NTSB ANC86LA046Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot stated that while doing a series of touch and go's, the aircraft veered on the runway; the pilot lost directional control of the aircraft causing the plane to nose over on its back.NTSB NYC86LA106Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · W. Milford, NJOn approach to Milford airport, the flight collided with power lines and crashed. The pilot made a missed approach then on second approach collided with wires, the pilot stated that it was dark and he did not see the wires until it was too late.NTSB NYC86LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Doylestown, PAThe pilot made a long landing and ran off the end of the runway. After departing the runway, he ran through a fence and hit a dirt embankment. The pilot said when he realized he was going off the end of the runway, he stayed on the brakes rather than add…NTSB NYC86LA102Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Newton, NJThe eng lost power during takeoff at an altitude of aprx 100 ft. subsequently, the acft settled into trees near the departure end of the rwy & was damaged. A post-acdnt exam of the acft revealed the fuel tanks were empty.NTSB MKC86FA088Accident · 5 fatalField investigationFinal reportPiper PA-31 · Norfolk, NEThe airplane departed on runway 31 with a low ceiling and visibility variable from 1/4 mile to 1/16 mile and winds from 290 degrees at 38 knots, gusting to 47 knots. A witness stated that the airplane was airborne no more than two minutes after the engines…NTSB MIA86LA138Accident · No injuriesLimited investigationFinal reportBell UH-1B · North Port, FLThe flt experienced an eng failure at an alt of aprx 8 ft AGL shortly after takeoff and the helicopter sustained substantial damage when a hard landing was made. Post accident inspection of the eng revealed the pwr turbine wheel experienced a loss of two…NTSB MIA86LA121Accident · No injuriesLimited investigationFinal reportCessna 340 · Ocala, FLWhile on a combination company business and training flight, the instructor seated in the right seat of the aircraft commanded the other pilot to execute a VFR go-around on short final. The other pilot added power to both engines and noted that the right…NTSB MIA86LA120Accident · No injuriesLimited investigationFinal reportCessna T303 · Bunnell, FLWhile on a dual instructional flight both instructor and the student pilot noted a left brake failure on taxi to takeoff. The instructor attempted to utilize asymmetric power to steer the aircraft but could not control the turn. The aircraft ran off the edge…NTSB DEN86LA117Accident · No injuriesLimited investigationFinal reportCessna 172H · Crossroads, NMAccording to the plt, he was attempting to underfly powerlines over a public road during landing, when the aircraft contacted an unseen wire and crashed.NTSB CHI86FER04Accident · Serious injuriesFinal reportPiper PA-28-181 · Brooklyn Center, MNWhen the aircraft experienced a total power failure due to fuel exhaustion and the pilot determined that it was not possible to make a forced landing on an airport, the pilot elected to land on a highway. The pilot stated that when he was not able to land in…NTSB BFO86FA023Accident · Minor injuriesField investigationFinal reportPiper PA-28R-200 · Camp Springs, MDDuring a flt to prepare the student for a CFI check ride, both the student and the CFI could not obtain a green light confirming the nose gear was down and locked. After numerous attempts to assure it was down and locked the acft was landed at andrews afb.…NTSB ATL86MA114Accident · 4 fatalMajor investigationFinal reportBell 206L-3 · Holliston, MAThe Cessna 172 and a Bell 206L collided at 2,000 feet over Holliston, MA. Both aircraft were operating under visual flight rules with no flight plan or communications established with air traffic control. According to witnesses, the Bell was traveling in a…NTSB ATL86LA113Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Appalachia, VAN7792E experienced a gradual power loss while en route to greenwood. S.c. via Appalachia, VA. The pilot reported that the engine quit and restarted for a few seconds after he had been flying about twenty minutes. This cycle continued for about two more…NTSB ANC86LA045Accident · No injuriesLimited investigationFinal reportCessna 180-H · Cordova, AKThe pilot stated that after lift off from the water, the left wing tip caught the water causing the aircraft to cartwheel and sink. At the time of the accident the wind was reported as 060 degrees at 15 knots gusting 35 knots.NTSB LAX86LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Snellings, CAThe CFI stated that he pulled the acft up to avoid birds and then lowered the nose to gain airspeed from 70 KTS back to cruise speed. During the dive the acft collided with a power line that crossed a river at about 50 ft AGL. After the collision the acft was…NTSB DEN86LA116Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Wall, SDAccording to the plt he was making a precautionary landing due to wx, when the acft he was piloting encountered an unexpected crosswind just prior to touchdown. The plt said the left wing dipped & made contact with the ground. The impact resulted in…NTSB CHI86FA120Accident · 2 fatalField investigationFinal reportLuscombe 8B · Pittsford, MIThe pilot overshot final approach due to a 10-15 kt tailwind on base leg. According to a pilot friend on the ground he put the acft into a 60 degree bank to in an attempt to realign himself with the final approach course. During this steep turn the aircraft…NTSB ATL86LA112Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Orangeburg, SCDuring landing the student pilot lost directional control of the aircraft in a crosswind and ran off the side of the runway and into a drainage ditch.NTSB ANC86LA044Accident · No injuriesLimited investigationFinal reportCessna 120 · Lake George, AKThe pilot stated that during a three point landing the main landing gear broke through a thin layer of ice into approximately six inches of snow and then the aircraft went over on its back.NTSB SEA86LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Pioche, NVWhile on a quarter mile final to runway 06 with winds from 150 degrees at 15 knots gusting to 30 knots the pilot experienced turbulence. The pilot reported he retracted the flaps from 10 degrees and added full power. The aircraft climbed approximately 20 feet…NTSB SEA86LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Reno, NVThe student plt lost control of the acft during high gusty wind conditions. The acft then veered to the right of the rwy. The wind at the time of the accident was from 280 degrees at 28 knots gusting to 31 knots.NTSB SEA86LA102Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Harlen, ORThe acft contacted trees and descended to ground impact during an attempted go-around. The go-around was attempted after the plt over shot the farm field in which he had intended to land.NTSB MKC86LA092Accident · No injuriesLimited investigationFinal reportCessna 172P · Omaha, NEThe plt stated he was attempting a night landing but after repeated trys he requested assistance on the radio. The plt further stated that the inoperative landing light compounded the trouble and he made a hard three point landing. Subsequent inspection of…NTSB MKC86LA089Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Springfield, MOThe plt stated that after landing on rwy 28 the left gear folded while taxiing. The acft then fell onto its left wing. The plt reported the gear collapsed without warning. Examination of the gear support found a joint which was cold welded had failed.NTSB MKC86LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · St. Louis, MOThe plt reports that a wind squall passed over the arpt as he was landing. He said the acft encountered windshear at about 100 ft AGL on final apch and began to sink. The plt added pwr but could not stop the sink and the acft landed in a plowed field about 20…