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 SEA85LA039Accident · No injuriesLimited investigationFinal reportCessna 152A · Pullman, WAPlt made 10 touch and go landings and had just raised the flaps and was applying full pwr to initiate another takeoff. Noting he was rt of the centerline he applied left rudder. Acft veered sharply to the left where it slid on ice into a snowbank.Jan 5, 1985 · N4702A · Substantial damageNTSB MIA85LA072Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Pompano Beach, FLThe balloon envelope struck a palm tree and a building while landing. The basket turned over when it contacted the ground. A passenger was injured when another passenger fell on her as the basket turned over.Jan 5, 1985 · N4270A · Minor damageNTSB LAX85FA097Accident · No injuriesField investigationFinal reportCessna 182P · El Monte, CAShortly after takeoff at an alt of aprx 300 ft AGL, a ttl loss of pwr was experienced. The plt attempted a forced landing in a residential area but upon realizing the area was too congested, the acft was intentionally landed in a large tree. Post accident…Jan 5, 1985 · N58816 · Substantial damageNTSB FTW85LA092Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Oklahoma City, OKThe plt-in-command (PIC) reported that after touchdown, the spoilers & brakes were applied, but no braking action was felt although peddle pressure was evident. He stated that by the time it was clear that the brakes were ineffective,insufficient rwy remained…Jan 5, 1985 · N55PT · Substantial damageNTSB DEN85LA061Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Newburg, NDPlt attempted takeoff on a slippery, snow covered field with a 45 degree x-wind. Acft veered during the takeoff ground run and left main gear sheared off after contacting a snowbank.Jan 5, 1985 · N5046C · Substantial damageNTSB DEN85LA060Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Billings, MTPlt used cannula connected to portable oxygen system during climb starting at 11,000 ft MSL. At FL 170 plt switched to a mask connected to acft oxygen ststem. At FL 250, plt complained of stomach pains for aprx 1/2 hr. Plt then stated to his son that his…Jan 5, 1985 · N6750C · Substantial damageNTSB ANC85LA033Accident · Serious injuriesLimited investigationFinal reportMaule M6-235 · Trading Bay, AKThe plt-in-command, IA an attempt to avoid a mid-air collision, did not control his airplane sufficiently to avoid a stall. Once in the stall the plt-in-command did not properly recover & the airplane mushed into the ground.Jan 5, 1985 · N5652D · Substantial damageNTSB NYC85FA052Accident · 1 fatalField investigationFinal reportHughes 500D · Newark, NJThe right front seat passenger deplaned and walked rearward to retreive his luggage from the left rear seat of the helicopter during the cooling down stage of the engine shutdown. After deplanning he proceeded rearward under the main rotor wash. When rear of…Jan 4, 1985 · N1106M · Minor damageNTSB MKC85IA045Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · St. Louis, MOAfter departing st Louis and reaching cruise flt the crew experienced a continual trim pitch-up which had to be relieved by a reduced airspeed. No aural indication was noted by the crew. The return to the airport was uneventful. Follow-up inspection of the…Jan 4, 1985 · N322BA · No damageNTSB LAX85LA096Accident · No injuriesLimited investigationFinal reportCessna 172RG · Camarillo, CAThe plt reported that upon landing a strong gust of wind caused the acft to deviate to the left. Application of the appropriate flight controls did not arrest the deviation. Brakes were applied but not in time to prevent the acft from exiting the rwy. The…Jan 4, 1985 · N5194U · Substantial damageNTSB DEN85LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Rawlins, WYThe acft lost eng pwr and was substantially damaged during an off arpt energency landing. The purpose of the flt was to look for coyotes. The post accident eng exam revealed that 9 consecutive teeth on the left magneto drive gear were ground off. This allowed…Jan 4, 1985 · N3575Z · Substantial damageNTSB BFO85FA011Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-25 · West Point, VAAfter being delayed at least 2 days at youngstown, OH, due to maintenance problems the plt departed at aprx 1725 hrs with the knowledge that the wx at his destination was ift to lifr. In addition, the plt was scheduled for a vacation and had expressed hopes…Jan 4, 1985 · N275MA · DestroyedNTSB ANC85LA032Accident · No injuriesLimited investigationFinal reportCessna 207A · Nuiqsut, AKAfter a night landing by the copilot, and after the first bounce, the pilot in command took control of the aircraft after it developed a high sink rate. The pilot then ground looped the aircraft.Jan 4, 1985 · N9237M · Substantial damageNTSB MKC85LA043Accident · No injuriesLimited investigationFinal reportCessna 182P · Ellisonore, MOPlt obtained wx briefing for route from moline, IL, st. louis, MO, memphis, TX, to new orleans, LA. Plt was informed vfrwas not recommended in eastern Iowa but st. louis was VFR and forecast to be 1000 to 2000 ft broken to scattered all morning. VFR was also…Jan 3, 1985 · N20828 · Substantial damageNTSB LAX85LA092Accident · No injuriesLimited investigationFinal reportBell 2061-1 · Santa Barbara, CADuring takeoff & departure, the helicopter climbed to about 150 ft AGL & started to proceed over water. As it crossed over the shoreline near the end of the rwy, the eng flamed out. The plt turned about 120 deg back toward a Beech area & made an autorotative…Jan 3, 1985 · N2246Q · Substantial damageNTSB DEN85LA057Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Salt Lake City, UTThe helicopter collided uncontrolled with the terrain during external load operation. A 100 ft steel cable was attached to the cargo hook on the helicopter and a nylon sling was attached to the cable so a snowcat could be pulled out of a mud area. The plt…Jan 3, 1985 · N1356A · DestroyedNTSB DEN85LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Yoder, COEngine quit during cruise flight. Pilot made forced landing on dirt road during which the acft veered off the road and collided with a fence post. Fire department officials reported no evidence of fuel either in the fuel tanks or around the acft.Jan 3, 1985 · N2112K · Substantial damageNTSB DEN85FTI01Accident · 1 fatalFinal reportPolliwagen 2 Place · Manhattan, MTThe acft crashed in an open flt shortly after takeoff and was destroyed by fire. There were no witnesses to the accident. The plt reportedly stated he needed to depart Manhattan by 0500 MST to arrive in helena before 0600 MST when the ATC twr opened as his…Jan 3, 1985 · N13954 · DestroyedNTSB MKC85FA042Accident · 1 fatalField investigationFinal reportCessna 150F · Pawnee City, NEPlt and passenger departed to fly over a group of friends who were on a coyote hunt. Witness stated the acft approached from the NE aprx 300 ft AGL. Acft then made a left crcling turn and was described as flying very slow. After completing aprx 360 degrees of…Jan 2, 1985 · N7138F · Substantial damageNTSB DEN85LA058Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Lordsburg, NMPlt stated that during the flt the rt fuel tank was used until empty at which time the left tank was selected. Aprx 20 minutes after switching tanks and 2 hrs 35 minutes after departure, the engine backfired and subsequently quit. A forced landing was made…Jan 2, 1985 · N101PQ · Substantial damageNTSB CHI85LA083Accident · No injuriesLimited investigationFinal reportCessna 172M · Mt Sterling, ILThe plt landed long at his home arpt using no flaps with a prevailing tailwind. The 2600 ft turf strip was frozen. During braking the acft skidded off the rwy and struck a snow berm before rolling inverted.Jan 2, 1985 · N9484H · Substantial damageNTSB SEA85LA038Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Port Townsend, WAThe plt stated that once airborne during takeoff, the left wing dropped. Plt attempted remedial action, however, the acft contacted the left side of the taxiway in a nose down, left wing low attitude.Jan 1, 1985 · N4502E · Substantial damageNTSB NYC85FNC02Accident · Serious injuriesFinal reportPiper PA-34-200T · Hopkinton, NHThe acft collided with a tree during an ILS approach in IMC wx. The acft was on a x-cty flt and the plt declared a missed approach at this pt but did not acknowledge hitting the tree. When the rt eng quit and directional control could not be maintained the…Jan 1, 1985 · N47364 · DestroyedNTSB MIA85FA071Accident · Serious injuriesField investigationFinal reportFuji LM-1 "NIKKO" · Odessa, FLThe acft collided with the ground in an acft parking area on the arpt after a low alt loop which was not completed prior to ground contact. The plt had made one low pass down the rwy in formation with another Fuji acft, a 2nd pass ended in an aileron roll,…Jan 1, 1985 · N2104X · Substantial damageNTSB DEN85LA054Accident · No injuriesLimited investigationFinal reportCessna 180 · Marion, MTThe acft nosed over onto its back after the plt landed in snow 6 to 8 inches in depth.Jan 1, 1985 · N966K · Substantial damageNTSB DEN85FA055Accident · 2 fatalField investigationFinal reportCessna 310N · Edgewood, NMThe pvt rated pilot did not hold a multiengine or instrument rating. The pilot and passenger were returning from vacation. A witness near the accident site stated that she saw the aircraft descend out of a low over last at a very steep nose down angle. The…Jan 1, 1985 · N5069Q · DestroyedNTSB DCA85RA007Accident · 29 fatalForeign investigationBoeing 727-225 · La Paz, BoliviaJan 1, 1985 · N819EA · DestroyedNTSB ATL85LA075Accident · No injuriesLimited investigationFinal reportCessna 150J · Dublin, NCThe pilot reported that the acft lost power in cruise flight and he attempted to land in an open field. He aborted the approach because of a tailwind and flew along a river for aprx 1 mile before ditching in the water. The acft sank in the river and the plt…Jan 1, 1985 · N50913 · Substantial damageNTSB FTW85LA091Accident · No injuriesLimited investigationFinal reportCessna 210L · Monroe, LAThe acft suffered a collapsed nose gear after losing and regaining power during an ILS approach and finally completing an emergency landing two miles from the rwy of intended landing. There were no injuries and no fire. Examination of the acft in the field…Dec 31, 1984 · N2127S · Substantial damageNTSB DEN85LA053Accident · Minor injuriesLimited investigationFinal reportBell 206-L3 · Jackson, WYPlt had landed on prepared area (snow packed down by heli ski guide) to embark ski passengers. On departure plt lifted to hover, turned to desired hdg and initiated forward transition. As acft passed boundry of packed snow, rotor wash picked up soft loose…Dec 31, 1984 · N3898Y · Substantial damageNTSB ATL85LA074Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Birmingham, ALThe pilot reported after takeoff from rwy 23 at 400 ft AGL a horn sounded. A student plt passenger stated the marker beacon, and stall warning horn came on. The plt however could not identify the horn. The plt lowered the nose of the acft, began a descent and…Dec 31, 1984 · N201FR · Substantial damageNTSB LAX85LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · California City, CAThe plt elected to land in a clear, flat, open, desert area which was used by campers to ride motorcycles and off-road vehicles. On the date that the plt landed there, numerous campsites & off-road vehicles were in the area. Nearly 2 hrs after the landing, he…Dec 30, 1984 · N2826G · DestroyedNTSB FTW85FA090Accident · 3 fatalField investigationFinal reportCessna 172L · Galveston, TXA recently certificated private pilot with no known instrument training was given a 'VFR not recommended' weather briefing for a return trip on a pleasure flight. Weather conditions were predicted to, and did, deteriorate rapidly. He took off and turned on…Dec 30, 1984 · N2823Q · DestroyedNTSB DEN85LA052Accident · No injuriesLimited investigationFinal reportCessna 172 · Ft. Collins, COThe plt reported that upon arrival at fort Collins, and while at cruise altitude, the eng suddenly lost power. During the emergency descent maneuvering he lost sight of the airport and landed in a plowed field. Post crash examination of eng revealed the…Dec 30, 1984 · N9033H · Substantial damageNTSB ATL85LA073Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sparta, TNDual engine stoppage. Fuel tanks topped before takeoff. Plt had filed IFR en route but the wind had shifted to a 30 kt headwind. Plt became concerned about fuel remaining and made an instrument apch which was missed because of low clouds. During course to an…Dec 30, 1984 · N7589Y · Substantial damageNTSB ATL85FA072Accident · 1 fatalField investigationFinal reportCessna 182A · Dublin, VAAfter dropping the parachutist, the acft was observed to fly eastward over the dz, make a left 180 turn, line up on the parked van on an easterly heading and descend to a low altiude. Witnesses estimated the altitude at from 10 T0 30 ft AGL. The van was…Dec 30, 1984 · N4963D · DestroyedNTSB ATL85FA071Accident · Serious injuriesField investigationFinal reportCessna 172N · Dothan, ALThe plt, who was also an ATC specialist assigned to a fss, crashed short of the rwy during an attempted ILS apch. Whe wx conditions were below apch minimums.Dec 30, 1984 · N6527D · Substantial damageNTSB ATL85FA070Accident · 1 fatalField investigationFinal reportRobinson R22 · Moundsville, WVThe helicopter crashed aprx 1/2 mi from the marshall county arpt while on a personal flt. Investigaton revealed that the plt, a doctor who specialized in emergency room procedures, commuted between hospitals located in three different cities. The plt had been…Dec 30, 1984 · N9030B · DestroyedNTSB MIA85LA070Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Atlantic Ocean (Atlantic Ocean)About 5 hrs & 10 mins after departure, both engs failed due to fuel exhaustion at 11,000 ft aprx 40 miles from haiti. According to the plt, the acft was using more fuel than normal and the destn was changed accordingly. A short time after initiating the…Dec 29, 1984 · N801BR · DestroyedNTSB MIA85LA068Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Orlando, FLThe acft was flared for landing about 1/2 way down the rwy at excessive airspeed. The plt stated that as the acft touched down, it bounced into the air and impacted trees at 10-15 ft AGL. The spoilers were found in a retracted position after the accident.…Dec 29, 1984 · N1229S · Substantial damageNTSB MIA85IA069Incident · No injuriesIncident investigationFinal reportCessna 402B · Sanford, FLDuring cruise flt, the acft suddenly nosed down & began vibrating. Remedial action was taken & an uneventful emerg landing was made. An exam revealed that the bolt, nut & cotter pin (used to attach the elevator trim control rod to the elevator trim tab) were…Dec 29, 1984 · N402PB · Minor damageNTSB DEN85LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Fargo, NDAccording to the solo student plt, the landing was made in a snow filled ditch aprx 5 ft right of the rwy. The nose gear collapsed and the acft nosed over. The plt and his CFI stated that rwy markings were inadequate.Dec 29, 1984 · N48738 · Substantial damageNTSB MIA85IA076Incident · No injuriesIncident investigationFinal reportDouglas DC3A · Naples, FLShortly after takeoff, the aircrew noted that the elevator control was locked. They declared an emergency & landed without causing damage to the acft. After landing, the elevator external gust lock was found still installed.Dec 28, 1984 · N139PB · No damageNTSB LAX85LA089Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Sausalito, CAWx conds were sky obscured, visibility less than 1/16 of a mile in fog. Plt arrived at heliport, went directly to acft and started engine. Another heliport plt went to acft and advised mishap plt against departure due to low visibility. Mishap plt replied he…Dec 28, 1984 · N51755 · Substantial damageNTSB LAX85FA093Accident · 5 fatalField investigationFinal reportCessna 182P · Big Bear City, CAThe acft crashed in a mountainous area while on a VFR personal flt to long beach, CA. The non-instrument rated private plt & 4 minor children aboard the acft were killed. By low clouds & there were extensive snow showers in the arearea the plt's log book…Dec 28, 1984 · N5948J · DestroyedNTSB LAX85FA091Accident · 1 fatalField investigationFinal reportBell 47G3B · San Diego, CAThe helicopter landed on the morred tuna boat. After toudhdown the helicopter appeared to be repositioning itself when the main rotor blades contacted the boom portion of a crane which was being utilized to load bags of salt aboard the boat.Dec 28, 1984 · N474MP · Substantial damageNTSB LAX85FA088Accident · 4 fatalField investigationFinal reportCessna 182Q · Upland, CAThe instrument rated plt & 3 pax departed palo alto for an intended 3-hour long day VFR flt to santa ana, CA. The final destination was to be mx. The plt had not flown at night or on instruments in over 6 yrs. He elected to delay departing pao until 1611 PST…Dec 28, 1984 · N735MJ · DestroyedNTSB FTW85LA089Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Houma, LAThe plt departed into known bad wx with low ceilings and poor visibility. Very shortly after takeoff the plt elected to return to the arpt. During a descending right turn the plt broke out of IMC at a very low altitude. He pulledcollective but still landed…Dec 28, 1984 · N1075Y · Substantial damageNTSB SEA85LA037Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Boise, IDOn final approach, the pilot's wife, also a rated pilot, was reviewing the landing check list. At item 'heaters off' she inadvertently turned fuel selectors to off. Both engines lost pwr and pilot executed a forced landing short of runway in rough terrain,…Dec 27, 1984 · CGTQE · Substantial damageNTSB NYC85LA050Accident · No injuriesLimited investigationFinal reportBeech P35 · Morrisville, VTPlt noted accumulation of rime ice in flt. On NDB approach, VFR conditions reached about 7 miles from runway, IFR flt plan cancelled and straight-in visual approach performed. Crossing threshold at about 2O ft AGL, plt reduced throttle and acft immediately…Dec 27, 1984 · N1DL · Substantial damage