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 DEN88FA119Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Maljamar, NMWhile in slow flt at low level on a oil pipeline patrol demonstration flt, the acft entered a left turn and, according to witnesses, the nose suddenly dropped and the acft crashed in a vertical attitude. The acft was destroyed in the accident and both…Jun 2, 1988 · N1393R · DestroyedNTSB CHI88LA133Accident · No injuriesLimited investigationFinal reportAlon A2 · Flushing, MIDuring initial takeoff climb the acft experienced a loss of engine power at approximately 30' to 40' above the ground. The pilot elected to execute a forced landing on the grassy infield of the airport because insufficient runway remained. The acft struck the…Jun 2, 1988 · N6589Q · Substantial damageNTSB ANC88LA091Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Nikolai Creek, AKA pilot reported that he was attempting to taxi off the dirt road that he had just used as a landing site in a rural area of Alaska, when the airplane's left main landing gear wheel became mired in a soft spot. The aircraft veered off the road into a ditch.Jun 2, 1988 · N9895L · Substantial damageNTSB ANC88LA066Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Eagle, AKThe pilot was attempting to land a heavily loaded De Havilland otter (DHC-3) on a gravel strip in rural Alaska. Upon touchdown, the pilot reported that the airplane veered slightly to the right. He unlocked the tail wheel centering device and attempted to…Jun 2, 1988 · N3125N · Substantial damageNTSB ANC88LA064Accident · No injuriesLimited investigationFinal reportCessna 206 · Chugiak, AKThe pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to exit the left side of the runway into an open ditch. The aircraft traveled approximately 1000 feet of the runway.Jun 2, 1988 · N4571K · Substantial damageNTSB ANC88FA065Accident · 3 fatalField investigationFinal reportCessna 172N · Hatcher Pass, AKThe aircraft crashed at the 3100 foot level of a mountain Pass. The aircraft was destroyed by ground impact and fire, and the pilot and the two passengers were fatally injured. Witnesses near the crash site stated the aircraft was maneuvering very low above…Jun 2, 1988 · N3327E · DestroyedNTSB NYC88LA152Accident · No injuriesLimited investigationFinal reportBeech H18 · Utica, NYThe flight had departed syracuse airport enroute to plattsburg, new york transporting ups packages. At about 0810 hours, a loss of power on the left engine was experienced and altitude could not be maintained. The pilot informed griffiss control that he could…Jun 1, 1988 · N20PA · Substantial damageNTSB MIA88LA186Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Callahan, FLWhile maneuvering the helicopter during an aerial application flt the eng quit. During the autorotative landing the helicopter landed hard. Examination of the eng revealed the accessory drive gear, which is attached to the crankshaft by 6 AN-4A bolts with the…Jun 1, 1988 · N9080T · Substantial damageNTSB MIA88LA185Accident · No injuriesLimited investigationFinal reportBost Pitts S-1C · Miami, FLThe plt stated that he was performing a tail-slide maneuver when the eng suddenly quit. He attempted to restart eng. When eng would not restart, he elected to lnd a/c in a fld. During landing roll, the a/c nosed over. FAA stated that the carb was damaged…Jun 1, 1988 · N36GB · Substantial damageNTSB MIA88LA183Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Gretna, FLWhile on an aerial application flt, the plt stated he maneuvered the helicopter to release the remaining chemical. He then heard a loud 'screeching' noise followed by silence as the eng quit. The helicopter landed hard breaking the skids. It came to rest on…Jun 1, 1988 · N4029R · Substantial damageNTSB MIA88FA184Accident · 2 fatalField investigationFinal reportPiper J3C · N Fort Myers, FLThe plt tkof on rwy 27 with the wind fm 060 deg at 12 gusting 23 KTS. Density alt was 2100'. Witnesses said the acft was in a slow speed, nose hi climb, when eng pwr was interrupted momentarily. Pwr was restored, but soon thereafter, the acft rolled rgt,…Jun 1, 1988 · N98178 · DestroyedNTSB LAX88LA207Accident · No injuriesLimited investigationFinal reportBeech M35 · Scottsdale, AZDuring the climb out the engine experienced a loss of power. A forced landing was made where during the landing roll the airplane collided with the terrain. Inspection of the engine revealed that the number two connecting rod broke.Jun 1, 1988 · N9896R · Substantial damageNTSB FTW88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hinton, OKThe pilot departed bethany, Oklahoma on a local pleasure flight with the fuel tanks slightly less than 1/2 full. After about a 1.5 hour flight, he landed at the red rock airport in Hinton, Oklahoma. No service was performed on the aircraft while in Hinton and…Jun 1, 1988 · N25352 · Substantial damageNTSB DEN88LA117Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Ft. Collins, COJun 1, 1988 · N6638N · Substantial damageNTSB DEN88LA116Accident · Serious injuriesLimited investigationFinal reportCessna TR-182RG · Englewood, COThe CFI, a private rated dual student, and one passenger were preparing to depart on a training flight. The CFI attempted to hand prop the airplane when the battery was found to be inoperative. During the attempt, the CFI was struck in the back of the head.Jun 1, 1988 · N999HP · No damageNTSB DCA88IA060Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Jamaica, NYNone submittedJun 1, 1988 · SXOAB · Minor damageNTSB MKC88LA104Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hickory Ridge, ARWhile executing a standard procedure aerial application turn around maneuver, the acft began to settle. The plt dumped his remaining chemical load, but acft continued to settle, and mushed into the trees. Post accident fire destroyed the acft, but the plt…May 31, 1988 · N9653 · DestroyedNTSB MIA88LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco Island, FLWhile on an instructional flt prior to touchdown on rwy 17, the flt was advised that the winds were from 110 degrees at 15 KTS with gusts to 20. The CFI stated that the aircraft was slow on final apch. With 20 degrees of flaps lowered, the acft was blown off…May 31, 1988 · N25516 · Substantial damageNTSB FTW88DRG10Accident · Minor injuriesFinal reportPiper PA-28RT-201 · Lampasas, TXThe pilot experienced a partial loss of engine power during cruise, while on a night, VFR, cross-country flight. He attempted to spiral down to an airport for an emergency landing but reported that he became disoriented and attempted to land downwind,…May 31, 1988 · N8209H · DestroyedNTSB CHI88LA124Accident · No injuriesLimited investigationFinal reportBeech B-19A · Lacon, ILA hard landing made by the student pilot after attempting to recover from a bounced landing.May 31, 1988 · N4306S · Substantial damageNTSB CHI88FA120Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Wautoma, WIPerformance of an aerobatic maneuver with insufficient altitude for recovery.May 31, 1988 · N28156 · DestroyedNTSB CHI88DEM05Accident · No injuriesFinal reportBell 47G-2A · Midland, MIThe plt rprtd that before takeoff, he checked the fuel gage & concluded there was enough fuel to dispense his load. However, after spraying out the load, he started to return to the landing site & then the eng lost power from fuel exhaustion. The helicopter…May 31, 1988 · N440TG · Substantial damageNTSB SEA88LA101Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lester State, WAThe pilot inadvertently flew into a narrow valley with trees on both sides and steep rising terrain during climb to cruise. The aircraft was not able to outclimb the rising terrain, so the pilot slowed the aircraft to 40 m.p.h. and attempted a shallow…May 30, 1988 · N20580 · DestroyedNTSB NYC88LA148Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Dover, PALoss of engine power for an unknown reason. Contributing factors were: failure of the pilot to maintain runway alignment obstructions near the end of the runway (sign, stone fence & tree).May 30, 1988 · N9981L · Substantial damageNTSB NYC88DGT02Accident · Minor injuriesFinal reportBell 47G3B1 · Cove Gap, PAThe helicopter plt was taking off from an area surrounded by trees & buildings for a local spray operation. The wind was calm. Reportedly, during the attempted departure, the plt 'exhausted all power available then made right turn to return to field.' After…May 30, 1988 · N48181 · Substantial damageNTSB MKC88LA102Accident · No injuriesLimited investigationFinal reportPitts S-2 · Siloam Springs, ARThe pilot said that after takeoff and reaching a safe altitude, he made an immediate hard left turn resulting in a loss of control. Pilot did not recover from the resultant stall.May 30, 1988 · N246PC · Substantial damageNTSB MIA88IA181Incident · No injuriesIncident investigationFinal reportCessna P210N · Daytona Beach, FLThe plt rprtd that while on final apch to land, he became distracted by conversation with the passenger & failed to lower the landing gear. Subsequently, the acft was landed with the gear retracted. After it was lifted from the rwy after the incident, the…May 30, 1988 · N6330W · Minor damageNTSB LAX88LA206Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Long Beach, CAWhile on final approach to the runway, the engine quit. During the forced landing the empennage caught on the airport boundary fence. The airplane collided with the terrain and nosed over. Inspection of the fuel tanks revealed that one tank was empty and the…May 30, 1988 · N6178N · Substantial damageNTSB LAX88LA203Accident · Minor injuriesLimited investigationFinal reportBell 206B · Honolulu, HIDuring a sightseeing flt, just after take off, the helicopter began to spin to the right, the plt tried to correct the situation by applying left rudder. The helicopter continued to spin. The plt reduced the throttle and adjusted the collective. The spin…May 30, 1988 · N83203 · DestroyedNTSB LAX88FA204Accident · 2 fatalField investigationFinal reportTaylorcraft BL65 · Eloy, AZFailure of the pilot to maintain control of the aircraft during takeoff climb resulting in an inadvertent spiral. Contributing to this accident was the pilot's lack of total experience in the aircraft make and model.May 30, 1988 · N27463 · DestroyedNTSB LAX88FA196Accident · 1 fatalField investigationFinal reportBeech H-35 · Phoenix, AZThe plt had just completed a flight from farmington, n.m., to Phoenix, AZ (phx) where she deplaned her pax. The plt dept phx enroute to mesa, AZ, (ffz). After t.o. the LCL controller instructed the plt to turn right to 300 deg and to turn on the xpndr; the…May 30, 1988 · N904Q · DestroyedNTSB CHI88LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Romeoville, ILMay 30, 1988 · N68312 · Substantial damageNTSB SEA88LA102Accident · No injuriesLimited investigationFinal reportBeech B55 · Reno, NVThe pilot was attempting to land on runway 25 with winds from 290 degrees at 17 knots. Just prior to flare, the aircraft encountered a gust of wind. The pilot lost control of the aircraft and landed hard on the right main gear. The right strut, wheel and…May 29, 1988 · N8567M · Substantial damageNTSB NYC88LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · W. Peru, METhe cockpit of the Piper PA-28 filled with smoke after takeoff, at an altitude of approximately 800 ft. the pilot tried to land on a road and struck trees, shearing off the wings. The fuselage landed on a road, inverted and was immediately enfulfed in flames.…May 29, 1988 · N54368 · DestroyedNTSB NYC88LA155Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Franconia, NHThe pilot landed the aircraft long on a grass runway with a tailwind. The pilot reported that she touched down longer than anticipated, but she thought she would have had adequate stopping distance. She was unable to stop the acft on the remaining runway and…May 29, 1988 · N6115B · Substantial damageNTSB NYC88LA151Accident · 1 fatalLimited investigationFinal reportBeech 23 · Meriden, CTThe Beech 23 lost power during a go-around. During an off-airport landing, the acft struck a house. The private pilot died the following day of injuries and the flight instructor was seriously injured. There was no evidence of a large fuel spill and only…May 29, 1988 · N6042X · Substantial damageNTSB NYC88LA150Accident · No injuriesLimited investigationFinal reportCessna 305A · Colts Neck, NJLoss of power due ot vapor lock of the aircraft engine and an off airport landing and collision with an object.May 29, 1988 · N5202G · Substantial damageNTSB NYC88FA147Accident · 1 fatalField investigationFinal reportLake LA4-250 · Shaftsbury, VTThe Lake amphibian was being flown with two ferry tanks installed in the cabin. The pilot departed with full fuel in the aircraft tanks and 15 gallons in the ferry tanks. The center of gravity at zero fuel weight was 3/4 inch past the aft limit. With addition…May 29, 1988 · N1405F · DestroyedNTSB NYC88DFA01Accident · No injuriesFinal reportLloyd Feary VJ-22 · Kingston, NYThe aircraft was substantially damaged when it swerved off the side of the runway during landing roll on the first flight by the new owner. The homebuilt amphibian had been inspected by a mechanic, who signed off an annual inspection for the engine but noted…May 29, 1988 · N59262 · Substantial damageNTSB MKC88LA100Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Bismark, MOThe accident aircraft was observed making several low passes over lake Bismark near Bismark, Missouri. Witnesses stated that, following the last pass, the aircraft contacted the water and sank. The pilot's blood alcohol content was analyzed as .14 percent…May 29, 1988 · N8122V · Substantial damageNTSB MKC88LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Des Moines, IADuring a cross country flight, an emergency landing was made within three miles of destination airport. The aircraft nosed over after landing attempt, and passenger and PIC were not injured. Post flight inspection revealed engine had failed due to fuel…May 29, 1988 · N67360 · Substantial damageNTSB LAX88FA215Accident · 4 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAInflight encounter with forcasted severe icing and turbulence beyond the capability of either the aircraft or the pilot , which led to an inflgiht loss of control. Factors in the accident were the pilots lack of understanding of high altitude flight aspects…May 29, 1988 · N98683 · DestroyedNTSB LAX88FA197Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pinecrest, CAPilots decision to continue VFR flight through a mountain area after encountering instrument meteorological conditions.May 29, 1988 · N1259T · DestroyedNTSB FTW88LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Denton, TXThe instructor was simulating an engine-out emergency for the dual student. The student was making an approach to an emergency field with a line of trees on the approach end. When the instructor became aware that they might not reach the field, he directed…May 29, 1988 · N98088 · DestroyedNTSB FTW88LA111Accident · No injuriesLimited investigationFinal reportCessna 210D · New Roads, LAThe airplane had not had an annual inspection and had not been flown for over a year. The pilot stated he found no contamination during the draining of the fuel sumps. Shortly after takeoff, the engine started sputtering and eventually stopped. During the…May 29, 1988 · N3799Y · DestroyedNTSB FTW88DQG05Accident · 1 fatalFinal reportPiper PA-25-260 · Stratford, TXWhile maneuvering during an aerial application flt, the pilot allowed the right wing to contact the ground. The aircraft was destroyed in the accident with fatal injuries to the pilot.May 29, 1988 · N8810L · DestroyedNTSB FTW88DQA01Accident · 1 fatalFinal reportAerotek Pitts S2S · El Paso, TXPilot's failure to complete the aerobatic maneuver in a manner which insured adequate terrain clearance at the termination.May 29, 1988 · N5333N · DestroyedNTSB CHI88LA121Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ILThe pilot said that on final apch, 'a rapid descent took place.' The aircraft touched down on the rwy and bounced. The pilot said he added pwr and lowered the nose, but the nose gear and propeller hit the rwy. The acft bounced again and sustained substantial…May 29, 1988 · N736AF · Substantial damageNTSB BFO88LA052Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Milford, DEThe plt stated the landing apch was too fast and the acft bounced on touchdown. The plt stabilized the acft and attempted another touchdown, however, the acft bounced again. Having used over half the rwy by this time, the plt elected to abort the landing by…May 29, 1988 · N35253 · DestroyedNTSB SEA88LA106Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Elgin, ORThe purpose of the flight was for the pilot to practice for his aerial applicators certificate. Water was being used instead of chemical. The pilot reported that as the aircraft began to accelerate during takeoff it began to oscillate. As in prior…May 28, 1988 · N370FH · Substantial damage