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 NYC87LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-20 · Allaire, NJDuring landing roll, the pilot lost directional control. The aircraft veered off the runway to the left, collided with a tree and was substantially damaged.May 3, 1987 · N3618Z · Substantial damageNTSB MIA87LA156Accident · No injuriesLimited investigationFinal reportDouglas DC-6A · Ft.Lauderdale, FLThe plt stated that they had made a normal landing and on rollout experienced severe vibration from a nose wheel shimmy. The vibration resulted in substantial damage to the horizontal stabilizer spar attach points.May 3, 1987 · N43867 · Substantial damageNTSB MIA87LA155Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Panama City Bch, FLThe plt reported that shortly after takeoff the eng began to lose power, then failed. He then autorotated & set the helicopter down aprx 6 feet offshore. Examination of the eng logbooks by FAA personnel revealed that AD 62-23-02 which requires insp of the oil…May 3, 1987 · N43CD · Substantial damageNTSB FTW87LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Amarillo, TXAfter landing, the pilot attempted to taxi the aircraft to the ramp when he encountered strong gusty winds. The passenger and four linemen attempted to hold the aircraft down, but the winds blew the aircraft over inverted causing substantial damage.May 3, 1987 · N7259A · Substantial damageNTSB DEN87LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Missoula, MTThe private plt was practicing touch and go landings. While on a takeoff roll, a gust of wind lifted the right wing and pushed the acft off the rwy to the left. Directional control was lost and the acft taxied through high grass parallel to the rwy. The nose…May 3, 1987 · N7511D · Substantial damageNTSB CHI87LA120Accident · No injuriesLimited investigationFinal reportCessna 150J · Detroit, MIWhile on approach to Detroit city airport the #1 cylinder fractured and separated resulting in engine failure. The pilot made a forced landing in a field approx. four miles west of the airport. Examination of the broken cylinder revealed the mode of the…May 3, 1987 · N60023 · Substantial damageNTSB ATL87FA132Accident · 2 fatalField investigationFinal reportAeronca 7BCM · Georgiana, ALThe plts & pax of 2 acft were returning from an annual pleasure trip. Neither acft had a good comm radio. Shortly after takeoff, they enctrd fog. They flew above the wx until they were near their 1st refueling stop (greenville, AL). Both plts dscndd beneath…May 3, 1987 · N10521 · DestroyedNTSB NYC87LA139Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Valatie, NYThe Robinson R-22B took off from a open field, traveled 600 feet and struck suspended utility lines at approximately 25-30 ft. afterward, the helicopter was landed successfully. Other lines were approximately 1000 ft from the departure point. The pilot was…May 2, 1987 · N2442A · Substantial damageNTSB NYC87DHM02Accident · Serious injuriesFinal reportFokker DR-1 · Rhinebeck, NYThe plt was making his first takeoff in a Fokker DR-1 tri-plane. After becoming airborne he yawed right, then left, followed by the acft nose falling below the horizon. The acft was destroyed in the crash landing which followed. After the crash, the plt…May 2, 1987 · N2009R · Substantial damageNTSB MKC87LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Meade, KSAfter takeoff, the engine started losing power. During the turn toward a landing area, the airplane stalled, hit the ground to the right of the runway and flipped forward to the inverted position. A partial tear down inspection revealed that the intake valve…May 2, 1987 · N38687 · Substantial damageNTSB MIA87LA154Accident · No injuriesLimited investigationFinal reportCessna T210N · Apalachicola, FLThe plt stated that he departed panama city en route to tampa, FL, when the manifold pressure and oil pressure started to drop. He then turned towards Apalachicola to try to make it to the airport but was unable and made a forced landing in a swampy area aprx…May 2, 1987 · N4612C · Substantial damageNTSB MIA87FA153Accident · No injuriesField investigationFinal reportCessna 152 · Lantana, FLThe plt stated that he was at 60 KTS. With full flaps & just about to flare when somthing forced the nose down. He then pulled back on the controls, hit the ground, veered off the left side of the runway & collided with a C152 that was holding for takeoff,…May 2, 1987 · N152LG · 2 aircraft · Minor damageNTSB LAX87LA201Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZDuring and instructional flight on short and soft field landings, the pilot reported that during the landing roll an unobserved dust devil hit the aircraft. The aircraft was raised approximately 60 ft AGL. The instructor was unable to regain control and the…May 2, 1987 · N25111 · Substantial damageNTSB DEN87LA129Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mandan, NDThe pilot and his son were ferrying a recently purchased Boeing stearman to their home in Ohio. During landing roll, at an en route stop, a gust of wind lifted the tail section and the acft groundlooped. The left wing struck the runway and the acft was…May 2, 1987 · N75546 · Substantial damageNTSB CHI87LA121Accident · No injuriesLimited investigationFinal reportBeech 58P · Evansville, INDuring landing roll-out the left main and nose gear collapsed. The pilot stated in his report that he does not recall touching any switches on roll-out. However, upon exiting the aircraft, the pilot reported that the landing gear relay was tripped open and…May 2, 1987 · N6401H · Substantial damageNTSB NYC87LA137Accident · No injuriesLimited investigationFinal reportStearman PT-17 · Hampton, NHWhile on final approach, the plt stated that the acft encountered a moderate crosswind. At abt mid-field, the plt elected to make a go-around, however, due to windshear and/or downdrafts, the acft was unable to climb. The Stearman collided with several tall…May 1, 1987 · N3993P · Substantial damageNTSB MKC87LA100Accident · No injuriesLimited investigationFinal reportCessna 188 · Ottawa, KSThe acft was returning from an aerial application flt when the fuel line to the fuel filter disconnected. During the forced landing, the acft ran into a fence. The eng had been installed 100 flt hrs prior to the accident.May 1, 1987 · N9858V · Substantial damageNTSB MIA87RA152Accident · 6 fatalForeign investigationCessna P206 S/N P206-0009 · St. Johns, CanadaMay 1, 1987 · N2509XNTSB FTW87LA113Accident · Minor injuriesLimited investigationFinal reportBoeing 707-323C · Oklahoma City, OKAfter engine start ground personnel experienced difficulty disconnecting the airstart unit hose. The ground signalman left the view of the crew to assist the other men in an effort to disconnect the unit from the aircraft. The pilot assuming that all was…May 1, 1987 · N8404 · Substantial damageNTSB FTW87LA112Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Arcola, TXDuring landing roll the aircraft swerved to the right. The pilot applied the left brake and the aircraft nosed over inverted causing substantial damage. The pilot stated that the left brake locked. The reason for the brake seizure is undetermined.May 1, 1987 · N1346M · Substantial damageNTSB DEN87LA117Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Lamar, COThe commercial plt was on takeoff from a dirt strip with a fully loaded ag acft, for an aerial application flt. After lifting off prematurely, the acft settled to the rwy. The left wing struck a post skidding the acft to the left. After crossing an irrigation…May 1, 1987 · N2335X · Substantial damageNTSB DCA87MA029Accident · 4 fatalClass 1 · MajorFinal reportCessna 340A · Orlando, FLThe two acft, a Cessna 340A and a north American SNJ-4, collided in flt at aprx 3000 ft MSL over Orlando FL in VMC with a visibility of 7 miles. Both acft were in contact with and being radar vectored by Orlando approach control. The C-340 was in level flt…May 1, 1987 · N8716K · 2 aircraft · DestroyedNTSB CHI87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kentland, INPilot reported a loss of power approx. 10 to 30 feet above the runway. The aircraft came to rest along the left side and approx. 1500 feet down the 3500-foot runway. Inspection of the aircraft after the accident did not reveal any evidence of engine problems.…May 1, 1987 · N23781 · Substantial damageNTSB NYC87LA136Accident · No injuriesLimited investigationFinal reportBeech BE-18 · York, PAWhile the aircraft was being ferried from massy, Maryland to ankeny, Iowa, a loss of oil pressure on the left engine was experienced. A precautionary landing was made in a cornfield with the landing gear in the up position when the gear failed to extend. Fire…Apr 30, 1987 · N66PA · Substantial damageNTSB MKC87LA098Accident · No injuriesLimited investigationFinal reportCessna 172F · Blythville, ARThe eng started to slow down ten miles from the destination arpt and despite emergency measures, it stopped two miles out. The forced landing was in a plowed field and when the nose wheel dug in, the acft flipped forward to the inverted position. The…Apr 30, 1987 · N8800U · Substantial damageNTSB MKC87LA095Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brinkley, ARThe acft had 100 gallons of water onboard for the ag training flt. The plt has completed one spray pass and was half way through the turnaround when the acft stalled. It collided with the ground and flipped forward to the inverted position. The plt listed 80…Apr 30, 1987 · N2000A · DestroyedNTSB MIA87LA151Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Titusville, FLFlt experienced complete loss of power in both engines due to fuel exhaustion. While attempting a forced landing at an airport the aircraft touched down 200 feet short of the runway and then rolled up onto the runway. The aircraft was substantially damaged in…Apr 30, 1987 · N54552 · Substantial damageNTSB LAX87FA198Accident · No injuriesField investigationFinal reportMooney M20K · Long Beach, CAOn 4/28/87, after a flt from Long Beach to las vegas, the plt requested the left wing tank be svcd with 15 gal of fuel; no fuel was added to the rgt tank. Two days later, the plt took off on the return flt. Drg arrival at Long Beach, he was vectored for an…Apr 30, 1987 · N231MW · Substantial damageNTSB LAX87FA196Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Newhall, CAAt about 1440 PDT, the non-instrument rated plt depd antioch CA, on a flt to burbank, CA. No known in-flt communicationswere made until the plt contacted TRACON at 1725 PDT. At that time, he rprtd inbound at 7500' & requested a special VFR clnc to the arpt.…Apr 30, 1987 · N8444A · Substantial damageNTSB DEN87LA116Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Greeley, COThe plt departed with full fuel in the acft to practice aerial spraying techniques. After 45 mins of practice he returned to the arpt for landing. He said that prior to entering the traffic pattern he switched from the half-full right tank to the full left…Apr 30, 1987 · N9256W · Substantial damageNTSB CHI87DEP05Accident · Serious injuriesFinal reportJohnson Quickie 2 · Eau Claire, WIThe pilot was attempting to land the experimental aircraft when he lost control and impacted on the rwy. This was the first time the pilot had flown this aircraft. The pilot stated the aircraft 'refused to flare properly.'Apr 30, 1987 · N3262P · Substantial damageNTSB ATL87DKG03Accident · No injuriesFinal reportCessna 310D · Athens, GAThe acft was reportedly stalled about 30 ft above the rwy and a hard ldg was made. The multi-eng rated plt was practicing short-field ldgs under the instruction of a CFI in preparation for obtaining commercial certificate. The acft wings and fuselage…Apr 30, 1987 · N6752T · Substantial damageNTSB ATL87DEG05Accident · No injuriesFinal reportEnstrom F-28A · Wilmington, OHDuring a climbout the pilot reported a power reduction. The engine continued operating and the rotor RPM dropped as the helicopter climbed to 10 feet. The wreckage examination failed to disclose any system malfunction or failures. The pilot was attempting to…Apr 30, 1987 · N180Q · Substantial damageNTSB ANC87LA064Accident · No injuriesLimited investigationFinal reportCessna 206 · Pt. Mackenzie, AKThe pilot stated that during the takeoff roll on the beach the aircraft struck a sand bar causing the aircraft to nose over on the beach.Apr 30, 1987 · N51205 · Substantial damageNTSB SEA87LA087Accident · No injuriesLimited investigationFinal reportCessna 310L · Chiloquin, ORThe aircraft departed the end of the runway during landing roll. The aircraft then went down an embankment and through a fence. The right main gear collapsed with the aircraft turning 90 degrees before coming to rest. A tailwind was present during landing.…Apr 29, 1987 · N808AA · Substantial damageNTSB NYC87LA134Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Ellington, CTDuring an instructional flight, the instructor pilot simulated a forced landing at about 250 feet and 60 KIAS. The student pilot at this time entered an autorotation and the helicopter started to descend. Collective was pulled but this failed to stop the…Apr 29, 1987 · N9070F · Substantial damageNTSB MKC87FA094Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Neelyville, MOWitnesses stated that the p.I.c. had aborted several takeoff attempts while trying to depart to the north--the winds were originating from the southwest at approximately 5 mph. The aircraft eventually departed from, and almost used the full length of, runway…Apr 29, 1987 · N44213 · DestroyedNTSB LAX87LA199Accident · 2 fatalLimited investigationFinal reportHughes 369D · TamuningsA Hughes 369D, operated off of a fishing vessel, went out of control and crashed in the pacific ocean, nr guam. The accident was witnessed by the ship's captain. His statement indicated one of the main rotor blades separated in flt while the helo was orbiting…Apr 29, 1987 · N10995 · DestroyedNTSB LAX87LA195Accident · Serious injuriesLimited investigationFinal reportCessna 402A · Kahului, HIShortly after takeoff, the plt reqd an 'immediate downwind' to rtrn to the arpt & was clrd to land. When asked if equip-ment was needed, he replied, 'negative, sir, a little matter of fuel.' A witness said the acft appeared very low on final apch with both…Apr 29, 1987 · N4588Q · DestroyedNTSB LAX87DVA07Accident · No injuriesFinal reportGrumman G-164A · Tulare, CADuring a climbing 180 degree turn to the left, the engine lost power. The pilot attempted to land in a nearby field that had just been plowed. With insufficient altitude to turn FAR enough to line the aircraft up with the rows, the pilot touched down at a '20…Apr 29, 1987 · N8366 · Substantial damageNTSB DEN87LA115Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Roosevelt, UTDuring landing, as the acft neared the taxiway leading to the parking ramp, the plt applied brakes and the acft veered to the off the rwy. The plt then applied pwr in an attempt to takeoff. The acft paralleled the rwy for a short distance and after crossing a…Apr 29, 1987 · N4745J · Substantial damageNTSB ATL87LA129Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe aircraft landed with the landing gear in the up position when the pilot inadvertently failed to extend the gear. He had disarmed the landing gear warning system by pulling the system circuit breaker because it was activating at normal power settings. He…Apr 29, 1987 · N3240Y · Substantial damageNTSB ATL87FA130Accident · 2 fatalField investigationFinal reportCessna 182R · Kennesaw, GAN5511N was in the traffic pattern at cobb county airport-mc collum field and was near the turning point from crosswind to dwnd when it was struck by N52995. N52995 was making a straight-in entry into the downwind leg of the traffic pattern from the west with…Apr 29, 1987 · N5511N · 2 aircraft · DestroyedNTSB NYC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Portland, METhe pilot of the PA-23 was attempting an NDB approach into the Portland, ME. Int'l jetport. The wx was rpt'd as moderate turbulence and moderate or greater icing, the icing level was rpt'd from the surface to 16000 ft. prior to this NDB approach the pilot had…Apr 28, 1987 · N13808 · DestroyedNTSB NYC87DNC05Accident · Minor injuriesFinal reportPiper PA-18-135 · Greenville, METhe pilot was taking off from a lake during windy conditions. The aircraft stalled shortly after takeoff. The aircraft was about 60 feet above the surface. The nose dropped and the aircraft impacted the water. The pilot reported that there was turbulence…Apr 28, 1987 · N114 · DestroyedNTSB MKC87LA096Accident · No injuriesLimited investigationFinal reportRotorway Executive · Gerald, MOThe stu PIC was solo on a x-country flt when the eng backfired. The stu entered autorotation with low rotor RPM which accelerated the descent rate. The stu flared before touchdown but did not level the helo in time to land. The tailboom struck the gnd and the…Apr 28, 1987 · N4891H · Substantial damageNTSB MIA87LA149Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Daytona Beach, FLPilot made a hard landing at which time the left main gear collapsed. The aircraft then ground looped and ran off the runway. Post crash examination of the left main gear revealed it collapsed when a support brace rusted through from the inside of the tube.…Apr 28, 1987 · N3167E · Substantial damageNTSB MIA87FA150Accident · 1 fatalField investigationFinal reportPiper PA-11 · Hollandale, MSWitnesses stated that the acft circled a pond & dived once, then on a 2nd circling attempt, it made a short steep turn & went into a twisting dive into the pond. The passenger stated that they were flying at appx 100 to 150 ft above some fish ponds when the…Apr 28, 1987 · N5093H · DestroyedNTSB LAX87DVG04Accident · No injuriesFinal reportSchweizer G-164B · Pleasant Grove, CADuring an aerial application flight, the pilot reported that during a turn for the next pass over the field, the engine quit. The aircraft was turned into the wind and was landed on a rough plowed field. During the landing roll the aircraft nosed over. The…Apr 28, 1987 · N3633B · Substantial damageNTSB FTW87LA110Accident · No injuriesLimited investigationFinal reportLaw OSPREY-2 · Minden, LAPilot stated that he flared about ten feet too high and landed hard collapsing the main gear followed by the aircraft sliding off the runway and colliding with a ditch where substantial damage occurred.Apr 28, 1987 · N55889 · Substantial damage