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.

NTSB SEA86FA155Accident · 2 fatalField investigationFinal reportAeronca 7AC · Mulino, ORThe pvt plt had been giving rides around the local area for about an hour. He had just dropped off one passenger and picked up another. The acft taxied from the ramp to the rwy 30 and made a normal takeoff. During crosswind turn the engine started to miss and…Jul 5, 1986 · N84463 · DestroyedNTSB NYC86LA175Accident · No injuriesLimited investigationFinal reportCessna T210C · Manville, NJDuring flight from princeton to kupper airport, aircraft suffered engine power loss for undetermined reasons. Aircraft crashed in an open field, causing substantial damage.Jul 5, 1986 · N2320S · Substantial damageNTSB NYC86LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · West Dover, VTShortly after liftoff, the aircraft encountered a tailwind and downdraft forcing the aircraft downward and subsequently impacted trees and collided with the ground.Jul 5, 1986 · N43792 · Substantial damageNTSB MKC86LA171Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Iowa City, IAThe flight instructor stated that he had planned to conduct an engine-out drill after takeoff by reducing power to the starboard engine. During the engine-out drill the student reduced power to the operating engine and the aircraft landed hard back on the…Jul 5, 1986 · N1130P · Substantial damageNTSB MIA86FA200Accident · 1 fatalField investigationFinal reportGrumman G-164B · Vega Baja, PRThe plt of the Grumman ag cat allowed 2 parachutists to board the resticted catagory acft for a parachute jumping flt. Each parachutist was positioned on a wing with his arm crooked around the respective wing center strut. After takeoff, the parachutist on…Jul 5, 1986 · N6915K · No damageNTSB LAX86LA312Accident · No injuriesLimited investigationFinal reportMooney M20F · Cloverdale, CAThe acft collided with wires following a loss of control. The plt indicated that he was following a river at 1,500 ft MSL at a slow airspeed when the stall warning sounded. The plt stated that he lowered the nose in a downdraft and recovered close to the…Jul 5, 1986 · N6762V · Substantial damageNTSB LAX86FA278Accident · 4 fatalField investigationFinal reportBeech C24R · Meyers, CAWith a density altitude of about 8400 ft, and an aircraft near its max certificated gross weight, the plt & 3 pax departed on rwy 18. During takeoff either the pilot's door was not closed or it came open. The open door degraded the acft's climb performance.…Jul 5, 1986 · N66287 · DestroyedNTSB DEN86LA191Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Provo, UTPlt and three pax flew from el paso, TX to Provo, UT en route to Alaska vacation. Left main tire blew after acft touched down. Acft veered to left and went off rwy. Examination of tire revealed large hole but with good tread remaining. Acft damage was…Jul 5, 1986 · N8253J · Substantial damageNTSB DEN86LA189Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Hurley, NMDuring landing, one of the paxs in the Balloon basket suffered a broken ankle. Plt says landing was a normal rip out landing. Neither he nor pax knows how injury occurred.Jul 5, 1986 · N37486 · No damageNTSB ANC86LA101Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Hope, AKThe plt stalled the acft during final apch to a small gravel airstrip. The plt had not received training as a student plt nor did he hold any FAA plt or medical certificate.Jul 5, 1986 · N936C · DestroyedNTSB MKC86LA143Accident · No injuriesLimited investigationFinal reportBeech C23 · Cheney, KSThe pilot stated that the aircraft was barely airborne as it reached the end of the airstrip, on the takeoff roll. At this point he encountered crosswind conditions and the aircraft mush/stalled and impacted the ground. Post-accident computations reveal that…Jul 4, 1986 · N66353 · Substantial damageNTSB MIA86FA199Accident · Serious injuriesField investigationFinal reportRobinson R22 · Islamorada, FLWitnesses reported seeing the helicopter flying at approximately 8 to 10 feet off the water. The helicopter entered a left turn and as the turn progressed the helicopter descended striking the water with a skid and cartwheeling.Jul 4, 1986 · N2385X · DestroyedNTSB LAX86LA285Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Lincoln, CAThe student pilot indicated that this was his first solo flight. He had accumulated a total of 6.8 hours of flight time prior to this flight and he had flown earlier in the day with his flight instructor. After two landings with the flight instructor, the…Jul 4, 1986 · N91360 · Substantial damageNTSB DEN86LA188Accident · No injuriesLimited investigationFinal reportPiper J-3 · Ashland, MTPlt did not possess a plt certificate or medical certificate. The plt stated that he fueled the acft with the 'last gas in the storage tank.' The plt preflighted the acft and took off. Shortly after takeoff the engine lost power. The plt executed a landing in…Jul 4, 1986 · N40660 · Substantial damageNTSB DEN86LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Richfield, UTPlt stated after the accident, '...I noticed the wind sock and it was drooping...I went to final approach (for rwy 1) ... Noticed a little wind so I crabbed into it, and I noticed my approach didn't look good so I went to do a go-around. I went to raise the…Jul 4, 1986 · N8291E · Substantial damageNTSB CHI86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fraser, MIAircraft nosed over during an attempted downwind dead stick landing on an airport after running out of fuel. The aircraft landed at midfield and was unable to stop before running off of the end of the runway.Jul 4, 1986 · N9499T · Substantial damageNTSB CHI86FEX09Accident · Serious injuriesFinal reportCessna 150F · Marion, INThe plt rprtd that while circling around farm fields, he entered a turn & was looking behind the acft when it entered a power-on stall, then began to spin. Rprtdly, the acft was in a nose high attitude when it stalled. The plt stopped the rotation & was…Jul 4, 1986 · N8602G · DestroyedNTSB CHI86FEM10Accident · Minor injuriesFinal reportPiper PA-25-235 · Ionia, MIDuring initial banner pick-up of a banner towing operation the tow cable fouled the rudder control mechanism. The rudder was jammed and the banner release mechanism failed to operate. The aircraft impacted the ground left wing first and was substantially…Jul 4, 1986 · N4811Y · Substantial damageNTSB CHI86FEE05Accident · Serious injuriesFinal reportEipper Mxii · Aurora, ILDuring cruise flight the ultralight experienced an inadvertent deployment of the drag chute accompanied by a failure of the drag chute to inflate. This resulted in an uncontrolled descent and subsequent impact with the terrain.Jul 4, 1986 · N4976X · Substantial damageNTSB CHI86FEC04Accident · Serious injuriesFinal reportCameron 77 · Hamburg, MIPlt made a precautionary landing reportedly due to high winds. Upon touchdown the basket tipped and one of the pax received a fractured left leg.Jul 4, 1986 · N340CB · No damageNTSB ATL86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Van Wert, OHThe plt reported that his airspeed was too high on ldg and that the acft brakes failed to function when he tried to stop the acft. The plt turned the acft off the rwy into a soft grassy area as the acft neared the rwy end. Another plt who witnessed the…Jul 4, 1986 · N9835D · Substantial damageNTSB ATL86LA191Accident · No injuriesLimited investigationFinal reportCessna 337F · Cherry Point, NCWhen the gear selector handle was placed in the up position the gear unsafe warning horn sounded. The plt reported a stall warning horn to ATC and returned to the airport and landed. Finding nothing wrong with the aircraft the plt. Took-off again. Whenthe…Jul 4, 1986 · N1770M · Substantial damageNTSB ATL86IA190Incident · Minor injuriesIncident investigationFinal reportSwearingen SA-26AT · Waycross, GAThe pax had received instructions by the plt on how to open the cabin door. The acft was shut down on the ramp and the pax attempted to open the cabin door. The latch was turned; the door began to fall open and the pax caught the door step channel at a hinge…Jul 4, 1986 · N20EF · No damageNTSB ANC86LA099Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Barrow, AKThe plt stated there were mechanical problems with the acft but it was decided to fly it back to another arpt for repairs. Enroute the plt shut down the right eng because of an oil leak. While attempting to crossfeed fuel, the plt accidently pushed the left…Jul 4, 1986 · N4109E · Substantial damageNTSB ANC86LA098Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Fairbanks, AKAfter touchdown on the runway, the pilot lost directional control of the aircraft which ground looped to the right. The right main gear was sheared off at the gear box during the ground loop.Jul 4, 1986 · N7935V · Substantial damageNTSB NYC86LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Block Island, RIThe eng lost partial power on the initial climb-out as the plt was taking off from rwy 28. He initiated a left turn back to the arpt, but the eng lost all power. Subsequently, the acft was landed in an area of brush & small trees near the west end of the…Jul 3, 1986 · N5533J · Substantial damageNTSB MKC86LA144Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Davenport, IAThe owner of the airplane had not flown since 1980 and was receiving instruction to become current and was to receive a bfr on this trip also. The airplane had been rebuilt after a forced landing and also had just received an annual inspection. The airplane…Jul 3, 1986 · N6FF · Substantial damageNTSB MKC86LA142Accident · No injuriesLimited investigationFinal reportStevens Akro · Conway, ARThe PIC stated he allowed the acft to develop a high sink rate on final approach to the rwy, and was late in applying pwr to arrest the descent. Subsequently the acft impacted the terrain and sustained substantial damage.Jul 3, 1986 · N6009N · Substantial damageNTSB MIA86LA198Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Okolona, MSWhile in cruise flt at 100 feet en route to the spraying area the engine 'spit' twice and quit completely. During a forced landing in a field the aircraft encountered mud and nosed over coming to rest inverted. The engine had 100 hours before it was to be…Jul 3, 1986 · N6603 · Substantial damageNTSB MIA86LA197Accident · No injuriesLimited investigationFinal reportCessna T210H · Cedar Key, FLThe student plt stated that he overflew the arpt to observe the direction of the wind as indicated by the wind sock. When he was unable to locate it, a landing was made on rwy 5 with a left quartering tailwind. Unable to stop, the acft left the rwy struck a…Jul 3, 1986 · N2228R · Substantial damageNTSB LAX86LA284Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Los Angeles, CAThe private plt had no prior experience at the Los Angeles intl. Arpt. & the plt was unknowledgeable of the existence of arpt motor vehicle traffic service roads. The plt was given an ATC clearance to taxi, & in the darkness the plt mistook a service road for…Jul 3, 1986 · N54203 · Substantial damageNTSB DEN86LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Tooele, UTAfter successive aircraft bounces during a touchdown phase of landing, the pilot lost control. The aircraft departed the side of the runway into an area of soft terrain. The landing gear nose wheel sank into the ground and the aircraft nosed over into an…Jul 3, 1986 · N5552E · Substantial damageNTSB ATL86LA193Accident · No injuriesLimited investigationFinal reportCessna 177A · Huntsville, ALThe acft had set on the ramp with little fuel in it for aprx one week. Just before the accident flt, the pilot took fuel samples, but found no water. He then taxied to the fuel pumps and added aprx 20 gal of fuel in each tank. Another fuel sample was not…Jul 3, 1986 · N30365 · Substantial damageNTSB ANC86LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sparrovahn, AKThe plt reported a total loss of pwr occurred while maneuvering over an area to observe the terrain. A forced landing was made on a gravel bar during which the acft nosed over. In his recommendation on how the accident could have been prevented, the plt…Jul 3, 1986 · N5472H · Substantial damageNTSB ANC86LA097Accident · No injuriesLimited investigationFinal reportCessna 305 · Figure Eight Lk, AKThe plt attempted an emergency landing on a lake following a partial pwr loss in-flt. During touchdown the plt lost control of the acft which nosed over on it's back and sank into the lake. The acft was not recovered from the water.Jul 3, 1986 · N5312G · Substantial damageNTSB NYC86FHD01Accident · 1 fatalFinal reportPiasecki Acft. Helistat 97-34J · Lakehurst, NJThe helistat, a hybrid a/c with 4 H-34 main fuselages attached to a frame along with a ZPG-2 helium filled envelope had just completed it first hover test flt successfully and landed. A pwr loss was noted on the no. 3 helicopter and the test was terminated…Jul 2, 1986 · N1897Z · DestroyedNTSB MKC86LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, IAThe student PIC was practicing touch and go landings at a pvt strip when on landing the PIC stated he lost directional control and veered off the left side of runway 33. The ensuing departure substantially damaged the acft. Rptd winds were 290 degrees at 10…Jul 2, 1986 · N64998 · Substantial damageNTSB MKC86LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Lake City, ARThe acft dptd the rwy normally to fertilize a nearby fld. The PIC stated that the acft lost pwr shortly into the climb and he had to make a forced lndg off airport. The PIC was unable to dump the load of fertilizer aboard before impact in a rice field. The…Jul 2, 1986 · N78MH · Substantial damageNTSB MKC86LA137Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Wynne, ARThe plt stated that he had been fertilizing rice crops the morning prior to the accident flt and that there was nothing wrong with the acft. He further stated that on the accident flt he had already initiated the takeoff roll, when he realized that the flt…Jul 2, 1986 · N4685B · Substantial damageNTSB LAX86LA277Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Garberville, CAThe student plt had just taken off on a training x-country flt when the main rotor tachometer needle decreased below the engine tachometer needle. He turned the helicopter to return to the arpt but was unable to maintain altitude and landed hard in rough…Jul 2, 1986 · N26186 · Substantial damageNTSB LAX86LA276Accident · No injuriesLimited investigationFinal reportCessna 320D · Compton, CAThe plt attempted a night landing after he was unable to extend the acft's landing lights. He stated that, over the end of the rwy at about 25 ft AGL, everything blended into a large black spot. As the plt attempted a go-around, the acft contacted the rwy,…Jul 2, 1986 · N4153T · Substantial damageNTSB DEN86LA183Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bynum, MTAfter the first landing on a gravel road for reloading liquid insecticide the pilot attempted to take off for an aerial application flight. During the take off ground roll the pilot observed that the left door was not properly closed. He momentarily reduced…Jul 2, 1986 · N7099Z · Substantial damageNTSB DEN86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Williston, NDDuring the telephone interview, the plt stated the eng of his crop duster quit due to fuel exhaustion and a forced landing was made.Jul 2, 1986 · N7131Z · Substantial damageNTSB BFO86FA038Accident · 4 fatalField investigationFinal reportBeech 95-B 55 · Lynchburg, VAThe non-instrument rated pilot filed an IFR flight plan into known and forecast IFR weather. During his second ILS approach to the airport, after the control tower had closed, he failed to utilize the aircraft radio to illuminate the approach lighting system.…Jul 2, 1986 · N133P · DestroyedNTSB SEA86LA161Accident · No injuriesLimited investigationFinal reportCessna T-188-C · Othello, WAAn engine failure for unknown reasons occurred during an aerial application maneuver. A forced landing was accomplished onto very rough, rocky terrain where the aircraft was destroyed during the landing sequence.Jul 1, 1986 · N9574J · DestroyedNTSB SEA86LA159Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Rexburg, IDDuring an aerial application turn the aircraft encountered a severe downdraft. Although the pilot lowered the nose of the aircraft, leveled the wings, added full power and dumped his chemical load, he was unable to climb. The aircraft then struck the ground…Jul 1, 1986 · N9621P · DestroyedNTSB NYC86LA167Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Lakewood, NJAfter returning to the airport, the pilot lost directional control during the landing and the aircraft veered off the runway. Subsequently, the aircraft struck a runway light and the left main wheel & left wing were damaged.Jul 1, 1986 · N5186X · Substantial damageNTSB NYC86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, RIThe plt intended to practice a short field landing & extended full flaps. Initially, his apch was higher & faster than normal. However, before landing, a high sink rate developed. The acft touched down hard, the right wing dropped & the acft started to turn…Jul 1, 1986 · N2428P · Substantial damageNTSB MKC86LA136Accident · No injuriesLimited investigationFinal reportFairchild SA-227 · Lincoln, NEFlare for touchdown ended short of the active rwy at Lincoln, Nebraska. The PIC rptd windshear on final but wind conditions were rptd as being 340 degrees at 15 KTS, a headwind for this landing. No mechanical control pblm was reportedly experienced during…Jul 1, 1986 · N243DH · Substantial damageNTSB ANC86LA096Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Alexander Creek, AKWhile landing on a river bar, the acft drifted to the left of the normal touchdown zone. Subsequently, the wheels entered soft sand and the airplane turned over.Jul 1, 1986 · N2806C · Substantial damage