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.

NTSB MKC86LA086Accident · No injuriesLimited investigationFinal reportGrumman G164B · Advance, MOThe airplane was being operated as an agricultural aircraft when the engine started backfiring and then quit. During the forced landing in a plowed field, the airplane flipped forward to the inverted position. Investigation revealed the teeth on the left…Apr 12, 1986 · N6609Q · Substantial damageNTSB LAX86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Salinas, CAThe acft stalled and collided with the ground shortly after departing rwy 31 at Salinas municipal airport. Neither the certified flight instructor nor the dual student was injured. The instructor reported that she was giving the student plt 'touch and go'…Apr 12, 1986 · N24274 · Substantial damageNTSB LAX86LA175Accident · No injuriesLimited investigationFinal reportRobinson R22 · Grand Canyon, AZThe pilot stated that he was attempting to land on a dirt road and that the helicopter was at a two to five foot hover when a gust of wind pivoted the tail into the wind. The helicopter touched down and rolled over onto its right side. The pilot further…Apr 12, 1986 · N211DM · Substantial damageNTSB LAX86LA174Accident · No injuriesLimited investigationFinal reportCessna 172N · Mesa, AZThe plt lost control of the acft during a touch and go maneuver and ran off the rwy. After touchdown the acft lifted back off the ground and drifted right. The acft then settled and touched down on the right shoulder of the rwy. The plt then noticed a…Apr 12, 1986 · N6235D · Substantial damageNTSB LAX86LA173Accident · No injuriesLimited investigationFinal reportCessna 182A · Death Valley, CAThe acft collided with terrain after a loss of pwr 50 yards short of the rwy. The plt stated he used various fuel selector positions while en route. Upon entry into the traffic pattern on a right downwind, the left tank was selected. On final apch the plt…Apr 12, 1986 · N5925B · Substantial damageNTSB FTW86LQG14Accident · Minor injuriesFinal reportPiper PA-36-400 · Semonole, TXThe acft nosed over during landing. The plt stated that he landed straight in to the south in a 45 degree tailwind. The landing was made on a dirt strip after an aerial application flt.Apr 12, 1986 · N2401Z · Substantial damageNTSB FTW86LA064Accident · Serious injuriesLimited investigationFinal reportTaylorcraft L-2 · Graham, TXWitnesses stated the aircraft stalled during a sharp right bank at approximately 150 feet. The propeller exhibited no signs of rotation at impact. The engine was dissassembled in an attempt to determine the apparent failure. No evidence of pre-impact failure…Apr 12, 1986 · N50639 · Substantial damageNTSB FTW86FA063Accident · 1 fatalField investigationFinal reportCessna 177RG · Dallas, TXThe pilot was advised by the FAA weather briefer, prior to flight, against making this flight due to present and forecast weather conditions. After arriving in the general area of his destination the plt observed the weather conditions and commented on thier…Apr 12, 1986 · N8047G · DestroyedNTSB DEN86LA122Accident · No injuriesLimited investigationFinal reportRJB Skybolt A-1 · Erie, COThe plt reported that the acft encountered a ridge on the rwy during the landing roll and swerved off the side. He said weather was not a factor. An FAA ops inspector examined the rwy after the acdnt and could not locate the reported ridge.Apr 12, 1986 · N42RJ · Substantial damageNTSB DEN86FA115Accident · Minor injuriesField investigationFinal reportCessna 207A · Ogden, UTAcft was en route to slc where it was to be put on static display with other acft equipped with soloy-conversions (allison 250-C20S turboshaft engine installation). During descent through 12,000 ft into slc area eng flamed out and the prop auto-feathered. Plt…Apr 12, 1986 · N1721Q · Substantial damageNTSB CHI86LA124Accident · No injuriesLimited investigationFinal reportHughes 269A · Lowell, MIThe pilot had just completed two autorotations when he landed hard on the third. The main rotor flexed down severing the tailboom and tailrotor. Although the pilot had logged over 6000 hours flight time, he had only 51 hours total rotorcraft time. He had…Apr 12, 1986 · N8059H · Substantial damageNTSB ATL86LA111Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Waynesville, OHThe pilot misread his altimeter and misjudged his altitude while in the traffic pattern for landing at the private gliderport. The glider collided with powerlines on the approach end of the runway and crashed short of the runway surface.Apr 12, 1986 · N2760R · Substantial damageNTSB ATL86LA110Accident · Serious injuriesLimited investigationFinal reportAeronca L-3B · Harrison, OHDuring a demonstration flight to a resident who lived near the airport, the acft crashed in a plowed field in a departure stall. The flight was intended to demonstrate the safe maneuverability of the acft and deception of altitude clearances from the…Apr 12, 1986 · N47187 · Substantial damageNTSB SEA86FA100Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Lone Pine, IDAfter an initial weather briefing the plt departed coeur dalene, Idaho, for his destination of Idaho falls, Idaho, with a planned passenger pickup at missoula, Montana. During the second leg of the flt he misnavigated while avoiding weather which resulted in…Apr 11, 1986 · N3714T · DestroyedNTSB MKC86LA085Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jackson, MOIn cruise flt the PIC smelled something burning and noticed black and white smoke pouring fm the eng cowling. This was followed by a partial loss of pwr. A precautionary landing was made in a field. The PIC noticed flames erupting fm the eng area after…Apr 11, 1986 · N5564X · Substantial damageNTSB MIA86FA119Accident · 2 fatalField investigationFinal reportBeagle B206-2 · Pedro, FLImmediately after take-off, the left eng seized & the prop stopped due to a connecting rod failure. Witnesses reported that about 200 ft above the ground, the acft rolled to the left and collided with a powerline before crashing to the ground in a near…Apr 11, 1986 · N112CS · DestroyedNTSB DEN86LA114Accident · Minor injuriesLimited investigationFinal reportAerotek PITTS-S-1S · Loveland, COAccording to the plt, the acft encountered a tailwind during the landing roll. The plt said the acft nosed over onto its back when he applied brakes. The plt had indicated his total flt experience in this tail wheel acft to be aprx 4 hrs.Apr 11, 1986 · N14RN · Substantial damageNTSB CHI86FEP03Accident · Minor injuriesFinal reportSteinorth Extra Long EZ · Kenosha, WIDuring an apch to land, the eng of the home built acft lost power. The plt tried to restart the eng by using the ignition switch, but was unable. He turned to land in a pasture, but the acft hit an electrical wire & came to rest in a row of trees. The plt…Apr 11, 1986 · N123AE · Substantial damageNTSB CHI86FEE02Accident · Serious injuriesFinal reportCessna 182Q · Lansing, ILWhile on the return flt to Lansing, IL, the plt checked the midway ATIS for info. He believed that just before landing at the Lansing muni arpt, the wind had shifted to the east. According to witnesses, the acft touched down on the last 1/3 of the 2432 ft…Apr 11, 1986 · N94531 · Substantial damageNTSB ATL86LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Birmingham, ALAfter takeoff pilot noted loss of engine oil pressure. Engine siezed and pilot landed short of runway. A/c hit ILS antenna during landing roll, severed right wing. Engine oil cooler line burst due to aging. Line was fabricated in the 1st qtr 0F 1972. Oil…Apr 11, 1986 · N4087W · Substantial damageNTSB SEA86LA099Accident · Serious injuriesLimited investigationFinal reportMorley Avid Flyer · Spokane, WAWhile on a five-mile final, a total loss of power occurred. A loose right magneto contacting the flywheel magnet and shorting the electrical system was found. In an attempt to miss a river in the approach path to the runway, the pilot attempted a 180 degree…Apr 10, 1986 · N318M · DestroyedNTSB SEA86FA098Accident · 2 fatalField investigationFinal reportPiper PA-32-301T · Fort Hall, IDRadar track showed acft made normal climb on course from airport (elev 4488 ft MSL) to 9400 ft. MSL, then executed a left turn of about 90 degrees, climbing to 9700 ft MSL as shown by next-to-last radar tgt. 29 secs later, final radar tgt showed 6900 ft MSL.…Apr 10, 1986 · N82238 · DestroyedNTSB MKC86LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Perry, IAShortly after takeoff the PIC noticed a loss of engine pwr and flames erupting from the engine cowling. The PIC executed a turn back to the arpt as thick black smoke filled the cockpit. The PIC opened the side vent window to maintain sight of the ground and…Apr 10, 1986 · N8178N · Substantial damageNTSB LAX86LA172Accident · No injuriesLimited investigationFinal reportCessna 182 · Jackson, CAThe acft went out of control and collided with terrain during a landing roll on rwy 19. The plt stated that a gust of wind lifted the right wing during the landing roll and the acft departed the rwy and collided with a ditch. The plt reported that the winds…Apr 10, 1986 · N9875E · Substantial damageNTSB LAX86LA171Accident · No injuriesLimited investigationFinal reportCessna 172D · Mojave, CAThe acft wing struck a tree during taxi on a dirt road being used for takeoff. The CFI said that he did not make a survey to identify obstructions before the taxi for takeoff. The acft had landed on the road when the CFI could not regain eng power following a…Apr 10, 1986 · N2762U · Substantial damageNTSB LAX86LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · San Jose, CAThe acft collided with terrain after a complete loss of pwr while on final apch. Post accident exam of the acft disclosed no fuel in either the main tanks nor in the carburetor fuel line. The plt indicated on his plt/operator accident report the right and…Apr 10, 1986 · N9237K · Substantial damageNTSB DEN86LA113Accident · No injuriesLimited investigationFinal reportde Havilland DHC · Pembina, NDThe plt stated the eng quit because the fuel cap had not been properly secured and the fuel had siphoned out in flt.Apr 10, 1986 · N713W · Substantial damageNTSB SEA86LA097Accident · No injuriesLimited investigationFinal reportCessna 180K · Emigrant Pass, NVThe plt was informed during a wx briefing that VFR flt was not recommended. The plt elected to takeoff regardless and encountered low ceilings and visibilities. While looking for an area of a highway to land the acft, pwr lines were contacted with the top of…Apr 9, 1986 · N644FM · Substantial damageNTSB SEA86FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · East Wenatchee, WAThe plt departed arpt in bottom of columbia river gorge on night VFR flt to spokane, WA. Five to six min after departure acft impacted terrain on lip of canyon wall. Plts reported moderate to severe turbulence near the bluff line before and after crash. The…Apr 9, 1986 · N42496 · DestroyedNTSB FTW86LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · El Paso, TXA student pilot, practicing touch and go landings, attempted a go-around. The pilot did not maintain sufficient airspeed before the aircraft stalled and collided with the runway.Apr 9, 1986 · N69054 · Substantial damageNTSB DEN86FA112Accident · 3 fatalField investigationFinal reportCessna T-210N · Jay Em, WYThe non-instrument rated plt took off on a VFR flt into an area of forecast adverse wx. Radar track of the acft at 9,700 feet MSL was lost in the vicinity of the accident site at 0930 MST, 4/9/86. The acft wreckage was located at 1155 MST, 4/10/86 and was…Apr 9, 1986 · N6535N · DestroyedNTSB MKC86FA083Accident · 1 fatalField investigationFinal reportGlasair 2 · Cheney, KSThe acft approached Cheney lake, west of wichita, Kansas at low altitude from the southeast. Several witnesses fishing from the bank saw the acft pass near the Cheney lake marina heading toward the lake. The acft then entered a spin and crashed into the lake…Apr 8, 1986 · N161JD · DestroyedNTSB MIA86LA117Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Miami, FLThe student plt was on a supervised solo flt & was hovering. The helicopter was seen to wobble, roll to the right & crash to the ground. The owner of the helicopter stated that he had flown the acft just prior to the accident & the acft performed normally.…Apr 8, 1986 · N428FH · Substantial damageNTSB MIA86LA116Accident · No injuriesLimited investigationFinal reportBeech BE-95 · Hollywood, FLThe acft had not been flown in over 2 yrs & the last annual inspection was performed 1-25-83. The acft had to be jump started due to a dead battery. During ldg roll-out, the gear collapsed. An exam of the bottom of the acft revealed damage consistent with the…Apr 8, 1986 · N17AT · Substantial damageNTSB LAX86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Hesperia, CADuring a solo instructional flight the student plt attempted to land on a 3910-foot-long rwy which had its landing threshold displaced by 550 feet. The wind was light & variable, & the student plt was low on short final approach. The acft collided with the…Apr 8, 1986 · N5889V · Substantial damageNTSB LAX86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mesa, AZThe pilot lost control of the aircraft which traveled off the runway following a nose gear collapse during landing. Examination of the aircraft revealed evidence of side loading.Apr 8, 1986 · N3872E · Substantial damageNTSB FTW86LA065Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Del Rio, TXThe student pilot was being instructed in the landing of a tail dragger aircraft, when he lost control of the aircraft at touchdown. The instructor failed to take corrective action when the student pilot inadvertently applied left brake, causing the aircraft…Apr 8, 1986 · N2360B · Substantial damageNTSB DEN86LA111Accident · No injuriesLimited investigationFinal reportCessna 170B · St George, UTThe plt stated the acft encountered a crosswind and ground looped during the landing touchdown.Apr 8, 1986 · N2436D · Substantial damageNTSB CHI86FA119Accident · Minor injuriesField investigationFinal reportBoeing 737-222 · Chicago, ILThe left main landing gear collapsed moments after touchdown. Winds as reported by the twr were from 350 degs at 19 KTS gusting to 29 KTS. The captain and copilot reported the touchdown was normal. The 3 flight attendants said the aircraft landed hard and…Apr 8, 1986 · N9054U · Substantial damageNTSB BFO86LA022Accident · No injuriesLimited investigationFinal reportCessna 152II · Clinton, MDThe acft nosed over following a loss of control during touchdown. The student plt stated the acft bounced after touching down on all three landing gears. The pilot stated she may have panicked and pushed the control yoke forward. The acft touched down on the…Apr 8, 1986 · N757JZ · Substantial damageNTSB ATL86LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Charlotte, NCDuring the attempted takeoff the acft skipped, climbed a few feet, settled to the ground then climbed again before the plt attempted to abort the takeoff. The acft overran the end of the rwy, crossed a road and hit a ditch and nosed over. An estimated weight…Apr 8, 1986 · N2851Q · DestroyedNTSB SEA86IA095Incident · No injuriesIncident investigationFinal reportRaven RX-7 · Beaverton, ORThe pilot misjudged obstacle clearance during his descent for landing. The balloon's envelope was then impaled on a light pole. Flt time was not reported by the plt.Apr 7, 1986 · N27980 · Minor damageNTSB NYC86LA101Accident · Serious injuriesLimited investigationFinal reportDouglas DC-10-30 · Jamestown, NYA sabena world airlines DC-10-30 descending from FL 410, enroute from detroit, mi to boston ma, encountered high altitude windshear as it was descending through FL 404. The pilot, passengers and flight attendents state that they felt vibrations prior to an…Apr 7, 1986 · 00SLB · Minor damageNTSB MKC86FA082Accident · Serious injuriesField investigationFinal reportHiller UH-12B · Fall River, KSThe helicopter flew through the tops of trees next to a plowed field and impacted almost straight down in the plowed field and nosed over to the inverted position. The pilot stated that he had intended to land in the field and allowed the airspeed and main…Apr 7, 1986 · N5307V · DestroyedNTSB MIA86LA114Accident · No injuriesLimited investigationFinal reportCessna 177RG · Orlando, FLThe plt stated that on final apch he extended the landing gear but on touchdown the gear completely collapsed. Post crash examination of the acft revealed that the alternator belt was loose allowing the battery to drain down enough so the electric hydraulic…Apr 7, 1986 · N35911 · Substantial damageNTSB MIA86FA115Accident · 1 fatalField investigationFinal reportPitts Special · Homestead, FLThe plt was on a flt to practice aerobatic mnvrs in a designated practice area. A witness, who was driving nearby, stated that he saw the acft 'falling straight down' & crash in a tomato field. An investigation revealed evidence that the acft had impacted in…Apr 7, 1986 · N501L · DestroyedNTSB LAX86FA167Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Mesa, AZWhile on the fourth leg of an IFR business flight from stow, Ohio to santa paula, California, the airplane experienced fuel exhaustion and crashed about 1 1/2 miles northeast of falcon field (ffz), Mesa, Arizona. The flight was being conducted under the…Apr 7, 1986 · N555KS · Substantial damageNTSB CHI86LA117Accident · Minor injuriesLimited investigationFinal reportCessna 172-RG II · St Paul, MNDuring climbout after t.o. and passing thru 4000 ft smoke began to enter the cabin. Plt declared an emergency and turned toward arpt. Eng then began to shake violently. Acft was cleared to ld but plt continued to a point four mi past base leg, attempted to…Apr 7, 1986 · N9538B · Substantial damageNTSB BFO86FA021Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Chesapeake, VABefore the flt, the plt was observed drinking in a bar. He & 3 others then drove to the arpt, where rprtdly, the wx was bad & the visibility was restricted by fog. After awhile, the plt stated he was going to taxi the acft around the arpt & invited the others…Apr 7, 1986 · N9636W · DestroyedNTSB ATL86LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300T · Fort Deposit, ALShortly after takeoff smoke and flames entered the cockpit. The pilot returned to the airport and landed hard damaging the firewall. Examination of the aircraft revealed that the turbo charger exhaust clamp broke and allowed hot exhaust gases to ignite a fire…Apr 7, 1986 · N22370 · Substantial damage