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 DEN88LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe private plt was practicing landings at centennial airport, denver, Colorado. Rnwy 17L, an asphalt rnwy 8,500 feet long and 101 feet wide, was in use. The plt reported that when he attempted to add power on final approach, the throttle cable would not…Feb 12, 1988 · N4914D · Substantial damageNTSB ANC88LA030Accident · No injuriesLimited investigationFinal reportCessna 207 · Brevig Mission, AKThe pilot stated that while taxiing on the ramp perpendicular to the wind direction, a strong wind gust lifted the right wing and tail of the aircraft. The aircraft slowly turned over on its back.Feb 12, 1988 · N9950M · Substantial damageNTSB NYC88LA079Accident · 1 fatalLimited investigationFinal reportCessna 172P · East Hampton, NYThe flight departed East Hampton airport for a pleasure flt. Shortly thereafter, the pilot called on frequency 122.7 stating that he had struck some birds and could not maintain control of the aircraft. There as no further transmission as to his location, and…Feb 11, 1988 · N52535 · DestroyedNTSB MKC88LA052Accident · No injuriesLimited investigationFinal reportCessna 172 · Kimball, NEThe pilot said that he was using outdated charts for his destination apt. He failed to notice a new runway. He also failed to notice the yellow x's, signifying closure of the old runway. It was almost parallel to the runway, within ten degrees of heading. Ldg…Feb 11, 1988 · N12600 · Substantial damageNTSB CHI88LA065Accident · No injuriesLimited investigationFinal reportCessna 172F · Brighton, MIFeb 11, 1988 · N8863U · Substantial damageNTSB CHI88IA061Incident · No injuriesIncident investigationFinal reportDouglas DC-10 · Chicago, ILJudgemental error on the part of the local controller for clearing vehicles across the active runway tiwh insufficient separation from arriving aircraft, which was further compromised by a mechanical malfunction in the equipment crossing the runway.Feb 11, 1988 · N123AA · No damageNTSB MKC88LA049Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Burlington, IAWhile taxiing out on a snow covered taxiway, during an air taxi operation, the aircraft struck an unmarked, unlighted, snow covered drainage hole, with the left landing gear. Substantial damage occurred to the left engine nacelle, the left wing spar, and the…Feb 10, 1988 · N2230D · Substantial damageNTSB LAX88LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Van Nuys, CAThe student pilot was on his second supervised solo and had executed a go-around on his first attempted touch & go maneuver. The plt reentered the traffic pattern and landed on runway 34L. The airplane exited to the left of the runway onto the grass. With the…Feb 10, 1988 · N25732 · Substantial damageNTSB FTW88LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · San Antonio, TXThe pilot experienced a complete loss of engine power while on the final approach. The damage to the aircraft occurred when he had to land on unsuitable terrain during the forced landing. Examination of the aircraft fuel system showed that a fuel line to the…Feb 10, 1988 · N68806 · Substantial damageNTSB FTW88FA060Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Oklahoma City, OKThe airplane was equipped for IFR but not equipped to fly into icing cond. At 4000 feet MSL, the OAT was above freezing. At 3000 feet MSL the airplane was in clouds with OAT of 32 degrees f. the plt elected to attempt downwind ILS approach and landing. Plt…Feb 10, 1988 · N2186K · Substantial damageNTSB FTW88FA057Accident · Serious injuriesField investigationFinal reportCessna 120 · Ada, OKThe pilot was flying low up the river and hit the upper strand of a two strand high voltage power line. Both the pilot and passenger received serious injuries when the airplane crashed on a sand-bar in the river.Feb 10, 1988 · N2431N · DestroyedNTSB DEN88LA067Accident · No injuriesLimited investigationFinal reportCessna 180 · Roundup, MTThe private plt rancher was completing a work flt. During the flt, the plt made 5 off arpt landings in snow 5 to 6 inches deep. The landing on which the accident occurred was made at a local arpt on a snow covered rwy. During the landing, the acft sank into…Feb 10, 1988 · N7661A · Substantial damageNTSB DEN88LA066Accident · No injuriesLimited investigationFinal reportPiper J3C · Cody, WYDuring an attempted landing at a private airstrip which was covered by 5-6 inches of dry powdered snow, the acft touched down. It pitched forward and nosed over. After the acft came to rest, the pilot got out of the acft, examined the landing gear, and…Feb 10, 1988 · N7468 · Substantial damageNTSB NYC88DHA02Accident · 1 fatalFinal reportGribosh LONG-EZ · Perkasie, PAThe homebuilt airplane was being operated on its second test flight after manufacture. Witnesses stated that they heard the engine 'making power changes' and 'surging' while the airplane was maneuvering at 30 to 50 feet above the ground. Also, they reported…Feb 9, 1988 · N814EZ · Substantial damageNTSB MKC88LA050Accident · No injuriesLimited investigationFinal reportCessna 182RG · Texarkana, ARThe PIC claimed he was unable to start the aircraft normally. He said he couldn't remember if he properly secured the acft before attempting to prop start. As he pulled the propeller through, the acft eng revved up to a high RPM. The PIC claimed there was a…Feb 9, 1988 · N756FF · Substantial damageNTSB MKC88LA048Accident · No injuriesLimited investigationFinal reportCessna T-188C · Goodland, KSWhile flying a certificated experimental ag acft, for purpose of compliance with FAR regulations, the employee of the federal aviation administration lost control during landing rollout. The wind conditions, relative to the runway, were about a 80 degree…Feb 9, 1988 · N4509J · Substantial damageNTSB MIA88LA102Accident · Minor injuriesLimited investigationFinal reportHess QUICKIE-2 · Orlando, FLThe plt stated that on the landing rollout, the acft began to veer left. While he was attempting correction to the right, the acft hit a bump off the runway, flipped over & came to rest inverted.Feb 9, 1988 · N3241K · Substantial damageNTSB LAX88DVM01Accident · No injuriesFinal reportBeech M35 · San Jose, CADuring a pleasure flight, while on final approach to the airport, the engine quit. The pilot made a forced landing in a shopping center parking lot, where the aircraft collided with three parked vehicles. Inspection of the engine did not identify any…Feb 9, 1988 · N2036C · Substantial damageNTSB CHI88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Wis. Rapids, WIAirplane drifted left into a snowbank while rolling out from a landing on a snow and ice covered runway. Landing winds as reported by the pilot were from 60 degrees to the right of the nose at 5 to 8 knots.Feb 9, 1988 · N3790T · Substantial damageNTSB ATL88MA089Accident · 3 fatalMajor investigationFinal reportBritish Aerospace 3101 · Springfield, OHA company designated instr and two f/o trainees were conducting a FAR 135 trng flt. The third apch was terminated with ago-around initiated over the rwy threshold at about 50 ft. after climbing to about 150 ft, the acft was observed to oscillate in yaw,…Feb 9, 1988 · N823JS · DestroyedNTSB ATL88FA088Accident · 1 fatalField investigationFinal reportCessna 150H · Youngstown, OHFeb 9, 1988 · N618DP · Substantial damageNTSB SEA88LA045Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palamino Valley, NVThe student pilot was practicing 's' turns over a roadway when engine power loss occurred. Forced landing attempt on the road resulted in a high flare and hard landing, shearing the nose gear. The acft flipped inverted. Engine inspection and test run revealed…Feb 8, 1988 · N48890 · Substantial damageNTSB MIA88WA101Accident · Minor injuriesForeign investigationPiper PA-23-250 · Rock Sound, BahamasFeb 8, 1988 · N5173Y · DestroyedNTSB ANC88LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Chugiak, AKThe certified flight instructor and his student were on a right downwind doing touch-and-go landings when, according to the pilot, the engine suddenly lost all power. Attempts at restarting the engine were unsuccessful, and the airplane landed short of the…Feb 8, 1988 · N2423U · Substantial damageNTSB MIA88LA104Accident · 2 fatalLimited investigationFinal reportBeech 65-88Undetermined.Feb 7, 1988 · N884G · DestroyedNTSB LAX88LA106Accident · No injuriesLimited investigationFinal reportCessna TR182 · Truckee, CAFeb 7, 1988 · N5533S · Substantial damageNTSB DEN88FA071Accident · 3 fatalField investigationFinal reportCessna 172M · Red Lodge, MTThe plt and two pax were returning to twin falls, id from billings, MT. The plt rec two wx briefings prior to dep. The wx forecast indicated low clouds, snow, turb and icing cond along the intended route of flight. The route of flight required the plt to…Feb 7, 1988 · N20484 · DestroyedNTSB CHI88DET02Accident · No injuriesFinal reportBeech A35 · Wheeler, INThe acft was being operated iaw a ferry permit to obtain an annual inspn. The prev annual inspn was on 3/13/85. Drg flt abt 1.3 hrs after takeoff, the eng lost pwr. The plt noted the fuel pres was zero. He said he turned on the aux fuel pump & insured the…Feb 7, 1988 · N8568A · Substantial damageNTSB ATL88LA087Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Liberty, NCThe plt rptd that he overestimated the amount of fuel on board the acft prior to departure. The engine subsequently lost pwr at cruise due to fuel exhaustion. A forced ldg was made in a field. During the rollout, the airplane vaulted the crest of a small hill…Feb 7, 1988 · N2633W · Substantial damageNTSB NYC88LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Westerly, RIThe plt reported that he experienced a power loss at 350 ft AGL after takeoff. He turned back toward the airport but had insufficient altitude. He elected to land off-airport at an industrial site with the stall warning horn sounding. During landing roll, the…Feb 6, 1988 · N3210J · Substantial damageNTSB FTW88LA059Accident · No injuriesLimited investigationFinal reportCessna 182P · Weatherford, TXA used eng had just been installed in the acft and the owner and mech were performing a functional test flt. Shortly after takeoff at about 300 ft AGL, the eng lost power. The plt pumped the throttle and the eng restarted but immediately quit again and would…Feb 6, 1988 · N52536 · Substantial damageNTSB CHI88LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, ILPilot-in-command's misjudged flare and his failure to attain a proper descent rate.Feb 6, 1988 · N5450Q · Substantial damageNTSB BFO88LA017Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Petersburg, VAThe plt hand-propped the engine when he was unable to start it using the starter. The acft had just been refueled and it was standing next to the fuel pumps. The plt pushed the acft away from the pumps before he tried to hand-prop it. After the third…Feb 6, 1988 · N313AC · Substantial damageNTSB SEA88LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Henderson, NVDuring ground landing roll on a touch and go practice session, the solo student pilot allowed the aircraft to drift off the side of the runway and overcorrected in the opposite direction. After applying full power to abort the landing, she realized the flaps…Feb 5, 1988 · N2249E · Substantial damageNTSB NYC88LA076Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Williamstown, NJThe flight departed runway 27 at cross keys airport and upon reaching 250 feet altitude, the engine lost power and began vibrating. The pilot maneuvered to return to the airport but was unable to reach it. The aircraft crashed in a yard about 1/2 mile from…Feb 5, 1988 · N2352N · DestroyedNTSB NYC88LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hammonton, NJThe plt reported that he experienced a power loss after takeoff at about 100 feet AGL near the end of rwy 30. He said the acft stalled at treetop level, collided with trees, and came to rest in a nosedown attitude. The plt reported that he initiated the flt…Feb 5, 1988 · N2126J · DestroyedNTSB MIA88LA100Accident · No injuriesLimited investigationFinal reportBeech V-35 · Fernandina Bch, FLWhile on a personal flt, the acft landed gear up. The plt stated that he lowered it. He also stated that the gear warning horn was inoperative. Operational check of the landing gear revealed no discrepancies except for an improperly adjusted warning horn &…Feb 5, 1988 · N7987M · Substantial damageNTSB LAX88DVD02Accident · No injuriesFinal reportCessna A188B · Lodi, CAFeb 5, 1988 · N2832J · Substantial damageNTSB DEN88FA064Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Roswell, NMFeb 5, 1988 · N8417F · DestroyedNTSB MIA88IA099Incident · No injuriesIncident investigationFinal reportBeech C-99 · Orlando, FLDrg a visual apch to Orlando intl arpt, bar harbor flt 3949 (Beech C-99, N232BH) contacted the tower (local controller) at 1817:07 & rprtd 5 mi north of the VOR for landing. The VOR was located 5.8 mi north of the rwy. About 20 sec later, the local controller…Feb 4, 1988 · N232BH · 2 aircraft · No damageNTSB DEN88FA063Accident · 3 fatalField investigationFinal reportCessna 421A · Helena, MTThis accident occurred during a night, ILS app to rwy 27 in IMC. The acft collided with a mountain 12 NM ese of the arpt while turning inbound to intercept the LOC course. Investigation revealed that one VOR receiver was set on the destinaton ILS freq, the…Feb 4, 1988 · N517S · DestroyedNTSB DEN88FA062Accident · 1 fatalField investigationFinal reportPiper PA-18-125 · Brighton, COThe student pilot was observed by witnesses to 'buzz' the city of Brighton, Colorado. Witnesses stated that N1153A flew over houses and buildings at a very low altitude. The acft was then observed to climb to a high altitude, do a 'wing over' or 'hammerhead'…Feb 4, 1988 · N1153A · DestroyedNTSB CHI88LA058Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MIFeb 4, 1988 · N383SP · Substantial damageNTSB NYC88LA091Accident · No injuriesLimited investigationFinal reportCessna 303 · Hyannis, MAThe Cessna 303 broke out of the clouds and made a long landing on a 5567 ft runway. Tire marks showed that the aircraft touched down with less than 2000 ft of runway remaining. The landing runway was 24 and the winds were from 360 degrees at 8 KTS. The runway…Feb 3, 1988 · N5461V · Substantial damageNTSB MKC88LA051Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Texarkana, ARFollowing the completion of the ILS approach and landing on runway 22 at the Texarkana, Arkansas airport the nose gear of the aircraft collapsed during the landing roll. The aircraft collided with the runway causing substantial damage to the aircraft. The…Feb 3, 1988 · N2824M · Substantial damageNTSB LAX88WA105Accident · Serious injuriesForeign investigationCessna 182N · Creeley, MexicoFeb 3, 1988 · N92535 · Substantial damageNTSB DEN88FA061Accident · Minor injuriesField investigationFinal reportConvair 580 · Durango, COAfter making an IFR approach, the pilot made a go-around because he was blinded by the reflection of the landing/taxi lights against the falling snow. The pilot landed the aircraft after the second approach. The pilot said he sensed the aircraft drifting to…Feb 3, 1988 · N5808 · Substantial damageNTSB DCA88MZ002Incident · Minor injuriesFinal reportMcdonnell Douglas DC-9-83 · Nashville, TNAmerican flt 132 was loaded with undeclared & improperly marked haz mtrl (hm) packed in a fiber drum. It contained 5 galof 50% hydrogen peroxide solution (oxidizer) & 25 lbs of textreat s-w (corrosive agent; sodium orthosilicate-based mix),shipped by textile…Feb 3, 1988 · N569AA · Minor damageNTSB CHI88LA057Accident · No injuriesLimited investigationFinal reportCessna 421A · Wheeling, ILFeb 3, 1988 · N421Q · Substantial damageNTSB NYC88LA075Accident · No injuriesLimited investigationFinal reportCessna 402C · Provincetown, MAThe Cessna 402C was being positioned for a scheduled commuter flight with only a pilot on board. The pilot made an ILS approach to runway 7 with winds from 220 degrees at 14 knots, the runway wet and light rain falling. The aircraft slid off the end of the…Feb 2, 1988 · N29PB · Substantial damage