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 FTW86LRD16Accident · No injuriesFinal reportGrumman G-164B · Abbeville, LAThe pilot stated he made a successful forced landing, due to loss of power, and then had to flip the aircraft to prevent colliding with a lateral (above ground irrigation system) with a water depth of about four feet. Subsequent engine examination revealed…Jun 17, 1986 · N48592 · Substantial damageNTSB FTW86LA111Accident · Serious injuriesLimited investigationFinal reportAyres S-2R · Liverpool, TXThe pilot was involved in a aerial application flt when the acft stalled during a turn. The pilot stated he had too much weight to execute the turn at the airspeed selected. The airspeed was aprx 10 KTS above stall speed at the time of the downwind turn. He…Jun 17, 1986 · N8935Q · Substantial damageNTSB DEN86FTK03Accident · 1 fatalFinal reportPiper PA-25 · Badger, SDThe acft nosed over during a forced landing after takeoff. The acft was landed straight ahead and rolled out into a standing pool of water 8-10 inches deep where it flipped over crushing the canopy and trapping the plts body. During post acc invest sediment…Jun 17, 1986 · N6120Z · Substantial damageNTSB CHI86LA157Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Griffith, INThe student plt & instructor (CFI) were on a dual instructional flt, practicing landings. During an apch to rwy 8, the student began to undershoot on final apch. As the helicopter was apchg a fence near the apch end of the rwy, he became alarmed & applied aft…Jun 17, 1986 · N2295U · Substantial damageNTSB CHI86LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grand Rapids, MNThe CFI and sp were returning from a transition. Enroute the #3 exhaust valve push rod failed. When the CFI smelled 'something burning' she shut down the engine. During the descent struck power lines. Acft ld in swampy terrain and nosed over inverted.Jun 17, 1986 · N52565 · Substantial damageNTSB CHI86FER11Accident · Serious injuriesFinal reportBell 47G-5 · Brooten, MNAccording to the pilot, the helicopter collective control failed to respond to a climb input to level off after a descent for an agricultural swath run. Fire and impact damage to the helicopter was extensive, however one broken rod end in the collective…Jun 17, 1986 · N8122J · DestroyedNTSB BFO86FA037Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edgewater, MDWitnesses indicated that the engine sounded normal during takeoff run but started to lose power shortly after liftoff. The aircraft departed on runway 30 at lee airport, annapolis, MD. The runway is 2400 feet long and beards creek is located about 200 feet…Jun 17, 1986 · N6959W · DestroyedNTSB BFO86FA036Accident · Serious injuriesField investigationFinal reportPiper PA-28-160 · Michellville, MDAfter circling around the airport, trying to raise somebody on UNICOM to find out wind conditions at the field, the pilot noted the lighted windsock indicator and elected to land to the north. The aircraft was observed to land long on the 2420 foot runway,…Jun 17, 1986 · N5444W · Substantial damageNTSB ATL86FA174Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-36 · Waynesville, OHThe plt was attempting to achieve a club duration/altitude gain goal and released from the tow plane at 1,000 ft as opposed to the requested 3,000 ft tow. The plt communicated with another glider plt in the area and stated he was getting low and had to land.…Jun 17, 1986 · N36175 · DestroyedNTSB ANC86LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · King Salmon, AKThe plt stated that after lift off the acft stalled. He then lost directional control and the acft contacted a ditch.Jun 17, 1986 · N2937P · Substantial damageNTSB ANC86FA081Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Lakecreek River, AKAccording to a witness on the ground, the pilot-in-command landed from west to east and after unloading the supplies decided to takeoff in the same direction. The pilot taxied down to the end of the runway and upon turning around the witness stated the tail…Jun 17, 1986 · N83377 · DestroyedNTSB ANC86FA078Accident · 1 fatalField investigationFinal reportCessna 207A · Saint Marys, AKThe pilot stalled the airplane while making a steep turn to avoid high voltage power lines. The airplane caught fire on impact and the air taxi pilot subsequently died of extensive thermal injuries. The plt was flying in formation with another acft at low…Jun 17, 1986 · N9699M · DestroyedNTSB MIA86MA182Accident · 2 fatalMajor investigationFinal reportHughes 369HE · Jacksonville, FLA LCL tv stn had hired the oper to provide a helicopter for use in broadcasting an airborne traffic show. The plt took off with a rprtr & a camera man aboard. Drg a live traffic rprt, the acft was hdg eastbound at slow speed ovr a downtownarea at aprx 400 ft…Jun 16, 1986 · N9045F · DestroyedNTSB LAX86LA255Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Quincy, CAThe commercial plt/cfi, attempted to takeoff when a left 40 deg, 15 to 25 knot crosswind existed. The plt lost directional control of the acft, & when attempting to abort the takeoff the acft's gear collapsed & the acft collided with a drainage ditch. The plt…Jun 16, 1986 · N97201 · Substantial damageNTSB LAX86LA254Accident · No injuriesLimited investigationFinal reportNorth American Navion A · San Jose, CAThe acft's engine failed aprx 10 minutes after takeoff. The acft collided with a utility pole during the forced landing that followed. Post accident inpsection of the acft revealed the fuel selector was positioned on the aux tank. The main fuel tanks were…Jun 16, 1986 · N91608 · Substantial damageNTSB LAX86FUG03Accident · 1 fatalFinal reportBensen-Jansen B-8M · Adelanto, CAThe acft collided with power lines crossing the airstrip at midfield and crashed on the rwy. A witness stated that the plt had been briefed on the pwr lines prior to the flt.Jun 16, 1986 · N2522 · DestroyedNTSB FTW86LA119Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS35OD · Theriot, LAThe pilot experienced a sudden yaw in the helicopter at cruise flight. The ng started winding down confirming an engine failure. The pilot had to extend an autorotation over a tree line, which caused the RPM to decrease, and made a hard landing in an adjacent…Jun 16, 1986 · N229EH · Substantial damageNTSB FTW86FA115Accident · 1 fatalField investigationFinal reportCessna P206C · Grand Chenier, LAThe aircraft impacted the marshy terrain while in a very shallow descent and wings level attitude and at a relatively high speed (I.e.,cruise). It then cartwheeled and slid to a stop. There was evidence of substantial engine power being developed at impact.…Jun 16, 1986 · N8621Z · DestroyedNTSB DEN86FA163Accident · 1 fatalField investigationFinal reportBeech C90A · Jackson, WYThe plt departed olathe, KS, en route to Jackson, WY. The plt radioed the denver efas and reported his position as 56 miles northwest of casper, WY. There was no further radio communication with N114CM. The plt's wife stated after the accident that the plt…Jun 16, 1986 · N114CM · DestroyedNTSB CHI86FET03Accident · No injuriesFinal reportEdward R. Merkner MUSTANG-II · Valparaiso, INAfter three apparent hard touch-&-go landings, the left main landing gear collapsed on the fourth & final landing. The pilot stated that there were no mechanical malfunctions of the aircraft prior to the accident.Jun 16, 1986 · N9021A · Substantial damageNTSB ATL86LA173Accident · No injuriesLimited investigationFinal reportPitts S-15 · Raleigh, NCDuring normal cruise VFR flight at 1,500 ft AGL, the pilot reported hearing an erratic hissing sound and the acft began losing fuel pressure. The aircraft lost power and a forced landing was made into a field. The right main landing gear dropped into a hole…Jun 16, 1986 · N73BJ · Substantial damageNTSB ATL86LA171Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Apex, NCThis was the first flight for the passenger. After about one and one-half hours en route the weather ahead deteriorated and the pilot turned to return to the departure point. Weather prevented a landing there so he turned to another airport. It too was in an…Jun 16, 1986 · N5447W · DestroyedNTSB ANC86LA079Accident · No injuriesLimited investigationFinal reportCessna 185F · Naknek, AKAirplane ran out of fuel on one tank. Altitude was too low to restart on other tank prior to ground impact.Jun 16, 1986 · N70438 · Substantial damageNTSB ANC86LA077Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Vogel Lake, AKAfter takeoff from a small lake the pilot stated that engine started to run rough. The pilot stalled the aircraft and crashed into the lake. Examination of the engine revealed that the number 4 cylinder primer port plug was broken.Jun 16, 1986 · N1556N · Substantial damageNTSB ANC86FA080Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Settlers Bay, AKThe instructor (CFI) gave the front seat plt a simulated forced lndg while the airplane was aligned with rwy 20 & the wind. The front seat plt elected to fly a traffic pattern to rwy 2. As the front seat plt maneuvered to line up with rwy 2, much alt was lost…Jun 16, 1986 · N11864 · Substantial damageNTSB SEA86LA148Accident · No injuriesLimited investigationFinal reportMooney M20-C · Paradise Valley, NVA forced landing was made due to a very rough running engine accompanied by backfiring. It was discovered on engine examination that the spark plugs were worn beyond service limits. During landing roll a cattle guard was struck with the wing tips.Jun 15, 1986 · N6263U · Substantial damageNTSB NYC86LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Palmer, MAThe acft climbed in an excessively nose high attitude upon rotation at 60 mph. It then veered left and settled to the left side of the rwy. The plt reduced the power to idle and applied braked. The acft continued to slide and collided with trees. The acft was…Jun 15, 1986 · N1866T · DestroyedNTSB MKC86LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Liberty, MOThe instructor stated that the student had done well during this dual session, and he felt that traffic pattern airwork would be appropriate. Traffic pattern entry and letdown were normal, but the student got too low and slow on the full flap final approach.…Jun 15, 1986 · N68729 · Substantial damageNTSB LAX86LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Glendale, AZThe pilot said that during the takeoff roll on the 2,400 foot long runway he noticed the aircraft aceleration was slow and the airspeed was still below 55 KTS at 3/5 of the way down the runway and he elected to abort the takeoff. The aircraft overran the end…Jun 15, 1986 · N8156E · Substantial damageNTSB LAX86LA246Accident · No injuriesLimited investigationFinal reportBellanca Kcab · Taft, CAThe citabrea bounced on landing and ground looped on the runway. The pilot indicated that on touchdown the aircraft bounced. Throttle was advanced and on the second touchdown the aircraft veered left. The left wing rose placing the aircraft on the right main…Jun 15, 1986 · N8780 · Substantial damageNTSB FTW86LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · Mineola, TXThe student pilot was practicing touch and go landings when he lost control of the acft on landing. He stated he lost directional control due to windy conditions. However, winds in the area were reported to be calm. The aircraft veered off the runway damaging…Jun 15, 1986 · N25512 · Substantial damageNTSB DEN86LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMThe plt stated that shortly after takeoff the engine began running rough and she was cleared by the tower to land on any rwy. The plt chose rwy 10. She added one notch of flaps over the rwy threshold and the acft continued to float, touching down with 1/3 of…Jun 15, 1986 · N52985 · Substantial damageNTSB CHI86LA155Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Indianapolis, INThe plt with one hr PIC time in the tail wheel acft began to veer to the left during t.o. roll. He applied left brake instead of rt rudder ran off the rwy and struck a ditch.Jun 15, 1986 · N5370H · Substantial damageNTSB CHI86LA154Accident · No injuriesLimited investigationFinal reportGlasflugel Club Libelle 205 · St. Elmo, ILThere was a loss of thermal activity while the glider plt was on a x-country flt. During an off arpt lndg, the wingtip of the sailplane struck weeds. Subsequently, the acft ground looped & was damaged.Jun 15, 1986 · N8HD · Substantial damageNTSB ATL86LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Middle Bass Is., OHHeavy rains had flooded the causeway that connected Middle Bass island to the main island. A family was in need of transportation off the island and the pilot was attempting to fly them to the mainland using the 2,100 foot grass airstrip. The airstrip was wet…Jun 15, 1986 · N9135W · DestroyedNTSB ANC86LA076Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Egegik, AKThe pilot stated that after touchdown he lost directional control of the aircraft causing the plane to nose over. At the time of the accident there was a direct crosswind.Jun 15, 1986 · N3598M · Substantial damageNTSB NYC86LA151Accident · No injuriesLimited investigationFinal reportCessna 172 · Arcade, NYThe pilot landed on a wet runway that sloped slightly downhill. He stated that the aircraft touched down about 800 feet down the runway in winds that were from the west at 1 to 3 mph. The brakes were ineffective on the wet turf. Subsequently, the aircraft…Jun 14, 1986 · N13605 · Substantial damageNTSB MKC86FCA03Accident · 2 fatalFinal reportRobbins ACRO-DUSTER II SA750 · Fenton, MOThe aircraft was observed to go into a steep climb after departure from the runway. At 300 to 500 feet AGL, it nosed over and started a steep vertical dive into the ground. Examination of wreckage found no malfunction or failure of the aircraft. The pilot had…Jun 14, 1986 · N111TR · DestroyedNTSB MIA86LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Vaiden, MSThe plt stated that upon landing in a cow pasture he lost directional control of the acft. The acft collided with a vehicle located at the FAR end and off to one side of the pasture. The acft then traveled through a fence and a ditch before coming to rest…Jun 14, 1986 · N23930 · Substantial damageNTSB MIA86FA181Accident · 1 fatalField investigationFinal reportRobinson R22 HP · Lk Buena Vista, FLMotorists obsd the helicopter flying low ovr & along an interstate hiway. In the vicinity of a hiway rest area, the helicopter maneuvered to the side of the hiway, then flew back ovr the median. Two witnesses said it came to a hover, then started to continue…Jun 14, 1986 · N8400C · DestroyedNTSB LAX86LA257Accident · No injuriesLimited investigationFinal reportCessna 182L · Lodi, CAA acft collided with a gravel pile after overrunning the 2,070 ft asphalt rwy. The plt indicated that the wind sock at the arpt was indicating a variable wind direction from 200 deg to 230 deg. The plt elected to land on rwy 12. He stated he would have had…Jun 14, 1986 · N3496R · Substantial damageNTSB LAX86LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cucamonga, CADuring a pleasure x-country flight in the student plt's own acft, he elected to fly over a ridge of hills rather than via a longer route which circumnavigated the hills. While climbing enroute the plt entered a box canyon, experienced a downdraft and collided…Jun 14, 1986 · N4593R · DestroyedNTSB FTW86FPA22Accident · Serious injuriesFinal reportRutan LONG-EZ · Cedar Hill, TXShortly after takeoff and leveling off at 3000 ft MSL, the plt switched fuel tanks. Aprx 20 minutes into the flt a total loss of engine power was experienced. The plt attempted to land in a field; however, the acft contacted power lines during the descent.…Jun 14, 1986 · N23RY · Substantial damageNTSB DEN86FA160Accident · Serious injuriesField investigationFinal reportBeech C23 · Lamar, CODuring the takeoff climb, the plt's door came open. The pvt plt with 2 hours flying experience in C-23 acft made a close in traffic pattern to return for landing. During the turn from base leg to final the nose of the acft suddenly dropped and the acft…Jun 14, 1986 · N6337U · DestroyedNTSB CHI86FEM07Accident · No injuriesFinal reportCessna 188B · Bay City, MIDuring an ag spray operation, the plt flew over the area before starting his swath runs. On his first run, he flew over wires at the end of the field. On the return swath run, he attempted to fly under the wires. While doing so, the acft struck a newly…Jun 14, 1986 · N53140 · DestroyedNTSB BFO86FIG02Accident · Minor injuriesFinal reportAero Commander 560A · Easton, MDThe acft overran the end of the rwy and struck an embankment during an aborted takeoff. The plt reported that shortly after takeoff, the acft settled back on the rwy. He reduced the engine power to idle, raised the flaps and attempted to stop the acft to no…Jun 14, 1986 · N2756B · Substantial damageNTSB ATL86LA172Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Dillon, SCDuring landing roll, the plt reported, the rwy surface was wet and he was unable to stop the acft before departing the paved surface. According to published landing procedures, the plt would have needed aprx 1439 ft of paved surface for the landing roll. The…Jun 14, 1986 · N2034Z · Substantial damageNTSB ATL86LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · Pelion, SCThe private plt and student plt returned to the acft after pausing from landing practice for a soft drink. An engine start was attempted and a back fire occurred that started and induction fire. The intensity of the fire grew and the occupant exited the acft…Jun 14, 1986 · N30265 · DestroyedNTSB ATL86LA168Accident · No injuriesLimited investigationFinal reportAnderson Tierra II 1984 · Smith Station, ALThe acft's engine lost pwr shortly after t/o and a forced ldg was made in some saplings. The plt reported that he neglected to use the electric fuel boost pump during the t/o and subsequent pwr loss. He had previously installed the pump on the home-built acft…Jun 14, 1986 · N5291Y · Substantial damageNTSB ANC86LA075Accident · No injuriesLimited investigationFinal reportCessna 180 · Tanunak, AKThe plt stated that after touchdown he lost directional control of the acft which resulted in a ground loop and nose over.Jun 14, 1986 · N3887C · Substantial damage