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 MKC85LA128Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Swifton, ARThe ag pilot was landing the airplane too fast and when he couldn't stop on the wet grass, he attempted a go-around. By the time the engine accelerated, there was not enough airspeed or runway and the airplane went through a fence and stopped against a…NTSB MKC85LA123Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paragould, ARPilot was seeding rice when the engine failed. Pilot attempted forced landing on gravel road and impacted a utility pole before touchdown. Acft destroyed by impact and post impact fire. The reason for the engine failure could not be determined.NTSB MKC85IA131Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · St. Louis, MOWhile on an IFR approach to land at stl and the plt initiated flaps. The no.3 outboard flap vane separated from its mounting and fell to the ground. Upon separation the flap vane struck the leading edge of the trailing edge flap knocking a hole in the skin.…NTSB MIA85LA189Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Kissimmee, FLThe plt stated that just after takeoff, at about 800 ft alt the eng lost pwr. He then made an emerg landing in a fld and the acft struck a ditch during the landing roll. Post accident examination revealed both magneto cases were cracked and the #1 cly fuel…NTSB MIA85LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Wabasso, FLThe acft nosed over during a forced landing on a beach. The plt was on a solo flt to practice maneuvers. He stated that when pwr was reduced to 1500 RPM in preparation for a stall series the RPM continued to decrease to aprx 1100. He was not able to regain…NTSB LAX85FA269Accident · Minor injuriesField investigationFinal reportAero Commander 1121 · Van Nuys, CAThe plt, executing and ILS apch, observed a primary hydraulic pressure drop and declared his intent to land without the use of flaps, speed brakes, reversers or nose wheel steering. The acft ran off the end of the rwy during landing, traveled aprx 1300 ft and…NTSB FTW85LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tahlequah, OKThe plt stated the acft was in flt slightly more than three hrs after it was refueled, before fuel exhaustion occurred. The acft reportedly was leaned during the flt. Post accident examination revealed no evidence of any fuel system leaks. Reason for the fuel…NTSB ANC85FA092Accident · No injuriesField investigationFinal reportBellanca 7GCBC · Anchorage, AKThe pilot in command executed a step turn resulting in his final takeoff path downwind which would have placed the airplane's flight path over the bank with the least obstructions, except for the small scrub tree. The airplane struck the small scrub tree and…NTSB SEA85LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Las Vegas, NVDuring a local instructional flight a bounced landing was made. The acft bounced nose high to about 20 ft AGL. The acft then veered left of the rwy after full power had been added and flaps reduced from 40 degrees to 25 degrees for an attempted go-around at…NTSB FTW85LA251Accident · Serious injuriesLimited investigationFinal reportRockwell 112B · Marietta, OKThe plt lifted off the rwy too early for the conditions ie; high gross weight and rough, uphill rwy with grass four to six inches tall. He then attempted to climb too steeply and stalled immediately after passing through ground effect. The acft descended…NTSB SEA85LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kendrick, IDThe plt had finished spraying a field & was returning to the ag strip when the eng failed. He made an emerg landing in a barley field which was muddy & soft. During the landing roll, the wheels sank in the terrain & the acft nosed over. An exam revealed that…NTSB SEA85LA130Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Truckee, CAContrary to common departure practice, the pilot commenced his takeoff from the lake headed westbound and towards rising terrain. Additionally, he failed to use all the takeoff surface available. The density altitude at donner lake at the time of the accident…NTSB SEA85LA129Accident · No injuriesLimited investigationFinal reportRobinson R22 · Port Orchard, WAThe instructor plt (CFI) with only 358 hrs total flt time was demonstrating an autorotation with a power recovery. During the recovery, the CFI failed to fully regain RPM & the helicopter settled to the surface. With a low rotor RPM, there was a loss of tail…NTSB NYC85LA143Accident · No injuriesLimited investigationFinal reportEnstrom 280C · S.Woodstock, VTThe helicopter experienced a loss of RPM on liftoff and received substantial damage when it collided with a chain link fence. The plt stated that on liftoff to aprx 50 ft AGL, the RPM dropped off to 2800 and a loss of climb resulted. The plt descended in an…NTSB NYC85FA141Accident · 2 fatalField investigationFinal reportBeech BE-200 · Hamptonburgh, NYPlt filed IFR for 2 flight legs; baltimore, MD to teterboro, NJ & teterboro to montgomert, NY (orange co arpt). The plt received a preflight wx briefing & was advised that the forecast for stewart, NY, about 10 mis form montgomery was sky partially obscured…NTSB MKC85FA124Accident · 1 fatalField investigationFinal reportE.T. Meredith III Christen Eagle II · Carlisle, IAThe aerobatic airplane had a total of 23.6 flight hours at the time of this accident. This accident pilot had flown 6.3 hours of that time. The aircraft log did not indicate any spin practice by this pilot in this airplane but did indicate three flights with…NTSB LAX85LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Biggs, CAThe plt stated that while loading the acft with spray mix he looked at his fuel quantity gage and believed he had enough fuel for one more aerial application flt. The plt continued to state that shortly after liftoff the engine quit and a forced landing was…NTSB LAX85LA268Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Oracle, AZDuring a LCL pleasure flt the plt stated that the acft's eng began running rough so he made a precationary ldg on a dirt road which was at an elevation of 4,000 ft MSL. After inspecting the acft & finding it to be in proper working order the plt decided to…NTSB FTW85LA250Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dallas, TXThe plt filed and flt planned for an overwater route between clearwater, FL, and Dallas, TX, which was denied due to ATC restrictions. On arrival over new orleans, a planned re-fueling stop, the plt determined that he would make it to Dallas. On arrival in…NTSB FTW85LA249Accident · No injuriesLimited investigationFinal reportCessna 310F · Midland, TXOn takeoff, the plt heard a loud bang when he cycled the gear up and he got a gear unsafe light. Personnel on the ground advised him that the nose gear was hanging down at a 45 degree angle, but the mains were up. The plt diverted to a nearby arpt that had…NTSB DEN85LA155Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fillmore, UTThe plt reported the engine failed while he was spraying a corn field, necessitating a straight ahead forced landing. During the landing roll the wheels bogged down in the soft earth and the plane overturned. Subsequent examination of theengine by the plt…NTSB DEN85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Los Almos, NMThe plt was making an apch to rwy 27 at the los alamos muni arpt in gusty x-wind conditions. The arpt was located atop a mesa & rwy 27 had a 1.5% uphill rwy gradient. The plt said he selected 2 notches (25 deg) of flaps. The winds were reported to be from 210…NTSB DEN85FA153Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Melstone, MTThe acft was observed in a left turn in a steep dive until it passed out of view behind a hill. The investigation revealed no evidence of airframe or engine malfunction or failure piror to the crash. Medical findings revealed the plt, sole occupant, had 90…NTSB CHI85LA232Accident · No injuriesLimited investigationFinal reportPiper J-3 · Gaylord, MIThe plt attempt to take the float plane across a lake in wind that was from 270 deg at 20 gusting 40 KTS. Subsequently, the acft capsized & was damaged. In a revised statement, the plt reported that he was 'sailing' (letting the wind blow the acft) across the…NTSB CHI85FEX02Accident · Serious injuriesFinal reportCessna 310C · Greenfield, INWhile en route, the l eng suddenly lost power & would not restart, so the plt feathered the l prop. After letting it cool aprx 5 min, he tried restarting it again, but still was unable. He stated he thought he then secured (feathered) the l eng. The plt…NTSB ATL85LA195Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Wingate, NCThe plt & passenger consumed several beers shortly before boarding the helicopter for a flt in the local area. The flt lasted aprx 15 min. The passenger reported that during a landing, the skid on the right side contacted the ground causing the helicopter to…NTSB ANC85LA091Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai Lake, AKThe plt stated that the float struck the water during landing resulting in the acft nosing over and sinking in 25 ft of water.NTSB ANC85FA090Accident · No injuriesField investigationFinal reportAeronca 7AC · Anchorage, AKThe acft collided with a parked helicopter during landing. The acft had left the rwy at midfield & collided with the parked acft. The plt stated that he lost directional control after lndg. A rwy light on the left side of the rwy aprx 900 ft from the approach…NTSB MKC85LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Curtis, NEThe plt stated he misread the windsock and made a downwind landing resulted. The acft overran the end of the grass rwy and nosed over when the nose gear contacted a plowed fld. The arpt operator reported the winds were from 180 degs at 18 KTS when the landing…NTSB MKC85LA126Accident · No injuriesLimited investigationFinal reportCessna A-188-B · Broadwater, NEAg plt reports that the acft would not climb fast enough after takeoff to clear tree stumps off the end of the runway at his ag strip. The density altitude was about 6,000 and the plt acknowledges that a lighter load would have allowed the acft to climb fast…NTSB MKC85LA125Accident · No injuriesLimited investigationFinal reportSnow AT301 · Marianna, ARAfter departing the ag strip the plt rptd a vibrating engine which shook violently until finally quitting. The plt responded with an emergency landing attempt to a plowed bean field. The acft impacted the soft terrain at a high rate of speed where the acft…NTSB MIA85LA186Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City, FLThe plt stated that while taking off in a x-wind he lost control of the acft. The acft contacted the lip of a large drainage ditch, cartwheeled 180 degs to the right and crashed into a ditch.NTSB MIA85LA185Accident · No injuriesLimited investigationFinal reportHughes 269C · St.Petersburg, FLThe helicopter was landing after a training flight with an instructor pilot and a non-rated-non-certificated student pilot on board. As the helicopter touched down a severe resonant vibration started. The instructor stated that he attempted to lift off the…NTSB MIA85FA187Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Daytona Beach, FLAccording to witnesses, the plt was flying at a very low alt & was making 's' turns while proceeding southbound along a Beach. During the last left turn toward the east, the acft turned further left toward the north. While turning, the left wing struck water…NTSB FTW85LA248Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Keller, TXThe acft collided with a tree during a forced landing roll following a loss of power on initial takeoff climb. The plt reported a leak was found in the gascolator after the accident.NTSB DEN85LA160Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Gardner, COThe ag-acft stalled & crashed during an ag operation in high density alt. The mountainous terrain and downdrafts contributed to the overall effect of dissapating the clearance between the acft & the undulating terrain.NTSB DEN85LA159Accident · No injuriesLimited investigationFinal reportPiper PA-25-235-B · Lovington, NMThe plt attempted to take off to the east from a 1000-foot mowed alfalfa field at a field elevation of 3700 ft MSL. The plt estimated the winds to be from the southeast at 8 mph. The density altitude was computed to be between 6578 and 6871 ft MSL. According…NTSB DEN85LA158Accident · No injuriesLimited investigationFinal reportMooney M20K · Lafayette, COOn June 8, 1985, a Mooney M20K, impacted the ground off the rwy while landing at alexander dawson arpt, Lafayette, o. the plt said he was attempting to make a short field apchto the plt, the apch was high and fast. The acft landed, porpoised, and departed the…NTSB DEN85LA157Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Albuquerque, NMThe plt reported that during a normal landing, the right main gear folded back, followed by collapse of the left main gear. An exam revealed evidence of fatigue failure of a clevis bolt in the threaded area.NTSB CHI85LA231Accident · Serious injuriesLimited investigationFinal reportJenkins HP-18 · Wellington, OHFollowing an aprx one-half hour flt, witnesses stated that the glider did not appear to flare for landing, but instead, impacted the ground without arresting the rate of descent. The plt eported he had very poor ventilation in the cockpit and feels that he…NTSB CHI85LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Blair, WIThe plt attempted to land the acft in a farm field but was unable to stop before reaching the end of the field. The acft ran through a fence & a ditch before coming to rest. The plt stated that he overshot the rwy, landed long, & was unable to stop the acft…NTSB CHI85LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Osceola, WIThe solo student plt attempted to land the acft with an aprx 90 deg x-wind of 24 KTS gusting to 32 KTS. Feeling unsure of the conditions on his first apch, he decided to make a go around. This he successfully accomplished. On his second attempt, he was able…NTSB CHI85LA227Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Cleveland, OHOn takeoff, a tackel box slid forward and jammed the cyclic. The plt attempted to return to the landing pad, however, one of the skids missed the pad and the acft began to roll until the main rotor contacted the roof of a garage.NTSB CHI85FA226Accident · 1 fatalField investigationFinal reportSchweizer G-164A · Red Lake Falls, MNThe plt had been spray a field in north & south directions, then elected to make a swath run from east to west toward the sun. This pass was made late in the day. While on the swath run, the acft collided with an unmarked wire, then veered & crashed in a…NTSB MKC85LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Des Moines, IADuring a full stop landing the plt applied brakes to arrest the landing roll and upon application of the brakes, the acft veered slowly to the left without slowing down. The check plt applied his brakes to assist the plt, but without any effect. The acft…NTSB LAX85LA267Accident · No injuriesLimited investigationFinal reportCessna 152 · Compton, CADuring a dual instructional flt, in preparation for the student's private plt flt exam, the instructor plt failed to confirm that adequte fuel was on board. Despite the fact that the fuel gauges were indicating nearly empty, the instructor plt permitted her…NTSB FTW85FA247Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Pineville, LAThe aircraft landed long and fast on the relatively short, sloping runway. After bouncing four times, the pilot rapidly added throttle on the turbocharger-equipped aircraft and attempted to climb. Witnesses observed smoke from the exhaust, and described high…NTSB DEN85LA154Accident · Minor injuriesLimited investigationFinal reportCallair A-9 · Riverton, WYDuring an aerial application turn-around maneuver, the eng lost power. The plt stated that he immediately changed the fuel selector & turned on the boost pump, but the acft was too low for the eng to have time to restore power. The eng had been using fuel…NTSB DEN85LA151Accident · No injuriesLimited investigationFinal reportBeech B35 · Chinook, MTAbout 10 min after takeoff, the acft was damaged during a forced landing after the eng began sputtering & then lost power. The plt reported that he made a normal takeoff with the cowl flaps open & the mixture rich. After climbing about 1100 ft (to 3500 ft…NTSB CHI85LA233Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Frankenmuth, MIDuring the approach power was added & the aircraft was observed to bounce after touchdown. The acft entered a left turn & from about 50 ft AGL was observed to collide with the ground in a nose down attitude. The flaps were found in the down position.