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 DCA84AA016Accident · 6 fatalFinal reportLearjet 24 · Avalon, CAThe acft departed on a sales demo flt to monterey, CA with potential buyers aboard. En route, the destination was changed to Avalon, CA. UNICOM advised the crew of the wind direction & speed on downwind. Witnesses reported the acft was slightly hi on final,…NTSB DCA84AA015Accident · 3 fatalFinal reportSwearingen SA226TC · Terre Haute, INAfter taking off from rwy 23, the acft crashed ssw of the arpt about 6300 ft from the departure end of the rwy & about 1800 ft to the left of the rwy centerline. Impact occurred while the acft was in a steep descent. The wreckage path was scattered along a…NTSB ATL84LA089Accident · Minor injuriesLimited investigationFinal reportBach CGS Hawk · Newton, NCReportedly, the eng of the registered ultralight acft lost power in flt & the student plt began a forced landing however, before landing, the ultralight collided with utility wires, then it struck the ground. The plt reported that the acft had an unexpectedly…NTSB ATL84FA088Accident · 2 fatalField investigationFinal reportCessna P210N · Greensboro, NCDuring arrival, the plt was advised that the arpt wx had just changed to IFR. He was assigned an alt (2900 ft MSL) & provided a vector for an ILS apch. Shortly thereafter, the plt advised that he was 'having motor difficulty & needed to come straight-in.' He…NTSB SEA84LA046Accident · No injuriesLimited investigationFinal reportLark IS28B2 · Issaquqh, WAThe CFI stated that while returnsing to the airport he encountered turbulence. When it became obvious that reaching the intended airport would be marginal another landing field was chosen. During turn to final, the left wing tip struck a power pole and the…NTSB NYC84LA080Accident · No injuriesLimited investigationFinal reportCessna 172RG · Marietta, PAThe acft struck a snowbank during a night landing. The CFI stated everything was normal until flareout when the acft began to settle. After striking the snowbank the acft nosed over.NTSB NYC84LA079Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Philadelphia, PAThe plt broke out of the overcast at 1000 ft lowered flaps and landed the acft with the gear retracted. The plt said he had lowered the gear. The gear warning horn reportedly did not sound.NTSB NYC84FA085Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Templeton, MAThe acft collided with trees on unlgtd terrain at ngt after making a low pass at aprx 60 ft AGL with the gear extended. Witnesses reported that the acft's clearance lights were not operating until the rwy lights were turned on, then they observed the acft's…NTSB LAX84LA158Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Coalinga, CAWhile cruising at 8,500 ft MSL,the plt noticed a loss of all oil pressure. He secured the eng, lowered the landing gear & wing flaps, & declared an emergency stating he would attempt an eng out landing at harris ranch arpt. While descendingthrough 1,000 ft…NTSB CHI84LA097Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Faribault, MNThe acft landed in a snow covered field following a partial power loss. The plt stated that he performed a preflight which included checking the fuel for contamination. Post accident investigation revealed water in the gascolator and icein the fuel lines near…NTSB NYC84LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Akron, NYThe acft lost power during takeoff and landed off arpt in the snow collapsing the nose gear. Weather conditions were conductive to carburetor icing and the abnormally long taxi and ground time added to the potential hazard.NTSB MKC84LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft ran off the rwy during landing and collided with a pile of debris, collapsing the landing gear.NTSB MKC84LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Jasper, ARThe plt landed the acft on private property to visit relatives. During the landing the acft groundlooped and collapsed the left main landing gear. The plt reported that the winds were from 290 degrees at 18 KTS and gusty. Rugged terrain surrounded the area of…NTSB LAX84LA172Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Camarillo, CAAccording to witnesses, the plt had been drinking & decided to prove to his friends that he could fly a helicopter. Reportedly, he 'threw on a bunch of switches, and got the engine started.' When he attempted the takeoff, the helicopter rolled over on its…NTSB LAX84LA161Accident · No injuriesLimited investigationFinal reportCessna 401A · San Francisco, CAThe acft was landed gear up after attempts to lower the gear were unsuccessful. The system malfunctioned because the nose gear jammed the main gear during retraction. The jamming occurred because the nose strut did not extend due to lackof air pressure. The…NTSB DEN84LA077Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Erie, COThis acft had not had an annual inspection in more than 13 years and had not been flown in 8 years. During the accident flt the acft engine quit after 25 minutes of flt. After the forced landing a mechanic found the carburetor bowl dry and the fuel line vent…NTSB DEN84FA076Accident · 2 fatalField investigationFinal reportBeech A36 · Columbus, NMThe plt took off at night in the company of plts flying 2 other acft, a Cessna 150 & a Piper PA-22. N719K, a Beech A36 bonanza, was flying ahead of the other 2 acft. The plt of 1 of the other acft stated that the bonanza plt would usually fly at a slower…NTSB CHI84LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit Lakes, MNThe acft collided with a snow embankment 15 to 20 ft short of the rwy on final approach. The acft got low and slow on final according to the instructor and he became concerned about a hard landing. As he advanced the throttle the acft hitthe embankment. The…NTSB CHI84LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIDuring a cross wind landing the acft veered left, collided with a snowbank and nosed over. The winds were gusting to 20 knots.NTSB ATL84FIJ01Accident · No injuriesFinal reportCessna 150J · Elizabeth, WVThe plt reported that he departed steubenville, oh for welch, WV, to pick up a passenger and continue to parkersburg, WV. He stated that he departed steubenville with full fuel tanks and cruised at an alt of 7500 MSL. He began an enroute descent and as the…NTSB SEA84LA047Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Imnaha, ORThe acft nosed over during a forced landing on a snow covered field. The plt reported that the acft began to lose power at about 6500 ft MSL. An inspection of the eng did not reveal any mechanical malfunction or discrepancy.NTSB SEA84LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Burley, IDThe plt stated the engine lost power because of fuel exhaustion. A forced landing was performed in a field during which the acft contacted a ditch. The acft was flown 4.1 hrs since it had last been refueled.NTSB NYC84LA076Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nashua, NHThe helicopter left skid hooked on the guard rail as takeoff began from a trailer. As the plt continued to increase power to lift, the acft rolled over and the main rotor hit the hood of the tractor.NTSB NYC84LA075Accident · No injuriesLimited investigationFinal reportCessna 150E · Brewer, METhe acft was on a local pre-solo takeoff and landing practice flight. Several landings were made with the student pilot adjusting for wind conditions below a tree line. On the last landing the CFI reported that the acft moved quickly to theright and started…NTSB MIA84FA067Accident · 1 fatalField investigationFinal reportBell 206B · Stuart, FLWitnesses observed the helicopter flying at 100 to 150 ft above the water & about 100 yds offshore. They observed & heard nothing unusual, except they said the helicopter began descending until it impacted the water. The rear doors had been removed for the…NTSB FTW84FA122Accident · 2 fatalField investigationFinal reportBeech 77 · Fritch, TXThe acft departed on 1/27/84 and failed to return from a 2 hour local flt. Time of departure was 1330 CST. On 1/28/84, afisherman on lake meredith found an acft wheel floating in the water. This wheel was later found to have the same part numbers and paint as…NTSB DEN84LA099Accident · No injuriesLimited investigationFinal reportChampion 7EC · Wall, SDThe acft crashed during a flight for the purpose of observing the plt's cattle. The plt stated he was 'making a steep left turn at about 75 feet and the bottom (left) wing flew into a wind shear on the downward side of a hill. The airplane slid to the left…NTSB DEN84LA075Accident · No injuriesLimited investigationFinal reportHughes 369HS · Buffalo, WYThe helicopter lost power a few minutes after takeoff and made a forced landing. The acft had been refueled from a fuel truck shortly before takeoff. Samples of fuel from the acft and the fuel truck were examined and found to contain water.NTSB LAX84LA157Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Santa Ana, CAWhile taxiing after landing, a gust of wind overturned the acft. The winds were gusting to 40 KTS.NTSB LAX84LA156Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Victorville, CAThe acft landed gear up during a forced landing after the engine quit on takeoff. The plt thinks he left the fuel selector in an improper position after showing a customer the alternate location of the tip tank indicator switch.NTSB LAX84LA155Accident · Minor injuriesLimited investigationFinal reportBeech 60 · Lake Casitas, CAThe plt was told by his company to deliver the recently sold acft to its new owner. During the flt, an intermediate stopwas made, but no fuel was added because the plt believed he had enough fuel. Fuel exhaustion occurred about 20 minutes after departure.…NTSB CHI84LA096Accident · No injuriesLimited investigationFinal reportCessna 150M · West Bend, WIThe acft went out of control during the takeoff roll after a touch and go landing. The plt stated that, as he applied power and went to raise the flaps the acft began to drift to the left. When he applied right rudder the acft began to skid to the right. He…NTSB CHI84LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Greenville, ILThe plt received a weather briefing the night before the accident and did not have it updated on the day of the accident. The acft was descended below the mda during the approach in fog and collided with high tension lines.NTSB ATL84LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Snowville, VAThe acft crash landed in a pasture during a go-around attempt after a demonstration forced landing. The go-around was delayed and the terrain rose faster than the acft ascent rate. Since there was a powerline in the way the CFI elected to land the acft.NTSB ATL84IA087Incident · No injuriesIncident investigationFinal reportBritish Aerospace 1-11 · Richmond, VAFlt 498, experienced a partial power loss on one eng during the final approach. Both plts stated that the eng spool down occurred moments after selecting tcc(top temp control). A eng runup of the acft failed to repeat the discrepancy & a precautionary change…NTSB SEA84LA044Accident · No injuriesLimited investigationFinal reportCessna T21OL · Bend, ORThe plt reported that he departed boulder city, NV with 92 gal of fuel on board. About 4 hrs & 10 min later, he was forced to land when the eng lost power from fuel exhaustion. According to him, the fuel gages had been indicating normal with an indication of…NTSB NYC84FA074Accident · 3 fatalField investigationFinal reportCessna P210N · Groton, CTThe acft was blown off course during a procedure turn for an ILS approach. The plt made a missed approach because of themisalignment and tried a non standard means of orientation for the 2nd attempt and intercepted the middle marker unexpectedly. Radar shows…NTSB MKC84LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kennett, MOThe acft crashed in IMC weather after the engine lost power due to fuel exhaustion. The plt had received a briefing on the weather prior to departure. Post accident investigation revealed less than 2 gallons of fuel remained aboard the acft.NTSB FTW84LA119Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Cedar Hill, TXPurpose of the flt was to check for oil leaks after maintenance was performed. Shortly after takeoff, at an alt of 50 to 100 ft AGL, the plt noticed a '2 per rev vibration' and decided to land in a field. When aprx 5 ft AGL the plt felt what he described as a…NTSB DEN84LA074Accident · No injuriesLimited investigationFinal reportCessna 210D · Englewood, COThe acft was landed with the main gear retracted after attempts to extend them failed. After landing the acft departed the right side of the rwy. Post accident examination revealed that the secondary relief valve had failed in the hydraulic power pack. This…NTSB ATL84FLT02Accident · Serious injuriesFinal reportPiper PA-22-150 · Memphis, TNThe acft struck a powerline and crashed 1.5 mi south of Memphis airport while on a ILS localizer app to rwy 36R. The wx at the time of acc was ceiling 200 ft, visibility 3/4 mile with fog. The acft was equipped with a VOR localizer, but no glide sloop…NTSB MKC84LA064Accident · No injuriesLimited investigationFinal reportMitsubishi MU 2B-20 · Ames, IAThe acft landed in a crosswind on a snow and ice covered rwy. During landing, directional control was lost and the acft collided with a snowbank. The plt stated he attempted to use propeller reversing for braking and the acft started to slide to the left.NTSB MIA84LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Plymouth, FLThe acft was landed hard at higher than normal airspeed. The plt stated that he came in'too high and too fast'and when he landed he'broke the nose wheel'. Investigation revealed that the plt did not possess any aeronautical certificates or ratings. He had…NTSB LAX84LA159Accident · No injuriesLimited investigationFinal reportBeech D55 · Monterey, CAAccording to the plt, he extended the gear & flaps before landing, & on final apch, he rechecked that the gear was down & the green gear down & locked light was illuminated. He & both passengers reported that the acft touched down on the wheels, then it…NTSB LAX84LA154Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Healdsburg, CAThe plt reported that a gust of wind pushed up the left wing & the acft veered off the rwy. The acft then went down a shallow grade & impacted bushes. He reported the wind was from 330 deg at 10 gusting 18 KTS.NTSB FTW84LA118Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Venice, LAAbout 10 min after departing an offshore platform, the plt encountered an area of fog. He descended to aprx 200 ft, slowed to 40 KTS & started turning back. As he was turning, he was looking to the right to locate a petroleum production facility to use as a…NTSB CHI84LA095Accident · No injuriesLimited investigationFinal reportCessna C-172P · Macomb, ILThe acft swerved off the rwy into a ditch during a crosswind landing. The wind was from 180 degrees at 10 KTS. The plt said that he lost directional control of the acft because of the wind.NTSB CHI84IA093Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-61 · Chicago, ILAs the capt applied power & released brakes to begin the takeoff, the acft started to drift to the right. The capt stated that he closed the throttles & put the #1 & #2 throttles in reverse. The acft then began to veer left & spun around nearly 1-1/2 times.…NTSB ANC84LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Anchorage, AKThe plt stated that just prior to the eng failure, the left fuel tank 'was empty' and the right tank contained approximately 1/8 of a tank of fuel. The plt suspected fuel starvation.NTSB MIA84LA065Accident · No injuriesLimited investigationFinal reportBeech 58 · Ft.Myers, FLThe acft was rolling on the rwy after a smooth landing when the left tire blew out and the left landing gear collapsed. The acft swerved to the left into the wind and slid off the left side of the rwy. According to the plt, the wind was from 090 deg at 18…