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 LAX84LA411Accident · No injuriesLimited investigationFinal reportAeronca 60-TF · Gorman, CAAccording to the plt a 90 degree crosswind caused a loss of directional control shortly after takeoff. The empennage contacted a fence and trees off the left side of the rwy.NTSB LAX84LA410Accident · No injuriesLimited investigationFinal reportCessna 152 · Salida, CAFailure of the number 3 exhaust push rod caused the power loss. The CFI took control of the acft and performed a forced ldg on a private airstrip. Due to a higher than optimum approach the acft landed long, overran the end of the rwy and collided wiht trees.NTSB LAX84LA409Accident · Minor injuriesLimited investigationFinal reportVance-Hamm Glasair · Scottsdale, AZWhen the plt was cleared for takeoff, the tower was reporting a wind from 260 deg at 11 KTS. The takeoff was initiated & the acft accelerated normally. When the tailwheel was raised, the plane began drifting left. The plt said she applied rudder until she had…NTSB LAX84LA408Accident · Minor injuriesLimited investigationFinal reportNesmith Cougar 1 · Williams, AZWhile en route, the plt elected to land at the Williams muni arpt for a rest stop. He noted that rwy 2/20 was closed; however, he observed what appeared to be a new gravel strip, oriented north/south & an airplane on the arpt. The plt assumed the arpt was…NTSB FTW84LA322Accident · No injuriesLimited investigationFinal reportCessna 152 · Friendswood, TXDuring a touch-&-go landing, the plt lost directional control of the acft after he applied power to takeoff again. The acft went off the left side of the rwy, hit a ditch & nosed over.NTSB DEN84LA234Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Redfield, SDThe pilot reported he exhausted his fuel supply while engaged in aerial application. The power loss occurred as the aircraft was in a turn and ground impact occurred. In an accident report, the plt suggested that he should have had an operable fuel gage &…NTSB DEN84LA233Accident · No injuriesLimited investigationFinal reportCessna A188B · Stratford, SDPlt stated that he was taking off on this flight with 120 gallons of chemical and full fuel tanks. He continued to state that the acft did not accelerate as it had earlier that day. The acft rolled aprx 3 quarters of the 1/2 mile long rwy before it became…NTSB DEN84FTM02Accident · Minor injuriesFinal reportAmateur Built Thorp T-18 · Salt Lake City, UTThe plt was on a x-country to Salt Lake City. Approaching Salt lake he saw thunderstorms in the area. At this point he said he had 1/4 of a tank of gas so he diverted to ogden then tried for morgan where he was waved off by 3 people on therwy. Plt then…NTSB CHI84LA307Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Huntley, ILThe plts of a Boeing A75, N55070, & a vultee BT-13, N176VR, where in formation as they apchd their destination. When the saw the arpt, they separated for separate landings & lost sight of each other. Before landing, both plts flew over the arpt & noted the…NTSB CHI84LA306Accident · No injuriesLimited investigationFinal reportCessna 150M · Newark, OHThe pilot stated that the engine failed due to fuel starvation. The fuel selector is an on-off type. Examination of the aircraft revealed that the fuel vent was partially blocked by mud dobbers.NTSB CHI84LA305Accident · No injuriesLimited investigationFinal reportBeech B-35 · Harrison, MIThe plt inadvertently landed the acft with the landing gear retracted. He said he forgot to lower the gear. Most of his 200+ hours of flight time had been in fixed gear acft.NTSB ATL84LA233Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Morrison, TNThe plt was giving free rides to his friends. He was attempting to land on rwy 27 when the 'aircraft lost lift at 15 feet above the rwy.' The acft dropped to the rwy in a three point attitude, the plt added power to regain control. The left wing tip and the…NTSB ATL84LA232Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Harlan, KYAs the acft accelerated for takeoff the pilot's seat slid aft and he was unable to maintain directional control. The acft went off the left side of the rwy and nosed over when it rolled through high grass. According to the pilot the seat was locked in place…NTSB SEA84LA181Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Creswell, ORThe acft was on a night VFR flt from san carlos, CA, to eugene, OR, when the plt asked apch control how for away the arpt was. ATC informed the plt that the arpt was 16 miles further. About 3 minutes later, the left fuel tank was emptied. The plt switched to…NTSB SEA84FA178Accident · 2 fatalField investigationFinal reportSperling BD-4 · Henderson, NVWitnesses reported observing the acft depart to the ssw toward the mountains. The acft made a series of turns and banks to avoid a group of thunderstorm cells (air mass thunderstorms) in a direction of interstate highway 15. The acft was reported to have made…NTSB NYC84LA253Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Seboomook Lake, METhe acft was on final for a water landing when a bird hit the windscreen according to the plts statement. A witness who observed a dark object (thought to be a cormorant, since several were seen in the area before & after the accident) saidthe object floated…NTSB NYC84LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Beverly, MAThe acft made a forced landing after the engine vibrated and lost power. The plt said that the fuel gages were checked and indicated 1/4 full. The plt said he switched fuel tanks but the engine did not improve its performance. The plt thenaccomplished the…NTSB NYC84FNC06Accident · Serious injuriesFinal reportPiper PA-24-180 · Bingham, METhe acft used, according to various accounts, between 1/2 and 2/3 of the 2300 ft runway on take-off roll. Normal handbook take-off run is 750 ft. passengers stated acft skipped off and touched back down twice before finally becoming airborne. Acft rolled…NTSB MKC84LA227Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Troy, KSShortly after takeoff the acft collided with wires and crashed. The plt had tried to fly under the wires because the acft would not climb over them. Investigation revealed that the acft was overloaded and out of balance by having 2 minorpassengers in the…NTSB MKC84LA224Accident · No injuriesLimited investigationFinal reportCessna 150 · Kearney, NEAcft nosed over in a corn fld during a forced landing following a loss of pwr. No fuel was found on board the acft. Plt made one stop en route for fuel but was unable to obtain any services as the arpt was unattended.NTSB MKC84FA225Accident · 1 fatalField investigationFinal reportBobby Wayne Watkins Mini Coupe · Nashville, ARThe builder/owner/plt had flown the home built acft for about 10 mins on its 1st test flt which was made a few days prior to the accident. On third flt, he took off on rwy 01, climbed straight-out for awhile, made a left turn to x-wind leg & started a…NTSB LAX84LA416Accident · No injuriesLimited investigationFinal reportCessna 172E · Elk Grove, CAThe acft bounced several times during landing according to a plt witness near the rwy. During the bounces the acft left the rwy in a crosswind. The damage to the acft was estimated as minor up to this time. The plt of the accident acft decided to try to…NTSB LAX84FA415Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-300 · Tau, AntarcticaThe acft crash landed after the plt used flaps and power to semi-control pitch after the elevator down control cable failed at about 300 ft AGL on final approach. The left wing of the acft hit the terminal roof during the stall mush FROM50 ft AGL. The company…NTSB LAX84FA407Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Goleta, CAThe plt radioed to the santa barbara tower that he was 'without power' & was going to attempt to land in an open field. However, during the forced landing, the acft collided with trees aprx 50 ft short of the field. An exam of the eng revealed that the fuel…NTSB FTW84LA319Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bryan, TXThe acft collided with trees and the ground after stalling during a pull-up while maneuvering for aerial application. It was a hot day and the acft had recently been loaded. The plt advised to 'beware of density altitude and turning hard over trees.' This…NTSB FTW84LA316Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · High Isl Blk298The helicopter skid contacted a net fence around the landing platform on an oil rig. The safety net broke and the acft rocked over the side of the platform. The plt attempted to autorotate into the water. The landing was hard and one floatseparated. The…NTSB FTW84LA315Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · El Paso, TXThe helicopter crashed into a field during an aerial application flight. There were no eyewitnesses to the crash. The pilot was pulled from the wreckage by a farm worker who heard the crash. The pilot would not state to investigators what occurred.NTSB DEN84LA232Accident · No injuriesLimited investigationFinal reportBell 206B · Durango, COThe acft engine quit as the plt maneuvered over a ridge line after operating over 1 hour without refueling even though fuel was available at the last stop. The plt said the fuel gages indicated 6 gallons of fuel remaining. Of this about 2 are unusable in…NTSB BFO84FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Selbyville, DEThe student pilot and one passenger departed on the flight without a wx briefing despite the existence of low ceilings and rain. Witnesses related hearing the engine accelerate and seeing the acft start a climb before it broke up and impacted the ground.…NTSB ATL84LA234Accident · No injuriesLimited investigationFinal reportBeech V35B · Marion, NCThe acft collided with light gauge power lines which broke but acft control was not lost. The plt and a passenger were flying low over a lake looking for another friend who was skiing there. The flt was proceeding at about 25 ft AGL when the wires were…NTSB ATL84LA231Accident · No injuriesLimited investigationFinal reportBeech C23 · Gainesboro, TNThe acft collided with a static wire while flying along a river. The collision occurred at 350 ft AGL about 5 miles NE of the arpt. The left wing hit the wire which cut into the wing and penetrated a fuel cell. Fuel escaped from this cell and when the acft…NTSB ATL84LA230Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Georgetown, MSThe plt reported that during a pull-up, the prop went to a low pitch angle & the eng was not developing full power. He noted that the tachometer was near the red line & he retarded the prop pitch control & the throttle. Also, he noted that the oil pressure…NTSB ANC84FA119Accident · 4 fatalField investigationFinal reportGrumman G-21A · Ouzinkie, AKN2021A departed kodiak, AK, at 0904 AKDT under a special VFR clearance. Two other plts stated N2021A was then circling over monashka bay while waiting for the wx over the narrow strait to clear. At 0920 AKDT the plt of N2021A stated to one of the other plts…NTSB SEA84LA179Accident · No injuriesLimited investigationFinal reportCessna 152II · Reno, NVAccording to the CFI, when he & his student were on approach for landing on rwy 16R, he received a report of wind shear. The CFI stated that he was instructing his student in the 'wing down' method for x-wind landings & the acft touched-downon its right wheel…NTSB SEA84LA177Accident · No injuriesLimited investigationFinal reportCessna 150H · Worley, IDThe pilot was performing a touch-and-go landing on an 80 foot wide, turf and gravel runway. The plt stated that he made a normal lnding but during the takeoff the acft lifted off the gnd then settled back on the rwy. The acft then swerved off the left side of…NTSB MKC84LA228Accident · No injuriesLimited investigationFinal reportAero Commander Thrush S2R · Waldenberg, ARWhile on takeoff roll one propeller blade separated and the engine came loose from the engine mounts. The acft was then stopped on the rwy.NTSB MKC84LA226Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Steele, MOThe pilot stated that after takeoff, at an altitude of 50 ft AGL he reduced the engine power. Shortly thereafter, the acft stalled and touched down on the rwy. He stated he applied excessive brake pressure to stop the acft and it nosed over on the rwy.NTSB MIA84LA205Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bonifay, FLWhile turning after a swath run the control stick came loose and the acft impacted the ground. Inspection revealed the bolt used to secure the control stick failed due to corrosion.NTSB MIA84FA204Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · St.Simons Is., GAThe acft crashed during a forced landing after a power loss on final apch. The plt reported to fss on a 3 mile final and then reported the power loss and said he would make a 'dead stick' landing. Shortly thereafter, fss received an ELT signal. The acft was…NTSB LAX84LA406Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Wikieup, AZThe acft was serviced with a full load of fuel before the plt took off. About 1 hr after takeoff, the eng lost power as the throttle was advanced to climb over a mtn ridge. Subsequently, the acft was damaged during an emergency landing on rough terrain. No…NTSB FTW84LA318Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe heavily loaded acft was turned shortly after takeoff and began to settle. The plt started to dump the load but the acft contacted trees during the attempt and crashed. The acft was loaded with fertilizer and nearly full of fuel. The temperature was 90…NTSB FTW84LA317Accident · No injuriesLimited investigationFinal reportBeech D-18S · Mcallen, TXThe PIC was observing from the right seat while the C0-PLT was in the left seat taking off. During the takeoff roll, the co-plt lost directional control of the acft & the PIC was unable to recover. The acft veered off the left side of the rwy, the right main…NTSB FTW84LA314Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355F · El Paso, TXThe helicopter encountered turbulence and downdrafts during landing. The acft impacted the asphalt ramp slightly nose low and bounced 2-3 ft into the air. The nose dipped more and full aft cyclic was applied. The main rotor blades hit the ground and the acft…NTSB DEN84LA230Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Richey, MTThe pilot stated that he landed in a pasture where he intended to refuel. During the landing roll, one of the wheels dropped into a hole, causing the main rotor blade to flex downward and severe the tailboom.NTSB DEN84LA228Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Meeteetse, WYPlt reported flt was being conducted in mountainous terrain with fog patches in the area. Conditions conducive to carb ice existed. Calculated temp at flight altitude of 9000 ft MSL: 62 degs. Plt's estimate of temp: 50 degs. Closest reported dew pt: 57 degs.…NTSB DEN84LA221Accident · Minor injuriesLimited investigationFinal reportPiper 28RT-201T · Glendo, WYThe acft was damaged in a forced landing in a wooded area after the engine failed. The plt said that he was cruising at 7500 ft MSL when without warning the engine began making noises and then lost oil pressure. After the landing the enginewas examined at the…NTSB CHI84LA302Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Munising, MIThe acft nosed over during landing on a solo instructional flt. The students instructor said the approach seemed normal. When the acft flared the nose struck the ground first. The student said he 'did not remember pushing the wheel forward but apparently I…NTSB CHI84FA303Accident · 3 fatalField investigationFinal reportCessna 421 · Birchwood, WIDuring flt, the plt transmitted to ARTCC 'we've got a problem, we're losing altitude.' The controller provided a vector to the nearest arpt, but shortly after that, the plt stated that he would not be able to reach the arpt. The plt did not inform ARTCC of…NTSB ATL84LA228Accident · No injuriesLimited investigationFinal reportCessna 175 · Enterprise, ALA witness observed the airplane slipping on final apch. The aircraft lost too much altitude and hit the terrain short of the runway. The airplane damage indicated that the pilot failed to correct the slip condition in time to arrest the descent.NTSB ATL84LA227Accident · Minor injuriesLimited investigationFinal reportCessna 172F · John'S Island, SCDuring a solo flt, the student flew to a local arpt to practice takeoffs & landings. After his last landing (on rwy 9), he elected to make a x-wind takeoff on rwy 21. During the takeoff, the acft began drifting left at about lift-off speed. The student…