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 MKC84LA261Accident · No injuriesLimited investigationFinal reportCessna U206F · Satanta, KSThe pilot selected 10 degrees of flap for takeoff with the aircraft loaded to near limits for existing conditions. The aircraft became airborne in ground effect and would not accelerate to flying speed, necessitating a forced landing in a soybean field.…NTSB LAX84LA454Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355E · Strawberry, CAThe helicopter was approaching the landing pad when the plt heard a loud noise & experienced a loss of tail rotor control. He lost directional control & the helicopter began spinning to the left, struck the helipad, rolled over & burned. The acft was…NTSB LAX84FA453Accident · 5 fatalField investigationFinal reportCessna 320C · Monterey, CAThe flt arrived in Monterey, CA, that afternoon. After dinner the flt was returning to the point of original departure. When the plt contacted the twr for taxi instruction he was informed that Monterey wx was below VFR minimums. After a discussion of wx…NTSB FTW84LA370Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tahlequah, OKLaw enforcement officers responding to the acft accident found the acft inverted beyond the south end of the runway. Plt stated he and his passengers had been drinking beer and decided to go flying. Plt's statements to officers are not clear on exact events…NTSB FTW84LA367Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Arlington, TXAfter two unsuccessful landing attempts the acft touched down on the rwy, veered to the right and off the side of the rwy, colliding with a concrete structure. Rwy 16 was used.NTSB FTW84LA366Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Oak Grove, LAAircraft landed with a flat left main tire, veered left and nosed over inverted.NTSB FTW84LA356Accident · Serious injuriesLimited investigationFinal reportGulfstream 520 · Goliad, TXAcft was found abandoned. Wreckage scene indicates collision with trees prior to collision with terrain. Acft suspected of being used for illegal cargo operations.NTSB DEN84LA265Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Poplar, MTPlt stated, 'river current 12-15 mph, landing area 100 yards wide, curving to right, wind gusting to 20 knots from right rear quarter. Approach was fast, and upon landing, aircraft remained on step, unresponsive to aileron and rudder for turning. Quartering…NTSB DCA84AA034Accident · 17 fatalClass 1Final reportBeech C-99 · San Luis Obispo, CAAt about 1118, a Beech C-99 (wings west flt 628), N6399U, & a rockwell 112TC, N112SM, collided in midair aprx 8 mi west-northwest of the san loui Obispo county arpt. The rockwell 112TC had departed paso robles, CA & was descending toward the san loui Obispo…NTSB CHI84LA361Accident · No injuriesLimited investigationFinal reportBeech V35B · Eden Prairie, MNPlt reported that after operating the fuel boost pump on pre-flt, he exited the acft to turn the prop by hand. During a telephone interview, he stated he could not recall removing the ignition key. After pulling the prop through 1/4 turn, the eng started and…NTSB CHI84LA359Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Woodstock, ILThe acft collided with the terrain during a forced landing. The wx was VMC & no flt plan was filed. During the forced landing in a farm field the right main gear was sheared off and the nose gear bent. The left wing was also substantiallydamaged. The engine…NTSB ATL84LA271Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Biloxi, MSPrior to departure the pilot determined that his destination, a grass runway, was dry. His first approach to this field resulted in a go-around because he would have landed long. The second approach resulted in a landing, but because his wheels began to slide…NTSB SEA84LA212Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Medford, ORThe pilot had been advised by his CFI to avoid using this airstrip during midday due to thermal disturbances. During power-off approach, updrafts were encountered and a right turn out for go-around was initiated; however, power was not added. The aircraft…NTSB NYC84LA297Accident · No injuriesLimited investigationFinal reportPiper PA-601P · Teterboro, NJAcft was cleared to taxi to the rwy. Taxiway was blocked by construction. Plt elected to taxi to runup area to make a 180 deg turn. Plt turned right and right main gear went off pavement onto the soft shoulder and collapsed.NTSB MKC84LA260Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Dexter, MOThe engine on the ag-plane lost power during takeoff and the plt began dumping his load as he made a forced landing. Thelanding area available was a flooded rice levee. The acft was landed tailwheel first but when the main gear dug in, the acft nose over.…NTSB MKC84LA258Accident · No injuriesLimited investigationFinal reportPiper PA-36-400 · Hill City, KSThe plt cleared some power lines and descended to spray a sunflower field. The acft descended until it contacted the flowers with the landing gear. The tall flowers destroyed the leading edges of the acft wings and the landing gear. The drag slowed the acft…NTSB MIA84LA238Accident · Minor injuriesLimited investigationFinal reportBell 206B · Ocoee, FLThe acft rolled over during an attempted takeoff when one skid became stuck in the soft terrain. The plt had landed to deplane a passenger and upon attempting to takeoff the plt found one skid was stuck. The plt continued to apply takeoff power and the acft…NTSB MIA84LA237Accident · No injuriesLimited investigationFinal reportCessna 150 · Ft. Pierce, FLThe student plt on first solo flt misjudged his alt and landed the acft about 30 ft short of the rwy in the grass. This was his instructors assessment of the accident.NTSB LAX84FU031Accident · 1 fatalFinal reportCalypso N/A · Chula Vista, CAOperator/company personnel had been flying the calypo ultralight for about 2 hrs when the marketing director was approached by a plt who wanted to fly the vehicle. They noted that the plt had been teaching students in an eipper ultralight. Company personnel…NTSB LAX84FA452Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Vista, CAAccording to a statement from the passenger who initially survived, the acft encountered fog shortly after takeoff and the plt was attempting to head inland to get out of the fog by reference to street lights. Shortly thereafter, while in a climb, ground…NTSB FTW84LA365Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-300 · Lorenzo, TXAfter completion of a swath run the acft turned right and then left before it descended to the ground in a left bank and nose down attitude. Plt stated that the acft would not recover from the left turn when full right stick travel was applied. The acft was…NTSB FTW84LA362Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Pecan Island, LADue to the wet condition of the sod strip the plt used only the last 1,000 ft of the strip for the takeoff. During the roll he felt that insufficient rwy remained and initiated an aborted takeoff. Unable to stop however the plt resumed the attempted takeoff.…NTSB CHI84LA358Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Cottage Grove, WIWhile over-flying a local arpt at aprx 200 ft AGL the eng lost power. A forced landing was made in an adjacent alfalfa field. The acft landed hard in a nose low attitude and came to rest about 90 ft from initial ground contact.NTSB CHI84FA354Accident · 3 fatalField investigationFinal reportCessna 150A · Twin Lake, MIThe acft collided with the ground in a spiral like descent with the eng in a power retarded state as evidenced by the sound effects. The was no missing or backfiring of the power plant. The acft struck the ground vertically after being seen in a nose dwn…NTSB ATL84LA267Accident · No injuriesLimited investigationFinal reportCessna 172M · Winston-Salem, NCFollowing a high and slow apch, the plt decided to discontinue the landing. Power was added for a go-around, but the power response was not sufficient and the plt elected to continue the landing. Power was reduced and the nose lowered but, the acft stalled…NTSB ANC84LA144Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Viekoda Bay, AKBefore taking off, the plt had become preoccupied with pumping water from the floats & allowed the acft to drift downwind from a fishing vessel. He then elected to takeoff into the wind which was also directly toward the sun. After making a normal rough water…NTSB SEA84LA211Accident · No injuriesLimited investigationFinal reportHayes Quickie Q2 · Puyallup, WAThe plt reported that he had placed 50 lbs of sand in the acft baggage compartment to complement the acft CG. During takeoff the acft was very nose heavy. He elected to make 2 landings at tacoma where the nose dropped severely while the plt attempted to…NTSB SEA84LA210Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Sheridan, ORCFI stated, 'the acft became airborne aprx 2/3 of the way down a 3000 ft gravel and dirt rwy. At lift off, OR slightly before or after, student put on full flaps. Until this point student was in control of the airplane except for minor corrections from me.…NTSB SEA84FA209Accident · 1 fatalField investigationFinal reportBenson B8M · Newman Lake, WAWitnesses observed the aircraft go through a series of rapid pitch oscillations at about 300 ft AGL. The pitch changes increased in magnitude and severity until the main rotor blades struck the rudder stopping it's rotation and resulting in an uncontrolled…NTSB MIA84LA236Accident · No injuriesLimited investigationFinal reportCessna 172 · Winter Haven, FLThe acft landed on glassy water in a nose low attitude and nosed over. The CFI who was checking out an applicant for a seaplane rating said he was preparing to call for or actually pulled the nose up as the acft floats hit the water and went under. According…NTSB MIA84LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe tailwheel equipped acft collided with a stopped Cessna while taxiing to takeoff. The Cessna was in the runup area. The Boeing A75 acft plt said he failed to see the parked acft.NTSB LAX84LA450Accident · No injuriesLimited investigationFinal reportBastian Pitts S1S · Tucson, AZThe plt stated after the accident that he was flying inverted when he experienced an engine failure. Several in flight restart attempts were unsuccessful and the pilot initiated a forced landing on a dirt road. While on final apch to the dirt road, a pick up…NTSB LAX84LA449Accident · No injuriesLimited investigationFinal reportCessna 206 · Sacramento, CAWhile taxiing for takeoff the pilot's seat slid aft causing the loss of directional control and subsequent collision with other acft. The plt stated that when she entered the acft she moved the seat full forward and that the seat lockingmechanism was not…NTSB LAX84FA451Accident · 1 fatalField investigationFinal reportCessna T337G · Paradise, CAWitnesses observed the acft touchdown then heard a power application and watched the acft depart in a nose high attitude. The left wing of the acft struck an aprx 70 ft tall tree about 600 ft from the end of the rwy and 200 ft left of the rwy extended…NTSB FTW84LA363Accident · 1 fatalLimited investigationFinal reportAir Tractor AT301 · Plain Dealing, LAWitnesses reported that the acft made a descending low level turn at the end of a spray run, nosed over and dove into the soybean fld being sprayed. The plt was not wearing a shoulder harness or helmet when the accident occurred. Toxicology results revealed a…NTSB DEN84LA263Accident · No injuriesLimited investigationFinal reportCessna 185 · Akron, COThe aircraft was aprx 200 lbs under max gross weight for the takeoff. According to the pilot all of his previous takeoffs had been at near sea level. He stated that he was not used to high density takeoffs such as this one (7011 feet density altitude). The…NTSB DEN84LA262Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Kindred, NDThe practice autorotation to touchdown began at 500 ft AGL. Shortly after initiating the flare the tail rotor contacted the ground. The pilot was scheduled for a private pilot helicopter check ride on the afternoon of the accident.NTSB CHI84LU010Accident · Serious injuriesFinal reportPioneer Flightstar · Westfield, INThe ultralight dove into the ground from about 100 ft AGL while in the traffic pattern. The plt at first interview said the engine quit. Later, the plt's father said he was told by the plt that the vehicle just stalled. Witnesses heard the engine running and…NTSB ATL84LA265Accident · No injuriesLimited investigationFinal reportCessna 150D · Parkersburg, WVThe pilot was unable to see the deer on the rwy during the landing roll because of the dark night conditions.NTSB ATL84FA268Accident · 1 fatalField investigationFinal reportCessna A188B · Eastover, SCThe acft collided with the ground during a turn-around. The hopper dump valve on the acft was found closed after the accident. The fuel tanks were reportedly full (54 gallon capacity) and 120 gals of benlate, a non-toxic liquid herbicidehad been loaded aboard…NTSB ANC84LA134Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Murphy Dome, AKThe CFI said the engine quit in 'straight and level flight' & 'acted like fuel starvation.' The prop was windmilling. Restarts were attempted without success. A forced landing was made in a wooded area. The landing was cushioned by the acft floats and wings.…NTSB SEA84LA208Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Shelley, IDThe pilot indicated that he was en route to spray a local field when the engine began to run rough. He diverted to an ag strip nearby, but the engine ceased operation prior to reaching the strip. The aircraft struck an irrigation pivot during the forced…NTSB NYC84LA296Accident · No injuriesLimited investigationFinal reportCessna 172P · Manville, NJAcft swerved on rwy before rotation and climbed aprx 10 feet before settling back on the rwy. Plt aborted the takeoff but was unable to stop before end of rwy.NTSB NYC84LA292Accident · Minor injuriesLimited investigationFinal reportCessna 152II · Mercer, PADuring takeoff from ballard field the engine lost partial power. The acft struck a power line during descent, abruptly losing airspeed, and then striking the ground. Post accident investigation revealed the engine spark plug gaps were too wide.NTSB NYC84LA291Accident · Minor injuriesLimited investigationFinal reportCessna 210J · Pine Grove Mill, PADuring takeoff, the eng lost power as the acft was climbing thru about 400 ft AGL. The plane was damaged during a wheel-up landing. The plt reported that a braided fuel line had ruptured & allowed fuel to leak out of the right fuel tank while the acft was…NTSB NYC84LA290Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Caldwell, NJThe instructor plt stated that while he was giving instruction, he made a normal landing. When the wheels touched down, the right main gear snapped off & hit the side of the fuselage. The acft then skidded along the rwy until it came to rest.NTSB MKC84FPG01Accident · Serious injuriesFinal reportRobinson R22 · Frenchman'Bayou, ARThe acft crashed during autorotation into a soy bean field after the engine lost power. The plt was a student who did not have authorization to fly nor the proper certificate and endorsement from the CFI. The acft engine stopped due to fuel exhaustion. The…NTSB LAX84LA458Accident · No injuriesLimited investigationFinal reportCessna P172D · Livermore, CAAccording to the plt, the acft landed hard and porpoised several times before the landing was aborted. The second landing was uneventful. Subsequent inspection of the acft revealed that both wings and the fuselage were buckled and the lower engine mounts were…NTSB LAX84IA448Incident · No injuriesIncident investigationFinal reportCessna 172 · Redding, CAPlt briefed pax on use of brakes so he could hand prop acft. Plt stated, the acft 'got away from the passenger' when the engine started. Acft contacted a parked acft and a hangar before stopping.NTSB ATL84LA266Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Iuka, MSOn initial climb from take-off, a partial power loss occurred. Carb heat was selected but pwr remained at a level too low to sustain altitude and a forced landing was effected in rough, wooded terrain. Investigation revealed no discrepancies in the fuel or…