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 CHI88LA047Accident · No injuriesLimited investigationFinal reportCessna 172P · Jenison, MIThe low total time pilot took off in crosswind conditions for a proficiency flight and during a go around lost directional control and struck a snow bank along the downwind side of the runay.Jan 16, 1988 · N62877 · Substantial damageNTSB ATL88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Florence, SCThe left main ldg gear collapsed during takeoff roll, following a touch & go ldg. The airplane subsequently veered into a snowbank. Post-crash examination of the airplane revealed that the left MLG truss bracket assy had pulled loose from the acft structure…Jan 16, 1988 · N268NA · Substantial damageNTSB ANC88LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKThe pilot had selected the left auxiliary fuel tank for takeoff. During the climbout the engine quit; the aircraft crashed short of a private airstrip. The pilot stated that he ran the left auxiliary fuel tank dry and did not select another fuel tank with the…Jan 16, 1988 · N9103W · Substantial damageNTSB MKC88FA039Accident · Serious injuriesField investigationFinal reportCessna 177RG · Camden, ARThe pilot reported that he lost all engine power during cruise. He attempted to make the Camden, Arkansas airport. The aircraft did not make the intended landing area and struck a tree and subsequently, a swamp area. The accident investigation revealed no…Jan 15, 1988 · N8052G · DestroyedNTSB CHI88LA050Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Red Lake Falls, MNJan 15, 1988 · N8122U · DestroyedNTSB ATL88LA079Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Fayetteville, NCThe student plt rptdly became lost on a solo x-c flight, and was unable to locate her destination arpt. She subsequently obtained radar vectors to another arpt. The airplane subsequntly lost power while on final appch to the arpt, and the airplane crashed…Jan 15, 1988 · N60362 · DestroyedNTSB NYC88LA065Accident · Serious injuriesLimited investigationFinal reportBell 206 · Holmdel, NJThe pilot had just landed the helicopter from a speed survey of garden state parkway and was in idle. The passenger/police officer deplaned and walked to the rear of the aircraft and was struck by the tail rotor blade receiving serious injuries.Jan 14, 1988 · N3NJ · Minor damageNTSB MIA88WA085Accident · No injuriesForeign investigationBoeing 707-330C · Bogota, ColombiaJan 14, 1988 · N707HE · Substantial damageNTSB LAX88LA086Accident · No injuriesLimited investigationFinal reportCessna 195 · Sonoma, CADuring a local pilot check flight, upon touchdown, a loud bang was heard. The acft gradually veered to the right then ground looped. A local mechanic was unable to identify a failure. The plt reported that the brakes were operating normally prior to and…Jan 14, 1988 · CGADA · Substantial damageNTSB FTW88FA051Accident · 1 fatalField investigationFinal reportCessna 310 · Conroe, TXThe newly certificated private pilot, who had 55.2 hours total flight experience, was on his initial solo flight in the Cessna 310 model. His flight logbook had been endorsed for solo flight in the aircraft on November 20, 1987. Witnesses observed a rather…Jan 14, 1988 · N3022D · DestroyedNTSB DEN88LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe commercial plt was taxiing after landing during a fuel stop while on a long cross country flight. The plt landed on runway 21, a hard surface runway, 10,600 feet long by 150 feet wide. The winds were reported from 230 degrees at 22 knots, with gusts to 31…Jan 14, 1988 · N1879P · Substantial damageNTSB CHI88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mankato, MNJan 14, 1988 · N713LS · Substantial damageNTSB ATL88FA078Accident · 1 fatalField investigationFinal reportCessna 150H · Cedartown, GAJan 14, 1988 · N12NF · Substantial damageNTSB LAX88LA084Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Blythe, CAA Cessna T210L was found abandoned with the landing gear collapsed. Skid marks were noted on the ground where the aircraft had touched down on the rough terrain. The pilot was never identified and traces of illegal contraband were found in the aircraft.Jan 13, 1988 · N2516S · Substantial damageNTSB LAX88FA085Accident · 1 fatalField investigationFinal reportBell 47G-2A1 · San Diego, CAPilots complacency in performing the preflight inspection. His failure to disconnect the two tie downs straps attached to the right side of the helicopter resulted the roll.Jan 13, 1988 · XBDGH · DestroyedNTSB ANC88LA024Accident · No injuriesLimited investigationFinal reportCessna 150D · Chugiak, AKThe flight instructor stated the student landed back on the runway after a practice engine failure; at that point the flight instructor realized how slick the runway was and the aircraft exited the departure end of the runway into a snow bank.Jan 13, 1988 · N4379U · Substantial damageNTSB SEA88LA080Accident · 2 fatalLimited investigationFinal reportCessna 180 · Hailey, IDThis Cessna 180 was on a VFR flight from gooding, Idaho to Hailey, Idaho when it disappeared. The wreckage was later found in a steep canyon about 15 miles from the destination. No mechanical failures were found. Good VFR weather conditions existed at the…Jan 12, 1988 · N180W · DestroyedNTSB DEN88LA049Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Clovis, NMJan 12, 1988 · N5063J · Substantial damageNTSB DEN88FA050Accident · 2 fatalField investigationFinal reportCessna T303 · Kiowa, COThe plt obtained two wx briefings and filed an IFR flt plan to el paso, TX. He was not instrument rated. The acft departed apa at 1959 and disappeared from radar at 2010. The crash site was 11- 1/2 mi se of the Kiowa VORTAC and 36 mi se of apa. Radar showed a…Jan 12, 1988 · N9565T · DestroyedNTSB ATL88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student plt rptd that he attempted to land long to avoid snow and ice on the rwy. The airplane touched down earlier than he intended however, and contacted the snow and ice. The airplane subsequently veered off of the runway, impacted a snowbank, and…Jan 12, 1988 · N757AS · Substantial damageNTSB ATL88LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Carolina Beach, NCThe aircraft sustained substantial airframe damage when the acft collided with the ground following an aborted t/o. the instructor reported that the student pulled the throttle back after the aircraft broke ground. The instructor attempted to recover, but the…Jan 12, 1988 · N50738 · Substantial damageNTSB FTW88DRA02Accident · No injuriesFinal reportCessna 180 · Beaumont, TXAcft experienced a power loss while in cruise flt at 500' AGL on an aerial pipeline patrol flt. An off-arpt emergency lndg was made in rough terrain and the acft was substantially damaged. Investigation revealed that the carb heat gate valve would only close…Jan 11, 1988 · N2517K · Substantial damageNTSB SEA88LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Juneau, AKThe aircraft was ballooning during the approach to the ice-covered lake. The pilot momentarily added power to go-around, but elected to reduce the power in order to land. During the landing roll directional control was lost with the aircraft sliding into an…Jan 10, 1988 · N7221F · Substantial damageNTSB NYC88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Old Bridge, NJThe flight made a normal approach and touched down on runway 24. As the pilot applied pwr for takeoff due to the hazardous runway conditions, the pilot lost directional control and the left main landing gear impacted plowed snow at the edge of the runway.Jan 10, 1988 · N9317N · Substantial damageNTSB NYC88LA054Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Honesdale, PAShortly after takeoff from runway 35 at cherry ridge airport, Honesdale, Pennsylvania, the aircraft experienced an engine power loss and crashed about 200 feet off the end of the runway. Examination of the aircraft after the accident revealed no fuel in the…Jan 10, 1988 · N26869 · Substantial damageNTSB MKC88LA038Accident · No injuriesLimited investigationFinal reportCessna 177 · St. Charles, MOWhile practicing touch and go ldgs, PIC noted a significant increase in sink rate. Additional power failed to arrest the descent, and the acft struck the terrain short of the rwy causing substantial damage to the acft, and no injuries to plt and pax.Jan 10, 1988 · N35284 · Substantial damageNTSB FTW88LA050Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10 · Dfw Airport, TXUnexpected opening of the IL door, which caught the passenger between it and the bulkhead as the door moved inward and upward. A secondary cause was the failure of the flight attendants to follow company procedures requiring them to guard all entry doors…Jan 10, 1988 · N142AA · No damageNTSB DEN88LA052Accident · No injuriesLimited investigationFinal reportCessna 305A · Littleton, COJan 10, 1988 · N5245G · Substantial damageNTSB DEN88LA047Accident · No injuriesLimited investigationFinal reportCessna 182G · Aurora, CON3406S was landing on rwy 32, an asphalt rwy 5,000 ft long and 40 ft wide. The rwy was clear and dry, but the terrain surrounding the rwy was covered by 12 to 15 inches of snow. The wind at an arpt 5 mi sw was from 160 deg at 5 KTS. In his rpt of the acdt the…Jan 10, 1988 · N3406S · Substantial damageNTSB CHI88LA042Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Converse, INThe plt had flown one closed circuit pattern of the local arpt and landed to pick up two additional passengers. Purpose of the local flight was for sightseeing. The acft was parked with engine at idle. One boarding passenger approached the acft from the left…Jan 10, 1988 · N46701 · No damageNTSB CHI88FA041Accident · 3 fatalField investigationFinal reportFairchild SA226T · Pontiac, MIAcft was scheduled for an instructional flt. During the wx briefing, the CFI told the fss specialist that the flt would include eng-out practice. Witness statements indicate that the acft rolled sharply to the rt and nosed down after attaining about 100 ft of…Jan 10, 1988 · N800AW · DestroyedNTSB ATL88LA076Accident · No injuriesLimited investigationFinal reportCessna 182G · Lancaster, OHThe plt rptd that the airplane began to veer left almost immediately after touchdown. The airplane subsequently swerved off of the rwy. Traveled across a snow-covered grassy area, and impacted a taxiway embankment. The nose gear was found to be collapsed…Jan 10, 1988 · N2006R · Substantial damageNTSB MKC88FA037Accident · No injuriesField investigationFinal reportBeech 58 · Dewitt, ARThe pilot of N4613S was making a VFR approach into the de witt, Arkansas municipal airport. Snow had been removed from the runway and piled up on the approach end of runway 35. The nose gear of the aircraft contacted the piled up snow/ice at touchdown,…Jan 9, 1988 · N4613S · Substantial damageNTSB LAX88LA083Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G109B · Tehachapi, CAThe pilot and his passenger used the motorglider's powerplant to takeoff and climb to a mountain ridge to soar. Upon reaching the ridge top the pilot shut off the powerplant and entered soaring flight. The passenger stated that the motorglider descended into…Jan 9, 1988 · N109MD · Substantial damageNTSB DEN88LA051Accident · No injuriesLimited investigationFinal reportRaven RX-7 · Rio Rancho, NMDuring the landing the plt reported a wind shift which drifted the balloon into pwr lines before the landing could be accomplished. The plt reported she could not see the pwr lines due to the balloon restricting visibility and the pax pointed the lines out to…Jan 9, 1988 · N2797L · Substantial damageNTSB DEN88LA048Accident · No injuriesLimited investigationFinal reportRotorway Executive · Colorado Spring, COThe plt contacted ground control & was cleared to taxi from a hangar on the south end of the arpt to a hangar on the north end via twy-a. twy-a was located 400' west & parallel to rwy 17/35. The plt said he was air taxiing the helicopter just above the…Jan 9, 1988 · N7007B · DestroyedNTSB DCA88RA022Accident · 1 fatalForeign investigationPiper PA-28-180 · Snaefellsnes, IcelandJan 9, 1988 · N9120BNTSB CHI88IA040Incident · No injuriesIncident investigationFinal reportBoeing 747-251F · Minneapolis, MNAircraft experienced a loss of aileron ctl when ice formed around aileron control cables and restricted their movement. Water draining through open plenum drains in the main landing gear wheel well froze when exposed to below freezing temperatures at 35,000…Jan 9, 1988 · N618US · No damageNTSB ANC88DAG02Accident · No injuriesFinal reportCessna 172 · Willow, AKThe pilot stated that immediately upon touchdown, the airplane started sinking in (two feet) deep snow, and came to a stop in about 50 feet. The left wing and propeller struck the ground. The plt had overflown the arpt and saw the snow removal equipment about…Jan 9, 1988 · N8439X · Substantial damageNTSB NYC88LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Atlantic City, NJThe Piper PA-23-250 made an instrument approach to the airport. The pilot said he lowered the landing gear prior to touchdown, however, both propellers struck the runway. The pilot tried to make a go-around and the aircraft started to veer to the left. The…Jan 8, 1988 · N62554 · Substantial damageNTSB LAX88FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Napa, CAPilot's inflight loss of control of the aircraft while maneuvering in IFR conditions after becoming disoriented while executing an instrument approach procedure. Factors in the accident were the pilots lack of recent instrument flight experience and the…Jan 8, 1988 · N2938X · DestroyedNTSB FTW88MA047Accident · 2 fatalMajor investigationFinal reportGates Learjet 36A · Monroe, LAThe crew was executing the ILS approach and had turned back inbound on the procedure turn to the outer marker when the co-pilot stated they were 5.9 DME in a calm voice with no indication of a problem. Impact with the ground occurred at about 5.9 DME,…Jan 8, 1988 · N79SF · DestroyedNTSB DEN88LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe plt reported that he was making touch and go landings on rwy 09, an asphalt rwy 6200 x 75 ft. the wind was light and variable. The plt said that during the 4th t&g, he landed a little fast and not perfectly aligned with the rwy. When he applied pwr to…Jan 8, 1988 · N280SV · Substantial damageNTSB CHI88FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Warsaw, INAircraft departed during the hours of darkness and was declared missing after failing to arrive at its stated destination. The proposed route of flight crossed a large body water and a local lakeshore resident reported hearing an airplane strike the water. No…Jan 8, 1988 · N4878G · DestroyedNTSB LAX88DUG01Accident · Minor injuriesFinal reportSmith DSA-1 · Upland, CAThe pilot reported that he had performed a moderate to severe 'noseover' at 4000 ft AGL. The engine started to run rough and then quit. The pilot stated that he had performed maintenance on the carburetor just prior to this flight. An emergency landing was…Jan 7, 1988 · N2Q · Substantial damageNTSB BFO88LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Rock Camp, WVDuring cruise flight in IMC the engine stopped when the plt turned the carb heat to check for carb ice. He was unable to restart the engine. He descended into VMC and tried a forced landing in an open field. The acft struck a tree short of the field. The plt…Jan 7, 1988 · N14BK · Substantial damageNTSB MIA88LA084Accident · No injuriesLimited investigationFinal reportDouglas C-118A · Miami, FLThe plt stated that while taxiing in the ramp area he turned the aircraft to park it & inadvertantly struck the horizontal stabilizer of a parked aircraft.Jan 6, 1988 · HRAKZ · Substantial damageNTSB MIA88FA083Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Pembroke Park, FLThe non-instrument rated private pilot obtained a weather briefing that indicated the weather would be deteriorating to IMC, but he attempted a flight anyway. During the flight, he became disoriented and penetrated 2 control zones and then struck an antenna…Jan 5, 1988 · N5327F · DestroyedNTSB FTW88FA046Accident · Serious injuriesField investigationFinal reportBeech B36TC · Woodward, OKBefore tkof, the plt was briefed on flt precautions for IFR & snow; however, he was not adzd of icing conds in clouds & precip above the freezing lvl to 18,000' as cautioned in the current area forecast. While climbing after tkof, he enctrd clouds & 'some…Jan 5, 1988 · N6624N · Substantial damageNTSB CHI88FA039Accident · 1 fatalField investigationFinal reportCessna T210N · Bedford Park, ILDrg an arrival to chicago midway arpt on a cold night, the plt rprtd he was having trouble with a sticky throttle. Subsequently, he made an emergency transmission & said he was 'going in.' Witnesses saw the acft in a descent before it crashed. One witness…Jan 5, 1988 · N4746C · Destroyed