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 ATL88DKG04Accident · Serious injuriesFinal reportWeber Evans VF-1 · Fort Payne, ALFeb 26, 1988 · N18JW · Substantial damageNTSB SEA88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Yakima, WAThe pilot had just purchased the aircraft and was practicing takeoffs and landings. On the first landing attempt, during the ground roll after touchdwn, the pilot lost directional control and the aircraft ground looped.Feb 25, 1988 · N8919C · Substantial damageNTSB MKC88LA055Accident · No injuriesLimited investigationFinal reportCarter Quickee 2 · Springfield, MOWhile flying a homebuilt aircraft, under experimental category, the pilot experienced an engine failure. An emergency ldg was made on a highway, and during the ldg roll the acft struck some marker barrels, suffering substantial damage. The pilot said the…Feb 25, 1988 · N587TC · Substantial damageNTSB MIA88LA113Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Jupiter, FLThe plt stated that he had completed a ldg away from his home base without the gear down & locked lights being illuminated. He stated that he had assumed the lights were 'burned out'. Upon departure, he retracted the gear & flew to his home airport. Upon…Feb 25, 1988 · N7377Y · Substantial damageNTSB LAX88LA116Accident · No injuriesLimited investigationFinal reportBeech F35 · Pacoima, CAThe plt rprtd that he had initially psnd the fuel selector (sel) to the left main tank. He said that after abt 1 hr of flt (near palmdale, CA), he psnd the sel to the rgt main tank for a short time, then (near Pacoima), he moved it back to the left main tank.…Feb 25, 1988 · N5041B · Substantial damageNTSB LAX88DUM03Accident · Minor injuriesFinal reportBeech A36 · Ramona, CADuring a test flight for certification of wing tip tanks, while performing spins, the aircraft entered a flat spin. The pilot was unable to regain control and exited the aircraft and parachuted to safety. The aircraft collided with the terrain shortly…Feb 25, 1988 · N23536 · DestroyedNTSB CHI88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minneapolis, MNStudent pilot stated that airplane went off runway at 50 KIAS after losing control during landing rollout. Airplane sustained substantial damaged when nose gear collapsed.Feb 25, 1988 · N2359K · Substantial damageNTSB MIA88FA114Accident · 2 fatalField investigationFinal reportCessna 172N · Kissimmee, FLThe acft was observed at about 2000 ft sw bound & the sound of the eng could be heard. The acft was next observed about a minute later inbound at about 50 ft & eng sound could be heard. The witness heard a 'poof' sound & the acft was observed inverted. The…Feb 24, 1988 · N5211E · DestroyedNTSB LAX88LA115Accident · No injuriesLimited investigationFinal reportCessna 180A · Prescott, AZDuring the dual primary cross country flight, the student was making the approach and landing at Prescott. The CFI said that the approach and touchdown were normal, however, the aircraft began drifting to the right in a gradual turn as the aircraft slowed.…Feb 24, 1988 · N26AW · Substantial damageNTSB FTW88DPJ03Accident · Serious injuriesFinal reportCessna 172M · Norman, OKPilot retracted flaps during go around and aircraft settled into trees and was destroyed. Front seat occupants were not wearing the available shoulder harnesses. The acft was landing with a quartering tailwind. Due to serious head injuries the plt never…Feb 24, 1988 · N20129 · DestroyedNTSB CHI88LA086Accident · No injuriesLimited investigationFinal reportMooney M-20C · Minneapolis, MNWhile executing touch and go landings the pilot's attention was diverted inside the aircraft while adjusting the interior lights to determine the position of the flaps. He lost control of the aircraft and it departed the runway striking a snow bank.Feb 24, 1988 · N6228U · Substantial damageNTSB CHI88LA068Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILFeb 24, 1988 · N4917K · Substantial damageNTSB CHI88DEM01Accident · Minor injuriesFinal reportNorth American T-28A · Schoolcraft, MIWhile the pilot was climbing through 7800 MSL he noticed a vapor trail coming from the right exhaust area. The pilot notified approach control that he was returning to the departure airport and they supplied radar vectors. The pilot started a descent and…Feb 24, 1988 · N14142 · Substantial damageNTSB BFO88LA020Accident · No injuriesLimited investigationFinal reportMaule MX7-180 · Lewisburg, WVThe plt started landing flare on rwy 22 when he encountered wind gusts. The acft swung right and the left wing struck the rwy. The acft cartwheeled and came to a stop inverted.Feb 24, 1988 · N5662H · Substantial damageNTSB ATL88LA099Accident · No injuriesLimited investigationFinal reportBeech 18S · Morganton, NCPIC aborted first takeoff attempt due to crosswind induced directional control difficulties. During second takeoff attempt, gusty crosswind lifted left wing & acft became airborne. PIC forced acft back onto rwy, lost directional control and veered off rwy…Feb 24, 1988 · N1480K · Substantial damageNTSB NYC88LA092Accident · No injuriesLimited investigationFinal reportCessna 182 · Westfield, PAThe pilot was attempting a soft field takeoff with full power and right rudder applied. During ground run, the tail of the aircraft struck a snowbank, pulling the aircraft into the snow. When the left main gear hit the snow the aircraft flipped over onto its…Feb 23, 1988 · N3374F · Substantial damageNTSB FTW88LA071Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Benito, TXThe student plt was making a touch and go on his second solo flt. After the flaps were retracted and the power was increased, the acft veered to the right and hit a runway light. The acft then continued into the dirt beside the runway where the nose gear…Feb 23, 1988 · N24447 · Substantial damageNTSB FTW88LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Fabens, TXThe plt reported that the eng ran rough on a previous flt and he removed, cleaned, and replaced the spark plugs. He then took off and at a point seven miles from the departure arpt, the eng again began to run rough and intermittently. An emergency landing…Feb 23, 1988 · N5542Z · Substantial damageNTSB DEN88DQA02Accident · Minor injuriesFinal reportShiner Pitts S-1S · Los Lunas, NMThe plt reported that the tailwheel steering chain broke during the landing rollout. When the acft slowed to about 30 KTS the rudder was no longer effective and the plt was unable to control direction by use of the brakes. The acft turned to the lt and ran…Feb 23, 1988 · N79SS · Substantial damageNTSB CHI88FA067Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Martinsville, INPilot to take into caonsideration the wind direction and velocity before selecting his takeoff direction.Feb 23, 1988 · N9958U · DestroyedNTSB ANC88LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kipnuk, AKThe pilot stated that during the initial climbout from the airport he encountered a complete whiteout condition. The pilot then elected to land on the frozen lake and during the rollout the aircraft struck a snowbank.Feb 23, 1988 · N8429N · Substantial damageNTSB NYC88LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Rochester, NHDuring landing, the flight encountered a crosswind from the left and almost immediately the aircraft became airborne again. The pilot flared for landing, landed hard, bounced and at this time the pilot decided to abort and go around. The aircraft drifted to…Feb 22, 1988 · N1061F · Substantial damageNTSB LAX88LA111Accident · Serious injuriesLimited investigationFinal reportCessna R182 · San Andreas, CADuring a night flight the plt attempted to land on a 3600-FT-long rwy. He misjudged his altitude, touched down long & attempted to go-around. The acft became airborne & upon passing the airport's boundary it collided with a fence & crashed. The plt did not…Feb 22, 1988 · N3178C · DestroyedNTSB DEN88LA075Accident · No injuriesLimited investigationFinal reportCessna 206G · Loveland, COA commercial plt was flying a group of parachutists for a skydiving club. The aircraft encountered turbulence during a climb to 4,500 feet AGL. As the second jumper was exiting, the aircraft dropped and the parachutist struck the horizontal stabilizer. The…Feb 22, 1988 · N756EY · Substantial damageNTSB ATL88LA097Accident · No injuriesLimited investigationFinal reportCessna 172 · Jackson, TNWhile returning home with his newly purchased acft the plt made a refueling stop. The winds were strong and gusting upwards of thirty KTS at the refueling arpt and the destination arpt. During the takeoff roll the winds shifted to a right crosswind. The acft…Feb 22, 1988 · N6285E · Substantial damageNTSB MKC88FA054Accident · 1 fatalField investigationFinal reportBell 47D1 · Nixa, MODuring the process of moving the helicopter from the hangar the right skid slipped off the concrete helipad and became stuck in the mud. The pilot attempted to dislodge the skid by bringing the aircraft to a hover. The left skid became airborne and contacted…Feb 21, 1988 · N7735 · DestroyedNTSB LAX88FA113Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Rosamond, CADecision of the pilot to attempt multiple low level passes over a residence in an area of rising terrain. Contributing to the accident was the significant levels of methamphetamine and amphetamine found in both the pilot's blood and urine specimens. A factor…Feb 21, 1988 · N8321K · DestroyedNTSB FTW88LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Fort Worth, TXThe flt was cruising at 2,000 ft MSL when the eng lost pwr. The student plt changed fuel tanks and the engine regained pwr for about 20 sec then again lost pwr. During the forced landing the acft collided with a fence and nosed over. Examination of the eng by…Feb 21, 1988 · N3524P · Substantial damageNTSB FTW88DRG06Accident · Minor injuriesFinal reportHodges Condor III +2 · Canyon Lake, TXThe homebuilt airplane was being flown by the new owner and his son. After two takeoffs and landings, the airplane was 5O feet in the air when the engine quit. The pilot stated in his report, 'we suspect a kill switch was inadvertently touched and this was…Feb 21, 1988 · N5539Z · Substantial damageNTSB DEN88LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Aurora, COFeb 21, 1988 · N2904C · Substantial damageNTSB DEN88LA077Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Gila, NMThe plt said that he and his friend were on a pleasure flt following a river bed when he spotted some electrical power lines ahead. He said that he felt that he had adequate clearance over the lines but that he did not see the static line above the wires. The…Feb 21, 1988 · N2359E · Substantial damageNTSB DEN88LA076Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Miles City, MTFeb 21, 1988 · N6693R · Substantial damageNTSB CHI88LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, ILThe aircraft experienced a hard landing followed by collapse of the nose gear. The student pilot stated that he bounced on his first attempt to land and the second touchdown was nose first which resulted in the collapse of the nose gear.Feb 21, 1988 · N18225 · Substantial damageNTSB BFO88LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Annapolis, MDThe plt said he did a preflight inspection of the acft which included a check for water in the fuel. Tanks were partially full- 17 gals in each one. A pre-takeoff eng runup was normal. During the initial takeoff climb the eng had a partial power loss. After…Feb 21, 1988 · N32019 · Substantial damageNTSB BFO88FA024Accident · 2 fatalField investigationFinal reportCessna 177RG · Ellamore, WVAprx 3 hrs and 26 minutes after takeoff from republic airport, the plt reported having engine problems. Unable to make it to an airport, the plt radioed that he was going to attempt to land on a road. The airplane struck trees and crashed in a wooded area…Feb 21, 1988 · N2109Q · DestroyedNTSB ATL88LA098Accident · No injuriesLimited investigationFinal reportBeech 77 · Concord, GAPIC obtained wx brief of high winds from northwest with strong gusts. Takeoff was from pvt strip with wind sock which showed wind aligned with rwy 01. As takeoff roll was begun wind shifted to 90 degrees left crosswind. At rotation left wing was lifted by…Feb 21, 1988 · N623CH · Substantial damageNTSB ATL88IA096Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Elyria, OHFeb 21, 1988 · N5740Y · Minor damageNTSB NYC88LA088Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Morristown, NJThe Mooney crashed while on a ILS approach at night. The plt had been unable to get into two other airports due to weather and air traffic. The aircraft impacted in swampy area. The pilot had told ATC that he felt uneasy about his engine; however, he did not…Feb 20, 1988 · N5782E · Substantial damageNTSB NYC88FA093Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Stratford, CTThe pilot and pilot-rated pax received vectors for multiple ILS approaches in deteriorating conditions. On the first attempt the aircraft passed over witnesses but was off course and not in a position to land. The second attempt was aborted before reaching…Feb 20, 1988 · N2469M · DestroyedNTSB NYC88FA087Accident · 3 fatalField investigationFinal reportPiper PA-31-325 · Hamilton Twp., NJThe aircraft disappeared from radar at approximately 1 mile final on a night ILS rwy 13 approach. Radar data indicated that the aircraft completed almost 180 degrees of turn prior to disappearing. The aircraft crashed in a heavily wooded area. No evidence of…Feb 20, 1988 · N27400 · DestroyedNTSB MIA88LA111Accident · No injuriesLimited investigationFinal reportCessna A188B · Macon, MSThe plt stated that during the takeoff roll, the left lndg gear failed causing the acft to swerve off the rwy & into a ditch bordering the rwy. An exam by FAA personnel revealed tire marks on the rwy which continued off the rwy & into the ditch. According to…Feb 20, 1988 · N4489Q · DestroyedNTSB MIA88IA112Incident · No injuriesIncident investigationFinal reportCessna 182 · Stuart, FLWhile on final apch to land from a banner towing flt, the eng lost power due to fuel exhaustion. The plt made an emergency landing off the airport, but the nose gear collapsed, which resulted in minor damage.Feb 20, 1988 · N6418A · Minor damageNTSB LAX88FA114Accident · 2 fatalField investigationFinal reportBeech A23 · Big Bear City, CAThe passenger told friends that the pilot was going to perform some aerobatic maneuvers near the lodge where they were staying. The other residents in the lodge reported that the airplane flew very low over the house and proceeded towards the east. After…Feb 20, 1988 · N1461L · DestroyedNTSB FTW88FA069Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Big Spring, TXThe pilot was on a local pleasure flight practicing aerobatic maneuvers in the vicinity of the airport. Witnesses thought the pilot was entering the pattern for landing at the completion of the aerobatic practice. They noted a power reduction after which the…Feb 20, 1988 · N29779 · DestroyedNTSB DEN88LA080Accident · Minor injuriesLimited investigationFinal reportCessna TU-206 · Durango, COWhile on a cross country flight the plt ran short of fuel and altered course to another airport. The pilot said the acft engine failed short of the new destination due to fuel exhaustion. The plt performed an emergency landing in an open field and the acft…Feb 20, 1988 · N9848M · Substantial damageNTSB DCA88MA032Accident · 12 fatalMajor investigationFinal reportFairchild SA227-AC · Cary, NCThe aircraft departed during low ceiling, low visibility, and night conditions. Shortly after takeoff the aircraft impacted a reservoir. Analysis of radar data indicated the acft was in a 45 degree descending turn. Exam of the acft trim system showed that the…Feb 20, 1988 · N622AV · DestroyedNTSB ATL88LA095Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Jacksonville, ALThe pilot had just purchased the aircraft and it had less than one hour on the overhauled engine. The pilot was at 1500 feet when the engine quit. On final approach to the emergency landing area, the aircraft collided with trees. The engine examination…Feb 20, 1988 · N1703R · Substantial damageNTSB SEA88IA051Incident · Minor injuriesIncident investigationFinal reportPiper PA-31T · Las Vegas, NVWhile cruising at FL270, right side cockpit window failed, resulting in decompression. Acft diverted to normal landing. Examination revealed lower bolts overtorqued and plexiglas compromised by excess primer, initiating cracking. Evidence indicated window not…Feb 19, 1988 · N2645Z · Minor damageNTSB MIA88LA109Accident · 3 fatalLimited investigationFinal reportPiper PA-28-161 · Stuart, FLBfr depg at ngt with no flt plan, non-inst rated plt was adzd of psbl clds forming at a low lvl. En route, he got radar flt flwg. Apchg his destn, he got vctrs & alt chgs to avoid wx & otr acft. At 2001:04, radar svc was trmtd with palm bchapch ctl to cont…Feb 19, 1988 · N43253 · DestroyedNTSB LAX88LA112Accident · No injuriesLimited investigationFinal reportCessna 172N · Temecula, CAAt the end of a local pleasure flight, while on final approach, the pilot reported that there was a strong crosswind. Just prior to touchdown the wing lifted and the pilot lost control of the aircraft and collided with a wind tee. There were no mechanical…Feb 19, 1988 · N5135K · Substantial damage