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 FTW88LA095Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Pipe Creek, TXShortly after takeoff, the engine started running rough. The pilot said he thought he could make the airport and turned toward it. Just short of the airport, the engine quit completely. The pilot was able to get to the airport but crossways to the runway.…May 2, 1988 · N80799 · Substantial damageNTSB DCA88IA056Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Nr Tokyo, JapanUnited flt 97 experienced indications of uneven fuel flow from main tanks 2 and 3 at FL360 beginning about 4- hours after departure on an 11-hour transpacific flight. The fuel system had been set up for all engine feed from the nos 2 and 3 tanks. Although it…May 2, 1988 · N157UA · Minor damageNTSB ATL88LA163Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Canfield, OHThe plt reported that the he elected to go-around after realizing he was going to land long. A gust of wind lifted up the left wing as he initiated the go-around, and he lost control of the airplane. It subsequently impacted the terrain on the right side of…May 2, 1988 · N5061M · Substantial damageNTSB ATL88LA161Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Greenwood, SCThe plt reported that the engine RPM began to drop. Shortly after he took off from an open field. He opened the throttle further in an attempt to regain RPM but the engine did not respond. The helicopter subsequently crashed onto a bldg roof as the plt…May 2, 1988 · N58197 · Substantial damageNTSB ATL88FA162Accident · No injuriesField investigationFinal reportBeech 55 · Atlanta, GAMay 2, 1988 · N2025W · Substantial damageNTSB SEA88LA087Accident · Minor injuriesLimited investigationFinal reportStearman A-75-N1 · Medford, ORPlt performed a negative 'g' maneuver, estimated at 2 to 2.5 negative 'g' force, following which the engine lost power. A forced landing was accomplished in scrub trees. The engine is equipped with a float carburetor. There were indications that the cause of…May 1, 1988 · N53125 · Substantial damageNTSB NYC88FA133Accident · 1 fatalField investigationFinal reportBell 206B · Long Island Cty, NYThe Bell 206B was on a sightseeing flight around the Island of manhattan when it experienced a low rotor RPM situation. The pilot said he could not recover rotor RPM and made a forced landing in the east river. The pilot and three passengers exited the…May 1, 1988 · N7094J · DestroyedNTSB MKC88FA082Accident · Serious injuriesField investigationFinal reportCessna 180 · Rolla, MOAs the pilot approached the Rolla, Missouri airport he stated that he switched the fuel tank selector from the right tank to both tanks in preparation for landing. The pilot stated that he did not know which direction he moved the fuel selector valve. Engine…May 1, 1988 · N9161C · Substantial damageNTSB LAX88LA171Accident · No injuriesLimited investigationFinal reportCessna 180B · Quincy, CAAt the end of a pleasure flight, while in the traffic pattern, the pilot noted that the winds were light and variable. While on final approach, a correction for drift was made. During the landing roll, in gusting conditions, the pilot lost control of the…May 1, 1988 · N5104E · Substantial damageNTSB FTW88DRA10Accident · Minor injuriesFinal reportNew Rutan LONG-EZE · Friendswood, TXThe pilot overrotated the aircraft on takeoff to a nose high attitude, then overcontrolled in the opposite direction to get the nose down. The aircraft touched down nose gear first and all three landing gears collapsed, a wing sheared off, and the aircraft…May 1, 1988 · N331LB · Substantial damageNTSB DEN88LA104Accident · No injuriesLimited investigationFinal reportBeech H35 · Ruidoso, NMMay 1, 1988 · N618T · Substantial damageNTSB DEN88LA103Accident · No injuriesLimited investigationFinal reportCessna 172G · Las Vegas, NMThe private plt and his daughter were on a cross country flight. Landing with a strong headwind and reported gusts to 31 knots, the plt taxied clear of the runway. A 90 degree turn crosswind on the taxiway resulted in wind lifting the left wing and a loss of…May 1, 1988 · N6059R · Substantial damageNTSB CHI88FA102Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Merrimac, WIThe pilot had just taken off from a private strip and immediately entered a high angle of bank turn to the left at low altitude. A witness, who was an experienced aerobatic pilot, estimated the angle of bank to approach 90 degrees. The nose was seen to pitch…May 1, 1988 · N31288 · DestroyedNTSB BFO88LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Winchester, VAThe T-6 struck the C-150 from behind while both were taxiing for takeoff. The C-150 was stopped at the time. There was an annual fly-in being held at the arpt with about 300 acft in attendance. Ground personnel were directing ground traffic. The T-6 plt said…May 1, 1988 · N905PS · 2 aircraft · Substantial damageNTSB BFO88LA043Accident · No injuriesLimited investigationFinal reportBeech C23 · Manassas, VAThe plt said that earlier he attempted to land at carlisle, pa and during the lndg roll he encountered a wind gust and lost directional control of the acft. The r wing raised and the acft went off the side of the rwy. The plt said he heard a loud bump as the…May 1, 1988 · N9358S · Substantial damageNTSB BFO88LA042Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Mechanicsville, MDThe acft was flown with the engine cowling plugs installed. The engine overheated and it lost power. The plt said he forgot to remove the plugs during the preflight. During the forced landing roll the acft collided with a berm and the rt main lndg gear was…May 1, 1988 · N4022V · Substantial damageNTSB BFO88LA041Accident · No injuriesLimited investigationFinal reportCessna 170B · Goldsboro, MDThe plt said he unsuccessfully tried to climb in ground-effect after the acft lifted off before adequate flying speed was obtained. The acft drifted right of the rwy and touched down in a plowed field where it nosed over.May 1, 1988 · N8271A · Substantial damageNTSB ATL88LA160Accident · No injuriesLimited investigationFinal reportCessna 172N · Gilbert, SCThe airplane overran rwy 23 during ldg and nosed over. The plt reported that he attempted to abort the ldg after initially landing long on the rwy. As the airplane began to climb however, he realized that it would not clear obstacles located past the end of…May 1, 1988 · N5085K · Substantial damageNTSB NYC88LA135Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Morristown, NJA loss of control due to improper technique after a bounced landing. Contributing was the second pilot also attempting to correct the situation.Apr 30, 1988 · N4557Q · Substantial damageNTSB NYC88LA132Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Jamestown, NYThe Piper PA-28-181 departed with two pilots onboard. About one hour after takeoff, the PIC got very sick and could not continue flying. She experienced a severe headache and vomitting. The non-instrument rated pilot continued the flight. The aircraft made…Apr 30, 1988 · N5688V · Substantial damageNTSB LAX88LA173Accident · No injuriesLimited investigationFinal reportChampion 7CCM · Cameron Park, CAWhile practicing touch and go landings, the pilot reported that a wind from behind caught the tail of the aircraft. The pilot overcorrected and ground looped the aircraft. The aircraft veered off the runway and nosed over. The pilot reported that there were…Apr 30, 1988 · N6712C · Substantial damageNTSB LAX88LA172Accident · No injuriesLimited investigationFinal reportCessna 150F · Westlake, CADuring a banner towing operation, the plt had just transferred fuel from the aux tank to the mains. Two minutes later the engine quit. A forced landing was made in a field where the acft collided with the terrain. The engine was inspected and ran for several…Apr 30, 1988 · N8008S · Substantial damageNTSB FTW88DRA11Accident · 1 fatalFinal reportCessna L-19E · Conroe, TXThe airplane was observed by witnesses making a chandelle-like maneuver from takeoff. At the top, the nose and right wing dropped for approximately 180 degrees of turn. The wings were almost level when the airplane hit the runway. The airplane burned after…Apr 30, 1988 · N3946L · DestroyedNTSB DEN88LA105Accident · No injuriesLimited investigationFinal reportCessna 185F · Erie, COThe commercial plt was practicing touch and go landings during a local flight. During landing roll on the last landing, the pilot reached down to retract landing flaps and opened the cowl flaps. He then became aware that the aircraft was turning right. Left…Apr 30, 1988 · N8389Q · Substantial damageNTSB CHI88LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-140D · Whittemore, MIWhile landing on a farmer's strip, the pilot failed to maintain directional control of the aircraft. The aircraft swerved off the left side of the strip, into a plowed field where it struck a rock.Apr 30, 1988 · N6433R · Substantial damageNTSB CHI88LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140D · Flushing, MIWhile on final approach for landing on a short, grass strip, the pilot said she encountered sunglare which restricted her visibility such that she was unable to judge the landing. Touchdown occurred with insufficient runway remaining to stop the aircraft. The…Apr 30, 1988 · N5965U · Substantial damageNTSB BFO88LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Wise, VAThe student plt was on his first solo flight and attempting his second solo landing when he was unable to maintain directional control in a left crosswind. The acft drifted right and the plt attempted to do a go-around to avoid going off the side of the rwy.…Apr 30, 1988 · N7947N · Substantial damageNTSB NYC88FA131Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Thomasville, PADue to the pilot's improper preflight planning, he attempted to takeoff with his aircraft weight above the maximum gross weight in a high unfavorable 90 degree crosswind, failed to maintain directional control, and collided with trees.Apr 29, 1988 · N3014Z · DestroyedNTSB MKC88LA093Accident · No injuriesLimited investigationFinal reportBeech 95 · Shell Knob, MOThe pilot of the accident aircraft failed to maintain directional control during the landing roll. The left wing of the aircraft struck trees along the left side of the runway. Aircraft control was lost resulting in the right main landing gear collapsing.Apr 29, 1988 · N635B · Substantial damageNTSB MKC88LA084Accident · Serious injuriesLimited investigationFinal reportRaven S-55 · Burlington, IAWhile attempting to land the balloon during a commercial operation, a dust devil was encountered. The balloon and gondola twisted and pitched violently. During a hard landing, the PIC was thrown from the aircraft, and the aircraft continued to bounce along…Apr 29, 1988 · N6436U · Substantial damageNTSB MKC88LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Dexter, MOShortly after takeoff, during an instructional night cross country training flt, the CFI said he began to lose engine RPM. He made a 180 degree turn to return to the departure apt, when he had a complete power failure. An emergency ldg was made on a freshly…Apr 29, 1988 · N25038 · Substantial damageNTSB MKC88LA080Accident · No injuriesLimited investigationFinal reportBeech F17D · Perryville, MODuring the landing phase of operation, the propeller struck the runway several times prior to the acft making a gear up ldg. After the acft came to a stop, a post flight fire erupted destroying the acft. Evidence of gear up landing was confirmed after post…Apr 29, 1988 · N385 · DestroyedNTSB CHI88LA104Accident · No injuriesLimited investigationFinal reportBeech K35 · Milaca, MNApr 29, 1988 · N6042E · Substantial damageNTSB BFO88LA038Accident · No injuriesLimited investigationFinal reportCessna 172M · Fayetteville, WVThe pilot landed long and with excessive airspeed, which resulted in an overrun of the runway. Inadequate inflight planning is a contributing factor.Apr 29, 1988 · N13261 · Substantial damageNTSB ATL88LA159Accident · No injuriesLimited investigationFinal reportCessna 150J · Sandy Ridge, NCThe aircraft engine began to vibrate excessively and lost power. The pilot landed the aircraft in a field. The aircraft nosed over in the soft ground. Examination of the engine revealed that the number one cylinder valve spring seat lock had failed allowing…Apr 29, 1988 · N60276 · Substantial damageNTSB ATL88FA158Accident · No injuriesField investigationFinal reportBeech E18S · Cynthiana, KYThe plt was repositioning the airplane from an on-demand air taxi freight flight. He was en route from rochester, NY to huntsville, al with a planned refuel stop at louisville, KY. Near falmouth, KY he changed his destination to lexington 'due to a developing…Apr 29, 1988 · N300W · DestroyedNTSB SEA88LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Elko, NVDuring landing roll the pilot lost directional control of the aircraft with a groundloop resulting. The pilot had a total time of 17 hours in this type of aircraft and 152 hours total flight time.Apr 28, 1988 · N2952C · Substantial damageNTSB SEA88LA085Accident · No injuriesLimited investigationFinal reportBeech 35 · Pasco, WADuring lndg roll, NLG and rmlg collapsed. During tow in from rwy, lndg gear cb was noted to be tripped. Cause of cb activation unk.Apr 28, 1988 · N2839V · Substantial damageNTSB MIA88RA162Accident · Serious injuriesForeign investigationCessna 207A · St Eustatius, NTApr 28, 1988 · N7303UNTSB LAX88LA170Accident · No injuriesLimited investigationFinal reportCessna 150F · Hayfork, CAAfter landing and taxiing to parking, the pilot heard a noise, the pilot exited the airplane and noticed a fire in the engine compartment area. The airplane was consumed by fire shortly thereafter.Apr 28, 1988 · N6742F · Substantial damageNTSB FTW88LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Lamont, OKThe pilot lost directional control while landing on an asphalt roadway near his residence. The nose wheel dug into adjacent soft terrain and the aircraft tipped over. The road was not in use by auto traffic because a bridge was out of service. It was…Apr 28, 1988 · N2645F · Substantial damageNTSB FTW88DQG04Accident · No injuriesFinal reportPiper PA-28-201T · Shallowater, TXThe pilot lost directional control during the landing roll with a strong left crosswind on a narrow runway. A go-around was attempted but the aircraft drifted right and received substantial damage when it touched down in soft terrain.Apr 28, 1988 · N30273 · Substantial damageNTSB DEN88LA101Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COApr 28, 1988 · N96299 · Substantial damageNTSB DCA88MA054Accident · 1 fatalMajor investigationFinal reportBoeing 737-297 · Maui, HIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-89/03. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Flt…Apr 28, 1988 · N73711 · Substantial damageNTSB CHI88FA101Accident · 1 fatalField investigationFinal reportCessna 152 · Lonsdale, MNThe student pilot was on his first solo flight outside the airport traffic area and was practicing maneuvers prescribed by his flight instructor including slow flight and stall type maneuvers. The aircraft experienced a loss of control, followed by an…Apr 28, 1988 · N67338 · DestroyedNTSB BFO88LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Elkton, MDDuring cruise flt at an alt of 1500 ft, the engine suddenly stopped producing power. The acft was landed on railroad tracks in order to avoid trees. The acft nosed over during the landing. Plt stated that the right fuel tank gauge indicated 1/4 tank and the…Apr 28, 1988 · N4255F · Substantial damageNTSB NYC88LA134Accident · No injuriesLimited investigationFinal reportBeech C17B · Butler, PAAfter landing the airplane was taxiing on runway 08 when it went off the side of the runway and struck a runway light and taxi sign. While attempting to get back on the runway, the left gear collapsed.Apr 27, 1988 · N47024 · Substantial damageNTSB NYC88LA129Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Dracut, MAThe pilot said that while making a normal approach for a 'glassy water' landing on a lake, he flared high and stalled the airplane. The right wing dropped off and the airplane crashed into the water.Apr 27, 1988 · N9712N · Substantial damageNTSB LAX88LA174Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Chico, CAApr 27, 1988 · N6601P · Substantial damageNTSB LAX88FA169Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Hayward, CAPilot's failure to detect an uncommanded propeller feathering procedures established in the pilot's operating handbook.Apr 27, 1988 · N3588Y · Destroyed