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 SEA84IA233Incident · No injuriesIncident investigationFinal reportBoeing 747-200B · Seattle, WADuring climbout, passing thru 4000 ft MSL, the acft experienced a failure of the #2 engine. The crew reported hearing an explosive sound followed by a drop in fuel flow with N1 speed decreasing to 30% RPM on the #2 engine. The acft returned to Seattle for an…NTSB NYC84LA322Accident · Minor injuriesLimited investigationFinal reportGulfstream 112 · West Hampton, NYThe acft collided with the ground following a loss of control during the landing flare. As the student plt began the flare, the acft veered to the left and contacted the ground despite the application of right rudder.NTSB MIA84LA264Accident · Minor injuriesLimited investigationFinal reportCessna 152 · La Belle, FLThe student plt was making a go-around because of a wind gust and said he added 'some power' and retracted the flaps butthe acft continued to drift left until it collided with the trees to the left of the rwy at about midfield.NTSB LAX84LA501Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Borrego Springs, CAAfter landing, the plt hover taxied to the fuel pumps to refuel. While maneuvering to touch down at the pumps, the main rotor blade struck a 10 to 12 ft high vent pipe. The plt reported that the vent pipes were painted black & were not readily apparent with…NTSB LAX84LA500Accident · No injuriesLimited investigationFinal reportPiper PA-60 · San Diego, CAThe takeoff rwy had arresting gear installed 1,900 ft from the threshold. In an effort to avoid rolling over the arresting gear cable during the takeoff roll the plt elected to utilize the overrun area for the initiation of the roll. As the acft taxied from…NTSB FTW84IA412Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6-300 · Houston, TXDuring a landing on rwy 14R, the acft veered off the left side of the rwy, hit a rwy sign & was damaged. At the same time the DHC-6 was approaching to land, a Boeing 727 was also in the traffic pattern to land on rwy 14L. According to tower personnel, the…NTSB DEN84FTM04Accident · 1 fatalFinal reportRolladen-Schneider LS3 · Brigham City, UTThe acft impacted on a mountain ridge during a 60 deg left bank. The plt had been in radio communication with another glider plt near his flt area. Just prior to the accident he radioed that he was going around a mountain point in search of a thermal. When no…NTSB CHI84LA409Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIAccording to the CFI the glider was at about 500 ft AGL on base leg when a downdraft caused the acft to descend and touch down 50 ft short of the rwy.NTSB CHI84LA388Accident · No injuriesLimited investigationFinal reportAvian Balloon AX8 · Canton, OHPlt and passenger (student balloon pilot) elected a precautionary landing in an open field rather than overfly densely populated area and power lines, on touchdown, wind lifted balloon slightly and caused drift. As student plt was operating envelope vent, she…NTSB ANC84LA193Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKPlt was returning to departure point because of poor wx and darkness. During apch plt could not clearly see landing area. Attempted go-around. Plt stated acft settled into bushes and was yawed into trees because he let too much airspeed bleed off.NTSB SEA84LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Darrington, WAThe acft went off the rwys end into a tree stump and brush during landing. The plt said he landed with excess speed and was unable to stop. The plt recommended that a go-around should have been performed.NTSB MKC84FA285Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Wilmot, ARWitnesses stated, acft was seen circling over farmland and during the third circle it descended toward a brick house. The acft was seen to pull-up at which time it contacted the top of a sycamore tree in a left bank. The acft continued an additional 230 ft…NTSB MIA84LA263Accident · No injuriesLimited investigationFinal reportCessna 421 · Naples, FLDuring climbout on this FAA check ride the acft experienced a nose gear extension-retraction malfunction of unknown origin. The plt was unable to extend the nose gear for landing. According to the FAA examiner on the flt, the PIC shut down both engines on…NTSB MIA84FA265Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Bryceville, FLFlt departed in instrument meteorological conditions. After departure plt failed to maintain assigned headings several times and had to be corrected by ATC. After 15 mins of flight the plt reported he was having problems with the right engine and would like…NTSB LAX84LA499Accident · 1 fatalLimited investigationFinal reportGrumman American AA1C · Molokai, HIThe student plt was on the last leg of his 1st x-country flt from honolulu, HI, to lanai, HI, to Molokai, HI, & return to honolulu. He departed Molokai at 1304 HST & at 1311, he reported abeam laau point. About 5 min later, the plt reported that he was 15 to…NTSB LAX84LA471Accident · No injuriesLimited investigationFinal reportCessna 172N · Stockton, CAAccording to the pilot at 50 KTS rotation was attempted but unsuccessful. At 70 KTS the takeoff abort was initiated by reducing power. At that time the acft 'jumped' into the air at about a 45 degree nose up attitude. The pilot the pushed the yoke forward and…NTSB DEN84FA303Accident · 1 fatalField investigationFinal reportPiper PA-31-310 · Paonia, COThe acft was flying at a very low alt over mountanous terrain. As the acft approached a crest of a ridge the acft started to buffet and then encountered a downslope wind condition. The combination of approaching a stall and encountering a downdraft forced the…NTSB ANC84FA192Accident · No injuriesField investigationFinal reportCessna 305A · Anchorage, AKDuring the rollout the tail wheel began to shimmy and the acft swerved to the right and ground looped. The left wing and left horizontal stabilizer contacted the ground. Investigation revealed that the tail wheel spring ass'y was oversized and not properly…NTSB SEA84LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Boulder City, NVPlt executed a forced landing in a field following a loss of power during initial takeoff climb. Post accidnet investigation revealed a large quantity of water in the fuel system. The acft had been parked at an arpt with 1/2 full fuel tanks. The tie down area…NTSB NYC84LA324Accident · No injuriesLimited investigationFinal reportCessna 140 · Harrisburg, PAAcft was landed downwind in light wind conditions by student plt. On roll-out, after normal braking was applied for deceleration, acft began to drift right. Student applied left brake as CFI also applied corrective left brake. Left brake connecting rod failed…NTSB MIA84LA266Accident · No injuriesLimited investigationFinal reportCessna 210N · Orlando, FLAfter encountering mod turbulence and strong winds on final approach, with reported surface winds of 25 KTS gusting to 34 KTS, the plt elected to continue landing. During flare, gusting winds exceeded acft performance capability. Plt attempted go-around but…NTSB MIA84LA262Accident · No injuriesLimited investigationFinal reportThomas Pitts Special S1-SP · Niceville, FLDue to failure of the engine throttle linkage the engine decelerated to idle power. The plt elected to perform a forced landing in a bayou.NTSB LAX84FA498Accident · Minor injuriesField investigationFinal reportCessna 172Q · Prescott, AZDuring a descent to the 5,042 ft elevation arpt the acft impacted the trees and mountainous terrain at the 7,000 ft level. According to the pilot, with the hooded student pilot at the controls, the flight began it's descent from 10,500 ft 30 miles from the…NTSB CHI84LA407Accident · No injuriesLimited investigationFinal reportCessna 150M · Clio, MIThe airport consists of three sod strips none of which contains rwy lights. The CFI and student departed the arpt for a local night flight. The CFI stated that upon returning to the arpt he called the arpt office on the UNICOM freq and requested the night…NTSB ANC84FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-12 · Anchorage, AKThe acft departed on 9-27-84 and was reported missing the following day. USAF rcc conducted 140 unsuccessful search missions. No wreckage was ever discovered. Both occupants are presumed to have been fatally injured.NTSB SEA84LA232Accident · No injuriesLimited investigationFinal reportGlasair None · Burns, ORDuring the takeoff ground run the aircraft drifted to right side of the rwy. Plt attempted to correct the drift using left rudder and he stated that he over corrected for the drift and the acft began to veer to the left. The acft veered left and departed the…NTSB MIA84LA260Accident · No injuriesLimited investigationFinal reportCessna C-152 · Little S.Simons, GAThe acft struck a washed-out area during a beach landing at night and was destroyed when it flipped over into the ocean. Investigation revealed that the plt was bringing a mechanic/plt to this part of the beach in an effort to repair another acft that had…NTSB FTW84LA414Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Delta 105While in cruise flt, total pwr loss was experienced. Plt setup autorotative water landing, deployed emergency floats. Right float was not fully inflated by water touchdown, acft rolled right to inverted position. Eng teardown revealed carbon buildup between…NTSB FTW84LA402Accident · Serious injuriesLimited investigationFinal reportCessna T210N · San Augustine, TXThe pilot made a forced landing in a field while on a IFR flight after his engine failed. The aircraft landed short of the selected touchdown point, impacted trees and experienced a hard landing. It then caught fire and burned. Subsequent engine examination…NTSB FTW84FA408Accident · 2 fatalField investigationFinal reportCessna 172P · Webbers Falls, OKAcft struck electrical transmission line 80' above water while flying under the line during a wildlife survey. The acft's mission was to conduct a duck count along a river in a nat'l wildlife refuge which required low, slow maneuvering. The ex-ag pilot was…NTSB DEN84LA302Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Corona, NMAt 0809 hrs, plt obtained telephone weather briefing & was advised VFR flt not recommended for intended route. At 1310 hrs, plt obtained second briefing, VFR flight again not recommended, no improvement expected prior to noon of following day. At 1428 hrs plt…NTSB DEN84LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kiowa, COWhile practicing a simulated engine failure the student plt inavertantly shut off the fuel. During the actual forced landing in a rough field, the acft contacted a yucca plant and a gear collapse resulted. The CFI later reported the spring loaded safty stop…NTSB ATL84FA298Accident · 1 fatalField investigationFinal reportBeech V35B · Mc Cormick, SCN6740Z, a Beech V35B acft,separated in flt over mccormick, SC while operating in VFR conditions. The investigation failed to locate witnesses who observed the flt prior to & during the inflight separation. Witnesses on the ground heard the acft & observed…NTSB ATL84FA297Accident · 2 fatalField investigationFinal reportBell 206B · Kernersville, NCWhile dismantling a water tower, an iron worker was seriously injured & pinned as he was removing a portion of a water tower leg (aprx 92 ft AGL). The helicopter plt responded to the emergency. The acft was equipped with a make-shift sling line to retrieve…NTSB NYC84LA323Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hazleton, PAAcft departed with full fuel and passenger load near max gross weight, toward rising terrain. After reaching about 400 ft AGL, plt felt acft was losing climb performance, although no signs of power decrease were noted. Acft seemed to be settling. Plt noted…NTSB LAX84LA495Accident · No injuriesLimited investigationFinal reportSchweizer G164 · Tulare, CAThe aircraft had a full load of fuel and chemicals on board for this takeoff. The pilot stated that the brakes locked on the takeoff ground run and reduced the aircrafts acceleration. A railroad cross tie barrier at the end of the runway made an on ground…NTSB LAX84LA494Accident · Serious injuriesLimited investigationFinal reportHiller UH12ET · Yuma, AZThe pilot stated that he was carrying a load of pesticide for application on a broccoli field. The aircraft was in level flight, approximately 4 to 8 feet AGL when it became uncontrollable and impacted the ground. The aircraft was consumed by a post crash…NTSB DEN84LA299Accident · No injuriesLimited investigationFinal reportCessna T207A · Mexican Hat, UTPlt stated after accident that while on final approach with eng pwr reduced for landing, the acft began to descend below the desired glidepath. When the throttle was advanced there was no added thrust. An in-flight restart was unsuccesful. The acft landed…NTSB ATL84FLT15Accident · No injuriesFinal reportPiper PA-28-181 · Jackson, TNDuring a go-around, the engine lost all power. The pilot was able to land on the rwy. The acft went off the end of the rwy, went through a ditch, struck a fence and came to rest on an adjacent road. Examination disclosed no fuel in the left tank. The right…NTSB NYC84LA321Accident · No injuriesLimited investigationFinal reportBeech 58F · Titusville, PAPlt stated that during final approach with a right quartering crosswind, the acft passed an opening in the trees to the right (former intersecting runway) and the sudden increase in crosswind component caused the acft to drift left. Plt stated he elected to…NTSB MKC84LA284Accident · No injuriesLimited investigationFinal reportCessna 150 · Campbell, MOPlt stated that the acft was low on final apch and full pwr was added to go-around. The acft continued to settle until it contacted the rwy. The acft traveled off the left side of the rwy. After continuing through grass the acft contacted a steel angle iron…NTSB MIA84LA261Accident · No injuriesLimited investigationFinal reportCessna 172 · Miami, FLPlt stated, the acft was lifted off prematurely in ground effect on takeoff. When the acft reached tree top level a gust of wind caused the acft to drift to the right of the rwy where the right wing contacted trees. The acft spun 180 deg in heading before…NTSB MIA84LA259Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bimini, BahamasThe plt reported that he had been airborne for about 30 min when eng missed one time and stopped running. He attempted to switch fuel tanks but the selector only went to the off position and stuck. The plt ditched about 20 mi nw of Bimini island.NTSB LAX84LA496Accident · No injuriesLimited investigationFinal reportCessna 180K · Salinas, CAThe plt stated that he landed on rwy 26 and after the acft slowed down to aprx 15 to 20 KTS, a gust of wind lifted the rt wing and the acft veered to the rt. The plt was unable to maintain directional control and the acft ground looped collapsing the left…NTSB LAX84LA493Accident · No injuriesLimited investigationFinal reportCessna 180 · Camarillo, CAThe pilot reported that he was unfamiliar with the acft. He discovered that the right main tire was deflated during his landing roll and he over controlled the acft while compensating. The acft ground looped to the left and nosed over.NTSB CHI84IA404Incident · No injuriesIncident investigationFinal reportBeech A36TC · Lafayette, INThe plt reported that when he leveled off at 3000 ft MSL, the aux fuel boost switch was still on, so he switched it 'off.' When the switch was turned off, the eng began to run with a bit of vibration, so he returned the switch to 'on' & left it in that…NTSB CHI84FA402Accident · Serious injuriesField investigationFinal reportCessna 152 · Wheeling, ILWitnesses stated that the acft began to climb before it banked to the left and entered a nose down attitude. The student pilot's instructor stated that he was aware that the flt was to have taken place that evening but he did not discuss with the student…NTSB ATL84MA296Accident · Serious injuriesMajor investigationFinal reportPiper PA-31T3 · Atlanta, GAThe normal fuel load for the flt was 1500 lbs, but with a forecast tail wind & an estimated flt time for only 1+10, the crew accepted the lower indctd (950 lb) fuel load. The flt was uneventful until an indctn of 250 lbs per side, then the fuel 'seemed to…NTSB ATL84LA295Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Bluefield, WVThe pilot stated that he hovered the helicopter, made a right pedal turn and initiated a hover taxi across a rocky ravine adjacent to the pad. When over the ravine the helicopter settled onto to boulders beneath it. The pilot also stated that he thought he…NTSB ATL84LA293Accident · No injuriesLimited investigationFinal reportGrumman AA5-B · Luka, MSDuring normal cruise flight the number one cylinder exhaust valve head separated from the valve stem causing a significant power loss. The pilot set up a landing approach to a farm field. On final approach the pilot noticed that rough and rising terrain…