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 CHI87LA190Accident · No injuriesLimited investigationFinal reportCessna 150 · Wheeling, ILThe student plt was on her fourth supervised solo making touch-&-go lndgs. Drg a lndg, the acft ballooned, then touched down hard. The nose gear collapsed, & subsequently, the acft came to rest off the left side of the rwy.NTSB CHI87LA180Accident · No injuriesLimited investigationFinal reportHughes 369HS · Griffith, INThe tail boom of the helicopter was severed after rotor blade contact during a hard landing. The acc occurred during an autorotation demo for the police dept with a power recovery. Application of power was late and the helicopter landed hard and bounced. The…NTSB ATL87DKG05Accident · No injuriesFinal reportSchweizer G-164A · Summerdale, ALThe pilot was about to engage in an aerial application operation. During climb the engine lost power, the chemical load was dumped and the airplane was landed in an adjacent field. On rollout the airplane hit a ditch and nosed over. Examination of the engine…NTSB MKC87LA147Accident · No injuriesLimited investigationFinal reportCessna 188B · Fairfield, NEShortly after takeoff for an aerial application flight, the aircraft began to settle. The left wing struck the ground and the aircraft turned 180 degrees. Temperature was 95 degrees f and density altitude 4000 feet. The pilot stated he 'could have dumped some…NTSB MIA87LA216Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · St Petersburg, FLAfter climbing abv 3000' drg an instrnl flt, the instructor (CFI) had the student lower the gear & flaps to a takeoff configuration & slow the acft below VMC (72 KTS). The CFI then shut off fuel to the left eng. The student followed the correct procedures to…NTSB MIA87FA217Accident · Serious injuriesField investigationFinal reportCessna 185F · Hollywood, FLThe plt stated that he performed a thorough preflight of the acft to include the draining of the sumps & fuel strainer and no water was found. After takeoff while on the downwind leg, the eng quit. The plt attempted to return to the airport; however, the acft…NTSB LAX87DVA10Accident · No injuriesFinal reportGrumman G-164B · Taft, CADuring a repositioning flight, the plt landed the aircraft on a dirt road. During the landing roll the left wing struck an irrigation standpipe. The aircraft turned rapidly which collapsed the main landing gear. There were no mechancial failures or…NTSB FTW87LA180Accident · No injuriesLimited investigationFinal reportDouglas DC-3A · Laredo, TXThe left engine failed during initial climb immediately after liftoff. Airspeed could not be maintained with one engine out due to the fact that the aircraft was climbing slowly just above the surface and was loaded to 3,809 pounds above its maximum allowable…NTSB DEN87LA201Accident · No injuriesLimited investigationFinal reportCessna 152 · Lafayette, COCFI was demonstrating eng out emerg landing and allowed acft to descend into tall weeds before adding power which was insufficient to overcome drag of weeds on gear. Acft struck bank and fence separating prop and right main gear. Hull and cowling were buckled…NTSB DEN87LA199Accident · Serious injuriesLimited investigationFinal reportBell 204B · Dubois, WYThe commercial plt was performing external sling loads in support of seismic operations. The plt reported that the engine failed during a load release and the plt executed an autorotation. This resulted in a hard landing in heavy timber on sloping terrain.…NTSB CHI87LA178Accident · No injuriesLimited investigationFinal reportRobinson 22 · Minnetonka, MNWhile attempting to land on a flat spot on top of a hill the tail rotor hit the ground and the tail boom broke off. One witness reports that when the helicopter touched down it bounced up about 10 feet. No mechanical malfunctions were reported.NTSB CHI87FA177Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Morris, MNThe plt was ferrying the acft from Ohio to Alaska. While en route, he stopped & refueled at Morris, MN. After he took off, the plane crashed in an open field about 1/2 mi from the arpt. No known witnesses saw the acdnt, but a passerby found the acft on its…NTSB NYC87LA220Accident · No injuriesLimited investigationFinal reportAerospatiale AS350D · Nantucket, MAThe flight was enroute from Nantucket to hyannis when the pilot heard a loud bang followed by a severe vibration, loss of power to the main rotor system, and a loss of hydraulic pressure. The helicopter made an autorotative landing in water about 25 feet in…NTSB LAX87LA285Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Kernville, CADuring a solo instructional flight, the student plt was attempting a landing with a 6-10 knot crosswind. While on final approach with full flaps and pwr off, the plt stated that over the threshold at aprx 10 ft AGL in the flare configuration, a gust of wind…NTSB DEN87LA212Accident · No injuriesLimited investigationFinal reportCessna 414 · Cuba, NMThe acft was dispatched to the Cuba, NM area to pick up a critically ill patient. The state police blocked off a section of highway for the acft to land on. The plt landed on the highway, but drg the landing roll, the underside of the rgt wing struck a road…NTSB DEN87LA200Accident · No injuriesLimited investigationFinal reportCessna 185A · Hillsboro, NDThe pvt plt was receiving dual instruction for the purpose of a checkout in the Cessna 185. The dual student landed the acft on runway 34 with a right crosswind. During the landing roll the acft began to 'weathervane' and the rt wing began to rise. Remedial…NTSB DEN87LA197Accident · No injuriesLimited investigationFinal reportCessna 172RG · Aspen, COThe plt said that because of thunderstorm activity in the local area he was distracted from concentrating on his flying. During his landing approach, he failed to extend the landing gear and landed the aircraft wheels up.NTSB DEN87LA196Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fargo, NDPlt installed new aerial application chemical tank. The tank was filled with water for a test flight. Plt could not hold nose down after takeoff. Acft stalled into trees and landed in field beyond trees. Acft nosed over and damaged fuselage and vertical…NTSB NYC87DNE04Accident · 1 fatalFinal reportPiper PA-28-180 · Groton, CTShortly after the aircraft departed the airport, air traffic control personnel received a distress call from the non-pilot rated passenger. She stated that the pilot (her husband) was incapacitated by an apparent heart attack and she was not qualified to fly…NTSB MKC87FA148Accident · 1 fatalField investigationFinal reportWatts 532 Elite · Davenport, IAWitnesses located 1/4 mi north of the accident site, observed the gyrocopter departing the Davenport, IA airport and turning to the southwest. While in cruise flight the witnesses observed the aircraft moving in an up and down motion prior to what appeared to…NTSB LAX87DJA07Accident · No injuriesFinal reportEmair MA-1B · Pahala, HIAt the end of an aerial application flt, the plt reported that after approaching the arpt in a light rain, he failed to keep the acft centered on the rwy. The acft exited the rwy to the left where it collided with the terrain and nosed over. There were no…NTSB FTW87FA179Accident · 1 fatalField investigationFinal reportStinson 108-3 · Kirbyville, TXThe pilot approached the Kirbyville airport in preparation for landing, witnesses stated that smoke was observed coming from the engine area. The aircraft impacted 30 foot pine trees, & control was lost. The aircraft struck a large tree approximately 5 feet…NTSB FTW87FA177Accident · Minor injuriesField investigationFinal reportAero Commander 520 · Carrollton, TXAcft was destroyed when it struck pwr lines and the grnd during a single eng go-around. Following a left eng shut down due to severe vibrations, the plt overflew one arpt to return to his home base. En route, he elected not to go to full pwr due to a 3 min…NTSB ANC87LA111Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Nikolai Creek, AKThis pilot stated he did not fully understand crosswind operating procedures. When he encountered a crosswind during takeoff he allowed the aircraft to drift to the left off the runway and groundlooped.NTSB ANC87FA110Accident · Minor injuriesField investigationFinal reportCessna 182P · Anchorage, AKThere was hvy traffic when the plt of N1946M contacted Anchorage (anc) intl twr for lndg instrns at the lake hood strip. Anc twr ctld traffic at the nrby lake hood strip & lake hood seaplane base, as well as at the anc intl arpt. The wnd at lake hood had been…NTSB NYC87LA211Accident · No injuriesLimited investigationFinal reportCessna 310 · Wrightstown, NJThe instructor (CFI) & multi-eng commercial plt (student) were on a flt for a check-out in the Cessna 310. Drg a single eng go-around, the student increased the pitch attitude excessively & the airspeed decayed. The CFI took control of the acft & increased…NTSB NYC87LA206Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Palmyra, PAThe Cessna 210 was cruising enroute when it experienced a loss of power which the pilot attributed to low fuel/ exhaustion. He then attempted an approach at reigle fld but was too long and went around. On his second approach, he was again high and long, and…NTSB NYC87FA209Accident · 1 fatalField investigationFinal reportCessna 182 · Poestenkill, NYThe non-instrument rated plt was on a flt to psn the acft for sky diving activities. As he was transiting the albany arpt radar svc area at 5500', radio and radar ctc were lost. Subsequently, the acft crashed in a steep dive and was demolished by impact. Psnl…NTSB NYC87DNC11Accident · No injuriesFinal reportBeech C23 · Vergennes, VTThe pilot of the Beech C23 had taken off and was returning to the airport due to deteriorating weather conditions. The pilot attempted to land on runway 20, but made a go around because of gusty winds. On the second attempt to land on the same runway, the…NTSB MIA87LA215Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Atlantic Ocean (Atlantic Ocean)The flt was aprx 43 miles west-northwest of freeport, Bahamas, en route to fort lauderdale, FL when the plt observed theengine oil pressure gauge indicating zero pressure. He reversed course back to freeport, contacted miami radio and gave his location. The…NTSB LAX87LA334Accident · 1 fatalLimited investigationFinal reportCessna 206 · Williams, AZThe aircraft was reported stolen on July 26, 1987. It is believed that the aircraft departed the grand canyon airport in grand canyon, Arizona on July 26, 1987, at 0300 MST. A search of records or airports in the area revealed that the aircraft was refueled…NTSB LAX87LA284Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Tucson, AZDuring a local sightseeing balloon flight, the plt was making a landing at an open construction site. The gondola touched down then skipped three times and came to rest on the edge of a ledge aprx 10 ft in height. The balloon tipped over the edge and collided…NTSB LAX87DVM05Accident · Minor injuriesFinal reportScharschmidt LONG-EZ · Paso Robles, CAShortly after take-off on runway 01 the engine lost all power. Having gained 500' AGL the pilot attempted to turn 180 degrees and land on runway 19. Realizing he wouldn't make it to runway 19, the pilot decided to attempt to land in an open field to the…NTSB FTW87LA181Accident · No injuriesLimited investigationFinal reportCessna 150L · Rockwall, TXAs the acft touched down, the rgt main wheel contacted a rut in a soft area of the rwy & the acft veered to the rgt. To avoid hitting parked acft on the west side of the rwy, the plt added full power & left rudder & aileron. He stated that as the acft left…NTSB FTW87LA178Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Aransas Pass, TXThe plt rprtd that drg a takeoff roll, the acft encountered a gust of wind from the left which caused it to veer off the right side of the rwy. Subsequently, it contacted a ditch & was damaged.NTSB FTW87LA176Accident · No injuriesLimited investigationFinal reportPiper PA28R-201 · Houston, TXAccording to the pilot, during takeoff roll, and at the point of rotation the nose gear failed, causing the aircraft to drop down striking the runway with the prop. The aircraft then became airborne for approx. 15 sec. The pilot landed the aircraft on an…NTSB FTW87DPA04Accident · No injuriesFinal reportRoe/Pietenpol Aircamper · Arlington, TXAs the plt was landing, he applied excessively hard braking & the acft nosed over. No pre-acdnt part failure or malfunction was evident.NTSB DEN87LA195Accident · No injuriesLimited investigationFinal reportCessna 182L · Aberdeen, SDThe plt was taking off on rwy 13 at Aberdeen, SD, muni arpt. He said when he reached 55 mph he rotated the acft and the stall warning horn sounded. He said he allowed the nosewheel to settle back on the rwy. The acft then veered right and left, then departed…NTSB DEN87LA194Accident · No injuriesLimited investigationFinal reportCessna 172D · Custer, SDThe plt and his plt-rated pax were landing on rwy 7 (4700 ft x 50 ft) at Custer county arpt (5602 ft MSL), Custer, SD. The plt estimated the winds to be from 180 deg at 15 KTS. Another plt at the arpt estimated the winds to be out of the se at 20 to 25 KTS…NTSB CHI87DEM11Accident · Minor injuriesFinal reportCessna 182K · Paw Paw, MIThe aircraft experienced an uncontrolled descent into a hangar on takeoff. The aircraft was substantially damaged and the pilot and two of his three passengers received minor injuries. The pilot attempted takeoff from a 1320' grass strip with 7' high grass.…NTSB ATL87LA225Accident · Serious injuriesLimited investigationFinal reportNorth American AT-6G · Clanton, ALThe airplane engine loss pwr shortly after takeoff, and the plt turned back toward the arpt. The airplane crashed approx 1200 ft short of the rwy in a clearing. The plt reported that he had departed the arpt with the fuel selector in the 'off' position.NTSB ATL87FA223Accident · 2 fatalField investigationFinal reportCessna 150G · Circleville, OHAprx 35 min after the acft tkof, witnesses observed it in what they described as erratic flt. One witness rprtd the acftflew over a vacant field where it entered a steep climb, then stalled & impacted the gnd in a steep nose down attitude. No preimpact part…NTSB ANC87LA113Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Happy Valley, AKThe aircraft struck the mountain at the 4000 foot level. At the time of the accident several witnesses stated that the weather was IFR, low ceiling, ground fog, and the prevailing visibility was less than one mile.NTSB ANC87LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Levelock, AKAs the pilot of the Piper PA-18 airplane was completing his landing roll at the unattended airport, three children, riding an all terrain vehicle (atv), pulled onto the runway and were struck by the right side of the acft. The pilot attempted to avoid the…NTSB ANC87LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dillingham, AKDuring an approach for landing the float equipped airplane stalled at a higher than normal indicated airspeed. The pilot was unable to effect recovery and the airplane crashed in wet tundra. The wind at shannon pond at the time of the accident was described…NTSB ANC87LA106Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kenai, AKThe pilot of the float equipped airplane attempted to takeoff in crosswind conditions that exceeded the demonstrated capability of the aircraft. The pilot stated that while taking off to the north, with winds out of the west gusting to 20 knots, the right…NTSB ANC87FA107Accident · No injuriesField investigationFinal reportMaule M-6 · Anchorage, AKThe pilot lost directional control while landing with a quartering tailwind from the left. The aircraft ground looped and struck a chain link fence. The pilot stated that he found the brake shaft broken at the shaft reduction retaining clip point. He…NTSB SEA87LA148Accident · No injuriesLimited investigationFinal reportCessna 150G · Gresham, ORDuring the student pilot's long solo cross-crounty a loss of power occurred. During the forced landing the pilot overshot the intended field so he selected a nearby field. He overshot this field, flew between 2 trees at 20 feet AGL and descended to the…NTSB MIA87LA214Accident · No injuriesLimited investigationFinal reportBoeing 747-287B · Miami, FLDuring lndg the entire length of the rwy was used due to an inop no 2 eng reverser. Only brakes were used to slow down the acft and taxi to the gate. The plt stated that he had arrived at the gate, set the parking brake, and was notified that the wheel chocks…NTSB LAX87LA283Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Galt, CADuring the takeoff ground roll on a 2000 ft private runway, at the point to rotate, the plt applied back pressure, however, the aircraft did not respond. Aprx three quarters of the way down the rwy the plt realized that the acft was not lifting off and he…