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 SEA87LA057Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyssa, ORDuring takeoff roll, a domestic sheep crossed the strip in front of the aircraft. The pilot cut engine power and maneuvered to avoid, but the animal crossed back in front. Contact with the propeller caused the aircraft to flip inverted.NTSB SEA87LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Mountain Home, IDAcft lost pwr on init climb from takeoff, necessitating a forced landing in an open field. Acft nosed over inverted after touchdown in soft terrain. Investigation revealed #3 cylinder rocker arm bosses had broken. Inspection showed, during previous repair,…NTSB MIA87LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe acft ballooned during the student plt's first touch & go landing. She then lowered the nose of the acft, after which, it began to porpoise. The acft then touched down, bounced, stalled, & landed hard collapsing the landing gear.NTSB CHI87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Oshkosh, WIAccording to the plt, at aprx 1800 feet 'the engine abruptly quit with no runon or sputter' following takeoff from rwy 18 at Oshkosh, WI. The plt stated that he banked the acft back to the airport, but the aileron controls became jammed or 'frozen'. According…NTSB CHI87FA083Accident · 4 fatalField investigationFinal reportCessna 172N · Fergus Falls, MNFollowing a 1.5 hour personal flight at night, the aircraft crashed into the side of a low hill near the destination airport. Although the pilot had a total of 6 hours of night time, most of his solo night time was during this last flight. Hazy VFR conditions…NTSB CHI87FA081Accident · Serious injuriesField investigationFinal reportBoeing 747-122 · Detroit, MIDrg flt, united flt 108 recd info of a bomb threat. Due to a short time limit, specified in the threat, the flt divertedto Detroit & the slides were used to evacuate the acft; 8 of 10 slides deployed nmly & were used. The slide at door 4R didn't inflate &…NTSB BFO87FA022Accident · 2 fatalField investigationFinal reportRobinson R22 · Myersville, MDThe non-instrument rated commercial pilot departed hgr in a Robinson helicopter that was not equipped to fly in instrument conditions. The pilot had not logged any instrument time and elected to depart in IFR conditions under a special VFR clearance. ATC…NTSB NYC87LA084Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Oxford, MAThe plt rprtd that drg a lndg, the acft enctrd a gust of wind & veered into a ground loop before he could correct the situation. The acft then hit a snowbank at the side of the rwy & was damaged. The plt rprtd the wind was from 300 deg at 12 gusting 15 KTS.NTSB NYC87FA085Accident · No injuriesField investigationFinal reportBeech 99 · Oneonta, NYThe flight was uneventful until its arrival at Oneonta municipal airport. The aircraft landed 10 feet short of runway 24IN one foot of snow. The left main landing gear collapsed, the propeller struck the runway and the aircraft veered off the left side of the…NTSB FTW87DPJ02Accident · Serious injuriesFinal reportAir Tractor AT-302 · Colony, OKDuring a downwind swath run the number one compressor bearing failed in the ltp 101-600-1A engine which resulted in the engine failing completely. During an attempt to turn into the wind for an emergency landing the left wing tip struck the ground and the…NTSB DEN87LA054Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Colo. Springs, COThe Balloon attempted a normal landing. The instructor plt diverted his attention while the student plt allowed the envelope to cool excessively. This gave a high rate of descent and the Balloon made a hard landing.NTSB DEN87LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Eureka, SDAfter normal takeoff, the acft contacted the terrain then continued on until it came to rest aprx 350' from the initial impact point. The landing gear had been retracted at the time of initial impact and the plt had no indication of any malfunction/failure.NTSB BFO87LA021Accident · No injuriesLimited investigationFinal reportCessna 310Q · Moundsville, WVOn touchdown the pilot realized that he was long but decided it was too late to go-around. He intentionally ground looped the aircraft to the right. Both ends of the runway drop off into a valley.NTSB LAX87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tulare, CAThe pilot attempted to land while the runway and VASI approach lights were off. The night was dark and he inadvertently landed on a roadway parallel to the runway. The aircraft collided with a fence when the road came to a dead end adjacent to the near…NTSB LAX87LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · El Monte, CADuring a local instructional flight, the pilot reported that while on the base leg to runway 19 the aircraft was a bit high but was corrected while on final approach. Upon landing the aircraft touched-down in a three point attitude and ballooned up. On the…NTSB BFO87DIG01Accident · No injuriesFinal reportCessna 152C · Gaithersburg, MDWhile taking off on rwy 32, the acft veered to the left & collided with a snowbank before the student plt could regain control. The student rprtd the winds were from 280 deg at 10 KTS.NTSB LAX87FA112Accident · 1 fatalField investigationFinal reportHughes 369D · Honolulu, HIDrg tkof clb, a loud noise occurred as 1 of 5 main rotors (mrb's) & the tail boom sepd fm the helicopter (hel). The hel then crashed & hit a submerged reef aprx 200' fm the heliport. An exam of the failed mrb showed its retention strap assy(rsa), pn…NTSB DEN87LA052Accident · No injuriesLimited investigationFinal reportCessna 185C · Cedar City, UTDuring normal descent at seven-thousand ft MSL, acft struck a bird. The left wing tip leading edge incurred a dent twenty-four inches long and twelve inches deep. Directional control became difficult so plt made a precautionary landing on highway I-15, and…NTSB SEA87LA055Accident · No injuriesLimited investigationFinal reportCessna 150E · Joseph, ORPlt was on first flight of season. After two hours flying, landing was attempted on dry hard-surface runway in slight tailwind. During roll-out, left drift developed. Use of right brake caused tail of acft to lift. Plt applied both brakes and acft nosed over…NTSB SEA87LA054Accident · No injuriesLimited investigationFinal reportRobinson R22 · Brinnon, WAWhen psgr became nauseous in flt, plt attempted downwind lndg onto pinnacle in rough terrain. Acft contacted slope short of intended point of lndg, main rotor flexed downward, severing tail boom.NTSB NYC87FA138Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Lanesville, NYThe plt and his family dptd 2/8/87 on a ski trip to VT. The flt did not arrive. The acft was fnd on a mtn plateau on 5/2/87. Wx conditions rptdly deteriorated and darkness was apching at the estimated time of the acdt, shortly after sunset. The acft impacted…NTSB MKC87LA049Accident · No injuriesLimited investigationFinal reportMooney M20E · St.Louis, MOThe PIC was clrd by twr to lnd rwy 30L. The twr advzd the PIC that his gear was not extended. The PIC rspnd with 'I know that and I have lost eng pwr too'. The acft subsequently impacted short of the rwy. FAA maint insp of the acft revealed no fuel in the…NTSB LAX87LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Tucson, AZDuring a local dual instructional flight, the pilot reported that the aircraft developed a vibration and a substantial power loss. The acft was forced to land off the arpt in the high vegetation. Examination of the aircraft revealed that the #3 cylinder was…NTSB LAX87LA111Accident · Serious injuriesLimited investigationFinal reportCessna T210L · El Cajon, CAThe plt indicated that he and his wife were planning to fly together, but at the last minute his wife changed her mind. She exited the acft and departed the area to the rear of the plane. The plt was taxiing from his parking spot when his wife suddenly…NTSB FTW87LA063Accident · No injuriesLimited investigationFinal reportCessna 172N · Bay City, TXAccording to the pilot, during flare/touchdown the aircraft was substantially damaged when he lost control of the aircraft due to a cross wind.NTSB CHI87FA070Accident · 3 fatalField investigationFinal reportMooney M20J · Waskish, MNDuring the preflight wx briefing the non-instrument rated pilot was advised that VFR flight was not recommended. Shortly before the accident, the acft was observed flying over a state highway under a low overcast in poor visibility. The acft was witnessed to…NTSB BFO87FA020Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Mount Airy, MDThe instructor pilot simulated an engine out emergency by retarding the throttle. The student, who had not soloed, became engrossed in handling the emergency. The instructor kept his hand on the throttle throughout the practice maneuver. When he applied full…NTSB NYC87LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Caldwell, NJThe student plt was on his 1st supervised solo flt. He stated that drg a touch-&-go lndg, he cleaned up the acft & applied power, but as the speed increased, the nosewheel began to shimmy & the acft veered to the left. The student said he shut-off the power &…NTSB NYC87LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Livingston, NYDuring landing roll, the aircraft encountered patchy ice on the runway surface causing the aircraft to skid out of control and impact a snowbank.NTSB NYC87LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Beverly, MAStudent pilot became lost and disoriented during enroute flight to the manchester area and landed at Beverly airport instead. During landing roll, the aircraft drifted to the left of the runway and collided with a snowbank, breaking off the nose gear and…NTSB NYC87LA078Accident · No injuriesLimited investigationFinal reportCessna 150C · Downingtown, PAA precautionary landing was made in a snow covered level field due to a loss of power for unknown reasons. The aircraft was substantially damaged.NTSB MKC87FA048Accident · 1 fatalField investigationFinal reportCessna A150K · West Memphis, ARThe airplane was making low passes over the edge of a trailer park and at the end of each pass, it would climb almost straight up and then make a steep banked turn and dive for another pass. At the end of the last pullup, the airplane made an abrupt steep…NTSB MIA87LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Venice, FLFull flap x-wind take off & landings were being conducted on rwy 13 with the winds at 210 to 220 degs at 10 KTS, or a right x-wind component of 80 to 90 degs. The student plt permitted the acft to get too slow while about 10 ft above the ground. A high sink…NTSB LAX87LA110Accident · 2 fatalLimited investigationFinal reportCessna 150L · Ayase, JapanDuring an instructional flight, just after take-off the instructor was heard to transmit over the radio 'request emergency landing.' At an altitude of approximately 15O feet AGL the aircraft was observed to pitch up then nosed down in a shallow left turn. The…NTSB LAX87LA109Accident · No injuriesLimited investigationFinal reportSchweizer 2-32 · Vacaville, CADuring a local sightseeing flight, the pilot was flying south approximately 300-500 ft above the ridge looking for lift. The pilot could not find sufficient lift in the area east of the ridge so he flew to the west side where the glider encountered a strong…NTSB FTW87LA056Accident · No injuriesLimited investigationFinal reportCessna T210L · Borger, TXAccording to the pilot, during flare/touchdown the aircraft was substantially damaged when the right brake jammed causing the aircraft to veer off the rt side of the runway and into a gulley. However witnesses stated that the aircraft came in fast and landed…NTSB FTW87FA064Accident · 2 fatalField investigationFinal reportCessna 210N · Diboll, TXAcft was destroyed when it impacted the ground in an uncontrolled attitude at high speed. The non-instrument rated pvt plt had filed IFR and departed into M80VC 5 l-f weather with tops above 8,000'. About 20 minutes after departure, the plt reported to the…NTSB FTW87FA061Accident · Serious injuriesField investigationFinal reportPiper PA-42 · Horseshoe Bay, TXThe pilot made a fairly long taxi from the ramp to the end of the runway and then started his takeoff roll with the parking brake still partially set. The brakes became very hot and the component parts expanded. After rolling almost 3,000 feet the brakes…NTSB DEN87LA051Accident · No injuriesLimited investigationFinal reportCessna 172 M · Air Force Acade, COWhile making a landing, the acft landed hard and began to porpoise. After the third bounce, the nose gear collapsed.NTSB CHI87LA080Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Big Fork, MNAfter several unsuccessful attempts to takeoff from a snow-covered lake, the plt found a plowed area leading to a fish house. He taxied to the area and began to takeoff towards the east. On lift-off, the left aileron struck the top of the fish house. The plt…NTSB CHI87LA079Accident · No injuriesLimited investigationFinal reportCessna 150K · Clear Lake, MNThe plt stated that near the touchdown point a gust 'jarred' the acft and the throttle in the forward position. According to the plt, the acft 'took a steep left' and he leveled the wings, however there was not time to avoid trees which were about 100-150…NTSB CHI87LA078Accident · No injuriesLimited investigationFinal reportCessna 182P · Utica, MIThe pilot experienced a loss of power to 900 RPM shortly after takeoff. The plt had climbed to 2000 ft and reduced power. When the RPM dropped to 900 RPM he applied carb heat to no avail. The acft was landed in a field 6 miles north of the departure arpt.…NTSB BFO87LA019Accident · No injuriesLimited investigationFinal reportCessna 152II · Clinton, MDThe plt stated he made a normal approach and touchdown. On roll-out, after the flaps were retracted, a pulling was noted to the left. The acft swerved off the left side of the rwy, collided with a snowbank, and flipped over. A witness located in the run-up…NTSB ANC87LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clear, AKThe pilot of the ski equipped airplane stated he taxied too fast after landing and damaged the airplane after the right ski toed into a large snow drift on rough surface ice.NTSB NYC87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Marlboro, MAThe pilot allowed the aircraft to stall and touch down hard causing substantial damage. The pilot was unfamiliar with the short field at this airport.NTSB NYC87LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Beaver Falls, PAThe pilot attempted a turn while taxiing and added power to taxi over soft ground. The pilot did not realize the close proximity of aircraft wing tip to the hanger. The edge of the right wing caught a part of the hanger and was substantially damaged.NTSB FTW87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Waxahachie, TXThe aircraft received substantial damage during an emergency landing. According to the pilot, the engine failed because of carburetor icing. Atmospheric conditions at the time of the accident were conducive to carburetor icing. No mechanical failure or…NTSB CHI87LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNDuring takeoff roll at about 50-55 KTS plt lost directional control. As the acft started going to the left, the plt applied the brakes. When the acft departed rwy 30, the nose wheel collapsed.NTSB ATL87LA070Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Florence, SCDuring the final leg of a domestic scheduled commuter airline flight the aircraft landed with the landing gear in the retracted position. The captain could not recall placing the gear selector handle in the down position and the co-pilot could not remember…NTSB NYC87LA077Accident · No injuriesLimited investigationFinal reportStinson 108 · Wildwood, NJThe plt rprtd that prior to takeoff, he taxied thru svrl puddles of water from melting snow. The temp at that time was rprtd as 25 deg. He rprtd that when he landed at Wildwood, the wind was from 290 deg at 15 gusting 20 KTS & the temp was 30 deg. He said…