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 SEA87LA193Accident · No injuriesLimited investigationFinal reportCessna 340A · Tecopa, CAA dual engine failure occurred after the first reduction in power at about 200 feet AGL. The aircraft then descended to the ground. No mechanical reason for the loss of power could be determined.NTSB MIA87LA258Accident · No injuriesLimited investigationFinal reportAero Commander 560-F · Opa Locka, FLThe plt stated that he had just completed his third touch & go ldg when the gear collapsed while the acft was on the rwy. A plt/mechanic who assisted in removing the acft from the rwy stated that just after the accident, he peered into the cockpit & observed…NTSB FTW87LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXDrg a practice touch-&-go landing, the plt raised the flaps after making a normal lndg & applied full power for a go-around. However, the acft veered off the left side of the rwy & contacted soft ground. Subsequently, the nose gear collapsed & the left wing…NTSB ATL87LA261Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Winston Salem, NCThe stu plt discussed a cross country flt with his CFI, but did not get a sign off nor give a date for the flt. He then rented an acft and departed on the flt. During the flt, the com radio's became inop. The operator and the CFI were called from an enroute…NTSB MKC87LA177Accident · Minor injuriesLimited investigationFinal reportBeech A23A · Wentzville, MOThe airplane became airborne after 1000 feet. A witness stated that after climbing to abt 10 feet, the right wing dropped almost to the ground. The acft then pulled up sharply to almost vertical and stalled at abt 75 feet above the ground and collided with a…NTSB MIA87LA252Accident · No injuriesLimited investigationFinal reportCessna 150M · Belle Glade, FLThe student plt stated he was en route along the hillsborough canal when he enctrd a rain shower & retarded the power to 2000 RPM to dscnd. He stated that carb ice formed & the eng lost power. He made a forced landing on a dike. However, as the acft was…NTSB MIA87FA257Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Geneva, FLFlt experienced engine failure when the number six connecting rod separated from the crankshaft after failure of the connecting rod bearing. During an attempted forced landing during darkness the acft collided with trees and then crashed to the ground.…NTSB FTW87DPJ09Accident · Serious injuriesFinal reportG&C Helicopters EL Tomcat MK5A · Marlow, OKPilot failed to see and avoid tree at end of swath run during a spraying operation. After contacting the tree, the helicopter started to spin and struck the ground in an approximate 90 degree right bank and started to burn.NTSB BFO87DID04Accident · No injuriesFinal reportBennetter-Stevens Starduster · Roanoke, VAThe plt went on an orientation flt in the home built starduster. Drg the lndg, the acft touched down at about 40 mph. The plt stated that as it slowed to about 25 mph, the 'right brake or something locked, plane pulled hard right, then up on nose & over on…NTSB ATL87LA265Accident · No injuriesLimited investigationFinal reportCessna 172 · Murfreesboro, TNDuring a practice landing the aircraft bounced three times which resulted in the failure of the nose gear structural support. The pilot said that he experienced gusty wind conditions prior to touchdown. The pilot did not properly compensate for or anticipate…NTSB SEA87FA190Accident · 3 fatalField investigationFinal reportCessna T210L · Hailey, IDAfter dark night takeoff, acft was observed to execute an immediate left turn up a canyon into rising terrain. During climb, acft lights were seen to perform maneuver characteristic of stall/spin. Investigation showed acft struck terrain slightly nose low. No…NTSB MIA87LA253Accident · No injuriesLimited investigationFinal reportCessna TU206F · Tavernier, FLThe acft ditched in the atlantic about 40 mi e of Tavernier, FL during an extended overwater flt to georgetown, Bahamas. The acft sank after the accident & the plt & his pax were rescued by the USCG unharmed. The fixed base operator where the acft departed,…NTSB LAX87LA349Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Monica, CAThe student pilot, on his first supervised solo flight, executed two full stop landings without incident. On the next landing, the student pilot stated that the aircraft apparently caught a gust of wind and ballooned. He indicated that he over-corrected and…NTSB LAX87DVA12Accident · No injuriesFinal reportGrumman G164B · Buttonwillow, CADuring an aerial application flight, after pulling out of a pass over a field the plt heard a loud bang followed by severe engine vibration. The acft lost power and the pilot made a forced landing in a plowed field. During the landing roll the acft nosed…NTSB CHI87LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Hillsdale, MITkof and climb to 7000 ft were made on the left fuel tank. Shortly after lvl-off, the plt switched to the rt tank and stayed on it during the initial cruise. The plt then switched back to left tank and abt 10 min later the eng began to lose pwr. Readings were…NTSB CHI87FA219Accident · 1 fatalField investigationFinal reportBeech H-18 · Rockford, ILThe commercial pilot was on a repositioning flight from kenosha, Wisconsin to atlanta, Georgia, after having been without sleep for about 20 hours. Witnesses observed the aircraft circling a subdivision near Rockford, Illinois at a low altitude, just above…NTSB CHI87DEX09Accident · Serious injuriesFinal reportde Havilland Dragonfly DH-90 · Sellersburg, INAircraft began left drift during takeoff roll. Pilot corrected with right rudder, and aircraft veered sharply right. Aircraft did not respond to application of left rudder or increased thrust from right engine; departed runway and crashed into drainage ditch.…NTSB ANC87LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Talkeetna, AKThe airplane was substantially damaged after it nosed over during the takeoff roll, but the pilot and his passenger were uninjured. The pilot stated that he had landed at an off-airport site to set up his moose hunting camp and that during a subsequent…NTSB SEA87LA191Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Las Vegas, NVThe aircraft was on descent for landing at 6500 feet MSL about 5 miles from the airport when a total loss of power occurred due to fuel exhaustion. At 5000 feet AGL the pilot lowered the landing gear and at about 2000 feet AGL landing flaps were added. The…NTSB MKC87LA176Accident · Minor injuriesLimited investigationFinal reportEllsworth Varieze · Lebanon, MOThe PIC was back-taxiing down rwy 18 with a planned dept to the north. The PIC stated that he applied brakes in order to modify his direction during the taxi, but the brake failed to compensate. The PIC further stated that he applied more pwr in an attempt to…NTSB MIA87LA254Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Bristol, FLThe eng began losing power as the plt was en route to spray a field. He was unable to maintain altitude, dumped the load of chemicals & prepared for an emerg landing. While he was attempting to reach an open field, the acft collided with 100 foot trees, then…NTSB MIA87IA256Incident · No injuriesIncident investigationFinal reportGates Learjet 36A · Tyndall Afb, FLThe captain aborted the takeoff at 124 KTS after hearing an explosive sound, feeling the aircraft swerve, and seeing debris from a main wheel rim and brake being thrown forward of the aircraft. The aircraft continued down the runway, barely controllable and…NTSB FTW87FA223Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Greenwood, LAThe pilot touched down briefly in a small clearing which he had prevously driven to by automobile. He then lifted off and started a climbout. Two separate electrical power lines were located just inside a tree line which was very close to the previously…NTSB DEN87DTI02Accident · No injuriesFinal reportBakeng Deuce · Gillette, WYThe plt rprtd that on each of his 1st 3 attempts to land, he began losing directional control during roll-out & went around. On the 4th attempt, he again tried to go around, but the acft swerved off the rwy & ground looped, collapsing the left main gear &…NTSB ANC87LA166Accident · No injuriesLimited investigationFinal reportCessna 170A · Melozitna River, AKThe pilot attempted to takeoff from a River sandbar close to the water's edge. During the take off roll, one main landing gear tire entered the water and pulled the airplane into the water. The airplane subsequently nosed over and incurred substantial damage.NTSB ANC87FA165Accident · 5 fatalField investigationFinal reportPiper PA-31-310 · Eldred Rock, AKThe flt was clrd on an IFR flt fm whitehorse to juneau, via V-428 to chill intxn, then drct to juneau. Chill intxn was located on V-428, 36 mi south of haines NDB on a bearing of 146 deg. On reaching haines NDB, the plt cancelled his IFR clnc & contd under…NTSB NYC87LA261Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Fitchburg, MADrg arrival, the plt was clrd for an ndb-a apch to Fitchburg muni arpt. The NDB was located on the arpt & the arpt elev was 350'. The min dscnt alt (mda) was 1140' MSL. The apch procedure was to go outbnd fm the NDB on a 137 deg bearing, make a procedure…NTSB MKC87LA174Accident · No injuriesLimited investigationFinal reportCessna 120 · Creighton, NEThe flt dptd harvard, NE., with a dest of wausa, NE abt 1 hrs flying dist to the northeast. The departure commenced abt 1 hr and 40 min's prior to dark. The PIC stated he encountered strong headwinds along the route which delayed his progress. The acft…NTSB LAX87LA345Accident · No injuriesLimited investigationFinal reportCessna 180K · San Diego, CAA Cessna 180K dragged its' wing tip during landing roll on runway 28R. The pilot indicated that he encountered a wind gust from the left raising the right wing. The pilot stated that he 'over corrected' in that when the gust subsided the aircraft rolled left…NTSB LAX87LA344Accident · No injuriesLimited investigationFinal reportCessna 150 · Marana, AZThe student pilot lost control of the airplane during landing roll on rwy 30. He indicated that the winds were from 280 deg at 9 KTS gusting to 12 KTS. The airplane veered right departing the rwy. The nose gear subsequently collapsed in rough and uneven…NTSB LAX87LA343Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tucson, AZA Piper PA-28-180 collided with a tree after veering off runway 15. The pilot indicated that he encountered a right crosswind during the landing roll and veered off the left side of the runway. The aircraft's left wing then struck a tree severing it from the…NTSB LAX87LA340Accident · Serious injuriesLimited investigationFinal reportPiper JC3-65 · Sacramento, CAThe pilot was observed to be flying at a very low altitude by two separate witnesses. They stated that he was flying and maneuvering at approximately 15-20 feet AGL and buzzing powerlines. The pilot stated that he can not remember what happened and that the…NTSB LAX87FA341Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Sonoma, CAThe 70-hour student plt had recently passed the pvt plt written exam & had completed most of the flt trng for certification. He was looking forward to becoming a licensed plt. While on a personal flt, the plt flew over his brother's residence & was observed…NTSB FTW87FA222Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Jackson, LAJust prior to the acdnt, witnesses observed the acft flying at low alt over a creek. They rprtd the acft went into a steep climbing left turn from about 40 to 75 ft AGL, then it entered a steep descent & crashed in the creek. No eng problems or changes in the…NTSB DEN87LA242Accident · No injuriesLimited investigationFinal reportMooney M20K · Aspen, COWhile on a cross country pleasure flt the acft engine failed apx four miles short of the dest aprt. A forced landing was made in a field.NTSB CHI87LA220Accident · No injuriesLimited investigationFinal reportCessna 172RG · Pinckneyville, ILAccording to the instructor (CFI), he & the student confirmed the gear was extended & locked as they entered the traffic pattern. Flaps were extended & they contd in the pattern to practice a short field landing technique. Power was reduced after crossing…NTSB CHI87LA218Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Grayslake, ILThe aircraft landed off the right side of the runway on a dark night when the pilot was unable to identify the intended landing runway. The aircraft landed in soft turf and during subsequent loss of control, turned right and nosed down into a ravine. The…NTSB CHI87LA216Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Washington, INThe pilot was landing the aircraft, after returning from a personal cross-country flight, when he encountered a crosswind gust and 'veered strongly to the right.' The pilot then decided to abort the landing and proceeded to add full power for a go-around.…NTSB CHI87LA215Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Belleville, INThe aircraft was returning to an unlighted private airstrip after a local pleasure flight. The sun had set but, according to the pilot, the sky was still illuminated. The pilot stated he was able to set up an approach, but when established on final he 'lost…NTSB CHI87LA214Accident · No injuriesLimited investigationFinal reportBeech E55 · Green Bay, WIThe plt intended to land long on rwy 36L since he parked the acft near the north end of the field. He stated that he flew over the rwy at an alt of aprx 30 ft until near the intx with rwy 6/24, then he retarded the throttles & adjusted the trim for landing.…NTSB BFO87LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Roanoke, VARoanoke tower cleared the aircraft for landing and the pilot pulled the power to idle. The pilot did not realize the engine had quit until he applied power on short final and the engine did not respond. The aircraft struck short of runway 33. The pilot stated…NTSB ANC87LA164Accident · No injuriesLimited investigationFinal reportInterstate S-1B2 · Beluga River, AKThe pilot landed on a small lake, decided it was too small and attempted to take off. He was unable to attain lift off speed prior to striking the opposite bank with his floats and subsequently damageing the airplane.NTSB SEA87LA189Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cathlamet, WAThe pilot was making soft field takeoffs with no flaps. He lost control of the aircraft at about 10 feet AGL, the aircraft's right wing struck the ground and the aircraft came to a stop.NTSB MKC87LA175Accident · No injuriesLimited investigationFinal reportCessna 180B · Atkinson, NEWitnesses stated that the pilot was chasing a wild horse out of an alfalfa field and back into a corral when a wingtip struck a grove of trees and the aircraft cartwheeled onto the ground. The pilot stated to FAA that he did not see the treeline due to…NTSB MKC87LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Festus, MOThe CFI was giving inst to a pvt plt who was undergoing a biennial flt review. The pvt plt cmpltd the maneuvers and ret to the arpt. The lndg was aborted and a go-around was made. The CFI took control and executed another appch. The pvt plt was to monitor an…NTSB MIA87FA250Accident · 3 fatalField investigationFinal reportCommonwealth 185 · St. Petersburg, FLThe pilot of the Commonwealth erroneously reported his positon to the tower for landing instructions. He then failed to follow the instructions and collided with a Beech 23 acft that was on downwind to land at albert whitted airport. Both aircraft involved in…NTSB ATL87LA263Accident · No injuriesLimited investigationFinal reportCessna 140 · Jesup, GADuring initial takeoff the aircraft's engine lost power and the aircraft collided with the ground. Investigation revealed the carburetor inlet filter was 50 percent plugged with rusty material and two tablespoons of rusty water remained in the carburetor…NTSB ANC87LA162Accident · No injuriesLimited investigationFinal reportCessna 206G · 100mi S.Kng Slm, AKThe aircraft experienced an engine power loss while in cruise flight and subsequently undershot a lake during the emergency landing. Examination of the engine revealed the number 2 bearing was found completely disintegrated and missing from its seat. Evidence…NTSB NYC87LA259Accident · No injuriesLimited investigationFinal reportBeech 23 · Montpelier, VTDuring a landing, the aircraft bounced and the student pilot attempted to correct the situation. However, the aircraft touched down and bounced again, then became uncontrollable. Subsequently, it veered off the left side of the runway and hit a parked Cessna…NTSB NYC87FA260Accident · Serious injuriesField investigationFinal reportBoeing 737 · Philadelphia, PAThe acft was in a holding pattern at 11,000' in an area of thunderstorms & turbulence. Although the seat belt sign was on, two passengers (pax) went to the aft lavatory. As one of the pax was waiting & the other was exiting the lavatory, the acft encountered…