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 NYC84LA187Accident · No injuriesLimited investigationFinal reportCessna 177 · Annville, PAThe plt stated that during an aborted landing while trying to recover from a bounced touchdown he misused the flaps. Once airborne the acft settled into a wheat field. The plt stated excessive airspeed was gained during the steep landing apch.NTSB NYC84LA186Accident · No injuriesLimited investigationFinal reportCessna C150 · Stow, MADuring the initial takeoff climb at about 400 ft AGL the acft experienced a loss of power. During the emergency descent the eng restarted and ran for aprx 30 seconds before quiting again. The plt perofrmed a forced landing into the pine trees below.NTSB MKC84LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Hardy, ARThe acft collided with trees during an off arpt precautionary landing. The plt received a wx briefing that forecasted low ceilings and visibilities along his route. The plt elected to continue the flt. During the flt he encountered fog. He made a 180 and…NTSB MKC84LA148Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Humnoke, ARPlt stated he noticed a vibration in the acft on two flts prior to the accident flt. Plt felt forward pressure on the stick so he attempted to trim the acft. The acft nosed forward colliding with the terrain. Inspection disclosed no preimpact…NTSB MKC84FA147Accident · 1 fatalField investigationFinal reportHughes 369D · Kearney, NEDuring return to arpt from a local flight, the plt diverted to observe property of a personal friend, located along a river bank. The plt was making a right turn about 200 ft AGL at 40 to 50 KTS airspeed when vibration was felt in the anti-torque pedals & the…NTSB LAX84LA317Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Irvine, CAThe plt stated that while in cruise flt at 1200 ft MSL the eng power went to idle, he switched tanks, turned on the boost pump, placed the mixture in the rich position but to no avail. Post crash examination revealed that the fuel boost pump did not operate.…NTSB LAX84LA316Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · King City, CAThe acft right wing dragged the ground shortly after takeoff; the acft cartwheeled and came to rest against a tractor. The plt reported that he began a turn at 500 ft AGL and the acft entered an accelerated stall. A passenger reported thatthe acft became…NTSB FTW84LA254Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Amarillo, TXDuring a pre-flt breifing, the wind was reported to be from 280 deg at 6 to 12 KTS. At launch time, the plt estimated the wind was blowing at 7 KTS. He took off at 0720 CDT without difficulty & climbed to about 1000 ft AGL. Aprx 1 hr after taking off, the plt…NTSB FTW84LA251Accident · No injuriesLimited investigationFinal reportCessna 182Q · Whitney, TXAccording to the plt, he was unable to stop the acft after landing on a 2000 ft asphalt rwy. The acft overran the end of the rwy & hit a ditch. The nose gear collapsed & the acft nosed over. The wind was reported blowing from 210 deg at 20 gusting 25 KTS.…NTSB FTW84LA250Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Arnett, OKAccording to the plt, the wx for his route of flt was forcast to remain VFR. En route, ceilings at 4000 to 5000 ft MSL were encountered in the vicinity of hobart, OK. As the flt continued the wx deteriorated. In order to maintain VFR conditions, the…NTSB FTW84FA244Accident · Serious injuriesField investigationFinal reportBell 206B · San Antonio, TXIn a left orbit the helicopter yawed right and continued the right rotation to impact. At the time of the loss of control the acft was operating out of ground effect at 250 ft AGL with a density alt of 3751 ft and an indicated airspeed of 20 to 25 KTS. The…NTSB FTW84FA243Accident · 1 fatalField investigationFinal reportCessna 177B · Kinner, LAThe plt stated he lost eng pwr after departing the new orleans int'l arpt. The flt was unable to return to the arpt. The acft crashed in the waters of lake pontchartraih about 1 mile from the arpt. The wreckage was located and marked with a buoy. Due to high…NTSB CHI84LA216Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes Firefly 8-24 · Burnsville, MNThe Balloon landed without incident. According to the plt, the envelope was being deflated when a gust of wind tipped the basket. The plt said he saw a young boy with his leg under the basket. The plt lifted the edge of the basket by stepping out of it to…NTSB CHI84LA215Accident · Serious injuriesLimited investigationFinal reportIstenes Oldfield Baby Lakes · Middlefield, OHIt was reported that the acft had performed two tight left traffic pattern turns after takeoff. On the downwind turn the acft banked 60 degrees. The plt lost control of the acft and crashed in a wooded area. It was reported that the plt had no previous…NTSB CHI84LA210Accident · Minor injuriesLimited investigationFinal reportWagner Cuby WAG-A-BOND · Lyons, WIThe plt noticed '...a little power loss...' After takeoff at about 550 AGL. He turned downwind & flew a normal traffic pattern, but at a lower altitude. The acft stalled during the base turn. The plt stated that the loss of power was due to the mixture…NTSB CHI84LA208Accident · No injuriesLimited investigationFinal reportCessna 172L · Painesville, OHThe acft left the dry asphalt rwy, crossed a grassy area, went through a fence and killed a horse. The plt stated that after landing the airplane 'get pushed to rt of rwy.' Local winds were reported from 040 degs at 10 KTS. The plt had just recently purchased…NTSB CHI84LA207Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 · Plainwell, MIThe acft veered to the left side of a grass strip into taller grass which increased the drag on the left main gear. The acft swerved farther off path until a furrow was struck and the acft nosed over. Local winds were reported from 150 degrees at 8 KTS. The…NTSB CHI84LA206Accident · Serious injuriesLimited investigationFinal reportErcoupe 415C · Sturtevant, WIAccording to the plt, he was making a hi speed taxi check when the acft lifted off to about 5 ft AGL. After lift-off, the acft began to go to the left. When the plt applied right rudder, the plane veered further left & crashed in an onion field. An exam of…NTSB ATL84LA189Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Huntsville, ALAfter lift-off & gear retraction, the acft settled back onto the rwy, hit a barrier cable, slid backward aprx 300 ft & crossed a road before coming to rest. The plt reported that the carburetor heat door had come loose. However, an FAA inspector examined the…NTSB ATL84FIJ02Accident · Serious injuriesFinal reportTaylorcraft F-19 · Middlebourne, WVAfter returning to the arpt, the plt made an apch to rwy 10, which had a drop-off on the apch end. The winds were reported as variable & occasionally gusty. On the 1st apch, the acft encounter 'slight air turbulence' & the plt elected to go around. He stated…NTSB ATL84FA185Accident · Serious injuriesField investigationFinal reportCessna 402C · Hickory, NCDuring the ILS apch to rwy 24 (6400 ft long), visual contact with the rwy was established at aprx 500 ft AGL and the acft was indicating 'one dot' high on the glide slope. Witnesses stated the acft touched down past the halfway point on the rwy with full…NTSB ANC84LA077Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Wasilla, AKThe acft nosed over during a forced landing after the engine lost power. The plt said that the engine failed due to carburetor icing. Examination of the eng revealed no mechanical failure or malfunction.NTSB SEA84LA120Accident · No injuriesLimited investigationFinal reportCessna A185E · Refuge Cove, AKThe plt stated in his report on form 6120.1 that the acft was on step during takeoff when the acft began a roll to the right. The right wing hit the water twice in spite of aileron control inputs to correct it. With the application of rudder and a power…NTSB SEA84LA118Accident · Minor injuriesLimited investigationFinal reportVarga 2150-A · Mountain Home, IDThe student plt became lost on the last leg of his x-country, solo flt. He final determined that his position was over boise, ID, about 35 mi from his destination. He turned to follow railroad tracks. About 15 min later, the eng ceased operating due to fuel…NTSB NYC84LA188Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Pepperell, MAThe glider was attempting a tow-launch when the right wing tip struck a clump of high grass. The glider yawed right and collided with the asphalt rwy, breaking the fuselage and collapsing the landing gear. The pilot stated that the grass was too high for a…NTSB MKC84LA151Accident · No injuriesLimited investigationFinal reportBeech BE35 · Nashville, ARThe acft collided with the ground after takeoff. The plt said he over-rotated during takeoff. The acft rolled right and left, striking the right landing gear and then the left wing on the rwy.NTSB LAX84LA323Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Novato, CAPlt lost directional control during landing roll. Acft veered off left side of rwy. Plt attempted to return to rwy and acft contacted VASI light. Gusty crosswind conditions existed. Plt's ttl flt time was 68.9 hrs.NTSB LAX84FA315Accident · Serious injuriesField investigationFinal reportBölkow Phoebus A-1 · Llano, CACircling in lift near a high ridge the sailplane encountered what the plt referred to as wind shear. Losing control, the sailplane collided with a tree before impacting the ground.NTSB FTW84LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe plt reported after the accident that he was dispensing fertilizer and had just flown through a heavy rain shower when the engine began to lose power. A forced landing was made in a flooded rice field and the acft nosed over. The pilot stated that he was…NTSB FTW84LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tallulah, LAThe acft caught fire shortly after takeoff and the plt landed in a wheat field. The nosewheel dug into the soft field and the acft nosed over. This acft has been the subject of recommendations on worn and deteriorated fuel lines. The pltsdescription of his…NTSB FTW84FA242Accident · 1 fatalField investigationFinal reportBeech BE35G · Wewoka, OKThe plt was not current in IMC operations nor was the acft certified for instrument lft. After obtaining a wx briefing which forecast a chance of thunderstorms along his route, the plt departed on a x-country. En route the plt contacted Oklahoma city efas and…NTSB DEN84IA163Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Salt Lake City, UTFlt 428 landed on rwy 16R which was closed for construction. The closure info was contained in a NOTAM which was announced in ATIS info oscar. The flt crew reported they had obtained oscar. The flt was cleared to land on rwy 16L but instead landed on rwy 16R.…NTSB DEN84FA162Accident · Minor injuriesField investigationFinal reportCessna 340A · Paonia, COThe pilot reported that at about 200 ft (AGL) on initial climb from takeoff, a complete power loss was experienced on the left engine. He stated the left propeller was feathered, but the aircraft would not hold altitude at recommended single-engine speed…NTSB DEN84FA161Accident · 1 fatalField investigationFinal reportLet L-13 · Edgewood, NMWitnesses reported that the acft appeared to be too high, too fast, and in a crab as it approached the rwy. Over the rwy the glider was observed to roll into a right turn as the nose came up. Shortly thereafter the right wing struck 3 parked acft and collided…NTSB ATL84LA186Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · New Bern, NCThe plt was performing a low level fly-by simulating an inexperienced flyers erratic maneuvers when the acft fell vertically to the ground and bounced into a fence before it came to rest in a field. The plt said he hit a down draft at a tree line. The fly-by…NTSB ATL84FU004Accident · 1 fatalFinal reportUltraflight Lazair II · Blichton, GAThe ultralight was low and flat during an approach to land. The acft was aligned with a tree, and according to witnesses, there was no evasive maneuver to avoid the obstruction. The vehicle collided with the tree about 40 ft alg and fell to the ground. No…NTSB ATL84FA184Accident · 1 fatalField investigationFinal reportBeech A36 · Fayette, ALThe acft collided with the ground in a near vertical nose down attitude after being observed by witnesses to pitch down during cruise flt. This acft & plt flew earlier in the day with an instructor who had to recover control of the acft after the plt allowed…NTSB SEA84LA117Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Ketchikan, AKThe plt was making a low turn at slow airspeed to land on a gravel road. His left gear dug into the gravel and broke offand the acft ground looped.NTSB SEA84LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Stewart Island, WAThe plt landed to the west on a wet grass strip with 1/4 inch of standing water. He said he had no traction & the acft slid off the end between 2 trees, damaging both wings. He also said the wind was 090 deg at 5 KTS gusting 15 KTS.NTSB SEA84LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Fall City, WAThe acft was landed at an arpt with a narrow 25 ft rwy with tall grass on either side and partially unsurfaced. The student plt said he was blown off center line by a x-wind into the tall grass. As the acft slowed the nose wheel sunk inthe soft terrain and…NTSB NYC84LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Williamsport, PAThe aircraft was engaged in student flight training; the student was performing touch and go landing in shifting, gusty wind conditions. A gust hit the aircraft on short final and the student was unable to recover control before a hard landing and bounce…NTSB MKC84FA146Accident · 2 fatalField investigationFinal reportCessna 150H · Camdenton, MOWitnesses observed the acft flying low over a lake. As it approach the home of the plt's parents, the acft's wings moved as though waving, then the acft entered a steep climb. After reaching its maximum height from the pull-up, the acft rolled into a steep…NTSB MIA84LA171Accident · No injuriesLimited investigationFinal reportCessna 182 · San Juan, PRWhile the plt was in the traffic pattern (on base) to land at isla grande arpt, the eng lost power. Subsequently, the acft was ditched & sank in about 40 ft of water. The acft was not recovered, so the eng could not be examined.NTSB LAX84LA314Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe helicopter experienced a tail rotor failure shortly after departing the airport on a VFR local sling loading flt. The plt stated that, 'at approx 500 ft asl on climb out experienced sudden, severe vibration. Made a 180 degree turn to return to airport &…NTSB FTW84LA249Accident · No injuriesLimited investigationFinal reportBeech 65 · Zapata, TXAccording to law enforcement officers, the acft experienced double eng failure and made a forced landing in unimproved terrain. During the landing rollout the acft struck several trees. An intense post crash fire erupted destroying all but one wing tip of the…NTSB DEN84LA164Accident · No injuriesLimited investigationFinal reportCessna 210E · Livingston, MTWhile on a visual flight plan flight the non-instrument rated plt operated his unpressurized Cessna 210 above the clouds and up to an altitude of 16500 feet MSL. The plt stated that just after passing, 'crazy peak', he encountered extreme turbulence and the…NTSB DEN84FA155Accident · 1 fatalField investigationFinal reportCessna 180H · Broadus, MTDuring the initial takeoff climb in a westerly direction a severe wind gust from the south occurred at an alt of aprx 150 AGL. The plt turned the acft to the south and a rapid increase in alt of aprx 60-70 ft occurred. The wind stopped suddenly and the acft…NTSB CHI84LA209Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Martin, MIThe plt had landed on a dragstrip after he encountered deteriorating wx. When the wx improved, he took off & attempted to depart over a bleacher area. The plt had difficulty climbing over the bleachers & said 'noticed RPM at 2700, helicopter in a turn.' He…NTSB CHI84LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Middleton, WIPwr loss experienced during normal cruise flt. Plt received vector to nearest airport. There was no evidence of attempt to regain power. On approach to airport, plt extended lndg gear. Resultant drag factor increased glide angle to extent plt felt clearance…NTSB ATL84LA188Accident · Minor injuriesLimited investigationFinal reportWaco RNF · Danville, VAThe pilot was en route to NJ when the eng began to run rough. He diverted to Danville, VA, and landed. During the subsequent takeoff the eng began to run rough, then quit at an alt of aprx 700 feet. The pilot turned the acft and over flew the departure rwy to…