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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX84FA170Accident · Serious injuriesField investigationFinal reportPiper PA-31T · Riviera, AZAcft lost pwr on the left eng during climb to cruise aprx 8 minutes after takeoff. Arpt mgr heard UNICOM transmission from N36CA, 'we lost an eng, we're coming back.' A warning horn (possibly gear warning or stall horn) was heard in the background of the…NTSB FTW84LA130Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A · Benavides, TXThe plt was herding cattle when an eng failure occurred over a small group of trees. The plt auto-rotated and the acft landed hard.NTSB CHI84LA104Accident · Minor injuriesLimited investigationFinal reportBryan Dragon FLY · Vanolia, OHThe plt stated that after takeoff, while on downwind, the eng failed. He attempted to land back on the runway when the left wing struck the ground. The acft then struck a 55 gal concrete drum and a chain link fence. Examination of the acftrevealed that a…NTSB NYC84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-600 · Newark, NJThe acft was on landing roll when it began to veer from the rwy. The plt attempted to maintain directional control but the acft left the rwy and collided with a taxiway marker sign causing substantial damage to the acft. Shortly thereafter, the right main…NTSB MKC84LA100Accident · No injuriesLimited investigationFinal reportBeech F90 · Jonesboro, ARWhile en route to Jonesboro, the plt was informed the rwy and taxiway lights were inop. When he asked fss if the arpt was closed the reply was, 'negative, land at your own risk.' The plt lined up with what he thought was rwy 05 but in actuality it was a…NTSB FTW84LA236Accident · No injuriesLimited investigationFinal reportBeech D17S · Stratford, TXThe pilot stated after the accident that the engine failure occurred as the acft climbed through 6500 feet. According to the plt the no. 1 cylinder separated from the radial eng. The acft nosed over during the landing on unimproved terrain.NTSB DEN84FA086Accident · 1 fatalField investigationFinal reportCessna T210M · Sidney, MTRichland flt #101, a bank check courier flt, departed VFR with 180 lbs of cargo. Six minutes prior to the crash, the last radio transmission from the acft was heard concerning a routine landing wx advisory. The acft crashed aprx 45 degs nose low, gear & flaps…NTSB SEA84LA049Accident · No injuriesLimited investigationFinal reportCessna A185F · Winslow, WADuring a water landing the acft was in turbulent crosswind conditions when the left float and wing dug into the water. The acft cartwheeled and came to rest with the right wingtip touching the bottom of the bay. The plt stated it would have been more prudent…NTSB NYC84LA083Accident · No injuriesLimited investigationFinal reportCessna 150H · Leonardtown, MDThe student plt was on his 1st supervised solo flt. During a landing, the acft encountered a x-wind & was blown off the centerline of the rwy. The student added power to go around. However, he said that he failed to lower the nose & the acft stalled. During…NTSB LAX84LA167Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Lake Havasu Cit, AZIn cruise at 8,500 ft MSL the propeller ass'y forward of the mounting flange separated from the acft. During the forced landing rollout the acft struck a tree. Airworthiness directive 82-27-01 called for inspection of the prop hub and mounting bolt hole areas…NTSB FTW84FA127Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Lampasas, TXThe acft descended into the ground along the east bank of the Colorado river at about a 45 deg angle to the horizon in a wings level attitude. There were no witnesses to the accident. Investigation revealed that the plt was planning a springtime canoe trip…NTSB FTW84FA126Accident · 1 fatalField investigationFinal reportPiper PA-30B · Hugo, OKAccording to witnesses, the acft was having some kind of problem after takeoff. It entered a nose high attitude, went to the right & crashed. An exam revealed that it had impacted in a nose down attitude. The landing gear was found in a down & locked…NTSB CHI84LA103Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Logansport, INThe plt stated that the acft eng was running rough at rotation. He climbed to approx 300 ft AGL and began a left trafficpattern back to rwy 27. A landing was made 225 ft short of the rwy. During the post-accident eng run-up the eng started easily and ran…NTSB SEA84FA048Accident · 1 fatalField investigationFinal reportSikorsky S-61L · Medford, ORThe plt deviated from the painted taxi line to avoid a parked fuel truck and collided with a hangar door. The main rotor hit the door and flying debris damaged 2 hangers,3 acft and 2 cars.NTSB LAX84LA166Accident · No injuriesLimited investigationFinal reportCessna 150M · Fremont, CAThe plt said he was doing a precautionary landing because he heard a 'pop' during a practice spin. During the landing the wing of the acft struck a tree. The acft was successfully flown back to the arpt and landed without further incident.NTSB LAX84LA165Accident · Serious injuriesLimited investigationFinal reportCessna 180J · Hayward, CADuring arrival, the plt had descended to stay below the tca & was approaching his destination when the eng lost power. He turned back toward the Hayward arpt, but was unable to reach it or restart the eng. During a forced landing at night, the acft was…NTSB LAX84LA163Accident · Serious injuriesLimited investigationFinal reportHughes 500C (369HS) · San Diego, CAThe plt reported a partial power loss. During the forced landing tahe right skid collapsed & the t/r severed the tail boom. During a subsequent eng test, the eng would produce no more than 20 PSI torque at 100% N2. The fuel control & fuel nozzle were found to…NTSB DEN84LA087Accident · No injuriesLimited investigationFinal reportTexas Helicopter 205 · Erie, COThe plt reported that he landed on rwy 15 with a wind from O90 deg at 20 gusting 30 KTS. After touchdown, the acft began veering to the left. The plt applied right rudder & right brake, but the left wheel dropped off the left side of the rwy & went into mud.…NTSB DEN84LA083Accident · Minor injuriesLimited investigationFinal reportMaule M-4S · Three Forks, MTThe plt was flying low toward rising terrain. The airspeed slowed to the point that the point that the acft mushed into the ground and cartwheeled. The plt said he had not removed all the frost on the wings prior to flt and he thought the stall speed was…NTSB ATL84FA092Accident · 1 fatalField investigationFinal reportCessna 210 · Newport News, VAThe flight had been airborne for aprx 38 mins when the pilot began experiencing communication problems. Nine minutes later the pilot reported 'instrument problems' and began to receive radar vectors to a landing. 15 minutes later she declared an emergency and…NTSB NYC84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Easton, PAThe student plt on his first solo flt veered off the rwy into a snowbank and nosed over. The plt said a puddle of water on the rwy contributed to the beginning of the swerve and he could not recover.NTSB MKC84LA070Accident · No injuriesLimited investigationFinal reportCessna 182 · Derby, KSDuring an apch from the south in gusty wind conditions, the acft crossed over wires & shrubbery with 20 deg of flaps. The plt reported that before reaching the rwy, the'lost air & descended straight down.' The acft touched down in mud, short of the rwy. The…NTSB MIA84FA072Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Hoboken, GAWhile on base leg for landing, the forward right wing strut failed causing the right wing to separate. The acft then entered an uncontrolled descent & crashed. The non-certificated plt owned the acft. He had not complied with airworthiness directive 77-03-08.…NTSB LAX84FA164Accident · No injuriesField investigationFinal reportPiper PA-38-112 · Fullerton, CAThe acft engine lost power during a go around following a long power-off glide during which carburetor heat was not used. During the forced landing in a soft cultivated field the acft nose wheel' dug in' and the acft nosed over. The weatherreport indicated…NTSB FTW84LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Lamkin, TXThe acft nose gear dug into the soft sod rwy and collapsed. After the nose gear collapsed the acft nosed over and slid inverted for about 100 ft. the FAA coordinator said the plt apparently forced the nose down while trying to maintain directional control.…NTSB DEN84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe acft swerved off the rwy and collapsed the left main landing gear during landing. The plt said he believes he misused the heel brakes during the landing roll since he was more familiar with acft with toe brakes.NTSB NYC84FA081Accident · 2 fatalField investigationFinal reportCessna 402 · Jaffrey, NHThe plt had filed an IFR flt plan; however, he took off in VFR conditions & did not activate the flt plan. Radar data showed that the latter part of the flt was flown at 6300 ft, then at 1712:39 EST, a descent was begun. One minute later, the flt was last…NTSB MKC84FA069Accident · Minor injuriesField investigationFinal reportBellanca 17-30 · Kansas City, KSThe acft caught fire shortly after takeoff, the plt declared an emergency and the acft was cleared to 'take any runway or any taxiway.' The plt landed in an open field on the airport. The acft was destroyed by fire. Investigation revealed that the main source…NTSB MIA84LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Naranjito, PRThe acft collided with hilly terrain during a low pass. The plt was preparing to land at a nearby private airstrip.NTSB FTW84FA125Accident · 1 fatalField investigationFinal reportCessna 152 · College Station, TXThe plt had received a telephone wx briefing at 1610 & an in-person wx briefing at 1932, about 45 min before takeoff. The local wx deteriorated considerably between the last briefing & the time of the accident. The acft departed at 2016, & at 2024 the acft…NTSB DEN84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Dixon, WYThe acft began to wander back & forth across the rwy on the takeoff roll. The CFI took control as the acft veered to theleft. The left wheel hit a snowbank & the acft ground looped to the left substantially damaging the right wing before coming to rest. There…NTSB DEN84FA085Accident · 1 fatalField investigationFinal reportCessna TR182 · Tappen, NDThe private non-instrument rated plt received two weather briefings before the flight. During the last briefing at 1350 MST, he was informed that VFR flt was not recommended. At 1554 MST, the acft departed crystal arpt in a westerly direction. Several…NTSB CHI84LA102Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Bellaire, MIDuring the flare round out, 100 ft from the rwy at 10 ft AGL the acft stalled at 100 KIAS. Aprx 1/8 inch of ice was present on the airfoils. Moderate rhime ice was reported in the clouds along the route of flight. The plt did not activate the de-ice boots…NTSB NYC84FHJ01Accident · No injuriesFinal reportGordon Teenie TWO · Hauppauge, NYThe acft engine failed internally and oil spraying on the windshield reduced the plts visibility during the forced landing. During the rollout on a road the acft collided with a stop sign. An exam revealed there was no compression in the left rear cylinder.…NTSB FTW84LA128Accident · No injuriesLimited investigationFinal reportRyan PT-22C · El Paso, TXInvestigation revealed a touch-and-go landing was completed when the acft became airbourne prematurely and drifted slowly left in a light crosswind. After flying about 2000 ft the main gear struck the top of a sand dune and the acft nosed over.NTSB CHI84LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lk In The Hills, ILThe plt made a hard landing which damaged the nose gear making it impossible for the plt to avoid a collision with a snowbank during a subsequent landing.NTSB CHI84LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · New Paris, OHThe acft collided with a power line while practicing an emergency approach to a field. The plt stated he struck the top wire of two wires strung about 30 ft AGL.NTSB ATL84LA091Accident · No injuriesLimited investigationFinal reportCessna 404 · Covington, KYA fire ignited in the right engine on the landing roll. The fire source was near the point where the fuel supply line connects to the engine driven fuel pump. The acft was on its first revenue flight after the right engine was changed, atwhich time the…NTSB ATL84FA090Accident · 4 fatalField investigationFinal reportBeech 23 · Loris, SCThe estimated time of takeoff was about 1930 EST. The route of flt before 2000 EST was not known. At aprx 2005, the plt reported that he was unsure of his position. Shortly after that, the acft was identified over a military firing range. The plt was vectored…NTSB FTW84LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft landed hard and bounced. The plt reacted by pushing the nose over and when the acft contacted the rwy the nose gear collapsed.NTSB DEN84LA080Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Santa Fe, NMThe plt noticed the throttle sticking on takeoff and tried to abort the takeoff but the throttle was binding. The acft tookoff at a below normal speed and had to be landed. Subsequently, the acft impacted the ground & several trees. An engineer said the…NTSB DEN84FA081Accident · 1 fatalField investigationFinal reportEnstrom F-28C · Chester, MTAccording to a company employee, the plt made a radio call from a remote mountain site where the plt was doing some workon a transmitter tower & stated that he was taking off, & if the employee did not hear from him in an hour to come look for him. The…NTSB CHI84LA101Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Lacon, ILThe plt was ferrying the acft to the Lacon arpt for winter storage. On final apch she touched down short & struck a snow bank on the apch end of the rwy. The plt stated that difficulty in depth perception due to the snow covered terrain resulted in touchdown…NTSB ANC84LA034Accident · Serious injuriesLimited investigationFinal reportHelio H-250 · Iliamna, AKAccording to witnesses, the ski equipped acft took off toward the north. They reported that after taking off, the acft made a tight left turn, then spiraled to the ground. They estimated that the maximum alt was aprx 150 ft. also, they reported that the eng…NTSB DEN84LA079Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Ogden, UTThe plt took off from a mountainous work site to return to salt lake city, UT. The wx was clear at the work site (elevation 6700 ft), but there was fog below. After encountering the fog, the plt hovered with a slow forward speed over snow covered terrain. A…NTSB CHI84LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Lone Rock, WIDuring the takeoff following a touch and go landing the acft swerved to the left and collided with a snowbank. The plt said he reached for the carburetor heat control and flap handle as the acft swerved. After the collision the acft nosed over.NTSB NYC84FA078Accident · No injuriesField investigationFinal reportDassault Falcon 10 · Trenton, NJDistracted by an interruption in taxi and departure routines, the pilot reset his altitude alert controller to two hundred feet instead of two thousand feet, his ammended clearance altitude. Taking off on instruments in the dense morning fog, the alert system…NTSB LAX84LA160Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Santa Nella, CADuring a low level ag turn, the acft's left wing impacted an 8-FT high stand pipe. The acft then cartwheeled & crashed. A few weeks before the accident, the plt had personally inspected the field. However, just days before the accident, the standpipe had been…NTSB FTW84LA123Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Huntsville, TXThe plt had flown the acft with students earlier in the day, & it was his habit to fly the acft around the pattern once at the end of the day prior to securing it in the hangar. Shortly after lift-off the acft crashed on the rwy. Evidence found in the rear…NTSB DEN84LA078Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Billings, MTThe plt stated that during takeoff a gust of wind blew the acft to the right and he decided to abort the takeoff. Duringthe abort the acft departed the rwy, went down a bank and came to rest upside down.