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 LAX86FA042Accident · 2 fatalField investigationFinal reportPiper PA 28-151 · Lebec, CAAfter receiving a preflight wx briefing that forecast strong headwinds, over mountainous terrain, severe turbulence and pireps of severe turbulence on the proposed flt route. The instructor plt and his student instrument plt took off for a night IFR training…NTSB FTW86LRD03Accident · No injuriesFinal reportCessna 185 · Leeville, LAThe acft collided with a power line during an off arpt landing on a canal. It was an intentional landing to transport company employees of la-tex gulf drilling, inc. the wx was VMC and no flt plan was filed.NTSB ATL86LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · Jacksonville, NCDuring the takeoff phase of a touch & go landing the student plt lost directional control of the acft and ran off the side of the rwy. The student plt was on his third solo training flight.NTSB ATL86FA026Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Chester, SCWitnesses at the accident site estimated the ground visibility to be 100 yds or less. The instrument rated plt on the 32 NM flt had not filed a flt plan even though he had obtained a wx briefing from fss. The acft collided with the steel cables atop steel…NTSB NYC86LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Atlantic City, NJThe acft experienced a collapse of the nose gear during the landing roll after what the plt said was a normal landing. The right main gear was further damaged during removal of the acft from the rwy.NTSB NYC86LA036Accident · No injuriesLimited investigationFinal reportCessna C182 · Gardiner, NYThe acft contacted power lines on final apch and descended uncontrolled to ground impact. The plt reported that turbulence was encountered when he entered the traffic pattern. He then proceeded onto final apch at a 'normal altitude'and full flaps were added.…NTSB MKC86FA029Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Osage Beach, MOWitnesses observed N80426 lt of the final apch course for rwy 14 heading toward the arpt for landing. One witness said the acft was at 300 to 400 ft AGL when the nose of the acft rose abruptly, the lt wing went down and the acft descended to the ground. Other…NTSB FTW86FQG04Accident · 1 fatalFinal reportLagatore Thorp T-18 · Lubbock, TXThe acft contacted the terrain in a 75 to 85 deg nose down attitude following a loss of control. The plt was reportedly circling a friend's house at an alt of 800 to 1000 ft AGL when the acft stalled, entered a spin and descended to ground impact.NTSB DEN86LA025Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 6B · Englewood, COThe plt stated that while on a Balloon flt, the blast valve, which operates the burner flame, stuck open during one of the burns. The plt attempted unsuccessfully to disengage the blast valve. When the plt could not stop the flame with the blast valve, he…NTSB DEN86LA024Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berthoud, COThe plt stated that he made 7-9 high speed taxies to pack the snow on the grass strip, aborting mid-strip when flying speed was not attained. On the final run, the plt said the acft again failed to reach flying speed and decided to abort mid-strip. The plt…NTSB CHI86LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Coldwater, OHThe plt flying at a low altitude during a civil air patrol training maneuver struck a 30-FT high power line with the nose gear. The acft then nosed over and impacted the ground.NTSB CHI86FA029Accident · 2 fatalField investigationFinal reportCessna 172N · Mt Carmel, ILAccording to the survivor, the plt & 2 pax all had a beer, then went to the arpt. After taking off at night, the plt flew over Mt Carmel, then flew toward his home. He elected to make a low pass over his house. During the pass, the acft struck a tree & some…NTSB BFO86FA006Accident · 1 fatalField investigationFinal reportEipper Quicksilver MXL II · Parkton, MDWitnesses in the area observed the vehicle flying in the local area at other times however this was the first time they had seen two people in it. They also observed the vehicle flying erratically after liftoff and noted that the winds were gusty. Upon…NTSB SEA86LA024Accident · No injuriesLimited investigationFinal reportCessna 421C · Idaho Falls, IDDuring initial apch inflight icing was encountered. The windscreen failed to heat due to an inoperative inverter. A small area on the right bottom portion of the windscreen de-iced due to defrost heat. The plt elected to land using the small clear area of the…NTSB LAX86LA041Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Springerville, AZThe plt stated that the eng oil pressure dropped to zero while the acft was in cruise flight. He selected an open field in which to make a precautionary landing. He said that as he approached the field the acft entered a downdraft. He stated he had reduced…NTSB FTW86LPJ03Accident · No injuriesFinal reportCessna 182 · Goldsby, OKThe plt stated the purpose of the flt was to drop parachute jumpers. The jumpers deplaned at 8500 ft MSL and the plt reduced pwr for a descent and landing at the arpt of departure. He stated he did not apply carb heat during the entire descent and he entered…NTSB DEN86LA027Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ft. Collins, COThe acft collided with large chunks of snow on the rwy during takeoff roll. The plt stated that during the roll about mid-way down the rwy he spotted the snow and decided to abort but was unable to avoid the snow. The left gear contacted the snow and the acft…NTSB ANC86FA009Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Quinhagak, AKThe aircraft crashed on the frozen level tundra at night while on a part 135 air taxi flight from bethel to quinhagaki Alaska. The investigation revealled the commericial rated air taxi pilot did not have a 135 air taxi check ride or competency check. The…NTSB NYC86LA035Accident · Serious injuriesLimited investigationFinal reportLake LA4-200 · Millbrook, NYDuring a go-around the aircraft stalled and crashed on the airport.NTSB DEN86FA023Accident · Serious injuriesField investigationFinal reportBeech A45 · Albuquerque, NMWhile maneuvering to enter traffic at alameda arpt, the plt experienced severe acft vibrations. He attempted but was not able to reach the arpt due to rapid loss of airspeed andaltitude. The acft crashed 1/2 mile from the landing rwy. The one pax and a…NTSB SEA86LA023Accident · Minor injuriesLimited investigationFinal reportBrisbin Pientenpol Aircamper · Gig Harbor, WAA total loss of power occurred for unknown reasons shortly after takeoff. A 75 foot tree was struck with the aircraft striking the ground nose first and then coming to rest inverted. The engine was tested and ran normally with no abnormalities with the…NTSB LAX86FA039Accident · 1 fatalField investigationFinal reportCessna 182P · Cottonwood, AZWitnesses saw the plt depart with frost covering the acft & without either a runup or warmup. The witnesses reported that the plt 'scraped the frost from a small square directly in front of him on the windshield' just prior to takeoff. Temp & dew point were…NTSB CHI86LA028Accident · No injuriesLimited investigationFinal reportMooney M20F · Piper City, ILThe pilot elected to land on a paved road because his rla was too wet. The aircraft landed on top of a moving automobile. The aircraft remained on top of the automobile as it ran off the side of the road.NTSB ATL86FA025Accident · 2 fatalField investigationFinal reportCessna 182Q · Edenton, NCThe aircraft crashed into the abermarle sound and sank in 18 ft of water. The pilot was reportedly on an NDB approach and descended below mda. Witnesses stated that the aircraft circled over head about 15 minutes prior to the accident. Witnesses also stated…NTSB NYC86FA034Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Wellsville, NYAfter departure the plt made 3 practice isl apchs at bradford regional arpt located 35 mls away. The acft returned to Wellsville and was cleared for rwy localizer apch. The plt radioed Wellsville UNICOM for advisories and was informed that a fog bank was over…NTSB MKC86FA028Accident · 1 fatalField investigationFinal reportCessna 337B · Fayetteville, ARThe plt and his wife were flying to Alaska with the first en route stop to be canton, TX. The non-plt wife stated that as the acft passed over the departure end of the rwy on takeoff, her husband released the controls and threw his head back. She kept the…NTSB MKC86FA027Accident · 4 fatalField investigationFinal reportCessna 210K · Baxter Springs, KSAfter lndg at neosho, MO, the plt called the joplin fss at 1132 CST & reqd wx info for a flt to hays, KS. The specialistadvised that his wx computer was out of svc & suggested the plt contact another facility or call back in about 20 min. The plt indicated he…NTSB MKC86FA026Accident · 4 fatalField investigationFinal reportCessna P210N · Wichita, KSThe acdt occurred during an IFR, non-precision approach to the uncontrolled jabara airport. When the flt was one mile from the faf, ATC told the flt that in the event of a missedapproach N3864P should enter controlled airspace heading 360 deg. The controller…NTSB FTW86FA024Accident · 1 fatalField investigationFinal reportBeech S35 · Pampa, TXDrg arrival, N6843Q was cleared for an NDB rwy 17 apch. The plt's last radio call was at 1949 CST, when he acknowleged radar svc was terminated & freq chg was approved. When the acft did not arrive, a search was initiated. At 2335, after fog had lifted, the…NTSB DEN86FA022Accident · 1 fatalField investigationFinal reportPiper PA-25-235B · Holly, COAccording to the plt's brother, he was on a flt to calibrate the acft's spraying equipment & to make a few practice crop spraying runs. While flying at aprx 30 ft AGL, the acft struck power lines, then crashed to the ground & burned. No preimpact part failure…NTSB ATL86LA024Accident · Minor injuriesLimited investigationFinal reportGary E. Wilson Quickie · Paris, TNThe plt had completed several high speed taxi runs in the homebuilt acft prior to the attempted flt. The acft climbed to about 50-100 ft and reached a speed of apprx 65 mph. It would not accelerate nor climb any further. The plt attempted a turn back to the…NTSB SEA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORPrior to takeoff the pilot taxied through a lot of slush. A nose over occurred while attempting to land on a snow covered clearing. The nose over probably occurred due to very deep snow on the landing area and frozen brakes.NTSB LAX86FVD02Accident · 1 fatalFinal reportJohn Patrick Coleman Bensen B-8M · Eureka, CAOn November 12, 1985, at approximately 1345 PST an amateur built bensen B-8M aircraft owned and operated by John Patrick Coleman crashed while on a pleasure flight. VFR conditions prevailed and no flight plan was filed. The aircraft was destroyed and the…NTSB CHI86FA026Accident · 1 fatalField investigationFinal reportCessna 402C · Detroit, MIA 100-FT ceiling with 3000 ft RVR existed at Detroit. The plt attempted an ILS apch with a 200 ft dh when he struck trees one mile from the rwy. He flew the acft to the airfield but crashed near the threshold. The only apch plates found onboard were for…NTSB BFO86FA005Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Coatesville, PAThere was no wx rprtg stn at Coatesville, but aprx 25 mi ese at philadelphia, the forecast was for ocnl ceilings of 600'OVERCAST, vis 3 mi with lgt rain showers & fog. There were flt prctns for turbc blo 5000' due to wnd shear, ceilings & vis freq blo 1000' &…NTSB ATL86FKG05Accident · No injuriesFinal reportSmith, Ted Aerostar Aerostar 600 · Birmingham, ALThe left main gear collapsed during a loss of control on landing. The plt reported the acft touched down prematurely during the flare and it contacted the lip of the rwy at the apch end. Directional control could not be maintained, according to the plt, and…NTSB ANC86LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Rainbow Lake, AKThe plt reported that after the acft touched down on a snow covered, frozen lake, he was unable to hold the nose gear up, due to the depth of the snow. When the nose came down, the nose gear buckled under & the acft nosed over.NTSB SEA86LA022Accident · No injuriesLimited investigationFinal reportCessna T210N · Overton, NVSeveral diversions had been made due to encountering airframe icing. Once the pilot realized that a low fuel condition existed he asked for vectors to the nearest airport. The pilot had to make a forced landing due to fuel exhaustion 1 mile short of the…NTSB NYC86LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · West Chester, PAA practice VOR apch was made to the arpt. Afterwards a landing was attempted on rwy 27. A G0 around was made when the acft was too high on final. A second landing attempt was made. According to the CFI, while on final the student was headed for a touchdown…NTSB LAX86FA037Accident · 1 fatalField investigationFinal reportBeech 35 · Avenal, CAThe plt received a weather briefing (twice) and was advised each time that VFR flt along his route was not recommended. A witness observed the acft flying at a low alt below a cloud layer, when it made an abrupt left descending turn and crashed in a field.…NTSB CHI86MA025Accident · 5 fatalMajor investigationFinal reportCessna 441 · Derry, PADrg arrival, the plt was advised the destn wx was: estd 500' overcast, vis 1 mi with fog, arpt blo mins. The plt electedto make an NDB rwy 23 apch, but said he would divert if a missed apch was made. He was provided radar vectors & was clrdfor the apch. At…NTSB ATL86LA023Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Paducah, KYAfter being cleared for descent to 4,000 ft and to the localizer the acft lost two way communications. The plt stated that he lost his HSI and radio's. however, he was able to fly in the area around the VORTAC for almost an hour before he descended through a…NTSB ATL86FMG04Accident · No injuriesFinal reportCessna 177RG · Kenansville, NCThe acft contacted two piles of dirt during a gear-up landing. The plt took off with intensions of practicing touch and go landings. On the second apch, the plt was unable to fully extend the landing gear. The plt had one passenger check the hydraulic fluid…NTSB NYC86LA033Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Colts Neck, NJThe acft was being used to fly an advertising banner for the jersey shore marathon. The flt took off in a westerly direction, following the traffic pattern, climbing to aprx 1500 ft. a pullup maneuver was made to simulate a banner pickup. The plt checked for…NTSB NYC86FNE01Accident · No injuriesFinal reportDorfman,William A. Bede 4/275 · Westfield, MAThe aircraft collided with the ground off to the side of the runway during a takeoff attempt. The nose gear and the main gear collapsed during the ground contact. The wind blew the aircraft to the side with a wing raised and before recovery as effected the…NTSB LAX86FA038Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Gold Run, CAThe accident location and the departure airport is located in a mountainous area. The acft departed truckee-tahoe arpt (trk) to the northeast in marginal VFR conditions at sunset. The acft continued on a northeasterly heading for 18 miles and then turned to a…NTSB FTW86FRG03Accident · Serious injuriesFinal reportCessna 150G · Geronimo, TXThe acft failed to achieve proper climb to clear pwr lines during takeoff initial climb. The takeoff was performed on a 700 ft long grass strip in a downwind direction. When it became questionable that the acft could climb over a pwr line the plt cut the…NTSB DEN86LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Buffalo, SDAccording to officials, the plt was searching for hunters when the acft he was flying contacted the ground. Witnesses stated that blowing snow, low overcast clouds & visibility of less than 1/2 mi prevailed at the time of the acdnt. A blood sample was taken…NTSB DCA86AA004Accident · 6 fatalFinal reportDassault Falcon 50 · Fairview, NJDassalt falcon 50 (D50), N784B, was on vor/dme-a apch at dusk to circle/lnd at teterboro (teb), as Piper PA-28, N1977H, was transiting arpt traffic area (ata) fm west to east at 1500' in VFR (no flt pln). PA-28 plt was clrd thru ata by teb twr (staying blo…NTSB ATL86LLT02Accident · No injuriesFinal reportCessna 152 · Knoxville, TNThe plt was on a personal night proficiency flt. He made 2 stop & go landings without incident. On the 3rd landing, the acft touched down about 50 to 60 ft short of the rwy on upsloping terrain & the nose gear collapsed. The plt stated that he was making a…