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 CHI88LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Flint, MIWhile on a solo instructional flight for the purpose of practicing takeoffs and landings, the student pilot executed a hard landing. The aircraft bounced; when it touched down again, the nose gear collapsed and the aircraft skidded to a stop on the runway.Jul 31, 1988 · N2539G · Substantial damageNTSB CHI88LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Belleville, MIDuring a solo instructional flight for the purpose of practicing touch and gos, the student pilot experienced a loss of control when the aircraft bounced after a hard landing. The pilot failed to perform remedial action as the aircraft continued to porpoise…Jul 31, 1988 · N69120 · Substantial damageNTSB CHI88LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · St. Jacob, ILDuring the initial climbout the student pilot failed to attain sufficient altitude to clear the power lines located off of the departure end of the runway. When the pilot realized that he would not be able to clear the power lines, he elected to attempt to…Jul 31, 1988 · N9291T · Substantial damageNTSB CHI88FA183Accident · No injuriesField investigationFinal reportBoeing B75N1 · Wonder Lake, ILJul 31, 1988 · N4408N · Substantial damageNTSB CHI88DEE08Accident · No injuriesFinal reportTownson Starduster SA100 · Monee, ILPilot failing to maintain control of the airplane during landing touchdown and roll out.Jul 31, 1988 · N9119R · Substantial damageNTSB SEA88FA140Accident · 3 fatalField investigationFinal reportCessna 185 · Liscome Bay, AKWhile in a narrow, tree-lined area just above a small cove, the pilot lost control of the aircraft while maneuvering, in preparation for a landing on a lake. The aircraft struck trees in-flight while in an unusual attitude and then struck the water. Poor…Jul 30, 1988 · N70168 · DestroyedNTSB NYC88LA199Accident · Minor injuriesLimited investigationFinal reportCessna 172L · No. Kingstown, RIThe failure of the boston center controller to adequately understand the pilot-in-command's request and to assess the gravity of the situation.Jul 30, 1988 · N19699 · Substantial damageNTSB NYC88LA198Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Montpelier, VTEngine power loss due to fuel contamination of water and rust particles in fuel system.Jul 30, 1988 · N2883P · Substantial damageNTSB MKC88LA145Accident · No injuriesLimited investigationFinal reportGrumman G-164B · West Helena, ARThe plt said, while enroute to an aerial application operation, the engine lost power and an emergency ldg was made into the trees. Post accident investigation revealed that an intake valve on number 9 cylinder had failed.Jul 30, 1988 · N8257K · Substantial damageNTSB MKC88LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Cherry Valley, ARThe plt said that shortly after takeoff, he had a partial power loss. He dumped his chemical load and attempted to return for landing. While turning the engine suffered a complete loss of power. He attempted to land, but on the roll out, acft nosed over in…Jul 30, 1988 · N6823K · Substantial damageNTSB MKC88DPG02Accident · 2 fatalFinal reportSnow 600-S2C · Almyra, ARTwo ag aircraft were spraying the same field. According to several witnesses, 1671S was heading south and 3660X was heading east. Both aircraft were actively engaged in the spraying operation but did not seem to the witnesses to be coordinating with each…Jul 30, 1988 · N1671S · 2 aircraft · DestroyedNTSB MIA88WA241Accident · No injuriesForeign investigationPiper PA-23-250 · Nassau, BahamasJul 30, 1988 · N6283Y · DestroyedNTSB MIA88FA239Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Avon Park, FLThe CFI radioed that he would be conducting a simulated engine-out aprch. 2 plt witnesses, 1 of whom was a CFI, stated that acft was seen on final aprch at about 200 ft with the left prop feathered & the gear & flaps down. They stated that although the acft…Jul 30, 1988 · N3464P · DestroyedNTSB LAX88LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Placerville, CAThe plt initiated a touch & go landing in an acft that was loaded near its max certificated gross weight. He landed slightly long & applied power for takeoff. However, he stated that the eng sputtered & the acft contd to decelerate, so he rejected the…Jul 30, 1988 · N8414A · Substantial damageNTSB LAX88FA274Accident · 2 fatalField investigationFinal reportLearjet 23 · Perris, CAThe pilot decided to conduct his flight with known aircraft deficiencies. Induced company pressure to deliver the aircraft to its destination is considered to have been a factor in the accident.Jul 30, 1988 · N745F · DestroyedNTSB LAX88FA272Accident · 3 fatalField investigationFinal reportCessna 177RG · Cedar Grove, CAPilots decision to attempt a flight through a mountainous area at an altitude insufficient to ensure terrain clearance.Jul 30, 1988 · N52504 · DestroyedNTSB LAX88DVG09Accident · No injuriesFinal reportSchweizer G-164B · Robbins, CADuring landing roll, after an aerial application flight, the sprayboom became entangled in weeds. The airplane ground looped and nosed over. There were no reported mechanical failures or malfunctions of the airplane at the time of the accident.Jul 30, 1988 · N3633C · Substantial damageNTSB CHI88DER06Accident · No injuriesFinal reportHiller UH-12E · Buffalo Lake, MNWhen the helicopter lifted off, the left tail rotor cable separated. Directional control was lost and the aircraft collided with the terrain. The pilot reported no injuries, however the helicopter sustained substantial damage. An inspection of the left tail…Jul 30, 1988 · N173HA · DestroyedNTSB ATL88LA222Accident · No injuriesLimited investigationFinal reportBeech V35B · Parson, TNThe pilot reported that shortly after a heavy weather system passed over, he attempted a takeoff from a wet runway. During the takeoff roll he did not allow the airspeed to accelerate to the lift off speed. As he prematurely lifted off he lost directional…Jul 30, 1988 · N38573 · Substantial damageNTSB ATL88DKG11Accident · Minor injuriesFinal reportPiper PA-25-235 · Climax, GAJul 30, 1988 · N4880Y · Substantial damageNTSB ANC88LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pilot Point, AKThe non-certificated Pilot reported that he had just purchased the accident airplane the preceding day, and had only flown it for a period of two hours or so. On the accident flight, he had been airborne less than 10 minutes when the engine reportedly began…Jul 30, 1988 · N2212F · Substantial damageNTSB SEA88LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Lewis, WAThe pilot had just received his fixed wing rating. The pilot stated that he made a hard landing. The aircraft then began to porpoise. On the third bounce the nosegear failed and the aircraft departed the runway. As the aircraft came to rest a small fire…Jul 29, 1988 · N24995 · Substantial damageNTSB NYC88LA197Accident · Serious injuriesLimited investigationFinal reportErco 415C · W. Bloomfield, NYShorlty after takeoff at about 150 feet a.g.l., the pilot lost control of the airplane and crashed in a corn field about 0.5 mile from airport. A passenger reported that they encountered a wind gust and the pilot was unable to control the airplane.Jul 29, 1988 · N94011 · DestroyedNTSB MKC88LA142Accident · No injuriesLimited investigationFinal reportShirlan Dickey E-RACER · Dubuque, IAAt a fuel stop in Dubuque, IA the PIC purchased fuel for the final leg of his flt to oshkosh. After a pre-flt chk and subsequent eng runup, the PIC took the active rwy and commenced a takeoff roll. The lift off and initial climb went without difficulty until…Jul 29, 1988 · N131RD · Substantial damageNTSB LAX88LA271Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Healdsburg, CASolo student pilot failed to maintain airspeed above the stall speed during the go around attempt, thereby losing control of the airplane and stalling and mushing until colliding with a tree.Jul 29, 1988 · N91352 · Substantial damageNTSB LAX88FA273Accident · Minor injuriesField investigationFinal reportRearwin 8500 · Glendale, CASeperation of an engine cylinder that moved into the plane of the wooden propeller blades. The propeller blades were sheared by the dislodged cylinder. The rough landing surface contributed to the accident.Jul 29, 1988 · N15855 · Substantial damageNTSB DEN88LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Forsyth, MTJul 29, 1988 · N3290B · Substantial damageNTSB CHI88LA184Accident · No injuriesLimited investigationFinal reportPiper J-3 · Waynesville, OHDuring a dual instructional flight for the purpose of practicing takeoffs and landings with a pre-solo student, the instructor pilot failed to maintain adequate aircraft control and visual lookout, and the aircraft departed the right side of the runway,…Jul 29, 1988 · N92483 · Substantial damageNTSB CHI88FA179Accident · 1 fatalField investigationFinal reportPiper PA-30 · Oshkosh, WIJul 29, 1988 · N43GS · No damageNTSB MKC88LA141Accident · No injuriesLimited investigationFinal reportRockwell S2R · O'Kean, ARWhile performing an aerial application operation, the plt said he experienced a total powerplant failure. He attempted an emergency ldg in a cultivated rice field. During the ldg attempt, the aircraft sustained substantial damage to the propeller, landing…Jul 28, 1988 · N3665X · Substantial damageNTSB MKC88LA140Accident · No injuriesLimited investigationFinal reportMooney M20C · Olathe, KSShortly after takeoff, the pilot said the engine failed. He said he pumped the throttle and the engine restarted about the same time the acft returned to the runway. The engine restart propelled the aft back into the air. The plt felt he had sufficient power…Jul 28, 1988 · N6722U · Substantial damageNTSB CHI88FA178Accident · No injuriesField investigationFinal reportSonerai IIL · Oshkosh, WIJul 28, 1988 · N398 · Substantial damageNTSB CHI88FA177Accident · No injuriesField investigationFinal reportQuickie Q-2 · Oshkosh, WIThe plt was on a flt to Oshkosh to an eaa convention. When he arrived, traffic was hvy & special traffic procedures were in effect. Info to attendees (before the convention) advertised that the north/south rwys would be used primarily for display acft & the…Jul 28, 1988 · N48BH · Substantial damageNTSB CHI88DEV03Accident · No injuriesFinal reportHughes 369HS · Ashland, ILAs the helicopter was taking off, there was a loss of rotor RPM which was accompanied by a loss of fuel flow to the eng. The plt aborted the takeoff, but during touchdown, the main rotor blades flexed downward & severed the . Tail boom. An inspn of the eng…Jul 28, 1988 · N9033F · Substantial damageNTSB ATL88LA221Accident · No injuriesLimited investigationFinal reportCessna 182A · Elberta, ALThe plt was on a x-country flt from Elberta, AL, to destin, FL & return. The flt included 4 en route stops to pick up & drop off pax. During an en route stop, the plt checked the fuel by using a home made dip stick & he thought there was sufficient fuel to…Jul 28, 1988 · N4090D · Substantial damageNTSB ANC88LA099Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Kustatan River, AKThe private pilot was attempting to land his Piper PA-14 airplane at a remote beach fishing site in gusty crosswind conditions. He reportedly encountered a wind gust upon touch down, lost directional control and struck an abandoned hunting shack and an…Jul 28, 1988 · N5135H · Substantial damageNTSB ANC88FA100Accident · No injuriesField investigationFinal reportFairchild SA227-AT · Anchorage, AKDuring the taxi to the runway, the flight crew noted a vibration in the airplane and stopped to check the tires, thinking that they were underinflated. No obvious problem was seen, and they elected to takeoff. Shortly after takeoff, a fire erupted in the left…Jul 28, 1988 · N482SA · Substantial damageNTSB NYC88LA195Accident · No injuriesLimited investigationFinal reportCessna 177RG · Canton, MADuring initial climb from takeoff, the engine lost total power and an emergency landing was made on a highway. The left wing and horizontal stabilizer struck a guardrail when the pilot was maneuvering to avoid a truck. A post-crash inspection of the engine…Jul 27, 1988 · N52865 · Substantial damageNTSB NYC88FA196Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pocantico Hills, NYThe non-instrument rated private pilot departed in instrument flight conditions against the advice of several people he talked to. Approximately 1 hour and 30 minutes after departure the first of four or five mayday calls were heard by bridgeport radio and an…Jul 27, 1988 · N9715W · DestroyedNTSB MKC88LA139Accident · No injuriesLimited investigationFinal reportGrumman G164-B · Gould, ARThe pilot said that while returning from an aerial application operation, he lost directional control during the ldg. He veered off the concrete runway, into the soft, tall grass border, and nosed over.Jul 27, 1988 · N54JS · Substantial damageNTSB MKC88LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Lamar, MOThe plt of the aerial applicator acft said he was pulling out for an intersection departure on rwy 21, when the Cessna on a landing roll, struck him from the rear. The pilot said that possibly the background, haze, and airframe components made the incoming…Jul 27, 1988 · N29168 · 2 aircraft · Substantial damageNTSB CHI88LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbon, INJul 27, 1988 · N6818A · Substantial damageNTSB CHI88LA174Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Neillsville, WIJul 27, 1988 · N5700A · DestroyedNTSB CHI88DER05Accident · Minor injuriesFinal reportVans RV-3A · Walker, MNThe pilot reported that after making a low level pass over a lake, he attempted to climb to pattern altitude in preparation for landing at a nearby airport. When the climb was initiated, the aircraft did a loop and the plt lost control. The acft subsequently…Jul 27, 1988 · N9WL · Substantial damageNTSB ANC88LA098Accident · No injuriesLimited investigationFinal reportCessna 180A · Northway, AKThe commercially certificated pilot was landing at Northway, AK., when the airplane ground-looped to the left. He reportedly had also ground-looped the same airplane when he landed at whitehorse, Canada, just prior to the landing at Northway. A post-accident…Jul 27, 1988 · N5327D · Substantial damageNTSB ANC88LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe private pilot and his passenger were uninjured when their Piper PA-18 (super cub) ground-looped while landing at Anchorage international airport, Anchorage, AK. The pilot stated that the right main landing gear tire 'grabbed' when it touched the paved…Jul 27, 1988 · N8653Y · Substantial damageNTSB ANC88LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Sand Point, AKThe pilot reported that the aircraft had high oil temp and moderate vibrations. The aircraft was landed at Sand Point and a company mechanic arrived to inspect the aircraft. The oil quantity was checked and a run-up performed. The mechanic reported that no…Jul 27, 1988 · N493CA · Substantial damageNTSB SEA88LA139Accident · No injuriesLimited investigationFinal reportCessna 172 · Monroe, WAThe pilot reported that he encountered a downdraft on final. He added power for a go-around; however, a wingtip struck the ground. The aircraft cartwheeled and came to rest to the left of the runway.Jul 26, 1988 · N46692 · Substantial damageNTSB MKC88MA134Accident · 1 fatalMajor investigationFinal reportLearjet 35A · Morristown, NJThe crew was positioning the aircraft in preparation for a revenue flight and executing a non-directional beacon (NDB) apch to rwy 05. The captain reported that the copilot was flying the acft. However, the capt stated that he took controlof the acft during…Jul 26, 1988 · N442NE · DestroyedNTSB MKC88LA137Accident · No injuriesLimited investigationFinal reportGrumman G164B · Knobel, ARThe plt said he had just completed an aerial application operation and was returning to his base airfield to re-load. While in a low level cruise, the engine quit abruptly, and an emergency ldg was attempted in a soft, muddy soy bean field. During the ldg…Jul 26, 1988 · N2500W · Substantial damage