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 CHI87LA144Accident · No injuriesLimited investigationFinal reportCessna 182M · Lake Village, INThe aircraft bounced twice while landing on runway 36 and nosed over after the third bounce. Pilot reports being high on final with 20 degrees flaps so she applied full flaps and steepened glide angle. She also reports a northwest crosswind at 15 to 20 knots,…NTSB CHI87LA143Accident · No injuriesLimited investigationFinal reportCessna 172N · Prairie Duchien, WIWhile in cruise flight, tape which was holding a piece of plexiglass over the cracked windshield came loose. The windshield lifted up and the pilot was not able to maintain altitude. During the forced landing in a soft field. The nose gear sheared off.NTSB ATL87LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Sylva, NCThe CFI instructed his low-time beginning student to make a normal appch to the rwy, and fly down the rwy at about 10 ft above the rwy surface while maintaining rwy hdg. The CFI stated that the purpose of the maneuver was '...to help the student improve his…NTSB NYC87LA169Accident · No injuriesLimited investigationFinal reportCessna 414A · Binghamton, NYDuring takeoff roll, full throttle was applied to both engines but the left engine was slow to respond. When full pwr was not reached, the flight was aborted. The acft continued to roll off the dept end of the rwy and down a ravine. The plt stated that on the…NTSB LAX87LA233Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Porterville, CAA Cessna 150H collided with terrain after a loss of power. The pilot stated his tanks were indicating 1/4 when the engine quit. He further stated that he 'misjudged landing speed and elevation' and when he turned to avoid power lines, the aircraft stalled.…NTSB ATL87IA166Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Columbus, OHFlt attendant rpted smoke in cabin and pungent odor which dissipated. After descent for landing was begun smoke and odor returned. Pax informed flt crew of smoke intensity and precautionalry landing was made at divert field. Subsequent exam revealed that the…NTSB ANC87LA078Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot stated that he started his takeoff run in the middle of the lake. The aircraft overran the lake and ended up on the tundra approximately 75 yards from the lake shore.NTSB NYC87LA171Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Middlesex, NYThe pilot stated that a normal t/d was made at 75 mph abt 1/3RD of the way down the rwy. During rollout, the acft went through a dip and became airborne again. After touching down again, brakes were applied but the aircraft did not stop on the wet, freshly…NTSB MIA87LA179Accident · No injuriesLimited investigationFinal reportCessna A188B · Senatobia, MSThe plt stated that the acft was slow to climb after takeoff. He then dumped the load of chemical in an effort to clear trees. After clearing the trees the acft stalled and crashed into an open field. The plt also stated that there was no engine failure or…NTSB MIA87LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kissimmee, FLThe plt failed to lower the landing gear prior to touchdown. Insp of the acft revealed that the landing gear warning horn & gear down & locked light were inoperative.NTSB MIA87LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ruleville, MSWhile maneuvering the acft for a swath run after takeoff the plt stated that it was slow to climb. He then lowered the nose to increase airspeed, & realizing that the acft would not clear trees located ahead of the flt, elected to land in a field. Upon…NTSB MIA87LA175Accident · No injuriesLimited investigationFinal reportGreco Bruno Dolphin 1 · Miami, FLThe pilot stated that the acft stalled during the flare to touchdown, landed hard, & collapsed the rt main landing gear.NTSB MIA87FA176Accident · No injuriesField investigationFinal reportBell 206L-1 · Winter Haven, FLThe pilot stated that on short final approach the engine began surging and losing power. He attempted to stretch the glide and the aircraft landed hard, short of the intended point of touchdown. The engine was removed, examined, partially disassembled and…NTSB FTW87FA139Accident · 2 fatalField investigationFinal reportBeech V35A · El Paso, TXAcft experienced a complete pwr loss shortly after takeoff and subsequently struck a house during the ensuing forced landing. No evidence of mechanical failure or malfunction was found during the investigation. Evidence did indicate that one tank was either…NTSB ATL87DKG04Accident · No injuriesFinal reportBell TH-13T · Melvin, ALThe plt rprtd that after lndg to reload with herbicide, he got out of the helicopter to check the fuel in the tanks. After a visual inspn, he believed he had 'an adequate amount' of fuel to fly about 1/4 mi to the area to be sprayed, apply the chemical &…NTSB SEA87FA112Accident · Serious injuriesField investigationFinal reportCessna 150L · The Dalles, ORThe student plt's instructor became seriously ill after the first leg of a dual, cross country flight. Another instructor/pilot examiner signed off on the student pilot's logbook to return solo to the departure airport. The instructor/pilot examiner failed to…NTSB MKC87FA121Accident · Serious injuriesField investigationFinal reportTaylorcraft BL-65 · Hope, ARThe PIC had last student certificate and medical in 1978. On this flight with passenger, takeoff was made from rough hay meadow, 1372 feet long. When airplane could not climb over powerline at end of meadow, pilot decided to fly under powerline. Right wing…NTSB FTW87LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Norman, OKWhile performing a touch and go landing, the aircraft landed hard causing a vibration in the engine area, and some loss of rudder control. The pilot flew by the tower and the tower indicated everything looked ok. On landing roll the nose gear failed causing…NTSB DEN87LA146Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Grafton, NDThe plt was positioning the helicopter for an aerial application project. Before taking off, he checked the fuel quantity indicator & estimated there was 30 min of fuel on board. The proposed flt was estimated to take 10 min. During flt, the eng lost power &…NTSB ATL87LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Unity, OHThe CFI reported that he reduced pwr to near idle with the throttle, to have his student practice a simulated forced ldg. The engine subsequently lost pwr completely at about 400-500 ft AGL when he attempted to add pwr back so that the student could initiate…NTSB ATL87IA163Incident · No injuriesIncident investigationFinal reportPiper PA-34-200 · Birmingham, ALThe pilot reported that during a landing, he forgot to extend the landing gear. He was wearing a 'dave clark' headset with earplugs & did not hear the landing gear warning horn. During a subsequent check of the landing gear, it operated normally.NTSB ANC87IA077Incident · Minor injuriesIncident investigationFinal reportBoeing 727-90C · Anchorage, AKThe mechanic in charge of taxiing the Boeing 727 allowed an unauthorized avionics technician to occupy the pilot seat. They inadvertently deactivated the brake pressurization system and struck a passenger jetway at the terminal gate. An ensuing fire destroyed…NTSB ANC87DAG02Accident · No injuriesFinal reportde Havilland Beaver U-6A · Sparrevohn, AKThe pilot stated that just prior to touchdown he encountered a wind shear. The acft stalled and crashed on the gravel bar.NTSB SEA87LA111Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 MK.1 · Sedro Woolley, WAShortly after takeoff a loss of power occurred and the aircraft struck trees in flight. Less than 1/2 fuel was available in all three fuel tanks. The fuel selector valve was tested and found that the selections plate was indexed off center for all selections…NTSB NYC87LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Grove City, PAThe plt rprtd that while on final apch to lnd at night, the acft stalled. He stated that he applied full power, but the acft 'just dropped.' It struck the ground short of the rwy. Drg impact, all three gear collapsed, the rgt main spar was damaged & the lower…NTSB MKC87LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Ankeny, IAWhile practicing take offs and landings, CFI and student experienced engine failure shortly after take off. An emergency landing was initiated, and during forced landing attempt the aircraft was substantially damaged. The CFI stated the engine quit due to…NTSB LAX87LA353Accident · 1 fatalLimited investigationFinal reportCessna 172P · Independence, CAThe acft was rprtd missing after it departed san jose, CA, at about 1852 PDT on 6/9/87. A search was initiated, but the plane was not found until the wreckage was discovered by a hiker on 6/30/90. The acdnt occurred near kearsarge pass at an elev of 12,000…NTSB FTW87LA136Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Brownwood, TXThe engine failed during cruise flight due to fuel exhaustion. During the forced landing to a pasture the right horizontal stabilizer hit a tree and a limb became jammed between the stabilizer and the elevator jamming it in the full nose down position. The…NTSB FTW87DRA03Accident · No injuriesFinal reportGrumman G-164B · Egypt, TXAcft experienced a power loss drng an aerial app maneuver. During the ensuing emerg lndg, the left wing struck high weeds on the shoulder of a road, veered left into a ditch, and flipped over. Investigation revealed no. 7 cylinder had a pre-existing crack in…NTSB ATL87LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Franklin, NCA 17 inch portion of one of the prop blades fractured and separated from the 76 inch dia prop while the acft was at cruise. During the forced landing the acft struck a fence post. Examination of the prop revealed the presence of filiform corrosion across the…NTSB ATL87LA165Accident · No injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHPIC rpted he flew over airport and noted wind direction as 290-300 degrees on wind indicator. He entered downwind for rwy 31 at uncontrolled field. Normal approach flown with full flaps on final with left crosswind correction. About 30-40 feet above rwy, acft…NTSB ATL87LA162Accident · No injuriesLimited investigationFinal reportBeech V35B · Lexington, NCThe airplane encountered rough terrain and impacted trees during a forced landing attempt in a field. The plt reported that the engine had lost pwr at 8,500 ft MSL. Post-accident exam of the engine revealed that the #1 cyl barrel had cracked and separated…NTSB ATL87FA160Accident · 1 fatalField investigationFinal reportGlobe Globe GC-1A · Pleasant View, TNUpon returning from a short local area flight the aircraft was observed as it buzzed the owners private airstrip, where the passenger waved to his family. The plt pulled up sharply and made another low pass. This pullup was straight ahead. The climb peaked…NTSB ANC87LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Salcha, AKThe pilot was indecisive during his attempted takeoff. He first elected to abort the effort, then changed his mind and added full power to continue the take off. The airplane rose a few feet off the river bar before stalling and crashing into the river.NTSB SEA87LA110Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Aurora, ORDuring climbout at about 500 feet AGL for a touch and go, a loss of power occurred. Forced landing was accomplished onto a rough field where the left wing struck a small tree. The aircraft spun around and the nose gear and main gear collapsed. Examination of…NTSB NYC87LA163Accident · No injuriesLimited investigationFinal reportSchweizer ASW-20 · Middletown, NYThe glider pilot failed to hook up the elevator control cable before launch and during takeoff there was no pitch control. The aircraft pitched up uncontrollably overstressing the rope. The rope broke and the glider impacted hard on a road bouncing 150 feet…NTSB NYC87LA162Accident · No injuriesLimited investigationFinal reportCessna 182 · Vera Cruz, PAThe plt rprtd that while en route at 3500 ft, the eng began to vibrate. About 1 min later, oil started covering the windshield & the cockpit began filling with smoke. He shut down the eng & looked for a place to land. Before landing, he restarted the eng, but…NTSB MKC87LA123Accident · No injuriesLimited investigationFinal reportBeech C35 · Spencer, IADuring ldg, PIC failed to maintain directional control and swerved off the rwy. Ldg gear collapsed and acft was substantially damaged. Witnesses said plt and pax were behaving irrationally prior to lvf departure apt. PIC left the scene of accident and two…NTSB MKC87LA120Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Mediapolis, IAThe PIC attempted to depart downwind on a rural farm landing strip during an aerial application operation. The acft failed to attain flying speed and the acft struck a fence and ditch beyond the airport boundary.NTSB MIA87LA174Accident · No injuriesLimited investigationFinal reportCessna 172P · Tallahassee, FLWhile taxiing to take off the left wing collided with an utility pole.NTSB LAX87LA232Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Rancho Calif, CAThe plt elected to make a precautionary landing due to deteriorating wx along his route of flt. He stated that there was a x-wind from the left when he landed on rwy 30. Drg the landing, the acft drifted off the rwy & one of the main landing gear mired in…NTSB LAX87LA231Accident · Serious injuriesLimited investigationFinal reportMooney M-18L · Maricopa, CADuring a pleasure flight the plt stated that while on final approach to a private airstrip, he noticed some turbulence. On short final the plt stated that a severe wind shear dropped the acft into a ravine. The plt added full pwr, however, the acft did not…NTSB LAX87LA228Accident · No injuriesLimited investigationFinal reportCessna 120 · Fresno, CAA Cessna 120 landed left of the runway on a rough dirt area and nosed over. The pilot indicated that the airport is not lighted. The runway is equipped with white reflectors and the taxiways are equipped with amber reflectors. The pilot stated he was unable…NTSB FTW87MA135Accident · 2 fatalMajor investigationFinal reportMBB BO-105CBS · Bay City, MIAcft was involved in EMS static demonstration at beaver township fire dept, near Bay City. Following demonstration, shortly after takeoff, the pilot attempted a steep downwind turn at low altitude. Reported winds at the time of the accident were 250 degrees…NTSB DEN87LA154Accident · No injuriesLimited investigationFinal reportMooney M20E · Harwood, NDThe plt was landing his Mooney M20E on a private grass airstrip. He said he lowered the manual landing gear and thought he felt the thumblock snap into place. Upon touchdown the landing gear folded up and the acft slid to a stop, resulting in substantial…NTSB CHI87LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Dodgeville, WIWhile landing on runway 30, the pilot reported that the wind shifted from a crosswind to a tailwind. During an attempted go-around the pilot lost directional control and struck a metal utility shed prior to impacting the ground.NTSB CHI87FA140Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Middleton, WIThe pilot had communicated with other pilots concerning the difficulties he was having with the winds. He had already attempted approaches to two other runways but had failed to complete a landing. He asked the pilot of a recent arrival for the wind…NTSB BFO87DIG05Accident · No injuriesFinal reportCessna 152 · Baltimore, MDThe student pilot, who had approximately 47 hours in the aircraft and approximately 8 hours as pilot-in-command, stated that after touchdown on runway 33R the aircraft veered to the right and departed the runway and collided with a ditch. The wind was…NTSB ANC87LA076Accident · No injuriesLimited investigationFinal reportMaule M-6 · Kenai, AKThe pilot effected a go-around during an approach to runway 01 in gusty surface wind conditions. During the second approach he landed and lost control at or near the demonstrated crosswind component limit for this airplane. The airplane ground looped and…NTSB SEA87LA113Accident · No injuriesLimited investigationFinal reportCessna 172P · Snohomish, WAThe pilot initiated a landing on a 2650 ft long runway in a 11-18 knot quartering tailwind condition. He flew the final approach too fast and flared prematurely. The acft floated down the rwy, landed hard and bounced twice. The plt lost control and the acft…