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 LAX88LA247Accident · 1 fatalLimited investigationFinal reportSchweizer SGS-1-26A · Montague, CADuring a pleasure flight, the last transmission by the pilot stated he was going to see what the glider could do besides straight and level flight. Witnesses in the area reported that they heard a loud pop and observed the glider, minus the left wing, in a…Jul 1, 1988 · N2726Z · DestroyedNTSB LAX88LA243Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Lancaster, CAJul 1, 1988 · N4179K · Substantial damageNTSB LAX88LA242Accident · No injuriesLimited investigationFinal reportPiper J3 · Rialto, CADuring a local flight, the engine quit while descending to the airport. A forced landing was made on a road where during the landing roll a gust of wind pushed the airplane off the road. The airplane ground looped, collided with the terrain and nosed over.…Jul 1, 1988 · N6868H · Substantial damageNTSB LAX88DVG08Accident · No injuriesFinal reportGrumman G-164A · Gridley, CADuring the landing roll, the left wing caught on high weeds. The pilot lost control of the airplane, veered off the landing strip, and collided with a ditch paralleling the runway. There were no reported mechanical failures or malfunctions with the airplane…Jul 1, 1988 · N7933 · Substantial damageNTSB DEN88LA143Accident · No injuriesLimited investigationFinal reportMooney M-20K · Gunnison, COJul 1, 1988 · N231PG · Substantial damageNTSB DEN88DTE06Accident · No injuriesFinal reportHelfrich-Leonard BD-5B · Englewood, COThis experimental acft is powered by a modified honda 1250 cc, watercooled eng. The plt reported that after takeoff the eng temp reached the redline and the eng lost power. During the forced landing the main landing gear collapsed. Examination of the eng…Jul 1, 1988 · N250TH · Substantial damageNTSB CHI88LA150Accident · Serious injuriesLimited investigationFinal reportRockwell 112A · Sandusky, OHThe pilot failed to maintain directional control after making a bounched landing. Additionally, the pilot failed to add full power after the bounched landing prior to striking trees to the left of the runway.Jul 1, 1988 · N1463J · Substantial damageNTSB CHI88DEX06Accident · No injuriesFinal reportPiper J3 · Bedford, INAircraft was in cruise flight at 1000 feet AGL when the pilot heard a backfire from the engine followed by immediate and total loss of power. Forced landing was made in rugged, rocky terrain. Landing gear sheared off on rollout. Investigation revealed failure…Jul 1, 1988 · N42684 · Substantial damageNTSB ATL88LA208Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Thomson, GAThe plt reported that the engine lost pwr about 20 miles from the arpt where he had intended to refuel. The airplane subsequently collided with utility wires as he was attempting to land on a hwy. the plt attributed the pwr loss to fuel exhaustion. Postcrash…Jul 1, 1988 · N29238 · Substantial damageNTSB ATL88LA206Accident · No injuriesLimited investigationFinal reportCessna 172M · Spring Creek, NCThe plt reported that the engine began to run rough & lose power as the airplane climbed through 9,000 ft MSL. She then switched fuel tanks and moved the mixture to full rich, but the engine continued to lose power. Carb heat was not used at any time. A…Jul 1, 1988 · N1534V · Substantial damageNTSB ATL88FA207Accident · 1 fatalField investigationFinal reportPiper PA-32 · Uniontown, ALJul 1, 1988 · N8324V · DestroyedNTSB ANC88LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Hooper Bay, AKThe commercially certificated pilot was attempting to land in winds estimated as 30 knots gusting to 40. He reportedly hit a downdraft just piror to landing and had a harder than normal touchdown. During the later stages of the landing roll-out, he applied…Jul 1, 1988 · N15268 · Substantial damageNTSB SEA88IA121Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-73F · Seattle, WACrew noted inflight indications of loss of hydraulic fluid, then carried out standard procedures per crew manual. Emerg hyd sys used to lower flaps for lndg. Acft landed with four right brakes locked. The tires blew and the wheels were ground flat.…Jun 30, 1988 · N791FT · Minor damageNTSB MKC88LA118Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Olathe, KSAfter a long cross country flight, the pilot said he encountered heavy rain and thunderstorms near his destination. He reported that he was able to continue the flight under VFR, but when landing on the wet runway braking was ineffective. The airplane…Jun 30, 1988 · N8328A · Substantial damageNTSB MIA88LA210Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Atlantic Ocean (Atlantic Ocean)The plt stated that the eng started running rough. He decided to divert to alt aprt 15 miles away. While enroute, the plt stated that he heard a 'clanking' noise and oil sprayed the windsheild. The eng lost all power. The a/c was ditched in the Atlantic Ocean…Jun 30, 1988 · N75033 · DestroyedNTSB MIA88LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · Titusville, FLThe plt stated that on approach for landing the acft developed a high sink rate. The acft landed hard and bounced. The pilot said she had pushed the nose of the acft down to prevent it from stalling and did not apply power. The nose gear collapsed and the…Jun 30, 1988 · N46068 · Substantial damageNTSB LAX88FA241Accident · 1 fatalField investigationFinal reportHelio HST-550A · Perris, CAFailure of the electrical stabilizer trim control that resulted in an uncommanded full nose down elevator trim command.Jun 30, 1988 · N9991F · DestroyedNTSB LAX88FA240Accident · 1 fatalField investigationFinal reportCessna 172P · Descanso, CAPilot's poor judgment and intentional decision to low fly the aircraft below the minimum safe altitude.Jun 30, 1988 · N51234 · DestroyedNTSB DEN88LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTJun 30, 1988 · N6392Q · Substantial damageNTSB CHI88LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lonsdale, MNThe pilot was executing a power-off glide and when an attempt was made to recover by adding power, the engine did not respond. The pilot was then forced to make an emergency landing in a field. During the forced landing the pilot was unable to maintain…Jun 30, 1988 · N63178 · Substantial damageNTSB BFO88LA062Accident · No injuriesLimited investigationFinal reportTravel Air D4D · Roanoke, VAThe plt reported that during the landing roll the tail wheel began to shimmy. He stated that since there was not enough airspeed to lift the tail of the acft, he applied brakes in an attempt to slow the acft. At this time the acft veered to the right. He…Jun 30, 1988 · N434N · Substantial damageNTSB ATL88LA205Accident · No injuriesLimited investigationFinal reportBeech K35 · Greensboro, NCThe flight was climbing to 11,000 feet with an instrument flight clearance when a propeller blade separated from the hub. The blade was subsequently recovered from the yard of a local resident. The fracture examination disclosed that the cracking originated…Jun 30, 1988 · N5335R · Substantial damageNTSB ANC88LA082Accident · No injuriesLimited investigationFinal reportCessna 172 · Healy, AKThe commercial pilot/flight instructor was attempting to land at a private turf airstrip when she reportedly encountered the outflow from a thunderstorm located about one mile away. She elected to continue with the landing and touched down with a greater than…Jun 30, 1988 · N739QH · Substantial damageNTSB SEA88FA120Accident · 2 fatalField investigationFinal reportCessna 150F · Skykomish, WAThe noninstrument rated pilot was attempting to follow us highway 2 westbound across the cascades mountains. According to several witnesses upon cresting the stevens pass area at an altitude of 4300 feet MSL (approximately 250 feet AGL) he encountered low…Jun 29, 1988 · N2RE · DestroyedNTSB NYC88DHD02Accident · Minor injuriesFinal reportDarlington Monnett Moni · Vincentown, NJThe plt was on his 1st flt in the home built acft. During the initial climb after takeoff, he diverted his attention from the airspeed indicator to other instruments. He believed that he may have inadvertently pulled up the nose at that time. Subsequently,…Jun 29, 1988 · N2276R · Substantial damageNTSB LAX88LA239Accident · Minor injuriesLimited investigationFinal reportCessna 206F · Healdsburg, CAJust after takeoff the engine lost power. A forced landing was made in a field where the airplane collided with rough terrain. Inspection of the engine revealed evidence of corrosion in the main fuel sump bowl and on the fuel injection throttle body fuel…Jun 29, 1988 · N33284 · Substantial damageNTSB LAX88LA238Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Agua Caliente, CADuring a cross country flight, the right engine began to run rough. The pilot feathered the propeller and turned to land at the airport. En route, the left engine began to run rough. Unable to land at the airport, a forced landing was made on a road, where,…Jun 29, 1988 · N27332 · Substantial damageNTSB LAX88DXQ02Accident · 1 fatalFinal reportBaron Minicoupe · Truckee, CAIt was reported that the purpose of the flight was to buzz friends of the pilot who were windsurfing on sailboards. The airplane was seen maneuvering erratically at a very low altitude over the boca reservoir. Witnesses said the airplane did several steep…Jun 29, 1988 · N8534A · DestroyedNTSB FTW88LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Charles, LABetween flights, the pilot noticed the nose was very high while taxiing but thought it was because the strut had failed to compress. On the next touchdown, on the main wheels, the airplane started porpoising and despite the pilot's corrections, the porpoising…Jun 29, 1988 · N3969M · Substantial damageNTSB FTW88DRD11Accident · Minor injuriesFinal reportSchweizer G-164B · Cheneyville, LAThe ag airplane was returning after spraying chemical when the engine started to lose power. During the forced landing on a highway the left wing struck a road sign. No mechanical reason for the engine power loss was found. The acft had an annual inspection…Jun 29, 1988 · N48585 · DestroyedNTSB FTW88DPJ07Accident · Minor injuriesFinal reportNorthrop C-125A · Tulsa, OKThe pilot did not hold a type rating or written authorization to act as pilot in command. The co-pilot did not hold a type rating or written authorization to act as second in command and his medical had expired. The aircraft did not have an airworthiness…Jun 29, 1988 · N3756Q · Substantial damageNTSB DEN88LA140Accident · No injuriesLimited investigationFinal reportBeech C35 · Brighton, COShortly after takeoff and while cruise flight, the eng lost pwr. The fuel pressure gauge indicated o PSI. The plt switched on the electric fuel pump. The eng did not respond. The plt activated the auxiliary (wobble) pump and switched fuel tanks. The eng still…Jun 29, 1988 · N8930A · Substantial damageNTSB CHI88FA145Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Detroit Lakes, MNJun 29, 1988 · N44140 · Substantial damageNTSB BFO88DIA01Accident · Serious injuriesFinal reportTerry Osprey II · Manassas, VAThe pilot reported that on initial climb at an alt of 300 ft AGL, engine power began to decay. A right turn was initiated to return to the runway but a further loss of power was experienced and a forced landing was attempted in a field. The acft contacted…Jun 29, 1988 · N70J · DestroyedNTSB ATL88LA204Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Collierville, TNA multiple balloon flight was being conducted to obtain publicity for the local balloon club. Television exposure of balloon flights had been shot and the balloons were in the process of landing. The reporter/passenger in the accident balloon had been through…Jun 29, 1988 · N9807N · No damageNTSB ATL88LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, SCThe student & instructor (CFI) were on a practice short field apch, simulating a 50' obstacle. The CFI rprtd that as the acft came over the threshold at about 40' AGL, the airspeed was 60 mph & the flaps were extended 40 deg. The studentreduced the power to…Jun 29, 1988 · N7392A · Substantial damageNTSB ANC88LA077Accident · No injuriesLimited investigationFinal reportHelio H-295 · Clear, AKThe commercially certificated 8,000 hour pilot was attempting to land his Helio courier airplane at a remote, private airstrip in Alaska to pick up a non-revenue passenger. He reported that he landed hard, and that the left main gear collapsed. He said that…Jun 29, 1988 · N6493V · Substantial damageNTSB ANC88LA076Accident · Minor injuriesLimited investigationFinal reportChampion 7GCB · Fairbanks, AKThe 70 hour private pilot was attempting to take off from a private turf airstrip with her non-pilot husband onboard. As she advanced the throttle to the one-half open position, the airplane veered sharply to the left. She said that she pulled the airplane…Jun 29, 1988 · N9892Y · Substantial damageNTSB ANC88LA075Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Medfra, AKThe 18 year-old 100 hour private pilot initially reported that the left wing tip of the Piper PA-20 he was piloting struck brush next to the turf runway during the landing flare. He said that the airplane veered to the left, off the runway and into the dense…Jun 29, 1988 · N7074K · Substantial damageNTSB ANC88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shismaref, AKThe pilot stated he decided to land on the beach due to weather. After touchdown on the beach the main landing gear dropped into an area of soft sand; the aircraft then went over on its back.Jun 29, 1988 · N7157Z · Substantial damageNTSB SEA88LA119Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Elko, NVPlt had just purchased acft and was on initial leg of cross-country flight. Plt calculated 4.9 hrs endurance, verified by CFI as adequate for proposed flt. After 4.2 hours tach time, fuel exhaustion occurred and a forced landing was executed 21 miles short of…Jun 28, 1988 · N35181 · Substantial damageNTSB MKC88LA117Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Warrensburg, MODuring a student pilot's first solo in a glider, the plt said he misread the altimeter by 1000 feet. Attempting to land on the airport during the low approach, he struck trees, then a fence, before ground contact.Jun 28, 1988 · N7546 · Substantial damageNTSB CHI88FA144Accident · 1 fatalField investigationFinal reportCessna 150G · Ft Wayne, INInadvertent stall/spin due to the failure to maintain adequate airspeed, and failure to avoid the adverse wind conditions associated with a thunderstorm.Jun 28, 1988 · N4744X · DestroyedNTSB ATL88LA202Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Whitsett, NCThe plt reported that the engine lost power during initial climb at 150 ft AGL. He attempted to make a 180 deg turn back to the arpt; the airplane crashed at about the 180 deg point. Post-crash exam of the engine revealed no evidence of mechanical failure or…Jun 28, 1988 · N2875Y · Substantial damageNTSB ANC88LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kenai, AKThe pilot stated that he was in a 180 degree turn when he encountered IMC conditions. The flight path had placed the pilot in a valley with cloud shrouded hills to the sides. The aircraft struck the side of a hill at 1780 MSL.Jun 28, 1988 · N65928 · Substantial damageNTSB NYC88DFJ02Accident · Minor injuriesFinal reportHiller UH-12E · Cherry Creek, NYThe pilot reported that during an aerial application operation, he heard a noise that was followed by a decay in rotor RPM. Subsequently, he was forced to land in an area of tall trees & the helicopter was damaged. An investigationrevealed that a connecting…Jun 27, 1988 · N157HA · Substantial damageNTSB MIA88WA207Accident · 1 fatalForeign investigationCessna 414 · Nassau, BahamasJun 27, 1988 · N1555T · DestroyedNTSB MIA88LA208Accident · No injuriesLimited investigationFinal reportCessna 150M · Davisville, FLAcft's engine had over 200 RPM drop on one magneto during runup. Plt attempted to takeoff with the engine running rough. After liftoff the engine began to backfire and lose power. The plt stated he then applied carburetor heat and pumped the engine primer.…Jun 27, 1988 · N704MN · Substantial damageNTSB LAX88LA236Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Lake Tahoe, CADuring the initial climb the pilot was unable to sustain a positive climb rate. The acft collided with a tree at the end of the runway and, subsequently, the ground. There were no reported mechanical failures or malfunctions. The density altitude was about…Jun 27, 1988 · N23TW · Substantial damageNTSB FTW88DRD10Accident · No injuriesFinal reportBell 206L-1 · Houma, LAShortly after liftoff, the helicopter experienced a power loss at 300 feet. During the emergency landing in a wet swampy area with very high vegetation, the helicopter landed hard, and the main rotor blades struck the tailboom. At a post accident inspection,…Jun 27, 1988 · N2611 · Substantial damage