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 BFO88LA087Accident · No injuriesLimited investigationFinal reportBeech B23 · Roanoke, VAThe plt said the acft bounced twice during the landing. The apch speed was 75 to 80 KTS. The left main gear collapsed on the second bounce. The nose gear collapsed on the final touchdown. The acft slid off the left side of he rwy. The plt reported no…NTSB ATL89LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Monroeville, ALAccording to the plt, he had requested the acft be fully svcd with fuel before takeoff; however, he did not visually check the fuel. He rprtd that after takeoff, he had flown about 50 min when he noted the rgt tank, which he was using, indcd empty. He said he…NTSB ATL89LA001Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Ridgeland, SCThe plt reported that the left brake failed to function during taxi when he attempted to reduce speed and turn 180 deg into t/o position. The airplane began to track to the right. He released brake pressure on both pedals thinking that he might have been…NTSB SEA88LA192Accident · No injuriesLimited investigationFinal reportCessna 207 · Center Island, WAThe plt was landing upslope on a one-way 1700 ft rwy in wind that was variable & changing from calm to gusts from the north. The plt rprtd a northerly gust cond occurred as he was landing. Subsequently, the acft floated beyond the desired touchdown point &…NTSB NYC88LA251Accident · No injuriesLimited investigationFinal reportCessna 210 · Kirkwood, NYThe plt attempted to land at a private airport at night on an unlit rwy. A go-around was initiated and during the go-around the eng lost pwr. A gear up landing was made beyond the rwy. The investigation revealed water in the fuel system. The eng was run up…NTSB NYC88LA250Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Sodus Bay, NYWhile on a low level pleasure flt over water the plt failed to maintain adequate terrain clearance and the left wing contacted the water. The acft crashed into the water and remained upright. The plt and pax exited the acft and were picked up by a passing…NTSB NYC88LA247Accident · Minor injuriesLimited investigationFinal reportCessna 172P · New York, NYWhile on a night personal pleasure flt along the hudson river between New York and new jersey, at 300 feet AGL, the plt turned the acft toward an unlighted shore area and lost visual cues. The plt inadvertently flew the acft into the water. The acft sunk and…NTSB LAX88DVG10Accident · 1 fatalFinal reportCessna A188B · Dixon, CAPlt had completed aerial application of a field several miles south. Witnesses heard sounds of acft. One witness observed acft briefly inverted and 'out of control.' Acft impacted open field upright, wings level and nose down. Fire ensued. No evidence found…NTSB CHI88FA248Accident · 2 fatalField investigationFinal reportCessna 210L · Monroe, WINTSB ATL88LA257Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student pilot was conducting his first SOL0 flight, when he lost directional control and collided with three parked airplanes. The student said that his right foot slipped off the rudder pedal; attempts to recover failed. The pilot did not report any…NTSB ANC88LA149Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Homer, AKJust after liftoff the airplane experienced a complete engine failure, the airplane crashed on the mud flats approximately 500 feet off the departure end of runway 21. The chief pilot stated that the pilot did not check the fuel supply prior to this flight…NTSB SEA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Renton, WAThe student pilot was returning from a long solo cross country. The runway was undergoing construction. 2,300 feet remained for landing. Landing needed to be accomplished over barriers. The student pilot had approach flaps set. The tower asked the pilot to…NTSB SEA88LA190Accident · No injuriesLimited investigationFinal reportCessna 185F · Hillsboro, ORDuring landing roll the aircraft veered to the right and departed the runway where a groundloop occurred. The wind was calm. No explanation for the loss of control was given by the plt.NTSB NYC88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Carlton Center, NYPlt stated he was landing to the west and touched down about half way down a 2,000 ft grass strip. The plt also said the grass was wet and the wheel braking was ineffective. The plt elected to keep the airplane on the ground due to obstacles at the end of the…NTSB NYC88DFJ04Accident · Serious injuriesFinal reportCallair A-9 · Churchville, NYThe pilot was engaged in aerial application activities. When he started a turn at low altitude to align himself for another spray run the aircraft stalled and struck the terrain.NTSB MKC88LA180Accident · No injuriesLimited investigationFinal reportEllis Quickie Q2 · Winfield, KSWitnesses said that after takeoff, the plt made one low level pass, then returned for landing. The plt rprtd that he intended to make a go-around, but that he may have pushed the elevator control forward instead of the throttle. Subsequently, the acft was…NTSB MIA88LA275Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Belleview, FLAfter clearing transmission wires at the apch end of the rwy, the plt stated the acft was low & slow. Prior to touchdown she stated the acft stalled, then landed hard. The nose wheel collapsed during the touchdown.NTSB LAX88FA330Accident · No injuriesField investigationFinal reportBell 206L-1 · Santa Barbara, CAFailure of the #1 turbine wheel. Contributing to this accident was the unreported over temperature cycles of the engine. Also contributing was the unsuitability of the landing surface from the presence of the 1/4 inch steel sheeting.NTSB FTW88LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Worth, TXThe pvt plt (PIC) was flying with an instructor (CFI), who had an expired medical certificate. The CFI stated he was flying as a safety plt only. The PIC extended his downwind leg & subsequently was low & slow on a long final apch. He raised the nose of the…NTSB DEN88LA209Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Questa, NMThe private plt and 1 pax were taking off using 2,500 ft of a 4,000 x 50 ft dirt strip with a d/a of 9,200 ft. during intial climb the plt noticed a sink rate. The plt said he varied the angle of flaps from 5 to 25 deg 'in search of lift.' The right wing and…NTSB DCA88RA108Accident · No injuriesForeign investigationBoeing 757 · Alajuela, Costa RicaNTSB BFO88FA085Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Clarksville, VAInflight loss of control as a result of pilot disorientation when the pilot tried to conduct VFR flight into IMC. Low clouds, poor visibility, fog and poor decision are contributing factors.NTSB ANC88LA148Accident · No injuriesLimited investigationFinal reportBell 212 · Deadhorse, AKThe pilot encountered a whiteout condition and elected to land on a frozen lake approximately 3 miles southwest of the airport. After touchdown on the ice, the helicopter broke the ice and rolled over on its back. The helicopter was destroyed by ground fire.NTSB NYC88DGM02Accident · Serious injuriesFinal reportBarker Quickie Q2 · Martinsburg, PAThe pilot reported he was practicing takeoffs and landings, and that he was 'determined to hold the approach speed to 80 and rate of descent to 500 feet per minute . . .' The approach was flown at dusk as light was beginning to fail. The pilot stated, 'I…NTSB MKC88LA181Accident · No injuriesLimited investigationFinal reportBeech 77 · Friendship, ARThe CFI rprtd he was demonstrating an emergency landing to a pvt rated plt & confusion (about who was flying the acft) resulted in a commitment to land. The landing was made on a gravel road. During the roll-out, the acft veered into a ditch & was damaged.NTSB CHI88LA242Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Akron, OHOn taxiing in from landing on a dark night, the pilot inadvertently taxied off the pavement onto a grassy area. When he realized that he was off the pavement he made an attempt to return to the pavement and encountered a 20' hole. The main gear sank into the…NTSB BFO88LA086Accident · No injuriesLimited investigationFinal reportCessna 172M · Keysville, VAAircraft overran the runway after the pilot aborted the takeoff because the aircraft did not accelerate to takeoff speed. A contributing cause is inadequate prelight planning. A contributing factor is upsloping high grass covered terrain and failure to use…NTSB ATL88FA256Accident · 2 fatalField investigationFinal reportBellanca 14-19-3 · Oak Grove, ALNTSB NYC88LA244Accident · No injuriesLimited investigationFinal reportCessna 177 · Machias, METhe plt was practicing night takeoffs and landings. He stated that he had successfully accomplished two full stop landings. After the third landing, he applied full power to execute a go-around. The pilot said the airplane pulled to the left so he reduced the…NTSB LAX88DVM04Accident · No injuriesFinal reportWeatherly 201B · Soledad, CAThe pilot stated that after detecting smoke in the cockpit he turned off all electrical switches and made one more spray pass. After the pass, smoke became visible from the engine and part of the cowl separated. The engine lost power and the pilot executed a…NTSB NYC88LA243Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Keene, NHThe plt received a head inj and was not able to relate the details of the acdt. The acft crashed into trees about 3 mi short of the landing rwy at the conclusion of a cross country flt. An FAA insp examined the wreckage and reported that the fuel selector was…NTSB NYC88LA242Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5B · Roscoe, NYThe plt said the eng lost power during takeoff past mid-field and he initiated an abort. The acft was unable to stop in the remaining rwy and collided with a dirt embankment past the end of the rwy. The owner of the acft is a student plt and was the passenger…NTSB NYC88DHM02Accident · Serious injuriesFinal reportAir Command 532 · Stormville, NYThe acdnt occurred as the non-certificated plt was operating the non-registered gyroplane in the traffic pattern. Witnesses heard a 'loud crack.' They then observed the gyroplane descending in an apparent unusual attitude. The gyroplane collided with trees,…NTSB MKC88LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bertrand, NEThe plt rprtd that while practicing takeoffs & ldgs, he believed he had excessive ground speed & elected to go around. He said he waited to long to go around, so he decided to fly under power lines, located at the dep end of the strip. Shortly after lift-off,…NTSB MIA88LA274Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Groveland, FLThe acft crashed into the trees at the end of the rwy while on initial climb after sustaining complete eng failure. FAA personnel attempted to test run the engine after the accident, but were unable to due so due to an air leak on the gascolator. When upward…NTSB SEA88LA189Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Toledo, WAThe plt took off from an uncontrolled strip in marginal wx conds, believing he could affect a departure to good VFR conds. Shortly after takeoff, he enctrd solid IMC & momentarily lost control of the acft. After regaining control & having lost altitude, he…NTSB NYC88LA241Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Millbrook, NYThe private plt-in-command was seated in the right seat and his commercial plt-pax was seated in the left seat. The plt in command was at the controls. The acft was on final apch. The plt said the wind was from 170 deg. He did not give the wind velocity. He…NTSB MKC88LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cameron, MOThe student pilot said he was practicing short field takeoffs from his pasture, when he stalled shortly after takeoff. The aircraft fell uncontrolled to the terrain causing substantial damage to the wings, fuselage and nose gear.NTSB MKC88LA177Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Omaha, NEThe plt rprtd that when the acft was at aprx 150' to 200' AGL on final apch, the eng lost pwr & would not restart. Unable to rch the rwy, he lndd about 50' short on soft trrn, where the gear collapsed & the acft was dmgd. Only about 12 ounces of fuel was…NTSB MIA88WA273Accident · Minor injuriesForeign investigationPiper PA-23-250 · Staniel Cay, BahamasNTSB LAX88LA328Accident · No injuriesLimited investigationFinal reportCentrair 101 · Vacaville, CAThe pilot flew over a field at 700 ft. a.g.l. to see if it was safe for landing. He turned the glider to establish a downwind leg. He then turned to the base leg. While turning onto final approach at a low altitude, the glider pitched up and rolled to the…NTSB FTW88DPA10Accident · No injuriesFinal reportBell 206L-1 · Fort Worth, TXThe rated helicopter pilot was undergoing recurrent training with an instructor at a training field. During a practice autorotation to a landing, the helicopter went into a high sink rate with a low main rotor RPM. The helicopter touched down hard in a tail…NTSB CHI88LA245Accident · No injuriesLimited investigationFinal reportCessna 150F · Baraboo, WIWhile landing on a sod strip with an 11 knot quartering tailwind, the aircraft drifted to the left of the runway and encountered uneven terrain. The pilot reported that he failed to maintain directional control and was unable to avoid a ditch with standing…NTSB CHI88FA244Accident · 1 fatalField investigationFinal reportPiper PA-28 · Hutchinson, MNFailure of the student rated pilot to use proper control inputs and procedures to regain and maintain control of the airplane while executing a go-around from a bounced landing. The pilots lack of total experience is a contributing factor in the cause.NTSB ATL88LA255Accident · No injuriesLimited investigationFinal reportCessna 150 · Bessemer City, NCThe pilot reported that he had observed a cloud layer forming along his flt route. At about the same time, the acft VOR rcvr failed. The plt elected to continue vfr-on-top to his planned destination based on VFR wx reported by an ATIS broadcast from an arpt…NTSB SEA88LA188Accident · 2 fatalLimited investigationFinal reportSvensson Bushby Mustang II · Everett, WAJust prior to the acdnt, witnesses saw the acft in a steep, high speed descent. Impact occurred in soft, marshy terrain & much of the wreckage was buried. No mechanical reason was found for a loss of control; however, the acft was extensively damaged drg…NTSB NYC88LA240Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Burlington, CTThe plt was attempting to land at the mountain arpt. Patwas indicated the winds were from the north at 15 KTS. Gusts were not reported. The plt made her apch at 70 mph IAS and with 20 deg of flaps deployed. As she flared the acft, she encountered a gust of…NTSB MIA88LA276Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bunnell, FLWhile taxiing to takeoff after lndg, the left main lndg gear collapsed. The acft slid to stop. Examination of the acft revealed the lndg gear microswitch failed internally. The landing gear handle was down gut no determination could be made as to its position…NTSB FTW88DRG13Accident · Serious injuriesFinal reportBingelis T-40 · Georgetown, TXThe pilot's inability to maintain control of an aircraft that he had never flown before, as well as, his inability to apply remedial action as required for the flight regime.NTSB FTW88DPJ13Accident · Serious injuriesFinal reportNord 1101 · Ardmore, OKImmediately after liftoff, the airplane abruptly turned left, nosed down, and struck the ground. Examination of the electrical pitch control of the propeller revealed the propeller blades to be in the high pitch, low RPM position. Due to extreme damage of the…