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 NYC87FA265Accident · 1 fatalField investigationFinal reportBeech D95A · Pittstown, NJPilot departed runway 26 at alexandria arpt toward trees in fog. Left wing hit trees. Acft landed hard collapsing landing gear. Acft hit a tree in area of pilot seat during lndg fatally injuring the plt.NTSB MKC87LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ozark, MODuring a ldg, the acft touched down long, ran off the end of the airstrip and struck a fence and then a ditch. The rwy was 2100 feet long, downsloping, and the grass surface was wet.NTSB MKC87LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · El Dorado, KSAfter departing midfield and attaining approximately 100 feet of altitude, plt experienced a complete power failure. Plt attempted to reland on intersecting runway by executing an approximate 270 degree turn. Acft struck the terrain before completing the…NTSB MIA87LA262Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Ocala, FLThe plt stated that the eng lost power & he was at low alt looking for an emerg ldg field when the wing hit a tree. The pax stated they were doing aerobatics at low alt & the eng quit. She stated that she was not wearing the required parachute & had asked the…NTSB MIA87IA264Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Hampton, NYA full performance level controller (fpl ctlr) at sector 31 of boston ARTCC was giving familiarization training to another fpl ctlr to familiarize the trainee with a new area that had been transferred from new york ARTCC to boston ARTCC. Sector 31 was…NTSB NYC87FA264Accident · Serious injuriesField investigationFinal reportLockheed L-1011 · Bermuda, BermudaEncounter with undetectable clear air turbulence.NTSB MIA87RA261Accident · 1 fatalForeign investigationEmbraer EMB 110-P-2 · Freeport, BahamasNTSB DEN87LA246Accident · No injuriesLimited investigationFinal reportCessna 150K · Aurora, COThe student plt was flying a long cross country instructional flight. The pilot stated he became disoriented at the first check point and followed highways for the remainder of the four hour flight. The engine quit and the pilot landed in a weed filled field.…NTSB CHI87LA225Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Rochester, INThe tailwheel aircraft was landed into a strong left crosswind, experienced a loss of directional control, followed by a ground loop, and nose over.NTSB SEA87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Mount Vernon, WAThe aircraft's engine ceased operating due to fuel exhaustion about five miles short of the destination airport. A field was selected for the landing site. During the landing roll, the aircraft nosed over on freshly plowed terrain.NTSB SEA87FA194Accident · Minor injuriesField investigationFinal reportHughes 369D · Seattle, WAThe plt rprtd that while he was in cruise flight at about 1000', the eng lost power. He initiated an autorotation to an athletic field in a city park. Drg his apch, he changed his planned touchdown point svrl times due to personnel on the field. He said that…NTSB NYC87LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Plymouth, VTWhile cruising at about 5500', the eng lost power & the prop contd to windmill, but the plt was unable to restart the eng. Subsequently, he landed the acft in a rough field. During the landing roll, the prop dug into a mound of dirt & the aircraft flipped…NTSB NYC87LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stow, MAThe pilot was on takeoff roll when he decided to abort. He stated that he felt the engine was not developing adequate power and the airspeed was not up to required takeoff speed. The aircraft continued off the end of the runway and inverted in swampy soil.NTSB LAX87LA348Accident · No injuriesLimited investigationFinal reportCessna 175 · Camp Verde, AZWhen both passengers became air sick the pilot decided to land on a dirt road. Upon touchdown, the pilot heard a loud pop and assumed that a tire had blown. Because of this, he used the brakes sparingly and could not stop the aircraft in time to avoid trees.…NTSB LAX87DVD05Accident · No injuriesFinal reportRotorway Scorpion 133 · Boonville, CAThe plt said that when he was practicing quick stops & flares, the tail rotor struck the ground. The helicopter then yawed, touched down (right skid 1st) & rolled over. No preimpact mechanical failure or malfunction was rprtd.NTSB FTW87FA225Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · Houston, TXPlt executed an emergency landing into trees after he experienced an inflight fire and eng failure shortly after t/o. the lndg in the trees was executed after the plt decided that he could not make it to a clear area. Investigation revealed that the fire had…NTSB FTW87DRG07Accident · Serious injuriesFinal reportNixon Quickie 1 · Del Rio, TXEarlier in the day, the plt had flown the home built acft on its maiden flt of 0.2 hrs with no rprtd problems. He stated that after taking off on the 2nd flt, he was climbing at aprx 200' AGL when the acft seemed to hit a gust of wind & roll left. He applied…NTSB DEN87LA243Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Las Cruces, NMA CFI and a private plt were ferrying a newly purchased helicopter to their home airport. During a fuel stop, while on a visual approach, the helicopter encountered windshear. The density altitude was 8000 feet, and the helicopter was at or near max gross wt.…NTSB CHI87LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Frankfort, ILThe student plt was on a flt with 2 pax aboard. He rprtd that drg a ngt lndg, the acft bounced & ballooned. He added pwr to fly the acft back down to the rwy, but it bounced & ballooned again. By this time, the acft was about halfway down the rwy.…NTSB CHI87LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Joliet, ILThe aircraft landed on what the pilot thought was a runway. He stated that on short final the aircraft floated before touching down and consequently there was not enough room to make a go-around. After touchdown, he braked hard and the aircraft swerved left…NTSB CHI87LA222Accident · No injuriesLimited investigationFinal reportCessna 150H · Sparta, WIThe plt was taking off on his pvt strip in a prevailing 12 kt x-wind that was vrbl & blowing fm a 'lull' to 18 KTS. He said the strip was located near an l-shaped ridge which attenuated the general wind flow. Also, he said the 1900' sod strip sloped downhill…NTSB BFO87LA069Accident · No injuriesLimited investigationFinal reportMooney M20E · Pocomoke City, MDWhile on final apch, the plt realized his touchdown point was farther down the rwy than usual, but he believed there was sufficient rwy & elected to cont the lndg. After touchdown, he applied brakes, but was unable to stop on the remaining rwy. Subsequently,…NTSB BFO87LA067Accident · Minor injuriesLimited investigationFinal reportStinson SR8B · Lynchburg, VAThe pilot diverted to falwell airport due to deteriorating weather and uneven fuel consumption indication between the left and right fuel tanks. During the landing approach for runway 28 the pilot noted the upslope of the runway surface. The pilot misjudged…NTSB ATL87LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Winston Salem, NCThe student pilot was performing touch and go landings as part of his supervised solo training. The aircraft landed hard and bounced twice before coming to rest with a collapsed nose gear. Examination of the airframe disclosed extensive crushing damage to the…NTSB SEA87LA195Accident · No injuriesLimited investigationFinal reportBeech 23 · Basin City, WAThe pilot was making a low pass over the ground for a possible off airport landing next to his farm. During the low approach, he noticed power lines ahead and pushed forward on the controls to clear under them. However, there was a wrecked vehicle below the…NTSB NYC87LA271Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Waynesburg, PAThe pilot said he flooded the engine of the Piper PA-28-180 and decided to pull the prop through a couple of times by hand. He said he thought he had turned the mags off, pulled the mixture to idle cut-off, and set the parking brake. When he had pulled the…NTSB NYC87LA267Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Irwin, PADuring taxi operation, the pilot lost directional control of the aircraft and it struck a tree stump which was located to the side of the runway. The aircraft then continued to roll about 500 feet off the rwy where it came to rest with substantial damage.NTSB NYC87LA254Accident · Minor injuriesLimited investigationFinal reportBeech E55 · Block Island, RIJust before lift-off, after the aircraft had accellerated to about 115 mph, the door on the passenger's side came open. The pilot immediately aborted the takeoff, but was unable to stop on the remaining portion of the 2500' runway. After departing the runway,…NTSB MKC87LA180Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Osage Beach, MOWhile performing as PIC during a biennial flt review, the CFI requested that the owner perform a short fld lndg using full flaps in cross wind conditions. The acft struck the terrain 50 feet short of the rwy and bounced onto the approach end of it. The CFI…NTSB MKC87LA179Accident · No injuriesLimited investigationFinal reportJenkins Pitts S-1 · Orleans, NEThe pilot stated that the aircraft was cruising at 2,000 ft (AGL) when the engine lost power. He turned toward the nearest suitable emergency airfield but the aircraft's rate of descent precluded this option. The pilot selected a road as alternate, but…NTSB MKC87LA178Accident · No injuriesLimited investigationFinal reportAero Commander 500B · Kansas City, MOThe pilot was on approach to Kansas City international when he was requested to slow down and follow another aircraft. He used his checklist and decided to leave the gear up until he was closer to the airport. On short final he extended the flaps but failed…NTSB MIA87LA263Accident · No injuriesLimited investigationFinal reportCessna 411 · No.Atlantic Oc (Atlantic Ocean)The acft was ditched 35 miles southeast of cat island on a flt from georgetown to freeport, Bahamas for unknown reason(s). The acft has not been recovered. Attempts to contact the pilot & registered owner were to no avail.NTSB MIA87FA260Accident · 2 fatalField investigationFinal reportBeech B35 · Kissimmee, FLThe plt bgn taking off on a pvt 1800' grass strip which had trees nr the edges. Aprx 1575' fm the threshold, there was a parked acft nr the left side of the strip with its rgt wing protruding over the rwy area. While taking off with a rgt qtrg tail wind, the…NTSB LAX87LA347Accident · No injuriesLimited investigationFinal reportCessna 182D · San Ramon, CAAfter telling the lineman at calexico, CA to fill the tanks, the plt walked away from the acft to clear customs. When he returned, he loaded his passengers into the acft and departed the arpt. After flying 3 and 1/2 hours the engine stopped and the acft was…NTSB LAX87LA346Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Lakeport, CAThe pilot stated that the aircraft groundlooped during landing roll just as the tailwheel touched down. There were no reported mechanical problems and winds were light and variable. However, the pilot stated that he thought he felt a gustof wind.NTSB DEN87LA245Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Bountiful, UTWhile on a local low level pleasure flt the plt failed to see power lines and an in flight collision with the lines occurred severing the right skid and 90 degree gear box from the acft. A semi-autorotative crash occurred on the bank of a irrigation reservoir.NTSB DEN87LA244Accident · No injuriesLimited investigationFinal reportCessna 140 · San Ysidro, NMThe plt and pax were on a LCL sightseeing flt. The plt stated that he had been flying low and slow at a nose high attitude. The engine began to overheat and did not cool off and the pilot executed a precautionary landing on a dirt road. The acft ballooned and…NTSB CHI87LA224Accident · No injuriesLimited investigationFinal reportCessna 172L · Lakeville, MNAircraft landed hard, nose wheel first, and collapsed the nose landing gear tire. PIC was concerned about a sharp knocking noise in the rear of the aircraft that he heard after liftoff. The reason for the noise was not determined. He acknowledged that he…NTSB ANC87LA168Accident · No injuriesLimited investigationFinal reportChampion Aeronca TL · White Mountain, AKThe pilot stated upon touchdown the airplane bounced and groundlooped. The acft had been landed on a gravel bar and the landing area was loose gravel and rocks. No malfunctions of the acft were reported. The plt stated that he thought that the bounced landing…NTSB ANC87LA167Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Beluga Lake, AKThe pilot stated that he was maneuvering 20 feet above the tree tops when a gust of wind made him lose directional control of the aircraft, causing the aircraft to strike the trees and hillside.NTSB SEA87MA192Accident · Serious injuriesMajor investigationFinal reportFairchild SA227-AC · Twin Falls, IDChk plt was conducting capt proficiency chk on another company plt (PIC) under dark ngt condtns. Subsequent to full stop ldg on rwy 25, takeoff chklst was recited. PIC commenced t/o on rwy 07. Chk plt simulated VI eng cut after liftoff. PIC was unable to…NTSB NYC87LA269Accident · No injuriesLimited investigationFinal reportRyan ST-3RR · Hamburg, NYAccording to the plt, when he arrived at the arpt, the winds were from 280 deg at 20 gusting 25 KTS. He believed that with the strong x-wind & gusts, it would be safer to land on sod beside the rwy. During the landing, the main gear sank into the sod & the…NTSB NYC87FA262Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Montoursville, PAThe plt initiated the ILS approach and acknowledged a frequency change. The acft was found on a steep hill one mile south of the airport. No evidence of an engine or control system malfunction was found. It appeared that the pilot made a missed approach and…NTSB MIA87FA259Accident · 2 fatalField investigationFinal reportBeech D18S · Miami, FLWitnesses observed the aircraft taxi to the end of runway 27R and positioned so the tail was out in the overrun area. Witnesses further stated the aircraft appeared to take an overly long takeoff roll before lifting off. After lift off, the aircraft pitched…NTSB FTW87LA224Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Addison, TXThe aircraft became too slow while on final approach, started mushing, and drifted left. Full engine power was applied accompanied by nose up elevator trim. The aircraft bounced then climbed about 30 feet while attaining a steep nose up attitude and stalled.…NTSB DEN87LA239Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Colorado Sprgs, COThe plt stated that after he lndd to pick up a pax, he engaged the control lock fm habit, but did not shut dwn the eng. He got clnc to taxi back to the rwy & takeoff, but 'forgot to release control lock.' The Cessna 195 has a combination control lock and…NTSB CHI87LA221Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Troy, MIDrg the initial climb after takeoff, the eng lost power. Subsequently, the acft was dmgd drg a forced lndg west of the arpt. Drg an exam of the acft, 20 to 25 gal of avgas was fnd in the left fuel tank; however, the rgt tank had only residual fuel remaining.…NTSB CHI87DEC05Accident · No injuriesFinal reportWilli/Bensen B-8M · Fraser, MIDeterioration of the internal surface of the fuel tank which led to blockage of the fuel flow and subsequent fuel starvation of the engine.NTSB ATL87LA266Accident · No injuriesLimited investigationFinal reportCessna 172H · Chuckey, TNThe plt estimated there was 9 gal of fuel on board when he took off. Aprx 20 min later, he was making a low pass over a private strip when the eng lost power. He stated that he repositioned the fuel selector to the other tank, but was unable to restart the…NTSB ATL87FA262Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Demopolis, ALThe plt of an aircraft carrying an estimated 317 kilos of cocaine was attempting to land at an apt which did not have a published instrument approach procedure in IMC. Witnesses estimated that the visibility was no more than 1/2 mile in fog about 45 min after…