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 LAX88DUM01Accident · Serious injuriesFinal reportDurbin Monnett Moni · Ramona, CAAcquaintances of the plt rprtd he had performed maintenance to repair an inoperative airspeed indicator. He then took off on a test flt. A witness, who was a plt, rprtd the eng started to 'cut out' at about 200 to 300 ft AGL, the tail 'waggled a couple of…Nov 1, 1987 · N190PJ · DestroyedNTSB ATL88LA027Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Moultrie, GAThe plt took off to the north at the private, sod airstrip. He rptd that the acft began to 'drop' shortly after liftoff. He then attempted to arrest the descent by increasing the nose-up pitch angle, and the acft 'began to stall'. He aborted the takeoff and…Nov 1, 1987 · N3798X · Substantial damageNTSB ATL88FA025Accident · 1 fatalField investigationFinal reportMooney M-18C-55 · Camden, OHThe pilot took off downwind and did not use all of the available runway. With insufficient airspeed, the aircraft stalled shortly after takeoff. The pilot was unable to recover within the altitude remaining and collided with an oncoming train.Nov 1, 1987 · N4157 · DestroyedNTSB NYC88LA025Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Millbrook, NYThe aircraft had just become airborne when power fluctuation occurred. On the second power loss, carburetor heat was applied but the engine lost power completely. The instructor pilot was making a turn back towards the airport when the wing contacted trees…Oct 31, 1987 · N8362G · Substantial damageNTSB NYC88LA022Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33 · Blairstown, NJAs the glider was being towed it lifted too high above the tow plane. At an altitude of about 55 to 65 feet it was disconnected. However the glider was tilting slightly to the right and as the pilot attempted to correct, it stalled and crashed.Oct 31, 1987 · N2669H · DestroyedNTSB NYC88LA021Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F21B · Montgomery, NYThe aircraft was on approach for landing on runway 26 at orange county airport. However the aircraft collided with a tree about 200 yards from the runway threshold just outside of the airport boundary.Oct 31, 1987 · N4419C · DestroyedNTSB MKC88FA012Accident · Serious injuriesField investigationFinal reportMerchant Pitts S-1S · Vinton, IAThe plt was rprtd to be on a maint ferry flt to another state. He rprtd that before the flt, he topped off the fuel tank & that the preflt, takeoff & departure were normal. Due to low clouds, he leveled off at aprx 2000' AGL. Shortly thereafter, the eng RPM…Oct 31, 1987 · N76EM · Substantial damageNTSB MIA88LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Sarasota, FLDrg arrival, while being transferred from tampa apch ctl to twr ctl, the plt was clrd to lnd on rwy 14. Bfr lndg, he was adzd the wind was fm 070 deg at 15 KTS. Rwy 4 was available, but it was not suggested by the twr ctlr or reqd by the plt. The plt stated…Oct 31, 1987 · N2746Q · Substantial damageNTSB MIA88FA024Accident · 1 fatalField investigationFinal reportBeech C-55 · Brookhaven, MSThe pilot of the twin engine aircraft landed with vis 1/2 mile in fog and realized he had landed long. He executed a go-around and on the second landing forgot to lower the landing gear. The propellers stuck the runway and severely damaged one propeller. He…Oct 31, 1987 · N640B · DestroyedNTSB LAX88WA031Accident · No injuriesForeign investigationCessna 421C · Wollongong, AustraliaOct 31, 1987 · N8410G · Substantial damageNTSB LAX88LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · San Jose, CAWhile flying 500-600 feet above the terrain on a local pleasure flight, the pilot turned into what he believed to be an open ended canyon. After becoming aware that he had inadvertently turned into a box canyon, the pilot attempted a 'chandelle turn' to exit…Oct 31, 1987 · N4771A · DestroyedNTSB LAX88LA029Accident · No injuriesLimited investigationFinal reportCessna 182A · Laveen, AZThe pilot stated that he was ferrying his aircraft three miles to a private strip. Shortly after takeoff, the engine began losing power. The pilot did not think he could make it to the private strip so he attempted a precautionary landing on a dirt road. He…Oct 31, 1987 · N3804D · Substantial damageNTSB LAX88FA065Accident · 2 fatalField investigationFinal reportBritten-Norman BN2A-26 · Desert Center, CAThe plt was hired to ferry an islander from el paso, TX to santa paula, CA. He represented himself to the ferry company as being an experienced islander plt. No previous islander flt time was found in the pilot's logbook. It was the plt's 40th birthday & he…Oct 31, 1987 · N25MR · DestroyedNTSB FTW88LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Angelo, TXWhile on a long final approach the aircraft ran out of fuel. The pilot made a forced landing in a field. During landing roll the nose gear collapsed, the main landing gear came off, and both wings were damaged. The pilot stated that he could have avoided the…Oct 31, 1987 · N3449J · Substantial damageNTSB DEN88LA017Accident · No injuriesLimited investigationFinal reportPiper J5A · Devils Lake, NDA commercial plt was giving instruction to another commercial plt with a CFI rating. Witnesses observed the aircraft at approximately 100 feet over a water fowl production lake. The plt stated that during a turn and pull up, the engine lostpower and the…Oct 31, 1987 · N32887 · Substantial damageNTSB DEN88DTE01Accident · No injuriesFinal reportQuickie Q-200 · Watkins, COThe plt rprtd he failed to lock the aileron reflexers tight for landing. During the landing roll, the lock slipped & the tail lifted off the rwy. Subsequently, the acft veered to the right, went off the rwy & hit a mudhole, then flipped over.Oct 31, 1987 · N275CH · Substantial damageNTSB CHI88LA014Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Lapeer, MIThe helicopter was in cruise flt when the rgt side horizontal stabilizer attach tube failed & separated from the tail boom, then contacted the tail rotor. This resulted in failure of the tail rotor drive shaft flex coupling at the tail rotor gear box. In…Oct 31, 1987 · N9583 · Substantial damageNTSB CHI88LA009Accident · No injuriesLimited investigationFinal reportCessna R182RG II · Indianapolis, INAfter take-off, the pilot attempted to retract the landing gear when the hydraulic line on the right main gear actuator failed. The left main landing gear was stuck in the trailing position while the nose gear and right main gear remained down and locked. The…Oct 31, 1987 · N739JG · Substantial damageNTSB CHI88FA012Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Lawrenceville, ILWhile performing aerobatic maneuvers the aircraft entered a spin to the left and did not recover before impacting the ground. The acft entered the spin after the plt announced that this spin would be the last maneuver before landing. The spin was started at…Oct 31, 1987 · N41682 · DestroyedNTSB NYC88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Windham, CTThe flight departed groton, Connecticut enroute to willimantic, Connecticut in unlimited visibility. However at Windham airport, the runway was partially obscured by patchy fog according to the pilot. The pilot landed long due to carrying additional speed in…Oct 30, 1987 · N38334 · Substantial damageNTSB NYC88LA020Accident · No injuriesLimited investigationFinal reportAgusta 109A · Spring Valley, NYThe helicopter had been refueled and the pilot was attempting to ground taxi. Prior to turning the aircraft around to taxi to a parking area the helicopter went into ground resonance as soon as the aircraft was moved. Collective was lowered, the engine…Oct 30, 1987 · N109AM · Substantial damageNTSB MIA88FA023Accident · 2 fatalField investigationFinal reportCessna 150E · Aguadilla, PRWitnesses observed the acft maneuvering a low alt over ocean water near a shoreline. They saw it pull up sharply to clear a commercial boat dock, then nose over & impact the water in a nose low, rgt wing low attitude. The acft sank & came to rest in 30' of…Oct 30, 1987 · N4081U · DestroyedNTSB FTW88DRG02Accident · No injuriesFinal reportGrumman Schweizer G-164A · Edcouch, TXAfter a normal takeoff and climb to 200 feet AGL the pilot reduced power and the engine quit. A forced landing was made into a dry but soft plowed field. The aircraft rolled 300 feet and then nosed over into an inverted attitude and stopped. The engine was…Oct 30, 1987 · N45691 · Substantial damageNTSB MIA88LA022Accident · No injuriesLimited investigationFinal reportMooney M20F · Vero Beach, FLPlt stated that while turning final approach he believes he placed the landing gear handle in the down position and observed red gear intransit lights. He was occupied by a strong wind for the landing and never checked for a gear down and safe indication. The…Oct 29, 1987 · N413HM · Substantial damageNTSB LAX88FA028Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Buttonwillow, CAA Piper PA-24-250 collided with terrain while on an IFR flight. The pilot received a wx briefing from fss. While en route, radio and radar contact was lost, then regained. The pilot stated to ATC that the acft had been struck by lightning. He elected to…Oct 29, 1987 · N5431P · DestroyedNTSB CHI88IA015Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILThe south rwys (32L, 9R, & 4R) were being ctld by the south LCL ctlr (slc) & the north rwys (9L & 4L) were ctld by the north LCL ctlr (nlc). At 1543:26, slc told united flt 973 (Boeing 737) to hold on 32L & expect a 3 min delay bfr tkof. Air Wisconsin flt 954…Oct 29, 1987 · N305UA · 2 aircraft · No damageNTSB MIA88LA021Accident · No injuriesLimited investigationFinal reportParrish Dragonfly · Boca Raton, FLWhile on short final approach the flight encountered a wind gust which caused the left canard to drop. The landing gear on the left canard then struck the raised lip of the runway causing substantial damage. The aircraft came to rest on the runway.Oct 28, 1987 · N41GK · Substantial damageNTSB MIA88IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-214 · St CroixPaa flt was on visual apch and in contact with apch control who informed flt of two acft ahead also on visual apch. The controller offered vectors to clear traffic. Paa flt elected to continue current heading. The two preceding acft were on twr freq giving…Oct 28, 1987 · N375PA · 2 aircraft · No damageNTSB LAX88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casa Grande, AZDuring an instructional flt, the student was performing climbs, descents and turns when the engine sputtered and lost power. The flight instructor took control of the aircraft but was unable to restart the engine. The aircraft was landed on a dirt road where…Oct 28, 1987 · N4101E · Substantial damageNTSB FTW88MA021Accident · Minor injuriesMajor investigationFinal reportConvair 640 (340D) · Bartlesville, OKThe capt was cross-feeding both engines from the right tank while the first officer (f/o) was flying, without informing the f/o. the capt then left the cockpit while cross-feeding. Both tank valves and the right boost pump were on. The right tank ran dry, the…Oct 28, 1987 · N3411 · DestroyedNTSB FTW88LA019Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Fort Supply, OKThe acft was forced to land due to loss of eng power. The plt attempted to land on a roadway. During the landing the acft rt wing struck a fence post. The landing gear collapsed during a groundloop after lndg. Post acc investigation revealed that the eng was…Oct 28, 1987 · N2LU · Substantial damageNTSB CHI88IA011Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILA wing panel separated from the airplane while in cruise flight. Crew declared an emergency and landed without further incident. Examination revealed that maintenance personnel did not fasten 4 of the 5 rod end assembilies used to secure the panel to the top…Oct 28, 1987 · N1813U · Minor damageNTSB ANC88LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Iliamna, AKThe acft eng lost oil pressure during cruise. The plt attempted to land on a small airstrip. He did not make it to the strip and overran nearby tundra into Iliamna lake. The oil pump housing was broken; one gear was split and the other had a broken tooth. The…Oct 28, 1987 · N43639 · Substantial damageNTSB NYC88LA019Accident · Minor injuriesLimited investigationFinal reportBeech 19A · Buena, NJa loss of electrical power for undetermined reasons, which necessitated a precautionary landing. Factors were rain, clouds, dark night, and the pole. This report was modified on February 9, 2005.Oct 27, 1987 · N5082T · Substantial damageNTSB LAX88LA025Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas 369D · Borrego Springs, CAThe pilot and three passengers were flying at low altitude over mountainous terrain looking for big horn sheep. Thirty minutes into the flight the pilot heard a loud noise and the tail yawed left. The pilot turned away from the mountain to look for a place to…Oct 27, 1987 · N47861 · Substantial damageNTSB FTW88LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, TXThe pilot landed long and could not stop before running off the end of the runway. The aircraft, collided with a fence and the left wing was damaged when the acft collided with a ditch.Oct 27, 1987 · N3931L · Substantial damageNTSB ATL88LA024Accident · Minor injuriesLimited investigationFinal reportCessna 337C · Columbus, OHPIC rpted rear eng quit after take-off. Fuel selector found on right main tank which was empty. Prop was not feathered and landing gear was found in transient position after crash. Owners manual cautions against higher drag with gear in transit due to large…Oct 27, 1987 · N11GL · Substantial damageNTSB ANC88LA014Accident · No injuriesLimited investigationFinal reportPiper PA32 · Larsen Bay, AKThe pilot stated the wind on the surface was light and variable and while he was on final approach the airplane developed a high sink rate from which he was late effecting recovery. The airplane struck the ground short of the runway threshold.Oct 27, 1987 · N2585M · Substantial damageNTSB SEA88LA014Accident · No injuriesLimited investigationFinal reportBell 47G2 · Lebanon, ORThe student was performing an autorotation at about 50' AGL and the flare was begun. The instructor pilot noticed that the helicopter was not leveling and took control of the aircraft. The helicopter settled tail low onto the soft ground striking the tail…Oct 26, 1987 · N6141 · Substantial damageNTSB SEA88LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Snoqualamie Pss, WAThe pilot was advised that with his proposed route of flight VFR was not recommended due to low clouds and marginal visibility. The pilot elected to fly through the area at night and encountered low clouds and marginal visibility. While attempting to climb…Oct 26, 1987 · N44856 · DestroyedNTSB LAX88DUJ01Accident · Serious injuriesFinal reportWarnke Sonerie II · Patagonia, AZDuring a local flight, the engine lost power. Subsequently, the aircraft was extensively damaged during a forced landingin mountainous terrain. The reason for the power loss was reported to be from an electrical malfunction of the ignition system.Oct 26, 1987 · N505BW · Substantial damageNTSB FTW88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Ardmore, OKDuring landing, the aircraft touched down about 15 feet short of the runway causing the rt main gear to collapse. The acft slid approx 800 ft BEF0RE coming to rest on the rwy. Both gear penetrated the upper skin on the wings.Oct 26, 1987 · N742WP · Substantial damageNTSB FTW88DPJ02Accident · Serious injuriesFinal reportPiper PA-25 · Catoosa, OKThe pilot stalled the aircraft while turning downwind during a practice agricultural operation. The aircraft impacted the ground out of control. The pilot stated that he could not recall anything about the flight.Oct 26, 1987 · N9787P · DestroyedNTSB DEN88FA016Accident · 3 fatalField investigationFinal reportBeech A-36 · Mitchell, SDThe acft had been cleared for the VOR approach at Mitchell municipal arpt at approx 1915 CST. The acft collided with the ground in a slight nose down attitude about 12 miles northwest of the arpt at the point where the procedure turn intersected the inbound…Oct 26, 1987 · N1257E · DestroyedNTSB ANC88IA013Incident · No injuriesIncident investigationFinal reportCessna 402B · Cordova, AKThe company maintenance personnel were aware of a shimmy problem but they thought is was only worn bushings. The maintenance people stated they inspected the part but found no problem. The pilot-in-command also stated he found no problem upon visually…Oct 26, 1987 · N5718M · Minor damageNTSB ANC88FA012Accident · No injuriesField investigationFinal reportCessna 185 · Anchorage, AKThe relatively inexperienced seaplane pilot-in-command made one go around when he experienced difficulty in identifying the surface of the glassy water. On the second landing attempt he flew the airplane into the water at a negative angle of attack. The…Oct 26, 1987 · N9946X · Substantial damageNTSB NYC88LA018Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Laconia, NHThe plt rprtd he was demonstrating a full touchdown autorotation in winds that were from 290 deg at 15 gusting 20 KTS. He stated the touchdown was soft with a lot of pitch pulled in; however, as he lowered the collective after touchdown, the retreating blade…Oct 25, 1987 · N51699 · Substantial damageNTSB NYC88LA017Accident · Minor injuriesLimited investigationFinal reportPiper J-4 · St. Paul, PAThe flight was enroute from mount pleasant to winchester, Virginia on a heading of 140 degrees and at 4500 feet. About 25-30 minutes into the flight, engine power loss was experienced. The pilot switched from the auxilliary to the main fuel tank and applied…Oct 25, 1987 · N28205 · Substantial damageNTSB NYC88LA016Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Barre, MAThe aircraft was in the traffic pattern when it experienced a power loss. The plt made an off-airport landing in a wooded area. The pilot reported that he was in a slip prior to and at the time of the reported power loss. The FAA reported that the engine…Oct 25, 1987 · N333FG · Substantial damageNTSB MIA88LA039Accident · No injuriesLimited investigationFinal reportPitts S-1C · Clearwater, FLThe plt stated that on landing roll, as he added power to go around, he lost control of the aircraft, ran off the runway, flipped over and came to rest inverted. The torque of the relatively powerful engine added to the control problems in this short fuselage…Oct 25, 1987 · N14SH · Substantial damage