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 MIA87IA185Incident · No injuriesIncident investigationFinal reportBell 47G-2 · Miami, FLWhile in cruise flt at aprx 300 ft the plt reported that he heard a loud noise followed by a loss of power. He then autorotated & set the helicopter down with no further incident. Insp of the eng revealed that the number 6 cylinder connecting rod failed near…Jun 17, 1987 · N17271 · Minor damageNTSB FTW87LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Red Oak, TXThe pilot stated the aircraft did not appear to lift properly. It gained about 50 feet altitude after liftoff but then settled back to the ground. The departure runway was concrete and was 1200 feet in length. The field elevation was 650 feet MSL and the…Jun 17, 1987 · N7992F · Substantial damageNTSB FTW87FA151Accident · Serious injuriesField investigationFinal reportCessna A188B · New Taiton, TXAcft was observed departing on rwy 35 of a 4,250' pvt ag strip after having been loaded to near capacity with 46% nitrogen fertilizer. Acft lifted off, crossed a fence parallel to the rwy and struck a fence that was perpendicular to the north end of the rwy.…Jun 17, 1987 · N731XQ · Substantial damageNTSB DEN87FA153Accident · No injuriesField investigationFinal reportConcept 70 · Durango, COThe plt reported that he had been flying for one hour and had been doing acrobatics. He had started an inside loop and during pull up, he reported indicating 5.5 g's on his new g meter. The plt reported that both wings left the acft and he jettisoned the…Jun 17, 1987 · N23405 · Substantial damageNTSB CHI87LA150Accident · No injuriesLimited investigationFinal reportHughes 300C · Aurora, ILWhile the student & instructor (CFI) were on an instructional flt, a decision was made to practice an autorotation & simulated tail rotor failure. Rprtdly, a smooth touchdown was made, but the helicopter began to vibrate. The CFI electedto get the helicopter…Jun 17, 1987 · N3625B · Substantial damageNTSB ANC87DAG03Accident · No injuriesFinal reportDenney FOX 1 · Palmer, AKThe pilot stated that after touchdown on the sand bar the aircraft struck an open ditch. The pilot lost directional control of the aircraft causing the plane to nose over on its back.Jun 17, 1987 · N4987 · Substantial damageNTSB NYC87LA175Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Croton Fall, NYAbt 15 minutes aft tkof, the eng started to lose pwr. All efforts to restart it were unsuccessful and the acft was forced to land in a landfill. During lndg roll the acft collided with a hole and the gear sheared off. Exam of the eng revealed a burned piece…Jun 16, 1987 · N1524R · Substantial damageNTSB NYC87LA174Accident · Minor injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe Cessna 172 is reported to have lost power after getting airborne while making a short field takeoff from a 1838 ft long runway. The student pilot told the operator he landed the aircraft on the remaining runway and ran off the departure end of the runway.…Jun 16, 1987 · N9638L · Substantial damageNTSB LAX87LA229Accident · No injuriesLimited investigationFinal reportCessna 180 · Kernville, CAThe plt rprtd that he made a precautionary landing on a remote airstrip after detecting smoke & an odor of burnt oil coming from the eng compartment. After landing, he determined the source of the odor was spilled oil on the exhaust & he elected to takeoff…Jun 16, 1987 · N2477C · DestroyedNTSB DEN87LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Monument Valley, UTThe plt landed to take pictures in Monument Valley off designated arpt. On takeoff the plt reported that the acft could not maintain sufficient altitude and that he had to make a forced landing. The plt did not report any mechanical failure or malfunction.Jun 16, 1987 · N2398D · Substantial damageNTSB CHI87DCA01Accident · Minor injuriesFinal reportBeech 3NM · Cahokia, ILThe acft experienced a loss of pwr in the rt eng immediately aft tkof. The plt was not able to feather the propeller and was forced to land in a wheat field on arpt property. Conditions were conducive to carburetor icing at the time of the accd. Investigation…Jun 16, 1987 · N37CB · Substantial damageNTSB ATL87LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hazard, KYThe plt observed the rear of the upper engine cowling lift up shortly after takeoff and he became concerned that the cowling might come off the airplane during flight. The pilot attempted to maneuver the airplane back to the airport to land, the airplane…Jun 16, 1987 · N8021W · Substantial damageNTSB ATL87FA168Accident · 4 fatalField investigationFinal reportCessna 205C · Bowling Green, KYShortly after takeoff from Bowling Green, the pilot reported a problem. He did not report the details of the problem, but witnesses heard the aircraft backfiring as it descended. The aircraft had taken on fuel at Bowling Green. The investigation failed to…Jun 16, 1987 · N1823Z · DestroyedNTSB ANC87FA080Accident · No injuriesField investigationFinal reportPiper PA-22 · Theodore River, AKThe private pilot elected to abort the takeoff attempt from an abandoned roadway too late to stop in time to avoid going into brush and small trees. He said he decided against the takeoff at about the mid-point in the 4000 foot gravel section of the road. The…Jun 16, 1987 · N2447P · Substantial damageNTSB NYC87LA173Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Canastota, NYA student pilot was performing tkofs and lndgs when after touchdown on the third landing, he lost directional control of the aircraft. After atmptg to salvage the lndg, the pilot initiated a go-around but the left wing stalled and the aircraft impacted on the…Jun 15, 1987 · N2477B · Substantial damageNTSB LAX87LA236Accident · No injuriesLimited investigationFinal reportCessna T210L · Merced, CADuring a cross country flight, the engine lost power and quit aprx 4 miles from the airport. The pilot was unable to reach the runway and made a forced landing aprx 3 miles short of the runway. During the landing roll the aircraft collided with a fence and…Jun 15, 1987 · N59104 · Substantial damageNTSB LAX87LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Long Beach, CAThe aircraft ditched in the pacific ocean while on a VFR instructional flight. Both pilots indicated that the engine stopped abruptly and they were unable to restart it. The propeller would not turn when the starter was engaged, nor would it windmill. The CFI…Jun 15, 1987 · N115RJ · DestroyedNTSB LAX87FA234Accident · 1 fatalField investigationFinal reportCessna T210N · Huntington Bch, CADuring a pleasure flight, the pilot informed an air traffic controller that he was running out of fuel and turning to an airport. During the descent the airplane collided with a tree and terrain. There were no reported mechanical failures or malfunctions with…Jun 15, 1987 · N6461N · DestroyedNTSB FTW87DRA04Accident · No injuriesFinal reportAero Commander Callair B-1A · Louise, TXAcft was departing from a 1500' private strip on an aerial application flt. Opr had reduced the fertilizer load on this flt in order to compensate for the higher ambient temps in the afternoon. On takeoff, the acft lifted off normally, but settled back onto…Jun 15, 1987 · N7287V · DestroyedNTSB ANC87LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kvichak Bay, AKThe pilot stated that during the takeoff the aircraft's engine lost power; the aircraft stalled and crashed on the gravel bar. The pilot also stated he did not know how much fuel was on board the aircraft and he did not remember the last time he fueled the…Jun 15, 1987 · N92558 · Substantial damageNTSB SEA87LA117Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Reno, NVWhile soaring, thunderstorms developed in the area. The pilot returned to the landing field, encountering turbulence and gusty winds. On landing roll, gusty winds caused the single-wheel glider to drift into a parked vehicle. Surface winds reported at Reno…Jun 14, 1987 · N3616F · Substantial damageNTSB SEA87LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Odessa, WADuring landing roll on a dirt road, the aircraft drifted to the side, encountered the shoulder ditch and flipped over.Jun 14, 1987 · N5458W · Substantial damageNTSB NYC87LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Towanda, PAThe Taylorcraft, N43978, collided with the tail of Piper, N4889L while both were taxiing to rwy 22. The plt of the Taylorcraft stated that he was taxiing parallel to the rwy and the Piper came from behind and to the left to cross in front of him. The plt of…Jun 14, 1987 · N4889L · 2 aircraft · Substantial damageNTSB MIA87LA183Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Miramar, FLThe student plt was conducting solo touch & go ldgs when directional control of the acft was lost & the acft left the rwy & collided with a rwy designator sign during the ldg phase.Jun 14, 1987 · N2537N · Substantial damageNTSB MIA87LA181Accident · Serious injuriesLimited investigationFinal reportCessna 150H · St. Cloud, FLThe plt stated that the engine ran good during the run up & on his takeoff roll the acft accelerated normally until he reached 45 knots, he looked down and noticed that the carburetor heat was on & he wasn't getting any more power. Realizing he was going to…Jun 14, 1987 · N6647S · DestroyedNTSB FTW87LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Yukon, OKOn touchdown the aircraft started to drift to the left. The pilot applied right rudder and lost directional control of the aircraft. The aircraft's right wing contacted the runway and the aircraft nosed over.Jun 14, 1987 · N13618 · Substantial damageNTSB FTW87LA144Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · Lago Vista, TXWhile maneuvering at approximately 50 feet AGL, the aircraft's landing gear contacted a 7200 volt powerline. Control of the aircraft was lost, and it descended out of control into about 2 feet of water, causing substantial damage.Jun 14, 1987 · N874K · Substantial damageNTSB FTW87LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Cameron, TXDuring takeoff climb the aircraft struck a powerline then trees and impacted the ground. The aircraft was being flown bya student pilot with no medical certificate or solo endorsement.Jun 14, 1987 · N5079A · Substantial damageNTSB DEN87LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Los Lunas, NMThe plt reported that after touchdown, the acft swerved to the right and went into a water filled irrigation ditch. The acft nosed over and came to rest inverted. A post accident inspection revealed a deflated tail wheel which appeared to have blown out. It…Jun 14, 1987 · N8924D · Substantial damageNTSB DEN87LA149Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Driscoll, NDThe plt rprtd he lost directional control as he was lndg on a paved section of old highway to load chemicals. The acft swerved & went into a ditch. The left main gear collapsed & the acft came to rest back on the roadway, where it was destroyed by a…Jun 14, 1987 · N57773 · DestroyedNTSB DEN87FA148Accident · 2 fatalField investigationFinal reportMooney M20K · Broomfield, CODrg takeoff, the baggage door (bd) came open. Twr psnl advised the plt, but recd no discernible reply. At aprx 100' AGL,the acft pitched up & rolled left, then entered a steep dscnt & crashed aprx 500' left of the rwy. Except for the bd, nopreimpact mech…Jun 14, 1987 · N4047H · DestroyedNTSB CHI87LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Anderson, INThe plt rprtd that shortly after lift-off, the eng bgn 'hitting & missing.' He made a shallow left turn to avoid a house & land in a corn field. However, the acft stalled & the left wing struck the ground. An exam of the eng revealed that a screw (which held…Jun 14, 1987 · N7306W · DestroyedNTSB CHI87LA146Accident · No injuriesLimited investigationFinal reportCessna 210M · La Porte, INThe acft was damaged when the left main gear collapsed drg a landing. An investigation revealed that a swaged fitting at the end of a hydraulic line in the gear sys had failed. The plt rprtd that with this failure, the left main gear only partially extended.Jun 14, 1987 · N761Q · Substantial damageNTSB CHI87DET06Accident · No injuriesFinal reportKennedy Avid Flyer · Goshen, INWhile cruising at 1600 feet MSL, one propeller blade failed in the root area and departed the engine. The pilot made a successful emergency landing in a farmer's field. Vibrations, resulting from the unbalanced propeller condition, were of sufficient…Jun 14, 1987 · N138RK · Substantial damageNTSB CHI87DET05Accident · Serious injuriesFinal reportBannwart Maxair XP-503 · Michigan City, INWhile in cruise flight the carburetor of this amateur built aircraft became detached and the engine failed. An emergency land was attempted, however obstacles prevented a landing at primary landing site and an alternate was selected. The aircraft was unable…Jun 14, 1987 · N171RB · Substantial damageNTSB ATL87DEI05Accident · Minor injuriesFinal reportBell 47G-2 · Lisbon, OHThe helicopter rolled over as it was lifting off from a transport trailer. A post-crash exam revealed that the left rear tie-down strap on the trailer was wrapped around one of the helicopter skids. The ground crewman believed he had removed all of the straps…Jun 14, 1987 · N984B · Substantial damageNTSB SEA87LA115Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ketchikan, AKThe plt made a hard landing while attempting to land on smooth, glassy water. The landing gear float rigging broke on impact which allowed the acft to enter the water. The acft filled with water and sank.Jun 13, 1987 · N43944 · DestroyedNTSB SEA87LA114Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Yerington, NVWhile on an aerial application swath run the pilot allowed the aircraft landing gear to contact the grain crop, resulting in loss of airspeed, uncontrolled descent, impact with the ground and nose over.Jun 13, 1987 · N9795J · DestroyedNTSB NYC87LA178Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sterling, MAWhile practicing hovering in the designated hover area at the arpt, the stu plt accidently pulled aft cyclic while the helicopter was drifting backwards. This caused the tail structure and rotor blades to contact the ground. The main rotor blades then…Jun 13, 1987 · N351 · Substantial damageNTSB NYC87LA177Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Quakertown, PAThe pilot came in high and fast on the approach. He reduced pwr initially to increase rate of descent. As he apched trees, he applied power to stop the descent, but collided with the tops of the trees. The acft yawed to the right about 30 degrees and touched…Jun 13, 1987 · N94383 · Substantial damageNTSB NYC87FA172Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Nantucket, MAThe weather at the Nantucket airport was below the prescribed minima for the ILS approach to runway 24. A blanket broadcast had been made on the air traffic frequencies that the Nantucket weather was below the minima for most users and, thereafter, the…Jun 13, 1987 · N222HF · DestroyedNTSB MIA87LA182Accident · No injuriesLimited investigationFinal reportCessna 172G · Caribbean SeaThe plt became disoriented while flying from saint lucia to saint vincent after he incorrectly selected the wrong station when navigating using the adf. He contacted ATC who advised him to climb & was advised that the flt was aprx 20 miles west of saint…Jun 13, 1987 · N4346W · Substantial damageNTSB MIA87LA180Accident · No injuriesLimited investigationFinal reportTaylorcraft BL-65 · Deland, FLThe plt stated that just after take-off, the rt wing was lifted by a x-wind & the acft stalled & crashed into the trees. The plt stated that the accident could have been prevented if he had decreased the angle of attack after take-off & had made 'a turn into…Jun 13, 1987 · N36130 · Substantial damageNTSB FTW87FA142Accident · Serious injuriesField investigationFinal reportBeech 35 · Cookson, OKJust after takeoff smoke was smelled and then observed in the cockpit. The pilot beleived that the smoke source was electrical and turned off the master switch. Just before touchdown flames began burning the pilots left leg. The aircraft was stopped on the…Jun 13, 1987 · N3063V · DestroyedNTSB DEN87LA150Accident · No injuriesLimited investigationFinal reportCessna A185E · Norwood, COThe plt was circling gnd psnl at 300 to 500 ft AGL, banking up to 60 deg, when the eng quit. An eng restart was successful; however, the acft was too low to recover & it collided with a fence. After hitting the fence, the acft crashed to the gnd & was…Jun 13, 1987 · N5836J · Substantial damageNTSB DEN87LA143Accident · No injuriesLimited investigationFinal reportBeech 19A · Erie, COThe instructor (CFI) was instructing the student plt, who was the new owner of the acft. The CFI rprtd the acft was 'very close to gross weight due to having so much fuel aboard and the density altitude was high.' He estd the density altitude was 7600 ft. drg…Jun 13, 1987 · N7650R · Substantial damageNTSB CHI87IA148Incident · No injuriesIncident investigationFinal reportDornier DO-228-201 · Springfield, ILThe flightcrew experienced inflight opening of the aft baggage door and inflight separation of the cabin stairway door. The copilot checked the doors on three occasions before takeoff because the door warning light was illuminated. The captain initiated the…Jun 13, 1987 · N88FB · Minor damageNTSB SEA87LA118Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-2 · Milton-Freewatr, ORThe pilot was hovering up rising terrain at a slow airspeed, at 15 feet above the ground while on an agricultural spraying flight and encountered settling with power. The aircraft entered an uncontrolled descent and impacted the ground.Jun 12, 1987 · N2219W · DestroyedNTSB FTW87LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TXThe dual student pilot, while on his second flight, suddenly applied full right rudder during flare/touchdown and froze on the controls while in this position. The aircraft veered off the right side of the runway into deep and soft mud before the CFI could…Jun 12, 1987 · N24258 · Substantial damageNTSB DEN87LA141Accident · No injuriesLimited investigationFinal reportCessna T210H · Salt Lake City, UTThe plt rprtd dscndg from 10,500 feet MSL for an apch to rwy 34 right at the Salt Lake City arpt. He stated he had selected landing flaps & had moved the mixture to rich & the prop to high RPM. At 8,500 MSL, 'the engine quit.' Subsequently, the plt made a…Jun 12, 1987 · N692RF · Substantial damage