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 DEN84FA030Accident · 2 fatalField investigationFinal reportCessna 414 · Aurora, CODuring wx briefings the plt was advised of icing conditions in the denver area. While approaching the denver area the plt radioed 'can you get me down, it's a little bit icy up here.' The plt was subsequently asked & was given a close turn onto the outer…NTSB ATL84LA048Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Clemson, SCThe pilot failed to lower the landing gear stating that he was distracted by an acft on the ground & diverted his attention from the landing checklist.NTSB ATL84FIA01Accident · No injuriesFinal reportCessna 150K · Newburg, MDThe plt reported that during takeoff at aprx 200 ft AGL, the eng began to sputter & run rough. He elected to make a 180 deg turn in an attempt to reach a clear area. However, the acft struck a tree & impacted in a wooded area. Reportedly, the acft had been…NTSB NYC84LA036Accident · No injuriesLimited investigationFinal reportCessna 172 · Ft. Plain, NYThe flt departed bedford, ma at about 1300. Upon arriving in the area of the destination arpt, the plt had difficulty inlocating the arpt. After seeing what he thought was a wind sock, he landed in a farmer's field. He was told that this was the original…NTSB MIA84LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe plt of the C-172 stated that as he entered the landing pattern he observed another company C-172 making landings & took an appropriate interval behind the observed traffic. The plt of the C-152 stated he made his approach behind an acft he observed in the…NTSB FTW84MA069Accident · 4 fatalMajor investigationFinal reportCessna 210N · El Paso, TXN4742P departed El Paso, TX, on an IFR flight plan with a clearance to climb to 10,000 feet. No climb restrictions were included in the clearance. Departure control service was provided by albuquerque ARTCC since El Paso tower had shut downfor the night. The…NTSB FTW84FA068Accident · 1 fatalField investigationFinal reportMooney M20J · El Paso, TXThe acft collided with the ground at 4380 ft MSL. The plt had called the control tower in El Paso and advised that he was at 8500 ft and would have to start descending due to weather in the area. The plt was VFR and no flt plan had been filed. He was advised…NTSB CHI84FAMS1Accident · 1 fatalMissing aircraftFinal reportMooney M20C · Near Green Bay, WIAfter a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further…NTSB NYC84LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Farmingdale, NYWind was gusting 40 KTS with a reported low level windshear. The plt stated his approach speed was fast & he possibly did not flare enough on landing. The acft landed hard & porpoised. On the third bounce a strong gust of crosswind from the left was…NTSB MKC84FA029Accident · Serious injuriesField investigationFinal reportAerospatiale AS350D · Sweet Springs, MOThe helicopter landed hard during a forced landing after a power loss during a ferry flt. The plt stated that at about 200 ft turning on a base leg for landing he heard a loud bang and the engine failed. A witness said he heard the engine die and saw the…NTSB LAX84FA068Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Wikieup, AZBefore taking off, the plt obtained 2 wx briefings & was advised that VFR flt was not recommended. He departed at 1730. Several requests were made for en route wx from las vegas flt watch. At 1945, the plt declared an emergency & indicated that he was lost.…NTSB FTW84LA070Accident · No injuriesLimited investigationFinal reportPiper PA28RT-201T · Cameron, TXThe acft collided with trees during a forced landing after engine failure. During post accident examination the clamp which secures the turbocharger inlet tube to the engine exhaust was found to be off the threads of the bolt and were not damaged and the nut…NTSB FTW84LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Okmulgee, OKAccording to the plt, the eng was not producing sufficient power to maintain alt in normal cruise. Also, he reported that 'extra power' was required on final apch for landing at the destination arpt. He further stated that he was unable 'to cut power to idle'…NTSB DEN84LA028Accident · No injuriesLimited investigationFinal reportCessna 170B · Kalispell, MTThe acft landed hard just short of the rwy after the plt exprienced icing problems in flt. The airspeed indicator stopped working in flt so the plt was attempting a landing and says he also lost engine power at about 30 ft in the air during the flare for…NTSB NYC84FA033Accident · 6 fatalField investigationFinal reportAero Commander 500B · Franklin, PABefore departing youngstown, OH, the plt filed 2 IFR flt plans, 1 for a flt to plattsburgh, NY, the other for a return flt from plattsburgh back to youngstown. After a 2 hr & 10 min flt to plattsburgh, 70 gal of fuel was added, but the person who serviced the…NTSB MIA84LA035Accident · 1 fatalLimited investigationFinal reportCessna 340A · Nr. Orangeville, FLThe acft disappeared fm radar coverage while in cruise flt at 10,000 feet MSL near Orangeville, FL. The ATC transcript revealed that the plt had been inquiring abt the weather ahead of him and was cleared to descend to 6000 in order to get below strong…NTSB LAX84FA064Accident · 1 fatalField investigationFinal reportCessna 210 · Grass Valley, CADuring arrival, the plt was cleared for a vor-a apch to the Nevada county arpt. The apch controller advised the plt that he had failed to issue the required radar info for the final apch fix & instructed the plt to initiate a missed apch. Radar contact with…NTSB FTW84LA071Accident · No injuriesLimited investigationFinal reportde Havilland DHC-1 · Orange, TXAccording to the plt, the eng lost power as he made a throttle adjustment in the traffic pattern while turning from downwind to base. Subsequently, he allowed the acft to stall & land hard. Short of the rwy. The origin of the malfunction was not identified.NTSB DEN84FA027Accident · 4 fatalField investigationFinal reportGrumman American AA-5B · Boulder, COAccording to witnesses, the plt had made 3 attempts to land & during each attempt he overshot his approach & executed a go-around without touching down. On the fourth attempt he did touch down but appeared to be too fast & the acft skipped & bounced. After…NTSB CHI84LA048Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Norwalk, OHThe acft made a hard landing while on a cross-country flt. The plt stated that he encountered turbulence below 3000 ft MSL. During the he encountered wind shear which caused him to drop 40 ft onto the rwy. The acft manual states that 'in high wind conditions…NTSB SEA84LA026Accident · No injuriesLimited investigationFinal reportHelio H-391B · Hood River, ORAccording to FAA inspectors, the plt made a hi speed turnoff onto a taxiway after landing & ground looped the acft. The plt stated that the right brake failed, the acft rolled off the rwy into mud & the plane spun 270 deg to the left. However, the right brake…NTSB NYC84LA044Accident · No injuriesLimited investigationFinal reportCessna 177 · Bayport, NYThe acft dragged a wing tip after encountered a gusty crosswind and aborted his takeoff. According to the plt, as the acft became airborne it seemed to be pushed down and he initiated a landing. The takeoff was aborted by reducing power and the acft touched…NTSB NYC84LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Shirley, NYThe acft collided with the ground during an aborted go-around. This was a supervised solo flt for practice touch and go landings. During the 1st landing attempt the plt flared too high and decided to go-around. Full power was added and as the pilot moved her…NTSB MIA84FA032Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Near Naples, FLThe plt, along with his safety plt, departed page field at 1401 to accomplish airwork. 1 min later the crew was questioned by the tower why they had not started a turn southbound. The safety plt responded 'I just pulled an engine onhim and he is going to…NTSB LAX84LA066Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Peach Springs, AZReportedly, the wind was variable & gusty when the acft took off from the hualapai arpt, Peach Springs, AZ. The plt reported that after rotating for takeoff, the acft moved laterally to the left, and as he was correcting for the movement, the left main gear…NTSB FTW84LA066Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Addison, TXThe plt reported that during an ILS apch to land, the eng lost power when the acft was about 1/4 mi from the threshold. He stated that he 'confirmed mixture rich, carb heat on, fuel pump on, fuel fullest tank.' The plt was unable to restart the eng. During an…NTSB FTW84LA065Accident · No injuriesLimited investigationFinal reportCessna 150G · Mcallen, TXThe acft groundlooped during landing and collided with a ditch. This acft had been converted to conventional landing gear. The plt had only 1 hour as PIC in this configuration of landing gear equipment.NTSB DEN84LA029Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Colorado Spgs, COThe Piper PA-18, N3594P, was being used to tow a burkhart grob flugzeugbau G103 twin astir, N4246L. At 0950 MST, the wind was reported from 310 deg at 9 KTS. Since the terrain sloped downhill to the south, rwy 17R (covered with hard packed snow) was being…NTSB CHI84FA049Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Dexter, MIAt 2135 EST, the plt called the lansing fss & requested a wx forcast for the detroit city arpt & winds aloft. He was briefed, but he did not file a flt plan, sometime after 2200 EST, he took off form mason, MI on a passenger flt to ann arbor, MI. At 2252, the…NTSB ANC84LA018Accident · No injuriesLimited investigationFinal reportCessna C-180 · Big Lake, AKAccording to the plt, the acft encountered an overflow while landing and nosed over. He stated his ground speed had almost decreased enough to maneuver when he encountered the overflow, which is water between the ice and snow on top.NTSB SEA84LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Oregon City, ORThe plt, who was an a & p mechanic, had just installed an eng that had been overhauled by someone else. He reported that the pretakeoff & run-up checks were normal. At aprx 250 to 300 ft AGL, during takeoff, the eng began to shake violently & lost power. The…NTSB NYC84LA031Accident · No injuriesLimited investigationFinal reportBeech B23 · West Dover, VTThe plt reported that during descent, below 4000 ft, he encounter severe turbulence. He reported that the destination wind was from the northwest, but he could not recall the wind velocity. During arrival, final apch to rwy 01 was flown at 80 mph while still…NTSB NYC84FA032Accident · 2 fatalField investigationFinal reportBeech K35 · Stockholm, NJAt 1455 EST, a Beech K35 (bonanza), N106Q, & a Piper PA-34-200, N56670, collided while the acft were flying over the vicinity of the sparta VORTAC. The bonanza plt was on a local flt while the PA-34 was on multi-eng training flt. The student in the PA-34…NTSB MKC84LA028Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Kearney, NEDuring the landing roll, the plt held the nosewheel off while slowing down, and used right rudder to compensate for a reported x-wind condition. As soon as the nosewheel touched down, the acft veered to the right. It went off the right side of the rwy, the…NTSB LAX84LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe plt, who was on his fist solo stated he 'started to flare out bit high, bounced a few times, lost directional control and went off runway 30, to the right. The acft went up on its right wing, then back down, and came to rest upright.'NTSB FTW84LA073Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Walters, OKThe plt & safety plt had made two simulated instrument approaches at duncan,OK &a low VFR pass at Walters which was to terminate with a circling approach & landing. The acft stalled during the pull-up from the low pass.NTSB FTW84FA064Accident · 3 fatalField investigationFinal reportCessna T210N · Nageezi, NMBefore takeoff, the plt was informed of a segmet which forcasted occasional severe rime or mixed icing from the freezing level at 8000 ft up thru 20,000 ft & moderate to severe turbulence below 18,000 ft. also, embedded thunderstorms, lightning & thunder were…NTSB CHI84LA047Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Columbus, OHThe plt stated that during the preflt, he visually checked the fuel & estemated that the left tank was aprx 1/4 full & the right tank was about 1/2 full. He made his pretakeoff checks, but stayed on the ground longer than normal to allow the oil to warm up.…NTSB CHI84LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Northfield, MNThe plt stated that while enroute at an alt of 3000 ft MSL the eng failed. He also stated that all attempts to restart the eng failed so he proceeded to make an emergency landing. Investigation revealed a manufacturing defect in the left magneto; the body…NTSB CHI84LA045Accident · Minor injuriesLimited investigationFinal reportMooney M-20K · Buffalo, MNThe acft collided with trees during an approach on a dark night. The weather was VMC and the plt canceled his IFR flt plan 15 miles east of the arpt. The plt approached the arpt in a normal VFR pattern but on final approach he got an illusion from the lights…NTSB ATL84LA046Accident · No injuriesLimited investigationFinal reportBell 47-G · Middle River, MDWhile practicing hovering about 2 ft AGL the student allowed the helicoper to start drifting aft & right. The right skid heel contacted the ground & the helicopter roll onto its right side.NTSB NYC84LA030Accident · No injuriesLimited investigationFinal reportBeech B23 · Pittstown, NJDuring first landing the flt encountered windshear. The student did not make proper correction so the CFI took control &landed the acft. Prior to performing another takeoff & landing, the problem of windshear & what proper action to take was discussed. During…NTSB MKC84LA027Accident · No injuriesLimited investigationFinal reportBeech BE77 · Des Moines, IAThe acft landed on the nose gear bounced and drifted off the right side of the rwy. During the 2nd touchdown the nose gear collapsed and the acft nosed over. The pilot was a student engaging in some solo landing practice. The pilot said he thought he was high…NTSB MKC84LA026Accident · No injuriesLimited investigationFinal reportCessna 180A · Topeka, KSThe acft veered off the rwy into the grass and collapsed the main landing gear during takeoff. The pilots seat slid aft as the acft accelerated and the pilot lost control of the acft. The acft veered off the left side of the runway into the grass. The pilot…NTSB MIA84LA031Accident · No injuriesLimited investigationFinal reportCessna 185 · Gainesville, FLThe acft nosed over during landing while on an instructional flt. The instructor plt was demonstrating a touch and go landing at the time of the accident. The landing was made on rwy 28 with the wind from 340 degrees at 7 KTS. The instructor stated that…NTSB FTW84LA061Accident · No injuriesLimited investigationFinal reportHughes 269C · Freer, TXThe plt & 2 passengers were on a flt to look for deer in a pasture area. While in a turn after the last pass over the pasture, the eng lost power at aprx 150 ft AGL. The plt initiated an autorotative landing in an area of mesquite brush & bushes. He reported…NTSB DEN84LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Yankton, SDThe plt stated the eng wouldn't start & he suspected a dead spot on the starter. He then asked a mechanic to rotate the prop. All switches were off except the battery switch. When the mechanic moved the prop the eng started & the prop struck the mechanic.…NTSB DEN84LA026Accident · No injuriesLimited investigationFinal reportCessna 177RG · Durango, COThe acft ran off the right side of the rwy and collided with rwy lights during landing. The plt said he landed on the right side because the left side was being seal coated. Proper alignment was not maintained and the acft's right landing gear dropped off the…NTSB NYC84LA043Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Morristown, NJEarlier in the evening, the plt had taken off with 3 passengers on board. Shortly after takeoff, he advised the tower that the eng was not developing full power. He remained in the traffic pattern & landed, then taxied to the ramp. Later, the plt made a 2nd…NTSB MKC84LA024Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Sargent, NEThe pilot became dioriented on a flight from hastings, NE enroute to Sargent, NE. He decided to land on a county road west of Sargent. During the landing the acft right wing tip struck a pole and the acft tipped up on its nose.