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 NYC89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Laconia, NHAircraft striking the road sign after the aircraft experienced a double power loss due to mismanagement of the fuel system by the pilot.Dec 7, 1988 · N16502 · Substantial damageNTSB MKC89LA031Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Martelle, IAAnticipating a fuel shortage on a personal cross country flight, the plt requested the nearest airport from approach control. The nearest apt was within five miles of his destination apt so continued on course. About 15 miles from his destination, and having…Dec 7, 1988 · N198V · Substantial damageNTSB MIA89FA048Accident · Serious injuriesField investigationFinal reportCessna 150J · Gainesville, FLPlt obtained weather briefing prior to departure at which time he was told the possibility of IFR conditions on arrival at destination existed due to fog. Plt failed to obtain en route weather briefing. Near his destination, the plt encountered IFR…Dec 7, 1988 · N60029 · DestroyedNTSB LAX89LA061Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Arbuckle, CADuring cruise flight, the pilot noted oil on the windshield. The pilot diverted to a nearby airport. Enroute the windshield became covered with oil. The pilot opted to make an emergency landing on a road. Due to power lines, he diverted to an open field. Just…Dec 7, 1988 · N9569R · Substantial damageNTSB FTW89LA030Accident · No injuriesLimited investigationFinal reportCessna A185H · San Antonio, TXDuring the landing roll, the left wheel brake cylinder failed and the airplane groundlooped. The plt did not file an accident report.Dec 7, 1988 · N7392H · Substantial damageNTSB SEA89LA024Accident · No injuriesLimited investigationFinal reportCessna 180J · Ketchikan, AKThe pilot had planned to taxi the floatplane from one ramp to another for the purpose of obtaining an annual inpn & to dock the plane at better facilities. She found the float rudder pulley to be inoperative. A decision was then made to fly the plane from its…Dec 6, 1988 · N46602 · Substantial damageNTSB MIA89LA047Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Tampa, FLThe plt stated that he failed to maintain directional control during landing in a crosswind. He further stated that he aggravated the loss of control by over-application of the controls and adding full throttle which led to the aircraft departing the rwy and…Dec 6, 1988 · N86073 · Substantial damageNTSB DEN89LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Englewood, COThe CFI and her student were practicing landings on rwy 10 with winds reported as 090 deg at 5 KTS. The student was on the controls, flared too high, and the acft bounced at touchdown. The CFI told him to add power to recover from the bounced landing. The…Dec 6, 1988 · N6356D · Substantial damageNTSB LAX89LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Carlsbad, CADuring the initial climb after takeoff, the engine lost power. Subsequently, the airplane collided with terrain as the plt was completing an emergency landing. An examination of the fuel tanks disclosed no evidence of fuel in the left tank. However, aprx 9…Dec 5, 1988 · N706FL · Substantial damageNTSB FTW89LA031Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · South Marsh 113Failure and separation of one of the tail rotor blades for undetermined reasons. Thr resulting imbalance and vibration caused the separation of the 90 degree gearbox and a portion of the vertical pylon which necessitated the emergency autorotation to the…Dec 5, 1988 · N2785B · Substantial damageNTSB ATL89LA053Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Vidalia, GAAircraft experienced loss of power and returned to airport. Departed second time and experienced rough running engine. Aircraft attempted emergency landing and overturned in field. Examination of the engine revealed piston failure in #4 cylinder. Post acc…Dec 5, 1988 · N9107M · Substantial damageNTSB NYC89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Chambersburg, PAThe pilot of the Piper PA-28 was at cruise altitude and getting advisories from ATC. ATC gave him a SIGMET for turbulence when he noted his fuel was getting low. He decided to land at a nearby airport and was told by ATC that the airport he wanted was at his…Dec 4, 1988 · N2179Y · DestroyedNTSB MKC89LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Hibbing, MNWhile practicing takeoffs and landings on a patchy snow and ice covered runway, the student pilot lost directional control on takeoff and veered off the runway into a snow bank. The acft nosed down and damaged the prop and right wing.Dec 4, 1988 · N6132H · Substantial damageNTSB LAX89DVG02Accident · Minor injuriesFinal reportKnowles Thorp T-18 · Lincoln, CAThe pilot stated that he was practicing takeoffs and landings on a local flight. During one of those landings he indicated that the right wheel locked up and caused the aircraft to veer to the right. He stated that he subsequently lost control of the aircraft…Dec 4, 1988 · N77KK · Substantial damageNTSB DEN89LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Watkins, COThe student plt was practicing touch and go landings during an unsupervised solo flight. Runway 26 was in use, with winds reported as 320 deg at 5 KTS. At the first landing, the acft touched down nose first, thirty feet left of the center line. The acft…Dec 4, 1988 · N4782B · Substantial damageNTSB ATL89LA050Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawrenceville, GAAfter 3 full stop landings, the pilot reported that the airplane would not accelerate to liftoff airspeed on 4th takeoff after rolling about 2000 feet. The pilot elected to abort the takeoff. The airplane rolled off the departure end of runway 07 and nosed…Dec 4, 1988 · N5518D · Substantial damageNTSB ANC89LA021Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Homer, AKAfter landing, the plt was advised to taxi to the ramp via the south taxiway, since this was the only taxiway that had been snow plowed. Only about a 12 ft width of the 80 ft wide taxiway had been plowed. The cleared portion was on the outer edge of the…Dec 4, 1988 · N525EH · Substantial damageNTSB SEA89FA021Accident · 2 fatalField investigationFinal reportCessna 335 · Arlington, WADrg a ngt arr, the plt was vectored for a LOC rwy 34 apch. After rchg the final apch fix/outer marker (om), he was clrd for the apch. Abt 5 or 6 min later, the ATC ctlr noticed the acft was aprx 7 mi nw of the arpt, climbing abv 3000' MSL. Missed apch…Dec 3, 1988 · N2706F · DestroyedNTSB NYC89LA043Accident · No injuriesLimited investigationFinal reportCessna 185 · Hanson, MAThe pilot reported that he had just landed when the left brake failed. In order to avoid hitting trucks parked near the runway the pilot elected to ground loop the aircraft. The side loading on the left landing gear during the ground loop caused it to…Dec 3, 1988 · N6387 · Substantial damageNTSB NYC89LA037Accident · No injuriesLimited investigationFinal reportCessna 172 · Block Island, RIThe pilot of the Cessna 182 was on downwind when he stated that he pulled the carburetor heat on and then pulled the power back to 1500 RPM. Within a few seconds the engine quit and the pilot informed the tower. The aircraft landed about 500 feet short of the…Dec 3, 1988 · N19863 · Substantial damageNTSB MKC89LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeview, ARDuring a personal cross country flight, the newly certificated private pilot said he was attempting to land on a 3200 foot grass strip with an existing gusting crosswind. He lost directional control during the landing, hit a runway light, tearing off the left…Dec 3, 1988 · N4344F · Substantial damageNTSB MKC89LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Garnett, KSHaving just made a parachutist's drop, during a sky diving operation, the private pilot spiraled down from altitude to land, but had to extend his pattern to allow a departing acft to leave. During a long final approach, the engine failed and an emergency…Dec 3, 1988 · N5851B · Substantial damageNTSB LAX89LA059Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZDuring the first solo flight, the student pilot reported that while on final approach, the airplane was high. The student reduced power and extended full flaps. During the landing roll, the student was intending to exit the runway on a right taxiway, however,…Dec 3, 1988 · N47220 · Substantial damageNTSB FTW89LA029Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Texarkana, TXDec 3, 1988 · N22229 · Substantial damageNTSB FTW89LA027Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Plano, TXFuel exhaustion which resulted from the pilot's inadequate fuel consumption calculations and his failure to utilize numerous suitable sources of fuel along his route of flight.Dec 3, 1988 · N7917X · Substantial damageNTSB FTW89FA028Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Tomball, TXThe airplane was being used for touch and go landings by an instructor and a low time student. It was on a base leg to land to the south when the instructor told the tower she had lost the engine and was going down. There were no witnesses to the accident.…Dec 3, 1988 · N2379V · DestroyedNTSB CHI89FA030Accident · 2 fatalField investigationFinal reportMooney M20J · Vermillion, ILDec 3, 1988 · N201UL · DestroyedNTSB CHI89DEX02Accident · No injuriesFinal reportCessna 172 · Greencastle, INInflight collision with a large bird.Dec 3, 1988 · N5728A · Substantial damageNTSB CHI89DEV04Accident · 1 fatalFinal reportTesori Regionne 2002 · Urbana, ILThe plt transmitted on an advisory frequency 'clear the area I have engine trouble'. While turning from downwind to the base leg of his emergency approach to the airport, witnesses observed the airplane in a steep right bank when it suddenly banked left and…Dec 3, 1988 · CGFSY · Substantial damageNTSB ATL89DMG01Accident · 1 fatalFinal reportFlagg Teenie TWO · Albemarle, NCReportedly, the 150-hour pilot owner was performing a high speed taxi run to get acquainted with the airplane and its controls. The airplane taxiied down runway 22, using 3000 feet of the 4700 foot runway and suddenly became airborne. The flight continued to…Dec 3, 1988 · N4831Y · Substantial damageNTSB NYC89DNE01Accident · 1 fatalFinal reportBell 47D1 · Russell, MAA pilot induced low rotor RPM condition, followed by blade flapping as the main rotor blade contacted the tail of the helicopter.Dec 2, 1988 · N163B · DestroyedNTSB MKC89LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Little Falls, MNWhile attempting a touch and go ldg during a student solo cross country flt, directional control was lost during the takeoff phase on the snow packed runway. The student pilot said he had never landed and taken off under those runway conditions. The acft…Dec 2, 1988 · N65642 · Substantial damageNTSB LAX89DVD01Accident · 1 fatalFinal reportHitchcock JH-1 · Petaluma, CAPlt was on initial flt in newly-built gyrocopter. After takeoff, witnesses observed the acft to climb to about 100 feet then to nose over until ground impact. No evidence of mechanical failure was found.Dec 2, 1988 · N58EE · DestroyedNTSB LAX89DUQ02Accident · No injuriesFinal reportChamberlain Long EZ · Camarillo, CADuring a local test flight, the pilot had reduced power to decrease altitude for approach to the airport. When power was applied, the engine did not respond. The pilot made an off-runway landing. Inspection of the airplane revealed that the spring on the…Dec 2, 1988 · N84BJ · DestroyedNTSB FTW89DPA03Accident · Serious injuriesFinal reportBell 47-D1 · Allen, TXUnqualified pilot's poor judgement in leveling the helicopter during the flare and contributing to this was his lack of total experience in this type aircraft.Dec 2, 1988 · N74124 · Substantial damageNTSB ATL89LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Griffin, GAAfter a preflight and runup the pilot made a takeoff and remained in closed traffic for landing practice. On downwind, opposite the desired point of touchdown, he retarded power, applied carb heat and slowed the airplane. Turning base, the acft lost power.…Dec 2, 1988 · N92388 · Substantial damageNTSB ATL89FA051Accident · No injuriesField investigationFinal reportBell 206B · Pinson, ALTwo FAA inspectors were conducting currency training when the helicopter landed hard during a practice power recovery autorotation. The pilot had delayed in applying power and collective pitch. Upon contact with the ground, all engine instruments indicated…Dec 2, 1988 · N3TV · Substantial damageNTSB LAX89LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Modesto, CADuring an ILS approach in night instrument meteorological conditions, the pilot allowed the airspeed to diminish resulting in the airplane stalling. Before the pilot could regain control, the airplane collided with the terrain short of the runway. There were…Dec 1, 1988 · N5852V · Substantial damageNTSB BFO89LA013Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Washington, DCPilots failure to maintain control of the airplane during a touch and go landing.Nov 30, 1988 · N263CM · Substantial damageNTSB ATL89LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, NCThe accident occurred during the student pilot's first supervised-solo flight. The student reported that she pushed the acft's nose down while on final appch after realizing she was too high, which led to an increase in airspeed. The student's instructor…Nov 30, 1988 · N68001 · Substantial damageNTSB ATL89FA047Accident · 3 fatalField investigationFinal reportBeech P35 · Bakersville, NCDuring the VFR business flight radar data indicated the acft descended from 9,500 to approx. 5,500' MSL where it collided with a mountain. Clouds were present in the area. There were no witnesses to the accident. The wreckage was located by ELT signal. The…Nov 30, 1988 · N9584Y · DestroyedNTSB NYC89LA041Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Sharon, MAEngine power loss while landing due to fuel exhaustion.Nov 29, 1988 · N9035U · Substantial damageNTSB MKC89DCJ01Accident · 1 fatalFinal reportPiper PA-17 · Omaha, NEWitnesses observed the airplane takeoff and climb steeply to about 100 feet above ground. The airplane then turned sharply to the right and crashed into the ground in a nose low attitude. Investigation revealed no problems with either engine or airframe.Nov 28, 1988 · N4691H · Substantial damageNTSB MIA89LA046Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Atlantic Ocean (Atlantic Ocean)The student pilot contacted ifss at miami, FL and filed an intl flight plan to the Bahamas. He did not request a weather briefing and none was given. The pilot later contacted controllers and stated that he was in instrument meteorological conditions and…Nov 28, 1988 · N7926N · DestroyedNTSB MIA89LA045Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Crestview, FLWhile in cruise flt near an arpt, the prop separated. Plt was given vectors to arpt & entered pattern for lndg. Downwind leg was extended due to strong tailwind. Strong headwind on final caused acft to land short. During landing roll acft collided with two…Nov 28, 1988 · N8226P · Substantial damageNTSB MIA89IA043Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · San Juan, PRCompany maintenance crews replaced the high pressure bleed valve prior to the flight and installed the mounting clamp improperly. After takeoff the valve disconnected and the bleed air discharge activated the fire warning system. The crew discharged both fire…Nov 28, 1988 · N80057 · Minor damageNTSB LAX89FA057Accident · 1 fatalField investigationFinal reportBeech N35 · Hanford, CAThe pilot failed to maintain sufficient altitude and descended below the minimum descent altitude while executing the missed approach. Contributing to this accident was the deteriorating weather conditions and the pilot's wish to return the airplane to its…Nov 28, 1988 · N9469Y · DestroyedNTSB DEN89FA038Accident · 1 fatalField investigationFinal reportCessna 150L · Fairplay, CONov 28, 1988 · N1464Q · DestroyedNTSB CHI89LA029Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas 269C · Frankfort, ILThe helicopter experienced a tree strike with the main rotor blades and then rolled over when it struck the ground during a precautionary landing attempt. The helicopter had been conducting contract power line patrol when the PIC noted an apparent partial…Nov 28, 1988 · N1098P · Substantial damageNTSB MIA89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Fort Pierce, FLAir traffic controllers stated that while the aircraft was on short final they noticed that the gear on the aircraft was not extended. They attempted to contact the pilot but he never responded. The pilot stated that he failed to extend the landing gear prior…Nov 27, 1988 · N45MA · Substantial damage