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 ATL84LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Mountain, ALWhile en route, the plt arrived at a check point 18 min behind schedule. Aprx 25 min later, he tuned in an incorrect VOR frequency that he had written down on his flt plan. The station that he tuned in was east of the desired station & the geographic features…NTSB ANC84FAG01Accident · Minor injuriesFinal reportCessna C-185 · Naknek, AKThe acft crashed during takeoff. The plt said that during takeoff at an alt of about 10 ft AGL it felt as though the fltcontrols were not responding. The acft stalled and hit the runway. The plt suspected the controls had been tampered with, but when the acft…NTSB MIA84FA049Accident · 1 fatalField investigationFinal reportPiper PA-12 · Ft. Lauderdale, FLThe acft crashed on the arpt in a steep nose down attitude after dropping a banner it was towing. The plt waved to the ground personnel and turned in a 60 degree bank nose high turn. After 180 degrees of turn the acft stalled, the nosefell through and the…NTSB LAX84LA112Accident · 1 fatalLimited investigationFinal reportBeech H35 · Modesto, CAThe plt taxied & initiated a takeoff without obtaining a clearance. The tower controller observed the acft take off, immediately turn left, then collide with a 10 ft dirt bank, located between the parallel rwys. After hitting the dirt bank, the acft skidded…NTSB LAX84LA110Accident · No injuriesLimited investigationFinal reportCessna 180K · Santa Rosa Island, CAAccording to the plt, the nose of the acft felt heavy just before lift-off & when he became airborne. He felt something was wrong with the tail of the acft & that he was unable to obtain full elevator response, so he aborted the takeoff. The acft rolled 300…NTSB LAX84FA114Accident · 3 fatalField investigationFinal reportCessna 182E · Humbolt, NVWhile on a x-country flt in a mountainous area, the acft crashed into the side of a snow covered mountain. Impact occurred at the 8200 ft level in prince royal canyon. The canyon sloped upward to the south & terminated at an elevation of about 8900 ft. the…NTSB FTW84LA101Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Bellville, TXThe plt stated he landed 'a little long & a little fast.' The acft then drifted off the paved rwy into grass & soft terrain. The right wheel dug into the ground & the acft nosed over onto its back at the line of rwy lights.NTSB FTW84FA100Accident · 2 fatalField investigationFinal reportMooney M20F · Ada, OKThe eng lost power shortly after takeoff & the acft stalled while in a slight left turn. Examination revealed that the left wing fuel sump drain contained frozen water in the drain ports. The fuel injector screen, after thawing out, contained frozen water…NTSB DEN84LA046Accident · Serious injuriesLimited investigationFinal reportGates Learjet 25D · Eagle, COWhile en route, the aricrew encountered stronger headwinds than expected. They realized there would not be enough fuel reserved for an IFR flt to aspen, so the elected to divert to Eagle, CO. However, their landing at engle was delayed due to a snowplow (with…NTSB MKC84LA043Accident · No injuriesLimited investigationFinal reportGates Learjet 25 · Kansas City, KSDuring takeoff on a snow covered rwy at night the aircraft ran off the left side of the runway & was damaged. At that time, the rwy was covered with a thin layer of dry snow over the top of hard packed snow. A 50 ft strip had previously been plowed along the…NTSB MIA84FA048Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Vero Beach, FLShortly after takeoff from rwy 29L the eng began to lose power. A turn back to the arpt was made when the eng quit & the acft struck trees & bushes about 350 ft short of rwy 11L. Teardown of the eng & fuel injector system revealed that the injector for the #5…NTSB LAX84LA108Accident · No injuriesLimited investigationFinal reportBell 47G · El Cajon, CADuring a demonstration to show his student how to autorotate fm a 2 ft height AGL the instructor reduced pwr and inadvertently applied fwd cyclic. The front portion of the skids hit the gd followed by the main rotor blades. Helicopter then rocked backwards,…NTSB LAX84FA107Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Tehachapi, CAThe acft collided with the ground after stalling during a right climbing turn into clouds. Witnesses reported that the initial climb attitude was 'very steep'. No one observed the crash but the engine RPM 'revved up' to a very high RPM 4-5SECONDS prior to the…NTSB CHI84LA065Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Detroit, MIWhile receiving vectors for an ILS apch, the acft encountered rime icing conditions. The left windshield began icing over & would not clear when the plt adjusted the windshield heat from normal to high. Since the autopilot was engaged, he moved to the right…NTSB ATL84LA072Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Spartanburg, SCThe acft propeller struck a passenger approaching to board the acft. The plt had started the acft for warm-up prior to the boarding. The passenger stumbled approaching the acft and fell into the revolving propeller.NTSB ATL84LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Indian Head, MDThe plt stated that shortly after departing dca, he encountered a small amount of rain that froze on the aircraft's windshield. He continued on to his destination and again encounter freezing rain when turning from base to final. He elected to make a…NTSB ATL84LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waverly, KYAbout 8 mi from his destination the plt encountered freezing rain. He decided to retrieve a flashlight from his briefcase in the back seat to use in checking for ice on the wings & in consulting his charts. While leaning over the back seat, the plt lost his…NTSB MKC84LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Schuyler, NEWhile descending toward the planned destination, the eng began running rough & the plt attempted to improve the eng's performance by using carburetor heat. He made a localizer-only apch, but was unable to see the rwy at the min descent alt. A missed apch was…NTSB MKC84LA041Accident · No injuriesLimited investigationFinal reportCessna 310 · Olathe, KSThe plt was returning to Kansas city, MO with no cargo on board after delivering cancelled checks to tulsa, OK. While en route, the plt noticed a slight drop in oil pressure. About 75 mi from his destination, he noticed that the oil gage indicated below the…NTSB DEN84FA045Accident · No injuriesField investigationFinal reportConvair 440 · Rock Springs, WYCombs airways, flt 709, collided with a snow bank during the landing roll at sweetwater county aprt. The capt reported that 'immediately after touchdown, the acft veered left, struck a snow bank, then veered to the right 180 deg coming to rest on the rwy…NTSB DCA84AA012Accident · 1 fatalFinal reportDouglas DC-9-31 · Sioux Falls, SDDuring landing the crew acquired visual reference with the ground & apch lights about 200 ft AGL, followed by visual sighting of the rwy. Since the ATIS reported blowing snow, the crew expected to see, & was not surprised to see, snow blowing across the rwy…NTSB CHI84LA072Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Covington, INThe acft made a forced landing on a highway when the engine quit after less than an hour of flight time following departure. The wings were damaged during the landing. After the accident an FAA maintenance inspector opened both main tank drains and drained…NTSB ATL84LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student plt reported he picked up a slight crosswind during his descent for landing. The acft touched down on the main landing gear wings level, started to veer left & did not respond to right rudder pressure. The plt applied max braking but the acft ran…NTSB ANC84FA027Accident · Serious injuriesField investigationFinal reportCessna C-185-D · Anchorage, AKThe acft crashed shortly after takeoff following a power loss. The plt stated that smoke entered the cockpit from the heat vents. He thought the smoke was from residual oil spilled on the engine during an oil change and he pulled the engine cut off mistaking…NTSB ANC84FA026Accident · Serious injuriesField investigationFinal reportBoeing 747-200F · Anchorage, AKAt 2359 the local controller cleared the flt to land on rwy 6R. At 0001 the ground controller cleared a state-operated pick-up truck onto rwy 6R for a tapley run. The ground controller stated that he requested clearance from the local controller to allow the…NTSB NYC84LA056Accident · No injuriesLimited investigationFinal reportCessna 150M · Belfast, METhe acft lost power during takeoff and landed in the trees. The student plt was on his second solo flt. The loss of power occurred at about 700 ft. an attempt to land on an old closed rwy failed and the plt tried to go around but the engine quit completely…NTSB NYC84LA055Accident · No injuriesLimited investigationFinal reportBell 47-G3B1 · Dummerston, VTThe plt initiated a practice autorotation from about 600 ft AGL. Airspeed was about 55 KTS with low m/r RPM due to low gross weight. A moderate flare was initiated in an effort to increase rotor RPM, reducing the airspeed to 40 KTS. However, the application…NTSB MKC84IA040Incident · No injuriesIncident investigationFinal reportDouglas DC-9-15 · Wichita, KSA catastrophic (uncontainted) failure of the left engine occurred at the beginning of the takeoff roll. The takeoff was aborted & fire erupted on the taxi back to the gate. Investigation revealed a broken turbine long shaft.NTSB MIA84FA047Accident · 1 fatalField investigationFinal reportRygg Volmer VJ22 · Oldmar, FLWitnesses observed the acft flying in a northerly direction over tampa bay at a height of 25 to 50 ft above the surface. Moments before crashing, the acft made an abrupt descent & passed under a power line that spinned the northern neck of the bay.…NTSB LAX84LA135Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Mokuleia, HIThe plt was rated for airplanes & helicopters, but did not have a glider rating. He had only 2.5 hrs in gliders, all of which was in this same make & model. During a solo instructional flt, he encountered a high sink while on a base turn to land. He stated…NTSB DEN84LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Broomfield, COThe acft collided with a snow bank during landing and nosed down. This was the student's first solo landing. The studentthought the landing was all right except that the acft kept going to the left in spite of right rudder. Some power was still on the acft.…NTSB CHI84LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hayward, WIThe acft collided with a snow bank during the landing roll and nosed over. The rwy was covered with snow and was slick. The solo student plt said he landed with more airspeed than normal and the acft started to go to the left on the rwy. The plts attempted…NTSB SEA84LA027Accident · No injuriesLimited investigationFinal reportCessna 150F · Prosser, WAAccording to the pilot shortly after departure the engine began running rough for the second time. The pilot elected to make a precautionary landing on a gravel road he was familiar with. During the landing flare, with a gusty crosswind, directional control…NTSB NYC84FA058Accident · 2 fatalField investigationFinal reportBeech T-34A · Stockton, NJPrior to the accident, the acft was observed in aerobatic type maneuvers. According to one witness, he saw the acft enter a descent after it had completed a roll maneuver. It was still in a steep descent when he lost sight of the acft due to trees. The acft…NTSB NYC84FA057Accident · 1 fatalField investigationFinal reportPiper J3C-65 · North Hampton, NHThe acft stalled at about 100 ft of alt after takeoff during an instructional flt. One witness said the acft turned through 180 degrees before it collided with the ground in a nose low and right bank attitude. Another witness said he thought the acft was…NTSB MKC84LA039Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, MOThe plt took off from pleasant hill, MO to look for relatives who may have been survivors of an overturned boat. After searching a lake, he elected to land at Clinton, MO. The arpt at Clinton was closed for construction & the rwy was covered with snow & ice.…NTSB LAX84LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Livermore, CADuring arrival in IFR conditions, the plt was vectored for an ILS rwy 25 apch. At about 0909 PST, he was cleared for the apch & instructed to maintain 3000 ft until intercepting the localizer. A short time later, the controller instructed the plt to contact…NTSB CHI84LA064Accident · No injuriesLimited investigationFinal reportCessna 421 · Harbor Springs, MIThe plt stated that an overboost occurred on the right eng during the takeoff roll. He pulled off power on both engs but the acft slid off the rwy into a snowbank.NTSB CHI84LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Peoria, ILThe student plt elected to make a touch & go landing on a rwy covered with loose snow & patches of ice. He reported that when he added power during his 1st touch & go, the acft veered to the left & subsequently collided with a snowbank.NTSB CHI84FA063Accident · 1 fatalField investigationFinal reportCessna 150M · Stockwell, INThe plt had been wx briefed & filed a flight plan at the lafayette fss. About 1 hr later he returned to the fss & asked if the fss had heard him calling on 119.6. He was advised that he had not been heard. The plt stated he would try to call when airborne. On…NTSB ATL84FA068Accident · 1 fatalField investigationFinal reportCessna C-172M · Chesapeake, VAThe acrt crashed into a lake while making a low pass when the plt was distracted by a passenger door that would not stay latched. The acft collided while turning and the plt stated that he was trying to help the passenger close the door. He also stated that…NTSB MKC84LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sikeston, MOThe acft nose gear collapsed during a forced landing after engine failure. During a x-country flt the engine popped and quit. The plt approached a road to land but saw a vehicle during approach and veered off into a field. Post accident investigation revealed…NTSB LAX84FA106Accident · No injuriesField investigationFinal reportHiller UH-12A · Van Nuys, CAThe instructor plt (CFI) stated that the eng quit 2 times after he refueled the helicopter. He then drained a quantity of water from the fuel gascolator & restarted the helicopter. After that he air taxied the helicopter to the flt school where, without…NTSB FTW84LA099Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Imperial, TXThe plt reported that when he was in cruise flt at 300 ft AGL, a sudden violent shudder went thru the whole helicopter, then the shudder stopped. He noted no change in the flit characteristics or eng power. The plt elected to make a precautionary landing by…NTSB ATL84LA067Accident · No injuriesLimited investigationFinal reportCessna 182P-SYLANE · Damascus, GAThe plt, an auctioneer, had rented the acft to fly to a farm where he was to conduct an auction. Previously, he had inspected the intended landing area, a soy bean field, & thought it would be satisfactory for a landing. When he arrived & landed, the main…NTSB ANC84LA025Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe plt reported that during flt, he encountered freezing rain. Although he applied carburetor heat, the eng ceased operating. During a forced landing, the right main gear collapsed & the right outboard wing panel was damaged. The plt reported that freezing…NTSB MKC84LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Garnett, KSWhile enroute pilot was running the acft using the right main fuel tank. He switched to the left to balance the load and the engine quit about 10 seconds after being switched. The pilot could not restart the engine and a forced landing was made in a field.…NTSB MIA84LA046Accident · No injuriesLimited investigationFinal reportBeech 35 · Lake City, FLThe plt landed with the nose gear partially extended. The plt reported that he heard a crack while the landing gear was retracting after takeoff. He put the gear handle back down and continued to Lake City. After flying several low passes, the control tower…NTSB DEN84FA042Accident · Serious injuriesField investigationFinal reportMooney M20J · Bismarck, NDThe plt of N1151N reported that the departure arpt had some drifting snow which caused the r brake to freeze after takeoff. When the acft was landed, the r tire slid until it wore thru, then deflated. The plt stopped the acft on the rwy, informed tower psnl…NTSB ATL84LA066Accident · No injuriesLimited investigationFinal reportCessna P206A · Charleston, SCThe acft undershot the rwy during landing. The weather was VMC but the landing was made one hour after official sunset. Visibility was reported as 10 miles. There were no problems reported with the arpt or acft except the plt during one radio call saying he…