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 CHI88LA209Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mt. Vernon, OHWhile in cruise flight in VFR conditions and on an IFR flight plan, the pilot experienced a total loss of engine power. The pilot executed a forced landing in a soy bean field after an unsuccessful restart attempt. Examination of the oil cooler hose revealed…Aug 14, 1988 · N9769B · Substantial damageNTSB ANC88LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kwethluk, AKThe pilot lost directional control of the aircraft while landing. At the time of accident the wind was from 180 degrees at 15 knots gusting 20 knots. The airplane landed on runway 25; after touchdown the airplane departed the right side of the runway into an…Aug 14, 1988 · N32062 · Substantial damageNTSB SEA88LA152Accident · 1 fatalLimited investigationFinal reportCassutt III · Shelton, WAAcft had been restored and recertificated since last flight in 1969. On initial test flight takeoff, plt immediately turned to and flew low, slow landing pattern circuit with sounds of reduced power, colliding with trees in final approach turn. Investigation…Aug 13, 1988 · N2984G · DestroyedNTSB MKC88LA157Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Springfield, MOWhile attempting to depart a 1600 ft sod runway, the PIC said he was unable to get airborne and elected to abort the takeoff. Unable to stop, he went through a fence, substantially damaging both wings. The plt recommended not trying to takeoff from a short…Aug 13, 1988 · N93437 · Substantial damageNTSB MIA88FA254Accident · 1 fatalField investigationFinal reportCessna 172E · Floweree, MSThe student pilot departed early in the morning and was not found until the next afternoon. There were no witnesses to the accident. The aircraft impacted the ground in a 50 degree nose down angle at a high rate of speed with evidence of aircraft rotation…Aug 13, 1988 · N5555T · DestroyedNTSB LAX88WA323Accident · No injuriesForeign investigationCessna 177RG · El Alamo, MexicoAug 13, 1988 · N52835 · Substantial damageNTSB DEN88LA182Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Pueblo, COAug 13, 1988 · N2341Z · Substantial damageNTSB CHI88LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Dodgeville, WIDuring an attempted landing in gusty wind, the pilot failed to maintain directional control, got blown off to the left side of the runway and experienced a tail strike. The pilot attempted to abort the landing, but was unable to climb out of ground effect,…Aug 13, 1988 · N47804 · Substantial damageNTSB CHI88FA201Accident · 4 fatalField investigationFinal reportCessna 210B · Noblesville, INAug 13, 1988 · N562D · DestroyedNTSB CHI88DEM08Accident · No injuriesFinal reportChampion 7KCAB · Grand Haven, MIThe pilot's inattentive fuel system monitoring, and the resultant total failure of the aircraft's powerplant due to fuel exhaustion. A forced landing was executed on a stretch of beach with sand dunes, and the aircraft was substantially damaged during the…Aug 13, 1988 · N5124T · Substantial damageNTSB ATL88DKG17Accident · No injuriesFinal reportIntermountain Mfg. Callair A-9 · Redbud, GAAug 13, 1988 · N7233V · Substantial damageNTSB ATL88DKG16Accident · No injuriesFinal reportCessna 188 · Hazel Green, ALThe plt rprtd he had flown off the strip all day & the temp had risen to 101 deg. As he was on his last takeoff, he realized the chemical load was too great for the conditions. He said he dumped part of the load, but the acft settled back to the ground.…Aug 13, 1988 · N42404 · Substantial damageNTSB NYC88FA216Accident · 2 fatalField investigationFinal reportCessna TU206G · White Lake, NYThe float equipped aircraft made multiple takeoff attempts on a lake, getting airborne at least once prior to the accident. On the takeoff run that terminated in the accident, the pilot turned into an inlet after getting airborne with insufficent room to turn…Aug 12, 1988 · N4613Z · Substantial damageNTSB MKC88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · St Charles, MOThe plt rprtd that during the flt, he enctrd thunderstorm activity, as well as a downdraft, which resulted in a loss of about 400 ft of alt. Subsequently, the acft was landed in a corn field & was damaged. About 13 mi se at st louis, the visibility was rprtd…Aug 12, 1988 · N96344 · Substantial damageNTSB DEN88GA185Accident · 1 fatalFinal reportCessna 182R · Georgetown, COAug 12, 1988 · N9545H · Substantial damageNTSB CHI88LA202Accident · No injuriesLimited investigationFinal reportWaco ATO · Middletown, OHThe plt stated that during initial climb the engine sputtered and he discovered that the fuel pressure gauge read zero. He made an immediate right turn back toward the airport. While attempting to glide to the airport he noticed that the fuel selector was set…Aug 12, 1988 · N763E · Substantial damageNTSB CHI88IA200Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILAug 12, 1988 · N426MQ · No damageNTSB NYC88LA215Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Montgomeryville, PAThe plt reported that the flt took off with light & variable winds. He said he used the short fld, obstacle clearance procedure to avoid powerlines which are located 1000 ft from the end of the rwy. After the acft became airborne it would not climb. A turn…Aug 11, 1988 · N8233N · DestroyedNTSB NYC88LA214Accident · Minor injuriesLimited investigationFinal reportBell 47G5 · Biddeford, METhe helicopter made an approach to a low hover above a hard surfaced rwy. The helicopter was slowly air taxiing when the plt felt the helicopter become unstable directionally and he considered making a run-on landing. However, before he could make the landing…Aug 11, 1988 · N14861 · Substantial damageNTSB MKC88LA155Accident · No injuriesLimited investigationFinal reportCessna 188B · Sumner, IADuring takeoff for an aerial application operation, the pilot said he was not able to climb high enough to clear a 4 foot high road at the end of the runway. He collided with the road, shearing off the main ldg gear and substantially damaging the acft. He…Aug 11, 1988 · N4999R · Substantial damageNTSB MIA88LA253Accident · No injuriesLimited investigationFinal reportCessna 172D · Tupelo, MSThe private pilot landed on runway 18 after completing a cross-country flight. During landing roll the aircraft encountered a downwind gust of wind and the pilot lost control of the aircraft while on the ground. The propeller and right wing were substantially…Aug 11, 1988 · N2344U · Substantial damageNTSB LAX88LA284Accident · No injuriesLimited investigationFinal reportCessna 150M · Gila Bend, AZAt the end of a cross country flight, the pilot overflew the runway looking for the wind sock. Unable to locate the sock, the pilot made an approach for landing. The pilot did not realize until too late that he was landing the airplane with a 10 knot…Aug 11, 1988 · N704GJ · Substantial damageNTSB DEN88LA180Accident · No injuriesLimited investigationFinal reportBell 206B · Sturgis, SDThe plt was on a flt with 2 pax to take pictures. He stated that 'while in level flight at 120 mph and 300 feet above the ground, a pitch over was initiated for picture taking. At that moment, it appeared that the fuel flow cavitated. The forward fuel pump…Aug 11, 1988 · N49727 · Substantial damageNTSB CHI88DEP10Accident · No injuriesFinal reportPiper PA-25-235 · Beaver Dam, WIWhile in cruise flight the aircraft experienced a total loss of power due to fuel exhaustion. The pilot stated that there were no good landing areas available, so he elected to make the emergency landing in a marsh. The aircraft landed hard and sustained…Aug 11, 1988 · N4856Y · Substantial damageNTSB SEA88LA150Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Leavenworth, WAThe PIC reported that during a practice helicopter autorotation to a power recovery, the pilot under instruction held the flare too long. The helicopter's tail guard and tail rotor struck the ground and the aircraft began to spin. The PIC reduced the throttle…Aug 10, 1988 · N62404 · Substantial damageNTSB NYC88LA213Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Plymouth, MAThe acft was taking off on a hard packed, grassy area beside a paved rwy with a 12 kt headwind. After the tail was raised, and at a point 900 ft from the beginning of the roll, the acft suddenly nosed over. Examination of the broken right main landing gear…Aug 10, 1988 · N2232K · Substantial damageNTSB NYC88LA212Accident · 1 fatalLimited investigationFinal reportCessna 152 · Swanton, VTThe plt took the passenger (his wife) on a short flt, which was her 1st flt. She was described as apprehensive. Before going back to the parking area after landing, the plt taxied to the terminal bldg for his wife to deplane. He stopped the acft with the left…Aug 10, 1988 · N757LD · Minor damageNTSB MKC88FA154Accident · Serious injuriesField investigationFinal reportBoeing 737-222 · Little Rock, ARThe sked air carrier flt was aborted after the capt heard a noise and felt a vibration emanating from the left side of the acft, which at the time, was perceived as a 'blown' tire. The acft was subsequently stopped on the active rwy, and an order fm the…Aug 10, 1988 · N9060U · No damageNTSB MIA88LA250Accident · Minor injuriesLimited investigationFinal reportContinental Copters MK-5A · Valley Park, MSThe pilot stated that he thought he had 8 gallons of fuel prior to takeoff. The engine failed about 100 ft AGL and he attempted to stretch the glide of the helicopter by using collective pitch. The aircraft hit hard and rolled over. Only 1 quart of fuel was…Aug 10, 1988 · N9086T · Substantial damageNTSB FTW88IA147Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Oklahoma City, OKThe flight was an instructional flight with three pilots onboard. The airplane departed on runway 17R and was 300 to 400 feet AGL when one blade of the right propeller separated from the hub, followed by the remainder of the propeller. The PIC made an…Aug 10, 1988 · N3589B · Minor damageNTSB CHI88FA198Accident · 2 fatalField investigationFinal reportPiper PA-28 · Auburn, INFlight known adverse weather conditions.Aug 10, 1988 · N3828K · DestroyedNTSB CHI88DEX11Accident · 1 fatalFinal reportContinental Copters MK-5 · Redkey, INPhysical impairment of the pilot due to drugs which resulted in a misjudged approach and subsequent contact with trees during the approach to an aerial application swath run.Aug 10, 1988 · N25561 · DestroyedNTSB ATL88DKG12Accident · No injuriesFinal reportCessna 188B · Bainbridge, GAAug 10, 1988 · N731UH · DestroyedNTSB ANC88LA107Accident · 2 fatalLimited investigationFinal reportArtic S-1B2 · Kotzebue, AKThe airplane crashed at 2700 feet m.s.l. in a box canyon while maneuvering at low level & scouting for sheep. The top of the ridge was approximately 3200 feet m.s.l. the investigation revealed that the pilot was trying to outclimb the ridge when the airplane…Aug 10, 1988 · N58AT · Substantial damageNTSB NYC88LA211Accident · Minor injuriesLimited investigationFinal reportMooney M20C · E. Stroudsburg, PAThe plt said that during an attempted landing the acft floated during the flare. After using about half the rwy he decided to go-around. The temp was 90 deg f resulting in a density alt of 3200 ft. the plt said he applied full pwr but the acft did not climb…Aug 9, 1988 · N2HV · DestroyedNTSB MKC88LA153Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Macomb, MOThe acft had been flown 235 nautical miles the previous day without re-fueling. The PIC stated he thought that he could reach his next fuel stop without refueling at the departure arpt. The PIC stated he flew the acft in that gen dirctn for abt 1 hour. At the…Aug 9, 1988 · N4503U · Substantial damageNTSB MKC88DCA02Accident · Serious injuriesFinal reportCallair A-9A · Rush Hill, MOAbout 25 minutes after sunset, the airplane struck a powerline and pole during a spray run. The airplane struck the ground inverted.Aug 9, 1988 · N7735V · Substantial damageNTSB MIA88WA252Accident · 2 fatalForeign investigationPiper PA-23-250 · Gr. Harbor Cay, BahamasAug 9, 1988 · N6737Y · DestroyedNTSB MIA88WA249Accident · Serious injuriesForeign investigationCessna 421C · Marsh Harbour, BahamasAug 9, 1988 · N98427 · DestroyedNTSB CHI88DEP09Accident · Minor injuriesFinal reportEaa Acro II · Fond Du Lac, WIThe plt rprtd that after reaching cruise alt, the eng began to run rough & subsequently lost power. He made an emerg landing in a dry cultivated field. Drg the landing, the gear collapsed & the acft was substantially damaged. The fuel tank was equipped with a…Aug 9, 1988 · N9EA · Substantial damageNTSB ATL88DKG13Accident · No injuriesFinal reportGrumman G-164A · Fadette, ALThe pilot reported a partial power loss during an aerial application flight. The aircraft landed in the crops. The pilot stated that he found the number 3 cylinder partially separated from the engine.Aug 9, 1988 · N8573H · Substantial damageNTSB ANC88LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chandalar River, AKAfter touchdown on the gravel bar along the side of the River, the pilot lost control and the airplane nosed over on its back.Aug 9, 1988 · N8066C · Substantial damageNTSB SEA88LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Yoncalla, ORStudent plt was at 8500 ft crz when pwr loss occurred. Forced lndg made in open field where acft collided with fence on lndg roll. Engine ran normally post-mishap. Fuel sample clear of water or other contaminant. Plt did not use carb heat when pwr loss…Aug 8, 1988 · N67992 · Substantial damageNTSB SEA88LA148Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Wilbur, WAThe pilot reported that an engine power loss occurred during an aerial application maneuver. The pilot made a forced landing in rough terrain. Examination of the engine revealed deteriorated seals in the engine driven fuel pump. Exam of the electric fuel pump…Aug 8, 1988 · N4603G · Substantial damageNTSB NYC88LA203Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Wildwood, NJThe aircraft struck a building after if experienced a power loss due to fuel exhaustion caused by oil dilution and low engine compression.Aug 8, 1988 · N20722 · Substantial damageNTSB MKC88LA151Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lees Summit, MOShortly after takeoff, on a touch and go, after a full flap landing, the CFI and student said they heard a loud bang about 150 AGL on climbout. The CFI took over the controls and said they were nonresponsive in pitch. Full throttle was maintained and they…Aug 8, 1988 · N51390 · Substantial damageNTSB MKC88DCQ04Accident · Serious injuriesFinal reportTeratorn Tierra II · Plevna, KSThe pilot stated that on takeoff climb, approximately 100 feet AGL, the a/c broke to the right and hit the ground. The pilot suspected right aileron control problems. Inspection of a/c revealed no mechanical problems. The wind was light and variable at 10 KTS.Aug 8, 1988 · N68JM · Substantial damageNTSB MKC88DCD03Accident · 1 fatalFinal reportPiper PA-25-235 · Eldora, IAPilot was spraying a bean field when a witness saw his aircraft strike the ground. The aircraft then climbed to approximately 200 feet and leveled off. It then began a gentle climb, then entered a spin and desended into the ground. Examination of the aircraft…Aug 8, 1988 · N9612P · Substantial damageNTSB FTW88LA148Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Edna, TXA delay in initiation of the go-around during the pilot's second attempt to land in the dark night conditions. Contributing to the accident was the runway closure due to construction, which resulted in no runway lights illuminated, and the fact that the pilot…Aug 8, 1988 · N8355L · Substantial damageNTSB DEN88LA181Accident · No injuriesLimited investigationFinal reportCessna 180 · Cascade, MTThe plt was landing at an unattended airstrip with a 1000' dirt rwy. There was a northerly wind, but due to the sloping rwy terrain, he elected to use rwy 19 & land uphill with a tailwind. The plt rprted that as he was about to flare, the acft pitched down &…Aug 8, 1988 · N1509C · Substantial damage