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 CHI86FER16Accident · No injuriesFinal reportAero Commander Callair A9B · Argyle, MNWhile setting up for a swath run the pilot struck the ground in a wings level descent. He stated that a 'whirlwind' or 'downdraft' prevented him from pulling up in time to pre-vent impact with the ground.NTSB CHI86FEM13Accident · Minor injuriesFinal reportPiper PA-28-140 · Menominee, MIThe acft lost eng pwr shortly after takeoff. The plt attempted to land back on the rwy but ran off the end into a ditch. The reason for the power loss could not be determined.NTSB ANC86LA121Accident · No injuriesLimited investigationFinal reportCessna U206 · Egegik, AKThe pilot stated that during the landing rollout on the gravel bar he lost control of the aircraft causing the plane to nose over on its back.NTSB SEA86LA189Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Rosalia, WADuring climb out the acft entered a departure stall. The acfts left wing dropped and the acft came to rest 90 degrees from its departure heading. This acft has no stall warning system.NTSB NYC86LA193Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Lancaster, PAThe Piper PA-60 Aerostar was making a takeoff with five passengers on board. The PIC did not establish any procedures with his co-pilot prior to the takeoff. The aircraft continued off the 4100 ft runway to the overrun finally becoming airborne. The co-pilot…NTSB MKC86FA166Accident · 1 fatalField investigationFinal reportAttebery-Stainbrook Varieze · Osawatomie, KSWitnesses stated that the aircraft appeared to be operating normally and flying at cruise altitude when, suddenly the left (port) wing separated from the fuselage. Sounds of engine power ceased immediately following the in-flight breakup and the aircraft…NTSB MIA86LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Zellwood, FLThe flt sustained eng failure immediately after lift-off & collided with a tree near the end of the rwy. The plt stated that the take-off roll had been 'sluggish'. He said that it was his practice to keep his acft outdoors & to only fuel the tanks to about…NTSB MIA86LA226Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe acft had been in the air for about 1 hr & was aprching the arpt. While on final aprch, the eng quit & the plt radioed 'mayday,mayday,fuel exhaustion' & ditched the acft in the water. The CFI plt stated that he checked the fuel supply by looking at the…NTSB LAX86MA311Accident · 2 fatalMajor investigationFinal reportBell 206B · Alamo, CAWitnesses reported seeing the helicopter circle twice over a residence at an alt of aprx 50' AGL. Upon initiating the third turn the helicopter entered an abrupt 90 deg bank and nosed down to impact with the terrain. Exam of the helicopter failed to reveal…NTSB LAX86LA316Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Marana, AZA Schweizer sgs 1-35, landed hard after a steep final approach. The pilot indicated that he was high on final approach and initially applied 30 degrees of flaps. He was still too high and elected to use 80 degrees (full) flaps. The aircraft landed hard nose…NTSB FTW86FRA11Accident · Minor injuriesFinal reportThorp Aero 211 · Liberty, TXThe acft collided with a ditch which sheared the nose gear during a forced landing. The plt said he had only flown about 30 minutes since refueling and suspected a fuel problem. He stated that he had checked for water & contaminents during pre-flt but found…NTSB DEN86LA215Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Laramie, WYThe plt stated that a flt from California to Laramie was uneventful. The acft was then refueled and he departed to the east. Shortly after takeoff, the engine began to lose power and the cockpit filled with smoke. The plt executed an emergency landing next to…NTSB CHI86LA196Accident · No injuriesLimited investigationFinal reportPiper PA-20-115 · Mosinee, WIFollowing departure from oshkosh, WI, the plt proceeded directly to central Wisconsin airport, Mosinee, WI, at aprx 2500 ft MSL. After receiving an arpt advisory from the central Wisconsin UNICOM, the plt landed on rwy 26. According to the plt, a 30-35 deg…NTSB CHI86LA195Accident · Serious injuriesLimited investigationFinal reportPiper J-3 · Peoria, ILThe plt reported that the acft stalled on takeoff, control was lost and the acft descended to impact with the terrain.NTSB CHI86FEV04Accident · Minor injuriesFinal reportPate Quickie · Danville, ILAfter performing hi speed taxi tests, the plt of a new home built acft took off on the acft's 1st flt. After taking off,he realized something was wrong; however, by then, the acft was past the dep end of the rwy at 50 to 75 ft AGL & would not climb any…NTSB SEA86LA190Accident · No injuriesLimited investigationFinal reportCessna T210L · Elko, NVDuring landing rollout on runway 23 the aircraft deviated to the right and the pilot corrected first with rudder and then left brake. The aircraft then veered left and departed the runway. The pilot then attempted to initiate a go around and fly out of the…NTSB NYC86LA208Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Hartford, CTThe Beech 24R pilot noticed a build-up of a substance on the windshield. He also experienced a problem controlling the propeller. He said upon landing he could not judge forward visibility and flared high (30-40 ft). The pilot reported that the aircraft…NTSB NYC86FNC07Accident · Serious injuriesFinal reportCessna 150M · Nashua, NHThe CFI had allowed the student to make the takeoff, witness observed the C150 flying above the rwy at approx 75 to 100 ft with 20 degree flaps. Other witnesses stated that the nose was observed to pitch up then the left wing dropped and the acft went from…NTSB MKC86LA165Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hugoton, KSThe PIC stated that the eng quit on takeoff abt 100 feet abv the gnd and 200 yds past the departure end of the rwy. The PIC stated that he had no warning prior to the engine quitting. The acft dscnd to the gnd, impacted hard and subsequently flipped over…NTSB MKC86LA164Accident · No injuriesLimited investigationFinal reportCessna 188B · Hugoton, KSThe PIC stated that he was flying low and slow in an attempt to observe an acft that had just crashed in an open fld off the departure end of the rwy at Hugoton. The acft was then observed to roll left and descend and impact the gnd about 1/4 mile beyond…NTSB MIA86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Crestview, FLWhile on final aprch with the ldg gear extended for ldg, the plt observed another acft ahead of him which he felt he was overtaking. He elected to execute a go-around & while on downwind leg, the plt retracted the gear absent-mindedly thinking he was…NTSB MIA86LA224Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Boynton Beach, FLThe acft was ditched in the atlantic ocean about 4 miles off shore in about 600 ft of water after allegedly sustaining eng failure. The plt stated that the acft was full of fuel prior to departure & that no water or other foreign matter was detected in the…NTSB MIA86LA223Accident · No injuriesLimited investigationFinal reportBeech J35 · Bunnell, FLThe plt stated that he became distracted & forgot to put the landing gear down. He also stated that the landing gear warning horn was inoperative. Post crash examination revealed that the landing gear warning horn microswitch was out of adjustment.NTSB LAX86FVD09Accident · No injuriesFinal reportJaks Volksplane VP-2 · Ukiah, CAAt the end of a local flight, during the landing roll, the plt was distracted and allowed the acft to veer to the right side of the rwy. The plt applied the brakes when the left main landing gear collapsed.NTSB FTW86FRG29Accident · 2 fatalFinal reportCollins Charles A KR-2 · Georgetown, TXAcft was observed to takeoff, circle the arpt and make a low pass down the departure rwy. Following the low pass the acft entered a steep right bank, stalled and nosed over into the ground. During the investigation, no evidence of mech failure or malfunction…NTSB CHI86FA194Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Oshkosh, WIThe aircraft ran out of fuel after 3+41 hours of flight. The pilot stated that he was sure the tanks were full on takeoff. Flight planning and a documented conservative fuel burn rate indicated that the aircraft should have been able to remain airborne for at…NTSB CHI86FA191Accident · 2 fatalField investigationFinal reportHawker Siddeley DH-125-1A · Bedford, INThe plt canceled IFR 8 miles from the arpt to continue on a visual apch and landing. Witnesses stated a strong thunderstorm had just passed over the arpt. Wind info issued to the plt by UNICOM were west at 20 KTS. Witnesses observed the acft apch rwy 31 and…NTSB ATL86LA215Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cumming, GAThe plt reported that he made 3 attempts to land on a short narrow rwy in windy conditions. After the 1st attempt, he changed rwys, based on the UNICOM announcement that the wind favored rwy 3. On the last apch, the plt landed about 1/3 to 1/2 of the way down…NTSB SEA86LA186Accident · No injuriesLimited investigationFinal reportCessna 210 · Hillsboro, ORThe pilot reported that he struck a post on take-off and broke off the main landing gear wheel. The pilot proceeded to Hillsboro, Oregon where an emergency landing was made on a paved runway with the landing gear still extended. The stub caught in the runway…NTSB SEA86FA211Accident · Serious injuriesField investigationFinal reportSchweizer SGS-2-33 · Toledo, WAThe weak link at the tow vehicle broke during launching. The plt lowered the nose of the acft and turned into the wind. The plt stated that the acft was stalled and that he was unable to stop the descent rate. The acft struck the runway in a slight nose down…NTSB LAX86LA310Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Oroville, CAA Cessna 140 nosed over in a ditch after aborting a takeoff. The plt indicated he was practicing stop and go landings. During the last landing the right brake was inadvertently applied and the acft veered to the right off the rwy. The plt initiated a…NTSB CHI86LA197Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Perrysville, INThe acft was substantially damaged during a forced landing in a corn field following a loss of power. Post accident inspection of the acft failed to reveal any fuel in either the fuel tanks or carburetor.NTSB CHI86FEP08Accident · Minor injuriesFinal reportNorth American T28D-FENNEC · Madison, WIAfter the aircraft was initally taxied for takeoff, the pilot returned to the ramp and stated that he was experiencing engine problems. He inquired at an FBO about chartering an aircraft to take himself and his son to an experimental aircraft association…NTSB CHI86FA193Accident · No injuriesField investigationFinal reportCapetown Builders Glasair RG · Fond Du Lac, WIThe pilot experienced a complete electrical system failure that was caused by a broken wire at an alternator terminal. Upon extension of the hydraulically operated landing gear a safe gear down indication was not obtained. Activation of the CO2 operated…NTSB CHI86FA192Accident · No injuriesField investigationFinal reportCessna 177RG · Oshkosh, WIThe IFR flt experienced an engine failure during the landing apch to the destination aprt in Oshkosh, WI, and the plt ditched the acft in lake winnebago. Exam of the acft showed that the eng failed due to fuel exhaustion. The plt reported there were 60…NTSB ANC86LA119Accident · No injuriesLimited investigationFinal reportLake LA-4 · Kotzebue, AKDuring the climbout over the mountain ridge, the aircraft began to lose altitude eventually contacting the edge of the ridge. At the time of the accident strong winds and heavy rain was reported in the area.NTSB ANC86FA118Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKA ground control (gnd ctl) trainee clrd Cessna 152 (C-152), N757WV, to taxi to rwy 6, then relinquished the gnd ctl psn to a full performance level (fpl) ctlr, who had just signed on duty. The fpl ctlr was aware of the lctn & taxi destn of the C-152, the fpl…NTSB SEA86LA187Accident · No injuriesLimited investigationFinal reportBoeing PT13/17 · Vancouver, WAThe plt reported the engine started running rough near woodland, Washington and an approach was set up, but due to many aircraft in the pattern the pilot elected to go to scappose, Washington (about 10 NM south of woodland). At scappose, Washington the pilot…NTSB SEA86LA185Accident · No injuriesLimited investigationFinal reportVarga 2150A · Everett, WAThe plt reported he made an emergency landing in a wheat field following a loss of power due to fuel exhaustion. The acft struck a ditch and nosed over during the landing roll. The plt stated he sould have refueled at the last stop.NTSB LAX86FJA03Accident · Serious injuriesFinal reportBell 47G-3B1 · Lihue, HIThe helicoper crashed into trees while on a local pleasure flight. The pilot indicated that while hovering out of ground effect the main rotor and engine RPM were dropping below the minimum operating limits. The pilot lowered the collective to regain RPM but…NTSB FTW86LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Bartlesville, OKThe plt took off on a test flt after an annual inspn of the acft & a top overhaul of the eng had been completed. While climbing thru about 1200 to 1300 ft AGL, the eng started running rough, then quit. The plt attempted to return to the arpt, but was unable.…NTSB DEN86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Albuquerque, NMWhile taxiing for takeoff in strong gusty wind conditions the aircraft was blown into an inverted position on the taxiway.NTSB DEN86FA213Accident · 2 fatalField investigationFinal reportThorp T-18 · Rawlins, WYThe accident acft, a Thorp T-18, was one of four acft (quickie ii, varieze, longeze) in a loose formation that was en route to the annual eaa convention at oshkosh, WI. The acft departed redding, CA, at 0500 PDT, refueled at wendover, UT, and departed there…NTSB ATL86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lenoir, NCThe student plt was executing full stop landings then making a take off after each landing. He was attempting his fourth landing when the acft bounced, he applied power to try to regain control of the acft. The nose gear collapsed upon touch down, the strut…NTSB SEA86LA197Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Nimbus Iiit · Hawthorne, NVAfter a 5 hour flight in the motorized glider during which the engine was utilized on several occasions the pilot returned to his destination. Upon arrival he executed a number of low passes over the runway for photographers. The pilot executed a fly by…NTSB SEA86LA160Accident · No injuriesLimited investigationFinal reportCessna 172G · Carson City, NVThe plt stated a dust devil was encountered during final approach. He then added full power, but neglected to lower the nose of the acft. A full stall occurred and recovery was not possible due to the low altitude. The acft then struck the ground, nose first,…NTSB NYC86FGM05Accident · Serious injuriesFinal reportBomberger Vans RV-4 · Friedens, PADue to a low ceiling and poor visibility, the plt decided to make a precautionary landing at somerset arpt. Unable to locate the arpt, a landing was being made to a field when the acft stalled into trees during the approach.NTSB MKC86LA163Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Hershey, NEThe pilot stated he was spraying insecticides on corn and encountered a wind shear that pulled the airplane down into the corn. He was unable to recover and the airplane hit the ground.NTSB MIA86LA221Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Hopewell, FLFlight experienced complete engine failure when crankshaft failed due to fatigue cracking of the crankshaft cheek between the number 1 and 2 rodbearing journal. During the subsequent forced landing the aircraft collided with trees due to the pilot not wanting…NTSB LAX86LA308Accident · Minor injuriesLimited investigationFinal reportTemco GC-1B · Huntington Bch, CAThe pilot stated that he was putting some time on the engine after maintenance had been performed when the engine quit. He initially stated that he departed at 1300 PDT with 12 gallons of fuel on board. He later stated that he departed at 1400 PDT and that…