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 BFO88LA045Accident · No injuriesLimited investigationFinal reportMooney M-20J · Yorktown, VAThe plt was returning to the arpt after a 20 minute local flight. About 5 miles from the arpt he noticed the oil pres/temp gages indicated zero even after he checked the circuit breakers-shortly afterward the engine began to lose power and vibrate severely.…May 11, 1988 · N567MM · DestroyedNTSB SEA88LA092Accident · No injuriesLimited investigationFinal reportCessna 185 · Mercer Island, WAThe pilot stated that the aircraft struck a log while landing on the water. The aircraft then nosed over inverted and sank.May 10, 1988 · N1701R · Substantial damageNTSB SEA88LA090Accident · No injuriesLimited investigationFinal reportAyres S2R Thrush · Lind, WADuring an aerial application maneuver, a total loss of power occurred due to the number nine cylinder failing. A restart was attempted, but was unsuccessful. The pilot made a forced landing onto a very soft sandy field, where the aircraft nosed over inverted…May 10, 1988 · N5660X · Substantial damageNTSB MIA88IA167Incident · No injuriesIncident investigationFinal reportBeech 200 · Chicago, ILMidway flt 172 (Mcdonnell Douglas DC-9, N1065T) was on an IFR departure from Chicago midway arpt at the same time that Beech 200, N981LL, was on an IFR arrival for a visual apch to merrill c meigs arpt, although both were in VMC. Previously, o'hare TRACON had…May 10, 1988 · N981LL · 2 aircraft · No damageNTSB ATL88LA170Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elizabethton, TNThe flt was being accomplished to refamiliarize the commercial plt with the airplane prior to completing the remainder of the training curriculum. One takeoff and ldg had been completed without incident. During the second approach to landing, it was related…May 10, 1988 · N8641V · Substantial damageNTSB ATL88LA169Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Raeford, NCThe airplane lost power shortly after takeoff, at 100-200 ft AGL. A witness reported hearing the engine backfire several times before it lost power completely. The airplane crashed shortly thereafter, as the pilot was attempting to return to the arpt. Exam of…May 10, 1988 · N5678B · Substantial damageNTSB SEA88LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Kennewick, WADuring landing roll the aircraft's nose gear began to shudder, with the nose gear turning 90 degrees to the left. The aircraft then nosed down onto the nose and right wing. Visual examination of the aircraft's shimmy dampener arm assembly revealed a previous…May 9, 1988 · N7090A · Substantial damageNTSB MKC88FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Mansfield, MOA witness saw the acft flying at low alt as it passed in front of her car at dusk in a northeasterly drctn. She rprtd the acft contd down a valley toward power lines that spanned an open field. She saw the acft pull up rapidly, become entangled in the power…May 9, 1988 · N8605S · Substantial damageNTSB LAX88DVA05Accident · No injuriesFinal reportHiller 12E · Firebaugh, CADuring an aerial application, the helicopter collided with a guy wire and then a field. The pilot knew that the wire was there. He stated that he simply forgot that it was there and did not see it. There were no mechanical problems prior to the accident.May 9, 1988 · N117HA · Substantial damageNTSB FTW88LA098Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Sour Lake, TXThe acft struck trees and the grnd during a night cross country in marginal weather. The non-instrument rated pvt plt stated that he was flying in cruise flt at 1250' MSL when he hit trees. The closest wx station recorded 1200 overcast with 5 miles…May 9, 1988 · N3853V · DestroyedNTSB FTW88IA097Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Detroit, MIThe PIC made an unscheduled landing following decompression at 30,000 feet. The aircraft had been written up by flightcrews numerous times between may 7 and may 9 for pressurization problems. Pressure bulkhead at station 940 in the right wheel well cracked 15…May 9, 1988 · N800AA · Minor damageNTSB CHI88FA110Accident · No injuriesField investigationFinal reportBoeing 747-136 · Chicago, ILFailure of the number three flap track due to stress corrosion cracking. Factors contributing to this failure are insufficient design of the member and inadequate inspection and maintenance procedures to detect cracks before they propagate to a critical…May 9, 1988 · GAWND · Substantial damageNTSB ATL88FA168Accident · 1 fatalField investigationFinal reportHughes 269A · Ozark, ALThree months prior to the accident a mechanic repaired the left magneto. He reinstalled it and timed it with the right magneto. Both magnetos were found to have advanced timing. Internal examination showed discrepancies which would lead to electrical…May 9, 1988 · N1038Y · Substantial damageNTSB ANC88LA055Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Kodiak, AKThe pilot stated that during the takeoff run he lost control of the aircraft causing the aircraft to nose over on its back at the departure end of the lake. The plt had been issued a special VFR clearance by Kodiak tower due to existing wx conditions. The plt…May 9, 1988 · N8842D · Substantial damageNTSB NYC88LA136Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · Lyons, NYPilot failed to maintain airspeed during his go around.May 8, 1988 · N7982L · DestroyedNTSB MIA88LA165Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Jacksonville, FLThe plt stated that he had just brought the acft to a stop & had shut down both engs. At that time, the lt. gear collapsed. Maintenance crew found that one of the actuating cyls was out of adjustment & the bungee cords were weak. The gear assy itself appeared…May 8, 1988 · N57222 · Substantial damageNTSB LAX88DUJ04Accident · Serious injuriesFinal reportStarr Bumble BEE II · Marana, AZThe airplane was on its first flight since being certified. The pilot had overhauled the engine 2.5 hours prior to the flight. During the climb the engine lost power. The airplane rolled to the left and collided with a utility pole then the ground. The pilot…May 8, 1988 · N89WS · DestroyedNTSB FTW88LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Pawnee, OKAircraft's flight envelope was exceeded.May 8, 1988 · N1424C · DestroyedNTSB CHI88LA109Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INMay 8, 1988 · N43DR · Substantial damageNTSB NYC88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blairstown, NJThe flight was on final for runway 7 following another airplane, when the pilot's attention was drawn to a glider maneuvering in the area. He yielded left to maintain a comfortable distance from the glider and failed to observe an antenna tower in his path.…May 7, 1988 · N6762P · Substantial damageNTSB MKC88DCQ02Accident · 1 fatalFinal reportPiper PA-25-150 · Chase, KSWitnesses stated they saw the acft spraying a hayfield. They observed the acft strike a powerline as it was making a turn. The pilot stated that his wing clipped the powerline and that the acft went into a flat spin from which he couldn't recover.May 7, 1988 · N6337Z · Substantial damageNTSB LAX88FA192Accident · 2 fatalField investigationFinal reportBeech 35 · Santa Paula, CAPilot's failure to maintain an airspeed at which the aircraft is controllable and above the stall speed.May 7, 1988 · N3322V · DestroyedNTSB LAX88FA176Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Guatay, CAFailure of the pilot to maintian VFR while flying in mountainous terrain.May 7, 1988 · N4367J · DestroyedNTSB DEN88FA106Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Cortez, COThe plt said that he had just taken off and reached an alt of about 300 ft when his collective control went 'limp'. The helicopter entered a descent, partially controlled by the plt using throttle and cyclic control inputs. The helicopter touched down in soft…May 7, 1988 · N8455E · DestroyedNTSB DEN88DTE04Accident · No injuriesFinal reportGrumman G-164A · Vona, COThe pilot said the wind was calm when he got in the aircraft before takeoff. He said that when the aircraft reached about 50 feet AGL, after takeoff, he encountered a tailwind. The aircraft settled and collided with the ground. The ground was soft and the…May 7, 1988 · N8518H · Substantial damageNTSB CHI88LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sault Ste Marie, MIDuring taxi for take-off, the student pilot attempted to apply brakes as he neared the end of the runway. As the aircraft veered to the left, he noted that his right foot was not on the brake pedal. The aircraft left the taxiway and struck a fire hydrant,…May 7, 1988 · N15372 · Substantial damageNTSB CHI88LA108Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Minneapolis, MNThe pilot was executing a downwind takeoff, the winds reportedly gusting to 25 knots, loaded with two passengers, when just after takeoff the pilot stated the helicopter experienced a loss of power. The pilot then attempted to execute an autorotation, but…May 7, 1988 · N9487F · Substantial damageNTSB CHI88DEE04Accident · Minor injuriesFinal reportCessna 205 · Moline, ILDuring initial climb on a pleasure flight the airplane experienced a loss of fuel pressure and then total engine failure. The airplane nosed over during the subsequent off airport landing. Post accident examination of the engine driven fuel pump revealed…May 7, 1988 · N647MA · DestroyedNTSB ATL88LA167Accident · No injuriesLimited investigationFinal reportCessna 172P · Bowling Green, OHThe plt reported that he reduced the pwr to idle while on final appch after determining that the airplane was too high. He then lowered the nose to 'accelerate the descent'. The airplane touched down long on the rwy at about 90 KTS, and began to porpoise. He…May 7, 1988 · N5495K · Substantial damageNTSB SEA88LA088Accident · No injuriesLimited investigationFinal reportCessna 172M · Hood River, ORPlt had diverted back along course to land because of observed wx ahead. On late final, a strong wind gust tipped the acft to near wings-vertical attitude. Plt managed to correct to wings level but could not control altitude loss before ground contact. Plt…May 6, 1988 · N12659 · Substantial damageNTSB NYC88DFJ01Accident · Minor injuriesFinal reportHurd/Drifter XP503 · Baldwinsville, NYThe plt rprtd that during a preflt, he noted the fuel tank was about 1/4 full. He rprtd that as he was taking off, the acft was climbing thru about 200 ft AGL, when the eng lost power. From that position, he was unable to rtrn to the arpt or glide to an open…May 6, 1988 · N29CH · Substantial damageNTSB MKC88LA087Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Waldenburg, ARThe acft was being positioned for an aerial application operation. While landing, the acft struck a 1.5 ft levee at the end of the private grass strip. Subsequently, the main gear sheared off, the wings were buckled & the prop was damaged.May 6, 1988 · N6782K · Substantial damageNTSB MIA88LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Everglades City, FLThe plt stated when the flt departed, there was 33 gals of fuel aboard for the x-c daylight flight. Fuel burn for the acft was approx 8 gph. The flt to the dest required about 1.5 hrs. The plt stated that he intended to refuel at his destination, but the FBO…May 6, 1988 · N285DP · Substantial damageNTSB ATL88LA166Accident · 1 fatalLimited investigationFinal reportPiper J5C · Gulf Shores, ALA witness reported that the airplane encountered a 'downdraft' while attempting to pick up a banner. The main ldg gear caught the banner pick-up line and carried the banner aloft. The witness radioed the plt to advise him of the situation, but received no…May 6, 1988 · N41333 · Substantial damageNTSB ANC88LA054Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Hunter Creek, AKAfter landing at a mining camp airstrip, the right landing gear failed causing the aircraft to ground loop. Examination of the broken gear part revealed the original fracture to be a fatigue fracture. The initial crack in the gear leg ran parallel to the gear…May 6, 1988 · N22901 · Substantial damageNTSB MKC88FA085Accident · Serious injuriesField investigationFinal reportCessna 182K · Neligh, NENone submittedMay 5, 1988 · N2872R · Substantial damageNTSB LAX88LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAThe student pilot's flt purpose was to practice takeoffs & landings at a different arpt. When he departed, the winds were the same as the dest arpt. The CFI felt that a weather briefing was not required. The student touched down on rwy 24 & the acft began…May 5, 1988 · N25294 · Substantial damageNTSB LAX88DUG03Accident · No injuriesFinal reportStolp-Starduster Too SA-300-A · Chino, CADuring the ground run for take off, the left main gear strut broke. The main landing gear collapsed resulting in substantial damage. The reason for the strut failure was undetermined.May 5, 1988 · N1300S · Substantial damageNTSB CHI88LA107Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lake Village, INThe pilot had landed long and, realizing he would not stop before running off the runway, attempted a go-around. The pilot stated he had one notch of flaps down, approximately 10 degrees, and after adding full power attempted to lift-off. The aircraft ran off…May 5, 1988 · N55552 · Substantial damageNTSB ATL88LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lawrenceville, GAThe student plt returned to the departure arpt and attempted a landing with a cross wind gusting to an estimated 20 KTS. After landing, a gust of wind was encountered. The aircraft became airborne. The student pilot held the aircraft's controls rigid. The…May 5, 1988 · N8205 · DestroyedNTSB MIA88LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Freeport, BahamasThe pilot's inadvertent encounter with adverse weather.May 4, 1988 · N8068J · Substantial damageNTSB LAX88DVG04Accident · No injuriesFinal reportHiller UH-12E · Winters, CAThe pilot was taking off from a loading truck for his 16th aerial application. He reduced the load from 90 to 70 gals because the winds had become variable. The helicopter descended into ground effect where it normally attains translational lift. The…May 4, 1988 · N62391 · DestroyedNTSB ANC88LA053Accident · 1 fatalLimited investigationFinal reportCessna 150L · Kotzebue, AKThe aircraft crashed five miles south of the city along the beach line. FAA inspectors, the Alaska state troopers accident report and several witnesses revealed that the pilot stated prior to the flight that he intended to commit suicide. The plt had a fight…May 4, 1988 · N6592G · DestroyedNTSB CHI88LA106Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Eden Prairie, MNWhile on an aircraft familiarization for purpose of check out, the pilot encountered a gusty crosswind on landing and failed to maintain aircraft control. The instructor pilot took over the controls, but was unable to regain directional control, and the…May 3, 1988 · N29935 · Substantial damageNTSB ATL88LA164Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Wilkesboro, NCAfter a normal approach and landing, the left main gear slowly collapsed during the roll out. The aircraft veered to the left, struck a sign off the runway edge and collided with a ditch. The left main gear was found unlocked during postaccident…May 3, 1988 · N34GK · Substantial damageNTSB ANC88FA052Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Larson Bay, AKA float equipped Piper PA-18-150 and float equipped Cessna 185F, were involved in a midair collision at an altitude of approximately 800 feet MSL over Larson Bay, AK. At the time of the midair collision both aircraft were being used as fish spotters for…May 3, 1988 · N54768 · 2 aircraft · DestroyedNTSB MKC88LA083Accident · Minor injuriesLimited investigationFinal reportHyde Quickee · Creve Coeur, MOThe plt, flying the unfamiliar homebuilt canard type acft for the first time, said shortly after takeoff the acft began to buffet and sink. The acft then entered a steep bank and continued sinking until it struck the terrain. Corrective attempts by the plt to…May 2, 1988 · N263Q · Substantial damageNTSB MIA88LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Centerville, MSThe pilot stated that he thought the aircraft had been refueled the previous evening. During preflight he did not observe any fuel in the aircraft fuel tanks. He further stated that the aircraft fuel quantity guages had been unreliable. In cruise flight both…May 2, 1988 · N7353R · Substantial damageNTSB LAX88DVG03Accident · No injuriesFinal reportSchweizer G-164B · Gridley, CADuring an agricultural operation, the engine quit at approximately 50 feet AGL. The airplane was landed on a dirt field and nosed over. Inspection of the engine revealed that the left magneto drive gear teeth were missing and the right magneto drive gear was…May 2, 1988 · N3627Q · Substantial damageNTSB LAX88DVA04Accident · 1 fatalFinal reportSchumann KR-2 · Merced, CAThe pilot was flight testing a new airplane that he had constructed. He had completed two touch and go landings. During a third approach, witnesses observed the airplane approaching the runway at a very high airspeed. The airplane touched down on the runway…May 2, 1988 · N127AS · Destroyed