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 ATL86FKG02Accident · No injuriesFinal reportCessna 152 · Pell City, ALThe acft nosed over following a loss of control during a x-wind landing. The student plt stated he crabbed the acft intothe wind to compensate for the x-wind during the apch. The acft touched down still in the crabbed position and traveled off the right side…NTSB SEA86LA006Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Emmett, IDWhile landing in calm wind conditions on a 2400 ft rwy, the left brake failed & the acft contd off the departure end, then hit a fence. An exam revealed the left brake pads were worn & the left actuator cylinder was losing fluid. The brake backing plate & the…NTSB SEA86LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Fall City, WADuring an attempted go around the acft struck trees and bushes. The plt stated he could not remember if carb heat was removed during the go around. He continued to state, sufficient alt and airspeed could not be gained. An eng examination revealed several…NTSB NYC86FA002Accident · 3 fatalField investigationFinal reportCessna C-377A · Breakabeen, NYThe plt was advised by several sources that bad wx was located along the intended route of flt. The plt stated that he intended to fly over the bad wx since wx at the destination was good. A mayday call from 24J was broadcasted over the emer. Freq. Witnesses…NTSB MKC86LA007Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Dumas, AROn landing at a pvt sod strip near Dumas, the plt stated he encountered a strong crosswind. The crosswind forced his acft to veer off the side of the rwy. After veering off the rwy the right wing struck the ground sustaining substantial damage to the wing…NTSB MKC86LA004Accident · No injuriesLimited investigationFinal reportQuickie Q2 · Willard, MOClimbing to cruise the plt rptd a loss of eng pwr an turned to head back to the airport of departure, the ensuing forced landing substantially damaged the acft. Inspection into the eng failure revealed a contaminated inline fuel filter restricting fuel flow…NTSB MKC86LA003Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Guilford, MOThe plt reports that he landed hard, bounced and came down on the nose gear. The nose gear broke and the acft went over on its back.NTSB MKC86FA002Accident · 2 fatalField investigationFinal reportRockwell 112A · Gravois Mills, MOThe acft was observed on final with the gear down, flying along a ridge that was beside a lake. Witnesses stated that it was below the elevation of the arpt that was on top of the hill. Two witnesses also stated that the eng was running but not at full pwr.…NTSB MIA86LA006Accident · No injuriesLimited investigationFinal reportNorth American Navion · Tallahassee, FLThe plt stated that while doing touch-and-go landings at quincy, FL, the left main strut fell off the acft. He then returned to Tallahassee and made an intentional gear-up landing. Examination of the main landing gear scissor ass'y revealed that it failed due…NTSB MIA86LA004Accident · No injuriesLimited investigationFinal reportBell 206L · Islamorada, FLAircraft was ditched in the atlantic ocean after loss of engine power. Post crash inspection of the engine after recovery from the ocean revealed thje pc or compressor pressure air line had failed at a 'b' nut at the compressor schroll. With this line failed…NTSB LAX86LA005Accident · Minor injuriesLimited investigationFinal reportWillie II · Blythe, CAOn oct 5, 1985 a Willie ii homebuilt crashed on takeoff after its left main landing gear collapsed. VMC existed at the time and no flt plan was filed. The ac sustained substantial damage and the two occupants received minor injuries. The winds were from 050.…NTSB FTW86LA005Accident · No injuriesLimited investigationFinal reportBeech K35 · El Paso, TXThe plt stated his straight-in landing final apch was smooth. The airspeed had decreased from 80 to 65 KTS & the acft's wheels were only inches above the rwy when the right wing suddenly lifted and caused the acft to veer left and touch down on the dirt…NTSB DEN86FTE01Accident · Minor injuriesFinal reportSkurich FOCKE-WULF 190 · Falcon, COThe acft groundlooped to the rt during an attempted go-around after landing. The plt was landing at a arpt with watch he was unfamilar. He thought he saw wires at the approach end of the rwy so he landed long and then attempted a go-around. The acft…NTSB ATL86FKG01Accident · Serious injuriesFinal reportPiper PA-32-300 · Perry, GAThe acft landed short of the rwy during a forced landing following loss of pwr during a x-country flt of 2 hrs. 3 witnesses saw the acft bring refueled but the only one who mentioned the amount of fuel added was the refueler who said he'topped off' all 4…NTSB ANC86LA001Accident · Serious injuriesLimited investigationFinal reportChampion Citabria 7GCBC · Ptarmigan Pass, AKThe pilot-in-command stated that just after departure. He spotted a moose and made a low circle above the moose. He leveled off and attempted to pull the aircraft up. The nose of the aircraft pitched down and the airplane crashed to the ground.NTSB MIA86LA003Accident · No injuriesLimited investigationFinal reportCessna 414 · Sarasota, FLThe plt stated that his right main gear would not extend, so he circled the arpt for about 1/2 hour to burn off excess fuel, retracted the remaining gear & intentionally landed gear up on rwy 32. Examination of the right main landing it to extend beyond it's…NTSB MIA86LA002Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Pahokee, FLThe plt stated that upon takeoff from hickory farms airstirp, the aircraft began losing power. He then dumped his load of chemicals and on descent, struck sugar cane and cartwheeled into a canal. No determination could be made as to the nature of the loss of…NTSB MIA86IA001Incident · No injuriesIncident investigationFinal reportPiper PA-32-300 · Jacksonville, FLAfter departure flight experienced loss of engine power and visible smoke coming from the windshield exhaust ducts. The engine subsequently failed but the pilot was able to regain power and return to the airport for a normal landing. Post landing inspection…NTSB LAX86LA008Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Santa Barbara, CAOn oct. 3, 1985, pipter PA-23-250 crashed into the pacific ocean while on an air sampling flt near Santa Barbara, CA. The ac was destroyed and the two plts were fatally injured. The flt was to be flown along a predermined route utilizing loran navaids. The ac…NTSB CHI86LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Troy, MIThe plt landed on rwy 27 with winds from 185 degs at 20 KTS gusting to 30 KTS. The acft ballooned on short final. The plt added pwr but the right wing dropped and hit the rwy. The acft cartwheeled.NTSB CHI86FEM01Accident · Minor injuriesFinal reportLeone Sonerai II · Traverse City, MIThe acft contacted a tree and impacted the terrain in a nose down attitude during a forced landing following a loss of pwr which resulted from fuel exhaustion.NTSB BFO86LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Annapolis, MDThe plt crossed mid-field, and entered a left down wind for rwy 30. He then checked wind direction, completed a base leg, and entered final apch. After reducing his airspeed, the acft 'floated' prior to touching down aprx 600 ft short of mid-fld. The plt…NTSB BFO86FA002Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Gaithersburg, MDThe plt was clrd for a VOR rwy 14 apch. On apch, he rprtd at the sleet intxn (a fix on the NDB apch). The acft was then seen flying ovr the arpt on an easterly hdg. UNICOM operator said he then heard the plt call "turning final." However, bfr lndg, the acft…NTSB ANC86LAG01Accident · No injuriesFinal reportCessna 140 · Beluga, AKThe student plt attempted takeoff from am unimproved, overgrown river bed. He stated he paced off the distance availablefor takeoff and it was too short, however, he decided to takeoff anyway. The acft impacted alders and a stream bank just as it was lifting…NTSB NYC86FA001Accident · 1 fatalField investigationFinal reportMooney M20J · Robbinsville, NJDuring IFR departure from an uncontrolled arpt, the acft was instructed to squawk the discrete freq that had been issued in pre-flt clearance. The plt acknowledged the freq. The acft disappeared from radar. Ground witnesses saw the acft descend out of the low…NTSB MKC86LA001Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Kansas City, MOThe Piper PA-28-140 was departing the Kansas City, MO area for a VFR, no flight-plan flight to warrensburg, MO. Witnesses stated that the airplane appeared to lift off prematurely and remained effectively stalled until impact two min later in a…NTSB FTW86MA010Accident · 4 fatalMajor investigationFinal reportBeech V35 · Bridger, MTDrg a preflt wx briefing, the plt was advised that VFR flt was not recommended due to forecast frontal activity moving southbound along his route. Severe turbulence & icing had been reported just to the north of his course. He filed a VFR flt plan & took off…NTSB FTW86LA003Accident · No injuriesLimited investigationFinal reportCessna 182N · Odessa, TXDuring touch-&-go landing practice on her second solo training flight, the student plt made a hard landing. The nose gear strut was driven upward through the firewall and the prop was damaged. The acft bounced/porpoised three times & came to rest off the left…NTSB FTW86LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe acft experienced eng failure as a result of fuel exhaustion and the plt made a forced landing in a lake near the departure arpt while towing a banner. FAA stated the plt did not obtain a waiver to tow the banner.NTSB DEN86FA002Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Chamberlain, SDThe plt and his passenger friend were looking for stray cattle when aprx at 142 ft above the ground their acft struck an antennae mounted on a microwave tower. The acft descended and was destroyed on ground impact.NTSB CHI86LA003Accident · No injuriesLimited investigationFinal reportCessna 172F · Canton, OHThe acft overran the rwy and collided with wires and a pole during landing. The student plt stated that he was too fast and landed long during the calm wind landing. He also stated he should have used more flaps.NTSB ATL86LLQ01Accident · Minor injuriesFinal reportCessna 172 · London, KYThe acft crashed during a forced landing after fuel exhaustion during a x-country flt. The plt had encountered wx and in attempting to reach an alternate arpt the acft ran out of fuel. The plt was not instrument rated and the wx at London was 600 ft overcast…NTSB ATL86FA002Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Hurricane, WVN9629U crashed in a wooded area near Hurricane, west Virginia while conducting a visual flight from millwood, WV to grundy, Virginia. The pilot and aircraft were certificated in accordance with current FARS. The pilot received a weather briefing for the…NTSB ANC86LAG03Accident · No injuriesFinal reportPiper PA-18A-150 · Homer, AKThe landing gear axle failure was due to the oversize tires that were installed on the aircraft.NTSB LAX86LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Van Nuys, CAThe plt stated that after takeoff he climbed to 1800 ft MSL (aprx 1000 ft above ground level) and entered a left turn. The eng failed in the turn an he selected a dry flood control basin on which to land. The acft's airspeed was slow on landing and the…NTSB CHI86LA002Accident · No injuriesLimited investigationFinal reportCessna 172 · Crivitz, WIThe plt lost directional control of the acft during the landing roll in x-wind conditions. As the acft veered to the left side of the rwy it struck a rwy light. The arpt owner stated the acft touched down in a crabbed position and the local winds were from…NTSB CHI86FEX01Accident · No injuriesFinal reportPiper PA-38-112 · Terre Haute, INThe acft rt main & nose gear collapsed during a forced landing after a power loss during takeoff. The student plt was at the controls when the eng quit at about 300 ft AGL. The CFI took the controls and turned left toward a taxiway for the landing. The acft…NTSB SEA86LA001Accident · No injuriesLimited investigationFinal reportCessna 172P · Winnemucca, NVDirectional control was lost during takeoff roll due to a flat nose wheel tire. The aircraft continued to veer to the left of the runway despite the student pilots attempts to correct to the right. The aircraft departed the runway where it nosed over.NTSB FTW86MA001Accident · 5 fatalMajor investigationFinal reportCessna 441 · Dallas, TXA student plt in a Cessna 152, N5522L, had deptd redbird arpt at Dallas. He was practicing solo maneuvers in a privatelydesignated practice area that overlapped the extended inbnd course to rwys 31L & r at love field. At the same time, a Cessna 441, N400BG,…NTSB DEN86LA001Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Cortez, COAfter 3.9 hrs flt time on a x-country flt from cheyenne, WY, to Cortez, CO, the plt experienced an eng failure due to fuel exahustion. He executed a forced landing in a mountain meadow that was not adequate in length for the landing. The acft impacted trees…NTSB CHI86LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHAccording to the initial solo stufent pilot, he landed uneventfully, applied takeoff power and reached down to retract the flaps. As the aircraft began to accelerate it began to drift to the left. The student pilot applied right rudder but the aircraft…NTSB ATL86FA001Accident · 2 fatalField investigationFinal reportCessna 172 · Chapel Hill, NCN2765U crashed shortly after making a low pass over a private air strip near Chapel Hill. The aircraft was seen in a nose high attitude prior to impacting a tree about 40 above the ground. The aircraft also collided with a power transmission line. The…NTSB SEA85LA231Accident · 1 fatalLimited investigationFinal reportMitchell U2 · Prineville, ORPlt was on second flt in newly completed, registered ultralight. Craft had not been issued a certificate of airworthiness. After takeoff, acft was observed to circle airport, then descend out of sight behind trees. Investigation showed steeep, nosedown…NTSB NYC85FHJ04Accident · No injuriesFinal reportCessna 172 · Montauk, NYThe Cessna 172 was cruising 3000 ft off shore at 600 ft AGL over the ocean. The engine was at 1900 RPM with the carburator heat on when the aircraft experienced a power failure. The flight instructor made an emergency landing on a beach. Upon touch down the…NTSB MKC85LA224Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Council Bluffs, IAOn climbout fm the Council Bluffs airport the plt reported a loss of engine power and the engine quitting. The plt attempted an air restart but was too low to the grnd to continue. The plt weaved in and out of trees during his descent finally impacting the…NTSB LAX85LA404Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Huntington Bch, CAThe plt acknowledged that on short final approach to the 2330 ft-long rwy, the acft's speed was 'a little hot', & during ldg flare the acft 'floated in ground effect'. After the acft bounced 3 times the plt decided to go around & he applied full pwr. The plt…NTSB DEN85IA250Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Denver, CODuring gear extn for lndg, the flt crew noted a 'loud & very noticeable jolting of the acft.' Shortly thereafter, they also noticed that a portion of the right main gear had punctured the upper surface of the rgt wing. The crew then declared an emergency &…NTSB ATL86LMG01Accident · No injuriesFinal reportCessna 310R · Rocky Mount, NCThe acft touched down 150 ft short of rwy 04 at the Rocky mountain-wilson arpt. The acft contacted two rows of apch lights and a ground drop off which sheared all three landing gears. The flt departed wilson municipal arpt and upon reaching 3700 ft the plt…NTSB SEA85LA232Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Lopez Island, WAShortly after takeoff the acft's eng ceased operating for unknown reasons. During the landing rollout, the acft struck a fence and nosed over.NTSB SEA85FA228Accident · 2 fatalField investigationFinal reportTeratorn Tierra II · Post Falls, IDThe acft contacted the terrain in an uncontrolled descent following an inflt separation of the left wing. A witness stated the left wing separated as the acft was being maneuvered in a race track pattern using bank angles of 45 degs. The wife of the acft…