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 CHI86FA042Accident · 3 fatalField investigationFinal reportLearjet 35A · Rochester, MNThe aircraft had just successfully completed a series of practice approaches to a full stop. The training flight was being conducted to give refresher training to the pilot who had not flown a lear jet in over a year and had never flown a lear model 35. The…Dec 8, 1985 · N15TW · DestroyedNTSB ATL86LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Stone Mountain, GAAfter an IFR flight into his home area, pilot changed dest to land on his home airport. Made a VFR pattern to land on rwy 17. Plt stated that he flared too late, hit the runway, bounced real high and went around. Made a soft field ldg and when tying acft down…Dec 8, 1985 · N4707N · Substantial damageNTSB SEA86LA029Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Idaho Falls, IDA total loss of power occurred during an ILS approach due to induction ice. During touchdown on 12 inches of snow a nose over occurred.Dec 7, 1985 · N5635D · Substantial damageNTSB LAX86LA058Accident · No injuriesLimited investigationFinal reportCessna 210D · Flagstaff, AZThe plt noticed a weakness of the acft's left brake during taxi for takeoff but elected to make the flt. Control tower personnel at the destination arpt stated the acft landed long and attempted to turn onto the right highspeed taxiway. The plt stated that…Dec 7, 1985 · N3762Y · Substantial damageNTSB FTW86LRG04Accident · No injuriesFinal reportCessna 150J · Temple, TXThe acft nosed over during a forced landing on soft terrain following a total loss of eng pwr. The plt reported that the eng quit while on a 45 deg entry to the downwind leg for rwy 15. The plt then attempted to restart the eng and maneuver the acft toward…Dec 7, 1985 · N51079 · Substantial damageNTSB FTW86FRA02Accident · Minor injuriesFinal reportCessna T210N · Houston, TXThe acft crashed in a wooded area during a forced landing after fuel exhaustion. The acft had extra fuel cans on board and had been flying for almost 12 hours in an attempt to avoid capture by U.S. Agents for the possession of marijuana. The acft contained…Dec 7, 1985 · N72WF · Substantial damageNTSB CHI86LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Carbondale, ILAccording to the student pilot flying the plane, after he touched down on his main wheels he lowered the nose and he heard a crack. The nose wheel then collapsed andthe aircraft slid to a stop. According to the operator of the aircraft no preexisting…Dec 7, 1985 · N62FS · Substantial damageNTSB CHI86LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Kalamazoo, MIUpon the approach to hover for landing on a snow covered airstrip, dry snow blew up and obscured the pilot's visual references. One skid touched down as the helicopter was moving laterally causing the aircraft to roll over on its side.Dec 7, 1985 · N7763 · Substantial damageNTSB CHI86LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Rochester, INUpon takeoff and after reaching an altitude of approx ten feet the right side of the cowl became unlatched and whipped up into the airstream, blocking the pilots forward view and causing some control problems. He elected to abort the takeoff and ran off the…Dec 7, 1985 · N4155N · Substantial damageNTSB ATL86FA037Accident · No injuriesField investigationFinal reportPiper PA-28-181 · Clover, SCThe aircraft experienced an engine failure during cruise flight and attempted an emergency landing in a field. During landing roll the aircraft collided with small trees on the FAR end of the field. Post-crash examination of the engine disclosed that the bolt…Dec 7, 1985 · N5388F · Substantial damageNTSB SEA86FA028Accident · Serious injuriesField investigationFinal reportCessna 335 · Pendleton, ORAt 500 ft AGL on departure climb, with lndg gear unretracted, plt felt vibrations similar to rough-running engine but noted no instrument indications, throttled back and leveled off. While trouble-shooting problem, plt noted acft was descending at 1200 fpm,…Dec 6, 1985 · N2711U · DestroyedNTSB DEN86LA041Accident · No injuriesLimited investigationFinal reportCessna 177B · Billings, MTThe acft was damaged during a forced landing in a fld following a loss of pwr from fuel exhaustion. The plt stated that during the preflight he checked the fuel level by the gages and not visually. The gages indicated slightly over one-half full at that time.Dec 6, 1985 · N13717 · Substantial damageNTSB DEN86LA040Accident · No injuriesLimited investigationFinal reportHelio H-391B · Bozeman, MTAccording to personnel in the area, the plt radioed he had smoke in the cockpit and was returning to gallantin field, his departure point. Later, the plt transmitted that the eng lost total pwr and he was making a forced landing. During the investigation, it…Dec 6, 1985 · N4101D · Substantial damageNTSB DEN86FA039Accident · 1 fatalField investigationFinal reportBeech 35-B33 · Columbia Falls, MTThe acft contacted snow covered terrain in an uncontrolled descent aprx 3 minutes after takeoff. The plt obtained a wx briefing from kalispell, MT, NWS and updated briefings from missoula and great Falls, MT, fss, for proposed night VFR flt to ogden, UT. VFR…Dec 6, 1985 · N5637K · DestroyedNTSB CHI86FA041Accident · 1 fatalField investigationFinal reportCessna 320 · Ada, OHThe pilot overflew a planned intermediate stop before running low on fuel. He was unable to find the airport he was being vectored to & attempted to land in a plowed field during dark conditions. As the aircraft passed over powerlines the aircraft was…Dec 6, 1985 · N5755X · DestroyedNTSB ATL86LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCStudent pilot was returning from a solo cross country flight. In his report the student said he flew a long final with the VASI showing a proper descent angle. The acft was landed with a shallow flare touching down in a flat attitude. It bounced, bounced…Dec 6, 1985 · N44687 · Substantial damageNTSB ATL86LA035Accident · No injuriesLimited investigationFinal reportCessna 182J · Bishopville, SCDuring an attempt to make a direct crosswind landing at a private grass airstrip, the plt allowed the acft to drift off the left side of the rwy where it nosed over in a plowed fld.Dec 6, 1985 · N2650F · Substantial damageNTSB ANC86LA012Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Shageluk, AKThe acft contacted trees and descended to the terrain while on an apch to a lake. The plt reported the acft windscreen kept frosting up and he had to repeatedly wipe it clean. In the process of wiping the windscreen he approached the lake at a lower than…Dec 6, 1985 · N97MM · Substantial damageNTSB NYC86FA048Accident · 2 fatalField investigationFinal reportPiper PA-28 · Selinsgrove, PAThe afct was seen flying at low alt before it collided with unmarked transmission lines at a height of 170 ft AGL. The acft pitched up and then descended to the ground. The top of the rudder and vertical stabilator were severed from the acft. The collision…Dec 5, 1985 · N652FL · DestroyedNTSB LAX86LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · San Jose, CAAfter completing a personal flight the plt landed the acft. Upon touchdown on the 8899 ft-long by 150 ft-wide rwy the plt failed to maintain directional control of the acft. There was a 70 deg, 8 kt. Right x-wind. The acft overran the runway's edge, entered a…Dec 5, 1985 · N82009 · Substantial damageNTSB LAX86LA056Accident · Minor injuriesLimited investigationFinal reportCessna P210R · Scottsdale, AZWhile descending from 9,500 to 5,000 ft MSL, the plt reported that the eng suddenly lost all power. The plt stated that he was unable to restart the eng & made an emergency landing at a nearby arpt. The plt, who had entered the downwind leg for the 8,251 foot…Dec 5, 1985 · N5298A · Substantial damageNTSB LAX86LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Deer Valley, AZShortly after begining descent from 7,500 ft. m.s.l. the acft experienced a total loss of power. Prior to descent the plt richened the mixture and applied carb heat. The pilot radioed his position & situation to Deer Valley tower, Deer Valley, Arizona while…Dec 5, 1985 · N3334A · Substantial damageNTSB LAX86FUJ02Accident · 2 fatalFinal reportCessna 182G · Gila Bend, AZOn December 4, 1985, at 1928 MST, a Cessna 182, N3205S, collided with a power utility pole near paloma, AZ. Visual meteorological conditions prevailed at the time and no flight plan was filed. The aircraft was destroyed and the two people on board the…Dec 5, 1985 · N3205S · DestroyedNTSB LAX86FA057Accident · 1 fatalField investigationFinal reportBeech F33A · Sacramento, CAOn December 4, 1985 at 2230 PST, a Beech F33A, operated by the owner, collided with trees during a missed approach at Sacramento metropolitan airport, Sacramento, California, while on a business flight. Instrument meteorological conditions prevailed at the…Dec 5, 1985 · N6541A · DestroyedNTSB CHI86LA040Accident · No injuriesLimited investigationFinal reportCessna 177 · Crookston, MNWhile doing a 270 degree turn on base leg for runway realignment the pilot permitted the acft to fly into the ground.Dec 5, 1985 · N3386T · Substantial damageNTSB ANC86IA010Incident · No injuriesIncident investigationFinal reportPiper Navajo PA-31-350 · Kenai, AKThe pilot in command could not raise the landing gear properly after departure. He diverted to Kenai, Alaska, whereupon extending the gear he obtained three safe gear indications. The pilot landed the airplane and upon roll out the left main gear collapsed.…Dec 5, 1985 · N492SC · Minor damageNTSB NYC86LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · East Moriches, NYThe acft was substantially damaged when it collided with trees during a forced landing following a loss of pwr during a takeoff climb. The plt reported that the pwr loss resulted from carb ice.Dec 4, 1985 · N3530S · Substantial damageNTSB CHI86FA038Accident · Minor injuriesField investigationFinal reportCessna T210M · Highland, MIFifteen minutes after takeoff an eng failure occurred. The plt force landed the acft in a fld but the roughness of the landing surface resulted in the nose and right main gear collapsed. Examination disclosed the exhaust vavle had failed in the #4 cylinder.…Dec 4, 1985 · N1982M · Substantial damageNTSB NYC86LA046Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Mt. Lafayette, NHThe acft, while in cruise flt en route to lyndonville, VT, encountered a severed downdraft and the plt was unable to penetrate or climb out of the descent. The acft continued to descend until impact with a mountain occurred. The acft contacted the terrain at…Dec 3, 1985 · N5281U · Substantial damageNTSB MIA86LA038Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Wimauma, FLThe plt stated that after turning on the rwy lights using the radio transmitter. They appeared to be dim, & only one side of the lights came on. He then landed south of the rwy at which time the right wing struck a fence post. The landing gear then collapsed,…Dec 3, 1985 · N700TD · Substantial damageNTSB LAX86FVD03Accident · 1 fatalFinal reportAero Commander 680T · Concord, CAOn 12/3/85 at aprx 0830, the acft was fnd lying inverted in a canal adjacent to the arpt where it had been on 24 hr standby for medical flts. Twelve days later, the plt's body was also fnd in the canal. An investigation revealed the acft had been taken…Dec 3, 1985 · N17690 · DestroyedNTSB CHI86LA050Accident · No injuriesLimited investigationFinal reportCessna 172RG · East Liverpool, OHAccording to the plt, he was unable to stop the acft at the end of the taxiway after he had taxied through water. The acft came to rest after sliding into a drainage ditch at the end of the taxiway. The plt continued the flt although the acft was damaged. The…Dec 3, 1985 · N6208V · Substantial damageNTSB DEN86FA034Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Englewood, COThe plt had been flying aprx 7 hrs and was completing the flt at night when the accident occurred. He was using visual cues (the arpt enviroment) to position the acft at a proper alt for a visual apch and landing. The terrain south of the arpt rises several…Dec 2, 1985 · N9250Y · Substantial damageNTSB DEN86FA033Accident · Serious injuriesField investigationFinal reportCessna 421B · Franktown, COThe acft departed nashville, TN, for a flt to aspen, CO. The plts made one refueling stop at chanute, KS. The plts were unable to land at aspen or a nearby alternate arpt (eagle, CO) and elected to return back to the denver area. The plts indicated to an…Dec 2, 1985 · N249JM · Substantial damageNTSB CHI86IA037Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Detroit, MIThe acft suffered a failure of the left rear axle during taxi to takeoff.Dec 2, 1985 · N90427 · Minor damageNTSB ATL86FA034Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Dacula, GAThe acft collided with trees 3.5 miles from the arpt during an instrument approach in dense fog. The approach required an adf receiver and the acft did not have one. The mda on the approach was 1600 ft. the acft impacted the trees at 1200 ft MSL. The acft was…Dec 2, 1985 · N9289J · DestroyedNTSB ANC86LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fishtrap Lake, AKPilot attempted to land his wheel equipped aircraft on frozen lake with water overflow and 12 to 18 inches snow. Acft broke through top layer of thin ice and nosed over upon touchdown.Dec 2, 1985 · N1237A · Substantial damageNTSB NYC86LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Hazleton, PAPiper aircraft ran off the runway during landing at Hazleton Pennsylvania. According to the pilot the first approach was missed due to bad visibility. The flight returned to the initial aprroach fix for a second attempt. The pilot broke out of the clouds at…Dec 1, 1985 · N4324D · Substantial damageNTSB MIA86LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Cedar Key, FLThe plt was attempting a night landing on his first night x-country & had not landed at this aprt prior to this time. He stated that during the flare, he was caught by a x-wind & blown into the trees adjacent to the rwy. Surface winds at the time of the…Dec 1, 1985 · N136AV · Substantial damageNTSB MIA86LA037Accident · No injuriesLimited investigationFinal reportBeech 60 · Lakeland, FLThe plt stated that he experienced a loss of power in both engines, made an emerg landing in a cow pasture, & struck a cow on landing rollout. Due to the extent of post crash fire no determination could be made as to the nature of the malfunction of the…Dec 1, 1985 · N7080D · DestroyedNTSB LAX86MA050Accident · 1 fatalMajor investigationFinal reportBell 206L-1 · San Pedro, CATwo Bell 206L'S (N3913Z oprd by helitrans, N5759Y oprd by island express) deptd avalon 2 min apart on flts to San Pedro. Arr route at destn was ovr a RVR with angling fnl acph arnd a floating restaurant (fr). Heliport (HP) was in congested area nr bridge,…Dec 1, 1985 · N3913Z · 2 aircraft · DestroyedNTSB LAX86LA052Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calexico, CAThe acft ground looped during a landing on rwy 08 at Calexico arpt. The plt reported that upon touchdown the acft began to swerve to the right. The plt applied left rudder to arrest the right swerve. The acft then began a swerve to the left and the plt was…Dec 1, 1985 · N7728K · Substantial damageNTSB LAX86LA051Accident · No injuriesLimited investigationFinal reportPitts S1-C · San Jose, CAThe plt was practicing takeoff and landings on rwy 13 at reid-hillview airport, San Jose, CA. The plt reported that during the base leg to final turn, while negotiating a 'power-off' apch, he attempted by apply pwr but was unable to do so. The acft crashed in…Dec 1, 1985 · N75PB · Substantial damageNTSB DEN86LA037Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Fort Collins, COThe plt stated that during takeoff roll the acft used over twice the normal distance to rwy to become airborne. After becoming airborne, the stall warning sounded, and continued to sound until the forced landing when the plt said he couldnot maintain alt. The…Dec 1, 1985 · N991OU · Substantial damageNTSB DEN86LA036Accident · No injuriesLimited investigationFinal reportCessna 152 II · Greeley, COAccording to the plt, during the landing roll the acft veered to the left of the rwy and struck a snow berm. The plt stated that the accident could have been prevented if he had held the 'nose wheel off the ground' longer and not relaxed his attention.Dec 1, 1985 · N49209 · Substantial damageNTSB BFO86FA008Accident · 1 fatalField investigationFinal reportBeech D95A · Millville, NJThe plt & his wife deptd sarasota FL for a 5HR and 10MIN planned flt to Millville, NJ. 5HRS and 8MIN ltr the acft crashed in woods abt 2 miles short of miv. Fuel calculations indicated the acft should have had ovr 11GALS left in the tanks. Witnesses located…Dec 1, 1985 · N26FM · DestroyedNTSB ATL86LA033Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Albany, GAThe aircraft landed on the wet sod runway with a 30 to 35 knot tailwind and ran off the end of the runway and into the trees. The pilot related that the wind shifted 180 degrees upon touchdown. The pilot also stated that he touched down approximately 1000 ft…Dec 1, 1985 · N999B · Substantial damageNTSB LAX86LA053Accident · No injuriesLimited investigationFinal reportMooney M20J · Taft, CAThe landing gear intransit light illuminated and stayed on when the plt attempted to retract the gear after takeoff. After all efforts to extend or retract the gear failed the plt elected to land at the arpt of departure. The landing gear collapsed on…Nov 30, 1985 · N201UH · Substantial damageNTSB DEN86LA035Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Beulah, NDDuring a landing at dusk on a snow covered rwy, the acft encountered deep snow and nosed over onto its back. The plt stated that after touchdown, he realized that there was aprx one ft of snow on the rwy and was unable to make a go-around.Nov 30, 1985 · N8143K · Substantial damageNTSB DEN86FA038Accident · 2 fatalField investigationFinal reportCessna C-182 · Gallup, NMThe plt departed las cruces, NM, on a VFR flt to Gallup,NM. Approx 23 miles from destination, in mountainous terrain, the non-instrument rated plt encountered unforecast snow storm conditons at night. While the plt was maneuvering toward the destination at a…Nov 29, 1985 · N52599 · Destroyed