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 ANC86LA017Accident · No injuriesLimited investigationFinal reportCessna C-177RG · Big Lake, AKWhile performing slow flight maneuvers, the student applied power with no response. Various combinations of controls produced no further response from the engine. The instructor and student completed a forced landing in a furrowed clearing at night.Dec 17, 1985 · N2191Q · Substantial damageNTSB MKC86LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Aurora, MOThe pilot stated there was patches of snow and ice on the runway surface a snow on the sides and as he pulled up the flaps, the airplane veered right, off the runway. He said that after he got the airplane back on the runway, it ground- looped to the left and…Dec 16, 1985 · N83956 · Substantial damageNTSB DEN86LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Logan, UTThe plt stated that shortly after a night departure, the acft entered a fog bank. The plt said he was turning to reverse direction and descending in order to avoid IMC. Prior to completing the turn, the plt encountered IMC and lost all outside visual…Dec 16, 1985 · N739KU · Substantial damageNTSB ATL86LA043Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Spartanburg, SCDuring landing roll the landing gear collapsed and the acft skidded to a stop on the rwy. The acft was substantially damaged and the plt was not injured. A witness stated that he observed the landing gear in the down position while the acft was in the traffic…Dec 16, 1985 · N4445K · Substantial damageNTSB ANC86LA015Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Dillingham, AKDec 16, 1985 · N777YA · Substantial damageNTSB NYC86LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mt. Joy, PAPiper aircraft was in cruise flight from lancaster, PA to mt joy, PA. When an oil line apparently fractured. An emergecny landing was made in a field. During landing, the nose collapsed and the aircraft was substantially damaged.Dec 15, 1985 · N7177W · Substantial damageNTSB MIA86LA043Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Homestead, FLThe plt stated that while on a flight from marco island FL, to ocean reef FL, he heard a loud bang and elected to land at Homestead general arpt. Upon landing he found the left muffler had seperated from the acft, struck the propeller and was driven through…Dec 15, 1985 · N2969P · Substantial damageNTSB FTW86FRG05Accident · No injuriesFinal reportAdams William C Quickie Q1 · Beeville, TXThe acft crashed during a forced lndg after a power loss at 200 ft AGL during takeoff. The acft crashed on the arpt in a run-up area adjacent to the rwy. The only discrepancy noted during post acc exam was a very weak spark produced by the battery coil…Dec 15, 1985 · N220WA · Substantial damageNTSB DEN86LA045Accident · No injuriesLimited investigationFinal reportCessna 150L · Aurora, COAccording to the CFI, during a touch & go landing, the student allowed the acft to drift to the left side of the rwy where it contacted a snow bank. The CFI stated she failed to correct for the drift soon enough to prevent the accident. The landing was being…Dec 15, 1985 · N19409 · Substantial damageNTSB DCA86AA011Accident · No injuriesFinal reportBoeing 747-136 · Boston, MAAprx 16 ft of the left inboard trailing edge flap separated while the acft was on final apch to land. The apch and landing were completed without further incident. Investigation revealed 5 of the 8 bolts which hold the no. 3 flap trackforward attach fitting…Dec 15, 1985 · GAWNE · Substantial damageNTSB CHI86LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dodgeville, WIAfter a x-country flt and during the landing roll the acft started to drift left on the snow covered rwy. The left main gear then encountered deeper snow causing the acft to swing to the left and run into a six-ft snowbank.Dec 15, 1985 · N8458H · Substantial damageNTSB BFO86LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Edgewater, MDUpon returning to lee arpt, Edgewater, MD, from a x-country flt to lancaster, PA, the student plt applied full flaps during the final apch for rwy 12. During the landing flare, the acft ballooned and the plt applied full pwr in order to execute a go-around.…Dec 15, 1985 · N427FL · Substantial damageNTSB ATL86LA042Accident · No injuriesLimited investigationFinal reportCessna 150L · Manning, SCDuring takeoff ground run on the wet grass runway the aircraft hit a soft spot in the runway and nosed over to an inverted attitude. Both the private pilot and passenger escaped without injury.Dec 15, 1985 · N19099 · Substantial damageNTSB ATL86FA041Accident · 1 fatalField investigationFinal reportMooney M20K · Langhorne, PAAcft collided with marked but unlighted transmission lines 670 ft fm rwy threshold. The lines are 81 ft above the threshold elevation and are marked but unlighted. They are also 1193 ft from the displaced threshold. The pilot did not have a current medical or…Dec 15, 1985 · N231A · Substantial damageNTSB ATL86FA040Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Springfield, TNThe acft collided with the ground inverted. Witnesses stated that the acft was performing loops prior to the accident. Reportedly, the plt was giving a female companion a 'joy ride'. The plt had recently received his commercial cert. Instrument rating & CFI…Dec 15, 1985 · N2697Z · DestroyedNTSB ANC86LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wasilla, AKAircraft lost control during landing and crashed into another private aircraft. Witness reported seeing aircraft make a fast appraoch, land long, ground loop and slide side ways into parked Aeronca. Witness stated that aircraft landed with a tailwind,while…Dec 15, 1985 · N7773K · Substantial damageNTSB ANC86FA014Accident · Serious injuriesField investigationFinal reportCessna C-207 · Napaskiak, AKAccording to the pilot-in-command, the weather at his destination was deteriorating so he diverted to Napaskiak where he encountered freezing drizzle rain and fog. While attempting to align himself with the runway for a landing to the south, the windshield…Dec 15, 1985 · N6497H · Substantial damageNTSB MIA86FA044Accident · 2 fatalField investigationFinal reportBeech BE-23 · Pensacola, FLShortly after takeoff on initial climb the aircraft was seen to crash back on the runway. Examination of the wreckage revealed that the right stabilator attach/hinge bolt was not installed, and the left stabilator attach/hinge bolt was found partially…Dec 14, 1985 · N6636B · DestroyedNTSB LAX86LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Glendale, AZAfter completing a LCL flight the plt returned to his home base arpt & proceeded to land on the 2400 ft long rwy. The plt reported that he was unable to stop at its end and collided with barricades and a fence. A witness reported that the acft skidded on the…Dec 14, 1985 · N3885F · Substantial damageNTSB FTW86LRG07Accident · No injuriesFinal reportCessna 150G · Donna, TXThe acft was damaged during a forced landing after a loss of power. The CFI said that ground reference maneuvers were being demonstrated to a student plt at 900 ft AGL and the engine sputtered. The CFI said that he applied carburetor heat and the eng quit.…Dec 14, 1985 · N2900J · Substantial damageNTSB DEN86LA046Accident · No injuriesLimited investigationFinal reportCessna 206 · Hardin, MTAfter ldg to the east on a snow covered dirt rwy, the pilot elected to t/o on an intersecting rwy to the south. He could not see the entire rwy surface from the position due to dwn slope from center of rwy. The acft impacted snowdrifts 40-50 mph on t/o gnd…Dec 14, 1985 · N5173U · DestroyedNTSB CHI86MA047Accident · 5 fatalMajor investigationFinal reportBeech B-60 · Carp Lake, MIDrg arrival, the plt reported a problem with his #1 nav, but said he would try to make an ILS apch. He said he would return to pontiac, if his ILS did not work. ARTCC cleared him for the ILS rwy 32 apch & instructed him to contact pellston radio (fss). At…Dec 14, 1985 · N24RT · DestroyedNTSB CHI86LA048Accident · No injuriesLimited investigationFinal reportCessna 152 II · Aurora, ILDuring initial climbout the student plt saw his IAS drop 10 KTS. He aborted the takeoff and land hard on the nose gear. Gear collapsed.Dec 14, 1985 · N4655P · Substantial damageNTSB MKC86LA034Accident · No injuriesLimited investigationFinal reportCessna 402B · Gardner, KSLanding on an ice covered rwy, the cross-wind was stronger than rptd. The acft drifted left despite control input to correct. The nose gear collapsed before the plt could initiate a go-around. The rptd wind was 340 degrees at 8 knots. The plt stated it was…Dec 13, 1985 · N3950C · Substantial damageNTSB MIA86LA042Accident · No injuriesLimited investigationFinal reportBeech E-18S · Opa Locka, FLThe plt stated that while on his takeoff roll, the left main wheel started to shimmy, the acft pulled left then veered off the right side of the rwy, collapsing the tail wheel & coming to rest in the grass.Dec 13, 1985 · N43T · Substantial damageNTSB LAX86LA065Accident · Serious injuriesLimited investigationFinal reportHiller H-23A · Madera, CAThe helicopter crashed during a local frost protection flight. After about one hour of light, in dark night time conditions, fog appeared suddenly and the pilot became disoriented and crashed into the ground.Dec 13, 1985 · N3107G · DestroyedNTSB LAX86FVA01Accident · 1 fatalFinal reportRobert D. Campbell KR-1 · Oakdale, CAThe acft crashed in a cow pasture in VMC wx. The acft left wing struck the ground in a steep angle of bank and the acft nosed in throwing the eng 450 ft farther across the field. The canopy & canopy latch were found prior to the impact point of the left wing.…Dec 13, 1985 · N12YC · DestroyedNTSB LAX86FA066Accident · 1 fatalField investigationFinal reportCessna 150 · Oxnard, CAThe acft took off, pitched up steeply, stalled, nosed over to the right and crashed, nose down into the grass south of the rwy. Post accident inspection of the acft disclosed that the 2 inch bolt the plt used as a control gust lock for the elevator and…Dec 13, 1985 · N7310X · DestroyedNTSB FTW86FA025Accident · 2 fatalField investigationFinal reportGates Learjet 35A · College Station, TXThe acft rolled to the right and crashed after a catastrophic (uncontained) failure of the rt eng during takeoff for a night flt. The rt eng fan rotor disc separated from the hub which damaged the cowling and some disc fragments buried in the fuselage but…Dec 13, 1985 · N723GL · DestroyedNTSB BFO86LHD01Accident · No injuriesFinal reportCessna 414 · Georgetown, DEThe acft impacted trees during a VOR apch and descended to ground impact. The plt flew the apch with the autopilot coupled. The alt hold and alert were set for the mda. When visual contact with the arpt enviroment was established, the plt disconnected the alt…Dec 13, 1985 · N13FH · DestroyedNTSB ATL86LLQ04Accident · No injuriesFinal reportBeech BE-60 · Lexington, KYThe left main gear and nose gear collapsed following a loss of control during touchdown. During the flare the acft banked sharply to the right and struck the rwy. The acft then bounced onto the left gear, collapsing it and the nose gear before slidding off…Dec 13, 1985 · N202TT · Substantial damageNTSB SEA86LA030Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B · Kimberly, IDA forced landing with a rollover onto snow occurred due to the number 3 cylinder rod failing.Dec 12, 1985 · N73208 · Substantial damageNTSB MKC86FA033Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Omaha, NEN8895E was climbing through 2,800' MSL, 15 min after takeoff and when the pilot retarded the throttle to climb power, the eng quit. The pilot selected an open field for the forced landing but collided with trees during the approach. Examination of the eng…Dec 12, 1985 · N8895E · Substantial damageNTSB DCA86RA010Accident · 256 fatalForeign investigationDouglas DC-8-63 · Gander, CanadaDec 12, 1985 · N950JWNTSB CHI86FA111Accident · No injuriesField investigationFinal reportPiper PA-46-310P · Evanston, ILThe aircraft was on climbout on an IFR flight plan in VMC conditions when the engine failed. A restart was attempted and the engine ran for a minute or less. Subsequent attempts were unsuccessful. The aircraft was over lake Michigan and had insufficient…Dec 12, 1985 · N4380A · DestroyedNTSB LAX86LA064Accident · Minor injuriesLimited investigationFinal reportCessna 335 · Yuba City, CAUpon completing a 35 min sight-seeing flight the plt entered the traffic pattern & prepared for landing. While descending, both engines lost all power. The plt stated that he repositioned the fuel selectors to the aux tanks, power was restored to the left…Dec 11, 1985 · N2708X · DestroyedNTSB LAX86LA062Accident · No injuriesLimited investigationFinal reportCessna 150K · Honolulu, HIThe plt reported that 5 mins after takeoff the eng reduced to idle pwr, & attempts to restore full pwr were unsuccessful. The plt did state that brief periods of pwr obtained by using the hand primer. The acft was unable to maintain alt & was ditched about 25…Dec 11, 1985 · N6347G · Substantial damageNTSB ATL86FA039Accident · 1 fatalField investigationFinal reportPiper PA-30 · Corning, NYDuring ILS runway 6 approach acft hit high terrain short of the outer marker. When on downwind for approach pilot said he was not receiving the localizer and asked for a surveillance approach. Controller said he could not provide. When cleared for the ILS…Dec 11, 1985 · N7770Y · DestroyedNTSB MKC86LA032Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Topeka, KSN4NP diverted from the original destination forbes field Topeka,Kansas to billard field,b NM away, due to weather. Billard ATCT advised the flight during initial contact, before N4NP reached the ILS fof, of the runway braking action. The pilot said braking…Dec 10, 1985 · N4NP · Substantial damageNTSB LAX86FA063Accident · 2 fatalField investigationFinal reportCessna TR182 · Independence, CAWhile en route, the acft collided with moutainous terrain (trrn) at an aprx elev of 13,500 ft. previously, the plt had requested & was rcvg traffic advisories fm ARTCC. Bfr the acdnt, the acft's psn & alt (mode c reply) were noted by the controller (ctlr). No…Dec 10, 1985 · N737SG · DestroyedNTSB CHI86FA046Accident · 2 fatalField investigationFinal reportAerospatiale SA365N · Adrian, MIThe purpose of this flight was to pick up an injured patient and return him to a medical center. The weather was adequate for a VFR takeoff. However, enroute weather reports indicated fog and probable low ceilings. According to the single survivor of the…Dec 10, 1985 · N5800H · DestroyedNTSB LAX86LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAOn December 9, 1985 at 0730 PST a Cessna 152 registered to walter d. cable of upand, California collided with a parked truck while taxiing for takeoff on the paralellel taxiway of rwy 24 at cable airport, Upland, CA. VMC prevailed at the time. The airport was…Dec 9, 1985 · N64851 · Substantial damageNTSB LAX86FA061Accident · 3 fatalField investigationFinal reportPiper PA-28-201T · So. Lake Tahoe, CAPrior to departing on a VFR flt from south lake Tahoe, CA, to tracy, CA, the plt failed to obtain a wx briefing or file a flt plan. Wx at the arpt of departure was reported as scattered clouds at 1500 ft, broken ceiling conditions at an estimated 3000 ft,…Dec 9, 1985 · N2854R · DestroyedNTSB DEN86LA042Accident · No injuriesLimited investigationFinal reportCessna 172P · Missoula, MTThe solo student plt was attempting to land during a local flt when he lost control of the acft during the landing roll. The plt stated that the acft veered to one side of the ice covered rwy where it contacted 6 to 8 inches of snow, the acft continued…Dec 9, 1985 · N64069 · Substantial damageNTSB NYC86FA049Accident · 1 fatalField investigationFinal reportCessna 340A · Peru, MADuring IFR flight at 12000 feet both aircraft vacuum pumps failed. Aircraft descended in right turn off radar. Witnesses observed aircraft at low altitude above trees, circle, make steep left turn, climb and descend to ground.Dec 8, 1985 · N36888 · DestroyedNTSB MIA86LA041Accident · No injuriesLimited investigationFinal reportCessna 337F · Sarasota, FLThe plt stated that all attempts to extend the landing gear were to no avail. He then intentionally landed gear up on the left side of rwy 4.Dec 8, 1985 · N1158M · Substantial damageNTSB MIA86LA040Accident · No injuriesLimited investigationFinal reportDouglas C. Campbell Varieze · Orlando, FLThe plt stated that the acft lost power, & in an attempt to return to the arpt, the acft collided with a light pole & some orange trees, coming to rest on a canal bank. Post crash examination of the eng revealed that it failed because the #4 rod ass'y…Dec 8, 1985 · N111VE · Substantial damageNTSB LAX86LA059Accident · No injuriesLimited investigationFinal reportMooney M20E · Selma, CADuring cruise on a VFR x-country flt, the plt stated that the eng became rough with moderate vibration levels. After shutting down the eng, the plt made a forced landing in a fld, collided with gnd obstructions & collapsed all 3 landing gear. Examination of…Dec 8, 1985 · N5516Q · Substantial damageNTSB FTW86LPA08Accident · No injuriesFinal reportCessna 152II · Frisco, TXThe student plt stated that he departed mckinney municipal arpt at aprx 1030 LCL en route to wichita falls, TX. He said he became disoriented while en route, but landed at wichita falls at aprx 1220 LCL. The plt did not refuel the acft. He then departed…Dec 8, 1985 · N4731H · Substantial damageNTSB DEN86LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Aurora, COAccording to the plt, the right wing struck a fence while diverting off the taxiway centerline to make room for another oncoming acft. Contact with the fence resulted in a bent spar in the right wing.Dec 8, 1985 · N37550 · Substantial damage