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 ANC85FA023Accident · No injuriesField investigationFinal reportPiper PA-28RT-201T · Anchorage, AKThe acft crashed during the takeoff roll by running off the departure end of the rwy, gliding over a hwy & impacting trees. According to the plt, 'on takeoff, we accelerated to 90-95 KTS, but the acft did not respond to back pressure for lift off. We…NTSB NYC85LA031Accident · No injuriesLimited investigationFinal reportCessna 182D · Woodside, DEThe plt reported that he refueled the acft on 11/12/84 & filled the tanks. Tach time was 1766.95. On 11/20/84, when he took off, he estimated 51 gals of fuel was on board. He flew to another location & landed, then was away from his acft about 1 hr. When he…NTSB MKC85LA023Accident · No injuriesLimited investigationFinal reportCessna 150L · Joplin, MOPlt departed with estimated 16 gals of fuel on board for brief flight. Approaching arpt for landing, engine lost power. Plt set up for forced lndg in open field. Acft overran available open space and collided with brush. Plt stated acft had been modified for…NTSB MKC85FA024Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Cozad, NEThe acft collided with a electrical transmission line while on a business flt. Investigation revaled IMC existed at the time of the accident, the plt did not file a flt plan, there was no evidence of a wx briefing and there were no known communications with…NTSB CHI85FA053Accident · 5 fatalField investigationFinal reportCessna 310N · Valparaiso, INThe aircraft stalled and impacted the terrain during a forced landing. Witnesses observed the acft flying at 'tree top level' with the wings 'wagging'. One witness reported hearing no engine sounds. The acft impacted the terrain (open field) in a near…NTSB ATL85LA040Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Bumpass, VAVFR plt was using VOR airway navigation. He arrived in the vicinity of destination after dark and attempted to locate the arpt by flying a radial from the VOR; however, he used the 230 degree radial (published radial is 237 degrees). Further, the arpt is…NTSB ANC85LA024Accident · No injuriesLimited investigationFinal reportCessna 170B · King Salmon, AKThe acft crashed during a takeoff from a sandbar on the King Salmon river. The plt stated that during his take- off roll, the windshield fogged over & he was unable to see, the acft's main gear struck a rock & the acft nosed over.NTSB ANC85LA021Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Koliganek, AKThe acft crashed when it failed to become airborne during the takeoff run. The plt & witnesses agreed that snow was not removed from the acft prior to departure.NTSB ANC85LA020Accident · No injuriesLimited investigationFinal reportEmbraer EMB-110 · Fairbanks, AKThe acft sustained substantial damage when the landing gear collapsed during landing. Tests conducted by the acft operator and acft manufacturer failed to provide any reason for the gear collapse. Both plts stated the gear was down and locked upon touchdown.NTSB SEA85LA021Accident · No injuriesLimited investigationFinal reportCessna 180J · Ketchikan, AKThe acft sank after a hard landing on water. The plt reported that the acft bounced during landing and the wind got under the upwind wing and rolled the acft. The wind was reported as 18 KTS with gusts to 25 KTS.NTSB NYC85LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Antrim, NHPlt stated, a wind shift occurred on short final resulting in a sudden uncontrollable yaw to the left. Right aileron and full power was added, however, the acft contacted trees before recovery was made.NTSB MKC85FA022Accident · No injuriesField investigationFinal reportPiper J5A · Stuttgart, ARThe acft was being ferried x-country in legs of approximately 2 hrs flt duration. The acft was refueled for the next legand it needed 18 gallons of fuel. The plt was predicting a burn of 5-6 gallons of fuel per hour. After a flt of 2 hrs and 17 minutes with…NTSB MIA85RA039Incident · No injuriesForeign investigationDouglas DC-8 · Nassau, BahamasNTSB LAX85LA046Accident · No injuriesLimited investigationFinal reportMooney M20J · Tulelake, CAThe plt stated that he was conducting touch and go landings on a road when the left wing struck a 4X4 in wooden speed limit sign post.NTSB FTW85LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Pampa, TXPreflight weather briefing showed closest reporting station to destination below dest apch minimum of I mile visibility but fcst to improve to 1/2 mi by arrival. Area freezing level fcst at 3-4000 ft. flt to dest at 6000 ft was on top of clouds and…NTSB DEN85LA029Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Snowville, UTThe acft nosed over during an off arpt forced landing after the engine failed in cruise flt. The engine was disassembledand examined on 12/3/84. The #3 and #4 piston rods were separated from their cranckshaft journals. Most of the rod bearings were worn. The…NTSB CHI85FEI01Accident · Serious injuriesFinal reportPiper PA-32R-301T · Sandusky, OHThe acft collided with trees at night during a short final approach to land and crashed to the ground in the back yard of a private residence. The plt, who was seriously injured in the accident, said he flew a normal pattern into a 15-20 kt wind when tree…NTSB ATL85FA041Accident · Serious injuriesField investigationFinal reportCessna 172K · Lineville, ALPlt obtained 2 wx briefings stating VFR flight not recommended along intended route. Plt requested local wx only during 3rd wx briefing. Reporting stations upwind and downwind of mountains were forecasting ceilings to be below mountain tops. Route of flt was…NTSB MKC85LA021Accident · No injuriesLimited investigationFinal reportMooney M20J · Kirksville, MOAccording to the plt, during a localizer apch impact with an object was heard and the acft yawed left. The plt did not see what the acft hit but stated that he believed the acft struck a bird. Using a flashlight he attempted to inspect theacft in order to…NTSB MIA85FA040Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Freeport, FLPreflt wx brief included advisory for scattered showers/thunderstorms along route of flt. Departed in VFR conditions but encountered deteriorating wx enroute, received inflt wx advisory to expect low clngs and reduced visibility ahead. Plt stated he 'would…NTSB MIA85FA037Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · Pembroke Pines, FLThe plt had recently been checked out on banner towing operations & was on his 5th banner towing flt. After taking off from rwy 9R, he turned left, crossed to the left of rwy 9L to a left downwind & intended to continue in a left pattern for a banner pick-up…NTSB LAX85LA044Accident · No injuriesLimited investigationFinal reportCessna 185F · Glendale, AZThe acft went to the left of the desired track for takeoff and the plt said that in the attempt to regain directional control by means of throttle manipulation and brake application (the plt in later inspection of rwy and brakes reported rubber marks on the…NTSB FTW85FA054Accident · 1 fatalField investigationFinal reportBellanca 17-31ATC · Allen, TXThe acft collided with the ground as the plt, who was not current for night/instrument flt, tried to maneuver beneath a low overcast on a dark night. Although seriously injured during the accident sequence, the plt was able to tell rescue workers that he 'was…NTSB CHI85LA049Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wild Rose, WIThe plt stated that he was flying at 500 ft AGL over an open marsh that is surrounded by higher terrain covered with pine trees, looking for his father who was hunting in the area. The plt continued to state that he became preoccupied with trying to identify…NTSB SEA85LA033Accident · No injuriesLimited investigationFinal reportCessna 175 · Indian Meadows, IDLanded long and acft slid off end of rwy on compact snow and ice contacting a snow berm near end of rwy.NTSB SEA85LA019Accident · 3 fatalLimited investigationFinal reportCessna U206 · Dixie, IDThe acft crashed shortly after takeoff from yellow pine bar airstrip, witnesses observed the acft depart to the sw, enter a steep left turn immediately after liftoff, cross the river in a turn and impact the south bank abeam the airstrip. A ground fire broke…NTSB NYC85FA029Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Atlantic City, NJThe aircraft was observed in close proximity to another aircraft in the traffic pattern. The pilot extended the downleg leg leg. During the turn to align the aircraft with the runway the pilot suffered a disabling heart attack. Unable to recover the aircraft…NTSB MIA85LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Parkland, FLThe plt stated that as he approached the airstrip he flew his pattern low. As he turned base the wind caught the left wing shoving the acft down. He jammed the throttle forward but the acft crashed.NTSB MIA85FA038Accident · Serious injuriesField investigationFinal reportPiper PA-36-300 · Fellsmere, FLPlt was completing downwind turn when acft began to settle. Plt failed to use full power or jettison the chemical load. As airspeed fell below minimum steady state control spd, acft mushed into grnd.NTSB LAX85LA043Accident · No injuriesLimited investigationFinal reportCessna 150M · Ojai, CAWhile simulating emerg procedures the plt added power and began a 180 deg turn to avoid colliding with trees. During the turn the right wing tip struck the rising terrain causing the acft to cartwheel to the ground inverted.NTSB CHI85LA094Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Holland, MIThe plt stated that a slight rudder pedal misalignment caused the acft to run off the rwy & into a ditch during the takeoff roll. He stated that during the first part of the takeoff roll the rudder 'did not respond normally or as expected.' A later…NTSB CHI85LA052Accident · No injuriesLimited investigationFinal reportBeech A23 · Plato Center, ILOn final approach with a 30-degree right crosswind of 14-16 KTS, the plt experienced a loss of headwind component as theacft passed below height of buildings in the windstream. Power was not added and the acft settled to the ground short of the runway…NTSB CHI85LA051Accident · No injuriesLimited investigationFinal reportCessna 182H · Terre Haute, INPlt stated he was unable to activate the runway lights by radio so visual cues of arpt bldgs were used to line up with runway. Acft lndg/taxi light was inoperative. Plt did not realize he had undershot the approach turn and was, IN fact, lined up to the left…NTSB CHI85FA050Accident · 2 fatalField investigationFinal reportNorth American P-51D · New Haven, MIThe acft, a North American P51D, crashed into a potato field after striking an electrical wire running at a rt angle to the ground track, struck the ground, a building & disintegrated. The plt & owner of the acft was a 50 yr old ex-naval aviator with…NTSB ATL85LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Luray Caverns, VAThe acft was landed on a inadequate field during a simulated forced landing that became a real emergency because the fltinstructor cut the mixture to off. The CFI took over the landing at the last part of the approach and told the student to restart the…NTSB ATL85LA037Accident · Minor injuriesLimited investigationFinal reportAero Commander 500 · Florence, SCThe acft crashed short of the rwy after both engines lost power on the base leg. Th acft hit about 200 ft short of the rwy and slid through the fence onto the rwy destroying about 4 rwy lights. Investigation disclosed that the left fuel strainer drain was…NTSB ANC85LA022Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Anchorage, AKAccording to the plt, he was making an approach over trees that were ten ft high. After passing the trees he 'chopped' the power & the acft landed hard. He noticed the fuselage was buckled just forward of the vertical fin when he exited the acft.NTSB SEA85LA020Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Kings Valley, ORThe plt attempted to fly the acft away from the site of a proposed load drop before the drop was completed. The FAA inspectors said the sling did not release properly. When the plt attempted to depart the area the acft struck the groundin a nose low attitude.…NTSB SEA85LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Aurora, ORThe acft caught fire during start. The FAA inspectors said that AD 72-11-01 had not been followed in compliance.NTSB MIA85LA035Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Stuart, FLAcft was flying at low level over water to film a tv commercial. Plt pushed throttle in for additional pwr but engine did not respond. Full throttle was applied with no response from the eng. Plt stated that there was insufficient pwr to maintain level flt.…NTSB MIA85LA033Accident · No injuriesLimited investigationFinal reportCessna 172C · Titusville, FLAccording to the plt, after he was unsuccessful in starting the acft eng he switched off the magnetos and master switch and exited the acft. Later, during the process of moving the propeller to a position to clear a hand toe bar, the acft started, taxied…NTSB DCA85AA003Accident · Serious injuriesFinal reportBoeing 747-122 · Honolulu, HIAfter accelerating to about 153 KTS drg the takeoff roll, the #7 tire failed & the flt crew aborted the takeoff. The acft was stopped with aprx 3000 ft of rwy remaining. Due to a fuel leak from the right wing, the capt ordered an evacu- ation from the left…NTSB NYC85LA028Accident · No injuriesLimited investigationFinal reportCessna 150G · Westerly, RIWhile practicing a landing, the acft bounced & touched down hard on the nosewheel. The nose gear collapsed & the right wing & prop were damaged.NTSB NYC85FGM02Accident · Serious injuriesFinal reportHiller UH-12B · Butler, PAAfter training at mcville arpt for about 1HR & 15MIN the plt decided to purchase fuel, taxied to the fuel pumps & discovered that the operator was not there. The CFI EST that there was sufficient fuel to fly to Butler county arpt, aprx 18 miles away. During…NTSB FTW85FA052Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · San Antonio, TXShortly after takeoff both engines began to surge. Plt stated he did not switch fuel tanks during emerg procedure because he knew outboard tanks were empty. Company policy was to carry on 10 gallons of fuel in outboard tanks. Post accident investigation…NTSB DEN85FA027Accident · 4 fatalField investigationFinal reportBell 206B-11 · Bingham Canyon, UTPilot was taking passeengers on a sightseeng flight over the kennecott copper mine, largest open pit copper mine in the world. Helicopter collided with unmarked power lines approx 185 ft AGL. Power lines are supported by two unmarked towers on opposing hills…NTSB CHI85LA090Accident · No injuriesLimited investigationFinal reportBeech 58 · Hayward, WIThe acft sustained subst damage after uncontrolled contact with the rwy during landing. Investigation revealed that the landing was inadvertently attempted at a time when the winds shifted to a direct x-wind with gusts to 35 KTS.NTSB ATL85LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Madison, WVFollowing a loss of eng power during a x-country flt, the plt landed on a bridge. During the ldg roll the wing struck a pole. Post crash examination of the engine disclosed that the camshaft gear teeth suffered fatigue failure.NTSB ATL85LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Conway, SCThe certificated pilot, receiving instruction from a certified flight instructor, was manipulating the controls at the time of the accident. The student undershot the runway and touched down short of the paved rwy surface. The aircraft landing gear struck the…NTSB MIA85IA031Incident · No injuriesIncident investigationFinal reportSwearingen SA-226AT · Tallahassee, FLN31264 crashed intentionally gear up on rwy 18 at Tallahassee, FL, while on a night, all cargo 14 CFR 135 flt. The crew attempted emergency gear extension procedures & a fly-by. Investigation revealed a broken wire, TS-70, where it connects with terminal 6.…