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 ANC87FA009Accident · No injuriesField investigationFinal reportArtic Privateer S4 · Anchorage, AKThe acft desceded to terrain impact and nosed over following a loss of control as it climbed out of ground effect during takeoff. The plt reported he and his passengerds 'roped' frost off of the acft wings and other control surfaces prior to takeoff. Post…NTSB SEA87LA013Accident · No injuriesLimited investigationFinal reportCessna 180K · Burlington, WAPlt was taking off in fog from wet grass strip. Acft swerved left, plt unable to arrest with opposite rudder and brake, collided with fence. Abort not attempted.NTSB NYC87MA024Accident · 1 fatalMajor investigationFinal reportEnstrom F-28F · Manhattan, NYThe aircraft was contracted by nbc to make daily highway traffic observations in the new york city area. The pilot and passenger, an nbc radio traffic reporter, were flying in a northerly direction along Manhattan's west side at an altitude of about 75 feet.…NTSB MIA87LA012Accident · No injuriesLimited investigationFinal reportAyres SR-2-600 · Glen Allan, MSShortly after takeoff the pilot stated the engine failed and he executed a forced landing. Post accident examination revealed no fuel in the aircraft fuel system.NTSB LAX87LA024Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Gila Bend, AZThe acft veered off the rwy during takeoff ground run and nosed over. The plt inidcated that during the takeoff his seat slid rearward and he was unable to reach the throttle or the rudder pedals. The acft departed the rwy to the left into vegetated desert…NTSB LAX87LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZDuring a first solo instructional flight, the pilot was taking off from his third touch-and-go when at an altitude of approximately 10 feet AGL the right wing was suddenly rose. The aircraft then veered to the left. The left main gear then collided with a…NTSB DEN87FA007Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Crosby, NDCrosby municipal arpt was notam'd closed due to rwy construction and resurfacing. The plt and paxs were employees of the engineering company participating in the arpt construction. The plt of N8271P had landed on the closed rwy earlier in the day. The rwy was…NTSB CHI87LA008Accident · No injuriesLimited investigationFinal reportCessna 177 · Waukesha, WIAccording to the plt, it was a normal flight and approach to rwy 18. On touchdown, the acft nose dropped and the acft bounced three of four times. The plt stated that he immediately added pwr and became airborne, but a vibration caused him to cut pwr and land…NTSB CHI87LA006Accident · No injuriesLimited investigationFinal reportCessna 120 · Decatur, ILThe pilot stated that he was practicing crosswind landings on runway 24 when the airplane bounced twice. According to the pilot, he immediately added power and then lost directional control of the airplane and ground looped to the left. Following the ground…NTSB ATL87FA010Accident · 2 fatalField investigationFinal reportCessna 152 II · Pembroke, KYThe acft was observed shortly after departing the owner/operator's private landing strip. Witnesses rprtd hearing a sudden decrease in eng power, then a short time later, they heard the eng 'fire' or restart momentarily, but decrease in power again. The acft…NTSB ANC87LA008Accident · No injuriesLimited investigationFinal reportHughes 300-269B · Fairbanks, AKThe helicopter exhausted its fuel supply during climbout. During the ensuing autorotation landing, the rotor speed was allosed to decay and the helcopter spun at touchdown. It rolled over and failed the rotor blades.NTSB NYC87LA044Accident · No injuriesLimited investigationFinal reportCentrair 101A · Julian, PAThe pilot had decided to land following a 41 minute flt. The plt reported his airspeed was too fast during the landing apch and he over compensated which resulted in too slow of an airspeed. The glider touched down hard, became airborne and landed hard a…NTSB MKC87DCA01Accident · 2 fatalFinal reportCessna C-152 · Fredericktown, MOThe aircraft was being used to give relatives local area flights. The witnesses reported that the airplane had been doing low altitude maneuvers, stalls, and engine power cuts for over an hour. The witnesses observed the acft in a low altitude pass when it…NTSB CHI87LA007Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Lake Village, INThe plt stated that the acft would not start so he applied the acft hand brake and proceeded to hand prop the acft with no one aboard. While hand propping the acft, the engine fired and the hand brake did not hold. As the plt walked around the right wing, the…NTSB ATL87FKG01Accident · 1 fatalFinal reportJere L. Rosser Rand KR-2 · Kennesaw, GADuring initial climb the aircraft was observed at a high angle of attack at low altitude before descending in a stall/spin collision with the ground. Witnesses at the aprt reported that the engine sounded rough during the taxi and takeoff roll. The plt had…NTSB ANC87LA007Accident · 1 fatalLimited investigationFinal reportInterstate S-1B1 · Eureka Creek, AKThe pilot lost control of the aircraft on landing & it collided with a large metal sluice box that was located beside the runway. At the time of the accident, the wind was from the northeast & was gusty. The dirt ruway was frozen, rough &rutted.NTSB ANC87LA006Accident · No injuriesLimited investigationFinal reportShort Brothers SC7 · Nightmute, AKAccording to the plt-in-command (PIC), when the acft was on final apch to the 1600 ft rwy, it encountered a downdraft. Subsequently, the acft hit hard on the lip of the rwy, then bounced & touched down on the rwy. After the 2nd touchdown, the acft veered to…NTSB NYC87FA023Accident · 1 fatalField investigationFinal reportCessna R172K · Rockwood, TNThe aircraft was observed departing at approx 2010 hours, reversing course and flying over the airport at 300-400 ft AGL. The aircraft crashed 3/4 miles south of the airport in unpopulated, mountainous/hilly terrain at an elevation of 1560 feet, which is 104…NTSB LAX87LA022Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Big Bear City, CAThe acft veered off rwy 7 during landing roll. The plt indicated the acft veered to the right. There was a single rubber skid mark aprx 150 ft long found on the rwy. The wind was reported by another plt to be 'down the runway at 10-15 knots.' Examination of…NTSB CHI87DEM02Accident · No injuriesFinal reportLeblanc Dragonfly · Lansing, MIThe home built acft was on a test flt & was being flown by a plt with only about 2.5 hrs of flt time in this make & model. During the landing, the acft touched down hard & began to porpoise. The canard & wooden prop were damaged during the occurrence.NTSB ATL87FA009Accident · Minor injuriesField investigationFinal reportBell 206B III · Nashville, TNThe plt was in a descent toward a building in a downtown area which he wanted aerial photographs of. At about 1700 ft AGL he reported the helicopter jerked hard and yawed to the left. He initiated an autorotation and during the descent to the selected landing…NTSB ATL87FA007Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Nashville, TNThe flight was cleared for the localizer approach to rwy 31. The pilot reported the airport in sight. The flight descended into the cloud layer and crashed about 1000 feet short of the middle marker. The pilot did not report any aircraft problem. The approach…NTSB NYC87LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Port Matilda, PAThe aircraft experienced power loss for unknown reasons while cruising at 4500 feet MSL. An emergency landing was executed in an open field in a heavily wooded mountainous area. The aircraft was substantially damaged, and there was no fire. The pilot, being…NTSB MKC87LA009Accident · No injuriesLimited investigationFinal reportCessna 501 · Little Rock, ARThe PIC stated that he had to fly a faster than normal apprch to the outer marker for the ILS apprch as instructed by apprch control. Apprch cntl indicated that a Boeing 727 was no. 2 for the apprch and that the PIC should maintain 230 KTS till further…NTSB MKC87DCQ01Accident · 1 fatalFinal reportJames Olivier Quickie · Harper, KSA witness stated that he observed the aircraft in slow level flight at a low altitude. The a/c then pulled up in a steep right turn, then it descended to the ground. Examination of the wreckage found no pre-impact problems with engine or controls.NTSB LAX87LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Michigan Bar, CADuring a pleasure cross-country flight, the aircraft experienced an enging failure. Examination of the fuel tanks revealed that both tanks were empty of fuel. The carburetor was removed from the engine and found to contain approximately 1 tablespoon of fuel.…NTSB FTW87LA006Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Jacksboro, TXThe pilot reports that after a hard landing, the aircraft ballooned, bounced hard and veered off the runway due to gusty crosswinds. The winds for the area were reported to be from 140 degrees at 11 knots with no gusts.NTSB CHI87LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Galesburg, MIThe student plt reported becoming ill which resulted in her getting off course between flint, MI, and grand haven, MI, during a three leg x-country. The acft was not refueled upon reaching grand haven and fuel exhaustion occurred en route to coldwater. The…NTSB CHI87DEM01Accident · 1 fatalFinal reportBrown Acro Sport II · Grand Haven, MIAccording to the pilot after takeoff he leveled off to gain airspeed and then entered a 60 degree pitch up attitude. The pilot stated at about 400 feet AGL he noticed the airspeed was lower than 'normal'. Shortly thereafter the aircraft stalled and entered a…NTSB ATL87FA006Accident · No injuriesField investigationFinal reportCessna 140A · Hamilton, OHThe Cessna high wing was in the traffic pattern doing touch and go's and was on the third apch when the homebuilt biwing entered the traffic pattern. The homebuilt overtook the Cessna on short final. The collision occurred about 100-200 feet AGL. Both acft…NTSB ATL87DEG01Accident · No injuriesFinal reportCessna T210N · Cleves, OHThe plt reported that he initiated a go-around during an apch T0 a private strip. He stated that he misjudged the height of the acft and stalled it into trees and brush while climbing over rising terrain. He also said he was suffering from a cold and sinus…NTSB ANC87LA005Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chickaloon Flat, AKThe pilot-in-command refused to cooperate and would not submit an NTSB form 6120.1 nor would he discuss the accident except that he crashed upon landing. The plts med. Cert had expired.NTSB NYC87FA022Accident · 1 fatalField investigationFinal reportGulfstream American 112 · Beekman, NYThe acft departed dutchess county airport, poughkeepsie, NY, and had an engine failure due to inadequate lubrication. The oil filter was found disconnected from the engine. At duthess county airport parking area, fresh oil was found on the grass parking area…NTSB NYC87FA021Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Jamestown, NYThe non-inst rated plt had received a telephone wx briefing prior to the planned flt. Marginal VFR wx was forecast for the route with vis 1/8 mile and fog. The acft was located aprx 24 hrs later in a heavily wooded area about 200 yds east of and parallel to…NTSB MKC87LA008Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Macon, MOThe pilot stated that he encountered more severe crosswinds than planned upon landing and that he tried remedial action, including a rejected landing, but it came too late. The wind was blowing from the right on the landing roll as he shut down the engine and…NTSB MIA87IA011Incident · No injuriesIncident investigationFinal reportCessna 310R · West Palm Beach, FLWhile on an on-demand air-taxi flight the pilot noted that at touchdown the rt main gear was collapsing. He executed a go-around and attempted to lower the gear manually, but could not. The pilot then shut down the right engine and feathered the right…NTSB LAX87LA020Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Pacoima, CAThe plt refueled the acft, but was unable to restart the eng by using the battery. He hand propped the eng which started immediately. The acft began to move unattended & the plt clung to the left wing strut, but relinquished his grip after the acft moved aprx…NTSB LAX87LA019Accident · Serious injuriesLimited investigationFinal reportLake LA4-180 · Folsom, CADuring a local cross country pleasure flight, the pilot attempted a landing on Lake Folsom. Upon touchdown the aircraft began settling in the water then nosed over and sank. The pilot stated he felt there was an object in the water that was struck. Witnesses…NTSB ANC87LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · King Salmon, AKThe pilot was cleared to taxi his airplane into position and to hold behind a cherokee six airplane. After the cherokee six departed, he was cleared for takeoff. Immediately after lift off at 10 to 15 feet above the runway, the pilot stated the airplane went…NTSB MKC87LA006Accident · No injuriesLimited investigationFinal reportCessna 421C · Hot Springs, ARThe pilot stated that gear went down normally, he had three green lights and the gear warning horn was not on and he could see that the nose gear was down by looking in the nacelle mirror. After touchdown, the nose was lowered and as it touched the runway,…NTSB MKC87IA007Incident · No injuriesIncident investigationFinal reportSwearingen SA-226-TC · Springfield, MODuring the approach, the right main landing gear would not extend by normal or emergency means. Airplane was intentionally landed with all landing gear retracted. Inspection indicated gear doors pulled closed farther than normal due to right main landing gear…NTSB LAX87MA018Accident · 2 fatalMajor investigationFinal reportCessna 172N · Altadena, CAWhile rtrng to santa monica (smo) fm a x-country, the plts diverted to van nuys when the rwy at smo was closed due to a disabled acft. After the rwy was reopened, they filed an IFR flt pln to cont at 5000' & tkof at ngt. Drg dep, the AR-3 ctlr provided radar…NTSB ATL87LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Middlefield, OHStudent plt stated that he was preparing to land after a business x-country flt. On downwind he noted the wind sock ind a x-wind. Made a long final and did not notice x-wind. Stated that at flare he seemed to have a little tailwind since his spd was 85 KTS…NTSB NYC87FA020Accident · 2 fatalField investigationFinal reportCessna 182E · Fishers Island, NYA Cessna 182 taking off on rwy 25 collided with a Piper PA-28-181 which was landing on rwy 12. The collision occured in the intersection of the two runways. The two occupants of the Cessna were seriously injured and the two occupants of the Piper were fatally…NTSB MIA87LA010Accident · No injuriesLimited investigationFinal reportBuhl LA-1 · Belleview, FLThe plt stated that he had reached an alt of about 50 ft when the eng quit. He stated that while he was attempting to determine the cause of the problem, he stopped flying the acft & permitted a high sink rate to develop which was not arrested prior to the…NTSB MIA87FA009Accident · Serious injuriesField investigationFinal reportCessna 152 · Hattiesburg, MSThe student plt was on a supervised solo flt. He stated that he had always been 'scared' of landings & when he returned to the airport to land, the wind sock was standing 'straight out.' He later stated that he intended to continue flying and thought that he…NTSB LAX87LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Hana, HIDuring a solo instructional flight, the pilot was attempting to fly a course directly over a 10,400 foot mountain. At the 5,200 ft level the pilot encountered turbulence and noticed a cloud build-up over the mountain. The pilot then decided to divert to the…NTSB LAX87FA017Accident · 2 fatalField investigationFinal reportBell 206B-3 · Lompoc, CAThe helipad deck at the stern of the barge was covered with a loosely secured rope net and witnesses reported that as the helicopter lifted up to a hover the net came up 'caught on the rear of the left skid.' The acft was seen to hover for a moment with the…NTSB FTW87LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Lago Vista, TXThe instructor (CFI) & student had planned a 30 min flt to practice touch-&-go landings. During the initial climb after the 3rd touch-&-go, the eng lost power from fuel exhaustion. The CFI stated that he measured the fuel supply with a ruler drg the preflt &…NTSB NYC87LA019Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Leroy, NYFlight instructor simulating an emergency landing, landed on main landing gears and tail. Aircraft veered to the right off the runway and collided with bushes.